SDOT Street Signs [OLD]

Dataset

Name Value
Catalog Link
Metadata Link
Data: JSON 100 Rows
Data: CSV 100 Rows
Host data.seattle.gov
Id kb3s-zi3z
Name SDOT Street Signs [OLD]
Category Transportation
Tags signs, streets, sdot, seattle, stop, parking, bike, route, regulation, speed limit, traffic, vision zero
Created 2015-03-19T04:57:27Z
Publication Date 2015-03-19T04:58:59Z

Description

THIS DATASET IS SET TO BE RETIRED. PLEASE USE THE DATASET AT THE FOLLOWING URL: https://data.seattle.gov/Transportation/SDOT-Street-Signs/atig-uucb

Columns

| Included | Schema Type    | Field Name          | Name                | Data Type | Render Type |
| ======== | ============== | =================== | =================== | ========= | =========== |
| Yes      | series tag     | objectid            | OBJECTID            | text      | number      |
| Yes      | series tag     | unitid              | UNITID              | text      | text        |
| Yes      | series tag     | unittype            | UNITTYPE            | text      | text        |
| Yes      | series tag     | signtype            | SIGNTYPE            | text      | text        |
| Yes      | series tag     | category            | CATEGORY            | text      | text        |
| Yes      | series tag     | categorydescr       | CATEGORYDESCR       | text      | text        |
| Yes      | series tag     | unitdesc            | UNITDESC            | text      | text        |
| Yes      | series tag     | facing              | FACING              | text      | text        |
| Yes      | series tag     | support             | SUPPORT             | text      | text        |
| Yes      | series tag     | supportdescr        | SUPPORTDESCR        | text      | text        |
| Yes      | series tag     | color1              | COLOR1              | text      | text        |
| Yes      | series tag     | signsz              | SIGNSZ              | text      | text        |
| Yes      | series tag     | reflectiveyn        | REFLECTIVEYN        | text      | text        |
| Yes      | series tag     | fieldnotes          | FIELDNOTES          | text      | text        |
| Yes      | series tag     | custom              | CUSTOM              | text      | text        |
| Yes      | numeric metric | compkey             | COMPKEY             | number    | number      |
| Yes      | series tag     | comptype            | COMPTYPE            | text      | number      |
| Yes      | numeric metric | segkey              | SEGKEY              | number    | number      |
| Yes      | numeric metric | intkey              | INTKEY              | number    | number      |
| Yes      | numeric metric | elmntkey            | ELMNTKEY            | number    | number      |
| Yes      | numeric metric | distance            | DISTANCE            | number    | number      |
| Yes      | numeric metric | width               | WIDTH               | number    | number      |
| Yes      | numeric metric | supportkey          | SUPPORTKEY          | number    | number      |
| Yes      | series tag     | supportid           | SUPPORTID           | text      | text        |
| Yes      | series tag     | startday            | STARTDAY            | text      | text        |
| Yes      | series tag     | endday              | ENDDAY              | text      | text        |
| Yes      | series tag     | starttime           | STARTTIME           | text      | text        |
| Yes      | series tag     | endtime             | ENDTIME             | text      | text        |
| Yes      | series tag     | side                | SIDE                | text      | text        |
| Yes      | series tag     | ownership           | OWNERSHIP           | text      | text        |
| Yes      | series tag     | current_status      | CURRENT_STATUS      | text      | text        |
| Yes      | series tag     | condition           | CONDITION           | text      | text        |
| Yes      | series tag     | text                | TEXT                | text      | text        |
| Yes      | time           | adddttm             | ADDDTTM             | date      | date        |
| No       |                | moddttm             | MODDTTM             | date      | date        |
| No       |                | instdate            | INSTDATE            | date      | date        |
| No       |                | expdate             | EXPDATE             | date      | date        |
| 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 = adddttm
Format & Zone = seconds

Series Fields

Excluded Fields = moddttm,instdate,expdate

Data Commands

