- Each Template spreadsheet downloaded comes with a corresponding Legend.xls spreadsheet. This spreadsheet shows the field types and values (Selection) required for each field in the Template shapefile:
- Use the rules in the table below, along with the Legend.xls, when populating the Template shapefile attributes:
Table 1: Data validation for template shapefiles.
| File Type/ Validation | Format/ Data Entry Rule | Additional Information |
| String (Text) | Text field up to 254 characters | |
| Date | yyyy-mm-dd | Ensure this formula is correct, i.e. no additional spaces, correct order of year-month-date. |
| Selection | Choose a value for the corresponding field name from Legend.xls | The value entered must match exactly the value given in Legend.xls (i.e. “Bollard” not “bollard”). |
| Number | Integer or decimal | No letters or special characters other than a decimal point. |
| Image | Imagename.jpg | Can take only one image for each record (can only be .jpg or .png files). |
| File | Filename.zip or Filename.pdf | .zip can take multiple images or files when zipped together. |
| Mandatory fields | Must be completed, others can be left blank | Capture as much data as possible. |
| “ID” field (CRITICAL) | Must be populated.
Must be a unique integer. Must be unique between templates of the same activity. |
i.e. 1,2,3… |
NOTE: Once data is uploaded “Area” and “Length” fields for polygons and polylines are added and calculated automatically
NOTE: Field names for shapefiles will be truncated to 10 characters. If you are unsure of a field name when viewing shapefile attributes, see the corresponding field in the Legend.xls.