- 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.
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.