[Imports] Queens, NYC addresses (was: United States Poultry Import)

[Kevin Kenny]

On Tue, Apr 19, 2022 at 4:48 PM Jmapb <jmapb at gmx.com> wrote:

> On 4/19/2022 3:07 PM, Imre Samu wrote:
>
> for me, ( living in Europe )   this NY city name is strange
> *addr:city=Astoria*
> (  based on:  https://en.wikipedia.org/wiki/Astoria,_Queens
>    "Astoria is a neighborhood in the western portion of the New York City
> borough of Queens."  )
>
> on the other hand
> -  I have found a lot of other similar POI -s (
> https://overpass-turbo.eu/s/1hNB “'addr:city'=Astoria in "New york"”  )
> -  but I have found  :   addr:city ="Queens" or addr:city ="New York"
> values
>
> Strange :-)
>
> New York mapper here. In the borough of Queens, it's normal to use
> neighborhood names as city names in addresses.
>
> Most other NYC boroughs use the borough name as the city name in
> addresses. A value of "New York" for addr:city is only valid for addresses
> in the borough of Manhattan.
>
> Yes, it's a mess! NYC had a full address import in 2013-2014 (see
> https://wiki.openstreetmap.org/wiki/Import/Catalogue/NYC_Buildings_Addresses
> ) which omitted the addr:city tag -- presumably because no appropriate
> value was available in the city's address dataset. But of course mappers
> often add addr:city, and often incorrectly.
>
> For Queens addresses, I don't know of any authoritative way to determine
> the best value for the addr:city tag, other than local knowledge of
> neighborhood boundaries. (It's possible to use the United States Postal
> Service website, but unfortunately this is *not* open data.)
>

The NYS E911 address point data has a 'zipcity' column that's supposed to
contain the 'postal city'.  I recently redid about 130,000 buildings in NY
State to use it, because `addr:city` was giving unacceptable values
relative to the ZIP code - usually because it was an enclosing village
rather than the serving post office. There were a bunch of other address
defects, like dropping the street name prefix and suffix, giving 'Church'
in place of 'West Church Street', or whatever.

The only ones that I hit were the ones that `miluethi` and his horde of
sock puppets imported.  If there are systemic problems with NYC address
points, we could consider designing another mechanical edit to address them.
-- 
73 de ke9tv/2, Kevin
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/imports/attachments/20220420/9fd33fc1/attachment.htm>