This page helps provide guidance on how to use the Bike Parking Dashboard and pull data from the associated web app. Both of these features are available as part of the Bike Parking Hub.
On initial load of the Bike Parking Hub you will view the Bike Parking Dashboard. This provides a location to run quick filters on the data to get a better idea of work being done in the field.
Using Filters
On the right-hand side of the dashboard you will see a column for Filter. These filters can be used to learn more about the data ie (# of installs in the past month).
Because bike rack data is stored in a separate table from maintenance records, some filters will only update bike rack information while other will only update maintenance records. The image below is color coded to show which filter updates each dashboard visual.
Other Features
The "Most Recent Maintenance Records" column will always display the 10 most recent maintenance records that have been submitted
The map component will allow you view features by location and see associated attributes through a pop up. This component is currently not linked to any filters.
Accessing Map Viewer
To access map viewer you will need to click the "Data Viewer/Editor" tab in the top left.
Accessing Attribute Data in the Map Viewer
Once the map viewer is open you can begin exploring the different features on the map.
To view the attribute table you will need to click the little button in the bottom center of the page (shown below).
Through the attribute table you can create custom filters to view specific subsets of data. This is also were you can export attribute data for use in Excel and other programs.
Viewing Data in the Attribute Table
The attribute table will allow you to see all records for each layer that is included in the map.
To change which layer attribute you are viewing, click on the tab with the layer name. In this case we are only interested in the "Bike Racks" and "Maintenance Records" tabs.
The filter you set will only apply to the data you have displayed in the attribute table (ie. separate filters would need to be created for the Bike Raks and Maintenance Records.
Filtering to View Subset of Data
If you are exporting data it is likely you may only want a subset of the dataset.
Within the Attribute table "Options" drop down, you can select filter to build a custom query of the data.
Creating Filter/Building Expression
Once you have selected the "Filter" option a new window will appear to create the custom filter. in the window that appears select "Add Expression".
Within the expression builder use the drops downs to build the expression to include only the features you are interested in. Once expression is created click "OK".
The Filter below will show only bike racks with a "Date Installed" value that falls between August 1st and August 31st.
Exporting Filtered Data
Once filter is set, the attribute table will update to show only the feature your filter has been set to display.
To export this subset of data, select the "Options" button in the attribute table and in the drop down select "Export All to CSV". (Since the filter is in place, it will export only the filtered subset of data)
In new window that opens Select "OK"
Saving Data
This will then allow to save the csv to your computer or open the document in Excel. Select the option that works best for you.
Open the document and make sure only the subset of data you want is included. You can then run any analysis in Excel or share with individuals that may be requesting data for reporting.
