Edmonds WA Import

From OpenStreetMap Wiki
Jump to navigation Jump to search

Complete

This import was for adding buildings and addresses in Edmonds, WA. The import completed Feb. 9, 2020.

About

This page is intended to document plans for an upcoming import of data from the city of Edmonds. The data is provided by Snohomish County and is in the public domain.

The intent is to begin this effort in earnest in late 2019.

Goals

The goal of this effort is to improve the quality and detail of addresses and buildings in Edmonds, WA. Additional the City of Edmonds plans to use OSM basemaps in some of their apps.

Schedule

  • Community Interest: Invite local community members to be involved with the import
  • Import: Import Edmonds, WA buildings outlines and address points with new and existing local community members
  • QA: post-import

Import Data

Data Files

Edmonds provided its information as shapefile in Washington State Plane North. The data is considered to be in the public domain according to Washington State RCWs. additional the City of Edmonds has no restrictions on its use in OSM.

Import Type

This is an OSM Washington community-based, one-time import.

There are currently no plans to script or automate this import.

Data Preparation

Tagging Plans

No source tags will be added.

Changeset Tags

Need to learn more about how to use these in order to make sure we set things up properly.

Tag in import-related changesets: import=Edmonds, WA GIS

Data Transformation

The source files will need to be converted to OSM XML. Code is available on Edmonds Scripts and Data

The Counties address database includes the building type. The following county building types will be converted to appropriate OSM tags.

Data Transformation Results

Output OSM XML files can be reviewed here:

Edmonds Scripts and Data

