How to import shapefile in PostGIS using ogr2ogr?

How to import shapefile in PostGIS using ogr2ogr?

Firstly, you will import a shapefile in PostGIS using the most significant options of the ogr2ogr command. Then, still using ogr2ogr, you will export the results of a spatial query performed in PostGIS to a couple of GDAL-supported vector formats.

How to import ISO2 features in ogr2ogr?

Using some of the options from ogr2ogr, you will import only the features from SUBREGION=2 (Africa), and the ISO2 and NAME attributes, and rename the feature class to africa_countries:

What do you use ogr2ogr for in GDAL?

ogr2ogr is a command-line utility provided by GDAL for translating and converting vector geospatial data. It’s most often used for converting from one format to another, but it can also speak to a variety of web services – including the ArcGIS REST API, as we’ll demonstrate here, as well as WFS and WMS.

What are the parameters of the ogr2ogr command?

The ogr2ogr command has many options and parameters; in this recipe, you have seen some of the most notable ones such as -f to define the output format, -t_srs to reproject/transform the dataset, and -sql to define an (eventually spatial) query in the input OGR dataset.

How is OGR used to import non-spatial data?

Using OGR to Import Non-spatial Data While OGR was designed primarily to transform data between different spatial datasources, it is a little known fact that it can be used as well for importing non-spatial datasources such as Dbase files and CSV files. Importing Dbase file into PostgreSQL using Ogr2Ogr

How to import and export vector data from PostGIS?

In this recipe, you will use the popular ogr2ogr GDAL command for importing and exporting vector data from PostGIS. Firstly, you will import a shapefile in PostGIS using the most significant options of the ogr2ogr command.

Can a raster2pgsql be run in PostGIS?

Just like shp2pgqsl, raster2pgsql comes packaged with a PostGIS bundle installation. Just like shp2pgsql, this outputs a SQL file that you can then run in PostGIS. OpenStreetMap is a slightly specific case, but worth going through here separately, as it is widely used.

How to test PostGIS import with shp2pgsql?

I would have been stumped by your second error for awhile, but by testing your SQL user with a different import utility (shp2pgsql), which was smart, you got a more precise error message and gave your SQL user necessary privileges on the spatial_ref_sys table.

How to spatially enable a table in Oracle?

If you have a regular Oracle table without an SDO_GEOMETRY column, but containing location-related information (such as latitude/longitude values for points), you can spatially enable the table by adding an SDO_GEOMETRY column and using existing (and future) location-related information in records to populate the SDO_GEOMETRY column values.

How can I import data from OpenStreetMap to PostGIS?

OpenStreetMap: OpenStreetMap (OSM) is a collaborative project to create a free editable map of the world. Many people refer to OSM as the Wikipedia of maps. If you seek easy ways to get an extract of the data, you can check for GeoFabrik for Shapefiles or osmdata.xyz for GeoPackages. OpenStreetMap data from Africa.

Is the openfilegdb listed in the list of drivers?

OpenFileGDB is listed in the list of drivers. What am I doing wrong? I think the previous answer alluded to it, but at least one problem is that you are combining your dataset name with the data source. They need to be separate. Here is an example from the GDAL website:

How to read geodatabase In Postgres with ogr2ogr?

My set up of ogr2ogr looks like this: When I run ogrinfo on the test dataset I get error: Unable to open datasource ‘C:\\david recks.gdb’ When I run ogr2ogr on my set up I get error: Unable to open datasource ‘host=pg.rambck.local dbname=projects…….’

Why is ogr2ogr unable to open DataSource?

