← All datasets

# curated.infra_adopt_drain_available
Adopt-a-Drain program: drains still available to adopt (81k) (81,487 rows; category: Infrastructure & drainage; geometry column `geom` (Point, EPSG:4326))
Notes: Compare with infra_adopt_drain_unavailable (already adopted or not adoptable) for adoption rates by area.
Fields (expression | type | filled/distinct in a sample | values or examples):
- objectid | bigint | 5000/5000 | e.g.: 190313; 245097; 226586
- attrs->>'Adopteddate' | null | 121/121 | e.g.: 1525491074000; 1591392723000; 1599785401000
- attrs->>'Assetstatus' | string | 5000/2 | values: Available; Adopted
- attrs->>'condition' | string | 3/1 | values: No Issues
- attrs->>'CouncilDistrict' | string | 4987/12 | values: C; D; I; G; K;  ; E; A; H; B; F; J
- attrs->>'DateLoaded' | number | 5000/18 | e.g.: 1520207146000; 1610400176000; 1651486066000
- attrs->>'FACILITYID' | null | 3/3 | values: cIN-0130249; cIN-0130243; cIN-0130247
- attrs->>'Laststatusupdate' | number | 194/125 | e.g.: 1689166983000; 1684526424000; 1694032818000
- attrs->>'Nickname' | string | 110/109 | e.g.: ; This is where my happiness went down the drain.; Sea Foam Green
- attrs->>'publicview' | string | 3/1 | values: Yes
- attrs->>'RelateGUID' | null | 121/105 | e.g.: {E0344878-B786-42AF-87D6-107793F8C2ED}; {059723C5-0173-4CA2-9990-119E3CED64A2}; {7CBDC4BA-7C17-433B-B9C5-40B5D4B7267E}
attrs values are text: cast when comparing numbers, e.g. (attrs->>'PCI')::numeric.