trees

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

✎ 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)
3329 260429 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 580 Capp St 7 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 778605 6007240 2103949 37.7574523501876 -122.417970414127 (37.7574523501876, -122.417970414127) 2 4 7 28859 19
3713 225189 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 580 Capp St 3 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
6489 225192 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 580 Capp St 6 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
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
9271 225190 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 580 Capp St 4 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3 Permit Number 778605 6007240 2103949 37.7574523501876 -122.417970414127 (37.7574523501876, -122.417970414127) 2 4 7 28859 19
11511 225198 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 3160 21st St 5 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3 Permit Number 778605 6007149.23047 2103831.77129 37.7571253581517 -122.418276020715 (37.7571253581517, -122.418276020715) 2 4 7 28859 19
11548 225197 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 3160 21st St 4 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3 Permit Number 778605 6007163.79352 2103832.50742 37.7571281991351 -122.418225708166 (37.7571281991351, -122.418225708166) 2 4 7 28859 19
12438 260430 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 580 Capp St 8 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 778605 6007240 2103949 37.7574523501876 -122.417970414127 (37.7574523501876, -122.417970414127) 2 4 7 28859 19
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
17210 225188 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 580 Capp St 2 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
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
30240 243370 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1 Hill St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/04/2016 12:00:00 AM 3 3x3 Permit Number 778691 6006249.22799 2103449.78821 37.7560258191488 -122.421361454386 (37.7560258191488, -122.421361454386) 2 4 5 28859 19
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
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
124974 243371 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1 Hill St 3 Sidewalk: Curb side : Cutout Tree Private 2   08/04/2016 12:00:00 AM 3 3x3 Permit Number 778691 6006273.47273 2103450.37091 37.7560287860041 -122.42127764924 (37.7560287860041, -122.42127764924) 2 4 5 28859 19
135960 103695 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1X Hill St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/04/2016 12:00:00 AM 3 3x3 Permit Number 778691 6006027.79546 2103458.18152 37.7560363783091 -122.422127839194 (37.7560363783091, -122.422127839194) 2 4 5 28859 19
147853 64697 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1X Hill St 3 Sidewalk: Curb side : Cutout Tree Private 2   08/04/2016 12:00:00 AM 3 3x3 Permit Number 778691 6006319.44787647 2103419.18592492 37.7559457511246 -122.421116437378 (37.7559457511246, -122.421116437378) 2 4 5 28859 19
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
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
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
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
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
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
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
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
10960 166315 Planning Code 138.1 required 2 Pistacia chinensis :: Chinese Pistache 32 2600 Harrison St 3 Sidewalk: Curb side : Cutout Tree Private 2   07/29/2019 12:00:00 AM 3 10x4 Permit Number 779829 6008872.21502 2103120.32489 37.7552687230844 -122.412266973836 (37.7552687230844, -122.412266973836) 2 4 7 28859 19
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
16166 166316 Planning Code 138.1 required 2 Pistacia chinensis :: Chinese Pistache 32 2600 Harrison St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/29/2019 12:00:00 AM 3 10x4 Permit Number 779829 6008870.16891 2103155.64589 37.7553655917605 -122.412276546247 (37.7553655917605, -122.412276546247) 2 4 7 28859 19
18610 259660 Planning Code 138.1 required 2 Pistacia chinensis :: Chinese Pistache 32 2600 Harrison St 5 Sidewalk: Curb side : Cutout Tree Private 2   07/29/2019 12:00:00 AM 3 10x4 Permit Number 779829 6008872.21502 2103120.32489 37.7552687230844 -122.412266973836 (37.7552687230844, -122.412266973836) 2 4 7 28859 19
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
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
1902 261997 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 607X Florida St 3 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
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
3426 231237 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 2000 Bryant St 4 Sidewalk: Curb side : Cutout Tree Private 2   04/07/2020 12:00:00 AM 3 4x4 Permit Number 780566 6009518.21853 2105339.01767 37.7613969805183 -122.410189528218 (37.7613969805183, -122.410189528218) 2 4 7 28859 19
3779 231240 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 2000 Bryant St 7 Sidewalk: Curb side : Cutout Tree Private 2   04/07/2020 12:00:00 AM 3 4x4 Permit Number 780566 6009523.77815 2105243.21899 37.7611342507514 -122.410163536041 (37.7611342507514, -122.410163536041) 2 4 7 28859 19
5042 231235 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 2000 Bryant St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/07/2020 12:00:00 AM 3 4x4 Permit Number 780566 6009517.2839 2105385.27542 37.7615239413898 -122.410196026727 (37.7615239413898, -122.410196026727) 2 4 7 28859 19
7258 262001 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 607X Florida St 7 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
7502 236582 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 607 Florida St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/07/2020 12:00:00 AM 3 4x4 Permit Number 780566 6009292.77734 2105398.52034 37.7615477221736 -122.410973441191 (37.7615477221736, -122.410973441191) 2 4 7 28859 19
8936 261999 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 607X Florida St 5 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
9770 262000 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 607X Florida St 6 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
10030 261998 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 607X Florida St 4 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
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
15138 231239 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 2000 Bryant St 6 Sidewalk: Curb side : Cutout Tree Private 2   04/07/2020 12:00:00 AM 3 4x4 Permit Number 780566 6009523.66683 2105264.06886 37.7611914935157 -122.410165393114 (37.7611914935157, -122.410165393114) 2 4 7 28859 19
18826 262002 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 607X Florida St 8 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
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
34077 256492 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 280 Diamond St 2 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
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
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
27355 239457 Planning Code 138.1 required 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 165 Sussex St 2 Sidewalk: Curb side : Cutout Tree DPW 1   10/11/2017 12:00:00 AM 3 Width 3ft Permit Number 780743 6001959.66963 2096487.1672 37.7366653238346 -122.435698035437 (37.7366653238346, -122.435698035437) 2 7 5 63 7
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
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
159683 239458 Planning Code 138.1 required 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 165 Sussex St 3 Sidewalk: Curb side : Cutout Tree DPW 1   10/11/2017 12:00:00 AM 3 Width 3ft Permit Number 780743 6001977.4736 2096494.97635 37.7366877772239 -122.435637038029 (37.7366877772239, -122.435637038029) 2 7 5 63 7
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
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
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
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
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
8699 262221 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 240 Chattanooga St 2 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
11910 262222 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 240 Chattanooga St 3 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
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
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
182124 166234 Planning Code 138.1 required 2 Tree(s) :: 17 2986 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/25/2018 12:00:00 AM 3 3x3 Permit Number 781629 6008392.95809 2103319.50363 37.7557887182862 -122.413938481678 (37.7557887182862, -122.413938481678) 2 4 7 28859 19
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
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
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
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
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
96451 225775 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 577 Castro St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft Permit Number 782239 6002401.77617 2104846.28665 37.75964259654 -122.43476706624 (37.75964259654, -122.43476706624) 2 4 5 28862 3
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
82212 156914 Planning Code 138.1 required 2 Tree(s) :: 17 2995 Harrison St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/21/2018 12:00:00 AM 3 3x3 Permit Number 782654 6009047.12311 2101072.92433 37.7496568330138 -122.411517443787 (37.7496568330138, -122.411517443787) 2 4 7 28859 19
125934 256878 Planning Code 138.1 required 2 Podocarpus gracilor :: Fern Pine 51 3098 26th St 3 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
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
179256 152616 Planning Code 138.1 required 2 Podocarpus gracilor :: Fern Pine 51 3098 26th St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/23/2019 12:00:00 AM 3 3x3 Permit Number 782654 6009096.56353 2101019.92176 37.7495140728181 -122.411342732484 (37.7495140728181, -122.411342732484) 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
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
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
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

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