Questions tagged [ogrinfo]

ogrinfo is a program in the suite of GDAL tools. ogrinfo provides information about an OGR supported data format (traditionally vector format types).

Filter by
Sorted by
Tagged with
1 vote
1 answer
41 views

Use ogr2ogr/ogrinfo to connect to MSSQL on Ubuntu Server

OS: Ubuntu Server 20.04; Software: GDAL/QGIS, ogr2ogr/ogrinfo My goal is to use ogr to pull data from MSSQL as part of a longer process that I'm working on. First step is to test out the connection ...
1 vote
1 answer
71 views

How to get feature count of a GeoJSON into a bash variable?

I would like to have the number of features in a GeoJSON loaded into a bash variable. An example GeoJSON, example.geojson: { "type": "FeatureCollection", "features": [ { &...
2 votes
0 answers
126 views

How to download all parcel boundaries of North Rhine-Westphalia?

Context I'd like to download North Rhine-Westphalia's cadastre parcels as GeoJSON. Their website provides a WFS URL: https://www.wfs.nrw.de/geobasis/wfs_nw_inspire-flurstuecke_alkis?REQUEST=...
1 vote
1 answer
71 views

ogrinfo doesn't respond while exporting to MSSQL with ogr2ogr

I am trying to export data from postgres to MSSQL. While ogr2ogr -nln outputLayerName -f "MSSQLSpatial" "MSSQL_conn_string" --config MSSQLSPATIAL_USE_GEOMETRY_COLUMNS NO "...
  • 375
1 vote
0 answers
49 views

Find best cell size to use for rasterization from a shapefile

I've been using GDAL/OGR so far to gather information about my shapefile ogrinfo -so c:/shapefile.shp Using information such as the extents, I can incorporate this into my next command of gdal_grid ...
0 votes
0 answers
33 views

Using ogrinfo in Python to find specified information [duplicate]

I am using ogrinfo in Python to find out information about a shapefile from subprocess import Popen, PIPE args = ['ogrinfo', '-so', '-al', 'C:/test/test_shapefile.shp'] process = Popen(args, stdout=...
2 votes
1 answer
560 views

ogrinfo - specify what information you want returned

I am using ogrinfo to find out information about a shapefile ogrinfo -so -al 'C:/test/test_shapefile.shp' This obviously gives me a large summary, but I'm wondering is there any way to specify that I ...
0 votes
1 answer
414 views

Docker ogr2ogr & ogrinfo .shp shapefile "Unable to open datasource"

I am using current gdal docker image osgeo/gdal:ubuntu-full-3.4.1 to display metadata from a shapefile. After multiple failed attempts of failed installation of GDAL 3.4 on Ubuntu 20.10 I am now using ...
1 vote
0 answers
98 views

ogrinfo filter invalid geometries

I have shapefile and I want to filter all invalid geometries. ogrinfo -q /workspace/INVALID/0.shp -sql "SELECT * FROM \"0\"" -fid 1749 Layer name: 0 OGRFeature(0):1749 Target (...
0 votes
1 answer
258 views

Getting all Datasets and/or Feature classes and consequently spatial data from Esri Structures in MS SQL

I'm looking for query Esri data on MS SQL Server (best by using pure SQL). So far I'm using ArcPy from Esri Python toolset but that is far from being optimal. Example of iterating through the entire ...
  • 112
1 vote
1 answer
132 views

PyQGIS: Prompt ogr2ogr error in the log window of the processing tool

I have a processing tool that helps users to export data from PostGIS tables to GPKG. I am using ogr2ogr commands to achieve the tasks. I am calling the commands via subprocess. However, I cannot ...
  • 1,443
3 votes
1 answer
341 views

How to batch rename tables in GeoPackage with OGR

I would like to rename all tables in a GeoPackage file. The "translations" are stored in a .csv file. I would like to do this on the command line and found the below thread that uses the ...
  • 143
0 votes
2 answers
62 views

One-liner to print first feature from GPKG

To make the findings from this GDAL issue more discoverable, I'm posting here as well. ogr2ogr has a -limit option. I couldn't find this option for ogrinfo, while ogrinfo has e.g. -where. I would ...
0 votes
1 answer
47 views

One-liner to print first feature from GeoJSON

To make the findings from this GDAL issue more discoverable, I'm posting here as well. ogr2ogr has a -limit option. I couldn't find this option for ogrinfo, while ogrinfo has e.g. -where. I would ...
1 vote
1 answer
252 views

ogrinfo st_area for geopackage returns invalid target SRID

I want to use ogrinfo to get areas from a lat-long (EPSG:4326) layer right on the terminal shell, I'm using the query: ogrinfo -dialect sqlite -sql "select st_area(st_transform(geom, 32615)) from ...
  • 3,384
0 votes
0 answers
660 views

ogr2ogr cannot import .osm.pbf file to PostGIS

I'm trying to import a multipolygon layer from "colorado-latest.osm.pbf" into PostGIS. GDAL 2.4.2 has been installed in a Ubuntu system. However, whenever I'm trying to import the osm.pbf file, I get ...
1 vote
1 answer
2k views

Create and use index with GDAL/ogr on shapefile

I'm using OGR and VRT to create a new shapefile from two distinct sources (CSV file and shapefile). It works well, but it is very slow. I want to make it more efficient, so I tried indexing my data ...
  • 8,550
3 votes
1 answer
2k views

Converting DXF to ESRI Shapefile using ogr2ogr

I like to convert this DXF file to ESRI Shapefiles. I tried the following command: ogr2ogr -f "ESRI Shapefile" test.shp Umweltzone-Neu-Ulm.dxf ... which output the following warnings ...
  • 1,511
6 votes
1 answer
873 views

Adding file info using ogrinfo -sql UPDATE expression

I try to add the filename with the tool ogrinfo in a bunch of shape files for later merging reasons under Debian 8 and gdal 2.4.0. I stuck by expressing a valid statement for UPDATE part. For the ...
  • 3,508
8 votes
1 answer
378 views

QGIS and Mapinfo reporting different projections for some files

When I open a tab file that's been generated in QGIS using EPSG 28355 (MGA 94, z55s) using QGIS 3.10 the projection is transformed to 5551 But when I open it in Mapinfo v17 it's correctly reported as ...
  • 7,904
1 vote
0 answers
27 views

How to get feature class name using ogrinfo

I am importing kmz into postgres $ogrCommand = 'ogr2ogr -f "PostgreSQL" -a_srs "EPSG:4326" PG:"host='.env("DB_HOST").' port='.env("DB_PORT").' user='.env("DB_USERNAME").' dbname='.env("DB_DATABASE")...
0 votes
1 answer
540 views

How to convert an ASCII file (with lat,lon coordinates) to a shapefile using OGR?

I have an ASCII file with the following columns : ID, longitude, latitude, value Is it possible to use OGR (ogr2ogr or ogrinfo) in command line in order to open the ASCII file and convert it to a ...
  • 259
1 vote
2 answers
223 views

How to efficiently extract specific metadata for many shapefiles?

I have a directory with 50 subdirectories containing a total of 300 shapefiles which I would like to query for their feature count and output to a text file. Thus far I am able to get the feature ...
  • 127
0 votes
0 answers
421 views

Alter and update a shapefile with a field from an ASCII file using ogr

I have a vector file "map.shp" with a field ID. I have an attribute table (data.txt) with the following fields: ID, value1, value2. The field ID is the same in both files. I want to update map.shp by ...
  • 219
3 votes
2 answers
227 views

ST_Area(geometry) with ogrinfo estimates a stable area per grid cell

I use ST_area(geometry) in order to calculate the area of each grid cell of a vector grid with LCC projection and 6x6km2 resolution. The CRS of the vector is: +proj=lcc +lat_1=45 +lat_2=22 +lat_0=38.7 ...
  • 219
2 votes
1 answer
852 views

Add FID to attribute table using ogrinfo

I want to add the fid to the attribute table using ogrinfo in OSGeo4W Shell. Here is my code: ogrinfo layer.shp -sql "ALTER TABLE layer ADD COLUMN ID integer" ogrinfo layer.shp -dialect SQLite -...
  • 325
8 votes
3 answers
5k views

ogr2ogr sql: what is the name of the geometry field?

I have the following ogrinfo -so output about a shapefile: Layer name: PREDEFINED Geometry: Polygon Feature Count: 58075 Extent: (425995.430000, 336399.500000) - (447356.663000, 359782.760000) Layer ...
  • 3,181
1 vote
1 answer
2k views

ogrinfo says "Unable to open datasource" with KML?

I have a KMl file that will open fine in QGIS, but when I try to use ogrinfo I get: $ ogrinfo -so "myfile.kml" FAILURE: Unable to open datasource `myfile.kml' with the following drivers. -> ...
  • 3,181
2 votes
0 answers
356 views

ogrinfo: Unable to use sqlite dialect with -oo GEOM_POSSIBLE_NAMES open option

I am having problems using the SQLite SQL dialect to read a CSV file using ogrinfo, but only if I also specify a geometry column using the -oo GEOM_POSSIBLE_NAMES open option. Suppose file test.csv ...
  • 21
4 votes
1 answer
91 views

Why won't ogrinfo write to new column using informaiton from previous columns?

I'm having problems classifying an area of mixed forest using ogrinfo. I have an .sqlite file which contains the three columns; proportionclass1. proportionclass2, proportionclass3. I'm trying to ...
  • 455
2 votes
1 answer
1k views

How to List Fields of a Featureclass in a FileGDB using ogrinfo

I have an ArcGIS File Geodatabase, and I know that there is a featureclass within it. If I type: ogrinfo myfilegdb.gdb it lists the featureclasses within it. I now want to just find out what are the ...
1 vote
1 answer
4k views

How to install older GDAL v1.11 on Ubuntu 16.04 instead of v2.1.3

I have another question going on this forum regarding GDAL 2.1 ogrinfo not working at Trying to get GDAL 2.x to work, but ogrinfo reports ERROR 3: and ERROR 4: and "Failed to open table res_t48....
1 vote
0 answers
319 views

Trying to get GDAL 2.x to work, but ogrinfo reports ERROR 3: and ERROR 4: and "Failed to open table res_t48.PAT"

We have been using GDAL 1.9 for years on a Ubuntu 12.04 machine, but are trying to upgrade to Ubuntu 16.04 with the latest PostGIS and GDAL. When I install gdal-bin I end up with version 2.1.3. But ...
1 vote
2 answers
913 views

Remove Duplicate Records IDENT field -Shapefile using GDAL OGRINFO or OGR2OGR

I have two shapefiles that I am merging/combining. However, this produces more than 4,000 duplicate records. I need to have only unique records. Is this possible with OGRINFO or OGR2OGR? I've ...
4 votes
2 answers
175 views

Reading various (non-.shp) vector types using ogrinfo

I am using the OSGeo4W shell to call ogrinfo on a directory (geodata) to see what vector files it includes: As you see, it lists two shapefiles and it tells me that it is using the shapefile driver; ...
  • 6,431
14 votes
3 answers
6k views

Calculate total area of polygons in shapefile using GDAL?

I have a shapefile in British National Grid projection: Geometry: 3D Polygon Feature Count: 5378 Extent: (9247.520209, 14785.170099) - (638149.173223, 1217788.569952) Layer SRS WKT: PROJCS["...
  • 3,181
3 votes
1 answer
596 views

ogrinfo: Get a sample row from a GeoJSON file?

I know how to examine the properties of a GeoJSON file: ogrinfo my.geojson OGRGeoJSON -so But is there a way that I can retrieve a single feature's actual properties, to see what they look like? I ...
  • 3,181
1 vote
1 answer
83 views

How to restrict the output parameters in ogrinfo?

Just want to know, is it possible to restrict the output parameters while using ogrinfo? For example, I need only the Projection details for a bunch of tab files, that too in a single continuous line ...
  • 1,421
8 votes
1 answer
2k views

Using ogrinfo how to extract number of columns and attribute population?

Currently i'm using this DO ogrinfo -al -so to extract Projection, Feature count, Field_names for a bunch of files in batch mode. Is it possible to extract number of fields & how many fields are ...
  • 1,421
2 votes
0 answers
79 views

How to run ogrinfo for files listed in a CSV? [closed]

I am using this code to extract info's of all the tab files in a folder. We have a csv list which has, say 100 file names out of 500 files in that folder. How to modify the code only to do ogrinfo's ...
  • 1,421
2 votes
0 answers
26 views

Attribute table empty with custom driver in newer versions

I've written a custom ogr driver for one of our own formats. When loading the data I get to see vector data nicely displayed in Brighton/Essen/Pisa. However, when opening the 'Attribute Table' only ...