trees

1,732 rows where qLegalStatus_id = 6 sorted by qCaretaker_id

✎ View and edit SQL

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)
3205 259817 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 850x Bryant St 11 Sidewalk: Property side : Yard Tree Private 2       3x3   6011306 2110409 37.7754180474052 -122.404363174614 (37.7754180474052, -122.404363174614) 14 2 9 28853 34
3287 259814 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 850x Bryant St 8 Sidewalk: Property side : Yard Tree Private 2       3x3   6011306 2110409 37.7754180474052 -122.404363174614 (37.7754180474052, -122.404363174614) 14 2 9 28853 34
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
3323 258079 Significant Tree 6 Syagrus romanzoffianum :: Queen Palm 85 606 Capp St 3 Sidewalk: Property side : Cutout Tree Private 2       Width 3ft   6007262.82565 2103708.68672 37.7567937898158 -122.417874439265 (37.7567937898158, -122.417874439265) 2 4 7 28859 19
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
3462 233333 Significant Tree 6 Pinus radiata :: Monterey Pine 15 188 States St 1 Back Yard : Yard Tree Private 2     14 Width 3ft Permit Number 784841 6001049.9199 2106366.66768 37.763740347549 -122.43955144426 (37.763740347549, -122.43955144426) 15 5 5 28862 3
3581 255621 Significant Tree 6 Washingtonia robusta :: Mexican Fan Palm 72 366 San Carlos St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 785157 6006692 2103986 37.7575230865131 -122.419868246156 (37.7575230865131, -122.419868246156) 2 4 7 28859 19
3682 261986 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 1500 Bancroft Ave 3 Front Yard : Yard Tree Private 2           6014696 2091834 37.7246038778524 -122.391337493735 (37.7246038778524, -122.391337493735) 10 3 8 58 1
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
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
3910 173844 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 2X Crestline Dr 1 Front Yard : Yard Tree Private 2           5999319 2101169 37.7493701671822 -122.445164434644 (37.7493701671822, -122.445164434644) 2 5 5 63 38
4000 79751 Significant Tree 6 Schinus terebinthifolius :: Brazilian Pepper 93 15 Junipero Serra Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2       4x10   5991685.90264393 2095891.27109779 37.7344402285305 -122.471175151585 (37.7344402285305, -122.471175151585) 9 8 4 59 40
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
4096 261159 Significant Tree 6 Tree(s) :: 17 1100X Moraga St 3 Sidewalk: Property side : Yard Tree Private 2   05/22/2020 12:00:00 AM 3 10x10 Permit Number 784837 5990881 2103853 37.7562544846391 -122.474538790377 (37.7562544846391, -122.474538790377) 1 8 4 56 12
4164 260061 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 100 Larkin St 8 Sidewalk: Property side : Yard Tree Private 2       Width 3ft   6007818.52804 2111871.98583 37.7792395550969 -122.416530850318 (37.7792395550969, -122.416530850318) 7 9 9 28852 36
4207 247626 Significant Tree 6 Pittosporum eugenioides :: Tarata 138 286 Bradford St 1 Front Yard : Yard Tree Private 2     8     6009494.96271 2096975.40444 37.7384310509429 -122.409679612625 (37.7384310509429, -122.409679612625) 10 7 7 28859 2
4313 105327 Significant Tree 6 Tree(s) :: 17 2051 03rd St 1 Back Yard : Yard Tree Private 2         Permit Number 771015 6015779.9 2106081.5 37.7637846705736 -122.388584622631 (37.7637846705736, -122.388584622631) 14 3 8 28856 29
4419 260950 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 59 460x Davis Ct 2 Side Yard : Yard Tree Private 2       3x3   6013239 2118152 37.7967863568579 -122.398219792292 (37.7967863568579, -122.398219792292) 3 1 10 28860 6
4567 261551 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 135 Fernwood Dr 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5994788 2095004 37.7321829429526 -122.460385989231 (37.7321829429526, -122.460385989231) 9 8 4 59 40
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
4737 261021 Significant Tree 6 Pinus radiata :: Monterey Pine 15 3440X 19th Ave 2 Back Yard : Yard Tree Private 2       10x10 Permit Number 784857 5990714 2092679 37.7255638768787 -122.474300978757 (37.7255638768787, -122.474300978757) 9 8 4 64 40
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
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
4938 260583 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 397 05th St 1 Sidewalk: Property side : Yard Tree Private 2       3x3   6012019 2111820 37.7793321462044 -122.401995938922 (37.7793321462044, -122.401995938922) 6 2 9 28856 34
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
5213 84938 Significant Tree 6 Eucalyptus Spp :: Eucalyptus 52 145 Guerrero St 1 Front Yard : Yard Tree Private 2         Permit Number 49347 6005480 2108218 37.7690748022624 -122.42436083172 (37.7690748022624, -122.42436083172) 8 4 5 28853 19
5239 112929 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 2X Noe St   Sidewalk: Property side : Yard Tree Private 2   08/27/2015 12:00:00 AM   3x3 Permit Number 775129 6002836.07968 2107997.59158 37.7683199626551 -122.433490232023 (37.7683199626551, -122.433490232023) 15 5 5 28862 3
5246 262331 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 2140 Wawona St 1 Back Yard : Cutout Tree Private 2       3x3   5986390 2097232 37.7378137677629 -122.489583137449 (37.7378137677629, -122.489583137449) 1 8 3 29491 35
5414 261208 Significant Tree 6 Cedrus deodara :: Deodar Cedar 109 1131 Sutter St 1 Front Yard : Cutout Tree Private 2       3x3   6007175 2115019 37.7878442781586 -122.418980353142 (37.7878442781586, -122.418980353142) 13 9 10 28858 21
5510 104813 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 1601X Portola Dr 5 Front Yard : Yard Tree Private 2                              
5577 92312 Significant Tree 6 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 2711 34th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3 3x3   5985822.132 2096946.3119 37.7369961745626 -122.49152548244 (37.7369961745626, -122.49152548244) 1 8 3 29491 35
5622 251139 Significant Tree 6 Tree(s) :: 17 621X Gough St 1 Back Yard : Yard Tree Private 2   03/10/2017 12:00:00 AM 3   Permit Number 779685                    
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
5712 258876 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 1326 Hayes St 1 Sidewalk: Curb side : Yard Tree Private 2       Width 0ft   6001504 2110473 37.7750411502564 -122.438275119801 (37.7750411502564, -122.438275119801) 15 5 11 29492 10
5792 260568 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 131 Edgehill Way 2 Front Yard : Yard Tree Private 2       3x3   5994866 2098973 37.743085324311 -122.460403807929 (37.743085324311, -122.460403807929) 1 8 4 59 40
5928 260423 Significant Tree 6 Juniperus californica :: California juniper 295 237 Glenview Dr 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   5998907 2100812 37.7483664070673 -122.446563453195 (37.7483664070673, -122.446563453195) 2 5 5 63 38
5983 110477 Significant Tree 6 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 131X Washington St 1 Back Yard : Yard Tree Private 2   04/16/2015 12:00:00 AM 3 10x10 Permit Number 774729 6013427.21844 2117958.83498 37.7962664536588 -122.397554954018 (37.7962664536588, -122.397554954018) 3 1 10 28860 6
6044 259265 Significant Tree 6 Pinus radiata :: Monterey Pine 15 3580X 19th Ave 3 Sidewalk: Property side : Yard Tree Private 2       3x3 Permit Number 784388 5990529 2092111 37.723993571379 -122.474899060099 (37.723993571379, -122.474899060099) 9 8 4 64 14
6097 95161 Significant Tree 6 Acer palmatum :: Japanese Maple 216 2721 Pacific Ave   Front Yard : Yard Tree Private 2         Permit Number 54078 6001026.7 2116843.3 37.7925052022591 -122.440383162252 (37.7925052022591, -122.440383162252) 13 6 1 29490 27
6111 260586 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 397 05th St 4 Sidewalk: Property side : Yard Tree Private 2       3x3   6012019 2111820 37.7793321462044 -122.401995938922 (37.7793321462044, -122.401995938922) 6 2 9 28856 34
6121 260584 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 397 05th St 2 Sidewalk: Property side : Yard Tree Private 2       3x3   6012019 2111820 37.7793321462044 -122.401995938922 (37.7793321462044, -122.401995938922) 6 2 9 28856 34
6178 247627 Significant Tree 6 Pittosporum eugenioides :: Tarata 138 286 Bradford St 2 Front Yard : Yard Tree Private 2     9     6009494.82009 2096968.41626 37.7384118549208 -122.409679612627 (37.7384118549208, -122.409679612627) 10 7 7 28859 2
6296 260461 Significant Tree 6 Pinus radiata :: Monterey Pine 15 99X Lopez Ave 4 Front Yard : Yard Tree Private 2       10x10 Permit Number 784513 5994049 2100330 37.746764271907 -122.463327202712 (37.746764271907, -122.463327202712) 1 8 4 29491 40
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
6364 264920 Significant Tree 6 Tree(s) :: 17 99X Everglade Dr 2 Sidewalk: Property side : Cutout Tree Private 2   11/10/2020 12:00:00 AM 3 6x10 Permit Number 785453 5986512 2095174 37.7321701636719 -122.489010079787 (37.7321701636719, -122.489010079787) 1 8 4 64 35
6370 261832 Significant Tree 6 Ilex spp :: Holly Species 81 16 Merced Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5995265 2100184 37.7464333732005 -122.459111852123 (37.7464333732005, -122.459111852123) 1 8 4 59 40
6413 259813 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 850x Bryant St 7 Sidewalk: Property side : Yard Tree Private 2       3x3   6011306 2110409 37.7754180474052 -122.404363174614 (37.7754180474052, -122.404363174614) 14 2 9 28853 34
6519 251515 Significant Tree 6 Pinus radiata :: Monterey Pine 15 99x Mountview Ct 1 Back Yard : Yard Tree Private 2       3x3   5997620 2100449 37.7472961010623 -122.450987675073 (37.7472961010623, -122.450987675073) 1 5 4 63 38
6580 261206 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 2301 Leavenworth St 1 Side Yard : Yard Tree Private 2       3x3   6007514 2120271 37.8022840477627 -122.418179969724 (37.8022840477627, -122.418179969724) 5 1 1 28858 32
6612 259812 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 850x Bryant St 6 Sidewalk: Property side : Yard Tree Private 2       3x3   6011306 2110409 37.7754180474052 -122.404363174614 (37.7754180474052, -122.404363174614) 14 2 9 28853 34
6691 256248 Significant Tree 6 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 199x Clinton Park 3 Sidewalk: Property side : Yard Tree Private 2       3x3   6005490 2108162 37.7689216043545 -122.424322258789 (37.7689216043545, -122.424322258789) 8 4 5 28853 19
6747 261157 Significant Tree 6 Tree(s) :: 17 1100X Moraga St 1 Sidewalk: Property side : Yard Tree Private 2   05/22/2020 12:00:00 AM 3 10x10 Permit Number 784837 5990881 2103853 37.7562544846391 -122.474538790377 (37.7562544846391, -122.474538790377) 1 8 4 56 12
6758 95372 Significant Tree 6 Pinus radiata :: Monterey Pine 15 180 Yukon St   Back Yard : Cutout Tree Private 2     15   Permit Number 767755 6000174.3 2103956.9 37.7570738455347 -122.442406920559 (37.7570738455347, -122.442406920559) 2 4 5 28862 3
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
6931 92315 Significant Tree 6 Prunus serrulata :: Ornamental Cherry 84 2783 34th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3 3x3   5985839.9086 2096474.3035 37.7357012036342 -122.491429290175 (37.7357012036342, -122.491429290175) 1 8 3 29491 35
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
7026 121414 Significant Tree 6 Pinus radiata :: Monterey Pine 15 150 Raccoon Dr 1 Back Yard : Cutout Tree Private 2     36 3x3   5998776 2103987 37.7570766935068 -122.447244922317 (37.7570766935068, -122.447244922317) 15 5 5 63 3
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
7039 119606 Significant Tree 6 Myoporum laetum :: Myoporum 62 299x Avalon Ave 2 Front Yard : Yard Tree Private 2                              
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
7245 251144 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 200X Clarendon Ave 3 Sidewalk: Property side : Yard Tree Private 2       3x3   5996559 2104265 37.7577130831875 -122.454932197022 (37.7577130831875, -122.454932197022) 15 5 4 63 12
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
7291 105130 Significant Tree 6 Tree(s) :: 17 4045 MORAGA ST   Sidewalk: Property side : Yard Tree Private 2           5981665.2 2103465.9 37.7546533409301 -122.506380933635 (37.7546533409301, -122.506380933635) 1 8 3 56 35
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
7389 119599 Significant Tree 6 Cupressocyparis leylandii :: Leyland Cypress 185 4357x Mission St 1 Front Yard : Yard Tree Private 2         Permit Number 774415                    
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
7698 259819 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 850x Bryant St 13 Sidewalk: Property side : Yard Tree Private 2       3x3   6011306 2110409 37.7754180474052 -122.404363174614 (37.7754180474052, -122.404363174614) 14 2 9 28853 34
7767 262288 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 1601 Innes Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6015383 2097256 37.7395297026764 -122.389341053483 (37.7395297026764, -122.389341053483) 10 3 8 58 1
7770 98170 Significant Tree 6 Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 2324 Sacramento St   Front Yard : Yard Tree Private 2   12/22/2011 12:00:00 AM 3   Permit Number 768454 6003670.2 2115963.1 37.7902385582714 -122.431173718492 (37.7902385582714, -122.431173718492) 13 9 1 29490 27
7796 264921 Significant Tree 6 Tree(s) :: 17 99X Everglade Dr 3 Sidewalk: Property side : Cutout Tree Private 2   11/10/2020 12:00:00 AM 3 6x10 Permit Number 785453 5986512 2095174 37.7321701636719 -122.489010079787 (37.7321701636719, -122.489010079787) 1 8 4 64 35
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
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
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
7964 105328 Significant Tree 6 Tree(s) :: 17 2051 03rd St 2 Back Yard : Yard Tree Private 2         Permit Number 771015 6015779.9 2106081.5 37.7637846705736 -122.388584622631 (37.7637846705736, -122.388584622631) 14 3 8 28856 29
8007 261753 Significant Tree 6 Podocarpus gracilor :: Fern Pine 51 127 Edgehill Way 3 Back Yard : Cutout Tree Private 2   02/25/2020 12:00:00 AM 3     5994849.50332 2098967.43632 37.7430690988325 -122.46046044555 (37.7430690988325, -122.46046044555) 1 8 4 59 40
8040 260572 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 131 Edgehill Way 6 Front Yard : Yard Tree Private 2       3x3   5994866 2098973 37.743085324311 -122.460403807929 (37.743085324311, -122.460403807929) 1 8 4 59 40
8078 260059 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 100 Larkin St 6 Sidewalk: Property side : Yard Tree Private 2       Width 3ft   6007818.52804 2111871.98583 37.7792395550969 -122.416530850318 (37.7792395550969, -122.416530850318) 7 9 9 28852 36
8163 82435 Significant Tree 6 Pinus radiata :: Monterey Pine 15 51 Peralta Ave 1 Front Yard : Yard Tree Private 2   04/02/2005 12:00:00 AM 20     6010636.52703341 2100363.58782589 37.7477981742678 -122.405971235802 (37.7477981742678, -122.405971235802) 2 7 7 28859 2
8183 261995 Significant Tree 6 Phoenix spp :: Date palm (species unknown) 255 2727 Pierce St 2 Front Yard : Yard Tree Private 2   10/07/2020 12:00:00 AM 3 3x3 Permit Number 785198 6001553 2117834 37.7952553588401 -122.438633170174 (37.7952553588401, -122.438633170174) 13 9 1 57 27
8218 100711 Significant Tree 6 Tree(s) :: 17 966-968 Guerrero St 1 Front Yard : Yard Tree Private 2   09/27/2012 12:00:00 AM 14   Permit Number 769148 6005605.8 2103343.5 37.7556976788024 -122.423579088745 (37.7556976788024, -122.423579088745) 2 4 5 28859 19
8301 114726 Significant Tree 6 :: 45 520 Townsend St 2 Front Yard : Yard Tree Private 2           6012508.1 2109575.3 37.7731959986981 -122.400146236912 (37.7731959986981, -122.400146236912) 14 2 9 28853 34
8316 260638 Significant Tree 6 Olea europaea :: Olive Tree 9 3140 25th St 2 Sidewalk: Property side : Cutout Tree Private 2     3 3x3   6008726.17419 2101580.94088 37.7510337250786 -122.412663209658 (37.7510337250786, -122.412663209658) 2 4 7 28859 19
8454 247630 Significant Tree 6 Pittosporum eugenioides :: Tarata 138 286 Bradford St 5 Front Yard : Yard Tree Private 2     7     6009492.89578 2096949.07994 37.7383586537362 -122.409684901541 (37.7383586537362, -122.409684901541) 10 7 7 28859 2
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
8535 251265 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 3630x 19th Ave 4 Sidewalk: Property side : Yard Tree Private 2         Permit Number 779147                    
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
8580 261010 Significant Tree 6 Tree(s) :: 17 91 Parkridge Dr 3 Sidewalk: Curb side : Cutout Tree Private 2   12/18/2019 12:00:00 AM 3 3x3 Permit Number 784979 5998980 2102204 37.7521926688144 -122.446411148664 (37.7521926688144, -122.446411148664) 2 5 5 63 38
8743 261207 Significant Tree 6 Umbellularia californica :: California Bay 326 2301 Leavenworth St 3 Side Yard : Yard Tree Private 2       3x3   6007514 2120271 37.8022840477627 -122.418179969724 (37.8022840477627, -122.418179969724) 5 1 1 28858 32
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
8965 261020 Significant Tree 6 Pinus radiata :: Monterey Pine 15 3440X 19th Ave 1 Back Yard : Yard Tree Private 2       10x10 Permit Number 784857 5990714 2092679 37.7255638768787 -122.474300978757 (37.7255638768787, -122.474300978757) 9 8 4 64 40
8974 260925 Significant Tree 6 Pittosporum crassifolium :: Karo Tree 95 1900 Noriega St 1 Sidewalk: Property side : Yard Tree Private 2       3x3   5987961.4849 2103092.5821 37.7539969916819 -122.484579575666 (37.7539969916819, -122.484579575666) 1 8 3 56 35
9069 255620 Significant Tree 6 Washingtonia robusta :: Mexican Fan Palm 72 366 San Carlos St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 785157 6006692 2103986 37.7575230865131 -122.419868246156 (37.7575230865131, -122.419868246156) 2 4 7 28859 19
9200 259821 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 850x Bryant St 15 Sidewalk: Property side : Yard Tree Private 2       3x3   6011306 2110409 37.7754180474052 -122.404363174614 (37.7754180474052, -122.404363174614) 14 2 9 28853 34
9206 114067 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 6 Higuera Ave 1 Front Yard : Cutout Tree Private 2     20     5987898 2090420 37.7191976939958 -122.48386996767 (37.7191976939958, -122.48386996767) 1 8 4 64 14
9215 260060 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 100 Larkin St 7 Sidewalk: Property side : Yard Tree Private 2       Width 3ft   6007818.52804 2111871.98583 37.7792395550969 -122.416530850318 (37.7792395550969, -122.416530850318) 7 9 9 28852 36
9218 106080 Significant Tree 6 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 188 The Embarcadero 1 Front Yard : Yard Tree Private 2   03/20/2014 12:00:00 AM     Permit Number 771259 6015087.8131 2116516.98611 37.7923997963133 -122.391708043282 (37.7923997963133, -122.391708043282) 12 2 9 28855 6
9303 259269 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 3580X 19th Ave 7 Sidewalk: Property side : Yard Tree Private 2       3x3   5990529 2092111 37.723993571379 -122.474899060099 (37.723993571379, -122.474899060099) 9 8 4 64 14
9381 261160 Significant Tree 6 Tree(s) :: 17 1100X Moraga St 4 Sidewalk: Property side : Yard Tree Private 2   05/22/2020 12:00:00 AM 3 10x10 Permit Number 784837 5990881 2103853 37.7562544846391 -122.474538790377 (37.7562544846391, -122.474538790377) 1 8 4 56 12
9433 261043 Significant Tree 6 Tilia cordata :: Littleleaf Linden 12 499x Howard St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014038 2115260 37.7888900740934 -122.39525236007 (37.7888900740934, -122.39525236007) 6 2 9 28855 6

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