Data catalog / cleansed / energov_permit
cleansed.energov_permit
Permits. 8,100 rows.
LayerCleansed
Source systemEnerGov
Data ownerDevelopment Services Director
Data stewardMichael Okafor
ClassificationInternal
RefreshNightly
RetentionCurrent version
AccessRoles R1 to R5, row policy P-01
Lineage
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 | |
valuation | double precision | |
parcel_id | text | |
address | text | Internal, generalized for viewers |
status | text | |
modified_at | timestamp without time zone | |
_run_id | text | Load metadata |
_extracted_at | timestamp without time zone | Load metadata |
business_days_to_issue | integer |
Quality rules
DQ-101 Block Issued or finaled permits have an issue date
Completeness
DQ-102 Warn Permit parcel exists in the GIS parcel layer
Referential
DQ-103 Block Issue date is on or after application date
Validity
Sample rows
| permit_no | permit_type | work_class | applied_date | issued_date | valuation | parcel_id | address | status | modified_at | _run_id | _extracted_at | business_days_to_issue |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ACC-25-00003 | Sign | Accessory | 2025-10-01 10:02:00 | 2025-10-06 11:00:00 | 4820.0 | FBCAD-244038 | 121 Brazos Landing Dr | Finaled | 2025-10-06 11:00:00 | L-20261101-0100 | 2026-11-01 01:02:22 | 3 |
| ACC-25-00005 | Pool and spa | Accessory | 2025-10-01 10:06:00 | 2025-10-13 13:00:00 | 12530.0 | FBCAD-938362 | 9085 Eldridge Rd | Finaled | 2025-10-13 13:00:00 | L-20261101-0100 | 2026-11-01 01:02:22 | 8 |
| ACC-25-00007 | Pool and spa | Accessory | 2025-10-01 10:25:00 | 2025-10-13 13:00:00 | 6310.0 | FBCAD-241257 | 7319 Sugar Creek Blvd | Finaled | 2025-10-13 13:00:00 | L-20261101-0100 | 2026-11-01 01:02:22 | 8 |
| ACC-25-00009 | Fence | Accessory | 2025-10-01 11:14:00 | 2025-10-06 09:00:00 | 12440.0 | FBCAD-706307 | 19911 Elkins Rd | Finaled | 2025-10-06 09:00:00 | L-20261101-0100 | 2026-11-01 01:02:22 | 3 |
| ACC-25-00014 | Pool and spa | Accessory | 2025-10-01 13:23:00 | 2025-10-08 11:00:00 | 8220.0 | FBCAD-688054 | 13052 Greatwood Pkwy | Finaled | 2025-10-08 11:00:00 | L-20261101-0100 | 2026-11-01 01:02:22 | 5 |
Data as of run R-20261111-0200, finished 11/11/2026 02:13 Central. Curated layer: curated schema.