[postgis-users] Cities returning as number values.

Stephen Woodbridge woodbri at swoodbridge.com
Mon Jan 12 12:45:12 PST 2015


On 1/12/2015 2:16 PM, Barry McCall wrote:
> Hello everyone!
>
> When reverse geocoding the points below the address returned is "1143
> Rafter Rd, 3, TN 37385"
>
> SELECT pprint_addy(r.addy[1]) FROM
> reverse_geocode(ST_GeomFromText('POINT(-84.2303009033
> 35.3702011108)',4269),true) As r;
>
>
> Is this bad census data, an anomaly, or postGIS issue? Or possibly user
> error on my part?


Hi Barry,

My reverse geocoder (not the postgis version) using Tiger 2014 data reports:

        lon = -84.23022580144594
        lat = 35.369982395410545
    address = 1152 Rafter Rd
    village = TELLICO PLAINS
       city = 3
     county = Monroe
      state = TN
    country = US
   postcode = 37385
   distance = 22.583276897
     linkid = 85310215

City is determined based on the county subdivision name and in some 
states this is just a number. I get the village name by looking up the 
zipcode  and getting its name.

This is just the Census data doing its funky thing.

-Steve



More information about the postgis-users mailing list