← All datasets

# curated.service_request_311
Houston 311 service requests 2011-2026 (5.6M), typed columns, from the city's 311 archive (5,592,467 rows; category: 311 service requests; geometry column `geom` (Point, EPSG:4326))
Notes: One row per request. case_type is the request type (e.g. 'Pothole', 'Drainage', 'Water Leak', 'Trash Dumping or Illegal Dumpsite', 'Missed Garbage Pickup'; flood-related: 'Flooding', 'Drainage', 'Poor Drainage', 'Roadside Ditch Maintenance', 'Storm Sewer Repair'; environmental: 'Air Pollution' (11,037 resident complaints 2011-2026), 'Water or Ground Pollution' (2,085) — check distinct values with ILIKE first). created_local/closed_local timestamps: resolution time = closed_local - created_local. super_neighborhood (UPPER CASE) and council_district (letter) are already attached. 2011 is a partial year; 2026 is year-to-date. ~4% of rows have no geom. Large table: always filter by case_type and/or date before spatial joins.

Fields (expression | type | filled/distinct in a sample | values or examples):
- case_number | text | 5000/5000 | e.g.: 2600016031; 12053164-101002304726; 101001634021
- case_number_365 | text | 4999/4999 | e.g.: 2600016031; 101000607394; 101001634021
- source_schema | text | 5000/2 | values: d365; harvey
- status | text | 5000/19 | e.g.: Service Completed; Merged; SWM Can Delivered
- created_local | timestamp without time zone | 5000/4990 | e.g.: 2013-01-27 05:55:47; 2020-09-09 02:48:06; 2025-07-16 14:27:01
- closed_local | timestamp without time zone | 4945/4896 | e.g.: 2016-05-16 11:00:11; 2013-04-23 16:07:20; 2017-09-11 08:55:28
- resolve_by | timestamp without time zone | 3638/3481 | e.g.: 2022-01-17 23:00:00; 2019-07-02 22:00:00; 2023-01-12 23:00:00
- case_type | text | 5000/188 | e.g.: Water Leak; Missed Garbage Pickup; Sewer Wastewater
- title | text | 5000/2250 | e.g.: Repair or Replace Damaged or Missing Container; Missed Garbage Collection; Sewer Wastewater
- department | text | 5000/14 | e.g.: Public Works; Solid Waste Management; Neighborhoods
- division | text | 5000/33 | e.g.: Collections; Houston Water; Transportation Drainage Operations
- service_area | text | 4807/6 | values: NW; SW; NE; SE; GNEHSA; IAH
- council_district | text | 4805/11 | values: C; D; B; H; I; K; A; E; G; F; J
- key_map | text | 4826/873 | e.g.: 492R; 493L; 493S
- super_neighborhood | text | 4788/91 | e.g.: GREATER HEIGHTS; ALIEF; CENTRAL SOUTHWEST
- management_district | text | 2123/37 | e.g.: Greater Northside MD; Spring Branch MD; East End MD
- channel | text | 5000/11 | values: Phone; Portal; Not Applicable; App; Email; SCF; In Person; SMS; Voice In; Chat; Fax
- incident_address | text | 4829/4720 | e.g.: 12600 BRIAR FOREST DR 1420 S DAIRY ASHFORD RD 77077; 1000 HOLCOMBE BLVD 2100 W HOLCOMBE BLVD 6800 MAIN ST 77030; 1231 ANSBURY DR HOUSTON 77018
- incident_street | text | 4827/4696 | e.g.: 1000 HOLCOMBE BLVD 2100 W HOLCOMBE BLVD 6800 MAIN ST; 13400 ALMEDA RD 2 ALMEDA GENOA RD 2900 W FUQUA ST; 12600 BRIAR FOREST DR 1420 S DAIRY ASHFORD RD
- zip | text | 4825/105 | e.g.: 77009; 77007; 77004
- geocode_precision | text | 5000/3 | values: source_point; failed; address