Filtering and Exporting Data

Snapshot

The Export Page for a Data Source allows for you to filter out data and columns, allowing you to extract the data you want.

At the end of this tutorial, you’ll be able to

• Filter your data
• Export your data
• Use the Stae API to share civic data

911 Call Data Filter Page

1. Data Filter Page

When you import your data to Stae, you can view individual columns and rows just like you would in Excel. You can access this filtering mode by selecting Explore on any Data Type on the Overview Page. You could also select a Data Source on the Sources Page, and then navigate to the Data Tab.

Narrowing 911 calls to parking violations

Header filter options

2. Filtering Your Data

Depending on the dataset you choose, you may only have a few data points or you may be looking at a large archive. Let’s look at 911 calls. There are just under 107,000 data points for Jersey City since they have started to digitize their records with Mark43. It would be impossible to get any value from all of this data. That’s why filtering becomes a critical tool.

Consider this scenario: say you’re getting reports of speeding issues and people ignoring traffic signals from your constituents. To understand the situation, you can prepare a report in Stae that isolates 911 calls related to traffic and vehicular data.

You can also filter out headers to isolate specific columns. In most situations, you will want to filter out the ID of a data source, since the ID is a server-generated code and not related to your data’s integrity. To filter headers, click on the column icon on the far right of the header section.

Data Export View

3. Exporting Your Data

Once you’re satisfied with the filtered results, you can export your data to a number of machine-readable files or application integrations. We currently support integrations with the following data visualization software: Carto, Plotly, and Tableau. For flat files, you can choose to export to JSON, GeoJSON, and CSV/Excel.

JSON API links for software developers

4. API Documentation for Developers

If you’re working with software developers, you can provide them with your filtered data view or the entire dataset by clicking on the JSON API button. For information on how to use the API, see our API Documentation.

Stae Inspired

“Cities have the capability of providing something for everybody, only because, and only when, they are created by everybody.”
Jane Jacobs, The Death and Life of Great American Cities

Have any questions or running into issues with this feature?
Reach us at: support@stae.co