Contents
How is geometry data assigned in ogr2ogr?
The geometry data is assigned the projected SRID EPSG:2249 (assumed to be the SRID in which the source data is supplied, but this is not checked by OGR2OGR). The following code listing takes data from the precincts.shp ESRI shapefile and loads it into the sql2012 SQL Server instance running on localhost .
How to export ogr2ogr patterns to SQL Server?
The following code exports data from the OGRExportTable in the localhost\\sqlexpress SQL Server instance to an ESRI Shapefile called c: emp\\sqlexport_linestring.shp . ESRI Shapefiles can only contain features of a single geometry type.
Where is the geog4269 column in the prospatial table?
The data is inserted into a geography column called geog4269 in the CaliforniaZCTA table of the ProSpatial database. The inserted geography data is assigned the EPSG:4269 SRID, which is the spatial reference system in which the data of the shapefile is already defined.
What is the difference between GDAL and OGR?
While GDAL itself deals with raster data – GeoTIFFs, ECW, DEMs and the like – its sister project, OGR, deals with vector data formats such as ESRI Shapefiles, MapInfo, KML, or SQL Server geography/geometry data. The OGR2OGR utility is the specific GDAL/OGR component for transforming data between these different vector formats.
What do you need to know about ogr2ogr SQL Server?
After importing any data, OGR2OGR will create two additional tables in your SQL Server database – spatial_ref_sys and geometry_columns, which store metadata about the spatial columns in the tables. These tables can be safely ignored (or deleted) – OGR2OGR will recreate them after each conversion anyway.
What to do with double quotes in ogr2ogr?
If you do use double quotes, you should use “straight quotes”, and not “smart quotes”. After importing any data, OGR2OGR will create two additional tables in your SQL Server database – spatial_ref_sys and geometry_columns, which store metadata about the spatial columns in the tables.
How to export multiple PostGIS tables in ogr2ogr?
One way in which ogr2ogr excels above using the pgsql2shp tool is that ogr2ogr can export multiple tables at once. This is pretty handy for sharing your postgis data with others who do not have a postgis database. The code below will export all your postgis tables out into a folder called mydatadump in ESRI shape (shp) format.
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