← All datasets
# curated.streets_adt_local
Traffic counts (ADT) on local streets (139 rows; category: Streets & traffic; geometry column `geom` (Point, EPSG:4326))
Fields (expression | type | filled/distinct in a sample | values or examples):
- objectid | bigint | 139/139 | e.g.: 877; 1070; 497
- attrs->>'ADDRESS' | string | 139/139 | e.g.: 6200 W BELLFORT ST, HOUSTON, TX, 77035; 5827 WHEATLEY ST, HOUSTON, TX, 77091; 4003 ANTOINE DR, HOUSTON, TX, 77092
- attrs->>'COLLECTIONTYPE' | string | 139/1 | values: LOCAL STREET ADT
- attrs->>'Notes' | string | 32/1 | values:
- attrs->>'REGION' | string | 139/3 | values: SW; NW; NE
- attrs->>'SEGMENT' | string | 139/120 | e.g.: KIRBY TO CHILTON; SHEPHERD TO CHILTON; W GREENRIDGE TO UNITY
- attrs->>'StationID' | number | 139/139 | e.g.: 30985139166; 30945138826; 30975137865
attrs values are text: cast when comparing numbers, e.g. (attrs->>'PCI')::numeric.