Explore ogr2ogr command line tool

[kzollove]

Could this replace some R functionality? Where would this happen?

One potential entry point would be using ogr2ogr to load into postgis. The benefits of this would likely only be noticed with datasets that are never brought into R memory.

Currently, data is:

1. downloaded to local machine
2. imported to R
3. transformed using geom_spec or attr_spec
4. loaded to postgis with Rpostgis

If steps 2 and 3 could be changed (transformation happens using command line tools only), then data would never have to be loaded into R, potentially dramatically improving efficiency.

Consider trying to recreate a data source using sed, awk, and ogr2ogr for transformations. Is there a noticeable or valuable difference in load efficiency?

[kzollove]

ogr2ogr has option -sql allowing user to execute sql on file: https://gdal.org/programs/ogr2ogr.html#cmdoption-ogr2ogr-sql

[kzollove]

This could be a good option for replacing the current *_specs @rtmill