trees

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

✎ View and edit SQL

This data as json, CSV (advanced)

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)
122731 100106 Undocumented 4 Ficus nitida :: Laurel Fig 53 461 Jefferson St 4 Sidewalk: Curb side : Cutout Tree Private 2           6007004.8 2122229.7 37.8076334645768 -122.420081138169 (37.8076334645768, -122.420081138169) 5 1 1 308 32
48222 100107 Undocumented 4 Ficus nitida :: Laurel Fig 53 461 Jefferson St 5 Sidewalk: Curb side : Cutout Tree Private 2           6007004.8 2122229.7 37.8076334645768 -122.420081138169 (37.8076334645768, -122.420081138169) 5 1 1 308 32
114077 100108 Undocumented 4 Ficus nitida :: Laurel Fig 53 461 Jefferson St 6 Sidewalk: Curb side : Cutout Tree Private 2           6007004.8 2122229.7 37.8076334645768 -122.420081138169 (37.8076334645768, -122.420081138169) 5 1 1 308 32
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
191099 100527 Undocumented 4 Ficus nitida :: Laurel Fig 53 1728 Jones St 1 Sidewalk: Curb side : Cutout Tree Private 2       4.5x6   6008341 2118363 37.7970916696404 -122.415182998934 (37.7970916696404, -122.415182998934) 5 1 10 308 21
118093 102618 Permitted Site 7 Ficus nitida :: Laurel Fig 53 190X Pfeiffer St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3 Permit Number 18461 6009953.9 2121114.8 37.8047379445266 -122.409796287705 (37.8047379445266, -122.409796287705) 3 1 10 308 23
163667 102619 Permitted Site 7 Ficus nitida :: Laurel Fig 53 190X Pfeiffer St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3 Permit Number 18461 6009953.9 2121114.8 37.8047379445266 -122.409796287705 (37.8047379445266, -122.409796287705) 3 1 10 308 23
142193 102620 Permitted Site 7 Ficus nitida :: Laurel Fig 53 190X Pfeiffer St 4 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3 Permit Number 18461 6009953.9 2121114.8 37.8047379445266 -122.409796287705 (37.8047379445266, -122.409796287705) 3 1 10 308 23
38641 102621 Permitted Site 7 Ficus nitida :: Laurel Fig 53 190X Pfeiffer St 5 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3 Permit Number 18461 6009953.9 2121114.8 37.8047379445266 -122.409796287705 (37.8047379445266, -122.409796287705) 3 1 10 308 23
34305 102625 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1865X Grant Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3 Permit Number 17346 6010349.4 2120908.5 37.804193651889 -122.408413053021 (37.804193651889, -122.408413053021) 3 1 10 308 23
65947 103484 Undocumented 4 Ficus nitida :: Laurel Fig 53 2375X Jones St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 9x6   6007909 2120582.3 37.8031610244278 -122.416835141288 (37.8031610244278, -122.416835141288) 5 1 1 308 32
100883 103485 Undocumented 4 Ficus nitida :: Laurel Fig 53 2375X Jones St 2 Sidewalk: Curb side : Cutout Tree Private 2     24 9x9   6007909 2120582.3 37.8031610244278 -122.416835141288 (37.8031610244278, -122.416835141288) 5 1 1 308 32
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
170611 104729 Undocumented 4 Ficus nitida :: Laurel Fig 53 250-252 FRANCISCO ST   Sidewalk: Curb side : Cutout Tree Private 2     22 5x5   6010061.3 2121325.4 37.805322217951 -122.409439489572 (37.805322217951, -122.409439489572) 3 1 10 308 23
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
179087 105657 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 901X Lombard St 4 Sidewalk: Curb side : Cutout Tree DPW 1 SFUSD         6007813.03508 2120272.88823 37.8023060594642 -122.417145293832 (37.8023060594642, -122.417145293832) 5 1 1 308 32
65259 105658 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 901X Lombard St 5 Sidewalk: Curb side : Cutout Tree DPW 1 SFUSD         6007813.03508 2120272.88823 37.8023060594642 -122.417145293832 (37.8023060594642, -122.417145293832) 5 1 1 308 32
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
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
59611 106127 Undocumented 4 Ficus nitida :: Laurel Fig 53 1609 POWELL ST 2 Sidewalk: Curb side : Cutout Tree Private 2       5x5   6009609.6 2119208.8 37.7994852403002 -122.410853080764 (37.7994852403002, -122.410853080764) 3 1 10 308 4
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
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
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
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
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
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
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
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
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
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
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
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
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
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
74171 110682 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 370 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 6x4   6011146.7308 2119712.42854 37.8009541508763 -122.405569522927 (37.8009541508763, -122.405569522927) 3 1 10 308 23
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
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
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
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
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
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
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
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
88657 110984 Permitted Site 7 Ficus nitida :: Laurel Fig 53 245x North Point St 3 Sidewalk: Curb side : Cutout Tree Private 2           6009556.06624176 2121873.83782792 37.8067997698403 -122.41122668881 (37.8067997698403, -122.41122668881) 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
183563 110986 Permitted Site 7 Ficus nitida :: Laurel Fig 53 245x North Point St 5 Sidewalk: Curb side : Cutout Tree Private 2           6009556.06624176 2121873.83782792 37.8067997698403 -122.41122668881 (37.8067997698403, -122.41122668881) 3 1 10 308 23
53203 110987 Permitted Site 7 Ficus nitida :: Laurel Fig 53 245x North Point St 6 Sidewalk: Curb side : Cutout Tree Private 2           6009556.06624176 2121873.83782792 37.8067997698403 -122.41122668881 (37.8067997698403, -122.41122668881) 3 1 10 308 23
73243 110988 Permitted Site 7 Ficus nitida :: Laurel Fig 53 245x North Point St 7 Sidewalk: Curb side : Cutout Tree Private 2           6009556.06624176 2121873.83782792 37.8067997698403 -122.41122668881 (37.8067997698403, -122.41122668881) 3 1 10 308 23
172294 110990 Permitted Site 7 Ficus nitida :: Laurel Fig 53 245x North Point St 9 Sidewalk: Curb side : Cutout Tree Private 2   05/26/2015 12:00:00 AM 3     6009556.06624176 2121873.83782792 37.8067997698403 -122.41122668881 (37.8067997698403, -122.41122668881) 3 1 10 308 23
126032 110991 Permitted Site 7 Ficus nitida :: Laurel Fig 53 245x North Point St 10 Sidewalk: Curb side : Cutout Tree Private 2           6009556.06624176 2121873.83782792 37.8067997698403 -122.41122668881 (37.8067997698403, -122.41122668881) 3 1 10 308 23
136446 110992 Permitted Site 7 Ficus nitida :: Laurel Fig 53 245x North Point St 11 Sidewalk: Curb side : Cutout Tree Private 2           6009556.06624176 2121873.83782792 37.8067997698403 -122.41122668881 (37.8067997698403, -122.41122668881) 3 1 10 308 23
190730 110993 Permitted Site 7 Ficus nitida :: Laurel Fig 53 245x North Point St 12 Sidewalk: Curb side : Cutout Tree Private 2   05/26/2015 12:00:00 AM 3     6009556.06624176 2121873.83782792 37.8067997698403 -122.41122668881 (37.8067997698403, -122.41122668881) 3 1 10 308 23
35514 110994 Permitted Site 7 Ficus nitida :: Laurel Fig 53 245x North Point St 13 Sidewalk: Curb side : Cutout Tree Private 2           6009556.06624176 2121873.83782792 37.8067997698403 -122.41122668881 (37.8067997698403, -122.41122668881) 3 1 10 308 23
44244 110995 Permitted Site 7 Ficus nitida :: Laurel Fig 53 245x North Point St 14 Sidewalk: Curb side : Cutout Tree Private 2           6009556.06624176 2121873.83782792 37.8067997698403 -122.41122668881 (37.8067997698403, -122.41122668881) 3 1 10 308 23
138984 110996 Permitted Site 7 Ficus nitida :: Laurel Fig 53 245x North Point St 15 Sidewalk: Curb side : Cutout Tree Private 2           6009556.06624176 2121873.83782792 37.8067997698403 -122.41122668881 (37.8067997698403, -122.41122668881) 3 1 10 308 23
171851 110997 Permitted Site 7 Ficus nitida :: Laurel Fig 53 245x North Point St 16 Sidewalk: Curb side : Cutout Tree Private 2           6009556.06624176 2121873.83782792 37.8067997698403 -122.41122668881 (37.8067997698403, -122.41122668881) 3 1 10 308 23
67256 110998 Permitted Site 7 Ficus nitida :: Laurel Fig 53 245x North Point St 17 Sidewalk: Curb side : Cutout Tree Private 2           6009556.06624176 2121873.83782792 37.8067997698403 -122.41122668881 (37.8067997698403, -122.41122668881) 3 1 10 308 23
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
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
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
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
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
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
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
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
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
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
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
145725 112106 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 699x COLUMBUS AVE 1 Sidewalk: Curb side : Cutout Tree DPW 1     10 3x3   6009471 2119722 37.8008865881446 -122.411368963081 (37.8008865881446, -122.411368963081) 3 1 10 308 4
126231 112107 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 699x COLUMBUS AVE 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6009471 2119722 37.8008865881446 -122.411368963081 (37.8008865881446, -122.411368963081) 3 1 10 308 4
184105 112108 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 699x COLUMBUS AVE 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6009471 2119722 37.8008865881446 -122.411368963081 (37.8008865881446, -122.411368963081) 3 1 10 308 4
83502 112109 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 699x COLUMBUS AVE 4 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6009471 2119722 37.8008865881446 -122.411368963081 (37.8008865881446, -122.411368963081) 3 1 10 308 4
37409 112110 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 699x COLUMBUS AVE 5 Sidewalk: Curb side : Cutout Tree DPW 1     24 4x4   6009471 2119722 37.8008865881446 -122.411368963081 (37.8008865881446, -122.411368963081) 3 1 10 308 4
52578 112111 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 699x COLUMBUS AVE 6 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6009471 2119722 37.8008865881446 -122.411368963081 (37.8008865881446, -122.411368963081) 3 1 10 308 4
99464 112750 Undocumented 4 Ficus nitida :: Laurel Fig 53 135X TRENTON ST 4 Sidewalk: Curb side : Cutout Tree Housing Authority 15 Private     3x3   6009947 2118097 37.7964514227226 -122.409607037418 (37.7964514227226, -122.409607037418) 3 1 10 308 4
43430 112751 Undocumented 4 Ficus nitida :: Laurel Fig 53 135X TRENTON ST 5 Sidewalk: Curb side : Cutout Tree Housing Authority 15 Private     3x3   6009947 2118097 37.7964514227226 -122.409607037418 (37.7964514227226, -122.409607037418) 3 1 10 308 4
186524 112825 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 101X COLUMBUS AVE 1 Sidewalk: Curb side : Cutout Tree DPW 1     8 3x3   6011274 2118052 37.7964021326886 -122.405012137355 (37.7964021326886, -122.405012137355) 3 1 10 308 4
148636 112826 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 101X COLUMBUS AVE 2 Sidewalk: Curb side : Cutout Tree DPW 1     8 3x3   6011274 2118052 37.7964021326886 -122.405012137355 (37.7964021326886, -122.405012137355) 3 1 10 308 4
55005 112827 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 101X COLUMBUS AVE 3 Sidewalk: Curb side : Cutout Tree DPW 1     8 3x3   6011274 2118052 37.7964021326886 -122.405012137355 (37.7964021326886, -122.405012137355) 3 1 10 308 4
139551 112828 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 101X COLUMBUS AVE 4 Sidewalk: Curb side : Cutout Tree DPW 1     8 3x3   6011274 2118052 37.7964021326886 -122.405012137355 (37.7964021326886, -122.405012137355) 3 1 10 308 4
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
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
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
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
73387 113573 Undocumented 4 Ficus nitida :: Laurel Fig 53 901 LOMBARD ST 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency     3x3   6007813 2120272 37.8023036186348 -122.417145352251 (37.8023036186348, -122.417145352251) 5 1 10 308 32
177916 113574 Undocumented 4 Ficus nitida :: Laurel Fig 53 901 LOMBARD ST 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency     3x3   6007968 2120121 37.8018977290678 -122.416598272247 (37.8018977290678, -122.416598272247) 5 1 10 308 32
99484 116156 Undocumented 4 Ficus nitida :: Laurel Fig 53 755 SANSOME ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6012110 2118369 37.7973192357085 -122.402141679915 (37.7973192357085, -122.402141679915) 3 1 10 308 4
182781 117184 Undocumented 4 Ficus nitida :: Laurel Fig 53 201x GREENWICH ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011833 2120374 37.8028090150843 -122.40324129087 (37.8028090150843, -122.40324129087) 3 1 10 308 23
52074 117185 Undocumented 4 Ficus nitida :: Laurel Fig 53 201x GREENWICH ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011833 2120374 37.8028090150843 -122.40324129087 (37.8028090150843, -122.40324129087) 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
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
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
158673 117398 Undocumented 4 Ficus nitida :: Laurel Fig 53 75x BEACH ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009846 2122112 37.8074699595292 -122.410240137563 (37.8074699595292, -122.410240137563) 3 1 10 308 23
56447 117399 Undocumented 4 Ficus nitida :: Laurel Fig 53 75x BEACH ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009846 2122112 37.8074699595292 -122.410240137563 (37.8074699595292, -122.410240137563) 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
185775 117401 Undocumented 4 Ficus nitida :: Laurel Fig 53 75x BEACH ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009846 2122112 37.8074699595292 -122.410240137563 (37.8074699595292, -122.410240137563) 3 1 10 308 23
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
150414 117403 Undocumented 4 Ficus nitida :: Laurel Fig 53 75x BEACH ST 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009846 2122112 37.8074699595292 -122.410240137563 (37.8074699595292, -122.410240137563) 3 1 10 308 23
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
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

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