OpenStreetMap data model

[flacombe]

Hi,

I'm just discovering what water-gis is all about. What an inspiring work, it's really great. By the way I wasn't able to find a more appropriate place to write this issue here, there are many repositories.

Where the data model your GIS supports is defined please? Is it derived from any existing standard? Is it mandatory to import data as Epanet INP files or geojson with comparable data structure?

I use to contribute to OpenStreetMap data model for 10 years now, mainly focused on infrastructure and utilities. Several objects related to water networks are now well defined and it could be interesting to examine how we could build links, couldn't you?

• Valves : https://wiki.openstreetmap.org/wiki/Proposal:Pipeline_valves_proposal
• Pumps : https://wiki.openstreetmap.org/wiki/Proposal:Pumping_proposal
• Pipelines : https://wiki.openstreetmap.org/wiki/Tag:man_made%3Dpipeline
• Hydropower water supplies : https://wiki.openstreetmap.org/wiki/Proposal:Hydropower_water_supplies And so on...

Let me know if it's relevant for your project and how we could go further.

Best regards

[JinIgarashi]

@flacombe Hi, thank you for commenting. My approach does not use any data model. We are using PostGIS to fetch geospatial data to generate vector tiles. Any data model can fit to this approach because we just use SQL to flexibly mandate vector tiles. To be honest, every water utility use different data structure, this makes development of GIS more difficult. So, I think using PostGIS is a good approach to fit any data models.

Also, thank you for sharing the information about the data model on water network in OpenStreetMap. I did not know it, and the model is very well designed, I think it will fit to most of water utilities' data. My only concern is, I really don't know how many institutions want to make their utilities' data public in OSM. As you know, water network is quite sensitive data, and the data should not be modified by anyone else except responsive organizations.

maybe you can download a pmtiles to check their data structure.

• Narok, Kenya https://github.com/narwassco/vt/blob/master/data/narok.pmtiles
• Nanyuki, Kenya https://github.com/nawasco/vt/blob/master/data/nanyuki.pmtiles
• Rwanda (sorry, we don't have pmtiles and only have mbtiles for Rwanda) https://github.com/WASAC/vt/blob/master/data/rwss.mbtiles

All their data is under CC By 4.0 License

[flacombe]

Hi and thank you for answering :)

My approach does not use any data model. We are using PostGIS to fetch geospatial data to generate vector tiles.

Understood, it's perfectly fine

My only concern is, I really don't know how many institutions want to make their utilities' data public in OSM.

It's not necessary to put your data in OSM to get the benefits of its tagging model. Semantics and modelisation can be used standalone, in regard of the CC BY-SA 2.0 covering our documentation.

Answering to questions like How do I describe a pump or a valve? is different from mapping them in the public database.

I intend to make this more visible, because a wide part of the community doesn't think about it that way. Feel free to ask or reuse part of our work, the only constraint is to mention OSM when reusing something coming from it.

Thank you for open data sources, I'll have a look at them