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 <cl...@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.pl...@gmail.com > <javascript:_e(%7B%7D,'cvml','elliott.pl...@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 <cl...@oced.ca > <javascript:_e(%7B%7D,'cvml','cl...@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.pl...@gmail.com >> <javascript:_e(%7B%7D,'cvml','elliott.pl...@gmail.com');>> >> *Sent:* Sunday, September 21, 2014 10:59 AM >> *To:* Clark Trivers >> *Cc:* imports@openstreetmap.org >> <javascript:_e(%7B%7D,'cvml','imports@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 <cl...@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.
_______________________________________________ Imports mailing list Imports@openstreetmap.org https://lists.openstreetmap.org/listinfo/imports
