Central Data Repository City of Sugar Land, Office of Data and Innovation
PRODUCTION
Marisol Ortega, Data and Innovation Administrator (CDR Administrator)
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.