Import/Catalogue/AU NSW TfNSW Railway Level Crossings
TfNSW Railway Level Crossings is a manual import of the NSW level crossings on public roads dataset thorough the Maproulette TfNSW Railway Level Crossings challenge. The import is currently proposed.
Import Data
Background
Data source site: https://opendata.transport.nsw.gov.au/dataset/nsw-level-crossings-on-public-roads
Data license: Creative Commons Attribution
Link to permission (if required): with CC BY waiver.
OSM attribution (if required): https://wiki.openstreetmap.org/wiki/Contributors#Transport_for_NSW
OSM Data Files
Import Type
This is a one-time import via MapRoulette.
Data Preparation
Data Reduction & Simplification
# 1. download xlsx from https://opendata.transport.nsw.gov.au/dataset/nsw-level-crossings-on-public-roads
# 2. convert to csv
build/nsw-public-road-level-crossings.csv: build/nsw-public-road-level-crossings.xlsx
xlsx2csv --sheetname 'Crossing Site' $< $@
# 3. convert to geojson
build/nsw-public-road-level-crossings.geojson: build/nsw-public-road-level-crossings.csv
csv2geojson $< > $@
# 4. fetch existing osm data via Overpass Wizard Query:
# railway=level_crossing in "NSW, AU"
# https://overpass-turbo.eu/?w=railway%3Dlevel_crossing+in+%22NSW,AU%22&R
# Export to GeoJSON
Then follow steps in Data Transformation.
Tagging Plans
Level Crossings to be tagged as railway=level_crossing
Changeset Tags
Fill in the values your changesets will use.
Key | Value |
---|---|
comment | Add railway=level_crossing per TfNSW data and available imagery. |
Data Transformation
1. Source and process data per Makefile.
2. Open both OSM and TfNSW data in JOSM.
3. Using the Conflation plugin, choose Configure
4. Select all data from `nsw-public-road-level-crossings.geojson` and Freeze as the Reference
5. Select all exported OSM data and Freeze as the Subject
6. Choose Simple matching with Disambiguating Centroid < 50
7. Untick Replace Geometry, Merge Tags and Overwrite tags without confirmation.
8. Generate Matches. To identify differences between the two datasets.
9. Reference only are those found in TfNSW data but missing in OSM.
10. Select all the reference only results and choose select selected primitives, then with the TfNSW layer active, Copy and Paste with geometry into a New Layer, then Save As TfNSWDataMissingInOSM.geojson
Data Transformation Results
Data Merge Workflow
Team Approach
Open to anyone to join via Maproulette.
References
All data to be manually mapped taking into account available imagery sources, and vintage of existing OSM data.
Workflow
Identify if there appears to be a level crossing per the available imagery, taking into account the vintage of the imagery and existing OSM data.
See also
The post to the community forum was sent on 2024-09-12 and can be found here