Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▲ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 129004 | 129004 | 108871 | Property Tree 7 | Tree(s) :: 17 | 99x OAKWOOD ST | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6005305.0 | 2104962.0 | 37.760124716943295 | -122.424734485609 | (37.7601247169433, -122.424734485609) | |||||
| 143358 | 143358 | 117258 | Undocumented 2 | Tree(s) :: 17 | 99X PROSPER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2x3 | 6003339.0 | 2106236.0 | 37.7635115803019 | -122.431624896471 | (37.7635115803019, -122.431624896471) | ||||
| 10010 | 10010 | 173778 | Significant Tree 6 | Tree(s) :: 17 | 99X Cleveland St | 1 | Side Yard : Cutout 18 | Tree 1 | Private 1 | 3x3 | 6010549.0 | 2110746.0 | 37.7763010397716 | -122.40700558704799 | (37.7763010397716, -122.407005587048) | ||||
| 139153 | 139153 | 59646 | Permitted Site 1 | Tree(s) :: 17 | 999 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1981 12:00:00 AM | Permit Number 19060 | 6002238.22079915 | 2109816.85060103 | 37.773281259813 | -122.43568833985701 | (37.773281259813, -122.435688339857) | |||
| 2644 | 2644 | 124734 | Permitted Site 1 | Tree(s) :: 17 | 999 Brannan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6010535.71931722 | 2108464.76902983 | 37.7700365636667 | -122.406890710328 | (37.7700365636667, -122.406890710328) | |||||
| 4740 | 4740 | 124733 | Permitted Site 1 | Tree(s) :: 17 | 999 Brannan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6010535.71931722 | 2108464.76902983 | 37.7700365636667 | -122.406890710328 | (37.7700365636667, -122.406890710328) | |||||
| 6372 | 6372 | 124739 | Permitted Site 1 | Tree(s) :: 17 | 999 Brannan St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6010535.71931722 | 2108464.76902983 | 37.7700365636667 | -122.406890710328 | (37.7700365636667, -122.406890710328) | |||||
| 6769 | 6769 | 124735 | Permitted Site 1 | Tree(s) :: 17 | 999 Brannan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6010535.71931722 | 2108464.76902983 | 37.7700365636667 | -122.406890710328 | (37.7700365636667, -122.406890710328) | |||||
| 7004 | 7004 | 124738 | Permitted Site 1 | Tree(s) :: 17 | 999 Brannan St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6010535.71931722 | 2108464.76902983 | 37.7700365636667 | -122.406890710328 | (37.7700365636667, -122.406890710328) | |||||
| 7186 | 7186 | 124737 | Permitted Site 1 | Tree(s) :: 17 | 999 Brannan St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6010535.71931722 | 2108464.76902983 | 37.7700365636667 | -122.406890710328 | (37.7700365636667, -122.406890710328) | |||||
| 7602 | 7602 | 124740 | Permitted Site 1 | Tree(s) :: 17 | 999 Brannan St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6010535.71931722 | 2108464.76902983 | 37.7700365636667 | -122.406890710328 | (37.7700365636667, -122.406890710328) | |||||
| 8812 | 8812 | 124736 | Permitted Site 1 | Tree(s) :: 17 | 999 Brannan St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6010535.71931722 | 2108464.76902983 | 37.7700365636667 | -122.406890710328 | (37.7700365636667, -122.406890710328) | |||||
| 102663 | 102663 | 56768 | Permitted Site 1 | Tree(s) :: 17 | 994 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/21/1974 12:00:00 AM | Permit Number 13987 | 6003117.251443 | 2102450.87538679 | 37.753105962208295 | -122.432121532394 | (37.7531059622083, -122.432121532394) | |||
| 91707 | 91707 | 57292 | Permitted Site 1 | Tree(s) :: 17 | 994 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/27/1976 12:00:00 AM | Permit Number 16113 | 6000688.67615408 | 2088842.44530642 | 37.7156023927573 | -122.43954453854201 | (37.7156023927573, -122.439544538542) | |||
| 101296 | 101296 | 91113 | Permitted Site 1 | Tree(s) :: 17 | 994 Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 51999 | 5999620.1 | 2101651.4 | 37.750711902365104 | -122.44415788679599 | (37.7507119023651, -122.444157886796) | |||
| 140947 | 140947 | 53554 | Permitted Site 1 | Tree(s) :: 17 | 990 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/20/2016 12:00:00 AM | Permit Number 6466 | 6009376.89757939 | 2118082.87777148 | 37.796380684344605 | -122.41157872386299 | (37.7963806843446, -122.411578723863) | |||
| 86579 | 86579 | 56545 | Permitted Site 1 | Tree(s) :: 17 | 99 Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6006997.81069025 | 2098938.41719823 | 37.7436807955871 | -122.418452724226 | (37.7436807955871, -122.418452724226) | |||||
| 140990 | 140990 | 62893 | Permitted Site 1 | Tree(s) :: 17 | 99 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/1986 12:00:00 AM | Permit Number 23267 | 6012353.11575448 | 2119483.32983433 | 37.8003924841325 | -122.401378783456 | (37.8003924841325, -122.401378783456) | |||
| 79005 | 79005 | 31812 | Permitted Site 1 | Tree(s) :: 17 | 99 Divisadero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2015 12:00:00 AM | Permit Number 776677 | 6001914.86865911 | 2108255.52596642 | 37.768975877879896 | -122.436695073767 | (37.7689758778799, -122.436695073767) | ||
| 84078 | 84078 | 31810 | Permitted Site 1 | Tree(s) :: 17 | 99 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2015 12:00:00 AM | Permit Number 776677 | 6001914.86865911 | 2108255.52596642 | 37.768975877879896 | -122.436695073767 | (37.7689758778799, -122.436695073767) | ||
| 101597 | 101597 | 31811 | Permitted Site 1 | Tree(s) :: 17 | 99 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2015 12:00:00 AM | Permit Number 776677 | 6001914.86865911 | 2108255.52596642 | 37.768975877879896 | -122.436695073767 | (37.7689758778799, -122.436695073767) | ||
| 140282 | 140282 | 57896 | Permitted Site 1 | Tree(s) :: 17 | 99 Carmelita St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1977 12:00:00 AM | Permit Number 16850 | 6002564.875106299 | 2108837.1800356996 | 37.7706098752833 | -122.43448833975 | (37.7706098752833, -122.43448833975) | |||
| 107388 | 107388 | 65163 | Permitted Site 1 | Tree(s) :: 17 | 99 Anderson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/1989 12:00:00 AM | Permit Number 27143 | 6007985.44375638 | 2098157.69275388 | 37.7415926486376 | -122.414982469753 | (37.7415926486376, -122.414982469753) | |||
| 80063 | 80063 | 106087 | Undocumented 2 | Tree(s) :: 17 | 98X EUREKA ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/04/2014 12:00:00 AM | 18 | 4x7 | Permit Number 773366 | 6001388.0 | 2105433.0 | 37.76119596044521 | -122.438315238354 | (37.7611959604452, -122.438315238354) | |
| 141422 | 141422 | 106935 | Undocumented 2 | Tree(s) :: 17 | 98X EUREKA ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/04/2014 12:00:00 AM | 18 | 3x5 | Permit Number 773366 | 6001388.0 | 2105433.0 | 37.76119596044521 | -122.438315238354 | (37.7611959604452, -122.438315238354) | |
| 128073 | 128073 | 27426 | DPW Maintained 3 | Tree(s) :: 17 | 98X Duboce Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/14/2012 12:00:00 AM | 1 | 3x3 | 6006094.6477071 | 2108521.7458746 | 37.769943504838295 | -122.422256382252 | (37.7699435048383, -122.422256382252) | ||
| 144745 | 144745 | 104791 | Undocumented 2 | Tree(s) :: 17 | 98X 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005767.0 | 2099074.0 | 37.7439837097913 | -122.422718209223 | (37.7439837097913, -122.422718209223) | ||||
| 2050 | 2050 | 252861 | DPW Maintained 3 | Tree(s) :: 17 | 988 Howard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/19/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779759 | 6010589.4479 | 2112082.95565 | 37.7799742710855 | -122.40695991983 | (37.7799742710855, -122.40695991983) | |
| 141836 | 141836 | 56846 | Permitted Site 1 | Tree(s) :: 17 | 986 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/02/1974 12:00:00 AM | Permit Number 14079 | 5998840.14997758 | 2106594.41071291 | 37.7642396583237 | -122.44721071857799 | (37.7642396583237, -122.447210718578) | |||
| 146329 | 146329 | 59032 | Permitted Site 1 | Tree(s) :: 17 | 985 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/24/1990 12:00:00 AM | Permit Number 29367 | 6008032.28329812 | 2102204.43473858 | 37.7527067292395 | -122.415106889811 | (37.7527067292395, -122.415106889811) | |||
| 81916 | 81916 | 34515 | Permitted Site 1 | Tree(s) :: 17 | 985 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/1997 12:00:00 AM | Permit Number 38226 | 6002302.16174719 | 2109825.48895759 | 37.773308610263705 | -122.43546777780001 | (37.7733086102637, -122.4354677778) | |||
| 117238 | 117238 | 54588 | Permitted Site 1 | Tree(s) :: 17 | 985 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/20/1972 12:00:00 AM | Permit Number 10410 | 6004419.38059901 | 2103166.11531702 | 37.755143582868 | -122.42766946727801 | (37.755143582868, -122.427669467278) | |||
| 79201 | 79201 | 59907 | Permitted Site 1 | Tree(s) :: 17 | 984 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/13/1981 12:00:00 AM | Permit Number 19375 | 6009935.836616299 | 2103478.41458502 | 37.756311583351895 | -122.408613897079 | (37.7563115833519, -122.408613897079) | |||
| 122745 | 122745 | 57291 | Permitted Site 1 | Tree(s) :: 17 | 984 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/14/1998 12:00:00 AM | Permit Number 16112 | 6000628.34526102 | 2088870.91338198 | 37.7156771258377 | -122.43975510871799 | (37.7156771258377, -122.439755108718) | ||
| 140528 | 140528 | 68009 | Permitted Site 1 | Tree(s) :: 17 | 983 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/18/1993 12:00:00 AM | Permit Number 32354 | 6009987.14221026 | 2103492.44293605 | 37.7563529753643 | -122.40843745326099 | (37.7563529753643, -122.408437453261) | |||
| 185238 | 185238 | 54501 | Permitted Site 1 | Tree(s) :: 17 | 981 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/2015 12:00:00 AM | 9 | Permit Number 10294 | 6003131.59212331 | 2110978.68598933 | 37.776522075700996 | -122.432681058715 | (37.776522075701, -122.432681058715) | ||
| 128528 | 128528 | 56814 | Permitted Site 1 | Tree(s) :: 17 | 980 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/02/1974 12:00:00 AM | Permit Number 14045 | 5999238.55674578 | 2106649.81706748 | 37.7644145466661 | -122.445836733238 | (37.7644145466661, -122.445836733238) | |||
| 81471 | 81471 | 106284 | Permitted Site 1 | Tree(s) :: 17 | 98 Hill St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3X3 | Permit Number 772597 | 6005778.8 | 2103496.8 | 37.7561283684884 | -122.422991694326 | (37.7561283684884, -122.422991694326) | |||
| 141585 | 141585 | 58054 | Permitted Site 1 | Tree(s) :: 17 | 98 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/1977 12:00:00 AM | Permit Number 772597 | 6005730.65570095 | 2103467.82030042 | 37.7560460801664 | -122.423156133952 | (37.7560460801664, -122.423156133952) | |||
| 145680 | 145680 | 106283 | Permitted Site 1 | Tree(s) :: 17 | 98 Hill St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3X3 | Permit Number 772597 | 6005778.8 | 2103496.8 | 37.7561283684884 | -122.422991694326 | (37.7561283684884, -122.422991694326) | |||
| 126404 | 126404 | 62423 | Permitted Site 1 | Tree(s) :: 17 | 98 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/13/1985 12:00:00 AM | Permit Number 22580 | 6001470.60482532 | 2121060.78917044 | 37.80411058360271 | -122.43914965364901 | (37.8041105836027, -122.439149653649) | |||
| 139426 | 139426 | 113642 | Permitted Site 1 | Tree(s) :: 17 | 98 Bosworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6004258.919079901 | 2095333.58373446 | 37.7336281759245 | -122.42766636908001 | (37.7336281759245, -122.42766636908) | |||||
| 6049 | 6049 | 67144 | Permitted Site 1 | Tree(s) :: 17 | 98 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/30/1992 12:00:00 AM | Permit Number 30575 | ||||||||
| 112104 | 112104 | 59893 | Permitted Site 1 | Tree(s) :: 17 | 979 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/09/2009 12:00:00 AM | 3x3 | Permit Number 53058 | 6009985.91107581 | 2103514.77494726 | 37.756414225119705 | -122.408443286156 | (37.7564142251197, -122.408443286156) | ||
| 110331 | 110331 | 56813 | Permitted Site 1 | Tree(s) :: 17 | 979 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/21/1979 12:00:00 AM | Permit Number 17592 | 5999211.28862433 | 2106723.09933971 | 37.7646142044254 | -122.44593631683 | (37.7646142044254, -122.44593631683) | |||
| 113573 | 113573 | 59903 | Permitted Site 1 | Tree(s) :: 17 | 978 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/18/1981 12:00:00 AM | Permit Number 19370 | 6009933.98991463 | 2103511.91260184 | 37.756403457972205 | -122.408622646638 | (37.7564034579722, -122.408622646638) | |||
| 106498 | 106498 | 64673 | Permitted Site 1 | Tree(s) :: 17 | 977 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/07/1988 12:00:00 AM | Permit Number 25607 | 6006475.41955519 | 2113833.8404448 | 37.7845507034759 | -122.42131658124399 | (37.7845507034759, -122.421316581244) | |||
| 111766 | 111766 | 35233 | Permitted Site 1 | Tree(s) :: 17 | 977 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/03/1998 12:00:00 AM | Permit Number 38728 | 6009259.02361808 | 2115999.80882041 | 37.7906544730272 | -122.411839324665 | (37.7906544730272, -122.411839324665) | |||
| 123787 | 123787 | 35234 | Permitted Site 1 | Tree(s) :: 17 | 977 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/03/1998 12:00:00 AM | Permit Number 38728 | 6009259.02361808 | 2115999.80882041 | 37.7906544730272 | -122.411839324665 | (37.7906544730272, -122.411839324665) | |||
| 81364 | 81364 | 68439 | Permitted Site 1 | Tree(s) :: 17 | 976 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/26/1993 12:00:00 AM | Permit Number 32295 | 5998828.42464645 | 2106635.10411516 | 37.7643507222069 | -122.44725420197099 | (37.7643507222069, -122.447254201971) | |||
| 108630 | 108630 | 54038 | Permitted Site 1 | Tree(s) :: 17 | 975 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/1972 12:00:00 AM | Permit Number 10409 | 6004416.15943168 | 2103222.77559119 | 37.7552989764571 | -122.427684643763 | (37.7552989764571, -122.427684643763) | |||
| 85961 | 85961 | 57290 | Permitted Site 1 | Tree(s) :: 17 | 974 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/27/1976 12:00:00 AM | Permit Number 16111 | 6000581.22802918 | 2088898.81783879 | 37.7157510631694 | -122.43991996655701 | (37.7157510631694, -122.439919966557) | |||
| 97703 | 97703 | 60751 | Permitted Site 1 | Tree(s) :: 17 | 974 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/17/1983 12:00:00 AM | Permit Number 20416 | 6009390.15275809 | 2103504.22260106 | 37.756351869515704 | -122.410502890718 | (37.7563518695157, -122.410502890718) | |||
| 91736 | 91736 | 58826 | Permitted Site 1 | Tree(s) :: 17 | 974 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1979 12:00:00 AM | Permit Number 18080 | 5999252.44566313 | 2106677.26538634 | 37.764490705900606 | -122.445790669653 | (37.7644907059006, -122.445790669653) | |||
| 6732 | 6732 | 57894 | Permitted Site 1 | Tree(s) :: 17 | 972 Terminal Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/25/1977 12:00:00 AM | Permit Number 16848 | ||||||||
| 84380 | 84380 | 59913 | Permitted Site 1 | Tree(s) :: 17 | 972 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/24/1981 12:00:00 AM | Permit Number 19381 | 6003110.2879633 | 2102576.29406876 | 37.7534499374036 | -122.43215456934999 | (37.7534499374036, -122.43215456935) | |||
| 97439 | 97439 | 58484 | Permitted Site 1 | Tree(s) :: 17 | 972 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/29/1978 12:00:00 AM | Permit Number 17645 | 5998823.42067619 | 2106649.12151543 | 37.764388924538295 | -122.447272518172 | (37.7643889245383, -122.447272518172) | |||
| 87932 | 87932 | 59711 | Permitted Site 1 | Tree(s) :: 17 | 972 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/18/1981 12:00:00 AM | Permit Number 19141 | 6001145.23690779 | 2096128.31561736 | 37.735633706575996 | -122.438488172106 | (37.735633706576, -122.438488172106) | |||
| 99679 | 99679 | 56644 | Permitted Site 1 | Tree(s) :: 17 | 970 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6004829.89837183 | 2112224.98491998 | 37.7800402747918 | -122.42689490850901 | (37.7800402747918, -122.426894908509) | |||||
| 89400 | 89400 | 57195 | Permitted Site 1 | Tree(s) :: 17 | 97 Turquoise Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/21/1974 12:00:00 AM | Permit Number 14475 | 5999265.35823706 | 2099128.11837395 | 37.743763337504 | -122.44520321661699 | (37.743763337504, -122.445203216617) | |||
| 99228 | 99228 | 53566 | Permitted Site 1 | Tree(s) :: 17 | 97 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/18/1969 12:00:00 AM | Permit Number 6483 | 6002340.08891744 | 2108797.49414171 | 37.770488144998204 | -122.43526303763201 | (37.7704881449982, -122.435263037632) | |||
| 80891 | 80891 | 84736 | Permitted Site 1 | Tree(s) :: 17 | 97 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2007 12:00:00 AM | Permit No. 49268 | 6008713.1 | 2098156.5 | 37.7416302361339 | -122.41246638758899 | (37.7416302361339, -122.412466387589) | |||
| 93369 | 93369 | 84737 | Permitted Site 1 | Tree(s) :: 17 | 97 Banks St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2007 12:00:00 AM | Permit No. 49268 | 6008713.1 | 2098156.5 | 37.7416302361339 | -122.41246638758899 | (37.7416302361339, -122.412466387589) | |||
| 113971 | 113971 | 84738 | Permitted Site 1 | Tree(s) :: 17 | 97 Banks St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Removed on Permit No. 49268 | 6008713.1 | 2098156.5 | 37.7416302361339 | -122.41246638758899 | (37.7416302361339, -122.412466387589) | ||||
| 95500 | 95500 | 32153 | Permitted Site 1 | Tree(s) :: 17 | 969 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1995 12:00:00 AM | Permit Number 35504 | 6003235.75676176 | 2110648.6378976 | 37.775621752290796 | -122.432297146371 | (37.7756217522908, -122.432297146371) | |||
| 118002 | 118002 | 60238 | Permitted Site 1 | Tree(s) :: 17 | 968 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/10/1982 12:00:00 AM | Permit Number 19790 | 6003751.21424174 | 2102621.34749149 | 37.7536099612435 | -122.42994132376002 | (37.7536099612435, -122.42994132376) | |||
| 97376 | 97376 | 59031 | Permitted Site 1 | Tree(s) :: 17 | 967 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/11/2011 12:00:00 AM | 3x3 | Permit Number 54077 | 6008026.95539569 | 2102304.76680146 | 37.7529819189616 | -122.415132416061 | (37.7529819189616, -122.415132416061) | ||
| 50498 | 50498 | 100711 | Significant Tree 6 | Tree(s) :: 17 | 966-968 Guerrero St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/27/2012 12:00:00 AM | 14 | Permit Number 769148 | 6005605.8 | 2103343.5 | 37.7556976788024 | -122.423579088745 | (37.7556976788024, -122.423579088745) | ||
| 102989 | 102989 | 58929 | Permitted Site 1 | Tree(s) :: 17 | 965 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/1984 12:00:00 AM | Permit Number 21297 | 6010336.43057751 | 2112654.12338288 | 37.7815284017612 | -122.407875512148 | (37.7815284017612, -122.407875512148) | |||
| 127878 | 127878 | 65275 | Permitted Site 1 | Tree(s) :: 17 | 965 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/14/1989 12:00:00 AM | Permit Number 28077 | 6010779.70119315 | 2112201.30520785 | 37.7803098755256 | -122.4063100863 | (37.7803098755256, -122.4063100863) | |||
| 109552 | 109552 | 97348 | Permitted Site 1 | Tree(s) :: 17 | 964 Wisconsin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2011 12:00:00 AM | 5x5 | Permit Number 768176 | 6012736.5 | 2103020.4 | 37.7552104319979 | -122.398896025594 | (37.7552104319979, -122.398896025594) | ||
| 119475 | 119475 | 53690 | Permitted Site 1 | Tree(s) :: 17 | 963 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/17/1970 12:00:00 AM | Permit Number 6634 | 5995896.72164381 | 2090309.84501573 | 37.719357632827894 | -122.456213636288 | (37.7193576328279, -122.456213636288) | |||
| 100660 | 100660 | 60212 | Permitted Site 1 | Tree(s) :: 17 | 962 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/1982 12:00:00 AM | Permit Number 19760 | 6008701.15564914 | 2115817.9706594 | 37.790123877236 | -122.413756656236 | (37.790123877236, -122.413756656236) | |||
| 92659 | 92659 | 69536 | Permitted Site 1 | Tree(s) :: 17 | 96 Minerva St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/1998 12:00:00 AM | Permit Number 38601 | 5995943.38364261 | 2089047.51213064 | 37.71589424203211 | -122.45596113449699 | (37.7158942420321, -122.455961134497) | |||
| 92709 | 92709 | 95788 | Undocumented 2 | Tree(s) :: 17 | 96 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6008711.8 | 2112556.7 | 37.7811698125515 | -122.41348908139 | (37.7811698125515, -122.41348908139) | |||
| 88394 | 88394 | 68111 | Permitted Site 1 | Tree(s) :: 17 | 96 Manchester St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/1993 12:00:00 AM | Permit Number 31857 | 6008217.88662288 | 2099456.83768322 | 37.7451728719547 | -122.414270654938 | (37.7451728719547, -122.414270654938) | |||
| 101290 | 101290 | 111777 | Undocumented 2 | Tree(s) :: 17 | 96 CRESTLINE DR | 1 | Median : Cutout 11 | Tree 1 | Private 1 | 3x3 | 5998960.0 | 2102304.0 | 37.7524661019794 | -122.446487505153 | (37.7524661019794, -122.446487505153) | ||||
| 106835 | 106835 | 62449 | Permitted Site 1 | Tree(s) :: 17 | 96 Berkeley Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/1985 12:00:00 AM | Permit Number 22615 | 6001049.20292225 | 2097405.94652407 | 37.7391363194927 | -122.438911728207 | (37.7391363194927, -122.438911728207) | |||
| 588 | 588 | 251328 | Undocumented 2 | Tree(s) :: 17 | 95x Tompkins Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 779511 | 6007651.0 | 2096616.0 | 37.7373407014575 | -122.416029712695 | (37.7373407014575, -122.416029712695) | |||
| 597 | 597 | 251329 | Permitted Site 1 | Tree(s) :: 17 | 95x Tompkins Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/2017 12:00:00 AM | 3x3 | Permit Number 779511 | 6007651.0 | 2096616.0 | 37.7373407014575 | -122.416029712695 | (37.7373407014575, -122.416029712695) | ||
| 610 | 610 | 251327 | Permitted Site 1 | Tree(s) :: 17 | 95x Tompkins Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/2017 12:00:00 AM | 3x3 | Permit Number 779511 | 6007651.0 | 2096616.0 | 37.7373407014575 | -122.416029712695 | (37.7373407014575, -122.416029712695) | ||
| 10240 | 10240 | 122375 | Permitted Site 1 | Tree(s) :: 17 | 95x Tompkins Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779511 | 6007651.0 | 2096616.0 | 37.7373407014575 | -122.416029712695 | (37.7373407014575, -122.416029712695) | |
| 10244 | 10244 | 122373 | Permitted Site 1 | Tree(s) :: 17 | 95x Tompkins Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779511 | 6007651.0 | 2096616.0 | 37.7373407014575 | -122.416029712695 | (37.7373407014575, -122.416029712695) | |
| 103461 | 103461 | 101711 | Permitted Site 1 | Tree(s) :: 17 | 95X Milton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/13/2012 12:00:00 AM | 3x3 | Permit Number 769047 | 6003767.7 | 2095277.7 | 37.7334469335284 | -122.42936067235901 | (37.7334469335284, -122.429360672359) | ||
| 80212 | 80212 | 102404 | Undocumented 2 | Tree(s) :: 17 | 95X Harriet St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010704.6 | 2111649.2 | 37.7787897224959 | -122.406530981243 | (37.7787897224959, -122.406530981243) | |||
| 88199 | 88199 | 102406 | Undocumented 2 | Tree(s) :: 17 | 95X Harriet St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010704.6 | 2111649.2 | 37.7787897224959 | -122.406530981243 | (37.7787897224959, -122.406530981243) | |||
| 88378 | 88378 | 102407 | Undocumented 2 | Tree(s) :: 17 | 95X Harriet St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010704.6 | 2111649.2 | 37.7787897224959 | -122.406530981243 | (37.7787897224959, -122.406530981243) | |||
| 93877 | 93877 | 102402 | Undocumented 2 | Tree(s) :: 17 | 95X Harriet St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010704.6 | 2111649.2 | 37.7787897224959 | -122.406530981243 | (37.7787897224959, -122.406530981243) | |||
| 118946 | 118946 | 102401 | Undocumented 2 | Tree(s) :: 17 | 95X Harriet St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010704.6 | 2111649.2 | 37.7787897224959 | -122.406530981243 | (37.7787897224959, -122.406530981243) | |||
| 127424 | 127424 | 102408 | Undocumented 2 | Tree(s) :: 17 | 95X Harriet St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010704.6 | 2111649.2 | 37.7787897224959 | -122.406530981243 | (37.7787897224959, -122.406530981243) | |||
| 128856 | 128856 | 102403 | Undocumented 2 | Tree(s) :: 17 | 95X Harriet St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010704.6 | 2111649.2 | 37.7787897224959 | -122.406530981243 | (37.7787897224959, -122.406530981243) | |||
| 145520 | 145520 | 102405 | Undocumented 2 | Tree(s) :: 17 | 95X Harriet St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010704.6 | 2111649.2 | 37.7787897224959 | -122.406530981243 | (37.7787897224959, -122.406530981243) | |||
| 117892 | 117892 | 53033 | Permitted Site 1 | Tree(s) :: 17 | 95PARNASSAS Woodland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/06/2006 12:00:00 AM | Permit Number 49012 | 5997087.00567641 | 2105993.56041391 | 37.762489548053296 | -122.45323093288799 | (37.7624895480533, -122.453230932888) | |||
| 88995 | 88995 | 57237 | Permitted Site 1 | Tree(s) :: 17 | 959 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/09/1975 12:00:00 AM | Permit Number 14524 | 6003157.7766932 | 2102658.98865518 | 37.7536796895051 | -122.43199624791 | (37.7536796895051, -122.43199624791) | |||
| 111742 | 111742 | 68780 | Permitted Site 1 | Tree(s) :: 17 | 959 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/16/1993 12:00:00 AM | Permit Number 32710 | 6009176.95310097 | 2103582.08234897 | 37.756553700165604 | -122.41124571208401 | (37.7565537001656, -122.411245712084) | |||
| 128822 | 128822 | 54037 | Permitted Site 1 | Tree(s) :: 17 | 957 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/1972 12:00:00 AM | Permit Number 9759 | 6004410.3613312 | 2103324.76407224 | 37.755578684868 | -122.427711961591 | (37.755578684868, -122.427711961591) | |||
| 121413 | 121413 | 64679 | Permitted Site 1 | Tree(s) :: 17 | 956 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/1988 12:00:00 AM | Permit Number 25616 | 6006574.59293679 | 2113813.33754337 | 37.7844999983021 | -122.420972018144 | (37.7844999983021, -122.420972018144) | |||
| 114777 | 114777 | 56546 | Permitted Site 1 | Tree(s) :: 17 | 956 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6010166.84164109 | 2116878.99429559 | 37.7931193913483 | -122.408760362127 | (37.7931193913483, -122.408760362127) | |||||
| 127433 | 127433 | 100183 | Permitted Site 1 | Tree(s) :: 17 | 956 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003075.2 | 2102641.9 | 37.7536280862965 | -122.432280596021 | (37.7536280862965, -122.432280596021) | ||||
| 142526 | 142526 | 56844 | Permitted Site 1 | Tree(s) :: 17 | 956 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/1978 12:00:00 AM | Permit Number 17644 | 5998803.40478425 | 2106705.19114701 | 37.7645417339158 | -122.44734578320299 | (37.7645417339158, -122.447345783203) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");