A couple of weeks back OGL's Postgres installation was upgraded. I
made a dump of the database before that happened, but it seems to have
been in a slightly inconsistent state - key constraints broken in some
places, probably due to me removing enormous swathes of spam in a
rather brutal fashion. As a result, I can't currently restore it. I
tried commenting out the restraints in question in the dump before the
restore (which let it happen), and then locating and deleting the
errant nodes, but I obviously wasn't doing something right.
Could someone with more knowledge in this department please help me
out? I'm happy to give you a copy of the dump to test.
Thanks very much,
(Not specifically OG question but people here have interests in this
I want to make a leaflet for an event and include a map. Most of the
ways usually done for this are not strictly legal. I could just use the
(non) defence of everyone does it but I would rather not.
I have noticed that OpenStreetMap has coverage of the area of Central
London I am interested in. The simple way to make my map would be to
screen scrape the browser window as a bitmap. Is there any better way,
eg extracting an SVG file of a particular area.
I also want to add some annotations - eg route you get from tube to the
venue. Frustratingly it is dead easy to do this online using
Googlemaps. But this doesn't help legally for a printed or emailed leaflet.