trees
11,761 rows where qSpecies_id = 17 sorted by qAddress 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 32266 | 108871 | Property Tree 8 | Tree(s) :: 17 | 99x OAKWOOD ST | 1 | Back Yard : Yard | Tree | Private 2 | 6005305 | 2104962 | 37.7601247169433 | -122.424734485609 | (37.7601247169433, -122.424734485609) | 2 | 4 | 5 | 28859 | 19 | |||||
| 172870 | 117258 | Undocumented 4 | Tree(s) :: 17 | 99X PROSPER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x3 | 6003339 | 2106236 | 37.7635115803019 | -122.431624896471 | (37.7635115803019, -122.431624896471) | 15 | 4 | 5 | 28862 | 3 | ||||
| 2335 | 262272 | Undocumented 4 | Tree(s) :: 17 | 99X Glendale St | Unaccepted Street : Yard | Tree | Private 2 | 3x3 | 5999984 | 2103563 | 37.7559814441149 | -122.443036761048 | (37.7559814441149, -122.443036761048) | 2 | 5 | 5 | 28862 | 38 | |||||
| 6364 | 264920 | Significant Tree 6 | Tree(s) :: 17 | 99X Everglade Dr | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 11/10/2020 12:00:00 AM | 3 | 6x10 | Permit Number 785453 | 5986512 | 2095174 | 37.7321701636719 | -122.489010079787 | (37.7321701636719, -122.489010079787) | 1 | 8 | 4 | 64 | 35 | |
| 7796 | 264921 | Significant Tree 6 | Tree(s) :: 17 | 99X Everglade Dr | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 11/10/2020 12:00:00 AM | 3 | 6x10 | Permit Number 785453 | 5986512 | 2095174 | 37.7321701636719 | -122.489010079787 | (37.7321701636719, -122.489010079787) | 1 | 8 | 4 | 64 | 35 | |
| 145519 | 173778 | Significant Tree 6 | Tree(s) :: 17 | 99X Cleveland St | 1 | Side Yard : Cutout | Tree | Private 2 | 3x3 | 6010549 | 2110746 | 37.7763010397716 | -122.407005587048 | (37.7763010397716, -122.407005587048) | 14 | 2 | 9 | 28853 | 34 | ||||
| 184138 | 59646 | Permitted Site 7 | Tree(s) :: 17 | 999 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/1981 12:00:00 AM | Permit Number 19060 | 6002238.22079915 | 2109816.85060103 | 37.773281259813 | -122.435688339857 | (37.773281259813, -122.435688339857) | 15 | 5 | 11 | 29492 | 9 | |||
| 1892 | 124739 | DPW Maintained 1 | Tree(s) :: 17 | 999 Brannan St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010535.71931722 | 2108464.76902983 | 37.7700365636667 | -122.406890710328 | (37.7700365636667, -122.406890710328) | 14 | 2 | 9 | 28853 | 34 | |||||
| 25257 | 124734 | DPW Maintained 1 | Tree(s) :: 17 | 999 Brannan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010535.71931722 | 2108464.76902983 | 37.7700365636667 | -122.406890710328 | (37.7700365636667, -122.406890710328) | 14 | 2 | 9 | 28853 | 34 | |||||
| 42479 | 124733 | DPW Maintained 1 | Tree(s) :: 17 | 999 Brannan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010535.71931722 | 2108464.76902983 | 37.7700365636667 | -122.406890710328 | (37.7700365636667, -122.406890710328) | 14 | 2 | 9 | 28853 | 34 | |||||
| 67595 | 124740 | DPW Maintained 1 | Tree(s) :: 17 | 999 Brannan St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010535.71931722 | 2108464.76902983 | 37.7700365636667 | -122.406890710328 | (37.7700365636667, -122.406890710328) | 14 | 2 | 9 | 28853 | 34 | |||||
| 79355 | 124737 | DPW Maintained 1 | Tree(s) :: 17 | 999 Brannan St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010535.71931722 | 2108464.76902983 | 37.7700365636667 | -122.406890710328 | (37.7700365636667, -122.406890710328) | 14 | 2 | 9 | 28853 | 34 | |||||
| 84841 | 124735 | DPW Maintained 1 | Tree(s) :: 17 | 999 Brannan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010535.71931722 | 2108464.76902983 | 37.7700365636667 | -122.406890710328 | (37.7700365636667, -122.406890710328) | 14 | 2 | 9 | 28853 | 34 | |||||
| 118354 | 124738 | DPW Maintained 1 | Tree(s) :: 17 | 999 Brannan St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010535.71931722 | 2108464.76902983 | 37.7700365636667 | -122.406890710328 | (37.7700365636667, -122.406890710328) | 14 | 2 | 9 | 28853 | 34 | |||||
| 168080 | 124736 | DPW Maintained 1 | Tree(s) :: 17 | 999 Brannan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010535.71931722 | 2108464.76902983 | 37.7700365636667 | -122.406890710328 | (37.7700365636667, -122.406890710328) | 14 | 2 | 9 | 28853 | 34 | |||||
| 110827 | 56768 | Permitted Site 7 | Tree(s) :: 17 | 994 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/1974 12:00:00 AM | Permit Number 13987 | 6003117.251443 | 2102450.87538679 | 37.7531059622083 | -122.432121532394 | (37.7531059622083, -122.432121532394) | 2 | 4 | 5 | 28862 | 22 | |||
| 78520 | 57292 | Permitted Site 7 | Tree(s) :: 17 | 994 Geneva Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/27/1976 12:00:00 AM | Permit Number 16113 | 6000688.67615408 | 2088842.44530642 | 37.7156023927573 | -122.439544538542 | (37.7156023927573, -122.439544538542) | 9 | 7 | 6 | 28861 | 5 | |||
| 103160 | 91113 | Permitted Site 7 | Tree(s) :: 17 | 994 Corbett Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51999 | 5999620.1 | 2101651.4 | 37.7507119023651 | -122.444157886796 | (37.7507119023651, -122.444157886796) | 2 | 5 | 5 | 63 | 38 | |||
| 186254 | 53554 | Permitted Site 7 | Tree(s) :: 17 | 990 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/20/2016 12:00:00 AM | Permit Number 6466 | 6009376.89757939 | 2118082.87777148 | 37.7963806843446 | -122.411578723863 | (37.7963806843446, -122.411578723863) | 3 | 1 | 10 | 308 | 4 | |||
| 12315 | 56545 | Permitted Site 7 | Tree(s) :: 17 | 99 Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6006997.81069025 | 2098938.41719823 | 37.7436807955871 | -122.418452724226 | (37.7436807955871, -122.418452724226) | 2 | 7 | 7 | 28859 | 2 | |||||
| 181671 | 62893 | Permitted Site 7 | Tree(s) :: 17 | 99 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/1986 12:00:00 AM | Permit Number 23267 | 6012353.11575448 | 2119483.32983433 | 37.8003924841325 | -122.401378783456 | (37.8003924841325, -122.401378783456) | 3 | 1 | 10 | 28860 | 6 | |||
| 39332 | 31810 | Permitted Site 7 | Tree(s) :: 17 | 99 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/2015 12:00:00 AM | Permit Number 776677 | 6001914.86865911 | 2108255.52596642 | 37.7689758778799 | -122.436695073767 | (37.7689758778799, -122.436695073767) | 15 | 5 | 5 | 29492 | 3 | ||
| 49341 | 31812 | Permitted Site 7 | Tree(s) :: 17 | 99 Divisadero St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/2015 12:00:00 AM | Permit Number 776677 | 6001914.86865911 | 2108255.52596642 | 37.7689758778799 | -122.436695073767 | (37.7689758778799, -122.436695073767) | 15 | 5 | 5 | 29492 | 3 | ||
| 102874 | 31811 | Permitted Site 7 | Tree(s) :: 17 | 99 Divisadero St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/2015 12:00:00 AM | Permit Number 776677 | 6001914.86865911 | 2108255.52596642 | 37.7689758778799 | -122.436695073767 | (37.7689758778799, -122.436695073767) | 15 | 5 | 5 | 29492 | 3 | ||
| 179499 | 57896 | Permitted Site 7 | Tree(s) :: 17 | 99 Carmelita St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1977 12:00:00 AM | Permit Number 16850 | 6002564.8751063 | 2108837.1800357 | 37.7706098752833 | -122.43448833975 | (37.7706098752833, -122.43448833975) | 15 | 5 | 5 | 29492 | 9 | |||
| 131283 | 65163 | Permitted Site 7 | Tree(s) :: 17 | 99 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/1989 12:00:00 AM | Permit Number 27143 | 6007985.44375638 | 2098157.69275388 | 37.7415926486376 | -122.414982469753 | (37.7415926486376, -122.414982469753) | 2 | 7 | 7 | 28859 | 2 | |||
| 43561 | 106087 | Undocumented 4 | Tree(s) :: 17 | 98X EUREKA ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/04/2014 12:00:00 AM | 18 | 4x7 | Permit Number 773366 | 6001388 | 2105433 | 37.7611959604452 | -122.438315238354 | (37.7611959604452, -122.438315238354) | 15 | 4 | 5 | 28862 | 3 | |
| 174291 | 106935 | Undocumented 4 | Tree(s) :: 17 | 98X EUREKA ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/04/2014 12:00:00 AM | 18 | 3x5 | Permit Number 773366 | 6001388 | 2105433 | 37.7611959604452 | -122.438315238354 | (37.7611959604452, -122.438315238354) | 15 | 4 | 5 | 28862 | 3 | |
| 24117 | 27426 | DPW Maintained 1 | Tree(s) :: 17 | 98X Duboce Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/14/2012 12:00:00 AM | 1 | 3x3 | 6006094.6477071 | 2108521.7458746 | 37.7699435048383 | -122.422256382252 | (37.7699435048383, -122.422256382252) | 8 | 4 | 7 | 28853 | 19 | ||
| 4964 | 104791 | Undocumented 4 | Tree(s) :: 17 | 98X 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005767 | 2099074 | 37.7439837097913 | -122.422718209223 | (37.7439837097913, -122.422718209223) | 2 | 7 | 5 | 28859 | 22 | ||||
| 110211 | 252861 | DPW Maintained 1 | Tree(s) :: 17 | 988 Howard St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/19/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779759 | 6010589.4479 | 2112082.95565 | 37.7799742710855 | -122.40695991983 | (37.7799742710855, -122.40695991983) | 14 | 2 | 9 | 28853 | 34 | |
| 177627 | 56846 | Permitted Site 7 | Tree(s) :: 17 | 986 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/02/1974 12:00:00 AM | Permit Number 14079 | 5998840.14997758 | 2106594.41071291 | 37.7642396583237 | -122.447210718578 | (37.7642396583237, -122.447210718578) | 15 | 5 | 11 | 29492 | 9 | |||
| 194111 | 59032 | Permitted Site 7 | Tree(s) :: 17 | 985 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/24/1990 12:00:00 AM | Permit Number 29367 | 6008032.28329812 | 2102204.43473858 | 37.7527067292395 | -122.415106889811 | (37.7527067292395, -122.415106889811) | 2 | 4 | 7 | 28859 | 19 | |||
| 44411 | 34515 | Permitted Site 7 | Tree(s) :: 17 | 985 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/1997 12:00:00 AM | Permit Number 38226 | 6002302.16174719 | 2109825.48895759 | 37.7733086102637 | -122.4354677778 | (37.7733086102637, -122.4354677778) | 15 | 5 | 11 | 29492 | 9 | |||
| 158454 | 54588 | Permitted Site 7 | Tree(s) :: 17 | 985 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/20/1972 12:00:00 AM | Permit Number 10410 | 6004419.38059901 | 2103166.11531702 | 37.755143582868 | -122.427669467278 | (37.755143582868, -122.427669467278) | 2 | 4 | 5 | 28862 | 22 | |||
| 39440 | 59907 | Permitted Site 7 | Tree(s) :: 17 | 984 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/13/1981 12:00:00 AM | Permit Number 19375 | 6009935.8366163 | 2103478.41458502 | 37.7563115833519 | -122.408613897079 | (37.7563115833519, -122.408613897079) | 2 | 4 | 7 | 28859 | 19 | |||
| 154511 | 57291 | Permitted Site 7 | Tree(s) :: 17 | 984 Geneva Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/14/1998 12:00:00 AM | Permit Number 16112 | 6000628.34526102 | 2088870.91338198 | 37.7156771258377 | -122.439755108718 | (37.7156771258377, -122.439755108718) | 9 | 7 | 6 | 28861 | 5 | ||
| 180099 | 68009 | Permitted Site 7 | Tree(s) :: 17 | 983 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/1993 12:00:00 AM | Permit Number 32354 | 6009987.14221026 | 2103492.44293605 | 37.7563529753643 | -122.408437453261 | (37.7563529753643, -122.408437453261) | 2 | 4 | 7 | 28859 | 19 | |||
| 39273 | 54501 | DPW Maintained 1 | Tree(s) :: 17 | 981 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/11/2015 12:00:00 AM | 9 | Permit Number 10294 | 6003131.59212331 | 2110978.68598933 | 37.776522075701 | -122.432681058715 | (37.776522075701, -122.432681058715) | 15 | 9 | 11 | 29492 | 10 | ||
| 29585 | 56814 | Permitted Site 7 | Tree(s) :: 17 | 980 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/02/1974 12:00:00 AM | Permit Number 14045 | 5999238.55674578 | 2106649.81706748 | 37.7644145466661 | -122.445836733238 | (37.7644145466661, -122.445836733238) | 15 | 5 | 5 | 29492 | 9 | |||
| 150204 | 207774 | DPW Maintained 1 | Tree(s) :: 17 | 98 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 05/31/2019 12:00:00 AM | 3 | Width 10ft | Permit Number 782995 | 5993269.03182 | 2097018.73215 | 37.7376273996789 | -122.465783688974 | (37.7376273996789, -122.465783688974) | 1 | 8 | 4 | 59 | 40 | |
| 52054 | 255462 | Significant Tree 6 | Tree(s) :: 17 | 98 Saint Francis Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/24/2018 12:00:00 AM | 3 | 10x5 | Permit Number 777805 | 5992112.53458 | 2095987.97644 | 37.7347304251367 | -122.469707196177 | (37.7347304251367, -122.469707196177) | 9 | 8 | 4 | 59 | 40 | |
| 42813 | 106284 | Permitted Site 7 | Tree(s) :: 17 | 98 Hill St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | Permit Number 772597 | 6005778.8 | 2103496.8 | 37.7561283684884 | -122.422991694326 | (37.7561283684884, -122.422991694326) | 2 | 4 | 5 | 28859 | 19 | |||
| 183810 | 58054 | Permitted Site 7 | Tree(s) :: 17 | 98 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/13/1977 12:00:00 AM | Permit Number 772597 | 6005730.65570095 | 2103467.82030042 | 37.7560460801664 | -122.423156133952 | (37.7560460801664, -122.423156133952) | 2 | 4 | 5 | 28859 | 19 | |||
| 192894 | 106283 | Permitted Site 7 | Tree(s) :: 17 | 98 Hill St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | Permit Number 772597 | 6005778.8 | 2103496.8 | 37.7561283684884 | -122.422991694326 | (37.7561283684884, -122.422991694326) | 2 | 4 | 5 | 28859 | 19 | |||
| 20630 | 62423 | Permitted Site 7 | Tree(s) :: 17 | 98 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/13/1985 12:00:00 AM | Permit Number 22580 | 6001470.60482532 | 2121060.78917044 | 37.8041105836027 | -122.439149653649 | (37.8041105836027, -122.439149653649) | 13 | 9 | 1 | 57 | 17 | |||
| 181505 | 113642 | Permitted Site 7 | Tree(s) :: 17 | 98 Bosworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6004258.9190799 | 2095333.58373446 | 37.7336281759245 | -122.42766636908 | (37.7336281759245, -122.42766636908) | 2 | 7 | 5 | 28861 | 25 | |||||
| 9804 | 67144 | Permitted Site 7 | Tree(s) :: 17 | 98 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/30/1992 12:00:00 AM | Permit Number 30575 | |||||||||||||
| 149125 | 59893 | Permitted Site 7 | Tree(s) :: 17 | 979 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/09/2009 12:00:00 AM | 3x3 | Permit Number 53058 | 6009985.91107581 | 2103514.77494726 | 37.7564142251197 | -122.408443286156 | (37.7564142251197, -122.408443286156) | 2 | 4 | 7 | 28859 | 19 | ||
| 147454 | 56813 | Permitted Site 7 | Tree(s) :: 17 | 979 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/21/1979 12:00:00 AM | Permit Number 17592 | 5999211.28862433 | 2106723.09933971 | 37.7646142044254 | -122.44593631683 | (37.7646142044254, -122.44593631683) | 15 | 5 | 11 | 29492 | 9 | |||
| 145758 | 59903 | Permitted Site 7 | Tree(s) :: 17 | 978 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/1981 12:00:00 AM | Permit Number 19370 | 6009933.98991463 | 2103511.91260184 | 37.7564034579722 | -122.408622646638 | (37.7564034579722, -122.408622646638) | 2 | 4 | 7 | 28859 | 19 | |||
| 119611 | 64673 | Permitted Site 7 | Tree(s) :: 17 | 977 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/07/1988 12:00:00 AM | Permit Number 25607 | 6006475.41955519 | 2113833.8404448 | 37.7845507034759 | -122.421316581244 | (37.7845507034759, -122.421316581244) | 7 | 9 | 11 | 28858 | 41 | |||
| 16129 | 35234 | Permitted Site 7 | Tree(s) :: 17 | 977 Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/03/1998 12:00:00 AM | Permit Number 38728 | 6009259.02361808 | 2115999.80882041 | 37.7906544730272 | -122.411839324665 | (37.7906544730272, -122.411839324665) | 5 | 1 | 10 | 28857 | 21 | |||
| 148433 | 35233 | Permitted Site 7 | Tree(s) :: 17 | 977 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/03/1998 12:00:00 AM | Permit Number 38728 | 6009259.02361808 | 2115999.80882041 | 37.7906544730272 | -122.411839324665 | (37.7906544730272, -122.411839324665) | 5 | 1 | 10 | 28857 | 21 | |||
| 42225 | 68439 | Permitted Site 7 | Tree(s) :: 17 | 976 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/26/1993 12:00:00 AM | Permit Number 32295 | 5998828.42464645 | 2106635.10411516 | 37.7643507222069 | -122.447254201971 | (37.7643507222069, -122.447254201971) | 15 | 5 | 11 | 29492 | 9 | |||
| 124115 | 54038 | Permitted Site 7 | Tree(s) :: 17 | 975 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/1972 12:00:00 AM | Permit Number 10409 | 6004416.15943168 | 2103222.77559119 | 37.7552989764571 | -122.427684643763 | (37.7552989764571, -122.427684643763) | 2 | 4 | 5 | 28862 | 22 | |||
| 63223 | 57290 | Permitted Site 7 | Tree(s) :: 17 | 974 Geneva Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/27/1976 12:00:00 AM | Permit Number 16111 | 6000581.22802918 | 2088898.81783879 | 37.7157510631694 | -122.439919966557 | (37.7157510631694, -122.439919966557) | 9 | 7 | 6 | 28861 | 5 | |||
| 102828 | 60751 | Permitted Site 7 | Tree(s) :: 17 | 974 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/17/1983 12:00:00 AM | Permit Number 20416 | 6009390.15275809 | 2103504.22260106 | 37.7563518695157 | -122.410502890718 | (37.7563518695157, -122.410502890718) | 2 | 4 | 7 | 28859 | 19 | |||
| 76882 | 58826 | Permitted Site 7 | Tree(s) :: 17 | 974 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1979 12:00:00 AM | Permit Number 18080 | 5999252.44566313 | 2106677.26538634 | 37.7644907059006 | -122.445790669653 | (37.7644907059006, -122.445790669653) | 15 | 5 | 5 | 29492 | 9 | |||
| 2371 | 57894 | Permitted Site 7 | Tree(s) :: 17 | 972 Terminal Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/1977 12:00:00 AM | Permit Number 16848 | |||||||||||||
| 46972 | 59913 | Permitted Site 7 | Tree(s) :: 17 | 972 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/1981 12:00:00 AM | Permit Number 19381 | 6003110.2879633 | 2102576.29406876 | 37.7534499374036 | -122.43215456935 | (37.7534499374036, -122.43215456935) | 2 | 4 | 5 | 28862 | 22 | |||
| 89431 | 58484 | Permitted Site 7 | Tree(s) :: 17 | 972 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/1978 12:00:00 AM | Permit Number 17645 | 5998823.42067619 | 2106649.12151543 | 37.7643889245383 | -122.447272518172 | (37.7643889245383, -122.447272518172) | 15 | 5 | 11 | 29492 | 9 | |||
| 65419 | 59711 | Permitted Site 7 | Tree(s) :: 17 | 972 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/18/1981 12:00:00 AM | Permit Number 19141 | 6001145.23690779 | 2096128.31561736 | 37.735633706576 | -122.438488172106 | (37.735633706576, -122.438488172106) | 2 | 7 | 5 | 63 | 7 | |||
| 97789 | 56644 | Permitted Site 7 | Tree(s) :: 17 | 970 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6004829.89837183 | 2112224.98491998 | 37.7800402747918 | -122.426894908509 | (37.7800402747918, -122.426894908509) | 7 | 9 | 11 | 28852 | 41 | |||||
| 71852 | 57195 | Permitted Site 7 | Tree(s) :: 17 | 97 Turquoise Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/21/1974 12:00:00 AM | Permit Number 14475 | 5999265.35823706 | 2099128.11837395 | 37.743763337504 | -122.445203216617 | (37.743763337504, -122.445203216617) | 2 | 7 | 5 | 63 | 22 | |||
| 100020 | 53566 | Permitted Site 7 | Tree(s) :: 17 | 97 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/18/1969 12:00:00 AM | Permit Number 6483 | 6002340.08891744 | 2108797.49414171 | 37.7704881449982 | -122.435263037632 | (37.7704881449982, -122.435263037632) | 15 | 5 | 5 | 29492 | 9 | |||
| 51662 | 84736 | Permitted Site 7 | Tree(s) :: 17 | 97 Banks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/03/2007 12:00:00 AM | Permit No. 49268 | 6008713.1 | 2098156.5 | 37.7416302361339 | -122.412466387589 | (37.7416302361339, -122.412466387589) | 10 | 7 | 7 | 28859 | 2 | |||
| 80569 | 84737 | Permitted Site 7 | Tree(s) :: 17 | 97 Banks St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/03/2007 12:00:00 AM | Permit No. 49268 | 6008713.1 | 2098156.5 | 37.7416302361339 | -122.412466387589 | (37.7416302361339, -122.412466387589) | 10 | 7 | 7 | 28859 | 2 | |||
| 139114 | 84738 | Permitted Site 7 | Tree(s) :: 17 | 97 Banks St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Removed on Permit No. 49268 | 6008713.1 | 2098156.5 | 37.7416302361339 | -122.412466387589 | (37.7416302361339, -122.412466387589) | 10 | 7 | 7 | 28859 | 2 | ||||
| 85993 | 32153 | Permitted Site 7 | Tree(s) :: 17 | 969 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1995 12:00:00 AM | Permit Number 35504 | 6003235.75676176 | 2110648.6378976 | 37.7756217522908 | -122.432297146371 | (37.7756217522908, -122.432297146371) | 15 | 9 | 11 | 29492 | 10 | |||
| 167889 | 60238 | Permitted Site 7 | Tree(s) :: 17 | 968 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/10/1982 12:00:00 AM | Permit Number 19790 | 6003751.21424174 | 2102621.34749149 | 37.7536099612435 | -122.42994132376 | (37.7536099612435, -122.42994132376) | 2 | 4 | 5 | 28862 | 22 | |||
| 93204 | 59031 | Permitted Site 7 | Tree(s) :: 17 | 967 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/11/2011 12:00:00 AM | 3x3 | Permit Number 54077 | 6008026.95539569 | 2102304.76680146 | 37.7529819189616 | -122.415132416061 | (37.7529819189616, -122.415132416061) | 2 | 4 | 7 | 28859 | 19 | ||
| 8218 | 100711 | Significant Tree 6 | Tree(s) :: 17 | 966-968 Guerrero St | 1 | Front Yard : Yard | Tree | Private 2 | 09/27/2012 12:00:00 AM | 14 | Permit Number 769148 | 6005605.8 | 2103343.5 | 37.7556976788024 | -122.423579088745 | (37.7556976788024, -122.423579088745) | 2 | 4 | 5 | 28859 | 19 | ||
| 101636 | 58929 | Permitted Site 7 | Tree(s) :: 17 | 965 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/1984 12:00:00 AM | Permit Number 21297 | 6010336.43057751 | 2112654.12338288 | 37.7815284017612 | -122.407875512148 | (37.7815284017612, -122.407875512148) | 14 | 2 | 9 | 28853 | 34 | |||
| 37318 | 65275 | Permitted Site 7 | Tree(s) :: 17 | 965 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/14/1989 12:00:00 AM | Permit Number 28077 | 6010779.70119315 | 2112201.30520785 | 37.7803098755256 | -122.4063100863 | (37.7803098755256, -122.4063100863) | 14 | 2 | 9 | 28853 | 34 | |||
| 129539 | 97348 | Permitted Site 7 | Tree(s) :: 17 | 964 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/2011 12:00:00 AM | 5x5 | Permit Number 768176 | 6012736.5 | 2103020.4 | 37.7552104319979 | -122.398896025594 | (37.7552104319979, -122.398896025594) | 10 | 3 | 8 | 28856 | 29 | ||
| 157825 | 53690 | Permitted Site 7 | Tree(s) :: 17 | 963 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/17/1970 12:00:00 AM | Permit Number 6634 | 5995896.72164381 | 2090309.84501573 | 37.7193576328279 | -122.456213636288 | (37.7193576328279, -122.456213636288) | 9 | 8 | 6 | 28861 | 24 | |||
| 97578 | 60212 | Permitted Site 7 | Tree(s) :: 17 | 962 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/24/1982 12:00:00 AM | Permit Number 19760 | 6008701.15564914 | 2115817.9706594 | 37.790123877236 | -122.413756656236 | (37.790123877236, -122.413756656236) | 5 | 1 | 10 | 28858 | 21 | |||
| 76363 | 69536 | Permitted Site 7 | Tree(s) :: 17 | 96 Minerva St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/1998 12:00:00 AM | Permit Number 38601 | 5995943.38364261 | 2089047.51213064 | 37.7158942420321 | -122.455961134497 | (37.7158942420321, -122.455961134497) | 9 | 8 | 6 | 28861 | 24 | |||
| 77091 | 95788 | Undocumented 4 | Tree(s) :: 17 | 96 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6008711.8 | 2112556.7 | 37.7811698125515 | -122.41348908139 | (37.7811698125515, -122.41348908139) | 7 | 10 | 9 | 28852 | 36 | |||
| 67949 | 68111 | Permitted Site 7 | Tree(s) :: 17 | 96 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/1993 12:00:00 AM | Permit Number 31857 | 6008217.88662288 | 2099456.83768322 | 37.7451728719547 | -122.414270654938 | (37.7451728719547, -122.414270654938) | 2 | 7 | 7 | 28859 | 2 | |||
| 95608 | 111777 | Undocumented 4 | Tree(s) :: 17 | 96 CRESTLINE DR | 1 | Median : Cutout | Tree | Private 2 | 3x3 | 5998960 | 2102304 | 37.7524661019794 | -122.446487505153 | (37.7524661019794, -122.446487505153) | 2 | 5 | 5 | 63 | 38 | ||||
| 129790 | 62449 | Permitted Site 7 | Tree(s) :: 17 | 96 Berkeley Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/1985 12:00:00 AM | Permit Number 22615 | 6001049.20292225 | 2097405.94652407 | 37.7391363194927 | -122.438911728207 | (37.7391363194927, -122.438911728207) | 2 | 7 | 5 | 63 | 7 | |||
| 6746 | 122375 | Permitted Site 7 | Tree(s) :: 17 | 95x Tompkins Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779511 | 6007651 | 2096616 | 37.7373407014575 | -122.416029712695 | (37.7373407014575, -122.416029712695) | 2 | 7 | 7 | 28859 | 2 | |
| 53745 | 251329 | DPW Maintained 1 | Tree(s) :: 17 | 95x Tompkins Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/2017 12:00:00 AM | 3x3 | Permit Number 779511 | 6007651 | 2096616 | 37.7373407014575 | -122.416029712695 | (37.7373407014575, -122.416029712695) | 2 | 7 | 7 | 28859 | 2 | ||
| 75819 | 122373 | Permitted Site 7 | Tree(s) :: 17 | 95x Tompkins Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779511 | 6007651 | 2096616 | 37.7373407014575 | -122.416029712695 | (37.7373407014575, -122.416029712695) | 2 | 7 | 7 | 28859 | 2 | |
| 127727 | 251328 | DPW Maintained 1 | Tree(s) :: 17 | 95x Tompkins Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 779511 | 6007651 | 2096616 | 37.7373407014575 | -122.416029712695 | (37.7373407014575, -122.416029712695) | 2 | 7 | 7 | 28859 | 2 | |||
| 151785 | 251327 | DPW Maintained 1 | Tree(s) :: 17 | 95x Tompkins Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/2017 12:00:00 AM | 3x3 | Permit Number 779511 | 6007651 | 2096616 | 37.7373407014575 | -122.416029712695 | (37.7373407014575, -122.416029712695) | 2 | 7 | 7 | 28859 | 2 | ||
| 97322 | 101711 | Permitted Site 7 | Tree(s) :: 17 | 95X Milton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/13/2012 12:00:00 AM | 3x3 | Permit Number 769047 | 6003767.7 | 2095277.7 | 37.7334469335284 | -122.429360672359 | (37.7334469335284, -122.429360672359) | 2 | 7 | 5 | 28861 | 25 | ||
| 2436 | 102404 | Undocumented 4 | Tree(s) :: 17 | 95X Harriet St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6010704.6 | 2111649.2 | 37.7787897224959 | -122.406530981243 | (37.7787897224959, -122.406530981243) | 14 | 2 | 9 | 28853 | 34 | |||
| 26537 | 102408 | Undocumented 4 | Tree(s) :: 17 | 95X Harriet St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6010704.6 | 2111649.2 | 37.7787897224959 | -122.406530981243 | (37.7787897224959, -122.406530981243) | 14 | 2 | 9 | 28853 | 34 | |||
| 33965 | 102403 | Undocumented 4 | Tree(s) :: 17 | 95X Harriet St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6010704.6 | 2111649.2 | 37.7787897224959 | -122.406530981243 | (37.7787897224959, -122.406530981243) | 14 | 2 | 9 | 28853 | 34 | |||
| 67939 | 102407 | Undocumented 4 | Tree(s) :: 17 | 95X Harriet St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6010704.6 | 2111649.2 | 37.7787897224959 | -122.406530981243 | (37.7787897224959, -122.406530981243) | 14 | 2 | 9 | 28853 | 34 | |||
| 70964 | 102406 | Undocumented 4 | Tree(s) :: 17 | 95X Harriet St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6010704.6 | 2111649.2 | 37.7787897224959 | -122.406530981243 | (37.7787897224959, -122.406530981243) | 14 | 2 | 9 | 28853 | 34 | |||
| 86157 | 102402 | Undocumented 4 | Tree(s) :: 17 | 95X Harriet St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6010704.6 | 2111649.2 | 37.7787897224959 | -122.406530981243 | (37.7787897224959, -122.406530981243) | 14 | 2 | 9 | 28853 | 34 | |||
| 168707 | 102401 | Undocumented 4 | Tree(s) :: 17 | 95X Harriet St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6010704.6 | 2111649.2 | 37.7787897224959 | -122.406530981243 | (37.7787897224959, -122.406530981243) | 14 | 2 | 9 | 28853 | 34 | |||
| 192347 | 102405 | Undocumented 4 | Tree(s) :: 17 | 95X Harriet St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6010704.6 | 2111649.2 | 37.7787897224959 | -122.406530981243 | (37.7787897224959, -122.406530981243) | 14 | 2 | 9 | 28853 | 34 | |||
| 156360 | 53033 | Permitted Site 7 | Tree(s) :: 17 | 95PARNASSAS Woodland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/06/2006 12:00:00 AM | Permit Number 49012 | 5997087.00567641 | 2105993.56041391 | 37.7624895480533 | -122.453230932888 | (37.7624895480533, -122.453230932888) | 15 | 5 | 11 | 29492 | 12 | |||
| 69508 | 57237 | Permitted Site 7 | Tree(s) :: 17 | 959 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/09/1975 12:00:00 AM | Permit Number 14524 | 6003157.7766932 | 2102658.98865518 | 37.7536796895051 | -122.43199624791 | (37.7536796895051, -122.43199624791) | 2 | 4 | 5 | 28862 | 22 | |||
| 136050 | 68780 | Permitted Site 7 | Tree(s) :: 17 | 959 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/1993 12:00:00 AM | Permit Number 32710 | 6009176.95310097 | 2103582.08234897 | 37.7565537001656 | -122.411245712084 | (37.7565537001656, -122.411245712084) | 2 | 4 | 7 | 28859 | 19 |
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) );