← All datasets

# curated.dev_mobility_permit
Mobility (lane closure) permits (1,448 rows; category: Permits & development; geometry column `geom` (MultiLineString, EPSG:4326))
Fields (expression | type | filled/distinct in a sample | values or examples):
- objectid | bigint | 1448/1448 | e.g.: 71; 979; 1337
- attrs->>'COMPANYNAME' | string | 1448/208 | e.g.: Resicom, Inc.; Harper Brothers Construction; DL Glover Utilities LLC
- attrs->>'COMPLETIONDATE' | number | 1448/106 | e.g.: 1790812800000; 1790726400000; 1793491200000
- attrs->>'COUNCIL' | string | 1448/10 | values: D; I; H; G; C; A; B; F; E; null
- attrs->>'DAILYORCONTINUOUS' | string | 1448/2 | values: CONTINUOUS; DAILY
- attrs->>'DATEFROM' | number | 1448/118 | e.g.: 1788220800000; 1790812800000; 1785542400000
- attrs->>'DATETO' | number | 1448/69 | e.g.: 1790726400000; 1790812800000; 1790899200000
- attrs->>'ENDINGBLOCK' | string | 1448/142 | e.g.: 2100; 700; 2000
- attrs->>'ISSUEDDATE' | number | 1273/93 | e.g.: 1790208000000; 1788998400000; 1785801600000
- attrs->>'KEYMAP' | string | 1448/337 | e.g.: 492V; 493T; 493S
- attrs->>'LANESBLOCKED' | number | 861/5 | values: 1; 2; 3; 4; 5
- attrs->>'PERMITNUMBER' | number | 1448/1448 | e.g.: 355344; 354832; 353725
- attrs->>'PERMITSTATUS' | string | 1448/6 | values: PAID/ISSUED; APPROVED; SUBMITTED; DENIED; ACCEPTED; PENDING
- attrs->>'PERMITTYPE' | string | 1448/2 | values: Roadway Obstruction; Sidewalk Impairment
- attrs->>'PHONE' | string | 1448/208 | e.g.: 713-666-7775; 713-893-4590; 281-948-6254
- attrs->>'SIDEOFSTREET' | string | 1448/6 | values: North; South; East; Both North/South; West; Both East/West
- attrs->>'STARTINGBLOCK' | string | 1448/145 | e.g.: 2000; 600; 1700
- attrs->>'STREETNAME' | string | 1448/593 | e.g.: LOUISIANA ST; W ALABAMA ST; WESTHEIMER RD
- attrs->>'SW_OBSTRUCTION' | null | 587/2 | values: Full; Partial
- attrs->>'TIMEFROM' | string | 1448/15 | e.g.: 12:00 AM; 8:00 AM; 9:00 AM
- attrs->>'TIMETO' | string | 1448/17 | e.g.: 11:00 PM; 5:00 PM; 4:00 PM
- attrs->>'ZIPCODE' | string | 1448/88 | e.g.: 77006; 77002; 77098
attrs values are text: cast when comparing numbers, e.g. (attrs->>'PCI')::numeric.