<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:"Avenir Next";
panose-1:0 0 0 0 0 0 0 0 0 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0in;
margin-right:0in;
margin-bottom:0in;
margin-left:.5in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;
font-family:"Calibri",sans-serif;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:1315598325;
mso-list-type:hybrid;
mso-list-template-ids:-1006049786 -619276862 67698713 67698715 67698703 67698713 67698715 67698703 67698713 67698715;}
@list l0:level1
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level2
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level3
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l0:level4
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level5
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level6
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l0:level7
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level8
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level9
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l1
{mso-list-id:1321889883;
mso-list-type:hybrid;
mso-list-template-ids:599538578 67698689 67698691 67698693 67698689 67698691 67698693 67698689 67698691 67698693;}
@list l1:level1
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Symbol;}
@list l1:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:"Courier New";}
@list l1:level3
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Wingdings;}
@list l1:level4
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Symbol;}
@list l1:level5
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:"Courier New";}
@list l1:level6
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Wingdings;}
@list l1:level7
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Symbol;}
@list l1:level8
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:"Courier New";}
@list l1:level9
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Wingdings;}
@list l2
{mso-list-id:1368020503;
mso-list-type:hybrid;
mso-list-template-ids:-872360110 67698689 67698691 67698693 67698689 67698691 67698693 67698689 67698691 67698693;}
@list l2:level1
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Symbol;}
@list l2:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:"Courier New";}
@list l2:level3
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Wingdings;}
@list l2:level4
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Symbol;}
@list l2:level5
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:"Courier New";}
@list l2:level6
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Wingdings;}
@list l2:level7
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Symbol;}
@list l2:level8
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:"Courier New";}
@list l2:level9
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Wingdings;}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal">Thanks Mike, Greg, and Clifford. I’m working my way through all of the information in Greg’s email, but I can attempt to start to address the licensing question and a couple of others. I am indeed new to OSM (except for a HOT mapathon several
years ago), so I greatly appreciate the generous information and guidance.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">The motive for this task is a practical one: Castle Pines is expected to more than double in population over the next several years, and we wish to establish processes to keep addresses up to date for the benefit of our residents (ensuring
package delivery, navigation in consumer GIS apps, etc.). Once we get addresses sorted, we wish to evaluate the appropriateness and feasibility of updating other OSM features in Castle Pines, including parks, land use/land cover, and other features.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">In my estimation, using address points straight from Douglas County will probably be the best path. Their data is marked with a Creative Commons/CC-BY-SA 4.0 license, but it sounds like it’s preferable or necessary to get explicit permission
from the county, which I can start on. (Regarding Mike’s comment on disclaimer vs. license on the city’s open data site, he is correct - that’s a quirk of ArcGIS Open Data; it feeds the hosted item’s “Terms of Use” to the license field. I’m no legal expert
either, but I don’t think ‘terms of use’ == ‘license’.)<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Regarding the boundary: If acceptable, we can also take this directly from the county (layer:
<a href="https://gis-dougco.opendata.arcgis.com/datasets/municipality/explore?location=39.458592%2C-104.866197%2C13.30">
municipality</a>), so there’s no need to dissolve parcels. To Greg’s comments: The half that is present is correct, but nothing west of I-25 shows as part of the Castle Pines administrative boundary. I don’t yet know enough about OSM to say whether there may
be a difference between what’s rendered vs the database, but it certainly appears that half is missing. So I don’t wish to correct any existing geometry, or posit the accuracy of any dataset’s features over any other, simply to get the western half of the
city’s boundary added.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Further to the above, and perhaps because of the above, all of the addresses I’ve spot-checked so far west of I-25 show as being in unincorporated Douglas County. So once a conflation process is sorted, I’ll also want to add the correct
town name to the many address points that do exist yet lack the correct town designation.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Lastly, to the question of conflation: It seems to me that scripting a comparison of addresses proposed to be imported against the existing database would not be an extraordinarily heavy lift. We’re fortunate that our street names are relatively
unique (no 1<sup>st</sup>, Main, Lincoln, etc.), so I’m hopeful that I won’t find many matches outside the immediate area.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thanks again for the insight and guidance. To my understanding, the next steps are:<br>
<br>
<o:p></o:p></p>
<ol style="margin-top:0in" start="1" type="1">
<li class="MsoListParagraph" style="margin-left:0in;mso-list:l0 level1 lfo3">Get explicit written permission from Douglas County. If the Creative Commons license is sufficient, I’ll skip this, but I certainly don’t mind reaching out to the county if necessary
or preferable.<o:p></o:p></li><li class="MsoListParagraph" style="margin-left:0in;mso-list:l0 level1 lfo3">Reach out to local mappers for input<o:p></o:p></li><li class="MsoListParagraph" style="margin-left:0in;mso-list:l0 level1 lfo3">Familiarize myself with OSM tools and retrieve an OSM address list for comparison<o:p></o:p></li><li class="MsoListParagraph" style="margin-left:0in;mso-list:l0 level1 lfo3">Document a conflation process and write a script to compare county addresses to the existing OSM list, then manually review matches outside the immediate area, if any<o:p></o:p></li></ol>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Let me know if I’m missing or misunderstanding anything. City of Castle Pines is a member of DRCOG, so let me know how that might impact the process.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thanks again,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Joe Rhodes<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>From:</b> Mike Thompson <miketho16@gmail.com> <br>
<b>Sent:</b> Wednesday, August 3, 2022 6:05 PM<br>
<b>To:</b> Greg Troxel <gdt@lexort.com><br>
<b>Cc:</b> Joe Rhodes <joe.rhodes@castlepinesco.gov>; imports@openstreetmap.org<br>
<b>Subject:</b> Re: [Imports] Address import from city government source<o:p></o:p></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<p class="MsoNormal">Hello again Joe,<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">I went to your city's website and found the address data I believe you are interested in having in OSM[0]. Probably the first thing is to get a clear official statement as to the license, Currently the data has this "license":<o:p></o:p></p>
</div>
<div>
<div>
<p class="MsoNormal" style="background:#F3F3EE"><span style="font-size:10.5pt;font-family:"Avenir Next",serif;color:#333333">GIS information is not adequate for legal boundary definition. The information depicted on GIS maps is for general planning purposes
only and should not be used for legal boundary definition, regulatory interpretation, or property conveyance purposes.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:#F3F3EE"><span style="font-size:10.5pt;font-family:"Avenir Next",serif;color:#333333"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal" style="background:#F3F3EE"><span style="font-size:10.5pt;font-family:"Avenir Next",serif;color:#333333">Data and information is provided by the GIS system with the understanding that it is not guaranteed to be correct or complete. All data
is subject to change with periodic updates. The City of Castle Pines makes no claims, representations or warranties, express or implied, concerning the validity, reliability or the accuracy of the GIS data and GIS data products furnished by the City, specifically
including the implied or expressed validity of any uses of such data.<o:p></o:p></span></p>
</div>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">I am not a legal expert, but this seems to be more of a disclaimer rather than a license. This page on the OSM wiki shows which common licenses are compatible with ODBL[1]. Also, it seems the data was taken from Douglas County, and if
they are the true data owner, then we probably should engage them in this discussion. Alternatively, a letter signed by an authorized person in the city (or county if they are the data owner) explicitly giving permission for the data to be imported into
OSM could work. Suggested templates are here[2]. Is your city a member of DRCOG? DRCOG has worked with OSM before.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">I was unable to find a dataset on your website for your city's boundary, although I could probably just dissolve all of the parcel data. Once that data is available with an appropriate license making the necessary boundary edits in OSM
should be relatively easy. OSM uses "relations" for boundaries such that the boundary between two cities (e.g.) is only represented once. This prevents any "no man's land" in the data, but it is a concept that may be foreign to someone coming from a GIS/OGC
simple features background.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Mike<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">[0] <a href="https://cp-public-info-castlepines.hub.arcgis.com/datasets/castlepines::address-points-with-use-code/explore?location=39.471247%2C-104.883243%2C14.89">https://cp-public-info-castlepines.hub.arcgis.com/datasets/castlepines::address-points-with-use-code/explore?location=39.471247%2C-104.883243%2C14.89</a><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">[1] <a href="https://wiki.openstreetmap.org/wiki/Import/ODbL_Compatibility">https://wiki.openstreetmap.org/wiki/Import/ODbL_Compatibility</a><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">[2] <a href="https://wiki.openstreetmap.org/wiki/Import/Getting_permission">https://wiki.openstreetmap.org/wiki/Import/Getting_permission</a><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<p class="MsoNormal">On Tue, Aug 2, 2022 at 5:14 PM Mike Thompson <<a href="mailto:miketho16@gmail.com">miketho16@gmail.com</a>> wrote:<o:p></o:p></p>
</div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0in;margin-bottom:5.0pt">
<div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<p class="MsoNormal">On Tue, Aug 2, 2022 at 5:02 PM Greg Troxel <<a href="mailto:gdt@lexort.com" target="_blank">gdt@lexort.com</a>> wrote:<o:p></o:p></p>
</div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0in;margin-bottom:5.0pt">
<p class="MsoNormal"><br>
Joe Rhodes <<a href="mailto:joe.rhodes@castlepinesco.gov" target="_blank">joe.rhodes@castlepinesco.gov</a>> writes:<br>
<br>
> I'm the GIS manager for the newest municipality in the State of<br>
> Colorado, City of Castle Pines. <br>
<br>
Welcome to OSM.<o:p></o:p></p>
</blockquote>
<div>
<p class="MsoNormal">Yes, welcome to OSM!<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">I am in Colorado and an experienced mapper. I can help, but you will need to deal with the license issue, and some of the other things Greg mentions (good advice from Greg all around, which I second).<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Mike <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0in;margin-bottom:5.0pt">
<p class="MsoNormal"><br>
I don't know if you have experience editing OSM (not doing an import,<br>
just normal mapper activity). Generally, I and I think most others see<br>
that as a prereq.<br>
<br>
Have you read:<br>
<br>
<a href="https://wiki.openstreetmap.org/wiki/Import/Guidelines" target="_blank">
https://wiki.openstreetmap.org/wiki/Import/Guidelines</a><br>
<br>
You'll have to prepare documentation. One of the harder parts will be<br>
conflation with existing data.<br>
<br>
The easy part, to get one of the showstoppers out of the way:<br>
<br>
Please provide a link to download the data (no login, that anybody can<br>
do).<br>
<br>
Please provide a link to a public statement of the license for the<br>
data, so that we can see if it meets the OSM requirements.<br>
<br>
Are you in touch with the mappers that have edited in your area? Have<br>
you discussed this with them? What do they think? If not, please<br>
find them.<br>
<br>
> Many addresses in our city are missing<br>
> from OSM, and the ones that are there do not show Castle Pines as the<br>
> city (they appear to just be in unincorporated Douglas County). I am<br>
> seeking approval to do an import of the full set of address points for<br>
> our city in order to correct these problems.<br>
<br>
"import the full set" and "many are missing" do not go together. You'll<br>
need a conflation process -- which I think should be one with published,<br>
open-source code, so others in the community can replicate it -- that<br>
looks at your address data and matches it with OSM data, more or less<br>
sorting it into "address match, close geographically", "address match,<br>
far off", and "address not in OSM". The middle category needs manual<br>
review (that doesn't solidly presume either db is right) and the third<br>
is what ends up proceeding in import. Then there's the question of what<br>
object it is attached too, or just a bare point with address tags.<br>
<br>
> In addition, the city boundary is incorrect in OSM. The city has a<br>
> multipart boundary (there are two non-contiguous sections on each side<br>
> of an interstate highway), and only the eastern portion shows on<br>
> OSM. Because it is non-contiguous/multipart, I am unable to edit it to<br>
> reflect the correct boundary, so I'm seeking approval to import the<br>
> correct boundary as well.<br>
<br>
I don't understand how you can't edit it. Have you asked the local<br>
mappers for help?<br>
<br>
It sounds like it should be a multipolygon. You say "shows on OSM" but<br>
we should be talking about the objects in the database, not the output<br>
of any render. Let's assume there is a single closed way which is one<br>
of the parts and it has the admin/name tags. The first thing to do is<br>
look at the history (^H in JOSM, and if you haven't learned JOSM I would<br>
recommend that before importing, because if you import anything you have<br>
bit off the repsonsibility to fix any problems) and contact the people<br>
that edited it before and talk about the situation.<br>
<br>
If what you want to do is take a polygon for the missing half -- after<br>
verifying it really is missing -- and convert that to osm and turn the<br>
existing closed way and the new one into a multipolygon, then that's not<br>
that big a deal, but given that you seem to be new I think the steps of<br>
community consultation, public data, license, transform mechanism should<br>
be written down.<br>
<br>
You didn't talk about the half that is there being wrong, so I'm<br>
assuming you don't wnat to change that. In general "my data is better,<br>
and so I want to delete and add mine" is not ok; OSM has a strong<br>
doctrine of deference to hand mapping, even if any particular thing that<br>
is actually wrong can be fixed. Sometimes OSM people have good data<br>
about boundaries and it can be better than the official data. As an<br>
example I've measured my town's boundary stones with RTK, and the<br>
official data is an 1890 survey in the New England datum reckoned<br>
forward to NAD27 and then NAD83. The amazing thing is that we agree at<br>
the 0.5m level, and I may this year get to the point where I can<br>
reasonably confidently say my values are better. But most OSM data is<br>
not like this.<br>
<br>
Finally, and this is not a big deal, but I'm guessing your data is in<br>
NAD83(2011) epoch 2010.0 and OSM is nominally in WGS84. That's fuzzy,<br>
but you should transform to the latest realization, WGS84(G2159), or<br>
something like ITRF2014 as a close proxy.<br>
<br>
Greg (osm user gdt)<br>
_______________________________________________<br>
Imports mailing list<br>
<a href="mailto:Imports@openstreetmap.org" target="_blank">Imports@openstreetmap.org</a><br>
<a href="https://lists.openstreetmap.org/listinfo/imports" target="_blank">https://lists.openstreetmap.org/listinfo/imports</a><o:p></o:p></p>
</blockquote>
</div>
</div>
</blockquote>
</div>
</div>
</div>
</body>
</html>