trees
930 rows where qSpecies_id = 65 sorted by PlantDate descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
19773 | 113547 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2017 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/30/2015 12:00:00 AM | 1 | Permit Number 775016 | 6011715.20847 | 2105100.54779 | 37.7608650971692 | -122.40257424272 | (37.7608650971692, -122.40257424272) | 10 | 3 | 8 | 28856 | 29 | ||
188936 | 113546 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2017 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/30/2015 12:00:00 AM | 1 | Permit Number 775016 | 6011705.09048 | 2105100.13383 | 37.7608633956443 | -122.402609207467 | (37.7608633956443, -122.402609207467) | 10 | 3 | 8 | 28856 | 29 | ||
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 | ||
101142 | 65305 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 3629 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/1989 12:00:00 AM | Permit Number 28122 | 6005455.44263685 | 2104863.06150764 | 37.7598615508482 | -122.424207139046 | (37.7598615508482, -122.424207139046) | 2 | 4 | 5 | 28859 | 19 | ||
183603 | 67515 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 179 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/22/1992 12:00:00 AM | Permit Number 31051 | 5998906.63498153 | 2093763.92891486 | 37.7290140653184 | -122.446057838601 | (37.7290140653184, -122.446057838601) | 9 | 7 | 4 | 28861 | 40 | ||
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 |
145878 | 100940 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1470 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/20/2012 12:00:00 AM | 0 | Permit Number 769322 | 5982213.5 | 2105098.8 | 37.7591690876422 | -122.504605773131 | (37.7591690876422, -122.504605773131) | 1 | 8 | 3 | 56 | 35 | ||
156056 | 62982 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1391 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/20/1991 12:00:00 AM | 20 | Permit Number 30047 | 6006920.35815 | 2118393.21581 | 37.7970946941148 | -122.420100923242 | (37.7970946941148, -122.420100923242) | 5 | 1 | 10 | 28858 | 32 | |
164826 | 66782 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1001 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/20/1991 12:00:00 AM | 14 | Permit Number 30052 | 6006921.4512 | 2120474.40868 | 37.8028091860666 | -122.420244926256 | (37.8028091860666, -122.420244926256) | 5 | 1 | 1 | 28858 | 32 | |
60145 | 38581 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1483 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | 15 | Permit Number 40541 | 6015866.8585 | 2094128.4257 | 37.7309688285238 | -122.387449938884 | (37.7309688285238, -122.387449938884) | 10 | 3 | 8 | 58 | 1 | |
165874 | 38552 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1820 Keith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | 16 | Permit Number 40520 | 6015364.9925 | 2093693.5794 | 37.7297470188732 | -122.389154637038 | (37.7297470188732, -122.389154637038) | 10 | 3 | 8 | 58 | 1 | |
102715 | 67506 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 431 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/16/1992 12:00:00 AM | Permit Number 31036 | 5997894.54403764 | 2094074.0284741 | 37.7298076778319 | -122.449579034013 | (37.7298076778319, -122.449579034013) | 9 | 7 | 4 | 28861 | 40 | ||
6446 | 262161 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 8 Mill St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/07/2019 12:00:00 AM | 3 | ||||||||||||
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 | ||
6932 | 112764 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 145 Lakeview Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/2015 12:00:00 AM | Permit Number 774164 | 5997123.4 | 2089342.1 | 37.7167707693614 | -122.45190370908 | (37.7167707693614, -122.45190370908) | 9 | 8 | 6 | 28861 | 24 | ||
103379 | 60473 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 145 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/2015 12:00:00 AM | Permit Number 774164 | 5997228.1128738 | 2089314.92516138 | 37.7167021506206 | -122.451539811129 | (37.7167021506206, -122.451539811129) | 9 | 8 | 6 | 28861 | 24 | |||
8836 | 262545 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 1919 Donner Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/18/2020 12:00:00 AM | 3 | 3x3 | 6011672 | 2093386 | 37.7286970547273 | -122.401900181645 | (37.7286970547273, -122.401900181645) | 10 | 3 | 8 | 58 | 1 | ||
150990 | 64607 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 2451 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/18/1988 12:00:00 AM | 20 | Permit Number 25510 | 6008240.6573587 | 2104159.54552526 | 37.7580867271242 | -122.414524628823 | (37.7580867271242, -122.414524628823) | 2 | 4 | 7 | 28859 | 19 | |
65829 | 68256 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 243 Holyoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | 16 | Permit Number 32061 | 6009551.9423 | 2093241.4503 | 37.7281816043806 | -122.409219186739 | (37.7281816043806, -122.409219186739) | 10 | 3 | 7 | 309 | 28 | |
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 | ||
190011 | 66065 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 615 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/06/1990 12:00:00 AM | 15 | Permit Number 29105 | 6013588.8129 | 2104207.15934 | 37.7585164708659 | -122.396031617282 | (37.7585164708659, -122.396031617282) | 10 | 3 | 8 | 28856 | 29 | |
106236 | 120108 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 3528 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/03/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778087 | 6004858 | 2103141 | 37.7550994230029 | -122.426150804554 | (37.7550994230029, -122.426150804554) | 2 | 4 | 5 | 28862 | 22 | |
94208 | 52929 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 22 Cotter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2006 12:00:00 AM | 3 | 3x3 | Permit Number 48913 | 6002555.71096 | 2093126.63865 | 37.7274719160952 | -122.433397195531 | (37.7274719160952, -122.433397195531) | 9 | 7 | 6 | 28861 | 25 |
3705 | 244981 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 200 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 07/31/2019 12:00:00 AM | 3 | Width 0ft | Permit Number 781995 | 6005180.5539 | 2109687.8318 | 37.7730936920725 | -122.425501217452 | (37.7730936920725, -122.425501217452) | 7 | 9 | 11 | 28852 | 10 |
155728 | 67419 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 507 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/30/1992 12:00:00 AM | 21 | Permit Number 30920 | 5990601.19445 | 2111910.61451 | 37.7783623005847 | -122.476094929494 | (37.7783623005847, -122.476094929494) | 11 | 6 | 2 | 55 | 26 | |
105607 | 95918 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 682 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767617 | 5991324.67511 | 2110779.55477 | 37.7752986449747 | -122.473509641895 | (37.7752986449747, -122.473509641895) | 11 | 6 | 2 | 54 | 26 |
32465 | 96841 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 4426 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2011 12:00:00 AM | 3 | 3x3 | Permit Number 54781 | 5981806.97545 | 2111010.8887 | 37.7753780521761 | -122.506450142023 | (37.7753780521761, -122.506450142023) | 11 | 6 | 2 | 55 | 26 |
188964 | 96074 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 439 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2011 12:00:00 AM | 3x3 | Permit Number 767700 | 5983724.3 | 2112865.2 | 37.7805821513852 | -122.499954873055 | (37.7805821513852, -122.499954873055) | 11 | 6 | 2 | 55 | 26 | |
754 | 34739 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 581 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | 3x3 | Permit Number 38389 | 6007302.61875581 | 2103939.58827334 | 37.7574300317864 | -122.417753185833 | (37.7574300317864, -122.417753185833) | 2 | 4 | 7 | 28859 | 19 | |
83852 | 67386 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 725 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1992 12:00:00 AM | Permit Number 30883 | 5991613.49950521 | 2110478.88524866 | 37.7744898098292 | -122.47248861667 | (37.7744898098292, -122.47248861667) | 11 | 6 | 2 | 54 | 26 | ||
1576 | 260532 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1759 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 07/27/2019 12:00:00 AM | 3 | 5982834.94 | 2103154.54026 | 37.7538672331819 | -122.502312683451 | (37.7538672331819, -122.502312683451) | 1 | 8 | 3 | 56 | 35 | ||
155578 | 95909 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1455 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767610 | 5987104.5752 | 2105375.1658 | 37.7602144045714 | -122.487710617324 | (37.7602144045714, -122.487710617324) | 1 | 8 | 3 | 56 | 35 |
58364 | 27336 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 615 Bosworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/2000 12:00:00 AM | 3 | 2X3 | 6002282.10236 | 2095328.35794 | 37.7335018092598 | -122.434500417276 | (37.7335018092598, -122.434500417276) | 9 | 7 | 5 | 63 | 40 | ||
36087 | 67371 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1009 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1992 12:00:00 AM | 17 | Permit Number 30864 | 5992480.35304 | 2110659.61111 | 37.7750361697588 | -122.469503188985 | (37.7750361697588, -122.469503188985) | 11 | 6 | 2 | 54 | 11 | |
174591 | 51092 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1962 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/26/2004 12:00:00 AM | 8 | Permit Number 47549 | 5987266.4855 | 2101911.4788 | 37.7507135030867 | -122.486896287824 | (37.7507135030867, -122.486896287824) | 1 | 8 | 3 | 29491 | 35 | ||
65306 | 43793 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 170 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/26/2000 12:00:00 AM | 6 | Permit Number 43423 | 5989012.43621 | 2114211.91029 | 37.7845887590001 | -122.481759578125 | (37.7845887590001, -122.481759578125) | 11 | 6 | 2 | 55 | 26 | |
174046 | 37616 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 462 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/26/2000 12:00:00 AM | 17 | Permit Number 43442 | 5990631.36651 | 2112225.85325 | 37.7792296086918 | -122.476013583462 | (37.7792296086918, -122.476013583462) | 11 | 6 | 2 | 54 | 26 | |
9355 | 43688 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 219 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | 4 | 4x6 | Permit Number 43332 | 5993346.74324 | 2114008.67547 | 37.7842818271711 | -122.466749684627 | (37.7842818271711, -122.466749684627) | 11 | 6 | 2 | 54 | 11 |
21660 | 65231 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 812 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/1989 12:00:00 AM | 10 | Permit Number 28018 | 6008328.075 | 2093605.15348 | 37.7291116131036 | -122.41347586773 | (37.7291116131036, -122.41347586773) | 9 | 3 | 7 | 309 | 28 | ||
6929 | 160451 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 99 France Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2020 12:00:00 AM | 3 | Width 0ft | 6001258.21118 | 2090347.83316 | 37.7197682487796 | -122.437683721428 | (37.7197682487796, -122.437683721428) | 9 | 7 | 6 | 28861 | 5 | ||
8169 | 160453 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 99 France Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2020 12:00:00 AM | 3 | Width 0ft | 6001205.1197 | 2090381.66789 | 37.7198581324333 | -122.437869661652 | (37.7198581324333, -122.437869661652) | 9 | 7 | 6 | 28861 | 5 | ||
13377 | 160452 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 99 France Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2020 12:00:00 AM | 3 | Width 0ft | 6001241.76743 | 2090358.86031 | 37.719797591855 | -122.437741350891 | (37.719797591855, -122.437741350891) | 9 | 7 | 6 | 28861 | 5 | ||
15492 | 262409 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 99 France Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2020 12:00:00 AM | 3 | Width 0ft | 6001205.1197 | 2090381.66789 | 37.7198581324333 | -122.437869661652 | (37.7198581324333, -122.437869661652) | 9 | 7 | 6 | 28861 | 5 | ||
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 | ||
43175 | 38227 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1099 Mississippi St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/1998 12:00:00 AM | 14 | Permit Number 40351 | 6014264.01456 | 2102105.05687 | 37.7527820922208 | -122.393549330162 | (37.7527820922208, -122.393549330162) | 10 | 3 | 8 | 28856 | 29 | ||
182539 | 38225 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1099 Mississippi St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/1998 12:00:00 AM | 13 | Permit Number 40351 | 6014263.22127 | 2102058.4146 | 37.7526539784223 | -122.39354880945 | (37.7526539784223, -122.39354880945) | 10 | 3 | 8 | 28856 | 29 | ||
151367 | 64508 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 841 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/21/1988 12:00:00 AM | 36 | Permit Number 25389 | 6000432.9415 | 2111897.9264 | 37.7788926598871 | -122.442082438032 | (37.7788926598871, -122.442082438032) | 15 | 5 | 11 | 29490 | 16 | |
21642 | 38204 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 691 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1998 12:00:00 AM | 14 | Permit Number 40328 | 6010720.89935 | 2091470.20831 | 37.7233835629968 | -122.405053372309 | (37.7233835629968, -122.405053372309) | 10 | 3 | 7 | 309 | 28 | |
43315 | 38214 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 331 Wayland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1998 12:00:00 AM | 11 | Permit Number 40337 | 6010588.27199 | 2092325.30166 | 37.7257240567036 | -122.405572039215 | (37.7257240567036, -122.405572039215) | 10 | 3 | 7 | 309 | 28 | |
46915 | 38203 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 691 Goettingen St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1998 12:00:00 AM | 14 | Permit Number 40328 | 6010707.71448 | 2091513.67595 | 37.7235021790704 | -122.405102009451 | (37.7235021790704, -122.405102009451) | 10 | 3 | 7 | 309 | 28 | |
59999 | 38206 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 756 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1998 12:00:00 AM | 11 | Permit Number 40330 | 6010781.48445 | 2091161.67808 | 37.7225397893635 | -122.404822228563 | (37.7225397893635, -122.404822228563) | 10 | 3 | 7 | 309 | 28 | |
54908 | 63857 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 317 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/16/1987 12:00:00 AM | Permit Number 24557 | 6002233.40181795 | 2109560.38159908 | 37.7725767859044 | -122.435686656968 | (37.7725767859044, -122.435686656968) | 15 | 5 | 11 | 29492 | 9 | ||
55347 | 63855 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 728 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/16/1987 12:00:00 AM | Permit Number 24554 | 6003932.92812606 | 2110451.32130531 | 37.7751194750929 | -122.429871382589 | (37.7751194750929, -122.429871382589) | 7 | 9 | 11 | 29492 | 10 | ||
103785 | 63866 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 879 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/16/1987 12:00:00 AM | Permit Number 24569 | 6002490.08825783 | 2103093.39072976 | 37.7548345785172 | -122.434336316133 | (37.7548345785172, -122.434336316133) | 2 | 4 | 5 | 28862 | 22 | ||
68583 | 38114 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1296 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/13/1998 12:00:00 AM | 7 | Permit Number 40278 | 5987111.1601 | 2106473.2531 | 37.7632298344396 | -122.487768520051 | (37.7632298344396, -122.487768520051) | 1 | 8 | 3 | 56 | 35 | |
88120 | 38113 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1296 29th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/13/1998 12:00:00 AM | 9 | Permit Number 40278 | 5987108.7979 | 2106493.9222 | 37.7632864483052 | -122.487778208637 | (37.7632864483052, -122.487778208637) | 1 | 8 | 3 | 56 | 35 | |
60347 | 62771 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1628 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/12/1986 12:00:00 AM | Permit Number 23125 | 5993111.44496049 | 2104385.34678202 | 37.7578451513046 | -122.466863908769 | (37.7578451513046, -122.466863908769) | 1 | 8 | 4 | 56 | 12 | ||
69330 | 62770 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1622 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/12/1986 12:00:00 AM | Permit Number 23124 | 5993110.09884511 | 2104424.43713032 | 37.7579524055375 | -122.466871405848 | (37.7579524055375, -122.466871405848) | 1 | 8 | 4 | 56 | 12 | ||
79432 | 41233 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3725 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/2014 12:00:00 AM | 3 | Permit Number 773159 | 6002526.96331 | 2121423.4126 | 37.8051663037497 | -122.435520011048 | (37.8051663037497, -122.435520011048) | 13 | 9 | 1 | 57 | 17 | |
72547 | 102082 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 577 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/09/2009 12:00:00 AM | 3x3 | Permit Number 52510 | 5994678.1 | 2111611.2 | 37.7777757479831 | -122.461969778855 | (37.7777757479831, -122.461969778855) | 11 | 6 | 2 | 54 | 11 | |
106840 | 82673 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 67 Jennings Ct | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52499 | 6012920.29338 | 2089198.31583 | 37.7172681083272 | -122.397291182543 | (37.7172681083272, -122.397291182543) | 10 | 3 | 8 | 58 | 1 | |
88150 | 82830 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1475 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2009 12:00:00 AM | 9 | 3x3 | Permit Number 52467 | 6015906.1825 | 2094100.414 | 37.7308940918936 | -122.387312034756 | (37.7308940918936, -122.387312034756) | 10 | 3 | 8 | 58 | 1 | |
133938 | 106164 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1366 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2015 12:00:00 AM | 3 | 3x3 | Permit Number 771080 | 5993998.9 | 2106208.9 | 37.7629033349313 | -122.463927108118 | (37.7629033349313, -122.463927108118) | 1 | 5 | 11 | 56 | 12 | |
53408 | 37793 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 347 Hamilton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/06/1998 12:00:00 AM | 15 | Permit Number 40121 | 6009401.77176 | 2092702.5768 | 37.7266935573585 | -122.409700314138 | (37.7266935573585, -122.409700314138) | 10 | 3 | 7 | 309 | 28 | |
125993 | 47976 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1515 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2002 12:00:00 AM | 2 | Permit Number 45710 | 5988978.856 | 2104994.3044 | 37.7592778047967 | -122.481200551177 | (37.7592778047967, -122.481200551177) | 1 | 8 | 3 | 56 | 35 | |
4010 | 32946 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 265 Arkansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/02/2018 12:00:00 AM | 3 | Permit Number 782101 | 6012936.74876 | 2105822.26722 | 37.7629149012172 | -122.398400087987 | (37.7629149012172, -122.398400087987) | 14 | 3 | 8 | 28856 | 29 | |
158774 | 83067 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 624 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 10 | 3x6 | Permit Number 52379 | 6012068.69574 | 2105475.40084 | 37.7619140888872 | -122.401378022999 | (37.7619140888872, -122.401378022999) | 10 | 3 | 8 | 28856 | 29 | |
186443 | 83009 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 622 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 10 | 3x3 | Permit Number 52378 | 6012068.99141 | 2105489.95153 | 37.7619540583423 | -122.401378022995 | (37.7619540583423, -122.401378022995) | 10 | 3 | 8 | 28856 | 29 | |
30504 | 37659 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 486 Funston Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2008 12:00:00 AM | 16 | 3x3 | Permit Number 51139 | 5991909.24916 | 2112157.7974 | 37.7791167592266 | -122.471587940686 | (37.7791167592266, -122.471587940686) | 11 | 6 | 2 | 54 | 11 | |
111637 | 37615 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 458 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1998 12:00:00 AM | 13 | Permit Number 40039 | 5990633.38312 | 2112269.25863 | 37.779348904808 | -122.476009778191 | (37.779348904808, -122.476009778191) | 11 | 6 | 2 | 54 | 26 | |
120648 | 37604 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 775 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1998 12:00:00 AM | 24 | Permit Number 40032 | 5992242.46027 | 2110184.69167 | 37.773718418011 | -122.470291511842 | (37.773718418011, -122.470291511842) | 11 | 6 | 2 | 54 | 11 | |
158169 | 37614 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 438 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1998 12:00:00 AM | 21 | Permit Number 40038 | 5990631.22382 | 2112392.71042 | 37.7796877441109 | -122.476026266792 | (37.7796877441109, -122.476026266792) | 11 | 6 | 2 | 54 | 26 | |
111705 | 74111 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 500X Avalon Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/1994 12:00:00 AM | 15 | 3x3 | 6003976.59234436 | 2092494.78352221 | 37.7258174919201 | -122.428440184616 | (37.7258174919201, -122.428440184616) | 9 | 7 | 6 | 28861 | 5 | ||
86506 | 42268 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1463 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | 3 | Permit Number 42509 | 5987415.8588 | 2105330.3292 | 37.7601094468303 | -122.486630755953 | (37.7601094468303, -122.486630755953) | 1 | 8 | 3 | 56 | 35 | |
64277 | 37529 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1244 Larkin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1998 12:00:00 AM | 21 | Permit Number 39976 | 6007263.39142 | 2115650.05703 | 37.7895819825607 | -122.418719304647 | (37.7895819825607, -122.418719304647) | 13 | 9 | 10 | 28858 | 21 | |
71978 | 37528 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1244 Larkin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1998 12:00:00 AM | 21 | Permit Number 39976 | 6007265.87204 | 2115633.53426 | 37.789536754768 | -122.418709549719 | (37.789536754768, -122.418709549719) | 13 | 9 | 10 | 28858 | 21 | |
107607 | 37527 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1244 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1998 12:00:00 AM | 19 | Permit Number 39976 | 6007268.1881 | 2115618.13797 | 37.7894946107457 | -122.418700444082 | (37.7894946107457, -122.418700444082) | 13 | 9 | 10 | 28858 | 21 | |
145545 | 249373 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 649 Jones St | 1 | : | Tree | Private 2 | 06/22/1998 12:00:00 AM | 21 | Width 4ft | Permit Number 39973 | 6008805.56783 | 2114728.16614 | 37.7871374013058 | -122.4133182966 | (37.7871374013058, -122.4133182966) | 5 | 1 | 10 | 28852 | 36 | |
33233 | 67291 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 701 Peru Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1992 12:00:00 AM | 19 | Permit Number 30767 | 6005304.50618 | 2092488.24493 | 37.725874593313 | -122.423849212975 | (37.725874593313, -122.423849212975) | 9 | 7 | 7 | 309 | 5 | |
55051 | 67285 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 119 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1992 12:00:00 AM | Permit Number 30761 | 6004716.66423484 | 2092675.63660854 | 37.7263559262182 | -122.425894675863 | (37.7263559262182, -122.425894675863) | 9 | 7 | 6 | 28861 | 5 | ||
4566 | 65966 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2644 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/1990 12:00:00 AM | 23 | Permit Number 28988 | 5989285.4992 | 2097339.4197 | 37.7382773344848 | -122.479579961543 | (37.7382773344848, -122.479579961543) | 1 | 8 | 3 | 29491 | 35 | |
85940 | 65809 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 2268 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/1990 12:00:00 AM | Permit Number 28777 | 5991325.30735018 | 2099972.38049218 | 37.7456250483576 | -122.472719302053 | (37.7456250483576, -122.472719302053) | 1 | 8 | 4 | 29491 | 40 | ||
83313 | 68880 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3633 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2018 12:00:00 AM | 3 | Permit Number 32851 | 6000180.50707 | 2120770.20455 | 37.8032392229736 | -122.443593228653 | (37.8032392229736, -122.443593228653) | 13 | 9 | 1 | 57 | 17 | |
31198 | 84402 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1852 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51006 | 6000688.3478 | 2111734.5053 | 37.778458498926 | -122.441187160325 | (37.778458498926, -122.441187160325) | 15 | 5 | 11 | 29490 | 41 | |
193961 | 63264 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 474 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1999 12:00:00 AM | Permit Number 23819 | 6003326.56560874 | 2102164.81247283 | 37.7523323660448 | -122.431377264225 | (37.7523323660448, -122.431377264225) | 2 | 4 | 5 | 28862 | 22 | ||
150684 | 31817 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 378 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | 11 | Permit Number 35283 | 6003458.13683 | 2099246.4861 | 37.7443267796662 | -122.43071403582 | (37.7443267796662, -122.43071403582) | 2 | 7 | 5 | 63 | 22 | |
17461 | 2783 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 424 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/17/2020 12:00:00 AM | 3 | 3X3 | Permit Number 785448 | 5994280.27723 | 2110781.18915 | 37.7754738485256 | -122.463285730589 | (37.7754738485256, -122.463285730589) | 11 | 6 | 2 | 54 | 11 | |
73034 | 94147 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1838 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/2010 12:00:00 AM | 3x3 | Permit Number 53552 | 5992870.9 | 2102941.4 | 37.7538665624087 | -122.467590799812 | (37.7538665624087, -122.467590799812) | 1 | 8 | 4 | 56 | 12 | ||
77208 | 37072 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1426 43rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | 14 | Permit Number 39847 | 5982799.9219 | 2105403.4894 | 37.7600401558558 | -122.502600230953 | (37.7600401558558, -122.502600230953) | 1 | 8 | 3 | 56 | 35 | |
183302 | 37071 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1426 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | 10 | Permit Number 39847 | 5982798.7178 | 2105383.4209 | 37.7599849826858 | -122.502602909857 | (37.7599849826858, -122.502602909857) | 1 | 8 | 3 | 56 | 35 | |
31637 | 117427 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 690 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/14/2016 12:00:00 AM | 3 | Permit Number 776915 | 6002940.91679 | 2089412.44819 | 37.7172954225231 | -122.431800455543 | (37.7172954225231, -122.431800455543) | 9 | 7 | 6 | 28861 | 5 | ||
134976 | 255531 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 2130 15th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782019 | 6003380.68215 | 2107148.89983 | 37.7660205449408 | -122.431545908158 | (37.7660205449408, -122.431545908158) | 15 | 5 | 5 | 28862 | 3 | |
172961 | 46374 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2135 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/08/2016 12:00:00 AM | 3 | Permit Number 778548 | 5982916.26389717 | 2100594.08542438 | 37.7468417151598 | -122.50184201898 | (37.7468417151598, -122.50184201898) | 1 | 8 | 3 | 29491 | 35 | |
19588 | 67246 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 4732 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/08/1992 12:00:00 AM | 21 | Permit Number 30710 | 5983966.26401 | 2111769.24931 | 37.777587186025 | -122.499036819383 | (37.777587186025, -122.499036819383) | 11 | 6 | 2 | 55 | 26 | |
26083 | 65485 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 436 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/08/1992 12:00:00 AM | Permit Number 30733 | 6004123.88206182 | 2110310.82859854 | 37.7747445284274 | -122.429200810683 | (37.7747445284274, -122.429200810683) | 7 | 9 | 11 | 28852 | 10 | ||
84903 | 67260 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 596 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/08/1992 12:00:00 AM | Permit Number 30727 | 5983830.17257963 | 2111769.87555254 | 37.7775809215722 | -122.499507644306 | (37.7775809215722, -122.499507644306) | 11 | 6 | 2 | 55 | 26 | ||
85408 | 67245 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 4738 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/08/1992 12:00:00 AM | 15 | Permit Number 30709 | 5983942.53029 | 2111768.14196 | 37.7775827533368 | -122.499118839179 | (37.7775827533368, -122.499118839179) | 11 | 6 | 2 | 55 | 26 | |
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 | ||
142288 | 67252 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 874 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/08/1992 12:00:00 AM | 25 | Permit Number 30716 | 5983584.68504 | 2109860.80212 | 37.7723247514813 | -122.500215683916 | (37.7723247514813, -122.500215683916) | 11 | 6 | 2 | 55 | 26 |
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) );