Converting building usecodes to OSM Tags
Usecode OSM Tag
112 2 Single Family Residences house
113 3 Single Family Residences house
114 4 Single Family Residences house
115 5+ Single Family Residences house
116 Common Wall Single Family Residence house
117 Manufactured Home (Leased Site) manufactured
118 Manufactured Home (Owned Site) manufactured
119 Manufactured Home (Mobile Home Park) static_caravan
121 Two Family Residence convrtd from SFR (Duplex) house
122 Two Family Residence (Duplex) house
123 Three Family Residence (Tri-Plex) house
124 Four Family Residence (Four Plex) house
130 Multiple Family 5 - 7 Units apartments
131 Multiple Family 8 - 11 Units apartments
132 Multiple Family 12 - 15 Units apartments
132 Multiple Family 16 - 20 Units apartments
134 Multiple Family 21 - 30 Units apartments
135 Multiple Family 31 - 50 Units apartments
136 Multiple Family 51 - 100 Units apartmentsis
137 Multiple Family 101 - 200 Units apartments
138 Multiple Family 201 - 300 Units apartments
141 Single Family Residence Condominium Detached apartments
143 Single Family Residence Condominium Multiple apartments
144 Single Family Residence Condominium Project apartments
145 Condominium Conversion apartments
161 Hotel / Motel 26 - 50 Units motel
162 Hotel / Motel 51 - 75 Units motel
163 Hotel / Motel 76 - 100 Units hotel
173 Dormitory dormitory
174 Retirement Home / Orphanages yes
183 Non Residential Structure yes
188 SFR Converted to Group Home yes
223 Dying & Finishing Of Textiles manufacturing
243 Millwork, Veneer, Plywood & Prefab Struc. Wood manufacturing
278 Printing Trade Service Industries manufacturing
343 Electrical Machinery, Equipment & Supplies commercial
399 Other Miscellaneous Manufacturing NEC manufacturing
411 One-family Dwelling: year round use house
411 Railroad Transportation yes
461 Automobile Parking (Lot) yes
471 Telephone Communication commercial
481 Electric Utility commercial
483 Water Utilities & Irrigation & Storage yes
484 Sewage Disposal yes
506 Coml Condo - Services yes
518 Machinery, Equipment & Supplies commercial
521 Lumber & Other Building Materials retail
523 Paint, Glass & Wallpaper retail
531 Department Stores retail
539 Other Retail Trade NEC retail
541 Groceries (With or Without Meat) retail
549 Other Retail Trade - Food NEC retail
551 Motor Vehicles yes
553 Gasoline Service Stations retail
559 Other Retail Trade-Auto, Marine, Aircraft NEC retail
569 Other Retail Trade - Apparel & Accessories NEC retail
571 Furniture, Home Furnishings & Equipment retail
573 Radios, Televisions & Music Supplies retail
581 Eating Places (Restaurants) retail
582 Drinking Places (Alcoholic Beverages) retail
591 Drug & Proprietary retail
599 Other Retail Trade NEC retail
611 Banking & Bank Related Functions bank
614 Insurance Carriers, Agents, Brokers, Services retail
615 Real Estate & Related Services retail
619 Other Finance Insurance & Real Estate Services commercial
623 Beauty & Barber Services retail
624 Funeral & Crematory Services (Inc. Cemeteries) retail
629 Other Personal Services NEC retail
637 Warehousing & Storage Services warehouse
638 Mini-Warehouse warehouse
639 Other Business Services NEC commercial
641 Automobile Repair & Services retail
651 Medical & Other Health Services commercial
652 Legal Services commercial
659 Other Professional Services NEC commercial
661 General Contract Construction Services commercial
662 Special Construction Trade Services commercial
672 Protective Functions & Related Activities commercial
673 Postal Services yes
681 Nursery, Primary & Secondary School school
682 University, College, Junior College, Etc. school
691 Religious Activities (Churches Synagogues Etc. yes
699 Other Miscellaneous Services NEC yes
711 Cultural Activities (Inc. Libraries) yes
719 Other Cultural Activities & Nature Exhibitions yes
721 Entertainment Assembly (Inc. Theaters) retail
723 Public Assembly public
729 Other Public Assembly, NEC public
739 Other Amusements, NEC yes
741 Sports Activities Inc. Golf Tennis Ice Etc. yes
742 Playgrounds & Athletic Areas yes
744 Marinas yes
761 Parks - General Recreation yes
822 Animal Husbandry & Veterinary Services retail
WAREHOUSE warehouse

Data Merge Workflow

Existing will be first inspected to determine which is the best data to keep then either the old object will be merged with the newer object or if the older outline is better than the new outline, the old outline will be kept and tags updated with any missing address and building information.

Team Approach

The work for this effort will be divided up into sections, with each section constituting a voting district. Voting district data have been loaded into US Tasking Manager.

References

Using the JSOM, each volunteer will begin to work through the data for that district.

  • Local knowledge
  • Bing aerial layer
  • Existing OSM data
  • Address data import

Workflow

  • Click on the task tab above and claim a task on the map to the right by clicking on an area you'd like to work in
  • Click the "JOSM" button, this will open the area in JOSM and load up existing OSM data
  • Click the ".osm" button, this will open new address data in a separate layer
  • Select the new addresses layer and validate the layer, fix all issues (more in Tips & Tricks below)
  • Copy all geometry from addresses layer and paste it into the existing OSM data layer.
  • Run validation on the existing OSM data layer that now contains new data, resolve all issues emanating from collisions between existing and new data (see merge rules).
  • Do a sanity check on data: Do addresses correspond to adjacent roads? (more on imagery below)
  • Merge with existing address data. Use the JOSM "m" key to merge nodes. Check for addresses in POI and merge to new address data.
  • To merge with a building outline, use the Replace Geometry (Ctrl+Sift+G) by selection the existing building outline and the new address node. Note: Only merge building outline with an address node if the building outline contains just one address node.
  • Upload data to OSM
  • Go back to the Tasking Manager and mark the task as done (but not as validated)

Importer Quality Checks

The accepting tasks from the Tasking Manager should fix the following issues when importing addresses to help insure a high quality import:

  • Street addresses match nearby street name. If the addr:street does not match the street, verify the OSM tag against the latest TIGER road overlay. If there is no match the district should be skipped. Notify Clifford Snow of discrepancy. Additionally, add a note asking for a verification of street names.
  • Look for duplicate addresses. Check POI for address tags. Often POI's are added with incomplete addresses. Merge the imported address with the POI.
  • If a single address is inside of a building outline, merge the two. Leave multiple addresses inside building outlines as individual nodes.
  • Attempt to clean up misaligned roads by using the Bing background image as well as the "New & Misaligned TIGER Roads (TIGER 2013)"

Conflation Tools

Since the JOSM Conflation plugin is still broken, users will manually conflate address points

Known Dataset Conflation Issues

Local knowledge Issue: this is a great opportunity to infuse a lot of richness into Edmonds OSM data.

Approach: volunteers will be asked to add information they know along the way. For example: if you know the corner address for a building is a coffeeshop, add that information while you're buzzing about in the import.

Dedicated Import Account

Users will be expected to obtain an unique import account, for example, user FooBar might pick FooBar_Import.

QA

Validation

  • Pre-import training
  • Use of validation tools in the Tasking Manager process
  • Group activities and IRC for question answering during the import.