[Talk-us-massachusetts] Import of MassGIS addresses -- on converting names from UPPER to Title cases

Angela Morley amorley at protonmail.com
Sat Jul 21 02:06:59 UTC 2018


Title function in QGIS capitalizes the first letter of each word, so YMCA Street would turn into "Ymca Street", but "Oscar's Way" and "72nd Street" would be unaffected.

I think applying the title() to the data is the best way to go about this, despite having some fringe cases where things don't work exactly right. Although, I could manually review the streetnames in QGIS before importing, but I'd have no way of knowing if a street has two capitals without seeing a reference list.

I'd like to see if we can come to a community consensus about this... do we believe use of the title() function is an acceptable way, on the whole, to convert these UPPERCASE street names to something more user friendly within OSM?

‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐
On July 20, 2018 3:25 PM, Yury Yatsynovich <yury.yatsynovich at gmail.com> wrote:

> Another comment on the title() function -- if in QGIS this function works the same way as in Python, then some extra problems will be created not only for names like "McNamara Street", but also for names like "YMCA Street", "Oscar's Way" and "72nd Street"...
> Overall, I found around 800 named highways (except 'path', 'track', 'footway', 'cycleway' and 'service') in MA for which name!=name.title() (mostly, those names contain numbers or possessive adjectives, but in some cases there are errors  like "Country club road" instead of "Country Club Road"):
> https://mega.nz/#!H8l31QRb!al64XcgeYH78CchBGiT1axjs4c-ijixm2fNmA3Koa_g
>
> --
> Yury Yatsynovich
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/talk-us-massachusetts/attachments/20180720/174d1bf6/attachment.html>


More information about the Talk-us-massachusetts mailing list