|
Table Name
|
Column Name
|
Column Type
|
Column Width
|
Sample Domain Value
|
Definition
|
|
garbage_collection_schedules_pdx
|
--
|
--
|
--
|
--
|
|
|
|
Terrain
|
String
|
5
|
--
|
"T" indicates the area is within the "Westside Terrain Surcharge Area"
|
|
|
G_ICD_N
|
Date
|
36
|
--
|
The "initial collection date" of garbage in each schedule area effective 10/31/2011 (used by the online collection calendar)
|
|
|
R_Sched_N
|
Date
|
254
|
--
|
The recycling collection frequency in each schedule area (effective 10/31/2011)
|
|
|
|
|
|
W
|
Weekly collection
|
|
|
R_ICD_N
|
Date
|
36
|
--
|
The "initial collection date" of recycling in each schedule area effective 10/31/2011 (used by the online collection calendar)
|
|
|
C_Sched_N
|
Date
|
254
|
--
|
The composting collection frequency in each schedule area (effective 10/31/2011)
|
|
|
|
|
|
W
|
Weekly collection
|
|
|
C_ICD_N
|
Date
|
36
|
--
|
The "initial collection date" of composting in each schedule area effective 10/31/2011 (used by the online collection calendar)
|
|
|
MC_Sched_N
|
Date
|
254
|
--
|
The "monthly" garbage collection frequency effective 10/31/2011
|
|
|
|
|
|
EFW
|
Every-four-week garbage collection
|
|
|
OBJECTID
|
Integer
|
4
|
--
|
Unique numeric ID for each collection area
|
|
|
Coll_Day_N
|
Integer
|
254
|
--
|
The day of the week garbage, recycling, and composting is collected (effective 10/31/2011)
|
|
|
Coll_Cal_N
|
Integer
|
254
|
--
|
The garbage collection "calendar" for the collection schedule area (effective 10/31/2011)
|
|
|
|
|
|
Orange
|
The area is on an "orange" (a.k.a., "even") garbage collection schedule
|
|
|
|
|
|
Purple
|
The area is on an "purple" (a.k.a., "odd") garbage collection schedule
|
|
|
G_Sched_N
|
Integer
|
254
|
--
|
The garbage collection frequency in each schedule area (effective 10/31/2011)
|
|
|
|
|
|
EOW
|
Evey-other-week garbage collection
|
|
|
Website
|
String
|
50
|
--
|
The hauler website (where applicable)
|
|
|
Phone_Num
|
Integer
|
254
|
--
|
The hauler phone number
|
|
|
Hauler
|
Integer
|
254
|
--
|
Hauler name
|
|
|
Coll_Day
|
Date
|
254
|
--
|
The day of the week garbage, recycling, and compost is collected (through 10/30/2011)
|
|
|
Coll_Cal
|
Date
|
254
|
--
|
The compost collection calendar for the collection schedule area (through 10/30/2011)
|
|
|
|
|
|
Orange
|
The area uses the "orange" (a.k.a., "even") yard debris collection calendar
|
|
|
|
|
|
Purple
|
The area uses the "purple" (a.k.a., "odd") yard debris collection calendar
|
|
|
|
|
|
Pilot
|
The area is within the "Food Scrap Collection" pilot area; collection calendars are unique to the individual haulers.
|
|
|
G_Sched
|
Date
|
254
|
--
|
The garbage collection frequency in each schedule area (through 10/30/2011)
|
|
|
|
|
|
W
|
Weekly garbage collection
|
|
|
|
|
|
EOW
|
Every-Other-Week garbage collection (currently food scrap pilot areas only)
|
|
|
G_ICD
|
Date
|
36
|
--
|
The "initial collection date" of garbage in each schedule area through 10/30/2011 (used by the online collection calendar)
|
|
|
R_Sched
|
Date
|
254
|
--
|
The recycling collection frequency in each schedule area (through 10/30/2011)
|
|
|
|
|
|
W
|
Weekly recycling collection
|
|
|
|
|
|
EOW
|
Every-Other-Week recycling collection (food scrap pilot areas only)
|
|
|
R_ICD
|
Date
|
36
|
--
|
The "initial collection date" of recycling in each schedule area through 10/30/2011 (used by the online collection calendar)
|
|
|
Comp_Sched
|
String
|
15
|
--
|
The compost (yard debris, and yard debris/food scraps in the food scrap pilot area) collection frequency in each schedule area (through 10/30/2011)
|
|
|
|
|
|
W
|
Weekly compost collection (currently food scrap pilot areas only)
|
|
|
|
|
|
EOW
|
Every-Other-Week compost collection
|
|
|
Comp_ICD
|
Date
|
36
|
--
|
The "initial collection date" of compost in each schedule area through 10/30/2011 (used by the online collection calendar)
|
|
|
Edit_Date
|
Date
|
36
|
--
|
The date of the last modification to the collection schedule area
|
|
|
Edit_Name
|
Date
|
254
|
--
|
The name of the individual who made the last changes to the collection schedule area
|
|
|
Review
|
String
|
254
|
--
|
"True" indicates the area needs to be further reviewed by City of Portland staff or the garbage hauler
|
|
|
MC_Sched
|
Date
|
10
|
--
|
The "monthly" garbage collection frequency through 10/30/2011
|
|
|
|
|
|
FCD
|
Monthly garbage collected on the first weekly garbage collection day of the month
|
|
|
|
|
|
LCD
|
Monthly garbage collected on the last weekly garbage collection day of the month
|
|
|
TrackIT_UR
|
String
|
150
|
--
|
A link to any "collection error report" item in TrackIT (for internal City of Portland use only)
|
|
|
Notes
|
String
|
150
|
--
|
Any notes related to the collection schedule area
|