New answers tagged excel
QGIS can load geographic data from a CSV file via Layer --> Add Delimited Text Layer. If you would like to load the grid data as polygon, you will have to format the data in the WKT format. Your end result should be something like this wkt|mun_code|... POLYGON ((3145006 371500, 3145006 372000, 3145556 372000, 3145556 371500, 3145006 ...
If you do not mind multiple counties that relate to the different duplicated information you have for each county in your excel data... Convert your data in excel into a csv file (excel sheets can now be directly imported to ArcGIS but CSV has less issues). Import your csv table into ArcGIS and Join it to your county shape file data. Make the county shape ...
I had the same issue. I simply reversed the order of operations by export to excel first, then adding the layer. Or if that doesn't work you could just re-add the layer, no?
Use map joins with field calculator. Map join won't add the fields physically to your table, rather, it is an in-memory join. Right-click your layer in TOC > Click Joins and Relates> Join... Then use Field Calculator to interpolate.
While ArcGIS allows you to view Excel tables and join them with Esri formats, there are some limitations. Editing the content of the Excel data is one of them. If you just joined the two tables in ArcMap, try exporting the feature class to a new feature class after the join. That should permeate the join. Keep in mind though, you won't have much control ...
It is indeed not possible to edit data from a joined table. The easiest workaround is right clicking the layer name -> Data -> Export Data... and save it as a new shapefile. This new shapefile will then include all data from your joined table, and can be edited freely.
No one has mentioned the X-Ray tools suite for ArcGIS. Just do a Google search for "X-Ray ArcGIS". There are several variants for each ArcGIS version and platform (ArcCatalog, ArcMap). Here is one version. Here is another. It supports many Field and Domain-related functions, including changing the field type, name, alias, domains, etc. in MS Excel and ...
To my knowledge, this is not possible. In 10.3, Alter Field was expanded to allow altering field type; however, it still only works when the table doesn't have any records. Here is one approach to doing this though: Add a new field with a temporary name and the correct data type Use Calculate Field or cursors (with casting, if needed) Delete old field ...
Top 50 recent answers are included