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

learn more… | top users | synonyms

0
votes
0answers
13 views

osx terminal ogr2ogr batch covert .json to .kml

using osx El Capitan terminal This works fine one file at a time to convert .json to .kml ogr2ogr -f "KML" xxx.kml xxx.json I would like to do all files at once I have tried for %f in (*.json) do ...
2
votes
2answers
672 views

How to repair broken GDAL and PROJ.4 on Ubuntu?

EDIT2: I solved the library problem, but others remain, only vaguely related to that of PROJ.4 library not loaded. I asked a follow-up question for these. My GDAL package and PROJ.4 library are ...
1
vote
1answer
56 views

ogr2ogr Shapefiles to Postgres SRS problem

I am trying to import to my Postgresql (9.1+129ubuntu1) + PostGIS (1.5.3-2) database a Shapefile with polygons with the ogr2ogr tool from Gdal-Bin package (1.7.3-6ubuntu3). I know the origin SRS of ...
0
votes
0answers
25 views

Error clipping extent of shapefile with boundary box with ogr2ogr from python [closed]

Trying to clip polygon shapefile with boundary box in ogr2ogr called from python gives error: "FAILURE: Unable to open datasource 'C:\UserData\save.shp' with the following drivers." then lists ...
0
votes
0answers
11 views

Copy specfic layer to new datasource using OGR Swig Java bindings

Is it possible to efficiently copy a specific layer from one datasource to a different datasource using GDAL/OGR Java bindings? I know it is possible to create a new layer in the target data source ...
1
vote
1answer
72 views

Node GDAL for ogr2ogr conversion

I currently have some scripts that use OGR2OGR to translate data form various source formats like ESRI Shapefile, GML etc to other file formats but especially to my PostGIS database. My normal ...
3
votes
1answer
3k views

ogr2ogr : Converting KML to GeoJson

I have a requirement to convert .KML file to GeoJSON or JSON. Can you please recommend open source command line tools on GNU/Linux(2.6.32-358.14.1.el6.x86_64)? I have installed gdal, when I run.. ...
0
votes
1answer
288 views

How to set encoding when using ogr2ogr to export from oracle db to mapinfo table?

I am trying to automate the export of spatial data from a oracle database to mapinfo .tab files. Using this thread I made my script. However I can't see how to set the encoding right. My data have ...
3
votes
1answer
82 views

Convert KML to GeoJSON with ogr2ogr and remove KML special attributes

I'm trying to convert KML to GeoJSON (or some other formats) using ogr2ogr (look at this question). It's all working fine, except of one problem: I'm always receiving these metadata attributes with ...
3
votes
2answers
819 views

Debugging ogr2ogr “AddGeometryColumn failed” and “Terminating translation prematurely after failed translation of layer”

As noted in the title, I'm getting the following error: ERROR 1: AddGeometryColumn failed for layer pretty_polys, layer creation has failed. ERROR 1: Terminating translation prematurely after failed ...
1
vote
0answers
39 views

How to convert csv file into geo database file?

I have a csv file that i want to export to a file geodatabase (*.gdb) in C#. I am currently looking into GDAL ogr2ogr commands. They have a way to convert gdb file into csv file but not the ...
3
votes
2answers
717 views

Convert non-spatial Oracle table to spatial Oracle table in a different database

I'm trying to use ogr2ogr to convert data from a non-spatial table (has X & Y values) in an Oracle database (1) to a spatial format in a different Oracle database (2). This will be scheduled to ...
0
votes
1answer
245 views

ogr2ogr from MIF to KML including MID generating split kmls

I have a set of MIF and MID files that I would like to translate to KML. I used ogr2ogr to transform the MIF into one big KML which worked ok like so: ogr2ogr -f "KML" geo-kml geo-mif I have two ...
2
votes
1answer
29 views

Convert *.asc OSGB36 files to WGS84 GeoTIFF using gdal/ogr2ogr

I am trying to obtain elevation readings using gdallocationinfo (as per other datasets I have) from a set of .asc files containing elevation data (plus an associated .prj file), using WGS84, but I ...
3
votes
2answers
195 views

How to have GDAL print layers of GeoPDF AND say which are raster vs vector

My Objective: I would like to use GDAL to convert a GeoPDF. I want the vector layers as shp files and the raster layers as tif files. I want to do this in a programmatic way. Edit: In reality, I ...
2
votes
1answer
56 views

Split SHP file using ogr2ogr

I am trying to split a SHP file using all the attributes in the column header SUBURB. Below is an example of the attribute table sitting behind the SHP file: Name Suburb ABC BAY ...
4
votes
2answers
89 views

ogr2ogr of NTF_Lambert_II_etendu is off by about 30 meters

