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.&nbsp; 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          |                 |