← All datasets

# curated.streets_stop_sign
Stop signs (21,272 rows; category: Streets & traffic; geometry column `geom` (Point, EPSG:4326))
Fields (expression | type | filled/distinct in a sample | values or examples):
- objectid | bigint | 5000/5000 | e.g.: 38190; 29062; 21849
- attrs->>'ACTIVATION_DATE' | null | 1066/94 | e.g.: -631108800000; 1442919600000; 1444042800000
- attrs->>'ACTIVE_CONTROL' | null | 574/4 | values: Yes; yes; No; no
- attrs->>'CATEGORY' | string | 1164/2 | values: R1-1; R-1
- attrs->>'CLASS' | string | 1172/2 | values: Regulatory; 
- attrs->>'CONTROLTYPE' | string | 1133/3 | values: 2-way; 1-way; multi-way
- attrs->>'DESCRIPTION' | string | 7/3 | values: Heights; ; Signal Lights Control All
- attrs->>'GLOBALID_1' | string | 5000/5000 | e.g.: {F82C38D8-8473-4086-BE7B-F08E98E20D2E}; {3B69BB3F-D895-4A4E-9BAB-AA9B80C138CC}; {E5164DC2-BFD4-42AE-9B3D-E0DF7E9AA0C9}
- attrs->>'LINKID_1' | null | 1127/1066 | e.g.: 453S0004-452V0006; 452K0040-452K0045; 492M0086-492M0098
- attrs->>'MAINTENANCE_DATE' | number | 1066/96 | e.g.: -631108800000; 1442919600000; 1444042800000
- attrs->>'NODEID' | null | 1128/999 | e.g.: 492L0067; 451S0044; 490A0009
- attrs->>'REMOVAL_DATE' | number | 1066/110 | e.g.: 1442919600000; 1444042800000; 1457006400000
- attrs->>'SIGN_DIMENTIONS' | null | 4962/3 | values: 36x36; 36X36; 30x360
- attrs->>'SIGNID' | null | 1130/66 | e.g.: 999; 99; 777
- attrs->>'STREETNAME1' | null | 4969/1917 | e.g.: Chimney Rock Rd; Katy Fwy; Richmond Ave
attrs values are text: cast when comparing numbers, e.g. (attrs->>'PCI')::numeric.