Stillwater, OK GIS import

From OpenStreetMap Wiki
Jump to: navigation, search


Please do not attempt to import any features without first consulting the main contacts below.

The goal of this import is to add building and associated address data from publicly available datasets in Stillwater, OK.

The Github repository for all code is here: as well as issues and project tasks.

The scripts and code for creating the data are intended to generate OSM files that will be validated and imported on a neighborhood by neighborhood bases.


Main contributors/organizers of this project:

  1. Mike : User page

How can I help?

We need technical help with validation and script updates as necessary and documentation help.

Technical help

  1. Importing. OpenStreetMap account required (Create one here)

Documentation help

  1. Help update this project page; OpenStreetMap Wiki account required (Create one here)
  2. Write docs about importing
    • Working with the building and address data
    • Setting up and using JOSM

Source data


Data is provided by Stillwater. The datasets:

  1. Building Footprints:
  2. Address points:

The Building Footprints dataset will be referred to as "bldgs". The Address Points dataset will be referred to as "addrs".


These datasets are in the Public Domain


The general process for importing data is described below.

Data processing

  1. Import building and address data into JOSM
  2. Import existing OSM buildings (building=*) into JOSM
  3. Any new building footprints which intersect existing buildings will, for now, be ignored
  4. Tags will be created for each building as below

Address Tag Mappings

Remove all tags except "STNAME" and STTYPE to help assign correct addr:street tag.

tag source
STNAME "Original dataset value"
STTYPE "Original dataset value"
addr:housenumber STNO
addr:street (expanded)STDIR + STNAME + (expanded)STTYPE
addr:unit STAPT
addr:postcode NEAR_FID
addr:city Stillwater
addr:state OK
addr:country US
addr:full STFULLNAME

Building Tag Mappings

Remove all tags.

tag source
building yes (follow table below)

source value final value
Residential detached
Garage garage
RES, Res residential
Duplex, Apartment Complex, Multiplex, Residential Condominiums apartments
Dormitories dormitory
Everything else (the vast majority) yes

The bldgs dataset contains a column representing the use of the building "USAGE". The corresponding building= tag will be set as follows (based on


Addresses are connected to a building through a Accessors id. bldgs dataset contains a PARC_ACCT field that matched the addrs dataset ACCT field. These were removed.

All address POIs will remain just a point.

Import Plan

Phase 0: Preparation

  1. User "Stillwater_OK_GIS_Import" is owned by user mhenson
  2. Contributors/importers will create separate accounts followed by their normal usernames + "_Stillwater_OK_GIS_Import" for import purposes.
  3. Buildings will be extracted into neighborhoods (of at least 10 buildings each, at most 140) and converted into .osm format, with three outputs:
    • Only those that DO NOT overlap with existing OSM data and have a single address
    • Only those that overlap with existing OSM data or have multiple addresses (to use in Phase 2)
    • All buildings

Phase 1: The easy stuff

  1. This phase will only deal with buildings that do not overlap with other features in OSM and have one (or no) address, or simple one building on one Accessors id with multiple addresses
  1. Contributors will download a section of buildings, and a section of address nodes and validate it in JOSM, verify them with local knowledge & against the most recent imagery available; likely NAIP imagery with Bing as a fall back.

Please note: satellite imagery can have significant positioning errors versus more accurate surveys.

  1. After validation, the changeset for that section will be uploaded by the contributor with a commit message that indicates it is part of this project
  2. Contributors will adhere to a strict limit of features edited per hour to be determined with consultation of the OSM Imports-us group.

Phase 2: Reconciliation with existing buildings/addresses

This phase will involve conflating data to be added to buildings that already exist in OSM and dealing with any complex addressing issues.

Change Sets

Change Sets shall include text ",_OK_GIS_import"

Maintenance Plan

Contributors to this project are (and should be) Stillwater-area community members with an interest in keeping the data up to date.