SDOT Bike Racks

Dataset

Name Value
Catalog Link
Metadata Link
Data: JSON 100 Rows
Data: CSV 100 Rows
Host data.seattle.gov
Id qwc9-dpzw
Name SDOT Bike Racks
Category Transportation
Tags bikes, bicycles, racks, streets, seattle, parking, sdot asset status and condition report, assets
Created 2015-03-19T15:23:17Z
Publication Date 2015-03-19T15:27:55Z

Description

Displays the location and attributes of bike racks in the City of Seattle including the type of rack facility, type of mount, style of rack and color of the bike rack.

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 | segkey                    | SEGKEY                    | number    | 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     | bike_facility             | BIKE_FACILITY             | text      | text        |
| Yes      | numeric metric | rack_capacity             | RACK_CAPACITY             | number    | number      |
| Yes      | series tag     | delineator_posts          | DELINEATOR_POSTS          | text      | text        |
| Yes      | series tag     | finish_type               | FINISH_TYPE               | text      | text        |
| Yes      | series tag     | surface_type              | SURFACE_TYPE              | text      | text        |
| No       |                | install_date              | INSTALL_DATE              | date      | date        |
| Yes      | series tag     | mount_type                | MOUNT_TYPE                | text      | text        |
| Yes      | series tag     | color                     | COLOR                     | text      | text        |
| Yes      | series tag     | manufacturer              | MANUFACTURER              | text      | text        |
| Yes      | series tag     | model_type                | MODEL_TYPE                | text      | text        |
| Yes      | series tag     | condition                 | CONDITION                 | text      | text        |
| Yes      | time           | condition_assessment_date | CONDITION_ASSESSMENT_DATE | date      | date        |
| 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     | 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 = install_date

Data Commands

series e:qwc9-dpzw d:2009-08-19T00:00:00.000Z t:delineator_posts=N t:condition=GOOD t:comptype=16 t:current_status=INSVC t:unitdesc="EASTLAKE AVE E 0320 BLOCK NW SIDE ( 101) 101 FT NE/O HARVARD AVE E" t:ownership=SDOT t:unitid=BKR-265 t:color=NONE t:side=NW t:finish_type=GALV t:manufacturer=BKR-CRMTL t:overrideyn=N t:primarydistrictcd=DISTRICT3 t:model_type=BKR-RLRCK t:objectid=1 t:surface_type=PCC t:unittype=BKR t:mount_type=SUFMT t:bike_facility=SGL m:distance=101 m:segkey=10184 m:rack_capacity=2 m:width=34 m:compkey=517101

series e:qwc9-dpzw d:2009-08-17T00:00:00.000Z t:delineator_posts=N t:condition=GOOD t:comptype=16 t:current_status=INSVC t:unitdesc="35TH AVE SW 0730 BLOCK E SIDE ( 501) 119 FT N/O SW WEBSTER ST" t:ownership=SDOT t:unitid=BKR-2646 t:color=NONE t:side=E t:finish_type=GALV t:manufacturer=BKR-CRMTL t:overrideyn=N t:primarydistrictcd=DISTRICT1 t:model_type=BKR-RLRCK t:objectid=2 t:surface_type=PCC t:unittype=BKR t:mount_type=SUFMT t:bike_facility=SGL m:distance=524 m:segkey=5466 m:rack_capacity=2 m:width=31 m:compkey=518581

series e:qwc9-dpzw d:2017-04-21T08:13:46.873Z t:delineator_posts=N t:comptype=16 t:unitdesc="4TH AVE NE 0400 BLOCK E SIDE ( 335) 335 FT N/O NE 40 UPPER ST" t:unitid=BKR-3357 t:ownership=SDOT t:side=E t:finish_type=GALV t:primarydistrictcd=DISTRICT4 t:overrideyn=N t:objectid=3 t:surface_type=PCC t:unittype=BKR t:bike_facility=SGL m:distance=348 m:segkey=6173 m:rack_capacity=10 m:width=-17 m:compkey=614105

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:distance p:decimal l:DISTANCE d:DISTANCE t:dataTypeName=number

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

metric m:rack_capacity p:integer l:RACK_CAPACITY d:RACK_CAPACITY t:dataTypeName=number

entity e:qwc9-dpzw l:"SDOT Bike Racks" t:url=https://data.seattle.gov/api/views/qwc9-dpzw

property e:qwc9-dpzw t:meta.view v:id=qwc9-dpzw v:category=Transportation v:attributionLink=http://www.seattle.gov/transportation/ v:averageRating=0 v:name="SDOT Bike Racks"

property e:qwc9-dpzw t:meta.view.license v:name="Public Domain"

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

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

Top Records

