Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5893 | 5893 | 46201 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2001 12:00:00 AM | Permit Number 44518 | |||||||||
9250 | 9250 | 46200 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2001 12:00:00 AM | Permit Number 44518 | |||||||||
118366 | 118366 | 67075 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 100 Tompkins Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/1995 12:00:00 AM | Permit Number 30469 | 6007674.59209912 | 2096541.81182002 | 37.7371383234242 | -122.41594289157601 | (37.7371383234242, -122.415942891576) | ||
108008 | 108008 | 14770 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1000X McAllister St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Office of Mayor 21 | 02/06/2016 08:42:00 AM | 3 | 4x4 | 6004368.8552829 | 2111899.4426369 | 37.7791203368819 | -122.428466654288 | (37.7791203368819, -122.428466654288) | ||
112538 | 112538 | 14773 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1000X McAllister St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Office of Mayor 21 | 05/13/1992 12:00:00 AM | 6 | 4X4 | 6004368.8552829 | 2111899.4426369 | 37.7791203368819 | -122.428466654288 | (37.7791203368819, -122.428466654288) | ||
52058 | 52058 | 41522 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1001 Mariposa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/20/2000 12:00:00 AM | 3 | Permit Number 42063 | 6014186.00908 | 2106172.78785 | 37.763946866973704 | -122.39410383682 | (37.7639468669737, -122.39410383682) | ||
9197 | 9197 | 24149 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 100X Whitney Young Cir | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 3 | 3x3 | 6016357.373923 | 2096088.8828188 | 37.736379006835996 | -122.385890729183 | (37.736379006836, -122.385890729183) | ||
9227 | 9227 | 24151 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 100X Whitney Young Cir | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 3 | 3x3 | 6016357.373923 | 2096088.8828188 | 37.736379006835996 | -122.385890729183 | (37.736379006836, -122.385890729183) | ||
13371 | 13371 | 24145 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 100X Whitney Young Cir | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6016696.89665 | 2095171.76192 | 37.7338795595807 | -122.384652980151 | (37.7338795595807, -122.384652980151) | |||
14904 | 14904 | 24147 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 100X Whitney Young Cir | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6016689.05107 | 2095205.54183 | 37.7339718785836 | -122.384682457242 | (37.7339718785836, -122.384682457242) | |||
71194 | 71194 | 60642 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 101 Randall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/12/1983 12:00:00 AM | Permit Number 20270 | 6004901.36876785 | 2097539.55337894 | 37.7397215914528 | -122.425602180558 | (37.7397215914528, -122.425602180558) | ||
104065 | 104065 | 41900 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 101 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/20/2000 12:00:00 AM | Permit Number 42265 | 6002336.18060938 | 2108825.44123893 | 37.7705646588804 | -122.43527855581301 | (37.7705646588804, -122.435278555813) | |||
87927 | 87927 | 101047 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1050 Sansome St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/18/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774347 | 6012043.0 | 2119296.0 | 37.799860814363 | -122.40243873444099 | (37.799860814363, -122.402438734441) | |
114943 | 114943 | 61792 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1053 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1985 12:00:00 AM | Permit Number 21815 | 6012220.91982442 | 2103494.12981341 | 37.7564824480415 | -122.400712343497 | (37.7564824480415, -122.400712343497) | ||
9055 | 9055 | 24107 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 105X Whitney Young Cir | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 3 | 3x3 | 6016397.2233978 | 2096041.0813580002 | 37.7362499588234 | -122.385749620885 | (37.7362499588234, -122.385749620885) | ||
9206 | 9206 | 24109 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 105X Whitney Young Cir | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 3 | 3x3 | 6016397.2233978 | 2096041.0813580002 | 37.7362499588234 | -122.385749620885 | (37.7362499588234, -122.385749620885) | ||
85171 | 85171 | 60613 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 106 Randall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/12/1983 12:00:00 AM | Permit Number 20237 | 6004863.02785957 | 2097589.48802411 | 37.7398565341458 | -122.425738300436 | (37.7398565341458, -122.425738300436) | ||
169703 | 169703 | 36194 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 107 Spruce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Permit Number 39260 | 5997029.24357 | 2115938.23155 | 37.7897917089598 | -122.454149011282 | (37.7897917089598, -122.454149011282) | |||
53523 | 53523 | 48812 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1082Street Pennsylvania Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2002 12:00:00 AM | 5 | Permit Number 46042 | 6014467.053730001 | 2102353.10418 | 37.753474456898104 | -122.392864530587 | (37.7534744568981, -122.392864530587) | ||
79486 | 79486 | 48797 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1082Street Pennsylvania Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2002 12:00:00 AM | Permit Number 46042 | 6014495.63347758 | 2102077.94418173 | 37.7527205135809 | -122.39274644691601 | (37.7527205135809, -122.392746446916) | |||
79749 | 79749 | 48808 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1082Street Pennsylvania Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2002 12:00:00 AM | Permit Number 46042 | 6014495.63347758 | 2102077.94418173 | 37.7527205135809 | -122.39274644691601 | (37.7527205135809, -122.392746446916) | |||
80482 | 80482 | 48805 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1082Street Pennsylvania Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2002 12:00:00 AM | Permit Number 46042 | 6014495.63347758 | 2102077.94418173 | 37.7527205135809 | -122.39274644691601 | (37.7527205135809, -122.392746446916) | |||
87368 | 87368 | 48795 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1082Street Pennsylvania Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2002 12:00:00 AM | Permit Number 46042 | 6014495.63347758 | 2102077.94418173 | 37.7527205135809 | -122.39274644691601 | (37.7527205135809, -122.392746446916) | |||
93668 | 93668 | 48814 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1082Street Pennsylvania Ave | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2002 12:00:00 AM | Permit Number 46042 | 6014495.63347758 | 2102077.94418173 | 37.7527205135809 | -122.39274644691601 | (37.7527205135809, -122.392746446916) | |||
93881 | 93881 | 48807 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1082Street Pennsylvania Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2002 12:00:00 AM | Permit Number 46042 | 6014495.63347758 | 2102077.94418173 | 37.7527205135809 | -122.39274644691601 | (37.7527205135809, -122.392746446916) | |||
95001 | 95001 | 48798 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1082Street Pennsylvania Ave | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2002 12:00:00 AM | Permit Number 46042 | 6014495.63347758 | 2102077.94418173 | 37.7527205135809 | -122.39274644691601 | (37.7527205135809, -122.392746446916) | |||
97538 | 97538 | 48793 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1082Street Pennsylvania Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2002 12:00:00 AM | Permit Number 46042 | 6014495.63347758 | 2102077.94418173 | 37.7527205135809 | -122.39274644691601 | (37.7527205135809, -122.392746446916) | |||
103218 | 103218 | 48813 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1082Street Pennsylvania Ave | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2002 12:00:00 AM | Permit Number 46042 | 6014495.63347758 | 2102077.94418173 | 37.7527205135809 | -122.39274644691601 | (37.7527205135809, -122.392746446916) | |||
105017 | 105017 | 48796 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1082Street Pennsylvania Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2002 12:00:00 AM | Permit Number 46042 | 6014495.63347758 | 2102077.94418173 | 37.7527205135809 | -122.39274644691601 | (37.7527205135809, -122.392746446916) | |||
107290 | 107290 | 48806 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1082Street Pennsylvania Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2002 12:00:00 AM | Permit Number 46042 | 6014495.63347758 | 2102077.94418173 | 37.7527205135809 | -122.39274644691601 | (37.7527205135809, -122.392746446916) | |||
112016 | 112016 | 48804 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1082Street Pennsylvania Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2002 12:00:00 AM | Permit Number 46042 | 6014495.63347758 | 2102077.94418173 | 37.7527205135809 | -122.39274644691601 | (37.7527205135809, -122.392746446916) | |||
113270 | 113270 | 48802 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1082Street Pennsylvania Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2002 12:00:00 AM | Permit Number 46042 | 6014495.63347758 | 2102077.94418173 | 37.7527205135809 | -122.39274644691601 | (37.7527205135809, -122.392746446916) | |||
114793 | 114793 | 48794 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1082Street Pennsylvania Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2002 12:00:00 AM | Permit Number 46042 | 6014495.63347758 | 2102077.94418173 | 37.7527205135809 | -122.39274644691601 | (37.7527205135809, -122.392746446916) | |||
116610 | 116610 | 48792 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1082Street Pennsylvania Ave | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2002 12:00:00 AM | Permit Number 46042 | 6014495.63347758 | 2102077.94418173 | 37.7527205135809 | -122.39274644691601 | (37.7527205135809, -122.392746446916) | |||
119141 | 119141 | 48803 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1082Street Pennsylvania Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2002 12:00:00 AM | Permit Number 46042 | 6014495.63347758 | 2102077.94418173 | 37.7527205135809 | -122.39274644691601 | (37.7527205135809, -122.392746446916) | |||
124980 | 124980 | 48800 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1082Street Pennsylvania Ave | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2002 12:00:00 AM | Permit Number 46042 | 6014495.63347758 | 2102077.94418173 | 37.7527205135809 | -122.39274644691601 | (37.7527205135809, -122.392746446916) | |||
127193 | 127193 | 48801 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1082Street Pennsylvania Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2002 12:00:00 AM | Permit Number 46042 | 6014495.63347758 | 2102077.94418173 | 37.7527205135809 | -122.39274644691601 | (37.7527205135809, -122.392746446916) | |||
147265 | 147265 | 48809 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1082Street Pennsylvania Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2002 12:00:00 AM | 3 | Permit Number 46042 | 6014468.625469999 | 2102279.9042599997 | 37.753273552832205 | -122.392853974356 | (37.7532735528322, -122.392853974356) | ||
150866 | 150866 | 48811 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1082Street Pennsylvania Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2002 12:00:00 AM | 7 | Permit Number 46042 | 6014468.770930001 | 2102318.37211 | 37.7533791854235 | -122.392856162375 | (37.7533791854235, -122.392856162375) | ||
151589 | 151589 | 48815 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1082Street Pennsylvania Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2002 12:00:00 AM | 5 | Permit Number 46042 | 6014467.97393 | 2102326.82142 | 37.7534023411579 | -122.392859509671 | (37.7534023411579, -122.392859509671) | ||
151617 | 151617 | 48799 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1082Street Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2002 12:00:00 AM | 5 | Permit Number 46042 | 6014465.83632 | 2102364.69447 | 37.753506213741396 | -122.392869551502 | (37.7535062137414, -122.392869551502) | ||
161197 | 161197 | 48810 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1082Street Pennsylvania Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2002 12:00:00 AM | 5 | Permit Number 46042 | 6014469.89088 | 2102291.4479400003 | 37.753305319601495 | -122.392850405821 | (37.7533053196015, -122.392850405821) | ||
90598 | 90598 | 43924 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1100X HAMPSHIRE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/10/2000 12:00:00 AM | Permit Number 43515 | 6010276.0 | 2102522.0 | 37.7537045273505 | -122.407370066225 | (37.7537045273505, -122.407370066225) | ||
119465 | 119465 | 43925 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1100X HAMPSHIRE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/10/2000 12:00:00 AM | Permit Number 43515 | 6010276.0 | 2102522.0 | 37.7537045273505 | -122.407370066225 | (37.7537045273505, -122.407370066225) | ||
60352 | 60352 | 44270 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1101 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/13/2001 12:00:00 AM | 6 | 3x3 | Permit Number 43698 | 6009401.249919999 | 2117056.5968 | 37.793564133816794 | -122.411421918689 | (37.7935641338168, -122.411421918689) | |
18932 | 18932 | 30938 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1106 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2015 12:00:00 AM | 8 | 3x3 | Permit Number 772469 | 5995956.71997 | 2091289.90864 | 37.722052099618104 | -122.456077064214 | (37.7220520996181, -122.456077064214) | |
9464 | 9464 | 24167 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 110X Whitney Young Cir | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/01/2011 12:00:00 AM | 2 | 3x3 | 6016346.0952597 | 2096044.1423308998 | 37.736255534298 | -122.38592660691401 | (37.736255534298, -122.385926606914) | ||
94122 | 94122 | 81726 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1111X 23rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/06/2012 12:00:00 AM | 5 | 3x3 | Permit Number 768902 | 6015016.9034833005 | 2102945.53994176 | 37.7551316851739 | -122.39100442062201 | (37.7551316851739, -122.391004420622) |
108386 | 108386 | 81728 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1111X 23rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/06/2012 12:00:00 AM | 7 | 4x4 | Permit Number 768902 | 6015016.9034833005 | 2102945.53994176 | 37.7551316851739 | -122.39100442062201 | (37.7551316851739, -122.391004420622) |
124741 | 124741 | 81725 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1111X 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/06/2012 12:00:00 AM | 7 | 4x4 | Permit Number 768902 | 6015016.9034833005 | 2102945.53994176 | 37.7551316851739 | -122.39100442062201 | (37.7551316851739, -122.391004420622) |
102380 | 102380 | 68489 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1114-1116 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | Permit Number 32364 | 6009979.78982851 | 2102702.84015298 | 37.754184490832706 | -122.40840718703699 | (37.7541844908327, -122.408407187037) | ||
108092 | 108092 | 61119 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1120 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/1983 12:00:00 AM | 14 | 3x3 | Permit Number 20967 | 6007612.89522655 | 2103123.90329719 | 37.7552078032974 | -122.416622341764 | (37.7552078032974, -122.416622341764) | |
96839 | 96839 | 65258 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1121 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/18/1994 12:00:00 AM | Permit Number 28057 | 6009490.15544197 | 2102642.26317624 | 37.753990728209 | -122.41009619440399 | (37.753990728209, -122.410096194404) | ||
78598 | 78598 | 69390 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1124 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1994 12:00:00 AM | Permit Number 33493 | 6001914.6702364 | 2087745.37882292 | 37.7126597908787 | -122.435228529911 | (37.7126597908787, -122.435228529911) | ||
112025 | 112025 | 12667 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1124 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3X3 | 5991972.94269 | 2114825.89139 | 37.7864462960863 | -122.471562077277 | (37.7864462960863, -122.471562077277) | |||
82900 | 82900 | 37011 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1133 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | Permit Number 39625 | 6009493.89299858 | 2102575.04875629 | 37.753806381943896 | -122.41007852412201 | (37.7538063819439, -122.410078524122) | ||
65491 | 65491 | 69396 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1133 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1994 12:00:00 AM | 7 | Permit Number 33500 | 6001570.284530001 | 2087031.2786 | 37.7106794663567 | -122.436367757869 | (37.7106794663567, -122.436367757869) | |
70248 | 70248 | 100361 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1135 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6007562.69285 | 2118825.76087 | 37.7983185248271 | -122.417908959744 | (37.7983185248271, -122.417908959744) | |||
128591 | 128591 | 69392 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1139 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1994 12:00:00 AM | Permit Number 33495 | 6001921.70531705 | 2087676.61824048 | 37.71247138896779 | -122.435199299374 | (37.7124713889678, -122.435199299374) | ||
119086 | 119086 | 69400 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1155 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1994 12:00:00 AM | Permit Number 33504 | 6001338.55016435 | 2087735.88894959 | 37.7126010005012 | -122.437219100024 | (37.7126010005012, -122.437219100024) | ||
28850 | 28850 | 110361 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1155 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 6008381.52689 | 2115877.48528 | 37.790269335318996 | -122.41486676369699 | (37.790269335319, -122.414866763697) | ||||
160970 | 160970 | 59713 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1155 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/18/1981 12:00:00 AM | 7 | 3x3 | Permit Number 19144 | 6008363.54406 | 2115876.33125 | 37.790265156173504 | -122.414928901463 | (37.7902651561735, -122.414928901463) | |
75609 | 75609 | 38463 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1160 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/20/1998 12:00:00 AM | 4 | Permit Number 40473 | 6017671.3057 | 2092861.7612 | 37.727590590458604 | -122.38112356357 | (37.7275905904586, -122.38112356357) | ||
27085 | 27085 | 87158 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 119 Augusta St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2008 12:00:00 AM | 7 | 3x3 | Permit Number 50139 | 6011083.99361 | 2095446.91838 | 37.7343230701451 | -122.404077946949 | (37.7343230701451, -122.404077946949) | |
123996 | 123996 | 88467 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 119 Augusta St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51421 | 6011176.0 | 2095454.0 | 37.7343476550611 | -122.40376034751101 | (37.7343476550611, -122.403760347511) | |||
88863 | 88863 | 92267 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 119 Madrone Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2009 12:00:00 AM | 3x3 | Permit Number 52719 | 5992767.0 | 2098334.0 | 37.7412098217915 | -122.46761506147101 | (37.7412098217915, -122.467615061471) | ||
142371 | 142371 | 92268 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 119 Madrone Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2009 12:00:00 AM | 3x3 | Permit Number 52719 | 5992767.0 | 2098334.0 | 37.7412098217915 | -122.46761506147101 | (37.7412098217915, -122.467615061471) | ||
99583 | 99583 | 9555 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1195X Golden Gate Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Office of Mayor 21 | 6 | 3X3 | 6003912.3472435 | 2112132.7194564 | 37.7797350134544 | -122.43006254712499 | (37.7797350134544, -122.430062547125) | |||
140317 | 140317 | 9553 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1195X Golden Gate Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Office of Mayor 21 | 6 | 3X3 | 6003912.3472435 | 2112132.7194564 | 37.7797350134544 | -122.43006254712499 | (37.7797350134544, -122.430062547125) | |||
141722 | 141722 | 9550 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1195X Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Office of Mayor 21 | 6 | 3X3 | 6003912.3472435 | 2112132.7194564 | 37.7797350134544 | -122.43006254712499 | (37.7797350134544, -122.430062547125) | |||
96891 | 96891 | 41132 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 11X Belvedere St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2016 12:00:00 AM | 3 | 3x3 | Permit Number 53576 | 5998162.17039542 | 2108554.54786356 | 37.769582935081296 | -122.449696907216 | (37.7695829350813, -122.449696907216) | |
102205 | 102205 | 41131 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 11X Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2016 12:00:00 AM | 3 | 3x3 | Permit Number 53576 | 5998162.17039542 | 2108554.54786356 | 37.769582935081296 | -122.449696907216 | (37.7695829350813, -122.449696907216) | |
9321 | 9321 | 11465 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 12 Jakey Ct | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/1992 12:00:00 AM | 6 | 3X3 | 6016782.5188136 | 2095601.0665952999 | 37.7350630793796 | -122.384386845805 | (37.7350630793796, -122.384386845805) | ||
14701 | 14701 | 11464 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 12 Jakey Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/1992 12:00:00 AM | 6 | 3X3 | 6016788.858519999 | 2095545.6720200002 | 37.734911327499205 | -122.384361070118 | (37.7349113274992, -122.384361070118) | ||
16006 | 16006 | 11463 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 12 Jakey Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/1992 12:00:00 AM | 6 | 3X3 | 6016797.65257 | 2095521.33822 | 37.7348449980066 | -122.384328971504 | (37.7348449980066, -122.384328971504) | ||
15141 | 15141 | 81729 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1200 Indiana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/06/2012 12:00:00 AM | 5 | 3x3 | Permit Number 768902 | 6015012.434719999 | 2102924.7634900003 | 37.7550743894922 | -122.391018422974 | (37.7550743894922, -122.391018422974) |
100710 | 100710 | 61557 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1201 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/25/1984 12:00:00 AM | Permit Number 21517 | 6012259.00108581 | 2102806.05686261 | 37.754595274223206 | -122.400532312162 | (37.7545952742232, -122.400532312162) | ||
165345 | 165345 | 52196 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1205 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/2013 12:00:00 AM | 2 | Permit Number 770878 | 6007126.92706 | 2119460.55943 | 37.800036988073295 | -122.419461903656 | (37.8000369880733, -122.419461903656) | ||
102568 | 102568 | 46138 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1207 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2001 12:00:00 AM | Permit Number 44488 | 5998167.19673673 | 2106203.84420023 | 37.763128786615 | -122.449510117352 | (37.763128786615, -122.449510117352) | ||
91690 | 91690 | 85246 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 121 Italy Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/20/2007 12:00:00 AM | Permit Number 49547 | 6001091.3 | 2089693.7 | 37.717962654310206 | -122.43821383738899 | (37.7179626543102, -122.438213837389) | |||
47669 | 47669 | 36825 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1220 Fitzgerald Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2006 12:00:00 AM | 5 | Permit Number 49072 | 6014545.9992 | 2090648.9983 | 37.721341772631895 | -122.39177321286199 | (37.7213417726319, -122.391773212862) | |
105821 | 105821 | 36824 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1220 Fitzgerald Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2006 12:00:00 AM | Permit Number 49072 | 6014575.87209861 | 2090621.86928293 | 37.7212689399964 | -122.39166805396799 | (37.7212689399964, -122.391668053968) | ||
121687 | 121687 | 68372 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1239 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32194 | 5998975.45653157 | 2105577.19771881 | 37.7614543762476 | -122.446669539944 | (37.7614543762476, -122.446669539944) | ||
102409 | 102409 | 70248 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1248 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/2010 12:00:00 AM | 3x3 | Permit Number 53999 | 6008664.66375358 | 2101270.88121733 | 37.750178918205705 | -122.41285400071199 | (37.7501789182057, -122.412854000712) | |
14888 | 14888 | 24090 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 125X Whitney Young Cir | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/07/1997 12:00:00 AM | 6 | 3x3 | 6016342.364159999 | 2095991.2568 | 37.736110114791 | -122.3859358217 | (37.736110114791, -122.3859358217) | ||
128071 | 128071 | 96054 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1261 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767682 | 6009524.0 | 2101832.0 | 37.7517678233481 | -122.40992195715201 | (37.7517678233481, -122.409921957152) | |
70653 | 70653 | 65118 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 127 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/1989 12:00:00 AM | 4 | Permit Number 27088 | 5989266.29156 | 2114491.8349900004 | 37.7853721122289 | -122.480901836159 | (37.7853721122289, -122.480901836159) | |
107752 | 107752 | 43914 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1275 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/10/2000 12:00:00 AM | Permit Number 43510 | 6010342.61796113 | 2101801.88933632 | 37.7517309913329 | -122.40708893021099 | (37.7517309913329, -122.407088930211) | ||
87317 | 87317 | 8192 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1280 Fulton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/16/1991 12:00:00 AM | 6 | 3X3 | 6001602.3460099995 | 2111171.39622 | 37.776964363900596 | -122.437984956441 | (37.7769643639006, -122.437984956441) | ||
92348 | 92348 | 690 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1299X Potrero Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 20 | 3X3 | 6010664.761195901 | 2101498.8811325002 | 37.7509170198962 | -122.40595356703501 | (37.7509170198962, -122.405953567035) | |||
144769 | 144769 | 689 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1299X Potrero Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 3X3 | 6010664.761195901 | 2101498.8811325002 | 37.7509170198962 | -122.40595356703501 | (37.7509170198962, -122.405953567035) | |||
155477 | 155477 | 65116 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 130 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/1989 12:00:00 AM | 3 | Permit Number 27086 | 5989313.29751 | 2114460.89745 | 37.7852898986689 | -122.480736945877 | (37.7852898986689, -122.480736945877) | |
47443 | 47443 | 96053 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 130 Coso Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767681 | 6007306.3 | 2099659.0 | 37.745676716208 | -122.417437096994 | (37.745676716208, -122.417437096994) | |
95440 | 95440 | 96052 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 130 Coso Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767681 | 6007306.3 | 2099659.0 | 37.745676716208 | -122.417437096994 | (37.745676716208, -122.417437096994) | |
166156 | 166156 | 67528 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1306 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/22/1992 12:00:00 AM | 10 | Permit Number 31066 | 6013997.6079400005 | 2104810.58865 | 37.760196092391 | -122.394660066634 | (37.760196092391, -122.394660066634) | |
81749 | 81749 | 33436 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 131 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/20/1996 12:00:00 AM | Permit Number 37539 | 6006637.52258219 | 2098912.24250349 | 37.743588636726706 | -122.419696659188 | (37.7435886367267, -122.419696659188) | |||
93793 | 93793 | 50131 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 131 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2003 12:00:00 AM | Permit Number 46852 | 5992954.93923014 | 2098191.67856897 | 37.7408298924183 | -122.466954895883 | (37.7408298924183, -122.466954895883) | ||
77437 | 77437 | 10379 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1316 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/31/1990 12:00:00 AM | 18 | 3X3 | 5999827.9509 | 2108872.87214 | 37.7705521343685 | -122.44395792635001 | (37.7705521343685, -122.44395792635) | ||
19876 | 19876 | 10381 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1324 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 2X3 | 5999783.9663 | 2108832.8405 | 37.770439708466604 | -122.44410719203998 | (37.7704397084666, -122.44410719204) | |||
145278 | 145278 | 95794 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1330 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/2011 12:00:00 AM | 3x3 | Permit Number 767537 | 6010317.0 | 2101466.0 | 37.750807279737295 | -122.407153846535 | (37.7508072797373, -122.407153846535) |
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");