| OBJECTID |
OBJECTID |
NUMBER |
ESRI system maintained integer field used to uniquely identify rows in tables in a geodatabase. Note that OBJECTIID values change upon export or import of the data and should not be used as a primary field for searching or identifying records. |
|
|
|
| COUNTERID |
Counter ID |
VARCHAR2 |
A unique ID for each counter equipment
|
|
|
|
| EQUIPMENT_TYPE |
Equipment |
VARCHAR2 |
Counter equipment type |
|
|
|
| STATUS |
Status |
VARCHAR2 |
Indicates the status of feature. A pick list is used for this field - contact GIS for pick list values. |
|
|
|
| STATUS_DATE |
Status Date |
TIMESTAMP(6) |
Database maintained field. Updates to the current date/time when the STATUS field value is changed. |
|
|
|
| SOURCE |
Source |
VARCHAR2 |
GIS maintained field. Source EDRA (Electronic Document Registration Application) document number, or name of department or specific staff member that the information came from. |
|
|
|
| CREATE_BY |
Created By |
VARCHAR2 |
Database maintained field. Updates to the user name that created the feature. Update takes place when the feature is created. |
|
|
|
| CREATE_DATE |
Create Date |
TIMESTAMP(6) |
Database maintained field. Updates to the current data/time. Update takes place when the feature is created. |
|
|
|
| INSTALL_DATE |
Installation date |
TIMESTAMP(6) |
Date when equipment was installed and in operation |
|
|
|
| UPDATE_DATE |
Update date |
TIMESTAMP(6) |
Database maintained field. Updates to the current data/time when an attribute or the geometry of the feature is changed. Update takes place when the feature is created and/or changed. |
|
|
|
| USER_TYPE |
User Type |
VARCHAR2 |
Travel type - cyclist, pedestrian or mixed |
|
|
|
| COLLECTION_MODE |
Collection Mode |
VARCHAR2 |
Describes method to upload count data from counter equipment |
|
|
|
| FLOW_DIRECTION |
Flow Direction |
VARCHAR2 |
Directions observed by counter (in, our or bidirectional) |
|
|
|
| SITE_NAME |
Site Name |
VARCHAR2 |
A description of the site location |
|
|
|
| SITE_ID |
Site ID |
VARCHAR2 |
A unique ID for each site location - use for joining observation data to site location data |
|
|
|
| OBSERVATION_INTERVAL |
Observation Interval |
VARCHAR2 |
Frequency of observations - e.g. count totals every 15 minutes. |
|
|
|
| COMMENTS |
Comments |
VARCHAR2 |
Descriptive text outlining any problems or to highlight special characteristics of the feature. |
|
|
|
| OWNER |
Owner |
VARCHAR2 |
Equipment owner |
|
|
|
| SHAPE |
SHAPE |
ST_GEOMETRY |
ESRI system maintained field. Stores the geometry type and geometry of the feature. |
|
|
|