Reprojecting CSV with ogr2ogr

100%

Reprojecting CSV with ogr2ogr

✓ Published0🌍 Public

Last edited Feb 9, 2016

Created on Jul 10, 2014

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.

AI-generated description

rm -f output.csv
ogr2ogr -f CSV -t_srs EPSG:4326 -lco GEOMETRY=AS_XY -nln output output.csv input.vrt

gpl-3.0 Licensed

Similar vizzes

Loading thumbnail…

Custom Cartesian Projection

This example displays a set of land parcel polygons from a GeoJSON file, drawn as light gray shapes with black outlines on an SVG canvas. It creates a custom Cartesian projection by implementing a `d3.geoTransform` that maps raw coordinates through two `d3.scaleLinear` scales for the x and y axes. The resulting transform feeds into a `d3.geoPath` generator, which renders the geographic features using the projected coordinates, bypassing standard geographic projections.

Mmbostock

57% 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

56% match

Loading thumbnail…

Gist f3b3c7d224f1701a9d7f

This Shiny application lets a user upload a CSV file of XY coordinates, which are then read with the built-in `read.table` function and converted into a spatial points object using `SpatialPointsDataFrame` from the `sp` package. The app renders a basic scatterplot of these points via `plot()` and offers a download button that exports the coordinates as an ESRI Shapefile using `writeOGR` from `rgdal`, zipping the resulting files for delivery. The interface is built with `bootstrapPage` and `fileInput`, and it validates that data has been selected before plotting.

RRCura

56% match

Loading thumbnail…

Shiny / R : csv to shapefile

This Shiny/R application demonstrates a straightforward conversion of CSV point data into an interactive map and downloadable ESRI shapefile. Users upload a CSV file, which is read via `read.table` and converted into a spatial points data frame using `SpatialPointsDataFrame` from the `sp` package, with optional CRS assignment commented out. The coordinates are plotted using base R’s `plot` function, while the `writeOGR` function from `rgdal` exports the data as a shapefile, which is then zipped and served through a `downloadButton` wrapped in a `downloadHandler`.

RRCura

55% match

Loading thumbnail…

[Working with spatial data](https://github.com/enjalot/wwsd)

This example demonstrates how latitude and longitude coordinates from a world GeoJSON file are projected onto an SVG canvas using a custom cylindrical map projection, with red circles marking London and San Francisco. Built with D3.js version 3.5.5, the code uses `d3.geo.projection` to define the cylindrical transformation and `d3.geo.path` to render the world map from the 110m-resolution GeoJSON data. The `projection([0,52])` and `projection([-122.4194,37.7749])` calls place the two cities, while the commented-out alternative projections (Mercator and azimuthal equidistant) show the flexibility of the approach.

KKristinHenry

54% match

Loading thumbnail…

Raster & Vector III

This example shows how vector geographic features (U.S. counties) can be overlaid on raster map tiles from OpenStreetMap, with both layers staying aligned during pan and zoom interactions. The vector layer is rendered as a single SVG path using `d3.geoPath` and a `d3.geoMercator` projection, while raster tiles are fetched and positioned via `d3.tile` and `d3-zoom`. Instead of reprojecting, the code updates the SVG transform and stroke-width for efficiency, using `d3.zoomIdentity` and the `on("zoom")` event.

Mmbostock

54% match

Loading thumbnail…

Projection Contexts

This example demonstrates composable context wrappers for custom geographic projections in D3. It shows how d3.geoPath’s streaming geometry output can be intercepted at multiple stages—first through a radians-and-rotate context, then through a project-and-transform context, and finally through an antimeridian-intersection handler that splits lines crossing the ±180° meridian. The projection.line method chains these contexts to convert spherical coordinates to planar canvas coordinates. The code relies on D3’s geo-projection internals and the Canvas 2D context, illustrating a low-level approach for building tailored projection pipelines.

Mmbostock

54% match

Loading thumbnail…

Gist 496f20b47774ec679ab5dd48beff9d7e

This example maps French regional data from a CSV file onto a geographic outline of France. It uses a conic conformal projection and a quantized color scale to shade each region according to a numeric value. The visualization loads GeoJSON topology for the region boundaries and joins it with the CSV data, filling regions with a five-step green color ramp, while regions without data appear gray. The code relies on D3 v4’s `d3.geoConformal`, `d3.geoPath`, `d3.scaleQuantize`, and CSV/JSON loading functions.

EElisaDnr

54% match