home / trees

Street_Tree_List

Data source: data.sfgov.org

2,194 rows where qSpecies = 12

View and edit SQL

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, Fire Prevention Districts, Police Districts, Supervisor Districts, Zip Codes

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
45 10004 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 12 150 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     28 3X3   6005403.33839 2108127.1988 37.768821154693896 -122.424619539876 (37.7688211546939, -122.424619539876) 8 4 5 28853 19
117 10011 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 12 198 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     25 2X3   6005417.15338 2107897.14895 37.76819027309789 -122.424555388522 (37.7681902730979, -122.424555388522) 8 4 5 28853 19
137 10013 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 12 215 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     12 3x2   6005495.275 2107715.11687 37.7676948680391 -122.42427222529899 (37.7676948680391, -122.424272225299) 8 4 5 28853 19
213 10021 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 12 274 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     17 3x4   6005443.44254 2107417.66285 37.7668752034469 -122.424430347706 (37.7668752034469, -122.424430347706) 8 4 5 28853 19
230 100230 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 12 701X 39th Ave 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3 3x3   5983807.86909 2110960.60417 37.7753575879766 -122.49952497559799 (37.7753575879766, -122.499524975598) 11 6 2 55 26
232 100232 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 12 701X 39th Ave 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3 3x3   5983809.619390001 2110917.38856 37.775239033091104 -122.499515726535 (37.7752390330911, -122.499515726535) 11 6 2 55 26
301 10031 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 12 310 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     100 2x3   6005459.49344 2107143.4221799998 37.7661231103266 -122.42435532265301 (37.7661231103266, -122.424355322653) 8 4 5 28853 19
497 10055 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 12 432 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     90 3X2   6005503.26278 2106415.24362 37.7641261764966 -122.424152141508 (37.7641261764966, -122.424152141508) 8 4 5 28859 19
526 10058 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 12 451 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     18 3x5   6005573.3175800005 2106314.3851 37.763853198087 -122.4239026696 (37.763853198087, -122.4239026696) 8 4 5 28859 19
642 10072 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 12 573 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     12 3x3   6005609.84736 2105668.09746 37.7620807071743 -122.423730368485 (37.7620807071743, -122.423730368485) 8 4 5 28859 19
667 10075 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 12 595 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     12 2x2   6005616.34075 2105560.18901 37.7617847825636 -122.423700237591 (37.7617847825636, -122.423700237591) 8 4 5 28859 19
697 10078 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 12 615 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     12 3x3   6005625.0168 2105365.53505 37.761250798395295 -122.42365639023599 (37.7612507983953, -122.423656390236) 2 4 5 28859 19
911 10105 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 12 779 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   03/07/2016 12:00:00 AM 18 4x4   6005674.55908 2104459.44386 37.7587656810971 -122.42342062756201 (37.7587656810971, -122.423420627562) 2 4 5 28859 19
950 101107 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 12 1790 24th Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     5 3X3 Permit Number 14067 5988779.1453 2103160.9003 37.7542321578078 -122.48175694812299 (37.7542321578078, -122.481756948123) 1 8 3 56 35
951 101108 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 12 1790 24th Ave 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     2 3X3 Permit Number 14067 5988777.5028 2103198.1315 37.754334289199704 -122.481765355128 (37.7543342891997, -122.481765355128) 1 8 3 56 35
952 101109 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 12 1790 24th Ave 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3 3X3 Permit Number 14067 5988776.9552 2103216.747 37.754385370533704 -122.48176861229099 (37.7543853705337, -122.481768612291) 1 8 3 56 35
989 101143 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 12 450 Connecticut St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     6 2x2   6013205.5803 2104971.74956 37.760594538837296 -122.397410636805 (37.7605945388373, -122.397410636805) 10 3 8 28856 29
990 101144 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 12 450 Connecticut St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     2 2x2   6013206.1129 2104955.38983 37.7605496482619 -122.397407647447 (37.7605496482619, -122.397407647447) 10 3 8 28856 29
991 101145 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 12 450 Connecticut St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     5 2x2   6013204.93498 2104939.92488 37.7605071193183 -122.397410636789 (37.7605071193183, -122.397410636789) 10 3 8 28856 29
1088 101245 Permitted Site 2 Ligustrum lucidum :: Glossy Privet 12 1301X 08th Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   06/28/1972 12:00:00 AM     Permit Number 9950 5993577.2 2106568.3 37.763865841987204 -122.465411719392 (37.7638658419872, -122.465411719392) 1 8 11 56 12
1103 101260 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 12 1900 Irving St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     12 3x3   5989805.9135 2106546.133 37.7635867556905 -122.47845369468399 (37.7635867556905, -122.478453694684) 1 8 3 56 35
1104 101261 Undocumented 3 Ligustrum lucidum :: Glossy Privet 12 1945 Irving St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   5989742.0 2106485.0 37.763415190264894 -122.478670277794 (37.7634151902649, -122.478670277794) 1 8 3 56 35
1108 101265 Undocumented 3 Ligustrum lucidum :: Glossy Privet 12 2034 Irving St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   5989459.10715 2106523.8610900003 37.7635054630097 -122.47965154526001 (37.7635054630097, -122.47965154526) 1 8 3 56 35
1109 101266 Undocumented 3 Ligustrum lucidum :: Glossy Privet 12 2126 Irving St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   5989175.0 2106519.0 37.7634756077712 -122.48063381405599 (37.7634756077712, -122.480633814056) 1 8 3 56 35
1120 101277 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 12 2323 Irving St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     6 3x3   5988481.6146 2106443.4757 37.7632279152074 -122.48302644728001 (37.7632279152074, -122.48302644728) 1 8 3 56 35
1121 101278 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 12 2323 Irving St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     11 3x3   5988527.6084 2106443.4757 37.763230591454395 -122.482867371906 (37.7632305914544, -122.482867371906) 1 8 3 56 35
1124 101281 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 12 2049 Irving St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     4 3x3   5989322.9543 2106470.5284 37.763351115778796 -122.48011854571301 (37.7633511157788, -122.480118545713) 1 8 3 56 35
1127 101284 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 12 2034 Irving St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     6 3x3   5989388.4992 2106533.1127 37.7635267635243 -122.479896429915 (37.7635267635243, -122.479896429915) 1 8 3 56 35
1133 10129 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 12 892 Guerrero St 3 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     40 3X3   6005646.9391641 2103763.6492254 37.7568536327232 -122.42346668441999 (37.7568536327232, -122.42346668442) 2 4 5 28859 19
1236 101406 Undocumented 3 Ligustrum lucidum :: Glossy Privet 12 50-52 Ramona Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   09/29/2012 12:00:00 AM 12 3x3 Permit Number 769364 6005160.9 2107520.2 37.7671407866326 -122.425414915098 (37.7671407866326, -122.425414915098) 8 4 5 28853 19
1261 10143 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 12 920 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     12 3x3   6005657.84848 2103570.5399700003 37.7563240154596 -122.423415228047 (37.7563240154596, -122.423415228047) 2 4 5 28859 19
1313 101482 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 12 1021 Rhode Island St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     18 3x3   6011947.177080001 2103416.1545 37.7562530733255 -122.401653568078 (37.7562530733255, -122.401653568078) 10 3 8 28856 29
1386 10157 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 12 995 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     12 3x3   6005745.7610599995 2103227.37374 37.755386722241504 -122.42308680461201 (37.7553867222415, -122.423086804612) 2 4 5 28859 19
1397 10158 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 12 1001 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     6 3x3   6005753.82676 2103093.98635 37.7550209265961 -122.423049430612 (37.7550209265961, -122.423049430612) 2 4 5 28859 19
1432 10162 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 12 1013 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     12 2x2   6005758.27618 2103002.2349099996 37.7547692495131 -122.42302752222099 (37.7547692495131, -122.423027522221) 2 4 5 28859 19
1441 10163 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 12 1013 Guerrero St 2 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     18 2x2   6005764.7450429 2102960.7456767 37.7546556947331 -122.423002202394 (37.7546556947331, -122.423002202394) 2 4 5 28859 19
1447 101635 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 12 1800X 27th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     6 3x3   5987855.0174 2102962.611 37.753633925344296 -122.484938226474 (37.7536339253443, -122.484938226474) 1 8 3 56 35
1489 101683 Undocumented 3 Ligustrum lucidum :: Glossy Privet 12 16 West Portal Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   5993140.0 2098173.0 37.740789285401604 -122.466313673169 (37.7407892854016, -122.466313673169) 1 8 4 59 40
1579 10179 Permitted Site 2 Ligustrum lucidum :: Glossy Privet 12 1090X Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     23 3X3   6005708.480965099 2102624.2723741 37.7537286419918 -122.42317286327801 (37.7537286419918, -122.423172863278) 2 4 5 28859 19
1595 10181 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 12 1097X Guerrero St 3 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     24 3X3   6005777.346268901 2102574.3880576002 37.753595557271 -122.422931166019 (37.753595557271, -122.422931166019) 2 4 5 28859 19
1600 10183 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 12 1113 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     18 3X2   6005790.6047359 2102492.1542693 37.7533705104285 -122.422879471267 (37.7533705104285, -122.422879471267) 2 4 5 28859 19
1609 10185 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 12 1125 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     12 3X3   6005788.9112599995 2102417.59249 37.7531656854677 -122.422880028901 (37.7531656854677, -122.422880028901) 2 4 5 28859 19
1614 101866 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 12 851 Lisbon St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   01/09/2013 12:00:00 AM 2 3x3 Permit Number 769709 6001077.037690001 2088890.9773 37.71575774639479 -122.438205662778 (37.7157577463948, -122.438205662778) 9 7 6 28861 5
1618 10187 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 12 1135 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     18 3X3   6005790.8424 2102360.27695 37.7530084192058 -122.422869277503 (37.7530084192058, -122.422869277503) 2 4 5 28859 19
1678 10196 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 12 1200X Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     15 3x3   6005751.90575 2101904.66457 37.7517552157318 -122.422971548421 (37.7517552157318, -122.422971548421) 2 4 5 28859 19
1741 10202 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 12 1243 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     12 3X3   6005829.09689 2101725.42508 37.7512674207747 -122.42269187452601 (37.7512674207747, -122.422691874526) 2 4 5 28859 19
1796 102075 Significant Tree 4 Ligustrum lucidum :: Glossy Privet 12 273 Magellan Ave 5 Front Yard : Yard 4 Tree 1 Private 2           5994674.1 2100293.4 37.7466997707371 -122.461163031194 (37.7466997707371, -122.461163031194) 1 8 4 29491 40
1805 102084 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 12 201 15th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 07/09/2009 12:00:00 AM 1 3x3 Permit Number 52515 5991161.35766 2114023.19945 37.7841953413 -122.474311334384 (37.7841953413, -122.474311334384) 11 6 2 54 26
1853 10214 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 12 1335 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     18 4X3   6005859.10485 2101158.22325 37.7497117078336 -122.422547803155 (37.7497117078336, -122.422547803155) 2 4 5 28859 19
1866 102154 Undocumented 3 Ligustrum lucidum :: Glossy Privet 12 450X Banks St 9 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4   3 3x4   6008490.5 2096648.5 37.7374771037155 -122.413129459512 (37.7374771037155, -122.413129459512) 10 7 7 28859 2
1867 102155 Undocumented 3 Ligustrum lucidum :: Glossy Privet 12 450X Banks St 10 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4   3 3x4   6008490.5 2096648.5 37.7374771037155 -122.413129459512 (37.7374771037155, -122.413129459512) 10 7 7 28859 2
1868 102156 Undocumented 3 Ligustrum lucidum :: Glossy Privet 12 450X Banks St 11 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4   3 3x4   6008490.5 2096648.5 37.7374771037155 -122.413129459512 (37.7374771037155, -122.413129459512) 10 7 7 28859 2
1876 102165 Permitted Site 2 Ligustrum lucidum :: Glossy Privet 12 3988 20th St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/31/2012 12:00:00 AM 3 3x3 Permit Number 769758 6003795.7 2104247.9 37.7580786087619 -122.429903496461 (37.7580786087619, -122.429903496461) 2 4 5 28862 3
1899 102189 Undocumented 3 Ligustrum lucidum :: Glossy Privet 12 3999X Folsom St 4 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4   3 3x3   6008408.0 2096514.0 37.7371031642446 -122.41340519256 (37.7371031642446, -122.41340519256) 10 7 7 28859 2
1901 102190 Undocumented 3 Ligustrum lucidum :: Glossy Privet 12 3999X Folsom St 6 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4   6 3x3   6008408.0 2096514.0 37.7371031642446 -122.41340519256 (37.7371031642446, -122.41340519256) 10 7 7 28859 2
1902 102191 Undocumented 3 Ligustrum lucidum :: Glossy Privet 12 3999X Folsom St 5 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4   3 3x3   6008408.0 2096514.0 37.7371031642446 -122.41340519256 (37.7371031642446, -122.41340519256) 10 7 7 28859 2
1903 102192 Undocumented 3 Ligustrum lucidum :: Glossy Privet 12 3999X Folsom St 7 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4   3 3x3   6008408.0 2096514.0 37.7371031642446 -122.41340519256 (37.7371031642446, -122.41340519256) 10 7 7 28859 2
1904 102193 Undocumented 3 Ligustrum lucidum :: Glossy Privet 12 3999X Folsom St 8 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4   18 3x3   6008408.0 2096514.0 37.7371031642446 -122.41340519256 (37.7371031642446, -122.41340519256) 10 7 7 28859 2
1905 102194 Undocumented 3 Ligustrum lucidum :: Glossy Privet 12 3999X Folsom St 10 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4   4 3x3   6008408.0 2096514.0 37.7371031642446 -122.41340519256 (37.7371031642446, -122.41340519256) 10 7 7 28859 2
1906 102195 Undocumented 3 Ligustrum lucidum :: Glossy Privet 12 3999X Folsom St 9 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW 3   3 3x3   6008408.0 2096514.0 37.7371031642446 -122.41340519256 (37.7371031642446, -122.41340519256) 10 7 7 28859 2
1923 10221 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 12 1370 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     65 3X3   6005802.11698 2100976.8322900003 37.7492104347131 -122.42273198069599 (37.7492104347131, -122.422731980696) 2 4 5 28859 19
2001 10229 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 12 1417 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     18 3X3   6005889.94053 2100616.0721299998 37.748224824522296 -122.422402655257 (37.7482248245223, -122.422402655257) 2 4 5 28859 19
2011 10230 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 12 1426 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     40 2x3   6005817.36142 2100645.21865 37.7483007596771 -122.42265570290199 (37.7483007596771, -122.422655702902) 2 4 5 28859 19
2156 102448 Undocumented 3 Ligustrum lucidum :: Glossy Privet 12 3430X 23rd St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     30 15x8   6006285.0 2102686.4 37.753931748244604 -122.421183538041 (37.7539317482446, -122.421183538041) 2 4 5 28859 19
2325 102624 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 12 305 Chestnut St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     4 3x3   6010336.6771 2120942.4897 37.8042862667019 -122.408459480806 (37.8042862667019, -122.408459480806) 3 1 10 308 23
2327 102626 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 12 2039 Scott St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     12 3x3   6001408.07759 2115496.16268 37.7888280197366 -122.43896700003799 (37.7888280197366, -122.438967000038) 13 6 1 29490 27
2328 102627 Undocumented 3 Ligustrum lucidum :: Glossy Privet 12 2039 Scott St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     12 3x3   6001422.0 2115424.0 37.7886306717674 -122.43891365705299 (37.7886306717674, -122.438913657053) 13 6 1 29490 27
2703 103039 Undocumented 3 Ligustrum lucidum :: Glossy Privet 12 90X Collingwood St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     12 3x3   6001998.0 2105342.7 37.7609826950878 -122.43619904954399 (37.7609826950878, -122.436199049544) 15 4 5 28862 3
3160 103523 Undocumented 3 Ligustrum lucidum :: Glossy Privet 12 41X Brady St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     10 3x3   6006623.0 2109623.0 37.772997074385295 -122.420507000439 (37.7729970743853, -122.420507000439) 8 2 9 28853 19
3161 103524 Undocumented 3 Ligustrum lucidum :: Glossy Privet 12 41X Brady St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     10 3x3   6006623.0 2109623.0 37.772997074385295 -122.420507000439 (37.7729970743853, -122.420507000439) 8 2 9 28853 19
3229 103601 Permitted Site 2 Ligustrum lucidum :: Glossy Privet 12 100X Buchanan St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     14 3x3   6004868.5 2109011.4 37.771218737852294 -122.426532477218 (37.7712187378523, -122.426532477218) 7 9 5 28852 10
3230 103602 Permitted Site 2 Ligustrum lucidum :: Glossy Privet 12 100X Buchanan St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     14 3x3   6004868.5 2109011.4 37.771218737852294 -122.426532477218 (37.7712187378523, -122.426532477218) 7 9 5 28852 10
3231 103603 Permitted Site 2 Ligustrum lucidum :: Glossy Privet 12 100X Buchanan St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   05/12/2015 12:00:00 AM 3 3x3   6004868.5 2109011.4 37.771218737852294 -122.426532477218 (37.7712187378523, -122.426532477218) 7 9 5 28852 10
3232 103604 Permitted Site 2 Ligustrum lucidum :: Glossy Privet 12 100X Buchanan St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   05/12/2015 12:00:00 AM 3 3x3   6004868.5 2109011.4 37.771218737852294 -122.426532477218 (37.7712187378523, -122.426532477218) 7 9 5 28852 10
3233 103605 Permitted Site 2 Ligustrum lucidum :: Glossy Privet 12 100X Buchanan St 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     14 3x3   6004868.5 2109011.4 37.771218737852294 -122.426532477218 (37.7712187378523, -122.426532477218) 7 9 5 28852 10
3234 103606 Permitted Site 2 Ligustrum lucidum :: Glossy Privet 12 100X Buchanan St 6 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6004868.5 2109011.4 37.771218737852294 -122.426532477218 (37.7712187378523, -122.426532477218) 7 9 5 28852 10
3235 103607 Permitted Site 2 Ligustrum lucidum :: Glossy Privet 12 100X Buchanan St 7 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     8 3x3   6004868.5 2109011.4 37.771218737852294 -122.426532477218 (37.7712187378523, -122.426532477218) 7 9 5 28852 10
3236 103608 Permitted Site 2 Ligustrum lucidum :: Glossy Privet 12 100X Buchanan St 8 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     12 3x3   6004868.5 2109011.4 37.771218737852294 -122.426532477218 (37.7712187378523, -122.426532477218) 7 9 5 28852 10
3237 103609 Permitted Site 2 Ligustrum lucidum :: Glossy Privet 12 200X Buchanan St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6004748.9 2109266.8 37.7719132424086 -122.426964371637 (37.7719132424086, -122.426964371637) 7 9 5 28852 10
3239 103610 Permitted Site 2 Ligustrum lucidum :: Glossy Privet 12 200X Buchanan St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6004748.9 2109266.8 37.7719132424086 -122.426964371637 (37.7719132424086, -122.426964371637) 7 9 5 28852 10
3595 104004 Undocumented 3 Ligustrum lucidum :: Glossy Privet 12 2179 12th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           5992553.4 2100640.7 37.7475310970527 -122.46852139722701 (37.7475310970527, -122.468521397227) 1 8 4 29491 40
4157 104687 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 12 540 Blanken Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     12 3x3   6013068.15068 2086901.5117 37.7109697693033 -122.396619189338 (37.7109697693033, -122.396619189338) 10 3 8 309 1
4584 105174 Undocumented 3 Ligustrum lucidum :: Glossy Privet 12 1601X NEWCOMB AVE 3 Sidewalk: Curb side : Cutout 2 Tree 1 Arts Commission 8     40 3x3 Permit Number 770204 6015135.0 2095759.0 37.735405494081505 -122.390093985074 (37.7354054940815, -122.390093985074) 10 3 8 58 1
4598 105205 Undocumented 3 Ligustrum lucidum :: Glossy Privet 12 1266 HAMPSHIRE ST 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     14 4x3   6010266.0 2101883.7 37.7519513373564 -122.407359653428 (37.7519513373564, -122.407359653428) 2 4 7 28859 19
4868 105519 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 12 649 Central Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     18 3x3   5999623.0034 2110786.8502 37.775795739067995 -122.44480443932 (37.775795739068, -122.44480443932) 15 5 11 29492 16
5049 105711 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 12 820 Cabrillo St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     16 3x3   5993058.451859999 2110735.54675 37.7752780614677 -122.46750895958598 (37.7752780614677, -122.467508959586) 11 6 2 54 11
5168 105873 Undocumented 3 Ligustrum lucidum :: Glossy Privet 12 2X 27th St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6006029.156359999 2100240.43464 37.7472012619439 -122.421894571047 (37.7472012619439, -122.421894571047) 2 7 5 28859 22
5169 105874 Undocumented 3 Ligustrum lucidum :: Glossy Privet 12 2X 27th St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6006029.156359999 2100240.43464 37.7472012619439 -122.421894571047 (37.7472012619439, -122.421894571047) 2 7 5 28859 22
5170 105875 Undocumented 3 Ligustrum lucidum :: Glossy Privet 12 2X 27th St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6006029.156359999 2100240.43464 37.7472012619439 -122.421894571047 (37.7472012619439, -122.421894571047) 2 7 5 28859 22
5171 105876 Undocumented 3 Ligustrum lucidum :: Glossy Privet 12 2X 27th St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6006029.156359999 2100240.43464 37.7472012619439 -122.421894571047 (37.7472012619439, -122.421894571047) 2 7 5 28859 22
5366 106128 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 12 2204 25th St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     14     6012212.28641 2101900.78254 37.75210698286921 -122.400630274471 (37.7521069828692, -122.400630274471) 10 3 8 28856 29
6122 10706 Permitted Site 2 Ligustrum lucidum :: Glossy Privet 12 969X Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   05/02/2006 12:00:00 AM 3 3X3   6005743.4978976 2103345.7544707 37.7557116405021 -122.42310304530899 (37.7557116405021, -122.423103045309) 2 4 5 28859 19
6441 107462 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 12 1629 Taylor St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     5     6008769.702769999 2118455.29192 37.797369163620296 -122.41370610855101 (37.7973691636203, -122.413706108551) 5 1 10 308 21
6442 107463 Permitted Site 2 Ligustrum lucidum :: Glossy Privet 12 1629 Taylor St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6008753.83856 2118472.3887 37.7974152162793 -122.413762212943 (37.7974152162793, -122.413762212943) 5 1 10 308 21
6862 107956 Permitted Site 2 Ligustrum lucidum :: Glossy Privet 12 2299X 25TH ST 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6012136.0 2101880.0 37.752045663585896 -122.400892625965 (37.7520456635859, -122.400892625965) 10 3 8 28856 29
6863 107959 Permitted Site 2 Ligustrum lucidum :: Glossy Privet 12 2299X 25TH ST 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6012136.0 2101880.0 37.752045663585896 -122.400892625965 (37.7520456635859, -122.400892625965) 10 3 8 28856 29
7042 108149 Undocumented 3 Ligustrum lucidum :: Glossy Privet 12 2232 Webster St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6003295.44003 2116396.66877 37.791407783491294 -122.432501340527 (37.7914077834913, -122.432501340527) 13 9 1 29490 27
7045 108151 Undocumented 3 Ligustrum lucidum :: Glossy Privet 12 2232 Webster St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6003295.44003 2116396.66877 37.791407783491294 -122.432501340527 (37.7914077834913, -122.432501340527) 13 9 1 29490 27
8159 109255 Undocumented 3 Ligustrum lucidum :: Glossy Privet 12 1533 PINE ST 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/14/2015 12:00:00 AM 3 3x3   6006572.5 2115603.9 37.78941632368 -122.421106442083 (37.78941632368, -122.421106442083) 13 9 10 28858 21
8627 109819 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 12 909X Laguna St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1       4X4   6004814.1677377 2111967.1785845 37.779331512641896 -122.42693096158101 (37.7793315126419, -122.426930961581) 7 9 11 29490 41

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 73.894ms · Data source: data.sfgov.org