395 rows where qSpecies_id = 35 sorted by Supervisor Districts descending

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)
3739 261012 Property Tree 8 Pinus canariensis :: Canary Island Pine 35 170 Otis St 2 Front Yard : Cutout Tree Private 2       3x3   6006561 2108839 37.7708409033816 -122.420665800575 (37.7708409033816, -122.420665800575) 8 2 9 28853 19
18405 261011 Property Tree 8 Pinus canariensis :: Canary Island Pine 35 170 Otis St 1 Front Yard : Cutout Tree Private 2       3x3   6006561 2108839 37.7708409033816 -122.420665800575 (37.7708409033816, -122.420665800575) 8 2 9 28853 19
25362 194422 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 199X Kissling St 1 Sidewalk: Curb side : Yard Tree Private 2     52 Width 5ft   6007901.53326 2109054.57818 37.771508291196 -122.416044121944 (37.771508291196, -122.416044121944) 8 2 9 28853 19
82054 194426 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 132 Kissling St 5 Sidewalk: Curb side : Yard Tree Private 2     19 Width 5ft   6007946.83693 2109121.10943 37.7716935173803 -122.415892125715 (37.7716935173803, -122.415892125715) 8 2 9 28853 19
90902 194427 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 905 Minna St 3 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6008110 2110227 37.7747392032863 -122.415406037323 (37.7747392032863, -122.415406037323) 8 2 9 28853 34
100596 194423 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 132 Kissling St 2 Sidewalk: Curb side : Yard Tree Private 2     17 Width 5ft   6007917.867 2109077.33792 37.771571702413 -122.41598923453 (37.771571702413, -122.41598923453) 8 2 9 28853 19
129835 194424 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 132 Kissling St 3 Sidewalk: Curb side : Yard Tree Private 2     23 Width 5ft   6007931.05098 2109095.29996 37.7716217631679 -122.415944902456 (37.7716217631679, -122.415944902456) 8 2 9 28853 19
133229 194425 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 132 Kissling St 4 Sidewalk: Curb side : Yard Tree Private 2     16 Width 5ft   6007938.01013 2109107.31213 37.771655137004 -122.415921681048 (37.771655137004, -122.415921681048) 8 2 9 28853 19
192931 173637 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1155 Market St 99 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008672 2111900 37.779364436223 -122.4135803097 (37.779364436223, -122.4135803097) 8 2 9 28853 34
9009 258692 Property Tree 8 Pinus canariensis :: Canary Island Pine 35 100x Whitney Young Cir   Sidewalk: Curb side : Cutout Tree SFUSD 4       3x3   6016360 2096059 37.7362970999571 -122.385879567348 (37.7362970999571, -122.385879567348) 10 3 8 58 1
9342 23614 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 910X Vermont St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 30X30PL   6011300.2113585 2104101.3880723 37.7580984495586 -122.403939228694 (37.7580984495586, -122.403939228694) 10 3 8 28856 29
12415 258693 Property Tree 8 Pinus canariensis :: Canary Island Pine 35 100 Whitney Young Cir 11 Sidewalk: Curb side : Cutout Tree SFUSD 4       3x3   6016360 2096059 37.7362970999571 -122.385879567348 (37.7362970999571, -122.385879567348) 10 3 8 58 1
21134 87016 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 35 Whitfield Ct 3 Sidewalk: Curb side : Cutout Tree Private 2   12/05/2007 12:00:00 AM     Permit Number 49947 6017543.1 2094109.3 37.7310090102049 -122.381653502791 (37.7310090102049, -122.381653502791) 10 3 8 58 1
22825 200547 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1400x La Salle Ave 23 Median : Cutout Tree DPW 1     5 Width 0ft   6016201.7309 2095635.0286 37.7351242000527 -122.386397222999 (37.7351242000527, -122.386397222999) 10 3 8 58 1
32593 23612 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 890X Vermont St 1 Sidewalk: Curb side : Cutout Tree Rec/Park 5     12 30X30PL   6011290.8652502 2104244.5269478 37.7584909549369 -122.403981624636 (37.7584909549369, -122.403981624636) 10 3 8 28856 29
33716 178129 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 345 Tocoloma Ave 1 Sidewalk: Property side : Yard Tree Private 2     4 Width 8ft   6012554.38724 2086809.43241 37.7106883309719 -122.398388432799 (37.7106883309719, -122.398388432799) 10 3 8 309 1
42016 87018 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 1200 Oakdale Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   12/05/2007 12:00:00 AM     Permit Number 49948 6017188.8 2093995.7 37.7306775177665 -122.382870487304 (37.7306775177665, -122.382870487304) 10 3 8 58 1
54367 253555 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 27 Ceres St 1 Front Yard : Yard Tree Private 2 FUF         6013919.66127 2093997.42296 37.7305010827376 -122.394172607985 (37.7305010827376, -122.394172607985) 10 3 8 58 1
54454 200536 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1400x La Salle Ave 12 Median : Cutout Tree DPW 1     8 Width 0ft   6016175.6148 2095666.5235 37.7352092330314 -122.38648971191 (37.7352092330314, -122.38648971191) 10 3 8 58 1
54931 200542 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1400x La Salle Ave 18 Median : Cutout Tree DPW 1     7 Width 0ft   6016191.4179 2095647.8311 37.7351587822654 -122.38643377144 (37.7351587822654, -122.38643377144) 10 3 8 58 1
62488 200617 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1400x La Salle Ave 58 Median : Cutout Tree DPW 1     18 Width 0ft   6016444.7184 2095097.4319 37.7336615146436 -122.385519666546 (37.7336615146436, -122.385519666546) 10 3 8 58 1
71060 200527 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1400x La Salle Ave 3 Median : Cutout Tree DPW 1     15 Width 0ft   6016132.8234 2095707.6369 37.7353197532414 -122.386640524716 (37.7353197532414, -122.386640524716) 10 3 8 58 1
71238 200528 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1400x La Salle Ave 4 Median : Cutout Tree DPW 1     19 Width 0ft   6016143.3115 2095696.7293 37.7352903838014 -122.386603502798 (37.7352903838014, -122.386603502798) 10 3 8 58 1
80290 200146 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 6101 03rd St 2 Sidewalk: Curb side : Cutout Tree Private 2     22 Width 0ft   6013586.8559 2091305.2042 37.7230902914135 -122.395134667477 (37.7230902914135, -122.395134667477) 10 3 8 58 1
85596 87013 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 1184 Oakdale Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   12/05/2007 12:00:00 AM     Permit Number 49946 6017813.5 2093492.6 37.7293305991048 -122.380675823117 (37.7293305991048, -122.380675823117) 10 3 8 58 1
86690 200559 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1400x La Salle Ave 35 Median : Cutout Tree DPW 1     13 Width 0ft   6016309.6626 2095501.1365 37.7347625331555 -122.38601473032 (37.7347625331555, -122.38601473032) 10 3 8 58 1
109718 87015 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 35 Whitfield Ct 2 Sidewalk: Curb side : Cutout Tree Private 2   12/05/2007 12:00:00 AM     Permit Number 49947 6017543.1 2094109.3 37.7310090102049 -122.381653502791 (37.7310090102049, -122.381653502791) 10 3 8 58 1
118418 200613 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1400x La Salle Ave 54 Median : Cutout Tree DPW 1     15 Width 0ft   6016431.4971 2095119.9571 37.7337226328106 -122.385566946165 (37.7337226328106, -122.385566946165) 10 3 8 58 1
120683 255712 Undocumented 4 Pinus canariensis :: Canary Island Pine 35 618x Mendell St 6 Front Yard : Yard Tree Private 2       3x3 Permit Number 781846 6016234 2097322 37.7397580688138 -122.386403238688 (37.7397580688138, -122.386403238688) 10 3 8 58 1
122774 200572 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1400x La Salle Ave 42 Median : Cutout Tree DPW 1     18 Width 0ft   6016330.8681 2095450.735 37.7346253143087 -122.385937902813 (37.7346253143087, -122.385937902813) 10 3 8 58 1
131403 200571 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1400x La Salle Ave 41 Median : Cutout Tree DPW 1     17 Width 0ft   6016326.461 2095462.4873 37.7346573398722 -122.385953958726 (37.7346573398722, -122.385953958726) 10 3 8 58 1
136381 200558 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1400x La Salle Ave 34 Median : Cutout Tree DPW 1     8 Width 0ft   6016305.3951 2095506.8264 37.7347779203 -122.386029881179 (37.7347779203, -122.386029881179) 10 3 8 58 1
153030 200615 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1400x La Salle Ave 56 Median : Cutout Tree DPW 1     13 Width 0ft   6016438.8423 2095106.2461 37.7336853915549 -122.385540596193 (37.7336853915549, -122.385540596193) 10 3 8 58 1
158562 200567 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1400x La Salle Ave 39 Median : Cutout Tree DPW 1     5 Width 0ft   6016322.0539 2095480.6054 37.7347068446432 -122.385970458247 (37.7347068446432, -122.385970458247) 10 3 8 58 1
160963 87014 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 35 Whitfield Ct 1 Sidewalk: Curb side : Cutout Tree Private 2   12/05/2007 12:00:00 AM     Permit Number 49947 6017543.1 2094109.3 37.7310090102049 -122.381653502791 (37.7310090102049, -122.381653502791) 10 3 8 58 1
161693 3773 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1098 Carolina St 6 Median : Cutout Tree DPW 1     12 18   6012462.6103665 2102859.9036449 37.754754478768 -122.399831953417 (37.754754478768, -122.399831953417) 10 3 8 28856 29
165176 87017 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 1200 Oakdale Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/05/2007 12:00:00 AM     Permit Number 49948 6017188.8 2093995.7 37.7306775177665 -122.382870487304 (37.7306775177665, -122.382870487304) 10 3 8 58 1
169125 200573 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1400x La Salle Ave 43 Median : Cutout Tree DPW 1     17 Width 0ft   6016335.7649 2095440.4518 37.7345973496971 -122.385920256211 (37.7345973496971, -122.385920256211) 10 3 8 58 1
174672 200529 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1400x La Salle Ave 5 Median : Cutout Tree DPW 1     16 Width 0ft   6016150.0239 2095691.2754 37.7352757800904 -122.386579915171 (37.7352757800904, -122.386579915171) 10 3 8 58 1
178827 200557 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1400x La Salle Ave 33 Median : Cutout Tree DPW 1     17 Width 0ft   6016298.6383 2095516.7839 37.7348048876468 -122.386053935891 (37.7348048876468, -122.386053935891) 10 3 8 58 1
178910 61559 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1096 Carolina St 1 Median : Cutout Tree DPW 1   08/25/1984 12:00:00 AM 16   Permit Number 21519 6012461.11053783 2102868.78681941 37.7547787864142 -122.399837764002 (37.7547787864142, -122.399837764002) 10 3 8 28856 29
179540 200526 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1400x La Salle Ave 2 Median : Cutout Tree DPW 1     20 Width 0ft   6016126.5305 2095710.5736 37.7353274684402 -122.386662486514 (37.7353274684402, -122.386662486514) 10 3 8 58 1
186273 200533 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1400x La Salle Ave 9 Median : Cutout Tree DPW 1     6 Width 0ft   6016162.6096 2095677.4311 37.7352384631645 -122.386535436358 (37.7352384631645, -122.386535436358) 10 3 8 58 1
1190 107158 Undocumented 4 Pinus canariensis :: Canary Island Pine 35 101x Elsie St 1 Unaccepted Street : Yard Tree Private 2     20     6007300 2098759 37.7432051631731 -122.417395111614 (37.7432051631731, -122.417395111614) 2 7 7 28859 2
137465 234473 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 99 Elsie St 2 Sidewalk: Curb side : Pot Tree Private 2     16     6007295.70063 2098744.01488 37.7431637754778 -122.417408915989 (37.7431637754778, -122.417408915989) 2 7 7 28859 2
147596 234475 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 378 Highland Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   6007368.44216 2096501.62636 37.7370107660349 -122.416998547241 (37.7370107660349, -122.416998547241) 2 7 7 28859 2
170250 234474 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 72 Santa Marina St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6006078.82979 2097595.56477 37.7399418481504 -122.421534992063 (37.7399418481504, -122.421534992063) 2 7 7 28859 2
155300 178177 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 167 Vienna St 1 Sidewalk: Property side : Yard Tree Private 2     10     6004561.94872 2092421.12411 37.7256483463685 -122.426411406667 (37.7256483463685, -122.426411406667) 9 7 6 28861 5
2117 111271 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 700X BOSWORTH ST 9 Front Yard : Yard Tree DPW 1     42     6002150 2095428 37.7337679036822 -122.434964255854 (37.7337679036822, -122.434964255854) 2 7 5 63 7
20168 211040 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 52 Burnside Ave 11 Sidewalk: Property side : Yard Tree Private 2     24     6001161.45161 2095717.92279 37.7345077855016 -122.438402718629 (37.7345077855016, -122.438402718629) 9 7 5 63 7
32345 211008 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 700x Bosworth St 2 Median : Yard Tree DPW 1     33 Width 10ft   6002060.33003 2095430.49234 37.7337696552405 -122.435274449372 (37.7337696552405, -122.435274449372) 9 7 5 63 40
36557 211039 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 52 Burnside Ave 10 Sidewalk: Property side : Yard Tree Private 2     23     6001157.31367 2095726.26325 37.7345304511011 -122.438417622186 (37.7345304511011, -122.438417622186) 9 7 5 63 7
37212 111553 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 900x BOSWORTH ST 31 Front Yard : Yard Tree DPW 1     12     6001649 2095572 37.7341348351459 -122.436706663072 (37.7341348351459, -122.436706663072) 9 7 5 63 7
39027 211036 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 61 Burnside Ave 3 Sidewalk: Property side : Yard Tree Private 2     14     6001192.69302 2095737.41742 37.7345630902121 -122.438296103083 (37.7345630902121, -122.438296103083) 2 7 5 63 7
39660 111514 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 800x BOSWORTH ST 9 Front Yard : Yard Tree DPW 1     12     6001905 2095492 37.7339297189054 -122.435815869962 (37.7339297189054, -122.435815869962) 9 7 5 63 7
41737 115997 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 20X Park St 2 Median : Yard Tree DPW 1   08/30/2016 09:25:00 AM 3     6004982.6 2096420.1 37.7366524147431 -122.425241679782 (37.7366524147431, -122.425241679782) 2 7 5 28859 2
45135 111279 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 700X BOSWORTH ST 17 Front Yard : Yard Tree DPW 1     24     6002150 2095428 37.7337679036822 -122.434964255854 (37.7337679036822, -122.434964255854) 2 7 5 63 7
49956 211007 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 600x Bosworth St 8 Median : Yard Tree DPW 1     26 Width 10ft   6002197.80666 2095393.39137 37.7336755906519 -122.43479650017 (37.7336755906519, -122.43479650017) 9 7 5 63 40
66177 109347 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 59x BURNSIDE AVE 1 Median : Yard Tree DPW 1     14     6001229.7 2095779.3 37.7346801948558 -122.438171157158 (37.7346801948558, -122.438171157158) 2 7 5 63 7
68490 243115 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 5300x Diamond Heights Blvd 18 Median : Yard Tree DPW 1   05/01/2017 12:00:00 AM 3     6001841.69539 2098643.31719 37.7425789076843 -122.436260181872 (37.7425789076843, -122.436260181872) 2 7 5 63 7
69254 111516 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 800x BOSWORTH ST 11 Front Yard : Yard Tree DPW 1     14     6001905 2095492 37.7339297189054 -122.435815869962 (37.7339297189054, -122.435815869962) 9 7 5 63 7
69447 111507 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 800x BOSWORTH ST 2 Front Yard : Yard Tree DPW 1     18     6001905 2095492 37.7339297189054 -122.435815869962 (37.7339297189054, -122.435815869962) 9 7 5 63 7
69893 211037 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 61 Burnside Ave 4 Sidewalk: Property side : Yard Tree Private 2     16     6001183.29295 2095747.84811 37.7345911958118 -122.438329349227 (37.7345911958118, -122.438329349227) 2 7 5 63 7
71549 234477 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 500 Grand View Ave 4 Front Yard : Yard Tree Private 2     3     5999979.48342 2101750.0189 37.7510031819599 -122.442922193204 (37.7510031819599, -122.442922193204) 2 4 5 28862 22
83122 2045 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 700X Bosworth St 2 Median : Cutout Tree DPW 1     24 10   6002154.6210393 2095431.8532492 37.7337787461998 -122.434948555048 (37.7337787461998, -122.434948555048) 2 7 5 63 7
83823 211035 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 61 Burnside Ave 1 Sidewalk: Property side : Yard Tree Private 2     20     6001198.5187 2095714.51341 37.7345005324595 -122.438274321504 (37.7345005324595, -122.438274321504) 2 7 5 63 7
86234 173745 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 500X Grand View Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6000114 2102099 37.7519690677882 -122.442482075417 (37.7519690677882, -122.442482075417) 2 4 5 28862 22
87630 243112 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 5300x Diamond Heights Blvd 15 Median : Yard Tree DPW 1   05/01/2017 12:00:00 AM 3     6001806.81928 2098684.11193 37.7426889388393 -122.436383692077 (37.7426889388393, -122.436383692077) 2 7 5 63 7
96104 234476 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 784 Duncan St 2 Sidewalk: Property side : Yard Tree Private 2     2 Width 6ft   6001432.63511 2099723.41327 37.7455213464352 -122.437751929628 (37.7455213464352, -122.437751929628) 2 7 5 63 22
96483 4970 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 5200X Diamond Heights Blvd 6 Median : Cutout Tree DPW 1   01/09/2018 12:00:00 AM 3 12   6000842.33366 2099520.2529 37.7449299333661 -122.439778532074 (37.7449299333661, -122.439778532074) 2 7 5 63 7
97385 112912 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 480X BEACON ST 2 Sidewalk: Property side : Yard Tree DPW 1     30     6002571 2098077 37.7410653426557 -122.433697996676 (37.7410653426557, -122.433697996676) 2 7 5 63 7
101189 111558 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 900x BOSWORTH ST 36 Front Yard : Yard Tree DPW 1     15     6001649 2095572 37.7341348351459 -122.436706663072 (37.7341348351459, -122.436706663072) 9 7 5 63 7
107565 252925 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 700 Sanchez St 2 Front Yard : Yard Tree DPW 1           6003672 2104202 37.757945572264 -122.430328029181 (37.757945572264, -122.430328029181) 2 4 5 28862 3
113773 111508 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 800x BOSWORTH ST 3 Front Yard : Yard Tree DPW 1     18     6001905 2095492 37.7339297189054 -122.435815869962 (37.7339297189054, -122.435815869962) 9 7 5 63 7
113834 243114 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 5300x Diamond Heights Blvd 17 Median : Yard Tree DPW 1   05/01/2017 12:00:00 AM 3     6001830.21459 2098656.61242 37.7426147609522 -122.436300830338 (37.7426147609522, -122.436300830338) 2 7 5 63 7
115061 243111 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 5300x Diamond Heights Blvd 13 Median : Yard Tree DPW 1   05/01/2017 12:00:00 AM 3     6001795.3662 2098698.75734 37.7427285009166 -122.436424341429 (37.7427285009166, -122.436424341429) 2 7 5 63 7
120441 234471 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1350 Noe St 5 Sidewalk: Property side : Yard Tree Private 2     16     6003196.85258 2100348.13678 37.7473368492221 -122.431696139568 (37.7473368492221, -122.431696139568) 2 4 5 63 22
127523 243106 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 5300x Diamond Heights Blvd 9 Median : Yard Tree DPW 1   01/09/2018 12:00:00 AM 3     6001667.33897 2098826.57882 37.7430721930381 -122.436876170699 (37.7430721930381, -122.436876170699) 2 7 5 63 7
129439 4367 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 973 Chenery St 1 Sidewalk: Curb side : Cutout Tree DPW 1     24 3X3   6001101.12966 2096102.69208 37.7355608412513 -122.438638832041 (37.7355608412513, -122.438638832041) 2 7 5 63 7
135146 243113 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 5300x Diamond Heights Blvd 16 Median : Yard Tree DPW 1   05/01/2017 12:00:00 AM 3     6001816.52967 2098672.65474 37.7426580318326 -122.436349296602 (37.7426580318326, -122.436349296602) 2 7 5 63 7
138421 243116 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 5300x Diamond Heights Blvd 19 Median : Yard Tree DPW 1   05/01/2017 12:00:00 AM 3     6001856.44522 2098624.22352 37.7425273189785 -122.436207815256 (37.7425273189785, -122.436207815256) 2 7 5 63 7
146907 243109 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 5300x Diamond Heights Blvd 10 Median : Yard Tree DPW 1   05/01/2017 12:00:00 AM 3     6001750.32805 2098751.0187 37.7428694390712 -122.436583810118 (37.7428694390712, -122.436583810118) 2 7 5 63 7
147440 111557 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 900x BOSWORTH ST 35 Front Yard : Yard Tree DPW 1     12     6001649 2095572 37.7341348351459 -122.436706663072 (37.7341348351459, -122.436706663072) 9 7 5 63 7
150320 111555 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 900x BOSWORTH ST 33 Front Yard : Yard Tree DPW 1     24     6001649 2095572 37.7341348351459 -122.436706663072 (37.7341348351459, -122.436706663072) 9 7 5 63 7
160462 2028 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 600X Bosworth St 5 Median : Cutout Tree DPW 1     12 10   6002398.10054 2095366.8333155 37.7336140379052 -122.434102128474 (37.7336140379052, -122.434102128474) 2 7 5 63 7
161876 211038 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 52 Burnside Ave 1 Sidewalk: Property side : Yard Tree Private 2     36     6001171.81546 2095754.02956 37.7346075158123 -122.438369473392 (37.7346075158123, -122.438369473392) 2 7 5 63 7
162963 243101 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 5300x Diamond Heights Blvd 1 Median : Yard Tree DPW 1   01/09/2018 12:00:00 AM 3     6001501.83115 2098971.73396 37.7434613467555 -122.437458843264 (37.7434613467555, -122.437458843264) 2 7 5 63 7
165450 243102 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 5300x Diamond Heights Blvd 6 Median : Yard Tree DPW 1   05/01/2017 12:00:00 AM 3     6001583.44665 2098902.15724 37.7432749451763 -122.437171657349 (37.7432749451763, -122.437171657349) 2 7 5 63 7
171251 111554 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 900x BOSWORTH ST 32 Front Yard : Yard Tree DPW 1     26     6001649 2095572 37.7341348351459 -122.436706663072 (37.7341348351459, -122.436706663072) 9 7 5 63 7
175848 111265 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 700X BOSWORTH ST 3 Front Yard : Yard Tree DPW 1     20     6002150 2095428 37.7337679036822 -122.434964255854 (37.7337679036822, -122.434964255854) 2 7 5 63 7
186953 173744 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 500X Grand View Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6000114 2102099 37.7519690677882 -122.442482075417 (37.7519690677882, -122.442482075417) 2 4 5 28862 22
189067 243103 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 5300x Diamond Heights Blvd 8 Median : Yard Tree DPW 1   05/01/2017 12:00:00 AM 3     6001619.86426 2098870.33574 37.7431896408852 -122.437043457211 (37.7431896408852, -122.437043457211) 2 7 5 63 7
189697 234478 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 398 Surrey St 2 Sidewalk: Property side : Yard Tree Private 2     30 Width 5ft   6001098.40077 2096167.19905 37.7357378071451 -122.43865288754 (37.7357378071451, -122.43865288754) 2 7 5 63 7
193081 173746 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 500X Grand View Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6000114 2102099 37.7519690677882 -122.442482075417 (37.7519690677882, -122.442482075417) 2 4 5 28862 22
194257 4968 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 5200X Diamond Heights Blvd 4 Median : Cutout Tree DPW 1   12/03/2018 12:00:00 AM 3 12   6000815.91312 2099549.13893 37.7450077436274 -122.439871959934 (37.7450077436274, -122.439871959934) 2 7 5 63 7
194284 4966 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 5200X Diamond Heights Blvd 2 Median : Cutout Tree DPW 1   12/03/2018 12:00:00 AM 3 12   6000791.48606 2099581.9209 37.7450963646197 -122.439958774198 (37.7450963646197, -122.439958774198) 2 7 5 63 7
267 178174 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 0 Gonzalez Dr 5 Sidewalk: Curb side : Yard Tree Private 2     2     5988358.3694 2089791.63303 37.717499145949 -122.482232652541 (37.717499145949, -122.482232652541) 1 8 4 64 14
450 178165 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 10 Brotherhood Way 20 Median : Cutout Tree Private 2     5 Width 0ft   5992928.58802 2087852.90738 37.7124406464989 -122.466294818667 (37.7124406464989, -122.466294818667) 9 8 4 64 24
1053 211003 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 700 Portola Dr 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5996800.72253 2099394.55039 37.7443539050009 -122.453744529511 (37.7443539050009, -122.453744529511) 1 7 4 59 40
6387 114260 Undocumented 4 Pinus canariensis :: Canary Island Pine 35 800x BROTHERHOOD WAY 1 Front Yard : Cutout Tree Private 2     7     5990271 2088582 37.7142888575797 -122.475533361779 (37.7142888575797, -122.475533361779) 1 8 4 64 14

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