← All datasets

# curated.boundary_heavy_trash_area
Heavy trash pickup areas and days (1,364 rows; category: Boundaries & demographics; geometry column `geom` (MultiPolygon, EPSG:4326))
Fields (expression | type | filled/distinct in a sample | values or examples):
- objectid | bigint | 1364/1364 | e.g.: 71; 979; 1337
- attrs->>'CONTACT' | string | 1345/1 | values: See Irma Reyes
- attrs->>'Day' | string | 1364/7 | values: Wednesday; Thursday; Friday; Tuesday; Monday; NONE; Contract
- attrs->>'DESCRIPT' | null | 1345/1 | values: See Irma Reyes
- attrs->>'DISTRICTID' | string | 1345/3 | values: NE; SE; SW
- attrs->>'Driver' | string | 1127/2 | values: ; Contract
- attrs->>'edit_date' | string | 1345/1 | values: 9/4/12
- attrs->>'EMAIL' | null | 1345/1 | values: See Irma Reyes
- attrs->>'FRIDAY' | string | 250/1 | values: YES
- attrs->>'HELP_SECTION' | string | 1345/8 | values: 1; 2; 3; 4; 5; 6; 7; 8
- attrs->>'HolidaySchedule' | string | 1345/1 | values: http://www.houstontx.gov/solidwaste/holiday.html
- attrs->>'Id' | null | 1345/1 | values: 0
- attrs->>'MONDAY' | null | 236/1 | values: YES
- attrs->>'NAME' | string | 1364/542 | e.g.: NOSERV; NE1WE_14; NE1WE_12
- attrs->>'Notes' | null | 333/5 | values: On Demand Zone 1; On Demand Zone 2; On Demand Zone 5; On Demand Zone 3; On Demand Zone 4
- attrs->>'Phase' | null | 1345/1 | values: 0
- attrs->>'Poly_ID' | string | 1364/542 | e.g.: NOSERV; NE1WE_14; NE1WE_12
- attrs->>'QUAD' | string | 1364/4 | values: NE; SE; SW; NA
- attrs->>'SCHEDULE' | null | 1345/20 | e.g.: 3rd Wednesday; 1st Wednesday; 4th Wednesday
- attrs->>'SERVICE_DA' | string | 1364/22 | e.g.: 3rd Wednesday; 1st Wednesday; 4th Wednesday
- attrs->>'SERVICE_TY' | string | 1364/3 | values: HT; CR; Con
- attrs->>'Service_WK' | string | 1346/5 | values: 1st; 4th; 3rd; 2nd; Contract
- attrs->>'Supervisor' | string | 1127/2 | values: ; Contract
- attrs->>'THURSDAY' | string | 259/1 | values: YES
- attrs->>'TUESDAY' | null | 242/1 | values: YES
- attrs->>'WEDNESDAY' | null | 358/1 | values: YES
- attrs->>'WEEKFOUR' | null | 340/1 | values: YES
- attrs->>'WEEKONE' | string | 359/1 | values: YES
- attrs->>'WEEKTHREE' | string | 335/1 | values: YES
- attrs->>'WEEKTWO' | string | 311/1 | values: YES
attrs values are text: cast when comparing numbers, e.g. (attrs->>'PCI')::numeric.