Read more about best practices for assigning a mySidewalk geography here.
The first step of any data upload is to clean the data and ensure that it is ready for uploading to mySidewalk. (read more here).
- First, we can remove all of the rows that we do not want to upload
- Next, we need to ensure that all punctuation and symbols are removed from numbers (commas and symbols like $, % will cause numbers to be read as strings, which will cause problems for us later)
- Also, we need to make sure the first column is a 'label' column as it will not upload as data values, only labels. Typically, this is a boundary or a date/time reference.
- Finally, we need to ensure that there is only one header column row (access a sample file in the cleaned format here)
- Save the cleaned file as a .csv
1. Navigate to Layers and Add a Layer
Access the Layer library from the home page or the menu bar and then click Add Layer
2. Choose Add Geography
- Select “Add Geography” under the “Upload Data” section.
- Drag or choose a CSV file to upload.
3. Choose an option: Single or Multiple Geographies
The Single Feature option allows you to assign all of the data in your file to one MySidewalk maintained geography. This can be any of 14 feature classes we support (e.g. state, county, place, zip code). Census tract and census block group are excluded.
Pro Tip: if you aren’t sure what to choose, assigning to your default geography is an easy choice that allows the data to be uploaded and used fairly easily by the majority of components.
The Multiple Features option allows you to assign a different geography to each row in the uploaded table. Every row must be assigned and duplicate geographies are not allowed (if you put the same zip code in two rows, only one row of data will load).
4. Manage and Use your layer
A successful upload will result in a layer being created and move you to the layer management page. On this page, you can update the name of your file, add tags, add a description and change the label of your file. It will also reveal if you have uploaded time in a way the system can recognize (this example does not have time included).
Pro Tip: choose a field to assign as the label - geography often makes the most sense
From here, you can click “New Report” to start building visualizations or choose Reports from the menu and choose an existing report. The Layer you built will be accessible from components if you choose “Your Data”.