home / trees

Street_Tree_List

Data source: data.sfgov.org

300 rows where qLegalStatus = 5

View and edit SQL

Suggested facets: SiteOrder, qSiteInfo, PlantType, qCaretaker, qCareAssistant, PlantDate, DBH, PlotSize, Fire Prevention Districts, Police Districts, Supervisor Districts, Zip Codes, Neighborhoods

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods
51 100045 Property Tree 5 Acacia decurrens :: Acacia: Silver Wattle 15 556 28th St   Front Yard : Yard 4 Tree 1 Private 2         Not sure which property tree is located on. 6002301.0 2099461.0 37.7448501592716 -122.434730501666 (37.7448501592716, -122.434730501666) 2 7 5 63 22
52 100046 Property Tree 5 Tree(s) :: 13 562 28th St   Front Yard : Yard 4 Tree 1 Private 2   11/28/2012 12:00:00 AM 17   Permit Number 769057 6002262.0 2099459.0 37.7448424535299 -122.43486521318898 (37.7448424535299, -122.434865213189) 2 7 5 63 22
79 100070 Property Tree 5 Tree(s) :: 13 331 Serrano Dr 1 Front Yard : Yard 4 Tree 1 Private 2         Permit Number 777990 5990400.0 2090718.0 37.7201612636948 -122.47524333880699 (37.7201612636948, -122.475243338807) 1 8 4 64 40
147 100139 Property Tree 5 Tree(s) :: 13 155 05th St 2 Front Yard : Yard 4 Tree 1 Private 2         Permit Number 769024 6011029.6 2112857.4 37.782125333955705 -122.40549178692301 (37.7821253339557, -122.405491786923) 12 2 9 28853 34
151 100148 Property Tree 5 Tree(s) :: 13 209 Vicksburg St   Back Yard : Yard 6 Tree 1 Private 2           6004141.0 2102142.0 37.7523158521071 -122.428559192815 (37.7523158521071, -122.428559192815) 2 4 5 28862 22
169 100166 Property Tree 5 Salix spp :: Willow 40 2340 Twin Peaks Blvd   Front Yard : Yard 4 Tree 1 Private 2         Permit Number 769026                    
242 100244 Property Tree 5 Persea americana :: Avocado 54 71 Sanchez St   Back Yard : Yard 6 Tree 1 Private 2         Interior courtyard 6003507.0 2107903.0 37.7680982797144 -122.431162830878 (37.7680982797144, -122.431162830878) 7 9 5 28862 3
420 100472 Property Tree 5 Pinus radiata :: Monterey Pine 1 70 Stanford Heights Ave   Back Yard : Yard 6 Tree 1 Private 2           5997872.4 2096006.9 37.735113616296 -122.44979482672899 (37.735113616296, -122.449794826729) 9 7 4 59 40
1437 101625 Property Tree 5 Fagus sylvatica :: European Beech 139 64 Levant St 1 Front Yard : Cutout 10 Tree 1 Private 2         Permit Number 769362 6000275.9 2106473.5 37.76398959970761 -122.442236202383 (37.7639895997076, -122.442236202383) 15 5 5 28862 3
1641 101900 Property Tree 5 Pinus radiata :: Monterey Pine 1 1100 Ocean Ave 1 Front Yard : Yard 4 Tree 1 DPW 1         Permit Number 769623 5996507.7 2092470.2 37.7253245106519 -122.454257683967 (37.7253245106519, -122.454257683967) 9 7 4 28861 40
1642 101901 Property Tree 5 Metrosideros excelsa :: New Zealand Xmas Tree 3 1100 Ocean Ave 2 Front Yard : Yard 4 Tree 1 DPW 1         Permit Number 769623 5996507.7 2092470.2 37.7253245106519 -122.454257683967 (37.7253245106519, -122.454257683967) 9 7 4 28861 40
1644 101903 Property Tree 5 Washingtonia robusta :: Mexican Fan Palm 86 1100 Ocean Ave 4 Front Yard : Yard 4 Tree 1 DPW 1         Permit Number 769623 5996507.7 2092470.2 37.7253245106519 -122.454257683967 (37.7253245106519, -122.454257683967) 9 7 4 28861 40
1645 101904 Property Tree 5 Washingtonia robusta :: Mexican Fan Palm 86 1100 Ocean Ave 5 Front Yard : Yard 4 Tree 1 DPW 1         Permit Number 769623 5996507.7 2092470.2 37.7253245106519 -122.454257683967 (37.7253245106519, -122.454257683967) 9 7 4 28861 40
1646 101905 Property Tree 5 Washingtonia robusta :: Mexican Fan Palm 86 1100 Ocean Ave 6 Front Yard : Yard 4 Tree 1 DPW 1         Permit Number 769623 5996507.7 2092470.2 37.7253245106519 -122.454257683967 (37.7253245106519, -122.454257683967) 9 7 4 28861 40
1672 101951 Property Tree 5 Tree(s) :: 13 21 Lyell St   unknown : Yard 8 Tree 1 Private 2           6003106.0 2094969.0 37.7325618289587 -122.43162632292 (37.7325618289587, -122.43162632292) 9 7 5 28861 25
1696 101977 Property Tree 5 Cedrus deodara :: Deodar Cedar 96 601 Grand View Ave   Front Yard : Yard 4 Tree 1 Private 2           6000076.2 2101609.9 37.750623962991796 -122.44257767940901 (37.7506239629918, -122.442577679409) 2 4 5 28862 22
1776 102056 Property Tree 5 Pinus radiata :: Monterey Pine 1 332 19th Ave 1 Back Yard : Yard 6 Tree 1 Private 2           5990007.7 2113121.3 37.781652074321705 -122.47823656971501 (37.7816520743217, -122.478236569715) 11 6 2 55 26
1799 102079 Property Tree 5 Arbutus 'Marina' :: Hybrid Strawberry Tree 20 76 Manchester St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/18/2012 12:00:00 AM   3x3 Permit Number 769729 6008162.3 2099676.4 37.7457726186307 -122.414478397936 (37.7457726186307, -122.414478397936) 2 7 7 28859 2
1819 102101 Property Tree 5 Cordyline australis :: Dracena Palm 82 331 Vernon St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/19/2012 12:00:00 AM 12 3x3 Permit Number 769722 5992434.3 2090067.3 37.718492301183204 -122.468164197766 (37.7184923011832, -122.468164197766) 9 8 6 64 24
1963 102248 Property Tree 5 Olea europaea :: Olive Tree 42 125X Powhattan Ave 1 Front Yard : Yard 4 Tree 1 Private 2   01/07/2013 12:00:00 AM     Permit Number 768486 6007606.0 2098071.0 37.7413332800665 -122.416288322592 (37.7413332800665, -122.416288322592) 2 7 7 28859 2
1964 102249 Property Tree 5 Olea europaea :: Olive Tree 42 125X Powhattan Ave 2 Front Yard : Yard 4 Tree 1 Private 2   01/07/2013 12:00:00 AM     Permit Number 768486 6007606.0 2098071.0 37.7413332800665 -122.416288322592 (37.7413332800665, -122.416288322592) 2 7 7 28859 2
1966 102250 Property Tree 5 Olea europaea :: Olive Tree 42 125X Powhattan Ave 3 Front Yard : Yard 4 Tree 1 Private 2   01/07/2013 12:00:00 AM     Permit Number 768486 6007606.0 2098071.0 37.7413332800665 -122.416288322592 (37.7413332800665, -122.416288322592) 2 7 7 28859 2
1967 102251 Property Tree 5 Citrus × meyeri 'Improved' :: Improved Meyer Lemon 162 125X Powhattan Ave 4 Front Yard : Yard 4 Tree 1 Private 2   01/07/2013 12:00:00 AM     Permit Number 768486 6007606.0 2098071.0 37.7413332800665 -122.416288322592 (37.7413332800665, -122.416288322592) 2 7 7 28859 2
1989 102275 Property Tree 5 Tree(s) :: 13 267 Topaz Way   Back Yard : Yard 6 Landscaping 2 Private 2           6001225.6 2097744.2 37.740075118911705 -122.438326054857 (37.7400751189117, -122.438326054857) 2 7 5 63 7
2089 102381 Property Tree 5 Pinus radiata :: Monterey Pine 1 258 Molimo Dr   Back Yard : Yard 6 Tree 1 Private 2           5997615.0 2096604.0 37.7367383790998 -122.450727783905 (37.7367383790998, -122.450727783905) 9 7 4 59 40
2177 102469 Property Tree 5 Pinus radiata :: Monterey Pine 1 1021 Kirkham St 1 Back Yard : Yard 6 Tree 1 Private 2           5991773.0 2105198.0 37.7599991432047 -122.471551983129 (37.7599991432047, -122.471551983129) 1 8 4 56 12
2179 102470 Property Tree 5 Pinus radiata :: Monterey Pine 1 1021 Kirkham St 2 Back Yard : Yard 6 Tree 1 Private 2           5991773.0 2105198.0 37.7599991432047 -122.471551983129 (37.7599991432047, -122.471551983129) 1 8 4 56 12
2337 102639 Property Tree 5 Pinus radiata :: Monterey Pine 1 251 Dorado Ter 1 Back Yard : Yard 6 Tree 1 Private 2           5994312.1 2092840.7 37.726215661035106 -122.461874461465 (37.7262156610351, -122.461874461465) 9 8 4 28861 40
2397 102706 Property Tree 5 Cupressus macrocarpa :: Monterey Cypress 91 1342 Funston Ave 1 Back Yard : Yard 6 Tree 1 Private 2           5992135.4 2106294.8 37.7630316255695 -122.470378504645 (37.7630316255695, -122.470378504645) 1 8 11 56 12
2430 102745 Property Tree 5 Cupressus macrocarpa :: Monterey Cypress 91 222 Moncada Way 1 Front Yard : Yard 4 Tree 1 Private 2           5992354.0 2093377.4 37.727576385896604 -122.468682482409 (37.7275763858966, -122.468682482409) 9 8 4 59 40
2438 102752 Property Tree 5 Sequoia sempervirens :: Coast Redwood 157 2452 Green St   Back Yard : Yard 6 Tree 1 Private 2           6001313.0 2117994.0 37.7956810212331 -122.43947508164 (37.7956810212331, -122.43947508164) 13 9 1 57 17
3140 103504 Property Tree 5 Pinus radiata :: Monterey Pine 1 148 Huntington Dr 1 Back Yard : Yard 6 Tree 1 Private 2           5984515.0 2095210.0 37.732152252278794 -122.49591670504999 (37.7321522522788, -122.49591670505) 1 8 4 64 35
3153 103516 Property Tree 5 Cupressus macrocarpa :: Monterey Cypress 91 980 Green St 1 Back Yard : Yard 6 Tree 1 Private 2           6008298.0 2118971.0 37.7987586699451 -122.415374854445 (37.7987586699451, -122.415374854445) 5 1 10 308 32
3301 103673 Property Tree 5 :: 55 64 Henry St   Back Yard : Yard 6 Tree 1 Private 2           6003097.0 2107420.0 37.7667488371496 -122.432546472662 (37.7667488371496, -122.432546472662) 15 5 5 28862 3
3598 104008 Property Tree 5 Pinus radiata :: Monterey Pine 1 357 Collingwood St 1 Back Yard : Yard 6 Tree 1 Private 2     36     6002124.0 2103789.0 37.7567237682266 -122.435652112093 (37.7567237682266, -122.435652112093) 2 4 5 28862 3
3831 104318 Property Tree 5 Magnolia grandiflora :: Southern Magnolia 39 22 Beaver St 1 Front Yard : Yard 4 Tree 1 Private 2       3x3   6002763.0 2106816.0 37.765071454107996 -122.433658549479 (37.765071454108, -122.433658549479) 15 5 5 28862 3
3895 104397 Property Tree 5 Pseudotsuga menziesii :: Douglas Fir 205 350 Collingwood St 1 Front Yard : Yard 4 Tree 1 Private 2           6002086.0 2103822.0 37.756812219827296 -122.43578589078301 (37.7568122198273, -122.435785890783) 2 4 5 28862 3
4032 104538 Property Tree 5 Juniperus chinensis :: Juniper 94 1101 Van Ness Ave 1 Front Yard : Yard 4 Tree 1 Private 2           6006375.5 2114401.9 37.786104821458295 -122.42170263122401 (37.7861048214583, -122.421702631224) 13 9 11 28858 41
4033 104539 Property Tree 5 Juniperus chinensis :: Juniper 94 1101 Van Ness Ave 2 Front Yard : Yard 4 Tree 1 Private 2           6006375.5 2114401.9 37.786104821458295 -122.42170263122401 (37.7861048214583, -122.421702631224) 13 9 11 28858 41
4035 104540 Property Tree 5 Juniperus chinensis :: Juniper 94 1101 Van Ness Ave 4 Front Yard : Yard 4 Tree 1 Private 2           6006375.5 2114401.9 37.786104821458295 -122.42170263122401 (37.7861048214583, -122.421702631224) 13 9 11 28858 41
4036 104541 Property Tree 5 Juniperus chinensis :: Juniper 94 1101 Van Ness Ave 5 Front Yard : Yard 4 Tree 1 Private 2           6006375.5 2114401.9 37.786104821458295 -122.42170263122401 (37.7861048214583, -122.421702631224) 13 9 11 28858 41
4037 104542 Property Tree 5 Juniperus chinensis :: Juniper 94 1101 Van Ness Ave 6 Front Yard : Yard 4 Tree 1 Private 2           6006375.5 2114401.9 37.786104821458295 -122.42170263122401 (37.7861048214583, -122.421702631224) 13 9 11 28858 41
4038 104543 Property Tree 5 Juniperus chinensis :: Juniper 94 1101 Van Ness Ave 7 Front Yard : Yard 4 Tree 1 Private 2           6006375.5 2114401.9 37.786104821458295 -122.42170263122401 (37.7861048214583, -122.421702631224) 13 9 11 28858 41
4039 104544 Property Tree 5 Juniperus chinensis :: Juniper 94 1101 Van Ness Ave 8 Front Yard : Yard 4 Tree 1 Private 2           6006375.5 2114401.9 37.786104821458295 -122.42170263122401 (37.7861048214583, -122.421702631224) 13 9 11 28858 41
4062 104568 Property Tree 5 Juniperus chinensis :: Juniper 94 1101 Van Ness Ave 9 Front Yard : Yard 4 Tree 1 Private 2           6006375.5 2114401.9 37.786104821458295 -122.42170263122401 (37.7861048214583, -122.421702631224) 13 9 11 28858 41
4576 105167 Property Tree 5 Corymbia ficifolia :: Red Flowering Gum 5 4755X 03RD ST 1 Front Yard : Cutout 10 Tree 1 Arts Commission 8     8 3x3   6015032.0 2095658.0 37.7351224553975 -122.39044304267901 (37.7351224553975, -122.390443042679) 10 3 8 58 1
4578 105169 Property Tree 5 Corymbia ficifolia :: Red Flowering Gum 5 4755X 03RD ST 3 Front Yard : Cutout 10 Tree 1 Arts Commission 8     23 4x4   6015032.0 2095658.0 37.7351224553975 -122.39044304267901 (37.7351224553975, -122.390443042679) 10 3 8 58 1
4580 105170 Property Tree 5 Magnolia grandiflora :: Southern Magnolia 39 4755X 03RD ST 4 Front Yard : Cutout 10 Tree 1 Arts Commission 8     2 3x3   6015032.0 2095658.0 37.7351224553975 -122.39044304267901 (37.7351224553975, -122.390443042679) 10 3 8 58 1
4581 105171 Property Tree 5 Magnolia grandiflora :: Southern Magnolia 39 4755X 03RD ST 5 Front Yard : Yard 4 Tree 1 Arts Commission 8     14 4x4   6015032.0 2095658.0 37.7351224553975 -122.39044304267901 (37.7351224553975, -122.390443042679) 10 3 8 58 1
4625 105231 Property Tree 5 Pinus Spp :: Pine Spp 89 460X ROOSEVELT WAY 1 Front Yard : Yard 4 Tree 1 Private 2     9     6000051.0 2106345.0 37.7636239504047 -122.44300483360901 (37.7636239504047, -122.443004833609) 15 5 5 29492 3
4626 105232 Property Tree 5 Pinus radiata :: Monterey Pine 1 460X ROOSEVELT WAY 2 Front Yard : Yard 4 Tree 1 Private 2     17     5999944.0 2106286.0 37.7634558498539 -122.443370673769 (37.7634558498539, -122.443370673769) 15 5 5 29492 3
4630 105236 Property Tree 5 Cupressus macrocarpa :: Monterey Cypress 91 235X STATES ST 1 Back Yard : Yard 6 Tree 1 Private 2     30     6001213.0 2106258.0 37.7634512529938 -122.438979613423 (37.7634512529938, -122.438979613423) 15 5 5 28862 3
4729 105353 Property Tree 5 Tree(s) :: 13 1979 SAN JOSE AVE 2 Front Yard : Yard 4 Tree 1 Private 2   04/16/2014 12:00:00 AM 27   Permit Number 772405 5999886.5 2092393.4 37.7253068164695 -122.442572018552 (37.7253068164695, -122.442572018552) 9 7 6 28861 25
5029 105684 Property Tree 5 Ficus microcarpa :: Chinese Banyan 79 635 08TH ST 1 Front Yard : Pot 20 Tree 1 Private 2     10     6011418.5 2109097.9 37.7718243537934 -122.40388172759701 (37.7718243537934, -122.403881727597) 14 2 9 28853 34
5030 105685 Property Tree 5 Ficus microcarpa :: Chinese Banyan 79 635 08TH ST 2 Front Yard : Pot 20 Tree 1 Private 2     8     6011418.5 2109097.9 37.7718243537934 -122.40388172759701 (37.7718243537934, -122.403881727597) 14 2 9 28853 34
5031 105686 Property Tree 5 Ficus microcarpa :: Chinese Banyan 79 635 08TH ST 3 Front Yard : Pot 20 Tree 1 Private 2     6     6011418.5 2109097.9 37.7718243537934 -122.40388172759701 (37.7718243537934, -122.403881727597) 14 2 9 28853 34
5449 106227 Property Tree 5 Eucalyptus globulus :: Blue Gum 206 38 Stanford Heights Ave 1 Back Yard : Yard 6 Tree 1 Private 2           5997884.0 2095808.5 37.7345695210024 -122.44974042873999 (37.7345695210024, -122.44974042874) 9 7 4 59 40
5485 106275 Property Tree 5 Eucalyptus globulus :: Blue Gum 206 42 Stanford Heights Ave 1 Back Yard : Yard 6 Tree 1 Private 2           5997882.5 2095834.4 37.7346405503947 -122.449747480555 (37.7346405503947, -122.449747480555) 9 7 4 59 40
5636 106458 Property Tree 5 Tree(s) :: 13 71 HANCOCK ST   Back Yard : Yard 6 Tree 1 Private 2           6003861.6 2105050.0 37.7602847161222 -122.429732794413 (37.7602847161222, -122.429732794413) 2 4 5 28862 3
6048 106968 Property Tree 5 :: 55 351 26th Ave   Back Yard : Yard 6 Tree 1 Private 2           5987720.26121 2113604.44601 37.7828456076198 -122.48618540122601 (37.7828456076198, -122.486185401226) 11 6 2 55 26
6052 106971 Property Tree 5 Pinus radiata :: Monterey Pine 1 3479X San Bruno Ave 1 Front Yard : Yard 4 Tree 1 Private 2     30     6011510.60551 2091910.0343099998 37.7246353494236 -122.402354399294 (37.7246353494236, -122.402354399294) 10 3 7 309 28
6165 107130 Property Tree 5 Phoenix dactylifera :: Date Palm 253 751 DOLORES ST 1 Front Yard : Cutout 10 Tree 1 Private 2           6005081.8 2103948.4 37.7573290011944 -122.42543429450701 (37.7573290011944, -122.425434294507) 2 4 5 28859 19
7457 108574 Property Tree 5 Tree(s) :: 13 1891 15th St 1 Back Yard : Yard 6 Tree 1 Private 2       7x8   6004884.86016 2107160.4412599998 37.7661373754728 -122.426344078904 (37.7661373754728, -122.426344078904) 8 4 5 28853 19
7458 108576 Property Tree 5 :: 55 2479 Diamond St 1 Front Yard : Yard 4 Landscaping 2 Private 2           6002240.0 2097369.0 37.7391025518434 -122.434791855338 (37.7391025518434, -122.434791855338) 2 7 5 63 7
7508 108624 Property Tree 5 Juniperus chinensis :: Juniper 94 101 GENEBERN WAY 1 Front Yard : Yard 4 Tree 1 Private 2           6005050.2 2095237.8 37.733409902631 -122.42492386614401 (37.733409902631, -122.424923866144) 2 7 7 28861 2
7509 108625 Property Tree 5 Persea americana :: Avocado 54 100 GENEBERN WAY 1 Front Yard : Yard 4 Tree 1 Private 2     12     6004991.8 2095242.4 37.7334192343039 -122.42512609869301 (37.7334192343039, -122.425126098693) 2 7 7 28861 2
7522 108637 Property Tree 5 Pinus radiata :: Monterey Pine 1 15 TUCKER AVE   Back Yard : Yard 6 Tree 1 Private 2           6011049.2 2088423.2 37.715035447895396 -122.403704200211 (37.7150354478954, -122.403704200211) 9 7 8 309 39
7567 108680 Property Tree 5 Juniperus chinensis :: Juniper 94 240 SANTA ANA AVE 1 Back Yard : Yard 6 Tree 1 Private 2           5992606.9 2095181.7 37.73254515275271 -122.46793939448999 (37.7325451527527, -122.46793939449) 9 8 4 59 40
7770 108871 Property Tree 5 Tree(s) :: 13 99x OAKWOOD ST 1 Back Yard : Yard 6 Tree 1 Private 2           6005305.0 2104962.0 37.760124716943295 -122.424734485609 (37.7601247169433, -122.424734485609) 2 4 5 28859 19
7875 108973 Property Tree 5 Pinus radiata :: Monterey Pine 1 3485X SAN BRUNO AVE 1 Median : Yard 11 Tree 1 DPW for City Agency 5           6011510.0 2091910.0 37.724635221414 -122.402356490066 (37.724635221414, -122.402356490066) 10 3 7 309 28
7976 109076 Property Tree 5 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 10 1137 Munich St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2     3x3 Permit Number 772744 6001554.7 2087011.6 37.7106245477128 -122.43642021389401 (37.7106245477128, -122.436420213894) 9 7 6 28861 5
7992 109091 Property Tree 5 Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 56 4235 23rd St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 01/27/2015 12:00:00 AM 3 3x3 Permit Number 773805 6001611.4 2102294.1 37.7525900037408 -122.43731782876002 (37.7525900037408, -122.43731782876) 2 4 5 28862 22
7993 109092 Property Tree 5 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 10 237 28th St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 01/27/2015 12:00:00 AM 3 3x3 Permit Number 773766 6004335.1 2099509.2 37.7450977767532 -122.427700396282 (37.7450977767532, -122.427700396282) 2 7 5 63 22
7995 109097 Property Tree 5 Arbutus 'Marina' :: Hybrid Strawberry Tree 20 601 29th St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 01/27/2015 12:00:00 AM 3 3x3 Permit Number 774331 6002630.6 2098839.9 37.743163470374895 -122.43354642924999 (37.7431634703749, -122.43354642925) 2 7 5 63 7
8097 109194 Property Tree 5 Quercus agrifolia :: Coast Live Oak 129 4705 03rd St   Back Yard : Yard 6 Tree 1 Arts Commission 8     45     6015121.6 2095617.0 37.7350148477359 -122.39013039721901 (37.7350148477359, -122.390130397219) 10 3 8 58 1
8146 109242 Property Tree 5 Private shrub :: Private Shrub 212 2479 DIAMOND ST   Sidewalk: Curb side : Yard 7 Landscaping 2 Private 2           6002238.1 2097343.7 37.7390329760373 -122.434796615916 (37.7390329760373, -122.434796615916) 2 7 5 63 7
8273 109374 Property Tree 5 Populus nigra 'Italica' :: Lombardy Poplar 184 111 BAY ST 1 Back Yard : Yard 6 Tree 1 Private 2           6010193.2 2121519.2 37.8058617340589 -122.40899671325899 (37.8058617340589, -122.408996713259) 3 1 10 308 23
8274 109375 Property Tree 5 Populus nigra 'Italica' :: Lombardy Poplar 184 111 BAY ST 2 Back Yard : Yard 6 Tree 1 Private 2           6010193.2 2121519.2 37.8058617340589 -122.40899671325899 (37.8058617340589, -122.408996713259) 3 1 10 308 23
8275 109376 Property Tree 5 Populus nigra 'Italica' :: Lombardy Poplar 184 111 BAY ST 3 Back Yard : Yard 6 Tree 1 Private 2           6010193.2 2121519.2 37.8058617340589 -122.40899671325899 (37.8058617340589, -122.408996713259) 3 1 10 308 23
8276 109377 Property Tree 5 Populus nigra 'Italica' :: Lombardy Poplar 184 111 BAY ST 4 Back Yard : Yard 6 Tree 1 Private 2           6010193.2 2121519.2 37.8058617340589 -122.40899671325899 (37.8058617340589, -122.408996713259) 3 1 10 308 23
8277 109378 Property Tree 5 Populus nigra 'Italica' :: Lombardy Poplar 184 111 BAY ST 5 Back Yard : Yard 6 Tree 1 Private 2           6010193.2 2121519.2 37.8058617340589 -122.40899671325899 (37.8058617340589, -122.408996713259) 3 1 10 308 23
8862 110181 Property Tree 5 Magnolia grandiflora :: Southern Magnolia 39 2620 Sutter St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     11 1.5x4   5999902.8272 2114053.62 37.784781414472704 -122.444071244627 (37.7847814144727, -122.444071244627) 15 6 1 29490 31
8971 110320 Property Tree 5 :: 55 9 Imperial Aly   Back Yard : Yard 6 Landscaping 2 Private 2           6005040.9 2119421.8 37.7998128500526 -122.426677597274 (37.7998128500526, -122.426677597274) 13 9 1 57 17
9442 110843 Property Tree 5 Pseudotsuga menziesii :: Douglas Fir 205 2037 TURK BLVD   Front Yard : Yard 4 Tree 1 Private 2     15     6000252.0 2111948.0 37.779019836036206 -122.442711981138 (37.7790198360362, -122.442711981138) 15 5 11 29490 16
9537 110929 Property Tree 5 Pinus radiata :: Monterey Pine 1 445 BEACON ST   Back Yard : Yard 6 Tree 1 Private 2       3x3   6002243.0 2098437.0 37.7420352018096 -122.434857838675 (37.7420352018096, -122.434857838675) 2 7 5 63 7
9548 110939 Property Tree 5 Pinus radiata :: Monterey Pine 1 38 SAINT CHARLES AVE 1 Back Yard : Cutout 23 Tree 1 Private 2     30 3x3   5992046.0 2088201.0 37.7133454608488 -122.46937060641001 (37.7133454608488, -122.46937060641) 9 8 6 64 24
10829 112377 Property Tree 5 Eucalyptus sideroxylon :: Red Ironbark 117 801 ULLOA ST 3 Sidewalk: Curb side : Cutout 2 Tree 1 MTA 11     36     5993401.0 2098089.0 37.7405736985828 -122.46540514019699 (37.7405736985828, -122.465405140197) 1 8 4 59 40
11102 112668 Property Tree 5 Pinus radiata :: Monterey Pine 1 129 Henry St   Back Yard : Yard 6 Tree 1 Private 2           6002668.0 2107340.8 37.766507036069605 -122.434024647923 (37.7665070360696, -122.434024647923) 15 5 5 28862 3
11367 112948 Property Tree 5 Tristaniopsis laurina :: Swamp Myrtle 8 400 Pioche St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1 FUF 2   12 3x15   6005670.66964 2093276.94718 37.7280608613968 -122.42263943148599 (37.7280608613968, -122.422639431486) 9 7 7 309 5
11745 113379 Property Tree 5 Fagus sylvatica :: European Beech 139 140 CASTENADA AVE 1 Front Yard : Yard 4 Tree 1 Private 2     50     5994437.0 2101097.0 37.7488926059174 -122.462041158848 (37.7488926059174, -122.462041158848) 1 8 4 29491 40
11799 113440 Property Tree 5 Cupressus macrocarpa :: Monterey Cypress 91 190 BEACON ST   Back Yard : Yard 6 Tree 1 Private 2     32 3x3   6003193.0 2097540.0 37.739626138558705 -122.43150902083299 (37.7396261385587, -122.431509020833) 2 7 5 63 7
11845 113482 Property Tree 5 Pinus radiata :: Monterey Pine 1 2839 Pierce St   Back Yard : Yard 6 Tree 1 Private 2           6001345.0 2118077.0 37.7959107386074 -122.43937030854799 (37.7959107386074, -122.439370308548) 13 9 1 57 17
12632 114365 Property Tree 5 Pinus radiata :: Monterey Pine 1 2546 28th Ave 1 Back Yard : Yard 6 Tree 1 Private 2     35     5987735.7 2097954.4 37.739875761389605 -122.48498344199601 (37.7398757613896, -122.484983441996) 1 8 3 29491 35
12639 114373 Property Tree 5 Liquidambar styraciflua :: American Sweet Gum 44 805 GONZALEZ DR 1 Front Yard : Yard 4 Tree 1 Private 2     18     5988302.0 2089566.0 37.7168763353695 -122.482410970247 (37.7168763353695, -122.482410970247) 1 8 4 64 14
12678 114410 Property Tree 5 Pinus radiata :: Monterey Pine 1 10 GARDENSIDE DR   Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           5999306.0 2102458.0 37.752908704913395 -122.445302055175 (37.7529087049134, -122.445302055175) 2 5 5 63 38
12985 114731 Property Tree 5 Eucalyptus globulus :: Blue Gum 206 934 BRANNAN ST   Back Yard : Yard 6 Tree 1 Private 2 Dept of Real Estate 10     10x10   6010724.0 2108745.0 37.7708165471861 -122.40625919407302 (37.7708165471861, -122.406259194073) 14 2 9 28853 34
13071 114817 Property Tree 5 Pinus radiata :: Monterey Pine 1 100 RACCOON DR 1 Back Yard : Cutout 23 Tree 1 Private 2           5998725.0 2104028.0 37.757186355085004 -122.447424250084 (37.757186355085, -122.447424250084) 15 5 5 63 3
13179 114949 Property Tree 5 Pinus radiata :: Monterey Pine 1 1X WOODACRE DR 1 unknown : Yard 8 Tree 1 DPW 1     30 30x100   5991187.0 2095315.0 37.732829063550795 -122.47285799850201 (37.7328290635508, -122.472857998502) 1 8 4 64 40
13181 114950 Property Tree 5 Pinus radiata :: Monterey Pine 1 1X WOODACRE DR 2 unknown : Yard 8 Tree 1 DPW 1       30x100   5991187.0 2095315.0 37.732829063550795 -122.47285799850201 (37.7328290635508, -122.472857998502) 1 8 4 64 40
13855 115635 Property Tree 5 Pinus radiata :: Monterey Pine 1 81x ELSIE ST 1 Back Yard : Cutout 23 Tree 1 DPW 1     20 3x3   6007403.0 2098902.0 37.7436036039275 -122.41704909401301 (37.7436036039275, -122.417049094013) 2 7 7 28859 2

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" REAL,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" REAL,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT,
  "Fire Prevention Districts" INTEGER,
  "Police Districts" INTEGER,
  "Supervisor Districts" INTEGER,
  "Zip Codes" INTEGER,
  "Neighborhoods" INTEGER
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id))
Powered by Datasette · Query took 93.179ms · Data source: data.sfgov.org