Import/Eugene GIS fire hydrants

From OpenStreetMap Wiki
Jump to navigation Jump to search

The Eugene GIS fire hydrants import is a proposed import of the Eugene, Oregon GIS department's dataset covering all publicly-owned fire hydrants. The import is currently (as of (2024-12-24)) at the planning stage.

Goals

Import all fire hydrants available from the data available through their portal.

Schedule

Not done.

Import Data

Background

Provide links to your sources.

Data source site: https://mapping.eugene-or.gov/datasets/fee0d3258bfc4a959c0be84c0ff08a6d_0/explore
Data license: Public domain (see permission)
Type of license (if applicable): Public domain (see permission)
Link to permission (if required): See EugGIS data permission
OSM attribution (if required): Not done
ODbL Compliance verified: yes

OSM Data Files

Not done.

Import Type

This is a one-time import, since new fire hydrants are not frequently installed or removed. Said installations or removals can be done manually.

Data Preparation

Data Reduction & Simplification

Query for all fire hydrants inside of city bounds, obtaining their ref=* and alt_ref=* values.

Tagging Plans

The dataset has a handful of values.

elog_id

If this is equal to 0, ignore it.

Set the value ref=* if it is the same as eweb_id; otherwise, set the value to ref:US-OR:elog=*.

eweb_id

If this is equal to 0, ignore it.

Set the value ref=* if it is the same as elog_id; otherwise, set the value to ref:US-OR:eweb=*.

owner

Set the operator=* and operator:wikidata=* tags. Only set the operator:type=* tag if the former two tags are unset. Consult the table below for specifics.

EugGIS value Number of values present operator=* value operator:wikidata=* value operator:short=* value operator:type=* value (for unspecific values like "Private"; leave this blank otherwise) Extra notes
Eugene 4013 City of Eugene Q171224 Eugene
Springfield 1595 City of Springfield Q40268 Springfield
Eweb 153 Eugene Water & Electric Board
 Q5407841 EWEB
Santa Clara WD 167 Santa Clara Water District Q127607191 SCWD
Santa Clara Water District 1 Santa Clara Water District Q127607191 SCWD
River Road WD 155 River Road Water District Q131556861 RRWD
4J 1 Eugene School District Q5407736
Goshen 1 Goshen Q3478133
SUB 1 Springfield Utility Board Q114835124 SUB
UO 39 University of Oregon Q766145
SPRR 10 Union Pacific Railroad Q725793 Refers to Southern Pacific Railroad; these hydrants now belong to UP.
Private 482 - - private
Unincorporated 56 public
Unknown 15 - - -
(empty/null) 63 - - -

RuleID_1 and Override_1

Ignored; this appears to be an internal value for the GIS system.

Changeset Tags

Fill in the values your changesets will use.

Key Value
comment Import of fire hydrants in the Eugene area, from Eugene GIS
import yes
source EugGIS - Eugene Fire Hydrants
source:url https://mapping.eugene-or.gov/datasets/fee0d3258bfc4a959c0be84c0ff08a6d_0/explore
source:date 2024-12-18
import:page https://wiki.openstreetmap.org/wiki/Import/Eugene_GIS_fire_hydrants
source:license CC-PDDC

Data Transformation

A GeoJSON export will be made. Using this script, the transformations listed above in #Data Reduction & Simplification will be made.

Data Transformation Results

OSM XML files will be generated by JOSM.

Data Merge Workflow

The JOSM Conflation plugin will be used on the resulting data to conflate it with the existing OSM data.

Team Approach

This could be done solo, but I am very open to collaboration with others that have more experience with imports.

References

List all factors that will be evaluated in the import.

Workflow

Export data from mapping hub

Download the GeoJSON export from the mapping hub.

Run the processing script

  • Move the export to input.geojson in a new directory
  • Download the script and move it to process.py

Get all hydrants in the area

  • Launch JOSM
  • Enable RemoteControl in JOSM
  • Using this Overpass Turbo query with the provided bounding box, run the query, press Export, then press "JOSM" in the "load data into an OSM editor" section.

Conflate the dataset with OSM data

Export the change with JOSM

  • Use one changeset for the entire dataset, since it's "small" and covers the entire town (we could split it by ward, but that could take a while).
  • Export OSC from JOSM and post on this page

Upload the change

  • Open the OSC and upload it using JOSM

Revert (if something goes wrong)

  • Use revert.monicz.dev to revert the import if it is botched in some way (OSC will be generated and posted here immediately after the import)

QA

Query for fire hydrants within 20 meters of each other, potentially indicating a conflation error.

See also

Not done: Forum post.

The post to the community forum was sent on YYYY-MM-DD and can be found here

Retrieved from "https://wiki.openstreetmap.org/w/index.php?title=Import/Eugene_GIS_fire_hydrants&oldid=2794703"