[postgis-users] Tiger Line 2010 - Edges

Paragon Corporation lr at pcorp.us
Tue Oct 18 10:26:58 PDT 2011


Did you see the email Leo had posted


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.


--- LEO's email ---
Actually we implemented a reverse geocoding function too for tiger 2010.
That might be more what you are looking for.
The function usage is described here:
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. 
 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.

 -- END Email

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Dan
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.


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

postgis-users mailing list
postgis-users at postgis.refractions.net

More information about the postgis-users mailing list