Washington DC/DCGIS imports

From OpenStreetMap Wiki
Jump to: navigation, search

The District of Columbia, through the Office of the Chief Technology Officer (OCTO), makes data available and open for use by the public at http://data.octo.dc.gov. The terms of use (and we have explicit permission [1]) are such that we can use the data in OpenStreetMap.

The data is attributed to "District of Columbia (DC GIS)" and the terms of use are as follows:

"The data made available here has been modified for use from its original source, which is the Government of the District of Columbia. Neither the District of Columbia Government nor the Office of the Chief Technology Officer (OCTO) makes any claims as to the completeness, accuracy or content of any data contained in this application; makes any representation of any kind, including, but not limited to, warranty of the accuracy or fitness for a particular use; nor are any such warranties to be implied or inferred with respect to the information or data furnished herein. The data is subject to change as modifications and updates are complete. It is understood that the information contained in the web feed is being used at one's own risk."


Due to the number of DC datasets and in order to preserve history

DC's imported data should map the following features thusly:

  • Prefix: dcgis

Generally, unless mapped otherwise, DC-GIS data tags should be prefixed with dcgis

  • Lowercase

Tags should be remapped to lowercase

  • Dataset

In order to preserve the origin of the data, the dataset should be specified. The naming of these datasets should map to the naming of the zipfile, ie PostOfficePt or ParkPly, the resulting key, value pair would be dc-gis:dataset=ParkPly

In an ideal world, a permalinked URL would also exist in order to facilitate re-evaluating the data

  • Pubdate

DC-GIS data includes a pubdate in the supplementary XML file. This should be included in the features as dcgis:pubdate and the date should be reformatted to YYYY-MM-DD

  • GIS_ID

This feature appears on DC-GIS datasets. It should be preserved as dcgis:gis_id.

  • NAME

For DC GIS datasets, this feature usually maps to the common name of the feature (name). For other datasets, NAME may be used as a unique identifier. In the case of the former, NAME should remap to "name" as per common OSM data. In the case of the later, it should map to something which makes sense for the data. For example in the case of Fire Hydrants, NAME is remapped to hydrant_id.


DC data usually includes an address (though it may not be post-office compliant). Generally this should be mapped to "addr".

  • SSL and AID

The AID and SSL attributes are used to correlate the data with the DC MAR (Master Address Record) and should generally be preserved.

DC GIS Datasets

DC changed their license to accommodate importing into OSM. Here is a list of the potentially pertinent datasets taken from the DC GIS Catalog . Feel free to sign up and to import these:

Dataset Importer Started Completed? Problems
ABRA locations Filbertkm (User:Aude) done
Buildings Filbertkm (User:Aude) in review on imports and imports-us (Aug 2013)
Bicycle Lanes NE2 all existing lanes tagged (data apparently from 07/29/2010; downloaded September 2011)
Bicycle Routes Signed NE2 all existing routes tagged (data apparently from 02/04/2008; downloaded September 2011)
Bank Locations Filbertkm (User:Aude) done
Capital Bike Share Stations User:Andino 2013-04-21 all data through 2013-03-11 added to map Converted DC GIS kmz file using regex/find+replace to OSM. The original data had bikes and docks, not capacity. Had to manually add the two numbers (via find/replace).
Cemeteries User:Emacsen done
Charter Schools
Child Care Sites
Commuter Bus Locations User:Emacsen done
Community Gardens Filbertkm (User:Aude) July 2010
DC boundary
Cultural Features
Fire Stations  ? done
Gas Stations
Golf Courses  ? done
"Good Plan?"
Green Roof Locations
Grocery stores Filbertkm (User:Aude) done
Historic Districts
Historic Structures?
Hotel Filbertkm (User:Aude) done
Land Use
Landmark Areas  ? done ?
Landmark Buildings & Structures
Libraries Kate Chapman, Serge Wroclawski 11/7/09 11/7/09 Already Existing Dups
Metro Bus Lines ?
Metro Bus Stops ?
Metro Entrance Structures
Metro Lines (Full) mutantmonkey 5/17/10 5/17/10 Duplicated some TIGER data and existing traces; whatever was of highest quality was used
Metro Stations mutantmonkey 5/17/10 5/17/10 Existing duplicates were replaced with DCGIS data
Parcel Lots? DCRA
Parks Andrew Turner 04.10.09 04.10.09
Places of Worship
Points of Interest
Police Stations MPD
Primary Care Facilities (DOH)
Public Schools (DCPS)
Recreating Parks (DPR)  ? done
School Grounds (DCPS)
Trash Cans Serge Wroclawski 11/07/09 11/07/09
University Areas (EMA) Filbertkm (User:Aude) done
Waterbodies Andrew Turner 04.10.09 04.10.09
Wetlands (USFWS)
Zoning (OZ)
Recreation Facilites