[Imports] Chatham County North Carolina USA Address Import

Tommy Bruce sunfishtommy at gmail.com
Thu Jul 5 21:51:02 UTC 2018

Hi Leif this is Sunfishtommy

If you could give a little more time between notification and import i think that would be good.  Between first notification and the import I think a minimum of 2 weeks would be healthy.  Just to give more time for people to see and comment. 

It’s ultimately up to you, but only 4-5 days is a little short.

Sent from my iPad

> On Jul 4, 2018, at 19:38, Leif Rasmussen <354lbr at gmail.com> wrote:
> I finished importing about 74000 addresses in Orange County North Carolina on Sunday.  The import went relatively smoothly, with no major screw-ups.  The only problem I ran into was an internet disconnect in the middle of the 10th upload (of 11).  Only half of all addresses in the area had been added OSM when my internet connection broke.  To fix the issue, I closed the changeset, deleted all addresses added in the changeset (not all in the entire import), and re-uploaded that section.  No damage was done to the OSM database.  Other than the internet problem, everything went perfectly!  
> I am now planning on doing another import of addresses next weekend, this time in Chatham County North Carolina.  I will follow the exact same procedure as the last import, this time ensuring that I use a different computer that will not lose connection.  I have already created a new wiki page (https://wiki.openstreetmap.org/wiki/Chatham_County,_North_Carolina_Address_Import) for the import.   
> Procedure for data transformation:  
> First, I downloaded the data in Shapefile format from Chatham County Open Data.  
> Then, I opened the data with JOSM using the opendata plugin.  
> Then, I saved the file.  
> Then, I downloaded every object with "addr:housenumber" and "addr:street" in Chatham County using the Overpass API. I saved that data as a file as well.  
> I then ran my Java address editing program plugging in the new data and existing data. The program corrected casing (CHAPEL HILL -> Chapel Hill), created addr:street ("streetDirection"="N", "streetName" = "COLUMBIA", & "streetType"="ST" -> "addr:street"="North Columbia Street"), and flagged duplicates of existing addresses by comparing the dataset to the existing addresses in the OSM database.  
> I opened the file created by the program with JOSM and did some final modifications.
> Finally, I saved the ready-for-upload files on Google drive so that anyone can view them.  
> The Java address editing program is available here (https://drive.google.com/open?id=1_zStssFKP1kbp3XydUELFkEeWF-P3t8z).  
> The transformed address data is available here (https://drive.google.com/open?id=1P7i2heSHrvddLjlVOkfQ1OsBxXl8Xjnv).  
> I would love any feedback about the import procedure, quality of data, or anything else!  
> Thank you,  
> Leif Rasmussen
> _______________________________________________
> Imports mailing list
> Imports at openstreetmap.org
> https://lists.openstreetmap.org/listinfo/imports
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/imports/attachments/20180705/3a67b773/attachment.html>

More information about the Imports mailing list