New answers tagged


The solution was to use a SearchCursor and an InsertCursor to copy the data from the event layer to the feature class. This solution was found here. It is multple times faster than the arcpy.CopyFeatures_management tool.


UPDATE: I've already find this explanation of Microsoft about reserved words for Microsoft Access. and....oh surprise!!! "LONG" appears!!! List of reserved words in Access 2002 and in later versions of Access This article lists words and symbols that you should not use in field, object, and variable names in Microsoft Access 2002 and later ...


Awesome answer! Wrapping up those code snippets into a SQL agent job or a SSRS report that shows the lineage stats daily, or fires an email when they pass a certain value, would make for a great maintenance plan!


I'm afraid this is more of a personal preference than a best practices issue. You have many choices: Create the spatial table in database A with SQL tools, and access it though Query Layers Create the spatial table in database B with SQL tools, and access it through Query Layers Create the spatial table in database B with SQL tools, and register it with ...


To remove a table from Table Registry you need to execute the sde command: sdetable -o unregister -t -u av -p mo -i 7654 This command won't remove the objectid field, so you need to do manually.


After you supplied the error, I noticed you didn't use a colon at the end of line 10. You should replace lines 10 and 11 with the following lines. for fc in filtered: if arcpy.Exists(fc): arcpy.Delete_management(fc) Chances are you'd never have it try to delete one that doesn't exist but this way, it keeps deleting if it DOES find one that doesn't ...


Install ArcFM Object Reader Depending on your ArcMap Version Eg: For 10.2 ArcGIS install object Reader 10.2 Below is the link If it not recognizing the ArcGIS open your Arcmap and then try to install. After ...


My append query worked! I had to close and reopen my table in Access to see the changes. (Obviously I'm still learning MS Access) So this one's for the beginners! Here's the query steps: Create Tab > Query Design Show Table Window > Select Linked Table (As long as the fields in the linked table and the gdb are identical) Double-Click the Asterisk* to ...

Top 50 recent answers are included