trees

1,985 rows where qSpecies_id = 83 sorted by XCoord

✎ View and edit SQL

This data as json, CSV (advanced)

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                    
19125 72279 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 767 41st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   6     5983194.45467 2110583.80622 37.7742869998631 -122.501619002427 (37.7742869998631, -122.501619002427) 11 6 2 55 26
161764 117917 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 767 41st Ave 2 Sidewalk: Property side : Yard Tree Private 2     6 Width 4ft   5983194.46177 2110567.54263 37.7742423451733 -122.501617774429 (37.7742423451733, -122.501617774429) 11 6 2 55 26
114935 63194 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 420 38th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/14/1991 12:00:00 AM     Permit Number 23734 5984095.68800959 2112985.55374836 37.7809343960107 -122.498678978522 (37.7809343960107, -122.498678978522) 11 6 2 55 26
27648 21211 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 2392X Sunset Blvd 14 Sidewalk: Curb side : Cutout Tree DPW 1     3 60   5984971.1169577 2098921.2732344 37.7423691180201 -122.494613333405 (37.7423691180201, -122.494613333405) 1 8 3 29491 35
126444 21209 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 2392X Sunset Blvd 12 Sidewalk: Curb side : Cutout Tree DPW 1     3 60   5984971.1169577 2098921.2732344 37.7423691180201 -122.494613333405 (37.7423691180201, -122.494613333405) 1 8 3 29491 35
188228 21208 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 2392X Sunset Blvd 11 Sidewalk: Curb side : Cutout Tree DPW 1     3 60   5984971.1169577 2098921.2732344 37.7423691180201 -122.494613333405 (37.7423691180201, -122.494613333405) 1 8 3 29491 35
8293 69460 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 446 35th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/16/1994 12:00:00 AM 3   Permit Number 33570 5985026.61463 2112867.05169 37.7806635770894 -122.495449750327 (37.7806635770894, -122.495449750327) 11 6 2 55 26
76458 24700 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 6940 Geary Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2   03/15/2006 12:00:00 AM 3 3X3   5985447.12642 2112543.37928 37.77979947939 -122.493971158415 (37.77979947939, -122.493971158415) 11 6 2 55 26
75475 69449 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 435 33rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/16/1994 12:00:00 AM 7   Permit Number 33559 5985596.63224 2112961.6611 37.7809567074922 -122.493484787172 (37.7809567074922, -122.493484787172) 11 6 2 55 26
123864 118185 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 435 33rd Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   5985597.25903 2112945.42329 37.7809121598048 -122.493481422073 (37.7809121598048, -122.493481422073) 11 6 2 55 26
131593 69456 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 471 33rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/16/1994 12:00:00 AM 5   Permit Number 33566 5985607.3929 2112736.22477 37.7803383536355 -122.493430946652 (37.7803383536355, -122.493430946652) 11 6 2 55 26
78105 181741 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1215 33rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   5985810.6327 2106942.082 37.7644411641486 -122.492301073815 (37.7644411641486, -122.492301073815) 1 8 3 56 35
120709 253166 Planning Code 138.1 required 2 Pyrus kawakamii :: Evergreen Pear 83 2405 32nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/31/2017 12:00:00 AM 3 3x3 Permit Number 778209 5986396.6612 2098868.17463 37.742306656921 -122.489680395865 (37.742306656921, -122.489680395865) 1 8 3 29491 35
194093 24686 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 6599X Geary Blvd 2 Sidewalk: Curb side : Cutout Tree Rec/Park 5   03/15/2006 12:00:00 AM 3 3X3   5986563.55545 2112507.59289 37.7797664796243 -122.490106359296 (37.7797664796243, -122.490106359296) 11 6 2 55 26
10453 75980 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 6555 Geary Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3     5986643.29892 2112486.62546 37.7797135654944 -122.489828952967 (37.7797135654944, -122.489828952967) 11 6 2 55 26
170535 107696 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 2401 MORAGA ST 4 Sidewalk: Property side : Yard Tree Private 2     3     5986802.4 2103641.7 37.7554371523715 -122.488628271884 (37.7554371523715, -122.488628271884) 1 8 3 56 35
115468 182744 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1769 30th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   5986859.8585 2103239.7166 37.7543367681172 -122.488400024275 (37.7543367681172, -122.488400024275) 1 8 3 56 35
64107 182748 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1789 30th Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   5986861.6929 2103148.806 37.7540872593532 -122.488386999785 (37.7540872593532, -122.488386999785) 1 8 3 56 35
109062 182749 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1791 30th Ave 6 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   5986862.6162 2103130.803 37.754037881879 -122.488382483852 (37.754037881879, -122.488382483852) 1 8 3 56 35
168887 181801 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1919 Santiago St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   5986905.9682 2099586.0566 37.744307492185 -122.487972126615 (37.744307492185, -122.487972126615) 1 8 3 29491 35
20922 181803 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1915 Santiago St 4 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   5986942.1793 2099588.0871 37.7443151796952 -122.487847067129 (37.7443151796952, -122.487847067129) 1 8 3 29491 35
172801 112080 Undocumented 4 Pyrus kawakamii :: Evergreen Pear 83 1901x SANTIAGO ST 2 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   5986971 2099566 37.7442562155119 -122.487745790198 (37.7442562155119, -122.487745790198) 1 8 3 29491 35
173228 112082 Undocumented 4 Pyrus kawakamii :: Evergreen Pear 83 1901x SANTIAGO ST 4 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   5986971 2099566 37.7442562155119 -122.487745790198 (37.7442562155119, -122.487745790198) 1 8 3 29491 35
8966 38869 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 2439 29th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/02/1998 12:00:00 AM     Permit Number 40694 5987327.75302366 2098677.68678111 37.7418379454862 -122.486447023752 (37.7418379454862, -122.486447023752) 1 8 3 29491 35
149168 93044 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 155 26th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     12     5987698.59819 2114939.90173 37.7865111255347 -122.486358421479 (37.7865111255347, -122.486358421479) 11 6 1 55 33
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
165912 120183 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 160 26th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   5987744.35264 2114901.48572 37.7864083129421 -122.486197303246 (37.7864083129421, -122.486197303246) 11 6 1 55 33
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
150804 182788 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1781 26th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   5988111.6274 2103184.2484 37.7542574250981 -122.484067075117 (37.7542574250981, -122.484067075117) 1 8 3 56 35
177349 182789 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1785 26th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   5988112.4655 2103151.9819 37.7541688787672 -122.484061810783 (37.7541688787672, -122.484061810783) 1 8 3 56 35
138088 182790 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1791 26th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   5988113.3036 2103133.9629 37.754119452236 -122.484057591185 (37.754119452236, -122.484057591185) 1 8 3 56 35
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
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
111047 120252 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 160 24th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     5 Width 6ft   5988365.81555 2114876.44647 37.7863757629455 -122.484045388081 (37.7863757629455, -122.484045388081) 11 6 1 55 33
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
105538 120251 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 160 24th Ave 2 Sidewalk: Curb side : Yard Tree Private 2     10 Width 6ft   5988366.40775 2114885.43189 37.7864004688283 -122.484043998399 (37.7864004688283, -122.484043998399) 11 6 1 55 33
153821 120258 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 130 24th Ave 4 Sidewalk: Curb side : Yard Tree Private 2     3 Width 4ft   5988366.4287 2115019.00218 37.7867672160285 -122.484053724446 (37.7867672160285, -122.484053724446) 11 6 1 55 33
180083 120255 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 150 24th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     3 Width 6ft   5988367.99594 2114912.99225 37.7864762341937 -122.484040525506 (37.7864762341937, -122.484040525506) 11 6 1 55 33
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
127417 120257 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 140 24th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     6 Width 4ft   5988368.87318 2114954.36452 37.7865898817391 -122.484040525506 (37.7865898817391, -122.484040525506) 11 6 1 55 33
121667 120259 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 130 24th Ave 3 Sidewalk: Curb side : Yard Tree Private 2     6 Width 4ft   5988369.32629 2115004.14379 37.7867265878172 -122.484042609601 (37.7867265878172, -122.484042609601) 11 6 1 55 33
141976 120254 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 150 24th Ave 2 Sidewalk: Curb side : Yard Tree Private 2     3 Width 6ft   5988369.36546 2114920.76145 37.7864976459369 -122.4840363573 (37.7864976459369, -122.4840363573) 11 6 1 55 33
118817 120253 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 150 24th Ave 3 Sidewalk: Curb side : Yard Tree Private 2     3 Width 6ft   5988369.64092 2114933.75275 37.7865333323848 -122.484036357305 (37.7865333323848, -122.484036357305) 11 6 1 55 33
141906 114383 Significant Tree 6 Pyrus kawakamii :: Evergreen Pear 83 418X SERRANO DR 1 Sidewalk: Curb side : Yard Tree Private 2     6     5988379 2090615 37.7197611043299 -122.482221632222 (37.7197611043299, -122.482221632222) 1 8 4 64 14
152541 114384 Significant Tree 6 Pyrus kawakamii :: Evergreen Pear 83 418X SERRANO DR 2 Front Yard : Yard Tree Private 2     6     5988379 2090615 37.7197611043299 -122.482221632222 (37.7197611043299, -122.482221632222) 1 8 4 64 14
39382 114391 Significant Tree 6 Pyrus kawakamii :: Evergreen Pear 83 23x PINTO AVE 2 Front Yard : Yard Tree Private 2     7     5988521 2090808 37.7202992922588 -122.481744923362 (37.7202992922588, -122.481744923362) 1 8 4 64 14
78664 114390 Significant Tree 6 Pyrus kawakamii :: Evergreen Pear 83 23x PINTO AVE 1 Front Yard : Yard Tree Private 2     7     5988521 2090808 37.7202992922588 -122.481744923362 (37.7202992922588, -122.481744923362) 1 8 4 64 14
99871 120310 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 120 23rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   5988691.60184 2114529.40052 37.7854418348342 -122.482892819932 (37.7854418348342, -122.482892819932) 11 6 2 55 26
136633 120315 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 206 23rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   5988712.81851 2113914.04057 37.7837534650339 -122.4827743052 (37.7837534650339, -122.4827743052) 11 6 2 55 26
142718 101280 Undocumented 4 Pyrus kawakamii :: Evergreen Pear 83 2201 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5988947 2106461 37.7633031017087 -122.481418135942 (37.7633031017087, -122.481418135942) 1 8 3 56 35
93256 120438 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 123 22nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   5988956.31634 2114501.16974 37.7853797200377 -122.481974928571 (37.7853797200377, -122.481974928571) 11 6 2 55 26
15192 65109 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 145 22nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/24/1989 12:00:00 AM 5   Permit Number 27078 5988958.23473 2114388.99376 37.7850718280894 -122.481960071321 (37.7850718280894, -122.481960071321) 11 6 2 55 26
117418 64667 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 155 22nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/24/1989 12:00:00 AM 7   Permit Number 27077 5988959.0752 2114316.04033 37.7848715674717 -122.481951817597 (37.7848715674717, -122.481951817597) 11 6 2 55 26
48344 65108 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 183 22nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/24/1989 12:00:00 AM 6   Permit Number 27075 5988968.22756 2114128.63613 37.7843575407485 -122.481906421224 (37.7843575407485, -122.481906421224) 11 6 2 55 26
166404 3372 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 5951 California St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 3X3   5989085.57316 2113985.01381 37.7839700180526 -122.481489929013 (37.7839700180526, -122.481489929013) 11 6 2 55 26
144958 120776 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 57 21st Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5989252.7771 2114825.68271 37.7862879782034 -122.48097304382 (37.7862879782034, -122.48097304382) 11 6 1 55 33
120392 120778 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 57 21st Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   5989252.84217 2114809.14521 37.7862425746859 -122.480971607416 (37.7862425746859, -122.480971607416) 11 6 1 55 33
119489 120777 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 57 21st Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   5989253.41901 2114816.78103 37.7862635740202 -122.480970171004 (37.7862635740202, -122.480970171004) 11 6 1 55 33
144919 120775 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 57 21st Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5989253.50277 2114844.12588 37.7863386601165 -122.48097188408 (37.7863386601165, -122.48097188408) 11 6 1 55 33
170159 120774 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 57 21st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5989253.85466 2114850.93568 37.7863573783569 -122.480971165425 (37.7863573783569, -122.480971165425) 11 6 1 55 33
156114 65118 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 127 21st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/24/1989 12:00:00 AM 4   Permit Number 27088 5989266.29156 2114491.83499 37.7853721122289 -122.480901836159 (37.7853721122289, -122.480901836159) 11 6 2 55 26
170284 65116 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 130 21st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/24/1989 12:00:00 AM 3   Permit Number 27086 5989313.29751 2114460.89745 37.7852898986689 -122.480736945877 (37.7852898986689, -122.480736945877) 11 6 2 55 26
87033 65112 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 367 21st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/24/1989 12:00:00 AM 9   Permit Number 27081 5989323.93516 2112879.29731 37.7809478872799 -122.48058432391 (37.7809478872799, -122.48058432391) 11 6 2 55 26
11017 88581 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 515 21st Ave   Sidewalk: Curb side : Cutout Tree Private 2   07/31/2008 12:00:00 AM 5 3x3 Permit Number 51523 5989364.70117 2111797.63767 37.777980320812 -122.480364100125 (37.777980320812, -122.480364100125) 11 6 2 55 26
80341 183007 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 2440 22nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   5989549.7088 2098739.1145 37.7421358774653 -122.478768805014 (37.7421358774653, -122.478768805014) 1 8 3 29491 35
190332 49548 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 2434@ TARAVAL 21st Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2003 12:00:00 AM 1   Permit Number 46439 5989857.9655 2098790.1552 37.742293916006 -122.477706691652 (37.742293916006, -122.477706691652) 1 8 3 29491 35
150279 49549 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 2434@ TARAVAL 21st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/29/2003 12:00:00 AM 3   Permit Number 46439 5989858.6972 2098774.0563 37.7422497550695 -122.47770298517 (37.7422497550695, -122.47770298517) 1 8 3 29491 35
13494 83178 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 743 19th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/31/2019 12:00:00 AM 3 3x3 Permit Number 51518 5990037.32656 2110290.06846 37.7738800155956 -122.477927036337 (37.7738800155956, -122.477927036337) 11 6 2 55 26
1477 112866 Undocumented 4 Pyrus kawakamii :: Evergreen Pear 83 750 VICENTE ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5990595 2097751 37.7394834085128 -122.475082436927 (37.7394834085128, -122.475082436927) 1 8 4 29491 40
100392 112868 Undocumented 4 Pyrus kawakamii :: Evergreen Pear 83 750 VICENTE ST 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5990595 2097751 37.7394834085128 -122.475082436927 (37.7394834085128, -122.475082436927) 1 8 4 29491 40
119482 112867 Undocumented 4 Pyrus kawakamii :: Evergreen Pear 83 750 VICENTE ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5990595 2097751 37.7394834085128 -122.475082436927 (37.7394834085128, -122.475082436927) 1 8 4 29491 40
122755 112869 Undocumented 4 Pyrus kawakamii :: Evergreen Pear 83 750 VICENTE ST 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5990595 2097751 37.7394834085128 -122.475082436927 (37.7394834085128, -122.475082436927) 1 8 4 29491 40
128079 112864 Undocumented 4 Pyrus kawakamii :: Evergreen Pear 83 750 VICENTE ST 1 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   5990595 2097751 37.7394834085128 -122.475082436927 (37.7394834085128, -122.475082436927) 1 8 4 29491 40
149307 112865 Undocumented 4 Pyrus kawakamii :: Evergreen Pear 83 750 VICENTE ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5990595 2097751 37.7394834085128 -122.475082436927 (37.7394834085128, -122.475082436927) 1 8 4 29491 40
40500 121918 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 434 17th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 1ft   5990628.47281 2112418.69115 37.7797589204997 -122.47603768167 (37.7797589204997, -122.47603768167) 11 6 2 54 26
35148 69289 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 1900 18th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/09/1994 12:00:00 AM     Permit Number 33361 5990665.04614057 2102443.50433652 37.7523718663796 -122.475182730707 (37.7523718663796, -122.475182730707) 1 8 4 29491 12
132880 60149 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 1719 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/28/1982 12:00:00 AM     Permit Number 19680 5990880.97000409 2103694.68949662 37.7558198040644 -122.474527341121 (37.7558198040644, -122.474527341121) 1 8 4 56 12
77314 60150 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 1767 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/28/1982 12:00:00 AM     Permit Number 19681 5990891.54356846 2103381.184277 37.754959614042 -122.474467896907 (37.754959614042, -122.474467896907) 1 8 4 56 12
20110 56158 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 447 16th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/02/1973 12:00:00 AM 8   Permit Number 12266 5990893.79558 2112339.92163 37.7795580220906 -122.475114071606 (37.7795580220906, -122.475114071606) 11 6 2 54 26
41785 213911 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1767 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 2ft   5990895.24857 2103389.01356 37.7549813258512 -122.474455655417 (37.7549813258512, -122.474455655417) 1 8 4 56 12
91449 122099 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 451 16th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   5990895.26927 2112314.80254 37.7794891374062 -122.47510713931 (37.7794891374062, -122.47510713931) 11 6 2 54 26
21516 43755 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 264 16th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/26/2000 12:00:00 AM 3   Permit Number 43391 5990896.10038 2113625.86147 37.783088990728 -122.475200003572 (37.783088990728, -122.475200003572) 11 6 2 54 26
99471 56156 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 471 16th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/02/1973 12:00:00 AM 12   Permit Number 12264 5990899.19855 2112188.99411 37.7791439298602 -122.475084359841 (37.7791439298602, -122.475084359841) 11 6 2 54 26
101218 56218 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 475 16th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/03/1973 12:00:00 AM 9   Permit Number 12339 5990899.77179 2112161.89837 37.779069565646 -122.475080398267 (37.779069565646, -122.475080398267) 11 6 2 54 26
72928 56219 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 479 16th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/03/1973 12:00:00 AM 6   Permit Number 12340 5990900.94141 2112135.93012 37.7789983317715 -122.475074455932 (37.7789983317715, -122.475074455932) 11 6 2 54 26
167805 56220 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 483 16th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/03/1973 12:00:00 AM 10   Permit Number 12342 5990901.62894 2112114.24855 37.7789388399986 -122.475070494342 (37.7789388399986, -122.475070494342) 11 6 2 54 26
22264 60143 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 1610 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/28/1982 12:00:00 AM     Permit Number 19673 5990907.91625844 2104426.54438296 37.7578308453136 -122.474487560238 (37.7578308453136, -122.474487560238) 1 8 4 56 12
96995 60145 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 1622 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/28/1982 12:00:00 AM     Permit Number 19675 5990910.59858922 2104348.57566212 37.757616919266 -122.474472593844 (37.757616919266, -122.474472593844) 1 8 4 56 12
38017 122096 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 515 16th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   5990911.76477 2111862.01127 37.7782468532741 -122.475017013162 (37.7782468532741, -122.475017013162) 11 6 2 54 26
120079 60148 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 1718 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/28/1982 12:00:00 AM     Permit Number 19679 5990932.94045417 2103696.44229965 37.7558276278389 -122.474347740223 (37.7558276278389, -122.474347740223) 1 8 4 56 12

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