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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
169020 | 169020 | 30735 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 281 Rose St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | 6 | Permit Number 34629 | 6005244.0655 | 2109725.8172 | 37.773201579085004 | -122.42528422609699 | (37.773201579085, -122.425284226097) | |
99267 | 99267 | 30767 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1595 Underwood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | Permit Number 34647 | 6014606.20359025 | 2093675.42749231 | 37.729655084274995 | -122.39177660646999 | (37.729655084275, -122.39177660647) | ||
172828 | 172828 | 30770 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1662 Wallace Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/2008 12:00:00 AM | 2 | Permit Number 51077 | 6014463.7744 | 2093152.8983 | 37.7282124168861 | -122.39223247286101 | (37.7282124168861, -122.392232472861) | ||
96892 | 96892 | 30797 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 142 Acadia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1995 12:00:00 AM | Permit Number 34664 | 6001440.7282053 | 2094773.69226545 | 37.7319310278176 | -122.43736957803301 | (37.7319310278176, -122.437369578033) | ||
70597 | 70597 | 30894 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 133 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/13/1995 12:00:00 AM | 1 | Permit Number 34721 | 5996515.6245 | 2113531.2346 | 37.783153273367205 | -122.45575201055 | (37.7831532733672, -122.45575201055) | ||
39287 | 39287 | 31050 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 25 South Hill Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/01/2008 12:00:00 AM | 1 | 3x3 | Permit Number 51560 | 6002835.195830001 | 2087448.13614 | 37.711895858785894 | -122.432025692555 | (37.7118958587859, -122.432025692555) | |
80096 | 80096 | 31127 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 121 Foerster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 5.5x4 | Permit Number 34844 | 5998074.93385537 | 2093867.82881443 | 37.729251820430605 | -122.448940561252 | (37.7292518204306, -122.448940561252) | |
134091 | 134091 | 31134 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 154 Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 2 | Permit Number 34849 | 6000371.52521 | 2094373.11197 | 37.730770284917895 | -122.441037301429 | (37.7307702849179, -122.441037301429) | |
150611 | 150611 | 31299 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 519 Birch St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1995 12:00:00 AM | 8 | Permit Number 34943 | 6005251.2106 | 2111468.7266 | 37.777987587802 | -122.42538356524099 | (37.777987587802, -122.425383565241) | |
179096 | 179096 | 31300 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 519 Birch St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1995 12:00:00 AM | 10 | Permit Number 34943 | 6005263.3007 | 2111469.3023 | 37.7779898515936 | -122.425341782234 | (37.7779898515936, -122.425341782234) | |
74745 | 74745 | 31301 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 529 Birch St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1995 12:00:00 AM | 8 | Permit Number 34944 | 6005236.8177 | 2111465.8481 | 37.7779788709631 | -122.425433150534 | (37.7779788709631, -122.425433150534) | |
182779 | 182779 | 31302 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 529 Birch St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1995 12:00:00 AM | 9 | Permit Number 34944 | 6005223.0006 | 2111465.2723 | 37.7779765092875 | -122.42548090783501 | (37.7779765092875, -122.425480907835) | |
187911 | 187911 | 31303 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 535 Birch St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1995 12:00:00 AM | 7 | Permit Number 34945 | 6005167.7319 | 2111457.2123 | 37.777951255610795 | -122.425671528209 | (37.7779512556108, -122.425671528209) | |
71730 | 71730 | 31304 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 535 Birch St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1995 12:00:00 AM | 7 | Permit Number 34945 | 6005195.9419 | 2111461.818 | 37.7779654957454 | -122.425574267643 | (37.7779654957454, -122.425574267643) | |
151643 | 151643 | 31579 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1766 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | 10 | Permit Number 35118 | 5989083.5648 | 2103328.988 | 37.7547113797178 | -122.480716506349 | (37.7547113797178, -122.480716506349) | |
84774 | 84774 | 31652 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2066 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/31/1995 12:00:00 AM | Permit Number 35162 | 6001931.34452098 | 2119821.7914856 | 37.8007348293225 | -122.437466455186 | (37.8007348293225, -122.437466455186) | |||
128993 | 128993 | 31717 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2 Twin Peaks Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | Permit Number 35217 | 5999015.35080387 | 2105425.59790745 | 37.7610403997541 | -122.446520655595 | (37.7610403997541, -122.446520655595) | ||
124206 | 124206 | 31718 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2 Twin Peaks Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | Permit Number 35217 | 5999015.35080387 | 2105425.59790745 | 37.7610403997541 | -122.446520655595 | (37.7610403997541, -122.446520655595) | ||
169349 | 169349 | 31758 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2646 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 8 | Permit Number 35244 | 5989596.3538 | 2097340.4362 | 37.738298177735 | -122.478505265789 | (37.738298177735, -122.478505265789) | |
15956 | 15956 | 31845 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35298 | |||||||||
11986 | 11986 | 31849 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35298 | |||||||||
15875 | 15875 | 31850 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35298 | |||||||||
11785 | 11785 | 31851 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1117 Houston St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35299 | ||||||||
5373 | 5373 | 31852 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1117 Houston St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1995 12:00:00 AM | Permit Number 35299 | ||||||||
85569 | 85569 | 31855 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 15 Langton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | Permit Number 35301 | 6009805.81882643 | 2111161.45127671 | 37.7774001559158 | -122.409605796854 | (37.7774001559158, -122.409605796854) | ||
142824 | 142824 | 31920 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2296 15th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1995 12:00:00 AM | Permit Number 35341 | 5991714.32950315 | 2099798.09333533 | 37.7451690123809 | -122.47136143824699 | (37.7451690123809, -122.471361438247) | ||
93746 | 93746 | 31921 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2296 15th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1995 12:00:00 AM | Permit Number 35341 | 5991714.32950315 | 2099798.09333533 | 37.7451690123809 | -122.47136143824699 | (37.7451690123809, -122.471361438247) | ||
145099 | 145099 | 31922 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2296 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1995 12:00:00 AM | Permit Number 35341 | 5991714.32950315 | 2099798.09333533 | 37.7451690123809 | -122.47136143824699 | (37.7451690123809, -122.471361438247) | ||
20378 | 20378 | 31923 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2296 15th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1995 12:00:00 AM | Permit Number 35341 | 5991714.32950315 | 2099798.09333533 | 37.7451690123809 | -122.47136143824699 | (37.7451690123809, -122.471361438247) | ||
109568 | 109568 | 32092 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 4043 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1995 12:00:00 AM | Permit Number 35465 | 6002732.39068371 | 2104711.97751981 | 37.759292580613604 | -122.433614037894 | (37.7592925806136, -122.433614037894) | ||
116548 | 116548 | 32093 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 4043 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1995 12:00:00 AM | Permit Number 35465 | 6002732.39068371 | 2104711.97751981 | 37.759292580613604 | -122.433614037894 | (37.7592925806136, -122.433614037894) | ||
145699 | 145699 | 32137 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 618 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1995 12:00:00 AM | Permit Number 35496 | 6004564.35276407 | 2110630.82762794 | 37.7756480927458 | -122.42769993653499 | (37.7756480927458, -122.427699936535) | |||
115410 | 115410 | 32139 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 618 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1995 12:00:00 AM | Permit Number 35496 | 6004564.35276407 | 2110630.82762794 | 37.7756480927458 | -122.42769993653499 | (37.7756480927458, -122.427699936535) | |||
139535 | 139535 | 32140 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 618 Buchanan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1995 12:00:00 AM | Permit Number 35496 | 6004564.35276407 | 2110630.82762794 | 37.7756480927458 | -122.42769993653499 | (37.7756480927458, -122.427699936535) | |||
145007 | 145007 | 32149 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 131 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35500 | 6006458.85096741 | 2110609.91009121 | 37.775697640431396 | -122.42114490355699 | (37.7756976404314, -122.421144903557) | ||
114564 | 114564 | 32169 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 117 Lakeshore Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35511 | 5984955.52028324 | 2094294.56016286 | 37.7296644874619 | -122.49432629716298 | (37.7296644874619, -122.494326297163) | ||
127685 | 127685 | 32170 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 117 Lakeshore Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35511 | 5984955.52028324 | 2094294.56016286 | 37.7296644874619 | -122.49432629716298 | (37.7296644874619, -122.494326297163) | ||
88347 | 88347 | 32171 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 117 Lakeshore Dr | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35511 | 5984955.52028324 | 2094294.56016286 | 37.7296644874619 | -122.49432629716298 | (37.7296644874619, -122.494326297163) | ||
107326 | 107326 | 32172 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 117 Lakeshore Dr | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35511 | 5984955.52028324 | 2094294.56016286 | 37.7296644874619 | -122.49432629716298 | (37.7296644874619, -122.494326297163) | ||
18086 | 18086 | 32173 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 117 Lakeshore Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35511 | 5984955.52028324 | 2094294.56016286 | 37.7296644874619 | -122.49432629716298 | (37.7296644874619, -122.494326297163) | ||
124447 | 124447 | 32174 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 119 Lakeshore Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35512 | 5984952.68570177 | 2094288.33327225 | 37.7296472241819 | -122.49433563765699 | (37.7296472241819, -122.494335637657) | ||
145196 | 145196 | 32175 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 119 Lakeshore Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1995 12:00:00 AM | Permit Number 35512 | 5984952.68570177 | 2094288.33327225 | 37.7296472241819 | -122.49433563765699 | (37.7296472241819, -122.494335637657) | ||
120359 | 120359 | 32267 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 267 Texas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1996 12:00:00 AM | Permit Number 36853 | 6013772.46926434 | 2105862.13808331 | 37.7630708975316 | -122.395512392676 | (37.7630708975316, -122.395512392676) | |||
90220 | 90220 | 32381 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 106 Park St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/03/1996 12:00:00 AM | Permit Number 36928 | 6005508.65097551 | 2096383.43998281 | 37.7365814594064 | -122.423420287008 | (37.7365814594064, -122.423420287008) | |||
114011 | 114011 | 32382 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 106 Park St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/03/1996 12:00:00 AM | Permit Number 36928 | 6005508.65097551 | 2096383.43998281 | 37.7365814594064 | -122.423420287008 | (37.7365814594064, -122.423420287008) | |||
113477 | 113477 | 32383 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 106 Park St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/03/1996 12:00:00 AM | Permit Number 36928 | 6005508.65097551 | 2096383.43998281 | 37.7365814594064 | -122.423420287008 | (37.7365814594064, -122.423420287008) | |||
128135 | 128135 | 32384 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 106 Park St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/03/1996 12:00:00 AM | Permit Number 36928 | 6005508.65097551 | 2096383.43998281 | 37.7365814594064 | -122.423420287008 | (37.7365814594064, -122.423420287008) | |||
99137 | 99137 | 32397 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 226 Richland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/03/1996 12:00:00 AM | Permit Number 36938 | 6005820.24941842 | 2096097.7148736 | 37.7358145039443 | -122.42232266151301 | (37.7358145039443, -122.422322661513) | ||
104370 | 104370 | 32431 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 30 Tingley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/09/1996 12:00:00 AM | Permit Number 36958 | 6002847.4322838 | 2093541.64136391 | 37.72862796611629 | -122.432418342718 | (37.7286279661163, -122.432418342718) | |||
141694 | 141694 | 32790 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1704 Fulton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37155 | 5999594.67382686 | 2110888.19372737 | 37.776072385759605 | -122.44490972486601 | (37.7760723857596, -122.444909724866) | ||
18075 | 18075 | 32820 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 4231 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37179 | 6001652.66778496 | 2102313.08223681 | 37.7526444703409 | -122.43717647687599 | (37.7526444703409, -122.437176476876) | ||
40005 | 40005 | 32827 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 4107 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 6 | 3x3 | Permit Number 37185 | 6002480.53446063 | 2101776.94850735 | 37.751219399221604 | -122.434275246016 | (37.7512193992216, -122.434275246016) |
79577 | 79577 | 32850 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 743 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/2006 12:00:00 AM | Permit Number 37201 | 6001607.63275994 | 2102018.09259502 | 37.751831939335204 | -122.437311094932 | (37.7518319393352, -122.437311094932) | ||
128893 | 128893 | 32852 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 764 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1999 12:00:00 AM | Permit Number 41115 | 6001471.9166257 | 2102062.60736984 | 37.751946450075394 | -122.437783607007 | (37.7519464500754, -122.437783607007) | ||
104375 | 104375 | 32883 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1272 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/1996 12:00:00 AM | Permit Number 37227 | 5994266.48992242 | 2106860.31836546 | 37.7647073772985 | -122.463048880777 | (37.7647073772985, -122.463048880777) | ||
79015 | 79015 | 32921 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1392 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/1996 12:00:00 AM | Permit Number 37251 | 5993527.89393066 | 2105989.81652966 | 37.7622746341272 | -122.465540224747 | (37.7622746341272, -122.465540224747) | ||
98796 | 98796 | 32922 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1392 09th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/1996 12:00:00 AM | Permit Number 37251 | 5993527.89393066 | 2105989.81652966 | 37.7622746341272 | -122.465540224747 | (37.7622746341272, -122.465540224747) | ||
111078 | 111078 | 32925 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 338 Judah St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/1996 12:00:00 AM | 3x3 | Permit Number 37251 | 5993527.89393066 | 2105989.81652966 | 37.7622746341272 | -122.465540224747 | (37.7622746341272, -122.465540224747) | |
126352 | 126352 | 33042 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 407 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | Permit Number 37319 | 6005521.73281863 | 2101332.19930241 | 37.750170367356 | -122.423726818664 | (37.750170367356, -122.423726818664) | ||
88624 | 88624 | 33180 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 521 Dewey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/29/2000 12:00:00 AM | Permit Number 42760 | 5994469.49128291 | 2099720.55055185 | 37.7451150932518 | -122.461829011712 | (37.7451150932518, -122.461829011712) | ||
105465 | 105465 | 33331 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1771 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/01/2005 12:00:00 AM | Permit Number 37471 | 6004431.94596599 | 2119422.40230613 | 37.7997800572789 | -122.428784847863 | (37.7997800572789, -122.428784847863) | ||
53793 | 53793 | 33345 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 90 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | Permit Number 37482 | 6001488.85408541 | 2094961.63013744 | 37.7324497978026 | -122.437216648553 | (37.7324497978026, -122.437216648553) | ||
81105 | 81105 | 33461 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 305 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/27/1996 12:00:00 AM | Permit Number 37800 | 6006692.6358567 | 2098010.19766457 | 37.7411149282021 | -122.41944210942499 | (37.7411149282021, -122.419442109425) | |||
95468 | 95468 | 33546 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 222 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/1997 12:00:00 AM | Permit Number 37840 | 6007089.89691831 | 2097701.9148176997 | 37.740290819473294 | -122.418046671199 | (37.7402908194733, -122.418046671199) | |||
103122 | 103122 | 33549 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 218 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/1996 12:00:00 AM | Permit Number 37657 | 6007099.28804647 | 2097719.41644198 | 37.7403394036016 | -122.418015440747 | (37.7403394036016, -122.418015440747) | |||
119735 | 119735 | 33592 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 229 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/27/1996 12:00:00 AM | Permit Number 37699 | 6006800.96308098 | 2097830.12940838 | 37.7406266017969 | -122.419054783101 | (37.7406266017969, -122.419054783101) | ||
109518 | 109518 | 33616 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 426 Lily St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/20/1999 12:00:00 AM | Permit Number 37725 | 6004541.83388077 | 2110015.73229407 | 37.7739579174854 | -122.427733999418 | (37.7739579174854, -122.427733999418) | ||
96687 | 96687 | 33620 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 426 Lily St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/20/1999 12:00:00 AM | Permit Number 37725 | 6004541.83388077 | 2110015.73229407 | 37.7739579174854 | -122.427733999418 | (37.7739579174854, -122.427733999418) | ||
109525 | 109525 | 33656 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 595 Linden St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1996 12:00:00 AM | Permit Number 37745 | 6004567.28962624 | 2110660.7642941 | 37.775730457627795 | -122.427691910628 | (37.7757304576278, -122.427691910628) | |||
102592 | 102592 | 33657 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 595 Linden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1996 12:00:00 AM | Permit Number 37745 | 6004567.28962624 | 2110660.7642941 | 37.775730457627795 | -122.427691910628 | (37.7757304576278, -122.427691910628) | |||
83725 | 83725 | 33696 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 36 Germania St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1996 12:00:00 AM | Permit Number 37767 | 6004073.12371459 | 2108909.64468264 | 37.7708943463194 | -122.42927645844601 | (37.7708943463194, -122.429276458446) | |||
112262 | 112262 | 33701 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 119 Germania St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/04/1996 12:00:00 AM | Permit Number 37770 | 6003654.24341388 | 2108799.1286398 | 37.7705671735444 | -122.430717487593 | (37.7705671735444, -122.430717487593) | ||
119202 | 119202 | 33702 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 119 Germania St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1996 12:00:00 AM | Permit Number 37770 | 6003654.24341388 | 2108799.1286398 | 37.7705671735444 | -122.430717487593 | (37.7705671735444, -122.430717487593) | |||
84397 | 84397 | 33703 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 196 Germania St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/04/1996 12:00:00 AM | Permit Number 37772 | 6003356.08500561 | 2108810.32684763 | 37.7705810245056 | -122.431749619478 | (37.7705810245056, -122.431749619478) | ||
77341 | 77341 | 33704 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 196 Germania St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/04/1996 12:00:00 AM | Permit Number 37772 | 6003356.08500561 | 2108810.32684763 | 37.7705810245056 | -122.431749619478 | (37.7705810245056, -122.431749619478) | ||
145702 | 145702 | 33705 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 156 Germania St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1996 12:00:00 AM | Permit Number 37773 | 6003507.92359647 | 2108831.35817354 | 37.7706473771769 | -122.431225909902 | (37.7706473771769, -122.431225909902) | |||
121719 | 121719 | 33706 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 156 Germania St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1996 12:00:00 AM | Permit Number 37773 | 6003507.92359647 | 2108831.35817354 | 37.7706473771769 | -122.431225909902 | (37.7706473771769, -122.431225909902) | |||
144103 | 144103 | 33707 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 150 Germania St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1996 12:00:00 AM | Permit Number 37774 | 6003530.69937314 | 2108834.51287077 | 37.7706573298717 | -122.431147353426 | (37.7706573298717, -122.431147353426) | |||
112282 | 112282 | 33708 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 20 Germania St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1996 12:00:00 AM | 4 | 3x3 | Permit Number 37775 | 6004167.63204268 | 2108922.73514509 | 37.770935639433105 | -122.42895048520799 | (37.7709356394331, -122.428950485208) | |
112000 | 112000 | 33716 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 166 Germania St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/12/1997 12:00:00 AM | Permit Number 37853 | 6003469.96394021 | 2108826.10034088 | 37.770630789223496 | -122.431356837413 | (37.7706307892235, -122.431356837413) | |||
85021 | 85021 | 33758 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 842 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/1996 12:00:00 AM | Permit Number 37811 | 5981102.7142707 | 2109980.14676383 | 37.77250644827279 | -122.508809756644 | (37.7725064482728, -122.508809756644) | |||
80652 | 80652 | 33821 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 56 Mill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/03/1985 12:00:00 AM | Permit Number 37837 | 6010417.94927739 | 2089844.96936421 | 37.7189040522027 | -122.40598618211901 | (37.7189040522027, -122.405986182119) | |||
110082 | 110082 | 34095 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 598 Miramar Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/1997 12:00:00 AM | Permit Number 37973 | 5995414.64611355 | 2093305.76310855 | 37.7275560235395 | -122.458096686641 | (37.7275560235395, -122.458096686641) | ||
124721 | 124721 | 34096 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 600 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37974 | 5995414.643408099 | 2093328.34737639 | 37.727618034343706 | -122.45809832977899 | (37.7276180343437, -122.458098329779) | |||
95761 | 95761 | 34097 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 600 Miramar Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37974 | 5995414.643408099 | 2093328.34737639 | 37.727618034343706 | -122.45809832977899 | (37.7276180343437, -122.458098329779) | |||
106645 | 106645 | 34098 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 600 Miramar Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37974 | 5995414.643408099 | 2093328.34737639 | 37.727618034343706 | -122.45809832977899 | (37.7276180343437, -122.458098329779) | |||
96310 | 96310 | 34129 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1401 Plymouth Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/1997 12:00:00 AM | Permit Number 37983 | 5995840.26429469 | 2093321.75315516 | 37.7276243745144 | -122.45662648597799 | (37.7276243745144, -122.456626485978) | ||
119912 | 119912 | 34291 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2755 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/2002 12:00:00 AM | Permit Number 38082 | 6010200.77645809 | 2102785.10584633 | 37.7544227469466 | -122.407648757096 | (37.7544227469466, -122.407648757096) | ||
108700 | 108700 | 34300 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1247 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | 10x6 | Permit Number 38088 | 6010333.98586121 | 2101958.21119992 | 37.7521597335331 | -122.40712979916401 | (37.7521597335331, -122.407129799164) | |
88065 | 88065 | 34303 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1219 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38091 | 6011656.31212487 | 2091520.16541192 | 37.7235729821535 | -122.40182331486 | (37.7235729821535, -122.40182331486) | ||
9942 | 9942 | 34361 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1838 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/11/2017 12:00:00 AM | 3 | Permit Number 779412 | 6004552.33920365 | 2098065.78752592 | 37.7411467825752 | -122.42684644404301 | (37.7411467825752, -122.426846444043) | |
99821 | 99821 | 34369 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 71 Harper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | 12 | 12x4. 5 | Permit Number 38124 | 6003708.03789498 | 2097975.15575924 | 37.740850154442896 | -122.42975927113899 | (37.7408501544429, -122.429759271139) |
107822 | 107822 | 34377 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 192 Laidley St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/13/1997 12:00:00 AM | Permit Number 38132 | 6004119.49989193 | 2097245.26729923 | 37.7388693385577 | -122.428284582088 | (37.7388693385577, -122.428284582088) | ||
88467 | 88467 | 34382 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 520 Laidley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/1997 12:00:00 AM | 3x3 | Permit Number 38132 | 6003249.18885376 | 2096183.56473871 | 37.735904862626 | -122.431217948328 | (37.735904862626, -122.431217948328) | ||
124695 | 124695 | 34392 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 224 Miguel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | 3x3 | Permit Number 38139 | 6004139.10762167 | 2096768.34817433 | 37.7375609365762 | -122.428182808375 | (37.7375609365762, -122.428182808375) | |
138440 | 138440 | 34393 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 116 Moffitt St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 38140 | 6002651.93696473 | 2096854.08476893 | 37.7377120923069 | -122.433330781491 | (37.7377120923069, -122.433330781491) | ||
85926 | 85926 | 34394 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 124 Moffitt St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | 3 | Permit Number 38141 | 6002617.96680614 | 2096893.03282917 | 37.737817107463606 | -122.433451015032 | (37.7378171074636, -122.433451015032) | |
145743 | 145743 | 34397 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 140 Moffitt St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 38144 | 6002549.58677603 | 2096969.20024046 | 37.7380223658164 | -122.433692879918 | (37.7380223658164, -122.433692879918) | ||
143594 | 143594 | 34405 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 197 Moffitt St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 38153 | 6002304.0011487 | 2097200.08701306 | 37.7386423893301 | -122.434558494281 | (37.7386423893301, -122.434558494281) | ||
105631 | 105631 | 34419 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 100 Roanoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 38167 | 6003358.09011166 | 2096226.49076231 | 37.7360288984966 | -122.43084449611601 | (37.7360288984966, -122.430844496116) |
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");