439 rows where qSpecies_id = 148 sorted by SiteOrder

View and edit SQL

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)
134491 27307 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 4431 California St 1 Sidewalk: Curb side : Cutout Tree Private 2     45 3X3   5993817.95209 2114090.93355 37.7845348684789 -122.465125457344 (37.7845348684789, -122.465125457344) 11 6 2 54 11
135328 91841 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 861X HARRISON ST 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/07/2007 12:00:00 AM 10 3x3   6012389 2112023 37.7799101808503 -122.400730211489 (37.7799101808503, -122.400730211489) 6 2 9 28856 34
137191 91839 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1351 Harrison St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/07/2007 12:00:00 AM 3 3x3   6009423.082164 2109161.631862 37.7718876659968 -122.410788543549 (37.7718876659968, -122.410788543549) 8 2 9 28853 34
139425 27252 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 620X Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6006737.40655 2112650.78896 37.7813170997428 -122.420326195624 (37.7813170997428, -122.420326195624) 7 9 9 28852 36
139771 28165 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 199X King St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6014965.0656592 2111288.9310025 37.7780379351787 -122.391767040652 (37.7780379351787, -122.391767040652) 6 2 9 28856 20
143359 91820 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 2395x Harrison St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/07/2007 12:00:00 AM 3 3x3   6008850.144084 2104529.130727 37.7591357459563 -122.412442878611 (37.7591357459563, -122.412442878611) 2 4 7 28859 19
144167 13793 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 929 Market St 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/12/2016 06:56:00 AM 3 4X4   6010115.5056 2113327.9166 37.7833661076198 -122.408687358048 (37.7833661076198, -122.408687358048) 14 2 9 28853 34
147700 95179 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1301X Divisadero St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/17/2008 12:00:00 AM 3 3x3   6001253.46052 2112914.04483 37.781729388453 -122.439316796194 (37.781729388453, -122.439316796194) 15 5 11 29490 41
150496 91810 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 2701x Harrison St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/07/2007 12:00:00 AM 3 3x3   6008948.888017 2102724.532648 37.7541862688692 -122.411973846441 (37.7541862688692, -122.411973846441) 2 4 7 28859 19
150783 3258 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 4134 California St 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/20/2000 12:00:00 AM 8 3X3   5994723.99031 2114406.57793 37.7854537467716 -122.46201379337 (37.7854537467716, -122.46201379337) 11 6 1 54 11
152517 23013 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 780 Valencia St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 3X3   6006206.16059 2105091.96533 37.7605324270074 -122.421627026238 (37.7605324270074, -122.421627026238) 2 4 5 28859 19
152930 91827 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1941 Harrison St 1 Sidewalk: Curb side : Cutout Tree MTA 3   03/07/2007 12:00:00 AM 3 3x3   6008705.970676 2107189.131 37.7664314036014 -122.413129591178 (37.7664314036014, -122.413129591178) 8 4 7 28853 19
152934 91825 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 2147 Harrison St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/07/2007 12:00:00 AM 3 3x3   6008764.72509 2105924.073265 37.7629611450186 -122.412836921531 (37.7629611450186, -122.412836921531) 8 4 7 28859 19
153132 3074 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 2889 California St 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/10/2005 12:00:00 AM 3 3X3   6000557.1809667 2115144.6462063 37.7878143969754 -122.441885735464 (37.7878143969754, -122.441885735464) 13 6 1 29490 27
155330 14031 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1244 Market St 1 Sidewalk: Curb side : Cutout Tree DPW 1   10/28/2005 12:00:00 AM 3 4x4   6008141.7716697 2111544.9362715 37.7783597285455 -122.415389454094 (37.7783597285455, -122.415389454094) 7 2 9 28852 36
156969 27499 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 3478X California St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 3X3   5997784.225 2114880.84142 37.786931659649 -122.451460562094 (37.786931659649, -122.451460562094) 11 6 1 54 31
157553 91836 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1617 Harrison St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/07/2007 12:00:00 AM 3 3x3   6008750.352862 2108461.38548 37.7699272102311 -122.413066048552 (37.7699272102311, -122.413066048552) 8 2 9 28853 19
158393 91842 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 855 HARRISON ST 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/07/2007 12:00:00 AM 10 3x3   6012443 2111954 37.7797237344479 -122.400538552021 (37.7797237344479, -122.400538552021) 6 2 9 28856 34
158568 91781 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1100X Harrison St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/07/2007 12:00:00 AM 3 3x3   6010733 2110469 37.7755507567936 -122.40634955501 (37.7755507567936, -122.40634955501) 8 2 9 28853 34
159509 109761 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 899 VALENCIA ST 1 Sidewalk: Curb side : Cutout Tree Private 2   12/01/2015 12:00:00 AM 1 3x3 Permit Number 772584 6006382.7 2104441.4 37.7587560793788 -122.420970264824 (37.7587560793788, -122.420970264824) 2 4 7 28859 19
161688 5205 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 781 Divisadero St 1 Sidewalk: Curb side : Cutout Tree Private 2 DPW 10/28/2015 07:08:00 AM 3 4X4   6001514.7755792 2111067.8471612 37.7766750639305 -122.438280468838 (37.7766750639305, -122.438280468838) 15 5 11 29492 10
162970 14117 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1572X Market St 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/19/2015 12:52:00 PM 3 4x4   6006735.3160639 2110201.3257307 37.7745913473524 -122.420159536302 (37.7745913473524, -122.420159536302) 7 2 11 28852 10
164777 91822 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 2345 Harrison St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/07/2007 12:00:00 AM 3 3x3   6008829.344656 2104857.328808 37.7600357358129 -122.412538013148 (37.7600357358129, -122.412538013148) 2 4 7 28859 19
165481 91792 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 880 Harrison St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/07/2007 12:00:00 AM 3 3x3   6012180.114989 2111851.485898 37.7794275900263 -122.401440784868 (37.7794275900263, -122.401440784868) 6 2 9 28856 34
165559 18884 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 2324 Sacramento St 1 Sidewalk: Curb side : Cutout Tree DPW 1   04/01/1991 12:00:00 AM 6 3X3   6003670.20137 2115963.1333 37.7902386497824 -122.43117371613 (37.7902386497824, -122.43117371613) 13 9 1 29490 27
166295 102121 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1090X Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/27/2012 12:00:00 AM 5 3x3 Permit Number 769743 6003794.9 2101928.3 37.7517094896741 -122.429740821201 (37.7517094896741, -122.429740821201) 2 4 5 28862 22
166547 91852 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 699X Harrison St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/07/2007 12:00:00 AM 3 3x3   6013398.68241 2112960.74002 37.78254126295 -122.397303024799 (37.78254126295, -122.397303024799) 6 2 9 28856 6
168290 5284 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1351 Divisadero St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/21/2016 12:00:00 AM 3 3X4   6001249.4687 2113069.2889 37.7821554219249 -122.439341737157 (37.7821554219249, -122.439341737157) 15 5 11 29490 41
168625 27306 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 4419 California St 1 Sidewalk: Curb side : Cutout Tree DPW 1     25 3X3   5993893.05463 2114093.73932 37.7845469027899 -122.464865833974 (37.7845469027899, -122.464865833974) 11 6 2 54 11
179179 27304 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 4355 California St 1 Sidewalk: Curb side : Cutout Tree DPW 1     65 3X3   5994036.54811 2114137.7225 37.7846759409315 -122.464372593569 (37.7846759409315, -122.464372593569) 11 6 2 54 11
180891 84558 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1111X Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/27/2012 12:00:00 AM 5 4x4 Permit Number 769743 6003828.67431583 2101851.90831311 37.7515016484692 -122.429618577466 (37.7515016484692, -122.429618577466) 2 4 5 28862 22
182507 53296 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 4124 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/28/2008 12:00:00 AM   3x3 Permit Number 50423 6002335.15488349 2102402.29787451 37.7529282071332 -122.434822699235 (37.7529282071332, -122.434822699235) 2 4 5 28862 22
185602 121028 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1101X South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     14 3x3   6007689 2103175 37.7553523831166 -122.416362767289 (37.7553523831166, -122.416362767289) 2 4 7 28859 19
189664 59740 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 4301 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/27/2012 12:00:00 AM     Permit Number 769743 6001257.45272634 2101704.38356178 37.7509506561918 -122.438499588668 (37.7509506561918, -122.438499588668) 2 4 5 28862 22
191319 30169 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 3110 California St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/04/2007 12:00:00 AM 3 3x3   5999423.70663 2115059.74822 37.7875166362976 -122.445801222119 (37.7875166362976, -122.445801222119) 13 6 1 29490 31
192322 104164 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 2000 Ellis St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/21/2013 12:00:00 AM   4x4 Permit Number 768572 6001219.4 2112910.7 37.7817182660666 -122.43943438946 (37.7817182660666, -122.43943438946) 15 5 11 29490 41
31583 91851 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 855 HARRISON ST 10 Sidewalk: Curb side : Cutout Tree Private 2   03/07/2007 12:00:00 AM 6 3x3   6012443 2111954 37.7797237344479 -122.400538552021 (37.7797237344479, -122.400538552021) 6 2 9 28856 34
41853 111371 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 222 Stanyan St 10 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5996693 2111182 37.7767130721687 -122.454968563419 (37.7767130721687, -122.454968563419) 15 6 2 54 16
77788 8375 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1301X Geary Blvd 10 Sidewalk: Curb side : Cutout Tree DPW 1     24 3X3   6005507.71189 2114109.8093 37.7852538400076 -122.424684163392 (37.7852538400076, -122.424684163392) 13 9 11 28858 41
82698 13471 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 101 Market St 10 Sidewalk: Curb side : Cutout Tree DPW 1   01/01/2005 12:00:00 AM 20 4X4   6013989.3283097 2117008.9290081 37.79368951828 -122.395543339024 (37.79368951828, -122.395543339024) 12 2 9 28855 6
89848 28013 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 100 The Embarcadero 10 Sidewalk: Curb side : Cutout Tree Port 6   02/05/2001 12:00:00 AM 6 3X3   6014214.74401 2117682.27501 37.7955509040886 -122.394810554146 (37.7955509040886, -122.394810554146) 4 2 10 28860 6
105963 28174 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 199X King St 10 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6014965.0656592 2111288.9310025 37.7780379351787 -122.391767040652 (37.7780379351787, -122.391767040652) 6 2 9 28856 20
136072 8432 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1655X Geary Blvd 10 Sidewalk: Curb side : Cutout Tree DPW 1   10/22/2015 12:00:00 AM 3 3X3   6003848.7878415 2113876.6611275 37.7845198420807 -122.430406890022 (37.7845198420807, -122.430406890022) 13 9 11 29490 41
137815 27793 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 199X The Embarcadero 10 Median : Cutout Tree Port 6     12     6014015.4653372 2118064.3876984 37.7965890133894 -122.395526881953 (37.7965890133894, -122.395526881953) 3 1 10 28860 6
172485 28054 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1800 The Embarcadero 10 Sidewalk: Curb side : Cutout Tree Port 6   02/05/2001 12:00:00 AM 12 3X3   6008269.10023 2122669.55539 37.808912348093 -122.41573688061 (37.808912348093, -122.41573688061) 3 1 10 308 23
182430 27973 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 300 The Embarcadero 10 Sidewalk: Curb side : Cutout Tree Port 6   02/05/2001 12:00:00 AM 12 4X4   6013890.7555668 2118454.3638402 37.7976528582722 -122.395985750709 (37.7976528582722, -122.395985750709) 3 1 10 28860 6
185588 28157 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 100X King St 10 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6015580.6531721 2111966.262542 37.7799318892041 -122.38968480475 (37.7799318892041, -122.38968480475) 6 2 9 28856 20
190865 13588 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 525 Market St 10 Sidewalk: Curb side : Cutout Tree DPW 1     30 4X4   6012787.5365724 2115865.9219292 37.7904841708264 -122.399621379879 (37.7904841708264, -122.399621379879) 12 2 9 28855 6
20337 28014 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 100 The Embarcadero 11 Sidewalk: Curb side : Cutout Tree Port 6   02/05/2001 12:00:00 AM 6 3X3   6014226.68001 2117656.23301 37.7954800625202 -122.394767428538 (37.7954800625202, -122.394767428538) 4 2 10 28860 6
36837 117955 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 855 HARRISON ST 11 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6012443 2111954 37.7797237344479 -122.400538552021 (37.7797237344479, -122.400538552021) 6 2 9 28856 34
45913 28158 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 100X King St 11 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6015580.6531721 2111966.262542 37.7799318892041 -122.38968480475 (37.7799318892041, -122.38968480475) 6 2 9 28856 20
46380 111372 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 222 Stanyan St 11 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5996693 2111182 37.7767130721687 -122.454968563419 (37.7767130721687, -122.454968563419) 15 6 2 54 16
118943 27974 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 300 The Embarcadero 11 Sidewalk: Curb side : Cutout Tree Port 6   02/05/2001 12:00:00 AM 12 4X4   6013890.7555668 2118454.3638402 37.7976528582722 -122.395985750709 (37.7976528582722, -122.395985750709) 3 1 10 28860 6
135463 28055 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1800 The Embarcadero 11 Sidewalk: Curb side : Cutout Tree Port 6   02/05/2001 12:00:00 AM 12 3X3   6008269.10023 2122669.55539 37.808912348093 -122.41573688061 (37.808912348093, -122.41573688061) 3 1 10 308 23
139441 28175 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 199X King St 11 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6014965.0656592 2111288.9310025 37.7780379351787 -122.391767040652 (37.7780379351787, -122.391767040652) 6 2 9 28856 20
186329 27794 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 199X The Embarcadero 11 Median : Cutout Tree Port 6     12     6014015.4653372 2118064.3876984 37.7965890133894 -122.395526881953 (37.7965890133894, -122.395526881953) 3 1 10 28860 6
29819 27975 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 300 The Embarcadero 12 Sidewalk: Curb side : Cutout Tree Port 6   02/05/2001 12:00:00 AM 12 4X4   6013890.7555668 2118454.3638402 37.7976528582722 -122.395985750709 (37.7976528582722, -122.395985750709) 3 1 10 28860 6
98837 111373 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 222 Stanyan St 12 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5996693 2111182 37.7767130721687 -122.454968563419 (37.7767130721687, -122.454968563419) 15 6 2 54 16
114306 28159 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 100X King St 12 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6015580.6531721 2111966.262542 37.7799318892041 -122.38968480475 (37.7799318892041, -122.38968480475) 6 2 9 28856 20
125080 28176 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 199X King St 12 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6014965.0656592 2111288.9310025 37.7780379351787 -122.391767040652 (37.7780379351787, -122.391767040652) 6 2 9 28856 20
188165 28015 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 100 The Embarcadero 12 Sidewalk: Curb side : Cutout Tree Port 6   02/05/2001 12:00:00 AM 6 3X3   6014236.44501 2117630.19201 37.7954091029766 -122.39473181516 (37.7954091029766, -122.39473181516) 4 2 10 28860 6
27210 111374 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 222 Stanyan St 13 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5996693 2111182 37.7767130721687 -122.454968563419 (37.7767130721687, -122.454968563419) 15 6 2 54 16
42673 28160 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 100X King St 13 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6015580.6531721 2111966.262542 37.7799318892041 -122.38968480475 (37.7799318892041, -122.38968480475) 6 2 9 28856 20
65056 28016 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 100 The Embarcadero 13 Sidewalk: Curb side : Cutout Tree Port 6   02/05/2001 12:00:00 AM 6 3X3   6014245.12601 2117603.06501 37.7953351012525 -122.394699876607 (37.7953351012525, -122.394699876607) 4 2 10 28860 6
91931 13591 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 525 Market St 13 Sidewalk: Curb side : Cutout Tree DPW 1   02/15/2004 12:00:00 AM 8 4X4   6012787.5365724 2115865.9219292 37.7904841708264 -122.399621379879 (37.7904841708264, -122.399621379879) 12 2 9 28855 6
154189 27976 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 300 The Embarcadero 13 Sidewalk: Curb side : Cutout Tree Port 6   02/05/2001 12:00:00 AM 12 4X4   6013890.7555668 2118454.3638402 37.7976528582722 -122.395985750709 (37.7976528582722, -122.395985750709) 3 1 10 28860 6
185510 28177 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 199X King St 13 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6014965.0656592 2111288.9310025 37.7780379351787 -122.391767040652 (37.7780379351787, -122.391767040652) 6 2 9 28856 20
60140 28161 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 100X King St 14 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6015580.6531721 2111966.262542 37.7799318892041 -122.38968480475 (37.7799318892041, -122.38968480475) 6 2 9 28856 20
65902 28017 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 100 The Embarcadero 14 Sidewalk: Curb side : Cutout Tree Port 6   02/05/2001 12:00:00 AM 6 3X3   6014258.14701 2117577.02301 37.7952643199629 -122.394652996927 (37.7952643199629, -122.394652996927) 4 2 10 28860 6
130760 27977 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 300 The Embarcadero 14 Sidewalk: Curb side : Cutout Tree Port 6   02/05/2001 12:00:00 AM 12 4X4   6013890.7555668 2118454.3638402 37.7976528582722 -122.395985750709 (37.7976528582722, -122.395985750709) 3 1 10 28860 6
186043 111375 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 222 Stanyan St 14 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5996693 2111182 37.7767130721687 -122.454968563419 (37.7767130721687, -122.454968563419) 15 6 2 54 16
188561 28178 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 199X King St 14 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6014965.0656592 2111288.9310025 37.7780379351787 -122.391767040652 (37.7780379351787, -122.391767040652) 6 2 9 28856 20
55898 111376 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 222 Stanyan St 15 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5996693 2111182 37.7767130721687 -122.454968563419 (37.7767130721687, -122.454968563419) 15 6 2 54 16
106049 28162 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 100X King St 15 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6015580.6531721 2111966.262542 37.7799318892041 -122.38968480475 (37.7799318892041, -122.38968480475) 6 2 9 28856 20
137227 28179 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 199X King St 15 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6014965.0656592 2111288.9310025 37.7780379351787 -122.391767040652 (37.7780379351787, -122.391767040652) 6 2 9 28856 20
150361 27978 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 300 The Embarcadero 15 Sidewalk: Curb side : Cutout Tree Port 6   02/05/2001 12:00:00 AM 12 4X4   6013890.7555668 2118454.3638402 37.7976528582722 -122.395985750709 (37.7976528582722, -122.395985750709) 3 1 10 28860 6
153960 28018 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 100 The Embarcadero 15 Sidewalk: Curb side : Cutout Tree Port 6   02/05/2001 12:00:00 AM 6 3X3   6014268.99801 2117554.23701 37.7952023582244 -122.394613854051 (37.7952023582244, -122.394613854051) 4 2 10 28860 6
39391 28180 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 199X King St 16 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6014965.0656592 2111288.9310025 37.7780379351787 -122.391767040652 (37.7780379351787, -122.391767040652) 6 2 9 28856 20
55995 28163 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 100X King St 16 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6015580.6531721 2111966.262542 37.7799318892041 -122.38968480475 (37.7799318892041, -122.38968480475) 6 2 9 28856 20
113760 28019 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 100 The Embarcadero 16 Sidewalk: Curb side : Cutout Tree Port 6   02/05/2001 12:00:00 AM 6 3X3   6014278.76301 2117533.62001 37.7951462916621 -122.394578620953 (37.7951462916621, -122.394578620953) 4 2 10 28860 6
114312 111377 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 222 Stanyan St 16 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5996693 2111182 37.7767130721687 -122.454968563419 (37.7767130721687, -122.454968563419) 15 6 2 54 16
125130 27979 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 300 The Embarcadero 16 Sidewalk: Curb side : Cutout Tree Port 6   02/05/2001 12:00:00 AM 12 4X4   6013890.7555668 2118454.3638402 37.7976528582722 -122.395985750709 (37.7976528582722, -122.395985750709) 3 1 10 28860 6
34463 28181 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 199X King St 17 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6014965.0656592 2111288.9310025 37.7780379351787 -122.391767040652 (37.7780379351787, -122.391767040652) 6 2 9 28856 20
96005 28164 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 100X King St 17 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6015580.6531721 2111966.262542 37.7799318892041 -122.38968480475 (37.7799318892041, -122.38968480475) 6 2 9 28856 20
132807 27980 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 300 The Embarcadero 17 Sidewalk: Curb side : Cutout Tree Port 6   02/05/2001 12:00:00 AM 12 4X4   6013890.7555668 2118454.3638402 37.7976528582722 -122.395985750709 (37.7976528582722, -122.395985750709) 3 1 10 28860 6
148304 28020 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 100 The Embarcadero 17 Sidewalk: Curb side : Cutout Tree Port 6   02/05/2001 12:00:00 AM 6 3X3   6014303.72001 2117502.15301 37.795061278092 -122.394490060779 (37.795061278092, -122.394490060779) 4 2 10 28860 6
110413 27981 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 300 The Embarcadero 18 Sidewalk: Curb side : Cutout Tree Port 6   02/05/2001 12:00:00 AM 12 4X4   6013890.7555668 2118454.3638402 37.7976528582722 -122.395985750709 (37.7976528582722, -122.395985750709) 3 1 10 28860 6
191802 28182 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 199X King St 18 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6014965.0656592 2111288.9310025 37.7780379351787 -122.391767040652 (37.7780379351787, -122.391767040652) 6 2 9 28856 20
117269 27982 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 300 The Embarcadero 19 Sidewalk: Curb side : Cutout Tree Port 6   02/05/2001 12:00:00 AM 12 4X4   6013890.7555668 2118454.3638402 37.7976528582722 -122.395985750709 (37.7976528582722, -122.395985750709) 3 1 10 28860 6
2703 2795 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 6530X California St 2 Sidewalk: Curb side : Cutout Tree Private 2     75 5   5987349.71414 2113973.97564 37.783838627391 -122.487494476151 (37.783838627391, -122.487494476151) 11 6 1 55 33
19838 207 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 2919 19th Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   05/09/1994 12:00:00 AM 20 2X3   5990501.92231 2095794.16798 37.7341050531518 -122.47526143143 (37.7341050531518, -122.47526143143) 1 8 4 64 35
21517 27259 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 690 Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6006717.7455722 2112795.3484565 37.7817129170403 -122.420404476934 (37.7817129170403, -122.420404476934) 7 9 9 28852 36
23271 91828 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1941 Harrison St 2 Sidewalk: Curb side : Cutout Tree MTA 3   03/07/2007 12:00:00 AM 3 3x3   6008705.970676 2107189.131 37.7664314036014 -122.413129591178 (37.7664314036014, -122.413129591178) 8 4 7 28853 19
26556 26652 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 2324 Sacramento St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 3X3   6003670.20137 2115963.1333 37.7902386497824 -122.43117371613 (37.7902386497824, -122.43117371613) 13 9 1 29490 27
28859 91843 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 855 HARRISON ST 2 Sidewalk: Curb side : Cutout Tree Private 2   03/07/2007 12:00:00 AM 9 3x3   6012443 2111954 37.7797237344479 -122.400538552021 (37.7797237344479, -122.400538552021) 6 2 9 28856 34
29927 5259 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1221 Divisadero St 2 Sidewalk: Curb side : Cutout Tree DPW 1     3 2X3   6001282.65173 2112621.17829 37.7809269126295 -122.439194811296 (37.7809269126295, -122.439194811296) 15 5 11 29490 41
32018 14183 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1844 Market St 2 Sidewalk: Curb side : Cutout Tree DPW 1   10/26/2012 12:00:00 AM 12 4X4 Permit Number 769087 6005554.6579568 2109080.5883488 37.7714474783148 -122.424163948162 (37.7714474783148, -122.424163948162) 7 2 5 28852 10
32839 91205 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 90 Gough St 2 Sidewalk: Curb side : Cutout Tree Private 2   02/05/2009 12:00:00 AM   3x3 Permit Number 52043 6006233.7 2109956.2 37.7738900148236 -122.42187731202 (37.7738900148236, -122.42187731202) 7 9 11 28852 10
35496 27675 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 350 McAllister St 2 Sidewalk: Curb side : Cutout Tree DPW 1     20 3X3   6007460.0458899 2112313.2676776 37.780431041784 -122.417802279395 (37.780431041784, -122.417802279395) 7 9 9 28852 36
37390 41431 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 352-360 06th St 2 Sidewalk: Curb side : Cutout Tree DPW 1   03/26/2005 12:00:00 AM     Permit Number 42039 6011197 2111276 37.7777925370097 -122.404801285962 (37.7777925370097, -122.404801285962) 14 2 9 28853 34

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