topic Re: Joining a shapefiles attributes to a table in ArcGIS 10 using Python in Python Questions

Joining a shapefiles attributes to a table in ArcGIS 10 using Python

MoniqueDawson — Thu, 13 Mar 2014 18:37:13 GMT

Hi Experts,

I am trying to join a shapefiles attributes to a table in ArcGIS 10 using Python.
This is the code I have been using. What do the errors mean?? Why are error occuring?

>>> import arcpy
>>> from arcpy import env
>>> env.workspace = "R:\Dawson, Monique\Canada_Weather_Grid"

Parsing error <type 'exceptions.SyntaxError'>: invalid syntax (line 2)
>>> arcpy.JoinField_management("nodes_gp_100.csv", "ID", "Alberta_Weather_Nodes", "ID")
...
Runtime error <class 'arcgisscripting.ExecuteError'>: ERROR 000339: Input nodes_gp_100.csv does not have OIDs Failed to execute (JoinField).
>>> arcpy.JoinField_management("Alberta_Weather_Nodes", "ID", "nodes_gp_100.csv", "ID")
Runtime error <class 'arcgisscripting.ExecuteError'>: ERROR 999999: Error executing function. Failed to execute (JoinField).
>>> arcpy.JoinField_management("GP_100", "ID", "Alberta_Weather_Nodes", "ID")

Re: Joining a shapefiles attributes to a table in ArcGIS 10 using Python

JoshuaChisholm — Thu, 13 Mar 2014 18:57:54 GMT

Hello Monique,

I'd start by changing your env.workspace line. When specifying a path in python you have to do one of the three actions:

Replace all \'s with /'s

env.workspace = "R:/Dawson, Monique/Canada_Weather_Grid"

Replace all \'s with double \'s

env.workspace = "R:\\Dawson, Monique\\Canada_Weather_Grid"

(My personal favorite)Add an 'r' in front of the string

env.workspace = r"R:\Dawson, Monique\Canada_Weather_Grid"

This is because python sees "\" as a special character.

Let me know if this fixes your problem or not. Good luck!

Re: Joining a shapefiles attributes to a table in ArcGIS 10 using Python

NickJones — Fri, 14 Mar 2014 12:44:30 GMT

have you tried exporting your CSV to a DBF first? Also, as a side note, be careful with this join field tool. They may have fixed this in 10.2, but sometimes the results aren't good when you use a field that isn't numeric to perform the join with this tool.

Re: Joining a shapefiles attributes to a table in ArcGIS 10 using Python

KinleyWinchester — Mon, 22 Feb 2016 21:28:04 GMT

Struggle with this almost the entire day... just found this answer and option #3 worked like a charm. Thanks! Lives will be saved on my ride home today!

Re: Joining a shapefiles attributes to a table in ArcGIS 10 using Python

BruceHarold — Mon, 22 Feb 2016 21:45:56 GMT

Please also see this tool:

http://www.arcgis.com/home/item.html?id=da1540fb59d84b7cb02627856f65a98d

Regards

Re: Joining a shapefiles attributes to a table in ArcGIS 10 using Python

DanPatterson_Retired — Mon, 22 Feb 2016 21:45:58 GMT

Filenames and file paths in Python

Read it when you get home... your safe journey has other stumbling blocks...