1,985 rows where qSpecies_id = 83 sorted by Supervisor Districts

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)
449 252970 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 101X Whipple Ave 2 Sidewalk: Curb side : Yard Tree Private 2   04/26/2019 12:00:00 AM 3                        
2762 46200 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83   2 Sidewalk: Curb side : Cutout Tree Private 2   12/31/2001 12:00:00 AM     Permit Number 44518                    
3450 52146 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 145 Hawes St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/31/2005 12:00:00 AM     Permit Number 48337                    
3492 30592 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 269 Walter St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/26/1995 12:00:00 AM     Permit Number 34561                    
7715 260428 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 745 Silliman St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 08/17/2019 12:00:00 AM 3                        
9907 30593 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 269 Walter St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/26/1995 12:00:00 AM     Permit Number 34561                    
13512 259080 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1001 Visitacion Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   06/01/2019 12:00:00 AM 3                        
15478 252965 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 115X Whipple Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2017 02:04:00 PM 3                        
15527 19972 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 100 STAIRWAY44 3 Sidewalk: Curb side : Cutout Tree DPW 1     3 36                      
19620 46201 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83   1 Sidewalk: Curb side : Cutout Tree Private 2   12/31/2001 12:00:00 AM     Permit Number 44518                    
281 136194 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 2914 Fillmore St 6 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   6002528.73575 2118269.03723 37.7965053162169 -122.435288106477 (37.7965053162169, -122.435288106477) 13 9 1 57 17
381 136202 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1337 Francisco St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6004913.0684 2120534.02336 37.8028595013299 -122.427199210075 (37.8028595013299, -122.427199210075) 13 9 1 57 17
3017 136252 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 802 North Point St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6006854.74284 2121556.78092 37.8057773454026 -122.420552649091 (37.8057773454026, -122.420552649091) 5 1 1 28858 32
3730 120250 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 164 24th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     9 Width 6ft   5988365.5517 2114845.05893 37.7862895663335 -122.484043998391 (37.7862895663335, -122.484043998391) 11 6 1 55 33
5677 123020 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 152 06th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5993993.9147 2114546.78107 37.78579664693 -122.464549802121 (37.78579664693, -122.464549802121) 11 6 1 54 11
5790 136106 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 2362 Vallejo St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 4ft   6002236.43409 2117779.37436 37.7951442255914 -122.436264471651 (37.7951442255914, -122.436264471651) 13 9 1 57 17
8202 46512 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 2188 Green St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/27/2002 12:00:00 AM 8   Permit Number 44678 6002606.94356 2118178.75715 37.7962618715428 -122.435011030753 (37.7962618715428, -122.435011030753) 13 9 1 57 17
10812 58694 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 3633 Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/02/1979 12:00:00 AM 4   Permit Number 17970 5996855.26576 2115960.61486 37.7898431897625 -122.454752572401 (37.7898431897625, -122.454752572401) 11 6 1 54 31
11012 7356 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 2309 Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/01/2007 12:00:00 AM 4 3X3   6002769.01195 2116184.22684 37.7907946063198 -122.434307574482 (37.7907946063198, -122.434307574482) 13 9 1 29490 27
12316 124412 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 3900 Clay St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   5996120.28006 2115251.26489 37.7878533198568 -122.45724420279 (37.7878533198568, -122.45724420279) 11 6 1 54 31
13059 58732 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 2385 California St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/29/2005 12:00:00 AM     Permit Number 17967 6002968.76813263 2115478.70521399 37.7888687602145 -122.433565986183 (37.7888687602145, -122.433565986183) 13 9 1 29490 27
13315 34250 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 945 Bay St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/17/1998 12:00:00 AM 5   Permit Number 38731 6006204.75677 2121056.43709 37.8043668775019 -122.422766446326 (37.8043668775019, -122.422766446326) 5 1 1 28858 32
13618 143549 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 2245 UNION ST 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   6002240.1517 2118427.2493 37.7969233328664 -122.436297997013 (37.7969233328664, -122.436297997013) 13 9 1 57 17
16463 106806 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 167 Commonwealth Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4     5996526.1156 2113255.0824 37.7823956347772 -122.455695748043 (37.7823956347772, -122.455695748043) 11 6 1 54 31
18843 65788 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 201 Laurel St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/26/1990 12:00:00 AM 7   Permit Number 28756 5998021.12629 2115778.19726 37.7894091238674 -122.450705664532 (37.7894091238674, -122.450705664532) 11 6 1 54 31
22517 41240 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 270 Masonic Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   12/02/1999 12:00:00 AM     Permit Number 41940 5999013.40299918 2112000.64122659 37.7790936893244 -122.447000559943 (37.7790936893244, -122.447000559943) 15 5 1 54 16
23046 136230 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 3100 Gough St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6004683.10116 2120231.33167 37.8020153805639 -122.427973432847 (37.8020153805639, -122.427973432847) 13 9 1 57 17
23216 136209 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 3501 Washington St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   5997993.27095 2115789.6423 37.7894389544021 -122.450802865961 (37.7894389544021, -122.450802865961) 11 6 1 54 31
23910 69318 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1466 Chestnut St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/23/1994 12:00:00 AM 12   Permit Number 33399 6004829.35126 2120222.0032 37.8019980398336 -122.427466672957 (37.8019980398336, -122.427466672957) 13 9 1 57 17
24907 136189 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 2914 Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 2ft   6002539.896 2118184.5507 37.7962739719132 -122.435243443451 (37.7962739719132, -122.435243443451) 13 9 1 57 17
27479 136226 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1570 Chestnut St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6004327.39771 2120155.21272 37.8017862476969 -122.429198904827 (37.8017862476969, -122.429198904827) 13 9 1 57 17
28070 120249 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 164 24th Ave 2 Sidewalk: Curb side : Yard Tree Private 2     10 Width 6ft   5988365.91336 2114852.64965 37.7863104293457 -122.484043303996 (37.7863104293457, -122.484043303996) 11 6 1 55 33
28462 7316 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 2000 Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 3X3   6002972.25432 2115230.97031 37.7881887410682 -122.433536213059 (37.7881887410682, -122.433536213059) 13 9 1 29490 27
29411 124324 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 109 Jordan Ave 2 Sidewalk: Property side : Yard Tree Private 2     9 Width 3ft   5996182.48161 2113700.35533 37.7835985094544 -122.45691677945 (37.7835985094544, -122.45691677945) 11 6 1 54 31
30443 136227 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 3630 Webster St 4 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6002616.6752 2121115.11425 37.804324892641 -122.435187487615 (37.804324892641, -122.435187487615) 13 9 1 57 17
30941 136212 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 101 Spruce St 3 Sidewalk: Curb side : Yard Tree Private 2     7 Width 3ft   5997026.47763 2115953.79939 37.7898342954728 -122.454159706 (37.7898342954728, -122.454159706) 11 6 1 54 31
33527 136257 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 2106 Leavenworth St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6007681.63018 2119639.37861 37.8005592082118 -122.417555094503 (37.8005592082118, -122.417555094503) 5 1 1 308 32
33924 67694 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 3330 Clay St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/13/1992 12:00:00 AM 6 3x3 Permit Number 31302 5998887.34453115 2115637.9553757 37.7890736016783 -122.447698559552 (37.7890736016783, -122.447698559552) 13 6 1 54 31
33994 12670 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1128 Lake St 1 Sidewalk: Curb side : Cutout Tree DPW 1   04/07/1998 12:00:00 AM 6 3X3   5991921.00031 2114824.39199 37.786439173997 -122.471741673868 (37.786439173997, -122.471741673868) 11 6 1 54 11
34865 40635 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 2577 Post St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/10/1999 12:00:00 AM 1   Permit Number 41635 5999855.0848 2113645.9018 37.7836592022764 -122.444207108714 (37.7836592022764, -122.444207108714) 15 6 1 29490 31
35133 36194 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 107 Spruce St 1 Sidewalk: Curb side : Cutout Tree Private 2     10   Permit Number 39260 5997029.24357 2115938.23155 37.7897917089598 -122.454149011282 (37.7897917089598, -122.454149011282) 11 6 1 54 31
35410 87680 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 2998 Larkin St 3 Sidewalk: Curb side : Cutout Tree Private 2   05/23/2008 12:00:00 AM   3x3 Permit Number 50399 6006514.3 2121415.1 37.8053691339868 -122.421720734847 (37.8053691339868, -122.421720734847) 5 1 1 28858 32
35557 34252 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 945 Bay St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/17/1998 12:00:00 AM 8   Permit Number 38731 6006224.9654 2121058.41971 37.8043734614398 -122.42269665354 (37.8043734614398, -122.42269665354) 5 1 1 28858 32
35912 24578 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 2301 Fillmore St 1 Sidewalk: Curb side : Cutout Tree DPW 1   07/12/1996 12:00:00 AM 6 3x3   6002768.23016 2116232.67907 37.7909275993488 -122.434313744932 (37.7909275993488, -122.434313744932) 13 9 1 29490 27
37483 85089 Significant Tree 6 Pyrus kawakamii :: Evergreen Pear 83 1600 Chestnut St 2 Sidewalk: Property side : Cutout Tree Private 2           6004108.1 2120157.9 37.8017812094321 -122.429957968303 (37.8017812094321, -122.429957968303) 13 9 1 57 17
37783 67598 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 3320 Clay St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/06/1992 12:00:00 AM 5   Permit Number 31166 5998906.2009 2115636.68755 37.7890711982373 -122.447633227902 (37.7890711982373, -122.447633227902) 13 6 1 54 31
38148 136224 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 3699 Divisadero St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6000162.1216 2120884.12041 37.8035509567753 -122.443665040422 (37.8035509567753, -122.443665040422) 13 9 1 57 17
38222 7333 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 2066 Fillmore St 1 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3   6002924.90365 2115430.77271 37.7887346608959 -122.433714323915 (37.7887346608959, -122.433714323915) 13 9 1 29490 27
41167 87679 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 2998 Larkin St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/23/2008 12:00:00 AM   3x3 Permit Number 50399 6006514.3 2121415.1 37.8053691339868 -122.421720734847 (37.8053691339868, -122.421720734847) 5 1 1 28858 32
42954 7334 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 2095X Fillmore St 1 Sidewalk: Curb side : Cutout Tree DPW 1     10 3X3   6002864.90775 2115441.94118 37.7887619221715 -122.433922699489 (37.7887619221715, -122.433922699489) 13 9 1 29490 27
44763 90488 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 125 25th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/27/2008 12:00:00 AM 6 3x3   5987997.51268 2115126.89685 37.7870419790043 -122.485337990995 (37.7870419790043, -122.485337990995) 11 6 1 55 33
46070 136222 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 3159 Baker St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5999346.78651 2119715.31037 37.8002951834309 -122.446402399571 (37.8002951834309, -122.446402399571) 13 9 1 57 17
46495 85086 Significant Tree 6 Pyrus kawakamii :: Evergreen Pear 83 1600 Chestnut St 2 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 49476 6004108.1 2120157.9 37.8017812094321 -122.429957968303 (37.8017812094321, -122.429957968303) 13 9 1 57 17
48787 138699 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1600 BAKER ST 4 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   6000123.7356 2114472.3378 37.785943704602 -122.443337062115 (37.785943704602, -122.443337062115) 15 6 1 29490 27
48947 136254 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 804 North Point St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6006813.5477 2121550.30022 37.8057572293748 -122.420694750958 (37.8057572293748, -122.420694750958) 5 1 1 28858 32
49392 87678 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 2998 Larkin St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/23/2008 12:00:00 AM   3x3 Permit Number 50399 6006514.3 2121415.1 37.8053691339868 -122.421720734847 (37.8053691339868, -122.421720734847) 5 1 1 28858 32
49749 104043 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1405 Greenwich St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/19/2018 12:00:00 AM 3 3x3 Permit Number 782596 6006090.81059 2119657.40346 37.8005190588724 -122.423061266572 (37.8005190588724, -122.423061266572) 13 9 1 28858 32
49819 7319 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 2011 Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6002893.06 2115234.5275 37.7881940146245 -122.433810466039 (37.7881940146245, -122.433810466039) 13 9 1 29490 27
50414 136190 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 2914 Fillmore St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 2ft   6002538.23525 2118203.76672 37.7963266398053 -122.435250565155 (37.7963266398053, -122.435250565155) 13 9 1 57 17
53938 7989 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 2148 Franklin St 1 Sidewalk: Curb side : Cutout Tree DPW 1   07/26/2012 12:00:00 AM 3 3x3   6005571.0767989 2117355.4773403 37.7941692118946 -122.4246959118 (37.7941692118946, -122.4246959118) 13 9 1 28858 27
54028 7329 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 2043 Fillmore St 1 Sidewalk: Curb side : Cutout Tree DPW 1     6     6002875.62738 2115359.09835 37.7885350652007 -122.433879687382 (37.7885350652007, -122.433879687382) 13 9 1 29490 27
58092 41239 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 270 Masonic Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   12/02/1999 12:00:00 AM     Permit Number 41940 5999013.40299918 2112000.64122659 37.7790936893244 -122.447000559943 (37.7790936893244, -122.447000559943) 15 5 1 54 16
58138 137619 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 2270 Turk Blvd 4 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   5999129.6791 2111886.0816 37.7787857805731 -122.446590070713 (37.7787857805731, -122.446590070713) 15 5 1 54 16
58587 120181 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 142 26th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   5987742.58723 2115005.98358 37.7866951312776 -122.486211085191 (37.7866951312776, -122.486211085191) 11 6 1 55 33
61599 62003 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1446 Francisco St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/18/1994 12:00:00 AM 11   Permit Number 33451 6004382.28893 2120508.49846 37.8027593860996 -122.429034158913 (37.8027593860996, -122.429034158913) 13 9 1 57 17
62118 41238 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 270 Masonic Ave 6 Sidewalk: Curb side : Cutout Tree Private 2   12/02/1999 12:00:00 AM     Permit Number 41940 5999013.40299918 2112000.64122659 37.7790936893244 -122.447000559943 (37.7790936893244, -122.447000559943) 15 5 1 54 16
62203 138286 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 2027 FILLMORE ST 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   6002884.377 2115289.0168 37.7883431356378 -122.433844403927 (37.7883431356378, -122.433844403927) 13 9 1 29490 27
63186 136258 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 2110 Leavenworth St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6007680.05725 2119655.03643 37.8006021121473 -122.417561647852 (37.8006021121473, -122.417561647852) 5 1 1 308 32
64925 24570 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 2306 Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/12/1996 12:00:00 AM 6 3X3   6002830.77987 2116250.98173 37.7909814038841 -122.434098634738 (37.7909814038841, -122.434098634738) 13 9 1 29490 27
67739 7327 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 2042 Fillmore St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6002940.62895 2115331.17345 37.7884620789862 -122.433652795594 (37.7884620789862, -122.433652795594) 13 9 1 29490 27
68326 7325 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 2027 Fillmore St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6002881.7283 2115306.8957 37.7883920762372 -122.433854846414 (37.7883920762372, -122.433854846414) 13 9 1 29490 27
68649 136200 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 2101 Beach St 4 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6000132.37327 2120911.69707 37.8036249781613 -122.443769967932 (37.8036249781613, -122.443769967932) 13 9 1 57 17
69520 136201 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 20 Retiro Way 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6001803.6012 2121217.14439 37.8045588359743 -122.438008504412 (37.8045588359743, -122.438008504412) 13 9 1 57 17
72535 41236 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 270 Masonic Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/02/1999 12:00:00 AM     Permit Number 41940 5999013.40299918 2112000.64122659 37.7790936893244 -122.447000559943 (37.7790936893244, -122.447000559943) 15 5 1 54 16
73327 123628 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 142 02nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5995232.14872 2114600.88341 37.7860165001902 -122.460269811318 (37.7860165001902, -122.460269811318) 11 6 1 54 11
73731 141309 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 74 PARKER AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   5996869.9521 2114088.2769 37.7847030919253 -122.454566442022 (37.7847030919253, -122.454566442022) 11 6 1 54 31
76645 32025 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 2431 Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/24/1995 12:00:00 AM 7 4x4 Permit Number 35414 6002714.02785707 2116573.3755444 37.7918599877301 -122.434525653083 (37.7918599877301, -122.434525653083) 13 9 1 29490 27
79252 136192 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 2914 Fillmore St 4 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 2ft   6002533.36728 2118236.78125 37.7964170126905 -122.435269772002 (37.7964170126905, -122.435269772002) 13 9 1 57 17
79823 52196 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1205 Filbert St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/19/2013 12:00:00 AM 2   Permit Number 770878 6007126.92706 2119460.55943 37.8000369880733 -122.419461903656 (37.8000369880733, -122.419461903656) 5 1 1 28858 32
81316 136197 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 2101 Beach St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6000062.25305 2120901.6465 37.8035933822804 -122.444011899049 (37.8035933822804, -122.444011899049) 13 9 1 57 17
81997 34253 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 945 Bay St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/17/1998 12:00:00 AM 7   Permit Number 38731 6006242.74242 2121059.25353 37.8043767538414 -122.422635193862 (37.8043767538414, -122.422635193862) 5 1 1 28858 32
82779 136199 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 2101 Beach St 3 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6000108.92159 2120908.29838 37.8036143086235 -122.443850879042 (37.8036143086235, -122.443850879042) 13 9 1 57 17
83246 120256 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 140 24th Ave 2 Sidewalk: Curb side : Yard Tree Private 2     8 Width 4ft   5988368.86327 2114963.36268 37.7866145875471 -122.484041219882 (37.7866145875471, -122.484041219882) 11 6 1 55 33
85156 136195 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 2848 Scott St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6001082.7933 2118171.75388 37.7961559826614 -122.44028438991 (37.7961559826614, -122.44028438991) 13 9 1 57 17
85718 137620 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 2280 Turk Blvd 5 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   5999093.1296 2111881.6822 37.7787716131699 -122.446716192654 (37.7787716131699, -122.446716192654) 15 5 1 54 16
85796 137830 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 2000 FILLMORE ST 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   6002959.8323 2115200.8411 37.7881053091283 -122.433577037034 (37.7881053091283, -122.433577037034) 13 9 1 29490 27
86325 69319 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1490 Chestnut St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/23/1994 12:00:00 AM 8   Permit Number 33400 6004756.29564 2120212.83745 37.8019687408272 -122.427718826659 (37.8019687408272, -122.427718826659) 13 9 1 57 17
89745 85085 Significant Tree 6 Pyrus kawakamii :: Evergreen Pear 83 1600 Chestnut St 1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 49476 6004108.1 2120157.9 37.8017812094321 -122.429957968303 (37.8017812094321, -122.429957968303) 13 9 1 57 17
91874 91042 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 2998 Larkin St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/10/2008 12:00:00 AM 5 3x3 Permit Number 50399 6006462.58838 2121409.81945 37.8053517187772 -122.421899314626 (37.8053517187772, -122.421899314626) 5 1 1 28858 32
91925 115210 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 115 Spruce St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   5997031.37665 2115893.5791 37.7896692276076 -122.454138404663 (37.7896692276076, -122.454138404663) 11 6 1 54 31
92002 24565 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 2117 Fillmore St 1 Sidewalk: Curb side : Cutout Tree DPW 1   07/11/1996 12:00:00 AM 3 3X3   6002846.69927 2115626.75122 37.7892683300519 -122.433998913998 (37.7892683300519, -122.433998913998) 13 9 1 29490 27
92865 3228 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 3864 California St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/21/2013 12:00:00 AM 3 3x3   5995802.3054 2114541.58405 37.785886459875 -122.458292942759 (37.785886459875, -122.458292942759) 11 6 1 54 31
92920 120248 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 164 24th Ave 3 Sidewalk: Curb side : Yard Tree Private 2     9 Width 6ft   5988365.09621 2114861.46484 37.7863345857746 -122.484046777757 (37.7863345857746, -122.484046777757) 11 6 1 55 33
93559 7320 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 2016 Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/19/1992 12:00:00 AM 7 3X3   6003001.73917 2115232.48409 37.7881945703662 -122.433434308795 (37.7881945703662, -122.433434308795) 13 9 1 29490 27
93930 136206 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 201 Laurel St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   5998023.60869 2115735.83366 37.7892929467667 -122.450694020137 (37.7892929467667, -122.450694020137) 11 6 1 54 31
94074 136220 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 2901 Steiner St 14 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6002011.27576 2118147.89877 37.7961433022242 -122.437069950312 (37.7961433022242, -122.437069950312) 13 9 1 57 17
96374 136251 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 2711 Hyde St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6006870.92139 2121576.32062 37.8058319081714 -122.420498048543 (37.8058319081714, -122.420498048543) 5 1 1 28858 32
96665 24572 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 2122 Fillmore St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/16/2013 12:00:00 AM 3 3x3   6002889.00041 2115679.48805 37.7894155324538 -122.433856328234 (37.7894155324538, -122.433856328234) 13 9 1 29490 27
96801 69357 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1355 Francisco St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/18/1994 12:00:00 AM 7   Permit Number 33448 6004836.73382 2120523.45104 37.8028261553684 -122.427462613431 (37.8028261553684, -122.427462613431) 13 9 1 57 17
98632 137889 Undocumented 4 Pyrus kawakamii :: Evergreen Pear 83 2034 FILLMORE ST 2 Sidewalk: Curb side : Cutout Tree Private 2       Width 0ft   6002935.6901 2115351.8703 37.7885186270288 -122.433671363006 (37.7885186270288, -122.433671363006) 13 9 1 29490 27

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