If your project includes many camera locations and you already have their information in a spreadsheet, we have a method here to import those locations in bulk. If you prepare your data based on the format outlined on this help page, the location data can be imported in an existing project on AIT.
In order to be uploaded, the location data must be in a CSV file and contain the following fields, some of which are required, and some optional. Optional fields can be omitted but there must be values for all required fields, including geographic coordinates and location name. In the table below, the first column are exact names of the columns in the CSV (they are case sensitive).
Table of Column Attributes
Note: The order of the columns is not important, although the names of the columns are case sensitive.
| Column Name | Notes and Description |
|---|---|
| name | (required) Enter the name of this location. You can use a regular name or a code, but ideally this name identifies this location. |
| project_id | (required) When you visit your project homepage, the project_id is the last number appearing in the website address (the URL). |
| site | (optional) Enter the name of the site which this location is member. Locations are grouped by site on the website, as they establish a relationship between them (such as a single crossing structure with multiple cameras including on both sides of the structure). Site names much match exactly for their to be an association. |
| latitude | (required) WGS84 coordinate in decimal degrees. |
| longitude | (required) WGS84 coordinate in decimal degrees. |
| notes | (optional) Textual notes about the location. |
| type | (optional) Structure Type: Can be one of the following terms: Culvert, Overpass, Underpass, Wildlife Trail, or Opportunistic. More terms may be added in the future. |