[postgis-users] TIGER geocoder

Luma ruby.tahboub at gmail.com
Wed Apr 16 22:34:19 PDT 2014


Hi Andre,

The normalize_address helps to format an address string into its components
e.g., street no., name, etc.

I don't have the MA data up, I just have the IN, so here's a geocode query

SELECT ST_AsText(geomout) FROM geocode('305 N University Street,West
Lafayette,IN,47907',1)

answer: "POINT(-86.9168058978249 40.4273633313738)"

You can also geocode intersections:

SELECT ST_AsText(geomout) FROM geocode_intersection('Brown St','10th
St','IN','Lafayette','47904',1)

answer: "POINT(-86.885921 40.421825)"





--
View this message in context: http://postgis.17.x6.nabble.com/TIGER-geocoder-tp5006118p5006120.html
Sent from the PostGIS - User mailing list archive at Nabble.com.


More information about the postgis-users mailing list