← All datasets

# curated.boundary_trash_area
Automated trash pickup areas and days (1,342 rows; category: Boundaries & demographics; geometry column `geom` (MultiPolygon, EPSG:4326))
Fields (expression | type | filled/distinct in a sample | values or examples):
- objectid | bigint | 1342/1342 | e.g.: 71; 979; 1337
- attrs->>'DAY' | string | 1342/6 | values: MONDAY; FRIDAY; TUESDAY; THURSDAY; NONE; Contract
- attrs->>'DISTRICTID' | null | 1326/5 | values: NW; SW; SE; NE; 
- attrs->>'FRIDAY' | null | 358/1 | values: YES
- attrs->>'HELP_SECTION' | string | 1341/6 | values: 1; 3; 2; 4; 0; 5
- attrs->>'HolidaySchedule' | string | 1326/2 | values: http://www.houstontx.gov/solidwaste/holiday.html; 
- attrs->>'MONDAY' | string | 361/2 | values: YES; 
- attrs->>'NAME' | string | 1342/362 | e.g.: NOSERV; NWMO102; NWMO106
- attrs->>'QUAD' | string | 1342/5 | values: NW; SW; SE; NE; NA
- attrs->>'ReRoute' | null | 4/2 | values: NWTH126; NWTH125
- attrs->>'SCHEDULE' | null | 1326/5 | values: MONDAY; FRIDAY; TUESDAY; THURSDAY; 
- attrs->>'SEC_NAME' | string | 1342/362 | e.g.: NOSERV; NWMO102; NWMO106
- attrs->>'SERVICE_TYPE' | null | 16/1 | values: CR
- attrs->>'THURSDAY' | string | 267/1 | values: YES
- attrs->>'TUESDAY' | null | 340/1 | values: YES
- attrs->>'WEEKFOUR' | string | 1326/2 | values: YES; 
- attrs->>'WEEKONE' | string | 1326/2 | values: YES; 
- attrs->>'WEEKTHREE' | null | 1326/2 | values: YES; 
- attrs->>'WEEKTWO' | string | 1326/2 | values: YES; 
attrs values are text: cast when comparing numbers, e.g. (attrs->>'PCI')::numeric.