FAILURE: Unable to open datasource `Sydney2.shp’ with the following drivers. I have already checked successfully the shape with ogrinfo. ogr2ogr -f “ESRI Shapefile” Sydney.shp Sydney2.shp -s_srs EPSG:32656 -t_srs EPSG:4326 Any ideas? It looks like you’re expecting to convert data in Sydney.shp to Sydney2.shp with a different SRS.

How to convert CSV files to shapefile format?

The conversion of csv files to (projected) vector files (here we’ll use ESRI Shapefile format) can be automated using GDALs ogr2ogr library. First off, make sure you have gdal on your machine, otherwise download a copy and install it. Now, save this file called sample_xy.csv in a known directory on your machine.

Is it possible to visualise CSV files within a GIS?

The ability to visualise csv files within a GIS usually requires a couple of steps if you are operating your GIS in a point and click fashion. This is fine for a couple of files, but where you have multiple csv files, this takes / wastes a lot of time.

How to convert CSV files to ESRI shapefile format?

This is fine for a couple of files, but where you have multiple csv files, this takes / wastes a lot of time. The conversion of csv files to (projected) vector files (here we’ll use ESRI Shapefile format) can be automated using GDALs ogr2ogr library. First off, make sure you have gdal on your machine, otherwise download a copy and install it.

Do you need to select geometry field in ogr2ogr?

In these cases, you will need to select the geometry field to use. The most flexible way to do this is to use the -sql command which will take any sql statement. One way in which ogr2ogr excels above using the pgsql2shp tool is that ogr2ogr can export multiple tables at once.

How is ogr2ogr used to convert GIS data?

Ogr2ogr is the swiss-army knife when it comes to conversion of GIS data. It is part of the Geospatial Data Abstraction Library and provides an easy way to convert data between common storage formats: GeoJSON, Shapefile, PostGIS and others.

How can I export multiple tables in ogr2ogr?

The most flexible way to do this is to use the -sql command which will take any sql statement. One way in which ogr2ogr excels above using the pgsql2shp tool is that ogr2ogr can export multiple tables at once.

Which is the default solution for PostGIS shapefile?

* Note the recommendation in @LeeHachadoorian’s comment that -nlt PROMOTE_TO_MULTI be used as a default solution, rather than nlt GEOMETRY, as the former promotes best practice in addition to ancillary benefits.

What kind of data format does OGR support?

Ogr supports many data formats here is a subset of the ones we commonly use: ESRI Shapefile, MapInfo Tab file, CSV, DBF, GML, KML, Interlis, SQLite, GeoPackage,SpatiaLite, ODBC, ESRI GeoDatabase (MDB format), ESRI GDB database, PostGIS/PostgreSQL, MySQL.

How to change srid in ogr2ogr export function?

The initial ogr2ogr export function exports the shapefile with unreliable projection information (SRID). To ensure the shapefile retains the correct SRID the script creates a 2nd shapefile with the correct SRID. The original export file is NOT deleted.

How to export a shapefile with unreliable srid?

1. The initial ogr2ogr export function exports the shapefile with unreliable projection information (SRID). To ensure the shapefile retains the correct SRID the script creates a 2nd shapefile with the correct SRID. The original export file is NOT deleted.

How to export GML to geodatabase feature class?

Once you have set up the interoperability connection, you can export it to a shapefile or feature class using the usual Export Data command or geoprocessing tools such as Copy Features (Data Management). You could give the GDAL/OGR utility ogr2ogr a try.

How to export shapefile from SQL Server to Esri?

Around another 200 people have come here after searching for variations and combinations on this theme, including “OGR2OGR Sql Server”, “OGR2OGR MSSqlSpatial”, “OGR SQL”, “OGR Import shapefile” etc. What I’m not sure, though, is how to interpret this statistic or best act upon it.

How to export ogrexporttesttable to a shapefile?

So, let’s start by just trying out a basic example to export the entire OGRExportTestTable from my local SQLExpress instance to a shapefile at c: emp\\sqlexport.shp, as follows: (change the connection string to match your server/credentials as appropriate) This will fail with a couple of errors, but the first one to address is as follows:

How can I extract features from OpenStreetMap shapefile?

I’ve downloaded an openstreetmap shapefile and want to extract certain features (to make the file less heavy and have only the ones I’m interested in, for example bicycle paths from the roads). How would I do this, I can currently open the file and look at the features with this code:

Which is the best command to convert OGR data?

When you are working with an OGR dataset, two of the most popular OGR commands are ogrinfo, which lists many kinds of information from an OGR dataset, and ogr2ogr, which converts the OGR dataset from one format to another.

Which is the best tool to import data to PostGIS?

The tool I use most often for loading data to PostGIS is probably ogr2ogr. It is a very powerful tool to convert data into and from PostGIS to almost all possible vector data formats. GDAL/OGR is a software package that powers a great variety of different geospatial software tools and it comes with QGIS already installed on the server computer.