Skip to main content
3 votes
Accepted

Splitting SHP file based on property starting with an underscore

It should be valid in SQL to have field names beginning with an underscore https://www.postgresql.org/docs/current/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS but I have seen that sometimes they ...
user30184's user avatar
  • 67.3k
1 vote
Accepted

gpkg filename to add PostGIS table field

You can use the -sql flag to create arbitrary columns in the output. I've not got a PostGIS handy so I'm going to add to an existant table.gpkg file. It has 5 rows and the file column is all "nc1&...
Spacedman's user avatar
  • 65.1k
1 vote

How to create one buffer around all the points using ogr2ogr?

Using the ST_Union tip in the comments, we achieve the answer, and then go on to make a KML. $ ogr2ogr houses.buf.csv a1.houses.csv \ -lco GEOMETRY=AS_WKT -dialect SQLITE -sql \ "SELECT ST_Buffer(...
Dan Jacobson's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible