← 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.: 34884; 40986; 27551
- attrs->>'ACTIVATION_DATE' | null | 1026/92 | e.g.: -631108800000; 1444042800000; 1442919600000
- attrs->>'ACTIVE_CONTROL' | null | 564/3 | values: Yes; yes; No
- attrs->>'CATEGORY' | string | 1111/3 | values: R1-1; R-1; 
- attrs->>'CLASS' | string | 1116/2 | values: Regulatory; 
- attrs->>'CONTROLTYPE' | string | 1088/3 | values: 2-way; 1-way; multi-way
- attrs->>'DESCRIPTION' | string | 4/1 | values: Heights
- attrs->>'GLOBALID_1' | string | 5000/5000 | e.g.: {5970A81B-06F9-4C72-9B76-E04A51E80323}; {EA6B0234-1B71-421C-B90D-7994D41D9648}; {A552F7A6-AE6F-4190-A72C-FE7475B0D0F9}
- attrs->>'LINKID_1' | null | 1088/1036 | e.g.: 453W0084-452Z0081; 528V0004-528V0002; 493A0080-453W0009
- attrs->>'MAINTENANCE_DATE' | number | 1026/94 | e.g.: -631108800000; 1444042800000; 1442919600000
- attrs->>'NODEID' | null | 1088/983 | e.g.: 494Y0027; 492V0065; 489H0039
- attrs->>'REMOVAL_DATE' | number | 1026/105 | e.g.: 1444042800000; 1456228800000; 1442919600000
- attrs->>'SIGN_DIMENTIONS' | null | 4974/4 | values: 36x36; 36X36; 30x360; 36x6
- attrs->>'SIGNID' | null | 1087/73 | e.g.: 999; 99; 777
- attrs->>'STREETNAME1' | null | 4980/1912 | e.g.: Chimney Rock Rd; Westheimer Rd; Bissonnet St
attrs values are text: cast when comparing numbers, e.g. (attrs->>'PCI')::numeric.