trees

78 rows where Neighborhoods (old) = 20 and qLegalStatus_id = 2

✎ View and edit SQL

This data as json, CSV (advanced)

SiteOrder ✖

Neighborhoods (old) ✖

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)
4228 254718 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 900 16th St 3 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 3x4   6013911 2107143 37.7665955668607 -122.39512298129 (37.7665955668607, -122.39512298129) 14 3 8 28856 20
6978 253743 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1 Henry Adams St 9 Sidewalk: Curb side : Cutout Tree Private 2   11/03/2017 12:00:00 AM 3 3x6   6011517 2108140 37.7691996810398 -122.403473604048 (37.7691996810398, -122.403473604048) 8 2 8 28853 20
16206 109465 Planning Code 138.1 required 2 Koelreuteria bipinnata :: Chinese Flame Tree 164 360 Berry St 10 Sidewalk: Curb side : Cutout Tree Private 2     8 4x4 Permit Number 773752 6013321.87847 2109385.26551 37.7727195476045 -122.397317921189 (37.7727195476045, -122.397317921189) 14 2 9 310 20
16815 109466 Planning Code 138.1 required 2 Koelreuteria bipinnata :: Chinese Flame Tree 164 360 Berry St 11 Sidewalk: Curb side : Cutout Tree Private 2   03/15/2017 12:00:00 AM 3 4x4 Permit Number 773752 6013302.89282 2109368.02055 37.7726711397891 -122.397382385507 (37.7726711397891, -122.397382385507) 14 2 9 310 20
24826 198583 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 980 16th St 3 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013760.46871 2107146.56354 37.7665969793027 -122.395643896153 (37.7665969793027, -122.395643896153) 14 3 8 28856 20
26024 203202 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 189 Hubbell St 3 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013039.197 2107156.64294 37.7665845074832 -122.398139372753 (37.7665845074832, -122.398139372753) 14 3 8 28856 20
27368 109463 Planning Code 138.1 required 2 Koelreuteria bipinnata :: Chinese Flame Tree 164 360 Berry St 8 Sidewalk: Curb side : Cutout Tree Private 2   03/15/2017 12:00:00 AM 3 4x4 Permit Number 773752 6013357.96458 2109418.68041 37.7728133064148 -122.397195438039 (37.7728133064148, -122.397195438039) 14 2 9 310 20
31968 253741 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1 Henry Adams St 7 Sidewalk: Curb side : Cutout Tree Private 2   11/03/2017 12:00:00 AM 3 3x6   6011517 2108140 37.7691996810398 -122.403473604048 (37.7691996810398, -122.403473604048) 8 2 8 28853 20
36722 203212 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 189 Hubbell St 13 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013314.65603 2107418.87056 37.7673198651342 -122.397204991541 (37.7673198651342, -122.397204991541) 14 3 8 28856 20
37035 198590 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 980 16th St 10 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013501.44813 2107135.10099 37.766551094089 -122.396539005766 (37.766551094089, -122.396539005766) 14 3 8 28856 20
47139 257910 Planning Code 138.1 required 2 Tree(s) :: 17 199x Townsend St 3 Sidewalk: Curb side : Cutout Tree Private 2   01/18/2019 12:00:00 AM 3 3x3   6014800 2111540 37.778718149686 -122.392355631341 (37.778718149686, -122.392355631341) 6 2 9 28856 20
48111 253753 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 2x Rhode Island St 7 Sidewalk: Curb side : Cutout Tree Private 2   11/03/2017 12:00:00 AM 3 3x6   6011517 2108140 37.7691996810398 -122.403473604048 (37.7691996810398, -122.403473604048) 8 2 8 28853 20
48798 109467 Planning Code 138.1 required 2 Koelreuteria bipinnata :: Chinese Flame Tree 164 360 Berry St 12 Sidewalk: Curb side : Cutout Tree Private 2     6 4x4 Permit Number 773752 6013285.76594 2109350.55221 37.7726222220803 -122.397440404346 (37.7726222220803, -122.397440404346) 14 2 9 310 20
49512 254717 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 900 16th St 2 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 3x4   6013911 2107143 37.7665955668607 -122.39512298129 (37.7665955668607, -122.39512298129) 14 3 8 28856 20
50671 203206 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 189 Hubbell St 7 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013175.33077 2107284.78304 37.7669439332411 -122.397677495329 (37.7669439332411, -122.397677495329) 14 3 8 28856 20
50738 253752 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 2x Rhode Island St 6 Sidewalk: Curb side : Cutout Tree Private 2   11/03/2017 12:00:00 AM 3 3x6   6011517 2108140 37.7691996810398 -122.403473604048 (37.7691996810398, -122.403473604048) 8 2 8 28853 20
51331 199439 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 189 Hubbell St 17 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013405.93741 2107506.73149 37.7675661930534 -122.396895420613 (37.7675661930534, -122.396895420613) 14 3 8 28856 20
55756 198584 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 980 16th St 4 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013716.83628 2107143.63605 37.7665865138841 -122.395794609033 (37.7665865138841, -122.395794609033) 14 3 8 28856 20
57754 203208 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 189 Hubbell St 9 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013261.21102 2107370.66012 37.7671845144907 -122.397386470235 (37.7671845144907, -122.397386470235) 14 3 8 28856 20
58102 203211 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 189 Hubbell St 12 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013299.1332 2107408.33786 37.7672900804932 -122.39725794451 (37.7672900804932, -122.39725794451) 14 3 8 28856 20
59194 198587 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 980 16th St 7 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013654.04555 2107139.63113 37.7665720240075 -122.396011512024 (37.7665720240075, -122.396011512024) 14 3 8 28856 20
61405 253746 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1 Henry Adams St 12 Sidewalk: Curb side : Cutout Tree Private 2   11/03/2017 12:00:00 AM 3 3x6   6011517 2108140 37.7691996810398 -122.403473604048 (37.7691996810398, -122.403473604048) 8 2 8 28853 20
61796 203209 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 189 Hubbell St 10 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013274.22218 2107384.36901 37.7672228804628 -122.397342427714 (37.7672228804628, -122.397342427714) 14 3 8 28856 20
62404 253750 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 2x Rhode Island St 4 Sidewalk: Curb side : Cutout Tree Private 2   11/03/2017 12:00:00 AM 3 3x6   6011517 2108140 37.7691996810398 -122.403473604048 (37.7691996810398, -122.403473604048) 8 2 8 28853 20
64611 203204 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 189 Hubbell St 5 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013138.40782 2107249.76439 37.7668457236901 -122.397802750202 (37.7668457236901, -122.397802750202) 14 3 8 28856 20
67103 253756 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 41x Division St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/03/2017 12:00:00 AM 3 5x5   6011517 2108140 37.7691996810398 -122.403473604048 (37.7691996810398, -122.403473604048) 8 2 8 28853 20
70940 203205 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 189 Hubbell St 6 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013159.72459 2107270.14751 37.7669028782866 -122.397730448328 (37.7669028782866, -122.397730448328) 14 3 8 28856 20
71116 199441 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 189 Hubbell St 19 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013426.97714 2107527.99953 37.7676257614597 -122.39682413764 (37.7676257614597, -122.39682413764) 14 3 8 28856 20
71327 253751 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 2x Rhode Island St 5 Sidewalk: Curb side : Cutout Tree Private 2   11/03/2017 12:00:00 AM 3 3x6   6011517 2108140 37.7691996810398 -122.403473604048 (37.7691996810398, -122.403473604048) 8 2 8 28853 20
72278 198591 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 980 16th St 11 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013476.96853 2107132.95858 37.7665438491392 -122.396623526764 (37.7665438491392, -122.396623526764) 14 3 8 28856 20
73445 253735 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1 Henry Adams St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/03/2017 12:00:00 AM 3 3x6   6011517 2108140 37.7691996810398 -122.403473604048 (37.7691996810398, -122.403473604048) 8 2 8 28853 20
82264 203203 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 189 Hubbell St 4 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013052.87668 2107169.70276 37.7666211287738 -122.398092973126 (37.7666211287738, -122.398092973126) 14 3 8 28856 20
84511 109468 Planning Code 138.1 required 2 Koelreuteria bipinnata :: Chinese Flame Tree 164 360 Berry St 13 Sidewalk: Curb side : Cutout Tree Private 2     7 4x4 Permit Number 773752 6013267.70036 2109332.73182 37.7725722854256 -122.397501645497 (37.7725722854256, -122.397501645497) 14 2 9 310 20
93259 253749 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 2x Rhode Island St 3 Sidewalk: Curb side : Cutout Tree Private 2   11/03/2017 12:00:00 AM 3 3x6   6011517 2108140 37.7691996810398 -122.403473604048 (37.7691996810398, -122.403473604048) 8 2 8 28853 20
93355 199442 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 189 Hubbell St 20 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013442.0065 2107543.23317 37.7676684261738 -122.396773220723 (37.7676684261738, -122.396773220723) 14 3 8 28856 20
111570 254719 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 900 16th St 4 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 3x4   6013911 2107143 37.7665955668607 -122.39512298129 (37.7665955668607, -122.39512298129) 14 3 8 28856 20
114018 254721 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 900 16th St 6 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 3x4   6013911 2107143 37.7665955668607 -122.39512298129 (37.7665955668607, -122.39512298129) 14 3 8 28856 20
114271 203207 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 189 Hubbell St 8 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013251.61126 2107360.27951 37.7671554771575 -122.397418946544 (37.7671554771575, -122.397418946544) 14 3 8 28856 20
114716 198586 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 980 16th St 6 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013678.51918 2107141.48068 37.7665784640576 -122.39592699106 (37.7665784640576, -122.39592699106) 14 3 8 28856 20
115539 109460 Planning Code 138.1 required 2 Koelreuteria bipinnata :: Chinese Flame Tree 164 360 Berry St 5 Sidewalk: Curb side : Cutout Tree Private 2     7 4x4 Permit Number 773752 6013412.32492 2109471.0252 37.7729600595772 -122.397011068921 (37.7729600595772, -122.397011068921) 14 2 9 310 20
116197 253754 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 2x Rhode Island St 8 Sidewalk: Curb side : Cutout Tree Private 2   11/03/2017 12:00:00 AM 3 3x6   6011517 2108140 37.7691996810398 -122.403473604048 (37.7691996810398, -122.403473604048) 8 2 8 28853 20
121031 253742 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1 Henry Adams St 8 Sidewalk: Curb side : Cutout Tree Private 2   11/03/2017 12:00:00 AM 3 3x6   6011517 2108140 37.7691996810398 -122.403473604048 (37.7691996810398, -122.403473604048) 8 2 8 28853 20
121157 257909 Planning Code 138.1 required 2 Tree(s) :: 17 199x Townsend St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/18/2019 12:00:00 AM 3 3x3   6014800 2111540 37.778718149686 -122.392355631341 (37.778718149686, -122.392355631341) 6 2 9 28856 20
123458 253739 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1 Henry Adams St 5 Sidewalk: Curb side : Cutout Tree Private 2   11/03/2017 12:00:00 AM 3 3x6   6011517 2108140 37.7691996810398 -122.403473604048 (37.7691996810398, -122.403473604048) 8 2 8 28853 20
126016 254720 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 900 16th St 5 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 3x4   6013911 2107143 37.7665955668607 -122.39512298129 (37.7665955668607, -122.39512298129) 14 3 8 28856 20
126344 109462 Planning Code 138.1 required 2 Koelreuteria bipinnata :: Chinese Flame Tree 164 360 Berry St 7 Sidewalk: Curb side : Cutout Tree Private 2     10 4x4 Permit Number 773752 6013376.015 2109435.75899 37.7728612052211 -122.3971341969 (37.7728612052211, -122.3971341969) 14 2 9 310 20
127231 109459 Planning Code 138.1 required 2 Koelreuteria bipinnata :: Chinese Flame Tree 164 360 Berry St 4 Sidewalk: Curb side : Cutout Tree Private 2     10 4x4 Permit Number 773752 6013430.92674 2109487.72122 37.7730069385559 -122.396947893341 (37.7730069385559, -122.396947893341) 14 2 9 310 20
131688 198592 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 980 16th St 12 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013452.45897 2107129.35079 37.766532578853 -122.396708048633 (37.766532578853, -122.396708048633) 14 3 8 28856 20
131987 254722 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 900 16th St 7 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 3x4   6013911 2107143 37.7665955668607 -122.39512298129 (37.7665955668607, -122.39512298129) 14 3 8 28856 20
134719 253755 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 41x Division St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/03/2017 12:00:00 AM 3 5x5   6011517 2108140 37.7691996810398 -122.403473604048 (37.7691996810398, -122.403473604048) 8 2 8 28853 20
139534 253737 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1 Henry Adams St 3 Sidewalk: Curb side : Cutout Tree Private 2   11/03/2017 12:00:00 AM 3 3x6   6011517 2108140 37.7691996810398 -122.403473604048 (37.7691996810398, -122.403473604048) 8 2 8 28853 20
139833 198581 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 980 16th St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013801.3988 2107146.90693 37.7666001988537 -122.395502349162 (37.7666001988537, -122.395502349162) 14 3 8 28856 20
142538 253747 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 2x Rhode Island St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/03/2017 12:00:00 AM 3 3x6   6011517 2108140 37.7691996810398 -122.403473604048 (37.7691996810398, -122.403473604048) 8 2 8 28853 20
142606 199438 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 189 Hubbell St 16 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013354.61019 2107458.2254 37.7674301489953 -122.397069554541 (37.7674301489953, -122.397069554541) 14 3 8 28856 20
150292 109461 Planning Code 138.1 required 2 Koelreuteria bipinnata :: Chinese Flame Tree 164 360 Berry St 6 Sidewalk: Curb side : Cutout Tree Private 2     10 4x4 Permit Number 773752 6013397.07251 2109454.07559 37.7729126707161 -122.397062640549 (37.7729126707161, -122.397062640549) 14 2 9 310 20
152102 109458 Planning Code 138.1 required 2 Koelreuteria bipinnata :: Chinese Flame Tree 164 360 Berry St 3 Sidewalk: Curb side : Cutout Tree Private 2     9 4x4 Permit Number 773752 6013450.12112 2109506.07563 37.7730584040491 -122.396882784219 (37.7730584040491, -122.396882784219) 14 2 9 310 20
154592 109464 Planning Code 138.1 required 2 Koelreuteria bipinnata :: Chinese Flame Tree 164 360 Berry St 9 Sidewalk: Curb side : Cutout Tree Private 2     8 4x4 Permit Number 773752 6013338.99753 2109402.36294 37.7727674463814 -122.39725990323 (37.7727674463814, -122.39725990323) 14 2 9 310 20
155834 203210 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 189 Hubbell St 11 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013290.07277 2107397.08786 37.7672586860712 -122.397288494465 (37.7672586860712, -122.397288494465) 14 3 8 28856 20
158870 198585 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 980 16th St 5 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013694.72301 2107142.03178 37.7665808787261 -122.395870983078 (37.7665808787261, -122.395870983078) 14 3 8 28856 20
162006 254723 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 900 16th St 8 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 3x4   6013911 2107143 37.7665955668607 -122.39512298129 (37.7665955668607, -122.39512298129) 14 3 8 28856 20
163114 253748 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 2x Rhode Island St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/03/2017 12:00:00 AM 3 3x6   6011517 2108140 37.7691996810398 -122.403473604048 (37.7691996810398, -122.403473604048) 8 2 8 28853 20
164068 254716 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 900 16th St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 3x4   6013911 2107143 37.7665955668607 -122.39512298129 (37.7665955668607, -122.39512298129) 14 3 8 28856 20
166195 198588 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 980 16th St 8 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013599.81261 2107136.62549 37.766560753709 -122.396198884879 (37.766560753709, -122.396198884879) 14 3 8 28856 20
168906 109469 Planning Code 138.1 required 2 Koelreuteria bipinnata :: Chinese Flame Tree 164 360 Berry St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 4x4 Permit Number 773752 6013484.3589 2109540.27035 37.7731542007368 -122.3967667483 (37.7731542007368, -122.3967667483) 14 2 9 310 20
171909 199437 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 189 Hubbell St 15 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013340.81155 2107445.60575 37.7673947300992 -122.397116397514 (37.7673947300992, -122.397116397514) 14 3 8 28856 20
172837 199440 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 189 Hubbell St 18 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013418.56487 2107519.66805 37.767602416836 -122.396852650636 (37.767602416836, -122.396852650636) 14 3 8 28856 20
173158 253738 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1 Henry Adams St 4 Sidewalk: Curb side : Cutout Tree Private 2   11/03/2017 12:00:00 AM 3 3x6   6011517 2108140 37.7691996810398 -122.403473604048 (37.7691996810398, -122.403473604048) 8 2 8 28853 20
174788 253736 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1 Henry Adams St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/03/2017 12:00:00 AM 3 3x6   6011517 2108140 37.7691996810398 -122.403473604048 (37.7691996810398, -122.403473604048) 8 2 8 28853 20
176004 203201 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 189 Hubbell St 2 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013028.4198 2107143.70013 37.7665483691258 -122.398175741313 (37.7665483691258, -122.398175741313) 14 3 8 28856 20
178080 253744 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1 Henry Adams St 10 Sidewalk: Curb side : Cutout Tree Private 2   11/03/2017 12:00:00 AM 3 3x6   6011517 2108140 37.7691996810398 -122.403473604048 (37.7691996810398, -122.403473604048) 8 2 8 28853 20
181013 199436 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 189 Hubbell St 14 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013326.10031 2107431.53826 37.767355284933 -122.397166295486 (37.767355284933, -122.397166295486) 14 3 8 28856 20
182084 203200 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 189 Hubbell St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013014.64692 2107133.40427 37.7665193318293 -122.398222657156 (37.7665193318293, -122.398222657156) 14 3 8 28856 20
185470 198582 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 980 16th St 2 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013779.59756 2107146.17602 37.7665969792947 -122.395577705173 (37.7665969792947, -122.395577705173) 14 3 8 28856 20
186212 253740 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1 Henry Adams St 6 Sidewalk: Curb side : Cutout Tree Private 2   11/03/2017 12:00:00 AM 3 3x6   6011517 2108140 37.7691996810398 -122.403473604048 (37.7691996810398, -122.403473604048) 8 2 8 28853 20
189573 198589 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 980 16th St 9 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013524.37895 2107133.46335 37.76654787361 -122.396459576758 (37.76654787361, -122.396459576758) 14 3 8 28856 20
193110 109470 Planning Code 138.1 required 2 Koelreuteria bipinnata :: Chinese Flame Tree 164 360 Berry St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 4x4 Permit Number 773752 6013467.61268 2109523.16527 37.7731063019529 -122.396823476633 (37.7731063019529, -122.396823476633) 14 2 9 310 20
193393 257908 Planning Code 138.1 required 2 Tree(s) :: 17 199x Townsend St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/18/2019 12:00:00 AM 3 3x3   6014800 2111540 37.778718149686 -122.392355631341 (37.778718149686, -122.392355631341) 6 2 9 28856 20
193569 253745 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1 Henry Adams St 11 Sidewalk: Curb side : Cutout Tree Private 2   11/03/2017 12:00:00 AM 3 3x6   6011517 2108140 37.7691996810398 -122.403473604048 (37.7691996810398, -122.403473604048) 8 2 8 28853 20

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