[OSM-dev] Modeling OSM sidewalk data

Paul Norman penorman at mac.com
Tue Jul 12 07:42:29 UTC 2016

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?

More information about the dev mailing list