← All datasets

# curated.dev_scps_permit
SCPS permits issued in the past year (11,103 rows; category: Permits & development; geometry column `geom` (Point, EPSG:4326))
Fields (expression | type | filled/distinct in a sample | values or examples):
- objectid | bigint | 5000/5000 | e.g.: 3542; 3226; 2880
- attrs->>'ADDR_TYPE' | string | 4839/2 | values: StreetAddress; PointAddress
- attrs->>'APPROVEDDATE' | number | 5000/4814 | e.g.: 1583366400000; 1588032000000; 1578960000000
- attrs->>'ARC_STREET' | string | 5000/4828 | e.g.: 716 PINEMONT; 703 BRINGHURST STREET; 3600 W ALABAMA
- attrs->>'ARC_ZIP' | string | 5000/114 | e.g.: 77007; 77004; 77002
- attrs->>'CBD' | string | 2923/2 | values: N; Y
- attrs->>'CERT' | null | 3706/3702 | e.g.: 1594118147000; 1589788544000; 1586165045000
- attrs->>'COMPANYID' | number | 5000/214 | e.g.: 757; 467; 2510
- attrs->>'COMPANYNAME' | string | 5000/214 | e.g.: Centerpoint Energy Entex; Future Telecom, Inc.; Ervin Cable Construction LLC
- attrs->>'CONTRACTOR' | string | 1544/130 | e.g.: DIGCO UTILITY CONSTRUCTION, LLC; PM CONSTRUCTION & REHAB, LP; MJ SHERIDAN OF TEXAS
- attrs->>'COUNCILDISTRICT' | string | 3147/11 | values: D; G; H; I; C; B; A; F; E; N/A;  N/A
- attrs->>'DWGLISTOTHER' | null | 4678/4670 | e.g.: Drawing List:NA

Number of Excavations:1, 8X8X6, WORKING IN ; Drawing List:   N/A

Number of Excavations:

Block Numbers:	; Drawing List:

Number of Excavations:

Block Numbers:	KEY MA
- attrs->>'EXCAVATIONADDRESS' | string | 5000/4833 | e.g.: 1906 WROXTON RD 77005; 1616 POST OAK BLVD 77056; 3600 W ALABAMA 77027
- attrs->>'EXCAVATIONMETHOD' | null | 4678/4 | values: Open Cut; Multiple; Bore; Tunnel
- attrs->>'EXCAVPURPOSE' | null | 4678/2616 | e.g.: WATER REPAIR TO RELIEVE THE NECESSITY OF THE CUSTOMER; Installing Brand new fiber optic cable for MCI/METRO; WRAP
Repair Service line Waterline 
S-000MAO-0045-4 
ALEX RO
- attrs->>'EXCSTARTDATE' | number | 5000/348 | e.g.: 1586131200000; 1597622400000; 1597017600000
- attrs->>'EXCSTOPDATE' | number | 5000/407 | e.g.: 1603411200000; 1608595200000; 1606003200000
- attrs->>'FACILMAINTDESC' | string | 4678/3496 | e.g.: install 1" water tap; One optional ground mounted equipment cabinet will be instal; REPAIR ON WATER MAIN
- attrs->>'INTERST' | string | 5000/3546 | e.g.: Richmond Ave; Westheimer Rd; Westheimer
- attrs->>'ISSUEDDATE' | number | 5000/5000 | e.g.: 1578300008000; 1576773174000; 1591873028000
- attrs->>'KEYMAP' | string | 4873/768 | e.g.: 493Q; 492R; 492G
- attrs->>'LOC_NAME' | string | 4839/2 | values: GHC911_ROADS_L; AddressPointIn
- attrs->>'MATCH_ADDR' | null | 4839/4421 | e.g.: 4700 PINEMONT DR, HOUSTON, 77018; 3600 W ALABAMA ST, HOUSTON, 77027; 5300 CRAWFORD ST, HOUSTON, 77004
- attrs->>'MATCH_TYPE' | string | 5000/1 | values: A
- attrs->>'OWNER' | string | 5000/214 | e.g.: CENTERPOINT ENERGY ENTEX; FUTURE TELECOM, INC.; ERVIN CABLE CONSTRUCTION LLC
- attrs->>'PERMITNUMBER' | string | 5000/4882 | e.g.: SCPS-436124-0; SCPS-436186-0; SCPS-440466-0
- attrs->>'PERMITSTATUS' | string | 5000/5 | values: ISSUED - FEE PAID; ISSUED; CANCELLED; CLOSED; MARKED COMPLETE PENDING REVIEW
- attrs->>'PERMITTYPE' | string | 5000/3 | values: SP; EP; SPP
- attrs->>'PERMITTYPEID' | number | 5000/3 | values: 1; 2; 11
- attrs->>'PERMITTYPENAME' | string | 5000/3 | values: Scheduled ; Emergency ; Steel Plate
- attrs->>'SCORE' | number | 5000/36 | e.g.: 100; 89.04; 0
- attrs->>'SIDE' | string | 4807/2 | values: R; L
- attrs->>'STATUS' | string | 5000/3 | values: M; T; U
- attrs->>'STREETADDRESS' | string | 5000/4828 | e.g.: 716 PINEMONT; 703 BRINGHURST STREET; 3600 W ALABAMA
- attrs->>'SUBMITDATE' | number | 5000/4854 | e.g.: 1599004800000; 1599523200000; 1583280000000
- attrs->>'USER_FLD' | null | 4839/1 | values: 0
- attrs->>'ZIPCODE' | string | 5000/114 | e.g.: 77007; 77004; 77002
attrs values are text: cast when comparing numbers, e.g. (attrs->>'PCI')::numeric.