Central Data Repository City of Sugar Land, Office of Data and Innovation
PRODUCTION
Kevin Tran, Data Engineer (Data Engineer)
View as Administrator Data engineer Utilities steward Police steward
Data catalog / raw / energov_permit

raw.energov_permit

Permits. 8,307 rows.
LayerRaw
Source systemEnerGov
Data ownerDevelopment Services Director
Data stewardMichael Okafor
ClassificationInternal
RefreshNightly
RetentionAll versions, 7 years
AccessRoles R1 to R5, row policy P-01

Lineage

Columns

ColumnTypeClassification
permit_notext
permit_typetext
work_classtext
applied_datetimestamp without time zone
issued_datetimestamp without time zone
valuationdouble precision
parcel_idtext
addresstext Internal, generalized for viewers
statustext
modified_attimestamp without time zone
_run_idtext Load metadata
_extracted_attimestamp without time zone Load metadata

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_nopermit_typework_classapplied_dateissued_datevaluationparcel_idaddressstatusmodified_at_run_id_extracted_at
BLD-26-07754Commercial BuildingTenant finish out2026-10-23 14:57:002026-11-10 14:00:00528050.0FBCAD-2799223127 Palm Royale BlvdIssued2026-11-10 14:00:00R-20261111-02002026-11-11 02:02:22
BLD-26-07764Commercial BuildingTenant finish out2026-10-26 08:11:002026-11-10 14:00:0072880.0FBCAD-60422211889 Town Center BlvdIssued2026-11-10 14:00:00R-20261111-02002026-11-11 02:02:22
BLD-26-07315Commercial BuildingTenant finish out2026-10-01 11:38:002026-11-10 09:00:001750780.0FBCAD-405943158 Austin PkwyIssued2026-11-10 09:00:00R-20261111-02002026-11-11 02:02:22
BLD-26-07489Commercial BuildingNew construction2026-10-12 08:02:002026-11-10 11:00:00104860.0FBCAD-50461711129 Lexington BlvdIssued2026-11-10 11:00:00R-20261111-02002026-11-11 02:02:22
ACC-26-07766Pool and spaAccessory2026-10-26 08:32:002026-11-10 13:00:0061290.0FBCAD-18435717346 Voss RdIssued2026-11-10 13:00:00R-20261111-02002026-11-11 02:02:22

Data as of run R-20261111-0200, finished 11/11/2026 02:13 Central. Curated layer: curated schema.