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

Help

How the Central Data Repository is organized and where to start.
Architecture: City source systems feed the raw, cleansed and curated layers; governance, quality and cost controls apply across them; department views, Power BI and ArcGIS read the curated layer.

For department staff

Open Department views for your department's measures, maps and tables. Every measure links to its written definition. To get access for a position, ask your department data steward to raise a request under Access and roles.

If a number looks wrong, check Quarantine: records that fail a quality rule are held there until they are corrected in the source system.

For data engineering

Each night the pipeline extracts from every source, cleanses and validates, builds the curated layer, recomputes metrics and reconciles them. Start from Pipeline runs and Alerts. Runbooks are under Knowledge transfer.

Example of an issue and its resolution: R-20261106-0200 (EnerGov upgrade renamed a field) and R-20261107-0200 (mapping v4 and replay cleared it).

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