1

I'm importing a .csv that contains data that I am joining to a shapefile. The value that I am joining is shown in the first column of the image below. When I import the data into ArcMap the data in the second column is converted to type 'string' instead of 'integer'.

How do I import the data so that numeric values are of type integer 'instead' of 'string'?

enter image description here

PolyGeo
  • 65,136
  • 29
  • 109
  • 338
user135647
  • 19
  • 1
  • 1
    This tutorial has a solution for QGIS that I think would also work for ArcMap. Basically you add a line to the CSV file that defines the column types. Or you may find these questions helpful: https://gis.stackexchange.com/questions/109461/changing-field-type-of-excel-attribute-table-for-a-join, http://gis.stackexchange.com/questions/78087/problem-in-using-schema-ini-to-force-arcmap-recognize-field-types – csk Jan 22 '19 at 18:56
  • 1
    How do you import it? – BERA Jan 22 '19 at 19:42
  • schema.ini https://gis.stackexchange.com/a/164973/2856 https://gis.stackexchange.com/q/30670/2856 http://desktop.arcgis.com/en/arcmap/10.3/manage-data/tables/adding-an-ascii-or-text-file-table.htm#GUID-9131A09B-6C15-4654-8A72-F01C0C271392 – user2856 Jan 22 '19 at 21:32
  • 2
    A simple workaround is to let them be imported as strings and then add a new integer field (Add Field). Use Field Calculator to reproduce the old values into the new field, where they will show up as integers. – J Kelly Jan 22 '19 at 22:35
  • Precisely how did you import it when you got your undesirable result? – PolyGeo Feb 03 '19 at 22:14

0 Answers0