<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:st1="urn:schemas-microsoft-com:office:smarttags" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PostalCode"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="State"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="City"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="place"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="Street"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="address"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PersonName"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:Arial'>I posted
this up through Nabble, but it’s been sitting there 4 days without being
accepted so I’m trying through the list instead:<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:Arial'><o:p> </o:p></span></p>
<p class=MsoNormal>I have access to a significant amount of spatial data in sql
server 2008 spatial format for my county, covered under public domain/CC Share
Alike. <br>
It consists of about 70k addressed road centerline segments and 700,000 or so
building outlines, light rail lines and stations, police stations, fire
stations, schools, addressing points, hospitals, and care facilities. I
have direct contact with the GIS coordinator to work on any licensing issues. <br>
<br>
<o:p></o:p></p>
<p class=MsoNormal>My question though is, how do I get this data from sql
server spatial to OSM? <br>
<br>
<o:p></o:p></p>
<p class=MsoNormal>I can export out to any ArcInfo supported format (like
shapefile). I've read through working with shapefile to OSM, but could use a
little more detailed help on this perhaps. As well, once the data is in osm
format, how do I go about all the reconciles? Just the address points alone
would easily take several hundred hours to reconcile. Can I look for community
help on something like that if I make the data otherwise available?<span
style='font-size:10.0pt;font-family:Arial'><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:Arial'><o:p> </o:p></span></p>
<p class=MsoNormal><st1:PersonName w:st="on"><span style='font-size:10.0pt;
font-family:Arial'>Brett Lord-Castillo</span></st1:PersonName><br>
<span style='font-size:10.0pt;font-family:Arial'>Information Systems
Designer/GIS Programmer<br>
St. Louis County Police<br>
Office of Emergency Management<br>
14847 Ladue <st1:Street w:st="on"><st1:address w:st="on">Bluffs Crossing Drive</st1:address></st1:Street><br>
<st1:place w:st="on"><st1:City w:st="on">Chesterfield</st1:City>, <st1:State
w:st="on">MO</st1:State> <st1:PostalCode w:st="on">63017</st1:PostalCode></st1:place></span><o:p></o:p></p>
<table class=MsoNormalTable border=0 cellpadding=0 summary="Phone Numbers">
<tr>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:Arial'>Office:
314-628-5400</span><o:p></o:p></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:Arial'>Fax:
314-628-5508</span><o:p></o:p></p>
</td>
</tr>
<tr>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:Arial'>Direct:
314-628-5407</span><o:p></o:p></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><o:p> </o:p></p>
</td>
</tr>
</table>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
</div>
</body>
</html>