About the compendium
The compendium was created using scripts that accessed ArcGIS REST or Tyler Technologies Data & Insights (formerly Socrata) API endpoints (see the API Endpoint column in the show/hide columns menu of the references table). The API responses from the endpoints were processed to create the two tables shown here.
The purpose of the compendium is to compile existing practices for tracking bicycle, pedestrian, and accessibility infrastructure data. The compendium serves as inspiration for developing data in GATIS and tracking attributes that might not be covered by the specification. This page will be updated periodically as new data sources are acquired.
How to use
There are two tables that are linked by the Dataset ID column. You can show/hide columns with the drop down menu (some columns have been hidden by default for readability). Filters can be applied to each table by right clicking one of the column headers. Upon right clicking, a popup will appear that gives you options for filtering. Some of the columns can be filtered using checkboxes, some are filterable with a text search, and the numeric columns are filterable with conditional expressions.
Once a filter has been applied the tables will be updated and the columns that currently have a filter will be highlighted. If a particular Dataset ID is filtered out as a result of one or more filters, then it will be removed from both the References and Attributes table. If you wish to remove all of the filters, simply reload the page. You can also use "download CSV" to download a CSV of the table in its current filtered state.
Data dictionary
Click the table headers to access the source data.
References Table
| Column Name | Description |
|---|---|
| Dataset ID | Unique value used to name the dataset |
| Dataset Name | Scraped name of the dataset |
| Description | Scraped description of the dataset if available |
| Entity | Organization(s) that publish the dataset |
| City | City/cities that the dataset covers |
| State | State(s) that the dataset covers |
| Info URL | URL(s) for information/overview of the dataset |
| Row Count | Number of rows in the dataset |
| Column Count | Number of columns in the dataset |
| Tags | Tags to describe the type of infrastructure data covered |
| API Endpoint | API endpoint that the data were scraped from |
| API ID | Type of API ('arcgis' for ArcGIS REST API or 'tyler' for Tyler Technologies Data & Insights API) |
Attributes Table
| Column Name | Description |
|---|---|
| Attribute ID | Scraped name of the attribute |
| Dataset ID | Refer to references table |
| Attribute | Attribute alias name if available, otherwise same as Attribute ID |
| Data Type | Data type used by ESRI/Tyler Technologies |
| Unique Values | Up to 20 unique values for attribute listed in ascending order |
| Unique Count | Number of unique values for attribute |
| Null Percent | Percent of null values for attribute |
| Statistics | The minimum, maximum, average, and sum of the attribute (if applicable) |
Contributing new datasets
Are you aware of an open dataset that isn't in the attribute tracker that has an ArcGIS REST or Tyler Technologies Data and Insights API endpoint? Please send a link to the data so that it can be added using this form.