[Imports] [Imports-us] Address Data Import for Fulton County, Georgia

Carl Anderson carl.anderson at vadose.org
Mon Jan 13 16:05:47 UTC 2014

Looking at the wiki for addresses
(http://wiki.openstreetmap.org/wiki/Address), addr:city is intended to
hold the postal community and not the legal municipal name.

911 and 311 call centers struggle with this problem all the time in
that frequently, multiple locale names are in use and valid for a
location.  The authoritativeness or correctness of a name has to be
judged in the context in which it is used.


On Mon, Jan 13, 2014 at 9:20 AM, Saikrishna Arcot <saiarcot895 at gmail.com> wrote:
> I'm using the capitalization of the street name as it is in OSM.
> Technically, shouldn't the city name in OpenStreetMap match the
> legal/geographical city and not the postal city?
> Saikrishna Arcot
> On 01/13/2014 08:47 AM, Carl Anderson wrote:
>> Saikrishna,
>> I recommend that you follow the capitalization style of the adjacent Way in OSM.
>> Blindly using init cap functions will mangle things like McGill Park
>> Ave, McFarlin Lane, .......  Which are correctly capitalized in OSM.
>> You could try to do something like
>> http://wiki.postgresql.org/wiki/Culturally_aware_initcap, but
>> following the style of existing data in OSM is better.
>> C.
>> On Sun, Jan 12, 2014 at 8:26 PM, Clifford Snow <clifford at snowandsnow.us> wrote:
>>> On Sun, Jan 12, 2014 at 12:30 PM, Saikrishna Arcot <saiarcot895 at gmail.com>
>>> wrote:
>>>> Note that some of the cities around here (for example, DeKalb County)
>>>> are mixed case. Currently, the city case is just converted to title case
>>>> (first letter capitalized, the rest lowercase). This will need to be
>>>> corrected before the import begins.
>>> If you have the data in a postgresql database, The Init_cap() function
>>> should capitalize correctly. If you do have this in a db, let me know and I
>>> might be able to help you.
>>> --
>>> Clifford
>>> OpenStreetMap: Maps with a human touch
>>> _______________________________________________
>>> Imports mailing list
>>> Imports at openstreetmap.org
>>> https://lists.openstreetmap.org/listinfo/imports

More information about the Imports mailing list