395 rows where qSpecies_id = 35 sorted by Longitude

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)
2100 253677 Significant Tree 6 Pinus canariensis :: Canary Island Pine 35 199X Kissling St 1 Side Yard : Cutout Tree Private 2       5x10                      
3808 20305 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 50X Sunset Blvd 7 Sidewalk: Curb side : Cutout Tree DPW 1     24 60                      
3943 87019 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 10 Osceola Dr 1 Sidewalk: Curb side : Cutout Tree Private 2   12/05/2007 12:00:00 AM     Permit Number 49949                    
4106 19663 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 100 STAIRWAY5 62 Sidewalk: Curb side : Cutout Tree DPW 1     12 60ST                      
5212 19664 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 100 STAIRWAY5 63 Sidewalk: Curb side : Cutout Tree DPW 1     12 60ST                      
5625 19976 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 100 STAIRWAY45 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 30ST                      
6586 258122 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 500X Clarendon Ave 4 Median : Cutout Tree DPW 1   05/26/2019 09:11:00 PM 3 5x5                      
6613 19666 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 100 STAIRWAY5 65 Sidewalk: Curb side : Cutout Tree DPW 1     18 60ST                      
6935 258120 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 500X Clarendon Ave 2 Median : Cutout Tree DPW 1   05/26/2019 09:06:00 PM 3 5x5                      
7691 19980 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 100 STAIRWAY45 7 Sidewalk: Curb side : Cutout Tree DPW 1     12 30ST                      
7975 19667 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 100 STAIRWAY5 66 Sidewalk: Curb side : Cutout Tree DPW 1     12 60ST                      
13326 258119 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 500X Clarendon Ave 1 Median : Cutout Tree DPW 1   05/26/2019 09:14:00 PM 3 5x5                      
13843 20301 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 50X Sunset Blvd 3 Sidewalk: Curb side : Cutout Tree DPW 1     36 60                      
14131 258121 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 500X Clarendon Ave 3 Median : Cutout Tree DPW 1   05/26/2019 09:09:00 PM 3 5x5                      
15936 19986 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 100 STAIRWAY46 6 Sidewalk: Curb side : Cutout Tree DPW 1     12 40                      
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
129267 98161 Significant Tree 6 Pinus canariensis :: Canary Island Pine 35 600 Front St   Front Yard : Yard Tree Private 2   12/21/2011 12:00:00 AM     Permit Number 768589 6012888.4 2118392.6 37.7974274520849 -122.399449857041 (37.7974274520849, -122.399449857041) 3 1 10 28860 6
172237 108298 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 10X Greenwich St 1 Front Yard : Yard Tree Private 2   12/15/2014 12:00:00 AM 3   Permit Number 774449 6012830 2116175 37.7913351933509 -122.399496166675 (37.7913351933509, -122.399496166675) 4 1 10 28854 6
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
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
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
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
129810 132163 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 150 Lombard St 12 Sidewalk: Curb side : Yard Tree Private 2     16 Width 5ft   6011528.08163 2120803.57488 37.8039714887622 -122.404326723704 (37.8039714887622, -122.404326723704) 3 1 10 28860 6
57367 132164 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 150 Lombard St 13 Sidewalk: Curb side : Yard Tree Private 2     16 Width 5ft   6011515.19186 2120799.84951 37.8039605395195 -122.404371067467 (37.8039605395195, -122.404371067467) 3 1 10 28860 6
58106 132162 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 165 Francisco St 11 Front Yard : Yard Tree Private 2     13     6010559.73859 2121313.26508 37.8053168133783 -122.407713714409 (37.8053168133783, -122.407713714409) 3 1 10 308 23
182602 132161 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 165 Francisco St 10 Front Yard : Yard Tree Private 2     15     6010552.8238 2121311.79296 37.8053123842132 -122.407737540175 (37.8053123842132, -122.407737540175) 3 1 10 308 23
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
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
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
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
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
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
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
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
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
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
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
94007 132160 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1141 Chestnut St 5 Front Yard : Yard Tree Private 2     20     6006382.37262 2120397.93248 37.8025688116636 -122.422104980572 (37.8025688116636, -122.422104980572) 5 9 1 28858 32
21559 8344 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1300 Geary Blvd 10 Median : Cutout Tree DPW 1   06/08/1994 12:00:00 AM 12 6   6005496.3592183 2114176.6024527 37.7854365962768 -122.424728193484 (37.7854365962768, -122.424728193484) 13 9 11 28858 13
39949 8349 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1300 Geary Blvd 15 Median : Cutout Tree DPW 1     24 6   6005496.3592183 2114176.6024527 37.7854365962768 -122.424728193484 (37.7854365962768, -122.424728193484) 13 9 11 28858 13
43907 8339 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1300 Geary Blvd 5 Median : Cutout Tree DPW 1   06/08/1994 12:00:00 AM 18 6   6005496.3592183 2114176.6024527 37.7854365962768 -122.424728193484 (37.7854365962768, -122.424728193484) 13 9 11 28858 13
60514 8341 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1300 Geary Blvd 7 Median : Cutout Tree DPW 1     24 6   6005496.3592183 2114176.6024527 37.7854365962768 -122.424728193484 (37.7854365962768, -122.424728193484) 13 9 11 28858 13
79654 8340 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1300 Geary Blvd 6 Median : Cutout Tree DPW 1   06/08/1994 12:00:00 AM 24 6   6005496.3592183 2114176.6024527 37.7854365962768 -122.424728193484 (37.7854365962768, -122.424728193484) 13 9 11 28858 13
125264 8348 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1300 Geary Blvd 14 Median : Cutout Tree DPW 1   06/08/1994 12:00:00 AM 6 6   6005496.3592183 2114176.6024527 37.7854365962768 -122.424728193484 (37.7854365962768, -122.424728193484) 13 9 11 28858 13
150834 8342 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1300 Geary Blvd 8 Median : Cutout Tree DPW 1     24 6   6005496.3592183 2114176.6024527 37.7854365962768 -122.424728193484 (37.7854365962768, -122.424728193484) 13 9 11 28858 13
161286 8351 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1300 Geary Blvd 17 Median : Cutout Tree DPW 1     24 6   6005496.3592183 2114176.6024527 37.7854365962768 -122.424728193484 (37.7854365962768, -122.424728193484) 13 9 11 28858 13
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
177341 139329 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1350x GEARY BLVD 3 Median : Cutout Tree DPW 1     13 Width 0ft   6005196.3246 2114113.3931 37.7852460889347 -122.425761723999 (37.7852460889347, -122.425761723999) 13 9 11 28858 41
65641 139330 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1350x GEARY BLVD 4 Median : Cutout Tree DPW 1     31 Width 0ft   6005126.2471 2114101.4827 37.7852094256692 -122.426003322666 (37.7852094256692, -122.426003322666) 13 9 11 28858 41
110654 139356 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1350x GEARY BLVD 5 Median : Cutout Tree DPW 1     24 Width 0ft   6005063.0942 2114090.4032 37.7851754347521 -122.426221023287 (37.7851754347521, -122.426221023287) 13 9 11 28858 41
63272 4532 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 45 Cleary Ct 3 Sidewalk: Curb side : Cutout Tree Private 2   06/07/2018 12:00:00 AM 3 3X3 Permit Number 781999 6005027.0371 2113673.2533 37.784028006638 -122.42631605912 (37.784028006638, -122.42631605912) 7 9 11 28858 41
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
137065 4531 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 45 Cleary Ct 2 Sidewalk: Curb side : Cutout Tree Private 2   06/07/2018 12:00:00 AM 3 3X3 Permit Number 781999 6004996.2689 2113667.7308 37.7840111039908 -122.426422112629 (37.7840111039908, -122.426422112629) 7 9 11 28858 41
127704 4530 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 45 Cleary Ct 1 Sidewalk: Curb side : Cutout Tree Private 2   06/07/2018 12:00:00 AM 3 3X3 Permit Number 781999 6004963.1338 2113665.364 37.7840027322121 -122.426536579485 (37.7840027322121, -122.426536579485) 7 9 11 28858 41
187582 139358 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1350x GEARY BLVD 7 Median : Cutout Tree DPW 1     19 Width 0ft   6004934.0187 2114075.446 37.7851270694756 -122.426666519258 (37.7851270694756, -122.426666519258) 13 9 11 28858 41
63063 139214 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1350x GEARY BLVD 8 Median : Cutout Tree DPW 1     29 Width 0ft   6004809.3749 2114055.503 37.7850652633568 -122.427096327106 (37.7850652633568, -122.427096327106) 13 9 11 28858 41
94670 139359 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1350x GEARY BLVD 9 Median : Cutout Tree DPW 1     28 Width 0ft   6004685.2851 2114039.9918 37.7850156556233 -122.427524533418 (37.7850156556233, -122.427524533418) 13 9 11 28858 41
74434 120629 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1500 Geary Blvd 6 Median : Cutout Tree DPW 1           6004538 2114050 37.7850348039721 -122.428034806681 (37.7850348039721, -122.428034806681) 13 9 11 29490 13
45559 8390 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1500 Geary Blvd 1 Median : Cutout Tree DPW 1     36 8   6004488.7034 2114010.5767 37.7849237683164 -122.428202546761 (37.7849237683164, -122.428202546761) 13 9 11 29490 41
65698 8391 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1500 Geary Blvd 2 Median : Cutout Tree DPW 1     36 8   6004438.3798 2114005.2394 37.784906265949 -122.428376269712 (37.784906265949, -122.428376269712) 13 9 11 29490 41
436 120628 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1500 Geary Blvd 5 Median : Cutout Tree DPW 1           6004397 2113949 37.7847495050096 -122.428515420401 (37.7847495050096, -122.428515420401) 13 9 11 29490 41
1049 120626 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1500 Geary Blvd 3 Median : Cutout Tree DPW 1           6004397 2113949 37.7847495050096 -122.428515420401 (37.7847495050096, -122.428515420401) 13 9 11 29490 41
150152 120624 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1500 Geary Blvd 1 Median : Cutout Tree DPW 1           6004397 2113949 37.7847495050096 -122.428515420401 (37.7847495050096, -122.428515420401) 13 9 11 29490 41
156411 120627 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1500 Geary Blvd 4 Median : Cutout Tree DPW 1           6004397 2113949 37.7847495050096 -122.428515420401 (37.7847495050096, -122.428515420401) 13 9 11 29490 41
74880 8392 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1500 Geary Blvd 3 Median : Cutout Tree DPW 1     36 8   6004378.144 2113996.8521 37.7848798278423 -122.428584068109 (37.7848798278423, -122.428584068109) 13 9 11 29490 41
40576 120625 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1500 Geary Blvd 2 Median : Cutout Tree DPW 1           6004349 2113949 37.7847467885767 -122.428681484586 (37.7847467885767, -122.428681484586) 13 9 11 29490 41
54682 8393 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1500 Geary Blvd 4 Median : Cutout Tree DPW 1     36 8   6004320.9581 2113985.4149 37.7848451877241 -122.428781097193 (37.7848451877241, -122.428781097193) 13 9 11 29490 41
97674 8394 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1500 Geary Blvd 5 Median : Cutout Tree DPW 1     36 8   6004234.0356 2113977.7901 37.784819331933 -122.429081276927 (37.784819331933, -122.429081276927) 13 9 11 29490 41
73905 8395 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1500 Geary Blvd 6 Median : Cutout Tree DPW 1   06/09/1994 12:00:00 AM 6 8   6004192.8617 2113973.9777 37.7848065332396 -122.429223453232 (37.7848065332396, -122.429223453232) 13 9 11 29490 41

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