Converting 7 digit coordinates to Latitude and Longitude (Ohio, USA)

Question

I have a dataset of traffic monitoring stations in Ohio, and I am trying to locate these stations in Lat/Long.

Here is an example:

This station is located in Franklin county, along Interstate 71. CTL_BEGIN, per the Ohio Department of Transportation, is the "County True Log" Begin number. I am not sure of the reference point, but I would imagine it is a linear distance along this route from some reference point.

In the geometry field, one can see 7 digit coordinates (-9237663.3157 4859645.310999997). I tried entering these coordinates into a UTM -> Lat/Long converter, with UTM Zone 17, North Hemisphere, but this worked out to somewhere very much not in Ohio.

Here is a link to an admittedly sparse document on Ohio's coordinate systems, which I did not find helpful, but someone else may.

Any ideas how I would go about converting these coordinates, or otherwise locating these stations in Lat/Long, so that I may map them and do distance calculations with other coordinates?

Edit: For those who are operating with a Shape file and Python, if you import your .shp file into Geopandas, and then call .to_crs, you can convert quickly into the coordinate system of your choice. Calling .crs on your Geodataframe will tell you the system your data is using. I should have called that and I would have had my answer!

Answer 1

http://projfinder.com/ is a useful utility for finding the coordinate system of a set of points when the system isn't known.

If I put that point of yours in the X-Y boxes and go to Ohio, I can see a couple of possible locations around Columbus (and in the whole state there's some points way up north..)

The southernmost one appears to be on I71 at a junction:

(faint yellow circle, centre)

and this is EPSG:3857 which is the standard "Web Mercator" coordinate system. I'd wager that's what they are.

Coordinate convertors from EPSG:3857 to lat-long (EPSG:4326) or any other coordinate system are available via the PROJ library, with interfaces in Python, C, R, and a dozen other languages, or command line, or any GIS such as QGIS.