2 votes

Reading coordinates linked/separated with underscore

Excel, LibreOffice etc. seem to have a 1,048,576 row limit, so that would not be an option here. However, setting _ as an additional separator to , when importing the file to QGIS does the job. (Didn'...
user avatar
  • 103
2 votes

Finding intervals of latitude/longitude of cities throughout the world at 0.01° precision

The answer to my question can be found in this post and the following website can be used to find a bounding box of any city in the world : https://www.mapdevelopers.com/geocode_bounding_box.php
user avatar
1 vote

Reading coordinates linked/separated with underscore

Using a ETL (FME) pulling your sample data: Extracted your coordinates here substring_x, substring_y and rebuilt the geometry from the coordinates given. These can be scaled-up easily for millions of ...
user avatar
  • 48.5k
1 vote

Order of latitude and longitude in EPSG:4326

I couldn't quite accept that PostGIS forces me to use (lon,lat) order when EPSG:4326 says it should be (lat,lon), so I spent way too much time thinking of a clever solution to find a suitable ...
user avatar
  • 151

Only top scored, non community-wiki answers of a minimum length are eligible