← All datasets

# curated.census_tract
Census tract polygons (TIGER, 2020 tract definitions) for the 8-county Houston region (1,598 rows; category: Boundaries & demographics; geometry column `geom` (MultiPolygon, EPSG:4326))
Notes: Prefer curated.census_tract_profile, which is these polygons joined to ACS demographics. GEOID is attrs->>'GEOID'.
Fields (expression | type | filled/distinct in a sample | values or examples):
- objectid | bigint | 1598/1598 | e.g.: 62223; 31065; 17816
- attrs->>'AREALAND' | number | 1598/1595 | e.g.: 0; 2695892; 2422086
- attrs->>'AREAWATER' | number | 1598/1001 | e.g.: 0; 293; 699
- attrs->>'BASENAME' | string | 1598/1595 | e.g.: 9900; 9800; 3140.04
- attrs->>'CENTLAT' | string | 1598/1597 | e.g.: +29.6963073; +29.9091380; +29.6155400
- attrs->>'CENTLON' | string | 1598/1598 | e.g.: -095.6182377; -095.6061990; -095.0874490
- attrs->>'COUNTY' | string | 1598/8 | values: 201; 157; 339; 167; 039; 291; 473; 071
- attrs->>'FUNCSTAT' | string | 1598/1 | values: S
- attrs->>'GEOID' | string | 1598/1598 | e.g.: 48157672401; 48201241104; 48167723900
- attrs->>'INTPTLAT' | string | 1598/1598 | e.g.: +29.5967120; +29.7681348; +29.7864417
- attrs->>'INTPTLON' | string | 1598/1598 | e.g.: -095.5291406; -095.6405110; -095.3575745
- attrs->>'LSADC' | string | 1598/1 | values: CT
- attrs->>'MTFCC' | string | 1598/1 | values: G5020
- attrs->>'NAME' | string | 1598/1595 | e.g.: Census Tract 9900; Census Tract 9800; Census Tract 3101.01
- attrs->>'OID' | string | 1598/1598 | e.g.: 2079015657181296; 207903717156445; 2079015702008094
- attrs->>'STATE' | string | 1598/1 | values: 48
- attrs->>'TRACT' | string | 1598/1595 | e.g.: 990000; 980000; 450803
attrs values are text: cast when comparing numbers, e.g. (attrs->>'PCI')::numeric.