← All datasets

# curated.streets_bike_ped_count
Bike and pedestrian count locations (858 rows; category: Streets & traffic; geometry column `geom` (Point, EPSG:4326))
Fields (expression | type | filled/distinct in a sample | values or examples):
- objectid | bigint | 858/858 | e.g.: 262; 711; 16
- attrs->>'CollectionType' | string | 858/1 | values: TURNING MOVEMENTS
- attrs->>'created_date' | null | 856/856 | e.g.: 1393345488000; 1369938136000; 1422637506000
- attrs->>'created_user' | null | 856/5 | values: Jimmy Cantu; TOD Intern; Emiliano Carrillo; 999999; Kedrick Dixon 
- attrs->>'Historic_ID' | null | 855/855 | e.g.: 262; 711; 257
- attrs->>'Intersection' | string | 858/853 | e.g.: Braeswood at Cambridge; Buffalo Speedway at S. Main St.; Kingwood Dr at Kingwood Pl Dr
- attrs->>'last_edited_date' | number | 856/856 | e.g.: 1376494244000; 1479326172000; 1573134868000
- attrs->>'last_edited_user' | string | 856/5 | values: Jimmy Cantu; jessica.lott; Emiliano Carrillo; TDO; Kedrick Dixon 
- attrs->>'Region' | string | 858/6 | values: SW; NW; SE; NE; CBD; MMD
- attrs->>'Status' | null | 3/2 | values: Complete; Processing
- attrs->>'StreetName' | string | 858/335 | e.g.: Richmond Ave.; Memorial Dr.; Westheimer Rd.
- attrs->>'StreetName2' | string | 858/616 | e.g.: Shepherd Dr.; Long Point; Antoine Dr.
- attrs->>'X' | number | 858/858 | e.g.: 3056084.05008601; 3046098.76985976; 3104897.8701091
- attrs->>'Y' | number | 858/858 | e.g.: 13862253.85997958; 13856635.63991684; 13797316.04005234
attrs values are text: cast when comparing numbers, e.g. (attrs->>'PCI')::numeric.