series e:kb3s-zi3z d:2012-05-16T00:00:00.000Z t:endtime=1800 t:supportid=SAS-61253 t:comptype=20 t:startday=1 t:categorydescr="Restricted Parking Zone permited parking" t:unitdesc="WESTLAKE EAST RDWY AVE N 0090 BLOCK NE SIDE ( 302) 302 FT NW/O ALOHA ST (R8-BL4Z25 -35W/R8PSX)" t:unitid=SGN-168347 t:side=NE t:unittype=01-RS t:endday=6 t:signsz=12X18 t:custom=N t:fieldnotes=-35W/R8PSX t:text="[CIRCLE P] 4 HOURS MAX PAY 9A-4P" t:support=TS-10 t:starttime=800 t:condition=GOOD t:current_status=INSVC t:category=PRZ t:ownership=SDOT t:supportdescr="Telespar Post - 10'" t:facing=W t:primarydistrictcd=DISTRICT7 t:overrideyn=N t:reflectiveyn=Y t:objectid=1 t:color1=WHITE/BLUE t:signtype=R8-BL4Z25 m:distance=302 m:segkey=13549 m:width=-29 m:intkey=1 m:elmntkey=36158 m:supportkey=414125 m:compkey=585127

series e:kb3s-zi3z d:2012-12-17T00:00:00.000Z t:endtime=2359 t:supportid=SAS-124399 t:comptype=20 t:startday=1 t:categorydescr="No Parking, but ""standing"" allowed" t:unitdesc="COLORADO AVE S 0150 BLOCK W SIDE ( 690) 44 FT N/O S MASSACHUSETTS ST (R7-NPLR )" t:unitid=SGN-172392 t:side=W t:unittype=01-RS t:endday=7 t:signsz=18X18 t:text="[SLASH OVER CIRCLE] P [LEFT & RIGHT ARROW]" t:support=CW t:starttime=0 t:current_status=INSVC t:category=PNP t:ownership=SDOT t:supportdescr="Concrete Wall or Column" t:facing=E t:primarydistrictcd=DISTRICT2 t:overrideyn=N t:reflectiveyn=N t:objectid=2 t:color1=RED/WHITE t:signtype=R7-NPLR m:distance=715 m:segkey=9704 m:width=-8 m:intkey=1 m:elmntkey=9737 m:supportkey=592667 m:compkey=592673

series e:kb3s-zi3z d:2012-12-05T00:00:00.000Z t:endtime=900 t:supportid=SAS-107538 t:comptype=20 t:startday=1 t:categorydescr="Peak Parking Restrictions, TOW" t:unitdesc="NW MARKET ST 0240 BLOCK S SIDE ( 134) 134 FT W/O 24TH AVE NW (R7-PKAB -11)" t:unitid=SGN-172279 t:side=S t:unittype=01-RS t:endday=5 t:signsz=12x18 t:custom=N t:fieldnotes=-11 t:text="NO PARKING 6-9 AM EXC SAT-SUN-HOL TAZ" t:support=LP t:starttime=600 t:condition=GOOD t:current_status=INSVC t:category=PPEAK t:ownership=SDOT t:supportdescr="SCL Light Post" t:facing=W t:primarydistrictcd=DISTRICT6 t:overrideyn=N t:reflectiveyn=N t:objectid=3 t:color1=R/W t:signtype=R7-PKAB m:distance=158 m:segkey=19236 m:width=31 m:intkey=1 m:elmntkey=41726 m:supportkey=530747 m:compkey=592353

Meta Commands

metric m:compkey p:integer l:COMPKEY d:COMPKEY t:dataTypeName=number

metric m:segkey p:long l:SEGKEY d:SEGKEY t:dataTypeName=number

metric m:intkey p:long l:INTKEY d:INTKEY t:dataTypeName=number

metric m:elmntkey p:long l:ELMNTKEY d:ELMNTKEY t:dataTypeName=number

metric m:distance p:long l:DISTANCE d:DISTANCE t:dataTypeName=number

metric m:width p:long l:WIDTH d:WIDTH t:dataTypeName=number

metric m:supportkey p:long l:SUPPORTKEY d:SUPPORTKEY t:dataTypeName=number

entity e:kb3s-zi3z l:"SDOT Street Signs [OLD]" t:url=https://data.seattle.gov/api/views/kb3s-zi3z

property e:kb3s-zi3z t:meta.view v:id=kb3s-zi3z v:category=Transportation v:attributionLink=http://www.seattle.gov/transportation/ v:averageRating=0 v:name="SDOT Street Signs [OLD]"

property e:kb3s-zi3z t:meta.view.license v:name="Public Domain"

property e:kb3s-zi3z t:meta.view.owner v:id=geh9-fb2x v:screenName="SDOT GIS" v:displayName="SDOT GIS"

