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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7239 | 7239 | 28357 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3060 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2003 12:00:00 AM | 3 | 3X3 | 6000153.01588 | 2115483.23318 | 37.7887210301107 | -122.44330839538601 | (37.7887210301107, -122.443308395386) | ||
| 7243 | 7243 | 116776 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1106 Pacific Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/2016 12:00:00 AM | 3 | 3x3 | 6008776.88904 | 2117992.21481 | 37.7960980717264 | -122.41364847189399 | (37.7960980717264, -122.413648471894) | ||
| 7304 | 7304 | 117114 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1650 Broadway | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/07/2016 12:00:00 AM | 3 | 3x3 | Permit Number 773961 | 6005648.88243 | 2117910.88116 | 37.7956986045686 | -122.42446621984399 | (37.7956986045686, -122.424466219844) | |
| 7307 | 7307 | 7835 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 880 Franklin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/16/1994 12:00:00 AM | 6 | 4x4 | 6006172.94925 | 2113057.71328 | 37.782402591234295 | -122.42230786493099 | (37.7824025912343, -122.422307864931) | ||
| 7363 | 7363 | 26659 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 522 Fell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/1999 12:00:00 AM | 3 | 3X3 | 6004893.91605 | 2110587.9747 | 37.7755490656586 | -122.42655684321998 | (37.7755490656586, -122.42655684322) | ||
| 7390 | 7390 | 24488 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 730 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/1995 12:00:00 AM | 6 | 3X3 | 6003912.5381 | 2110447.8419 | 37.7751087667975 | -122.42994166795 | (37.7751087667975, -122.42994166795) | ||
| 7415 | 7415 | 18997 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3006 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/17/2007 12:00:00 AM | 3 | 3X3PL | 6000330.42565 | 2115511.74748 | 37.7888094379519 | -122.44269663335301 | (37.7888094379519, -122.442696633353) | ||
| 7435 | 7435 | 14489 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 303 Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 5998982.1627 | 2111728.505 | 37.7783446886067 | -122.447089042698 | (37.7783446886067, -122.447089042698) | |||
| 7462 | 7462 | 6063 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1913 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4X4 | 6001160.8022 | 2112439.8243 | 37.780422026336495 | -122.43960334291 | (37.7804220263365, -122.43960334291) | |||
| 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) | |||
| 7561 | 7561 | 2191 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1059 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/09/1998 12:00:00 AM | 6 | 4X4 | 6000860.0298 | 2112380.5159 | 37.780242057456704 | -122.440639597689 | (37.7802420574567, -122.440639597689) | ||
| 7575 | 7575 | 14521 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 610 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 5999188.9854 | 2110718.1832 | 37.7755824190107 | -122.446300870977 | (37.7755824190107, -122.446300870977) | |||
| 7695 | 7695 | 6060 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1909 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4X4 | 6001215.6265 | 2112445.5775 | 37.780440943348395 | -122.439414092915 | (37.7804409433484, -122.439414092915) | |||
| 7708 | 7708 | 7838 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 880 Franklin St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 4x4 | 6006162.87093 | 2113106.46808 | 37.7825358914721 | -122.422346196719 | (37.7825358914721, -122.422346196719) | |||
| 7711 | 7711 | 67618 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1440 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/14/1992 12:00:00 AM | 8 | 3x3 | Permit Number 31199 | 6006039.45477 | 2119353.8599099996 | 37.7996827073455 | -122.42321738978701 | (37.7996827073455, -122.423217389787) | |
| 7735 | 7735 | 116777 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1106 Pacific Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/2016 12:00:00 AM | 3 | 3x3 | 6008763.52683 | 2117990.43413 | 37.796092432072705 | -122.41369458194099 | (37.7960924320727, -122.413694581941) | ||
| 7756 | 7756 | 105526 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 228 Collins St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5998177.9524 | 2112999.2356 | 37.781787802518004 | -122.449962699898 | (37.781787802518, -122.449962699898) | |||
| 7799 | 7799 | 36854 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 7808 | 7808 | 6061 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1909 Eddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4X4 | 6001229.8402 | 2112447.2696 | 37.7804463983122 | -122.43936504248998 | (37.7804463983122, -122.43936504249) | |||
| 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) | |||
| 7880 | 7880 | 22767 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1686 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/05/2003 12:00:00 AM | 3 | 4X4 | 6001987.8205 | 2112260.207 | 37.779975877853296 | -122.43672944267401 | (37.7799758778533, -122.436729442674) | ||
| 7890 | 7890 | 6910 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 368 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/07/1995 12:00:00 AM | 6 | 3X3 | 6005671.181 | 2110697.5154 | 37.7758937479577 | -122.423875883731 | (37.7758937479577, -122.423875883731) | ||
| 7925 | 7925 | 22616 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1001 Turk St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3x5 | 6005581.297 | 2112717.6262 | 37.7814354041528 | -122.424330527926 | (37.7814354041528, -122.424330527926) | |||
| 7974 | 7974 | 14529 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 650 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 5999204.1149 | 2110576.3883 | 37.775193950570795 | -122.446238332395 | (37.7751939505708, -122.446238332395) | |||
| 8018 | 8018 | 18995 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3004 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2006 12:00:00 AM | 3 | 3X3PL | 6000360.72117 | 2115511.4863299998 | 37.7888104478801 | -122.44259179667101 | (37.7888104478801, -122.442591796671) | ||
| 8023 | 8023 | 93398 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2299 Turk Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/09/2008 12:00:00 AM | 3 | 3x3 | 5999064.1945 | 2111800.6301 | 37.778547412076605 | -122.446810456436 | (37.7785474120766, -122.446810456436) | ||
| 8068 | 8068 | 106333 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 319 Locust St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5997602.34127 | 2115286.79464 | 37.7880358825085 | -122.452119136194 | (37.7880358825085, -122.452119136194) | |||
| 8074 | 8074 | 8671 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2900 Geary Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/22/1996 12:00:00 AM | 7 | 3X3 | 5998027.8623 | 2113153.3867 | 37.7822024719051 | -122.450493055338 | (37.7822024719051, -122.450493055338) | ||
| 8119 | 8119 | 93480 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1356- 1360 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2014 12:00:00 AM | 12 | 3x2 | Permit Number 770976 | 6008293.467119999 | 2116608.96674 | 37.7922728557673 | -122.415223246858 | (37.7922728557673, -122.415223246858) | |
| 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) | |||
| 8179 | 8179 | 7828 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 828 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4x4 | 6006198.01452 | 2112875.51126 | 37.7819037229178 | -122.422208201166 | (37.7819037229178, -122.422208201166) | |||
| 8202 | 8202 | 22736 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1560 Turk St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/07/2005 12:00:00 AM | 3 | 3X3 | 6002447.5665 | 2112328.3989 | 37.7801892327397 | -122.435143856223 | (37.7801892327397, -122.435143856223) | ||
| 8291 | 8291 | 7837 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 880 Franklin St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4x4 | 6006168.41514 | 2113088.70054 | 37.78248741890079 | -122.42232575333401 | (37.7824874189008, -122.422325753334) | |||
| 8323 | 8323 | 8158 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1086 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/09/2007 12:00:00 AM | 3 | 3X3 | 6002587.9005 | 2111305.7426 | 37.7773892425571 | -122.434585232983 | (37.7773892425571, -122.434585232983) | ||
| 8334 | 8334 | 103272 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 989 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/08/2013 12:00:00 AM | 3 | 3x3 | Permit Number 770109 | 6007882.34676 | 2115110.89774 | 37.7881364123041 | -122.416539570166 | (37.7881364123041, -122.416539570166) | |
| 8505 | 8505 | 7836 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 880 Franklin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4x4 | 6006170.38861 | 2113076.8908 | 37.7824551035672 | -122.422318086628 | (37.7824551035672, -122.422318086628) | |||
| 8523 | 8523 | 107510 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2141 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/18/2014 12:00:00 AM | 3 | 3x3 | 6001605.27547 | 2119726.96625 | 37.8004559210497 | -122.438587988867 | (37.8004559210497, -122.438587988867) | ||
| 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) | |||
| 8615 | 8615 | 29734 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 644 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/2006 12:00:00 AM | 6 | 3x3 | 6009872.4617 | 2119193.0537 | 37.7994567403911 | -122.40994236951299 | (37.7994567403911, -122.409942369513) | ||
| 8662 | 8662 | 52583 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1047 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/24/2006 12:00:00 AM | 4 | 3x3 | Permit Number 48677 | 6009673.58749 | 2117095.63602 | 37.7936865972027 | -122.41048236278499 | (37.7936865972027, -122.410482362785) | |
| 8684 | 8684 | 68184 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 228 Collins St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/1993 12:00:00 AM | 7 | 3x3 | Permit Number 31957 | 5998180.4906 | 2112978.761 | 37.7817317298509 | -122.44995244286899 | (37.7817317298509, -122.449952442869) | |
| 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) | |||
| 8765 | 8765 | 116774 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1106 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/2016 12:00:00 AM | 3 | 3x3 | 6008811.215480001 | 2117995.14613 | 37.7961080479024 | -122.413529902601 | (37.7961080479024, -122.413529902601) | ||
| 8869 | 8869 | 18295 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2000 Post St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/20/1992 12:00:00 AM | 6 | 4X4 | 6002211.6561 | 2114031.8723 | 37.7848531404575 | -122.43608191019699 | (37.7848531404575, -122.436081910197) | ||
| 8943 | 8943 | 116775 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1106 Pacific Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/2016 12:00:00 AM | 3 | 3x3 | 6008794.04431 | 2117993.28546 | 37.79610197478279 | -122.413589186808 | (37.7961019747828, -122.413589186808) | ||
| 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) | |||
| 9000 | 9000 | 29738 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 656 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/2006 12:00:00 AM | 6 | 3x3 | 6009848.563999999 | 2119190.8307 | 37.7994492972084 | -122.410024907374 | (37.7994492972084, -122.410024907374) | ||
| 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) | |||
| 9099 | 9099 | 36836 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 9136 | 9136 | 29088 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2240 Bryant St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/2006 12:00:00 AM | 3 | 3x3 | 6009623.3077784 | 2104292.1140535 | 37.7585283102663 | -122.40975216800501 | (37.7585283102663, -122.409752168005) | ||
| 9142 | 9142 | 4534 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 65 Cleary Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3X3 | 6004810.0812 | 2113642.485 | 37.783931258626396 | -122.42706445579901 | (37.7839312586264, -122.427064455799) | |||
| 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) | |||
| 9189 | 9189 | 29087 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2240 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/2006 12:00:00 AM | 3 | 3x3 | 6009623.3077784 | 2104292.1140535 | 37.7585283102663 | -122.40975216800501 | (37.7585283102663, -122.409752168005) | ||
| 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) | |||
| 9282 | 9282 | 14446 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 Masonic Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/11/2012 12:00:00 AM | 3 | 3x3 | 5998938.7246 | 2112487.711 | 37.780426790070706 | -122.44729396725201 | (37.7804267900707, -122.447293967252) | ||
| 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) | |||
| 9328 | 9328 | 10963 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1431 Hudson Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1998 12:00:00 AM | 3 | 3X4 | 6016563.2925523 | 2096760.0557493 | 37.7382333059102 | -122.385225528118 | (37.7382333059102, -122.385225528118) | ||
| 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) | |||
| 9340 | 9340 | 26223 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 765X San Jose Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/2009 12:00:00 AM | 3 | 3X3 | 6005700.4508028 | 2098660.5880909 | 37.742844819447896 | -122.42291894531799 | (37.7428448194479, -122.422918945318) | ||
| 9350 | 9350 | 72948 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 510 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/20/1999 12:00:00 AM | 3 | 6004536.11910305 | 2110188.83574422 | 37.7744328940259 | -122.427766104146 | (37.7744328940259, -122.427766104146) | |||
| 9351 | 9351 | 29078 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2265 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/2006 12:00:00 AM | 4 | 3x3 | 6009683.3465759 | 2104161.2014379 | 37.758172218127704 | -122.40953528653 | (37.7581722181277, -122.40953528653) | ||
| 9380 | 9380 | 12155 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1400X La Salle Ave | 35 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6016212.874009999 | 2095683.59001 | 37.7352581567374 | -122.38636208157301 | (37.7352581567374, -122.386362081573) | ||
| 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) | |||
| 9394 | 9394 | 19116 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 507X Duboce Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/10/2001 12:00:00 AM | 20 | 3X3 | 6003392.0492998 | 2108320.088346 | 37.769236987964604 | -122.431590213757 | (37.7692369879646, -122.431590213757) | ||
| 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) | |||
| 9439 | 9439 | 995 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1682 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/12/2011 12:00:00 AM | 3 | 4x4 | 6001498.326169999 | 2092340.4216099998 | 37.725253096867206 | -122.436996309494 | (37.7252530968672, -122.436996309494) | ||
| 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) | |||
| 9484 | 9484 | 29081 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2230 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/2006 12:00:00 AM | 6 | 3x3 | 6009630.0 | 2104353.0 | 37.7586958643533 | -122.409733320805 | (37.7586958643533, -122.409733320805) | ||
| 9487 | 9487 | 2233 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1217 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/25/1993 12:00:00 AM | 9 | 4X4 | 6000793.5299 | 2112868.6894 | 37.781578670102704 | -122.440904680944 | (37.7815786701027, -122.440904680944) | ||
| 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) | |||
| 9535 | 9535 | 36839 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 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) | ||
| 9660 | 9660 | 87030 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 98 Brady St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/10/2007 12:00:00 AM | 2 | 3x3 | Permit Number 49973 | 6006766.5 | 2109389.9 | 37.7723651233427 | -122.419994070446 | (37.7723651233427, -122.419994070446) | |
| 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) | |||
| 9770 | 9770 | 151746 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3030 17th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779245 | 6008502.962040001 | 2106251.6003 | 37.763845762487 | -122.413765441348 | (37.763845762487, -122.413765441348) | |
| 9771 | 9771 | 159357 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 49 Naglee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 776198 | 5998577.1355099995 | 2087591.01668 | 37.7120458522191 | -122.446752958004 | (37.7120458522191, -122.446752958004) | |
| 9781 | 9781 | 36044 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3030 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779245 | 6008531.98185334 | 2106261.58493121 | 37.763874807614606 | -122.413665776536 | (37.7638748076146, -122.413665776536) | |
| 9795 | 9795 | 108228 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 390x TREAT AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779245 | 6008492.0 | 2106262.0 | 37.763873702058 | -122.413804091523 | (37.763873702058, -122.413804091523) | |
| 9796 | 9796 | 11975 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1200X La Salle Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2016 02:52:00 PM | 3 | 3X3 | 6017464.4799176 | 2094331.6246005 | 37.731615128467496 | -122.381940767084 | (37.7316151284675, -122.381940767084) | ||
| 9807 | 9807 | 36045 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3030 17th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779245 | 6008531.98185334 | 2106261.58493121 | 37.763874807614606 | -122.413665776536 | (37.7638748076146, -122.413665776536) | |
| 9877 | 9877 | 28444 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1995 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 3 | 3X3 | 5993681.5609 | 2092723.2933 | 37.725856971051 | -122.464045665001 | (37.725856971051, -122.464045665001) | ||
| 9905 | 9905 | 136907 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 352 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/06/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779330 | 6011790.69425 | 2119110.61996 | 37.7993377175325 | -122.40329876353901 | (37.7993377175325, -122.403298763539) | |
| 9964 | 9964 | 173762 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1405 Van Dyke Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/17/2017 12:00:00 AM | 3 | 3x3 | Permit Number 773007 | 6015436.02818 | 2092717.7192900002 | 37.727071439337 | -122.388840955894 | (37.727071439337, -122.388840955894) | |
| 9965 | 9965 | 173761 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1405 Van Dyke Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/17/2017 12:00:00 AM | 3 | 3x3 | Permit Number 773007 | 6015436.02818 | 2092717.7192900002 | 37.727071439337 | -122.388840955894 | (37.727071439337, -122.388840955894) | |
| 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) | |||
| 10048 | 10048 | 8607 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2428 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/01/2013 12:00:00 AM | 3 | 3x3 | 6000088.3544 | 2113383.7236 | 37.7829526339517 | -122.443381249115 | (37.7829526339517, -122.443381249115) | ||
| 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) | ||||
| 10142 | 10142 | 10120 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 851 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/30/2006 12:00:00 AM | 3 | 3X3 | 6005704.55717 | 2103950.70668 | 37.7573705007718 | -122.42328071642599 | (37.7573705007718, -122.423280716426) |
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");