I've got a CSV file which I downloaded from a Waka Kotahi open data website.

The file has got X,Y coordinates of locations. I am using that file in Python to generate markers in Folium. I don't have ArcGIS or QGIS.

Coordinates that file contains does not look in EPSG:4326 format. I suspect that it could be NZTM coordinate system (i.e. EPSG:2193). Because value looks like (X=1406914, y= 4915023).

Is there anyway that I could find the coordinate system of coordinates without using GIS system?

  • @mikewatt thanks. Last question: Do you know any website that converts coordinates into EPSG4326? I want to convert lat:-40.9006 long:174.8860 into EPSG4326 Commented Nov 3, 2021 at 20:03
  • Your coordinates look like EPSG:4326 but you seem to know that they are in some other coordinate system. What is that?
    – user30184
    Commented Nov 3, 2021 at 20:11
  • 1
    Can you download QGIS? It would make your life easier if you're working with gis data. Convert coords here epsg.io/transform#s_srs=4326&t_srs=3857 just change the coordinate systems to the ones you need.
    – jbalk
    Commented Nov 3, 2021 at 20:27
  • 4
    As a rule, it's better to get the spatial reference from the data provider than trying to guess, mostly because guessing has such a high error rate.
    – Vince
    Commented Nov 3, 2021 at 20:40

1 Answer 1


If you download the shapefile instead of the CSV you'll find a .prj file in the zip which is the projection metadata:


If the next step in your processing can deal with the WKT format like this, then great!

Otherwise QGIS recognises that as EPSG:2193 - NZGD2000 / New Zealand Transverse Mercator 2000 so you can plug that EPSG code into a conversion process.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.