Re: [Talk-GB] Quarterly project : Stats

[Adam Hoyle]

Hi Brian,

Great - I'm glad that it helps :-)

I've not looked at overpass before, but happy to take a look and add it in. 

If you (or anyone) have any pointers or example queries or anything to help me 
work it out, that would be awesome and definitely speed things up.

Thanks in advance,

Adam

// http://www.adamhoyle.co.uk/
// @adamhoyle

> On 10 Nov 2015, at 15:52, Brian Prangle  wrote:
> 
> Hi Adam
> 
> Thanks for your efforts here. This is a big step foward for us. Is there any 
> chance you could extend this backwards in time to Oct 1st when we started 
> this quarterly project?  I think there's something called attic data in 
> overpass
> 
> Regards
> 
> Brian
> 
>> On 6 November 2015 at 20:45, Adam Hoyle  wrote:
>> Hi Rob,
>> 
>> As promised...
>> 
>> https://docs.google.com/spreadsheets/d/1ZgOLIdPezrXUxa8GeNebuWrNmtuLTE2u5qEFUKbrPWY/edit?usp=sharing
>> 
>> I’ve got it running at 3am every morning on a server. Do let me know if it 
>> doesn’t run for any reason and I’ll prod the server.
>> 
>> It’s super easy to update for different tags, so I’m more than happy to do 
>> it for the next quarterly project.
>> 
>> For anyone interested the source code (written in javascript / nodejs) is 
>> here:
>> https://github.com/atomoil/osm_taginfo
>> 
>> In the meantime I’ve realised some of my local nature reserves aren’t 
>> covering the full area of the nature reserve (I added them some time ago), 
>> so I should probably go and fix them :-o
>> 
>> Best,
>> 
>> Adam
>> 
>>> On 6 November 2015 at 08:07:05, Rob Nickerson (rob.j.nicker...@gmail.com) 
>>> wrote:
>>> 
>>> Thanks Adam - much appreciated.
>>> 
>>> A Google sheet would be perfect if that's simple enough to do. And yes, 
>>> that should make the graph a simple point and click task!
>>> 
>>> Rob
>>> 
>>> On 6 Nov 2015 08:02, "Adam Hoyle"  wrote:
 Like saving to a Google Sheet?
 
 Sounds pretty straightforward - I'd be up for doing that. :-)
 
 And I do quite like making graphs too, although Google Sheets can probably 
 do that better.
 
 Best,
 
 Adam
 
 // 07973 428 333
 // http://www.adamhoyle.co.uk/
 // @adamhoyle
 
 On 5 Nov 2015, at 21:10, Rob Nickerson  wrote:
 
> Hi all,
> 
> During another eventful Mappa Mercia meeting in which we continued to 
> plot world domination, one idea that came up was "would a kind OSMer who 
> has a server running be willing pull back some stats for us on a daily 
> basis?"
> 
> In essence we're looking for a volunteer to query the TagInfo UK API once 
> per day and dump the output to a simple file (or a graph if you're 
> feeling particularly creative).
> 
> Our current project is nature reserves so a good API call would be:
> 
> http://taginfo.openstreetmap.org.uk/api/4/tag/stats?key=leisure&value=nature_reserve
> 
> It may not be the world domination your were expecting but is anyone up 
> for the challenge?
> 
> Best wishes,
> Rob
> ___
> Talk-GB mailing list
> Talk-GB@openstreetmap.org
> https://lists.openstreetmap.org/listinfo/talk-gb
>> 
>> ___
>> Talk-GB mailing list
>> Talk-GB@openstreetmap.org
>> https://lists.openstreetmap.org/listinfo/talk-gb
> 
___
Talk-GB mailing list
Talk-GB@openstreetmap.org
https://lists.openstreetmap.org/listinfo/talk-gb

[Talk-GB] Sync problem with british-isles.osm.pbf

[Lester Caine]

I've got a copy of british-isles.osm.pbf which was updating fine until
the 1st November when it got stuck at
start import from seq-nr 896702

The osm2pgsql stage is failing with ...

> Osm2pgsql failed due to ERROR: insert_way failed: ERROR:  null value in 
> column "pending" violates not-null constraint
> DETAIL:  Failing row contains (4254992, 
> {17947723,17947722,17947721,2891767946,2891767954,2891767909,289..., 
> {highway,secondary,ref,302}, null).
> (7)
> Arguments were: 4254992, 
> {17947723,17947722,17947721,2891767946,2891767954,2891767909,2891767947,2891767919,2891767905,17947720,2891767938,17947719,2891767929,17947718,17947716,2891767907,2891767922,17947715,2891767944,17947714,2891767959,17947717,2891767953,17947713,2891767939,2891767910,17947712,2891767942,2891767943,17947711,2891767933,2891767937,2891767952,2891767928,17947710,2891767906,2891767936,2891767932,2891767913,2891767958,2891767924,17947709,2891767925,2891767918,2891767920,2892714782,2891767940,17947708,2892714719,2891767948,2891767950,2891767917,2892713977,17947707,2891767955,2891767926,2891767927,2891767908,17947706,2891767916,2891767957,2892712501,2891767956,17947705,2891767935,2892710491,17947704,2891797509,2891767930,2891767923,17947703,2891767911,17947702,2891767934,17947701,2891767931,2891767921,17947700,2891797521,2891767945,2891769852,2891767912,2891767915,2891767941,2891790382,17947699,2891767914,2891767949,2891767951,17947698,17947697,2891721239,17947695,1794
7694,17947693,17947692,17947691,17947689,309822592,17947688,17947687,17947686,17947685,17947684,17947683,17947682,17947681,17947680,17947679,17947678,17947677,17947676,2218967592,17947675,1851431147,17947674,17947673,17947672,17947671,17947670,17947668,17947667,17947666,17947665,17947664,17947663,17947662,1851431102,2890090823,17947661,17947660,17947659,17947658,17947657,17947656,17947655,17947654,1861986735,1861986730,17947653},
 {"highway","secondary","ref","302"}, 

And now I'm stuck as to how to get it past the problem?
Is it a case of wiping the existing copy and downloading a clean copy,
or is there something to fix the update stream?

-- 
Lester Caine - G8HFL
-
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co.uk

___
Talk-GB mailing list
Talk-GB@openstreetmap.org
https://lists.openstreetmap.org/listinfo/talk-gb