Hi all,
I am proposing to import the City of Coquitlam Street Light dataset, sourced from the City of Coquitlam’s open data portal.
Documentation
You can find my wiki page for this import here: Vancouver/Imports/Coquitlam/Street Lamps - OpenStreetMap Wiki
The dataset download is available here: Street Lights
The GeoJSON file I have prepared shows the data after it was translated to the OSM schema. You can find the latest link to this on the wiki page under “Import Data” > “OSM Data Files”
License
I have checked that this data is compatible with the ODbL, and it has been confirmed compatible by the Legal Working Group.
This data is distributed under the Open Government Licence – British Columbia.
Abstract
This dataset contains 13,837 nodes, and after conversion to the OSM schema, comes in at 6.1 MB.
The dataset was converted to the OSM schema using a Python script which can be found on the wiki page (please excuse my poor Python, it’s been a while!).
I plan to conduct this import in one go using JOSM and the conflation plugin. There is little overlap with existing data so conflation shouldn’t be too complicated, and can be verified manually during the import process.
The list of converted tags can be found on the wiki page under “Data Transformation”, in table form.
This is my first import, so any feedback is greatly appreciated!
Thanks,
Max
5 Likes
Thanks for working on this! Looks pretty good to me.
Would you consider using the light:*=* namespace? These are in use, though much less so than the older and in my opinion inferior lamp_*=*-style tags.
For example:
light_source = lantern
light:method = led / high_pressure_sodium / metal-halide
light:mount = bent_mast / straight_mast
light:support = pole
light:height = *
In terms of tagging, the operator:wikipedia=* key is redundant. name-suggestion-index used to add it pro forma but stopped a few years back. I split out a new City of Coquitlam (Q139888158) item to represent the municipal government and updated the database and name-suggestion-index to refer to it instead of Coquitlam (Q643215), which is now focused on Coquitlam the place.
2 Likes
I like the look of the light:*=* namespace, but I’m a bit worried about established conventions. An Overpass query for the older lamp_*=*returns 32,000~ results in BC, whereas light_source returns just over 100.
I do see that the trend line for light:*=* has risen substantially recently, and I’m not opposed to shifting standards, just curious your thoughts on the potential fragmentation/split.
Thank you! I appreciate you adding the new entry. I’ll update the script to use the City of Coquitlam entry, and drop the wikipedia tag.
1 Like
I thought about it more overnight and decided I do quite like the light:*=* namespace. I’ve updated the script to use these tags, and updated the links on the wiki page. I’m also going to remove the links from the main forum post so I don’t have to keep updating them in two places!
1 Like
I don’t see another realistic way to improve the state of tagging in OSM. With such an old tag (lamp_type has >15yrs of usage history), I expect there would be holdouts past the last trace of lamp_*=* being removed from all of OSM. But what’s the alternative? Decisions made 1-2 decades ago are permanent deficiencies?
To me, it’s kind of like the crossing=* vs crossing:*=* thing. The main “identifying tags” (in this case, highway=street_lamp; in that one, (highway|footway)=crossing) are preserved and so some manner of critical backwards compatibility is maintained, but the details hopefully move over time to better schemas - ideally through both new additions and removal of old tags as things get updated.
Still, I do think a valid argument against light:*=* can be made, so it may be good to wait to hear from others!
1 Like
This import has now been done in the following two changesets. Thank you for all the discussion!
2 Likes