SDOT Dynamic Message Signs
Dataset
| Name | Value |
|---|---|
| Catalog | Link |
| Metadata | Link |
| Data: JSON | 100 Rows |
| Data: CSV | 100 Rows |
| Host | data.seattle.gov |
| Id | 8m64-tv56 |
| Name | SDOT Dynamic Message Signs |
| Category | Transportation |
| Tags | dynamic, message, signs, dms, seattle, traffic, streets, led, parking, real time, information, epark, standard, sdot asset status and condition report, assets |
| Created | 2015-03-19T15:43:59Z |
| Publication Date | 2015-03-19T15:44:54Z |
Description
Displays the locations of SDOT dynamic message signs in the City of Seattle. These display parking, traffic, and real-time information at various locations throughout the city.
Columns
| Included | Schema Type | Field Name | Name | Data Type | Render Type |
| ======== | ============== | ========================= | ========================= | ========= | =========== |
| Yes | series tag | objectid | OBJECTID | text | number |
| Yes | numeric metric | compkey | COMPKEY | number | number |
| Yes | series tag | comptype | COMPTYPE | text | number |
| Yes | numeric metric | distance | DISTANCE | number | number |
| Yes | numeric metric | width | WIDTH | number | number |
| Yes | series tag | unitid | UNITID | text | text |
| Yes | series tag | unittype | UNITTYPE | text | text |
| Yes | series tag | unitdesc | UNITDESC | text | text |
| Yes | series tag | ownership | OWNERSHIP | text | text |
| Yes | series tag | condition | CONDITION | text | text |
| Yes | time | condition_assessment_date | CONDITION_ASSESSMENT_DATE | date | date |
| Yes | series tag | current_status | CURRENT_STATUS | text | text |
| No | | current_status_date | CURRENT_STATUS_DATE | date | date |
| Yes | series tag | category | CATEGORY | text | text |
| Yes | series tag | manufacturer | MANUFACTURER | text | text |
| No | | install_date | INSTALL_DATE | date | date |
| Yes | series tag | installercd | INSTALLERCD | text | text |
| Yes | series tag | support | SUPPORT | text | text |
| Yes | series tag | supportdescr | SUPPORTDESCR | text | text |
| Yes | series tag | electr_wire_loc | ELECTR_WIRE_LOC | text | text |
| Yes | series tag | protocol_loc | PROTOCOL_LOC | text | text |
| No | | warranty_end_date | WARRANTY_END_DATE | date | date |
| Yes | series tag | mount | MOUNT | text | text |
| Yes | series tag | cntrl_housing_loc | CNTRL_HOUSING_LOC | text | text |
| Yes | series tag | aux_housing_loc | AUX_HOUSING_LOC | text | text |
| Yes | series tag | control_model | CONTROL_MODEL | text | text |
| Yes | series tag | air_filter | AIR_FILTER | text | text |
| Yes | series tag | lpr_function | LPR_FUNCTION | text | text |
| Yes | series tag | wireless_comm_type | WIRELESS_COMM_TYPE | text | text |
| Yes | series tag | comments | COMMENTS | text | text |
| Yes | series tag | pos1_panc_disc_dirfac1 | POS1_PANC_DISC_DIRFAC1 | text | text |
| Yes | series tag | pos2_panc_disc_dirfac1 | POS2_PANC_DISC_DIRFAC1 | text | text |
| Yes | series tag | pos3_panc_disc_dirfac1 | POS3_PANC_DISC_DIRFAC1 | text | text |
| Yes | series tag | pos4_panc_disc_dirfac1 | POS4_PANC_DISC_DIRFAC1 | text | text |
| Yes | series tag | pos5_panc_disc_dirfac1 | POS5_PANC_DISC_DIRFAC1 | text | text |
| Yes | series tag | pos6_panc_disc_dirfac1 | POS6_PANC_DISC_DIRFAC1 | text | text |
| Yes | series tag | side | SIDE | text | text |
| Yes | series tag | primarydistrictcd | PRIMARYDISTRICTCD | text | text |
| Yes | series tag | secondarydistrictcd | SECONDARYDISTRICTCD | text | text |
| Yes | series tag | overrideyn | OVERRIDEYN | text | text |
| Yes | series tag | overridecomment | OVERRIDECOMMENT | text | text |
Time Field
Value = condition_assessment_date
Format & Zone = seconds
Series Fields
Excluded Fields = current_status_date,install_date,warranty_end_date
Data Commands
series e:8m64-tv56 d:2011-03-04T00:00:00.000Z t:support=MA t:lpr_function=Y t:condition=GOOD t:comptype=16 t:current_status=INSVC t:pos1_panc_disc_dirfac1="0, BLK, AMBER, NE" t:control_model=TM-VFC3000 t:cntrl_housing_loc=AUX t:category=DMS-STND t:installercd=CONTRACT t:unitdesc="HOLMAN RD NW 0907 BLOCK NW SIDE ( 406) 15 FT SW/O 14TH AVE NW (DMS-STND)" t:aux_housing_loc=AUXPAD t:ownership=SDOT t:mount=TM-OVRHEAD t:unitid=DMS-9 t:side=NW t:manufacturer=DMS-DAKTRN t:supportdescr="Overhead Mast Arm" t:overrideyn=N t:primarydistrictcd=DISTRICT6 t:protocol_loc=FIBER t:objectid=1 t:unittype=DMS t:air_filter=Y t:comments="1. Installed DA300, S/N: 1408452. WO# 481933..........3-29-17" m:distance=429 m:width=30 m:compkey=545124
series e:8m64-tv56 d:2011-03-04T00:00:00.000Z t:support=MA t:lpr_function=N t:condition=GOOD t:comptype=16 t:current_status=INSVC t:pos1_panc_disc_dirfac1="0, BLK, AMBER, W" t:control_model=TM-VFC3000 t:cntrl_housing_loc=AUX t:category=DMS-STND t:installercd=CONTRACT t:unitdesc="ALKI TRL 0200 BLOCK N SIDE (896.53575448) 364 FT E/O 26TH AVE SW (DMS-STND)" t:aux_housing_loc=AUXPAD t:ownership=SDOT t:mount=TM-OVRHEAD t:unitid=DMS-15 t:side=N t:manufacturer=DMS-DAKTRN t:supportdescr="Overhead Mast Arm" t:overrideyn=N t:primarydistrictcd=DISTRICT1 t:protocol_loc=COPPER t:objectid=2 t:unittype=DMS t:air_filter=Y m:distance=411.5358 m:width=17 m:compkey=545130
series e:8m64-tv56 d:2017-04-21T09:16:44.371Z t:support=SP t:lpr_function=N t:condition=GOOD t:comptype=16 t:current_status=INSVC t:unitdesc="1ST AVE S 0080 BLOCK E SIDE ( 840) 840 FT S/O RAILROAD S WAY S (DMS-STND)" t:category=DMS-STND t:ownership=SDOT t:unitid=DMS-78 t:mount=TM-OVRHEAD t:side=E t:supportdescr="Metal Pole" t:overrideyn=N t:primarydistrictcd=DISTRICT2 t:objectid=3 t:unittype=DMS t:air_filter=N t:comments="<P>DMS-28 in Cameleon</P>
<P>1. Installed DA300, S/N: 1408467. WO# 481986....3/20/17</P>" m:distance=855.5 m:width=40 m:compkey=664851
Meta Commands
metric m:compkey p:integer l:COMPKEY d:COMPKEY t:dataTypeName=number
metric m:distance p:double l:DISTANCE d:DISTANCE t:dataTypeName=number
metric m:width p:double l:WIDTH d:WIDTH t:dataTypeName=number
entity e:8m64-tv56 l:"SDOT Dynamic Message Signs" t:url=https://data.seattle.gov/api/views/8m64-tv56
property e:8m64-tv56 t:meta.view v:id=8m64-tv56 v:category=Transportation v:attributionLink=http://www.seattle.gov/transportation/ v:averageRating=0 v:name="SDOT Dynamic Message Signs"
property e:8m64-tv56 t:meta.view.license v:name="Public Domain"
property e:8m64-tv56 t:meta.view.owner v:id=geh9-fb2x v:screenName="SDOT GIS" v:displayName="SDOT GIS"
property e:8m64-tv56 t:meta.view.tableauthor v:id=geh9-fb2x v:screenName="SDOT GIS" v:roleName=publisher v:displayName="SDOT GIS"
Top Records
| objectid | compkey | comptype | distance | width | unitid | unittype | unitdesc | ownership | condition | condition_assessment_date | current_status | current_status_date | category | manufacturer | install_date | installercd | support | supportdescr | electr_wire_loc | protocol_loc | warranty_end_date | mount | cntrl_housing_loc | aux_housing_loc | control_model | air_filter | lpr_function | wireless_comm_type | comments | pos1_panc_disc_dirfac1 | pos2_panc_disc_dirfac1 | pos3_panc_disc_dirfac1 | pos4_panc_disc_dirfac1 | pos5_panc_disc_dirfac1 | pos6_panc_disc_dirfac1 | side | primarydistrictcd | secondarydistrictcd | overrideyn | overridecomment |
| ======== | ======= | ======== | =============================================== | ===== | ====== | ======== | ============================================================================= | ========= | ========= | ========================= | ============== | =================== | ========= | ============ | ============ | =========== | ======= | ================= | =============== | ============ | ================= | ========== | ================= | =============== | ============= | ========== | ============ | ================== | =========================================================================== | ====================== | ====================== | ====================== | ====================== | ====================== | ====================== | ==== | ================= | =================== | ========== | =============== |
| 1 | 545124 | 16 | 429 | 30 | DMS-9 | DMS | HOLMAN RD NW 0907 BLOCK NW SIDE ( 406) 15 FT SW/O 14TH AVE NW (DMS-STND) | SDOT | GOOD | 1299196800 | INSVC | 1299196800 | DMS-STND | DMS-DAKTRN | | CONTRACT | MA | Overhead Mast Arm | | FIBER | | TM-OVRHEAD | AUX | AUXPAD | TM-VFC3000 | Y | Y | | 1. Installed DA300, S/N: 1408452. WO# 481933..........3-29-17 | 0, BLK, AMBER, NE | | | | | | NW | DISTRICT6 | | N | |
| 2 | 545130 | 16 | 411.5357999999999947249307297170162200927734375 | 17 | DMS-15 | DMS | ALKI TRL 0200 BLOCK N SIDE (896.53575448) 364 FT E/O 26TH AVE SW (DMS-STND) | SDOT | GOOD | 1299196800 | INSVC | 1299196800 | DMS-STND | DMS-DAKTRN | | CONTRACT | MA | Overhead Mast Arm | | COPPER | | TM-OVRHEAD | AUX | AUXPAD | TM-VFC3000 | Y | N | | | 0, BLK, AMBER, W | | | | | | N | DISTRICT1 | | N | |
| 3 | 664851 | 16 | 855.5 | 40 | DMS-78 | DMS | 1ST AVE S 0080 BLOCK E SIDE ( 840) 840 FT S/O RAILROAD S WAY S (DMS-STND) | SDOT | GOOD | | INSVC | | DMS-STND | | | | SP | Metal Pole | | | | TM-OVRHEAD | | | | N | N | | DMS-28 in Cameleon
1. Installed DA300, S/N: 1408467. WO# 481986....3/20/17 | | | | | | | E | DISTRICT2 | | N | |
| 4 | 545134 | 16 | 265 | -37 | DMS-19 | DMS | 1ST AVE S 0320 BLOCK W SIDE ( 242) 242 FT S/O S HANFORD ST (DMS-STND) | SDOT | GOOD | 1299196800 | INSVC | 1299196800 | DMS-STND | DMS-DAKTRN | | CONTRACT | MA | Overhead Mast Arm | | COPPER | | TM-OVRHEAD | AUX | AUXPOLE | TM-VFC3000 | Y | N | | | 0, BLK, AMBER, N | | | | | | W | DISTRICT2 | | N | |
| 5 | 545137 | 16 | 338 | -28 | DMS-22 | DMS | EAST MARGINAL WAY S 0420 BLOCK W SIDE ( 315) 315 FT S/O S IDAHO ST (DMS-STND) | SDOT | GOOD | 1299196800 | INSVC | 1299196800 | DMS-STND | DMS-DAKTRN | | CONTRACT | MA | Overhead Mast Arm | | FIBER | | TM-OVRHEAD | AUX | AUXPAD | TM-VFC3000 | Y | N | | 1. Installed DA300, S/N: R1408460. W/O# 481982.........3-22-17. | 0, BLK, AMBER, N | | | | | | W | DISTRICT2 | | N | |
| 6 | 545125 | 16 | 123 | -32 | DMS-10 | DMS | 15TH AVE W 0170 BLOCK E SIDE ( 110) 110 FT N/O W BLAINE ST (DMS-STND) | SDOT | GOOD | 1299196800 | INSVC | 1299196800 | DMS-STND | DMS-DAKTRN | | CONTRACT | MA | Overhead Mast Arm | | FIBER | | TM-OVRHEAD | AUX | AUXPAD | TM-VFC3000 | Y | N | | 1. Installed DA300, S/N: R1408494. W/O# 481962...........3-29-17. | 0, BLK, AMBER, S | | | | | | E | DISTRICT7 | | N | |
| 7 | 545132 | 16 | 221 | -37 | DMS-17 | DMS | 1ST AVE S 0520 BLOCK W SIDE ( 198) 25 FT N/O S BENNETT ST (DMS-STND) | SDOT | GOOD | 1299196800 | INSVC | 1299196800 | DMS-STND | DMS-DAKTRN | | CONTRACT | MA | Overhead Mast Arm | AUXPAD | FIBER | | TM-SHLDR | AUX | AUXPAD | TM-VFC3000 | Y | N | | | 0, BLK, AMBER, S | | | | | | W | DISTRICT2 | | N | |
| 8 | 545120 | 16 | 396 | 39 | DMS-5 | DMS | AURORA AVE N 1350 BLOCK W SIDE ( 373) 244 FT S/O N 137TH ST (DMS-STND) | SDOT | GOOD | 1297987200 | OUTSVC | 1297987200 | DMS-STND | DMS-DAKTRN | | WSDOT | MA | Overhead Mast Arm | | FIBER | | TM-OVRHEAD | AUX | AUXPAD | TM-VFC3000 | Y | N | | | 0, BLK, AMBER, N | | | | | | W | DISTRICT5 | | N | |
| 9 | 629834 | 16 | 230 | 28 | DMS-60 | DMS | ELLIOTT AVE 0240 BLOCK SW SIDE ( 230) 30 FT SE/O WALL ST (DMS-EPFAC) | SDOT | GOOD | 1409529600 | INSVC | 1409529600 | DMS-EPFAC | DMS-DAKTRN | | CONTRACT | BG | Building | | WIRELESS | | | | | | N | N | | Bell St Harbor Pier | | | | | | | SW | DISTRICT7 | | N | |
| 10 | 629832 | 16 | 105 | -25 | DMS-59 | DMS | WALL ST 0002 BLOCK SE SIDE ( 73) 150 FT SW/O ELLIOTT AVE (DMS-EPFAC) | SDOT | GOOD | 1409529600 | INSVC | 1409529600 | DMS-EPFAC | DMS-DAKTRN | | CONTRACT | BG | Building | | WIRELESS | | | | | | N | N | | Bell St Harbor Pier | | | | | | | SE | DISTRICT7 | | N | |