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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 175070 | 175070 | 236648 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1015 Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6005760.11711 | 2102955.81061 | 37.7546418830364 | -122.42301785630899 | (37.7546418830364, -122.423017856309) | |||
| 172165 | 172165 | 135823 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1015 Vallejo St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6008630.162959999 | 2118635.32656 | 37.7978556572789 | -122.414201697946 | (37.7978556572789, -122.414201697946) | ||||
| 146808 | 146808 | 236595 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1017 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008042.7939 | 2101868.50506 | 37.7517849329275 | -122.415046766617 | (37.7517849329275, -122.415046766617) | |||
| 93154 | 93154 | 49881 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1018 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/30/2003 12:00:00 AM | Permit Number 46647 | 5998856.6109844 | 2106476.48364513 | 37.763916800747204 | -122.447145297349 | (37.7639168007472, -122.447145297349) | ||
| 166256 | 166256 | 213085 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 102 Castenada Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5994444.11048 | 2101305.31055 | 37.7494649833313 | -122.462031675131 | (37.7494649833313, -122.462031675131) | |||
| 19389 | 19389 | 9994 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 102 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X2 | 6005389.27087 | 2108406.08421 | 37.7695861126487 | -122.424688040346 | (37.7695861126487, -122.424688040346) | |||
| 21918 | 21918 | 26668 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 102 Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 2X2 | 6005390.51366 | 2108390.09444 | 37.769542278768505 | -122.42468260394199 | (37.7695422787685, -122.424682603942) | |||
| 94480 | 94480 | 68763 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 102 Hancock St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/16/1993 12:00:00 AM | Permit Number 32686 | 6003608.24557851 | 2105105.19353469 | 37.760421914692 | -122.430612966732 | (37.760421914692, -122.430612966732) | ||
| 145686 | 145686 | 35966 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 102 Leese St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/1998 12:00:00 AM | Permit Number 39124 | 6005564.29083619 | 2096119.54100756 | 37.7358599920196 | -122.42320916287301 | (37.7358599920196, -122.423209162873) | ||
| 147540 | 147540 | 236352 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 102 Leese St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6005582.22784 | 2096096.1377700001 | 37.7357967442089 | -122.423145484495 | (37.7357967442089, -122.423145484495) | |||
| 34028 | 34028 | 213114 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 102 Omar Way | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5998118.31509 | 2097542.20212 | 37.7393432548731 | -122.449055178356 | (37.7393432548731, -122.449055178356) | |||
| 49846 | 49846 | 213113 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 102 Omar Way | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5998111.37586 | 2097542.73119 | 37.7393443106943 | -122.44907920913299 | (37.7393443106943, -122.449079209133) | |||
| 182842 | 182842 | 213112 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 102 Omar Way | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5998102.48269 | 2097542.14739 | 37.73934219908271 | -122.449109915589 | (37.7393421990827, -122.449109915589) | |||
| 162369 | 162369 | 135776 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 102 Willow St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6006971.508780001 | 2113460.79408 | 37.7835543655835 | -122.41957380089701 | (37.7835543655835, -122.419573800897) | |||
| 164227 | 164227 | 135775 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 102 Willow St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6006991.5777 | 2113463.70323 | 37.7835634838136 | -122.41950457648501 | (37.7835634838136, -122.419504576485) | |||
| 17636 | 17636 | 10167 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1021 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X2 | 6005764.985230001 | 2102811.5808900003 | 37.7542461363638 | -122.422990770503 | (37.7542461363638, -122.422990770503) | |||
| 76842 | 76842 | 196134 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1028 Wisconsin St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6012770.44441 | 2102683.83354 | 37.7542881850521 | -122.398755016246 | (37.7542881850521, -122.398755016246) | |||
| 69348 | 69348 | 236444 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1030 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5998870.99588 | 2106321.31552 | 37.7634915698929 | -122.44708437704399 | (37.7634915698929, -122.447084377044) | |||
| 92764 | 92764 | 43648 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1030 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | Permit Number 43295 | 5998862.78386083 | 2106432.26100273 | 37.7637957291639 | -122.447120764539 | (37.7637957291639, -122.447120764539) | ||
| 115824 | 115824 | 65254 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1031 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1989 12:00:00 AM | 4x6 | Permit Number 28053. Expanded basin to 4x6 | 6009460.81528619 | 2103170.09802024 | 37.755438399754894 | -122.41023492456199 | (37.7554383997549, -122.410234924562) | |
| 156336 | 156336 | 236588 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1031 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6009455.67216 | 2103157.72718 | 37.755404143913104 | -122.41025183774599 | (37.7554041439131, -122.410251837746) | |||
| 127295 | 127295 | 60577 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1036 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/05/1983 12:00:00 AM | Permit Number 20361 | 6009410.76277257 | 2103133.61421034 | 37.7553354176475 | -122.41040544615801 | (37.7553354176475, -122.410405446158) | ||
| 45955 | 45955 | 235932 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1036 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6010217.9954 | 2103185.93874 | 37.755524308619 | -122.407617468978 | (37.755524308619, -122.407617468978) | |||
| 79621 | 79621 | 43653 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1038 Clayton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | Permit Number 43296 | 5998866.89911478 | 2106402.77921975 | 37.7637150147123 | -122.44710440936501 | (37.7637150147123, -122.447104409365) | ||
| 98301 | 98301 | 43650 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1038 Clayton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | Permit Number 43296 | 5998866.89911478 | 2106402.77921975 | 37.7637150147123 | -122.44710440936501 | (37.7637150147123, -122.447104409365) | ||
| 112360 | 112360 | 43651 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1038 Clayton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | Permit Number 43296 | 5998866.89911478 | 2106402.77921975 | 37.7637150147123 | -122.44710440936501 | (37.7637150147123, -122.447104409365) | ||
| 119377 | 119377 | 43649 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1038 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | Permit Number 43296 | 5998866.89911478 | 2106402.77921975 | 37.7637150147123 | -122.44710440936501 | (37.7637150147123, -122.447104409365) | ||
| 132406 | 132406 | 124015 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 104 Funston Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5991819.02656 | 2114698.83579 | 37.7860885309356 | -122.472085318982 | (37.7860885309356, -122.472085318982) | |||
| 164074 | 164074 | 68694 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 104 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1993 12:00:00 AM | 7 | Permit Number 32606 | 5991821.21978 | 2114667.98437 | 37.7860039484018 | -122.47207548155399 | (37.7860039484018, -122.472075481554) | |
| 166198 | 166198 | 124014 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 104 Funston Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5991818.088169999 | 2114740.92009 | 37.786204028457604 | -122.47209163415 | (37.7862040284576, -122.47209163415) | |||
| 28645 | 28645 | 235960 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 104 Peralta Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6010190.58282 | 2100226.3292799997 | 37.747396341176 | -122.40750362019699 | (37.747396341176, -122.407503620197) | |||
| 65052 | 65052 | 235961 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 104 Peralta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6010201.05198 | 2100232.37101 | 37.7474135164352 | -122.40746784427401 | (37.7474135164352, -122.407467844274) | |||
| 109919 | 109919 | 37179 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 104 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/1998 12:00:00 AM | Permit Number 39752 | 6006192.48658967 | 2099515.53626406 | 37.7452200653601 | -122.42127831881001 | (37.7452200653601, -122.42127831881) | ||
| 126892 | 126892 | 69240 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1041 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/09/1994 12:00:00 AM | 6 | Permit Number 33302 | 6011659.83166 | 2103507.2832400003 | 37.756487254088704 | -122.40265372118799 | (37.7564872540887, -122.402653721188) | ||
| 27800 | 27800 | 245050 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1044 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6001532.5081 | 2109421.3340000003 | 37.7721551598934 | -122.438101153639 | (37.7721551598934, -122.438101153639) | |||
| 119044 | 119044 | 35155 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1044 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/02/1998 12:00:00 AM | Permit Number 38686 | 6001561.46281092 | 2109428.97187027 | 37.7721777782295 | -122.438001544264 | (37.7721777782295, -122.438001544264) | ||
| 156030 | 156030 | 41773 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1045 Mason St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | 5 | Permit Number 42187 | 6009460.67023 | 2116947.19217 | 37.7932670679698 | -122.411208586919 | (37.7932670679698, -122.411208586919) | |
| 182262 | 182262 | 41772 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1045 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | 7 | Permit Number 42187 | 6009458.388040001 | 2116963.23117 | 37.793310979166 | -122.411217616996 | (37.793310979166, -122.411217616996) | |
| 53209 | 53209 | 201245 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 105 Orsi Cir | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 2ft | 6012837.41647 | 2093205.33465 | 37.7282659571993 | -122.397858570225 | (37.7282659571993, -122.397858570225) | |||
| 174449 | 174449 | 201244 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 105 Orsi Cir | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 2ft | 6012833.80846 | 2093200.62135 | 37.728252814508295 | -122.397870712864 | (37.7282528145083, -122.397870712864) | |||
| 183824 | 183824 | 201243 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 105 Orsi Cir | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 2ft | 6012828.52235 | 2093195.2061299998 | 37.7282376510311 | -122.39788860758001 | (37.7282376510311, -122.39788860758) | |||
| 133715 | 133715 | 236971 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 105 Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006916.526769999 | 2098879.35603 | 37.7435140506415 | -122.418729597409 | (37.7435140506415, -122.418729597409) | |||
| 116537 | 116537 | 108944 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 105 Richland Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/15/2015 12:00:00 AM | 3 | 4x4 | Permit Number 772521 | 6005294.9 | 2096235.5 | 37.7361631827636 | -122.424148798432 | (37.7361631827636, -122.424148798432) | |
| 120119 | 120119 | 46366 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 105 Richland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/15/2015 12:00:00 AM | 3 | 4x4 | Permit Number 772521 | 6005231.58018962 | 2096222.89831587 | 37.7361250059804 | -122.42436682508301 | (37.7361250059804, -122.424366825083) | |
| 187669 | 187669 | 31093 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 105 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 8 | Permit Number 34826 | 6007741.23443 | 2107311.13584 | 37.7667121941381 | -122.416475089665 | (37.7667121941381, -122.416475089665) | |
| 22236 | 22236 | 4405 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1050 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/01/1993 12:00:00 AM | 12 | 3X3 | 6004381.0178 | 2102775.98302 | 37.7540702011025 | -122.42777434091299 | (37.7540702011025, -122.427774340913) | ||
| 85143 | 85143 | 115005 | Private 5 | Prunus cerasifera :: Cherry Plum 16 | 1050 MCALLISTER ST | 2 | Front Yard : Cutout 8 | Tree 1 | Office of Mayor 21 | DPW 4 | 3x3 | 6004148.0 | 2111858.0 | 37.778994045300706 | -122.42922772691401 | (37.7789940453007, -122.429227726914) | |||
| 40479 | 40479 | 245051 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1050 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6001509.2415 | 2109417.6778 | 37.7721437976514 | -122.43818137263 | (37.7721437976514, -122.43818137263) | |||
| 25176 | 25176 | 236560 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1050 South Van Ness Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007582.29585 | 2103543.58083 | 37.75635842082821 | -122.416757894081 | (37.7563584208282, -122.416757894081) | |||
| 35939 | 35939 | 236562 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1050 South Van Ness Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007584.89714 | 2103510.97173 | 37.7562690300153 | -122.41674658780701 | (37.7562690300153, -122.416746587807) | |||
| 37025 | 37025 | 236558 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1050 South Van Ness Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007580.51155 | 2103576.17352 | 37.7564478125326 | -122.416766373773 | (37.7564478125326, -122.416766373773) | |||
| 52464 | 52464 | 236563 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1050 South Van Ness Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007584.638830001 | 2103498.36122 | 37.756234389913004 | -122.41674658778601 | (37.756234389913, -122.416746587786) | |||
| 91957 | 91957 | 109597 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1050 South Van Ness Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6007567.1 | 2103584.6 | 37.756470195368294 | -122.416813352731 | (37.7564701953683, -122.416813352731) | |||||
| 106161 | 106161 | 39182 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1050 South Van Ness Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/1998 12:00:00 AM | Permit Number 40838 | 6007589.88726975 | 2103539.15878969 | 37.7563467058962 | -122.416731326975 | (37.7563467058962, -122.416731326975) | |||
| 112035 | 112035 | 39183 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1050 South Van Ness Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/1998 12:00:00 AM | Permit Number 40838 | 6007589.88726975 | 2103539.15878969 | 37.7563467058962 | -122.416731326975 | (37.7563467058962, -122.416731326975) | |||
| 118118 | 118118 | 236561 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1050 South Van Ness Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007585.02923 | 2103523.51342 | 37.75630347405421 | -122.416747019467 | (37.7563034740542, -122.416747019467) | |||
| 121481 | 121481 | 109598 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1050 South Van Ness Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6007567.1 | 2103584.6 | 37.756470195368294 | -122.416813352731 | (37.7564701953683, -122.416813352731) | |||||
| 139732 | 139732 | 39180 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1050 South Van Ness Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/1998 12:00:00 AM | Permit Number 40838 | 6007589.88726975 | 2103539.15878969 | 37.7563467058962 | -122.416731326975 | (37.7563467058962, -122.416731326975) | |||
| 142771 | 142771 | 39181 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1050 South Van Ness Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/1998 12:00:00 AM | Permit Number 40838 | 6007589.88726975 | 2103539.15878969 | 37.7563467058962 | -122.416731326975 | (37.7563467058962, -122.416731326975) | |||
| 172143 | 172143 | 236559 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1050 South Van Ness Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007581.82052 | 2103560.27559 | 37.7564042340812 | -122.416760720636 | (37.7564042340812, -122.416760720636) | |||
| 22170 | 22170 | 17373 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1050X Masonic Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3X3 | 5999390.9816 | 2109231.8772 | 37.771512935512796 | -122.44549522045601 | (37.7715129355128, -122.445495220456) | |||
| 54237 | 54237 | 245053 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1058 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6001496.9434 | 2109417.0130000003 | 37.7721412728311 | -122.43822386506099 | (37.7721412728311, -122.438223865061) | |||
| 71185 | 71185 | 64744 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1058 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/17/1988 12:00:00 AM | Permit Number 25706 | 6001496.66932698 | 2109419.88262313 | 37.7721491365124 | -122.43822501871 | (37.7721491365124, -122.43822501871) | ||
| 167403 | 167403 | 236589 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1059 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6009463.17078 | 2103000.9911599997 | 37.7549742023176 | -122.41021483966601 | (37.7549742023176, -122.410214839666) | |||
| 173598 | 173598 | 196263 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1059 Jamestown Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 6013674.30393 | 2089830.73604 | 37.7190465590346 | -122.394729166931 | (37.7190465590346, -122.394729166931) | ||||
| 148946 | 148946 | 212602 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1059 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5995906.91145 | 2090941.8957099998 | 37.7210936795162 | -122.456224088988 | (37.7210936795162, -122.456224088988) | |||
| 99972 | 99972 | 33470 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 106 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/1996 12:00:00 AM | Permit Number 770772 | 6006658.5962402 | 2099060.66654687 | 37.743997362867105 | -122.419634320147 | (37.7439973628671, -122.419634320147) | |||
| 22845 | 22845 | 34928 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 106 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/16/1997 12:00:00 AM | 3 | Permit Number 38520 | 5996566.0494 | 2113710.9366 | 37.7836495810368 | -122.455590554827 | (37.7836495810368, -122.455590554827) | ||
| 66277 | 66277 | 212367 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 106 Madrone Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5992722.38435 | 2098386.1123599997 | 37.741350333048295 | -122.467773114365 | (37.7413503330483, -122.467773114365) | |||
| 171545 | 171545 | 212368 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 106 Madrone Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5992720.22347 | 2098380.55994 | 37.741334962734 | -122.46778018213399 | (37.741334962734, -122.467780182134) | |||
| 146302 | 146302 | 32385 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 106 Park St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/03/1996 12:00:00 AM | Permit Number 36928 | 6005508.65097551 | 2096383.43998281 | 37.7365814594064 | -122.423420287008 | (37.7365814594064, -122.423420287008) | ||
| 41262 | 41262 | 140256 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1060 HAYES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5999087.5378 | 2110120.0757 | 37.7739343744836 | -122.446608759447 | (37.7739343744836, -122.446608759447) | |||
| 157328 | 157328 | 140260 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1060 HAYES ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5998893.619 | 2110091.0397 | 37.7738435703367 | -122.447277463951 | (37.7738435703367, -122.447277463951) | |||
| 176251 | 176251 | 140258 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1060 HAYES ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5998974.1592 | 2110103.1380000003 | 37.773881390953 | -122.446999734228 | (37.773881390953, -122.446999734228) | |||
| 182067 | 182067 | 140259 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1060 HAYES ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5998910.5566 | 2110094.4964 | 37.773854029358894 | -122.447219123108 | (37.7738540293589, -122.447219123108) | |||
| 28784 | 28784 | 85390 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1060 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/2007 12:00:00 AM | 5 | Permit Number 49660 | 6009093.49986 | 2117706.63601 | 37.7953317162473 | -122.412532734295 | (37.7953317162473, -122.412532734295) | ||
| 170792 | 170792 | 245015 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1060 Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5999396.4658 | 2109180.8568 | 37.7713731595136 | -122.445472581104 | (37.7713731595136, -122.445472581104) | |||
| 151336 | 151336 | 196120 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1065 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6012228.55506 | 2103398.12707 | 37.75621927141479 | -122.40067919398199 | (37.7562192714148, -122.400679193982) | |||
| 133075 | 133075 | 178840 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1065 Munich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6002119.38667 | 2087187.3937099997 | 37.711139309492395 | -122.434481095339 | (37.7111393094924, -122.434481095339) | |||
| 63398 | 63398 | 236552 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1066 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6008610.769640001 | 2102341.85895 | 37.7531165573006 | -122.41311609033998 | (37.7531165573006, -122.41311609034) | |||
| 128146 | 128146 | 48946 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1066 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/2002 12:00:00 AM | Permit Number 46133 | 6008605.50841318 | 2102337.36203543 | 37.7531039144279 | -122.41313396681002 | (37.7531039144279, -122.41313396681) | ||
| 142523 | 142523 | 30301 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 107 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 48196 | 5990498.42551573 | 2114680.4203788997 | 37.7859614580277 | -122.47665285108299 | (37.7859614580277, -122.476652851083) | |||
| 135885 | 135885 | 213118 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 107 Bella Vista Way | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5998502.70249 | 2097027.05983 | 37.7379507743002 | -122.447689068603 | (37.7379507743002, -122.447689068603) | |||
| 178988 | 178988 | 213117 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 107 Bella Vista Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5998491.69909 | 2097031.0960900001 | 37.737961228022 | -122.447727403094 | (37.737961228022, -122.447727403094) | |||
| 133883 | 133883 | 54535 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 107 Gaven St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/1994 12:00:00 AM | 8 | Permit Number 10330 | 6009992.40019 | 2095186.16028 | 37.7335460325239 | -122.407833574281 | (37.7335460325239, -122.407833574281) | |
| 26393 | 26393 | 245159 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 107 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6000307.8527 | 2109355.3565 | 37.7719042784691 | -122.44233258936501 | (37.7719042784691, -122.442332589365) | |||
| 98201 | 98201 | 45126 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 107 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2001 12:00:00 AM | Permit Number 43983 | 6000317.21225262 | 2109259.39896311 | 37.7716413366819 | -122.44229332427099 | (37.7716413366819, -122.442293324271) | ||
| 78060 | 78060 | 31092 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 107 Shotwell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34826 | 6007750.16699625 | 2107319.28125593 | 37.766735061881704 | -122.416444770373 | (37.7667350618817, -122.416444770373) | ||
| 109007 | 109007 | 31091 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 107 Shotwell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34826 | 6007750.16699625 | 2107319.28125593 | 37.766735061881704 | -122.416444770373 | (37.7667350618817, -122.416444770373) | ||
| 123857 | 123857 | 31090 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 107 Shotwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34826 | 6007750.16699625 | 2107319.28125593 | 37.766735061881704 | -122.416444770373 | (37.7667350618817, -122.416444770373) | ||
| 169251 | 169251 | 237495 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1070 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003781.39311 | 2102062.50844 | 37.7520772296931 | -122.42979710147499 | (37.7520772296931, -122.429797101475) | |||
| 39787 | 39787 | 135818 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1071 Lombard St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 6007217.26018 | 2120160.1793299997 | 37.801963055314495 | -122.419198970666 | (37.8019630553145, -122.419198970666) | |||
| 94757 | 94757 | 65242 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1077 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1989 12:00:00 AM | Permit Number 28036 | 6009214.60268532 | 2102898.17894887 | 37.7546779669117 | -122.411067200407 | (37.7546779669117, -122.411067200407) | ||
| 31394 | 31394 | 236442 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1079 Clayton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5998881.64355 | 2106235.14814 | 37.7632555842136 | -122.44704134900199 | (37.7632555842136, -122.447041349002) | |||
| 55528 | 55528 | 236441 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1079 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5998884.3660699995 | 2106216.5086 | 37.7632045602546 | -122.447030591303 | (37.7632045602546, -122.447030591303) | |||
| 184286 | 184286 | 236443 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1079 Clayton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5998879.37428 | 2106256.87538 | 37.7633151121175 | -122.44705076129601 | (37.7633151121175, -122.447050761296) | |||
| 32496 | 32496 | 248112 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 108 Brewster St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 6010381.20708 | 2099441.9489 | 37.745253272029096 | -122.406789179892 | (37.7452532720291, -122.406789179892) | ||||
| 67453 | 67453 | 212531 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 108 Dorado Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5994672.9021 | 2093140.1004599999 | 37.7270585067372 | -122.460648883855 | (37.7270585067372, -122.460648883855) | |||
| 176330 | 176330 | 196219 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 108 Freelon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6013347.14985 | 2111510.46831 | 37.7785562798816 | -122.397379568834 | (37.7785562798816, -122.397379568834) | |||
| 37887 | 37887 | 235941 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 108 Ripley St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008623.88293 | 2099066.97873 | 37.7441252029079 | -122.41283922684299 | (37.7441252029079, -122.412839226843) |
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");