Skip to main content
Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Code code:"if (foo != bar)"
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Saves in:saves
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with
Search options questions only not deleted user 63929

ogr2ogr is an open source command line utility popular for converting to and from various vector spatial data formats.

2 votes
2 answers
531 views

ogr2ogr download GeoJSON from URL with parameters

$limit=100000&$$app_token=mytoken&$where=county in('Kings','Queens','Bronx','Richmond','New York') Now I want to pull it and save it to a GeoJSON with ogr2ogr ogr2ogr -f "GeoJSON" /home/thefile.geojson …
ziggy's user avatar
  • 4,576
4 votes
1 answer
2k views

ogr2ogr dissolve shapefile

I am following this question with the first answer Dissolve/aggregate polygons with ogr2ogr or gpc? … where I am trying to dissolve my shapefile down to 1 row by the geometry field ogr2ogr C:\Users\name\Desktop\output.shp C:\Users\name\Desktop\All_constraints_v5.shp -dialect sqlite -sql "SELECT ST_Union …
ziggy's user avatar
  • 4,576
0 votes
1 answer
976 views

ogr2ogr shapefile to PostgreSQL problem

Trying to use ogr2ogr to import a shapefile in PostgreSQL. … but I have used ogr2ogr to import fileGDB's into PostgreSQL and it has always worked... not sure what's wrong with my command. I took out append and it still doesn't work. …
ziggy's user avatar
  • 4,576
2 votes
1 answer
3k views

ogr2ogr dwg CAD file to postgres

I am attempting to load a CAD .dwg file into a postgreSQL database using ogr2ogr. … this is the command ogr2ogr -f PostgreSQL "PG:host=localhost user=postgres password=*** dbname=jaffe" C:\Users\blah\Desktop\SAMCO.dwg -s_srs EPSG:4326 -lco GEOMETRY_NAME=geom get this error FAILURE …
ziggy's user avatar
  • 4,576
4 votes
1 answer
3k views

ogr2ogr export postgreSQL to ESRI file GDB wkbUnknown layer geometry type

I have 18 postgreSQL tables that I am trying to export to a ESRI file GDB using ogr2ogr. I have the FGD plugin installed. … However when I try and use the below command ogr2ogr gives me an error. the same error in this post Exporting PostgreSQL table to FileGDB: wkbUnknown layer geometry type Here is my command: ogr2ogr
ziggy's user avatar
  • 4,576
6 votes
1 answer
3k views

ogr2ogr filegdb to postgis change geometry column and SRID

I have figured out (through the use of this thread) on how to go from a file GDB to posgreSQL using ogr2ogr. … ogr2ogr -f "PostgreSQL" PG:"host=localhost port=5432 dbname=freelance user=postgres" C:\pathto\oakland.gdb -overwrite -progress when i run this cmd ogr2ogr command it correctly imports the feature classes …
ziggy's user avatar
  • 4,576
5 votes
2 answers
3k views

ogr2ogr PostgreSQL to geojson batch export

trying to export 20 postgreSQL tables to geoJSON using ogr2ogr ogr2ogr -f "GeoJSON" C:\path\Desktop\geo PG:"host=localhost user=postgres dbname=free password=xx" -t_srs EPSG:4326 getting these 2 errors … in the GDAL folder For %f in (* PG:"host=localhost user=postgres dbname=free password=xx ACTIVE_SCHEMA=public") do ogr2ogr -f "GEOJSON"% ~ nf.json% f with my modified script For %f in ("oak_available_parcels …
ziggy's user avatar
  • 4,576