Data standards
Enterprise standards applied as data is cleansed: names, dates, identifiers, addresses and demographics. Every non-conforming value is kept, flagged and listed as a documented exception.
Enterprise standards in force
| Standard | Applied in |
|---|---|
| Dates and times stored in City local time (Central) with the source time zone recorded | All cleansed tables |
| Department codes from the City department list (11 codes) | All facts; row level security key |
| Parcel identifier (Fort Bend CAD format) as the location key; geometry WGS 84 | Permits, work orders, 311, code cases |
| Addresses standardized to the City address point layer | 311, permits |
| Column names lower case with units in the name (e.g. consumption_kgal) | Curated layer |
| Demographics: City demographic standard, DM8 profile | Employees, program registrations |
DM8 demographic profile
Race and ethnicity as one combined question, multiple selections allowed. The profile below is as configured for this repository; the City's DM8 field list is confirmed with the Office of Data and Innovation in Phase 0.
| Code | Category |
|---|---|
| AIAN | American Indian or Alaska Native |
| ASIAN | Asian |
| BLACK | Black or African American |
| HISP | Hispanic or Latino |
| MENA | Middle Eastern or North African |
| NHPI | Native Hawaiian or Pacific Islander |
| WHITE | White |
| MULTI | Two or more selected |
| NOANS | Prefer not to answer |
Conformance by dataset
Employees (HR) 98.9% conform
| DM8 code | Employees |
|---|---|
| WHITE | 414 |
| HISP | 254 |
| BLACK | 155 |
| ASIAN | 141 |
| MULTI | 26 |
| NOANS | 18 |
| Exception | 12 |
| AIAN | 11 |
| MENA | 10 |
| NHPI | 5 |
Documented exceptions
| Source value | Records | Disposition |
|---|---|---|
| (blank) | 12 | Not collected at hire; HR updates at the next self-service review |
Parks program registrations (SharePoint) 86.0% conform
| DM8 code | Registrations |
|---|---|
| WHITE | 750 |
| HISP | 631 |
| ASIAN | 560 |
| Exception | 454 |
| BLACK | 329 |
| MULTI | 203 |
| NOANS | 189 |
| MENA | 95 |
| AIAN | 15 |
| NHPI | 14 |
Documented exceptions
| Source value | Records | Disposition |
|---|---|---|
| (blank) | 360 | Optional question left blank; counted as not reported |
| Other | 94 | Free text "Other" with no write-in; registration form to be updated to the DM8 list |
Value map (source value to DM8 code)
| Source value | DM8 code | Source value | DM8 code | Source value | DM8 code |
|---|---|---|---|---|---|
| american indian or alaska native | AIAN | I | AIAN | A | ASIAN |
| asian | ASIAN | asian indian | ASIAN | B | BLACK |
| black | BLACK | black or african american | BLACK | H | HISP |
| HISP | HISP | hispanic | HISP | hispanic or latino | HISP |
| latino | HISP | ME | MENA | mena | MENA |
| middle eastern or north african | MENA | 2 | MULTI | asian; white | MULTI |
| multiracial | MULTI | native hawaiian or pacific islander | NHPI | P | NHPI |
| prefer not to say | NOANS | U | NOANS | W | WHITE |
| white | WHITE |
Data as of run R-20261111-0200, finished 11/11/2026 02:13 Central. Curated layer: curated schema.