Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location ▲ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 92324 | 92324 | 96987 | Permitted Site 1 | Prunus spp :: Cherry 84 | 2201 North Point St | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 08/16/2011 12:00:00 AM | Permit Number 768194 | 6000179.9 | 2120547.2 | 37.8026268776405 | -122.44357930017799 | (37.8026268776405, -122.443579300178) | ||||
| 76569 | 76569 | 136021 | Undocumented 2 | Prunus spp :: Cherry 84 | 1010 Lombard St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | 6007482.49892 | 2120248.47345 | 37.802220422406705 | -122.418287380977 | (37.8022204224067, -122.418287380977) | ||||
| 2581 | 2581 | 107490 | DPW Maintained 3 | Prunus spp :: Cherry 84 | 1306x Montgomery St | 19 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6011447.18476 | 2119974.7633599997 | 37.8016912541172 | -122.404548295963 | (37.8016912541172, -122.404548295963) | ||||
| 85877 | 85877 | 103517 | Permitted Site 1 | Prunus spp :: Cherry 84 | 55X MacOndray Ln | 1 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | Permit Number 770452 | 6008432.0 | 2119159.0 | 37.7992824016355 | -122.41492448290899 | (37.7992824016355, -122.414924482909) | ||||
| 152816 | 152816 | 136023 | Undocumented 2 | Prunus spp :: Cherry 84 | 60 MacOndray Ln | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6008389.23117 | 2119145.89275 | 37.7992440090735 | -122.415071550105 | (37.7992440090735, -122.415071550105) | ||||
| 165975 | 165975 | 136022 | Undocumented 2 | Prunus spp :: Cherry 84 | 60 MacOndray Ln | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 6008402.81482 | 2119144.69077 | 37.7992414720639 | -122.415024460715 | (37.7992414720639, -122.415024460715) | ||||
| 184295 | 184295 | 136024 | Undocumented 2 | Prunus spp :: Cherry 84 | 66 MacOndray Ln | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6008379.74874 | 2119143.46885 | 37.7992368207748 | -122.415104191024 | (37.7992368207748, -122.415104191024) | ||||
| 158246 | 158246 | 136025 | Undocumented 2 | Prunus spp :: Cherry 84 | 80 MacOndray Ln | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 6008316.37067 | 2119137.06676 | 37.79921568041429 | -122.415323048225 | (37.7992156804143, -122.415323048225) | ||||
| 36648 | 36648 | 136020 | Undocumented 2 | Prunus spp :: Cherry 84 | 1477 Green St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6006004.56438 | 2118595.56069 | 37.7975986409201 | -122.423284189634 | (37.7975986409201, -122.423284189634) | |||
| 40011 | 40011 | 88560 | Permitted Site 1 | Prunus spp :: Cherry 84 | 2901 Pierce St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2008 12:00:00 AM | 3x3 | Permit Number 51505 | 6001501.0 | 2118350.0 | 37.7966692015857 | -122.43885009322901 | (37.7966692015857, -122.438850093229) | |||
| 143271 | 143271 | 88559 | Permitted Site 1 | Prunus spp :: Cherry 84 | 2901 Pierce St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2008 12:00:00 AM | 3x3 | Permit Number 51505 | 6001501.0 | 2118350.0 | 37.7966692015857 | -122.43885009322901 | (37.7966692015857, -122.438850093229) | |||
| 104294 | 104294 | 43986 | Permitted Site 1 | Prunus spp :: Cherry 84 | 2200 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/2000 12:00:00 AM | Permit Number 43550 | 6005547.87197183 | 2117529.65351428 | 37.7946461451301 | -122.42478860010799 | (37.7946461451301, -122.424788600108) | |||
| 78765 | 78765 | 122579 | Undocumented 2 | Prunus spp :: Cherry 84 | 2500X Lyon St | 1 | Median : Cutout 11 | Tree 1 | Private 1 | 30 | 10x20 | 5999276.0 | 2117538.0 | 37.794312827392396 | -122.446490617691 | (37.7943128273924, -122.446490617691) | |||
| 143403 | 143403 | 122586 | Undocumented 2 | Prunus spp :: Cherry 84 | 2500X Lyon St | 6 | Median : Cutout 11 | Tree 1 | Private 1 | 12 | 10x20 | 5999276.0 | 2117538.0 | 37.794312827392396 | -122.446490617691 | (37.7943128273924, -122.446490617691) | |||
| 98763 | 98763 | 249657 | Undocumented 2 | Prunus spp :: Cherry 84 | 2401 Lyon St | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | Width 10ft | 5999220.856459999 | 2117228.0712599996 | 37.7934586955217 | -122.44665911012301 | (37.7934586955217, -122.446659110123) | |||
| 181728 | 181728 | 136027 | Undocumented 2 | Prunus spp :: Cherry 84 | 957 Sacramento St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6010215.88282 | 2116843.14587 | 37.7930237069305 | -122.408588145932 | (37.7930237069305, -122.408588145932) | |||
| 148635 | 148635 | 136026 | Undocumented 2 | Prunus spp :: Cherry 84 | 957 Sacramento St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 3ft | 6010195.26054 | 2116841.12509 | 37.793017003381706 | -122.408659357866 | (37.7930170033817, -122.408659357866) | |||
| 19474 | 19474 | 51214 | Permitted Site 1 | Prunus spp :: Cherry 84 | 111 Mission St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/11/2004 12:00:00 AM | Permit Number 47578 | 6014394.74626942 | 2116530.73461445 | 37.7923990500381 | -122.39410705418699 | (37.7923990500381, -122.394107054187) | |||
| 94724 | 94724 | 84725 | Permitted Site 1 | Prunus spp :: Cherry 84 | 20 Cherry St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2007 12:00:00 AM | Permit No. 49296 | 5996092.0 | 2115960.0 | 37.7897976912986 | -122.457393340224 | (37.7897976912986, -122.457393340224) | |||
| 96787 | 96787 | 19030 | DPW Maintained 3 | Prunus spp :: Cherry 84 | 3176 SACRAMENTO ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | 2x2 | 5999568.0 | 2115477.0 | 37.78867053817721 | -122.44533201 | (37.7886705381772, -122.44533201) | |||
| 98177 | 98177 | 19029 | DPW Maintained 3 | Prunus spp :: Cherry 84 | 3176 SACRAMENTO ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 2x2 | 5999568.0 | 2115477.0 | 37.78867053817721 | -122.44533201 | (37.7886705381772, -122.44533201) | |||
| 144726 | 144726 | 19028 | DPW Maintained 3 | Prunus spp :: Cherry 84 | 3176 SACRAMENTO ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | 2x2 | 5999568.0 | 2115477.0 | 37.78867053817721 | -122.44533201 | (37.7886705381772, -122.44533201) | |||
| 112476 | 112476 | 19031 | Permitted Site 1 | Prunus spp :: Cherry 84 | 3190 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 2X2 | 5999568.0947900005 | 2115476.97835 | 37.7886704841429 | -122.445331680485 | (37.7886704841429, -122.445331680485) | |||
| 113713 | 113713 | 19022 | Permitted Site 1 | Prunus spp :: Cherry 84 | 3170 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2X2 | 5999571.77228 | 2115429.18678 | 37.7885394709311 | -122.445315519372 | (37.7885394709311, -122.445315519372) | |||
| 123844 | 123844 | 19023 | DPW Maintained 3 | Prunus spp :: Cherry 84 | 3170 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | 2X2 | 5999571.77228 | 2115429.18678 | 37.7885394709311 | -122.445315519372 | (37.7885394709311, -122.445315519372) | |||
| 145402 | 145402 | 19024 | DPW Maintained 3 | Prunus spp :: Cherry 84 | 3170 Sacramento St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X2 | 5999571.77228 | 2115429.18678 | 37.7885394709311 | -122.445315519372 | (37.7885394709311, -122.445315519372) | |||
| 188094 | 188094 | 72435 | Undocumented 2 | Prunus spp :: Cherry 84 | 339 Presidio Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/1996 12:00:00 AM | 13 | 5999048.262080001 | 2115432.1499099997 | 37.7885177095774 | -122.447126990534 | (37.7885177095774, -122.447126990534) | ||
| 90536 | 90536 | 19034 | Permitted Site 1 | Prunus spp :: Cherry 84 | 3192 Sacramento St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12 | 2X2 | 5999529.89099 | 2115397.3219999997 | 37.7884495878023 | -122.445458129536 | (37.7884495878023, -122.445458129536) | |||
| 144369 | 144369 | 19033 | Permitted Site 1 | Prunus spp :: Cherry 84 | 3192 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2X2 | 5999542.700669999 | 2115392.3027 | 37.7884365373764 | -122.44541344917101 | (37.7884365373764, -122.445413449171) | |||
| 51063 | 51063 | 120699 | Undocumented 2 | Prunus spp :: Cherry 84 | 82 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 5988985.45615 | 2114833.30825 | 37.786293373056104 | -122.48189845318501 | (37.7862933730561, -122.481898453185) | |||
| 107994 | 107994 | 39201 | Permitted Site 1 | Prunus spp :: Cherry 84 | 36 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/23/1998 12:00:00 AM | 3x3 | Permit Number 40852 | 5996541.64157093 | 2114326.11365116 | 37.7853372927938 | -122.455719478601 | (37.7853372927938, -122.455719478601) | ||
| 50088 | 50088 | 1497 | DPW Maintained 3 | Prunus spp :: Cherry 84 | 325 Arguello Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 3x3 | 5995534.5488977 | 2114067.6155393003 | 37.7845696798314 | -122.45918496626999 | (37.7845696798314, -122.45918496627) | |||
| 119284 | 119284 | 116071 | DPW Maintained 3 | Prunus spp :: Cherry 84 | 4150X CLEMENT ST | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 8 | 3x3 | 5983115.0 | 2113126.0 | 37.7812624555251 | -122.502082001527 | (37.7812624555251, -122.502082001527) | |||
| 158870 | 158870 | 141006 | Undocumented 2 | Prunus spp :: Cherry 84 | 269 COLLINS ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5998171.183999999 | 2112777.5693 | 37.7811787774786 | -122.449970134459 | (37.7811787774786, -122.449970134459) | |||
| 131317 | 131317 | 117739 | Undocumented 2 | Prunus spp :: Cherry 84 | 475 39th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5983746.16527 | 2112679.78018 | 37.7800743257794 | -122.49986552243 | (37.7800743257794, -122.49986552243) | |||
| 116225 | 116225 | 49367 | Permitted Site 1 | Prunus spp :: Cherry 84 | 1328@ 4th & 5t Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2005 12:00:00 AM | Permit Number 47977 | 5994585.78557071 | 2112147.74022661 | 37.7792436288989 | -122.46232804837099 | (37.7792436288989, -122.462328048371) | |||
| 98329 | 98329 | 40636 | Permitted Site 1 | Prunus spp :: Cherry 84 | 142 Russ St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/10/1999 12:00:00 AM | Permit Number 41636 | 6010372.94752615 | 2111469.26002805 | 37.7782770896065 | -122.40766561205099 | (37.7782770896065, -122.407665612051) | |||
| 78119 | 78119 | 105781 | Permitted Site 1 | Prunus spp :: Cherry 84 | 1631 MCALLISTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/03/2014 12:00:00 AM | Permit Number 772613 | 6001347.6 | 2111440.1 | 37.7776876665107 | -122.43888545994 | (37.7776876665107, -122.43888545994) | |||
| 17606 | 17606 | 6944 | DPW Maintained 3 | Prunus spp :: Cherry 84 | 561 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/09/2006 12:00:00 AM | 3 | 3X3 | 6004740.44786 | 2110511.39404 | 37.7753301167361 | -122.42708227125601 | (37.7753301167361, -122.427082271256) | ||
| 154486 | 154486 | 142312 | Undocumented 2 | Prunus spp :: Cherry 84 | 1691 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5999733.1826 | 2110513.1611 | 37.775050545633796 | -122.444403629404 | (37.7750505456338, -122.444403629404) | |||
| 457 | 457 | 142162 | Undocumented 2 | Prunus spp :: Cherry 84 | 490X Baker St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000657.0 | 2110488.0 | 37.7750341257837 | -122.44120614609 | (37.7750341257837, -122.44120614609) | |||
| 91181 | 91181 | 51065 | Permitted Site 1 | Prunus spp :: Cherry 84 | 10 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/2004 12:00:00 AM | Permit Number 47529 | 6006972.51081745 | 2110293.55168859 | 37.7748579396097 | -122.419345575047 | (37.7748579396097, -122.419345575047) | |||
| 105516 | 105516 | 51062 | Permitted Site 1 | Prunus spp :: Cherry 84 | 10 South Van Ness Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/2004 12:00:00 AM | Permit Number 47529 | 6006972.51081745 | 2110293.55168859 | 37.7748579396097 | -122.419345575047 | (37.7748579396097, -122.419345575047) | |||
| 111577 | 111577 | 51061 | Permitted Site 1 | Prunus spp :: Cherry 84 | 10 South Van Ness Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/2004 12:00:00 AM | Permit Number 47529 | 6006972.51081745 | 2110293.55168859 | 37.7748579396097 | -122.419345575047 | (37.7748579396097, -122.419345575047) | |||
| 115880 | 115880 | 51064 | Permitted Site 1 | Prunus spp :: Cherry 84 | 10 South Van Ness Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/2004 12:00:00 AM | Permit Number 47529 | 6006972.51081745 | 2110293.55168859 | 37.7748579396097 | -122.419345575047 | (37.7748579396097, -122.419345575047) | |||
| 141391 | 141391 | 51063 | Permitted Site 1 | Prunus spp :: Cherry 84 | 10 South Van Ness Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/2004 12:00:00 AM | Permit Number 47529 | 6006972.51081745 | 2110293.55168859 | 37.7748579396097 | -122.419345575047 | (37.7748579396097, -122.419345575047) | |||
| 141745 | 141745 | 51060 | Permitted Site 1 | Prunus spp :: Cherry 84 | 10 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/2004 12:00:00 AM | Permit Number 47529 | 6006972.51081745 | 2110293.55168859 | 37.7748579396097 | -122.419345575047 | (37.7748579396097, -122.419345575047) | |||
| 189034 | 189034 | 122230 | Undocumented 2 | Prunus spp :: Cherry 84 | 700 14th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5991662.29598 | 2110580.8797299997 | 37.774772683199394 | -122.472327258665 | (37.7747726831994, -122.472327258665) | |||
| 100159 | 100159 | 52194 | Permitted Site 1 | Prunus spp :: Cherry 84 | 415 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2005 12:00:00 AM | 3x3 | Permit Number 48384 | 6004604.76721884 | 2109944.08482631 | 37.7737647507648 | -122.42751119704201 | (37.7737647507648, -122.427511197042) | ||
| 125784 | 125784 | 42766 | Permitted Site 1 | Prunus spp :: Cherry 84 | 415 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/03/2005 12:00:00 AM | 3x3 | Permit Number 48384 | 6004604.76721884 | 2109944.08482631 | 37.7737647507648 | -122.42751119704201 | (37.7737647507648, -122.427511197042) | |
| 97214 | 97214 | 17372 | Permitted Site 1 | Prunus spp :: Cherry 84 | 1050X Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/24/2012 12:00:00 AM | 6 | 3X3 | Permit Number 769300 | 5999379.151930001 | 2109268.47217 | 37.771612740675394 | -122.44553877169399 | (37.7716127406754, -122.445538771694) | |
| 170723 | 170723 | 196513 | Undocumented 2 | Prunus spp :: Cherry 84 | 625 King St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 4ft | 6011917.55402 | 2108434.4901900003 | 37.770030649334295 | -122.402108807587 | (37.7700306493343, -122.402108807587) | |||
| 25681 | 25681 | 196512 | Undocumented 2 | Prunus spp :: Cherry 84 | 625 King St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 4ft | 6011914.18479 | 2108425.06588 | 37.770004584260704 | -122.402119799109 | (37.7700045842607, -122.402119799109) | |||
| 75325 | 75325 | 196511 | Undocumented 2 | Prunus spp :: Cherry 84 | 625 King St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 4ft | 6011918.6881 | 2108412.1194599997 | 37.7699692876805 | -122.402103311835 | (37.7699692876805, -122.402103311835) | |||
| 94149 | 94149 | 58408 | Permitted Site 1 | Prunus spp :: Cherry 84 | 755 Buena Vista Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/19/1979 12:00:00 AM | 5 | Permit Number 17543 | 5999798.5 | 2108081.7 | 37.7683780948237 | -122.44400294123699 | (37.7683780948237, -122.444002941237) | ||
| 117786 | 117786 | 109243 | Permitted Site 1 | Prunus spp :: Cherry 84 | 755 Buena Vista Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 5999798.5 | 2108081.7 | 37.7683780948237 | -122.44400294123699 | (37.7683780948237, -122.444002941237) | ||||
| 27679 | 27679 | 234916 | Undocumented 2 | Prunus spp :: Cherry 84 | 1 Albion St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6005792.88209 | 2107221.84485 | 37.766357260514 | -122.423207770616 | (37.766357260514, -122.423207770616) | |||
| 116443 | 116443 | 213700 | Undocumented 2 | Prunus spp :: Cherry 84 | 1316 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5993037.4807 | 2106453.44522 | 37.76351933917171 | -122.46727007765499 | (37.7635193391717, -122.467270077655) | |||
| 42127 | 42127 | 234920 | Undocumented 2 | Prunus spp :: Cherry 84 | 501 York St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 6ft | 6009827.75137 | 2105874.2614 | 37.7628839834388 | -122.409156748587 | (37.7628839834388, -122.409156748587) | |||
| 137899 | 137899 | 84640 | Permitted Site 1 | Prunus spp :: Cherry 84 | 1363 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52752 | 5988634.2057 | 2106032.7782 | 37.7621091296561 | -122.482468596885 | (37.7621091296561, -122.482468596885) |
| 93929 | 93929 | 49741 | Permitted Site 1 | Prunus spp :: Cherry 84 | 646@ 18th Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/2003 12:00:00 AM | Permit Number 46540 | 6010086.91434322 | 2105281.03537103 | 37.761269634638296 | -122.408218548113 | (37.7612696346383, -122.408218548113) | |||
| 183588 | 183588 | 196335 | Undocumented 2 | Prunus spp :: Cherry 84 | 1900 19th St | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6012008.47004 | 2105145.92381 | 37.761006057794 | -122.401563163706 | (37.761006057794, -122.401563163706) | ||||
| 155630 | 155630 | 196373 | Undocumented 2 | Prunus spp :: Cherry 84 | 1900 19th St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6012066.64129 | 2105141.25616 | 37.760996487210996 | -122.40136164543101 | (37.760996487211, -122.401361645431) | ||||
| 61578 | 61578 | 238534 | Undocumented 2 | Prunus spp :: Cherry 84 | 671 Church St | 39 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | Width 3ft | 6004315.939809999 | 2105094.00544 | 37.7604312615151 | -122.428164581928 | (37.7604312615151, -122.428164581928) | |||
| 152021 | 152021 | 196535 | Undocumented 2 | Prunus spp :: Cherry 84 | 2050 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6011971.89654 | 2104695.5973799997 | 37.759767520477205 | -122.401658003519 | (37.7597675204772, -122.401658003519) | |||
| 140252 | 140252 | 93987 | Permitted Site 1 | Prunus spp :: Cherry 84 | 200 Belgrave Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | Permit Number 53411 | 5997460.5 | 2104904.0 | 37.759519290122 | -122.45186055280199 | (37.759519290122, -122.451860552802) | |||
| 88192 | 88192 | 50440 | Permitted Site 1 | Prunus spp :: Cherry 84 | 1539 Funston Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/09/2003 12:00:00 AM | Permit Number 47091 | 5992108.98793904 | 2104967.81344644 | 37.7593865436509 | -122.47037320978998 | (37.7593865436509, -122.47037320979) | |||
| 138887 | 138887 | 50441 | Permitted Site 1 | Prunus spp :: Cherry 84 | 1539 Funston Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/09/2003 12:00:00 AM | Permit Number 47091 | 5992108.98793904 | 2104967.81344644 | 37.7593865436509 | -122.47037320978998 | (37.7593865436509, -122.47037320979) | |||
| 141592 | 141592 | 50443 | Permitted Site 1 | Prunus spp :: Cherry 84 | 1539 Funston Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/09/2003 12:00:00 AM | Permit Number 47091 | 5992108.98793904 | 2104967.81344644 | 37.7593865436509 | -122.47037320978998 | (37.7593865436509, -122.47037320979) | |||
| 145839 | 145839 | 50442 | Permitted Site 1 | Prunus spp :: Cherry 84 | 1539 Funston Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/09/2003 12:00:00 AM | Permit Number 47091 | 5992108.98793904 | 2104967.81344644 | 37.7593865436509 | -122.47037320978998 | (37.7593865436509, -122.47037320979) | |||
| 43070 | 43070 | 234922 | Undocumented 2 | Prunus spp :: Cherry 84 | 818 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6010155.119 | 2104325.0374 | 37.758648498551004 | -122.40791523902399 | (37.758648498551, -122.407915239024) | |||
| 38547 | 38547 | 196063 | Undocumented 2 | Prunus spp :: Cherry 84 | 1751 22nd St | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | Width 5ft | 6012868.1198 | 2103766.18767 | 37.757265535503 | -122.39849317144501 | (37.757265535503, -122.398493171445) | |||
| 177483 | 177483 | 196062 | Undocumented 2 | Prunus spp :: Cherry 84 | 1751 22nd St | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | Width 5ft | 6012859.76673 | 2103766.08005 | 37.757264774654395 | -122.398522052264 | (37.7572647746544, -122.398522052264) | |||
| 100275 | 100275 | 96676 | Property Tree 7 | Prunus spp :: Cherry 84 | 1701 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2011 12:00:00 AM | 5989644.3 | 2103769.9 | 37.7559545815884 | -122.478809598698 | (37.7559545815884, -122.478809598698) | ||||
| 115861 | 115861 | 96677 | Permitted Site 1 | Prunus spp :: Cherry 84 | 1701 21st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 767971 | 5989644.3 | 2103769.9 | 37.7559545815884 | -122.478809598698 | (37.7559545815884, -122.478809598698) | ||||
| 68550 | 68550 | 234921 | Undocumented 2 | Prunus spp :: Cherry 84 | 1062 Valencia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006317.5902 | 2103335.47216 | 37.7557157877704 | -122.421116917936 | (37.7557157877704, -122.421116917936) | |||
| 77820 | 77820 | 16688 | DPW Maintained 3 | Prunus spp :: Cherry 84 | 600X Noriega St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 2 | 5992180.8132004 | 2103552.59538 | 37.7555048781502 | -122.47002175838301 | (37.7555048781502, -122.470021758383) | |||
| 104487 | 104487 | 53181 | Permitted Site 1 | Prunus spp :: Cherry 84 | 2784 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/07/2006 12:00:00 AM | 3x3 | Permit Number 49099 | 6010077.71172244 | 2102830.43618978 | 37.7545403242811 | -122.408077545352 | (37.7545403242811, -122.408077545352) | |
| 82823 | 82823 | 104765 | Undocumented 2 | Prunus spp :: Cherry 84 | 47 VICKSBURG ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 4x4 | 6004132.1 | 2102787.4 | 37.754087465401604 | -122.428635972714 | (37.7540874654016, -122.428635972714) | |||
| 140754 | 140754 | 53304 | Permitted Site 1 | Prunus spp :: Cherry 84 | 47 Vicksburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/21/1969 12:00:00 AM | 2 | 4x4 | Permit Number 6194 | 6004117.25840717 | 2102785.08371789 | 37.7540802654829 | -122.42868713344 | (37.7540802654829, -122.42868713344) | |
| 157664 | 157664 | 237950 | Undocumented 2 | Prunus spp :: Cherry 84 | 3145 23rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008062.3853 | 2102670.45818 | 37.75398801563821 | -122.415035774193 | (37.7539880156382, -122.415035774193) | |||
| 70326 | 70326 | 237949 | Undocumented 2 | Prunus spp :: Cherry 84 | 3145 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6008037.75868 | 2102668.77987 | 37.753982023462704 | -122.41512082037599 | (37.7539820234627, -122.415120820376) | |||
| 136216 | 136216 | 237947 | Undocumented 2 | Prunus spp :: Cherry 84 | 923 Shotwell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6008000.7668699995 | 2102633.77568 | 37.7538838309939 | -122.415246269499 | (37.7538838309939, -122.415246269499) | |||
| 53397 | 53397 | 237946 | Undocumented 2 | Prunus spp :: Cherry 84 | 923 Shotwell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6008002.82503 | 2102600.12508 | 37.7537915497511 | -122.41523676997299 | (37.7537915497511, -122.415236769973) | |||
| 137017 | 137017 | 212859 | Undocumented 2 | Prunus spp :: Cherry 84 | 1850 17th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 5990965.567480001 | 2102825.03354 | 37.753436858936205 | -122.474171325764 | (37.7534368589362, -122.474171325764) | |||
| 66954 | 66954 | 234918 | Undocumented 2 | Prunus spp :: Cherry 84 | 1319 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6011166.831619999 | 2102201.8831 | 37.75287537621829 | -122.404266824377 | (37.7528753762183, -122.404266824377) | |||
| 139765 | 139765 | 121317 | DPW Maintained 3 | Prunus spp :: Cherry 84 | 1270 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 3x3 | 6007670.0 | 2102262.0 | 37.7528444245459 | -122.41636381055099 | (37.7528444245459, -122.416363810551) | |||
| 111598 | 111598 | 102286 | Undocumented 2 | Prunus spp :: Cherry 84 | 122 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/2014 12:00:00 AM | 26 | 4x4 | Permit Number 772865 | 6000574.8 | 2102350.7 | 37.7526864299915 | -122.44090662134501 | (37.7526864299915, -122.440906621345) | |
| 37252 | 37252 | 234917 | Undocumented 2 | Prunus spp :: Cherry 84 | 1341 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6011175.62775 | 2102086.9904099996 | 37.7525603976539 | -122.40422831989599 | (37.7525603976539, -122.404228319896) | |||
| 95257 | 95257 | 93959 | Permitted Site 1 | Prunus spp :: Cherry 84 | 419 Elizabeth St | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | Permit Number 53399 | 6003681.0 | 2102149.0 | 37.752309029626495 | -122.430150445418 | (37.7523090296265, -122.430150445418) | ||||
| 102022 | 102022 | 20856 | DPW Maintained 3 | Prunus spp :: Cherry 84 | 1892X Sunset Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5984852.8466778 | 2102317.5089788004 | 37.7516873322231 | -122.49527267334 | (37.7516873322231, -122.49527267334) | |||
| 119551 | 119551 | 20857 | DPW Maintained 3 | Prunus spp :: Cherry 84 | 1892X Sunset Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5984852.8466778 | 2102317.5089788004 | 37.7516873322231 | -122.49527267334 | (37.7516873322231, -122.49527267334) | |||
| 144988 | 144988 | 20855 | DPW Maintained 3 | Prunus spp :: Cherry 84 | 1892X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5984852.8466778 | 2102317.5089788004 | 37.7516873322231 | -122.49527267334 | (37.7516873322231, -122.49527267334) | |||
| 55882 | 55882 | 196536 | Undocumented 2 | Prunus spp :: Cherry 84 | 1422 Rhode Island St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6011983.19537 | 2101729.68858 | 37.751624416549795 | -122.40141048760401 | (37.7516244165498, -122.401410487604) | |||
| 106210 | 106210 | 56999 | Permitted Site 1 | Prunus spp :: Cherry 84 | 4206 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/27/1974 12:00:00 AM | Permit Number 14257 | 6001838.61131344 | 2101787.92307498 | 37.7512130767933 | -122.43649586805401 | (37.7512130767933, -122.436495868054) | |||
| 187643 | 187643 | 238533 | Undocumented 2 | Prunus spp :: Cherry 84 | 2929 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009029.88036 | 2101415.6654 | 37.7505969563892 | -122.411601283067 | (37.7505969563892, -122.411601283067) | |||
| 36913 | 36913 | 237948 | Undocumented 2 | Prunus spp :: Cherry 84 | 3387 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6007155.62665 | 2101453.9635099997 | 37.7505968017181 | -122.418085332981 | (37.7505968017181, -122.418085332981) | |||
| 25209 | 25209 | 196534 | Undocumented 2 | Prunus spp :: Cherry 84 | 2221 26th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6011830.1521 | 2101342.3848900003 | 37.750552424667504 | -122.401912510764 | (37.7505524246675, -122.401912510764) | |||
| 90214 | 90214 | 50019 | Permitted Site 1 | Prunus spp :: Cherry 84 | 1363 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46753 | 6009308.17778689 | 2101227.80950502 | 37.750096752782504 | -122.410625639874 | (37.7500967527825, -122.410625639874) | ||
| 81568 | 81568 | 40117 | Permitted Site 1 | Prunus spp :: Cherry 84 | 51 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/29/2001 12:00:00 AM | Permit Number 41332 | 6004835.9770779 | 2101026.68937802 | 37.7492927732201 | -122.42607645855 | (37.7492927732201, -122.42607645855) |
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");