7.04 Data Validation for Template Shapefiles

  1. 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:
  2. 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.