[OSM-dev] Modeling OSM sidewalk data

[Paul Norman]

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?