trees
336 rows where Police Districts = 7 and qLegalStatus_id = 6 sorted by DBH
This data as json, CSV (advanced)
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||
174 | 113728 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 1580 Valencia St | 5 | Front Yard : Yard | Tree | Private 2 | 6006496 | 2100402 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | 2 | 7 | 7 | 28859 | 2 | |||||
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 | |||
1377 | 262327 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 10X Sickles Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x10 | 5996833 | 2086575 | 37.709156314989 | -122.452707876493 | (37.709156314989, -122.452707876493) | 9 | 7 | 6 | 28861 | 25 | ||||
1679 | 262328 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 10X Sickles Ave | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x10 | 5996833 | 2086575 | 37.709156314989 | -122.452707876493 | (37.709156314989, -122.452707876493) | 9 | 7 | 6 | 28861 | 25 | ||||
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 | ||||
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 | |||||
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 | |||||
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 | ||||
6334 | 104866 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 411 Holladay Ave | 1 | Front Yard : Yard | Tree | Private 2 | 6010309.7 | 2098610.5 | 37.7429662928376 | -122.406977848202 | (37.7429662928376, -122.406977848202) | 10 | 7 | 7 | 28859 | 2 | |||||
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 | |||||
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 | ||||
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 | ||||
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 | ||||
9862 | 114526 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1 TIOGA AVE | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6011351 | 2088602 | 37.7155432513192 | -122.402673611341 | (37.7155432513192, -122.402673611341) | 9 | 7 | 8 | 309 | 39 | |||||
9889 | 116075 | Significant Tree 6 | Tree(s) :: 17 | 88 MONTCALM ST | 1 | Front Yard : Yard | Tree | Private 2 | 6010492 | 2099980 | 37.7467368416425 | -122.406443980671 | (37.7467368416425, -122.406443980671) | 2 | 7 | 7 | 28859 | 2 | |||||
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 | ||||
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 | ||||
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 | ||||
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 | |||
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 | ||||
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 | |||||
14780 | 262330 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 10X Sickles Ave | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x10 | 5996833 | 2086575 | 37.709156314989 | -122.452707876493 | (37.709156314989, -122.452707876493) | 9 | 7 | 6 | 28861 | 25 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
18601 | 262329 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 10X Sickles Ave | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x10 | 5996833 | 2086575 | 37.709156314989 | -122.452707876493 | (37.709156314989, -122.452707876493) | 9 | 7 | 6 | 28861 | 25 | ||||
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 | |||||
20298 | 113730 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 1580 Valencia St | 7 | Front Yard : Yard | Tree | Private 2 | 6006496 | 2100402 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | 2 | 7 | 7 | 28859 | 2 | |||||
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 | |||||
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 | |||||
22628 | 101981 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 25X Tiffany Ave | 4 | Front Yard : Yard | Tree | Private 2 | 6006415.7 | 2099833.4 | 37.7461054290546 | -122.420529042399 | (37.7461054290546, -122.420529042399) | 2 | 7 | 7 | 28859 | 2 | |||||
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 | |||||
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 | |||||
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 | ||||
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 | ||||
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 | |||
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 | ||||
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 | ||||
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 | |||||
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 | ||||
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 | ||||
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 | |||||
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 | ||||
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 | |||||
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 | |||||
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 | |||||
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 | |||||
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 | ||||
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 | ||||
39795 | 116833 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 1750 Geneva Ave | 1 | Front Yard : Yard | Tree | Private 2 | 6004521.4 | 2087037.7 | 37.710864341935 | -122.42616849364 | (37.710864341935, -122.42616849364) | 9 | 7 | 6 | 309 | 5 | |||||
41027 | 113738 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 1580 Valencia St | 15 | Front Yard : Yard | Tree | Private 2 | 6006496 | 2100402 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | 2 | 7 | 7 | 28859 | 2 | |||||
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 | |||
42851 | 113727 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 1580 Valencia St | 4 | Front Yard : Yard | Tree | Private 2 | 6006496 | 2100402 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | 2 | 7 | 7 | 28859 | 2 | |||||
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 | ||||
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 | ||||
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 | |||||
47565 | 116834 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 1750 Geneva Ave | 2 | Front Yard : Yard | Tree | Private 2 | 6004521.4 | 2087037.7 | 37.710864341935 | -122.42616849364 | (37.710864341935, -122.42616849364) | 9 | 7 | 6 | 309 | 5 | |||||
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 | ||||
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 | ||||
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 | |||||
51024 | 105872 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 595X San Jose Ave | 6 | Front Yard : Yard | Tree | Private 2 | 6006124.47156 | 2100100.14306 | 37.7468214281195 | -122.421555015777 | (37.7468214281195, -122.421555015777) | 2 | 7 | 7 | 28859 | 2 | |||||
52276 | 104869 | Significant Tree 6 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 411 Holladay Ave | 4 | Front Yard : Yard | Tree | Private 2 | Permit Number 770735 | 6010309.7 | 2098610.5 | 37.7429662928376 | -122.406977848202 | (37.7429662928376, -122.406977848202) | 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 | |||
52672 | 251603 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 44R Amber Dr | 2 | Back Yard : Yard | Tree | Private 2 | 5999509 | 2100035 | 37.7462673204657 | -122.444425925791 | (37.7462673204657, -122.444425925791) | 2 | 7 | 5 | 63 | 22 | |||||
54862 | 251605 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 95 | 48R Amber Dr | 2 | Back Yard : Yard | Tree | Private 2 | 5999482 | 2100041 | 37.7462822544405 | -122.444519719345 | (37.7462822544405, -122.444519719345) | 2 | 7 | 5 | 63 | 22 | |||||
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 | |||
59395 | 114525 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1 TIOGA AVE | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6011351 | 2088602 | 37.7155432513192 | -122.402673611341 | (37.7155432513192, -122.402673611341) | 9 | 7 | 8 | 309 | 39 | |||||
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 | |||
61399 | 113734 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 1580 Valencia St | 11 | Front Yard : Yard | Tree | Private 2 | 6006496 | 2100402 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | 2 | 7 | 7 | 28859 | 2 | |||||
61885 | 105866 | Significant Tree 6 | Maytenus boaria :: Mayten 58 | 3555 Cesar Chavez St | 1 | Front Yard : Yard | Tree | Private 2 | 6006336.4 | 2100501.8 | 37.7479362343406 | -122.420850697466 | (37.7479362343406, -122.420850697466) | 2 | 7 | 7 | 28859 | 2 | |||||
62334 | 87240 | Significant Tree 6 | Tree(s) :: 17 | 233 Arbor St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 02/14/2008 12:00:00 AM | Permit Number 50269 | 6001330 | 2096776 | 37.7374226054152 | -122.437895752709 | (37.7374226054152, -122.437895752709) | 2 | 7 | 5 | 63 | 7 | |||
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 | ||||
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 | |||||
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 | |||
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 | |||
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 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );