← All datasets

# curated.infra_stormdrain_inlets
City storm drain inlets (130k) with type, owner and install date (129,989 rows; category: Infrastructure & drainage; geometry column `geom` (Point, EPSG:4326))
Notes: Typed columns. inlet_type 'B' and 'BB' are the curb inlets a resident can clear (the Adopt-a-Drain set); owned_by_code IN (1, -12) = city-owned. council_district attached.

Fields (expression | type | filled/distinct in a sample | values or examples):
- objectid | integer | 5000/5000 | e.g.: 54298; 48775; 68154
- ufid | integer | 4997/4997 | e.g.: 7840753; 2946315; 6251276
- facilityid | text | 5000/5000 | e.g.: 7840753; 2946315; 6251276
- address | text | 993/954 | e.g.: 400, Cannot perform query. Invalid query parameters.; 3856 N MACGREGOR WAY, HOUSTON, 77004; 9501 GRANNIS ST, HOUSTON, 77075
- installdate | timestamp with time zone | 1048/234 | e.g.: 2009-06-15 06:00:00+00; 2019-05-30 06:00:00+00; 2010-01-07 06:00:00+00
- inlet_type | text | 4996/10 | values: BB; B; Other; A; C1; E; C2; C; H2; D
- inlet_type_label | text | 4996/10 | values: BB Inlet; B Inlet; Other; A Inlet; C1 Inlet; E Inlet; C2 Inlet; C Inlet; H2 Inlet; D Inlet
- owned_by_code | smallint | 4951/3 | values: 1; -2; -1
- owned_by | text | 4951/3 | values: City; Other; Private
- maint_by_code | smallint | 4947/3 | values: 1; -2; -1
- maint_by | text | 4947/3 | values: City; Other; Private
- council_district | text | 4573/11 | values: D; C; A; H; G; K; I; E; B; J; F
- inlet_material | text | 1434/3 | values: CP; RCP; BR
- lon | double precision | 5000/5000 | e.g.: -95.43008988149866; -95.56544471024772; -95.58787076126141
- lat | double precision | 5000/5000 | e.g.: 29.84059903390543; 29.736910957391146; 29.647325475745163