Latest Contributions by MoniqueDawson

‎07-11-2014

Hi Everyone, I have updated my ArcGIS from ArcGIS 10.0 to ArcGIS 10.1 and now my python code is SOOOO SLOW. And worked fine in ArcGIC 10.0!! What is the difference between to two?? Python Code: ### Import arcpy module import arcpy # Local variables: dir = "E:\\Dawson_Monique\\Weather_Grid\\Louis_Excel_2\\Prov_MB\\" for nodes in range(1,152): name = "nodes_gp_" + str(nodes) + ".csv" xyfile = dir + name eventfile = dir + "layer\\nodes_gp_"+ str(nodes) + "_layer.shp" arcpy.MakeXYEventLayer_management(xyfile, "lon", "lat", xyfile, "", "") arcpy.CopyFeatures_management(xyfile, eventfile, "", "0", "0", "0") print nodes print "done" The Copy Feature portion is Slow. Why? Use to take 5 min now all day. Thanks MO Message was edited by: Curtis Price (edited title, formatted code)

‎03-13-2014

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")

‎02-21-2014

I am exporting tables in arc so that I can import as a dbase table to perform a joint to point files. However some data gets lost. How many rows will an attribute table hold??

‎01-27-2014

I take it you have a common item between the two tables right? My personal approach would be to create a database table from the excel data. And, assuming that when you say shapefile you really mean point feature class, you should probably put the the excel data into the same database as your points. Then use a relate to see what data go with what points, via the common item. The problem is that the excel data does not have the same field as the point shapefile. The point names of each point matches the ID field in excel data instead. I would have to add a field that would link them so I can perform a join

‎01-27-2014

Hi all, I am trying to import/attach excel data (MaxTemp, MinTemp, precipitation) to a multi-point shapefile. Is there a faster way of doing it other than editing each point shapefile attribute table? MO

Online Status	Offline
Date Last Visited	‎11-11-2020 02:23 AM

My Ideas

Latest Contributions by MoniqueDawson

CopyFeatures from Excel data source much slower in 10.1 than 10.0

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

How many rows will an attribute table hold??

Re: Excel Data into ArcGIS

Excel Data into ArcGIS