Ticket #822 (closed enhancement: fixed)

Opened 2 years ago

Last modified 2 years ago

Add a reverse_geocode function to tiger geocoder

Reported by: robe Owned by: robe
Priority: medium Milestone: PostGIS 2.0.0
Component: postgis Version: trunk
Keywords: tiger, history Cc:

Description (last modified by robe) (diff)

Given a PostGIS long/lat WGS 84/NAD 80 geometry point (and an optional option of returning the street range (for cross streets) - boolean that defaults to false), return an array of approximate street addresses and other related items (reverse interpolating along the edges and street address ranges).

Other related items would be an array of cross streets (this will include street range if include_street_range is tru), array of centerline points (if the point is say at the corner of 2 streets) would return the interpolated centerline points) or just one.

This will be useful for example managing fleets of cars or emergency response when you get back a long lat from GPS devices, but don't know where that is along your road networks or if its parked off the street or possibly at a site)

Change History

Changed 2 years ago by robe

  • owner changed from pramsey to robe

Changed 2 years ago by robe

  • description modified (diff)

Changed 2 years ago by robe

  • status changed from new to closed
  • resolution set to fixed

More or less done and documented -- need to improve the speed to get it under 1 second (right now takes about 1.5 secs per point on my Windows 2003 server using all of MA data).

On the bright side -- it will take any point that has a srid, not just long lat.

Changed 2 years ago by robe

  • keywords tiger, history added; tiger removed
Note: See TracTickets for help on using tickets.