trees

336 rows where Police Districts = 7 and qLegalStatus_id = 6 sorted by Supervisor Districts

✎ 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)
3096 100121 Significant Tree 6 Myoporum laetum :: Myoporum 62 690 Miramar Ave 1 Front Yard : Yard Tree Private 2           5995444.4 2093941.6 37.7293035878447 -122.458039824042 (37.7293035878447, -122.458039824042) 9 7 4 28861 40
4898 211279 Significant Tree 6 Pinus radiata :: Monterey Pine 15 350 Joost Ave 1 Sidewalk: Property side : Yard Tree Private 2     28 Width 10ft   5999756.13451 2094992.8184 37.7324367835174 -122.443209289192 (37.7324367835174, -122.443209289192) 9 7 4 63 40
7288 264692 Significant Tree 6 Quercus agrifolia :: Coast Live Oak 172 1500 Plymouth Ave 1 Side Yard : Yard Tree Private 2       10x10   5995893.6658 2094152.61505 37.7299087874515 -122.456501934539 (37.7299087874515, -122.456501934539) 9 7 4 28861 40
7631 256540 Significant Tree 6 Pinus radiata :: Monterey Pine 15 379X Cresta Vista Dr 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5997117 2096261 37.7357680647268 -122.452424833384 (37.7357680647268, -122.452424833384) 9 7 4 59 40
9495 261033 Significant Tree 6 Tree(s) :: 17 551 Los Palmos Dr 1 Front Yard : Yard Tree Private 2   01/14/2020 12:00:00 AM 3 10x10 Permit Number 784596 5996615 2095626 37.7339957349096 -122.454114584985 (37.7339957349096, -122.454114584985) 9 7 4 59 40
10088 253978 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 441 Detroit St 1 Unaccepted Street : Yard Tree Private 2       3x10   5999396 2094599 37.7313349085161 -122.444426062201 (37.7313349085161, -122.444426062201) 9 7 4 59 40
12289 254085 Significant Tree 6 Pinus radiata :: Monterey Pine 15 411 Lansdale Ave 1 Front Yard : Cutout Tree Private 2       6x6   5995707 2096451 37.7362088759349 -122.457313463895 (37.7362088759349, -122.457313463895) 9 7 4 59 40
13663 258677 Significant Tree 6 Cedrus deodara :: Deodar Cedar 109 607 Congo St 1 Sidewalk: Property side : Yard Tree Private 2       10x10   6000094 2095817 37.7347190533418 -122.442100351643 (37.7347190533418, -122.442100351643) 9 7 4 63 40
14356 264786 Significant Tree 6 Cedrus atlantica :: Atlas Cedar 233 451 Yerba Buena Ave 1 Front Yard : Cutout Tree Private 2       10x10   5995368 2094795 37.7316424274687 -122.458365690275 (37.7316424274687, -122.458365690275) 9 7 4 59 40
15224 264691 Significant Tree 6 Leucodendron argenteum :: Silver Tree 46 1560 Plymouth Ave 1 Front Yard : Yard Tree Private 2       10x10   5995798 2094356 37.730461740667 -122.45684736471 (37.730461740667, -122.45684736471) 9 7 4 28861 40
21762 100124 Significant Tree 6 Radermachera sinica :: China Doll Tree 394 40@ San Ramon Eastwood Dr 1 Front Yard : Yard Tree Private 2           5995635 2092781 37.7261278087338 -122.457296979484 (37.7261278087338, -122.457296979484) 9 7 4 28861 40
23065 98547 Significant Tree 6 Pinus radiata :: Monterey Pine 15 555@Rio Teresita Blvd 3 Front Yard : Yard Tree Private 2           5999006.5 2097247.3 37.7385842819574 -122.445963035448 (37.7385842819574, -122.445963035448) 9 7 4 59 40
29607 101467 Significant Tree 6 Cupressocyparis leylandii :: Leyland Cypress 185 301 Hazelwood Ave 2 Front Yard : Yard Tree Private 2           5996219.7 2095283.8 37.7330334614805 -122.455456526637 (37.7330334614805, -122.455456526637) 9 7 4 59 40
34696 253950 Significant Tree 6 Cedrus atlantica :: Atlas Cedar 233 431 Yerba Buena Ave 1 Front Yard : Cutout Tree Private 2       10x10   5995366 2094904 37.7319416000564 -122.458380491445 (37.7319416000564, -122.458380491445) 9 7 4 59 40
36038 115661 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 341 HAZELWOOD AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     15 3x3   5996066 2095432 37.7334315621613 -122.455998615118 (37.7334315621613, -122.455998615118) 9 7 4 59 40
37139 98289 Significant Tree 6 Olea europaea :: Olive Tree 9 300 Mangels Ave 5 Sidewalk: Property side : Yard Tree Private 2   01/24/2012 12:00:00 AM     Permit Number 768637 5999381.8 2095276.6 37.7331946288913 -122.444523835506 (37.7331946288913, -122.444523835506) 9 7 4 59 40
38717 98546 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 555@Rio Teresita Blvd 2 Sidewalk: Property side : Yard Tree Private 2           5999006.5 2097247.3 37.7385842819574 -122.445963035448 (37.7385842819574, -122.445963035448) 9 7 4 59 40
39767 254934 Significant Tree 6 Cedrus atlantica Glauca :: Blue Atlas Cedar 208 755 Ocean Ave 1 Sidewalk: Property side : Cutout Tree Private 2       3x6   5998003.33154 2091542.89024 37.7228639895457 -122.449020681299 (37.7228639895457, -122.449020681299) 9 7 4 28861 24
47483 113358 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 702 Foerster St 1 Sidewalk: Property side : Cutout Tree Private 2           5998153.40008835 2095558.62470631 37.7338988325043 -122.448791034412 (37.7338988325043, -122.448791034412) 9 7 4 59 40
48955 255537 Significant Tree 6 Melaleuca linariifolia :: Flaxleaf Paperbark 103 93X Monterey Blvd 1 Side Yard : Cutout Tree Private 2       10x10   6001470 2094575 37.7313871286154 -122.437254157834 (37.7313871286154, -122.437254157834) 9 7 4 63 40
56399 254401 Significant Tree 6 Cedrus atlantica Glauca :: Blue Atlas Cedar 208 755 Ocean Ave 1 Sidewalk: Property side : Cutout Tree Private 2       3x3 Permit Number 779678 5998027 2091524 37.7228134749722 -122.448937504689 (37.7228134749722, -122.448937504689) 9 7 4 28861 24
57424 101476 Significant Tree 6 :: 45 541 Congo St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/07/2015 12:00:00 AM 3   Permit Number 775316 6000089 2095440.1 37.7336838892166 -122.442090592963 (37.7336838892166, -122.442090592963) 9 7 4 63 40
59778 112374 Significant Tree 6 Eucalyptus Spp :: Eucalyptus 52 1247 Bosworth St 1 Front Yard : Yard Tree Private 2       20x20 Permit Number 775819 6000424.11007 2096055.79143 37.7353935258967 -122.440976176652 (37.7353935258967, -122.440976176652) 9 7 4 63 40
61064 253428 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 3 Valletta Ct 1 Side Yard : Cutout Tree Private 2       6x10 Permit Number 780575 5999319 2096479 37.7364925519579 -122.444827352142 (37.7364925519579, -122.444827352142) 9 7 4 63 40
63394 106833 Significant Tree 6 Juniperus chinensis :: Juniper 113 174 STILLINGS AVE 1 Front Yard : Yard Tree Private 2           5999619.6 2095804.2 37.7346568605649 -122.443739589791 (37.7346568605649, -122.443739589791) 9 7 4 63 40
64560 87191 Significant Tree 6 Tree(s) :: 17 640 Miramar Ave 1 Front Yard : Yard Tree Private 2   01/29/2008 12:00:00 AM     Permit Number 50212 5995439 2093622 37.7284257331327 -122.458035371987 (37.7284257331327, -122.458035371987) 9 7 4 28861 40
71228 253470 Significant Tree 6 Juniperus chinensis :: Juniper 113 3 Valletta Ct 2 Side Yard : Cutout Tree Private 2       6x10   5999319 2096479 37.7364925519579 -122.444827352142 (37.7364925519579, -122.444827352142) 9 7 4 63 40
76095 106244 Significant Tree 6 Magnolia spp :: Magnolia 224 735 MANGELS AVE 1 Front Yard : Yard Tree Private 2   06/02/2014 12:00:00 AM 14   Permit Number 772876 5996640.8 2095225.8 37.7328983615352 -122.453996493912 (37.7328983615352, -122.453996493912) 9 7 4 59 40
78343 101466 Significant Tree 6 Afrocarpus gracilior :: Fern Pine 89 301 Hazelwood Ave 1 Front Yard : Yard Tree Private 2           5996219.7 2095283.8 37.7330334614805 -122.455456526637 (37.7330334614805, -122.455456526637) 9 7 4 59 40
85195 98151 Significant Tree 6 Pinus radiata :: Monterey Pine 15 850 Rockdale Dr 3 Front Yard : Yard Tree Private 2         Permit Number 768501 5996729.9 2098301.3 37.7413480470066 -122.453910481227 (37.7413480470066, -122.453910481227) 9 7 4 59 40
89599 98156 Significant Tree 6 Pinus radiata :: Monterey Pine 15 149x Chaves Ave 1 Front Yard : Yard Tree Private 2           5996703.5 2098396.7 37.7416084783757 -122.454008650942 (37.7416084783757, -122.454008650942) 9 7 4 59 40
104704 256850 Significant Tree 6 Calocedrus decurrens :: Incense Cedar 206 100 Brentwood Ave 1 Front Yard : Yard Tree Private 2       6x6   5995843 2095739 37.7342617075966 -122.456791779994 (37.7342617075966, -122.456791779994) 9 7 4 59 40
104794 115276 Significant Tree 6 Pinus radiata :: Monterey Pine 15 598X PORTOLA DR 1 Sidewalk: Curb side : Yard Tree Private 2       3x3   5997411 2099824 37.7455680371271 -122.451665301061 (37.7455680371271, -122.451665301061) 1 7 4 59 40
110581 113359 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 702 Foerster St 2 Sidewalk: Property side : Cutout Tree Private 2           5998153.40008835 2095558.62470631 37.7338988325043 -122.448791034412 (37.7338988325043, -122.448791034412) 9 7 4 59 40
116509 98545 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 555@Rio Teresita Blvd 1 Front Yard : Yard Tree Private 2           5999006.5 2097247.3 37.7385842819574 -122.445963035448 (37.7385842819574, -122.445963035448) 9 7 4 59 40
119037 112769 Significant Tree 6 Myoporum laetum :: Myoporum 62 1X HOWTH ST 1 Sidewalk: Property side : Yard Tree Private 2       3x3   5998027 2091524 37.7228134749722 -122.448937504689 (37.7228134749722, -122.448937504689) 9 7 4 28861 24
130286 253951 Significant Tree 6 Tree(s) :: 17 431 Yerba Buena Ave 2 Front Yard : Cutout Tree Private 2   01/17/2018 12:00:00 AM 3 10x10 Permit Number 780852 5995366 2094904 37.7319416000564 -122.458380491445 (37.7319416000564, -122.458380491445) 9 7 4 59 40
133887 112770 Significant Tree 6 Myoporum laetum :: Myoporum 62 1X HOWTH ST 2 Sidewalk: Property side : Yard Tree Private 2       3x3   5998027 2091524 37.7228134749722 -122.448937504689 (37.7228134749722, -122.448937504689) 9 7 4 28861 24
135306 253899 Significant Tree 6 Eucalyptus sideroxylon :: Red Ironbark 127 380 Monterey Blvd 1 Sidewalk: Property side : Cutout Tree Private 2       6x10 Permit Number 780835 5999528 2094735 37.7317158633652 -122.443979483467 (37.7317158633652, -122.443979483467) 9 7 4 63 40
136074 112773 Significant Tree 6 Myoporum laetum :: Myoporum 62 1X HOWTH ST 5 Sidewalk: Property side : Yard Tree Private 2       3x3   5998027 2091524 37.7228134749722 -122.448937504689 (37.7228134749722, -122.448937504689) 9 7 4 28861 24
137248 112771 Significant Tree 6 Myoporum laetum :: Myoporum 62 1X HOWTH ST 3 Sidewalk: Property side : Yard Tree Private 2       3x3   5998027 2091524 37.7228134749722 -122.448937504689 (37.7228134749722, -122.448937504689) 9 7 4 28861 24
139381 109706 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 96 CRESTA VISTA DR   Back Yard : Cutout Tree Private 2           5995602.1 2096103.5 37.7352487002973 -122.457651008037 (37.7352487002973, -122.457651008037) 9 7 4 59 40
139989 100474 Significant Tree 6 Pinus halepensis :: Allepo Pine 330 930 Monterey Blvd 2 Front Yard : Yard Tree Private 2           5995794.4 2094643.4 37.7312506649165 -122.456880589247 (37.7312506649165, -122.456880589247) 9 7 4 59 40
140130 112774 Significant Tree 6 Myoporum laetum :: Myoporum 62 1X HOWTH ST 6 Sidewalk: Property side : Yard Tree Private 2       3x3   5998027 2091524 37.7228134749722 -122.448937504689 (37.7228134749722, -122.448937504689) 9 7 4 28861 24
143508 256539 Significant Tree 6 Pinus radiata :: Monterey Pine 15 379X Cresta Vista Dr 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5997117 2096261 37.7357680647268 -122.452424833384 (37.7357680647268, -122.452424833384) 9 7 4 59 40
143852 98290 Significant Tree 6 Olea europaea :: Olive Tree 9 300 Mangels Ave 6 Sidewalk: Property side : Yard Tree Private 2   01/24/2012 12:00:00 AM     Permit Number 768637 5999381.8 2095276.6 37.7331946288913 -122.444523835506 (37.7331946288913, -122.444523835506) 9 7 4 59 40
146280 255793 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 441 Detroit St 1 Unaccepted Street : Yard Tree Private 2       30x30 Permit Number 782172 5999396 2094599 37.7313349085161 -122.444426062201 (37.7313349085161, -122.444426062201) 9 7 4 59 40
156524 101468 Significant Tree 6 Cupressocyparis leylandii :: Leyland Cypress 185 301 Hazelwood Ave 3 Front Yard : Yard Tree Private 2           5996219.7 2095283.8 37.7330334614805 -122.455456526637 (37.7330334614805, -122.455456526637) 9 7 4 59 40
160307 110393 Significant Tree 6 Juniperus chinensis :: Juniper 113 451 LOS PALMOS DR 1 Sidewalk: Property side : Cutout Tree Private 2       3x8   5997298 2095759 37.7344000615683 -122.451762846846 (37.7344000615683, -122.451762846846) 9 7 4 59 40
161712 92964 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 380 Valdez Ave 1 Front Yard : Yard Tree Private 2     17     5995792.2 2095482.9 37.7335556021648 -122.456948893253 (37.7335556021648, -122.456948893253) 9 7 4 59 40
165161 98288 Significant Tree 6 Olea europaea :: Olive Tree 9 300 Mangels Ave 4 Sidewalk: Property side : Yard Tree Private 2   01/24/2012 12:00:00 AM     Permit Number 768637 5999381.8 2095276.6 37.7331946288913 -122.444523835506 (37.7331946288913, -122.444523835506) 9 7 4 59 40
165386 112772 Significant Tree 6 Myoporum laetum :: Myoporum 62 1X HOWTH ST 4 Sidewalk: Property side : Yard Tree Private 2       3x3   5998027 2091524 37.7228134749722 -122.448937504689 (37.7228134749722, -122.448937504689) 9 7 4 28861 24
168489 254935 Significant Tree 6 Cedrus atlantica Glauca :: Blue Atlas Cedar 208 755 Ocean Ave 2 Sidewalk: Property side : Cutout Tree Private 2       3x6 Permit Number 779678 5998003.33154 2091542.89024 37.7228639895457 -122.449020681299 (37.7228639895457, -122.449020681299) 9 7 4 28861 24
178454 96779 Significant Tree 6 Tree(s) :: 17 555 Melrose Ave 1 Back Yard : Yard Tree Private 2   07/18/2011 12:00:00 AM     Permit Number 767966 5996882.6 2095364.1 37.7332919614683 -122.45317051412 (37.7332919614683, -122.45317051412) 9 7 4 59 40
182728 102583 Significant Tree 6 Tree(s) :: 17 22 Gennessee St 1 Front Yard : Yard Tree Private 2   02/27/2013 12:00:00 AM     Permit Number 769949 5997479.4 2093692.8 37.7287371564084 -122.450986747444 (37.7287371564084, -122.450986747444) 9 7 4 28861 40
183500 98157 Significant Tree 6 Pinus radiata :: Monterey Pine 15 149x Chaves Ave 2 Front Yard : Yard Tree Private 2           5996703.5 2098396.7 37.7416084783757 -122.454008650942 (37.7416084783757, -122.454008650942) 9 7 4 59 40
189375 100473 Significant Tree 6 Pinus halepensis :: Allepo Pine 330 930 Monterey Blvd 1 Front Yard : Yard Tree Private 2           5995794.4 2094643.4 37.7312506649165 -122.456880589247 (37.7312506649165, -122.456880589247) 9 7 4 59 40
194175 116308 Significant Tree 6 Cedrus deodara :: Deodar Cedar 109 699X DETROIT ST 9 Back Yard : Yard Tree Private 2       3x20   5999400 2095202 37.7329908332996 -122.444455553893 (37.7329908332996, -122.444455553893) 9 7 4 59 40
194504 265143 Significant Tree 6 Cedrus deodara :: Deodar Cedar 109 333 Lansdale Ave 1 Front Yard : Yard Tree Private 2       3x3   5995416 2096422 37.7361125310636 -122.458317465478 (37.7361125310636, -122.458317465478) 9 7 4 59 40
115 121173 Significant Tree 6 Tree(s) :: 17 950 Duncan St 2 Front Yard : Yard Tree Private 2       3x3   6000333 2099683 37.7453477932295 -122.441551386161 (37.7453477932295, -122.441551386161) 2 7 5 63 22
429 259715 Significant Tree 6 Pittosporum crassifolium :: Karo Tree 95 210 Gold Mine Dr 1 Front Yard : Cutout Tree Private 2       3x3   6000723 2098465 37.7420256658379 -122.440115509428 (37.7420256658379, -122.440115509428) 2 7 5 63 7
2175 121189 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 1000x Duncan St 10 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 775289 5999834 2099740 37.7454758595085 -122.443280934089 (37.7454758595085, -122.443280934089) 2 7 5 63 22
3054 109568 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 95 Nordhoff St 1 Back Yard : Yard Tree Private 2         Permit Number 777169 6000348.8 2095645.6 37.7342629464917 -122.441207129815 (37.7342629464917, -122.441207129815) 9 7 5 63 40
3798 262575 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 141 Topaz Way   Front Yard : Yard Tree Private 2       3x3   6001722 2097902 37.7405366227001 -122.436621002014 (37.7405366227001, -122.436621002014) 2 7 5 63 7
5702 121171 Significant Tree 6 Tree(s) :: 17 900x Duncan St 4 Front Yard : Yard Tree Private 2       3x3   6000584 2099647 37.745263242779 -122.440680889831 (37.745263242779, -122.440680889831) 2 7 5 63 7
7000 251607 Significant Tree 6 Pinus radiata :: Monterey Pine 15 52 Amber Dr 2 Back Yard : Yard Tree Private 2           5999455 2100046 37.7462944425817 -122.444613441074 (37.7462944425817, -122.444613441074) 2 7 5 63 22
7196 251612 Significant Tree 6 Pinus radiata :: Monterey Pine 15 60R Amber Dr 1 Back Yard : Yard Tree Private 2           5999394 2100048 37.7462964530913 -122.444824514752 (37.7462964530913, -122.444824514752) 2 7 5 63 22
7310 96412 Significant Tree 6 Acer palmatum :: Japanese Maple 216 185 Chilton Ave   Front Yard : Yard Tree Private 2   05/18/2011 12:00:00 AM     Permit Number 767805 6001587.1 2095138.7 37.732941575251 -122.436889661497 (37.732941575251, -122.436889661497) 9 7 5 63 40
7906 262219 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 21X Stillings Ave 1 Back Yard : Yard Tree Private 2       3x3   6000348 2095645 37.7342612534616 -122.441209852629 (37.7342612534616, -122.441209852629) 9 7 5 63 40
8573 264725 Significant Tree 6 Araucaria heterophylla :: Norfolk Island Pine 238 136 Addison St 1 Front Yard : Cutout Tree Private 2       3x3   6002996 2096937 37.7379592717499 -122.432147110586 (37.7379592717499, -122.432147110586) 2 7 5 63 7
14497 251425 Significant Tree 6 Pittosporum spp :: Pittosporum spp 170 5016 Diamond Heights Blvd 2 Sidewalk: Property side : Yard Tree Private 2           5999555 2100128 37.7465253005744 -122.444273545879 (37.7465253005744, -122.444273545879) 2 7 5 63 22
16372 96327 Significant Tree 6 Cordyline australis :: Dracena Palm 64 296 Randall St 1 Sidewalk: Property side : Yard Tree Private 2         Permit Number 767829 6003708 2097940 37.7407536226533 -122.429756895294 (37.7407536226533, -122.429756895294) 2 7 5 63 7
20228 251632 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 14R Amethyst Way 1 Back Yard : Yard Tree Private 2           5999202 2100044 37.7462745109784 -122.445488137723 (37.7462745109784, -122.445488137723) 2 7 5 63 22
20385 251602 Significant Tree 6 Pittosporum crassifolium :: Karo Tree 95 44R Amber Dr 1 Back Yard : Yard Tree Private 2           5999509 2100035 37.7462673204657 -122.444425925791 (37.7462673204657, -122.444425925791) 2 7 5 63 22
22846 105861 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 3615-3623X Cesar Chavez St 2 Front Yard : Yard Tree Private 2           6005538 2100417 37.7476583584974 -122.423605504909 (37.7476583584974, -122.423605504909) 2 7 5 28859 22
23740 255978 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 36 Amber Dr 1 Front Yard : Yard Tree Private 2       3x3   5999567 2100009 37.7461992398699 -122.444223501473 (37.7461992398699, -122.444223501473) 2 7 5 63 22
23771 105863 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 3615-3623X Cesar Chavez St 4 Front Yard : Yard Tree Private 2           6005538 2100417 37.7476583584974 -122.423605504909 (37.7476583584974, -122.423605504909) 2 7 5 28859 22
24668 97534 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 203 Surrey St 1 Front Yard : Yard Tree Private 2         Permit Number 768282 6002070 2096079.6 37.7355525046422 -122.435287431957 (37.7355525046422, -122.435287431957) 2 7 5 63 7
25399 252916 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 101 Gold Mine Dr 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001472 2098865 37.7431665844065 -122.437554349716 (37.7431665844065, -122.437554349716) 2 7 5 63 7
27545 115090 Significant Tree 6 Tree(s) :: 17 121 Topaz Way 1 Front Yard : Yard Tree Private 2   01/11/2016 12:00:00 AM     Permit Number 776934 6001846.4 2098050 37.7409500647868 -122.436201464472 (37.7409500647868, -122.436201464472) 2 7 5 63 7
30295 251424 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 5016 Diamond Heights Blvd 1 Sidewalk: Property side : Yard Tree Private 2       3x3   5999555 2100128 37.7465253005744 -122.444273545879 (37.7465253005744, -122.444273545879) 2 7 5 63 22
30591 105422 Significant Tree 6 Pinus radiata :: Monterey Pine 15 5827 DIAMOND HEIGHTS BLVD 1 Front Yard : Yard Tree Private 2     36     6000844.1 2096795.2 37.7374476811542 -122.439577108095 (37.7374476811542, -122.439577108095) 2 7 5 63 7
30833 258289 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 36 Amber Dr 6 Front Yard : Yard Tree Private 2       3x3   5999567 2100009 37.7461992398699 -122.444223501473 (37.7461992398699, -122.444223501473) 2 7 5 63 22
32555 121168 Significant Tree 6 Tree(s) :: 17 900x Duncan St 1 Front Yard : Yard Tree Private 2       3x3   6000584 2099647 37.745263242779 -122.440680889831 (37.745263242779, -122.440680889831) 2 7 5 63 7
34428 251636 Significant Tree 6 Pinus radiata :: Monterey Pine 15 22R Amethyst Way 1 Back Yard : Yard Tree Private 2           5999148 2100052 37.7462933941297 -122.445675437709 (37.7462933941297, -122.445675437709) 2 7 5 63 22
34770 251426 Significant Tree 6 Pinus radiata :: Monterey Pine 15 5020 Diamond Heights Blvd 1 Sidewalk: Property side : Yard Tree Private 2           5999455 2100046 37.7462944425817 -122.444613441074 (37.7462944425817, -122.444613441074) 2 7 5 63 22
34790 105768 Significant Tree 6 Pinus radiata :: Monterey Pine 15 98X GOLD MINE DR 3 Front Yard : Yard Tree Private 2     16     6001350 2099153 37.7439504273559 -122.437996817375 (37.7439504273559, -122.437996817375) 2 7 5 63 22
35675 105864 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 3615-3623X Cesar Chavez St 5 Front Yard : Yard Tree Private 2           6005538 2100417 37.7476583584974 -122.423605504909 (37.7476583584974, -122.423605504909) 2 7 5 28859 22
35918 109061 Significant Tree 6 Pinus radiata :: Monterey Pine 15 36 ARBOR ST   Front Yard : Yard Tree Private 2         Permit Number 774913 6002094.4 2096943.6 37.7379262346414 -122.435264853151 (37.7379262346414, -122.435264853151) 2 7 5 63 7
39032 251604 Significant Tree 6 Pinus radiata :: Monterey Pine 15 48R Amber Dr 1 Back Yard : Yard Tree Private 2           5999482 2100041 37.7462822544405 -122.444519719345 (37.7462822544405, -122.444519719345) 2 7 5 63 22
39514 108244 Significant Tree 6 Ulmus parvifolia :: Chinese Elm 31 150 Conrad St 1 Back Yard : Cutout Tree Private 2     20     6001768.8 2096480 37.7366348009068 -122.436357440328 (37.7366348009068, -122.436357440328) 2 7 5 63 7
41386 121194 Significant Tree 6 Dodonaea viscosa :: Hop Bush 43 255x Red Rock Way 1 Front Yard : Yard Tree Private 2       3x3 Permit Number 775289 5999917 2099808 37.7456673038035 -122.442998816589 (37.7456673038035, -122.442998816589) 2 7 5 63 22
42469 251630 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 8R Amethyst Way 2 Back Yard : Yard Tree Private 2           5999237 2100032 37.7462435599048 -122.445366249721 (37.7462435599048, -122.445366249721) 2 7 5 63 22
42733 121190 Significant Tree 6 Myoporum laetum :: Myoporum 62 1000x Duncan St 11 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 775289 5999834 2099740 37.7454758595085 -122.443280934089 (37.7454758595085, -122.443280934089) 2 7 5 63 22
42888 113973 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 11 Hiliritas Ave 1 Front Yard : Yard Tree Private 2         Permit Number 776381 6001589.6 2096875.9 37.7377116664791 -122.437005345865 (37.7377116664791, -122.437005345865) 2 7 5 63 7
45212 254126 Significant Tree 6 Acacia longifolia :: Golden Wattle 150 1291 Bosworth St 1 Front Yard : Yard Tree Private 2       3x3   6000129 2096323 37.7361104052088 -122.44201565285 (37.7361104052088, -122.44201565285) 2 7 5 63 7
49109 104146 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1710-1738 Diamond St 1 Front Yard : Yard Tree Private 2     40     6001979.7 2099047.6 37.7436968136687 -122.435811922611 (37.7436968136687, -122.435811922611) 2 7 5 63 22
50063 105765 Significant Tree 6 Pinus radiata :: Monterey Pine 15 95 ORA WAY 1 Front Yard : Yard Tree Private 2     18     6001454.9 2097857 37.7403978808149 -122.437541306682 (37.7403978808149, -122.437541306682) 2 7 5 63 7
50525 173933 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 190 Beacon St 1 Front Yard : Yard Tree Private 2           6003193 2097540 37.7396261385587 -122.431509020833 (37.7396261385587, -122.431509020833) 2 7 5 63 7
52280 121184 Significant Tree 6 Myoporum laetum :: Myoporum 62 1000x Duncan St 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 775289 5999834 2099740 37.7454758595085 -122.443280934089 (37.7454758595085, -122.443280934089) 2 7 5 63 22

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)
);