Excellent. Not a new idea then. https://alexurquhart.com/post/set-up-postgis-with-docker/ looks like a reasonable summary of what Docker is and why.
It being the whole of the UK, the download and create takes a while. I will be giving the choice of a smaller area, e.g. Greater Manchester. I'd like to include some sample SQL queries to help people get started. Help here would be useful. On Thu, 6 Feb 2020, 13:17 Derry Hamilton, <rasilo...@gmail.com> wrote: > Hi Tony, > I did something similar a while back at > https://github.com/rasilon/osm_database so that might help you get > started? > > Cheers, > Derry > > On Thu, 6 Feb 2020 at 13:10, Tony OSM <tonyo...@gmail.com> wrote: > >> Absolutely Fabulous! >> >> Not done Docker but I'll start learning how to get it on those >> environments. >> >> I'll try to support by QA and writing instructions as to how to get it >> live. >> >> Cheers >> >> TonyS999 >> On 06/02/2020 12:29, Jez Nicholson wrote: >> >> I come from a database background, and when a question isn't easily >> answered with Taginfo or Overpass Turbo I jump to my trusty local postgres >> database of UK data. I have a script that downloads the British Isles from >> Geofabrik, loads it with osm2pgsql, adds some useful indexes, and then >> removes Eire. Thereafter I can run SQL queries across the whole database to >> get 'UK-wide' results. >> >> I think that this would be useful for people on hackdays and the like and >> would be a good service for OSMUK to provide, so have just added a new >> github repository https://github.com/osm-uk/osmuk2pgsql >> >> Friendly-worded Issues are welcome, as are code contributions. I'd like >> to put it on a Docker environment so that it works quickly-and-easily on >> Windows, Linux, Mac, whatever. >> >> Comments? Thoughts? >> >> Regards, >> Jez >> >> _______________________________________________ >> Talk-GB mailing >> listTalk-GB@openstreetmap.orghttps://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 mailing list Talk-GB@openstreetmap.org https://lists.openstreetmap.org/listinfo/talk-gb
