trees
930 rows where qSpecies_id = 65 sorted by DBH
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 95563 | 38954 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 293 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/30/2008 12:00:00 AM | 3x3 | Permit Number 50374 | 6000154.66929043 | 2094929.77821336 | 37.73228640687 | -122.441826941763 | (37.73228640687, -122.441826941763) | 9 | 7 | 4 | 63 | 40 | ||
| 95940 | 68849 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 230 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1993 12:00:00 AM | Permit Number 32812 | 5999215.30905725 | 2094104.51871766 | 37.7299668673625 | -122.44501520736 | (37.7299668673625, -122.44501520736) | 9 | 7 | 4 | 28861 | 40 | ||
| 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 | ||
| 98528 | 87814 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 2000 10th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/2008 12:00:00 AM | 3x3 | Permit Number 777426 | 5993220.6 | 2101817.5 | 37.750800806475 | -122.466299791721 | (37.750800806475, -122.466299791721) | 1 | 8 | 4 | 29491 | 40 | ||
| 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 | ||
| 100080 | 67827 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 429 Vicksburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1992 12:00:00 AM | Permit Number 31487 | 6004187.64685523 | 2101514.68763135 | 37.7505960386394 | -122.428353174015 | (37.7505960386394, -122.428353174015) | 2 | 4 | 5 | 28862 | 22 | ||
| 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 | ||
| 101694 | 94830 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1537 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/10/2010 12:00:00 AM | 3x3 | Permit Number 53908 | 5994260.8 | 2105105.8 | 37.7598895981479 | -122.462941258172 | (37.7598895981479, -122.462941258172) | 1 | 5 | 4 | 56 | 12 | |
| 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 | ||
| 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 | |||
| 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 | ||
| 104709 | 66250 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 718 Holloway Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/24/1990 12:00:00 AM | Permit Number 29350 | 5994696.57852166 | 2091262.84709817 | 37.721905383508 | -122.460431070774 | (37.721905383508, -122.460431070774) | 9 | 8 | 4 | 28861 | 24 | ||
| 105667 | 64297 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 219 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/18/1988 12:00:00 AM | Permit Number 25106 | 6005151.45554357 | 2098997.50110191 | 37.7437389128818 | -122.424841182538 | (37.7437389128818, -122.424841182538) | 2 | 7 | 5 | 63 | 22 | ||
| 107628 | 97552 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 250@Flood Detroit St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 42524 | 5999434 | 2093931 | 37.7295029047189 | -122.444246704733 | (37.7295029047189, -122.444246704733) | 9 | 7 | 4 | 63 | 40 | ||||
| 110235 | 87815 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 2000 10th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/2008 12:00:00 AM | 3x3 | Permit Number 777426 | 5993220.6 | 2101817.5 | 37.750800806475 | -122.466299791721 | (37.750800806475, -122.466299791721) | 1 | 8 | 4 | 29491 | 40 | ||
| 110639 | 83535 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1779 48th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2008 12:00:00 AM | 3x3 | Permit Number 50180 | 5981283.63190284 | 2102973.80068941 | 37.7532797037627 | -122.507663961783 | (37.7532797037627, -122.507663961783) | 1 | 8 | 3 | 56 | 35 | |||
| 111638 | 115173 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2063 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2016 12:00:00 AM | Permit Number 775267 | 5982265.3 | 2101066.7 | 37.7481011229623 | -122.504127955016 | (37.7481011229623, -122.504127955016) | 1 | 8 | 3 | 29491 | 35 | |||
| 112453 | 113209 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 50x DASHIELL HAMMETT ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x2 | 6010410 | 2116139 | 37.7911011617465 | -122.407866810246 | (37.7911011617465, -122.407866810246) | 5 | 1 | 10 | 28857 | 21 | ||||
| 114233 | 114349 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1240 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2016 12:00:00 AM | 3x15 | Permit Number 777354 | 5981849.8 | 2106648.5 | 37.7634027199113 | -122.50597849798 | (37.7634027199113, -122.50597849798) | 1 | 8 | 3 | 56 | 35 | ||
| 115535 | 94829 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1531 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/10/2010 12:00:00 AM | 3x3 | Permit Number 53907 | 5994259.9 | 2105131.8 | 37.75996093558 | -122.462946257172 | (37.75996093558, -122.462946257172) | 1 | 5 | 4 | 56 | 12 | |
| 116231 | 114809 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1271 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/11/2015 12:00:00 AM | Permit Number 775836 | 5987972.1 | 2106659.4 | 37.763791122625 | -122.484804508138 | (37.763791122625, -122.484804508138) | 1 | 8 | 3 | 56 | 35 | |||
| 118130 | 67911 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 66 Marston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | Permit Number 31614 | 5998875.49490681 | 2093226.9126308 | 37.7275377658836 | -122.446126879833 | (37.7275377658836, -122.446126879833) | 9 | 7 | 4 | 28861 | 40 | ||
| 121537 | 256166 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 200 Laguna St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 6005182.68808 | 2109644.93499 | 37.772976028407 | -122.425490781615 | (37.772976028407, -122.425490781615) | 7 | 9 | 11 | 28852 | 10 | ||||
| 122464 | 94832 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1212 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993646.6 | 2107243.8 | 37.7657245899289 | -122.465220756233 | (37.7657245899289, -122.465220756233) | 11 | 8 | 11 | 56 | 12 | ||||
| 123393 | 115172 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1255 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2016 12:00:00 AM | Permit Number 775163 | 5982077.3 | 2106555.6 | 37.7631610318136 | -122.505184777155 | (37.7631610318136, -122.505184777155) | 1 | 8 | 3 | 56 | 35 | |||
| 124672 | 94831 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1541 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/10/2010 12:00:00 AM | 3x3 | Permit Number 53909 | 5994261.6 | 2105082.3 | 37.759825119308 | -122.462936786411 | (37.759825119308, -122.462936786411) | 1 | 5 | 4 | 56 | 12 | |
| 126686 | 64148 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1545 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1987 12:00:00 AM | Permit Number 24927 | 6003347.08832902 | 2099252.09112644 | 37.7443358777099 | -122.431098417838 | (37.7443358777099, -122.431098417838) | 2 | 7 | 5 | 63 | 22 | ||
| 128238 | 64300 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 170 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/21/1987 12:00:00 AM | 6004802.69510738 | 2099321.91565877 | 37.7446099759611 | -122.426070203486 | (37.7446099759611, -122.426070203486) | 2 | 7 | 5 | 63 | 22 | |||
| 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 | ||
| 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 | ||
| 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 | |
| 135471 | 66323 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 274 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1990 12:00:00 AM | Permit Number 29440 | 6000269.21852417 | 2094980.11816522 | 37.7324311551198 | -122.441434530926 | (37.7324311551198, -122.441434530926) | 9 | 7 | 5 | 63 | 40 | ||
| 135492 | 115202 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1352 Sanchez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/19/2016 12:00:00 AM | Permit Number 775318 | 6003856.3 | 2100365.8 | 37.747422706117 | -122.429417077187 | (37.747422706117, -122.429417077187) | 2 | 7 | 5 | 63 | 22 | |||
| 135735 | 97220 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 120 Quintara St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2016 12:00:00 AM | Permit Number 776182 | 5993132 | 2101212 | 37.749133146159 | -122.466562169914 | (37.749133146159, -122.466562169914) | 1 | 8 | 4 | 29491 | 12 | |||
| 139304 | 97553 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 250@Flood Detroit St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 42524 | 5999434 | 2093931 | 37.7295029047189 | -122.444246704733 | (37.7295029047189, -122.444246704733) | 9 | 7 | 4 | 63 | 40 | ||||
| 141890 | 39929 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 137 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/1999 12:00:00 AM | Permit Number 767825 | 6010490.84450997 | 2087849.27835868 | 37.7134283686634 | -122.405593725995 | (37.7134283686634, -122.405593725995) | 9 | 7 | 8 | 309 | 39 | ||
| 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 | ||
| 145681 | 97551 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 199x FLOOD AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 42524 | 5999753 | 2094070 | 37.7299027608053 | -122.443153872698 | (37.7299027608053, -122.443153872698) | 9 | 7 | 4 | 63 | 40 | ||||
| 148866 | 67788 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 3879 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/1992 12:00:00 AM | Permit Number 31428 | 6003934.74347541 | 2102438.27189101 | 37.7531176706218 | -122.42929358548 | (37.7531176706218, -122.42929358548) | 2 | 4 | 5 | 28862 | 22 | ||
| 149484 | 64150 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 412 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1987 12:00:00 AM | Permit Number 24929 | 6003228.47286853 | 2099240.58677175 | 37.7442975672349 | -122.431507743694 | (37.7442975672349, -122.431507743694) | 2 | 7 | 5 | 63 | 22 | ||
| 149788 | 105062 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 530 07th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 771082 | 5993803.2 | 2111872 | 37.7784414265163 | -122.465015282122 | (37.7784414265163, -122.465015282122) | 11 | 6 | 2 | 54 | 11 | ||||
| 151523 | 55367 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 166 San Aleso Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/12/1996 12:00:00 AM | Permit Number 11301 | 5993332.6421826 | 2094501.86251048 | 37.730720369862 | -122.465380982848 | (37.730720369862, -122.465380982848) | 9 | 8 | 4 | 59 | 40 | ||
| 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 | |
| 156296 | 87374 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 149 Staples Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 50353 | 5999085.2 | 2093741.7 | 37.7289632252792 | -122.445438930282 | (37.7289632252792, -122.445438930282) | 9 | 7 | 4 | 28861 | 40 | |||
| 157166 | 106344 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 2428 14th Ave | 1 | Median : Cutout | Tree | Private 2 | 04/18/2014 12:00:00 AM | 3x3 | 5992079 | 2098890.7 | 37.7426986307713 | -122.470034423922 | (37.7426986307713, -122.470034423922) | 1 | 8 | 4 | 29491 | 40 | |||
| 158268 | 81935 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 23 Gaviota Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/25/2007 12:00:00 AM | 3x3 | Permit Number 49833 | 5998498.7012246 | 2097562.09988585 | 37.7394196374476 | -122.447741409302 | (37.7394196374476, -122.447741409302) | 9 | 7 | 4 | 59 | 40 | ||
| 159463 | 57100 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 3720 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/2012 12:00:00 AM | Permit Number 768635 | 6004924.75692274 | 2102545.44998856 | 37.7534679546686 | -122.425877549626 | (37.7534679546686, -122.425877549626) | 2 | 4 | 5 | 28862 | 22 | |||
| 160970 | 107168 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 65 SCOTT ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x2 | 6002336.3 | 2108640.7 | 37.7700574118158 | -122.435264926513 | (37.7700574118158, -122.435264926513) | 15 | 5 | 5 | 29492 | 9 | |||||
| 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 | ||
| 163176 | 67814 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 963 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/1992 12:00:00 AM | Permit Number 31468 | 6003800.96031756 | 2102663.38209888 | 37.7537281954709 | -122.429772288819 | (37.7537281954709, -122.429772288819) | 2 | 4 | 5 | 28862 | 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 | ||
| 166768 | 83830 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 4429 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2008 12:00:00 AM | 3x3 | Permit Number 50197 | 5981144.78735824 | 2104834.04535283 | 37.7583792247877 | -122.50828217567 | (37.7583792247877, -122.50828217567) | 1 | 8 | 3 | 56 | 35 | ||
| 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 | ||
| 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 | ||
| 171966 | 64298 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 217 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/18/1988 12:00:00 AM | Permit Number 25107 | 6005164.15015163 | 2098998.20846843 | 37.7437415721643 | -122.424797337889 | (37.7437415721643, -122.424797337889) | 2 | 7 | 5 | 63 | 22 | ||
| 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 | ||
| 172187 | 114784 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1350 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/09/2015 12:00:00 AM | Permit Number 773262 | 6000262.8 | 2113654.9 | 37.7837071608561 | -122.442797219915 | (37.7837071608561, -122.442797219915) | 15 | 6 | 1 | 29490 | 13 | |||
| 172746 | 256165 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 200 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 6005182.68808 | 2109644.93499 | 37.772976028407 | -122.425490781615 | (37.772976028407, -122.425490781615) | 7 | 9 | 11 | 28852 | 10 | ||||
| 172907 | 112365 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 501x 09TH AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993143 | 2111731 | 37.7780161887977 | -122.467288887933 | (37.7780161887977, -122.467288887933) | 11 | 6 | 2 | 54 | 11 | ||||
| 173139 | 98032 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 132 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995145 | 2113574 | 37.783191941507 | -122.460496884135 | (37.783191941507, -122.460496884135) | 11 | 6 | 2 | 54 | 11 | ||||
| 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 | ||
| 176909 | 68818 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 122 Detroit St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/30/1993 12:00:00 AM | Permit Number 32765 | 5999442.86322085 | 2093551.99082798 | 37.7284627395009 | -122.444188839651 | (37.7284627395009, -122.444188839651) | 9 | 7 | 4 | 63 | 40 | ||
| 178764 | 83799 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1200 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/23/2008 12:00:00 AM | 3x3 | Permit Number 53146 | 5982135.42302083 | 2106787.40938389 | 37.7638009337056 | -122.505000931873 | (37.7638009337056, -122.505000931873) | 1 | 8 | 3 | 56 | 35 | ||
| 178793 | 64789 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 214 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/10/1989 12:00:00 AM | Permit Number 25785 | 6002808.76039687 | 2109284.75060862 | 37.7718526350484 | -122.433676731328 | (37.7718526350484, -122.433676731328) | 15 | 5 | 11 | 29492 | 9 | ||
| 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 | ||
| 185139 | 114957 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 590 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2015 12:00:00 AM | Permit Number 770549 | 5993817 | 2111494.4 | 37.7774054340765 | -122.46494011266 | (37.7774054340765, -122.46494011266) | 11 | 6 | 2 | 54 | 11 | |||
| 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 | ||
| 185739 | 106345 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 2428 14th Ave | 2 | Median : Cutout | Tree | Private 2 | 04/18/2014 12:00:00 AM | 3x3 | 5992079 | 2098890.7 | 37.7426986307713 | -122.470034423922 | (37.7426986307713, -122.470034423922) | 1 | 8 | 4 | 29491 | 40 | |||
| 186665 | 87813 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 2000 10th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/2008 12:00:00 AM | 3x3 | Permit Number 777426 | 5993220.6 | 2101817.5 | 37.750800806475 | -122.466299791721 | (37.750800806475, -122.466299791721) | 1 | 8 | 4 | 29491 | 40 | ||
| 187355 | 115291 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1811 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2016 12:00:00 AM | Permit Number 775894 | 5990908.2 | 2103066.5 | 37.7540965389008 | -122.474387332213 | (37.7540965389008, -122.474387332213) | 1 | 8 | 4 | 56 | 12 | |||
| 188694 | 65036 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 69 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/15/1992 12:00:00 AM | Permit Number 31412 | 6002360.88534811 | 2108648.78551282 | 37.7700810087641 | -122.435180464659 | (37.7700810087641, -122.435180464659) | 15 | 5 | 5 | 29492 | 9 | ||
| 188754 | 94833 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 1208 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/10/2010 12:00:00 AM | 3x3 | Permit Number 53910 | 5993657.5 | 2107252.8 | 37.7657499301273 | -122.465183709555 | (37.7657499301273, -122.465183709555) | 11 | 8 | 11 | 56 | 12 | |
| 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 | |
| 189079 | 253703 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1221 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998953 | 2105574 | 37.7614443133046 | -122.446746977382 | (37.7614443133046, -122.446746977382) | 15 | 5 | 11 | 29492 | 12 | ||||
| 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 | ||
| 652 | 144195 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 630 42nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2020 12:17:00 PM | 0 | Width 4ft | 5982905.71974 | 2111464.01201 | 37.7766868258595 | -122.502682939079 | (37.7766868258595, -122.502682939079) | 11 | 6 | 2 | 55 | 26 | ||
| 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 | ||
| 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 | |||
| 6851 | 144169 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 638 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/15/2020 11:23:00 AM | 0 | Width 4ft | 5983217.80995 | 2111442.38703 | 37.7766457853136 | -122.501601744449 | (37.7766457853136, -122.501601744449) | 11 | 6 | 2 | 55 | 26 | ||
| 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 | ||
| 13145 | 144156 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 750 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2020 12:08:00 PM | 0 | Width 4ft | 5983244.96709 | 2110688.35529 | 37.774577028035 | -122.501452009119 | (37.774577028035, -122.501452009119) | 11 | 6 | 2 | 55 | 26 | ||
| 16050 | 144227 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 782 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2020 12:48:00 PM | 0 | Width 4ft | 5982631.55426 | 2110466.9997 | 37.7739332051856 | -122.503557493782 | (37.7739332051856, -122.503557493782) | 11 | 6 | 2 | 55 | 26 | ||
| 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 | ||
| 74291 | 164206 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2539 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 5991384.96424 | 2098131.18541 | 37.7405730525915 | -122.472378820421 | (37.7405730525915, -122.472378820421) | 1 | 8 | 4 | 29491 | 40 | |||
| 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 | ||
| 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 | |||
| 1710 | 51499 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1518 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/13/2005 12:00:00 AM | 1 | Permit Number 47812 | 5983157 | 2104773 | 37.758329986723 | -122.501318651686 | (37.758329986723, -122.501318651686) | 1 | 8 | 3 | 56 | 35 | ||
| 3963 | 203515 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 301 Ortega St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5993048.57106 | 2102513.42561 | 37.7527017117304 | -122.466945265911 | (37.7527017117304, -122.466945265911) | 1 | 8 | 4 | 29491 | 12 | |||
| 5498 | 183675 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1274 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5984003.8455 | 2106504.9034 | 37.7631350020634 | -122.498517860637 | (37.7631350020634, -122.498517860637) | 1 | 8 | 3 | 56 | 35 | |||
| 7243 | 203528 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 24 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 8ft | 5992568.77798 | 2096730.41145 | 37.7367953253409 | -122.46818381133 | (37.7367953253409, -122.46818381133) | 1 | 8 | 4 | 59 | 40 | |||
| 11272 | 221805 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1350 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6003874.14486 | 2100377.76702 | 37.7474565750744 | -122.429356224108 | (37.7474565750744, -122.429356224108) | 2 | 7 | 5 | 63 | 22 | |||
| 16596 | 203511 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1359 12th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5992377.24702 | 2106218.29367 | 37.7628355396396 | -122.469536476251 | (37.7628355396396, -122.469536476251) | 1 | 8 | 11 | 56 | 12 | |||
| 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 | ||
| 23012 | 97550 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 199x FLOOD AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | Permit Number 42524 | 5999753 | 2094070 | 37.7299027608053 | -122.443153872698 | (37.7299027608053, -122.443153872698) | 9 | 7 | 4 | 63 | 40 | ||
| 34536 | 221809 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1216 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5998224.25103 | 2106127.66613 | 37.7629228845101 | -122.449307297897 | (37.7629228845101, -122.449307297897) | 15 | 5 | 11 | 29492 | 9 | |||
| 35299 | 203521 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 54 Aloha Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5991886.81261 | 2104359.60659 | 37.757703719373 | -122.471097283818 | (37.757703719373, -122.471097283818) | 1 | 8 | 4 | 56 | 12 | |||
| 40098 | 182924 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2627 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5981795.9682 | 2097192.3992 | 37.7374357552632 | -122.505463727969 | (37.7374357552632, -122.505463727969) | 1 | 8 | 3 | 29491 | 35 | |||
| 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 | |||
| 59484 | 221933 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 4166 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001253.22781 | 2105851.44827 | 37.7623372504834 | -122.438811343586 | (37.7623372504834, -122.438811343586) | 15 | 5 | 5 | 28862 | 3 |
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) );