Parking Signs / Street Space Permits
Dataset
| Name | Value |
|---|---|
| Catalog | Link |
| Metadata | Link |
| Data: JSON | 100 Rows |
| Data: CSV | 100 Rows |
| Host | data.sfgov.org |
| Id | sftu-nd43 |
| Name | Parking Signs / Street Space Permits |
| Attribution | San Francisco Department of Public Works |
| Category | City Infrastructure |
| Tags | permits, construction, buildings, sidewalk, sfmta, tow, verification, street, space, parking, signs |
| Created | 2016-12-30T17:54:45Z |
| Publication Date | 2017-04-18T03:21:44Z |
Description
Parking Signs / Street Space permits are generally issued for construction related work such as building construction activities or sidewalk repair work. Related photos of posted signs are here: https://data.sfgov.org/d/pigs-fac7
Columns
| Included | Schema Type | Field Name | Name | Data Type | Render Type |
| ======== | ============== | ================== | ================== | ============= | ============= |
| Yes | time | datetimeentered | DateTimeEntered | calendar_date | calendar_date |
| No | | datetimeposted | DateTimePosted | calendar_date | calendar_date |
| No | | updatedon | UpdatedOn | calendar_date | calendar_date |
| Yes | series tag | category | Category | text | text |
| Yes | series tag | source | Source | text | text |
| Yes | series tag | signtype | SignType | text | text |
| Yes | series tag | companyname | CompanyName | text | text |
| Yes | series tag | companyphone | CompanyPhone | text | text |
| Yes | series tag | permitnumber | PermitNumber | text | text |
| Yes | numeric metric | numberofsigns | NumberOfSigns | number | number |
| No | | startdate | StartDate | text | text |
| No | | enddate | EndDate | text | text |
| Yes | series tag | starttime | StartTime | text | text |
| Yes | series tag | endtime | EndTime | text | text |
| Yes | series tag | notes | Notes | text | text |
| Yes | series tag | 24hourenforcement | 24HourEnforcement | text | text |
| Yes | series tag | signid | SignID | text | number |
| Yes | series tag | sideofstreet | SideOfStreet | text | text |
| Yes | series tag | location_1 | location_desc | text | text |
| No | | address | address | text | text |
| Yes | numeric metric | cnn | cnn | number | number |
| Yes | series tag | streetfrontagefeet | StreetFrontageFeet | text | number |
| Yes | series tag | block | Block | text | text |
| Yes | series tag | lot | Lot | text | text |
| No | | latitude | Latitude | number | number |
| No | | longitude | Longitude | number | number |
| Yes | series tag | signlink | SignLink | url | url |
| Yes | series tag | alldatalink | AllDataLink | url | url |
| Yes | series tag | streetfrontagename | StreetFrontageName | text | text |
| Yes | series tag | streetfrontagefrom | StreetFrontageFrom | text | text |
| Yes | series tag | streetfrontageto | StreetFrontageTo | text | text |
Time Field
Value = datetimeentered
Format & Zone = yyyy-MM-dd'T'HH:mm:ss
Series Fields
Excluded Fields = datetimeposted,updatedon,enddate,address,latitude,longitude,startdate
Data Commands
series e:sftu-nd43 d:2017-04-06T14:22:33.000Z t:endtime=23:00 t:starttime=0:00 t:companyphone=415-238-7744 t:block=0976 t:streetfrontagefrom="BRODERICK ST" t:streetfrontageto="BAKER ST" t:signid=89973 t:streetfrontagefeet=20 t:alldatalink="http://bsm.sfdpw.org/permit/StreetSpaceInfo.aspx?id=2017040053236" t:companyname="DESIGN & DEVELOP CONSTRUCTION" t:signlink="http://bsm.sfdpw.org/permitstracker/reports/report.aspx?report=rptParkingSignV3¶ms=signid=89973&ExportPDF=1&filename=89973" t:category="Construction - Private" t:source=StreetSpaceRequest t:streetfrontagename="PACIFIC AVE" t:permitnumber=2017040053236 t:24hourenforcement=N t:lot=035 t:sideofstreet=N t:notes="12AM - 11:59PM - Mon - Sun" t:location_1="PACIFIC AVE: BRODERICK ST to BAKER ST (2900 - 2999)" t:signtype=DBI m:numberofsigns=2 m:cnn=10161000
series e:sftu-nd43 d:2016-11-28T08:25:11.000Z t:endtime=18:00 t:starttime=7:00 t:companyphone=415-916-2856 t:block=1157 t:streetfrontagefrom="BRODERICK ST" t:streetfrontageto="BAKER ST" t:signid=77254 t:streetfrontagefeet=100 t:alldatalink="http://bsm.sfdpw.org/permit/StreetSpaceInfo.aspx?id=M740487" t:companyname="Fineline Construction" t:signlink="http://bsm.sfdpw.org/permitstracker/reports/report.aspx?report=rptParkingSignV3¶ms=signid=77254&ExportPDF=1&filename=77254" t:category="Construction - Private" t:source=StreetSpaceRequest t:streetfrontagename="MCALLISTER ST" t:permitnumber=M740487 t:24hourenforcement=N t:lot=007 t:sideofstreet=N t:notes="7AM - 6PM - Mon - Fri" t:location_1="MCALLISTER ST: BRODERICK ST to BAKER ST (1700 - 1799)" t:signtype=DBI m:numberofsigns=6 m:cnn=8905000
series e:sftu-nd43 d:2016-10-31T15:38:02.000Z t:endtime=18:00 t:starttime=7:00 t:companyphone=510-885-1110 t:block=0984 t:streetfrontagefrom="PRESIDIO AVE" t:streetfrontageto="WALNUT ST" t:signid=74661 t:streetfrontagefeet=32 t:alldatalink="http://bsm.sfdpw.org/permit/StreetSpaceInfo.aspx?id=M734887" t:companyname="Welch Construction" t:signlink="http://bsm.sfdpw.org/permitstracker/reports/report.aspx?report=rptParkingSignV3¶ms=signid=74661&ExportPDF=1&filename=74661" t:category="Construction - Private" t:source=StreetSpaceRequest t:streetfrontagename="WASHINGTON ST" t:permitnumber=M734887 t:24hourenforcement=N t:lot=010 t:sideofstreet=N t:notes="7AM - 6PM - Mon - Fri" t:location_1="WASHINGTON ST: PRESIDIO AVE to WALNUT ST (3300 - 3399)" t:signtype=DBI m:numberofsigns=3 m:cnn=13446000
Meta Commands
metric m:numberofsigns p:integer l:NumberOfSigns t:dataTypeName=number
metric m:cnn p:integer l:cnn t:dataTypeName=number
entity e:sftu-nd43 l:"Parking Signs / Street Space Permits" t:attribution="San Francisco Department of Public Works" t:url=https://data.sfgov.org/api/views/sftu-nd43
property e:sftu-nd43 t:meta.view v:id=sftu-nd43 v:category="City Infrastructure" v:attributionLink=http://www.sfpublicworks.org v:averageRating=0 v:name="Parking Signs / Street Space Permits" v:attribution="San Francisco Department of Public Works"
property e:sftu-nd43 t:meta.view.license v:name="Open Data Commons Public Domain Dedication and License" v:termsLink=http://opendatacommons.org/licenses/pddl/1.0/
property e:sftu-nd43 t:meta.view.owner v:id=rcpp-nrjq v:profileImageUrlMedium=/api/users/rcpp-nrjq/profile_images/THUMB v:profileImageUrlLarge=/api/users/rcpp-nrjq/profile_images/LARGE v:screenName="Public Works" v:profileImageUrlSmall=/api/users/rcpp-nrjq/profile_images/TINY v:displayName="Public Works"
property e:sftu-nd43 t:meta.view.tableauthor v:id=rcpp-nrjq v:profileImageUrlMedium=/api/users/rcpp-nrjq/profile_images/THUMB v:profileImageUrlLarge=/api/users/rcpp-nrjq/profile_images/LARGE v:screenName="Public Works" v:profileImageUrlSmall=/api/users/rcpp-nrjq/profile_images/TINY v:roleName=editor v:displayName="Public Works"
Top Records
| datetimeentered | datetimeposted | updatedon | category | source | signtype | companyname | companyphone | permitnumber | numberofsigns | startdate | enddate | starttime | endtime | notes | 24hourenforcement | signid | sideofstreet | location_1 | address | cnn | streetfrontagefeet | block | lot | latitude | longitude | signlink | alldatalink | streetfrontagename | streetfrontagefrom | streetfrontageto |
| =================== | =================== | =================== | ====================== | ================== | ======== | ==================================== | ============ | ============= | ============= | ========== | ========== | ========= | ======= | =========================== | ================= | ====== | ============ | =============================================================== | ================== | ======== | ================== | ===== | ==== | ================ | ================= | ================================================================================================================================== | ========================================================================= | ================== | ================== | ================ |
| 2017-04-06T14:22:33 | 1900-01-01T00:00:00 | 2017-04-06T14:22:33 | Construction - Private | StreetSpaceRequest | DBI | DESIGN & DEVELOP CONSTRUCTION | 415-238-7744 | 2017040053236 | 2 | 04/13/2017 | 05/13/2017 | 0:00 | 23:00 | 12AM - 11:59PM - Mon - Sun | N | 89973 | N | PACIFIC AVE: BRODERICK ST to BAKER ST (2900 - 2999) | 2945 PACIFIC AVE | 10161000 | 20 | 0976 | 035 | 37.7919324064038 | -122.443726051883 | [http://bsm.sfdpw.org/permitstracker/reports/report.aspx?report=rptParkingSignV3?ms=signid=89973&ExportPDF=1&filename=89973, null] | [http://bsm.sfdpw.org/permit/StreetSpaceInfo.aspx?id=2017040053236, null] | PACIFIC AVE | BRODERICK ST | BAKER ST |
| 2016-11-28T08:25:11 | 2016-11-28T08:25:14 | 2016-11-28T08:25:11 | Construction - Private | StreetSpaceRequest | DBI | Fineline Construction | 415-916-2856 | M740487 | 6 | 12/01/2016 | 06/01/2017 | 7:00 | 18:00 | 7AM - 6PM - Mon - Fri | N | 77254 | N | MCALLISTER ST: BRODERICK ST to BAKER ST (1700 - 1799) | 1750 MCALLISTER ST | 8905000 | 100 | 1157 | 007 | 37.7777702416758 | -122.44053811009 | [http://bsm.sfdpw.org/permitstracker/reports/report.aspx?report=rptParkingSignV3?ms=signid=77254&ExportPDF=1&filename=77254, null] | [http://bsm.sfdpw.org/permit/StreetSpaceInfo.aspx?id=M740487, null] | MCALLISTER ST | BRODERICK ST | BAKER ST |
| 2016-10-31T15:38:02 | 2016-10-31T15:38:15 | 2016-10-31T15:38:02 | Construction - Private | StreetSpaceRequest | DBI | Welch Construction | 510-885-1110 | M734887 | 3 | 11/03/2016 | 05/03/2017 | 7:00 | 18:00 | 7AM - 6PM - Mon - Fri | N | 74661 | N | WASHINGTON ST: PRESIDIO AVE to WALNUT ST (3300 - 3399) | 3340 WASHINGTON ST | 13446000 | 32 | 0984 | 010 | 37.7901068196733 | -122.448172279309 | [http://bsm.sfdpw.org/permitstracker/reports/report.aspx?report=rptParkingSignV3?ms=signid=74661&ExportPDF=1&filename=74661, null] | [http://bsm.sfdpw.org/permit/StreetSpaceInfo.aspx?id=M734887, null] | WASHINGTON ST | PRESIDIO AVE | WALNUT ST |
| 2017-02-17T08:51:14 | 2017-02-18T15:48:33 | 2017-02-17T08:51:14 | Construction - Private | StreetSpaceRequest | DBI | Sure Inc | 415-706-6170 | M759347 | 2 | 02/22/2017 | 05/22/2017 | 7:30 | 5:30 | 7:30AM - 5:30AM - Mon - Sat | N | 84760 | N | UNION ST: LARKIN ST to POLK ST (1300 - 1399) | 1330 UNION ST | 12862000 | 20 | 0525 | 009 | 37.7991272348573 | -122.421280060435 | [http://bsm.sfdpw.org/permitstracker/reports/report.aspx?report=rptParkingSignV3?ms=signid=84760&ExportPDF=1&filename=84760, null] | [http://bsm.sfdpw.org/permit/StreetSpaceInfo.aspx?id=M759347, null] | UNION ST | LARKIN ST | POLK ST |
| 2017-04-03T15:22:43 | 2017-04-06T09:45:27 | 2017-04-03T15:22:43 | Construction - Private | StreetSpaceRequest | DBI | Matt Sanford Homes | 415-706-4168 | 201702038579 | 2 | 04/10/2017 | 08/10/2017 | 7:00 | 18:00 | 7AM - 6PM - Mon - Sat | N | 89370 | N | 30TH AVE: GEARY BLVD to ANZA ST (500 - 599) | 590 30TH AVE | 1642000 | 20 | 1515 | 020A | 37.778149052175 | -122.489687469789 | [http://bsm.sfdpw.org/permitstracker/reports/report.aspx?report=rptParkingSignV3?ms=signid=89370&ExportPDF=1&filename=89370, null] | [http://bsm.sfdpw.org/permit/StreetSpaceInfo.aspx?id=201702038579, null] | 30TH AVE | GEARY BLVD | ANZA ST |
| 2017-03-16T13:33:02 | 2017-03-22T17:07:55 | 2017-03-16T13:33:02 | Construction - Private | StreetSpaceRequest | DBI | hunts construction partnership | 408-858-7007 | M768907 | 2 | 03/23/2017 | 05/23/2017 | 8:00 | 17:00 | 8AM - 5PM - Mon - Fri | N | 87521 | N | CALIFORNIA ST: 26TH AVE to 27TH AVE (6400 - 6499) | 6423 CALIFORNIA ST | 3603000 | 20 | 1407 | 046 | 37.7835675795187 | -122.486511246171 | [http://bsm.sfdpw.org/permitstracker/reports/report.aspx?report=rptParkingSignV3?ms=signid=87521&ExportPDF=1&filename=87521, null] | [http://bsm.sfdpw.org/permit/StreetSpaceInfo.aspx?id=M768907, null] | CALIFORNIA ST | 26TH AVE | 27TH AVE |
| 2017-03-08T11:48:14 | 2017-03-15T08:16:12 | 2017-03-08T11:48:14 | Construction - Private | StreetSpaceRequest | DBI | Houseworks | 415-394-9300 | 201612134867 | 2 | 03/07/2017 | 05/07/2017 | 7:00 | 18:00 | 7AM - 6PM - Mon - Fri | N | 86683 | N | MISSOURI ST: 19TH ST to 20TH ST (400 - 499) | 430 MISSOURI ST | 9211000 | 20 | 4067 | 005 | 37.7608150730542 | -122.396670792546 | [http://bsm.sfdpw.org/permitstracker/reports/report.aspx?report=rptParkingSignV3?ms=signid=86683&ExportPDF=1&filename=86683, null] | [http://bsm.sfdpw.org/permit/StreetSpaceInfo.aspx?id=201612134867, null] | MISSOURI ST | 19TH ST | 20TH ST |
| 2017-02-15T08:46:05 | 1900-01-01T00:00:00 | 2017-02-15T08:46:05 | Construction - Private | StreetSpaceRequest | DBI | CHL CONSTRUCTION | 415-297-8897 | 20161152686 | 2 | 02/21/2017 | 04/21/2017 | 7:00 | 18:00 | 7AM - 6PM - Mon - Sat | N | 84415 | N | 04TH ST: CHANNEL to LONG BRIDGE ST (1100 - 1175) | 1170 04TH ST | 19981000 | 20 | 8711 | 014 | 37.7735407994211 | -122.392027896039 | [http://bsm.sfdpw.org/permitstracker/reports/report.aspx?report=rptParkingSignV3?ms=signid=84415&ExportPDF=1&filename=84415, null] | [http://bsm.sfdpw.org/permit/StreetSpaceInfo.aspx?id=20161152686, null] | 04TH ST | CHANNEL | LONG BRIDGE ST |
| 2016-12-07T10:19:46 | 2016-12-07T10:19:51 | 2016-12-07T10:19:46 | Construction - Private | StreetSpaceRequest | DBI | swinerton builders | 415-421-2980 | M737467 | 3 | 12/10/2016 | 05/10/2017 | 6:00 | 15:00 | 6AM - 3PM - Mon - Sun | N | 78339 | N | MISSION ST: FREMONT ST to 01ST ST (400 - 499) | 50 FREMONT ST | 9087000 | 40 | 3709 | 006A | 37.790304371639 | -122.397365063531 | [http://bsm.sfdpw.org/permitstracker/reports/report.aspx?report=rptParkingSignV3?ms=signid=78339&ExportPDF=1&filename=78339, null] | [http://bsm.sfdpw.org/permit/StreetSpaceInfo.aspx?id=M737467, null] | MISSION ST | FREMONT ST | 01ST ST |
| 2016-12-20T09:00:58 | 2017-01-07T23:01:45 | 2016-12-20T09:00:58 | Construction - Private | StreetSpaceRequest | DBI | Envision Construction & Design, Inc. | 925-560-9906 | 201511243561 | 2 | 01/03/2017 | 07/03/2017 | 5:30 | 17:00 | 5:30AM - 5PM - Mon - Sat | N | 79446 | N | DIVISADERO ST: ELLIS ST to OFARRELL ST (1301 - 1399) -- WEST -- | 2107 OFARRELL ST | 4810101 | 20 | 1101 | 001 | 37.782232534961 | -122.439580287088 | [http://bsm.sfdpw.org/permitstracker/reports/report.aspx?report=rptParkingSignV3?ms=signid=79446&ExportPDF=1&filename=79446, null] | [http://bsm.sfdpw.org/permit/StreetSpaceInfo.aspx?id=201511243561, null] | DIVISADERO ST | ELLIS ST | OFARRELL ST |