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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9165 | 9165 | 26222 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 765X San Jose Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6005700.4508028 | 2098660.5880909 | 37.742844819447896 | -122.42291894531799 | (37.7428448194479, -122.422918945318) | |||
| 9270 | 9270 | 26229 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 765X San Jose Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6005700.4508028 | 2098660.5880909 | 37.742844819447896 | -122.42291894531799 | (37.7428448194479, -122.422918945318) | |||
| 9310 | 9310 | 26227 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 765X San Jose Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6005700.4508028 | 2098660.5880909 | 37.742844819447896 | -122.42291894531799 | (37.7428448194479, -122.422918945318) | |||
| 9326 | 9326 | 26258 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1530 Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3X3 | 6005847.527000001 | 2100032.50262 | 37.746620083181796 | -122.42250785943199 | (37.7466200831818, -122.422507859432) | |||
| 9331 | 9331 | 26267 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 700X San Jose Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6005755.6616802 | 2099067.9825513 | 37.7439665475249 | -122.422756987055 | (37.7439665475249, -122.422756987055) | |||
| 9333 | 9333 | 26225 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 765X San Jose Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6005700.4508028 | 2098660.5880909 | 37.742844819447896 | -122.42291894531799 | (37.7428448194479, -122.422918945318) | |||
| 9384 | 9384 | 26268 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 700X San Jose Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3X3 | 6005755.6616802 | 2099067.9825513 | 37.7439665475249 | -122.422756987055 | (37.7439665475249, -122.422756987055) | |||
| 9404 | 9404 | 26230 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 765X San Jose Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6005700.4508028 | 2098660.5880909 | 37.742844819447896 | -122.42291894531799 | (37.7428448194479, -122.422918945318) | |||
| 9416 | 9416 | 2543 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1580 Burke Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6016211.0400559995 | 2099180.9466222 | 37.7448610852571 | -122.386612216975 | (37.7448610852571, -122.386612216975) | |||
| 9462 | 9462 | 26266 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 700X San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6005755.6616802 | 2099067.9825513 | 37.7439665475249 | -122.422756987055 | (37.7439665475249, -122.422756987055) | |||
| 9496 | 9496 | 19512 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 101X Saint Joseph's Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 4X4 | 6000653.0003 | 2112676.212 | 37.781042171769705 | -122.441377029637 | (37.7810421717697, -122.441377029637) | |||
| 9509 | 9509 | 105278 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 568-570 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 6x9 | Permit Number 771026 | 6002982.0 | 2104934.0 | 37.7599163606325 | -122.43276662907101 | (37.7599163606325, -122.432766629071) | ||
| 9512 | 9512 | 19511 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 101X Saint Joseph's Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6000658.415 | 2112657.2603 | 37.7809904437075 | -122.44135693728902 | (37.7809904437075, -122.441356937289) | |||
| 9540 | 9540 | 26551 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 90X Saint Joseph's Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6000745.8124 | 2112342.7819 | 37.780131944670295 | -122.441032019327 | (37.7801319446703, -122.441032019327) | |||
| 9548 | 9548 | 22798 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 16 Saint Joseph's Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6000767.4714 | 2112175.6015 | 37.7796741435255 | -122.440945094511 | (37.7796741435255, -122.440945094511) | |||
| 9560 | 9560 | 19503 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 90X Saint Joseph's Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 4X4 | 6000748.1814 | 2112325.5224 | 37.78008468941729 | -122.441022585328 | (37.7800846894173, -122.441022585328) | |||
| 9582 | 9582 | 105279 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 568-570 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 6x9 | Permit Number 771026 | 6002982.0 | 2104934.0 | 37.7599163606325 | -122.43276662907101 | (37.7599163606325, -122.432766629071) | ||
| 9718 | 9718 | 105047 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 278 Capitol Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5995102.4 | 2087946.7 | 37.7128233663074 | -122.458788296392 | (37.7128233663074, -122.458788296392) | |||||
| 9728 | 9728 | 173660 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1252 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 1 | 3x3 | 6004044.0 | 2112543.0 | 37.7808689972899 | -122.429636372405 | (37.7808689972899, -122.429636372405) | |||
| 9731 | 9731 | 173661 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1252 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 1 | 3x3 | 6004044.0 | 2112543.0 | 37.7808689972899 | -122.429636372405 | (37.7808689972899, -122.429636372405) | |||
| 9982 | 9982 | 120898 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 200 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6001048.0 | 2105186.0 | 37.7604984146453 | -122.439473444132 | (37.7604984146453, -122.439473444132) | |||
| 10076 | 10076 | 142645 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2380 Mason St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6008890.0639 | 2121379.5977 | 37.805405337199 | -122.41349655223 | (37.805405337199, -122.41349655223) | |||||
| 10115 | 10115 | 173855 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 511 Cordova St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5xt | 6002114.0 | 2086554.0 | 37.7093998431938 | -122.43445445536699 | (37.7093998431938, -122.434454455367) | ||||
| 10359 | 10359 | 26782 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 6 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 6010979.6007 | 2087065.0465 | 37.711302344066 | -122.403849252944 | (37.711302344066, -122.403849252944) | ||||
| 10363 | 10363 | 26319 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2021 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 3X3 | 5999671.6195 | 2092116.9094 | 37.7245353858939 | -122.443294987371 | (37.7245353858939, -122.443294987371) | |||
| 10431 | 10431 | 26328 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1857 San Jose Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6000421.70721 | 2093270.90592 | 37.7277467399142 | -122.440784780799 | (37.7277467399142, -122.440784780799) | |||
| 10437 | 10437 | 115185 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2300X Alemany Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 5999482.43288 | 2089277.31598 | 37.716727722789 | -122.443745071105 | (37.716727722789, -122.443745071105) | ||||
| 10581 | 10581 | 1040 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2003X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 4X4 | 6000664.666119999 | 2090352.04738 | 37.7197460535115 | -122.439735693745 | (37.7197460535115, -122.439735693745) | |||
| 10742 | 10742 | 115189 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2300X Alemany Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 5999437.68927 | 2089235.07738 | 37.716609193035396 | -122.443896694081 | (37.7166091930354, -122.443896694081) | ||||
| 10882 | 10882 | 15832 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5172 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6000113.1533 | 2088967.78634 | 37.7159137787676 | -122.441542789662 | (37.7159137787676, -122.441542789662) | |||
| 11090 | 11090 | 96865 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 620 Palmetto Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 5991908.438490001 | 2087239.0013 | 37.7106960939316 | -122.469776068222 | (37.7106960939316, -122.469776068222) | |||
| 11125 | 11125 | 15842 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5243 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 5999889.83361 | 2088564.50035 | 37.7147937208238 | -122.442285750192 | (37.7147937208238, -122.442285750192) | |||
| 11142 | 11142 | 15834 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5199X Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6000075.39694 | 2088803.4795400002 | 37.715460478198295 | -122.44166150827299 | (37.7154604781983, -122.441661508273) | |||
| 11225 | 11225 | 952 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1500 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 6x6 | 6002047.349219999 | 2093382.65925 | 37.7281460362049 | -122.435172906015 | (37.7281460362049, -122.435172906015) | |||
| 11251 | 11251 | 115187 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2300X Alemany Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 5999459.81391 | 2089256.7158599999 | 37.716669869389 | -122.443821774256 | (37.716669869389, -122.443821774256) | ||||
| 11297 | 11297 | 95009 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 151 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 6010165.2261 | 2087437.3639 | 37.712279121941 | -122.40669017224899 | (37.712279121941, -122.406690172249) | ||||
| 11346 | 11346 | 112661 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2450 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 5988181.8432 | 2106487.3051 | 37.7633308106608 | -122.484066458576 | (37.7633308106608, -122.484066458576) | |||
| 11472 | 11472 | 15829 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5163 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6000211.93935 | 2089017.25913 | 37.7160552475202 | -122.441204887393 | (37.7160552475202, -122.441204887393) | |||
| 11541 | 11541 | 15769 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4770 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001431.4832 | 2091064.0258 | 37.7217446032554 | -122.437136033126 | (37.7217446032554, -122.437136033126) | |||
| 11787 | 11787 | 26327 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1857 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6000413.8047 | 2093256.1266 | 37.7277057092515 | -122.440811040114 | (37.7277057092515, -122.440811040114) | |||
| 11793 | 11793 | 120892 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 201 Leland Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 3x3 | 6009904.76 | 2087542.3079 | 37.7125527002168 | -122.407597819442 | (37.7125527002168, -122.407597819442) | |||
| 11967 | 11967 | 15840 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5233 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5999921.34748 | 2088601.8147599997 | 37.714897973849396 | -122.44217950248999 | (37.7148979738494, -122.44217950249) | |||
| 12023 | 12023 | 95021 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 51 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 6010652.9596 | 2087185.8102 | 37.711615683002 | -122.404986710459 | (37.711615683002, -122.404986710459) | ||||
| 12033 | 12033 | 15771 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4770 Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001407.8795 | 2091033.0967 | 37.7216583371772 | -122.437215411352 | (37.7216583371772, -122.437215411352) | |||
| 12208 | 12208 | 95022 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 45 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 6010735.1769 | 2087146.3726 | 37.7115119909256 | -122.404699769405 | (37.7115119909256, -122.404699769405) | ||||
| 12460 | 12460 | 95000 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 160 Leland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 9x15 | 6010171.1456 | 2087482.6157 | 37.712403705394 | -122.40667289956998 | (37.712403705394, -122.40667289957) | |||
| 12485 | 12485 | 94989 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 44 Leland Ave | 1 | Sidewalk: Curb side : 21 | Tree 1 | Private 1 | 3 | 6010751.8878 | 2087184.0277 | 37.711616318234206 | -122.404644660956 | (37.7116163182342, -122.404644660956) | ||||
| 12498 | 12498 | 95030 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 11 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 6010891.1447 | 2087063.4869 | 37.7112931195577 | -122.404154871184 | (37.7112931195577, -122.404154871184) | ||||
| 12539 | 12539 | 95031 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 6010911.6433 | 2087052.7919 | 37.7112648985932 | -122.404083270279 | (37.7112648985932, -122.404083270279) | ||||
| 12735 | 12735 | 115192 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2300X Alemany Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 5999381.87795 | 2089181.7631299999 | 37.7164596204897 | -122.44408577653499 | (37.7164596204897, -122.444085776535) | ||||
| 12743 | 12743 | 96867 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 620 Palmetto Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5991882.45781 | 2087240.6995 | 37.710699255031294 | -122.46986598602301 | (37.7106992550313, -122.469865986023) | |||
| 12751 | 12751 | 15828 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5159 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6000226.64525 | 2089042.26586 | 37.7161247480431 | -122.441155850079 | (37.7161247480431, -122.441155850079) | |||
| 12795 | 12795 | 105355 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 202X Theresa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6002020.25197 | 2093863.8275799998 | 37.729465676201 | -122.435300985665 | (37.729465676201, -122.435300985665) | |||
| 12810 | 12810 | 94999 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 144 Leland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010257.4842 | 2087438.4037 | 37.7122871384537 | -122.406371372412 | (37.7122871384537, -122.406371372412) | |||
| 13133 | 13133 | 26797 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 141 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010236.5257 | 2087400.8229 | 37.71218277673879 | -122.40644116519199 | (37.7121827767388, -122.406441165192) | |||
| 13177 | 13177 | 94998 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 144 Leland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6010267.0774 | 2087433.8156 | 37.712275077109 | -122.406337892214 | (37.712275077109, -122.406337892214) | |||
| 13684 | 13684 | 96586 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 6323 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6013217.1012 | 2090358.8553 | 37.720471238132795 | -122.396346547024 | (37.7204712381328, -122.396346547024) | |||
| 13925 | 13925 | 2497 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1500 Burke Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016766.5915 | 2098782.9536200003 | 37.7437990179202 | -122.384663486948 | (37.7437990179202, -122.384663486948) | |||
| 14626 | 14626 | 10913 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1351X Hudson Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X4 | 6016987.51869 | 2096153.0024299999 | 37.7365899183909 | -122.38371649632299 | (37.7365899183909, -122.383716496323) | |||
| 14706 | 14706 | 117455 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 236 Shipley St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | Permit Number 776408 | 6011503.45491 | 2111758.7875900003 | 37.7791352841027 | -122.403775126323 | (37.7791352841027, -122.403775126323) | ||
| 14812 | 14812 | 116719 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 855 Folsom St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 6011931.9643 | 2112416.1862 | 37.7809642773111 | -122.402338963905 | (37.7809642773111, -122.402338963905) | |||
| 15788 | 15788 | 12148 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1400X La Salle Ave | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6016263.135559999 | 2095630.9008799999 | 37.735116265005296 | -122.38618463531701 | (37.7351162650053, -122.386184635317) | |||
| 16171 | 16171 | 117453 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 236 Shipley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | Permit Number 776408 | 6011539.59396 | 2111788.0027 | 37.779217520823 | -122.403652162024 | (37.779217520823, -122.403652162024) | ||
| 16613 | 16613 | 97168 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 519 07th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6011311.19047 | 2109913.80768 | 37.7740586534059 | -122.404310357843 | (37.7740586534059, -122.404310357843) | |||
| 16849 | 16849 | 22416 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5800 03rd St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 6013664.2375 | 2091773.8949 | 37.724381524856206 | -122.39489998248001 | (37.7243815248562, -122.39489998248) | ||||
| 16990 | 16990 | 10437 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1472 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5999082.1034 | 2108734.1403 | 37.770128638220704 | -122.44652782703501 | (37.7701286382207, -122.446527827035) | |||
| 17103 | 17103 | 10003 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 145 Guerrero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X2 | 6005473.24802 | 2108147.80938 | 37.7688816943622 | -122.424379193367 | (37.7688816943622, -122.424379193367) | |||
| 17148 | 17148 | 197 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 300 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002246.85388 | 2106423.49653 | 37.7639644352284 | -122.43541568967899 | (37.7639644352284, -122.435415689679) | |||
| 17203 | 17203 | 19345 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 533 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 5992567.96665 | 2089831.72635 | 37.7178531919482 | -122.467685048229 | (37.7178531919482, -122.467685048229) | |||
| 17249 | 17249 | 28766 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1007 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6005756.3593 | 2103044.9501900002 | 37.7548864275923 | -122.423037187213 | (37.7548864275923, -122.423037187213) | |||
| 17440 | 17440 | 4242 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4024 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X2 | 6003700.62714 | 2100425.74142 | 37.7475784763835 | -122.42995965841101 | (37.7475784763835, -122.429959658411) | |||
| 17584 | 17584 | 4006 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 314 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002254.21514 | 2106356.0846700002 | 37.7637797567577 | -122.435385406814 | (37.7637797567577, -122.435385406814) | |||
| 17592 | 17592 | 4009 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 321 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002319.05105 | 2106225.20693 | 37.7634240802833 | -122.43515179801201 | (37.7634240802833, -122.435151798012) | |||
| 17593 | 17593 | 35 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 765 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6003712.362269999 | 2107704.7999 | 37.767565705622296 | -122.430438361268 | (37.7675657056223, -122.430438361268) | |||
| 17663 | 17663 | 4241 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4024 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003717.078869999 | 2100425.61204 | 37.747579052827504 | -122.429902760105 | (37.7475790528275, -122.429902760105) | |||
| 17802 | 17802 | 26248 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1515 Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6005933.87923 | 2100151.66635 | 37.746952150739496 | -122.422217726773 | (37.7469521507395, -122.422217726773) | |||
| 17811 | 17811 | 4012 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 328 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6002260.92536 | 2106287.441 | 37.76359165905 | -122.435357287719 | (37.76359165905, -122.435357287719) | |||
| 17984 | 17984 | 26257 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1532 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 3X3 | 6005857.37846 | 2100031.69628 | 37.746618424911496 | -122.422473736782 | (37.7466184249115, -122.422473736782) | |||
| 18043 | 18043 | 25278 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1920 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 5993933.257 | 2092673.2529 | 37.725734075054895 | -122.4631719467 | (37.7257340750549, -122.4631719467) | |||
| 18130 | 18130 | 28744 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 756 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6005606.56213 | 2098654.88944 | 37.7428238740223 | -122.42324318142201 | (37.7428238740223, -122.423243181422) | |||
| 18220 | 18220 | 4499 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1705 Church St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6004659.32032 | 2098930.07064 | 37.7435259549485 | -122.426538068994 | (37.7435259549485, -122.426538068994) | |||
| 18296 | 18296 | 4008 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 317 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002316.37598 | 2106247.05915 | 37.7634839292556 | -122.435162613271 | (37.7634839292556, -122.435162613271) | |||
| 18425 | 18425 | 15522 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2776 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6007029.5967 | 2102225.1589 | 37.752707234242294 | -122.418575836304 | (37.7527072342423, -122.418575836304) | |||
| 18471 | 18471 | 4497 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1705 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6004661.68171 | 2098887.89252 | 37.743410276978295 | -122.426526901197 | (37.7434102769783, -122.426526901197) | |||
| 18646 | 18646 | 5581 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1061 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6005153.1959 | 2102184.2823799998 | 37.752489179437205 | -122.425061862427 | (37.7524891794372, -122.425061862427) | |||
| 18678 | 18678 | 19521 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 130X Saint Joseph's Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000722.7955642 | 2112514.8377136 | 37.7806030550121 | -122.44112399249201 | (37.7806030550121, -122.441123992492) | |||
| 18747 | 18747 | 29567 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1915 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 5994092.8246 | 2092513.634 | 37.7253049912672 | -122.46260876441299 | (37.7253049912672, -122.462608764413) | |||
| 18760 | 18760 | 19342 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 509 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 5992668.8586 | 2089831.50787 | 37.717858417018796 | -122.467336296546 | (37.7178584170188, -122.467336296546) | |||
| 18886 | 18886 | 19520 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 127 Saint Joseph's Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 4X4 | 6000564.0 | 2112525.0 | 37.7806219117946 | -122.44167407008999 | (37.7806219117946, -122.44167407009) | |||
| 19027 | 19027 | 97174 | Significant Tree 6 | Tristaniopsis laurina :: Swamp Myrtle 37 | 26 Gilbert St | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 6011445.1 | 2110013.2 | 37.7743390438118 | -122.40385413458 | (37.7743390438118, -122.40385413458) | |||||
| 19074 | 19074 | 28747 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 802 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6005523.07189 | 2098399.8522 | 37.7421188873695 | -122.423513739777 | (37.7421188873695, -122.423513739777) | |||
| 19093 | 19093 | 4188 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3853 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X6 | 6004845.42811 | 2100443.99625 | 37.7476933665766 | -122.42600230236602 | (37.7476933665766, -122.426002302366) | |||
| 19259 | 19259 | 1364 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 25 Amethyst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 1X1 | 5999126.95834 | 2100012.88601 | 37.746184795201 | -122.445745384538 | (37.746184795201, -122.445745384538) | |||
| 19285 | 19285 | 10094 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 718 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 2X3 | 6005593.36455 | 2104752.70261 | 37.759566317848 | -122.423722287162 | (37.759566317848, -122.423722287162) | |||
| 19462 | 19462 | 4498 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1705 Church St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6004660.458 | 2098906.89217 | 37.7434623764904 | -122.42653248508002 | (37.7434623764904, -122.42653248508) | |||
| 19593 | 19593 | 10226 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1401 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005881.42321 | 2100761.4578 | 37.7486235398515 | -122.422442436769 | (37.7486235398515, -122.422442436769) | |||
| 19756 | 19756 | 28746 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 842 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6005458.2686 | 2098205.39084 | 37.7415812825622 | -122.423723985986 | (37.7415812825622, -122.423723985986) | |||
| 19859 | 19859 | 25234 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1521 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 5995237.4628 | 2092125.3367 | 37.7243046742315 | -122.458623789784 | (37.7243046742315, -122.458623789784) | |||
| 19878 | 19878 | 5726 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1682 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 6005266.70473 | 2098545.04181 | 37.742503071459204 | -122.424410502341 | (37.7425030714592, -122.424410502341) | |||
| 19901 | 19901 | 21524 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2709X Diamond St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Tree was replanted 02/06/07 | 6002363.91789 | 2096241.5628900002 | 37.7360139044279 | -122.434282822689 | (37.7360139044279, -122.434282822689) |
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");