<div dir="ltr">Clark,<div><br></div><div>You can definitely use this data for automated importing (provided this list approves). In fact, because I love data and bike parking, I have converted your spreadsheet into a .OSM file for easy JOSM importing. Here's what I did:</div><div><br></div><div>1. Split the coordinates column in Excel into two columns, lat and long</div><div>2. Fixed the columns names and contents to be compatible with OSM structures (e.g. you put the key in the first row (heading) and the values in the subsequent rows)</div><div>3. Export to CSV</div><div>4. Use ogr2ogr to convert the CSV to SHP. See - <a href="http://gis.stackexchange.com/questions/327/how-can-i-convert-an-excel-file-with-x-y-columns-to-a-shapefile">http://gis.stackexchange.com/questions/327/how-can-i-convert-an-excel-file-with-x-y-columns-to-a-shapefile</a></div><div>5. Use ogr2osm to convert the SHP to OSM</div><div>6. Verify the tagging in JOSM - fix shapefile field name truncation</div><div>7. Validate</div><div>8. Save</div><div>9. Write this email</div><div><br></div><div>This data will look great on the map! I took a screenshot of how it fits spatially over OSM (via ArcMap) which is attached. Pardon the lame symbology.</div><div><br></div><div>Attached is the OSM file, and all the intermediary files I created.</div></div><div class="gmail_extra"><br><div class="gmail_quote">On Wed, Sep 24, 2014 at 12:18 PM, Clark Trivers <span dir="ltr"><<a href="mailto:Clark@oced.ca" target="_blank">Clark@oced.ca</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr" style="font-size:10pt;color:#333333;background-color:#ffffff;font-family:Calibri,Arial,Helvetica,sans-serif">
<p>Hey Elliott,<br>
</p>
<p><br>
</p>
<p>Thanks for that tip!<br>
</p>
<p><br>
</p>
<p>I made some changes. Do you think this spreadsheet could just be uploaded all at once? Would each row need to be put in as a node manually regardless of spreadsheet formatting?<br>
</p>
<p><br>
</p>
<p>I'm looking for a quick way of getting all these points on a map without having to go through all the rows one-by-one.<br>
</p>
<p><br>
</p>
<p>Thanks again,<br>
</p>
<p><br>
</p>
<p>Clark<br>
</p>
<div style="color:rgb(33,33,33)">
<hr style="display:inline-block;width:98%">
<div dir="ltr"><font face="Calibri, sans-serif" color="#000000" style="font-size:11pt"><b>From:</b> Elliott Plack <<a href="mailto:elliott.plack@gmail.com" target="_blank">elliott.plack@gmail.com</a>><br>
<b>Sent:</b> Sunday, September 21, 2014 10:59 AM<br>
<b>To:</b> Clark Trivers<br>
<b>Cc:</b> <a href="mailto:imports@openstreetmap.org" target="_blank">imports@openstreetmap.org</a><br>
<b>Subject:</b> [Imports] Ottawa Bike Parking Import</font>
<div> </div>
</div><div><div class="h5">
<div>Clark,
<div><br>
</div>
<div>This looks cool. One important step is to translate the types of bike parking in the document to the types that OSM uses. Here is a wiki page with pictures of each type. For instance, loop and post is probably "stands". <a href="http://wiki.openstreetmap.org/wiki/Key:bicycle_parking" target="_blank">http://wiki.openstreetmap.org/wiki/Key:bicycle_parking</a></div>
<div><br>
</div>
<div>Maybe add a column for that or write us a data dictionary for each of the Ottawa types.</div>
<div><br>
</div>
<div>Thanks,</div>
<div><br>
</div>
<div>Elliott<br>
<br>
On Tuesday, September 16, 2014, Clark Trivers <<a>Clark@oced.ca</a>> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr" style="font-size:10pt;color:#333333;background-color:#ffffff;font-family:Calibri,Arial,Helvetica,sans-serif">
<div style="font-family:Helvetica,sans-serif;font-size:13.3333339691162px;margin-top:0px;margin-bottom:0px">
Hi there,<br>
</div>
<div style="font-family:Helvetica,sans-serif;font-size:13.3333339691162px;margin-top:0px;margin-bottom:0px">
<br>
</div>
<div style="font-family:Helvetica,sans-serif;font-size:13.3333339691162px;margin-top:0px;margin-bottom:0px">
I work for the Ottawa Centre EcoDistrict and we recently did an assessment of all bike parking in downtown Ottawa. I was hoping to upload our data, share it with our partners, and invite the community to update as needed. I have attached our data in excel. <br>
</div>
<div style="font-family:Helvetica,sans-serif;font-size:13.3333339691162px;margin-top:0px;margin-bottom:0px">
<br>
</div>
<div style="font-family:Helvetica,sans-serif;font-size:13.3333339691162px;margin-top:0px;margin-bottom:0px">
I'm hoping you could give me some pointers on how best to share our findings in a way that allows anyone to keep the information up to date. <br>
</div>
<div style="font-family:Helvetica,sans-serif;font-size:13.3333339691162px;margin-top:0px;margin-bottom:0px">
<br>
</div>
<div style="font-family:Helvetica,sans-serif;font-size:13.3333339691162px;margin-top:0px;margin-bottom:0px">
Thanks,<br>
</div>
<p><br>
</p>
<p><br>
</p>
<div>
<div name="divtagdefaultwrapper">
<div><font face="Tahoma, Geneva, sans-serif"><b style="font-size:small">Clark Trivers
</b><font color="#888888" style="font-size:small">|</font><span style="color:rgb(136,136,136);font-size:small"> <i>Program Coordinator</i></span></font></div>
<div><font color="#808080" face="Tahoma, Geneva, sans-serif">Ottawa Centre EcoDistrict</font></div>
<div><font face="Tahoma, Geneva, sans-serif"><font color="#808080">p. <span style="background-color:rgb(255,255,255)"><a href="tel:613-256-6262" value="+16132566262" target="_blank">613-256-6262</a> x</span>3 | c.</font><span style="color:rgb(128,128,128);font-size:small"> <a href="tel:613-292-9130" value="+16132929130" target="_blank">613-292-9130</a></span></font></div>
<div><font color="#808080" face="Tahoma, Geneva, sans-serif"><a href="http://www.ottawaecodistrict.org/" target="_blank">www.ottawaecodistrict.org</a> | <a href="http://twitter.com/ott_ecodistrict" target="_blank">@ott_ecodistrict</a></font></div>
</div>
</div>
</div>
</blockquote>
</div>
<br>
<br>
-- <br>
Sent from iPhone; kindly excuse tyops.<br>
</div>
</div></div></div>
</div>
</blockquote></div><br><br clear="all"><div><br></div>-- <br><div dir="ltr">Elliott Plack</div><div dir="ltr"><a href="http://about.me/elliottp" target="_blank">http://about.me/elliottp</a></div>
</div>