Street_Tree_List

Data source: data.sfgov.org

616 rows where qSpecies = 45 sorted by Longitude

View and edit SQL

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH, PlotSize

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude ▼ Location
10851 52794 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 1277TEHAMA Houston St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/25/2006 12:00:00 AM     Permit Number 48833          
10944 35742 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45   2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/15/1998 12:00:00 AM     Permit Number 39016          
10980 52793 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 1277TEHAMA Houston St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/25/2006 12:00:00 AM     Permit Number 48833          
13065 52792 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 1277TEHAMA Houston St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/25/2006 12:00:00 AM     Permit Number 48833          
14122 35743 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/15/1998 12:00:00 AM     Permit Number 39016          
155906 183281 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 1267 48th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 0ft   5981168.1745 2106457.5745 37.762838347579006 -122.50832180491899 (37.762838347579, -122.508321804919)
128890 83492 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 2040 Great Hwy 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/24/2008 12:00:00 AM   3x3 Permit Number 50186 5981220.21812771 2101179.004699 37.748347964766396 -122.50775007916 (37.7483479647664, -122.50775007916)
48473 92109 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 654 46th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/02/2009 12:00:00 AM 3 3x3 Permit Number 52365 5981669.51861 2111284.19832 37.7761203861627 -122.506945906937 (37.7761203861627, -122.506945906937)
46879 52639 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 1634 47th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/08/2006 12:00:00 AM 3   Permit Number 48720 5981612.27437325 2103952.63979264 37.7559866741692 -122.506600058306 (37.7559866741692, -122.506600058306)
182997 184434 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 3816 Quintara St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   5981590.8846 2100821.8038 37.7473890220179 -122.506441860059 (37.7473890220179, -122.506441860059)
105121 69026 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 3826 Quintara St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/05/1994 12:00:00 AM     Permit Number 33030 5981605.36463184 2100817.40426398 37.7473777946481 -122.506391463775 (37.7473777946481, -122.506391463775)
187103 184430 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 3808 Quintara St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 0ft   5981643.6784 2100823.1575 37.747395847077996 -122.50625940628099 (37.747395847078, -122.506259406281)
95536 69021 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 2095 47th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/05/1994 12:00:00 AM     Permit Number 33025 5981665.37116425 2100840.03174895 37.747443456100704 -122.506185646516 (37.7474434561007, -122.506185646516)
152254 183295 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 1262 46th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   5981829.8203 2106490.9182 37.762968869451896 -122.50603591567899 (37.7629688694519, -122.506035915679)
41992 118563 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 8000 Geary Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   5982185.81739 2112405.54556 37.7792296683273 -122.50524304882099 (37.7792296683273, -122.505243048821)
68181 47745 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 4201 Clement St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/30/2002 12:00:00 AM 5   Permit Number 45527 5982377.51547 2113061.47559 37.7810419369254 -122.50462850953998 (37.7810419369254, -122.50462850954)
63294 47746 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 4201 Clement St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/30/2002 12:00:00 AM 6   Permit Number 45527 5982405.06542 2113061.4232400004 37.781043413721704 -122.50453319829201 (37.7810434137217, -122.504533198292)
27615 47743 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 4201 Clement St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/30/2002 12:00:00 AM 6   Permit Number 45527 5982418.5702 2113061.40286 37.78104415210971 -122.50448647782 (37.7810441521097, -122.50448647782)
161972 47744 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 4201 Clement St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/30/2002 12:00:00 AM 5   Permit Number 45527 5982434.29257 2113064.02501 37.7810522765206 -122.504432281557 (37.7810522765206, -122.504432281557)
68882 184399 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 2085 45th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 0ft   5982287.3567 2100926.0377 37.7477162005877 -122.50404126767499 (37.7477162005877, -122.504041267675)
173420 184400 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 2087 45th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 0ft   5982288.7103 2100911.824 37.747677253327 -122.504035534429 (37.747677253327, -122.504035534429)
159848 184401 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 2089 45th Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 0ft   5982289.7256 2100897.9487 37.74763921532389 -122.504030996054 (37.7476392153239, -122.504030996054)
168193 184402 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 2091 45th Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   5982290.4025 2100883.0582 37.7475983699641 -122.50402755264601 (37.7475983699641, -122.504027552646)
42735 69006 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 2111 45th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/05/1994 12:00:00 AM 3   Permit Number 33007 5982290.62244002 2100729.28975496 37.7471761775601 -122.504015404359 (37.7471761775601, -122.504015404359)
36146 69007 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 2115 45th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/05/1994 12:00:00 AM 0   Permit Number 33008 5982291.49205895 2100703.22551621 37.7471046635524 -122.504010467091 (37.7471046635524, -122.504010467091)
31223 184437 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 2115 45th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 0ft   5982295.3096 2100678.1438 37.7470360206297 -122.50399540910401 (37.7470360206297, -122.503995409104)
91660 87934 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 3600 Quintara St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/18/2008 12:00:00 AM   3x3 Permit Number 50956 5982309.0 2100840.0 37.7474812377595 -122.503960055968 (37.7474812377595, -122.503960055968)
98152 87936 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 3600 Quintara St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/18/2008 12:00:00 AM   3x3 Permit Number 50956 5982309.0 2100840.0 37.7474812377595 -122.503960055968 (37.7474812377595, -122.503960055968)
141514 87935 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 3600 Quintara St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/18/2008 12:00:00 AM   3x3 Permit Number 50956 5982309.0 2100840.0 37.7474812377595 -122.503960055968 (37.7474812377595, -122.503960055968)
147113 184465 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 2182 45th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 0ft   5982354.8718 2100269.3302 37.745917034436296 -122.503759179813 (37.7459170344363, -122.503759179813)
32269 69005 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 2087 44th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/05/1994 12:00:00 AM 0   Permit Number 33006 5982594.36064133 2100924.19223319 37.7477291823956 -122.50297954562099 (37.7477291823956, -122.502979545621)
122 183689 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 1341 42nd Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 0ft   5983043.6112 2105976.497 37.761627789464704 -122.501799836383 (37.7616277894647, -122.501799836383)
86977 122462 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 1351 42nd Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1         5983044.58583163 2105938.11904156 37.7615224717284 -122.501793626008 (37.7615224717284, -122.501793626008)
75380 40197 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 4845 Anza St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/30/1999 12:00:00 AM 5   Permit Number 41381 5983545.15866 2111697.12052 37.7773644306872 -122.50048820674401 (37.7773644306872, -122.500488206744)
156274 40198 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 4845 Anza St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/30/1999 12:00:00 AM 4   Permit Number 41381 5983564.00887 2111698.1064299997 37.7773682442298 -122.500423071675 (37.7773682442298, -122.500423071675)
185576 183218 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 3150 Rivera St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 0ft   5983331.3887 2100197.9386 37.7457783815563 -122.50037729543199 (37.7457783815563, -122.500377295432)
119499 40199 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 4845 Anza St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/30/1999 12:00:00 AM 5   Permit Number 41381 5983584.60152 2111699.05511 37.7773720577908 -122.500351906273 (37.7773720577908, -122.500351906273)
29223 183217 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 3150 Rivera St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 0ft   5983341.801 2100199.14 37.7457822914528 -122.50034138058201 (37.7457822914528, -122.500341380582)
58725 82802 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 770 40th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/07/2009 12:00:00 AM   3x3 Permit Number 52410 5983565.30013547 2110567.26400669 37.7742633542941 -122.500334977362 (37.7742633542941, -122.500334977362)
108701 72276 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 770 40th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/07/2009 12:00:00 AM   3x3 Permit Number 52410 5983565.30013547 2110567.26400669 37.7742633542941 -122.500334977362 (37.7742633542941, -122.500334977362)
168473 183216 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 3150 Rivera St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   5983362.6255 2100199.941 37.7457857131054 -122.500269432817 (37.7457857131054, -122.500269432817)
183050 69147 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 2474 42nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/29/2008 12:00:00 AM 2 3x3 Permit Number 50209 5983357.92346724 2098305.86052221 37.7405848112735 -122.50014569422399 (37.7405848112735, -122.500145694224)
128753 29219 DPW Maintained 3 Rhamnus alaternus :: Italian Buckthorn 45 1902X 41st Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 3X3   5983534.517682901 2102185.1808128003 37.7512467209802 -122.499821775189 (37.7512467209802, -122.499821775189)
149292 64781 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 3801 Balboa St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/20/1996 12:00:00 AM 4   Permit Number 25773 5983728.64713 2111021.26009 37.7755194830569 -122.499803502734 (37.7755194830569, -122.499803502734)
173280 117792 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 3801 Balboa St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5983744.15991 2111021.91382 37.775522188312394 -122.499749889479 (37.7755221883124, -122.499749889479)
153549 184960 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 1990 41st Ave 18 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 0ft   5983549.8392 2101614.3877 37.7496803803898 -122.499726609203 (37.7496803803898, -122.499726609203)
104373 100234 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 701X 39th Ave 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 3x3   5983811.49615 2110876.46915 37.7751267903243 -122.499506209788 (37.7751267903243, -122.499506209788)
169354 117837 DPW Maintained 3 Rhamnus alaternus :: Italian Buckthorn 45 660x 39th Ave 2 Median : Cutout 11 Tree 1 DPW 2     7 Width 6ft   5983820.01458 2111273.2343900003 37.776216692790705 -122.49950607144899 (37.7762166927907, -122.499506071449)
80692 100236 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 701X 39th Ave 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3x3   5983814.22353 2110811.1524900002 37.7749476096575 -122.499491947241 (37.7749476096575, -122.499491947241)
91393 100238 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 701X 39th Ave 11 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 3x3   5983814.58777 2110777.43528 37.774855053302495 -122.499488194975 (37.7748550533025, -122.499488194975)
115944 69045 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 1490 39th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/06/1994 12:00:00 AM 5   Permit Number 33052 5984059.2399452 2105030.87804217 37.7590909914126 -122.498217402727 (37.7590909914126, -122.498217402727)
118316 69032 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 1306 38th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/06/1994 12:00:00 AM     Permit Number 33038 5984326.99960905 2106268.60698724 37.76250514437871 -122.49738275102699 (37.7625051443787, -122.497382751027)
171218 69041 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 1481 38th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/06/1994 12:00:00 AM 2   Permit Number 33048 5984315.00463023 2105104.8689211 37.7593091431589 -122.497338322577 (37.7593091431589, -122.497338322577)
43449 69150 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 3826 Ulloa St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/18/1994 12:00:00 AM 4   Permit Number 33185 5984181.23627049 2098183.21295551 37.7402963417492 -122.49728998800501 (37.7402963417492, -122.497289988005)
145225 186232 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 1701 Sunset Blvd 43 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 0ft   5984802.7052 2103358.5602 37.754542835963505 -122.49552284211201 (37.7545428359635, -122.495522842112)
175663 186234 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 1701 Sunset Blvd 45 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984803.2409 2103355.3462 37.7545340425765 -122.495520752512 (37.7545340425765, -122.495520752512)
66165 186237 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 1701 Sunset Blvd 48 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5984808.8655 2103347.0431 37.7545115739121 -122.495500689099 (37.7545115739121, -122.495500689099)
37930 186236 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 1701 Sunset Blvd 47 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5984809.6691 2103350.7929 37.75452191688171 -122.495498186629 (37.7545219168817, -122.495498186629)
135840 117962 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 4340 Anza St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 4ft   5985111.43248 2111810.6865 37.7777680685843 -122.495078411045 (37.7777680685843, -122.495078411045)
157979 89252 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 433 34th Ave   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/14/2008 12:00:00 AM 4 4x4 Permit Number 51885 5985288.27991 2112944.4922700003 37.780891524599 -122.49455024837 (37.780891524599, -122.49455024837)
10245 43062 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 490 34th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/10/2017 12:00:00 AM 3 3x3 Permit Number 51464 5985348.18764 2112571.6735099996 37.779871377757296 -122.49431551232401 (37.7798713777573, -122.494315512324)
33040 185413 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 2300 Sunset Blvd 29 unknown : Yard 19 Tree 1 Private 1     4 Width 0ft   5985092.6382 2099208.8841 37.7431659316065 -122.49421435006501 (37.7431659316065, -122.494214350065)
162943 185411 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 2300 Sunset Blvd 26 unknown : Yard 19 Tree 1 Private 1     10 Width 0ft   5985100.1361 2099184.3909 37.7430991186582 -122.49418661978599 (37.7430991186582, -122.494186619786)
45898 78303 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 4200 Anza St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/22/2000 12:00:00 AM 8     5985601.84615 2111830.0583200003 37.7778499560934 -122.493383352985 (37.7778499560934, -122.493383352985)
175872 78389 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 4200 Anza St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/22/2000 12:00:00 AM 8     5985613.90998 2111830.68363 37.77785237866 -122.49334166667101 (37.77785237866, -122.493341666671)
137156 118182 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 615 33rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5985646.494109999 2111667.23632 37.7774055049593 -122.493216904169 (37.7774055049593, -122.493216904169)
176744 32595 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 1383 34th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/22/1996 12:00:00 AM 2   Permit Number 37063 5985531.94877095 2105814.83097448 37.7613297510328 -122.49318190152901 (37.7613297510328, -122.493181901529)
66939 32596 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 1474 34th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/22/1996 12:00:00 AM 2   Permit Number 37064 5985605.53989408 2105188.12612078 37.759613297357895 -122.492881221287 (37.7596132973579, -122.492881221287)
54735 32597 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 1478 34th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/22/1996 12:00:00 AM 2   Permit Number 37065 5985606.43921528 2105161.9851204 37.759541574007 -122.492876185531 (37.759541574007, -122.492876185531)
29717 32611 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 2926 Kirkham St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/23/1996 12:00:00 AM 0   Permit Number 37076 5985807.8579886 2105043.58172562 37.7592282476447 -122.492170870983 (37.7592282476447, -122.492170870983)
182568 33177 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 3245 Ulloa St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/05/1996 12:00:00 AM 4 3.5x5 Permit Number 37389 5985988.52360796 2098193.06286983 37.740429143118206 -122.491041921171 (37.7404291431182, -122.491041921171)
54592 32576 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 1366 32nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/22/1996 12:00:00 AM 2   Permit Number 37050 5986201.05883385 2105941.9596711 37.7617179230551 -122.49087711798 (37.7617179230551, -122.49087711798)
172410 69309 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 1554 30th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/16/1994 12:00:00 AM 3   Permit Number 33388 5986865.46516485 2104681.03924788 37.7582945739882 -122.488486559119 (37.7582945739882, -122.488486559119)
169430 42275 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 1522 29th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/23/2000 12:00:00 AM 4   Permit Number 42512 5987167.45157267 2104900.21174724 37.7589139779601 -122.48745827105 (37.7589139779601, -122.48745827105)
178425 42274 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 1522 29th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/23/2000 12:00:00 AM 5   Permit Number 42512 5987167.45157267 2104900.21174724 37.7589139779601 -122.48745827105 (37.7589139779601, -122.48745827105)
188506 84809 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 648 27th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/03/2007 12:00:00 AM 3   Permit No. 49264 5987557.75332 2111531.90689 37.7771455293989 -122.486595377302 (37.7771455293989, -122.486595377302)
130691 30907 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 2363 29th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/05/1996 12:00:00 AM 4   Permit Number 37373 5987310.298054401 2099201.63941585 37.743275562979605 -122.486545838163 (37.7432755629796, -122.486545838163)
40074 181349 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 2254 29th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 0ft   5987333.026000001 2099936.24 37.745293905616705 -122.48652117681601 (37.7452939056167, -122.486521176816)
50005 181948 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 1813 Taraval St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 0ft   5987556.2457 2098923.5959 37.742526463070796 -122.48567502435301 (37.7425264630708, -122.485675024353)
102768 88618 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 1815 Taraval St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/04/2008 12:00:00 AM 4 3x3 Permit Number 51591 5987609.0 2098941.0 37.7425773238376 -122.485493894781 (37.7425773238376, -122.485493894781)
25175 34531 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 635 24th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/22/1997 12:00:00 AM 5   Permit Number 38240 5988437.8449 2111647.649 37.7775145896121 -122.483559386935 (37.7775145896121, -122.483559386935)
62331 70121 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 2220 Cabrillo St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/17/1996 12:00:00 AM 4     5988662.200680001 2110577.24438 37.7745886129839 -122.48270481422199 (37.7745886129839, -122.482704814222)
84043 73758 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 2220 Cabrillo St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/17/1996 12:00:00 AM 6     5988694.038819999 2110577.4842 37.774591123751605 -122.48259469871799 (37.7745911237516, -122.482594698718)
147943 95925 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 467 23rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/29/2011 12:00:00 AM 4 3x3 Permit Number 767622 5988731.71404 2112146.6899 37.7789019165926 -122.482579385158 (37.7789019165926, -122.482579385158)
130949 181350 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 2270 25th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 0ft   5988575.9018 2099879.6972 37.745211025577895 -122.48221942866999 (37.7452110255779, -122.48221942867)
149259 181332 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 1458 24th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 0ft   5988697.9248 2105396.3508 37.760365379214605 -122.482201591019 (37.7603653792146, -122.482201591019)
74893 73753 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 2019 Balboa St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/17/1996 12:00:00 AM 7     5989295.11737 2111227.81825 37.7764117112404 -122.480563089536 (37.7764117112404, -122.480563089536)
52507 72377 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 2015 Balboa St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/17/1996 12:00:00 AM 3     5989328.1004 2111226.70664 37.776410575889 -122.480448911859 (37.776410575889, -122.480448911859)
169846 181318 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 1283 22nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 0ft   5989233.022000001 2106632.6794 37.7637911125829 -122.480441458463 (37.7637911125829, -122.480441458463)
185994 181319 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 1283 22nd Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 0ft   5989233.7879 2106609.7025 37.7637280687606 -122.48043712751101 (37.7637280687606, -122.480437127511)
143720 42161 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 2010 Balboa St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/21/2000 12:00:00 AM     Permit Number 42456 5989367.84309334 2111281.28093807 37.776562731283796 -122.480315427669 (37.7765627312838, -122.480315427669)
38309 120769 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 4500 Fulton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5989405.82896 2109925.10593 37.7728412569544 -122.48008475013701 (37.7728412569544, -122.480084750137)
55875 61446 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 167 20th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/24/2005 12:00:00 AM 4   Permit Number 48286 5989582.2838 2114261.13607 37.7847570404878 -122.479791723267 (37.7847570404878, -122.479791723267)
35612 72078 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 167 20th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/14/1984 12:00:00 AM 5     5989583.57132 2114255.42421 37.784741432124 -122.479786850818 (37.784741432124, -122.479786850818)
135718 43234 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 1442 21st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/12/2000 12:00:00 AM 0   Permit Number 43021 5989629.54713999 2105535.31198119 37.760801073285705 -122.478989743073 (37.7608010732857, -122.478989743073)
98519 101262 Undocumented 2 Rhamnus alaternus :: Italian Buckthorn 45 1948 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5989728.00904 2106533.07201 37.76354637066729 -122.47872218339701 (37.7635463706673, -122.478722183397)
66650 38870 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 1551 Judah St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/12/2000 12:00:00 AM 2   Permit Number 43029 5989746.74182688 2105808.42580632 37.7615577752966 -122.47860439661501 (37.7615577752966, -122.478604396615)
159224 38871 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 1551 Judah St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/02/1998 12:00:00 AM 2   Permit Number 40696 5989746.74182688 2105808.42580632 37.7615577752966 -122.47860439661501 (37.7615577752966, -122.478604396615)
82592 38845 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 1333 20th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/02/1998 12:00:00 AM     Permit Number 40675 5989863.06342131 2106288.82741716 37.76288358166779 -122.47823721882601 (37.7628835816678, -122.478237218826)
134013 43231 Permitted Site 1 Rhamnus alaternus :: Italian Buckthorn 45 1371 20th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/12/2000 12:00:00 AM 3   Permit Number 43018 5989871.41437878 2106041.52738456 37.7622050471688 -122.47819025383801 (37.7622050471688, -122.478190253838)

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" TEXT,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" TEXT,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");
Powered by Datasette · Query took 434.297ms · Data source: data.sfgov.org