For example, my intersection is Cross Avenue @ Sacramento Street, in the City of Tulare, CA.

I need a tool that gives me a GPS location for like 1500 intersections.


Using PostGIS

See geocode_intersection in PostGIS for the open source method of doing this.

Geocode_Intersection — Takes in 2 streets that intersect and a state, city, zip, and outputs a set of possible locations on the first cross street that is at the intersection, also includes a geomout as the point location in NAD 83 long lat, a normalized_address (addy) for each location, and the rating. The lower the rating the more likely the match. Results are sorted by lowest rating first. Can optionally pass in maximum results, defaults to 10. Uses Tiger data (edges, faces, addr), PostgreSQL fuzzy string matching (soundex, levenshtein).

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