<div dir="ltr">Oh, I should have dropped in a link to the scripts I used for the recent address fix: <a href="https://github.com/kennykb/NYbuildings_repair">https://github.com/kennykb/NYbuildings_repair</a> (They depend on my osm2pgsql instance for the OSM data, but that's obviously fixable.)</div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, Apr 20, 2022 at 6:51 PM Kevin Kenny <<a href="mailto:kevin.b.kenny@gmail.com">kevin.b.kenny@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div dir="ltr"><br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Tue, Apr 19, 2022 at 4:48 PM Jmapb <<a href="mailto:jmapb@gmx.com" target="_blank">jmapb@gmx.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div>
<div>On 4/19/2022 3:07 PM, Imre Samu wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">for me, ( living in Europe ) this NY city name is
strange <b>addr:city=Astoria</b><br>
<div>( based on: <a href="https://en.wikipedia.org/wiki/Astoria,_Queens" target="_blank">https://en.wikipedia.org/wiki/Astoria,_Queens</a> </div>
<div> "Astoria is a neighborhood in the western portion of the
New York City borough of Queens." )</div>
<div><br>
</div>
<div>on the other hand </div>
<div>- I have found a lot of other similar POI -s ( <a href="https://overpass-turbo.eu/s/1hNB" target="_blank">https://overpass-turbo.eu/s/1hNB</a> “'addr:city'=Astoria
in "New york"” ) </div>
<div>- but I have found : <span style="font-family:monospace;font-style:inherit;font-weight:inherit;color:rgb(74,74,74);font-size:12px">addr:city
="Queens" or addr:city ="New York"</span> values </div>
<div><br>
</div>
<div>Strange :-) </div>
<br>
</div>
</blockquote>
<p>New York mapper here. In the borough of Queens, it's normal to
use neighborhood names as city names in addresses. <br>
</p>
<p>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.</p>
<p>Yes, it's a mess! NYC had a full address import in 2013-2014 (see
<a href="https://wiki.openstreetmap.org/wiki/Import/Catalogue/NYC_Buildings_Addresses" target="_blank">https://wiki.openstreetmap.org/wiki/Import/Catalogue/NYC_Buildings_Addresses</a>
) 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. <br>
</p>
<p>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.)</p></div></blockquote><div><br></div><div>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. </div></div><div><br></div><div>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.</div>-- <br><div dir="ltr">73 de ke9tv/2, Kevin</div></div>
</blockquote></div><br clear="all"><div><br></div>-- <br><div dir="ltr" class="gmail_signature">73 de ke9tv/2, Kevin</div>