[Imports] Ottawa Bike Parking Import

[Elliott Plack]

Clark,

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:

1. Split the coordinates column in Excel into two columns, lat and long
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)
3. Export to CSV
4. Use ogr2ogr to convert the CSV to SHP. See -
http://gis.stackexchange.com/questions/327/how-can-i-convert-an-excel-file-with-x-y-columns-to-a-shapefile
5. Use ogr2osm to convert the SHP to OSM
6. Verify the tagging in JOSM - fix shapefile field name truncation
7. Validate
8. Save
9. Write this email

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.

Attached is the OSM file, and all the intermediary files I created.

On Wed, Sep 24, 2014 at 12:18 PM, Clark Trivers <Clark at oced.ca> wrote:

>  Hey Elliott,
>
>
>  Thanks for that tip!
>
>
>  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?
>
>
>  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.
>
>
>  Thanks again,
>
>
>  Clark
>  ------------------------------
> *From:* Elliott Plack <elliott.plack at gmail.com>
> *Sent:* Sunday, September 21, 2014 10:59 AM
> *To:* Clark Trivers
> *Cc:* imports at openstreetmap.org
> *Subject:* [Imports] Ottawa Bike Parking Import
>
>  Clark,
>
>  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". http://wiki.openstreetmap.org/wiki/Key:bicycle_parking
>
>  Maybe add a column for that or write us a data dictionary for each of
> the Ottawa types.
>
>  Thanks,
>
>  Elliott
>
> On Tuesday, September 16, 2014, Clark Trivers <Clark at oced.ca> wrote:
>
>>  Hi there,
>>
>>  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.
>>
>>  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.
>>
>>  Thanks,​
>>
>>
>>
>>   *Clark Trivers *| *Program Coordinator*
>> Ottawa Centre EcoDistrict
>> p. 613-256-6262 x3 | c. 613-292-9130
>> www.ottawaecodistrict.org | @ott_ecodistrict
>> <http://twitter.com/ott_ecodistrict>
>>
>
>
> --
> Sent from iPhone; kindly excuse tyops.
>



-- 
Elliott Plack
http://about.me/elliottp
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/imports/attachments/20140924/90b8affc/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: ottawa-bike-parking.osm
Type: application/octet-stream
Size: 97505 bytes
Desc: not available
URL: <http://lists.openstreetmap.org/pipermail/imports/attachments/20140924/90b8affc/attachment-0002.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: ottawa-bike-parking.7z
Type: application/octet-stream
Size: 15373 bytes
Desc: not available
URL: <http://lists.openstreetmap.org/pipermail/imports/attachments/20140924/90b8affc/attachment-0003.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 2014-09-24 13_47_27-Cadastral.mxd - ArcMap.png
Type: image/png
Size: 1161831 bytes
Desc: not available
URL: <http://lists.openstreetmap.org/pipermail/imports/attachments/20140924/90b8affc/attachment-0001.png>