Street_Tree_List

Data source: data.sfgov.org

229 rows where PlantType = 2 sorted by DBH

View and edit SQL

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH ▼ PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
114798 105147 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 52 Mirabel Ave   Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1   12/26/2013 12:00:00 AM   3X3 Permit Number 771012 6007663.7 2099931.8 37.7464458666696 -122.41622057503099 (37.7464458666696, -122.416220575031)
114892 115259 Permitted Site 1 :: 54 2130 Jackson St   Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1   01/21/2016 12:00:00 AM   6x12   6003918.8 2117004.0 37.7931106894063 -122.43038787884501 (37.7931106894063, -122.430387878845)
115357 98501 Property Tree 7 Tree(s) :: 17 232 Glenview Dr   Back Yard : Yard 13 Landscaping 2 Private 1           5998998.0 2100740.0 37.748173910048706 -122.446243600021 (37.7481739100487, -122.446243600021)
115664 85184 Permitted Site 1 Eriobotrya deflexa :: Bronze Loquat 49 501 Bartlett St   Sidewalk: Property side : Cutout 5 Landscaping 2 Private 1   12/13/2006 12:00:00 AM   3x25 Permit Number 768657 6006822.0 2100867.0 37.748966349809606 -122.419197411761 (37.7489663498096, -122.419197411761)
117077 89137 Permitted Site 1 Tree(s) :: 17 3170 23rd St   Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1   10/06/2008 12:00:00 AM     Permit Number 770875 6007866.1 2102749.5 37.7541940143569 -122.41572017373001 (37.7541940143569, -122.41572017373)
117306 104857 Permitted Site 1 :: 54 2555 46th Ave   Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1           5982069.8 2097707.6 37.7388664658919 -122.504555139124 (37.7388664658919, -122.504555139124)
118010 109755 Permitted Site 1 :: 54 601 Steiner St 2 Sidewalk: Property side : Cutout 5 Landscaping 2 Private 1       1x12   6003025.4 2110381.6 37.774876602731204 -122.433005738531 (37.7748766027312, -122.433005738531)
118218 104635 Permitted Site 1 :: 54 217 Montcalm St   Front Yard : Yard 7 Landscaping 2 Private 1       16x16   6009833.3 2099565.6 37.7455621186719 -122.40869248022899 (37.7455621186719, -122.408692480229)
118241 4313 DPW Maintained 3 Shrub :: Shrub 98 727 Chenery St 1 Sidewalk: Curb side : Cutout 1 Landscaping 2 DPW 2   08/17/2013 12:00:00 AM   3X3   6002321.2517800005 2095689.19659 37.7344948117373 -122.434390856497 (37.7344948117373, -122.434390856497)
119565 99732 Undocumented 2 Shrub :: Shrub 98 4150 Ocean Ave 1 Sidewalk: Property side : Cutout 5 Landscaping 2 Private 1           5986619.2 2095203.6 37.7322576937009 -122.48864164528798 (37.7322576937009, -122.488641645288)
119638 109607 Private 5 Shrub :: Shrub 98 775 Congo St 1 Front Yard : Yard 7 Landscaping 2 Private 1           6000381.8 2095947.7 37.7350943222142 -122.44111470541901 (37.7350943222142, -122.441114705419)
120169 104564 Private 5 Private shrub :: Private Shrub 64 18 FLOOD AVE 1 Front Yard : Yard 7 Landscaping 2 Private 1           6000327.0 2094154.0 37.730166118083794 -122.44117551704201 (37.7301661180838, -122.441175517042)
120372 88656 Permitted Site 1 Ginkgo biloba 'Autumn Sentinel' :: Autumn Sentinel Ginkgo 461 94 Danton St   Sidewalk: Property side : Cutout 5 Landscaping 2 Private 1   08/05/2008 12:00:00 AM     Permit Number 51634 6002844.0 2094598.0 37.7315282931893 -122.43250562955099 (37.7315282931893, -122.432505629551)
120634 116580 Significant Tree 6 Shrub :: Shrub 98 3000x 19TH AVE 3 Sidewalk: Property side : Cutout 5 Landscaping 2 MTA 6 DPW 4     3x3   5990602.0 2095184.0 37.7324354869182 -122.47487091251001 (37.7324354869182, -122.47487091251)
121197 109754 Permitted Site 1 :: 54 601 Steiner St 1 Sidewalk: Property side : Cutout 5 Landscaping 2 Private 1       1x12   6003025.4 2110381.6 37.774876602731204 -122.433005738531 (37.7748766027312, -122.433005738531)
122339 104861 Permitted Site 1 :: 54 3458A 18th St   Sidewalk: Property side : Cutout 5 Landscaping 2 Private 1           6006508.0 2105569.9 37.7618617394874 -122.42061702780899 (37.7618617394874, -122.420617027809)
122806 105040 Permitted Site 1 :: 54 2660 Harrison St 2 Sidewalk: Property side : Cutout 5 Landscaping 2 Private 1       2x7   6008868.4 2102978.1 37.7548779915591 -122.412270115586 (37.7548779915591, -122.412270115586)
123231 88829 Permitted Site 1 Shrub :: Shrub 98 4437 20th St   Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1   09/30/2008 12:00:00 AM   8x1 Permit Number 51764 6001659.0 2104076.0 37.757485378077604 -122.43728079846599 (37.7574853780776, -122.437280798466)
123904 106641 Private 5 Private shrub :: Private Shrub 64 1323X CLAYTON ST 1 Back Yard : Yard 13 Landscaping 2 Private 1           5999055.0 2105304.0 37.7607087868046 -122.446374778866 (37.7607087868046, -122.446374778866)
124767 99530 Permitted Site 1 Tree(s) :: 17 120 Howard St 4 Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1       4x9   6014737.1 2116083.2 37.7911892459774 -122.392891167069 (37.7911892459774, -122.392891167069)
125761 108576 Property Tree 7 :: 54 2479 Diamond St 1 Front Yard : Yard 7 Landscaping 2 Private 1           6002240.0 2097369.0 37.7391025518434 -122.434791855338 (37.7391025518434, -122.434791855338)
125875 89140 Permitted Site 1 Tree(s) :: 17 3170 23rd St   Sidewalk: Property side : Cutout 5 Landscaping 2 Private 1   10/06/2008 12:00:00 AM     Permit Number 770875 6007866.1 2102749.5 37.7541940143569 -122.41572017373001 (37.7541940143569, -122.41572017373)
127072 99201 Permitted Site 1 Tree(s) :: 17 4016 26th St   Sidewalk: Curb side : Cutout 1 Landscaping 2 DPW 2 FUF 1 04/12/2012 12:00:00 AM   6x10.5 Permit Number 768835 6003752.7 2100736.7 37.7484352450997 -122.429801769855 (37.7484352450997, -122.429801769855)
127755 83007 Permitted Site 1 Laurus x 'Saratoga' :: Hybrid Laurel 457 1058 De Haro St 1 Median : Cutout 11 Landscaping 2 Private 1   07/02/2009 12:00:00 AM   3x3 Permit Number 52381 6012170.46860809 2103464.70975517 37.7563988530014 -122.40088475581499 (37.7563988530014, -122.400884755815)
128027 82995 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1412 Quesada Ave 1 Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1   07/02/2009 12:00:00 AM   3x3 Permit Number 52364 6016260.71862294 2093905.81391215 37.730379387125204 -122.38607277339099 (37.7303793871252, -122.386072773391)
128347 104667 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 172 Clipper St 1 Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1 FUF 1 01/19/2016 12:00:00 AM   6x12 Permit Number 777366 6003998.6 2101043.1 37.749290469922705 -122.42897329466999 (37.7492904699227, -122.42897329467)
128554 93164 Permitted Site 1 Shrub :: Shrub 98 201 Upper Ter 2 Sidewalk: Property side : Cutout 5 Landscaping 2 Private 1   12/22/2009 12:00:00 AM   1x2   5999670.5 2106448.3 37.763885884820205 -122.444328283325 (37.7638858848202, -122.444328283325)
129064 99535 Permitted Site 1 Tree(s) :: 17 188 Spear St 3 Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1       5x9   6014774.7 2116168.9 37.791426646732894 -122.39276706915899 (37.7914266467329, -122.392767069159)
129188 105003 Undocumented 2 Shrub :: Shrub 98 607 CONGO ST   Sidewalk: Property side : Yard 9 Landscaping 2 Private 1           6000094.1 2095817.0 37.73471905904071 -122.44210000591002 (37.7347190590407, -122.44210000591)
138475 96182 Permitted Site 1 Tree(s) :: 17 330 South Van Ness Ave   Front Yard : Cutout 8 Landscaping 2 Private 1   04/04/2011 12:00:00 AM     Permit Number 767813 6007366.0 2107749.1 37.7678936317448 -122.417804012618 (37.7678936317448, -122.417804012618)
138621 104565 Private 5 Private shrub :: Private Shrub 64 18 FLOOD AVE 1 Front Yard : Yard 7 Landscaping 2 Private 1           6000327.0 2094154.0 37.730166118083794 -122.44117551704201 (37.7301661180838, -122.441175517042)
138642 99534 Permitted Site 1 Tree(s) :: 17 188 Spear St 2 Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1       5x9   6014774.7 2116168.9 37.791426646732894 -122.39276706915899 (37.7914266467329, -122.392767069159)
138994 99532 Permitted Site 1 Tree(s) :: 17 120 Howard St 6 Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1       4x9   6014737.1 2116083.2 37.7911892459774 -122.392891167069 (37.7911892459774, -122.392891167069)
139298 92611 Permitted Site 1 Shrub :: Shrub 98 3856 23rd St   Sidewalk: Property side : Pot 6 Landscaping 2 Private 1   08/31/2009 12:00:00 AM     Permit Number 52924 6004067.0 2102488.0 37.753261698893496 -122.428839761175 (37.7532616988935, -122.428839761175)
140567 94962 Permitted Site 1 Tree(s) :: 17 3098@Lyon Pacific Ave   Sidewalk: Property side : Cutout 5 Landscaping 2 Private 1   10/25/2010 12:00:00 AM       5999362.0 2116697.3 37.7920093994348 -122.44613254842899 (37.7920093994348, -122.446132548429)
140829 105041 Permitted Site 1 :: 54 2660 Harrison St 3 Sidewalk: Property side : Cutout 5 Landscaping 2 Private 1       2x2   6008868.4 2102978.1 37.7548779915591 -122.412270115586 (37.7548779915591, -122.412270115586)
140914 114321 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 2118 47th Ave 1 Front Yard : Cutout 8 Landscaping 2 Private 1   01/14/2016 12:00:00 AM   5x16 Permit Number 777356 5981743.9 2100646.6 37.7469169691931 -122.505899765145 (37.7469169691931, -122.505899765145)
141475 104153 Permitted Site 1 :: 54 525X Church St 1 Sidewalk: Curb side : Cutout 1 Landscaping 2 SFUSD 4 DPW 4     5x17   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895)
141674 104634 Permitted Site 1 :: 54 217 Montcalm St   Front Yard : Yard 7 Landscaping 2 Private 1       16x16   6009833.3 2099565.6 37.7455621186719 -122.40869248022899 (37.7455621186719, -122.408692480229)
142588 104374 Undocumented 2 Tree(s) :: 17 22 GARDENSIDE DR 1 Median : Yard 3 Landscaping 2 Private 1       50x50   5999468.0 2101996.0 37.7516494117124 -122.444708626009 (37.7516494117124, -122.444708626009)
143329 93161 Permitted Site 1 Tree(s) :: 17 201 Upper Ter 2 Sidewalk: Property side : Cutout 5 Landscaping 2 Private 1   12/22/2009 12:00:00 AM   1x1   5999670.5 2106448.3 37.763885884820205 -122.444328283325 (37.7638858848202, -122.444328283325)
143838 89015 Permitted Site 1 Shrub :: Shrub 98 4437 20th St   Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1   09/30/2008 12:00:00 AM   3x1 Permit Number 51764 6001659.0 2104076.0 37.757485378077604 -122.43728079846599 (37.7574853780776, -122.437280798466)
143915 93160 Permitted Site 1 Tree(s) :: 17 201 Upper Ter 1 Sidewalk: Property side : Cutout 5 Landscaping 2 Private 1   12/22/2009 12:00:00 AM   1x1   5999670.5 2106448.3 37.763885884820205 -122.444328283325 (37.7638858848202, -122.444328283325)
143940 106932 Undocumented 2 Shrub :: Shrub 98 358 SHOTWELL ST 1 Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1       8x10   6007793.2 2105846.4 37.7626932925098 -122.416191600332 (37.7626932925098, -122.416191600332)
144925 93163 Permitted Site 1 Shrub :: Shrub 98 201 Upper Ter 1 Sidewalk: Property side : Cutout 5 Landscaping 2 Private 1   12/22/2009 12:00:00 AM   1x15   5999670.5 2106448.3 37.763885884820205 -122.444328283325 (37.7638858848202, -122.444328283325)
145017 99533 Permitted Site 1 Tree(s) :: 17 188 Spear St 1 Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1       5x9   6014774.7 2116168.9 37.791426646732894 -122.39276706915899 (37.7914266467329, -122.392767069159)
145403 99528 Permitted Site 1 Tree(s) :: 17 120 Howard St 2 Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1       4x9   6014737.1 2116083.2 37.7911892459774 -122.392891167069 (37.7911892459774, -122.392891167069)
145716 98878 Property Tree 7 Tree(s) :: 17 11 Panorama Dr   Back Yard : Yard 13 Landscaping 2 Private 1           5998029.0 2100213.0 37.7466715093679 -122.449556386849 (37.7466715093679, -122.449556386849)
172552 140265 Undocumented 2 Shrub :: Shrub 98 2100X Grove St 3 Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1     0 Width 0ft   5997671.17 2110272.3417 37.7742714515841 -122.45151917218 (37.7742714515841, -122.45151917218)
1389 251532 Permitted Site 1 :: 54 2100X 20th St 4 Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1   05/15/2017 12:00:00 AM 3 4x11            
1391 251531 Permitted Site 1 :: 54 2100X 20th St 2 Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1   05/15/2017 12:00:00 AM 3 4x11            
1800 251700 Permitted Site 1 :: 54 1560 Sanchez St 1 Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1   06/05/2017 12:00:00 AM 3 410x11 Permit Number 780193 6003924.0 2099150.0 37.7440882334859 -122.429096301435 (37.7440882334859, -122.429096301435)
2270 253008 Permitted Site 1 :: 54 1201 Tennessee St 1 Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1   07/10/2017 12:00:00 AM 3 11x477   6015595.17459 2103370.35297 37.756330202721 -122.389034232236 (37.756330202721, -122.389034232236)
3170 208471 Permitted Site 1 Cordyline australis :: Dracena Palm 141 1175 Kirkham St 1 Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1   08/23/2017 12:00:00 AM 3 Width 2ft Permit Number 780657 5991201.16474 2105172.16858 37.7598951180952 -122.473527781682 (37.7598951180952, -122.473527781682)
3287 253411 Permitted Site 1 Lophostemon confertus :: Brisbane Box 11 1321 Mission St 3 Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1   08/30/2017 12:00:00 AM 3 4x12 Permit Number 775218 6008256.52806819 2110680.03106396 37.775991353803896 -122.414931236288 (37.7759913538039, -122.414931236288)
3292 253409 Permitted Site 1 Lophostemon confertus :: Brisbane Box 11 1321 Mission St 1 Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1   08/30/2017 12:00:00 AM 3 4x12 Permit Number 775218 6008256.52806819 2110680.03106396 37.775991353803896 -122.414931236288 (37.7759913538039, -122.414931236288)
3295 253410 Permitted Site 1 Lophostemon confertus :: Brisbane Box 11 1321 Mission St 2 Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1   08/30/2017 12:00:00 AM 3 4x12 Permit Number 775218 6008256.52806819 2110680.03106396 37.775991353803896 -122.414931236288 (37.7759913538039, -122.414931236288)
3305 253412 Permitted Site 1 Lophostemon confertus :: Brisbane Box 11 1321 Mission St 4 Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1   08/30/2017 12:00:00 AM 3 4x12 Permit Number 775218 6008256.52806819 2110680.03106396 37.775991353803896 -122.414931236288 (37.7759913538039, -122.414931236288)
3639 253517 Permitted Site 1 :: 54 559 24th Ave 2 Sidewalk: Property side : Cutout 5 Landscaping 2 Private 1   09/15/2017 12:00:00 AM 3 2x4.5   5988391.0 2112180.0 37.7789735494402 -122.483760479148 (37.7789735494402, -122.483760479148)
3643 253515 Permitted Site 1 :: 54 559 24th Ave 1 Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1   09/15/2017 12:00:00 AM 3 7x9.5   5988391.0 2112180.0 37.7789735494402 -122.483760479148 (37.7789735494402, -122.483760479148)
3650 253518 Permitted Site 1 :: 54 559 24th Ave 3 Sidewalk: Property side : Cutout 5 Landscaping 2 Private 1   09/15/2017 12:00:00 AM 3 2x1   5988391.0 2112180.0 37.7789735494402 -122.483760479148 (37.7789735494402, -122.483760479148)
3660 253516 Permitted Site 1 :: 54 559 24th Ave 1 Sidewalk: Property side : Cutout 5 Landscaping 2 Private 1   09/15/2017 12:00:00 AM 3 2x2   5988392.0 2112177.0 37.778965370493495 -122.483756799769 (37.7789653704935, -122.483756799769)
4723 253676 Permitted Site 1 :: 54 2975 Van Ness Ave 6 Sidewalk: Property side : Cutout 5 Landscaping 2 Private 1   10/24/2017 12:00:00 AM 3 3.2x3.75   6005536.30746 2120557.52588 37.8029592583559 -122.42504415389 (37.8029592583559, -122.42504415389)
4726 253675 Permitted Site 1 :: 54 2975 Van Ness Ave 1 Sidewalk: Property side : Cutout 5 Landscaping 2 Private 1   10/24/2017 12:00:00 AM 3 3.2x14.2   6005536.30746 2120557.52588 37.8029592583559 -122.42504415389 (37.8029592583559, -122.42504415389)
10092 173852 Permitted Site 1 :: 54 450 Toland St 7 Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1   01/27/2017 12:00:00 AM 3 8.5x4   6012768.71675 2099101.44192 37.74445161113729 -122.39850962968201 (37.7444516111373, -122.398509629682)
10093 173849 Permitted Site 1 :: 54 450 Toland St 4 Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1   01/27/2017 12:00:00 AM 3 17.6x4   6012768.71675 2099101.44192 37.74445161113729 -122.39850962968201 (37.7444516111373, -122.398509629682)
10096 173850 Permitted Site 1 :: 54 450 Toland St 5 Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1   01/27/2017 12:00:00 AM 3 13.9x4   6012768.71675 2099101.44192 37.74445161113729 -122.39850962968201 (37.7444516111373, -122.398509629682)
10097 173851 Permitted Site 1 :: 54 450 Toland St 6 Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1   01/27/2017 12:00:00 AM 3 27.75x4   6012768.71675 2099101.44192 37.74445161113729 -122.39850962968201 (37.7444516111373, -122.398509629682)
10098 173848 Permitted Site 1 :: 54 450 Toland St 3 Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1   01/27/2017 12:00:00 AM 3 19.5x4   6012768.71675 2099101.44192 37.74445161113729 -122.39850962968201 (37.7444516111373, -122.398509629682)
10101 173846 Permitted Site 1 :: 54 450 Toland St 1 Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1   01/27/2017 12:00:00 AM 3 15x4   6012768.71675 2099101.44192 37.74445161113729 -122.39850962968201 (37.7444516111373, -122.398509629682)
10104 173847 Permitted Site 1 :: 54 450 Toland St 2 Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1   01/27/2017 12:00:00 AM 3 11.85x4   6012768.71675 2099101.44192 37.74445161113729 -122.39850962968201 (37.7444516111373, -122.398509629682)
10106 173853 Permitted Site 1 :: 54 450 Toland St 8 Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1   01/27/2017 12:00:00 AM 3 26.75x4   6012768.71675 2099101.44192 37.74445161113729 -122.39850962968201 (37.7444516111373, -122.398509629682)
41228 117919 Undocumented 2 Ligustrum ovalifolium :: California privet 284 727 41st Ave 2 Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1     3 Width 3ft   5983193.78874 2110818.2250200002 37.774930606826 -122.501638652158 (37.774930606826, -122.501638652158)
42994 109343 Permitted Site 1 :: 54 3211 Baker St 2 Sidewalk: Property side : Yard 9 Landscaping 2 Private 1   02/11/2015 12:00:00 AM 3 4x13   5999315.1 2119860.5 37.8006920253414 -122.446522498385 (37.8006920253414, -122.446522498385)
50491 107717 Undocumented 2 Tree(s) :: 17 2400X 25th Ave 3 Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1 Port 11 10/16/2014 12:00:00 AM 3 3x3 Permit Number 773973 5985789.0 2098909.0 37.7423832554664 -122.49178447783899 (37.7423832554664, -122.491784477839)
81298 104856 Permitted Site 1 :: 54 739 27th St   Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1   02/12/2015 12:00:00 AM 3     6001722.3 2099959.7 37.746186600460604 -122.43676722664301 (37.7461866004606, -122.436767226643)
81307 20137 Permitted Site 1 Pyrus kawakamii :: Evergreen Pear 82 898 Steiner St 1 Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1   01/11/2011 12:00:00 AM 3 8x4 Permit Number 54088 6003009.7075288 2111327.5412022998 37.777473032235704 -122.433127623561 (37.7774730322357, -122.433127623561)
81443 100355 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 591 Waller St   Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1   12/30/2014 12:00:00 AM 3 27x6 Permit Number 769031 6002899.6 2108847.2 37.770656382716396 -122.43333123962 (37.7706563827164, -122.43333123962)
82393 108910 Permitted Site 1 Agonis flexuosa :: Peppermint Willow 7 129 Ellert St 1 Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1 FUF 1 01/09/2015 12:00:00 AM 3 3x3 Permit Number 773054 6007361.2 2097016.9 37.7384251864379 -122.417060086005 (37.7384251864379, -122.417060086005)
83041 109366 Permitted Site 1 :: 54 1205 Filbert St 3 Sidewalk: Property side : Cutout 5 Landscaping 2 Private 1 FUF 1 02/11/2015 12:00:00 AM 3 3.125x22   6007075.4 2119431.2 37.7999534721279 -122.419638123127 (37.7999534721279, -122.419638123127)
84402 109353 Private 5 Ficus Spp. :: 253 2505 Pacific Ave 6 Sidewalk: Property side : Cutout 5 Landscaping 2 Private 1   02/11/2015 12:00:00 AM 3 .5x1   6002092.0 2116990.0 37.7929686009801 -122.43670770268999 (37.7929686009801, -122.43670770269)
85779 110615 Permitted Site 1 Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 200 McAllister St 3 Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1   12/31/2015 12:00:00 AM 3 13.2x7.8 Permit Number 773269 6008108.0 2112443.0 37.7808236983351 -122.415569883338 (37.7808236983351, -122.415569883338)
91154 109365 Permitted Site 1 :: 54 1205 Filbert St 2 Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1 FUF 1 02/11/2015 12:00:00 AM 3 4.5x16   6007075.4 2119431.2 37.7999534721279 -122.419638123127 (37.7999534721279, -122.419638123127)
96541 110246 Permitted Site 1 :: 54 1706 28th Ave 1 Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1   04/01/2015 12:00:00 AM 3 1.5x12   5987540.7 2103643.4 37.755484875136204 -122.486075162345 (37.7554848751362, -122.486075162345)
97307 109345 Permitted Site 1 :: 54 3211 Baker St 4 Sidewalk: Property side : Yard 9 Landscaping 2 Private 1   02/11/2015 12:00:00 AM 3 8.75x13   5999315.1 2119860.5 37.8006920253414 -122.446522498385 (37.8006920253414, -122.446522498385)
97433 107716 Undocumented 2 Tree(s) :: 17 2400X 25th Ave 2 Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1 Port 11 10/16/2014 12:00:00 AM 3 3x3 Permit Number 773973 5985789.0 2098909.0 37.7423832554664 -122.49178447783899 (37.7423832554664, -122.491784477839)
99380 119616 Private 5 :: 54 400 Grove St 1 Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1   07/28/2016 12:00:00 AM 3     6005873.6969099995 2111410.5639299997 37.777863036884796 -122.42322602570499 (37.7778630368848, -122.423226025705)
99464 109344 Permitted Site 1 :: 54 3211 Baker St 3 Sidewalk: Property side : Yard 9 Landscaping 2 Private 1   02/11/2015 12:00:00 AM 3 4x13   5999315.1 2119860.5 37.8006920253414 -122.446522498385 (37.8006920253414, -122.446522498385)
101115 109364 Permitted Site 1 :: 54 1205 Filbert St 1 Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1 FUF 1 02/11/2015 12:00:00 AM 3 4.5x6   6007075.4 2119431.2 37.7999534721279 -122.419638123127 (37.7999534721279, -122.419638123127)
101235 109535 Permitted Site 1 :: 54 1234 Filbert St 3 Sidewalk: Property side : Cutout 5 Landscaping 2 Private 1 FUF 1 02/23/2015 12:00:00 AM 3 1.5x2.4   6007007.9 2119506.8 37.800157248198296 -122.419877066677 (37.8001572481983, -122.419877066677)
101338 110613 Permitted Site 1 Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 200 McAllister St 1 Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1   04/27/2015 12:00:00 AM 3 12.8x7.8 Permit Number 773269 6008108.0 2112443.0 37.7808236983351 -122.415569883338 (37.7808236983351, -122.415569883338)
101450 109486 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1314 POLK ST 1 Sidewalk: Curb side : Pot 10 Landscaping 2 DPW 2   01/23/2016 04:50:00 AM 3 3x3   6006825.7 2115468.8 37.7890596427133 -122.420220804515 (37.7890596427133, -122.420220804515)
102823 20136 Permitted Site 1 Pyrus kawakamii :: Evergreen Pear 82 890 Steiner St 1 Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1   01/11/2011 12:00:00 AM 3 8x4 Permit Number 54087 6003007.0 2111306.0 37.777413731872 -122.43313545029301 (37.777413731872, -122.433135450293)
104832 109350 Private 5 Ficus Spp. :: 253 2505 Pacific Ave 3 Sidewalk: Property side : Cutout 5 Landscaping 2 Private 1   02/11/2015 12:00:00 AM 3 .5x1   6002092.0 2116990.0 37.7929686009801 -122.43670770268999 (37.7929686009801, -122.43670770269)
105398 117608 Permitted Site 1 :: 54 450 Hayes St 1 Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1   06/29/2016 12:00:00 AM 3     6005708.4 2111040.6 37.776837876057 -122.423771533631 (37.776837876057, -122.423771533631)
107768 82751 Permitted Site 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 52 Sheridan St 1 Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1   07/07/2009 12:00:00 AM 3 3x3 Permit Number 52446 6009256.89976445 2109417.42292722 37.772580689338 -122.41138145626002 (37.772580689338, -122.41138145626)
112218 109536 Permitted Site 1 :: 54 1234 Filbert St 4 Sidewalk: Property side : Cutout 5 Landscaping 2 Private 1 FUF 1 02/23/2015 12:00:00 AM 3 1.5x2.4   6007007.9 2119506.8 37.800157248198296 -122.419877066677 (37.8001572481983, -122.419877066677)
113379 109349 Private 5 Ficus Spp. :: 253 2505 Pacific Ave 2 Sidewalk: Property side : Cutout 5 Landscaping 2 Private 1   02/11/2015 12:00:00 AM 3 .5x1   6002092.0 2116990.0 37.7929686009801 -122.43670770268999 (37.7929686009801, -122.43670770269)
114314 108701 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 478 30th St   Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1 FUF 1 01/02/2015 12:00:00 AM 3 3x3 Permit Number 774626 6003507.49152 2098366.3309400002 37.7419128730633 -122.43048058961 (37.7419128730633, -122.43048058961)
116050 111759 Permitted Site 1 :: 54 1235 47th Ave 2 Sidewalk: Curb side : Yard 2 Landscaping 2 Private 1   06/23/2015 12:00:00 AM 3 6x4   5981472.7 2106671.7 37.7634442160317 -122.50728446314301 (37.7634442160317, -122.507284463143)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" TEXT,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" TEXT,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");
Powered by Datasette · Query took 22.157ms · Data source: data.sfgov.org