[postgis-users] Cities returning as number values.

[Barry McCall]

I figured as much, but wanted to check.
Thanks Steve!

-Barry

On Mon, Jan 12, 2015 at 3:45 PM, Stephen Woodbridge <woodbri at swoodbridge.com
> wrote:

> 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
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20150112/bde124c9/attachment.html>