Featured image of post Format and convert map data
Data Wrangling Problems

Format and convert map data

A solution pattern for standardizing coordinates before passing data to the next map tool

Use this pattern when decimal precision or coordinate reference systems are inconsistent and your map data does not line up correctly in the next tool.

Solution

Standardize latitude/longitude formatting first, then convert the coordinate system if needed. Splitting the work into formatting and projection changes makes it easier to isolate the source of location errors.

Tools

Lat/Lon Formatter
dataprep.jp
Lat/Lon Formatter
Standardize latitude/longitude format and precision
latlon-formatter.dataprep.jp
Transform Coordinates
dataprep.jp
Transform Coordinates
Convert the coordinate system of geographic files
transform-coordinates.dataprep.jp

Good fit for

  • Mixing map data from different coordinate systems
  • Normalizing latitude/longitude precision
  • Troubleshooting positional offsets