[OSM-dev] Snapshot Server
Hi All, I am a complete newbie when it comes to databases and the like so please bear with me... I am attempting to set up a snapshot server in order to feed UK Public Rights of Way data into Potlatch 2's merging tool. I am following Andy's guide at [1]. I am doing this in debian (raspberry pi version) as an initial proof of concept work. So far I have managed to get postgreSQL 9.1.7 set up and I have created a user role: sudo -u postrgres psql # create role username login createdb; # \q (where lines 2 and 3 are run within postgresql). I have also put this username in config/database.yml and executed rake db:create. However, when I run rake db:migrate I get the following error: PG::Error: ERROR relation “geometry_columns” does not exist LINE 1: SELECT * FROM geometry_columns WHERE f_table_name='schema_migrations' Any ideas? Regards, Rob [1] https://github.com/gravitystorm/snapshot-server ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] Snapshot Server
Thanks. I got it up and running but was struggling to load some data. Can't quite remember the error message but I'm hoping to get to look at it again this weekend (tho time is an issue). RobJN On 8 Jan 2013, at 16:32, Andy Allan gravityst...@gmail.com wrote: On 28 December 2012 05:52, Paul Norman penor...@mac.com wrote: Readme.md for snapshot-server is not quite accurate. I’ve got an u pdated readme at https://github.com/pnorman/snapshot-server/blob/patch-3/README.md that covers enabling PostGIS and hstore but Andy hasn’t had time t o update upstream. I've updated the readme, and there's actually a chance now that you could get it installed. I've tested the instructions on a VM, but of course feedback is welcome. I've gone for the route that involves the least typing, so rake db:create will sort out all the postgis-related things for you. Rob, did you manage to get your snapshot-server instance up and running in the end? Cheers, Andy ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] Snapshot Server
A web based loading screen would be a big plus for me. I had a quick look and found a 5mb shapefile. I would imagine 10mb is probably the largest I have. Not sure how that converts to .osm filesize. Rob On 8 January 2013 17:35, Andy Allan gravityst...@gmail.com wrote: On 8 January 2013 17:28, Rob Nickerson rob.j.nicker...@gmail.com wrote: Thanks. I got it up and running but was struggling to load some data. Can't quite remember the error message but I'm hoping to get to look at it again this weekend (tho time is an issue). Do you know offhand how big your .osm files are? I know that for giant projects, nothing will beat the osmosis loading method that we have now. But I'm wondering if it's worthwhile building a mechanism into the web frontend that can handle smaller files a bit more easily, by just uploading the file to the site. The files I had for the original cycling data project were about 0.25 - 4.0 Mb in size but I know the stuff Paul has been wrangling are closer to gigabytes. Cheers, Andy ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] Snapshot Server
Andy, Apologies for the late reply to this one. I've only just had the chance this weekend to test the new snapshot server (and updated manual), however I should really have dropped you a quick thank you email much earlier. I reinstalled snapshot-server following your updated instructions, which was a lot simpler than last time :-) and gave the web load a test. It worked a charm :-) Next step is to see if I can get Potlatch2 up and running. Once I've tested the process on my home computer and am satisfied with it, the next step would be to see if I can get this online. Paul, If I can't scrounge some server space from somewhere, would you still be happy to host these OSM files on your snapshot server instance (we discussed this idea on IRC a couple of weeks back)? Regards, RobJN On 11 January 2013 17:33, Andy Allan gravityst...@gmail.com wrote: On 8 January 2013 17:59, Rob Nickerson rob.j.nicker...@gmail.com wrote: A web based loading screen would be a big plus for me. I had a quick look and found a 5mb shapefile. I would imagine 10mb is probably the largest I have. Not sure how that converts to .osm filesize. On Tuesday I coded up an upload form, and it's in the most recent version. It works at about 30s for a 1Mb file on my laptop, which is fine for the data that I've been handling but not great for others who need larger uploads. I've stuck in a few tickets on github for things that would be good to do in future - if anyone fancies having a stab at them, be my guest! There's nothing complex in the snapshot-server code. https://github.com/gravitystorm/snapshot-server Cheers, Andy ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
[OSM-dev] Deploying Potlatch2 - local test version
Hi All, I'm attempting to deploy P2 following the instructions on the wiki. At the moment I want to deploy this locally (as in, not on a public server), so that I can have a play with the snapshot sever / merging tool. I do not need to upload anything. Is it not possible to do this without registering my server with osm? Regards Rob ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
[OSM-dev] piwik.openstreetmap.org - does it include stats on the wiki?
On talk we spoke earlier this month about piwik.openstreetmap.org and how it is currently locked down but could potentially be opened up to provide some data (like that seen on http://openstreetmap.fr/piwik ) to the general public. Obviously the remaining data will stay behind a secure login. There was also offers from the French community to help set this up and integrate OSM sites from different domains. Is this still going on? One area I am interested in is documentation. I've spent time previously helping with the wiki. To better focus my time, I would be interested in any stats about the wiki. Does / can piwik include these? Ae there any other usage stats available? Rob ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
[OSM-dev] Please support my request to replace OS OpenData Licence with the standard OGL
All, Whether you care for public sector data released under the OS OpenData Licence or not, this will probably effect you one way or another. Can I therefore request that you please submit a comment in support of the data request available at the link below. This is especially true if you run a business that uses OSM data - if you could mention your business in the comments then that would be much appreciated. A simple line saying that your business relies on the availability of free re-use data would be great. http://data.gov.uk/data-requests/all-datasets-available-under-the-os-opendata-licence-ordnance-survey The Open Data User Group [1] is a Government Policy Advisory Group and they intend to discuss the OS OpenData Licence at their next meeting. Submissions by Tuesday morning would therefore be most beneficial. Rob p.s. Lets not get bogged down with the OSM/OS Special Arrangement (I've heard it all before). The bottom line is that OS OpenData Licence is a mess and the fewer public sector organisations that use it the better. [1] https://www.gov.uk/government/policy-advisory-groups/129 ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] JavaScript Opening Hours Parser
Good idea, A couple of values that gave incorrect results: Mo-Fr 08:62-27:88 Mo-Fr 09:00-16:00; Su 11-12 mo-we 12:00-15:00; Su off 24/7 we 09:00-12:00,13:30-15:00 The first is obviously incorrect so should produce an error rather than attempting to parse it. In the second and third example, when you type Su the parser assumes that the same times should be applied to the Sunday. It sticks with this assumption until a correctly formatted time is entered (in this case it should be 11:00-12:00), but does not recognise off as a correct time interval even though it is common use. The fourth value is the most common (as shown on taginfo). It is not parsed at all. The fifth represents a lunch time break. The parser picks up the initial part only. Cheers, Rob (p.s I expect that some of these might be simply that the parser shows the last correctly entered value until a new valid (an interpretable) value is given. ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] SotM ads for front page
I'm not sure what the final decision was for what will be and won't be promoted on the front page (and no doubt you are testing the waters here). For transparency I suggested that the SotM conference being promoted and for other events I suggested that we include a prominent events banner and then link to a spruced up events page based on the following: http://calendar.openstreetmap.org.uk/map My reasons for this idea were to (1) limit the number of banners, and (2) promote OMS's global annual conference which is now in it's seventh iteration and provides funds to OSM (if there is any surplus sponsorship - something that I am concerned will be harder for the organisers to achieve if we are struggling to get the message out about the conference). Anyway, it's not an issue that is up to me, and probably needs the CWG to decide. Rob ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
[OSM-dev] Ads for front page - Proposed solutions
Hi, I have no idea what the CWG vote was on and I can't find the up to date minutes to check it. Despite this, you much surely recognise the issue. For example, even if we restrict the banners to just those promoting conferences then we could easily have a rotation of 5 or more banners: * SOTM * SOTM-EU * SOTM-US * OSM Plus * SOTM Scotland * etc.. Extend this to other non-conference meet-ups and the number could easily quadruple. == Possible Solutions == A good place to start is to improve the events page. At the moment we have the wiki events calendar and http://calendar.openstreetmap.org.uk/map . The wiki is complicated - I have no idea how to add an event to this, but things could be improved. This events page can then have it's own dedicated banner on osm.org. To help boost awareness, there are several solutions. Here in the West Midlands, UK, we keep an eye out for new active mappers and message those who are more active through the OSM messaging system. During the summer months we take our monthly meet-up on tour to increase participation in smaller towns away from Birmingham. This works well. Furthermore, we also keep an eye out for local Open Data / Hack days or similar, and try to ensure that at least one OSM member attends each event. I also believe that a email distribution list would help. The concern is that nobody has signed up to an email when they joined OSM so perhaps we cannot start emailing them without an opt in. This is not an issue for me as we can create a sign-up page and promote it on OSM.org for the next few months. The current OSM new member sign up procedure can be changed to include the opt-in for emails. In my opinion, you could have people sign up to two email distributions: 1. A general monthly OSM update (based on the monthly blogs that are already being written) 2. An events email. For this people sign up to receive monthly emails about events within a user specified geographical region (e.g. x miles/km of some point). Regrettably, my technical skills aren't up to much, so I would struggle to do the 2nd. I am however happy to help with the first if (i) Pascal, Dennis and the “Wochennotiz” guys are happy for me to repost some of their content, (ii) I get reassurances that I can advertise the email sign up via a banner on osm.org for a period of 3 to 6 months, and (iii) the new member sign up procedure is updated. Hope this inspires some more possible solutions, Rob ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] Ads for front page - Proposed solutions
I also believe that a email distribution list would help. I don't comply with this: I clearly don't want to be spammed by Emails. Hi Michael, That was incredibly selective quoting of my original text and makes me wonder why I bothered putting my ideas down in writing. As noted any email list would be opt-in only; something I addressed as an issue in the sentence following the part you have quoted. Furthermore due to the decreasing popularity (and visibility) of RSS, some OSM users may actually like a monthly email delivered to them. I don't want to be overwhelmed by irrelevant banners, and hence I tried to propose some alternatives. I'm sorry you didn't like them. Rob ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] Using Google Street View Player with my own panoramic images
I'm no legal expert but Products and Content is defined by Google: By downloading, installing, or using the Google Earth software, accessing or using the Google Maps service (together, the Products or Services), or accessing or using any of the content available within the Products... To me, the viewer is a product and therefore is bound by the rules in the terms of use. In any case, isn't the StreetView viewer Flash? Firefox claims it is when I force quit the plugin-container process. If this is the case then why not use KRPano? Regards, Rob ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] map parameter (iD editor)
Do you mean in the URL? If so this example [1] suggest it is called as map=zoom/lat/lon [1] https://github.com/systemed/iD/issues/1511 ___ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev
[OSM-dev] New Imagery Layers - A plea for help
Hi Dev list, I'd like to add some more historic imagery layers for use in the main editors. I have quite a long list of Ordnance Survey Town Plans from the National Library of Scotland ready to go. Furthermore I am hoping to get the OS Hand drawn maps recently discussed on the talk-gb mailing list up on a tile server and added as an imagery layer. Finally user Blackadder has just acquired some historic maps from Coventry University which we would like to scan and upload. All are out of copyright. As a non-developer, I'm not particularly clued up for using github. As a test case, would someone please be so kind as to add this attached Bartholomew json (to Europe) and run the make script, as described at: https://github.com/osmlab/editor-imagery-index We have the permission of NLS to use their tile server. In fact they want us to use this actively. If this goes well, I'm wondering whether I can just upload the json and have someone else run the make bit (or give me a dummies guide to github on ubuntu) - or is that asking too much? :-) Kindest regards, RobJN p.s. Thinking ahead, it may be worth adding a date schema to the json so that the historical team can use this to eventually develop a slider to select layers from a given date range. NLS-BartholomewHalfInch1897-1907.json Description: application/json ___ dev mailing list dev@openstreetmap.org https://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] New Imagery Layers - A plea for help
Brilliant. Thanks for helping and providing all the steps. I think I can manage that now that I know what to do. Will double ckeck the json next time (is there a json checker tool that looks for missing braces?) Thanks, RobJN On 11 Oct 2013 23:10, Eric Fischer e...@pobox.com wrote: I made a pull request to add your imagery (after adding a missing closing brace in your json file): https://github.com/osmlab/editor-imagery-index/pull/18 The shell commands to do it were: git clone https://github.com/ericfischer/editor-imagery-index.git cd editor-imagery-index/ git branch nls git checkout nls cp ~/NLS-BartholomewHalfInch1897-1907.json sources/europe vi sources/europe/NLS-BartholomewHalfInch1897-1907.json make git status git add imagery.geojson imagery.json imagery.xml sources/europe/NLS-BartholomewHalfInch1897-1907.json git commit git push -u origin nls Eric On Fri, Oct 11, 2013 at 2:49 PM, Rob Nickerson rob.j.nicker...@gmail.com wrote: Hi Dev list, I'd like to add some more historic imagery layers for use in the main editors. ... ___ dev mailing list dev@openstreetmap.org https://lists.openstreetmap.org/listinfo/dev ___ dev mailing list dev@openstreetmap.org https://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] New Imagery Layers - A plea for help (Follow up post)
I've now had a go at a git pull request for the OS Town Plans. Hopefully I got it right (this is my first ever experience with git). https://github.com/osmlab/editor-imagery-index/pull/25 Thanks to Eric for helping me out with the Bartholomew example. Best, Rob ___ dev mailing list dev@openstreetmap.org https://lists.openstreetmap.org/listinfo/dev
[OSM-dev] Piwik stats for the wiki?
Hi All, Does our piwik stats site extend to the wiki? If yes, then can I get some anonymized data for page views as this would help me to target my wiki clean-up effort. https://piwik.openstreetmap.org/ Thanks, RobJN p.s. You could enable this level of anonymized data for non-logged in piwik users so that we can always get up to date info without having to request it. ___ dev mailing list dev@openstreetmap.org https://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] Piwik stats for the wiki?
That's a shame. Any plans to add the wiki? R On 7 Feb 2014 23:56, Tom Hughes t...@compton.nu wrote: On 07/02/14 22:52, Rob Nickerson wrote: Does our piwik stats site extend to the wiki? If yes, the... We're not currently running it for the wiki, no. Tom -- Tom Hughes (t...@compton.nu) http://compton.nu/ ___ dev mailing list dev@openstreetmap.org https://lists.openstreetmap.org/listinfo/dev
[OSM-dev] Wiki - VisualEditor
There is an issue open for this in trac. There was a stopper at the time but now that's been resolved I would also like to see the plugin added (it is default on Wikipedia) https://trac.openstreetmap.org/ticket/4920 Rob ___ dev mailing list dev@openstreetmap.org https://lists.openstreetmap.org/listinfo/dev
[OSM-dev] Help redesign NYPL Building inspector
Hi folks, We, as in those OSMers interested in historic maps are launching our own version of the NYPL Building Inspector site [1]. We're making great progress (for non-developers at least), but help is very welcome - especially if you're at sotm-eu hackday and are looking for something to do. Have a word with Tim Waters. :-) All the details are at: https://lists.openstreetmap.org/pipermail/historic/2014-June/000465.html Best regards, Rob [1] http://buildinginspector.nypl.org/ ___ dev mailing list dev@openstreetmap.org https://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] Wiki Pageview Stats
I would like the same as it would help me to focus my attention on the most read part of the wiki. Previous requests have unfortunately fallen on deaf ears. Fingers crossed that with two people asking for it we may actually get somewhere. Perhaps if Harry was also interested. Rob ___ dev mailing list dev@openstreetmap.org https://lists.openstreetmap.org/listinfo/dev
[OSM-dev] Learn Rails
Code academy have added Ruby on Rails, which is what OpenStreetMap uses for the website. Learn via their online interactive learning. http://www.codecademy.com/learn/learn-rails You never know, you could be contributing to OpenStreetMap code soon after :) ___ dev mailing list dev@openstreetmap.org https://lists.openstreetmap.org/listinfo/dev
