home / trees

Street_Tree_List

Data source: data.sfgov.org

389 rows where qSpecies = 22

View and edit SQL

Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, PlantDate, PlotSize, PermitNotes, Fire Prevention Districts, Police Districts, Supervisor Districts, Zip Codes, Neighborhoods

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods
76 100068 Permitted Site 2 Pinus canariensis :: Canary Island Pine 22 303 Serrano Dr 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/13/2012 12:00:00 AM     Permit Number 769006 5990392.0 2090762.0 37.720281613079 -122.47527420247 (37.720281613079, -122.47527420247) 1 8 4 64 40
894 101034 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 22 1010X Portola Dr 8 Front Yard : Yard 4 Tree 1 DPW 1           5995923.3 2098391.5 37.7415494342357 -122.45670592621 (37.7415494342357, -122.45670592621) 1 7 4 59 40
896 101036 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 22 1010X Portola Dr 10 Front Yard : Yard 4 Tree 1 DPW 1   04/11/2013 12:00:00 AM 3     5995923.3 2098391.5 37.7415494342357 -122.45670592621 (37.7415494342357, -122.45670592621) 1 7 4 59 40
901 101040 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 22 1010X Portola Dr 14 Front Yard : Yard 4 Tree 1 DPW 1   04/11/2013 12:00:00 AM 3     5995923.3 2098391.5 37.7415494342357 -122.45670592621 (37.7415494342357, -122.45670592621) 1 7 4 59 40
4653 105261 Undocumented 3 Pinus canariensis :: Canary Island Pine 22 619 GONZALEZ DR   Sidewalk: Curb side : Yard 7 Tree 1 Private 2     3     5988914.8 2089258.8 37.716068469533205 -122.48027037241002 (37.7160684695332, -122.48027037241) 1 8 4 64 14
4656 105268 Permitted Site 2 Pinus canariensis :: Canary Island Pine 22 842X GONZALEZ DR 1 Sidewalk: Curb side : Yard 7 Tree 1 Private 2     2     5988421.0 2089827.0 37.7175998975755 -122.48201875930201 (37.7175998975755, -122.482018759302) 1 8 4 64 14
5505 106310 Significant Tree 4 Pinus canariensis :: Canary Island Pine 22 99X Clearfield Dr 4 Sidewalk: Property side : Yard 5 Tree 1 Private 2   04/15/2014 12:00:00 AM     Permit Number 772542 5985798.26078 2095453.4648400003 37.73289581695511 -122.49149816384899 (37.7328958169551, -122.491498163849) 1 8 4 64 35
5506 106311 Significant Tree 4 Pinus canariensis :: Canary Island Pine 22 99X Clearfield Dr 5 Sidewalk: Property side : Yard 5 Tree 1 Private 2   04/15/2014 12:00:00 AM     Permit Number 772542 5985798.26078 2095453.4648400003 37.73289581695511 -122.49149816384899 (37.7328958169551, -122.491498163849) 1 8 4 64 35
6191 107158 Undocumented 3 Pinus canariensis :: Canary Island Pine 22 101x Elsie St 1 Unaccepted Street : Yard 13 Tree 1 Private 2     20     6007300.0 2098759.0 37.7432051631731 -122.417395111614 (37.7432051631731, -122.417395111614) 2 7 7 28859 2
7184 108298 Permitted Site 2 Pinus canariensis :: Canary Island Pine 22 10X Greenwich St 1 Front Yard : Yard 4 Tree 1 Private 2   12/15/2014 12:00:00 AM 3   Permit Number 774449 6012830.0 2116175.0 37.791335193350896 -122.399496166675 (37.7913351933509, -122.399496166675) 4 1 10 28854 6
8244 109347 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 22 59x BURNSIDE AVE 1 Median : Yard 11 Tree 1 DPW 1     14     6001229.7 2095779.3 37.7346801948558 -122.438171157158 (37.7346801948558, -122.438171157158) 2 7 5 63 7
9867 111265 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 22 700X BOSWORTH ST 3 Front Yard : Yard 4 Tree 1 DPW 1     20     6002150.0 2095428.0 37.73376790368221 -122.434964255854 (37.7337679036822, -122.434964255854) 2 7 5 63 7
9874 111271 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 22 700X BOSWORTH ST 9 Front Yard : Yard 4 Tree 1 DPW 1     42     6002150.0 2095428.0 37.73376790368221 -122.434964255854 (37.7337679036822, -122.434964255854) 2 7 5 63 7
9882 111279 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 22 700X BOSWORTH ST 17 Front Yard : Yard 4 Tree 1 DPW 1     24     6002150.0 2095428.0 37.73376790368221 -122.434964255854 (37.7337679036822, -122.434964255854) 2 7 5 63 7
10065 111507 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 22 800x BOSWORTH ST 2 Front Yard : Yard 4 Tree 1 DPW 1     18     6001905.0 2095492.0 37.733929718905394 -122.435815869962 (37.7339297189054, -122.435815869962) 9 7 5 63 7
10066 111508 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 22 800x BOSWORTH ST 3 Front Yard : Yard 4 Tree 1 DPW 1     18     6001905.0 2095492.0 37.733929718905394 -122.435815869962 (37.7339297189054, -122.435815869962) 9 7 5 63 7
10073 111514 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 22 800x BOSWORTH ST 9 Front Yard : Yard 4 Tree 1 DPW 1     12     6001905.0 2095492.0 37.733929718905394 -122.435815869962 (37.7339297189054, -122.435815869962) 9 7 5 63 7
10075 111516 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 22 800x BOSWORTH ST 11 Front Yard : Yard 4 Tree 1 DPW 1     14     6001905.0 2095492.0 37.733929718905394 -122.435815869962 (37.7339297189054, -122.435815869962) 9 7 5 63 7
10116 111553 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 22 900x BOSWORTH ST 31 Front Yard : Yard 4 Tree 1 DPW 1     12     6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072) 9 7 5 63 7
10117 111554 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 22 900x BOSWORTH ST 32 Front Yard : Yard 4 Tree 1 DPW 1     26     6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072) 9 7 5 63 7
10118 111555 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 22 900x BOSWORTH ST 33 Front Yard : Yard 4 Tree 1 DPW 1     24     6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072) 9 7 5 63 7
10120 111557 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 22 900x BOSWORTH ST 35 Front Yard : Yard 4 Tree 1 DPW 1     12     6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072) 9 7 5 63 7
10121 111558 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 22 900x BOSWORTH ST 36 Front Yard : Yard 4 Tree 1 DPW 1     15     6001649.0 2095572.0 37.734134835145895 -122.436706663072 (37.7341348351459, -122.436706663072) 9 7 5 63 7
10138 111575 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 22 1x SUNSET BLVD OFF RAMP 7 Median : Cutout 1 Tree 1 DPW 1     5 3x3   5984955.0 2095624.0 37.7333147463652 -122.494426056577 (37.7333147463652, -122.494426056577) 1 8 4 64 35
11343 112912 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 22 480X BEACON ST 2 Sidewalk: Property side : Yard 5 Tree 1 DPW 1     30     6002571.0 2098077.0 37.7410653426557 -122.433697996676 (37.7410653426557, -122.433697996676) 2 7 5 63 7
12429 114123 Undocumented 3 Pinus canariensis :: Canary Island Pine 22 1200X JUNIPERO SERRA BLVD 16 Sidewalk: Property side : Yard 5 Tree 1 Private 2     18     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304) 1 8 4 64 14
12430 114124 Undocumented 3 Pinus canariensis :: Canary Island Pine 22 1200X JUNIPERO SERRA BLVD 17 Sidewalk: Property side : Yard 5 Tree 1 Private 2     12     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304) 1 8 4 64 14
12444 114137 Undocumented 3 Pinus canariensis :: Canary Island Pine 22 1200X JUNIPERO SERRA BLVD 33 Sidewalk: Property side : Yard 5 Tree 1 Private 2     26     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304) 1 8 4 64 14
12445 114138 Undocumented 3 Pinus canariensis :: Canary Island Pine 22 1200X JUNIPERO SERRA BLVD 32 Sidewalk: Property side : Yard 5 Tree 1 Private 2   02/16/2016 12:00:00 AM 3     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304) 1 8 4 64 14
12446 114139 Undocumented 3 Pinus canariensis :: Canary Island Pine 22 1200X JUNIPERO SERRA BLVD 34 Sidewalk: Property side : Yard 5 Tree 1 Private 2     36     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304) 1 8 4 64 14
12568 114260 Undocumented 3 Pinus canariensis :: Canary Island Pine 22 800x BROTHERHOOD WAY 1 Front Yard : Cutout 10 Tree 1 Private 2     7     5990271.0 2088582.0 37.7142888575797 -122.475533361779 (37.7142888575797, -122.475533361779) 1 8 4 64 14
12636 114370 Undocumented 3 Pinus canariensis :: Canary Island Pine 22 821 GONZALEZ DR 1 Sidewalk: Curb side : Yard 7 Tree 1 Private 2     2     5988453.0 2089765.0 37.7174315222235 -122.481903612061 (37.7174315222235, -122.481903612061) 1 8 4 64 14
12637 114371 Undocumented 3 Pinus canariensis :: Canary Island Pine 22 821 GONZALEZ DR 2 Sidewalk: Curb side : Yard 7 Tree 1 Private 2     2     5988453.0 2089765.0 37.7174315222235 -122.481903612061 (37.7174315222235, -122.481903612061) 1 8 4 64 14
12638 114372 Undocumented 3 Pinus canariensis :: Canary Island Pine 22 821 GONZALEZ DR 3 Sidewalk: Curb side : Yard 7 Tree 1 Private 2     3     5988453.0 2089765.0 37.7174315222235 -122.481903612061 (37.7174315222235, -122.481903612061) 1 8 4 64 14
12640 114377 Permitted Site 2 Pinus canariensis :: Canary Island Pine 22 842X GONZALEZ DR 2 Sidewalk: Curb side : Yard 7 Tree 1 Private 2     2     5988421.0 2089827.0 37.7175998975755 -122.48201875930201 (37.7175998975755, -122.482018759302) 1 8 4 64 14
12641 114378 Permitted Site 2 Pinus canariensis :: Canary Island Pine 22 842X GONZALEZ DR 3 Sidewalk: Curb side : Yard 7 Tree 1 Private 2     2     5988421.0 2089827.0 37.7175998975755 -122.48201875930201 (37.7175998975755, -122.482018759302) 1 8 4 64 14
13155 114925 Undocumented 3 Pinus canariensis :: Canary Island Pine 22 4400x OCEAN AVE 3 Front Yard : Cutout 10 Tree 1 Private 2   02/17/2016 12:00:00 AM 3 3x3 Permit Number 777127 5985931.0 2095134.0 37.7320264068308 -122.491015755892 (37.7320264068308, -122.491015755892) 1 8 4 64 35
13165 114934 Undocumented 3 Pinus canariensis :: Canary Island Pine 22 4400x OCEAN AVE 10 Front Yard : Cutout 10 Tree 1 Private 2   02/17/2016 12:00:00 AM 3 3x3 Permit Number 777127 5985931.0 2095134.0 37.7320264068308 -122.491015755892 (37.7320264068308, -122.491015755892) 1 8 4 64 35
14046 115834 Undocumented 3 Pinus canariensis :: Canary Island Pine 22 900X LAKE MERCED BLVD 2 Median : Cutout 1 Tree 1 Private 2   08/30/2016 12:00:00 AM 3 10x100 Permit Number 777492 5987646.0 2090104.0 37.7183153647657 -122.484717856844 (37.7183153647657, -122.484717856844) 1 8 4 64 14
14194 115997 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 22 20X Park St 2 Median : Yard 11 Tree 1 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
14261 116067 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 22 4150X CLEMENT ST 5 Front Yard : Yard 4 Tree 1 DPW 1   04/15/2016 12:00:00 AM 3 3x3 Permit Number 777818 5983115.0 2113126.0 37.7812624555251 -122.502082001527 (37.7812624555251, -122.502082001527) 11 6 2 55 15
16523 118538 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 22 7900x Geary Blvd 1 Median : Cutout 1 Tree 1 DPW 1     11 Width 4ft   5982472.235830001 2112389.87128 37.7792034803758 -122.504251064408 (37.7792034803758, -122.504251064408) 11 6 2 55 26
17749 120262 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 22 100 24th Ave 6 Side Yard : Yard 27 Tree 1 Private 2     26     5988353.58713 2115180.43805 37.7872097252822 -122.484109995805 (37.7872097252822, -122.484109995805) 11 6 1 55 33
17989 120542 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 22 2450 California St 1 Front Yard : Yard 4 Tree 1 MTA 11 DPW for City Agency 4         6002644.1089699995 2115479.97736 37.7888538273233 -122.43468935172599 (37.7888538273233, -122.434689351726) 13 9 1 29490 27
18044 120624 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 22 1500 Geary Blvd 1 Median : Cutout 1 Tree 1 DPW 1           6004397.0 2113949.0 37.7847495050096 -122.428515420401 (37.7847495050096, -122.428515420401) 13 9 11 29490 41
18045 120625 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 22 1500 Geary Blvd 2 Median : Cutout 1 Tree 1 DPW 1           6004349.0 2113949.0 37.784746788576705 -122.428681484586 (37.7847467885767, -122.428681484586) 13 9 11 29490 41
18046 120626 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 22 1500 Geary Blvd 3 Median : Cutout 1 Tree 1 DPW 1           6004397.0 2113949.0 37.7847495050096 -122.428515420401 (37.7847495050096, -122.428515420401) 13 9 11 29490 41
18047 120627 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 22 1500 Geary Blvd 4 Median : Cutout 1 Tree 1 DPW 1           6004397.0 2113949.0 37.7847495050096 -122.428515420401 (37.7847495050096, -122.428515420401) 13 9 11 29490 41
18048 120628 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 22 1500 Geary Blvd 5 Median : Cutout 1 Tree 1 DPW 1           6004397.0 2113949.0 37.7847495050096 -122.428515420401 (37.7847495050096, -122.428515420401) 13 9 11 29490 41
18049 120629 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 22 1500 Geary Blvd 6 Median : Cutout 1 Tree 1 DPW 1           6004538.0 2114050.0 37.7850348039721 -122.428034806681 (37.7850348039721, -122.428034806681) 13 9 11 29490 13
19986 122584 Undocumented 3 Pinus canariensis :: Canary Island Pine 22 2500X Lyon St 4 Median : Cutout 1 Tree 1 Private 2     11 10x20   5999276.0 2117538.0 37.794312827392396 -122.446490617691 (37.7943128273924, -122.446490617691) 13 9 1 57 27
30275 132160 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 22 1141 Chestnut St 5 Front Yard : Yard 4 Tree 1 Private 2     20     6006382.37262 2120397.93248 37.802568811663605 -122.422104980572 (37.8025688116636, -122.422104980572) 5 9 1 28858 32
30276 132161 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 22 165 Francisco St 10 Front Yard : Yard 4 Tree 1 Private 2     15     6010552.8238 2121311.7929599998 37.8053123842132 -122.407737540175 (37.8053123842132, -122.407737540175) 3 1 10 308 23
30277 132162 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 22 165 Francisco St 11 Front Yard : Yard 4 Tree 1 Private 2     13     6010559.73859 2121313.26508 37.8053168133783 -122.40771371440901 (37.8053168133783, -122.407713714409) 3 1 10 308 23
30278 132163 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 22 150 Lombard St 12 Sidewalk: Curb side : Yard 7 Tree 1 Private 2     16 Width 5ft   6011528.08163 2120803.5748799997 37.8039714887622 -122.40432672370399 (37.8039714887622, -122.404326723704) 3 1 10 28860 6
30279 132164 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 22 150 Lombard St 13 Sidewalk: Curb side : Yard 7 Tree 1 Private 2     16 Width 5ft   6011515.19186 2120799.8495099996 37.8039605395195 -122.404371067467 (37.8039605395195, -122.404371067467) 3 1 10 28860 6
37498 139214 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 22 1350x GEARY BLVD 8 Median : Cutout 1 Tree 1 DPW 1     29 Width 0ft   6004809.3749 2114055.503 37.78506526335679 -122.427096327106 (37.7850652633568, -122.427096327106) 13 9 11 28858 41
37625 139329 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 22 1350x GEARY BLVD 3 Median : Cutout 1 Tree 1 DPW 1     13 Width 0ft   6005196.3246 2114113.3931 37.785246088934706 -122.425761723999 (37.7852460889347, -122.425761723999) 13 9 11 28858 41
37627 139330 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 22 1350x GEARY BLVD 4 Median : Cutout 1 Tree 1 DPW 1     31 Width 0ft   6005126.2471 2114101.4827 37.7852094256692 -122.42600332266599 (37.7852094256692, -122.426003322666) 13 9 11 28858 41
37655 139356 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 22 1350x GEARY BLVD 5 Median : Cutout 1 Tree 1 DPW 1     24 Width 0ft   6005063.0942 2114090.4032 37.785175434752105 -122.42622102328698 (37.7851754347521, -122.426221023287) 13 9 11 28858 41
37657 139358 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 22 1350x GEARY BLVD 7 Median : Cutout 1 Tree 1 DPW 1     19 Width 0ft   6004934.0187 2114075.446 37.7851270694756 -122.426666519258 (37.7851270694756, -122.426666519258) 13 9 11 28858 41
37658 139359 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 22 1350x GEARY BLVD 9 Median : Cutout 1 Tree 1 DPW 1     28 Width 0ft   6004685.2851 2114039.9918 37.7850156556233 -122.42752453341801 (37.7850156556233, -122.427524533418) 13 9 11 28858 41
45568 173637 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 22 1155 Market St 99 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6008672.0 2111900.0 37.779364436223 -122.4135803097 (37.779364436223, -122.4135803097) 8 2 9 28853 34
45670 173744 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 22 500X Grand View Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6000114.0 2102099.0 37.7519690677882 -122.442482075417 (37.7519690677882, -122.442482075417) 2 4 5 28862 22
45671 173745 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 22 500X Grand View Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1       3x3   6000114.0 2102099.0 37.7519690677882 -122.442482075417 (37.7519690677882, -122.442482075417) 2 4 5 28862 22
45672 173746 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 22 500X Grand View Ave 3 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1       3x3   6000114.0 2102099.0 37.7519690677882 -122.442482075417 (37.7519690677882, -122.442482075417) 2 4 5 28862 22
49352 178129 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 22 345 Tocoloma Ave 1 Sidewalk: Property side : Yard 5 Tree 1 Private 2     4 Width 8ft   6012554.38724 2086809.43241 37.7106883309719 -122.398388432799 (37.7106883309719, -122.398388432799) 10 3 8 309 1
49354 178130 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 22 20 Brotherhood Way 1 : 14 Tree 1 Private 2     7 Width 0ft   5992655.54446 2087848.4586 37.7124126730818 -122.4672382093 (37.7124126730818, -122.4672382093) 9 8 4 64 24
49355 178131 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 22 20 Brotherhood Way 2 : 14 Tree 1 Private 2     5 Width 0ft   5992618.59421 2087849.2354599999 37.7124126730667 -122.46736597596501 (37.7124126730667, -122.467365975965) 9 8 4 64 24
49356 178132 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 22 20 Brotherhood Way 3 : 14 Tree 1 Private 2     6 Width 0ft   5992585.12632 2087848.18621 37.7124078599039 -122.467481573927 (37.7124078599039, -122.467481573927) 9 8 4 64 24
49357 178133 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 22 20 Brotherhood Way 4 : 14 Tree 1 Private 2     6 Width 0ft   5992553.46677 2087849.4362400002 37.7124094643071 -122.467591088862 (37.7124094643071, -122.467591088862) 9 8 4 64 24
49358 178134 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 22 20 Brotherhood Way 5 Side Yard : Yard 27 Tree 1 DPW 1     5 Width 0ft   5992424.40969 2087850.98169 37.7124062555176 -122.46803725782699 (37.7124062555176, -122.468037257827) 9 8 4 64 24
49359 178135 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 22 20 Brotherhood Way 6 : 14 Tree 1 Private 2     5 Width 0ft   5992385.6999699995 2087851.7958799999 37.7124062555186 -122.46817110840401 (37.7124062555186, -122.468171108404) 9 8 4 64 24
49360 178136 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 22 20 Brotherhood Way 7 : 14 Tree 1 Private 2     5 Width 0ft   5992351.132540001 2087854.27594 37.7124110686957 -122.468290763208 (37.7124110686957, -122.468290763208) 9 8 4 64 24
49361 178137 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 22 20 Brotherhood Way 8 : 14 Tree 1 Private 2     5 Width 0ft   5992316.61451 2087859.0919400002 37.712422298533895 -122.46841041712901 (37.7124222985339, -122.468410417129) 9 8 4 64 24
49362 178138 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 22 20 Brotherhood Way 9 : 14 Tree 1 Private 2     7 Width 0ft   5992224.93754 2087880.30275 37.71247524252121 -122.46872882029699 (37.7124752425212, -122.468728820297) 9 8 4 64 24
49363 178139 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 22 20 Brotherhood Way 10 : 14 Tree 1 Private 2     6 Width 0ft   5992188.74587 2087889.2446599999 37.7124977039766 -122.468854559004 (37.7124977039766, -122.468854559004) 9 8 4 64 24
49365 178140 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 22 20 Brotherhood Way 11 : 14 Tree 1 Private 2     6 Width 0ft   5992153.764330001 2087899.9141099998 37.712524978625005 -122.46897624088301 (37.712524978625, -122.468976240883) 9 8 4 64 24
49366 178141 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 22 20 Brotherhood Way 12 Median : Yard 11 Tree 1 Private 2 DPW 3   5 Width 0ft   5992021.87667 2087934.24208 37.7126116138994 -122.46943457854401 (37.7126116138994, -122.469434578544) 9 8 4 64 24
49367 178142 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 22 20 Brotherhood Way 13 : 14 Tree 1 Private 2     5 Width 0ft   5991993.89623 2087943.0111099998 37.7126340744777 -122.469531924782 (37.7126340744777, -122.469531924782) 9 8 4 64 24
49368 178143 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 22 20 Brotherhood Way 14 : 14 Tree 1 Private 2     5 Width 0ft   5991964.10718 2087949.4813 37.7126501183836 -122.46963535489999 (37.7126501183836, -122.4696353549) 9 8 4 64 24
49369 178144 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 22 20 Brotherhood Way 15 : 14 Tree 1 Private 2     4 Width 0ft   5991934.88004 2087954.77106 37.712662953501294 -122.46973675705799 (37.7126629535013, -122.469736757058) 9 8 4 64 24
49370 178145 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 22 20 Brotherhood Way 16 : 14 Tree 1 Private 2     4 Width 0ft   5991905.80045 2087967.0692099999 37.71269504040679 -122.469838159212 (37.7126950404068, -122.469838159212) 9 8 4 64 24
49371 178146 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 22 20 Brotherhood Way 17 : 14 Tree 1 Private 2     4 Width 0ft   5991839.8077 2087981.8975 37.712731940507105 -122.47006732805 (37.7127319405071, -122.47006732805) 9 8 4 64 24
49372 178147 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 22 20 Brotherhood Way 18 : 14 Tree 1 Private 2     4 Width 0ft   5991814.6494 2087985.34878 37.712739962461 -122.47015453351999 (37.712739962461, -122.47015453352) 9 8 4 64 24
49373 178148 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 22 20 Brotherhood Way 19 : 14 Tree 1 Private 2     5 Width 0ft   5991783.61367 2087988.3395200002 37.712746380014295 -122.47026201958299 (37.7127463800143, -122.470262019583) 9 8 4 64 24
49374 178149 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 22 20 Brotherhood Way 20 : 14 Tree 1 Private 2     4 Width 0ft   5991654.66793 2087995.1451599998 37.712757610756 -122.470708188538 (37.712757610756, -122.470708188538) 9 8 4 64 24
49376 178150 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 22 20 Brotherhood Way 21 : 14 Tree 1 Private 2     4 Width 0ft   5991622.99627 2087995.81221 37.71275761073721 -122.47081770347401 (37.7127576107372, -122.470817703474) 9 8 4 64 24
49377 178151 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 22 10 Brotherhood Way 4 : 14 Tree 1 Private 2     3 Width 0ft   5993597.52442 2087641.3827799999 37.7118984245322 -122.46396744335199 (37.7118984245322, -122.463967443352) 9 8 4 64 24
49378 178152 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 22 10 Brotherhood Way 7 : 14 Tree 1 Private 2     5 Width 0ft   5993523.09133 2087729.02455 37.7121347780763 -122.46423106162399 (37.7121347780763, -122.464231061624) 9 8 4 64 24
49379 178153 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 22 10 Brotherhood Way 8 : 14 Tree 1 Private 2     7 Width 0ft   5993495.89449 2087748.40295 37.712186418929896 -122.464326467118 (37.7121864189299, -122.464326467118) 9 8 4 64 24
49380 178154 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 22 10 Brotherhood Way 9 : 14 Tree 1 Private 2     7 Width 0ft   5993415.347159999 2087786.9851099998 37.7122877131728 -122.464607659932 (37.7122877131728, -122.464607659932) 9 8 4 64 24
49381 178155 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 22 10 Brotherhood Way 10 : 14 Tree 1 Private 2     6 Width 0ft   5993366.44396 2087810.43567 37.71234928345479 -122.46477838452499 (37.7123492834548, -122.464778384525) 9 8 4 64 24
49382 178156 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 22 10 Brotherhood Way 11 : 14 Tree 1 Private 2     5 Width 0ft   5993327.478519999 2087822.82752 37.712381061909 -122.464913959129 (37.712381061909, -122.464913959129) 9 8 4 64 24
49383 178157 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 22 10 Brotherhood Way 12 : 14 Tree 1 Private 2     7 Width 0ft   5993292.82373 2087832.959 37.712406882332 -122.46503447098499 (37.712406882332, -122.465034470985) 9 8 4 64 24
49384 178158 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 22 10 Brotherhood Way 13 : 14 Tree 1 Private 2     5 Width 0ft   5993255.20411 2087840.2590599998 37.7124247572585 -122.465165024673 (37.7124247572585, -122.465165024673) 9 8 4 64 24
49385 178159 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 22 10 Brotherhood Way 14 : 14 Tree 1 Private 2     5 Width 0ft   5993218.97583 2087844.63687 37.7124346884772 -122.465290557432 (37.7124346884772, -122.465290557432) 9 8 4 64 24
49387 178160 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 22 10 Brotherhood Way 15 : 14 Tree 1 Private 2     6 Width 0ft   5993144.356269999 2087854.16093 37.712456535710395 -122.465549154771 (37.7124565357104, -122.465549154771) 9 8 4 64 24
49388 178161 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 22 10 Brotherhood Way 16 : 14 Tree 1 Private 2     6 Width 0ft   5993106.56964 2087853.50799 37.7124525633948 -122.46567970845899 (37.7124525633948, -122.465679708459) 9 8 4 64 24
49389 178162 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 22 10 Brotherhood Way 17 : 14 Tree 1 Private 2     5 Width 0ft   5993072.48922 2087856.39417 37.7124585223038 -122.46579770942301 (37.7124585223038, -122.465797709423) 9 8 4 64 24

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" REAL,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" REAL,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT,
  "Fire Prevention Districts" INTEGER,
  "Police Districts" INTEGER,
  "Supervisor Districts" INTEGER,
  "Zip Codes" INTEGER,
  "Neighborhoods" INTEGER
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id))
Powered by Datasette · Query took 30.162ms · Data source: data.sfgov.org