Show historical bike infrastructure growth

[juliekdang]

If you load the layers using the opendata.dc.gov URL for Bike Lane Street Right-of-Way, you can use a WHERE parameter that uses a typical SQL syntax on the end of the geojson URL.

You can show progressive accumulation of bike infrastructure with a query like this, which shows everything built before 2009

http://opendata.dc.gov/datasets/5b0d63150e2c4c47b5b21db73a4fd928_3.geojson?where=YEAR_INSTALLED%20%3C%3D%202009

Advance it by adding a year like so:

http://opendata.dc.gov/datasets/5b0d63150e2c4c47b5b21db73a4fd928_3.geojson?where=YEAR_INSTALLED%20%3C%3D%202010

In addition, you can pull a single year's additions with a query like this
http://opendata.dc.gov/datasets/5b0d63150e2c4c47b5b21db73a4fd928_3.geojson?where=YEAR_INSTALLED=2003

You can use the Filter in the table view to get a starting point for formatting the request.Hint: the filtered geojson is available from the APIs dropdown after applying a filter