GDAL/OGR

100%

✓ Published0🌍 Public

Last edited Feb 19, 2015

Created on Feb 19, 2015

This example demonstrates how to convert a File Geodatabase (file.gdb) into a PostgreSQL database using the GDAL/OGR command-line tool. The code executes `ogr2ogr` with a PostgreSQL connection string specifying the database name and user, directly transferring spatial and attribute data between formats. It highlights the library’s role in migrating geospatial datasets without additional scripting. The command handles the conversion in a single step, preserving the original file’s structure. No visualization or rendering occurs; the focus is purely on the data interchange process via GDAL’s OGR vector driver.

AI-generated description

Similar vizzes

Loading thumbnail…

Gist 61afda568887fcc603e1f9ef963925ec

This example demonstrates a QGIS Processing model that exports spatial data to a PostgreSQL/PostGIS database. The model chains two algorithms: `qgis:postgisexecuteandloadsql` to run SQL and load the result, followed by `qgis:importintopostgis` to write the output to a table named "out2" in the public schema. It uses the PostgreSQL connection "EPSG demo," sets UTF-8 encoding, and creates a geometry column. The model shows a reusable workflow for automating database ingestion directly from the QGIS Processing framework.

TThomasG77

64% match

Loading thumbnail…

Using ogr2ogr from Scala

This example demonstrates how to invoke the GDAL `ogr2ogr` command-line utility directly from a Scala application to convert geographic data between formats. The code uses the `org.gdal.apps.ogr2ogr` class to execute conversions asynchronously via Scala’s `Future`, allowing non-blocking file processing. It shows two distinct conversions: one to ESRI Shapefile using default settings, and another to CSV with custom layer creation options (`-lco`) for geometry as WKT, automatic `.csvt` generation, and semicolon separators. The example reads from a GeoPackage input file and writes to organized subdirectories, demonstrating path handling with `java.nio.file.Paths` and directory creation via `Files.createDirectories`. Error handling is implemented through Scala’s `Try`-style success/failure callbacks.

BBrideau

64% match

Loading thumbnail…

Gist ec3b35b83d07ef1d37a4af819723842b

This example demonstrates how to set up a PostgreSQL foreign data wrapper for staging data access. It shows the process of creating a foreign server, mapping users, and importing an external schema into a local staging schema. The code uses the `postgres_fdw` extension, along with SQL commands such as `CREATE SERVER`, `CREATE USER MAPPING`, and `IMPORT FOREIGN SCHEMA`. It also includes a commented example of querying imported tables, like selecting from `staging.users` to create a local table. The approach relies on PostgreSQL’s FDW API to connect to a remote database and expose its tables locally.

XXXX

62% match

Loading thumbnail…

Reprojecting CSV with ogr2ogr

This example demonstrates how to convert a CSV file containing projected coordinates (EPSG:2263) into unprojected longitude and latitude values (EPSG:4326). The conversion relies on a virtual dataset defined in a VRT file, which specifies the source CSV, its geometry type, and the source coordinate system. The command-line utility `ogr2ogr` from the GDAL library performs the reprojection, outputting a new CSV with the transformed coordinates. The VRT uses the `PointFromColumns` geometry encoding to interpret the X and Y columns as spatial points.

Mmbostock

61% match

Loading thumbnail…

Postgres is Enough

The visualization maps PostgreSQL’s ecosystem onto a network graph, showing how the database extends into background jobs, search, APIs, and data visualization. It uses a force-directed layout with `d3.forceSimulation` to position nodes representing tools like pg_cron, PostGIS, pgvector, and Metabase, while links connect related categories. The graph is rendered as an SVG with D3’s `d3.select` and `d3.line`, with node sizes encoding the number of associated libraries. Data comes from the static markdown file listing each tool’s URL and category.

Aapburnes

61% match

Loading thumbnail…

Shell script to import data into Postgres from https://www.nhgis.org. If you use this, you'll need to edit line 14 to include the census data you're importing.

This script sets up a Postgres database to hold U.S. Census block-group data, combining demographic race counts with spatial geometries. It first imports CSV race data into a table, then converts shapefiles to a uniform projection (EPSG:4326) using `ogr2ogr` and appends them via `shp2pgsql`. The code uses PostGIS for geometry support and creates a spatial index on the `geom` column. It relies on command-line tools like `dropdb`, `createdb`, and `psql`, processing files from the NHGIS source archive. The final output enables querying joined attribute and spatial data.

CCaged

61% match

Loading thumbnail…

Fustion Tables CSV => Postgresql => Geom fix

This example shows a workflow for repairing invalid geometry in a FEMA damage assessment dataset stored in PostgreSQL with PostGIS. It converts KML-style polygon coordinates from a Fusion Tables CSV export into valid PostGIS geometries, then updates the spatial column. The process uses SQL string functions like `replace()` to transform coordinate formatting, `ST_GeomFromText` to parse the text into geometry, and `ST_MakePolygon` with `ST_AddPoint` to close and correct the polygons. The result prepares the data for subsequent mapping or analysis in a GIS environment.

Aandrewxhill

60% match

Loading thumbnail…

Load GTFS as GPKG with GDAL 3.7

This example demonstrates converting an IDFM GTFS transit feed into a GeoPackage database using GDAL’s new GTFS driver. The Bash script first checks that GDAL 3.7 is installed, then uses `ogrinfo` with `-json` to list all available layers. For each layer, it runs `ogr2ogr` with the GeoPackage format, appending layers incrementally with the `-update` flag. The source data is loaded directly from a URL via `/vsicurl/`, and the script allows customizing input and output names through environment variables.

TThomasG77

60% match