property e:kb3s-zi3z t:meta.view.tableauthor v:id=geh9-fb2x v:screenName="SDOT GIS" v:roleName=publisher v:displayName="SDOT GIS"

Top Records

| objectid | unitid     | unittype | signtype  | category | categorydescr                                                                                      | unitdesc                                                                                       | facing | support | supportdescr            | color1     | signsz   | reflectiveyn | fieldnotes | custom | compkey | comptype | segkey | intkey | elmntkey | distance | width | supportkey | supportid  | startday | endday | starttime | endtime | side | ownership | current_status | condition | text                                                                | adddttm    | moddttm    | instdate   | expdate | primarydistrictcd | secondarydistrictcd | overrideyn | overridecomment | 
| ======== | ========== | ======== | ========= | ======== | ================================================================================================== | ============================================================================================== | ====== | ======= | ======================= | ========== | ======== | ============ | ========== | ====== | ======= | ======== | ====== | ====== | ======== | ======== | ===== | ========== | ========== | ======== | ====== | ========= | ======= | ==== | ========= | ============== | ========= | =================================================================== | ========== | ========== | ========== | ======= | ================= | =================== | ========== | =============== | 
| 1        | SGN-168347 | 01-RS    | R8-BL4Z25 | PRZ      | Restricted Parking Zone permited parking                                                           | WESTLAKE EAST RDWY AVE N 0090 BLOCK NE SIDE ( 302) 302 FT NW/O ALOHA ST (R8-BL4Z25 -35W/R8PSX) | W      | TS-10   | Telespar Post - 10'     | WHITE/BLUE | 12X18    | Y            | -35W/R8PSX | N      | 585127  | 20       | 13549  | 1      | 36158    | 302      | -29   | 414125     | SAS-61253  | 1        | 6      | 800       | 1800    | NE   | SDOT      | INSVC          | GOOD      | [CIRCLE P] 4 HOURS MAX PAY 9A-4P                                    | 1337126400 | 1438041600 | 1333411200 |         | DISTRICT7         |                     | N          |                 | 
| 2        | SGN-172392 | 01-RS    | R7-NPLR   | PNP      | No Parking, but "standing" allowed                                                                 | COLORADO AVE S 0150 BLOCK W SIDE ( 690) 44 FT N/O S MASSACHUSETTS ST (R7-NPLR )                | E      | CW      | Concrete Wall or Column | RED/WHITE  | 18X18    | N            |            |        | 592673  | 20       | 9704   | 1      | 9737     | 715      | -8    | 592667     | SAS-124399 | 1        | 7      | 0         | 2359    | W    | SDOT      | INSVC          |           | [SLASH OVER CIRCLE] P [LEFT & RIGHT ARROW]                          | 1355702400 |            |            |         | DISTRICT2         |                     | N          |                 | 
| 3        | SGN-172279 | 01-RS    | R7-PKAB   | PPEAK    | Peak Parking Restrictions, TOW                                                                     | NW MARKET ST 0240 BLOCK S SIDE ( 134) 134 FT W/O 24TH AVE NW (R7-PKAB -11)                     | W      | LP      | SCL Light Post          | R/W        | 12x18    | N            | -11        | N      | 592353  | 20       | 19236  | 1      | 41726    | 158      | 31    | 530747     | SAS-107538 | 1        | 5      | 600       | 900     | S    | SDOT      | INSVC          | GOOD      | NO PARKING 6-9 AM EXC SAT-SUN-HOL TAZ                               | 1354665600 | 1354665600 | 1349136000 |         | DISTRICT6         |                     | N          |                 | 
| 4        | SGN-170091 | 03-GSC   | D3-103X   | SNS      | Street Name Signs                                                                                  | NE 92ND ST 0010 BLOCK S SIDE ( 305) 0 FT W/O 2ND AVE NE (D3-103X )                             |        | 3INRND  | 3 Inch Round Pole       | WHITE/GREN | VariesX9 | Y            |            | N      | 588163  | 20       | 17841  | 37577  | 85814    | 318      | -14   | 588162     | SAS-123209 |          |        |           |         | S    | SDOT      | INSVC          | GOOD      | N SIDE: NE 92nd St S SIDE: NE 92nd St                               | 1342656000 |            | 1339113600 |         | DISTRICT5         |                     | N          |                 | 
| 5        | SGN-166367 | 03-GSC   | D3-103X   | SNS      | Street Name Signs                                                                                  | 6TH AVE N 0070 BLOCK W SIDE ( 287) 0 FT S/O VALLEY ST (D3-103X )                               |        | 3INRND  | 3 Inch Round Pole       | WHITE/GREN | VariesX9 | Y            |            | N      | 579590  | 20       | 7900   | 28738  | 8013     | 300      | 17    | 579589     | SAS-121326 |          |        |           |         | W    | SDOT      | INSVC          | GOOD      | N SIDE: Valley St 700 S SIDE: Valley St 800                         | 1328832000 |            | 1325808000 |         | DISTRICT7         |                     | N          |                 | 
| 6        | SGN-173951 | 01-RS    | R7-STX    | PZONE    | Includes charter bus, event, funeral, consel, carshare, miscellaneous, ambulance, taxi, motorcycle | SUMMIT AVE E 0100 BLOCK W SIDE ( 275) 275 FT N/O BELLEVUE E PL E (R7-STX 20' DF)               | S      | UP      | Wood Pole               | RED/WHITE  |          | N            | 20' DF     | N      | 596068  | 20       | 13000  | 1      | 35609    | 288      | 17    | 410062     | SAS-57190  | 1        | 7      | 0         | 2359    | W    | SDOT      | INSVC          |           | {15}NO STOPS 9AM-2PM WED [CAR BEING TOWED] PHONE 684-5444           | 1362614400 | 1375315200 |            |         | DISTRICT3         |                     | N          |                 | 
| 7        | SGN-165685 | 02-WS    | W11-2     | WARNCW   | Warning-Crosswalk                                                                                  | ROOSEVELT WAY NE 0430 BLOCK W SIDE ( 215) 215 FT N/O NE 43RD N ST (W11-2 )                     | N      | TS-10   | Telespar Post - 10'     | BLACK/FLGR | 30x30    | Y            |            | N      | 577946  | 20       | 12598  | 1      | 35237    | 215      | 24    | 577942     | SAS-121029 |          |        |           |         | W    | SDOT      | INSVC          | GOOD      | [PEDESTRIAN]                                                        | 1324425600 | 1423440000 | 1323734400 |         | DISTRICT4         |                     | N          |                 | 
| 8        | SGN-170889 | 01-RS    | R3-102L   | REGBP    | Regulatory-Bike Ped                                                                                | NE RAVENNA WB BV 0060 BLOCK SW SIDE ( 205) 205 FT SE/O NE 65TH ST (R3-102L )                   | SE     | TS-10   | Telespar Post - 10'     | RED/WHITE  | 30X36    | Y            |            |        | 589850  | 20       | 18084  | 1      | 86062    | 228      | -17   | 589846     | SAS-123646 |          |        |           |         | SW   | SDOT      | INSVC          |           | [GREEN BIKE LANE PARALLEL] [UP ARROW] [BIKE] [YIELD] [LEFT S ARROW] | 1346198400 |            | 1346112000 |         | DISTRICT6         | DISTRICT4           | N          |                 | 
| 9        | SGN-168196 | 03-GSC   | D3-103X   | SNS      | Street Name Signs                                                                                  | 29TH AVE 0080 BLOCK E SIDE ( 0) 0 FT N/O E COLUMBIA ST (D3-103X )                              |        | 3INRND  | 3 Inch Round Pole       | WHITE/GREN | VariesX9 | Y            |            | N      | 584596  | 20       | 4267   | 30058  | 27150    | 13       | -17   | 584594     | SAS-122288 |          |        |           |         | E    | SDOT      | INSVC          | GOOD      | N SIDE: E Columbia St 700 S SIDE: E Columbia St 800                 | 1335312000 |            | 1331596800 |         | DISTRICT3         |                     | N          |                 | 
| 10       | SGN-170197 | 03-GSC   | D3-103X   | SNS      | Street Name Signs                                                                                  | RAVENNA AVE NE 0549 BLOCK W SIDE ( 107) 0 FT S/O NE 55TH N ST (D3-103X )                       |        | 3INRND  | 3 Inch Round Pole       | WHITE/GREN | VariesX9 | Y            |            | N      | 588320  | 20       | 12454  | 26021  | 12449    | 107      | 30    | 588319     | SAS-123260 |          |        |           |         | W    | SDOT      | INSVC          | GOOD      | E SIDE: Ravenna Ave NE 2100 W SIDE: Ravenna Ave NE                  | 1342656000 | 1455148800 | 1337904000 |         | DISTRICT4         |                     | N          |                 |