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

learn more… | top users | synonyms

4
votes
0answers
206 views

How do I clip Geojson FeatureCollection with another Geojson polygon

I have a GeoJSON file that contains one FeatureCollection with a bunch of features that are polygons. I also have the boundary of the continental USA in another GeoJSON file. I'd like to clip the ...
3
votes
0answers
272 views

How to convert shapefile to mapinfo file preserving special characters?

I have to convert a bunch of shapefiles to mapinfo files on a machine without a MapInfo license, so I am using ogr2ogr to perform this task. The problem is that when opening the mapinfo files in ...
3
votes
0answers
524 views

How to save table from PostgreSQL to MapInfo File?

I have two tables: 1 with geometry in WGS 2 with geometry in Local System I tried this: ogr2ogr -f "MapInfo File" output2.tab PG:"host=localhost user=postgres password=123456 dbname=postgis" -sql ...
2
votes
0answers
38 views

How to clip or erase a csv file with a non-rectangular shapefile?

I can clip a csv file with a ogr2ogr having 4 extents of a rectangular polygon. Is it possible to clip a csv file with a non rectangular shapefile?
2
votes
0answers
64 views

Using OGR2OGR with LIBKML (Examples please)

I am trying to figure out how to use GDAL (ogr2ogr) to export spatial data from SQLServer to KML. The standard KML driver works, but it is not very robust. LIBKML has so much promise (layers, styling, ...
2
votes
0answers
86 views

ogr2ogr fileGDB translating points

I am converting data from spatialite to fileGDB (and reverse) for a project using QGIS and ArcGIS. When I convert using ogr2ogr (or QGIS) from spatialite to fileGDB, the points are translated ...
2
votes
0answers
105 views

ogr2ogr does NOT save “styles”, say “color”, information; how do I get around it?

I'm using ogr2ogr to convert KML to GeoJSON and I'd like to extract style information along with the data. The bash script I am using is: filekml="/tmp/poly.kml" filegeojson="/tmp/poly.geojson" ...
2
votes
0answers
97 views

How to export postgis points as blocks in dxf with ogr2ogr

I'm trying to export postgis points as blocks to DXF format. I have a simple table in postgis with columns: CREATE TABLE pod_com_azimuth ( ogc_fid integer, rotation double precision, pointtype ...
2
votes
0answers
189 views

How can you calculate the union/merge two polygons in ogr2ogr?

I want to calculate the union/merge two overlapping polygons using ogr2ogr (as I have 300+ to do). I want the output to be the same as you would get if you used the 'Merge shapefiles to one' command ...
2
votes
0answers
492 views

Ogr2ogr: Unable to open datasource problem

I downloaded the Precints shapefile from the City of Boston's data hub, and I'm trying import it into SQLServer (I'm running the Express verson). I've already created the database in the SQLServer ...
2
votes
0answers
198 views

CSV rows to Polyline with OGR

I'm not sure if I can complete this operation in one step - but someone might be able to help me. My input file is a csv file with PointID, x, y, z and LineID columns. I'm looking to combine all ...
1
vote
0answers
3 views

Include <link> in GPX when writing from ogr2ogr

http://www.gdal.org/drv_gpx.html seems to indicate that ogr2ogr should be able to write <link>[1] elements into a GPX file, however when using ogr2ogr to convert from PostGIS to GPX, I get the ...
1
vote
0answers
36 views

How to clip a big shapefile from another shapefile's extent

I am working on mangroves in Sundarbans (Bangladesh / India), using Landsat pictures. I need to equalize them in reflectance, before classification, for the evolution of the biomass in this region. I ...
1
vote
0answers
51 views

How to import UTF-8 encoded Shapefiles into SQL Server?

I am trying to load a shape file to sql, using ogr2ogr and Shape2SQL tools. The shape file uses UTF-8 encoding, specified in a .cpg file, and confirmed when opening the file with QGIS. However, as ...
1
vote
0answers
32 views

ogr2ogr latitute longitude conversion formats

trying to convert shape files into mysql tables. Able to create table and load data successfully using OGR2OGR. Only challenge I see is latitude/longitude is not exactly the same format as one of my ...
1
vote
0answers
52 views

Suppress verbose output when something goes wrong with ogr2ogr

Whenever ogr2ogr is not able to read a file, it seems to produce pages of output: Unable to open datasource `file.geojson' with the following drivers. -> ESRI Shapefile -> MapInfo File ...
1
vote
0answers
36 views

clip csv-file with ogr2ogr

I'm trying to clip a csv-file containing xyz-data (points) by an irregular shaped polygon in ogr2ogr. My code runs without any errors or warnings, but it returns an exact copy of the input-csv. What ...
1
vote
0answers
48 views

3d model to point cloud

Excepting FME, is there a way to convert 3d model to point cloud?
1
vote
0answers
38 views

Using TIGER/Line shape files, how do I get address coordinates?

I've downloaded addressfeature shapefiles from TIGER/Line on the Census Bureau website. I converted one file to CSV using ogr2ogr. I get the following sample output: ...
1
vote
0answers
66 views

OGR2OGR FileGDB 2 other format with -SQL query change structure

I'm using GDAL 1.11.1 with ESRI FileGDB Driver, GDB version 10.x. When I use ogr2ogr, my goal is to sort differently my fields and in some case, to rename them. The problem is when I call FileGDB ...
1
vote
0answers
92 views

Export DGN to shape or postgis with multiple mslinks

I need a command line tool to export DGN files to shapefile or PostGIS, I tried ogr2ogr but it only exports type, level, graphicgroup, colorindex, weight, style, entitynum, mslink and text. I need the ...
1
vote
0answers
78 views

ArcMap KML Multigeometry to Shapefile

I have been troubleshooting this issue for quite some time now. I have a variety of tools available to me: ArcMap, QGIS, as well as OGR2OGR. Unfortunately, I have not had any success with any of these ...
1
vote
0answers
38 views

Reverse clip with ogr2ogr

I'm fairly new to GIS, working on a project where I overlay counties on google maps, and overlay cities on top. I'm using fusion tables, and running into Z-index issues. To get around this I'm hoping ...
1
vote
0answers
152 views

Importing 2014 TIGER County Shape Files to 2012 SQL Server?

Last year, I figured out how to import TIGER Census Block shape files into 2012 SQL Server with no issues. I assumed I would use similar code to do the county shape files but I keep getting a few ...
1
vote
0answers
73 views

Import .gfs file into PostGIS?

Is it possible to import a .gfs file into PostGIS? I can open the .gfs file in QGis, so I assume it is a geographic file of some kind: but I'm not sure how to get it into PostGIS. I have Googled but ...
1
vote
0answers
77 views

What is causing invalid spatial reference error using ogr2ogr converting PostGIS to FileGDB in a Feature Dataset?

I am trying to use ogr2ogr to convert a layer from PostGIS to a FileGDB. I want the layer to be created inside a Feature Dataset. The spatial reference of the source layer is EPSG:3500. The spatial ...
1
vote
0answers
56 views

Limited number of entities exported with ogr2ogr?

I generate shapefiles with a php script that launches ogr2ogr commands. The ogr2ogr commands look like : "C:\OSGeo4W64\bin\ogr2ogr.exe" --config PGCLIENTENCODING LATIN1 -overwrite -f "ESRI Shapefile" ...
1
vote
0answers
66 views

QGIS crashes when trying to display features form MySQL

I import shapefiles into MySQL using the following command: ogr2ogr -f MySQL MySQL:GIS,host=localhost,user=root,password=root /home/user/Public/myshape.shp -nln Shape_table -update -overwrite -lco ...
1
vote
0answers
83 views

ogr2ogr “Error: pointer being freed was not allocated” on mac mavericks

I've successfully installed GDAL via homebrew on mac But while I'm using command ogr2ogr, keep getting error below $ ogr2ogr -f geoJSON tl_2010_20_tract10.json tl_2010_20_tract10.shp ...
1
vote
0answers
36 views

ogr2ogr giving “ERROR 1: Failed connect to 192.168.4.18:8181; Operation timed out” error?

This is my command, which was working OK yesterday: ogr2ogr -f "GeoJSON" ../geojson/myfile.geojson ../data/gml/myfile.gml -s_srs EPSG:27700 -t_srs EPSG:4326 The output is this: ERROR 1: Failed ...
1
vote
0answers
204 views

ogr2gr loading spatial data into mysql

I am trying to load shapefile into mysql (MYISAM) using ogr2ogr and i get an error that says failed to fetch the requested layer. What could be wrong with my statement is it the issue with quotes or ...
1
vote
0answers
261 views

problem with WFS Data, GDAL, Python, ArcGIS, & Defining Projection

I'm pulling in data in gml2 format with a EPSG#4267 from a wfs. I create a datastream in python and then run the following from the python window in ArcMap: data = datastream.read() #write the gml ...
1
vote
0answers
95 views

OGR Error : Silly size requested

I'm scripting OGR functionality in order to filter some mapinfo tables and convert them into sqlite files. ogr2ogr -f "SQLITE" newtest.sqlite test.tab -sql "SELECT cols FROM test WHERE .." where ...
1
vote
0answers
382 views

How to import 3D geometries from DXF, VRML or X3D into PostGIS 2

we plan to develop a webbased 3D GIS using PostGIS 2 and GeoServer with a W3DS. The architecture works fine, but i have problems to import 3D geometries into PostGIS. The geometries come from AutoCAD ...
1
vote
0answers
190 views

Trying to use OS Translator plugin and cant find ogr2ogr.exe

I have installed the OS Translator plugin from the Faunalia Repository but when I try to use the plugin I get a "Can't find ogr2ogr[.exe], can't continue" error message. I have tried reinstalling the ...
1
vote
0answers
123 views

Question about the bound box I'm getting from ogr2ogr

I'm using ogr2ogr to create geojson from a shapefile using the -lco WRITE_BBOX=YES argument. Everything is working great except the bound box (bbox) doesn't seem to be the traditional "left, bottom, ...
0
votes
0answers
27 views

QGIS 'Save As' Reprojection Produces Different Results from ogr2ogr command line

Another 3857 vs 4326 question. When I reproject from EPSG:3857 to EPSG:4326 (and from .shp to .geojson) via the QGIS 'Save As' dialog, I get results that display in the expected place on Google Maps. ...
0
votes
0answers
42 views

ogr2ogr failing to open/convert GML

I'm trying to convert a GML file into GeoJSON using ogr2ogr, I've compiled GDAL, Expat and Xerces from source, but when I run my command I get an error. My convert command ./ogr2ogr -f "GeoJSON" ...
0
votes
0answers
34 views

Can styling be applied to a kml (from a shp) using ogr2ogr

Is it possible to generate a styled KML using ogr2ogr (ie pen width and colour?) I cannot seem to find anything in the ogr2ogr documentation. My code so far is; ogr2ogr.exe -f "KML" prow-kml.kml ...
0
votes
0answers
24 views

Merging polygons in SHP

Is it possible to merge polygons, using ogr2ogr cmdline tools? I.e. taking a SHP file and generate a new one, where records are merged when a field has the same value?
0
votes
0answers
51 views

ogr2ogr converting ESRI shape to Mapinfo interchange

I'm trying to convert .shp files to .mif files on Ubuntu Linux using ogr2ogr: "ogr2ogr -f "MapInfo file" -dsco FORMAT=MIF mprec.mif mprec.shp" I don't get any errors but when I open the resulting ...
0
votes
0answers
17 views

Different KML size from ArcGIS and Ogr2Ogr

I have been converting shapefiles to KML. It seems that using ArcGIS to make a KML (by converting shapefile to feature layer and then using feature layer to kml tool) results in a much larger sized ...
0
votes
0answers
28 views

How to convert dc to shp with free software?

Someone can tell me how to convert data from a .dc file (DesignCAD file) to a shp file or postgresql with free softwares? I can do that easily with all versions of dxf or dwg files but not with dc.
0
votes
0answers
39 views

ogr2ogr re-projection produces empty shapefile

I use the following to re-project a shapefile to EPSG 4326 using ogr2ogr: ogr2ogr -s_srs "+proj=longlat +ellps=WGS84 +datum=WGS84 +no_defs" -t_srs "+proj=longlat +ellps=WGS84 +datum=WGS84 +no_defs" ...
0
votes
0answers
13 views

OGR2OGR converting Interlis to Shapefile fails

I tried an convert of a Interlis 1 file to Shape. For each table there is the following warning: Warning 1: No field definition found for table: Biens_fonds__PosPoint_limite I used different ...
0
votes
0answers
42 views

ogr2ogr libkml output - multiple components in OGR_STYLE

I have following command: ogr2ogr -overwrite -f libKML z.kml "MSSQL:server=dev;database=db;trusted_connection=yes;tables=tmp.libkml_test" -where "stabbr = 'CT'" My source table contains a series of ...
0
votes
0answers
15 views

Extract table-embedded attributes in KML using ogr2ogr

I'm loading a number of diverse data files into a PostGIS database, using ogr2ogr. One of these data files is a KML with useful attributes embedded as an HTML table in a description column: ...
0
votes
0answers
57 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 ...
0
votes
0answers
29 views

Subtract parts of polygon that overlap with ocean

I have some seismic data in format of shapefiles/geojson. The data has no relevance in the oceans so I am looking to strip away those parts of the polygon. What I am currently doing is using the ...
0
votes
0answers
81 views

ogr2ogr in java gdal

I would like to code ogr2ogr -f "GeoJSON" destination.geojson source.geojson -s_srs EPSG:3068 -t_srs EPSG:4326 in java-gdal. I tried to understand how it should work by looking at this example but ...