News for hackers. Stuff that matters.
Re:Switch to OpenStreetMap by ezzzzz on Thursday December 12, 2019 @10:13AM (#21772405)
Pardon my ignorance, but I'm wondering if anybody has experience with running OpenGIS in Postgres with one of the supported mapping servers listed on their about page? (https://postgis.net/features/)

I looked at this for a POC but was notably out of my depth and gave up. I'm not sure exactly how the tileserver OSM provides differs from the mapping servers in the link above.

Re:Switch to OpenStreetMap by ridaj on Thursday December 12, 2019 @10:22AM (#21772504)
I have, a few years ago. Unless things have changed dramatically, I would plan to have one full-time person work for a couple weeks to set this up, and a few weeks more if you want to set it up in a way that the map updates automatically over time. Doc is often out of date, some of the tools are unstable, the amount of data to wrangle is not trivial, and checking that your map is ok is actually not that easy, eg you might not find out immediately that the coastline is cutting across some random city in some corner of Asia.
Re:Switch to OpenStreetMap by ezzzzz on Thursday December 12, 2019 @10:31AM (#21772608)
Still, judging by the parent comment, it sounds like setting up a tile server in OSM isn't exactly trivial. Rather than editing, In my comment above, I meant PostGIS, not OpenGIS.

Anyway, I was interested in this at the time for a hobby project and (rightly) decided the effort would not be worth it. Thanks for the insight!

Re:Switch to OpenStreetMap by samcrawford on Thursday December 12, 2019 @12:02PM (#21773651)
Depends on the level of effort you want to put into it. I've been working on a hobby project with PostGIS recently, and I've found it very easy to get started (a few hours to get PostGIS running + import just the UK's dataset using osm2pgsql). But it's taken me months to get to a point where I'd say I'm pretty experienced with it.
Re:Switch to OpenStreetMap by ezzzzz on Friday December 13, 2019 @07:56AM (#21781117)
Awesome, thanks for the tip. Osm2pgsql looks very interesting, the docs lead me Mapnik which is pretty much what I was looking for.
Re:Switch to OpenStreetMap by dvdkon on Friday December 13, 2019 @01:08AM (#21779470)
Importing OSM data into PostGIS is mostly painless with imposm3, probably because it's actually documented, unlike most other pieces in the tile-serving stack. The biggest hurdle is probably understanding both the OSM and SQL way of thinking.
Re:Switch to OpenStreetMap by ezzzzz on Friday December 13, 2019 @08:06AM (#21781174)
Interesting, a cursory glance at the git repo for imposm3 looks promising. Which also lead me to https://mapproxy.org/ which the maintainers of imposm3 also created.

I understand your comment about sql thinking, in my day-to-day work I'm a bit of a reluctant sql developer (shudders in procedural spaghetti) but am gaining appreciation for being able to hand off aggregations and calculations to the db.