← All datasets

# curated.dev_sidewalk_permit
Sidewalk permits Oct 2020 - Jun 2023 (10,233 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.: 3202; 5917; 8362
- attrs->>'Date' | number | 5000/722 | e.g.: 1640044800000; 1625788800000; 1684972800000
- attrs->>'Loc_name' | string | 4990/2 | values: PDD_POINTS; PDD_ROADS
- attrs->>'Match_type' | string | 5000/2 | values: A; M
- attrs->>'MERGE_SRC' | string | 5000/4 | values: Sidewalk_Permits_2022; Sidewalk_Permits_2021; Sidewalk_Permits_2023; Sidewalk_Permits_2020
- attrs->>'Score' | number | 4990/76 | e.g.: 100; 98.95; 99
- attrs->>'SECTOR' | number | 4982/17 | e.g.: 3; 14; 8
- attrs->>'Square_Miles' | number | 4982/17 | e.g.: 42.18132184; 38.71480785; 25.873495
- attrs->>'Status' | string | 5000/3 | values: M; m; U
- attrs->>'USER_Appplicant_Name' | string | 5000/895 | e.g.: CANADA             KARLA       S; VARGAS             MARIA; BUCKWALTER         JACOB
- attrs->>'USER_Bldg_Cat' | null | 4997/4 | values: 3; O; B; 1
- attrs->>'USER_Building_Category' | string | 5000/5 | values: Residential 1 Or 2 Families; Other Structure; Other Building; Residential 3 Or More Families; *UNDEFINED*
- attrs->>'USER_Construction_Type' | string | 5000/5 | values: New Construction; Remodel; *UNDEFINED*; Shell; Single Trade
- attrs->>'USER_Const_Type' | string | 4998/4 | values: N; R; S; T
- attrs->>'USER_Length' | number | 5000/317 | e.g.: 1; 50; 2
- attrs->>'USER_LOT_AREA' | null | 382/195 | e.g.: 5000; 10000; 6000
- attrs->>'USER_LOT_DEPTH' | null | 355/88 | e.g.: 100; 120; 110
- attrs->>'USER_LOT_FEET_ACRES' | string | 4997/2 | values: F; A
- attrs->>'USER_LOT_FRONT' | string | 355/70 | e.g.: 50; 60; 100
- attrs->>'USER_LOT_NO' | string | 2609/274 | e.g.: 1; 2; 3
- attrs->>'USER_MAP_NO' | string | 189/149 | e.g.: RES A; 6; 2A
- attrs->>'USER_MAX_Permit_Fees' | number | 5000/333 | e.g.: 83.24; 124.86; 128.16
- attrs->>'USER_Paid_Date' | string | 5000/722 | e.g.: 07/09/2021; 05/25/2023; 12/21/2021
- attrs->>'USER_Permit_Fee_Description' | string | 5000/2 | values: Sidewalk,DW,PV; Drive/Sidewalk
- attrs->>'USER_Permit_Type_Code' | string | 5000/2 | values: 15; SW
- attrs->>'USER_Permit_Type_Code1' | string | 5000/2 | values: 15; SW
- attrs->>'USER_Proj_Appln_Date' | string | 5000/1068 | e.g.: 05/24/2022; 03/30/2022; 01/11/2021
- attrs->>'USER_Project' | string | 5000/4987 | e.g.: 21027003; 22029999; 21069375
- attrs->>'USER_Project_Address' | string | 5000/4978 | e.g.: 10518 VINCA MINOR LN 77016; 4219 KNOXVILLE ST 77051; 916 WAVERLY ST 77008
- attrs->>'USER_Project_Description' | string | 5000/1799 | e.g.: S.F. RES W/ATT. GARAGE (1-2-5-R3-B) 12 IRC/15 IECC; S.F. RES W/ATT. GARAGE (1-1-5-R3-B) 12 IRC/15 IECC; S.F. RES - NO GARAGE - (1-1-5-R3-B) 12 IRC/15 IECC
- attrs->>'USER_Receipt' | string | 5000/5000 | e.g.: 8439757; 8479005; 8581280
- attrs->>'Zip_Code' | string | 4990/89 | e.g.: 77048; 77016; 77028
attrs values are text: cast when comparing numbers, e.g. (attrs->>'PCI')::numeric.