trees
930 rows where qSpecies_id = 65 sorted by Supervisor Districts 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
87625 | 221792 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2818 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6009842.62719 | 2102814.79283 | 37.7544842057885 | -122.408889429605 | (37.7544842057885, -122.408889429605) | 2 | 4 | 7 | 28859 | 19 | |||
88122 | 248073 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 440 Holladay Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 3ft | 6010194.15796 | 2098463.12553 | 37.7425551682987 | -122.407366975408 | (37.7425551682987, -122.407366975408) | 10 | 7 | 7 | 28859 | 2 | |||
88668 | 221892 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3272 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6007901.84296 | 2101535.98387 | 37.7508639830901 | -122.415510655785 | (37.7508639830901, -122.415510655785) | 2 | 4 | 7 | 28859 | 19 | |||
91243 | 221828 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1070 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6008613.25764 | 2102303.67809 | 37.7530118609308 | -122.413104786776 | (37.7530118609308, -122.413104786776) | 2 | 4 | 7 | 28859 | 19 | |||
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 | |||
93872 | 102475 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 581 Capp St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 38389 | 6007298 | 2103932 | 37.7574089362149 | -122.417768621509 | (37.7574089362149, -122.417768621509) | 2 | 4 | 7 | 28859 | 19 | |||
95633 | 221883 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 34 Prospect Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6007121.00835 | 2099271.28888 | 37.7446017212974 | -122.418050328662 | (37.7446017212974, -122.418050328662) | 2 | 7 | 7 | 28859 | 2 | |||
98506 | 221791 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 867 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/15/1991 12:00:00 AM | 30 | Width 6ft | Permit Number 29826 | 6010196.62735 | 2104192.74111 | 37.7582875664398 | -122.407762355146 | (37.7582875664398, -122.407762355146) | 10 | 4 | 7 | 28859 | 19 | |
99508 | 221835 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 585 Capp St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6007295.48201 | 2103941.69106 | 37.7574354039359 | -122.41777801665 | (37.7574354039359, -122.41777801665) | 2 | 4 | 7 | 28859 | 19 | |||
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 | |||
103566 | 248075 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 407 Holladay Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6010292.79484 | 2098665.98806 | 37.743117705012 | -122.407040212138 | (37.743117705012, -122.407040212138) | 10 | 7 | 7 | 28859 | 2 | |||
104017 | 35736 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 351 Hale St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/14/1998 12:00:00 AM | 9 | Permit Number 39011 | 6008805.61164 | 2094302.44729 | 37.731053034462 | -122.411874232722 | (37.731053034462, -122.411874232722) | 9 | 3 | 7 | 309 | 28 | |
104584 | 221882 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 36 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6007355.35831 | 2099292.63872 | 37.7446735303753 | -122.417241503608 | (37.7446735303753, -122.417241503608) | 2 | 7 | 7 | 28859 | 2 | |||
109510 | 221880 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 47 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 3ft | 6007035.70082 | 2099744.20537 | 37.7458954419332 | -122.418378831241 | (37.7458954419332, -122.418378831241) | 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 | ||
126786 | 248223 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 70 Fair Ave | 5 | Side Yard : Yard | Tree | Private 2 | 18 | 6007150.20605 | 2099339.87769 | 37.744791694087 | -122.417954229812 | (37.744791694087, -122.417954229812) | 2 | 7 | 7 | 28859 | 2 | ||||
129447 | 63292 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 3075 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1987 12:00:00 AM | Permit Number 23858 | 6009183.06965006 | 2100534.27317896 | 37.7481854410784 | -122.411009292537 | (37.7481854410784, -122.411009292537) | 2 | 4 | 7 | 28859 | 2 | ||
129894 | 69204 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 2850 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1994 12:00:00 AM | Permit Number 33252 | 6008949.31851966 | 2101859.27420808 | 37.7518104876034 | -122.411911217702 | (37.7518104876034, -122.411911217702) | 2 | 4 | 7 | 28859 | 19 | ||
130543 | 221890 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 190 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6006689.76882 | 2102684.09428 | 37.7539482278401 | -122.419783585763 | (37.7539482278401, -122.419783585763) | 2 | 4 | 7 | 28859 | 19 | |||
130795 | 81299 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 109 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 12 | 3x3 | Permit Number 50541 | 6006708.25661782 | 2103139.88479614 | 37.7552007652727 | -122.419751988993 | (37.7552007652727, -122.419751988993) | 2 | 4 | 7 | 28859 | 19 | |
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 | ||
132571 | 63129 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 34 Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/11/1986 12:00:00 AM | Permit Number 23643 | 6007144.61352889 | 2099320.79872129 | 37.7447389927671 | -122.417972215495 | (37.7447389927671, -122.417972215495) | 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 | ||
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 | |
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 | |||
146627 | 175215 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 857 Barneveld Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 33 | Width 8ft | 6010301.67863 | 2094727.33157 | 37.7323034959049 | -122.406731980322 | (37.7323034959049, -122.406731980322) | 10 | 3 | 7 | 309 | 28 | |||
148843 | 221818 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 36 Mirabel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6007500.06769 | 2099881.60431 | 37.7462988382332 | -122.416782843047 | (37.7462988382332, -122.416782843047) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |
152125 | 221834 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 581 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6007293.84054 | 2103959.34746 | 37.7574837919732 | -122.417784945026 | (37.7574837919732, -122.417784945026) | 2 | 4 | 7 | 28859 | 19 | |||
152526 | 221816 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 27 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6007421.73456 | 2099361.81155 | 37.7448671975643 | -122.417016887145 | (37.7448671975643, -122.417016887145) | 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 | |||
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 | ||
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 | |||
157705 | 221881 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 4 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 3ft | 6007048.87361 | 2099774.96937 | 37.7459806544792 | -122.418335462324 | (37.7459806544792, -122.418335462324) | 2 | 7 | 7 | 28859 | 2 | |||
159038 | 221793 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 26 Norwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 5ft | 6009169.37019 | 2099491.8572 | 37.745322428991 | -122.410983048655 | (37.745322428991, -122.410983048655) | 2 | 7 | 7 | 28859 | 2 | |||
160888 | 97263 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 220 Gaven St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773740 | 6009330.61336 | 2094994.97082 | 37.7329839958128 | -122.410108077526 | (37.7329839958128, -122.410108077526) | 10 | 3 | 7 | 309 | 28 | |
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 | |
162952 | 221836 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 585 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6007298.30885 | 2103900.40234 | 37.7573221936904 | -122.417765313729 | (37.7573221936904, -122.417765313729) | 2 | 4 | 7 | 28859 | 19 | |||
167156 | 69206 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 2864 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1994 12:00:00 AM | Permit Number 33255 | 6008953.68763074 | 2101781.1943032 | 37.7515963427841 | -122.411890591701 | (37.7515963427841, -122.411890591701) | 2 | 4 | 7 | 28859 | 19 | ||
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 | |||
179502 | 221830 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2451 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 4ft | 6008241.38226 | 2104159.63616 | 37.7580870167112 | -122.414522128209 | (37.7580870167112, -122.414522128209) | 2 | 4 | 7 | 28859 | 19 | |||
180514 | 221817 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 25 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 3ft | 6007435.65723 | 2099387.93304 | 37.7449397045122 | -122.416970595441 | (37.7449397045122, -122.416970595441) | 2 | 7 | 7 | 28859 | 2 | |||
183922 | 221794 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 63 Mullen Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009581.16571 | 2099887.27047 | 37.7464312301328 | -122.409587024721 | (37.7464312301328, -122.409587024721) | 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 | ||
188123 | 248074 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 440 Holladay Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6010189.61639 | 2098448.43347 | 37.742514572897 | -122.407381643363 | (37.742514572897, -122.407381643363) | 10 | 7 | 7 | 28859 | 2 | |||
138 | 203559 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 145 Lakeview Ave | 1 | : | Tree | Private 2 | 1 | Width 3ft | 5997146.51683 | 2089373.33367 | 37.7168578537955 | -122.45182605794 | (37.7168578537955, -122.45182605794) | 9 | 8 | 6 | 28861 | 24 | |||
730 | 160454 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 11 France Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 0 | Width 0ft | 6001177.46897 | 2090398.6691 | 37.7199032415307 | -122.437966457494 | (37.7199032415307, -122.437966457494) | 9 | 7 | 6 | 28861 | 5 | ||
1937 | 78248 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 734 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 14 | 6002539.24351 | 2089283.26415 | 37.716917933889 | -122.433179625239 | (37.716917933889, -122.433179625239) | 9 | 7 | 6 | 28861 | 5 | |||
2206 | 70527 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 25 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6004201.75826 | 2093380.33154 | 37.7282617492704 | -122.427724869209 | (37.7282617492704, -122.427724869209) | 9 | 7 | 6 | 28861 | 5 | |||
3053 | 262433 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 470 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 3x3 | 6001714 | 2091050 | 37.7217221467453 | -122.43615844491 | (37.7217221467453, -122.43615844491) | 9 | 7 | 6 | 28861 | 5 | |||
3223 | 70495 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 41 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6004160.99444 | 2093317.30941 | 37.7280863985552 | -122.427861302663 | (37.7280863985552, -122.427861302663) | 9 | 7 | 6 | 28861 | 5 | |||
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 | ||
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 | ||
7372 | 175205 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 653 Peru Ave | 6 | Side Yard : Yard | Tree | Private 2 | 15 | 6005071.6263 | 2092637.86098 | 37.7262722564417 | -122.424664901662 | (37.7262722564417, -122.424664901662) | 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 | ||
8943 | 73896 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 800 Excelsior Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6004393.10182 | 2091444.69797 | 37.7229577492801 | -122.426925586868 | (37.7229577492801, -122.426925586868) | 9 | 7 | 6 | 28861 | 5 | |||
9080 | 160643 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 556 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 0 | Width 0ft | 6001401.85862 | 2090517.84189 | 37.7202432212254 | -122.437199350171 | (37.7202432212254, -122.437199350171) | 9 | 7 | 6 | 28861 | 5 | ||
9579 | 74128 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 800 Excelsior Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6004381.29063 | 2091452.37119 | 37.7229781503978 | -122.426966961977 | (37.7229781503978, -122.426966961977) | 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 | ||
13433 | 161215 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 800 Brazil Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 3 | Width 0ft | 6003987.70302 | 2090927.51887 | 37.7215147582736 | -122.428290125502 | (37.7215147582736, -122.428290125502) | 9 | 7 | 6 | 28861 | 5 | ||
13672 | 70491 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 26 Ina Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 18 | 6005035.04728 | 2091735.87999 | 37.7237935486115 | -122.424727215697 | (37.7237935486115, -122.424727215697) | 9 | 7 | 6 | 28861 | 5 | |||
14111 | 74492 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 800 Excelsior Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6004373.61085 | 2091456.86354 | 37.7229900511464 | -122.42699382922 | (37.7229900511464, -122.42699382922) | 9 | 7 | 6 | 28861 | 5 | |||
14927 | 262428 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 99 France Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 6001205.1197 | 2090381.66789 | 37.7198581324333 | -122.437869661652 | (37.7198581324333, -122.437869661652) | 9 | 7 | 6 | 28861 | 5 | ||||
15089 | 175203 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 655 Peru Ave | 1 | Side Yard : Yard | Tree | Private 2 | 52 | 6005189.8347 | 2092537.12043 | 37.7260023204239 | -122.424249099221 | (37.7260023204239, -122.424249099221) | 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 | ||
16687 | 74647 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 800 Excelsior Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6004365.04367 | 2091463.54141 | 37.7230079026666 | -122.42702391962 | (37.7230079026666, -122.42702391962) | 9 | 7 | 6 | 28861 | 5 | |||
16813 | 160908 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 615 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/2019 12:00:00 AM | 3 | Width 0ft | 6002284.55838 | 2090317.50092 | 37.7197432674186 | -122.434133839205 | (37.7197432674186, -122.434133839205) | 9 | 7 | 6 | 28861 | 5 | |
18137 | 70176 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 307 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 14 | 3.5x4 to 3.5x7 | 6004287.81152 | 2091470.53201 | 37.7230227297861 | -122.42729139329 | (37.7230227297861, -122.42729139329) | 9 | 7 | 6 | 28861 | 5 | ||
19536 | 160455 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 11 France Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 0 | Width 0ft | 6001161.40103 | 2090408.94535 | 37.719930544037 | -122.438022734371 | (37.719930544037, -122.438022734371) | 9 | 7 | 6 | 28861 | 5 | ||
30708 | 175201 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 648 Peru Ave | 7 | Side Yard : Yard | Tree | Private 2 | 14 | 6005063.1365 | 2092591.26253 | 37.7261438278596 | -122.424690937041 | (37.7261438278596, -122.424690937041) | 9 | 7 | 6 | 28861 | 5 | ||||
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 | ||
36536 | 175211 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 66 Madison St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6005436.48818 | 2093200.64124 | 37.7278381272226 | -122.423443582752 | (37.7278381272226, -122.423443582752) | 9 | 7 | 6 | 28861 | 5 | |||
45102 | 52520 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 54 Norton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2005 12:00:00 AM | 30 | Permit Number 48621 | 6001810.81862 | 2092293.71669 | 37.7251426126309 | -122.4359127153 | (37.7251426126309, -122.4359127153) | 9 | 7 | 6 | 28861 | 25 | |
48865 | 175202 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 654 Peru Ave | 6 | Side Yard : Yard | Tree | Private 2 | 13 | 6005192.08696 | 2092525.09672 | 37.7259694331304 | -122.424240458534 | (37.7259694331304, -122.424240458534) | 9 | 7 | 6 | 28861 | 5 | ||||
50392 | 203557 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 377 Capitol Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5995020.43667 | 2088328.90175 | 37.7138680909275 | -122.459099244044 | (37.7138680909275, -122.459099244044) | 9 | 8 | 6 | 28861 | 24 | |||
50747 | 65523 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 721 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1990 12:00:00 AM | 21 | Permit Number 28410 | 6001369.75843 | 2089371.25057 | 37.7170931137224 | -122.437228255287 | (37.7170931137224, -122.437228255287) | 9 | 7 | 6 | 28861 | 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 | ||
55860 | 175179 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 450 Italy Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6001771.83891 | 2089201.36797 | 37.7166495024579 | -122.43582630935 | (37.7166495024579, -122.43582630935) | 9 | 7 | 6 | 28861 | 5 | |||
58638 | 175199 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 648 Peru Ave | 4 | Side Yard : Yard | Tree | Private 2 | 9 | 6005054.924 | 2092614.92051 | 37.7262083236385 | -122.424721009467 | (37.7262083236385, -122.424721009467) | 9 | 7 | 6 | 28861 | 5 | ||||
63762 | 53384 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 259 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/21/2016 12:00:00 AM | Permit Number 772607 | 5994713.25997575 | 2090306.35958478 | 37.7192800571495 | -122.460304141 | (37.7192800571495, -122.460304141) | 9 | 8 | 6 | 28861 | 24 | ||
63890 | 35857 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 28 Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/1998 12:00:00 AM | 28 | 4x6 | Permit Number 39076 | 6002203.07861 | 2092639.23336 | 37.7261135989609 | -122.434581409299 | (37.7261135989609, -122.434581409299) | 9 | 7 | 6 | 28861 | 25 |
65106 | 175181 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 690 Athens St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6002921.15596 | 2089379.53862 | 37.7172039398928 | -122.431866410902 | (37.7172039398928, -122.431866410902) | 9 | 7 | 6 | 28861 | 5 | |||
66364 | 175206 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 653 Peru Ave | 7 | Side Yard : Yard | Tree | Private 2 | 13 | 6005071.10082 | 2092642.69367 | 37.7262854962678 | -122.424667061852 | (37.7262854962678, -122.424667061852) | 9 | 7 | 6 | 28861 | 5 | ||||
69194 | 175204 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 653 Peru Ave | 1 | Side Yard : Yard | Tree | Private 2 | 7 | 6005107.43376 | 2092594.03644 | 37.72615394614 | -122.424538001034 | (37.72615394614, -122.424538001034) | 9 | 7 | 6 | 28861 | 5 | ||||
69898 | 175184 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 190 Newton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001047.00422 | 2087602.25445 | 37.7122174923141 | -122.438217204682 | (37.7122174923141, -122.438217204682) | 9 | 7 | 6 | 28861 | 5 | |||
69909 | 175176 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 226 Rome St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 3ft | 5998630.92665 | 2088821.65601 | 37.7154279802818 | -122.446655529047 | (37.7154279802818, -122.446655529047) | 9 | 7 | 6 | 28861 | 25 | |||
72092 | 175200 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 648 Peru Ave | 6 | Side Yard : Yard | Tree | Private 2 | 6 | 6005058.70512 | 2092602.03865 | 37.7261731664377 | -122.424707022338 | (37.7261731664377, -122.424707022338) | 9 | 7 | 6 | 28861 | 5 | ||||
73282 | 108847 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 970 Prague St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 772762 | 6001586.13513 | 2086816.33243 | 37.7100901720951 | -122.436297601751 | (37.7100901720951, -122.436297601751) | 9 | 7 | 6 | 28861 | 5 | |
76373 | 175196 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 149 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6002904.02638 | 2092823.59155 | 37.7266595719653 | -122.432171435767 | (37.7266595719653, -122.432171435767) | 9 | 7 | 6 | 28861 | 5 | |||
77660 | 175178 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 763 Morse St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5998593.8483 | 2087142.30255 | 37.7108147396853 | -122.44666292955 | (37.7108147396853, -122.44666292955) | 9 | 7 | 6 | 28861 | 5 | |||
80252 | 112745 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 179 Caine Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/22/2014 12:00:00 AM | Permit Number 774163 | 5997059.3 | 2088800.2 | 37.7152791660762 | -122.452086194059 | (37.7152791660762, -122.452086194059) | 9 | 8 | 6 | 28861 | 24 | ||
80295 | 175183 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 404 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6003446.11855 | 2091231.22966 | 37.7223180210418 | -122.430183890869 | (37.7223180210418, -122.430183890869) | 9 | 7 | 6 | 28861 | 5 | |||
83894 | 108683 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 384 Allison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774613 | 6000302.20846 | 2086863.37515 | 37.7101463059777 | -122.440738464824 | (37.7101463059777, -122.440738464824) | 9 | 7 | 6 | 28861 | 5 |
87773 | 203558 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 179 Caine Ave | 1 | : | Tree | Private 2 | 3 | Width 3ft | 5997048.33435 | 2088809.54157 | 37.7153041877202 | -122.45212476956 | (37.7153041877202, -122.45212476956) | 9 | 8 | 6 | 28861 | 24 | |||
93586 | 102654 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 203X Farallones St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 5995004 | 2088355 | 37.7139388056528 | -122.459157943572 | (37.7139388056528, -122.459157943572) | 9 | 8 | 6 | 28861 | 24 | |||
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 |
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 | |||
105309 | 35840 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 621 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/1998 12:00:00 AM | 18 | 6x7 | Permit Number 39067 | 6002271.78016 | 2090299.14404 | 37.7196921382746 | -122.434176697315 | (37.7196921382746, -122.434176697315) | 9 | 7 | 6 | 28861 | 5 |
107710 | 175194 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 522 Avalon Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6004004.48398 | 2092477.2158 | 37.7257708331541 | -122.428342513702 | (37.7257708331541, -122.428342513702) | 9 | 7 | 6 | 28861 | 5 |
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) );