Edmonds WA Import
This import was for adding buildings and addresses in Edmonds, WA. The import completed Feb. 9, 2020.
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.
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.
- 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
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.
This is an OSM Washington community-based, one-time import.
There are currently no plans to script or automate this import.
No source tags will be added.
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
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:
|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|
|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|
|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|
|761 Parks - General Recreation||yes|
|822 Animal Husbandry & Veterinary Services||retail|
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.
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.
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
- 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)"
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.
- Pre-import training
- Use of validation tools in the Tasking Manager process
- Group activities and IRC for question answering during the import.