| 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. |
|
|
|
| GARBAGECANID |
Garbage Can ID |
NUMBER |
Database maintained field that permanently assigns a unique value for each record. This ID value should be the one referred to when identifying a record. |
|
|
|
| CATEGORY |
Type of Garbage Can |
VARCHAR2 |
Primary mapping field of the layer. Valid category values are:BARREL,BULK BIN,DEEP COLLECTION,FINE PAPER PICKUP,SANITATION CONTAINER,SURFACE MOUNT,SWEEPER DUMP,VICTORIAN CONTAINER |
GarbageCanCategory |
Barrel |
Barrel; Bulk Bin; Deep Collection Molok; Surface Molok; Sutera; Sweeper Dump; Victor Stanley; Victorian Container |
| SUBCATEGORY |
Type of waste collected |
VARCHAR2 |
Secondary mapping field of the layer.Valid subcategory values are:CORRIGATED CARDBOARD BIN,DOG WASTE,GARBAGE,PAPER,RECYCLE/GARBAGE,RECYCLING |
GarbageCanSubCategory |
Garbage |
Corrigated Cardboard; Dog Waste; Garbage; Grease; Paper; Recycling |
| PICKUP |
Is the bin picked-up |
VARCHAR2 |
|
YesNoOnly |
Y |
No; Yes |
| INDEX_CODE |
Index Code |
VARCHAR2 |
|
|
|
|
| LOCATION_REGION |
Location Region |
VARCHAR2 |
|
|
|
|
| SETUP |
When the garbage can is set up |
VARCHAR2 |
|
GarbageCanSetup |
Permanent |
Event Only; Permanent; Summer; Winter |
| CONTRACTOR |
Contractor |
VARCHAR2 |
|
GarbageCanContractor |
City |
Canadian Waste; City |
| QUESTIONS |
Comments |
VARCHAR2 |
|
|
|
|
| GARBAGE_SIZE |
Garbage Size |
VARCHAR2 |
|
GarbageCanSize |
|
2 Yards; 40 Yards; 45 GAL; 500 Litres; 55 GAL; 6 Yards (x2); Large; Medium; Mini; Small ...See GIS for a complete list... |
| MATERIAL |
What type of material is the garbage can made of |
VARCHAR2 |
|
GarbageCanMaterial |
Metal |
Concrete; Metal; Plastic; Plastic/Wood; Wood/Plastic |
| LOCATION |
Nearest Address |
VARCHAR2 |
Open text field that describes the location of the feature in more detail. |
|
|
|
| CONTACT |
Contact |
VARCHAR2 |
|
|
|
|
| LOCATION_COMMENT |
Location details (Location is automatically assigned) |
VARCHAR2 |
|
|
|
|
| SITE_NUMBER |
Site Number |
NUMBER |
|
|
|
|
| COMMON_LOCATION_REFERENCE |
Common Location Reference |
VARCHAR2 |
Location of the feature often using FM city sites as the source, it is generally populated by a spatial trigger |
|
|
|
| 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. |
|
|
|
| STATUS |
Status |
VARCHAR2 |
Indicates the status of feature. A pick list is used for this field - contact GIS for pick list values. |
OutdoorFurnitureStatus |
Active |
Active - Installed; DELETED - Put in trash; Off Site Storage; On Site Storage; Planned |
| STATUS_DATE |
Status Date |
DATE |
Database maintained field. Updates to the current date/time when the STATUS field value is changed. |
|
|
|
| UPDATE_BY |
Update By |
VARCHAR2 |
Database maintained field. Updates to the user name that most recently updated either an attribute or the geometry of the feature. Update takes place when the feature is created and/or changed. |
|
|
|
| UPDATE_DATE |
Update Date |
DATE |
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. |
|
|
|
| CREATE_BY |
Create 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 |
DATE |
Database maintained field. Updates to the current data/time. Update takes place when the feature is created. |
|
|
|
| SOURCE_DATE |
Source Date |
DATE |
GIS maintained field. Date of the source document or information. |
|
|
|
| SHAPE |
Shape |
ST_GEOMETRY |
ESRI system maintained field. Stores the geometry type and geometry of the feature. |
|
|
|
| CONCRETE_PAD |
Does it sit on a concrete pad |
VARCHAR2 |
|
YesNoOnly |
N |
No; Yes |
| MAINTAINED_BY |
Maintained By |
VARCHAR2 |
Asset Steward: The division at the City of Kitchener that is the custodian/caretaker of the asset. This is the City department or Non-City group that maintains an asset. |
GISDivisionResponsible |
OPERATIONS (ROADS) |
AGREEMENT - INS - PARKING; OPERATIONS (CEMETERIES); OPERATIONS (ROADS); OPERATIONS (TURF); PARKING; PLANNING; SPORT; STORM AND SANITARY UTILITY; TRANSPORTATION PLANNING; UNKNOWN ...See GIS for a complete list... |
| OWNERSHIP |
Who owns the asset |
VARCHAR2 |
Asset Owner: Who owns the feature, Generally Government agencies such as CITY, REGION and MTO and private citizens and businesses shown as PUBLIC. This usually relates to the property the asset sits on. |
GISDivisionResponsible |
OPERATIONS (PARKS) |
AGREEMENT - INS - PARKING; OPERATIONS (CEMETERIES); OPERATIONS (ROADS); OPERATIONS (TURF); PARKING; PLANNING; SPORT; STORM AND SANITARY UTILITY; TRANSPORTATION PLANNING; UNKNOWN ...See GIS for a complete list... |
| PUBLIC_ACCESS |
Is the garbage available for public use |
VARCHAR2 |
|
YesNoOnly |
Y |
No; Yes |
| COLLECTION_DAY |
COLLECTION_DAY |
VARCHAR2 |
|
GarbageCanDay |
|
Friday; Monday; NA; Saturday; Sunday; Thursday; Tuesday; Wednesday |
| COLLECTION_FREQUENCY |
COLLECTION_FREQUENCY |
VARCHAR2 |
|
GarbageCanSchedule |
|
2X Weekly; 3X Weekly; As Required; NA; Weekly |
| COLLECTION_SEQUENCE |
COLLECTION_SEQUENCE |
NUMBER |
|
|
|
|
| COLLECTION_ROUTE |
COLLECTION_ROUTE |
VARCHAR2 |
|
|
|
|
| TRANSIT_STOP |
Is garbage can located at a transit stop |
VARCHAR2 |
|
YesNoOnly |
N |
No; Yes |
