I'm working on putting OSM sidewalk data into PostgreSQL with ClearTables (https://github.com/ClearTables/ClearTables/issues/39) and looking at two different ways, and wondering if anyone has experience modeling it.

There are two obvious options

1. Have a sidewalk column with an enum type with both/left/right/neither

2. Have sidewalk_left and sidewalk_right boolean columns

I can see advantages and disadvantages to both.

Does anyone have experience consuming OSM sidewalk data and have thoughts about what would be better to work with?

_______________________________________________
dev mailing list
dev@openstreetmap.org
https://lists.openstreetmap.org/listinfo/dev

Reply via email to