trees

39,840 rows where qLegalStatus_id = 7 sorted by SiteOrder

✎ 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)
23473 87390 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 3318 Fillmore St   Sidewalk: Curb side : Cutout Tree Private 2   04/24/2008 12:00:00 AM   3x3 Permit Number 50367 6002344.5 2119563.8 37.8000499325498 -122.436018296661 (37.8000499325498, -122.436018296661) 13 9 1 57 17
23742 112565 Permitted Site 7 Tree(s) :: 17 1000X 17th Ave   Sidewalk: Curb side : Cutout Tree Private 2   08/06/2015 12:00:00 AM     Permit Number 774340 5990959.97324 2102133.59106 37.7515380150924 -122.474140224193 (37.7515380150924, -122.474140224193) 1 8 4 29491 12
23777 88528 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 771 14th St   Sidewalk: Curb side : Cutout Tree Private 2   07/21/2008 12:00:00 AM   3x3 Permit Number 51478 6003493 2107743 37.7676581652647 -122.431199833454 (37.7676581652647, -122.431199833454) 15 9 5 28862 3
23904 88195 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 443 Tehama St   Sidewalk: Curb side : Cutout Tree Private 2   07/08/2008 12:00:00 AM   3x3 Permit Number 51199 6011062 2112189 37.7802918756168 -122.405332612017 (37.7802918756168, -122.405332612017) 14 2 9 28853 34
24253 86716 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 396 Capp St   Sidewalk: Curb side : Cutout Tree Private 2   09/25/2007 12:00:00 AM     Permit Number 49702 6007196 2105003 37.7603439142388 -122.418197308773 (37.7603439142388, -122.418197308773) 2 4 7 28859 19
24700 88426 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 73 Commonwealth Ave   Sidewalk: Curb side : Cutout Tree Private 2   07/10/2008 12:00:00 AM   3x3 Permit Number 51392 5996480.7 2114051.6 37.7845800539807 -122.455910464712 (37.7845800539807, -122.455910464712) 11 6 1 54 31
24836 96563 Permitted Site 7 Crataegus phaenopyrum :: Washington Hawthorn 102 567 Moultrie St   Sidewalk: Curb side : Cutout Tree Private 2   05/31/2011 12:00:00 AM     Permit Number 767781 6007698 2096716 37.7376179219065 -122.415874290579 (37.7376179219065, -122.415874290579) 2 7 7 28859 2
24866 255162 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 598 Moultrie St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/16/2018 12:00:00 AM 3 3x3 Permit Number 779511 6007652.9891 2096583.60222 37.7372518561065 -122.416020541778 (37.7372518561065, -122.416020541778) 2 7 7 28859 2
25147 87468 Permitted Site 7 Olea europaea :: Olive Tree 9 147 Laidley St   Sidewalk: Curb side : Cutout Tree Private 2   05/12/2008 12:00:00 AM   3x3 Permit Number 50383 6003836 2097532 37.7396405954937 -122.429285233348 (37.7396405954937, -122.429285233348) 2 7 5 63 7
25619 86833 Permitted Site 7 Maytenus boaria :: Mayten 58 2845 Lake St   Sidewalk: Curb side : Cutout Tree Private 2   10/16/2007 12:00:00 AM   3x3 Permit Number 49778 5986671 2114422 37.7850291673476 -122.489875504221 (37.7850291673476, -122.489875504221) 11 6 1 55 33
25834 93215 Permitted Site 7 Ficus nitida :: Laurel Fig 53 499 Jackson St   Sidewalk: Curb side : Cutout Tree Private 2   02/25/2010 12:00:00 AM   3x3 Permit Number 53209 6011715 2118034 37.7963773511427 -122.403484907832 (37.7963773511427, -122.403484907832) 3 1 10 28860 4
25928 96470 Permitted Site 7 Magnolia grandiflora :: Southern Magnolia 19 2001 Market St   Sidewalk: Curb side : Cutout Tree Private 2 DPW 05/20/2011 12:00:00 AM     Permit Number 767173 6004662.9 2108069.9 37.7686219813575 -122.427176582427 (37.7686219813575, -122.427176582427) 8 4 5 28862 3
26035 88576 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7 565 18th Ave   Sidewalk: Curb side : Cutout Tree Private 2   07/21/2008 12:00:00 AM   3x3 Permit Number 51516 5990288 2111527.4 37.7772919335186 -122.477150362969 (37.7772919335186, -122.477150362969) 11 6 2 55 26
26127 96724 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 1357 Alabama St   Sidewalk: Curb side : Cutout Tree Private 2   07/06/2011 12:00:00 AM     Permit Number 767997 6009298 2101259 37.7501818243182 -122.410663037771 (37.7501818243182, -122.410663037771) 2 4 7 28859 19
26253 92760 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 528 Carter St   Front Yard : Yard Tree Private 2   10/09/2009 12:00:00 AM     Permit Number 52985 6005271.9 2086340.9 37.708993467942 -122.423525081608 (37.708993467942, -122.423525081608) 9 7 8 309 5
26545 88331 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 635 Madrid St   Sidewalk: Curb side : Cutout Tree Private 2   07/10/2008 12:00:00 AM   3x3 Permit Number 51319 6002224 2090226 37.7194885890815 -122.434336629443 (37.7194885890815, -122.434336629443) 9 7 6 28861 5
26633 88961 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 583 Shotwell St   Sidewalk: Curb side : Cutout Tree Private 2   09/21/2008 12:00:00 AM   3x3 Permit Number 51727 6008031.3 2104525.5 37.7590797904057 -122.415274584034 (37.7590797904057, -122.415274584034) 2 4 7 28859 19
26731 88124 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 266 Lexington St   Sidewalk: Curb side : Cutout Tree Private 2   07/02/2008 12:00:00 AM   3x3 Permit Number 51128 6006494 2104554 37.7590715260193 -122.42059333056 (37.7590715260193, -122.42059333056) 2 4 7 28859 19
26808 89205 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 662 25th Ave   Sidewalk: Curb side : Cutout Tree Private 2   10/08/2008 12:00:00 AM   3x3 Permit Number 51833 5988199 2111465.2 37.7769997309607 -122.48437223608 (37.7769997309607, -122.48437223608) 11 6 2 55 26
27253 108790 Permitted Site 7 Olea europaea :: Olive Tree 9 964 Avalon Ave   Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/06/2015 12:00:00 AM 3 3x3 Permit Number 774648 6005260.71538 2092108.77889 37.7248301904685 -122.423973622591 (37.7248301904685, -122.423973622591) 9 7 6 309 5
27312 88136 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 321 Los Palmos Dr   Sidewalk: Curb side : Cutout Tree Private 2   07/03/2008 12:00:00 AM   3x3 Permit Number 51162 5997690 2096237 37.7357349780848 -122.450442028597 (37.7357349780848, -122.450442028597) 9 7 4 59 40
27350 87261 Permitted Site 7 Brahea aramata :: Mexican Blue Palm 377 2360 Pacific Ave   Sidewalk: Curb side : Cutout Tree Private 2   03/12/2009 12:00:00 AM   3x3 Permit Number 52082 6002863.7 2117183.6 37.7935440023778 -122.434051428216 (37.7935440023778, -122.434051428216) 13 9 1 29490 27
27377 87782 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 169 Otsego Ave   Sidewalk: Curb side : Cutout Tree Private 2   05/30/2008 12:00:00 AM   3x3 Permit Number 50519 6000633.2 2092299.5 37.7250915243466 -122.439984025014 (37.7250915243466, -122.439984025014) 9 7 6 28861 25
27569 86819 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1010 Capitol Ave   Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 49755 5995086.4 2090661.6 37.7202769199461 -122.45904005327 (37.7202769199461, -122.45904005327) 9 8 6 28861 24
27726 254276 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 102 Bache St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/30/2018 12:00:00 AM 3 3x3 Permit Number 778482 6007158.62699 2095375.94585 37.7339080899914 -122.417644212443 (37.7339080899914, -122.417644212443) 2 7 7 28859 2
28017 86702 Permitted Site 7 Azara microphylla :: Little-Leaf Azara 312 306 Mullen Ave   Sidewalk: Curb side : Cutout Tree Private 2   09/20/2007 12:00:00 AM     Permit Number 49696 6010582.9 2099803.7 37.7462578450491 -122.40611723741 (37.7462578450491, -122.40611723741) 2 7 7 28859 2
28106 87131 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 20 De Montfort Ave   Sidewalk: Curb side : Cutout Tree Private 2   01/11/2008 12:00:00 AM   3x3 Permit Number 50083 5995245.2 2091924 37.7237522965749 -122.458582475556 (37.7237522965749, -122.458582475556) 9 8 4 28861 24
28128 86714 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 858 Duncan St   Sidewalk: Curb side : Cutout Tree Private 2   09/25/2007 12:00:00 AM     Permit Number 49701 6001009 2099689 37.745402758221 -122.439214324332 (37.745402758221, -122.439214324332) 2 4 5 63 22
28459 88318 Permitted Site 7 Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 607 France Ave   Sidewalk: Curb side : Cutout Tree Private 2   07/10/2008 12:00:00 AM   3x3 Permit Number 51309 6002519.4 2089575.2 37.7177183994753 -122.433269062939 (37.7177183994753, -122.433269062939) 9 7 6 28861 5
28498 106346 Permitted Site 7 Tree(s) :: 17 4020 19th St   Sidewalk: Curb side : Cutout Tree Private 2   04/18/2014 12:00:00 AM     Permit Number 772952 6002864.7 2104850 37.7596790634802 -122.433166310425 (37.7596790634802, -122.433166310425) 2 4 5 28862 3
28606 104299 Permitted Site 7 Tree(s) :: 17 4021 20TH ST   Sidewalk: Curb side : Cutout Tree Private 2       2x4   6003557 2104154 37.7578072610358 -122.430722322319 (37.7578072610358, -122.430722322319) 2 4 5 28862 3
29317 92765 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 528 Carter St   Front Yard : Yard Tree Private 2   10/09/2009 12:00:00 AM     Permit Number 52985 6005271.9 2086340.9 37.708993467942 -122.423525081608 (37.708993467942, -122.423525081608) 9 7 8 309 5
29518 88278 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 103 Aptos Ave   Sidewalk: Curb side : Cutout Tree Private 2   07/09/2008 12:00:00 AM   3x3 Permit Number 51270 5993062 2093861.6 37.7289467548913 -122.466270114229 (37.7289467548913, -122.466270114229) 9 8 4 59 40
29687 88259 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1460 Clayton St   Sidewalk: Curb side : Cutout Tree Private 2   07/08/2008 12:00:00 AM   3x3 Permit Number 51244 5999422 2104472 37.758445274906 -122.445045681381 (37.758445274906, -122.445045681381) 2 5 5 28862 3
29701 88320 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 645 France Ave   Sidewalk: Curb side : Cutout Tree Private 2   07/10/2008 12:00:00 AM   3x3 Permit Number 51311 6002646.5 2089495.7 37.7175073196157 -122.432824059512 (37.7175073196157, -122.432824059512) 9 7 6 28861 5
29775 107940 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 960 Harrison St   Sidewalk: Curb side : Cutout Tree Private 2   11/06/2014 12:00:00 AM 3   Permit Number 768645 6011630.15925 2111363.93441 37.7780581861375 -122.403309017255 (37.7780581861375, -122.403309017255) 14 2 9 28856 34
29838 258507 Permitted Site 7 Cordyline australis :: Dracena Palm 64 1929 48th Ave   Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/24/2019 12:00:00 AM 3 3x3 Permit Number 784311 5981324.28824 2101940.12469 37.7504439167515 -122.507446677579 (37.7504439167515, -122.507446677579) 1 8 3 29491 35
29897 86721 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1 South Park   Sidewalk: Curb side : Cutout Tree Private 2   09/25/2007 12:00:00 AM     Permit Number 49703 6014686.1 2112756.9 37.7820531563646 -122.392834816441 (37.7820531563646, -122.392834816441) 6 2 9 28856 6
30656 256908 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 751 25th Ave   : Tree Private 2 FUF 01/04/2019 12:00:00 AM 3 3x3 Permit Number 782750 5988160.57678 2110864.58172 37.7753483638678 -122.484461088261 (37.7753483638678, -122.484461088261) 11 6 2 55 26
30726 108878 Permitted Site 7 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 275 Staples Ave   Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/08/2015 12:00:00 AM 3 3x3 Permit Number 773301 5998271.57935 2093779.45417 37.7290204086136 -122.44825438236 (37.7290204086136, -122.44825438236) 9 7 4 28861 40
31000 104827 Permitted Site 7 :: 45 4366 26th St   : Cutout Tree Private 2       3X3   6001535.3 2100615.2 37.7479758185871 -122.437460780102 (37.7479758185871, -122.437460780102) 2 4 5 28862 22
31241 88116 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 4316 Kirkham St   Sidewalk: Curb side : Cutout Tree Private 2   07/01/2008 12:00:00 AM   3x3 Permit Number 51117 5981501 2104897 37.7585730656231 -122.507054926421 (37.7585730656231, -122.507054926421) 1 8 3 56 35
31299 97252 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 4391 26th St   Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 768116 6001406.8 2100528.2 37.7477296308595 -122.43789889633 (37.7477296308595, -122.43789889633) 2 4 5 63 22
31593 89364 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 2690 Ocean Ave   Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 51942 5990665.5 2095192.3 37.7324619562673 -122.474651985861 (37.7324619562673, -122.474651985861) 1 8 4 64 40
31625 96850 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1401 Kearny St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/29/2011 12:00:00 AM   3x3 Permit Number 767592 6010966.7 2119733.6 37.8010022141869 -122.406194001625 (37.8010022141869, -122.406194001625) 3 1 10 308 23
31876 88495 Permitted Site 7 Lagunaria patersonii :: Primrose Tree 6 27 Reddy St   Sidewalk: Curb side : Cutout Tree Private 2   07/18/2008 12:00:00 AM   3x3 Permit Number 51437 6013659 2094063 37.7306666521666 -122.395078350002 (37.7306666521666, -122.395078350002) 10 3 8 58 1
31884 255500 Permitted Site 7 Podocarpus gracilor :: Fern Pine 51 463 Arlington St   : Tree Private 2 FUF 06/01/2018 12:00:00 AM 3   Permit Number 779226 6003846.45772 2095958.75203 37.7353214068723 -122.429136928426 (37.7353214068723, -122.429136928426) 2 7 5 63 7
31923 254756 Permitted Site 7 Eriobotrya deflexa 'Coppertone' :: Coppertone Loquat 249 3044 Ulloa St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/26/2018 12:00:00 AM 3 3x3 Permit Number 778626 5986607.78234 2098260.29291 37.7406498995894 -122.488905737407 (37.7406498995894, -122.488905737407) 1 8 3 29491 35
31944 94585 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2725 Greenwich St   Sidewalk: Curb side : Cutout Tree Private 2   09/29/2010 12:00:00 AM   3x3 Permit Number 53761 5999865 2118793 37.7977923490456 -122.444542858 (37.7977923490456, -122.444542858) 13 9 1 57 17
32071 86715 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 868 Duncan St   Sidewalk: Curb side : Cutout Tree Private 2   09/25/2007 12:00:00 AM     Permit Number 49700 6001011.7 2099706.8 37.7454517864355 -122.439206263756 (37.7454517864355, -122.439206263756) 2 4 5 63 22
32144 108740 Permitted Site 7 Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 114 Coleridge St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/05/2015 12:00:00 AM 3 3x3   6006642.81745 2099018.83265 37.7438816075689 -122.419685912101 (37.7438816075689, -122.419685912101) 2 7 7 28859 2
32162 107809 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 174 14TH ST   Sidewalk: Curb side : Cutout Tree Private 2   12/22/2014 12:00:00 AM 3 3x3 Permit Number 773719 6007550.6 2107982.4 37.7685446055333 -122.417182034417 (37.7685446055333, -122.417182034417) 8 4 7 28853 19
32821 88995 Permitted Site 7 Tree(s) :: 17 5 Rico Way   Sidewalk: Curb side : Cutout Tree Private 2   09/24/2008 12:00:00 AM   3x3 Permit Number 51744 6001709 2121299 37.8047782094669 -122.438341747927 (37.8047782094669, -122.438341747927) 13 9 1 57 17
33052 91050 Permitted Site 7 Tree(s) :: 17 567 Texas St   Sidewalk: Curb side : Cutout Tree Private 2   12/10/2008 12:00:00 AM   4x4 Permit Number 51962 6013849 2104463 37.7592334263593 -122.395149687391 (37.7592334263593, -122.395149687391) 10 3 8 28856 29
33149 108817 Permitted Site 7 Elaeocarpus decipiens :: Japanese Blueberry Tree 321 70 Naples St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/06/2015 12:00:00 AM 3 3x3 Permit Number 774653 6004639.46555 2093127.26363 37.7275916310609 -122.426193686908 (37.7275916310609, -122.426193686908) 9 7 6 28861 5
33271 92232 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 654 Minnesota St   Sidewalk: Curb side : Cutout Tree Private 2   12/10/2007 12:00:00 AM   3x3 Permit Number 49975 6015152 2105524 37.7622190790018 -122.390717392856 (37.7622190790018, -122.390717392856) 10 3 8 28856 29
33508 92764 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 528 Carter St   Front Yard : Yard Tree Private 2   10/09/2009 12:00:00 AM     Permit Number 52985 6005271.9 2086340.9 37.708993467942 -122.423525081608 (37.708993467942, -122.423525081608) 9 7 8 309 5
33510 97172 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 1360 Mission St   Sidewalk: Curb side : Cutout Tree Private 2           6008094.3658 2110608.12589 37.7757848058124 -122.415487107901 (37.7757848058124, -122.415487107901) 8 2 9 28853 34
34153 94576 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 3775 21st St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/20/2010 12:00:00 AM   3x3 Permit Number 53754 6003162 2103575 37.7561950785204 -122.432047050117 (37.7561950785204, -122.432047050117) 2 4 5 28862 22
34561 87199 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 71 Mansfield St   Front Yard : Yard Tree Private 2   01/31/2008 12:00:00 AM   3x3 Permit Number 50216 6005338 2091826 37.7240581044071 -122.423686361989 (37.7240581044071, -122.423686361989) 9 7 6 309 5
34643 88348 Permitted Site 7 Magnolia grandiflora 'Russet' :: Russet Magnolia 248 100 Vienna St   Sidewalk: Curb side : Cutout Tree Private 2   07/10/2008 12:00:00 AM   3x3 Permit Number 51332 6004690.8 2092754.8 37.7265718296959 -122.425989720183 (37.7265718296959, -122.425989720183) 9 7 6 28861 5
34983 93555 Permitted Site 7 Tree(s) :: 17 290 Green St   Sidewalk: Curb side : Cutout Tree Private 2   03/11/2010 12:00:00 AM   3x3 Permit Number 53175 6011548 2119416 37.8001626595724 -122.404160079164 (37.8001626595724, -122.404160079164) 3 1 10 308 23
35153 92026 Permitted Site 7 Tree(s) :: 17 450 Somerset St   Sidewalk: Curb side : Cutout Tree Private 2   06/04/2009 12:00:00 AM   3x3 Permit Number 52171 6010071 2092425 37.7259688694367 -122.407367242494 (37.7259688694367, -122.407367242494) 10 3 7 309 28
35267 256901 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 2051 34th Ave   Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/31/2018 12:00:00 AM 3 3x3 Permit Number 782737 5985693.46852 2101265.2111 37.7488471905551 -122.492288254945 (37.7488471905551, -122.492288254945) 1 8 3 29491 35
35315 88470 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1519 Innes Ave   Sidewalk: Curb side : Cutout Tree Private 2   07/18/2008 12:00:00 AM   3x3 Permit Number 51424 6015916 2096861 37.7384746486807 -122.387470605672 (37.7384746486807, -122.387470605672) 10 3 8 58 1
35329 88365 Permitted Site 7 Ligustrum lucidum :: Glossy Privet 57 10 Lyon St   Sidewalk: Curb side : Cutout Tree Private 2   07/10/2008 12:00:00 AM   3x3 Permit Number 51347 6000409.7 2108931.9 37.7707473776731 -122.44194989411 (37.7707473776731, -122.44194989411) 15 5 11 29492 9
36120 91327 Permitted Site 7 Cercis occidentalis :: Western Redbud 136 59 Mars St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/09/2010 12:00:00 AM   3x3 Permit Number 53986 5999595 2105446 37.7611295104392 -122.44451737368 (37.7611295104392, -122.44451737368) 15 5 5 28862 3
36474 88364 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 2559 33rd Ave   Sidewalk: Curb side : Cutout Tree Private 2   07/10/2008 12:00:00 AM   3x3 Permit Number 51343 5986101.6 2097823.5 37.739421027827 -122.490623769288 (37.739421027827, -122.490623769288) 1 8 3 29491 35
36556 88319 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 631 France Ave   Sidewalk: Curb side : Cutout Tree Private 2   07/10/2008 12:00:00 AM   3x3 Permit Number 51310 6002604.8 2089521.8 37.7175766192591 -122.432970060785 (37.7175766192591, -122.432970060785) 9 7 6 28861 5
36600 254558 Permitted Site 7 Chamaerops humilis :: Mediterranean Fan Palm 310 585 Marina Blvd   Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/27/2018 12:00:00 AM 3 3x3 Permit Number 777528 6000172.72046 2121606.30595 37.8055344885305 -122.44368027529 (37.8055344885305, -122.44368027529) 13 9 1 57 17
37665 87773 Permitted Site 7 Podocarpus gracilor :: Fern Pine 51 91 Mizpah St   Sidewalk: Curb side : Cutout Tree Private 2   05/30/2008 12:00:00 AM   3x3 Permit Number 774823 6001042 2096186 37.7357862214985 -122.43884923338 (37.7357862214985, -122.43884923338) 2 7 5 63 7
37670 106946 Permitted Site 7 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 2710 BAKER ST   Sidewalk: Curb side : Cutout Tree Private 2   07/02/2014 12:00:00 AM 1 3x3   5999632.3 2118174.9 37.7960819303033 -122.44530359746 (37.7960819303033, -122.44530359746) 13 9 1 57 17
37694 86761 Permitted Site 7 Arbutus unedo :: Strawberry Tree 106 500 Brotherhood Way   unknown : Yard Tree Private 2         Permit Number 49739 5992573.4 2087955 37.7127004679185 -122.467529866031 (37.7127004679185, -122.467529866031) 9 8 6 64 24
38044 255484 Permitted Site 7 Geijera parviflora :: Australian Willow 25 2147 Beach St   : Tree Private 2 FUF 05/30/2018 12:00:00 AM 3   Permit Number 781954 5999947.25363 2120887.03087 37.8035466909489 -122.444408807729 (37.8035466909489, -122.444408807729) 13 9 1 57 17
38107 94858 Permitted Site 7 Pyrus calleryana 'New Bradford' :: New Bradford Pear 347 2595 15th Ave   Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/24/2009 12:00:00 AM   3x3 Permit Number 52715 5991705.5 2097813.3 37.7397187667404 -122.471247387159 (37.7397187667404, -122.471247387159) 1 8 4 29491 40
38290 88588 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 843 24th Ave   Sidewalk: Curb side : Cutout Tree Private 2   07/31/2008 12:00:00 AM   3x3 Permit Number 51532 5988473.4 2110243.3 37.7736607084043 -122.483333420147 (37.7736607084043, -122.483333420147) 11 6 2 55 26
38404 258531 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 4341 Kirkham St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/28/2019 12:00:00 AM 3 3x3 Permit Number 782234 5981427.35617 2104849.55351 37.7584384536263 -122.507306095471 (37.7584384536263, -122.507306095471) 1 8 3 56 35
38477 94887 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 1570 Underwood Ave   Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/23/2010 12:00:00 AM   3x3 Permit Number 53953 6014750 2093656.9 37.7296121929682 -122.391278188352 (37.7296121929682, -122.391278188352) 10 3 8 58 1
38498 88312 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 518 Athens St   Sidewalk: Curb side : Cutout Tree Private 2   07/10/2008 12:00:00 AM   3x3 Permit Number 51303 6003514 2090320 37.7198198301278 -122.429884275062 (37.7198198301278, -122.429884275062) 9 7 6 28861 5
38761 86703 Permitted Site 7 Azara microphylla :: Little-Leaf Azara 312 306 Mullen Ave   Sidewalk: Curb side : Cutout Tree Private 2   09/20/2007 12:00:00 AM     Permit Number 49696 6010582.9 2099803.7 37.7462578450491 -122.40611723741 (37.7462578450491, -122.40611723741) 2 7 7 28859 2
38867 105048 Permitted Site 7 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 205 Carl St   Sidewalk: Curb side : Cutout Tree Private 2       3X3 Permit Number 771190 5997152.5 2107007 37.7652759487806 -122.453077573625 (37.7652759487806, -122.453077573625) 15 5 11 29492 12
38873 92763 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 528 Carter St   Front Yard : Yard Tree Private 2   10/09/2009 12:00:00 AM     Permit Number 52985 6005271.9 2086340.9 37.708993467942 -122.423525081608 (37.708993467942, -122.423525081608) 9 7 8 309 5
39053 96460 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 2001 Market St   Sidewalk: Property side : Cutout Tree Private 2   05/20/2011 12:00:00 AM     Permit Number 767173 6004662.9 2108069.9 37.7686219813575 -122.427176582427 (37.7686219813575, -122.427176582427) 8 4 5 28862 3
39159 258206 Permitted Site 7 Cordyline australis :: Dracena Palm 64 1747 43rd Ave   Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/16/2019 12:00:00 AM 3 3x3 Permit Number 783176 5982832.36667 2103232.01834 37.7540798150651 -122.502327315989 (37.7540798150651, -122.502327315989) 1 8 3 56 35
39185 108613 Permitted Site 7 Podocarpus gracilor :: Fern Pine 51 859 Moultrie St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/02/2015 12:00:00 AM 3 3x3 Permit Number 774597 6007577.26936 2095354.40031 37.7338724793659 -122.416195309142 (37.7338724793659, -122.416195309142) 2 7 7 28859 2
39204 108736 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 1351 Minna St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/05/2015 12:00:00 AM 3 3x3   6006994.99302 2107616.27188 37.76750803134 -122.419077863332 (37.76750803134, -122.419077863332) 8 4 7 28853 19
39324 107135 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 38 08th St   Sidewalk: Curb side : Cutout Tree Private 2   07/31/2014 12:00:00 AM   3x3 Permit Number 769156 6008506.93846 2111466.36236 37.7781645006636 -122.414120641632 (37.7781645006636, -122.414120641632) 8 2 9 28853 34
39542 254749 Permitted Site 7 Callistemon viminalis :: Weeping Bottlebrush 60 164 Escolta Way   Sidewalk: Property side : Cutout Tree Private 2 FUF 03/26/2018 12:00:00 AM 3 4x6 Permit Number 781597 5986451.85258 2097316.8045 37.7380502293434 -122.489375519691 (37.7380502293434, -122.489375519691) 1 8 3 29491 35
39566 89234 Permitted Site 7 Tree(s) :: 17 239 08th St   Sidewalk: Curb side : Cutout Tree Private 2   10/09/2008 12:00:00 AM   3x3 Permit Number 51868 6009415.9 2110603.1 37.7758451977468 -122.41091521392 (37.7758451977468, -122.41091521392) 8 2 9 28853 34
39912 88823 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 110 Clayton St   Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 51710 5998275 2110294 37.7743654794888 -122.44943198445 (37.7743654794888, -122.44943198445) 15 5 11 29492 16
40296 89346 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 110 Hoffman Ave   Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 51930 6000570.6 2102426.2 37.75289349552 -122.440926561392 (37.75289349552, -122.440926561392) 2 4 5 28862 22
40470 87788 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 114 Theresa St   Sidewalk: Curb side : Cutout Tree Private 2   05/30/2008 12:00:00 AM   3x3 Permit Number 50526 6002199.1 2093679.9 37.7289708079503 -122.434669544642 (37.7289708079503, -122.434669544642) 9 7 6 28861 25
40777 96459 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 2001 Market St   Sidewalk: Property side : Cutout Tree Private 2   05/20/2011 12:00:00 AM     Permit Number 767173 6004662.9 2108069.9 37.7686219813575 -122.427176582427 (37.7686219813575, -122.427176582427) 8 4 5 28862 3
40860 88235 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 329 Lyon St   Sidewalk: Curb side : Cutout Tree Private 2   07/08/2008 12:00:00 AM   3x3 Permit Number 51224 6000219 2110006 37.7736857166247 -122.44268666247 (37.7736857166247, -122.44268666247) 15 5 11 29492 16
41279 87262 Permitted Site 7 Brahea aramata :: Mexican Blue Palm 377 2360 Pacific Ave   Sidewalk: Curb side : Cutout Tree Private 2   03/12/2009 12:00:00 AM   3x3 Permit Number 52082 6002863.7 2117183.6 37.7935440023778 -122.434051428216 (37.7935440023778, -122.434051428216) 13 9 1 29490 27
42094 107775 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 311 PARNASSUS AVE   Sidewalk: Curb side : Cutout Tree Private 2       3x3   5996666.6 2106591.7 37.7641077820156 -122.454728170136 (37.7641077820156, -122.454728170136) 15 5 11 29492 12
42122 93487 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 643 San Jose Ave   Sidewalk: Curb side : Cutout Tree Private 2   03/05/2010 12:00:00 AM   3x3 Permit Number 53236 6005997.4 2099554.6 37.745316324998 -122.421955670553 (37.745316324998, -122.421955670553) 2 7 5 28859 2
42192 88277 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 103 Aptos Ave   Sidewalk: Curb side : Cutout Tree Private 2   07/09/2008 12:00:00 AM   3x3 Permit Number 51270 5993062 2093861.6 37.7289467548913 -122.466270114229 (37.7289467548913, -122.466270114229) 9 8 4 59 40
42489 88104 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7 1247 46th Ave   Sidewalk: Curb side : Cutout Tree Private 2   06/30/2008 12:00:00 AM   4x10 Permit Number 51108 5981754.7 2106590.8 37.7632386939753 -122.50630313345 (37.7632386939753, -122.50630313345) 1 8 3 56 35
42526 88341 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 51 Prague St   Sidewalk: Curb side : Cutout Tree Private 2   07/10/2008 12:00:00 AM   3x3 Permit Number 51327 6004823 2090807 37.7212310687473 -122.425394157088 (37.7212310687473, -122.425394157088) 9 7 6 28861 5

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