0

This question already has an answer here:

I have a CSV with latitudes, longitudes, and place descriptions, I'm trying to figure out the CRS so I can reproject the data.

The data has no accessible documentation, and appears to be dumped out of an Oracle database.

Plotting the coordinates on a cartesian grid shows all of the United states and some places outside of it.

map of points in the dataset

What is the best way to figure the CRS out?

Here are a few examples from (juding by the FIPS codes) Brooklyn, Boston, and LA

Longitude, Latitude, State_Code, County_Code, Station_Location
73948800, 40725490, 36, 47, BTWN NORMAN AVE & DRIGGS AVE
71023639, 42424997, 25, 25, NORTHEAST EXPRESSWAY 
118442961, 34042668, 6, 37, N/O OLYMPIC BL; S/O JCT RTE 2

marked as duplicate by Vince, Andre Silva, Mapperz Nov 22 '16 at 17:33

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

2

In writing out this question I thought I'd look into one thing before I submitted.

Turns out these are just lat & lon but without decimal points and only positive

As such these coordinates appear to match the descriptions

Longitude, Latitude, State_Code, County_Code, Station_Location
-73.948800, 40.725490, 36, 47, BTWN NORMAN AVE & DRIGGS AVE
-71.023639, 42.424997, 25, 25, NORTHEAST EXPRESSWAY 
-118.442961, 34.042668, 6, 37, N/O OLYMPIC BL; S/O JCT RTE 2
  • 2
    to add the negative value and decimal places to the long and lat value you can multiply each individual value by 0.0000001 – ziggy Nov 22 '16 at 1:36

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