← All datasets

# curated.infra_stormdrain_inlets_adoptable
The ~77k city-owned curb inlets (types B/BB) that residents could adopt (107,260 rows; category: Infrastructure & drainage; geometry column `geom` (Point, EPSG:4326))
Fields (expression | type | filled/distinct in a sample | values or examples):
- adopt_key | text | 5000/5000 | e.g.: geohub:stormdrain-inlets:21430; geohub:stormdrain-inlets:91420; geohub:stormdrain-inlets:52997
- objectid | integer | 5000/5000 | e.g.: 99041; 51194; 54322
- ufid | integer | 5000/5000 | e.g.: 7373693; 6055046; 3523011
- facilityid | text | 5000/5000 | e.g.: 7373693; 6055046; 3523011
- address | text | 673/669 | e.g.: 400, Cannot perform query. Invalid query parameters.; 403 GAMMON DR, HOUSTON, 77022; 214 ST EMANUEL ST, HOUSTON, 77002
- installdate | timestamp with time zone | 671/291 | e.g.: 1998-06-30 06:00:00+00; 2008-12-31 06:00:00+00; 2009-09-03 06:00:00+00
- inlet_type | text | 4994/11 | values: BB; B; Other; A; C1; E; C2; H2; D; C; BB Inlet
- inlet_type_label | text | 4993/10 | values: BB Inlet; B Inlet; Other; A Inlet; C1 Inlet; E Inlet; C2 Inlet; H2 Inlet; D Inlet; C Inlet
- owned_by | text | 5000/1 | values: City
- maint_by | text | 5000/1 | values: City
- council_district | text | 4617/11 | values: C; D; I; B; K; A; G; E; H; F; J
- inlet_material | text | 1061/5 | values: CP; RCP; BR; UNK; Reinforced Concrete
- lon | double precision | 5000/5000 | e.g.: -95.61202886172971; -95.3664465659872; -95.41273004752449
- lat | double precision | 5000/5000 | e.g.: 29.78260063445727; 29.620768413751957; 29.831219166144084