Insights about project management, GIS, and how technology is transforming industries operating in the physical world.
A point at (0, 0) is not a place your data came from — it is a coordinate that went missing, got swapped, or was read from the wrong column. Four failures, each reproduced in the csv-viewer and the coordinate-converter, with any message the tool shows, the distance it costs, and the fix.
Nine degrees-minutes-seconds forms through the coordinate converter, measured: which parse, which come back as DMS format not recognized., and which are accepted and still wrong. Plus the spreadsheet formula that fails silently, GDAL exiting 0 with no points, and one DMS cell in the csv-viewer.
Three columns, lat and lon, dropped into the csv-viewer — that is the clean case. This post covers the others: the decimal comma Excel pt-BR writes, a title row that shreds every line, swapped columns that draw silently in the wrong ocean, DMS, UTM and Latin-1 — what the viewer shows, and the fix.