← All datasets

# curated.infra_adopt_drain_unavailable
Adopt-a-Drain: drains already adopted or not adoptable (57,372 rows; category: Infrastructure & drainage; geometry column `geom` (Point, EPSG:4326))
Fields (expression | type | filled/distinct in a sample | values or examples):
- objectid | bigint | 5000/5000 | e.g.: 48562; 53752; 23275
- attrs->>'ADDRESS' | null | 1552/1525 | e.g.: 400, Cannot perform query. Invalid query parameters.; 4044 AIRLINE DR, HOUSTON, 77022; 4325 BRITTMOORE RD, HOUSTON, 77041
- attrs->>'created_date' | null | 4970/1066 | e.g.: 1215820800000; 1331510400000; 1331769600000
- attrs->>'Enabled' | number | 4967/2 | values: 1; 0
- attrs->>'INSTALLDATE' | number | 1604/272 | e.g.: 1240790400000; 1262822400000; 1245024000000
- attrs->>'last_edited_date' | null | 4970/3271 | e.g.: 1572276441000; 1572276383000; 1572276375000
attrs values are text: cast when comparing numbers, e.g. (attrs->>'PCI')::numeric.