trees

117 rows where Police Districts = 6 and qLegalStatus_id = 6 sorted by Latitude

✎ View and edit SQL

This data as json, CSV (advanced)

Police Districts ✖

rowid TreeID qLegalStatus_id qSpecies_id qAddress SiteOrder qSiteInfo PlantType qCaretaker_id qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude ▼ Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods (old)
137332 112057 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 762 FUNSTON AVE 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   12     5991999 2110277 37.7739577928787 -122.47114039751 (37.7739577928787, -122.47114039751) 11 6 2 54 11
179316 112056 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 762 FUNSTON AVE 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   8     5991999 2110277 37.7739577928787 -122.47114039751 (37.7739577928787, -122.47114039751) 11 6 2 54 11
87883 120156 Significant Tree 6 Ficus nitida :: Laurel Fig 53 758 10th Ave 1 Sidewalk: Curb side : Cutout Landscaping Private 2     10     5992930 2110298 37.7740692588728 -122.467921468059 (37.7740692588728, -122.467921468059) 11 6 2 54 11
78031 91107 Significant Tree 6 Tree(s) :: 17 2650 Turk Blvd 2 Front Yard : Yard Tree Private 2   01/12/2009 12:00:00 AM   On campus Permit Number 51996 5995208 2110277 37.7741428808777 -122.460040004978 (37.7741428808777, -122.460040004978) 11 6 2 54 11
153312 91106 Significant Tree 6 Tree(s) :: 17 2650 Turk Blvd 1 Front Yard : Yard Tree Private 2   01/12/2009 12:00:00 AM   On campus Permit Number 51996 5995208 2110277 37.7741428808777 -122.460040004978 (37.7741428808777, -122.460040004978) 11 6 2 54 11
117508 121242 Significant Tree 6 Pinus radiata :: Monterey Pine 15 701 16th Ave 1 Back Yard : Cutout Tree Private 2     36     5990933 2110561 37.7746758635803 -122.474848566269 (37.7746758635803, -122.474848566269) 11 6 2 54 26
86650 102302 Significant Tree 6 Tree(s) :: 17 740X 31st Ave 1 Front Yard : Yard Tree Private 2   01/14/2013 12:00:00 AM     Permit Number 769784 5986476.3 2110809.8 37.7750997269751 -122.490283282468 (37.7750997269751, -122.490283282468) 11 6 2 55 26
1875 261661 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 741 30th Ave 1 Sidewalk: Curb side : Yard Tree Private 2 FUF         5986614 2110873 37.7752812973329 -122.489811603249 (37.7752812973329, -122.489811603249) 11 6 2 55 26
59834 253717 Significant Tree 6 Pinus Spp :: Pine Spp 100 4101 Balboa St 1 Back Yard : Yard Tree Private 2   01/08/2018 12:00:00 AM 3   Permit Number 780863 5982822 2110967 37.7753172554615 -122.50293574331 (37.7753172554615, -122.50293574331) 11 6 2 55 26
153240 107142 Significant Tree 6 Aesculus californica :: California Buckeye 168 2694 MCALLISTER ST 2 Front Yard : Yard Tree Private 2     48     5996297.4 2110789.6 37.7756129427938 -122.45630867289 (37.7756129427938, -122.45630867289) 11 6 2 54 16
138623 91110 Significant Tree 6 Pinus radiata :: Monterey Pine 15 2650 Turk Blvd 1 Front Yard : Yard Tree Private 2       On Campus   5998086.4 2111055.5 37.7764455713486 -122.450139282915 (37.7764455713486, -122.450139282915) 15 6 2 29492 16
191593 91111 Significant Tree 6 Pinus radiata :: Monterey Pine 15 2650 Turk Blvd 2 Front Yard : Yard Tree Private 2       On Campus   5998086.4 2111055.5 37.7764455713486 -122.450139282915 (37.7764455713486, -122.450139282915) 15 6 2 29492 16
124269 256872 Significant Tree 6 Tree(s) :: 17 2401X Golden Gate Ave 1 Sidewalk: Property side : Yard Tree Private 2   05/13/2019 12:00:00 AM 3 3x3 Permit Number 782666 5997871 2111315 37.7771457625148 -122.450903124986 (37.7771457625148, -122.450903124986) 15 6 2 29492 16
12431 262225 Significant Tree 6 Cupressus spp :: Cypress species 337 2450 Golden Gate Ave 1 Sidewalk: Property side : Yard Tree Private 2       Width 7ft   5997659.54255 2111324.05825 37.7771585265736 -122.451635273045 (37.7771585265736, -122.451635273045) 15 6 2 54 16
156485 105434 Significant Tree 6 Eriobotrya deflexa :: Bronze Loquat 8 4355 ANZA ST 1 Back Yard : Yard Tree Private 2     10     5985110.8 2111730.2 37.7775470387472 -122.495074662501 (37.7775470387472, -122.495074662501) 11 6 2 55 26
144517 112363 Significant Tree 6 Cedrus atlantica :: Atlas Cedar 233 540 10th Ave 3 Front Yard : Yard Tree Private 2     24 6x6   5992860.82014 2111778.58973 37.778130563709 -122.468268503132 (37.778130563709, -122.468268503132) 11 6 2 54 11
59898 108211 Significant Tree 6 Juniperus chinensis :: Juniper 113 524 45th Ave 2 Front Yard : Yard Tree Private 2         Permit Number 773704 5981973.19232 2112153.30127 37.7785245664452 -122.505959887315 (37.7785245664452, -122.505959887315) 11 6 2 55 26
172848 108210 Significant Tree 6 Juniperus chinensis :: Juniper 113 524 45th Ave 1 Front Yard : Yard Tree Private 2         Permit Number 773704 5981973.19232 2112153.30127 37.7785245664452 -122.505959887315 (37.7785245664452, -122.505959887315) 11 6 2 55 26
7835 258799 Significant Tree 6 Taxus baccata :: Irish Yew 86 566 29th Ave 1 Front Yard : Cutout Tree Private 2       3x3   5986943 2112080 37.7786145821325 -122.488762272653 (37.7786145821325, -122.488762272653) 11 6 2 55 26
17941 258800 Significant Tree 6 Juniperus chinensis :: Juniper 113 566 29th Ave 2 Front Yard : Cutout Tree Private 2       3x3   5986943 2112080 37.7786145821325 -122.488762272653 (37.7786145821325, -122.488762272653) 11 6 2 55 26
163821 87242 Significant Tree 6 Pinus radiata :: Monterey Pine 15 4131 Geary Blvd 1 Sidewalk: Property side : Yard Tree Private 2         Permit Number 50271 5994116.9 2112250.5 37.7794987690846 -122.46395756624 (37.7794987690846, -122.46395756624) 11 6 2 54 11
85997 111996 Significant Tree 6 Tree(s) :: 17 501 Point Lobos Ave   Front Yard : Yard Tree Private 2   07/08/2015 12:00:00 AM 3 3x3 Permit Number 775626 5981249.6 2112592.5 37.7796878572283 -122.508495636007 (37.7796878572283, -122.508495636007) 11 6 2 55 26
32725 106972 Significant Tree 6 Tree(s) :: 17 464 46TH AVE 3 Front Yard : Yard Tree Private 2   08/07/2014 12:00:00 AM     Permit Number 773827 5981646.2 2112608 37.7797537818913 -122.507124798545 (37.7797537818913, -122.507124798545) 11 6 2 55 26
90328 96835 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 6001 Geary Blvd 1 Front Yard : Cutout Tree Private 2           5988352.4 2112527.1 37.779924341439 -122.483919468894 (37.779924341439, -122.483919468894) 11 6 2 55 26
95953 95234 Significant Tree 6 Tree(s) :: 17 7 Almaden Ct   Front Yard : Yard Tree Private 2   01/25/2011 12:00:00 AM     Permit Number 767129 5995849 2112535 37.7803795989447 -122.457986127959 (37.7803795989447, -122.457986127959) 11 6 2 54 16
55810 116521 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 70 BEAUMONT AVE 1 Sidewalk: Property side : Yard Tree Private 2     10 3x3   5996728 2112568 37.7805206716372 -122.454947659336 (37.7805206716372, -122.454947659336) 11 6 2 54 16
135701 102604 Significant Tree 6 Tree(s) :: 17 401 45th Ave 1 Front Yard : Yard Tree Private 2   02/06/2013 12:00:00 AM     Permit Number 769720 5981859.7 2112893.4 37.7805499779863 -122.506407391963 (37.7805499779863, -122.506407391963) 11 6 2 55 26
13058 260903 Significant Tree 6 Taxus baccata :: Irish Yew 86 51 Shore View Ave 1 Sidewalk: Property side : Yard Tree Private 2       Width 4ft   5984536 2112849 37.7805852728313 -122.497145662996 (37.7805852728313, -122.497145662996) 11 6 2 55 26
45774 114249 Significant Tree 6 Eucalyptus Spp :: Eucalyptus 52 499x 24TH AVE 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   5988415 2112957 37.7811083698872 -122.483734439284 (37.7811083698872, -122.483734439284) 11 6 2 55 26
19027 260904 Significant Tree 6 Metrosideros excelsa :: New Zealand Xmas Tree 16 4228 Geary Blvd 1 Sidewalk: Property side : Cutout Tree Private 2       Width 4ft   5993841 2112866 37.7811728620679 -122.464956727678 (37.7811728620679, -122.464956727678) 11 6 2 54 11
59956 255159 Significant Tree 6 Pinus radiata :: Monterey Pine 15 4150 Clement St 1 Front Yard : Yard Tree Private 2           5983115 2113126 37.7812624555251 -122.502082001527 (37.7812624555251, -122.502082001527) 11 6 2 55 15
122238 254735 Significant Tree 6 Afrocarpus gracilior :: Fern Pine 89 363 14th Ave 1 Sidewalk: Property side : Cutout Tree Private 2         Permit Number 781538 5991507 2112990 37.781378479082 -122.473040175374 (37.781378479082, -122.473040175374) 11 6 2 54 26
61291 113491 Significant Tree 6 Dodonaea viscosa :: Hop Bush 43 366x 07TH AVE 1 Sidewalk: Property side : Cutout Tree Private 2   12/07/2015 12:00:00 AM 6 3x3 Permit Number 776681 5993712 2113143 37.7819259902039 -122.465423128165 (37.7819259902039, -122.465423128165) 11 6 2 54 11
49235 110583 Significant Tree 6 Phoenix canariensis :: Canary Island Date Palm 160 46 COOK ST 5 Sidewalk: Curb side : Cutout Tree Private 2     36     5997534 2113434 37.782944683725 -122.452221842699 (37.782944683725, -122.452221842699) 15 6 1 54 31
32630 85060 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 7070 California St 1 Front Yard : Cutout Tree Private 2   07/03/2007 12:00:00 AM     Permit Number 49405 5985878 2113896 37.7835385880022 -122.492580242312 (37.7835385880022, -122.492580242312) 11 6 2 55 26
1408 260469 Significant Tree 6 Cupressocyparis leylandii :: Leyland Cypress 185 1 Masonic Ave 4 Side Yard : Yard Tree Private 2           5998961 2113697 37.7837484562249 -122.447303968308 (37.7837484562249, -122.447303968308) 15 6 1 54 31
3184 260470 Significant Tree 6 Cupressocyparis leylandii :: Leyland Cypress 185 1 Masonic Ave 5 Side Yard : Yard Tree Private 2           5998961 2113697 37.7837484562249 -122.447303968308 (37.7837484562249, -122.447303968308) 15 6 1 54 31
7030 260467 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 1 Masonic Ave 2 Side Yard : Yard Tree Private 2           5998961 2113697 37.7837484562249 -122.447303968308 (37.7837484562249, -122.447303968308) 15 6 1 54 31
15148 260466 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 1 Masonic Ave 1 Side Yard : Yard Tree Private 2           5998961 2113697 37.7837484562249 -122.447303968308 (37.7837484562249, -122.447303968308) 15 6 1 54 31
16043 260472 Significant Tree 6 Cupressocyparis leylandii :: Leyland Cypress 185 1 Masonic Ave 7 Side Yard : Yard Tree Private 2           5998961 2113697 37.7837484562249 -122.447303968308 (37.7837484562249, -122.447303968308) 15 6 1 54 31
16147 260471 Significant Tree 6 Metrosideros excelsa :: New Zealand Xmas Tree 16 1 Masonic Ave 6 Side Yard : Yard Tree Private 2           5998961 2113697 37.7837484562249 -122.447303968308 (37.7837484562249, -122.447303968308) 15 6 1 54 31
18482 260468 Significant Tree 6 Cupressocyparis leylandii :: Leyland Cypress 185 1 Masonic Ave 3 Side Yard : Yard Tree Private 2           5998961 2113697 37.7837484562249 -122.447303968308 (37.7837484562249, -122.447303968308) 15 6 1 54 31
119552 101202 Significant Tree 6 Tree(s) :: 17 7070 California St 1 Front Yard : Tree Private 2   10/03/2012 12:00:00 AM     Permit Number 769231 5985659.5 2114437.4 37.7850123376907 -122.493376058427 (37.7850123376907, -122.493376058427) 11 6 1 55 33
145768 98703 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 7070@ 32nd Ave California St 4 Front Yard : Tree Private 2   03/10/2012 12:00:00 AM     Permit Number 767466 5985659.5 2114437.4 37.7850123376907 -122.493376058427 (37.7850123376907, -122.493376058427) 11 6 1 55 33
162612 101203 Significant Tree 6 Tree(s) :: 17 7070 California St 2 Front Yard : Tree Private 2   10/03/2012 12:00:00 AM     Permit Number 769231 5985659.5 2114437.4 37.7850123376907 -122.493376058427 (37.7850123376907, -122.493376058427) 11 6 1 55 33
186507 254476 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 1511 Lyon St 1 Front Yard : Cutout Tree Private 2           5999620 2114151 37.7850326563334 -122.445056733542 (37.7850326563334, -122.445056733542) 15 6 1 29490 31
8456 99698 Significant Tree 6 Eucalyptus sideroxylon :: Red Ironbark 127 1750 Divisadero St 1 Front Yard : Cutout Tree Private 2           6001124 2114376 37.7857361748448 -122.439869519979 (37.7857361748448, -122.439869519979) 15 6 1 29490 27
188669 99699 Significant Tree 6 Eucalyptus sideroxylon :: Red Ironbark 127 1750 Divisadero St 2 Front Yard : Cutout Tree Private 2           6001124 2114376 37.7857361748448 -122.439869519979 (37.7857361748448, -122.439869519979) 15 6 1 29490 27
156782 12711 Significant Tree 6 Tree(s) :: 17 1449 Lake St 3 Front Yard : Cutout Tree DPW 1   06/01/2000 12:00:00 AM   3   5990998.3321714 2114735.5234974 37.7861417388427 -122.474927352046 (37.7861417388427, -122.474927352046) 11 6 2 54 26
50 264964 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 3641 California St 1 Sidewalk: Curb side : Cutout Tree Private 2       3X3   5996989 2114619 37.7861671437011 -122.454192924446 (37.7861671437011, -122.454192924446) 11 6 1 54 31
1248 260958 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 59 3790 California St 2 Sidewalk: Property side : Cutout Tree Private 2       Width 3ft   5996359 2114633 37.786169437555 -122.456373557771 (37.786169437555, -122.456373557771) 11 6 1 54 31
17671 260957 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 59 3790 California St 1 Sidewalk: Property side : Cutout Tree Private 2       Width 3ft   5996359 2114633 37.786169437555 -122.456373557771 (37.786169437555, -122.456373557771) 11 6 1 54 31
127746 120952 Significant Tree 6 Tree(s) :: 17 100X 32nd Ave 1 Sidewalk: Curb side : Yard Tree Private 2   08/30/2016 12:00:00 AM 3 10x10 Permit Number 778529 5985781 2114962 37.7864598433405 -122.492994369609 (37.7864598433405, -122.492994369609) 11 6 1 55 33
5115 260959 Significant Tree 6 Metrosideros excelsa :: New Zealand Xmas Tree 16 400 Cherry St 11 Sidewalk: Property side : Yard Tree Private 2       Width 9ft   5996243 2114742 37.7864620624436 -122.456782770891 (37.7864620624436, -122.456782770891) 11 6 1 54 31
76263 85093 Significant Tree 6 Tree(s) :: 17 100 32nd Ave 2 Front Yard : Yard Tree Private 2   12/18/2009 12:00:00 AM     Permit Number 53112 5985781.7 2114962.8 37.7864620808454 -122.49299200677 (37.7864620808454, -122.49299200677) 11 6 1 55 33
182598 92909 Significant Tree 6 Tree(s) :: 17 100 32nd Ave 1 Front Yard : Yard Tree Private 2   12/18/2009 12:00:00 AM 11   Permit Number 53112 5985781.7 2114962.8 37.7864620808454 -122.49299200677 (37.7864620808454, -122.49299200677) 11 6 1 55 33
108809 187638 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 875 El Camino Del Mar 2 Side Yard : Yard Tree Private 2       10x10   5985641 2114972 37.786479112006 -122.493479464676 (37.786479112006, -122.493479464676) 11 6 1 55 15
157354 187637 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 875 El Camino Del Mar 1 Side Yard : Yard Tree Private 2       10x10   5985641 2114972 37.786479112006 -122.493479464676 (37.786479112006, -122.493479464676) 11 6 1 55 15
146707 103477 Significant Tree 6 Tree(s) :: 17 875 El Camino Del Mar 1 Front Yard : Tree Private 2   05/08/2013 12:00:00 AM     Permit Number 770113 5985641.7 2114972.5 37.7864805258078 -122.493477079739 (37.7864805258078, -122.493477079739) 11 6 1 55 15
3724 260475 Significant Tree 6 Acer spp :: Maple 88 520 Laurel St 3 Side Yard : Cutout Tree Private 2       Width 4ft   5998188 2114710 37.7864856873194 -122.450051281182 (37.7864856873194, -122.450051281182) 11 6 1 54 31
6928 260474 Significant Tree 6 Acer spp :: Maple 88 520 Laurel St 2 Side Yard : Cutout Tree Private 2       Width 4ft   5998188 2114710 37.7864856873194 -122.450051281182 (37.7864856873194, -122.450051281182) 11 6 1 54 31
14900 260476 Significant Tree 6 Acer spp :: Maple 88 520 Laurel St 4 Side Yard : Cutout Tree Private 2       Width 4ft   5998188 2114710 37.7864856873194 -122.450051281182 (37.7864856873194, -122.450051281182) 11 6 1 54 31
18519 260473 Significant Tree 6 Quercus agrifolia :: Coast Live Oak 172 520 Laurel St 1 Side Yard : Cutout Tree Private 2       Width 4ft   5998188 2114710 37.7864856873194 -122.450051281182 (37.7864856873194, -122.450051281182) 11 6 1 54 31
41301 108215 Significant Tree 6 Pinus radiata :: Monterey Pine 15 865 EL CAMINO DEL MAR 1 Front Yard : Yard Tree Private 2           5985761 2114995 37.7865492821054 -122.493065995445 (37.7865492821054, -122.493065995445) 11 6 1 55 33
68924 113937 Significant Tree 6 Pinus radiata :: Monterey Pine 15 800 EL CAMINO DEL MAR 1 Front Yard : Yard Tree Private 2     35     5985966 2115003 37.7865832348262 -122.492357345241 (37.7865832348262, -122.492357345241) 11 6 1 55 33
94461 98038 Significant Tree 6 Tree(s) :: 17 147 Lake St 1 Front Yard : Yard Tree Private 2   12/09/2011 12:00:00 AM     Permit Number 768423 5994977.2 2114852.5 37.7866927029397 -122.461170103848 (37.7866927029397, -122.461170103848) 11 6 1 54 11
3188 260646 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 3905 Sacramento St 2 Sidewalk: Property side : Cutout Tree Private 2       3x3   5996106 2114850 37.7867507340863 -122.457264569448 (37.7867507340863, -122.457264569448) 11 6 1 54 31
10213 260647 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 3905 Sacramento St 3 Sidewalk: Property side : Cutout Tree Private 2       3x3   5996106 2114850 37.7867507340863 -122.457264569448 (37.7867507340863, -122.457264569448) 11 6 1 54 31
17264 260645 Significant Tree 6 Eucalyptus sideroxylon :: Red Ironbark 127 3905 Sacramento St 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   5996106 2114850 37.7867507340863 -122.457264569448 (37.7867507340863, -122.457264569448) 11 6 1 54 31
137101 251410 Significant Tree 6 Magnolia grandiflora :: Southern Magnolia 19 2777 Pine St 1 Front Yard : Cutout Tree Private 2       3x3 Permit Number 779015 6000658 2114782 37.7868244087741 -122.441510888069 (37.7868244087741, -122.441510888069) 13 6 1 29490 27
47695 104013 Significant Tree 6 Fremontodendron spp :: Flannel Bush Tree 107 3978 Sacramento St 1 Front Yard : Yard Tree Private 2   07/24/2013 12:00:00 AM     Permit Number 770312 5995753.1 2114886.6 37.7868309532778 -122.458488162336 (37.7868309532778, -122.458488162336) 11 6 1 54 31
6867 260482 Significant Tree 6 Prunus cerasifera :: Cherry Plum 7 3333 California St 4 Sidewalk: Property side : Cutout Tree DPW 1       3X3   5998571 2114839 37.7868617958727 -122.448735497123 (37.7868617958727, -122.448735497123) 15 6 1 54 31
10395 260478 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 3333 California St 8 Sidewalk: Property side : Cutout Tree DPW 1       3X3   5998571 2114839 37.7868617958727 -122.448735497123 (37.7868617958727, -122.448735497123) 15 6 1 54 31
11407 260477 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 3333 California St 7 Sidewalk: Property side : Cutout Tree DPW 1       3X3   5998571 2114839 37.7868617958727 -122.448735497123 (37.7868617958727, -122.448735497123) 15 6 1 54 31
12545 260484 Significant Tree 6 Prunus cerasifera :: Cherry Plum 7 3333 California St 6 Sidewalk: Property side : Cutout Tree DPW 1       3X3   5998571 2114839 37.7868617958727 -122.448735497123 (37.7868617958727, -122.448735497123) 15 6 1 54 31
14823 260479 Significant Tree 6 Prunus cerasifera :: Cherry Plum 7 3333 California St 1 Sidewalk: Property side : Cutout Tree DPW 1       3X3   5998571 2114839 37.7868617958727 -122.448735497123 (37.7868617958727, -122.448735497123) 15 6 1 54 31
15393 260480 Significant Tree 6 Prunus cerasifera :: Cherry Plum 7 3333 California St 2 Sidewalk: Property side : Cutout Tree DPW 1       3X3   5998571 2114839 37.7868617958727 -122.448735497123 (37.7868617958727, -122.448735497123) 15 6 1 54 31
16021 260481 Significant Tree 6 Prunus cerasifera :: Cherry Plum 7 3333 California St 3 Sidewalk: Property side : Cutout Tree DPW 1       3X3   5998571 2114839 37.7868617958727 -122.448735497123 (37.7868617958727, -122.448735497123) 15 6 1 54 31
17369 260483 Significant Tree 6 Prunus cerasifera :: Cherry Plum 7 3333 California St 5 Sidewalk: Property side : Cutout Tree DPW 1       3X3   5998571 2114839 37.7868617958727 -122.448735497123 (37.7868617958727, -122.448735497123) 15 6 1 54 31
1427 260648 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 3891 Sacramento St 6 Sidewalk: Property side : Yard Tree Private 2       Width 7ft   5996301.11796 2114890.85877 37.7868741256738 -122.456592467462 (37.7868741256738, -122.456592467462) 11 6 1 54 31
4071 260649 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 3891 Sacramento St 7 Sidewalk: Property side : Yard Tree Private 2       Width 7ft   5996301.11796 2114890.85877 37.7868741256738 -122.456592467462 (37.7868741256738, -122.456592467462) 11 6 1 54 31
11600 260651 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 3751 Sacramento St 2 Front Yard : Cutout Tree Private 2       Width 3ft   5996933 2115011 37.7872402598449 -122.454414995547 (37.7872402598449, -122.454414995547) 11 6 1 54 31
16260 260650 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 3751 Sacramento St 1 Front Yard : Cutout Tree Private 2       Width 3ft   5996933 2115011 37.7872402598449 -122.454414995547 (37.7872402598449, -122.454414995547) 11 6 1 54 31
11487 260838 Significant Tree 6 Ficus nitida :: Laurel Fig 53 399 Laurel St 1 Side Yard : Cutout Tree Private 2       3x3   5998076 2115238 37.7879290262693 -122.45047684944 (37.7879290262693, -122.45047684944) 11 6 1 54 31
12511 260840 Significant Tree 6 Ficus nitida :: Laurel Fig 53 399 Laurel St 3 Side Yard : Cutout Tree Private 2       3x3   5998076 2115238 37.7879290262693 -122.45047684944 (37.7879290262693, -122.45047684944) 11 6 1 54 31
61403 111037 Significant Tree 6 Magnolia spp :: Magnolia 224 3991-3997 Washington St 2 Front Yard : Yard Tree Private 2           5995610.3 2115419.4 37.7882856707006 -122.459020806409 (37.7882856707006, -122.459020806409) 11 6 1 54 31
147948 111036 Significant Tree 6 Magnolia spp :: Magnolia 224 3991-3997 Washington St 1 Front Yard : Yard Tree Private 2           5995610.3 2115419.4 37.7882856707006 -122.459020806409 (37.7882856707006, -122.459020806409) 11 6 1 54 31
174679 98491 Significant Tree 6 Robinia pseudoacacia :: Black Locust 286 55X Perine Pl 1 Back Yard : Cutout Tree Private 2         Permit Number 768655 6002130.5 2115544.8 37.7890026421633 -122.436471006098 (37.7890026421633, -122.436471006098) 13 6 1 29490 27
127638 98241 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 3760 Washington St 1 Front Yard : Yard Tree Private 2   01/10/2012 12:00:00 AM 9   Permit Number 768462 5996814.46778 2115674.04938 37.7890540175629 -122.45487301497 (37.7890540175629, -122.45487301497) 11 6 1 54 31
26906 110476 Significant Tree 6 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 3700 Washington St 1 Back Yard : Yard Tree Private 2   04/16/2015 12:00:00 AM 3 10x10 Permit Number 774729 5997015.1 2115715 37.7891779638687 -122.454181816252 (37.7891779638687, -122.454181816252) 11 6 1 54 31
128000 104003 Significant Tree 6 Acer palmatum 'Sango Kaku' :: Coral Bark Maple 550 2109 Steiner St 1 Sidewalk: Property side : Cutout Tree Private 2   07/17/2013 12:00:00 AM     Permit Number 767176 6002333.5 2115633.4 37.7892574480846 -122.435774995524 (37.7892574480846, -122.435774995524) 13 6 1 29490 27
146644 105349 Significant Tree 6 Tree(s) :: 17 151X Spruce St 1 Front Yard : Yard Tree Private 2   01/16/2014 12:00:00 AM     Permit Number 771071 5997060.93638 2115845.70083 37.7895394616557 -122.45403267224 (37.7895394616557, -122.45403267224) 11 6 1 54 31
81784 93874 Significant Tree 6 Pistacia chinensis :: Chinese Pistache 32 2614 Sacramento St   Front Yard : Tree Private 2   04/14/2010 12:00:00 AM     Permit Number 53370 6002291 2115777 37.7896493226209 -122.435932319436 (37.7896493226209, -122.435932319436) 13 6 1 29490 27
90493 108096 Significant Tree 6 Ficus rubiginosa :: Port Jackson Fig 339 3370 Washington St 1 Front Yard : Cutout Tree Private 2     17   Permit Number 773610 5998674.83986 2115933.37372 37.7898725948813 -122.448455078738 (37.7898725948813, -122.448455078738) 13 6 1 54 31
147409 95215 Significant Tree 6 Acer palmatum :: Japanese Maple 216 2203 Divisadero St   Front Yard : Yard Tree Private 2           6000868 2115894 37.7898896344174 -122.440864138631 (37.7898896344174, -122.440864138631) 13 6 1 29490 27
48200 108097 Significant Tree 6 Tree(s) :: 17 3370 Washington St 2 Front Yard : Cutout Tree Private 2           5998663.3699 2115944.31994 37.789901994506 -122.448495552231 (37.789901994506, -122.448495552231) 13 6 1 54 31
44979 39247 Significant Tree 6 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 3524 Jackson St 1 Front Yard : Cutout Tree Private 2   08/22/2002 12:00:00 AM   5x10 Permit Number 772836 5997387.02929021 2116081.37513577 37.7902052526208 -122.452921449726 (37.7902052526208, -122.452921449726) 11 6 1 54 31
104764 115564 Significant Tree 6 Prunus serrulata :: Ornamental Cherry 84 3524 Jackson St 2 Front Yard : Cutout Tree Private 2       5x10   5997387.02929021 2116081.37513577 37.7902052526208 -122.452921449726 (37.7902052526208, -122.452921449726) 11 6 1 54 31
18680 262301 Significant Tree 6 Ficus microcarpa :: Chinese Banyan 97 2117 Broderick St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6000330 2116040 37.7902598573453 -122.44273605224 (37.7902598573453, -122.44273605224) 13 6 1 29490 27
105054 100572 Significant Tree 6 Magnolia grandiflora :: Southern Magnolia 19 3020 Washington St 1 Front Yard : Yard Tree Private 2     3   Permit Number 769157 6000180.60876 2116141.82829 37.790530933705 -122.443260250183 (37.790530933705, -122.443260250183) 13 6 1 29490 27

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "trees" (
   [rowid] INTEGER PRIMARY KEY,
   [TreeID] TEXT,
   [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]),
   [qSpecies_id] INTEGER,
   [qAddress] TEXT,
   [SiteOrder] TEXT,
   [qSiteInfo] TEXT,
   [PlantType] TEXT,
   [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]),
   [qCareAssistant] TEXT,
   [PlantDate] TEXT,
   [DBH] TEXT,
   [PlotSize] TEXT,
   [PermitNotes] TEXT,
   [XCoord] TEXT,
   [YCoord] TEXT,
   [Latitude] TEXT,
   [Longitude] TEXT,
   [Location] TEXT,
   [Fire Prevention Districts] TEXT,
   [Police Districts] TEXT,
   [Supervisor Districts] TEXT,
   [Zip Codes] TEXT,
   [Neighborhoods (old)] TEXT,
   FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id)
);