Import/Catalogue/AU NSW TfNSW Railway Level Crossings

From OpenStreetMap Wiki
Jump to navigation Jump to search

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

https://mpr.lt/c/49134

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

See Maproulette challenge.

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