trees

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

✎ 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)
32937 178336 Significant Tree 6 Pinus radiata :: Monterey Pine 15 401 Ocean Ave 2 Sidewalk: Property side : Yard Tree MTA 3     29 Width 8ft   5998664.9682 2091522.93582 37.7228470175482 -122.44673211619 (37.7228470175482, -122.44673211619) 9 7 6 28861 25
54303 178335 Significant Tree 6 Pinus radiata :: Monterey Pine 15 401 Ocean Ave 1 Sidewalk: Property side : Yard Tree MTA 3     33 Width 8ft   5998656.04486 2091523.12147 37.7228470175503 -122.446762975526 (37.7228470175503, -122.446762975526) 9 7 6 28861 25
36628 177109 Significant Tree 6 Ligustrum lucidum :: Glossy Privet 57 401 Ocean Ave 16 Sidewalk: Property side : Yard Tree MTA 3     6 Width 5ft   5998958.08532 2091518.52367 37.7228516427597 -122.445718558684 (37.7228516427597, -122.445718558684) 9 7 6 28861 25
47041 177110 Significant Tree 6 Ligustrum lucidum :: Glossy Privet 57 401 Ocean Ave 17 Sidewalk: Property side : Yard Tree MTA 3     6 Width 5ft   5998978.57855 2091518.53644 37.722852847868 -122.445647719081 (37.722852847868, -122.445647719081) 9 7 6 28861 25
49633 177105 Significant Tree 6 Ligustrum lucidum :: Glossy Privet 57 401 Ocean Ave 12 Sidewalk: Property side : Yard Tree MTA 3     4 Width 5ft   5998924.5969 2091518.78116 37.7228504376811 -122.445834339179 (37.7228504376811, -122.445834339179) 9 7 6 28861 25
57339 177108 Significant Tree 6 Ligustrum lucidum :: Glossy Privet 57 401 Ocean Ave 15 Sidewalk: Property side : Yard Tree MTA 3     5 Width 5ft   5998950.80755 2091518.23612 37.7228504376851 -122.44574369564 (37.7228504376851, -122.44574369564) 9 7 6 28861 25
173815 177104 Significant Tree 6 Ligustrum lucidum :: Glossy Privet 57 401 Ocean Ave 11 Sidewalk: Property side : Yard Tree MTA 3     4 Width 5ft   5998921.08183 2091519.29315 37.7228516427808 -122.445846526795 (37.7228516427808, -122.445846526795) 9 7 6 28861 25
176521 177106 Significant Tree 6 Ligustrum lucidum :: Glossy Privet 57 401 Ocean Ave 13 Sidewalk: Property side : Yard Tree MTA 3     7 Width 5ft   5998933.17773 2091518.16383 37.7228492325857 -122.445804632792 (37.7228492325857, -122.445804632792) 9 7 6 28861 25
551 234021 Significant Tree 6 Pittosporum tobira :: Japanese Mockorange 118 147 Nevada St 1 Sidewalk: Curb side : Pot Tree Private 2     13 Width 3ft   6009064.54563 2097789.74594 37.7406429263284 -122.411225300822 (37.7406429263284, -122.411225300822) 10 7 7 28859 2
3385 223764 Significant Tree 6 Juniperus chinensis :: Juniper 113 126 Bradford St 2 Sidewalk: Property side : Yard Tree Private 2     12 Width 3ft   6009530.67949 2097860.55808 37.7408634922583 -122.409618578359 (37.7408634922583, -122.409618578359) 10 7 7 28859 2
4813 223765 Significant Tree 6 Juniperus chinensis :: Juniper 113 126 Bradford St 3 Sidewalk: Property side : Yard Tree Private 2     9 Width 3ft   6009530.59471 2097856.4038 37.7408520807582 -122.409618578357 (37.7408520807582, -122.409618578357) 10 7 7 28859 2
7930 223763 Significant Tree 6 Juniperus chinensis :: Juniper 113 126 Bradford St 1 Sidewalk: Property side : Yard Tree Private 2     11 Width 3ft   6009530.79254 2097866.09723 37.7408787078943 -122.409618578334 (37.7408787078943, -122.409618578334) 10 7 7 28859 2
10162 230434 Significant Tree 6 Magnolia x soulangiana :: Saucer Magnolia 147 272 Anderson St 1 Front Yard : Yard Tree Private 2     9 Width 3ft   6007874.82314 2097362.07469 37.7394018403099 -122.415308650074 (37.7394018403099, -122.415308650074) 2 7 7 28859 2
11129 236516 Significant Tree 6 Prunus cerasifera :: Cherry Plum 7 63 Bronte St 1 Sidewalk: Curb side : Pot Tree Private 2     4 Width 3ft   6009359.84862 2097078.24448 37.7387058549889 -122.410154031979 (37.7387058549889, -122.410154031979) 10 7 7 28859 2
15717 221238 Significant Tree 6 Betula pendula :: European White Birch 253 55 Bronte St 1 Sidewalk: Curb side : Pot Tree Private 2     14 Width 3ft   6009363.02974 2097125.97708 37.7388370966643 -122.41014640214 (37.7388370966643, -122.41014640214) 10 7 7 28859 2
18860 229626 Significant Tree 6 Magnolia grandiflora :: Southern Magnolia 19 3658 Folsom St 1 Side Yard : Cutout Tree Private 2     10 Width 3ft   6008459.0571 2097864.523 37.7408142714666 -122.413324142211 (37.7408142714666, -122.413324142211) 2 7 7 28859 2
159697 226945 Significant Tree 6 Juniperus chinensis :: Juniper 113 998 Chenery St 4 Sidewalk: Property side : Yard Tree Private 2     21 Width 1ft   6001140.61217 2096125.61153 37.7356260187109 -122.438503967885 (37.7356260187109, -122.438503967885) 2 7 5 63 7
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
177584 234000 Significant Tree 6 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 749 27th St 2 Front Yard : Yard Tree Private 2     10 Width 10ft   6001659.60779 2099970.43439 37.7462125114091 -122.436984776447 (37.7462125114091, -122.436984776447) 2 7 5 63 22
104067 255325 Significant Tree 6 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 42 Lippard Ave 1 Front Yard : Yard Tree Private 2       Width 0ft Permit Number 781812 6002006.02273 2095939.48888 37.7351641583954 -122.435498605394 (37.7351641583954, -122.435498605394) 2 7 5 63 7
4724 262586 Significant Tree 6 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 2 Byron Ct 1 Front Yard : Yard Tree Private 2   08/19/2020 12:00:00 AM 3 8x8 Permit Number 781313 5999459.72778 2086749.57445 37.7097858201455 -122.443642066205 (37.7097858201455, -122.443642066205) 9 7 6 28861 5
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
29379 254551 Significant Tree 6 Cordyline australis :: Dracena Palm 64 1433 Cayuga Ave 1 Front Yard : Cutout Tree Private 2       6x6   5999129 2089595 37.7175798453783 -122.444989533853 (37.7175798453783, -122.444989533853) 9 7 6 28861 25
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
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
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
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
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
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
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
62 264980 Significant Tree 6 Ginkgo biloba :: Maidenhair Tree 22 222 Winfield St 1 Front Yard : Yard Tree Private 2       3x3   6006740 2098205 37.7416524795013 -122.419292156581 (37.7416524795013, -122.419292156581) 2 7 7 28859 2
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
873 113043 Significant Tree 6 Pinus radiata :: Monterey Pine 15 500 RAYMOND AVE 2 Front Yard : Cutout Tree Private 2   10/06/2015 12:00:00 AM   3x3   6008527 2088690 37.7156268060035 -122.412440877248 (37.7156268060035, -122.412440877248) 9 7 8 309 18
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
3313 262482 Significant Tree 6 Tree(s) :: 17 45 Delta St 1 Front Yard : Yard Tree Private 2       3x3   6010254 2089941 37.7191585615903 -122.406559656354 (37.7191585615903, -122.406559656354) 10 7 8 309 39
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
3842 109772 Significant Tree 6 Yucca elephantipes :: Giant Yucca 268 2200x SAN JOSE AVE 11 Sidewalk: Curb side : Cutout Tree Private 2     30 3x3   5998886 2091075 37.7216297132481 -122.445935857536 (37.7216297132481, -122.445935857536) 9 7 6 28861 25
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
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
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
8751 262427 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 1 Avalon Ave 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002848 2093194 37.7276734535 -122.432391560875 (37.7276734535, -122.432391560875) 9 7 6 28861 5
10910 120918 Significant Tree 6 Tree(s) :: 17 555x SAN JOSE AVE 2 Front Yard : Yard Tree Private 2   11/07/2016 12:00:00 AM 3 3x3 Permit Number 778877 6006305 2100249 37.747240333103 -122.420941331562 (37.747240333103, -122.420941331562) 2 7 7 28859 2
11014 262425 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 1 Avalon Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002848 2093194 37.7276734535 -122.432391560875 (37.7276734535, -122.432391560875) 9 7 6 28861 5
12676 251651 Significant Tree 6 Jacaranda mimosifolia :: Jacaranda 50 3237 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 782183 6009049 2099828 37.7462386522881 -122.411423013741 (37.7462386522881, -122.411423013741) 2 7 7 28859 2
15980 262426 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 1 Avalon Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002848 2093194 37.7276734535 -122.432391560875 (37.7276734535, -122.432391560875) 9 7 6 28861 5
16429 262110 Significant Tree 6 Phoenix dactylifera :: Date Palm 87 25 Santa Rosa Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002200 2092574 37.7259343081174 -122.434587389509 (37.7259343081174, -122.434587389509) 9 7 6 28861 25
18320 261763 Significant Tree 6 Pinus radiata :: Monterey Pine 15 315 Montcalm St 1 Front Yard : Yard Tree Private 2       3x3   6009577 2099558 37.7455268923792 -122.409578193595 (37.7455268923792, -122.409578193595) 2 7 7 28859 2
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
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
27222 258201 Significant Tree 6 Populus spp :: Poplar Spp 262 598X Alemany Blvd 5 Sidewalk: Property side : Cutout Tree Private 2       3x3   6006099.613365 2094764.868461 37.732170557365 -122.421262171784 (37.732170557365, -122.421262171784) 2 7 7 28861 2
28942 110737 Significant Tree 6 Taxodium mucronatum :: Montezuma Cypress 400 1299x PERSIA AVE 4 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14       3x3   6004594 2089787 37.7184174301537 -122.426113167879 (37.7184174301537, -122.426113167879) 9 7 8 309 18
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
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
32139 112726 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 40x BERNAL HEIGHTS BLVD 2 Sidewalk: Curb side : Cutout Tree Private 2     30 3x3   6009324 2098099 37.7415066181332 -122.410350033668 (37.7415066181332, -122.410350033668) 10 7 7 28859 2
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
33311 258200 Significant Tree 6 Populus spp :: Poplar Spp 262 598X Alemany Blvd 4 Sidewalk: Property side : Cutout Tree Private 2       3x3   6006099.613365 2094764.868461 37.732170557365 -122.421262171784 (37.732170557365, -122.421262171784) 2 7 7 28861 2
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
39321 120597 Significant Tree 6 Pinus radiata :: Monterey Pine 15 499x Ocean Ave 5 Sidewalk: Curb side : Cutout Tree MTA 3       3x3   5998874 2091543 37.7229140478676 -122.446010982458 (37.7229140478676, -122.446010982458) 9 7 6 28861 25
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
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
42938 112725 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 40x BERNAL HEIGHTS BLVD 1 Sidewalk: Curb side : Cutout Tree Private 2     30 3x3   6009324 2098099 37.7415066181332 -122.410350033668 (37.7415066181332, -122.410350033668) 10 7 7 28859 2
44800 120594 Significant Tree 6 Pinus radiata :: Monterey Pine 15 499x Ocean Ave 2 Sidewalk: Curb side : Cutout Tree MTA 3       3x3   5998874 2091543 37.7229140478676 -122.446010982458 (37.7229140478676, -122.446010982458) 9 7 6 28861 25
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
48619 253373 Significant Tree 6 Ginkgo biloba :: Maidenhair Tree 22 78 Peralta Ave 1 Front Yard : Yard Tree Private 2       3x3   6010457 2100357 37.7477700431666 -122.406591570174 (37.7477700431666, -122.406591570174) 2 7 7 28859 2
51717 115446 Significant Tree 6 Tree(s) :: 17 546 FRANCONIA ST 2 Back Yard : Yard Tree Private 2   04/01/2016 12:00:00 AM 3 3x3 Permit Number 777844 6009931 2098208 37.7418399166086 -122.408258912238 (37.7418399166086, -122.408258912238) 10 7 7 28859 2
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
55458 255165 Significant Tree 6 Podocarpus gracilor :: Fern Pine 51 371 Prospect Ave   Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/16/2018 12:00:00 AM 3 3x3 Permit Number 781717 6006352.58239 2097791.19314 37.7404944317648 -122.420602351048 (37.7404944317648, -122.420602351048) 2 7 7 28859 2
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
57354 121187 Significant Tree 6 Myoporum laetum :: Myoporum 62 1000x Duncan St 8 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
63157 116234 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 450 PERALTA AVE 1 Front Yard : Yard Tree Private 2       3x3   6009750 2099218 37.744603019334 -122.408955999129 (37.744603019334, -122.408955999129) 2 7 7 28859 2
63551 121177 Significant Tree 6 Acacia spp :: Acacia Spp 105 990x Duncan St 1 Front Yard : Yard Tree Private 2       3x3 Permit Number 775289 6000056 2099639 37.7452111944111 -122.442506045398 (37.7452111944111, -122.442506045398) 2 7 5 63 22
66441 109838 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 200x MONTCALM ST 1 Sidewalk: Curb side : Cutout Tree Private 2     30 3x3   6009924 2099647 37.7457907048197 -122.408384592716 (37.7457907048197, -122.408384592716) 2 7 7 28859 2
67180 121191 Significant Tree 6 Myoporum laetum :: Myoporum 62 1000x Duncan St 12 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
67675 110738 Significant Tree 6 Taxodium mucronatum :: Montezuma Cypress 400 1299x PERSIA AVE 5 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14       3x3   6004594 2089787 37.7184174301537 -122.426113167879 (37.7184174301537, -122.426113167879) 9 7 8 309 18
67746 121188 Significant Tree 6 Myoporum laetum :: Myoporum 62 1000x Duncan St 9 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
69512 113042 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 500 Raymond Ave 1 Front Yard : Cutout Tree Private 2   10/06/2015 12:00:00 AM 30 3x3   6008233.87951 2088473.93147 37.7150170728648 -122.413438766187 (37.7150170728648, -122.413438766187) 9 7 8 309 18
73655 253718 Significant Tree 6 Acer buergeranum :: Trident Maple 110 227 Madison St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF     3x3 Permit Number 780760 6005690 2092595 37.7261894743752 -122.422524168298 (37.7261894743752, -122.422524168298) 9 7 7 309 5
74590 115445 Significant Tree 6 Tree(s) :: 17 546 FRANCONIA ST 1 Back Yard : Yard Tree Private 2   04/01/2016 12:00:00 AM 3 3x3 Permit Number 777844 6009931 2098208 37.7418399166086 -122.408258912238 (37.7418399166086, -122.408258912238) 10 7 7 28859 2
80257 122411 Significant Tree 6 Ligustrum lucidum :: Glossy Privet 57 499x Ocean Ave 8 Sidewalk: Curb side : Cutout Tree MTA 3       3x3   5998874 2091543 37.7229140478676 -122.446010982458 (37.7229140478676, -122.446010982458) 9 7 6 28861 25
82626 258290 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 36 Amber Dr 7 Front Yard : Yard Tree Private 2       3x3   5999567 2100009 37.7461992398699 -122.444223501473 (37.7461992398699, -122.444223501473) 2 7 5 63 22
87873 121174 Significant Tree 6 Tree(s) :: 17 950 Duncan St 3 Front Yard : Yard Tree Private 2       3x3   6000333 2099683 37.7453477932295 -122.441551386161 (37.7453477932295, -122.441551386161) 2 7 5 63 22
88321 121186 Significant Tree 6 Myoporum laetum :: Myoporum 62 1000x Duncan St 7 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
88853 121193 Significant Tree 6 Myoporum laetum :: Myoporum 62 1000x Duncan St 14 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
92509 87216 Significant Tree 6 Robinia x ambigua 'Idahoensis' :: Idaho Pink Locust 525 500 Cortland Ave 2 Back Yard : Yard Tree Private 2   02/08/2008 12:00:00 AM   3x3 Permit Number 50224 6007640.7 2097187.4 37.7389090609704 -122.416105779709 (37.7389090609704, -122.416105779709) 2 7 7 28859 2
92548 122410 Significant Tree 6 Ligustrum lucidum :: Glossy Privet 57 499x Ocean Ave 7 Sidewalk: Curb side : Cutout Tree MTA 3       3x3   5998874 2091543 37.7229140478676 -122.446010982458 (37.7229140478676, -122.446010982458) 9 7 6 28861 25
94002 113187 Significant Tree 6 Pinus radiata :: Monterey Pine 15 3340 FOLSOM ST 1 Sidewalk: Curb side : Cutout Tree Private 2     17 3x3   6008444 2099179 37.7444226899799 -122.413469145285 (37.7444226899799, -122.413469145285) 2 7 7 28859 2
95045 121170 Significant Tree 6 Tree(s) :: 17 900x Duncan St 3 Front Yard : Yard Tree Private 2       3x3   6000584 2099647 37.745263242779 -122.440680889831 (37.745263242779, -122.440680889831) 2 7 5 63 7
95104 120593 Significant Tree 6 Metrosideros excelsa :: New Zealand Xmas Tree 16 499x Ocean Ave 4 Sidewalk: Curb side : Cutout Tree MTA 3     34 3x3   5998874 2091543 37.7229140478676 -122.446010982458 (37.7229140478676, -122.446010982458) 9 7 6 28861 25
95118 257896 Significant Tree 6 Myoporum laetum :: Myoporum 62 266 Moreland St 1 Front Yard : Yard Tree Private 2       3x3   6001949 2097289 37.7388663647576 -122.435792277212 (37.7388663647576, -122.435792277212) 2 7 5 63 7
98953 114193 Significant Tree 6 Tree(s) :: 17 555x SAN JOSE AVE 1 Front Yard : Yard Tree Private 2   11/07/2016 12:00:00 AM 3 3x3 Permit Number 778877 6006305 2100249 37.747240333103 -122.420941331562 (37.747240333103, -122.420941331562) 2 7 7 28859 2
100356 113045 Significant Tree 6 Pinus radiata :: Monterey Pine 15 500 RAYMOND AVE 4 Front Yard : Cutout Tree Private 2       3x3   6008527 2088690 37.7156268060035 -122.412440877248 (37.7156268060035, -122.412440877248) 9 7 8 309 18
102801 122418 Significant Tree 6 Ligustrum lucidum :: Glossy Privet 57 499x Ocean Ave 15 Sidewalk: Curb side : Cutout Tree MTA 3       3x3   5998874 2091543 37.7229140478676 -122.446010982458 (37.7229140478676, -122.446010982458) 9 7 6 28861 25
104414 120596 Significant Tree 6 Pinus radiata :: Monterey Pine 15 499x Ocean Ave 1 Sidewalk: Curb side : Cutout Tree MTA 3     36 3x3   5998874 2091543 37.7229140478676 -122.446010982458 (37.7229140478676, -122.446010982458) 9 7 6 28861 25
104555 258287 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 36 Amber Dr 4 Front Yard : Yard Tree Private 2       3x3   5999567 2100009 37.7461992398699 -122.444223501473 (37.7461992398699, -122.444223501473) 2 7 5 63 22
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
106382 116072 Significant Tree 6 Juniperus chinensis :: Juniper 113 388 POLARIS WAY 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   6000586 2086414 37.7089285790833 -122.439725431133 (37.7089285790833, -122.439725431133) 9 7 6 28861 5
109570 114194 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 555x SAN JOSE AVE 2 Front Yard : Yard Tree Private 2   11/23/2015 12:00:00 AM 30 3x3 Permit Number 777057 6006305 2100249 37.747240333103 -122.420941331562 (37.747240333103, -122.420941331562) 2 7 7 28859 2
110002 62912 Significant Tree 6 Robinia x ambigua 'Idahoensis' :: Idaho Pink Locust 525 500 Cortland Ave 1 Back Yard : Yard Tree Private 2   02/08/2008 12:00:00 AM   3x3 Permit Number 50224 6007523.90359428 2097218.90762974 37.7389890062486 -122.416511839888 (37.7389890062486, -122.416511839888) 2 7 7 28859 2

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