4 ms·

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 abou

by ezzzzz 7y ago

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/ 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.

ridaj 7y ago
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.
- ezzzzz 7y ago
  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!
  - samcrawford 7y ago
    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.
    - ezzzzz 7y ago
      Awesome, thanks for the tip. Osm2pgsql looks very interesting, the docs lead me Mapnik which is pretty much what I was looking for.
  - dvdkon 7y ago
    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.
    - ezzzzz 7y ago
      Interesting, a cursory glance at the git repo for imposm3 looks promising. Which also lead me to https://mapproxy.org/ 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.

by ezzzzz 7y ago

ridaj 7y ago

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.

ezzzzz 7y ago
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!
- samcrawford 7y ago
  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.
  - ezzzzz 7y ago
    Awesome, thanks for the tip. Osm2pgsql looks very interesting, the docs lead me Mapnik which is pretty much what I was looking for.
- dvdkon 7y ago
  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.
  - ezzzzz 7y ago
    Interesting, a cursory glance at the git repo for imposm3 looks promising. Which also lead me to https://mapproxy.org/ 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.