← All datasets

# curated.streets_active_pothole
Currently open pothole reports (60 rows; category: Streets & traffic; geometry column `geom` (Point, EPSG:4326))
Fields (expression | type | filled/distinct in a sample | values or examples):
- objectid | bigint | 60/60 | e.g.: 34; 18; 2
- attrs->>'CANCEL' | string | 60/1 | values: N
- attrs->>'DATEDISPATCHTO' | number | 21/21 | e.g.: 1786975430000; 1788531404000; 1789138562000
- attrs->>'DATEINVTDONE' | null | 14/14 | e.g.: 1788170699000; 1789814103000; 1788262417000
- attrs->>'DATESUBMITTO' | null | 59/59 | e.g.: 1789575151000; 1789994868000; 1790232836000
- attrs->>'DATETIMEINIT' | number | 60/60 | e.g.: 1789575151000; 1789994868000; 1790232836000
- attrs->>'DESCRIPTION' | string | 60/1 | values: ROW - Pothole
- attrs->>'DETAILS' | string | 60/60 | e.g.: Service 240 record locked for transfer to Houston Cityworks ; Service 240 record locked for transfer to Houston Cityworks ; Service 240 record locked for transfer to Houston Cityworks 
- attrs->>'DISPATCHTO' | null | 21/5 | values: HAYES, ROY; BUSBY, JEROLD; MORRIS, ELROYAL; POOLE, ROBERT; HOWARD, VIVIAN
- attrs->>'DISPATCHTOSID' | number | 21/5 | values: 25284; 18662; 19024; 24678; 18591
- attrs->>'DOMAINID' | number | 60/1 | values: 2
- attrs->>'EFFORT' | number | 60/1 | values: 0
- attrs->>'EXCURSION' | string | 60/1 | values: N
- attrs->>'FIELDINVTDONE' | string | 60/2 | values: N; Y
- attrs->>'INITIATEDBY' | string | 60/1 | values: soa, soa
- attrs->>'INITIATEDBYAPP' | string | 60/1 | values: INTERNAL
- attrs->>'INITIATEDBYSID' | number | 60/1 | values: 23815
- attrs->>'LABORCOST' | number | 60/1 | values: 0
- attrs->>'MAPPAGE' | string | 60/54 | e.g.: 577N      ; 492Y      ; 492X      
- attrs->>'NUM4' | number | 60/40 | e.g.: 29.62; 29.73; 29.78
- attrs->>'NUM5' | number | 60/39 | e.g.: -95.41; -95.43; -95.4
- attrs->>'PRIORITY' | string | 60/1 | values: 3
- attrs->>'PRJCOMPLETEDATE' | number | 60/60 | e.g.: 1786873835000; 1790453763000; 1789413081000
- attrs->>'PROBADDRESS' | string | 60/60 | e.g.: 5601?5609 WESTPARK DR; 8609 CADDO RD; 3406 FONDREN RD
- attrs->>'PROBADDTYPE' | string | 60/1 | values: A
- attrs->>'PROBCITY' | string | 60/3 | values: HOUSTON; WEST UNIVERSITY PLACE; UNINCORPORATED
- attrs->>'PROBDISTRICT' | null | 51/11 | values: C; D; B; E; F; I; H; G; J; K; A
- attrs->>'PROBLEMCODE' | string | 60/1 | values: ROW - Pothole
- attrs->>'PROBLEMSID' | number | 60/1 | values: 20612
- attrs->>'PROBZIP' | string | 60/37 | e.g.: 77008; 77034; 77007
- attrs->>'REQCATEGORY' | string | 60/2 | values: GENERAL; STORMSEWER
- attrs->>'REQCUSTFIELDCATID' | number | 60/1 | values: 19
- attrs->>'REQUESTID' | number | 60/60 | e.g.: 12802963; 12800725; 12801001
- attrs->>'RESOLUTION' | string | 8/3 | values: CORRET MAINTENANCE; RTOCM; SFR
- attrs->>'SHOP' | null | 58/4 | values: SW; NW; SE; NE
- attrs->>'SRX' | number | 60/60 | e.g.: -10622619.109; -10619805.937; -10640917.476
- attrs->>'SRY' | number | 60/60 | e.g.: 3455734.284; 3472374.559; 3453250.319
- attrs->>'STATUS' | string | 60/2 | values: PREPAIR; OPEN
- attrs->>'STREETNAME' | string | 60/60 | e.g.: GREENSPOINT DR 11816-11836 ; WAKEFOREST AVE 4759?4799 ; FONDREN RD 3406 
- attrs->>'SUBMITTO' | null | 59/2 | values: SEC-ASPHALT STREET, MAINTENANCE; SEC-STORM SEWER, REPAIR
- attrs->>'SUBMITTOSID' | null | 59/2 | values: 24056; 24067
- attrs->>'TEXT1' | string | 60/60 | e.g.: 2600307800-01; 2600299653-01; 2600279537-01
- attrs->>'TEXT13' | null | 30/7 | values: Roller crew; Roller crew ; Roller Crew ; Refer to roller crew ; A work order has been created for maintenance repairs.; Roller crew needs ;  
- attrs->>'TEXT14' | string | 16/2 | values: No customer contact information provided ; Customer did not answer 
- attrs->>'TILENO' | string | 60/50 | e.g.: 5256d; 5851a; 5359c
- attrs->>'WONEEDED' | string | 60/2 | values: N; Y
attrs values are text: cast when comparing numbers, e.g. (attrs->>'PCI')::numeric.