Given the extend time (days!) and difficulties (oddly misappropriated BT records) with the methods we developed in Python, @memoore and I decided to give it a run in R.
The COA_DBcreation_mergetable.R script takes a gdb of sgcnXpu intersections, loads each into a dataframe, does basic cleanup on the columns, and then merges all of them into a single DF via rbind).
This then exports the table as a csv.
Overall, this method seems to be faster than the python/arcGIS approach and will likely create a cleaner table.
Just documenting that this didn't work out all that well in R, and we're attempting a different way to do this in Arc using a COMBINE function on grids.
@memoore can you add more detail as we solve this.
Given the extend time (days!) and difficulties (oddly misappropriated BT records) with the methods we developed in Python, @memoore and I decided to give it a run in R.
The COA_DBcreation_mergetable.R script takes a gdb of sgcnXpu intersections, loads each into a dataframe, does basic cleanup on the columns, and then merges all of them into a single DF via rbind). This then exports the table as a csv.
Overall, this method seems to be faster than the python/arcGIS approach and will likely create a cleaner table.