SDOT 2011 Traffic Flow Counts

Dataset

Name Value
Catalog Link
Metadata Link
Data: JSON 100 Rows
Data: CSV 100 Rows
Host data.seattle.gov
Id vx33-v49r
Name SDOT 2011 Traffic Flow Counts
Attribution Seattle Department of Transportation
Category Transportation
Tags 2011, traffic, counts, speed, seattle, sdot, streets, vision zero
Created 2015-03-19T05:18:37Z
Publication Date 2015-03-19T05:20:28Z

Description

Provides traffic count data for Seattle that includes Average Annual Weekday Traffic (AAWDT) derived from averaging AM and PM peak hour traffic counts measured between Monday and Friday. This data is for traffic count data collected in 2011.

Columns

| Included | Schema Type    | Field Name     | Name           | Data Type  | Render Type |
| ======== | ============== | ============== | ============== | ========== | =========== |
| Yes      | series tag     | objectid       | OBJECTID       | text       | number      |
| Yes      | series tag     | geobasid       | GEOBASID       | text       | number      |
| Yes      | series tag     | downtown       | DOWNTOWN       | text       | text        |
| Yes      | numeric metric | compkey        | COMPKEY        | number     | number      |
| Yes      | series tag     | stname         | STNAME         | text       | text        |
| Yes      | series tag     | name           | NAME           | text       | text        |
| Yes      | time           | year_          | YEAR_          | number     | number      |
| Yes      | numeric metric | segkey         | SEGKEY         | number     | number      |
| Yes      | numeric metric | aawdt          | AAWDT          | number     | number      |
| Yes      | series tag     | input_study_id | INPUT_STUDY_ID | text       | number      |
| Yes      | series tag     | hpms           | HPMS           | text       | text        |
| Yes      | series tag     | flow_count     | FLOW_COUNT     | text       | text        |
| No       |                | shape          | SHAPE          | geospatial | geospatial  |
| Yes      | numeric metric | shape_length   | Shape_Length   | number     | number      |

Time Field

Value = year_
Format & Zone = yyyy

Series Fields

Excluded Fields = shape

Data Commands

series e:vx33-v49r d:2011-01-01T00:00:00.000Z t:input_study_id=304794 t:flow_count=Y t:geobasid=94250370 t:name="RENTON AVE S, N/O S CLOVERDALE ST" t:stname="RENTON AVE S" t:objectid=1 t:downtown=N m:shape_length=4614.87095919744 m:segkey=12522 m:aawdt=8100 m:compkey=12522

series e:vx33-v49r d:2011-01-01T00:00:00.000Z t:input_study_id=307682 t:flow_count=Y t:geobasid=50000650 t:name="AIRPORT WAY S, N/O S NORFOLK ST" t:stname="AIRPORT WAY S" t:objectid=2 t:downtown=N t:hpms=Y m:shape_length=18205.406552658682 m:segkey=8702 m:aawdt=10800 m:compkey=8702

series e:vx33-v49r d:2011-01-01T00:00:00.000Z t:input_study_id=304717 t:flow_count=Y t:geobasid=127150040 t:name="N NORTHGATE WAY, W/O ASHWORTH AVE N" t:stname="N NORTHGATE WAY" t:objectid=3 t:downtown=N t:hpms=Y m:shape_length=4585.847750314948 m:segkey=16114 m:aawdt=26900 m:compkey=16114

Meta Commands

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

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

metric m:aawdt p:integer l:AAWDT d:AAWDT t:dataTypeName=number

metric m:shape_length p:long l:Shape_Length d:SHAPE.LEN t:dataTypeName=number

entity e:vx33-v49r l:"SDOT 2011 Traffic Flow Counts" t:attribution="Seattle Department of Transportation" t:url=https://data.seattle.gov/api/views/vx33-v49r

property e:vx33-v49r t:meta.view v:id=vx33-v49r v:category=Transportation v:attributionLink=http://www.seattle.gov/transportation/ v:averageRating=0 v:name="SDOT 2011 Traffic Flow Counts" v:attribution="Seattle Department of Transportation"

property e:vx33-v49r t:meta.view.license v:name="Public Domain"

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

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

Top Records

| objectid | geobasid  | downtown | compkey | stname           | name                                | year_ | segkey | aawdt | input_study_id | hpms | flow_count | shape | shape_length                                  | 
| ======== | ========= | ======== | ======= | ================ | =================================== | ===== | ====== | ===== | ============== | ==== | ========== | ===== | ============================================= | 
| 1        | 94250370  | N        | 12522   | RENTON AVE S     | RENTON AVE S, N/O S CLOVERDALE ST   | 2011  | 12522  | 8100  | 304794         |      | Y          |       | 4614.8709591974402428604662418365478515625    | 
| 2        | 50000650  | N        | 8702    | AIRPORT WAY S    | AIRPORT WAY S, N/O S NORFOLK ST     | 2011  | 8702   | 10800 | 307682         | Y    | Y          |       | 18205.40655265868190326727926731109619140625  | 
| 3        | 127150040 | N        | 16114   | N NORTHGATE WAY  | N NORTHGATE WAY, W/O ASHWORTH AVE N | 2011  | 16114  | 26900 | 304717         | Y    | Y          |       | 4585.84775031494791619479656219482421875      | 
| 4        | 123450090 | N        | 15794   | N 65TH ST        | N 65TH ST, W/O LINDEN AVE N         | 2011  | 15794  | 8000  | 303940         |      | Y          |       | 12341.358542661795581807382404804229736328125 | 
| 5        | 9550200   | Y        | 2762    | 2ND AVE          | 2ND AVE, NW/O LENORA ST             | 2011  | 2762   | 6000  | 302238         | Y    |            |       | 4161.4757691542663451400585472583770751953125 | 
| 6        | 80150420  | N        | 11190   | LAKE CITY WAY NE | LAKE CITY WAY NE, S/O NE 145TH ST   | 2011  | 11190  | 37100 | 308061         |      | Y          |       | 8237.156888512736259144730865955352783203125  | 
| 7        | 78850080  | Y        | 11055   | JAMES ST         | JAMES ST, NE/O 7TH AVE              | 2011  | 11055  | 41500 | 304509         | Y    | Y          |       | 1288.213150915629739756695926189422607421875  | 
| 8        | 71050870  | N        | 10795   | GREENWOOD AVE N  | GREENWOOD AVE N, S/O N 145TH ST     | 2011  | 10795  | 21400 | 307700         | Y    | Y          |       | 5299.6892151715828731539659202098846435546875 | 
| 9        | 94250400  | N        | 12525   | RENTON AVE S     | RENTON AVE S, SE/O S HENDERSON ST   | 2011  | 12525  | 6800  | 304796         |      | Y          |       | 8271.6342009806321584619581699371337890625    | 
| 10       | 31300190  | Y        | 6138    | 4TH AVE          | 4TH AVE, NW/O LENORA ST             | 2011  | 6138   | 18900 | 302412         | Y    | Y          |       | 3501.3944100822272957884706556797027587890625 |