← 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.: 169217; 209126; 177489
- attrs->>'Adopteddate' | null | 118/118 | e.g.: 1602875379000; 1530204413000; 1533172475000
- attrs->>'Assetstatus' | string | 5000/2 | values: Available; Adopted
- attrs->>'condition' | string | 3/1 | values: No Issues
- attrs->>'CouncilDistrict' | string | 4991/12 | values: C; D; I; E; K;  ; H; B; G; A; F; J
- attrs->>'DateLoaded' | number | 5000/26 | e.g.: 1520207146000; 1610400176000; 1536657737000
- attrs->>'FACILITYID' | null | 9/9 | values: cIN-0130121; cIN-0130124; cIN-0130218; cIN-0130117; cIN-0130213; cIN-0130249; cIN-0130216; cIN-0130243; cIN-0130251
- attrs->>'Laststatusupdate' | number | 207/130 | e.g.: 1689166983000; 1694032819000; 1684526424000
- attrs->>'Nickname' | string | 109/108 | e.g.: Stormy Drainiels; Sparks3; THE DRAINPENING 
- attrs->>'publicview' | string | 3/1 | values: Yes
- attrs->>'RelateGUID' | null | 118/102 | e.g.: {19BFF4CE-C6AC-4E68-AADB-0D18AF5F8422}; {FE0E9E67-DE1D-4218-A8FB-6BA4E3FD6CEA}; {AA090AB7-9B13-4DC0-8994-9688C4BCA123}
attrs values are text: cast when comparing numbers, e.g. (attrs->>'PCI')::numeric.