I am converting RPG files in NTF_Lambert_II_etendu to wgs_84 using: ogr2ogr -t_srs EPSG:4326 ilot_2008_027_wgs84_2.shp ilot_2008_027.shp but the result is off by about 30 meters. Surprisingly, the ...
4
votes
1answer
63 views

Merging multiple feature classes in file geodatabase with ogr2ogr?

Is there a way to merge multiple feature classes into one feature class in a geodatabase with ogr2ogr? If this isn't possible with ogr2ogr, is there another method? I'm using the ESRI File Geodatabase ...
4
votes
2answers
2k views

Dissolve/aggregate polygons with ogr2ogr or gpc?

I have a large number of polygons representing the boundaries of US counties which I need to merge into as few polygons as possible. Is it possible to do this with non-commercial software, or ...
0
votes
1answer
16 views

Attempting to convert from GML to GeoJSON produces garbage

The file seems to convert without error, however when I attempt to display it on anything or any map, the coordinates are always rendered as a straight line across the top of the projection. I am not ...
0
votes
1answer
27 views

Ogr2ogr unable to export S57's Symbol to Shapefile

I am using ogr2ogr tool to convert the S57 files to shapefile. However in the resulted shapefile, I am unable to show the original icons from the S57. For example, the SOUNDG layer be represented by ...
0
votes
1answer
35 views

Determining of vector dataset single files to specify its size on a disk

I wonder how to get size of disk space that a specific vector dataset occupies on a disk. I didn't find any ogr2ogr util or OGR Python method that can return a list of files that belongs to given ...
2
votes
2answers
46 views

Convert NAD_1983_Georgia_Statewide_Lambert to NAD83

All I have a ESRI generated shapefile that uses: NAD_1983_Georgia_Statewide_Lambert Here is the projection information: ...
1
vote
2answers
619 views

ogr2ogr - extracting S-57 layers

I'm trying to extract the layer DEPARE from an S-57 datafile and convert it into a shapefile. I'm using ogr2ogr from OpenGeo Suite 4.5 (GDAL 1.11.1) on Windows 7 64 bit. The problem is that when I ...
1
vote
1answer
54 views

Gdal ogrinfo CSV unable to open datasource

When I try to import a csv file into a PostgreSQL table with the Gdal ogr2ogr tool I get the "Unable to open datasource" Failure. So I tried to open it with the tool ogrinfo and I get the same ...
0
votes
1answer
65 views

Converting multi-geometry GML with ogr2ogr not working

I am having difficulties with GML loading in PostGIS with ogr2ogr. It is a GML of buildingparts containing both polygons and (label)-points. In this example (below) I have a selection of 9 objects. ...
0
votes
0answers
15 views

SQL Server aggregate function in ogr2ogr command

I would like to define create a GeoJSON bounding box using SQL Server's EnvelopeAggregate function, embedded in an ogr2ogr command. I have the following command: ogr2ogr -f GeoJSON envelope.json ...
1
vote
0answers
38 views

converting shp to fileGDB with ogr2ogr changes geometry type?

