[postgis-users] Tiger Line 2010 - Edges

Dan Putler dan.putler at sauder.ubc.ca
Tue Oct 18 09:54:51 PDT 2011

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.


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 at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

More information about the postgis-users mailing list