newberry

python versus SQL

Discussion created by newberry on Nov 23, 2019
Latest reply on Dec 19, 2019 by newberry

Python (including arcpy) is fun when being used to process GIS vector data (point, line, polygon). However, it is tedious and inefficient compared to SQL. After all, SQL is the database language. Here,  arcpy.AddGeometryAttributes_management, arcpy.da.UpdateCursor, and SQL script were used to calculate field longitude and latitude in a point feature class. SQL script is 400 times faster than arcpy script. 

Attachments

Outcomes