trees
2,180 rows where qSpecies_id = 57 sorted by TreeID
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
119271 | 10004 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 150 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 28 | 3X3 | 6005403.33839 | 2108127.1988 | 37.7688211546939 | -122.424619539876 | (37.7688211546939, -122.424619539876) | 8 | 4 | 5 | 28853 | 19 | |||
108815 | 10011 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 198 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 2X3 | 6005417.15338 | 2107897.14895 | 37.7681902730979 | -122.424555388522 | (37.7681902730979, -122.424555388522) | 8 | 4 | 5 | 28853 | 19 | |||
100677 | 10013 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 215 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x2 | 6005495.275 | 2107715.11687 | 37.7676948680391 | -122.424272225299 | (37.7676948680391, -122.424272225299) | 8 | 4 | 5 | 28853 | 19 | |||
76339 | 100230 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 701X 39th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 5983807.86909 | 2110960.60417 | 37.7753575879766 | -122.499524975598 | (37.7753575879766, -122.499524975598) | 11 | 6 | 2 | 55 | 26 | |||
182535 | 100232 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 701X 39th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 5983809.61939 | 2110917.38856 | 37.7752390330911 | -122.499515726535 | (37.7752390330911, -122.499515726535) | 11 | 6 | 2 | 55 | 26 | |||
110386 | 10031 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 310 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 100 | 2x3 | 6005459.49344 | 2107143.42218 | 37.7661231103266 | -122.424355322653 | (37.7661231103266, -122.424355322653) | 8 | 4 | 5 | 28853 | 19 | |||
87906 | 10055 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 432 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X2 | 6005503.26278 | 2106415.24362 | 37.7641261764966 | -122.424152141508 | (37.7641261764966, -122.424152141508) | 8 | 4 | 5 | 28859 | 19 | |||
187519 | 10058 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 451 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x5 | 6005573.31758 | 2106314.3851 | 37.763853198087 | -122.4239026696 | (37.763853198087, -122.4239026696) | 8 | 4 | 5 | 28859 | 19 | |||
122217 | 10072 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 573 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6005609.84736 | 2105668.09746 | 37.7620807071743 | -122.423730368485 | (37.7620807071743, -122.423730368485) | 8 | 4 | 5 | 28859 | 19 | |||
99107 | 10075 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 595 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 2x2 | 6005616.34075 | 2105560.18901 | 37.7617847825636 | -122.423700237591 | (37.7617847825636, -122.423700237591) | 8 | 4 | 5 | 28859 | 19 | |||
70639 | 10078 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 615 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6005625.0168 | 2105365.53505 | 37.7612507983953 | -122.423656390236 | (37.7612507983953, -122.423656390236) | 2 | 4 | 5 | 28859 | 19 | |||
130181 | 10105 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 779 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2016 12:00:00 AM | 18 | 4x4 | 6005674.55908 | 2104459.44386 | 37.7587656810971 | -122.423420627562 | (37.7587656810971, -122.423420627562) | 2 | 4 | 5 | 28859 | 19 | ||
69917 | 101107 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1790 24th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3X3 | Permit Number 14067 | 5988779.1453 | 2103160.9003 | 37.7542321578078 | -122.481756948123 | (37.7542321578078, -122.481756948123) | 1 | 8 | 3 | 56 | 35 | ||
94756 | 101108 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1790 24th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3X3 | Permit Number 14067 | 5988777.5028 | 2103198.1315 | 37.7543342891997 | -122.481765355128 | (37.7543342891997, -122.481765355128) | 1 | 8 | 3 | 56 | 35 | ||
109676 | 101109 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1790 24th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | Permit Number 14067 | 5988776.9552 | 2103216.747 | 37.7543853705337 | -122.481768612291 | (37.7543853705337, -122.481768612291) | 1 | 8 | 3 | 56 | 35 | ||
183319 | 101143 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 450 Connecticut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 2x2 | 6013205.5803 | 2104971.74956 | 37.7605945388373 | -122.397410636805 | (37.7605945388373, -122.397410636805) | 10 | 3 | 8 | 28856 | 29 | |||
57752 | 101144 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 450 Connecticut St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 2x2 | 6013206.1129 | 2104955.38983 | 37.7605496482619 | -122.397407647447 | (37.7605496482619, -122.397407647447) | 10 | 3 | 8 | 28856 | 29 | |||
5650 | 101145 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 450 Connecticut St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 2x2 | 6013204.93498 | 2104939.92488 | 37.7605071193183 | -122.397410636789 | (37.7605071193183, -122.397410636789) | 10 | 3 | 8 | 28856 | 29 | |||
33758 | 101245 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1301X 08th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/28/1972 12:00:00 AM | Permit Number 9950 | 5993577.2 | 2106568.3 | 37.7638658419872 | -122.465411719392 | (37.7638658419872, -122.465411719392) | 1 | 8 | 11 | 56 | 12 | |||
191231 | 101261 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 1945 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5989742 | 2106485 | 37.7634151902649 | -122.478670277794 | (37.7634151902649, -122.478670277794) | 1 | 8 | 3 | 56 | 35 | ||||
117442 | 101265 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 2034 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5989459.10715 | 2106523.86109 | 37.7635054630097 | -122.47965154526 | (37.7635054630097, -122.47965154526) | 1 | 8 | 3 | 56 | 35 | ||||
110802 | 101266 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 2126 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5989175 | 2106519 | 37.7634756077712 | -122.480633814056 | (37.7634756077712, -122.480633814056) | 1 | 8 | 3 | 56 | 35 | ||||
129071 | 10129 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 892 Guerrero St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6005646.9391641 | 2103763.6492254 | 37.7568536327232 | -122.42346668442 | (37.7568536327232, -122.42346668442) | 2 | 4 | 5 | 28859 | 19 | |||
59530 | 101406 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 50-52 Ramona Ave | 1 | Sidewalk: Curb side : Cutout | Tree | 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 | |
42856 | 10143 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 920 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6005657.84848 | 2103570.53997 | 37.7563240154596 | -122.423415228047 | (37.7563240154596, -122.423415228047) | 2 | 4 | 5 | 28859 | 19 | |||
168508 | 101482 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1021 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6011947.17708 | 2103416.1545 | 37.7562530733255 | -122.401653568078 | (37.7562530733255, -122.401653568078) | 10 | 3 | 8 | 28856 | 29 | |||
153600 | 10158 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1001 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6005753.82676 | 2103093.98635 | 37.7550209265961 | -122.423049430612 | (37.7550209265961, -122.423049430612) | 2 | 4 | 5 | 28859 | 19 | |||
170995 | 10162 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1013 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2x2 | 6005758.27618 | 2103002.23491 | 37.7547692495131 | -122.423027522221 | (37.7547692495131, -122.423027522221) | 2 | 4 | 5 | 28859 | 19 | |||
113499 | 10163 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1013 Guerrero St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 2x2 | 6005764.7450429 | 2102960.7456767 | 37.7546556947331 | -122.423002202394 | (37.7546556947331, -122.423002202394) | 2 | 4 | 5 | 28859 | 19 | |||
93630 | 101635 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1800X 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 5987855.0174 | 2102962.611 | 37.7536339253443 | -122.484938226474 | (37.7536339253443, -122.484938226474) | 1 | 8 | 3 | 56 | 35 | |||
165636 | 101683 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 16 West Portal Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993140 | 2098173 | 37.7407892854016 | -122.466313673169 | (37.7407892854016, -122.466313673169) | 1 | 8 | 4 | 59 | 40 | ||||
149574 | 10179 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1090X Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | 3X3 | 6005708.4809651 | 2102624.2723741 | 37.7537286419918 | -122.423172863278 | (37.7537286419918, -122.423172863278) | 2 | 4 | 5 | 28859 | 19 | |||
100176 | 10181 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1097X Guerrero St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6005777.3462689 | 2102574.3880576 | 37.753595557271 | -122.422931166019 | (37.753595557271, -122.422931166019) | 2 | 4 | 5 | 28859 | 19 | |||
9735 | 10183 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1113 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X2 | 6005790.6047359 | 2102492.1542693 | 37.7533705104285 | -122.422879471267 | (37.7533705104285, -122.422879471267) | 2 | 4 | 5 | 28859 | 19 | |||
78491 | 10185 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1125 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005788.91126 | 2102417.59249 | 37.7531656854677 | -122.422880028901 | (37.7531656854677, -122.422880028901) | 2 | 4 | 5 | 28859 | 19 | |||
160174 | 101866 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 851 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/09/2013 12:00:00 AM | 2 | 3x3 | Permit Number 769709 | 6001077.03769 | 2088890.9773 | 37.7157577463948 | -122.438205662778 | (37.7157577463948, -122.438205662778) | 9 | 7 | 6 | 28861 | 5 | |
177041 | 10187 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1135 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6005790.8424 | 2102360.27695 | 37.7530084192058 | -122.422869277503 | (37.7530084192058, -122.422869277503) | 2 | 4 | 5 | 28859 | 19 | |||
26803 | 10196 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1200X Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6005751.90575 | 2101904.66457 | 37.7517552157318 | -122.422971548421 | (37.7517552157318, -122.422971548421) | 2 | 4 | 5 | 28859 | 19 | |||
131366 | 10202 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1243 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005829.09689 | 2101725.42508 | 37.7512674207747 | -122.422691874526 | (37.7512674207747, -122.422691874526) | 2 | 4 | 5 | 28859 | 19 | |||
84029 | 102075 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 273 Magellan Ave | 5 | Front Yard : Yard | Tree | Private 2 | 5994674.1 | 2100293.4 | 37.7466997707371 | -122.461163031194 | (37.7466997707371, -122.461163031194) | 1 | 8 | 4 | 29491 | 40 | |||||
102984 | 102084 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 201 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 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 |
193426 | 10214 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1335 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X3 | 6005859.10485 | 2101158.22325 | 37.7497117078336 | -122.422547803155 | (37.7497117078336, -122.422547803155) | 2 | 4 | 5 | 28859 | 19 | |||
108397 | 102154 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 450X Banks St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x4 | 6008490.5 | 2096648.5 | 37.7374771037155 | -122.413129459512 | (37.7374771037155, -122.413129459512) | 10 | 7 | 7 | 28859 | 2 | ||
78897 | 102155 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 450X Banks St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x4 | 6008490.5 | 2096648.5 | 37.7374771037155 | -122.413129459512 | (37.7374771037155, -122.413129459512) | 10 | 7 | 7 | 28859 | 2 | ||
153285 | 102156 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 450X Banks St | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x4 | 6008490.5 | 2096648.5 | 37.7374771037155 | -122.413129459512 | (37.7374771037155, -122.413129459512) | 10 | 7 | 7 | 28859 | 2 | ||
78795 | 102165 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 3988 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 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 |
33305 | 102189 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 3999X Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6008408 | 2096514 | 37.7371031642446 | -122.41340519256 | (37.7371031642446, -122.41340519256) | 10 | 7 | 7 | 28859 | 2 | ||
52882 | 102190 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 3999X Folsom St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 6008408 | 2096514 | 37.7371031642446 | -122.41340519256 | (37.7371031642446, -122.41340519256) | 10 | 7 | 7 | 28859 | 2 | ||
103551 | 102191 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 3999X Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6008408 | 2096514 | 37.7371031642446 | -122.41340519256 | (37.7371031642446, -122.41340519256) | 10 | 7 | 7 | 28859 | 2 | ||
183831 | 102192 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 3999X Folsom St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6008408 | 2096514 | 37.7371031642446 | -122.41340519256 | (37.7371031642446, -122.41340519256) | 10 | 7 | 7 | 28859 | 2 | ||
130673 | 102193 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 3999X Folsom St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 18 | 3x3 | 6008408 | 2096514 | 37.7371031642446 | -122.41340519256 | (37.7371031642446, -122.41340519256) | 10 | 7 | 7 | 28859 | 2 | ||
57109 | 102194 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 3999X Folsom St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 4 | 3x3 | 6008408 | 2096514 | 37.7371031642446 | -122.41340519256 | (37.7371031642446, -122.41340519256) | 10 | 7 | 7 | 28859 | 2 | ||
169010 | 102195 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 3999X Folsom St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 3 | 3x3 | 6008408 | 2096514 | 37.7371031642446 | -122.41340519256 | (37.7371031642446, -122.41340519256) | 10 | 7 | 7 | 28859 | 2 | ||
46411 | 10221 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1370 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 65 | 3X3 | 6005802.11698 | 2100976.83229 | 37.7492104347131 | -122.422731980696 | (37.7492104347131, -122.422731980696) | 2 | 4 | 5 | 28859 | 19 | |||
26547 | 10229 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1417 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6005889.94053 | 2100616.07213 | 37.7482248245223 | -122.422402655257 | (37.7482248245223, -122.422402655257) | 2 | 4 | 5 | 28859 | 19 | |||
38475 | 10230 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1426 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 2x3 | 6005817.36142 | 2100645.21865 | 37.7483007596771 | -122.422655702902 | (37.7483007596771, -122.422655702902) | 2 | 4 | 5 | 28859 | 19 | |||
176257 | 102448 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 3430X 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 15x8 | 6006285 | 2102686.4 | 37.7539317482446 | -122.421183538041 | (37.7539317482446, -122.421183538041) | 2 | 4 | 5 | 28859 | 19 | |||
28627 | 102624 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 305 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6010336.6771 | 2120942.4897 | 37.8042862667019 | -122.408459480806 | (37.8042862667019, -122.408459480806) | 3 | 1 | 10 | 308 | 23 | |||
135937 | 102626 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2039 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6001408.07759 | 2115496.16268 | 37.7888280197366 | -122.438967000038 | (37.7888280197366, -122.438967000038) | 13 | 6 | 1 | 29490 | 27 | |||
475 | 102627 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 2039 Scott St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6001422 | 2115424 | 37.7886306717674 | -122.438913657053 | (37.7886306717674, -122.438913657053) | 13 | 6 | 1 | 29490 | 27 | |||
72053 | 103039 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 90X Collingwood St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6001998 | 2105342.7 | 37.7609826950878 | -122.436199049544 | (37.7609826950878, -122.436199049544) | 15 | 4 | 5 | 28862 | 3 | |||
24120 | 103523 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 41X Brady St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6006623 | 2109623 | 37.7729970743853 | -122.420507000439 | (37.7729970743853, -122.420507000439) | 8 | 2 | 9 | 28853 | 19 | |||
113620 | 103524 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 41X Brady St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6006623 | 2109623 | 37.7729970743853 | -122.420507000439 | (37.7729970743853, -122.420507000439) | 8 | 2 | 9 | 28853 | 19 | |||
15127 | 103601 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 100X Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6004868.5 | 2109011.4 | 37.7712187378523 | -122.426532477218 | (37.7712187378523, -122.426532477218) | 7 | 9 | 5 | 28852 | 10 | |||
44926 | 103602 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 100X Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6004868.5 | 2109011.4 | 37.7712187378523 | -122.426532477218 | (37.7712187378523, -122.426532477218) | 7 | 9 | 5 | 28852 | 10 | |||
97966 | 103603 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 100X Buchanan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/12/2015 12:00:00 AM | 3 | 3x3 | 6004868.5 | 2109011.4 | 37.7712187378523 | -122.426532477218 | (37.7712187378523, -122.426532477218) | 7 | 9 | 5 | 28852 | 10 | ||
126147 | 103604 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 100X Buchanan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/12/2015 12:00:00 AM | 3 | 3x3 | 6004868.5 | 2109011.4 | 37.7712187378523 | -122.426532477218 | (37.7712187378523, -122.426532477218) | 7 | 9 | 5 | 28852 | 10 | ||
115155 | 103605 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 100X Buchanan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6004868.5 | 2109011.4 | 37.7712187378523 | -122.426532477218 | (37.7712187378523, -122.426532477218) | 7 | 9 | 5 | 28852 | 10 | |||
112331 | 103606 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 100X Buchanan St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004868.5 | 2109011.4 | 37.7712187378523 | -122.426532477218 | (37.7712187378523, -122.426532477218) | 7 | 9 | 5 | 28852 | 10 | ||||
107807 | 103607 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 100X Buchanan St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6004868.5 | 2109011.4 | 37.7712187378523 | -122.426532477218 | (37.7712187378523, -122.426532477218) | 7 | 9 | 5 | 28852 | 10 | |||
40930 | 103608 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 100X Buchanan St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6004868.5 | 2109011.4 | 37.7712187378523 | -122.426532477218 | (37.7712187378523, -122.426532477218) | 7 | 9 | 5 | 28852 | 10 | |||
81722 | 103609 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 200X Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004748.9 | 2109266.8 | 37.7719132424086 | -122.426964371637 | (37.7719132424086, -122.426964371637) | 7 | 9 | 5 | 28852 | 10 | ||||
53690 | 103610 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 200X Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004748.9 | 2109266.8 | 37.7719132424086 | -122.426964371637 | (37.7719132424086, -122.426964371637) | 7 | 9 | 5 | 28852 | 10 | ||||
16415 | 104004 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 2179 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5992553.4 | 2100640.7 | 37.7475310970527 | -122.468521397227 | (37.7475310970527, -122.468521397227) | 1 | 8 | 4 | 29491 | 40 | |||||
32436 | 104687 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 540 Blanken Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6013068.15068 | 2086901.5117 | 37.7109697693033 | -122.396619189338 | (37.7109697693033, -122.396619189338) | 10 | 3 | 8 | 309 | 1 | |||
75443 | 105174 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 1601X NEWCOMB AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 40 | 3x3 | Permit Number 770204 | 6015135 | 2095759 | 37.7354054940815 | -122.390093985074 | (37.7354054940815, -122.390093985074) | 10 | 3 | 8 | 58 | 1 | ||
129640 | 105205 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 1266 HAMPSHIRE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 4x3 | 6010266 | 2101883.7 | 37.7519513373564 | -122.407359653428 | (37.7519513373564, -122.407359653428) | 2 | 4 | 7 | 28859 | 19 | |||
127922 | 105519 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 649 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 5999623.0034 | 2110786.8502 | 37.775795739068 | -122.44480443932 | (37.775795739068, -122.44480443932) | 15 | 5 | 11 | 29492 | 16 | |||
137288 | 105711 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 820 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 5993058.45186 | 2110735.54675 | 37.7752780614677 | -122.467508959586 | (37.7752780614677, -122.467508959586) | 11 | 6 | 2 | 54 | 11 | |||
126825 | 105873 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 2X 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006029.15636 | 2100240.43464 | 37.7472012619439 | -122.421894571047 | (37.7472012619439, -122.421894571047) | 2 | 7 | 5 | 28859 | 22 | ||||
177487 | 105874 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 2X 27th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006029.15636 | 2100240.43464 | 37.7472012619439 | -122.421894571047 | (37.7472012619439, -122.421894571047) | 2 | 7 | 5 | 28859 | 22 | ||||
55964 | 105875 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 2X 27th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006029.15636 | 2100240.43464 | 37.7472012619439 | -122.421894571047 | (37.7472012619439, -122.421894571047) | 2 | 7 | 5 | 28859 | 22 | ||||
117142 | 105876 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 2X 27th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006029.15636 | 2100240.43464 | 37.7472012619439 | -122.421894571047 | (37.7472012619439, -122.421894571047) | 2 | 7 | 5 | 28859 | 22 | ||||
24257 | 106128 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2204 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 6012212.28641 | 2101900.78254 | 37.7521069828692 | -122.400630274471 | (37.7521069828692, -122.400630274471) | 10 | 3 | 8 | 28856 | 29 | ||||
59132 | 10706 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 969X Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2006 12:00:00 AM | 3 | 3X3 | 6005743.4978976 | 2103345.7544707 | 37.7557116405021 | -122.423103045309 | (37.7557116405021, -122.423103045309) | 2 | 4 | 5 | 28859 | 19 | ||
67147 | 107462 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1629 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 6008769.70277 | 2118455.29192 | 37.7973691636203 | -122.413706108551 | (37.7973691636203, -122.413706108551) | 5 | 1 | 10 | 308 | 21 | ||||
131683 | 107463 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1629 Taylor St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008753.83856 | 2118472.3887 | 37.7974152162793 | -122.413762212943 | (37.7974152162793, -122.413762212943) | 5 | 1 | 10 | 308 | 21 | |||||
129881 | 107956 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 2299X 25TH ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012136 | 2101880 | 37.7520456635859 | -122.400892625965 | (37.7520456635859, -122.400892625965) | 10 | 3 | 8 | 28856 | 29 | ||||
23720 | 107959 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 2299X 25TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012136 | 2101880 | 37.7520456635859 | -122.400892625965 | (37.7520456635859, -122.400892625965) | 10 | 3 | 8 | 28856 | 29 | ||||
20799 | 108149 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 2232 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6003295.44003 | 2116396.66877 | 37.7914077834913 | -122.432501340527 | (37.7914077834913, -122.432501340527) | 13 | 9 | 1 | 29490 | 27 | |||||
34652 | 108151 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 2232 Webster St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6003295.44003 | 2116396.66877 | 37.7914077834913 | -122.432501340527 | (37.7914077834913, -122.432501340527) | 13 | 9 | 1 | 29490 | 27 | |||||
182466 | 109255 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 1533 PINE ST | 2 | Sidewalk: Curb side : Cutout | Tree | 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 | ||
132435 | 109819 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 909X Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4X4 | 6004814.1677377 | 2111967.1785845 | 37.7793315126419 | -122.426930961581 | (37.7793315126419, -122.426930961581) | 7 | 9 | 11 | 29490 | 41 | ||||
193809 | 109820 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 909X Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4X4 | 6004814.1677377 | 2111967.1785845 | 37.7793315126419 | -122.426930961581 | (37.7793315126419, -122.426930961581) | 7 | 9 | 11 | 29490 | 41 | ||||
29374 | 109992 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 501X Shotwell St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | DPW | 3x3 | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | 2 | 4 | 7 | 28859 | 19 | |||
27383 | 109993 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 501X Shotwell St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | DPW | 3x3 | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | 2 | 4 | 7 | 28859 | 19 | |||
177165 | 109994 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 501X Shotwell St | 11 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | DPW | 3x3 | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | 2 | 4 | 7 | 28859 | 19 | |||
117136 | 109995 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 501X Shotwell St | 12 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | DPW | 3x3 | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | 2 | 4 | 7 | 28859 | 19 | |||
57725 | 109996 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 501X Shotwell St | 13 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | DPW | 3x3 | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | 2 | 4 | 7 | 28859 | 19 | |||
61185 | 110060 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2661 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 6000157.93618 | 2118825.46591 | 37.7978982024034 | -122.443531554039 | (37.7978982024034, -122.443531554039) | 13 | 9 | 1 | 57 | 17 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );