← 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.: 43309; 6304; 43602
- ufid | integer | 5000/5000 | e.g.: 3317213; 2980785; 7840937
- facilityid | text | 5000/5000 | e.g.: 3317213; 2980785; 7840937
- address | text | 1026/1014 | e.g.: 400, Cannot perform query. Invalid query parameters.; 7849 N SH 6, UNINCORPORATED, 77095; 0 TWILIGHT SHADOW LN
- installdate | timestamp with time zone | 1080/243 | e.g.: 2004-03-01 06:00:00+00; 2009-06-15 06:00:00+00; 2007-09-11 06:00:00+00
- inlet_type | text | 4985/11 | values: BB; B; Other; A; C1; E; C2; C; H2; D; Tree Box
- inlet_type_label | text | 4985/11 | values: BB Inlet; B Inlet; Other; A Inlet; C1 Inlet; E Inlet; C2 Inlet; C Inlet; H2 Inlet; D Inlet; Tree Box
- owned_by_code | smallint | 4962/3 | values: 1; -2; -1
- owned_by | text | 4962/3 | values: City; Other; Private
- maint_by_code | smallint | 4962/3 | values: 1; -2; -1
- maint_by | text | 4962/3 | values: City; Other; Private
- council_district | text | 4570/11 | values: D; C; B; A; H; I; K; G; E; F; J
- inlet_material | text | 1519/5 | values: CP; RCP; BR; PVC; Reinforced Concrete
- lon | double precision | 5000/5000 | e.g.: -95.48666628193597; -95.24312487278543; -95.2724861533227
- lat | double precision | 5000/5000 | e.g.: 29.601975807316354; 29.97581917039903; 29.708238891974716