[HOT] Damage evaluation tagging schema

Mark Cupitt markcupitt at gmail.com
Mon Jan 26 00:54:40 UTC 2015

Hi Althio

Thanks, good info

These would have to be dealt with in HStore in Postgres, it would blow the
column count out dramatically in Postgres, with an infinite number of
tag/key combinations (everything left of the first '=' would get its own
column or is considered a Tag in Hstore.

The beauty is that Hstore is a great way to do it anyway, as it is a lot
more flexible, provided you do not want to search on specific data in
there, but simply us it to add attributes to the map.

Pierre, well worth looking at.


Mark Cupitt

"If we change the world, let it bear the mark of our intelligence"

See me on Open StreetMap <https://www.openstreetmap.org/user/Mark_Cupitt>

On Sun, Jan 25, 2015 at 2:48 PM, althio <althio.forum at gmail.com> wrote:

> Hi Pierre, Mark and all
> FYI some related schemes -- currently used or proposed in OSM -- are
> gathered at this page:
> http://wiki.openstreetmap.org/wiki/Comparison_of_life_cycle_concepts
> In particular this section
> http://wiki.openstreetmap.org/wiki/Comparison_of_life_cycle_concepts#.3Cstatus.3E:.3Ckey.3E_.3D_.3Cvalue.3E
> At a basic level it would look like:
> damaged:building=hospital
> (damaged is not yet used or documented)
> I understand that you need more refinement for details:
> * source: imagery/survey
> * date
> * event name or reference
> So maybe you could consider this scheme as a starting point.
> Then you could add more field/key/tag so that it is adapted to your
> needs for completeness and data extraction.
> On Jan 23, 2015 5:04 AM, "Markware Software Services"
> <markwaresoftware at gmail.com> wrote:
> > Osm does have these tags already defined, I am sure you are aware
> > ...
> > abandoned=* - for a building
> and other related tags: disused/demolished/removed...
> But see http://wiki.openstreetmap.org/wiki/Key:abandoned
> in particular the section: Former use (as a simple tag)
> with
> Older scheme (deprecated)
> Intermediate scheme (discouraged)
> Current scheme (recommended)
> From the wiki: Using a simple key is now strongly discouraged. It is
> recommended to use the namespaced form instead.
> This leads to the scheme in
> http://wiki.openstreetmap.org/wiki/Comparison_of_life_cycle_concepts#.3Cstatus.3E:.3Ckey.3E_.3D_.3Cvalue.3E
> althio
> _______________________________________________
> HOT mailing list
> HOT at openstreetmap.org
> https://lists.openstreetmap.org/listinfo/hot
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/hot/attachments/20150126/67963f7f/attachment.html>

More information about the HOT mailing list