[Imports] Ottawa Bike Parking Import

[Elliott Plack]

Clark,

Quick tip, always reply all to these list emails so it goes back into the
list.

Definitely use the PNG! I'll license it as CC0.

For approval we should wait a few days for others to comment. Also we'll
want to check if there's any existing data that would be duplicated.

I can do the import for you too, no problem. It's just a few clicks.

Finally you'll want to write a wiki page on the OSM wiki. Just summarize
what you said in the first email.

Cheers,
Elliott

On Wednesday, September 24, 2014, Clark Trivers <Clark at oced.ca> wrote:

>  That is fantastic! Thank you, Elliott. However I can't open the .OSM
> file. It seems I have reached the point where I feel like a novice. Could
> you advise the next steps I should take? What is required for list
> approval? In the meantime I'll continue studying this
> <http://wiki.openstreetmap.org/wiki/Import/Guidelines>. Also, do you mind
> if I use your ArcMap .png on our website as a teaser before all the data is
> uploaded?
>
>
>  Cheers!
>
>
>  ------------------------------
> *From:* Elliott Plack <elliott.plack at gmail.com
> <javascript:_e(%7B%7D,'cvml','elliott.plack at gmail.com');>>
> *Sent:* Wednesday, September 24, 2014 2:24 PM
> *To:* Clark Trivers
> *Cc:* Imports OpenStreetMap.org; Alex Barth
> *Subject:* Re: [Imports] Ottawa Bike Parking Import
>
>  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
> <javascript:_e(%7B%7D,'cvml','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
>> <javascript:_e(%7B%7D,'cvml','elliott.plack at gmail.com');>>
>> *Sent:* Sunday, September 21, 2014 10:59 AM
>> *To:* Clark Trivers
>> *Cc:* imports at openstreetmap.org
>> <javascript:_e(%7B%7D,'cvml','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
>


-- 
Sent from iPhone; kindly excuse tyops.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/imports/attachments/20140924/c8b5ff0a/attachment-0001.html>