trees

177 rows where Fire Prevention Districts = 2 and qLegalStatus_id = 2 sorted by SiteOrder

✎ View and edit SQL

This data as json, CSV (advanced)

Fire Prevention 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)
685 151339 Planning Code 138.1 required 2 Jacaranda mimosifolia :: Jacaranda 50 1411 Florida St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/09/2019 12:00:00 AM 3 6x6 Permit Number 781016 6009578.8057 2100900.01209 37.7492118628581 -122.409666655187 (37.7492118628581, -122.409666655187) 2 4 7 28859 19
1519 154406 Planning Code 138.1 required 2 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 1270 Church St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/10/2019 12:00:00 AM 3 4x4 Permit Number 782729 6004450.91353 2101490.17776 37.7505436337949 -122.427441030576 (37.7505436337949, -122.427441030576) 2 4 5 28862 22
1810 253859 Planning Code 138.1 required 2 Prunus spp :: Cherry 68 130 Graystone Ter 1 Front Yard : Yard Tree Private 2       6x6 Permit Number 780749 5998952.88335 2104176.47413 37.7576070480405 -122.446646826709 (37.7576070480405, -122.446646826709) 2 5 5 28862 3
2224 236583 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 607X Florida St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/07/2020 12:00:00 AM 3 4x4 Permit Number 780566 6009282 2105415 37.7615923672124 -122.411011879772 (37.7615923672124, -122.411011879772) 2 4 7 28859 19
2678 157809 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 647 Duncan St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/06/2019 12:00:00 AM 3 3x3 Permit Number 781831 6002443.37703 2099727.28553 37.7455893990301 -122.4342572226 (37.7455893990301, -122.4342572226) 2 7 5 63 22
3850 262121 Planning Code 138.1 required 2 Potential Site :: Potential Site 48 296x Day St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6004047 2098716 37.7429035313116 -122.428640063872 (37.7429035313116, -122.428640063872) 2 7 5 63 22
3990 60261 Planning Code 138.1 required 2 Olea europaea :: Olive Tree 9 2495 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/08/2015 12:00:00 AM 12 3x3 Permit Number 776014 6008888.61229415 2103948.71328851 37.7575442102667 -122.412268813453 (37.7575442102667, -122.412268813453) 2 4 7 28859 19
4773 165865 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 275 Bonview St 1 Sidewalk: Curb side : Cutout Tree Private 2     0 3x4   6006836.83511 2097542.23848 37.7398381374333 -122.418910337746 (37.7398381374333, -122.418910337746) 2 7 7 28859 2
5173 169519 Planning Code 138.1 required 2 Olea europaea :: Olive Tree 9 1753 Noe St 1 Front Yard : Yard Tree Private 2     0 8x8 Permit Number 779099 6003417.91334 2098032.77345 37.7409919262491 -122.430766523865 (37.7409919262491, -122.430766523865) 2 7 5 63 7
5901 260465 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 3933 Mission St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/04/2019 12:00:00 AM 3 3x4 Permit Number 782033 6005003.24747 2095750.87761 37.7348160467336 -122.425122689163 (37.7348160467336, -122.425122689163) 2 7 7 28861 2
6077 230988 Planning Code 138.1 required 2 Magnolia spp :: Magnolia 224 44 Elsie St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/23/2018 12:00:00 AM 3 3x6 Permit Number 778706 6007424.10799 2099038.48568 37.7439795505181 -122.416985775987 (37.7439795505181, -122.416985775987) 2 7 7 28859 2
6487 261445 Planning Code 138.1 required 2 Eriobotrya deflexa :: Bronze Loquat 8 339 Crescent Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007092 2095790 37.7350412423636 -122.417903903871 (37.7350412423636, -122.417903903871) 2 7 7 28859 2
6664 226514 Planning Code 138.1 required 2 Magnolia grandiflora 'Russet' :: Russet Magnolia 248 1225 Dolores St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/07/2019 12:00:00 AM 3 3x3 Permit Number 781565 6005204.64951 2101211.39699 37.7498207677153 -122.424814719741 (37.7498207677153, -122.424814719741) 2 4 5 28859 19
7195 4140 Planning Code 138.1 required 2 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 3620 Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/11/2020 12:00:00 AM 3 3x6 Permit Number 780969 6006062.29639 2100597.35658 37.7481831571401 -122.421805323766 (37.7481831571401, -122.421805323766) 2 4 5 28859 19
7744 225194 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 3160 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3 Permit Number 778605 6007219.63733 2103836.19178 37.7571414587344 -122.418032839538 (37.7571414587344, -122.418032839538) 2 4 7 28859 19
8008 260640 Planning Code 138.1 required 2 Magnolia grandiflora :: Southern Magnolia 19 3936 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/07/2019 12:00:00 AM 3 4x4 Permit Number 776281 6004258 2100777 37.7485745007292 -122.428057323873 (37.7485745007292, -122.428057323873) 2 4 5 28862 22
8190 261370 Planning Code 138.1 required 2 Eriobotrya japonica :: Edible Loquat 119 102 Bache St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007140 2095356 37.7338522748733 -122.417707198486 (37.7338522748733, -122.417707198486) 2 7 7 28859 2
8319 260505 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 760 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/14/2019 12:00:00 AM 3 3x3 Permit Number 784870 6007464 2105234 37.7609932681872 -122.417286789238 (37.7609932681872, -122.417286789238) 2 4 7 28859 19
8601 222646 Planning Code 138.1 required 2 Ceanothus Sps :: California lilac 192 4209 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/06/2018 12:00:00 AM 3 Width 3ft   6001770.77195 2101738.59247 37.7510737715579 -122.436726932715 (37.7510737715579, -122.436726932715) 2 4 5 28862 22
10742 166681 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 563 Alvarado St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/28/2019 12:00:00 AM 3 3x3   6002718.47853 2102666.28528 37.7536748096657 -122.433515959096 (37.7536748096657, -122.433515959096) 2 4 5 28862 22
11040 260952 Planning Code 138.1 required 2 Nyssa sylvatica :: Tupelo: Sour Gum 92 1296 Shotwell St 1 Sidewalk: Curb side : Cutout Tree Private 2       4x8   6008013 2100716 37.7486187391462 -122.4150682294 (37.7486187391462, -122.4150682294) 2 4 7 28859 19
11143 258742 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 367 Liberty St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2019 12:00:00 AM 3 3x3 Permit Number 774042 6003945 2103884 37.7570878795298 -122.429361203627 (37.7570878795298, -122.429361203627) 2 4 5 28862 3
11200 4249 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 4043 Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/05/1995 12:00:00 AM 12 4x4   6003613.964 2100376.48243 37.7474383143284 -122.430255820476 (37.7474383143284, -122.430255820476) 2 4 5 63 22
11330 166753 Planning Code 138.1 required 2 Schinus molle :: California Pepper 91 350 Jersey St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/26/2019 12:00:00 AM 3 4x4 Permit Number 781737 6002856.72425 2101550.76622 37.7506197011549 -122.43295818429 (37.7506197011549, -122.43295818429) 2 4 5 28862 22
11346 261371 Planning Code 138.1 required 2 Syagrus romanzoffianum :: Queen Palm 85 105 Bache St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007217 2095358 37.7338620991787 -122.417441127318 (37.7338620991787, -122.417441127318) 2 7 7 28859 2
11734 243526 Planning Code 138.1 required 2 Cassia leptophylla :: Gold Medallion Tree 152 3443 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 3ft   6007325.13159 2104386.27009 37.7586577840397 -122.417706987288 (37.7586577840397, -122.417706987288) 2 4 7 28859 19
11885 157920 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 4147 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/23/2019 12:00:00 AM 3 3x3 Permit Number 777832 6002961.17206 2100636.31842 37.7481147664022 -122.432531686182 (37.7481147664022, -122.432531686182) 2 4 5 63 22
12003 166317 Planning Code 138.1 required 2 Pistacia chinensis :: Chinese Pistache 32 2600 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/29/2019 12:00:00 AM 3 10x4 Permit Number 779829 6008865.69274 2103234.56357 37.755582030708 -122.412297603862 (37.755582030708, -122.412297603862) 2 4 7 28859 19
12391 221098 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 2815 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/07/2020 12:00:00 AM 3 4x4 Permit Number 780566 6009314.5684 2105431.86525 37.7616405016156 -122.410900429722 (37.7616405016156, -122.410900429722) 2 4 7 28859 19
12677 259879 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 10 Romain St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/01/2019 12:00:00 AM 3 3x3 Permit Number 776294 6001192.18773 2103413.52714 37.7556398401092 -122.438847746407 (37.7556398401092, -122.438847746407) 2 4 5 28862 3
13165 152981 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 3400 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/15/2018 12:00:00 AM 3 4x4 Permit Number 776221 6006333.00148 2102621.91378 37.753757389911 -122.421012959005 (37.753757389911, -122.421012959005) 2 4 5 28859 19
13240 157603 Planning Code 138.1 required 2 Magnolia grandiflora 'D.D. Blanchard' :: D.D. Blanchard Southern Magnolia 221 16 Fountain St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/24/2020 12:00:00 AM 3 5x5 Permit Number 784681 6000322.25182 2101567.57465 37.7505217703771 -122.441723777343 (37.7505217703771, -122.441723777343) 2 4 5 28862 22
13706 225187 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 580 Capp St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3 Permit Number 778605 6007240 2103949 37.7574523501876 -122.417970414127 (37.7574523501876, -122.417970414127) 2 4 7 28859 19
15201 243525 Planning Code 138.1 required 2 Cassia leptophylla :: Gold Medallion Tree 152 3445 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2     0 4x5   6007302.00064 2104384.8851 37.7586526795002 -122.417786886671 (37.7586526795002, -122.417786886671) 2 4 7 28859 19
15356 251313 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 390 28th St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/20/2019 12:00:00 AM 3 4x4 Permit Number 779703 6003369 2099547 37.7451468706327 -122.431043696183 (37.7451468706327, -122.431043696183) 2 7 5 63 22
15413 262220 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 240 Chattanooga St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/08/2020 12:00:00 AM 3 3x3 Permit Number 781435 6004728 2102256 37.7526620712812 -122.426537368454 (37.7526620712812, -122.426537368454) 2 4 5 28862 22
16474 253340 Planning Code 138.1 required 2 Jacaranda mimosifolia :: Jacaranda 50 1045 Church St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/23/2017 12:00:00 AM 3 3x3 Permit Number 780536 6004464 2102825 37.7542094840672 -122.427490860103 (37.7542094840672, -122.427490860103) 2 4 5 28862 22
17339 166211 Planning Code 138.1 required 2 Cercis canadensis :: Eastern Redbud 346 3140 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 3ft   6008730.35876 2101584.0935 37.7510426163255 -122.412648961786 (37.7510426163255, -122.412648961786) 2 4 7 28859 19
17746 262424 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 328 Richland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/28/2020 12:00:00 AM 3 3x3   6006735.98718 2096026.524 37.7356706425738 -122.419151541699 (37.7356706425738, -122.419151541699) 2 7 7 28859 2
18063 259659 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 4061 Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/29/2019 12:00:00 AM 3 3x3 Permit Number 784440 6003514 2100377 37.7474340728524 -122.430601526112 (37.7474340728524, -122.430601526112) 2 4 5 63 22
18657 251312 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1499 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/20/2019 12:00:00 AM 3 4x4 Permit Number 779703 6003369 2099547 37.7451468706327 -122.431043696183 (37.7451468706327, -122.431043696183) 2 7 5 63 22
19030 221366 Planning Code 138.1 required 2 Quercus suber :: Cork Oak 78 55 Homestead St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/30/2019 12:00:00 AM 3 3x3 Permit Number 778991 6000992.93047 2101385.53728 37.7500601303816 -122.439391477336 (37.7500601303816, -122.439391477336) 2 4 5 28862 22
19431 242096 Planning Code 138.1 required 2 Quercus suber :: Cork Oak 78 3721 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/13/2019 12:00:00 AM 3 4x4 Permit Number 769571 6003563.92038 2103590.2718 37.756259789464 -122.430658162741 (37.756259789464, -122.430658162741) 2 4 5 28862 22
20472 124717 Planning Code 138.1 required 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 610 Cortland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/02/2016 12:00:00 AM 3 3x3 Permit Number 775784 6007724.21349 2097196.46477 37.7389386461297 -122.415817669649 (37.7389386461297, -122.415817669649) 2 7 7 28859 2
21868 221950 Planning Code 138.1 required 2 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 31 29th St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 3x3 Permit Number 780973 6006097.6775 2099053.58173 37.7439462971915 -122.421573349947 (37.7439462971915, -122.421573349947) 2 7 7 28859 2
22723 119256 Planning Code 138.1 required 2 Prunus cerasifera :: Cherry Plum 7 195 Brewster St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/19/2016 12:00:00 AM 3 3x3   6010242 2098801 37.7434855758555 -122.407225363197 (37.7434855758555, -122.407225363197) 2 7 7 28859 2
30794 10153 Planning Code 138.1 required 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 978 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1   06/11/2016 06:51:00 AM 3 3x3 Permit Number 780464 6005672.85931 2103292.97405 37.7555627312558 -122.423343584439 (37.7555627312558, -122.423343584439) 2 4 5 28859 19
31022 79408 Planning Code 138.1 required 2 Quercus agrifolia :: Coast Live Oak 172 322 Chattanooga St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/07/2018 12:00:00 AM 3 4x4 Permit Number 776851 6004758.73696772 2101857.84943819 37.7515705801104 -122.426402728229 (37.7515705801104, -122.426402728229) 2 4 5 28862 22
32243 66394 Planning Code 138.1 required 2 Olea europaea :: Olive Tree 9 504 Andover St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/26/2016 12:00:00 AM 3 3x4 Permit Number 772815 6007447.25872729 2096493.62336554 37.7369932248849 -122.41672547553 (37.7369932248849, -122.41672547553) 2 7 7 28859 2
33539 114537 Planning Code 138.1 required 2 Prunus cerasifera :: Cherry Plum 7 1624 Alabama St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/23/2015 12:00:00 AM   3x4   6009248.6 2099914.9 37.7464884538144 -122.41073895467 (37.7464884538144, -122.41073895467) 2 7 7 28859 2
38312 167082 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 280 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/17/2018 12:00:00 AM 3 3x3 Permit Number 780675 6001741.51076 2104267.16046 37.7580149486389 -122.437009129166 (37.7580149486389, -122.437009129166) 2 4 5 28862 3
48832 243143 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 98x Eugenia Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/16/2017 12:00:00 AM 3 3x3   6006195 2098242 37.7417233638646 -122.421179213365 (37.7417233638646, -122.421179213365) 2 7 7 28859 2
51236 243740 Planning Code 138.1 required 2 Podocarpus gracilor :: Fern Pine 51 550 Laidley St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/15/2017 12:00:00 AM 3 3x3 Permit Number 776473 6003047.05577 2096015.80768 37.7354327831918 -122.431904827248 (37.7354327831918, -122.431904827248) 2 7 5 63 7
52242 243372 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1050 Valencia St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/04/2016 12:00:00 AM 3 3x3 Permit Number 778691 6006308.99467 2103436.4955 37.7559926899263 -122.42115381712 (37.7559926899263, -122.42115381712) 2 4 5 28859 19
53742 82615 Planning Code 138.1 required 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2901 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/05/2016 12:00:00 AM 3 3x3 Permit Number 777487 6010040.72394239 2101604.72592715 37.7511727251881 -122.408119020981 (37.7511727251881, -122.408119020981) 2 4 7 28859 19
54415 224728 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 1110 York St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/13/2018 12:00:00 AM 3 3x3 Permit Number 771820 6009984.63313 2102660.33541 37.754068053508 -122.408387439738 (37.754068053508, -122.408387439738) 2 4 7 28859 19
58996 242613 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 48 Winfield St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 3x3 Permit Number 777782 6007306.44134 2099195.30791 37.7444035295914 -122.417403753004 (37.7444035295914, -122.417403753004) 2 7 7 28859 2
63824 120132 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1 Hill St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/04/2016 12:00:00 AM 3 3x3 Permit Number 778691 6006324.60427 2103454.53368 37.7560430985606 -122.421101114609 (37.7560430985606, -122.421101114609) 2 4 5 28859 19
68317 228832 Planning Code 138.1 required 2 Jacaranda mimosifolia :: Jacaranda 50 517 Bartlett St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/06/2018 12:00:00 AM 3 4x4   6006836.21643 2100716.23735 37.7485531903885 -122.419137558645 (37.7485531903885, -122.419137558645) 2 4 7 28859 19
74714 166016 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 3332 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/10/2018 12:00:00 AM 3 3x3 Permit Number 776384 6008453.51061 2099255.43212 37.7446330896597 -122.413441663829 (37.7446330896597, -122.413441663829) 2 7 7 28859 2
76348 258086 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 381 Lexington St 1 Sidewalk: Property side : Cutout Tree Private 2       2x1   6006575 2103913 37.7573160533564 -122.420267699006 (37.7573160533564, -122.420267699006) 2 4 7 28859 19
78698 173775 Planning Code 138.1 required 2 Jacaranda mimosifolia :: Jacaranda 50 1057 Florida St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/26/2018 12:00:00 AM 3 4x4 Permit Number 779347 6009462.91602 2103024.17334 37.7550378411013 -122.410217357343 (37.7550378411013, -122.410217357343) 2 4 7 28859 19
78754 119257 Planning Code 138.1 required 2 Prunus cerasifera :: Cherry Plum 7 191 Brewster St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/19/2016 12:00:00 AM 3 3x3   6010220 2098811 37.743511802413 -122.407302138847 (37.743511802413, -122.407302138847) 2 7 7 28859 2
82843 243896 Planning Code 138.1 required 2 Prunus cerasifera 'Thundercloud' :: Purple-Leaf Plum 'Thundercloud' 421 4225 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/13/2018 12:00:00 AM 3 3x3   6001659.32992 2102313.2065 37.7526451902403 -122.437153446982 (37.7526451902403, -122.437153446982) 2 4 5 28862 22
83711 258012 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 238 Eureka St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/12/2019 12:00:00 AM 3 3x3 Permit Number 781835 6001423.51445 2104434.57022 37.7584565353532 -122.438120885556 (37.7584565353532, -122.438120885556) 2 4 5 28862 3
84485 240578 Planning Code 138.1 required 2 Tree(s) :: 17 3636 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/17/2019 12:00:00 AM 3 4x4 Permit Number 782238 6004112.69332 2103663.95963 37.7564931932291 -122.428765570083 (37.7564931932291, -122.428765570083) 2 4 5 28862 3
84809 167131 Planning Code 138.1 required 2 Magnolia grandiflora :: Southern Magnolia 19 4540 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/20/2018 12:00:00 AM 3 3x3 Permit Number 780648 6000902.50099 2104660.33643 37.7590467894041 -122.439938965707 (37.7590467894041, -122.439938965707) 2 4 5 28862 3
88632 60705 Planning Code 138.1 required 2 Olea europaea :: Olive Tree 9 963 Alabama St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/05/1983 12:00:00 AM 1 3x3 Permit Number 20354 6009178.18020232 2103559.73737881 37.7564924147418 -122.4112398899 (37.7564924147418, -122.4112398899) 2 4 7 28859 19
90355 222216 Planning Code 138.1 required 2 Callistemon citrinus :: Lemon Bottlebrush 67 2 Van Buren St 1 Sidewalk: Curb side : Cutout Tree DPW 1     10 Width 3ft Permit Number 780743 6002014.89564 2096488.79408 37.7366729276156 -122.435507211887 (37.7366729276156, -122.435507211887) 2 7 5 63 7
91584 157471 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 844 Duncan St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/22/2018 12:00:00 AM 3 3x3   6001109 2099712 37.7454716006778 -122.438870189158 (37.7454716006778, -122.438870189158) 2 4 5 63 22
100236 166794 Planning Code 138.1 required 2 Crataegus phaenopyrum :: Washington Hawthorn 102 477 Elizabeth St 1 Sidewalk: Property side : Cutout Tree Private 2   05/30/2019 12:00:00 AM 3 3x3 Permit Number 774858 6003342.48296 2102120.18359 37.7522107277484 -122.431319034046 (37.7522107277484, -122.431319034046) 2 4 5 28862 22
100907 229627 Planning Code 138.1 required 2 Magnolia grandiflora :: Southern Magnolia 19 3662 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2016 12:00:00 AM 3 3x3 Permit Number 778622 6008456.11159 2097816.22885 37.7406815009641 -122.413330912287 (37.7406815009641, -122.413330912287) 2 7 7 28859 2
105542 251314 Planning Code 138.1 required 2 :: 45 1108 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001901 2100825 37.7485726639367 -122.4362112186 (37.7485726639367, -122.4362112186) 2 4 5 28862 22
108115 242845 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 1559 Church St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/18/2018 12:00:00 AM 3 3x3   6004609.7731 2099770.4554 37.7458306574531 -122.426769226215 (37.7458306574531, -122.426769226215) 2 7 5 63 22
110069 116528 Planning Code 138.1 required 2 :: 45 125 CROWN TER 1 Sidewalk: Property side : Cutout Tree Private 2     3 3x3   5998841 2104182 37.7576158290564 -122.447034160915 (37.7576158290564, -122.447034160915) 2 5 5 28862 3
112660 169518 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1783 Noe St 1 Front Yard : Yard Tree Private 2   05/01/2018 12:00:00 AM 3 3x3 Permit Number 780948 6003426.12868 2097901.04069 37.7406306838602 -122.430728719953 (37.7406306838602, -122.430728719953) 2 7 5 63 7
114599 240686 Planning Code 138.1 required 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 2810 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/15/2017 12:00:00 AM 3 3x3 Permit Number 775960 6010325.27315 2101087.17666 37.7497675773096 -122.407098537685 (37.7497675773096, -122.407098537685) 2 4 7 28859 19
115391 224618 Planning Code 138.1 required 2 Ficus microcarpa :: Chinese Banyan 97 165 Sussex St 1 Sidewalk: Curb side : Cutout Tree DPW 1     13 Width 3ft Permit Number 780743 6001936.24436 2096476.10277 37.7366336128599 -122.435778235198 (37.7366336128599, -122.435778235198) 2 7 5 63 7
119230 254617 Planning Code 138.1 required 2 :: 45 685 Florida St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/07/2018 12:00:00 AM 3 3x3 Permit Number 773164 6009303.1948 2105068.09113 37.7606410229668 -122.410914072761 (37.7606410229668, -122.410914072761) 2 4 7 28859 19
120060 221127 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1218 Treat Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/16/2016 12:00:00 AM 1 Width 3ft Permit Number 778419 6008662.3869 2101444.26707 37.750654869142 -122.412874131348 (37.750654869142, -122.412874131348) 2 4 7 28859 19
124453 158406 Planning Code 138.1 required 2 Olea europaea :: Olive Tree 9 50 Conrad St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/25/2017 12:00:00 AM 3 3X3 Permit Number 770857 6001789.37716 2096842.5543 37.7376314601307 -122.436312235543 (37.7376314601307, -122.436312235543) 2 7 5 63 7
125325 256910 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 835 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/07/2019 12:00:00 AM 3 3x3   6007598 2104806 37.7598256170474 -122.416793017555 (37.7598256170474, -122.416793017555) 2 4 7 28859 19
129591 152667 Planning Code 138.1 required 2 Jacaranda mimosifolia :: Jacaranda 50 811 Treat Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/05/2018 12:00:00 AM 3 3x3 Permit Number 777381 6008576.51497 2103684.24515 37.7568005230537 -122.413329473377 (37.7568005230537, -122.413329473377) 2 4 7 28859 19
133371 255306 Planning Code 138.1 required 2 Olea europaea :: Olive Tree 9 1163 Shotwell St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/08/2018 12:00:00 AM 3 3x6 Permit Number 777039 6008085.276 2101160.09095 37.7498421745418 -122.414849724814 (37.7498421745418, -122.414849724814) 2 4 7 28859 19
133424 254076 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 416 28th St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/20/2017 12:00:00 AM 3 3x3   6003139 2099532 37.7450926486102 -122.431837924964 (37.7450926486102, -122.431837924964) 2 7 5 63 22
134654 152810 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 2901 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/18/2017 12:00:00 AM 3 6x6 Permit Number 777487 6009973.24314 2101608.01571 37.7511779795992 -122.408352609887 (37.7511779795992, -122.408352609887) 2 4 7 28859 19
135896 114985 Planning Code 138.1 required 2 Acer buergeranum :: Trident Maple 110 1188 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/29/2015 12:00:00 AM     Permit Number 773128 6003158.9 2101346.9 37.7500770674438 -122.43189868142 (37.7500770674438, -122.43189868142) 2 4 5 28862 22
141915 225774 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 577 Castro St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft Permit Number 782239 6002400.68275 2104833.82508 37.7596083179996 -122.434769956692 (37.7596083179996, -122.434769956692) 2 4 5 28862 3
147582 166259 Planning Code 138.1 required 2 Olea europaea :: Olive Tree 9 2880 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2     0 3x3   6008980.17665 2103937.78959 37.7575193538388 -122.41195137385 (37.7575193538388, -122.41195137385) 2 4 7 28859 19
152110 239088 Planning Code 138.1 required 2 Pyrus calleryana :: Ornamental Pear 44 3855 26th St 1 Sidewalk: Curb side : Cutout Tree DPW 1     13 3x3 Permit Number 780732 6004794.15723 2100737.40071 37.748496089722 -122.426200479689 (37.748496089722, -122.426200479689) 2 4 5 63 22
152203 152615 Planning Code 138.1 required 2 Podocarpus gracilor :: Fern Pine 51 3098 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/23/2019 12:00:00 AM 3 3x3 Permit Number 782654 6009121.70897 2101021.23838 37.7495190982493 -122.411255871462 (37.7495190982493, -122.411255871462) 2 4 7 28859 19
152958 258304 Planning Code 138.1 required 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 2946 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008567 2103911 37.7574226061115 -122.413378415329 (37.7574226061115, -122.413378415329) 2 4 7 28859 19
156678 255580 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 384 28th St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/18/2018 12:00:00 AM 3 3x3 Permit Number 778885 6003411.13256 2099532.22132 37.7451086791398 -122.430896954644 (37.7451086791398, -122.430896954644) 2 7 5 63 22
162044 247938 Planning Code 138.1 required 2 Prunus cerasifera :: Cherry Plum 7 29 Joy St 1 Unaccepted Street : Yard Tree DPW 1     9   Permit Number 775404 6010254.90659 2098918.71089 37.7438095066969 -122.407189031056 (37.7438095066969, -122.407189031056) 2 7 7 28859 2
168129 23050 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1058 Valencia St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/04/2016 12:00:00 AM 3 3x3 Permit Number 778691 6006261.27662 2103419.73409 37.7559439767922 -122.421317651992 (37.7559439767922, -122.421317651992) 2 4 5 28859 19
168205 157655 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 4171 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/07/2018 12:00:00 AM 3 3x3 Permit Number 777107 6002113.71434 2101756.88931 37.7511434941804 -122.435542313334 (37.7511434941804, -122.435542313334) 2 4 5 28862 22
168649 243745 Planning Code 138.1 required 2 Magnolia grandiflora :: Southern Magnolia 19 130 Mateo St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/22/2017 12:00:00 AM 3 3x3 Permit Number 774373 6003834.27428 2096405.12406 37.7365463534355 -122.429210869408 (37.7365463534355, -122.429210869408) 2 7 5 63 7
170182 258184 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 95 Laidley St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003372 2097903 37.74063299685 -122.430916015884 (37.74063299685, -122.430916015884) 2 7 5 63 7
172284 256143 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 4068 Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/17/2018 12:00:00 AM 3 3x3   6003463 2100411 37.7475245395629 -122.430780306583 (37.7475245395629, -122.430780306583) 2 4 5 63 22
176317 256115 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 503 Anderson St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2018 12:00:00 AM 3 3x3 Permit Number 774745 6007867.72621 2096528.91607 37.7371137709195 -122.41527422465 (37.7371137709195, -122.41527422465) 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)
);