On Tue, Aug 3, 2010 at 3:57 PM, Richard Weait <[email protected]> wrote:
> On Tue, Aug 3, 2010 at 4:05 PM, Kevin Atkinson <[email protected]> > wrote: > > I'm almost done with this script. It's not a full bot, but instead > modifies > > an osm file which I will read back into JOSM and upload the changed parts > > (or if that doesn't work use one of the upload scripts). Changes in what > It > > will do noted below. > [ ... ] > > I'm not going to do this. Instead I am going to simply remove variants > on > > "name" (for example all other names in the "900 East" example). And than > > leave all other name_* and *_name alone (i.e. name_1, alt_name, etc). > When > > the alternate name is a numbered street, it will get the ".prefix" and > > ".full" tags. For example: > > name: Lorna Circle > > name_1: 3805 South > > name_1.prefix: W > > name_1.full: West 3805 South > > Whoa. Are you considering adding a period "." to the key? Might that > mess up postgres? From > > http://www.postgresql.org/docs/8.2/static/sql-syntax-lexical.html > > "The period (.) is used in numeric constants, and to separate schema, > table, and column names. " > > Perhaps bounce some of these ideas around on dev? > > I imagine the Ruby code is doing the proper escaping for text like this, but you're right: definitely worth a message to the dev list. Not that it matters too much to the majority of the OSM community, but a period in the key name is invalid for most NoSQL-based systems (MongoDB in particular).
_______________________________________________ Talk-us mailing list [email protected] http://lists.openstreetmap.org/listinfo/talk-us
