Right of Way Exception Data

Dataset

Name Value
Catalog Link
Metadata Link
Data: JSON 100 Rows
Data: CSV 100 Rows
Host data.sfgov.org
Id yrgu-vakm
Name Right of Way Exception Data
Attribution San Francisco Department of Public Works
Category City Infrastructure
Tags exceptions, street, restrictions, permits
Created 2012-09-25T00:09:14Z
Publication Date 2015-07-17T15:20:34Z

Description

A table of restrictions and information about existing conditions in the public right of way. including permits, moratorium streets, AWSS, SFMTA bluebook, 5 year plan, bike lanes, jurisdiction, monuments, etc. AKA Street Restrictions, The Exception Table

Columns

| Included | Schema Type    | Field Name         | Name               | Data Type     | Render Type   |
| ======== | ============== | ================== | ================== | ============= | ============= |
| Yes      | series tag     | ctrid              | ctrID              | text          | number        |
| Yes      | numeric metric | cnn                | CNN                | number        | number        |
| Yes      | series tag     | exceptioncode      | ExceptionCode      | text          | text          |
| Yes      | series tag     | permittype         | PermitType         | text          | text          |
| Yes      | series tag     | jobordernum        | JobOrderNum        | text          | text          |
| Yes      | series tag     | projectname        | ProjectName        | text          | text          |
| No       |                | effectivedate      | EffectiveDate      | calendar_date | calendar_date |
| No       |                | expirationdate     | ExpirationDate     | calendar_date | calendar_date |
| Yes      | series tag     | contactname        | ContactName        | text          | text          |
| Yes      | series tag     | contactphonenumber | ContactPhoneNumber | text          | text          |
| Yes      | series tag     | restriction_tow    | Restriction_Tow    | text          | text          |
| Yes      | time           | modifieddate       | ModifiedDate       | calendar_date | calendar_date |
| Yes      | series tag     | block              | block              | text          | text          |
| Yes      | series tag     | lot                | lot                | text          | text          |

Time Field

Value = modifieddate
Format & Zone = yyyy-MM-dd'T'HH:mm:ss

Series Fields

Excluded Fields = expirationdate,effectivedate

Data Commands

series e:yrgu-vakm d:2012-02-15T16:27:02.000Z t:contactname="Alex Demisch" t:exceptioncode=SFPARK t:ctrid=625234 t:contactphonenumber="(415) 701-4507" m:cnn=9122002

series e:yrgu-vakm d:2012-02-15T16:27:02.000Z t:contactname="Alex Demisch" t:exceptioncode=SFPARK t:ctrid=625235 t:contactphonenumber="(415) 701-4507" m:cnn=9122001

series e:yrgu-vakm d:2012-02-15T16:27:02.000Z t:contactname="Alex Demisch" t:exceptioncode=SFPARK t:ctrid=625236 t:contactphonenumber="(415) 701-4507" m:cnn=12318002

Meta Commands

metric m:cnn p:integer l:CNN t:dataTypeName=number

entity e:yrgu-vakm l:"Right of Way Exception Data" t:attribution="San Francisco Department of Public Works" t:url=https://data.sfgov.org/api/views/yrgu-vakm

property e:yrgu-vakm t:meta.view d:2017-09-25T07:24:35.752Z v:averageRating=0 v:name="Right of Way Exception Data" v:attribution="San Francisco Department of Public Works" v:attributionLink=http://www.sfdpw.org v:id=yrgu-vakm v:category="City Infrastructure"

property e:yrgu-vakm t:meta.view.license d:2017-09-25T07:24:35.752Z v:name="Open Data Commons Public Domain Dedication and License" v:termsLink=http://opendatacommons.org/licenses/pddl/1.0/

property e:yrgu-vakm t:meta.view.owner d:2017-09-25T07:24:35.752Z v:displayName="Public Works" v:profileImageUrlLarge=/api/users/rcpp-nrjq/profile_images/LARGE v:profileImageUrlSmall=/api/users/rcpp-nrjq/profile_images/TINY v:id=rcpp-nrjq v:screenName="Public Works" v:profileImageUrlMedium=/api/users/rcpp-nrjq/profile_images/THUMB

property e:yrgu-vakm t:meta.view.tableauthor d:2017-09-25T07:24:35.752Z v:displayName="Public Works" v:profileImageUrlLarge=/api/users/rcpp-nrjq/profile_images/LARGE v:roleName=editor v:profileImageUrlSmall=/api/users/rcpp-nrjq/profile_images/TINY v:id=rcpp-nrjq v:screenName="Public Works" v:profileImageUrlMedium=/api/users/rcpp-nrjq/profile_images/THUMB

Top Records

| ctrid  | cnn      | exceptioncode | permittype | jobordernum | projectname | effectivedate       | expirationdate | contactname  | contactphonenumber | restriction_tow | modifieddate        | block | lot | 
| ====== | ======== | ============= | ========== | =========== | =========== | =================== | ============== | ============ | ================== | =============== | =================== | ===== | === | 
| 625234 | 9122002  | SFPARK        |            |             |             | 1980-01-01T00:00:00 |                | Alex Demisch | (415) 701-4507     |                 | 2012-02-15T16:27:02 |       |     | 
| 625235 | 9122001  | SFPARK        |            |             |             | 1980-01-01T00:00:00 |                | Alex Demisch | (415) 701-4507     |                 | 2012-02-15T16:27:02 |       |     | 
| 625236 | 12318002 | SFPARK        |            |             |             | 1980-01-01T00:00:00 |                | Alex Demisch | (415) 701-4507     |                 | 2012-02-15T16:27:02 |       |     | 
| 625237 | 12318001 | SFPARK        |            |             |             | 1980-01-01T00:00:00 |                | Alex Demisch | (415) 701-4507     |                 | 2012-02-15T16:27:02 |       |     | 
| 625238 | 10624002 | SFPARK        |            |             |             | 1980-01-01T00:00:00 |                | Alex Demisch | (415) 701-4507     |                 | 2012-02-15T16:27:02 |       |     | 
| 625239 | 10624001 | SFPARK        |            |             |             | 1980-01-01T00:00:00 |                | Alex Demisch | (415) 701-4507     |                 | 2012-02-15T16:27:02 |       |     | 
| 625240 | 12553102 | SFPARK        |            |             |             | 1980-01-01T00:00:00 |                | Alex Demisch | (415) 701-4507     |                 | 2012-02-15T16:27:02 |       |     | 
| 625241 | 12553103 | SFPARK        |            |             |             | 1980-01-01T00:00:00 |                | Alex Demisch | (415) 701-4507     |                 | 2012-02-15T16:27:02 |       |     | 
| 625242 | 12158002 | SFPARK        |            |             |             | 1980-01-01T00:00:00 |                | Alex Demisch | (415) 701-4507     |                 | 2012-02-15T16:27:02 |       |     | 
| 625243 | 12158001 | SFPARK        |            |             |             | 1980-01-01T00:00:00 |                | Alex Demisch | (415) 701-4507     |                 | 2012-02-15T16:27:02 |       |     |