New answers tagged

1

Since your working in arcpy and doing a simple data transfer, use a search cursor to load your Spatial Join count results as the value dictionary to associated with the FID key and then use and update cursor to read the FID from the current feature being updated and lookup the count from the dictionary to post it. It takes a few more lines of code to set ...


0

It was a bug, which will be fixed when 2.14.3 is released


2

The field name changes with a join. The feature class or shapefile name is added to the start of the field, and a period is placed between the feature class/shapefile name and field name. os is a good module to use to create your new field name. Here's an example of how to create the joined field name: >>> import os >>> fld = "P_prod" ...


0

Sometimes I have needed to be dynamically linked to an Excel sheet that others interact with. One thing you might try is to open Access, go to the External Data tab, hit the Excel button, select Link to the data source by creating a linked table, and ensure your fields are all importing as the correct type. If you create a database connection with the ...


0

Might be good idea to review this since you said it is clean and doesn't contain any characters, sometimes you might be missing something... http://desktop.arcgis.com/en/arcmap/10.3/manage-data/tables/understanding-how-to-use-microsoft-excel-files-in-arcgis.htm


2

Save your excel file as a .csv, or export the excel file as a .dbase table or into a geodatabase. You should then be able to successfully join.


1

Updating is often quite slow. If it is possible, it is probably a lot faster to recreate the whole table like create table new_table as select pnt.*, poly.name from point_table pnt inner join poly_table poly on st_within(pnt.geom, poly.geom); I do this a lot and rename the new table to the original name and recreate indexes and constraints on it. If it ...


2

If these are true Null fields and not strings with the word "<Null>", then you need to use None in Python for Null. Try: if valueDictOfficialPipes_2[1] in [None, "", " "]: for nullNoMore in range (1,len(fieldsPipes15096)): updateRow2[nullNoMore] = valueDictOfficialPipes_2[keyValue2][nullNoMore-1] ...


3

Ensure the identifier field in both files are the same type. That is make sure they're both text or both numeric.


2

Join the larger table to the smaller table via the common field, selecting Keep All Records. Sort the joined table to see which ones are in one but not the other, export those records. Then append the missing records to Table A


0

You need to have GIS data, for example (State Boundary), in Arcmap in order to visualize the excel population data in GIS. The state boundary should have a field of StateName or State_Name that the names of the states in this field should be exactly similar to the names of the states in the State Name field in Excel. Otherwise, there will be no join relation ...


2

Firstly you'll need a spatial layer showing the state boundaries. A rough dataset is included with ArcGIS and is located at C:\Program Files (x86)\ArcGIS\Desktop10.2\TemplateData\TemplateData.gdb (or a similar path on your computer). You'll need to make some changes to your Excel file before you add it to ArcMap. Note that the column names cannot have ...



Top 50 recent answers are included