Rene, Did you see the email Leo had posted
http://www.postgis.org/pipermail/postgis-users/2011-October/031132.html The reverse_gecoder packaged with PostGIS 2.0 Tiger 2010 does output the city names. As Dan pointed out -- you need to join with the faces to get that. Faces also helps for determining which side of street a point falls in. -- I've reposted Leo's email for completeness Please let us know if anything is unclear. Thanks, Regina http://www.postgis.us --- LEO's email --- Actually we implemented a reverse geocoding function too for tiger 2010. That might be more what you are looking for. http://trac.osgeo.org/postgis/browser/trunk/extras/tiger_geocoder/tiger_2010 /geocode/reverse_geocode.sql The function usage is described here: http://www.postgis.org/documentation/manual-svn/Reverse_Geocode.html As far as installing the functions. A lot fo the functions have dependencies on other functions withing tiger schema. If you download the latest PostGIS 2.0 tar ball, that might be the easiest way to get started. http://www.postgis.org/download/postgis-2.0.0SVN.tar.gz There is a create_geocode.sh/bat scripts that install all the functions in the extras\tiger_geocoder\tiger_2010 folder and a README which I think is more or less up to date detailing installation etc. Leo http://www.postgis.us -- END Email -----Original Message----- From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Dan Putler Sent: Tuesday, October 18, 2011 12:55 PM To: PostGIS Users Discussion Subject: Re: [postgis-users] Tiger Line 2010 - Edges Hi Rene, The edges also include TFIDL and TFIDR fields. These are the foreign keys that identify the topological faces on the left- and right-side of an edge. If you combine this with the attribute data of the TIGER FACE layers (the topological faces), you can then determine the "place" (city, town, or Census Designated place) FIPS code associated with the topological face that is bounded by a road edge. To get the name of the "place", you then need to use the TIGER PLACE layers. However, many road segments don't have road segments that fall into a "PLACE", so you need to devise another strategy to deal with them. All in all, working with TIGER data is not straight forward. Dan On 10/18/2011 09:24 AM, René Fournier wrote: > Having imported the Edges shape files, I'm able to get quickly find the closest street to a given latlng point (reverse-geocode). From this row, I get the street name and house number ranges, and state (FIPS code) -- but not the city name. Any suggestions on the best way to find the town/city? > > Rene > > > > _______________________________________________ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
