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.

closed as unclear what you're asking by PolyGeo May 11 '17 at 2:28

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.


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.