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

Every table in the raw, cleansed and curated layers with its owner, steward, classification, row count and quality score. Select a table for columns, lineage and rules. Curated | Cleansed | Raw | All
DatasetLayerDepartmentData ownerData stewardClassificationRowsQuality score
dim_department
dim department
CuratedOffice of Data and Innovation Data and Innovation AdministratorKevin Tran Internal 11
dim_employee
dim employee
CuratedHuman Resources Human Resources DirectorTamika Wells Confidential 1,046
dim_parcel
dim parcel
CuratedOffice of Data and Innovation Data and Innovation AdministratorKevin Tran Internal 9,200
fact_ap_invoice
fact ap invoice
CuratedFinance Chief Financial OfficerGrace Lin Internal 15,300
fact_cad_incident
fact cad incident
CuratedPolice Police ChiefJasmine Patel Restricted (public safety) 38,589
fact_code_case
fact code case
CuratedDevelopment Services Development Services DirectorMichael Okafor Internal 2,350
fact_inspection
fact inspection
CuratedDevelopment Services Development Services DirectorMichael Okafor Internal 16,464
fact_permit
fact permit
CuratedDevelopment Services Development Services DirectorMichael Okafor Internal 8,100
fact_program_registration
fact program registration
CuratedParks and Recreation Parks and Recreation DirectorDaniel Novak Internal 3,240
fact_service_request
fact service request
CuratedCitizen Services (311) Citizen Services ManagerSofia Martinez Internal 30,400
fact_utility_bill
fact utility bill
CuratedUtilities Utilities DirectorBrandon Hayes Confidential 329,982
fact_work_order
fact work order
CuratedPublic Works Public Works DirectorElena Ruiz Internal 22,545
arcgis_parcel
Parcels
CleansedOffice of Data and Innovation Data and Innovation AdministratorKevin Tran Internal 9,200
cad_incident_summary
CAD incident summaries
CleansedPolice Police ChiefJasmine Patel Restricted (public safety) 38,589100.0
cityworks_workorder
Work orders
CleansedPublic Works Public Works DirectorElena Ruiz Internal 22,545100.0
crm311_service_request
311 service requests
CleansedCitizen Services (311) Citizen Services ManagerSofia Martinez Internal 30,40099.7
energov_code_case
Code enforcement cases
CleansedDevelopment Services Development Services DirectorMichael Okafor Internal 2,350100.0
energov_inspection
Inspections
CleansedDevelopment Services Development Services DirectorMichael Okafor Internal 16,464100.0
energov_permit
Permits
CleansedDevelopment Services Development Services DirectorMichael Okafor Internal 8,100100.0
hr_employee
Employees
CleansedHuman Resources Human Resources DirectorTamika Wells Confidential 1,04698.7
munis_ap_invoice
Accounts payable invoices
CleansedFinance Chief Financial OfficerGrace Lin Internal 15,300100.0
munis_ub_bill
Utility bills
CleansedUtilities Utilities DirectorBrandon Hayes Confidential 329,982100.0
perfdb_metric_value
Legacy performance metric values
CleansedOffice of Data and Innovation Data and Innovation AdministratorKevin Tran Internal 168100.0
sharepoint_parks_registration
Parks program registrations
CleansedParks and Recreation Parks and Recreation DirectorDaniel Novak Internal 3,24086.0
arcgis_parcel
Parcels
RawOffice of Data and Innovation Data and Innovation AdministratorKevin Tran Internal 18,400
cad_incident_summary
CAD incident summaries
RawPolice Police ChiefJasmine Patel Restricted (public safety) 38,600100.0
cityworks_workorder
Work orders
RawPublic Works Public Works DirectorElena Ruiz Internal 22,545100.0
crm311_service_request
311 service requests
RawCitizen Services (311) Citizen Services ManagerSofia Martinez Internal 30,40099.7
energov_code_case
Code enforcement cases
RawDevelopment Services Development Services DirectorMichael Okafor Internal 2,350100.0
energov_inspection
Inspections
RawDevelopment Services Development Services DirectorMichael Okafor Internal 16,464100.0
energov_permit
Permits
RawDevelopment Services Development Services DirectorMichael Okafor Internal 8,307100.0
hr_employee
Employees
RawHuman Resources Human Resources DirectorTamika Wells Confidential 11,50398.7
munis_ap_invoice
Accounts payable invoices
RawFinance Chief Financial OfficerGrace Lin Internal 15,300100.0
munis_ub_bill
Utility bills
RawUtilities Utilities DirectorBrandon Hayes Confidential 329,988100.0
perfdb_metric_value
Legacy performance metric values
RawOffice of Data and Innovation Data and Innovation AdministratorKevin Tran Internal 168100.0
sharepoint_parks_registration
Parks program registrations
RawParks and Recreation Parks and Recreation DirectorDaniel Novak Internal 3,24086.0

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