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

Saikrishna Arcot saiarcot895 at gmail.com
Mon Jan 13 14:20:04 UTC 2014


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