I'm converting a shapefile to file geodatabase with GDAL 1.11.3 and the ESRI FileGDB driver. ogrinfo on the .shp gives: $ ogrinfo NED1_Index.shp INFO: Open of `NED1_Index.shp' using driver `ESRI ...
0
votes
1answer
63 views

Export shapefile From PostGIS

I've a website where I'm giving the functionality of creating and editing line features. I'm using Leaflet-Draw plugin for drawing, PostGIS for storing the data and GeoJSON to display it on map. My ...
1
vote
3answers
1k views

convert csv to kml or geojson, etc using ogr2ogr or equivalent command line tools (use “latitude” and “longitude” attributes for coordinates)

I've just unsuccessfully tried to use ogr2ogr to convert CSV into KML like so: ogr2ogr -f "KML" output.kml input.csv The csv has "latitude" and "longitude" columns. The attributes are all loaded ...
0
votes
0answers
17 views

Use ogr2ogr to get KML out of PostGIS

I am trying to export a Postgis database table into KML using ogr2ogr. When I execute this command in terminal (Ubuntu 12) I just get the "documentation" back but no result or error: ogr2ogr -f "KML" ...
2
votes
1answer
40 views

Improving performance when importing file geodatabase into PostgreSQL?

I have a file geodatabase created with ArcMap 10.1 that contains one feature class with 650 million points. The feature class contains the shape field and an identifier. The .gdb is approximately ...
3
votes
4answers
5k views

How to convert SHP to GPX or to JSON?

I would like to convert the tree inventory shape files of London (Canada) into a GPX file and if possible into a JSON file. You can download the archive from their Open Data website. It contains the ...
0
votes
0answers
27 views

Converting DXF to GeoJSON with ogr2ogr

I'm trying to convert my DXF to GeoJSON with ogr2ogr, but I can't get it to include blocks. ogr2ogr -f "GeoJSON" "/Desktop/test2.geojson" "/Desktop\drawing.dxf" -sql "SELECT * FROM entities" ...
1
vote
2answers
78 views

ESRI Shapefile not loading into SQL Server

I have been loading a number of shapefiles into SQL server 2012 using ogr2ogr.exe and the MSSQLSpatial driver. Up until this point, I have been very successful with doing so. However, I have now run ...
0
votes
1answer
57 views

Convert SQL Server spatial table with unknown coordinate reference system to GeoJSON with ogr2ogr

I have a table in SQL Server with an STSrid of 0. I would like to convert this table to GeoJSON using ogr2ogr. The problem is, despite converting to EPSG:4326, the resulting coordinates are not valid ...
2
votes
0answers
40 views

Writing GeoJSON data into PostGIS in perl?

I am working with GeoJSON files and need to store them in PostgreSQL using perl. I can do this in 2 steps: open (JSON,">$path/tmp/current.json"); print JSON $fullJSON; close JSON; followed by: ...
3
votes
0answers
85 views

Dissolving polygons in a large dataset

I need to dissolve polygons by the ID attribute in a large dataset (+-1gb shapefile). I have been struggling to find an efficient method to do this. I have tried the following methods: Postgis ...
1
vote
1answer
24 views

Polygons created for holes after running ST_Collect

I ran an ST_Collect query on a polygon dataset using ogr2gor -dialect sqlite -sql SELECT ST_Collect(geometry),id FROM wl_test GROUP BY id The result is a multipart polygon, which is what I want, ...
2
votes
1answer
517 views

GDal problem “no suitable image found” when I run “ogr2ogr” command

I am trying to run "ogr2ogr" command macbook$ sudo ogr2ogr -f "PostgreSQL" PG:"dbname=test user=postgres" /Users/macbook/planning.gdb But I am getting this error: dyld: Library not loaded: ...
0
votes
1answer
130 views

GRIB data interpolation

I've been wrangling around in GFS grid based data (GRIB - mostly 0.5 degree resolution). I'm interested in plotting these by converting to geojson with ogr2ogr (which is quite easy). However, is there ...
1
vote
2answers
120 views

ogr2ogr without spatialite support - How to fix it?

I am trying to use ogr2ogr to convert OSM data from pbf to spatialite. I used to do so with the following command: ogr2ogr -f "SQLite" -dsco SPATIALITE=YES png-full-last.db ...
14
votes
6answers
4k views

How can I update ogr2ogr to include the PostgreSQL driver?

I'm trying to use ogr2ogr to upload a shapefile to a remote PostGres installation. When I ran this command: celenius:~ celenius$ ogr2ogr -f PostgreSQL PG:"host=255.34.00.00 user=postgres dbname=mydb ...
0
votes
0answers
25 views

Styling and saving multiple KMLs at once

is there a way to style multiple KML files at once and then save each one as its original file without going through them individually? I have approximately 600 KML point files that need to remain ...
2
votes
1answer
1k views

Convert GeoJSON with multiple Polygons and MultiPolygons into single MultiPolygon?

Is this even possible? I have a GeoJSON file with multiple polygons and multipolygons, and I need to set styling on them (in Leaflet.js). I'd like to create a single, large MultiPolygon from the ...
1
vote
1answer
333 views

Passing options to ogr2ogr using python subprocess.Popen

I'm trying to programmatically import some shapefiles to PostGIS, since I need to catch the exit code of the process I decided to use subprocess.Popen. I've managed to import the files using: cmd = ...
1
vote
1answer
32 views

Iterate over polygons to convert WFS features

So my first question on stackexchance. With ogr2ogr its possible to convert WFS features to SQlite with the following: ogr2ogr -f "SQLite" OUTPUT.sqlite WFS:"INPUT_WFS_url" It works. But there ...
1
vote
2answers
63 views

ogr2ogr unreadable dbf file header

I'm trying to convert Mapinfo tab file to ESRI shapefile using ogr2ogr either with sqlite dialect or without. When using sqlite dialect, ogr2ogr -overwrite -f "ESRI Shapefile" -dialect sqlite -sql ...
1
vote
0answers
61 views

SRID of geoemtry exported in PostgreSQL with ogr2ogr

I use ogr2ogr to export geometric data from EDIGEO files to some PostgreSQL table in append mode, but the output geometry SRID is always set to zero. Can I do something to specify the output geometry ...
1
vote
1answer
19 views

Reprojecting a shapefile with ogr2ogr when a line is crossing the international date meridian

I have a line shapefile with a local transverse mercator projection ("+proj=tmerc +lat_0=50 +lon_0=172.5 +x_0=0 +y_0=0 +a=6371000 +b=6371000 +units=m +no_defs") and I want to reproject it into ...