Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude ▲ | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 110681 | 110681 | 114472 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2351 Powell St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009289.50209159 | 2121693.25395674 | 37.8062889786662 | -122.412136419392 | (37.8062889786662, -122.412136419392) | ||||
| 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) | |||
| 75280 | 75280 | 32302 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 181 Marina Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/1996 12:00:00 AM | 8 | Permit Number 36878 | 6002656.62056 | 2121625.04836 | 37.8057273053331 | -122.435085747319 | (37.8057273053331, -122.435085747319) | ||
| 26930 | 26930 | 136782 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 181 Marina Blvd | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 2ft | 6002679.8644199995 | 2121606.5592 | 37.8056778588023 | -122.435003985458 | (37.8056778588023, -122.435003985458) | |||
| 98799 | 98799 | 33971 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1250 Columbus Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/1997 12:00:00 AM | Permit Number 37917 | 6007661.76235911 | 2121488.31416717 | 37.8056348004683 | -122.417754973992 | (37.8056348004683, -122.417754973992) | |||
| 111890 | 111890 | 33969 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1250 Columbus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/1997 12:00:00 AM | Permit Number 37917 | 6007661.76235911 | 2121488.31416717 | 37.8056348004683 | -122.417754973992 | (37.8056348004683, -122.417754973992) | |||
| 125630 | 125630 | 33968 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1250 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/1997 12:00:00 AM | Permit Number 37917 | 6007661.76235911 | 2121488.31416717 | 37.8056348004683 | -122.417754973992 | (37.8056348004683, -122.417754973992) | |||
| 127946 | 127946 | 33970 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1250 Columbus Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/1997 12:00:00 AM | Permit Number 37917 | 6007661.76235911 | 2121488.31416717 | 37.8056348004683 | -122.417754973992 | (37.8056348004683, -122.417754973992) | |||
| 55926 | 55926 | 142646 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2390 Mason St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6008887.4874 | 2121395.0564 | 37.8054476382381 | -122.413506562572 | (37.8054476382381, -122.413506562572) | |||
| 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) | |||||
| 105839 | 105839 | 111718 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2390x MASON ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008938.0 | 2121373.0 | 37.8053899130211 | -122.41333019555799 | (37.8053899130211, -122.413330195558) | ||||
| 118045 | 118045 | 111717 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2390x MASON ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008938.0 | 2121373.0 | 37.8053899130211 | -122.41333019555799 | (37.8053899130211, -122.413330195558) | ||||
| 124354 | 124354 | 111716 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2390x MASON ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008938.0 | 2121373.0 | 37.8053899130211 | -122.41333019555799 | (37.8053899130211, -122.413330195558) | ||||
| 34508 | 34508 | 142644 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2370 Mason St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6008891.6098 | 2121361.5625 | 37.8053559038697 | -122.413489926105 | (37.8053559038697, -122.413489926105) | |||
| 188119 | 188119 | 142643 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2360 Mason St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6008894.7015 | 2121338.3744 | 37.8052924087646 | -122.413477585873 | (37.8052924087646, -122.413477585873) | |||
| 84465 | 84465 | 115077 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2371X MASON ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 6008645.0 | 2121254.0 | 37.805046714355505 | -122.414335738873 | (37.8050467143555, -122.414335738873) | |||
| 105314 | 105314 | 115075 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2371X MASON ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6008645.0 | 2121254.0 | 37.805046714355505 | -122.414335738873 | (37.8050467143555, -122.414335738873) | |||
| 144731 | 144731 | 115076 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2371X MASON ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 6008645.0 | 2121254.0 | 37.805046714355505 | -122.414335738873 | (37.8050467143555, -122.414335738873) | |||
| 133812 | 133812 | 41231 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3710 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/30/1999 12:00:00 AM | 7 | Permit Number 41936 | 6002578.78066 | 2121369.73196 | 37.805021853734395 | -122.435336848833 | (37.8050218537344, -122.435336848833) | |
| 58258 | 58258 | 71429 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2029 Stockton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1995 12:00:00 AM | 6 | 6009865.7372 | 2121062.537 | 37.8045895022466 | -122.41009769333401 | (37.8045895022466, -122.410097693334) | ||
| 175170 | 175170 | 103690 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 147 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | Permit Number 775299 | 6001175.90706 | 2121214.18027 | 37.804514981434004 | -122.440180480455 | (37.804514981434, -122.440180480455) | ||
| 184280 | 184280 | 62154 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2016 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/1985 12:00:00 AM | 12 | Permit Number 22268 | 5999531.3312099995 | 2121219.56404 | 37.804435997587206 | -122.445872051358 | (37.8044359975872, -122.445872051358) | |
| 25492 | 25492 | 62153 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2022 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/1985 12:00:00 AM | 10 | Permit Number 22267 | 5999519.37482 | 2121217.44002 | 37.804429482897795 | -122.44591327448 | (37.8044294828978, -122.44591327448) | |
| 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) | |||
| 32335 | 32335 | 62148 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2040 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/1985 12:00:00 AM | 11 | Permit Number 22262 | 5999472.96679 | 2121211.62683 | 37.804410871434705 | -122.446073454522 | (37.8044108714347, -122.446073454522) | |
| 53057 | 53057 | 136781 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2040 Jefferson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5999446.52046 | 2121208.2792 | 37.8044001694986 | -122.446164733036 | (37.8044001694986, -122.446164733036) | |||
| 149467 | 149467 | 249817 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1744 Kearny St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6010847.33897 | 2120972.58058 | 37.8043974733193 | -122.40669440752501 | (37.8043974733193, -122.406694407525) | |||
| 60993 | 60993 | 249816 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1744 Kearny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6010853.01699 | 2120942.1518 | 37.8043142410716 | -122.40667261246901 | (37.8043142410716, -122.406672612469) | |||
| 136502 | 136502 | 102611 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 370 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6010058.3307 | 2120952.6173 | 37.8042984828907 | -122.409423440249 | (37.8042984828907, -122.409423440249) | |||
| 171455 | 171455 | 142974 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 370 CHESTNUT ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6010046.6712 | 2120952.6173 | 37.8042978296071 | -122.409463789067 | (37.8042978296071, -122.409463789067) | |||
| 143766 | 143766 | 102612 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 376 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010060.0 | 2120948.0 | 37.804285898460606 | -122.409417337419 | (37.8042858984606, -122.409417337419) | ||||
| 168548 | 168548 | 62150 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2033 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/1985 12:00:00 AM | 11 | Permit Number 22264 | 5999463.73231 | 2121165.54346 | 37.8042838116209 | -122.44610209435699 | (37.8042838116209, -122.446102094357) | |
| 55240 | 55240 | 62149 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2037 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/1985 12:00:00 AM | 10 | Permit Number 22263 | 5999450.735230001 | 2121163.3015799997 | 37.8042769138086 | -122.446146910269 | (37.8042769138086, -122.446146910269) | |
| 60694 | 60694 | 40099 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 657 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/18/1999 12:00:00 AM | 5 | Permit Number 41324 | 6008068.7482 | 2120981.8075 | 37.8042669554254 | -122.416310639788 | (37.8042669554254, -122.416310639788) | ||
| 3769 | 3769 | 136887 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1001x Bay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6005802.0 | 2120854.0 | 37.8037883050638 | -122.424145815925 | (37.8037883050638, -122.424145815925) | |||
| 3772 | 3772 | 136889 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1001x Bay St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6005802.0 | 2120854.0 | 37.8037883050638 | -122.424145815925 | (37.8037883050638, -122.424145815925) | |||
| 3785 | 3785 | 136888 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1001x Bay St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6005802.0 | 2120854.0 | 37.8037883050638 | -122.424145815925 | (37.8037883050638, -122.424145815925) | |||
| 4211 | 4211 | 136890 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1001x Bay St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 01:59:00 PM | 3 | Width 3ft | 6005802.0 | 2120854.0 | 37.8037883050638 | -122.424145815925 | (37.8037883050638, -122.424145815925) | ||
| 183133 | 183133 | 51246 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 284 Mallorca Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/17/2004 12:00:00 AM | 1 | Permit Number 47621 | 6001433.6702 | 2120922.8086900003 | 37.803729624187795 | -122.43926757234199 | (37.8037296241878, -122.439267572342) | |
| 152876 | 152876 | 136783 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1739 North Point St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 6002414.55619 | 2120883.51152 | 37.80367749317671 | -122.435870354529 | (37.8036774931767, -122.435870354529) | |||
| 115020 | 115020 | 62157 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2158 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/1985 12:00:00 AM | 10 | Permit Number 22272 | 5999899.60106 | 2120922.78087 | 37.8036421318499 | -122.44457628206301 | (37.8036421318499, -122.444576282063) | |
| 157917 | 157917 | 136767 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3520 Baker St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5999224.40422 | 2120935.42639 | 37.8036383025204 | -122.44691373607799 | (37.8036383025204, -122.446913736078) | |||
| 174874 | 174874 | 72166 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2164 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/1985 12:00:00 AM | 10 | 5999887.26115 | 2120921.40259 | 37.803637643329296 | -122.444618885675 | (37.8036376433293, -122.444618885675) | ||
| 187695 | 187695 | 136785 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1307 Bay St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6004526.27681 | 2120824.48877 | 37.803635162995 | -122.428558424738 | (37.803635162995, -122.428558424738) | |||
| 153142 | 153142 | 50660 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 629 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/18/2007 12:00:00 AM | 4 | 3x3 | Permit Number 49797 | 6008816.5346 | 2120736.2648 | 37.8036347775517 | -122.41370547845301 | (37.8036347775517, -122.413705478453) | |
| 162798 | 162798 | 136784 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1307 Bay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6004497.53006 | 2120820.54002 | 37.803622693902994 | -122.42865762266399 | (37.803622693903, -122.428657622664) | |||
| 73582 | 73582 | 62006 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1307 Bay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/31/1985 12:00:00 AM | 7 | Permit Number 22075 | 6004472.06597 | 2120817.82099 | 37.8036137870071 | -122.428745548466 | (37.8036137870071, -122.428745548466) | |
| 58487 | 58487 | 136766 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3520 Baker St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5999225.95627 | 2120925.5493900003 | 37.8036112716175 | -122.44690765398799 | (37.8036112716175, -122.446907653988) | |||
| 174205 | 174205 | 62007 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1325 Bay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/31/1985 12:00:00 AM | 7 | Permit Number 22076 | 6004435.889909999 | 2120811.64656 | 37.8035947861208 | -122.42887029705099 | (37.8035947861208, -122.428870297051) | |
| 176384 | 176384 | 143017 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 655 CHESTNUT ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6008708.0589 | 2120716.6295 | 37.8035747718659 | -122.414079475338 | (37.8035747718659, -122.414079475338) | |||
| 70637 | 70637 | 62160 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2129 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/1985 12:00:00 AM | 10 | Permit Number 22275 | 6000012.6105 | 2120894.62285 | 37.8035712652717 | -122.444183183902 | (37.8035712652717, -122.444183183902) | |
| 158750 | 158750 | 143016 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 655 CHESTNUT ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6008680.5233 | 2120713.7091 | 37.803565206571605 | -122.414174557157 | (37.8035652065716, -122.414174557157) | |||
| 75222 | 75222 | 143023 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 665 Chestnut St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6008630.4585 | 2120708.2854 | 37.8035475022359 | -122.414347425317 | (37.8035475022359, -122.414347425317) | |||
| 168864 | 168864 | 143022 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 675 Chestnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6008611.267000001 | 2120705.7822 | 37.803539550993705 | -122.414413661372 | (37.8035395509937, -122.414413661372) | |||
| 188975 | 188975 | 143021 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 685 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6008591.686000001 | 2120703.4993 | 37.8035321827214 | -122.414481260898 | (37.8035321827214, -122.414481260898) | |||
| 63317 | 63317 | 72167 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2157 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/1985 12:00:00 AM | 9 | 5999876.3414900005 | 2120874.18187 | 37.8035073648317 | -122.444653277524 | (37.8035073648317, -122.444653277524) | ||
| 136386 | 136386 | 62156 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2165 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/1985 12:00:00 AM | 9 | Permit Number 22270 | 5999843.40545 | 2120869.57146 | 37.803492826395704 | -122.444766922157 | (37.8034928263957, -122.444766922157) | |
| 183237 | 183237 | 69345 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2226 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/15/1994 12:00:00 AM | 10 | Permit Number 33434 | 5999526.13299 | 2120869.58365 | 37.8034747491173 | -122.445864854104 | (37.8034747491173, -122.445864854104) | ||
| 133206 | 133206 | 41221 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 263 Mallorca Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/30/1999 12:00:00 AM | 7 | Permit Number 41928 | 6001414.86425 | 2120821.76469 | 37.80345111405 | -122.439325404156 | (37.80345111405, -122.439325404156) | |
| 45737 | 45737 | 41183 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2246 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/24/1999 12:00:00 AM | 9 | Permit Number 41901 | 5999456.41796 | 2120862.19039 | 37.803450468333295 | -122.44610557292101 | (37.8034504683333, -122.446105572921) | |
| 57777 | 57777 | 62155 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2252 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/1985 12:00:00 AM | 13 | Permit Number 22269 | 5999444.38711 | 2120859.49312 | 37.8034423753191 | -122.44614701188699 | (37.8034423753191, -122.446147011887) | |
| 6518 | 6518 | 97735 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1150 Francisco St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/22/2016 02:46:00 PM | 3 | 3x3 | Permit Number 50638 | 6005694.978999999 | 2120690.49004 | 37.8033333055591 | -122.424504530974 | (37.8033333055591, -122.424504530974) |
| 130128 | 130128 | 143054 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1731 EDGARDO PL | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6010429.028 | 2120490.458 | 37.8030502706615 | -122.40810799266599 | (37.8030502706615, -122.408107992666) | |||
| 114790 | 114790 | 35017 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 25 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/1997 12:00:00 AM | Permit Number 38592 | 6001951.42049088 | 2120655.30141734 | 37.803024569063 | -122.43745670493 | (37.803024569063, -122.43745670493) | |||
| 132863 | 132863 | 143055 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1729 Grant Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6010430.3624 | 2120468.8411 | 37.802990990701296 | -122.40810184949301 | (37.8029909907013, -122.408101849493) | |||
| 102781 | 102781 | 136780 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3601 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6000192.73269 | 2120677.0811400004 | 37.802984228305995 | -122.443544228184 | (37.802984228306, -122.443544228184) | |||
| 124227 | 124227 | 84608 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1307 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2008 12:00:00 AM | 3x3 | Permit Number 50841 | 6005059.05085072 | 2120549.16999723 | 37.8029093444786 | -122.426695114755 | (37.8029093444786, -122.426695114755) | ||
| 155972 | 155972 | 136786 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3099 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6005074.92093 | 2120531.1200599996 | 37.802860681226896 | -122.426638909965 | (37.8028606812269, -122.426638909965) | |||
| 146636 | 146636 | 136788 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3044 Franklin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6005143.48747 | 2120475.2029 | 37.8027110232569 | -122.426397650651 | (37.8027110232569, -122.426397650651) | |||
| 148305 | 148305 | 136787 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3044 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6005144.52223 | 2120466.04669 | 37.8026859411546 | -122.426393417542 | (37.8026859411546, -122.426393417542) | |||
| 97501 | 97501 | 82889 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1423 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 07/01/2009 12:00:00 AM | 3x3 | Permit Number 52339 | 6004509.13864627 | 2120473.3950974997 | 37.8026701808582 | -122.42859269053001 | (37.8026701808582, -122.42859269053) | ||
| 326 | 326 | 251270 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 853 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/2017 12:00:00 AM | 3 | 3x3 | 6008278.12362 | 2120317.86249 | 37.8024557006055 | -122.415539041664 | (37.8024557006055, -122.415539041664) | ||
| 149191 | 149191 | 136901 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2333 Leavenworth St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 6007536.47447 | 2120305.57509 | 37.8023802472184 | -122.41810464953001 | (37.8023802472184, -122.41810464953) | |||
| 72488 | 72488 | 143088 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 614 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6009954.5993 | 2120247.1152 | 37.8023555364086 | -122.40973258446002 | (37.8023555364086, -122.40973258446) | |||
| 188557 | 188557 | 143090 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 618 Greenwich St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6009917.0126 | 2120239.8067 | 37.802333362696096 | -122.40986213721901 | (37.8023333626961, -122.409862137219) | |||
| 59212 | 59212 | 136902 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2213 Jones St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6008039.36395 | 2120205.32059 | 37.8021332654887 | -122.41635729467 | (37.8021332654887, -122.41635729467) | |||
| 33551 | 33551 | 68970 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3420 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1994 12:00:00 AM | 5 | Permit Number 32960 | 5999798.8127 | 2120325.39323 | 37.8019961143897 | -122.444882095654 | (37.8019961143897, -122.444882095654) | |
| 180580 | 180580 | 83206 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3036-3038 Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52341 | 6004708.92286 | 2120041.8538599997 | 37.80149658417171 | -122.42787056837099 | (37.8014965841717, -122.427870568371) | |
| 41682 | 41682 | 83357 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3036-3038 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52341 | 6004710.71346 | 2120028.26822 | 37.80145938280221 | -122.427863403488 | (37.8014593828022, -122.427863403488) | |
| 144774 | 144774 | 81924 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2564X Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/2008 12:00:00 AM | 3x3 | Permit Number 50755 | 6006664.346336401 | 2119981.34630043 | 37.8014408715731 | -122.421099611614 | (37.8014408715731, -122.421099611614) | ||
| 178328 | 178328 | 136886 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2655 Polk St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 2ft | 6006127.922230001 | 2119929.33879 | 37.801267818202895 | -122.422952183303 | (37.8012678182029, -122.422952183303) | |||
| 179115 | 179115 | 136897 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2507 Larkin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6006673.651330001 | 2119907.5833799997 | 37.80123886184 | -122.421062171681 | (37.80123886184, -122.421062171681) | |||
| 25392 | 25392 | 136765 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3248 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5999349.57703 | 2120035.43346 | 37.801174314804 | -122.446415785968 | (37.801174314804, -122.446415785968) | |||
| 79591 | 79591 | 81923 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2524X Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50824 | 6006683.22400402 | 2119851.76004091 | 37.801086124719895 | -122.421025080133 | (37.8010861247199, -122.421025080133) | ||
| 163202 | 163202 | 84626 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3348 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50854 | 6000840.939619999 | 2119902.06373 | 37.8008931831302 | -122.441245461216 | (37.8008931831302, -122.441245461216) | |
| 68062 | 68062 | 136891 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1317 Greenwich St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6006598.09728 | 2119723.5928599997 | 37.8007294111786 | -122.42131054914499 | (37.8007294111786, -122.421310549145) | |||
| 59827 | 59827 | 142484 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 504 Union St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6010505.5827 | 2119623.6166 | 37.8006744234406 | -122.407781912389 | (37.8006744234406, -122.407781912389) | |||
| 59399 | 59399 | 42680 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1400 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 4 | Permit Number 42705 | 6006144.13607 | 2119711.1736 | 37.800669706999 | -122.42288056219401 | (37.800669706999, -122.422880562194) | |
| 56123 | 56123 | 42681 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1400 Greenwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 6 | Permit Number 42705 | 6006130.25606 | 2119709.67411 | 37.800664806599606 | -122.422928486179 | (37.8006648065996, -122.422928486179) | |
| 65117 | 65117 | 136908 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1354 Kearny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6011043.96779 | 2119574.14237 | 37.8005687041424 | -122.40591538151699 | (37.8005687041424, -122.405915381517) | |||
| 55237 | 55237 | 66137 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3248 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/28/2006 12:00:00 AM | 5 | Permit Number 29200 | 5999873.32355 | 2119767.0762400003 | 37.8004673775197 | -122.444584102586 | (37.8004673775197, -122.444584102586) | |
| 677 | 677 | 107511 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2141 Chestnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/18/2014 12:00:00 AM | 3 | 3x3 | 6001625.68296 | 2119729.38155 | 37.8004637136911 | -122.43851754404601 | (37.8004637136911, -122.438517544046) | ||
| 81419 | 81419 | 87956 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3250 Broderick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 50982 | 5999898.4 | 2119763.0 | 37.800457616115 | -122.44449703515 | (37.800457616115, -122.44449703515) | ||
| 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) | ||
| 53510 | 53510 | 136776 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2600 Richardson Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 5999020.04225 | 2119778.41485 | 37.8004497840758 | -122.447537603903 | (37.8004497840758, -122.447537603903) | ||||
| 151784 | 151784 | 136774 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2600 Francisco St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 5999022.27584 | 2119774.26108 | 37.800438506586204 | -122.447529575653 | (37.8004385065862, -122.447529575653) | ||||
| 27243 | 27243 | 136775 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2600 Francisco St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 5999017.84714 | 2119772.0428299997 | 37.8004321627783 | -122.447544740905 | (37.8004321627783, -122.447544740905) | ||||
| 85439 | 85439 | 87069 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2268 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/2007 12:00:00 AM | 3x3 | Permit Number 50010 | 6001029.8 | 2119730.0 | 37.8004314980305 | -122.44057957797399 | (37.8004314980305, -122.440579577974) | ||
| 76925 | 76925 | 40166 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3031 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/2002 12:00:00 AM | 8 | 6x6 | Permit Number 41359 | 6004240.20521 | 2119600.37832 | 37.800257879547296 | -122.429461041019 | (37.8002578795473, -122.429461041019) |
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");