Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Determine the Latitude/Longitude ( or SRS( e.g. EPSG:3857) used) for Easting/Northing for CSV export of Surveys #70

Open
hemantbist opened this issue Dec 29, 2021 · 2 comments

Comments

@hemantbist
Copy link

How to determine the Latitude/Longitude ( or SRS( e.g. EPSG:3857) used) for Easting/Northing for CSV export of Surveys

I exported the Survey data from the Missouri Database provided at your website in csv format using your software
How do I map the location of the point where the survey was done?

This is what I tried (But failed)
a) There are two columns Easting and Northing but I am unable to map them to Latitude, Longitude.
I tried to guess the SRS for these, but could not find anything that mapped points correctly.

b) The data is sqlite but I am unable to find a table where this information may be stored.

c) There is no option to specify SRS during the export.

Here is the link to download the gzipped xsdb.
https://xsviewer.northarrowresearch.com/Technical_Reference/missouri_database.html

Here is a sample output from the exported CSV for one of the surveys.
Survey,CrossSection,River Distance,Sailing Distance,Easting,Northing,Elevation,Date,Station,Offset,Surey Point Codes
1994,109,5.07,5.07,2441187.50,14109360.83,396.13,01 Jul 1994,589.13,16.95,
1994,109,5.07,5.07,2441183.23,14109340.02,389.23,01 Jul 1994,610.37,28.49,
1994,109,5.07,5.07,2441179.14,14109320.03,388.93,01 Jul 1994,630.77,34.38,
1994,109,5.07,5.07,2441175.00,14109299.81,392.33,01 Jul 1994,651.40,37.96,

@JohnShelley
Copy link

JohnShelley commented Jan 3, 2022 via email

@hemantbist
Copy link
Author

hemantbist commented Jan 4, 2022

Thanks John,
I googled for the UTM 15 N feet.
EPSG: 32165 does map it correctly in the river.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants