473,396 Members | 1,853 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

Determining the US State from Latitude and Longitude

2
As a part of a larger project I'm looking for methods or examples of how to determine which of the 50 US States a vehicle is located in given its latitude and longitude. More detailed information like city, county, etc. isn't required but I can always toss out extra stuff.

Ultimately the "solution" will become a procedure or function that is incorporated into a stand alone (non-web based) program but there is a database available if lookup tables or other data sets are needed.

Thanks for any pointers or suggestions.

Tim
Sep 11 '07 #1
6 5205
debasisdas
8,127 Expert 4TB
You need to store all the Latitude and Longitude related data in the database table . Then you need to retrive the info implement the logic . I think u need to check for the intersection of Latitude and Longitude for the same.
Sep 12 '07 #2
tpmcd
2
You need to store all the Latitude and Longitude related data in the database table . Then you need to retrive the info implement the logic . I think u need to check for the intersection of Latitude and Longitude for the same.
Agreed. My search so far looks like the state boundaries are typically available as "shape files" used by various creators of Geographic Information Systems. The solution it seems will be to store that data in the database and create a query that can be used to determine which shape (state) encloses the specific coordinates being checked.

Tim
Sep 12 '07 #3
JosAH
11,448 Expert 8TB
As a part of a larger project I'm looking for methods or examples of how to determine which of the 50 US States a vehicle is located in given its latitude and longitude. More detailed information like city, county, etc. isn't required but I can always toss out extra stuff.
Well you do need the lat/long points that make up the border polygon of a state.
Determining in which polygon (state) a certain pont lies, isn't that much of a problem.

kind regards,

Jos
Sep 12 '07 #4
Shashi Sadasivan
1,435 Expert 1GB
Google maps
yahoo maps
Microsoft live maps
They all have API,s...free to use (including microsofts...all are implemented in javascripts but you can get the equivalent work in other languages done from some open source developers)

Cheers
Sep 14 '07 #5
nick b
1
does anyone know of a site where i can download the lat/long of each state border in a data set?
Dec 28 '08 #6
RedSon
5,000 Expert 4TB
You can do a google search for GIS Data and see if any of those are what you are looking for.
Dec 29 '08 #7

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: jack | last post by:
not sure exactly where I should ask this question, but im looking for a database of Australian Postcodes that included the longitude/latitude. Does anyone know of such a thing? Preferably...
4
by: YS Sze | last post by:
If you know the exact longitude and latitude for a specific location, would anyone think it'd make any sense to find out if this set of location numbers is really part of the Fibonacci series or...
1
by: Jochen | last post by:
Hello, I'm currently trying to programm a Windows Application that embedds a MapPointControl. My question is, how I can retrieve the Longitude and Latitude from a spot on the map, e.g. the...
2
by: kbperry | last post by:
I am not sure if this is the right place for this, but I thought it was worth a shot. What I want: Enter a From: street address and a To: street address, and then specify an interval (say...
6
by: helpneeded | last post by:
Hi I am a novice using the <maptag. I have a question. I would really appreciate if you could answer me. I want to use the <maptag to dynamically update my map with coordinates. These...
3
by: Sally1053 | last post by:
I have created a procedure which start by fecthing data from DB-X and put in into the temporary memory. what im trying to do now is to take data from temporary memory insert/update DB-Y. But now...
5
by: arial | last post by:
Hi all, I have a sql .bak file which i need to convert into xml file. can someone help with this? pointing out to some tutorial or some suggetion on how to start? Thak you,
1
by: alan5 | last post by:
I want to answer on the topic australian postcode db with longitude/latitude posted by jack. He wrote: not sure exactly where I should ask this question, but im looking for a database of...
1
omerbutt
by: omerbutt | last post by:
hi i am trying to store the longitude and latitude i have made the table with 3 columns codes, longitude , latitude and the type for longitude and latitude is decimal(15,11) but there are different...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.