[postgis-users] Census Block, other fields from Tiger Geocoder?

Daniel Weitzenfeld dweitzenfeld at gmail.com
Fri Oct 7 14:18:20 PDT 2011


I'm currently using this as my query:

SELECT g.*,
        ST_X(geomout) As lon,
        ST_Y(geomout) As lat, (addy).*
FROM geocode('<address here>') As g;

I'm wondering what other fields I can add to the SELECT.  E.g., can I get
census block?

I know one route is to use the lon/lat together with the shapefiles
themselves and use point-in-polygon, but that seems circuitous.

Thanks!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20111007/c17b18f3/attachment.html>


More information about the postgis-users mailing list