ogr2ogr is an open source command line utility popular for converting to and from various vector spatial data formats.
0
votes
1answer
52 views
Should a GDAL Plugin be the same version as GDAL aready built into QGIS
Should a GDAL Plugin be the same version as the GDAL that's aready built into the QGIS version installed?
Or,can another different version of GDAL be built and it installed as a Plugin for QGIS, ...
0
votes
1answer
38 views
OGR shows no layers
I have an ESRI File Geodatabase (FileGDB) (size is 15+GB), which has over 10 layers, when I open it up in ArcGIS, everything seems to be working.
I want to move this database to postgreSQL with OGR ...
1
vote
3answers
84 views
How to convert KML (Google Latitude) to SHP on Linux?
I downloaded a KML track from Google Latitude. The service allows to download the tracked route from the user's profile providing a link such as:
...
7
votes
2answers
185 views
How to reduce the file size of GeoJSON data?
For my project I am trying to convert the tiger shapefile information for us states into GeoJSON format
However when I use the ogr2ogr tool the data file is about 20 MB. I have seen the geoJSON file ...
0
votes
1answer
64 views
Export KML ExtendedData with OGR2OGR
I would like to export with ogr2ogr the data I have in a kml as ExtendedData
<Placemark>
<ExtendedData>
<SchemaData schemaUrl="#15540_punti">
...
0
votes
1answer
18 views
BBox missing when converting TIGER to GeoJSON
I can't get the bounding boxes of polygons if TIGER/Line shape files when converting them to GeoJSON using FWTools. The other default information is present and there is no difference between the ...
1
vote
1answer
24 views
Loading shapefile to a specific table in postgis using ogr2ogr
I have already created a geometry table in postgis. I want to load several shapefiles into that table using ogr2ogr. But I didn't find the parameter which could specify that table.
ogr2ogr -append ...
0
votes
1answer
33 views
Transform GeoRSS from WGS84 to UTM 33N with ogr2ogr
Is this really not supported or do I have missed something in my code? If it is not possible with ogr2ogr, do you know of any other open source methods to reproject from GeoRSS to GeoRSS or from shp ...
1
vote
1answer
28 views
Batch convert OSM/PBF data
I need to import some OSM data about a region of Italy into a SHP file or Postgres DB, possibly with batch process.
I already use OGR2OGR to batch import data from SHP to Oracle and Postgres and I ...
2
votes
1answer
190 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 ...
3
votes
1answer
475 views
How do you open shapefiles with ogr2ogr
I'm following along the D3 tutorial, and on this line:
ogr2ogr \
-f GeoJSON \
-where "adm0_a3 IN ('GBR', 'IRL')" \
subunits.json \
ne_10m_admin_0_map_subunits.shp
run into the following ...
2
votes
1answer
53 views
Converting mixed mapinfo tab files
Hi I need a little help/ ideas on how to convert tab files.
The problem:
I have many TAB files produced daily by 3 party app, I need to batch import the files into postgres.
Most files import fine, ...
0
votes
1answer
48 views
ogr2ogr extract shp-file by extent with bash script
I'm batch extracting features from shp-files in a directory with this bash script:
Is there a way to avoid the loop? I somewhere read that you can process folders but I was not able to get the right ...
3
votes
2answers
76 views
Is it possible to create CAD file from shapefile and also create CAD blocks from the database fields
I am trying to find out if there is any software or plugin/code that I can bundle that will take a shapefile and export it to a CAD file with CAD blocks generated so our CAD mappers can just move the ...
0
votes
0answers
21 views
Postgis to Spatialite using ogr2ogr create only schema
trying to use ogr2ogr to export from a Postgis database into sqlite (SPATIALITE) file, but I am getting only the database schema (tables definition) without any content (geometry and attributes).
I ...
0
votes
2answers
92 views
How to move and open shapefiles with ogr2ogr?
I'm a total newb following along the d3 map tutorial.
at this line:
ogr2ogr \
-f GeoJSON \
-where "adm0_a3 IN ('GBR', 'IRL')" \
subunits.json \
ne_10m_admin_0_map_subunits.shp
I get ...
3
votes
0answers
233 views
Ogr2Ogr exported this boundary 90 degrees incorrectly
I've got some GEOGRAPHY data in my Sql Server 2008. I wish to export it as a shapefile (so I can import it into QGIS) and when I do, it's rotated 90 degrees to the left.
Command line
C:\>ogr2ogr ...
2
votes
4answers
126 views
How to convert multipoint layer to point
I have a Spatialite layer which is multipoint (following a QGIS Save As from shapefile). I need it to be PostGIS and POINT. I have tried ogr2ogr -nlt POINT and got 'new row for relation "xxx" violates ...
2
votes
1answer
98 views
Can you explain this WKT multipolygon format?
I am confused by the output I'm getting from ogr2ogr when converting a shapefile to WKT. What I'm expecting to see is something in the form below (from Wikipedia):
MULTIPOLYGON (((40 40, 20 45, 45 ...
1
vote
0answers
62 views
Natural Earth: How to get the position of all provinces that belong to a state
This question is about Natural earth 1:10 states and provinces.shp file. I'm using ogr2ogr and want to know the name of the id i need to pass . In purpose of pulling out the right states regions.
...
1
vote
1answer
51 views
How does ogr2ogr determine which transformation to use and how big would the introduced error be?
I want to convert TIGER data
GEOGCS["GCS_North_American_1983",
DATUM["North_American_Datum_1983",
SPHEROID["GRS_1980",6378137,298.257222101]],
PRIMEM["Greenwich",0],
...
1
vote
0answers
103 views
Setting geometry types importing to PostGIS with OGR
I'm using ogr2ogr to import data into a PostGIS database. Each dataset I need to import has (theoretically) the same exact data structure, but it appears that they are not the same geometry types. ...
2
votes
1answer
88 views
Converting from shp to geojson fails
I'm following Mike Bostock's tutorial, let's make a map, but for a map of Mexico. I want to display state boundaries.
I was able to get the map of Mexico from Natural Earth Data's world maps. My ...
3
votes
2answers
380 views
How did QGIS fix a shapefile's character encoding, and can I do this on the command line with ogr2ogr?
Solved: I'm not sure why, but it works fine if I specify --config SHAPE_ENCODING "ISO-8859-1" in my ogr2ogr command. For whatever reason, this allowed ogr2ogr to go from the original TigerLine ...
4
votes
1answer
166 views
Can't export a polygon shapefile to MySQL using ogr2ogr?
I am having problems with ogr2ogr and keep getting different versions of the error:
ERROR 1: MySQL error message: The used table type doesn't support SPATIAL indexes.
Description: ALTER TABLE ...
1
vote
0answers
106 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
1answer
48 views
Ogr_wrap problem
I'm having problems with my csharp project in developing a console application.I've added references of ogr_csharp.dll & osr_csharp.dll & gdal_csharp.dll.
In the line Ogr.RegisterAll(); ...
1
vote
3answers
188 views
Ogr2Ogr SQLite Geometry Functions
I believe title is all clear.I'm using Ogr2ogr utilities & binaries to read geometry.
I used something like this:
ogr2ogr -f "SQLite" test2.sqlite test.sqlite -sql "SELECT ...
3
votes
0answers
54 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 ...
1
vote
1answer
100 views
Projecting shp from GK3 to UTM32 with BeTa2007
I've experimented with projections of shapes, used the official provided grid beta2007 for germany and noticed differences between transforming by double exporting over custom CRS in QGIS and ...
2
votes
1answer
100 views
How to debug ogr2ogr ERROR 1: Did not get at least 2 values or invalid number of set of coordinates?
I'm trying to convert a government data contour GML (http://geo.data.linz.gv.at/katalog/geodata/hoehenschichten/2011/1m-Hoehenschichten.gml) to Shapefile.
It seems like it was created by FME:
...
1
vote
0answers
45 views
ogr2ogr Convert to FileGeoDatabase FGDB_BULK_LOAD YES makes no difference
I am trying to export a lot of data from a PostGIS database to a FileGeoDatabase.
The command I used to use was
ogr2ogr -progress -append -f "FileGDB" -gt 66536 -sql "SELECT * FROM line" ...
2
votes
1answer
193 views
How to use non-native spatial data from MS SQL Server with ogr2ogr?
I have some tables in MS SQL Server (2012) with WKT string columns.
I want to export these data to a MapInfo tab file.
Currently I am using the following command:
ogr2ogr -f "MapInfo File" ...
1
vote
0answers
127 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
1answer
134 views
ogr2ogr from Postgres to GeoJSON missing crs key
I'm using ogr2ogr to convert some OSM data for Greenland (not really important for the question), from a PostGIS database to a file containing GeoJSON.
The problem is that the GeoJSON gets written ...
2
votes
1answer
134 views
Can ogr2ogr be used to append multiple DBF files?
Can ogr2ogr be used to append multiple DBF files? It works with SHP files, but I can't see how to do it with DBF files on their own. It ought to be possible, considering DBF is a subset of SHP.
3
votes
2answers
224 views
Why does Ogr2Ogr Postgres import fail?
I have a lot of S57 files that need to be imported to PostgresDB. The process takes over 2 hours. In order to improve performance, I have tried using PG_USE_COPY to use copy instead of DB inserts. I ...
2
votes
1answer
289 views
How to re-project shapefiles?
I wanted to re-project a QGIS project, but there is no such option. When searching for an answer I see ogr2ogr suggested for this task, by re-projecting each vector layer (shapefile in this example). ...
3
votes
0answers
179 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 ...
1
vote
1answer
157 views
GDAL 1.9.1 ogr2ogr KML to PostGIS not incuding ExtendedData
I have a KML file utilizing a Schema in the document and ExtendedData in each placemark. The ExtendedData does not seem to pass in conversion to PostGIS or shapefile.
Any assistance would be much ...
2
votes
2answers
239 views
What can go wrong in UTM to WGS1984 conversion (shifted data)
I try to convert .shp files to OSM data with shp2osm and ogr2osm but the output data is shifted.
Semi-Cross-Posting Warning: I have already asked a questions on the OSM help site, but this questions ...
8
votes
6answers
780 views
How to add field with filename when merging shapefiles with ogr2ogr?
I'm merging some shapefiles and I had some problems doing so inside QGIS, so i'm using ogr2ogr directly.
I'm doing this (in a batch):
ogr2ogr -overwrite %destination% %n1%
ogr2ogr -update -append ...
3
votes
1answer
167 views
ogr2ogr / GDAL remove features in FileGDB while in use by ArcGIS Server map service
I'm using ogr2ogr to pull features out of Oracle and put them into a File GeoDatabase. The FGDB is being used by an active ArcGIS Server map service. This is all done for performance / reducing DB ...
2
votes
3answers
494 views
How do I use ogr2ogr to convert a GML to shapefile in Python
I am trying to convert a GML to an ESRI shapefile using ogr2ogr utility in a python script.
I have successfully installed the GDAL/OGR package via osgeo but I am now struggling to find/understand ...
1
vote
0answers
81 views
Ogr2Ogr: Failed to create GPX file output.gpx
When i try to export an shapefile to gpx using ogr2ogr.
ogr2ogr -f GPX output.gpx D:\mypaste\input.shp -sql "SELECT Id AS name FROM layername"
It gives me the following error "Failed to create GPX ...
5
votes
2answers
239 views
OGR to read from oracle, and then write a CSV
I need to read an Oracle (not spatial) table with OGR.
I have no problem with ogrinfo. I use this command:
ogrinfo -ro OCI:user/password -sql "select * from HR.EMPLOYEES"
I have this kind of ...
5
votes
3answers
2k views
How to create a GeoJSON that works with D3?
I'm simply trying to convert a .shp file to a geoJSON format using:
ogr2ogr -f geoJSON output.json input.shp
After executing the command nothing seems to be wrong. Here's an excerpt from the ...
2
votes
0answers
210 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 ...
5
votes
1answer
503 views
OGR Shapefile to CSV: Using Python to get WKT for multipart Polys.
Using ogr2ogr and python, I'm running into a wall with trying to create a csv with WKTs for a shapefile that contains multipart polygons. Currently this is this code I'm using (found it on interweb):
...
5
votes
1answer
495 views
Importing KML in QGIS - what are all the node elements that QGIS looks for other than Name and Description?
Of all elements given at (ref: http://service.kmlvalidator.com/ets/ogc-kml/2.2/) only Name and Description seem to be recognized on importing KML using QGIS 1.8.0-Lisboa. I would like to know if this ...
