← All datasets
# curated.streets_adt_major
Traffic counts (ADT) on major thoroughfares (2,359 rows; category: Streets & traffic; geometry column `geom` (Point, EPSG:4326))
Fields (expression | type | filled/distinct in a sample | values or examples):
- objectid | bigint | 2359/2359 | e.g.: 10833; 247; 121
- attrs->>'ADDRESS' | string | 2359/2350 | e.g.: SAN FELIPE ST, HOUSTON, TX, 77027; YALE; 1698 DUNLAVY ST, HOUSTON, TX, 77006
- attrs->>'COLLECTIONTYPE' | string | 2359/1 | values: MAJOR THOROUGHFARE ADT
- attrs->>'Notes' | null | 637/78 | e.g.: ; Under construction ; under construction
- attrs->>'REGION' | string | 2359/6 | values: SW; CBD; SE; NE; NW; MMD
- attrs->>'SEGMENT' | null | 2358/1366 | e.g.: FANNIN TO SAN JACINTO; CHENEVERT TO HAMILTON; AUSTIN TO LA BRANCH
- attrs->>'StationID' | null | 2355/2345 | e.g.: 31220138396; 31237138397; 31111138409
attrs values are text: cast when comparing numbers, e.g. (attrs->>'PCI')::numeric.