Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qSiteInfo, qCaretaker, qCareAssistant, DBH, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate ▼ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1354 | 1354 | 14491 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 320 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 5999051.991 | 2111710.9656 | 37.77830051932229 | -122.446846219186 | (37.7783005193223, -122.446846219186) | |||
| 1445 | 1445 | 22600 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 837 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6005887.44223 | 2112751.69518 | 37.78154623162111 | -122.42327383483999 | (37.7815462316211, -122.42327383484) | |||
| 1531 | 1531 | 5189 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 509 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X3 | 6001637.7109 | 2110249.8513 | 37.7744360439082 | -122.43779659970501 | (37.7744360439082, -122.437796599705) | |||
| 1940 | 1940 | 139586 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3 Saint Joseph's Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | Width 0ft | 6000731.3449 | 2112139.6442 | 37.779573356306 | -122.44106749101401 | (37.779573356306, -122.441067491014) | |||
| 1942 | 1942 | 139585 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5 Saint Joseph's Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | Width 0ft | 6000729.6528 | 2112161.6416 | 37.7796336591807 | -122.4410749233 | (37.7796336591807, -122.4410749233) | |||
| 1952 | 1952 | 139587 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 Saint Joseph's Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11 | Width 0ft | 6000732.3602 | 2112121.031 | 37.7795223070318 | -122.441062642932 | (37.7795223070318, -122.441062642932) | |||
| 3757 | 3757 | 6923 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 436 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 6005320.8239 | 2110648.3853 | 37.775739063409794 | -122.425084363796 | (37.7757390634098, -122.425084363796) | |||
| 4556 | 4556 | 136909 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2210 Stockton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | Width 3ft | 6009830.0684 | 2121639.18274 | 37.806170828478606 | -122.410261867902 | (37.8061708284786, -122.410261867902) | |||
| 4578 | 4578 | 136910 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2210 Stockton St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | Width 3ft | 6009806.2153 | 2121790.84358 | 37.8065859141719 | -122.410355131177 | (37.8065859141719, -122.410355131177) | |||
| 5292 | 5292 | 14530 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 700 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 5999227.9935 | 2110423.9359 | 37.774776718941105 | -122.44614476286999 | (37.7747767189411, -122.44614476287) | |||
| 5443 | 5443 | 23446 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2100X Van Ness Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6005973.04919 | 2117793.46515 | 37.7953945104887 | -122.423336192033 | (37.7953945104887, -122.423336192033) | |||
| 5493 | 5493 | 22601 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 837 Turk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6005919.22221 | 2112752.51326 | 37.781550271357204 | -122.42316394935601 | (37.7815502713572, -122.423163949356) | |||
| 5745 | 5745 | 18285 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2000 Post St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6002494.2739 | 2114068.183 | 37.784968892425496 | -122.435106743694 | (37.7849688924255, -122.435106743694) | |||
| 6149 | 6149 | 14526 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 637 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 5999136.9105 | 2110609.5392 | 37.775281136182606 | -122.446473192139 | (37.7752811361826, -122.446473192139) | |||
| 6490 | 6490 | 8647 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2761 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 5998533.8029 | 2113119.8829 | 37.7821394236041 | -122.448740321446 | (37.7821394236041, -122.448740321446) | |||
| 6895 | 6895 | 6225 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1220 Ellis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X4 | 6005060.4446 | 2113384.1056 | 37.783235967029206 | -122.426179889067 | (37.7832359670292, -122.426179889067) | |||
| 7514 | 7514 | 14490 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 303 Masonic Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 5998985.0486 | 2111710.2278 | 37.7782946690144 | -122.44707774367399 | (37.7782946690144, -122.447077743674) | |||
| 7861 | 7861 | 8161 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1102 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6002408.427999999 | 2111279.278 | 37.7773063874437 | -122.43520419289699 | (37.7773063874437, -122.435204192897) | |||
| 8139 | 8139 | 26934 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1590 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6002010.1563 | 2111919.4162 | 37.7790414215793 | -122.436627772948 | (37.7790414215793, -122.436627772948) | |||
| 8574 | 8574 | 26199 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 871 Turk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6005870.33887 | 2112746.1622900004 | 37.7815300743983 | -122.42333261090799 | (37.7815300743983, -122.423332610908) | |||
| 8720 | 8720 | 22649 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1251 Turk St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6003938.1475 | 2112482.5866 | 37.7806971228818 | -122.429998257146 | (37.7806971228818, -122.429998257146) | |||
| 8980 | 8980 | 17002 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2028 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5999484.07976 | 2121214.10704 | 37.8044183160192 | -122.446035175776 | (37.8044183160192, -122.446035175776) | |||
| 9015 | 9015 | 22602 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 871 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6005851.84947 | 2112745.07106 | 37.78152603462821 | -122.423396497843 | (37.7815260346282, -122.423396497843) | |||
| 9021 | 9021 | 14488 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 303 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 5998978.3148 | 2111745.3393 | 37.778390691402 | -122.447103565775 | (37.778390691402, -122.447103565775) | |||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | |||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 20063 | 20063 | 19324 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 209 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 5993447.930369999 | 2089821.98942 | 37.717877226336604 | -122.46464272089099 | (37.7178772263366, -122.464642720891) | |||
| 20156 | 20156 | 3999 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 301 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002308.92816 | 2106431.24272 | 37.7639892295409 | -122.43520154760598 | (37.7639892295409, -122.435201547606) | |||
| 20559 | 20559 | 10046 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 380 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6005478.637490001 | 2106816.50174 | 37.765226545592604 | -122.424265853604 | (37.7652265455926, -122.424265853604) | |||
| 20922 | 20922 | 26259 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1536 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 3X3 | 6005857.34173 | 2100012.7812099997 | 37.7465664863671 | -122.422472519989 | (37.7465664863671, -122.422472519989) | |||
| 20935 | 20935 | 5168 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 301 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001743.2373 | 2109490.4691 | 37.7723569698475 | -122.437377176448 | (37.7723569698475, -122.437377176448) | |||
| 21504 | 21504 | 5727 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1677X Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 6005353.56233 | 2098539.50836 | 37.742492782318 | -122.424109780756 | (37.742492782318, -122.424109780756) | |||
| 21579 | 21579 | 17062 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1331 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000630.2617 | 2109590.1832 | 37.7725674241249 | -122.441234207963 | (37.7725674241249, -122.441234207963) | |||
| 21878 | 21878 | 28494 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 448 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 3X3 | 6007458.4187 | 2097228.942 | 37.7390128754438 | -122.416738967825 | (37.7390128754438, -122.416738967825) | |||
| 22036 | 22036 | 5724 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1673 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6005351.61965 | 2098567.02903 | 37.7425682381455 | -122.424118454716 | (37.7425682381455, -122.424118454716) | |||
| 22053 | 22053 | 26209 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 794X San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005562.046490001 | 2098516.05542 | 37.742440154891 | -122.423387236658 | (37.742440154891, -122.423387236658) | |||
| 22176 | 22176 | 26245 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1539 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005940.72977 | 2100031.08147 | 37.746621438530795 | -122.422185472598 | (37.7466214385308, -122.422185472598) | |||
| 22717 | 22717 | 9122 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5812 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 5988979.0954 | 2112675.0185 | 37.7803669476462 | -122.481762313457 | (37.7803669476462, -122.481762313457) | |||
| 23072 | 23072 | 23656 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 300 Virginia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 3X3 | 6006894.09507 | 2098285.17058 | 37.7418812873926 | -122.418765030684 | (37.7418812873926, -122.418765030684) | |||
| 23097 | 23097 | 24665 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4850 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | 5991933.61016 | 2112783.76885 | 37.7808369148225 | -122.471549293385 | (37.7808369148225, -122.471549293385) | ||||
| 23135 | 23135 | 9024 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5335 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | 3X3 | 5990401.7809 | 2112623.9395 | 37.7803093284395 | -122.47683690049801 | (37.7803093284395, -122.476836900498) | |||
| 23157 | 23157 | 16087 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 278 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | 0 | 6000249.694130001 | 2094706.57543 | 37.731678958116 | -122.441482409212 | (37.731678958116, -122.441482409212) | |||
| 23252 | 23252 | 22795 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1910 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | 3X3 | 6000839.4886 | 2112107.3676 | 37.7794908920615 | -122.440691060698 | (37.7794908920615, -122.440691060698) | |||
| 23285 | 23285 | 1681 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 405 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 5994319.83202 | 2111404.8234200003 | 37.7771884605269 | -122.46319416353901 | (37.7771884605269, -122.463194163539) | |||
| 23304 | 23304 | 24655 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 333 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 5 | 2X3 | 6006602.01583 | 2097861.4273599996 | 37.7407013336984 | -122.419744887942 | (37.7407013336984, -122.419744887942) | |||
| 23314 | 23314 | 25277 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1914 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | 3X3 | 5994096.5557 | 2092590.4338 | 37.7255160797575 | -122.46260143489401 | (37.7255160797575, -122.462601434894) | |||
| 23348 | 23348 | 12189 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1463 La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 6016268.9903 | 2095509.3837 | 37.7347829272824 | -122.38615592449699 | (37.7347829272824, -122.386155924497) | ||||
| 23474 | 23474 | 180020 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1800x Alemany Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 2ft | 6001294.8535400005 | 2091604.85507 | 37.7232218307036 | -122.437647038084 | (37.7232218307036, -122.437647038084) | |||
| 23615 | 23615 | 180300 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1500x Alemany Blvd | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6001840.8677900005 | 2092960.9802599999 | 37.7269764741671 | -122.43585655983 | (37.7269764741671, -122.43585655983) | |||
| 23923 | 23923 | 180093 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2200x Alemany Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 5999825.21966 | 2089601.0341900003 | 37.717636125294206 | -122.44258345996799 | (37.7176361252942, -122.442583459968) | |||
| 25341 | 25341 | 180280 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1204x Alemany Blvd | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6002728.35558 | 2094064.39346 | 37.730056572136704 | -122.432867327564 | (37.7300565721367, -122.432867327564) | |||
| 25355 | 25355 | 180096 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2200x Alemany Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 5999764.69095 | 2089543.44622 | 37.717474551281704 | -122.44278854676399 | (37.7174745512817, -122.442788546764) | |||
| 27182 | 27182 | 15918 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5688X Mission St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 3x3 | 5997918.76709 | 2086907.8121 | 37.710132296496894 | -122.44897927437799 | (37.7101322964969, -122.448979274378) | |||
| 27205 | 27205 | 180297 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1500x Alemany Blvd | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6001879.66047 | 2093045.2388099998 | 37.7272100325946 | -122.43572848019699 | (37.7272100325946, -122.435728480197) | |||
| 28906 | 28906 | 180049 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 2ft | 6000848.655230001 | 2090751.2328 | 37.7208525973406 | -122.439128305154 | (37.7208525973406, -122.439128305154) | |||
| 29276 | 29276 | 180062 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 29 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6000649.61116 | 2090402.60873 | 37.7198840266041 | -122.439791356397 | (37.7198840266041, -122.439791356397) | |||
| 30468 | 30468 | 180034 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1800x Alemany Blvd | 25 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6001097.83369 | 2091228.63345 | 37.7221776071819 | -122.43830115639601 | (37.7221776071819, -122.438301156396) | |||
| 31090 | 31090 | 180050 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6000834.87553 | 2090725.84202 | 37.7207820959038 | -122.43917411838801 | (37.7207820959038, -122.439174118388) | |||
| 31509 | 31509 | 180054 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 20 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 2ft | 6000783.664419999 | 2090626.8381700001 | 37.7205073395271 | -122.43934404620501 | (37.7205073395271, -122.439344046205) | |||
| 31681 | 31681 | 180089 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2100x Alemany Blvd | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 2ft | 5999997.23135 | 2089763.94995 | 37.7180932587717 | -122.442000582366 | (37.7180932587717, -122.442000582366) | |||
| 32210 | 32210 | 180306 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1604x Alemany Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6001696.41333 | 2092647.43732 | 37.7261073495475 | -122.436333505406 | (37.7261073495475, -122.436333505406) | |||
| 33314 | 33314 | 180058 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 25 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6000718.4568 | 2090503.6472599998 | 37.7201653741024 | -122.43956062093599 | (37.7201653741024, -122.439560620936) | |||
| 33418 | 33418 | 180274 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1204x Alemany Blvd | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6002921.14547 | 2094140.96014 | 37.7302777397151 | -122.432206295294 | (37.7302777397151, -122.432206295294) | |||
| 33919 | 33919 | 180071 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 43 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6000421.866669999 | 2090169.28245 | 37.719230399348795 | -122.440561861357 | (37.7192303993488, -122.440561861357) | |||
| 34228 | 34228 | 218724 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 600x Laguna Honda Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 3ft | 5995542.9319 | 2099985.30545 | 37.7459037813392 | -122.458136423557 | (37.7459037813392, -122.458136423557) | |||
| 34599 | 34599 | 180281 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1204x Alemany Blvd | 19 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6002702.132669999 | 2094050.3830099998 | 37.7300166152669 | -122.43295698278799 | (37.7300166152669, -122.432956982788) |
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");