221 rows where Police Districts = 1 and qSpecies_id = 53 sorted by Zip Codes

View and edit SQL

These facets timed out: Police 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)
35016 120999 Undocumented 4 Ficus nitida :: Laurel Fig 53 390 Sutter St 1 Sidewalk: Curb side : Cutout Tree Private 2       4x6   6010815 2115725 37.7899870820688 -122.406436332672 (37.7899870820688, -122.406436332672) 5 1 10 28857 6
46917 122714 Undocumented 4 Ficus nitida :: Laurel Fig 53 855x Kearny St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011188 2117923 37.7960431220576 -122.40530062832 (37.7960431220576, -122.40530062832) 3 1 10 28857 4
48551 18500 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 519X Powell St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 4X4   6010154.14929 2115557.66128 37.7894906186413 -122.408711019419 (37.7894906186413, -122.408711019419) 5 1 10 28857 21
52775 18497 Permitted Site 7 Ficus nitida :: Laurel Fig 53 501 Powell St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 4X4   6010150.58942 2115513.37022 37.7893688066449 -122.408720210327 (37.7893688066449, -122.408720210327) 5 1 10 28857 21
54854 18511 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 626 Powell St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 4x4   6010143.9604039 2115933.8512359 37.7905229751065 -122.408772822924 (37.7905229751065, -122.408772822924) 5 1 10 28857 21
80346 122712 Undocumented 4 Ficus nitida :: Laurel Fig 53 855x Kearny St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011188 2117923 37.7960431220576 -122.40530062832 (37.7960431220576, -122.40530062832) 3 1 10 28857 4
82985 51836 Permitted Site 7 Ficus nitida :: Laurel Fig 53 601 Jackson St 3 Sidewalk: Curb side : Cutout Tree Private 2   07/13/2005 12:00:00 AM     Permit Number 48064 6011231.99946686 2117956.55670314 37.7961377205174 -122.405150744824 (37.7961377205174, -122.405150744824) 3 1 10 28857 4
83480 120997 Undocumented 4 Ficus nitida :: Laurel Fig 53 360 Sutter St 1 Sidewalk: Curb side : Cutout Tree Private 2       4x6   6010836 2115566 37.7895516808253 -122.406352466288 (37.7895516808253, -122.406352466288) 5 1 10 28857 6
95573 106226 Undocumented 4 Ficus nitida :: Laurel Fig 53 350 Sutter St 1 Sidewalk: Curb side : Cutout Tree MTA 3     22 3x5   6010879 2115572 37.7895705607022 -122.406204113006 (37.7895705607022, -122.406204113006) 5 1 10 28857 6
105476 120996 Undocumented 4 Ficus nitida :: Laurel Fig 53 352 SUTTER ST 2 Sidewalk: Curb side : Cutout Tree MTA 3       3x5   6010871.2 2115571.1 37.789567653219 -122.406231036885 (37.789567653219, -122.406231036885) 5 1 10 28857 6
107778 51837 Permitted Site 7 Ficus nitida :: Laurel Fig 53 601 Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/13/2005 12:00:00 AM     Permit Number 48064 6011231.99946686 2117956.55670314 37.7961377205174 -122.405150744824 (37.7961377205174, -122.405150744824) 3 1 10 28857 4
131150 51835 Permitted Site 7 Ficus nitida :: Laurel Fig 53 601 Jackson St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/13/2005 12:00:00 AM     Permit Number 48064 6011231.99946686 2117956.55670314 37.7961377205174 -122.405150744824 (37.7961377205174, -122.405150744824) 3 1 10 28857 4
142924 18508 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 605X Powell St 1 Sidewalk: Curb side : Cutout Tree DPW 1     24 4X4   6010109.02253 2115823.8794949 37.7902190622309 -122.408885944172 (37.7902190622309, -122.408885944172) 5 1 10 28857 21
143936 106224 Undocumented 4 Ficus nitida :: Laurel Fig 53 340 SUTTER ST 1 Sidewalk: Curb side : Cutout Tree MTA 3     24 3x5   6010923.2 2115578.3 37.7895903312377 -122.406051628897 (37.7895903312377, -122.406051628897) 5 1 10 28857 6
146277 18498 Permitted Site 7 Ficus nitida :: Laurel Fig 53 501 Powell St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 4X4   6010152.17541 2115498.44033 37.7893279015823 -122.408713669265 (37.7893279015823, -122.408713669265) 5 1 10 28857 21
151930 18509 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 605X Powell St 2 Sidewalk: Curb side : Cutout Tree DPW 1     24 4X4   6010109.02253 2115823.8794949 37.7902190622309 -122.408885944172 (37.7902190622309, -122.408885944172) 5 1 10 28857 21
159297 106225 Undocumented 4 Ficus nitida :: Laurel Fig 53 340 SUTTER ST 2 Sidewalk: Curb side : Cutout Tree MTA 3     22 3x5   6010923.2 2115578.3 37.7895903312377 -122.406051628897 (37.7895903312377, -122.406051628897) 5 1 10 28857 6
159895 113553 Undocumented 4 Ficus nitida :: Laurel Fig 53 700 TAYLOR ST 3 Sidewalk: Curb side : Cutout Tree Private 2   11/24/2015 12:00:00 AM   3x3   6009263 2115423 37.7890709188275 -122.411784791395 (37.7890709188275, -122.411784791395) 5 1 10 28857 21
159917 122820 Permitted Site 7 Ficus nitida :: Laurel Fig 53 776 Bush St 3 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6009771.51732552 2115777.23613944 37.7900720800575 -122.410050397484 (37.7900720800575, -122.410050397484) 5 1 10 28857 21
166051 18510 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 605X Powell St 3 Sidewalk: Curb side : Cutout Tree DPW 1     18 4X4   6010109.02253 2115823.8794949 37.7902190622309 -122.408885944172 (37.7902190622309, -122.408885944172) 5 1 10 28857 21
176501 104744 Undocumented 4 Ficus nitida :: Laurel Fig 53 15 WAVERLY PL   Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6010745.5 2116998.1 37.7934788206973 -122.406766557506 (37.7934788206973, -122.406766557506) 3 1 10 28857 4
178040 120998 Undocumented 4 Ficus nitida :: Laurel Fig 53 370 Sutter St 1 Sidewalk: Curb side : Cutout Tree Private 2       4x6   6010792 2115565 37.789546473623 -122.406504631878 (37.789546473623, -122.406504631878) 5 1 10 28857 6
186331 122713 Undocumented 4 Ficus nitida :: Laurel Fig 53 855x Kearny St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011188 2117923 37.7960431220576 -122.40530062832 (37.7960431220576, -122.40530062832) 3 1 10 28857 4
188867 121000 Undocumented 4 Ficus nitida :: Laurel Fig 53 390 Sutter St 2 Sidewalk: Curb side : Cutout Tree Private 2       4x6   6010815 2115725 37.7899870820688 -122.406436332672 (37.7899870820688, -122.406436332672) 5 1 10 28857 6
7207 249360 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 601 Leavenworth St 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6008338.71076 2114562.35621 37.7866559051821 -122.41492178511 (37.7866559051821, -122.41492178511) 13 1 9 28858 36
13581 113413 Undocumented 4 Ficus nitida :: Laurel Fig 53 16X LEROY PL 1 Sidewalk: Curb side : Cutout Tree Private 2     7 1x1   6008359 2116497 37.7919691052865 -122.414988572568 (37.7919691052865, -122.414988572568) 5 1 10 28858 21
20147 103506 Undocumented 4 Ficus nitida :: Laurel Fig 53 1348 Sacramento St 2 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   6008356 2116660 37.7924164947138 -122.415010494885 (37.7924164947138, -122.415010494885) 5 1 10 28858 21
21080 11033 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1503 Hyde St 1 Sidewalk: Curb side : Cutout Tree DPW 1     70 3x3   6007448.9758793 2117473.8836265 37.7946002066648 -122.418206559463 (37.7946002066648, -122.418206559463) 5 1 10 28858 32
27435 11036 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1521 Hyde St 1 Sidewalk: Curb side : Cutout Tree DPW 1     70 3x3   6007446.95336 2117561.22726 37.79483991673 -122.41821975317 (37.79483991673, -122.41821975317) 5 1 10 28858 32
28662 99265 Undocumented 4 Ficus nitida :: Laurel Fig 53 1340 Leavenworth St 2 Sidewalk: Curb side : Cutout Tree Private 2           6008042 2117018 37.7933818247157 -122.416122311937 (37.7933818247157, -122.416122311937) 5 1 10 28858 21
28739 11129 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2140 Hyde St 1 Sidewalk: Curb side : Cutout Tree DPW 1     6 2X2   6007198.4118085 2119638.2581616 37.8005289300711 -122.419227150729 (37.8005289300711, -122.419227150729) 5 1 1 28858 32
34974 253521 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2626 Larkin St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/19/2017 12:00:00 AM 3 3x3   6006643 2120264 37.8022157634914 -122.42119356192 (37.8022157634914, -122.42119356192) 5 1 1 28858 32
36964 11109 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2022 Hyde St 2 Sidewalk: Curb side : Cutout Tree DPW 1     22 3X3   6007225.09879 2119363.63368 37.7997763833106 -122.419115312272 (37.7997763833106, -122.419115312272) 5 1 1 28858 32
39764 11100 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1960 Hyde St 1 Sidewalk: Curb side : Cutout Tree DPW 1     70 3X3   6007273.5320198 2119093.4977666 37.7990373853425 -122.418928545127 (37.7990373853425, -122.418928545127) 5 1 10 28858 32
41004 99266 Undocumented 4 Ficus nitida :: Laurel Fig 53 1340 Leavenworth St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008042 2117018 37.7933818247157 -122.416122311937 (37.7933818247157, -122.416122311937) 5 1 10 28858 21
41017 11117 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2054 Hyde St 2 Sidewalk: Curb side : Cutout Tree DPW 1     35 3X3   6007235.1189832 2119374.3616564 37.7998064039059 -122.419081399975 (37.7998064039059, -122.419081399975) 5 1 1 28858 32
45310 11177 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2740 Hyde St 3 Sidewalk: Curb side : Cutout Tree Private 2     36 3X3 Permit Number 769071 6006912.1976315 2121679.9811894 37.8061188596167 -122.420362567782 (37.8061188596167, -122.420362567782) 5 1 1 28858 32
47816 107839 Undocumented 4 Ficus nitida :: Laurel Fig 53 1000x LEAVENWORTH ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008256 2115925 37.790392745036 -122.415304443955 (37.790392745036, -122.415304443955) 5 1 10 28858 21
49389 11091 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1906 Hyde St 1 Sidewalk: Curb side : Cutout Tree Private 2     70 3X3   6007294.23278 2118880.01642 37.7984523847496 -122.418841764779 (37.7984523847496, -122.418841764779) 5 1 10 28858 32
50702 11103 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1995X Hyde St 1 Sidewalk: Curb side : Cutout Tree DPW 1     70 3X3   6007217.8875 2119096.40041 37.7990422218557 -122.419121300277 (37.7990422218557, -122.419121300277) 5 1 10 28858 32
52589 11046 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1560 Hyde St 1 Sidewalk: Curb side : Cutout Tree DPW 1     70 3X3   6007462.42749 2117742.73439 37.7953391611566 -122.418179084924 (37.7953391611566, -122.418179084924) 5 1 10 28858 32
53504 11175 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2740 Hyde St 1 Sidewalk: Curb side : Cutout Tree Private 2     36 3X3 Permit Number 769071 6006912.1976315 2121679.9811894 37.8061188596167 -122.420362567782 (37.8061188596167, -122.420362567782) 5 1 1 28858 32
55261 11108 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2022 Hyde St 1 Sidewalk: Curb side : Cutout Tree DPW 1     70 3X3   6007226.47271 2119353.11491 37.799747578786 -122.419109811467 (37.799747578786, -122.419109811467) 5 1 1 28858 32
56045 108604 Permitted Site 7 Ficus nitida :: Laurel Fig 53 625 LEAVENWORTH ST 1 Sidewalk: Curb side : Cutout Tree Private 2     14 3x3   6008310.7 2114660.6 37.7869240847944 -122.415025652231 (37.7869240847944, -122.415025652231) 13 1 9 28858 36
58920 11130 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2140 Hyde St 2 Sidewalk: Curb side : Cutout Tree DPW 1     6 2X2   6007198.4118085 2119638.2581616 37.8005289300711 -122.419227150729 (37.8005289300711, -122.419227150729) 5 1 1 28858 32
74524 95408 Undocumented 4 Ficus nitida :: Laurel Fig 53 1257 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3 No record of tree being permitted for planting. 6006989.2 2119073.6 37.7989667366731 -122.419911018667 (37.7989667366731, -122.419911018667) 5 1 10 28858 32
77923 256355 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1000 Bay St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW     3x3   6005985 2121074 37.804402699388 -122.423528183462 (37.804402699388, -122.423528183462) 5 1 1 28858 32
102458 99269 Undocumented 4 Ficus nitida :: Laurel Fig 53 1327 Leavenworth St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008010 2116967 37.7932399920042 -122.416229420814 (37.7932399920042, -122.416229420814) 5 1 10 28858 32
108315 251688 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 925 Sutter St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008132 2115128 37.788197407905 -122.415677021756 (37.788197407905, -122.415677021756) 13 1 10 28858 21
109285 11031 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1469 Hyde St 1 Sidewalk: Curb side : Cutout Tree DPW 1     30 3x3   6007466.43149 2117407.25122 37.7944182331434 -122.418141434433 (37.7944182331434, -122.418141434433) 5 1 10 28858 32
111411 253520 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2626 Larkin St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/19/2017 12:00:00 AM 3 3x3   6006643 2120264 37.8022157634914 -122.42119356192 (37.8022157634914, -122.42119356192) 5 1 1 28858 32
119461 11088 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1896 Hyde St 3 Sidewalk: Curb side : Cutout Tree DPW 1     45 4x4   6007314.6733074 2118798.6130291 37.7982300223497 -122.418765257989 (37.7982300223497, -122.418765257989) 5 1 10 28858 32
131827 99267 Undocumented 4 Ficus nitida :: Laurel Fig 53 1340 Leavenworth St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008042 2117018 37.7933818247157 -122.416122311937 (37.7933818247157, -122.416122311937) 5 1 10 28858 21
132857 11053 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1603 Hyde St 1 Sidewalk: Curb side : Cutout Tree DPW 1     70 3X3   6007388.39144 2117874.05515 37.795695567741 -122.418444578472 (37.795695567741, -122.418444578472) 5 1 10 28858 32
134743 107366 Undocumented 4 Ficus nitida :: Laurel Fig 53 851 POST ST 2 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6008079.7 2114773.8 37.7872219209064 -122.415832880524 (37.7872219209064, -122.415832880524) 13 1 9 28858 36
135761 11176 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2740 Hyde St 2 Sidewalk: Curb side : Cutout Tree Private 2     24 3X3 Permit Number 769071 6006912.1976315 2121679.9811894 37.8061188596167 -122.420362567782 (37.8061188596167, -122.420362567782) 5 1 1 28858 32
138743 11090 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1903 Hyde St 1 Sidewalk: Curb side : Cutout Tree DPW 1     26 6x6   6007250.95739 2118862.55474 37.7984020026002 -122.418990272151 (37.7984020026002, -122.418990272151) 5 1 10 28858 32
141238 11085 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1865 Hyde St 1 Sidewalk: Curb side : Cutout Tree DPW 1     60 3X3   6007279.7286506 2118687.2113849 37.7979221737821 -122.418878272086 (37.7979221737821, -122.418878272086) 5 1 10 28858 32
143675 107836 Undocumented 4 Ficus nitida :: Laurel Fig 53 1000x LEAVENWORTH ST 1 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   6008256 2115925 37.790392745036 -122.415304443955 (37.790392745036, -122.415304443955) 5 1 10 28858 21
155310 11113 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2037 Hyde St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 3X3   6007192.03327 2119340.88684 37.7997120641075 -122.41922811701 (37.7997120641075, -122.41922811701) 5 1 1 28858 32
157130 11034 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1509 HYDE ST 1 Sidewalk: Curb side : Cutout Tree Private 2     70 3X3   6007406.1 2117518.3 37.7947197495209 -122.418358066687 (37.7947197495209, -122.418358066687) 5 1 10 28858 32
166466 11087 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1896 Hyde St 2 Sidewalk: Curb side : Cutout Tree DPW 1     70 4x4   6007314.6733074 2118798.6130291 37.7982300223497 -122.418765257989 (37.7982300223497, -122.418765257989) 5 1 10 28858 32
173250 11082 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1849 Hyde St 1 Sidewalk: Curb side : Cutout Tree DPW 1     70 3X3   6007286.9943087 2118635.1241552 37.7977795644032 -122.418849434729 (37.7977795644032, -122.418849434729) 5 1 10 28858 32
175319 11028 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1449 Hyde St 1 Sidewalk: Curb side : Cutout Tree DPW 1     20 3x3   6007474.68946 2117365.61582 37.7943043774737 -122.418109907661 (37.7943043774737, -122.418109907661) 5 1 10 28858 32
182166 11086 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1896 Hyde St 1 Sidewalk: Curb side : Cutout Tree DPW 1     70 3x3   6007314.6733074 2118798.6130291 37.7982300223497 -122.418765257989 (37.7982300223497, -122.418765257989) 5 1 10 28858 32
182487 256357 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1000 Bay St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW     3x3   6005985 2121074 37.804402699388 -122.423528183462 (37.804402699388, -122.423528183462) 5 1 1 28858 32
192030 256356 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1000 Bay St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW     3x3   6005985 2121074 37.804402699388 -122.423528183462 (37.804402699388, -122.423528183462) 5 1 1 28858 32
9205 96542 Permitted Site 7 Ficus nitida :: Laurel Fig 53 100 Pine St 3 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 767720 6013094 2116579 37.7924591936564 -122.398611089295 (37.7924591936564, -122.398611089295) 4 1 10 28860 6
20131 113298 Undocumented 4 Ficus nitida :: Laurel Fig 53 700X DAVIS ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013208 2119104 37.7993985951424 -122.398393892143 (37.7993985951424, -122.398393892143) 3 1 10 28860 6
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
25882 40606 Permitted Site 7 Ficus nitida :: Laurel Fig 53 744 Montgomery St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/18/2005 12:00:00 AM     Permit Number 48110 6011762.49765618 2117875.03517526 37.7959435248288 -122.403309366526 (37.7959435248288, -122.403309366526) 3 1 10 28860 4
31247 106090 Permitted Site 7 Ficus nitida :: Laurel Fig 53 615 Front St 2 Sidewalk: Curb side : Cutout Tree Private 2           6012797.6 2118350.4 37.7973065196251 -122.399761086072 (37.7973065196251, -122.399761086072) 3 1 10 28860 6
55775 44125 Permitted Site 7 Ficus nitida :: Laurel Fig 53 431 Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 43629 6012046.82946857 2118068.4414971 37.796490448112 -122.402339123693 (37.796490448112, -122.402339123693) 3 1 10 28860 4
57914 106105 Permitted Site 7 Ficus nitida :: Laurel Fig 53 744x MONTGOMERY ST 2 Sidewalk: Curb side : Cutout Tree Private 2           6011751.6 2117873.5 37.7959387009634 -122.403346966666 (37.7959387009634, -122.403346966666) 3 1 10 28860 4
68154 113299 Undocumented 4 Ficus nitida :: Laurel Fig 53 700X DAVIS ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013208 2119104 37.7993985951424 -122.398393892143 (37.7993985951424, -122.398393892143) 3 1 10 28860 6
82064 117188 Undocumented 4 Ficus nitida :: Laurel Fig 53 200x GREENWICH ST 2 Sidewalk: Curb side : Cutout Tree Private 2       9x6   6011596 2120619 37.8034684863456 -122.404078688914 (37.8034684863456, -122.404078688914) 3 1 10 28860 6
84659 117187 Undocumented 4 Ficus nitida :: Laurel Fig 53 200x GREENWICH ST 1 Sidewalk: Curb side : Cutout Tree Private 2       9x6   6011596 2120619 37.8034684863456 -122.404078688914 (37.8034684863456, -122.404078688914) 3 1 10 28860 6
96257 4573 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Columbus Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     75 4   6011767.886 2117749.45401 37.7955990100454 -122.403281883117 (37.7955990100454, -122.403281883117) 3 1 10 28860 4
110473 49870 Permitted Site 7 Ficus nitida :: Laurel Fig 53 607@ JACKSON Front St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/23/2003 12:00:00 AM     Permit Number 46636 6012838.36008757 2118235.08187981 37.7969921557212 -122.399611944085 (37.7969921557212, -122.399611944085) 3 1 10 28860 6
118656 96541 Permitted Site 7 Ficus nitida :: Laurel Fig 53 100 Pine St 2 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 767720 6013094 2116579 37.7924591936564 -122.398611089295 (37.7924591936564, -122.398611089295) 4 1 10 28860 6
157239 44224 Permitted Site 7 Ficus nitida :: Laurel Fig 53 150 Pacific Ave 1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 43669 6012974 2118691 37.7982515579635 -122.399174613744 (37.7982515579635, -122.399174613744) 3 1 10 28860 6
182516 44225 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2 Broadway 1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 43670 6013393.18767606 2119056.04835121 37.799277245684 -122.397749707821 (37.799277245684, -122.397749707821) 3 1 10 28860 6
3804 117402 Undocumented 4 Ficus nitida :: Laurel Fig 53 75x BEACH ST 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009846 2122112 37.8074699595292 -122.410240137563 (37.8074699595292, -122.410240137563) 3 1 10 308 23
4699 23132 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 610X Vallejo St 2 Sidewalk: Curb side : Cutout Tree DPW 1   09/29/1999 12:00:00 AM 3 4x4   6010603.58879 2118945.35218 37.798817561298 -122.407394925794 (37.798817561298, -122.407394925794) 3 1 10 308 23
11284 117186 Undocumented 4 Ficus nitida :: Laurel Fig 53 201x GREENWICH ST 3 Sidewalk: Curb side : Cutout Tree Private 2       6x6   6011833 2120374 37.8028090150843 -122.40324129087 (37.8028090150843, -122.40324129087) 3 1 10 308 23
11874 110985 Permitted Site 7 Ficus nitida :: Laurel Fig 53 245x North Point St 4 Sidewalk: Curb side : Cutout Tree Private 2           6009556.06624176 2121873.83782792 37.8067997698403 -122.41122668881 (37.8067997698403, -122.41122668881) 3 1 10 308 23
12765 117400 Undocumented 4 Ficus nitida :: Laurel Fig 53 75x BEACH ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009846 2122112 37.8074699595292 -122.410240137563 (37.8074699595292, -122.410240137563) 3 1 10 308 23
13161 4609 Permitted Site 7 Ficus nitida :: Laurel Fig 53 316 Columbus Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/13/2015 12:00:00 AM 3 3X3 Permit Number 774670 6010771.0363 2118706.95943 37.7981723635161 -122.406798689949 (37.7981723635161, -122.406798689949) 3 1 10 308 23
13713 9943 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 601X Green St 3 Sidewalk: Curb side : Cutout Tree DPW 1     80 6x5   6010129.67767 2119173.05666 37.7994162456962 -122.409050895178 (37.7994162456962, -122.409050895178) 3 1 10 308 4
14581 4695 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 850X Columbus Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     125 4x8   6008940.69941 2120350.97779 37.802583847399 -122.4132485365 (37.802583847399, -122.4132485365) 3 1 10 308 23
18087 4603 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 270 Columbus Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     70 3X3   6010933.33158 2118545.7793 37.7977388815556 -122.406225735505 (37.7977388815556, -122.406225735505) 3 1 10 308 23
18979 110983 Permitted Site 7 Ficus nitida :: Laurel Fig 53 245x North Point St 2 Sidewalk: Curb side : Cutout Tree Private 2           6009556.06624176 2121873.83782792 37.8067997698403 -122.41122668881 (37.8067997698403, -122.41122668881) 3 1 10 308 23
20324 4630 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 427 Columbus Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     25 3X3   6010279.42625 2119026.32466 37.7990217431564 -122.408522353672 (37.7990217431564, -122.408522353672) 3 1 10 308 4
21287 23131 Permitted Site 7 Ficus nitida :: Laurel Fig 53 610X Vallejo St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/29/1999 12:00:00 AM 3 4x4   6010622.64357 2118948.98987 37.7988286159864 -122.407329246317 (37.7988286159864, -122.407329246317) 3 1 10 308 23
23258 4604 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 270 Columbus Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     26 3x3   6010907.72336 2118541.73775 37.7977263519913 -122.406314062528 (37.7977263519913, -122.406314062528) 3 1 10 308 23
26107 21817 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2683 Taylor St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 4X4   6008202.62871 2121958.17011 37.8069553278433 -122.4159165161 (37.8069553278433, -122.4159165161) 5 1 10 308 23
28305 121625 Undocumented 4 Ficus nitida :: Laurel Fig 53 101x Trenton St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010049 2117862 37.7958118850813 -122.409237502382 (37.7958118850813, -122.409237502382) 3 1 10 308 4
28626 100399 Undocumented 4 Ficus nitida :: Laurel Fig 53 900 Montgomery St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/17/2016 12:00:00 AM 3 4x4   6011664 2118384 37.7973355180624 -122.403686018548 (37.7973355180624, -122.403686018548) 3 1 10 308 23
28833 21815 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2653 Taylor St 2 Sidewalk: Curb side : Cutout Tree Private 2     18 4X4   6008264.14138 2121978.44796 37.8070144637358 -122.415705074993 (37.8070144637358, -122.415705074993) 5 1 10 308 23
29680 65045 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1066 Filbert St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/02/2004 12:00:00 AM     Permit Number 45972 6007827.74406772 2119607.84984942 37.8004808586212 -122.417047244449 (37.8004808586212, -122.417047244449) 5 1 1 308 32

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