trees
218 rows where Fire Prevention Districts = 2 and qSpecies_id = 65 sorted by YCoord
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7501 | 262401 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1X Benton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/21/2020 12:00:00 AM | 3 | 3x3 | 6004556 | 2094831 | 37.732264993682 | -122.426603497453 | (37.732264993682, -122.426603497453) | 2 | 7 | 7 | 28861 | 2 | ||
18580 | 262400 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1X Benton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/21/2020 12:00:00 AM | 3 | 3x3 | 6004556 | 2094831 | 37.732264993682 | -122.426603497453 | (37.732264993682, -122.426603497453) | 2 | 7 | 7 | 28861 | 2 | ||
76041 | 59441 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 98 Bosworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1980 12:00:00 AM | Permit Number 18804 | 6004258.9190799 | 2095333.58373446 | 37.7336281759245 | -122.42766636908 | (37.7336281759245, -122.42766636908) | 2 | 7 | 5 | 28861 | 25 | |||
69139 | 221840 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 98 Bosworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 2ft | 6004312.44121 | 2095336.44977 | 37.7336390727743 | -122.427481531566 | (37.7336390727743, -122.427481531566) | 2 | 7 | 5 | 28861 | 25 | |||
177042 | 221839 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 98 Bosworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6004329.20117 | 2095336.95284 | 37.7336414020218 | -122.42742362331 | (37.7336414020218, -122.42742362331) | 2 | 7 | 5 | 28861 | 25 | |||
66471 | 221841 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 5 Marsily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 2ft | 6004259.60988 | 2095362.69857 | 37.7337081577855 | -122.42766605444 | (37.7337081577855, -122.42766605444) | 2 | 7 | 5 | 28861 | 25 | |||
106933 | 221895 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 47 Milton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003758.63244 | 2095404.32352 | 37.7337940997194 | -122.429401048121 | (37.7337940997194, -122.429401048121) | 2 | 7 | 5 | 28861 | 25 | |||
28695 | 221842 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 5 Marsily St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 2ft | 6004251.52018 | 2095424.77714 | 37.7338781539609 | -122.427698444448 | (37.7338781539609, -122.427698444448) | 2 | 7 | 5 | 28861 | 25 | |||
143450 | 221902 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 7 Marsily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6004251.61559 | 2095453.80279 | 37.7339578572562 | -122.427700181935 | (37.7339578572562, -122.427700181935) | 2 | 7 | 5 | 28861 | 25 | |||
1033 | 221901 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 7 Marsily St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6004253.74444 | 2095482.9703 | 37.7340380650904 | -122.427694899296 | (37.7340380650904, -122.427694899296) | 2 | 7 | 5 | 28861 | 25 | |||
133256 | 5134 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 2815 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/1992 12:00:00 AM | 6 | 3X3 | 6002450.59942 | 2095504.85865 | 37.7339960032757 | -122.433930487392 | (37.7339960032757, -122.433930487392) | 2 | 7 | 5 | 63 | 7 | ||
149081 | 221900 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 7 Marsily St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6004249.68912 | 2095508.61359 | 37.7341082463924 | -122.427710746252 | (37.7341082463924, -122.427710746252) | 2 | 7 | 5 | 28861 | 25 | |||
140076 | 221903 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 19 Saint Marys Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6004552.30027 | 2095513.5436 | 37.7341388961924 | -122.426664875203 | (37.7341388961924, -122.426664875203) | 2 | 7 | 5 | 28861 | 25 | |||
188028 | 221867 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2825 Diamond St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6002454.8642 | 2095527.53959 | 37.7340585219649 | -122.43391736341 | (37.7340585219649, -122.43391736341) | 2 | 7 | 5 | 63 | 7 | |||
29348 | 221851 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 19 Saint Marys Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6004484.38042 | 2095546.73676 | 37.7342261969882 | -122.426902058798 | (37.7342261969882, -122.426902058798) | 2 | 7 | 5 | 28861 | 25 | |||
95845 | 221899 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 7 Marsily St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6004290.71623 | 2095557.06224 | 37.7342435961597 | -122.427572353179 | (37.7342435961597, -122.427572353179) | 2 | 7 | 5 | 28861 | 25 | |||
43199 | 221866 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 53 Wilder St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6002528.4957 | 2095557.08411 | 37.734143822686 | -122.433664907521 | (37.734143822686, -122.433664907521) | 2 | 7 | 5 | 63 | 7 | |||
95747 | 221850 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 19 Saint Marys Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6004464.56621 | 2095558.73638 | 37.7342580248697 | -122.426971417216 | (37.7342580248697, -122.426971417216) | 2 | 7 | 5 | 28861 | 25 | |||
72140 | 221898 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 7 Marsily St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6004300.13641 | 2095569.34378 | 37.7342778513286 | -122.427540659282 | (37.7342778513286, -122.427540659282) | 2 | 7 | 5 | 28861 | 25 | |||
22793 | 221849 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 19 Saint Marys Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6004448.4556 | 2095570.1665 | 37.7342884984186 | -122.427027930603 | (37.7342884984186, -122.427027930603) | 2 | 7 | 5 | 28861 | 25 | |||
181669 | 221897 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 7 Marsily St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 3ft | 6004313.27155 | 2095583.983 | 37.7343187902678 | -122.427496289445 | (37.7343187902678, -122.427496289445) | 2 | 7 | 5 | 28861 | 25 | |||
166822 | 221848 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 19 Saint Marys Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6004429.19741 | 2095585.11426 | 37.7343284525969 | -122.427095576708 | (37.7343284525969, -122.427095576708) | 2 | 7 | 5 | 28861 | 25 | |||
192333 | 221847 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 19 Saint Marys Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6004411.28278 | 2095593.12873 | 37.7343494454616 | -122.427158084072 | (37.7343494454616, -122.427158084072) | 2 | 7 | 5 | 28861 | 25 | |||
167184 | 221846 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 19 Saint Marys Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 6004388.2708 | 2095606.1808 | 37.7343839821397 | -122.427238573395 | (37.7343839821397, -122.427238573395) | 2 | 7 | 5 | 28861 | 25 | |||
50598 | 221896 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 7 Marsily St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6004330.56552 | 2095607.66514 | 37.7343847942306 | -122.427438185126 | (37.7343847942306, -122.427438185126) | 2 | 7 | 5 | 28861 | 25 | |||
38326 | 221845 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 19 Saint Marys Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6004371.42755 | 2095618.1193 | 37.7344158100226 | -122.427297656166 | (37.7344158100226, -122.427297656166) | 2 | 7 | 5 | 28861 | 25 | |||
79694 | 221813 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 810 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007573.94838 | 2095674.48731 | 37.7347511816054 | -122.416229453325 | (37.7347511816054, -122.416229453325) | 2 | 7 | 7 | 28859 | 2 | |||
67978 | 67941 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 127 Saint Mary's Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | Permit Number 31655 | 6004179.48175958 | 2095714.01541041 | 37.7346682618025 | -122.427968106929 | (37.7346682618025, -122.427968106929) | 2 | 7 | 5 | 28861 | 25 | ||
71152 | 221844 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 127 Saint Marys Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 2ft | 6004153.19016 | 2095736.31086 | 37.7347279926082 | -122.428060594226 | (37.7347279926082, -122.428060594226) | 2 | 7 | 5 | 28861 | 25 | |||
10474 | 221869 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 673 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6007432.02888 | 2095820.07599 | 37.7351429550833 | -122.416730429683 | (37.7351429550833, -122.416730429683) | 2 | 7 | 7 | 28859 | 2 | |||
135296 | 221865 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 592 Laidley St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6002930.8792 | 2095923.87336 | 37.7351737658507 | -122.432299929108 | (37.7351737658507, -122.432299929108) | 2 | 7 | 5 | 63 | 7 | |||
186207 | 114881 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 122 COLLEGE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6004593 | 2095924 | 37.7352682180932 | -122.426553380791 | (37.7352682180932, -122.426553380791) | 2 | 7 | 5 | 28861 | 2 | |||
190577 | 221864 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 592 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6002944.20199 | 2095934.50761 | 37.7352037204832 | -122.432254626652 | (37.7352037204832, -122.432254626652) | 2 | 7 | 5 | 63 | 7 | |||
52019 | 119902 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 598 Laidley St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002915 | 2095952 | 37.7352500947879 | -122.43235683741 | (37.7352500947879, -122.43235683741) | 2 | 7 | 5 | 63 | 7 | ||||
69208 | 119901 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 598 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002915 | 2095952 | 37.7352500947879 | -122.43235683741 | (37.7352500947879, -122.43235683741) | 2 | 7 | 5 | 63 | 7 | ||||
80067 | 221843 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 124 College Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 2ft | 6004594.79724 | 2095953.61848 | 37.7353496453739 | -122.426549275423 | (37.7353496453739, -122.426549275423) | 2 | 7 | 5 | 28861 | 2 | |||
169336 | 221863 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 214 Roanoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6003563.65489 | 2095975.96127 | 37.7353526463955 | -122.430115909332 | (37.7353526463955, -122.430115909332) | 2 | 7 | 5 | 63 | 7 | |||
176854 | 67934 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 19 Saint Mary's Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/1998 12:00:00 AM | Permit Number 31647 | 6003947.82619719 | 2095984.77824106 | 37.7353986067624 | -122.428788314932 | (37.7353986067624, -122.428788314932) | 2 | 7 | 5 | 63 | 7 | ||
155422 | 221812 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 724 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6007603.04648 | 2096007.03362 | 37.7356659171455 | -122.416152394917 | (37.7356659171455, -122.416152394917) | 2 | 7 | 7 | 28859 | 2 | |||
92787 | 114424 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 724 MOULTRIE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 4x2 | 6007601 | 2096031 | 37.735731608506 | -122.416161167234 | (37.735731608506, -122.416161167234) | 2 | 7 | 7 | 28859 | 2 | |||
42101 | 59432 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 3045 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/24/1994 12:00:00 AM | Permit Number 18794 | 6002901.09620901 | 2096034.49584779 | 37.7354758211207 | -122.432410798093 | (37.7354758211207, -122.432410798093) | 2 | 7 | 5 | 63 | 7 | ||
578 | 221823 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 199X Ogden Ave | 6 | Sidewalk: Curb side : Pot | Tree | Private 2 | 13 | Width 4ft | 6007760.27568 | 2096148.55485 | 37.7360633428545 | -122.415618808282 | (37.7360633428545, -122.415618808282) | 2 | 7 | 7 | 28859 | 2 | |||
10220 | 221824 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 199X Ogden Ave | 10 | Sidewalk: Curb side : Pot | Tree | Private 2 | 10 | Width 4ft | 6007730.82531 | 2096150.27006 | 37.7360663969372 | -122.415720751814 | (37.7360663969372, -122.415720751814) | 2 | 7 | 7 | 28859 | 2 | |||
153194 | 221788 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 67 Richland Ave | 1 | : | Tree | Private 2 | 20 | Width 4ft | 6005032.77253 | 2096203.58298 | 37.7360607419969 | -122.425052810752 | (37.7360607419969, -122.425052810752) | 2 | 7 | 5 | 28859 | 2 | |||
144794 | 32372 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 90 Leese St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/2018 12:00:00 AM | 3 | Permit Number 782452 | 6005529.07574 | 2096212.96171 | 37.7361145169719 | -122.423337554504 | (37.7361145169719, -122.423337554504) | 2 | 7 | 7 | 28859 | 2 | |
62771 | 62339 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 67 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/27/1994 12:00:00 AM | Permit Number 22481 | 6004929.22923105 | 2096213.38801269 | 37.7360818148322 | -122.425411499586 | (37.7360818148322, -122.425411499586) | 2 | 7 | 5 | 28859 | 2 | ||
136488 | 109499 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 99 Surrey St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | FUF | 02/19/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774984 | 6002392.9 | 2096233.9 | 37.7359945088656 | -122.43418207237 | (37.7359945088656, -122.43418207237) | 2 | 7 | 5 | 63 | 7 |
180750 | 158239 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 225 Bemis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/31/2018 12:00:00 AM | 3 | 3x3 | Permit Number 780004 | 6003126.50979 | 2096349.74034 | 37.7363541898933 | -122.43165395869 | (37.7363541898933, -122.43165395869) | 2 | 7 | 5 | 63 | 7 |
128312 | 221938 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 36 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6002640.28984 | 2096352.56391 | 37.7363343706279 | -122.433335224139 | (37.7363343706279, -122.433335224139) | 2 | 7 | 5 | 63 | 7 | |||
63785 | 158240 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 225 Bemis St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/2018 12:00:00 AM | 3 | 3x3 | Permit Number 778932 | 6003134.83556 | 2096356.78559 | 37.7363740064603 | -122.43162567588 | (37.7363740064603, -122.43162567588) | 2 | 7 | 5 | 63 | 7 |
117767 | 158241 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 225 Bemis St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/2018 12:00:00 AM | 3 | 3x3 | Permit Number 778932 | 6003145.71012 | 2096365.89505 | 37.7363996353363 | -122.431588728148 | (37.7363996353363, -122.431588728148) | 2 | 7 | 5 | 63 | 7 |
38682 | 158242 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 225 Bemis St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/2018 12:00:00 AM | 3 | 3x3 | Permit Number 778932 | 6003158.9626 | 2096376.80466 | 37.7364303417798 | -122.431543687401 | (37.7364303417798, -122.431543687401) | 2 | 7 | 5 | 63 | 7 |
58635 | 63004 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 368 Highland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/22/1986 12:00:00 AM | 20 | 4x6 | Permit Number 23414 | 6007279.07639479 | 2096499.56656681 | 37.7370000828457 | -122.417307379598 | (37.7370000828457, -122.417307379598) | 2 | 7 | 7 | 28859 | 2 |
132523 | 115548 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 368 Highland Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 20 | 4x6 | 6007279.07639479 | 2096499.56656681 | 37.7370000828457 | -122.417307379598 | (37.7370000828457, -122.417307379598) | 2 | 7 | 7 | 28859 | 2 | ||
17657 | 221821 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 368 Highland Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | 3x5 | 6007305.19909 | 2096505.34711 | 37.7370174246124 | -122.417217471014 | (37.7370174246124, -122.417217471014) | 2 | 7 | 7 | 28859 | 2 | |||
1806 | 221820 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 368 Highland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 2ft | 6007294.28583 | 2096507.5919 | 37.7370229743371 | -122.417255362169 | (37.7370229743371, -122.417255362169) | 2 | 7 | 7 | 28859 | 2 | |||
19306 | 221827 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 499X Tompkins Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6008328.718 | 2096529.81834 | 37.7371421461853 | -122.413680425731 | (37.7371421461853, -122.413680425731) | 2 | 7 | 7 | 28859 | 2 | |||
12895 | 221826 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 499X Tompkins Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6008314.44854 | 2096531.09899 | 37.7371448612571 | -122.413729852457 | (37.7371448612571, -122.413729852457) | 2 | 7 | 7 | 28859 | 2 | |||
2752 | 221825 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 499X Tompkins Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6008302.15962 | 2096532.14097 | 37.7371470321954 | -122.41377241466 | (37.7371470321954, -122.41377241466) | 2 | 7 | 7 | 28859 | 2 | |||
3681 | 106711 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 3990 FOLSOM ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008366.1 | 2096547.2 | 37.7371919715517 | -122.413552407719 | (37.7371919715517, -122.413552407719) | 2 | 7 | 7 | 28859 | 2 | |||||
152810 | 94662 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 252 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53799 | 6004605 | 2096922 | 37.7380091791898 | -122.426582934947 | (37.7380091791898, -122.426582934947) | 2 | 7 | 5 | 63 | 7 | |
136628 | 221862 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 252 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6004616.62035 | 2096933.09811 | 37.7380403090218 | -122.426543547661 | (37.7380403090218, -122.426543547661) | 2 | 7 | 5 | 63 | 7 | |||
35034 | 221861 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 246 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6004637.65749 | 2096950.59035 | 37.7380895280136 | -122.426472056954 | (37.7380895280136, -122.426472056954) | 2 | 7 | 5 | 63 | 7 | |||
133428 | 94661 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 246 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53798 | 6004650 | 2096961 | 37.7381188082759 | -122.426430123703 | (37.7381188082759, -122.426430123703) | 2 | 7 | 5 | 63 | 7 | |
32001 | 221822 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 129 Ellert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6007356.42456 | 2097004.67982 | 37.7383913638823 | -122.417075731561 | (37.7383913638823, -122.417075731561) | 2 | 7 | 7 | 28859 | 2 | |||
60245 | 108910 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 129 Ellert St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | FUF | 01/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773054 | 6007361.2 | 2097016.9 | 37.7384251864379 | -122.417060086005 | (37.7384251864379, -122.417060086005) | 2 | 7 | 7 | 28859 | 2 |
4034 | 158226 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 217 Whitney St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | 3x3 | 6004403.18115 | 2097173.01672 | 37.7386870025035 | -122.427298598675 | (37.7386870025035, -122.427298598675) | 2 | 7 | 5 | 63 | 7 | |||
153032 | 243747 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 217 Whitney St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2018 12:00:00 AM | 3 | Width 2ft | Permit Number 780010 | 6004399.27823 | 2097187.62567 | 37.7387268946327 | -122.427313133507 | (37.7387268946327, -122.427313133507) | 2 | 7 | 5 | 63 | 7 | |
23185 | 241540 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 191 Fairmount St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2018 12:00:00 AM | 3 | Width 2ft | Permit Number 780010 | 6004426.52656 | 2097222.39048 | 37.7388238918993 | -122.427221397276 | (37.7388238918993, -122.427221397276) | 2 | 7 | 5 | 63 | 7 | |
89515 | 221937 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 31 Fairmount St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6005028.18878 | 2097255.91505 | 37.7389499498753 | -122.425143513686 | (37.7389499498753, -122.425143513686) | 2 | 7 | 5 | 63 | 7 | |||
154695 | 4846 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 210 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/27/1992 12:00:00 AM | 15 | 3X3 | 6006713.9746 | 2097429.76412 | 37.7395223890352 | -122.419327161814 | (37.7395223890352, -122.419327161814) | 2 | 7 | 7 | 28859 | 2 | ||
121688 | 4845 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 202 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/27/1992 12:00:00 AM | 24 | 3X3 | 6006694.31051 | 2097440.2331 | 37.7395500270059 | -122.41939589432 | (37.7395500270059, -122.41939589432) | 2 | 7 | 7 | 28859 | 2 | ||
142834 | 33539 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 253 BOCANA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/06/2015 12:00:00 AM | 4x4 | Permit Number 775951 | 6007035 | 2097463 | 37.7396317225537 | -122.418219548801 | (37.7396317225537, -122.418219548801) | 2 | 7 | 7 | 28859 | 2 | ||
4442 | 221873 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 253 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6007019.01293 | 2097474.10434 | 37.7396613127072 | -122.418275612445 | (37.7396613127072, -122.418275612445) | 2 | 7 | 7 | 28859 | 2 | |||
64032 | 221815 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3734 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6008428.67762 | 2097499.17078 | 37.7398093887782 | -122.413403351802 | (37.7398093887782, -122.413403351802) | 2 | 7 | 7 | 28859 | 2 | |||
154673 | 221886 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 121 Santa Marina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6006322.71195 | 2097511.22057 | 37.7397240062552 | -122.420685761336 | (37.7397240062552, -122.420685761336) | 2 | 7 | 7 | 28859 | 2 | |||
121889 | 221935 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 102 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 4ft | 6004836.87593 | 2097581.93653 | 37.7398343216046 | -122.425828185523 | (37.7398343216046, -122.425828185523) | 2 | 7 | 5 | 63 | 7 | |||
64776 | 221819 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 68 Santa Marina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006048.67396 | 2097610.71259 | 37.7399817402673 | -122.421640334157 | (37.7399817402673, -122.421640334157) | 2 | 7 | 7 | 28859 | 2 | |||
35544 | 221939 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 21 Harry St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 8ft | 6003408.10773 | 2097774.81236 | 37.740283068906 | -122.430782023672 | (37.740283068906, -122.430782023672) | 2 | 7 | 5 | 63 | 7 | |||
3673 | 221872 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 619 Eugenia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007332.3833 | 2097776.98457 | 37.740510589287 | -122.417213566178 | (37.740510589287, -122.417213566178) | 2 | 7 | 7 | 28859 | 2 | |||
79681 | 221871 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 619 Eugenia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007314.53376 | 2097779.75076 | 37.7405171804218 | -122.417275479073 | (37.7405171804218, -122.417275479073) | 2 | 7 | 7 | 28859 | 2 | |||
172119 | 64418 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 76 Harper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/11/1988 12:00:00 AM | Permit Number 25266 | 6003598.76227624 | 2097871.53968329 | 37.7405594599669 | -122.430129715298 | (37.7405594599669, -122.430129715298) | 2 | 7 | 5 | 63 | 7 | ||
145041 | 221874 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 371 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 29 | Width 3ft | 6006129.02794 | 2097974.50861 | 37.7409851732348 | -122.421388331502 | (37.7409851732348, -122.421388331502) | 2 | 7 | 7 | 28859 | 2 | |||
98307 | 64417 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 48 Harper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/03/1988 12:00:00 AM | Permit Number 25265 | 6003653.48603698 | 2098020.8724606 | 37.7409725927511 | -122.429951151332 | (37.7409725927511, -122.429951151332) | 2 | 7 | 5 | 63 | 7 | ||
130024 | 221936 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 48 Harper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6003658.55433 | 2098021.59816 | 37.7409748723836 | -122.429933678794 | (37.7409748723836, -122.429933678794) | 2 | 7 | 5 | 63 | 7 | |||
71384 | 221875 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 319 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 4ft | 6006211.14692 | 2098216.1896 | 37.7416534045787 | -122.421121550328 | (37.7416534045787, -122.421121550328) | 2 | 7 | 7 | 28859 | 2 | |||
69147 | 33484 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 300 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/1996 12:00:00 AM | 30 | 6x6 | Permit Number 37610 | 6006227.43678663 | 2098258.25526822 | 37.741769825751 | -122.421068211473 | (37.741769825751, -122.421068211473) | 2 | 7 | 7 | 28859 | 2 |
168785 | 221814 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 78 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007954.65071 | 2098276.18605 | 37.7419162746098 | -122.415097327373 | (37.7419162746098, -122.415097327373) | 2 | 7 | 7 | 28859 | 2 | |||
84530 | 62373 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 451 30th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1987 12:00:00 AM | Permit Number 24914 | 6003654.71208885 | 2098328.44048503 | 37.741817173247 | -122.429968846467 | (37.741817173247, -122.429968846467) | 2 | 7 | 5 | 63 | 7 | ||
162352 | 4572 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 233 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/2015 12:00:00 AM | 1 | 6x6 | Permit Number 775065 | 6006398.09865 | 2098473.12689 | 37.742369434016 | -122.420493366683 | (37.742369434016, -122.420493366683) | 2 | 7 | 7 | 28859 | 2 | |
87022 | 64145 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 447 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1987 12:00:00 AM | Permit Number 24920 | 6002941.41423586 | 2098582.0522051 | 37.7424731102471 | -122.432453304275 | (37.7424731102471, -122.432453304275) | 2 | 7 | 5 | 63 | 22 | ||
161874 | 59173 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 327 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1992 12:00:00 AM | Permit Number 18486 | 6003820.21364245 | 2098630.45378724 | 37.742655803759 | -122.429418128827 | (37.742655803759, -122.429418128827) | 2 | 7 | 5 | 63 | 22 | ||
183461 | 221802 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 325 Day St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 18 | Width 3ft | 6003816.24882 | 2098634.77002 | 37.7426674306639 | -122.42943214577 | (37.7426674306639, -122.42943214577) | 2 | 7 | 5 | 63 | 22 | |||
98833 | 64258 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 184 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/03/1988 12:00:00 AM | Permit Number 25059 | 6004745.64406041 | 2098733.50242163 | 37.742991103255 | -122.426225591142 | (37.742991103255, -122.426225591142) | 2 | 7 | 5 | 63 | 22 | ||
93692 | 221803 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 118 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 4ft | 6005068.88763 | 2098748.30494 | 37.743050013041 | -122.42510895543 | (37.743050013041, -122.42510895543) | 2 | 7 | 5 | 63 | 22 | |||
165722 | 64259 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 118 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/03/1988 12:00:00 AM | Permit Number 25060 | 6005164.43101867 | 2098756.56789098 | 37.7430780980429 | -122.424779179687 | (37.7430780980429, -122.424779179687) | 2 | 7 | 5 | 63 | 22 | ||
100205 | 221884 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 230 Esmeralda Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 5ft | 6007166.67292 | 2098807.97162 | 37.7433321258706 | -122.417859593245 | (37.7433321258706, -122.417859593245) | 2 | 7 | 7 | 28859 | 2 | |||
185506 | 63233 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 200x ESMERALDA AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/13/1987 12:00:00 AM | Permit Number 23781 | 6007093 | 2098828 | 37.7433829729046 | -122.41811575542 | (37.7433829729046, -122.41811575542) | 2 | 7 | 7 | 28859 | 2 | ||
168332 | 64134 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 553 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1987 12:00:00 AM | Permit Number 24905 | 6003001.41812219 | 2098877.69698992 | 37.743288284611 | -122.432266938445 | (37.743288284611, -122.432266938445) | 2 | 7 | 5 | 63 | 22 | ||
75026 | 64105 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 531 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/1987 12:00:00 AM | Permit Number 24871 | 6003137.00791589 | 2098885.2523176 | 37.7433167168502 | -122.431798643811 | (37.7433167168502, -122.431798643811) | 2 | 7 | 5 | 63 | 22 |
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) );