← 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:95721; geohub:stormdrain-inlets:28598; geohub:stormdrain-inlets:74240
- objectid | integer | 5000/5000 | e.g.: 36112; 78300; 24268
- ufid | integer | 5000/5000 | e.g.: 3404478; 3593166; 2353196
- facilityid | text | 5000/5000 | e.g.: 3404478; 3593166; 2353196
- address | text | 709/703 | e.g.: 400, Cannot perform query. Invalid query parameters.; 1901 NOCTURNE LN, HOUSTON, 77043; 6403 WHEATLEY ST, HOUSTON, 77091
- installdate | timestamp with time zone | 672/295 | e.g.: 1998-06-30 06:00:00+00; 2007-09-26 06:00:00+00; 1993-10-03 06:00:00+00
- inlet_type | text | 4990/11 | values: BB; B; Other; A; C1; E; H2; C2; D; C; Tree Box
- inlet_type_label | text | 4990/11 | values: BB Inlet; B Inlet; Other; A Inlet; C1 Inlet; E Inlet; H2 Inlet; C2 Inlet; D Inlet; C Inlet; Tree Box
- owned_by | text | 5000/1 | values: City
- maint_by | text | 4998/1 | values: City
- council_district | text | 4632/11 | values: C; D; I; K; B; G; A; E; H; F; J
- inlet_material | text | 1078/5 | values: CP; RCP; BR; UNK; PVC
- lon | double precision | 5000/5000 | e.g.: -95.49161051156177; -95.5722285136483; -95.33259841641716
- lat | double precision | 5000/5000 | e.g.: 29.83379340728751; 29.790597463199788; 29.73393227284565