Data catalog / curated / fact_permit
curated.fact_permit
fact permit. 8,100 rows.
LayerCurated
Source systemEnerGov
Data ownerDevelopment Services Director
Data stewardMichael Okafor
ClassificationInternal
RefreshNightly
RetentionCurrent version
AccessRoles R1 to R5, row policy P-01
Lineage
SourcePermits
Cleansedcleansed.energov_permit
SourceParcels
Cleansedcleansed.arcgis_parcel
Curatedcurated.fact_permit
Columns
| Column | Type | Classification |
|---|---|---|
permit_no | text | |
permit_type | text | |
work_class | text | |
applied_date | timestamp without time zone | |
issued_date | timestamp without time zone | |
status | text | |
valuation | double precision | |
business_days_to_issue | integer | |
parcel_id | text | |
address | text | Internal, generalized for viewers |
council_district | bigint |
Quality rules
Rules run on the cleansed source tables upstream.
Sample rows
| permit_no | permit_type | work_class | applied_date | issued_date | status | valuation | business_days_to_issue | parcel_id | address | council_district |
|---|---|---|---|---|---|---|---|---|---|---|
| TRD-26-06417 | Solar | Trade | 2026-08-17 12:06:00 | 2026-08-24 15:00:00 | Finaled | 24040.0 | 5 | FBCAD-100466 | 2315 Sweetwater Blvd | 3 |
| TRD-26-03348 | Irrigation | Trade | 2026-03-13 13:11:00 | 2026-03-16 15:00:00 | Finaled | 23090.0 | 1 | FBCAD-100466 | 2315 Sweetwater Blvd | 3 |
| ACC-26-05392 | Sign | Accessory | 2026-06-26 12:29:00 | 2026-07-02 14:00:00 | Finaled | 5080.0 | 4 | FBCAD-100898 | 11499 New Territory Blvd | 3 |
| BLD-25-00090 | Residential Building | New single family | 2025-10-06 10:31:00 | 2025-10-22 11:00:00 | Finaled | 12340.0 | 12 | FBCAD-100898 | 11499 New Territory Blvd | 3 |
| ACC-26-07092 | Fence | Accessory | 2026-09-21 11:33:00 | 2026-09-23 11:00:00 | Issued | 2990.0 | 2 | FBCAD-100947 | 10407 Eldridge Rd | 4 |
Data as of run R-20261111-0200, finished 11/11/2026 02:13 Central. Curated layer: curated schema.