smnorris / roadintegrator

Quickly merge multiple BC road datasets into a single layer for Cumulative Effects analysis
Apache License 2.0
10 stars 1 forks source link

ArcGIS frequency tool chokes on output .gdb #11

Closed smnorris closed 3 years ago

smnorris commented 5 years ago

Two separate issues:

  1. ogr2ogr doesn't seem to generate the internal gdb Shape_Length column and I don't see any reference to this column in the fgdb driver/api docs. Currently we create this manually in ArcGIS instead, which is no big deal

  2. Once the Shape_Length column is populated in a new feature class in the .gdb, attempting to run arcpy.Frequency_analysis to summarize fails. Culprit seems to be text columns output by ogr2ogr - they are 65,536 chars in length.

Try shortening text columns in the ogr2ogr sql

smnorris commented 3 years ago

Don't bother dumping to .gdb