[postgis-users] Tiger Line 2010 - Edges
dan.putler at sauder.ubc.ca
Tue Oct 18 09:54:51 PDT 2011
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?
> postgis-users mailing list
> postgis-users at postgis.refractions.net
More information about the postgis-users