| objectid | compkey | comptype | segkey | distance | width | unitid   | unittype | unitdesc                                                           | bike_facility | rack_capacity | delineator_posts | finish_type | surface_type | install_date | mount_type | color | manufacturer | model_type | condition | condition_assessment_date | side | ownership | current_status | primarydistrictcd | secondarydistrictcd | overrideyn | overridecomment | 
| ======== | ======= | ======== | ====== | ======== | ===== | ======== | ======== | ================================================================== | ============= | ============= | ================ | =========== | ============ | ============ | ========== | ===== | ============ | ========== | ========= | ========================= | ==== | ========= | ============== | ================= | =================== | ========== | =============== | 
| 1        | 517101  | 16       | 10184  | 101      | 34    | BKR-265  | BKR      | EASTLAKE AVE E 0320 BLOCK NW SIDE ( 101) 101 FT NE/O HARVARD AVE E | SGL           | 2             | N                | GALV        | PCC          | 1132704000   | SUFMT      | NONE  | BKR-CRMTL    | BKR-RLRCK  | GOOD      | 1250640000                | NW   | SDOT      | INSVC          | DISTRICT3         |                     | N          |                 | 
| 2        | 518581  | 16       | 5466   | 524      | 31    | BKR-2646 | BKR      | 35TH AVE SW 0730 BLOCK E SIDE ( 501) 119 FT N/O SW WEBSTER ST      | SGL           | 2             | N                | GALV        | PCC          |              | SUFMT      | NONE  | BKR-CRMTL    | BKR-RLRCK  | GOOD      | 1250467200                | E    | SDOT      | INSVC          | DISTRICT1         |                     | N          |                 | 
| 3        | 614105  | 16       | 6173   | 348      | -17   | BKR-3357 | BKR      | 4TH AVE NE 0400 BLOCK E SIDE ( 335) 335 FT N/O NE 40 UPPER ST      | SGL           | 10            | N                | GALV        | PCC          | 1396742400   |            |       |              |            |           |                           | E    | SDOT      |                | DISTRICT4         |                     | N          |                 | 
| 4        | 606481  | 16       | 4972   | 484      | 17    | BKR-3320 | BKR      | 32ND AVE NE 1400 BLOCK W SIDE ( 471) 170 FT S/O NE 143RD ST        | SGL           | 2             | N                | GALV        | PCC          | 1383264000   |            |       |              |            |           |                           | W    | SDOT      |                | DISTRICT5         |                     | N          |                 | 
| 5        | 516697  | 16       | 2929   | 45       | 17    | BKR-1415 | BKR      | 20TH AVE 0010 BLOCK W SIDE ( 32) 32 FT N/O E YESLER WAY            | SGL           | 2             | N                | GALV        | PCC          |              | SUFMT      | NONE  | BKR-CRMTL    | BKR-RLRCK  | GOOD      | 1248307200                | W    | SDOT      | INSVC          | DISTRICT3         |                     | N          |                 | 
| 6        | 516721  | 16       | 3232   | 130      | -17   | BKR-342  | BKR      | 22ND AVE 0140 BLOCK E SIDE ( 117) 117 FT N/O E UNION ST            | SGL           | 2             | N                | GALV        | PCC          | 1076976000   | SUFMT      | NONE  | BKR-CRMTL    | BKR-RLRCK  | GOOD      | 1248220800                | E    | SDOT      | INSVC          | DISTRICT3         |                     | N          |                 | 
| 7        | 517099  | 16       | 10184  | 139      | -34   | BKR-2514 | BKR      | EASTLAKE AVE E 0320 BLOCK SE SIDE ( 139) 139 FT NE/O HARVARD AVE E | SGL           | 2             | N                | GALV        | PCC          |              | SUFMT      | NONE  | BKR-ARCRE    | BKR-RLRCK  | GOOD      | 1250640000                | SE   | SDOT      | INSVC          | DISTRICT3         |                     | N          |                 | 
| 8        | 517291  | 16       | 12131  | 36       | -26   | BKR-828  | BKR      | PHINNEY AVE N 0350 BLOCK E SIDE ( 12) 12 FT N/O N 35TH ST          | SGL           | 2             | N                | PAINT       | PCC-PAD      | 1249257600   | SUFMT      | GRN   | BKR-CRMTL    | BKR-RLRCK  | GOOD      | 1248825600                | E    | SDOT      | INSVC          | DISTRICT6         |                     | N          |                 | 
| 9        | 518518  | 16       | 4987   | 215      | -24   | BKR-2474 | BKR      | 32ND AVE NW 0640 BLOCK E SIDE ( 185) 0 FT S/O NW 65TH ST           | SGL           | 2             | N                | GALV        | PCC          |              | SUFMT      | NONE  | BKR-CRMTL    | BKR-RLRCK  | GOOD      | 1249257600                | E    | SDOT      | INSVC          | DISTRICT6         |                     | N          |                 | 
| 10       | 517241  | 16       | 6143   | 207      | 34    | BKR-1216 | BKR      | 4TH AVE 0260 BLOCK SW SIDE ( 181) 79 FT SE/O CEDAR ST              | SGL           | 2             | N                | GALV        | PCC          |              | SUFMT      | NONE  | BKR-CRMTL    | BKR-RLRCK  | GOOD      | 1247788800                | SW   | SDOT      | INSVC          | DISTRICT7         |                     | N          |                 |