Latest Contributions by MathewCoyle

Are you running any antivirus? Have group policies, or some other software/registry issues that may be interfering? What kind of profiles do you use for logging into the computers? ... View more

Have you added the custom toolbox to the default ArcGIS toolbox? Do you still get these errors If you completely uninstall ArcGIS, remove the associated folders and registry entries and do a clean install without the custom toolbox? ... View more

I am dealing with 7+ million records, so performance is a must.  mzcoyle's idea of insert cursor will take too long, and I made a script that worked based off of his example.  What kind of performance will I get with the append management?  The files that I am starting with are .txt files, and they are split into 2 (roughly 3.5 million per).  So I am also trying to figure out the fastest way to get them both together into one file into a file geodatabase. An insert cursor would be your best performance for this kind of operation. Can you post the code you have where you aren't getting the performance you require? Is there way to set field length as well?  I didn't see it in the help page.  Most of the fields I am exporting are of the text variety, and the 255 length eats up way too much space and slows down other operations.  Thanks!! Yes, length should be an editable property of a field object in field mapping. field.length = 10 ... View more

Using table to table you would have to use field mappings to setup the conversion from source field to destination field. Alternatively you could use an insert cursor on a template with the field restrictions you want. You can find examples on these forums of field mapping. Here's an example of me working through some issues I was having with field mapping. Should give you all the pieces you need for that route. http://forums.arcgis.com/threads/72269-field-map-problems ... View more

I have gotten some massive performance gains using in_memory over HDD workspaces, especially if you don't use RAID/SSD drives. I did some benchmarking a while back but can't find the results. Depending on the task it could be twice as fast to 20 times faster. Cursors on in_memory tables were the most gains IIRC. And yes, the caveat, you also have to keep on eye on the size of data you are writing to memory. I've crashed machines not being diligent about what is in memory and clearing unneeded data. 64-bit geoprocessing won't help you when trying to commit 64GB of data to memory. ... View more

1. Set your environment to your geodatabase. 2. Iterate through list of feature classes. 3. For each iteration rename the particular feature class. Here's an example of using string formatting. new_name = '{0}_county'.format(fc) ... View more

Pretty straight forward. List Feature Classes http://resources.arcgis.com/en/help/main/10.2/index.html#//018v00000018000000 Rename http://resources.arcgis.com/en/help/main/10.2/index.html#//001700000056000000 ... View more

I assume this list captures the highlights. From what I understand of the road map there is not a great deal of difference for arcpy between 10.1 and 10.2 in terms of functions. http://resources.arcgis.com/en/help/main/10.2/#/What_s_new_in_ArcGIS_10_2/016w0000005s000000/ ... View more

It really shouldn't even be taking that long, unless your strings are really long or you are dealing with a slow computer. Did you try it in a file geodatabase? ... View more

I don't believe this is exposed for access through arcpy. You may have some luck using arcobjects. I'd trying contacting your Esri rep for advice on this, licensing can be finicky. ... View more

Assuming I/O isn't your issue this method should take less than 2 minutes for 7 million records (takes around 10 seconds for 500k records for me). The only faster way I can think of is it do this through SQL directly in a database. ... View more

Ah yes I mixed up the index for the 3rd field. Should be this.     row[2] = '{0}{1}'.format(row[0], row[1]) And what literature are you referring to? ... View more

That depends on what you want your output to be. What reason would you have for using join in this context? ... View more

If it creates an sde connection file and you can use it in ArcGIS, that should be all arcpy needs to connect to the database. And I may be mistaken, but even using direct connects I believe you need to have SDE installed for your database. ... View more