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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 42481 | 42481 | 71284 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 Atalaya Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/07/1981 12:00:00 AM | 5 | 5998802.9816 | 2111041.8064 | 37.7764489521659 | -122.447659448254 | (37.7764489521659, -122.447659448254) | ||
| 38648 | 38648 | 68912 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 10 Florence St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 8 | Permit Number 32890 | 6008496.870730001 | 2118345.67653 | 37.797052862167604 | -122.41464241973 | (37.7970528621676, -122.41464241973) | |
| 165156 | 165156 | 69496 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 10 Otsego Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/24/1994 12:00:00 AM | 6 | Permit Number 33619 | 6000930.02783 | 2092989.43743 | 37.7270028279165 | -122.439007348127 | (37.7270028279165, -122.439007348127) | |
| 104017 | 104017 | 102628 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 100 Freelon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/07/2013 12:00:00 AM | 3x3 | Permit Number 769972 | 6013417.4 | 2111578.2 | 37.778746166691 | -122.397141295625 | (37.778746166691, -122.397141295625) | |
| 140743 | 140743 | 66752 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 100 Upper Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/12/1991 12:00:00 AM | Permit Number 30004 | 5999885.94793997 | 2106981.28514866 | 37.76536161907 | -122.443621406981 | (37.76536161907, -122.443621406981) | ||
| 115710 | 115710 | 42429 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 100@ Detroit Judson Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/13/2011 12:00:00 AM | Permit Number 768277 | 5999403.96940848 | 2093509.81726433 | 37.7283447217324 | -122.444320267584 | (37.7283447217324, -122.444320267584) | ||
| 142249 | 142249 | 42109 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 100@ Detroit Judson Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/13/2011 12:00:00 AM | Permit Number 768277 | 5999403.96940848 | 2093509.81726433 | 37.7283447217324 | -122.444320267584 | (37.7283447217324, -122.444320267584) | ||
| 79959 | 79959 | 42068 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 100X Ripley St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | 8 | 3x3 | Permit Number 42381 | 6015269.0 | 2115673.0 | 37.790092461076604 | -122.39102211089701 | (37.7900924610766, -122.391022110897) |
| 125439 | 125439 | 38880 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 101 Commonwealth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | Permit Number 40703 | 5996508.72142362 | 2113802.71293841 | 37.7838982845648 | -122.455795523067 | (37.7838982845648, -122.455795523067) | ||
| 83133 | 83133 | 32376 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 101 Leese St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/03/1996 12:00:00 AM | Permit Number 36923 | 6005608.6270807 | 2096147.29759992 | 37.7359387074275 | -122.423057847038 | (37.7359387074275, -122.423057847038) | ||
| 90719 | 90719 | 32373 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 101 Leese St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/03/1996 12:00:00 AM | Permit Number 36923 | 6005608.6270807 | 2096147.29759992 | 37.7359387074275 | -122.423057847038 | (37.7359387074275, -122.423057847038) | ||
| 94155 | 94155 | 32375 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 101 Leese St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/03/1996 12:00:00 AM | Permit Number 36923 | 6005608.6270807 | 2096147.29759992 | 37.7359387074275 | -122.423057847038 | (37.7359387074275, -122.423057847038) | ||
| 111748 | 111748 | 32374 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 101 Leese St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/03/1996 12:00:00 AM | Permit Number 36923 | 6005608.6270807 | 2096147.29759992 | 37.7359387074275 | -122.423057847038 | (37.7359387074275, -122.423057847038) | ||
| 119263 | 119263 | 31008 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 101 Morse St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34782 | 6000957.44438381 | 2087943.44267066 | 37.7131492251602 | -122.438551179992 | (37.7131492251602, -122.438551179992) | ||
| 127132 | 127132 | 31009 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 101 Morse St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34782 | 6000957.44438381 | 2087943.44267066 | 37.7131492251602 | -122.438551179992 | (37.7131492251602, -122.438551179992) | ||
| 75775 | 75775 | 35480 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1011 Silliman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/22/2002 12:00:00 AM | 4 | Permit Number 44832 | 6007756.215530001 | 2093380.89962 | 37.7284637342957 | -122.415436968047 | (37.7284637342957, -122.415436968047) | |
| 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) | ||
| 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) | ||
| 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) | |
| 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) | ||
| 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) | ||
| 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) | |
| 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) | ||
| 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) | |
| 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) | |
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |
| 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) | ||
| 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) | ||
| 123557 | 123557 | 69212 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1089 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1994 12:00:00 AM | Permit Number 33263 | 6008066.8179196995 | 2101598.29376591 | 37.7510443436687 | -122.414944565 | (37.7510443436687, -122.414944565) | ||
| 48367 | 48367 | 49748 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 109@ BRUSSELS Campbell Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2003 12:00:00 AM | 5 | Permit Number 46547 | 6011907.8290099995 | 2088398.1624200002 | 37.715014627609 | -122.400734636294 | (37.715014627609, -122.400734636294) | |
| 49635 | 49635 | 35149 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 11 Laussat St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/02/1998 12:00:00 AM | Permit Number 38681 | 6004664.75137838 | 2109286.2995173 | 37.771962024845294 | -122.427256837171 | (37.7719620248453, -122.427256837171) | ||
| 89676 | 89676 | 49125 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 11 Southwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/14/2003 12:00:00 AM | Permit Number 46256 | 5995794.69069605 | 2092577.70083633 | 37.725578768403295 | -122.456730244977 | (37.7255787684033, -122.456730244977) | ||
| 92654 | 92654 | 50123 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 11 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2003 12:00:00 AM | Permit Number 46846 | 5993295.32163742 | 2099072.65431328 | 37.7432684700147 | -122.465841985308 | (37.7432684700147, -122.465841985308) | ||
| 124905 | 124905 | 33472 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 110 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/20/1996 12:00:00 AM | Permit Number 37570 | 6006648.0674886 | 2099041.17525906 | 37.7439432510879 | -122.419669343585 | (37.7439432510879, -122.419669343585) | ||
| 65798 | 65798 | 49135 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 110 Valdez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/14/2003 12:00:00 AM | Permit Number 46262 | 5996344.49436596 | 2094285.70346417 | 37.730300088752706 | -122.45495298879601 | (37.7303000887527, -122.454952988796) | ||
| 85799 | 85799 | 49136 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 110 Valdez Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/14/2003 12:00:00 AM | Permit Number 46262 | 5996344.49436596 | 2094285.70346417 | 37.730300088752706 | -122.45495298879601 | (37.7303000887527, -122.454952988796) | ||
| 36830 | 36830 | 32000 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1100 Brazil Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1995 12:00:00 AM | 4 | Permit Number 35398 | 6004681.79036 | 2090489.9843099997 | 37.7203526336359 | -122.42585972476299 | (37.7203526336359, -122.425859724763) | |
| 176732 | 176732 | 31999 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1100 Brazil Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1995 12:00:00 AM | 7 | Permit Number 35398 | 6004667.05838 | 2090499.06627 | 37.72037673816379 | -122.42591129458201 | (37.7203767381638, -122.425911294582) | |
| 168825 | 168825 | 32695 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1106 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 5 | 3x3 | Permit Number 37103 | 6008138.63139 | 2115547.98028 | 37.7893509440283 | -122.41568382655599 | (37.7893509440283, -122.415683826556) |
| 88496 | 88496 | 37046 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 111 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/2003 12:00:00 AM | Permit Number 39652 | 6005218.05274193 | 2098707.44239672 | 37.742946239057495 | -122.42459027630301 | (37.7429462390575, -122.424590276303) | ||
| 24502 | 24502 | 66601 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1111 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/22/1991 12:00:00 AM | 9 | Permit Number 29794 | 6008473.92013 | 2115892.33746 | 37.7903153068679 | -122.414548140207 | (37.7903153068679, -122.414548140207) | |
| 103202 | 103202 | 48926 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1117 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/2002 12:00:00 AM | Permit Number 46116 | 6009228.51903101 | 2102650.40523838 | 37.7539984163421 | -122.411001574032 | (37.7539984163421, -122.411001574032) | ||
| 180513 | 180513 | 59534 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1117 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/09/1995 12:00:00 AM | 11 | Permit Number 18916 | 6009775.37323 | 2111231.47163 | 37.7775907092861 | -122.409716062169 | (37.7775907092861, -122.409716062169) | |
| 74408 | 74408 | 83942 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1118 Fitzgerald Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/29/2006 12:00:00 AM | 3 | 6015103.3012 | 2090231.7832 | 37.72022710350421 | -122.389817632552 | (37.7202271035042, -122.389817632552) | ||
| 158396 | 158396 | 37841 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1119 Brazil Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/07/1998 12:00:00 AM | 5 | Permit Number 40135 | 6004769.12053 | 2090484.0078 | 37.72034115831121 | -122.42555742754499 | (37.7203411583112, -122.425557427545) | |
| 164887 | 164887 | 37842 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1119 Brazil Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/07/1998 12:00:00 AM | 6 | Permit Number 40135 | 6004757.56597 | 2090489.6511 | 37.7203560007008 | -122.425597769339 | (37.7203560007008, -122.425597769339) | |
| 98592 | 98592 | 37461 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 112 Montcalm St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1998 12:00:00 AM | Permit Number 39933 | 6010401.79922935 | 2099926.04056844 | 37.746583634341796 | -122.406752085329 | (37.7465836343418, -122.406752085329) | ||
| 32900 | 32900 | 78278 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1129 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2000 12:00:00 AM | 3 | 6000344.02965 | 2090524.15486 | 37.720200365833996 | -122.440856356949 | (37.720200365834, -122.440856356949) | ||
| 148545 | 148545 | 31716 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1137 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 10 | Permit Number 35216 | 5997692.23217 | 2106590.3868400003 | 37.764162952473704 | -122.45118072960399 | (37.7641629524737, -122.451180729604) | |
| 94309 | 94309 | 33473 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 114 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/02/2003 12:00:00 AM | Permit Number 37594 | 6006637.53873578 | 2099021.68396902 | 37.743889139291504 | -122.41970436697599 | (37.7438891392915, -122.419704366976) | ||
| 46945 | 46945 | 60784 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 114 Ewing Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/14/1983 12:00:00 AM | 3 | Permit Number 20454 | 5998687.9541 | 2112447.9464 | 37.7803032743536 | -122.448158632248 | (37.7803032743536, -122.448158632248) | |
| 122294 | 122294 | 56398 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 115 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1993 12:00:00 AM | Permit Number 32595 | 5992079.75855562 | 2114689.20076693 | 37.7860771604727 | -122.47118256223601 | (37.7860771604727, -122.471182562236) | ||
| 90748 | 90748 | 45411 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 115 De Soto St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2001 12:00:00 AM | Permit Number 44214 | 5993222.61993316 | 2091915.18742558 | 37.723611648870396 | -122.465573496959 | (37.7236116488704, -122.465573496959) | ||
| 128759 | 128759 | 45412 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 115 De Soto St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2001 12:00:00 AM | Permit Number 44214 | 5993222.61993316 | 2091915.18742558 | 37.723611648870396 | -122.465573496959 | (37.7236116488704, -122.465573496959) | ||
| 172746 | 172746 | 54537 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 115 Gaven St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/1994 12:00:00 AM | 5 | Permit Number 10332 | 6009964.96309 | 2095176.72453 | 37.733518587899496 | -122.407927767479 | (37.7335185878995, -122.407927767479) | |
| 45219 | 45219 | 52525 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 115 Otsego Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | 5 | Permit Number 48625 | 6000708.298330001 | 2092511.5798799999 | 37.725678122036705 | -122.439739616589 | (37.7256781220367, -122.439739616589) | |
| 105530 | 105530 | 45134 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1155 Page St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/2005 12:00:00 AM | Permit Number 43992 | 6001042.61306002 | 2109303.63872684 | 37.771804125001395 | -122.439787297823 | (37.7718041250014, -122.439787297823) | ||
| 129382 | 129382 | 51250 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1155 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/17/2004 12:00:00 AM | Permit Number 47628 | 6008685.89318972 | 2101824.04277948 | 37.751698967516 | -122.41281969113301 | (37.751698967516, -122.412819691133) | ||
| 116251 | 116251 | 65016 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1159 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1989 12:00:00 AM | Permit Number 28061 | 6009501.99103818 | 2102429.41750782 | 37.753406964993 | -122.41004023881001 | (37.753406964993, -122.41004023881) | ||
| 87375 | 87375 | 68816 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 116 Congo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/30/1993 12:00:00 AM | Permit Number 32763 | 6000110.56465596 | 2094119.87106159 | 37.73006007699821 | -122.44192131130899 | (37.7300600769982, -122.441921311309) | ||
| 121941 | 121941 | 68123 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 116 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1993 12:00:00 AM | Permit Number 31871 | 6006164.46865808 | 2099463.44795455 | 37.7450754630274 | -122.421371501845 | (37.7450754630274, -122.421371501845) | ||
| 69143 | 69143 | 42839 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1167 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/29/2000 12:00:00 AM | 5 | Permit Number 42770 | 6007346.6476 | 2119488.5768 | 37.8001262898408 | -122.418703572815 | (37.8001262898408, -122.418703572815) | |
| 157782 | 157782 | 32467 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 118 Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1996 12:00:00 AM | 5 | Permit Number 36976 | 6000633.1646300005 | 2105655.4386299998 | 37.7617637600109 | -122.440941842909 | (37.7617637600109, -122.440941842909) | |
| 72721 | 72721 | 72129 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1183 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/25/1984 12:00:00 AM | 8 | 6012255.77606 | 2102909.56429 | 37.754879303143504 | -122.40055073574499 | (37.7548793031435, -122.400550735745) | ||
| 94437 | 94437 | 39171 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1183 Shotwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1998 12:00:00 AM | Permit Number 40833 | 6008097.4704466 | 2101048.57184337 | 37.749536653320796 | -122.41479966425301 | (37.7495366533208, -122.414799664253) | ||
| 102355 | 102355 | 39170 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1183 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1998 12:00:00 AM | Permit Number 40833 | 6008097.4704466 | 2101048.57184337 | 37.749536653320796 | -122.41479966425301 | (37.7495366533208, -122.414799664253) | ||
| 177871 | 177871 | 78222 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1186 Bowdoin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/2000 12:00:00 AM | 7 | 6009661.32539 | 2090689.78042 | 37.7211813813865 | -122.408661109741 | (37.7211813813865, -122.408661109741) | ||
| 179812 | 179812 | 40484 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 119 Shawnee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1999 12:00:00 AM | 7 | Permit Number 41563 | 5998642.9116 | 2089895.24325 | 37.7183764894551 | -122.44669130408501 | (37.7183764894551, -122.446691304085) | |
| 47754 | 47754 | 78568 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1192 Bowdoin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/2000 12:00:00 AM | 9 | 6009666.22083 | 2090670.9365 | 37.7211299140849 | -122.408642858878 | (37.7211299140849, -122.408642858878) | ||
| 87825 | 87825 | 46696 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1199 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/22/2002 12:00:00 AM | Permit Number 44825 | 6004486.23005194 | 2101922.27606935 | 37.7517320725102 | -122.427349680718 | (37.7517320725102, -122.427349680718) | ||
| 100140 | 100140 | 46697 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1199 Church St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/22/2002 12:00:00 AM | Permit Number 44825 | 6004486.23005194 | 2101922.27606935 | 37.7517320725102 | -122.427349680718 | (37.7517320725102, -122.427349680718) | ||
| 112981 | 112981 | 41104 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 120 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/10/1999 12:00:00 AM | Permit Number 41851 | 5998272.85279427 | 2108095.35344781 | 37.768328435863104 | -122.44928097444401 | (37.7683284358631, -122.449280974444) | ||
| 3674 | 3674 | 32468 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 120 Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/15/2017 12:00:00 AM | 3 | Permit Number 36977 | 6000626.3294 | 2105651.6556 | 37.7617529834407 | -122.44096521177099 | (37.7617529834407, -122.440965211771) | |
| 130165 | 130165 | 68695 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 120 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1993 12:00:00 AM | 7 | Permit Number 32607 | 5991824.01448 | 2114640.95732 | 37.7859299013327 | -122.47206384206699 | (37.7859299013327, -122.472063842067) | |
| 138299 | 138299 | 34467 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1200 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 38202 | 6008365.37271822 | 2117943.65111896 | 37.795941611119105 | -122.41506896543801 | (37.7959416111191, -122.415068965438) | ||
| 142081 | 142081 | 39154 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1201 Guerrero St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1998 12:00:00 AM | Permit Number 40824 | 6005810.90116687 | 2101975.65713529 | 37.751953473746 | -122.42277257880899 | (37.751953473746, -122.422772578809) | ||
| 144841 | 144841 | 39153 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1201 Guerrero St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1998 12:00:00 AM | Permit Number 40824 | 6005810.90116687 | 2101975.65713529 | 37.751953473746 | -122.42277257880899 | (37.751953473746, -122.422772578809) | ||
| 93861 | 93861 | 49186 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1205 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/30/2006 12:00:00 AM | Permit Number 48817 | 5997393.123944099 | 2105818.68108377 | 37.7620269142023 | -122.452159568724 | (37.7620269142023, -122.452159568724) | ||
| 11987 | 11987 | 50020 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1208 Bowdoin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | 4 | 2.5x4 | Permit Number 46754 | 6009698.1958800005 | 2090561.7050599998 | 37.7208317780481 | -122.408524628629 | (37.7208317780481, -122.408524628629) |
| 98358 | 98358 | 34339 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1208 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38096 | 6010010.44366071 | 2102153.08231876 | 37.7526766947255 | -122.408262405766 | (37.7526766947255, -122.408262405766) | ||
| 96171 | 96171 | 40643 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1209 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/2000 12:00:00 AM | Permit Number 43157 | 6003238.58601391 | 2101202.68184483 | 37.749685595307604 | -122.43161282786998 | (37.7496855953076, -122.43161282787) | ||
| 119392 | 119392 | 40644 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1209 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/2000 12:00:00 AM | Permit Number 43157 | 6003238.58601391 | 2101202.68184483 | 37.749685595307604 | -122.43161282786998 | (37.7496855953076, -122.43161282787) | ||
| 54626 | 54626 | 45131 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 121 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/2001 12:00:00 AM | Permit Number 43990 | 6000310.782626901 | 2109305.17604742 | 37.7717666625759 | -122.442318851526 | (37.7717666625759, -122.442318851526) | ||
| 90089 | 90089 | 34390 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 121 Miguel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | 8 | 3x3 | Permit Number 38138 | 6004012.83448978 | 2097023.52447631 | 37.738254447209 | -122.428637579074 | (37.738254447209, -122.428637579074) |
| 91450 | 91450 | 34391 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 121 Miguel St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | 8 | 3x3 | Permit Number 38138 | 6004012.83448978 | 2097023.52447631 | 37.738254447209 | -122.428637579074 | (37.738254447209, -122.428637579074) |
| 103586 | 103586 | 56625 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1220 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/19/1987 12:00:00 AM | 6001937.86252386 | 2100536.90799986 | 37.747783725843895 | -122.436063136304 | (37.7477837258439, -122.436063136304) | |||
| 78359 | 78359 | 46917 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1221 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/29/2002 12:00:00 AM | Permit Number 44973 | 5995133.00137739 | 2107226.62921874 | 37.7657630476681 | -122.460078405891 | (37.7657630476681, -122.460078405891) |
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");