← 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.: 3542; 247; 2880
- attrs->>'Date' | number | 5000/717 | e.g.: 1684972800000; 1625788800000; 1635120000000
- attrs->>'Loc_name' | string | 4985/3 | values: PDD_POINTS; PDD_ROADS; 
- attrs->>'Match_type' | string | 5000/3 | values: A; M; PP
- attrs->>'MERGE_SRC' | string | 5000/4 | values: Sidewalk_Permits_2022; Sidewalk_Permits_2021; Sidewalk_Permits_2023; Sidewalk_Permits_2020
- attrs->>'Score' | number | 4985/72 | e.g.: 100; 98.95; 98.89
- attrs->>'SECTOR' | number | 4977/17 | e.g.: 3; 14; 8
- attrs->>'Square_Miles' | number | 4977/17 | e.g.: 42.18132184; 38.71480785; 25.873495
- attrs->>'Status' | string | 5000/3 | values: M; m; U
- attrs->>'USER_Appplicant_Name' | string | 5000/890 | e.g.: CANADA             KARLA       S; VARGAS             MARIA; BUCKWALTER         JACOB
- attrs->>'USER_Bldg_Cat' | null | 4996/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/4 | values: New Construction; Remodel; *UNDEFINED*; Shell
- attrs->>'USER_Const_Type' | string | 4996/3 | values: N; R; S
- attrs->>'USER_Length' | number | 5000/313 | e.g.: 1; 50; 2
- attrs->>'USER_LOT_AREA' | null | 421/222 | e.g.: 5000; 10000; 6000
- attrs->>'USER_LOT_DEPTH' | null | 397/102 | e.g.: 100; 120; 110
- attrs->>'USER_LOT_FEET_ACRES' | string | 4997/2 | values: F; A
- attrs->>'USER_LOT_FRONT' | string | 397/70 | e.g.: 50; 60; 100
- attrs->>'USER_LOT_NO' | string | 2631/267 | e.g.: 1; 2; 3
- attrs->>'USER_MAP_NO' | string | 207/166 | e.g.: RES A; 2A; 17A
- attrs->>'USER_MAX_Permit_Fees' | number | 5000/335 | e.g.: 83.24; 124.86; 128.16
- attrs->>'USER_Paid_Date' | string | 5000/717 | e.g.: 05/25/2023; 10/25/2021; 07/09/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/1080 | e.g.: 05/24/2022; 10/06/2022; 01/11/2021
- attrs->>'USER_Project' | string | 5000/4987 | e.g.: 22040111; 20087218; 21028048
- attrs->>'USER_Project_Address' | string | 5000/4981 | e.g.: 738 BRITTMOORE RD 77079; 8849 EDGEBROOK ST 77075; 8614 TEXAS ACORN AVE 77078
- attrs->>'USER_Project_Description' | string | 5000/1783 | e.g.: S.F. RES W/ATT. GARAGE (1-2-5-R3-B) 12 IRC/15 IECC; S.F. RES - NO GARAGE - (1-1-5-R3-B) 12 IRC/15 IECC; S.F. RES W/ATT. GARAGE (1-1-5-R3-B) 12 IRC/15 IECC
- attrs->>'USER_Receipt' | string | 5000/5000 | e.g.: 8335394; 8439757; 8146097
- attrs->>'Zip_Code' | string | 4985/91 | e.g.: 77048; 77016; 77028
attrs values are text: cast when comparing numbers, e.g. (attrs->>'PCI')::numeric.