trees
7,322 rows where qSpecies_id = 1 sorted by YCoord descending
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord ▲ | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 87422 | 136910 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2210 Stockton St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | Width 3ft | 6009806.2153 | 2121790.84358 | 37.8065859141719 | -122.410355131177 | (37.8065859141719, -122.410355131177) | 3 | 1 | 10 | 308 | 23 | |||
| 146936 | 114472 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2351 Powell St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009289.50209159 | 2121693.25395674 | 37.8062889786662 | -122.412136419392 | (37.8062889786662, -122.412136419392) | 3 | 1 | 10 | 308 | 23 | ||||
| 4334 | 136909 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2210 Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | Width 3ft | 6009830.0684 | 2121639.18274 | 37.8061708284786 | -122.410261867902 | (37.8061708284786, -122.410261867902) | 3 | 1 | 10 | 308 | 23 | |||
| 35176 | 32302 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 181 Marina Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/1996 12:00:00 AM | 8 | Permit Number 36878 | 6002656.62056 | 2121625.04836 | 37.8057273053331 | -122.435085747319 | (37.8057273053331, -122.435085747319) | 13 | 9 | 1 | 57 | 17 | ||
| 126374 | 136782 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 181 Marina Blvd | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 2ft | 6002679.86442 | 2121606.5592 | 37.8056778588023 | -122.435003985458 | (37.8056778588023, -122.435003985458) | 13 | 9 | 1 | 57 | 17 | |||
| 24352 | 124853 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 55 Casa Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 05/25/2018 12:00:00 AM | 3 | Width 3ft | Permit Number 781938 | 6001524.844 | 2121579.60518 | 37.8055382003848 | -122.43899915981 | (37.8055382003848, -122.43899915981) | 13 | 9 | 1 | 57 | 17 | |
| 18525 | 128025 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2601 Jones St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/27/2018 12:00:00 AM | 3 | Width 4ft | 6007851.19839 | 2121552.20369 | 37.8058208834027 | -122.41710393162 | (37.8058208834027, -122.41710393162) | 5 | 1 | 10 | 308 | 23 | ||
| 35057 | 33968 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1250 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/1997 12:00:00 AM | Permit Number 37917 | 6007661.76235911 | 2121488.31416717 | 37.8056348004683 | -122.417754973992 | (37.8056348004683, -122.417754973992) | 5 | 1 | 10 | 308 | 23 | |||
| 36238 | 33970 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1250 Columbus Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/1997 12:00:00 AM | Permit Number 37917 | 6007661.76235911 | 2121488.31416717 | 37.8056348004683 | -122.417754973992 | (37.8056348004683, -122.417754973992) | 5 | 1 | 10 | 308 | 23 | |||
| 110671 | 33971 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1250 Columbus Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/1997 12:00:00 AM | Permit Number 37917 | 6007661.76235911 | 2121488.31416717 | 37.8056348004683 | -122.417754973992 | (37.8056348004683, -122.417754973992) | 5 | 1 | 10 | 308 | 23 | |||
| 133052 | 33969 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1250 Columbus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/1997 12:00:00 AM | Permit Number 37917 | 6007661.76235911 | 2121488.31416717 | 37.8056348004683 | -122.417754973992 | (37.8056348004683, -122.417754973992) | 5 | 1 | 10 | 308 | 23 | |||
| 4454 | 128029 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2601 Jones St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/27/2018 12:00:00 AM | 3 | Width 4ft | 6007868.73718 | 2121431.95 | 37.8054916838703 | -122.417034709883 | (37.8054916838703, -122.417034709883) | 5 | 1 | 10 | 308 | 23 | ||
| 162424 | 142646 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2390 Mason St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6008887.4874 | 2121395.0564 | 37.8054476382381 | -122.413506562572 | (37.8054476382381, -122.413506562572) | 3 | 1 | 10 | 308 | 23 | |||
| 19436 | 128031 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2601 Jones St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/2019 12:00:00 AM | 3 | Width 4ft | 6007875.63102 | 2121383.54419 | 37.8053591615717 | -122.417007420861 | (37.8053591615717, -122.417007420861) | 5 | 1 | 10 | 308 | 23 | ||
| 183626 | 142645 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2380 Mason St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008890.0639 | 2121379.5977 | 37.805405337199 | -122.41349655223 | (37.805405337199, -122.41349655223) | 3 | 1 | 10 | 308 | 23 | |||||
| 28490 | 111716 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2390x MASON ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008938 | 2121373 | 37.8053899130211 | -122.413330195558 | (37.8053899130211, -122.413330195558) | 3 | 1 | 10 | 308 | 23 | ||||
| 115497 | 111718 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2390x MASON ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008938 | 2121373 | 37.8053899130211 | -122.413330195558 | (37.8053899130211, -122.413330195558) | 3 | 1 | 10 | 308 | 23 | ||||
| 152945 | 111717 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2390x MASON ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008938 | 2121373 | 37.8053899130211 | -122.413330195558 | (37.8053899130211, -122.413330195558) | 3 | 1 | 10 | 308 | 23 | ||||
| 190945 | 41231 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3710 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/30/1999 12:00:00 AM | 7 | Permit Number 41936 | 6002578.78066 | 2121369.73196 | 37.8050218537344 | -122.435336848833 | (37.8050218537344, -122.435336848833) | 13 | 9 | 1 | 57 | 17 | |
| 186384 | 142644 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2370 Mason St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6008891.6098 | 2121361.5625 | 37.8053559038697 | -122.413489926105 | (37.8053559038697, -122.413489926105) | 3 | 1 | 10 | 308 | 23 | |||
| 24670 | 142643 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2360 Mason St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6008894.7015 | 2121338.3744 | 37.8052924087646 | -122.413477585873 | (37.8052924087646, -122.413477585873) | 3 | 1 | 10 | 308 | 23 | |||
| 52839 | 115077 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2371X MASON ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 6008645 | 2121254 | 37.8050467143555 | -122.414335738873 | (37.8050467143555, -122.414335738873) | 3 | 1 | 10 | 308 | 23 | |||
| 118895 | 115075 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2371X MASON ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6008645 | 2121254 | 37.8050467143555 | -122.414335738873 | (37.8050467143555, -122.414335738873) | 3 | 1 | 10 | 308 | 23 | |||
| 184869 | 115076 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2371X MASON ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 6008645 | 2121254 | 37.8050467143555 | -122.414335738873 | (37.8050467143555, -122.414335738873) | 3 | 1 | 10 | 308 | 23 | |||
| 7078 | 62154 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2016 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/04/1985 12:00:00 AM | 12 | Permit Number 22268 | 5999531.33121 | 2121219.56404 | 37.8044359975872 | -122.445872051358 | (37.8044359975872, -122.445872051358) | 13 | 9 | 1 | 57 | 17 | |
| 17970 | 62153 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2022 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/04/1985 12:00:00 AM | 10 | Permit Number 22267 | 5999519.37482 | 2121217.44002 | 37.8044294828978 | -122.44591327448 | (37.8044294828978, -122.44591327448) | 13 | 9 | 1 | 57 | 17 | |
| 5918 | 103690 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 147 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | Permit Number 775299 | 6001175.90706 | 2121214.18027 | 37.804514981434 | -122.440180480455 | (37.804514981434, -122.440180480455) | 13 | 9 | 1 | 57 | 17 | ||
| 189768 | 17002 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2028 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 5999484.07976 | 2121214.10704 | 37.8044183160192 | -122.446035175776 | (37.8044183160192, -122.446035175776) | 13 | 9 | 1 | 57 | 17 | |||
| 15266 | 62148 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2040 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/06/1985 12:00:00 AM | 11 | Permit Number 22262 | 5999472.96679 | 2121211.62683 | 37.8044108714347 | -122.446073454522 | (37.8044108714347, -122.446073454522) | 13 | 9 | 1 | 57 | 17 | |
| 99980 | 136781 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2040 Jefferson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5999446.52046 | 2121208.2792 | 37.8044001694986 | -122.446164733036 | (37.8044001694986, -122.446164733036) | 13 | 9 | 1 | 57 | 17 | |||
| 7240 | 62150 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2033 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/06/1985 12:00:00 AM | 11 | Permit Number 22264 | 5999463.73231 | 2121165.54346 | 37.8042838116209 | -122.446102094357 | (37.8042838116209, -122.446102094357) | 13 | 9 | 1 | 57 | 17 | |
| 17596 | 62149 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2037 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/06/1985 12:00:00 AM | 10 | Permit Number 22263 | 5999450.73523 | 2121163.30158 | 37.8042769138086 | -122.446146910269 | (37.8042769138086, -122.446146910269) | 13 | 9 | 1 | 57 | 17 | |
| 5314 | 71429 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2029 Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6009865.7372 | 2121062.537 | 37.8045895022466 | -122.410097693334 | (37.8045895022466, -122.410097693334) | 3 | 1 | 10 | 308 | 23 | |||
| 172996 | 40099 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 657 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/18/1999 12:00:00 AM | 5 | Permit Number 41324 | 6008068.7482 | 2120981.8075 | 37.8042669554254 | -122.416310639788 | (37.8042669554254, -122.416310639788) | 5 | 1 | 10 | 308 | 32 | ||
| 118142 | 249817 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1744 Kearny St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6010847.33897 | 2120972.58058 | 37.8043974733193 | -122.406694407525 | (37.8043974733193, -122.406694407525) | 3 | 1 | 10 | 308 | 23 | |||
| 139907 | 102611 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 370 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6010058.3307 | 2120952.6173 | 37.8042984828907 | -122.409423440249 | (37.8042984828907, -122.409423440249) | 3 | 1 | 10 | 308 | 23 | |||
| 163799 | 142974 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 370 CHESTNUT ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6010046.6712 | 2120952.6173 | 37.8042978296071 | -122.409463789067 | (37.8042978296071, -122.409463789067) | 3 | 1 | 10 | 308 | 23 | |||
| 188825 | 102612 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 376 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010060 | 2120948 | 37.8042858984606 | -122.409417337419 | (37.8042858984606, -122.409417337419) | 3 | 1 | 10 | 308 | 23 | ||||
| 38230 | 249816 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1744 Kearny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6010853.01699 | 2120942.1518 | 37.8043142410716 | -122.406672612469 | (37.8043142410716, -122.406672612469) | 3 | 1 | 10 | 308 | 23 | |||
| 16665 | 136767 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3520 Baker St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5999224.40422 | 2120935.42639 | 37.8036383025204 | -122.446913736078 | (37.8036383025204, -122.446913736078) | 13 | 9 | 1 | 57 | 17 | |||
| 141113 | 136766 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3520 Baker St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5999225.95627 | 2120925.54939 | 37.8036112716175 | -122.446907653988 | (37.8036112716175, -122.446907653988) | 13 | 9 | 1 | 57 | 17 | |||
| 86326 | 51246 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 284 Mallorca Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/17/2004 12:00:00 AM | 1 | Permit Number 47621 | 6001433.6702 | 2120922.80869 | 37.8037296241878 | -122.439267572342 | (37.8037296241878, -122.439267572342) | 13 | 9 | 1 | 57 | 17 | |
| 6711 | 62157 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2158 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/04/1985 12:00:00 AM | 10 | Permit Number 22272 | 5999899.60106 | 2120922.78087 | 37.8036421318499 | -122.444576282063 | (37.8036421318499, -122.444576282063) | 13 | 9 | 1 | 57 | 17 | |
| 5090 | 72166 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2164 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 5999887.26115 | 2120921.40259 | 37.8036376433293 | -122.444618885675 | (37.8036376433293, -122.444618885675) | 13 | 9 | 1 | 57 | 17 | |||
| 10039 | 62160 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2129 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/04/1985 12:00:00 AM | 10 | Permit Number 22275 | 6000012.6105 | 2120894.62285 | 37.8035712652717 | -122.444183183902 | (37.8035712652717, -122.444183183902) | 13 | 9 | 1 | 57 | 17 | |
| 104783 | 136783 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1739 North Point St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 6002414.55619 | 2120883.51152 | 37.8036774931767 | -122.435870354529 | (37.8036774931767, -122.435870354529) | 13 | 9 | 1 | 57 | 17 | |||
| 4362 | 72167 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2157 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 5999876.34149 | 2120874.18187 | 37.8035073648317 | -122.444653277524 | (37.8035073648317, -122.444653277524) | 13 | 9 | 1 | 57 | 17 | |||
| 96528 | 69345 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2226 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/15/1994 12:00:00 AM | 10 | Permit Number 33434 | 5999526.13299 | 2120869.58365 | 37.8034747491173 | -122.445864854104 | (37.8034747491173, -122.445864854104) | 13 | 9 | 1 | 57 | 17 | ||
| 7867 | 62156 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2165 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/04/1985 12:00:00 AM | 9 | Permit Number 22270 | 5999843.40545 | 2120869.57146 | 37.8034928263957 | -122.444766922157 | (37.8034928263957, -122.444766922157) | 13 | 9 | 1 | 57 | 17 | |
| 130975 | 41183 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2246 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/24/1999 12:00:00 AM | 9 | Permit Number 41901 | 5999456.41796 | 2120862.19039 | 37.8034504683333 | -122.446105572921 | (37.8034504683333, -122.446105572921) | 13 | 9 | 1 | 57 | 17 | |
| 7999 | 62155 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2252 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/04/1985 12:00:00 AM | 13 | Permit Number 22269 | 5999444.38711 | 2120859.49312 | 37.8034423753191 | -122.446147011887 | (37.8034423753191, -122.446147011887) | 13 | 9 | 1 | 57 | 17 | |
| 54075 | 136890 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1001x Bay St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2017 01:59:00 PM | 3 | Width 3ft | 6005802 | 2120854 | 37.8037883050638 | -122.424145815925 | (37.8037883050638, -122.424145815925) | 5 | 9 | 1 | 28858 | 32 | ||
| 55753 | 136887 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1001x Bay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6005802 | 2120854 | 37.8037883050638 | -122.424145815925 | (37.8037883050638, -122.424145815925) | 5 | 9 | 1 | 28858 | 32 | |||
| 110794 | 136889 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1001x Bay St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6005802 | 2120854 | 37.8037883050638 | -122.424145815925 | (37.8037883050638, -122.424145815925) | 5 | 9 | 1 | 28858 | 32 | |||
| 170233 | 136888 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1001x Bay St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6005802 | 2120854 | 37.8037883050638 | -122.424145815925 | (37.8037883050638, -122.424145815925) | 5 | 9 | 1 | 28858 | 32 | |||
| 135002 | 136785 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1307 Bay St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6004526.27681 | 2120824.48877 | 37.803635162995 | -122.428558424738 | (37.803635162995, -122.428558424738) | 13 | 9 | 1 | 28858 | 17 | |||
| 157741 | 41221 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 263 Mallorca Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/30/1999 12:00:00 AM | 7 | Permit Number 41928 | 6001414.86425 | 2120821.76469 | 37.80345111405 | -122.439325404156 | (37.80345111405, -122.439325404156) | 13 | 9 | 1 | 57 | 17 | |
| 116859 | 136784 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1307 Bay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6004497.53006 | 2120820.54002 | 37.803622693903 | -122.428657622664 | (37.803622693903, -122.428657622664) | 13 | 9 | 1 | 28858 | 17 | |||
| 8300 | 62006 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1307 Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/31/1985 12:00:00 AM | 7 | Permit Number 22075 | 6004472.06597 | 2120817.82099 | 37.8036137870071 | -122.428745548466 | (37.8036137870071, -122.428745548466) | 13 | 9 | 1 | 28858 | 17 | |
| 79955 | 62007 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1325 Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/31/1985 12:00:00 AM | 7 | Permit Number 22076 | 6004435.88991 | 2120811.64656 | 37.8035947861208 | -122.428870297051 | (37.8035947861208, -122.428870297051) | 13 | 9 | 1 | 28858 | 17 | |
| 73480 | 50660 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 629 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/2007 12:00:00 AM | 4 | 3x3 | Permit Number 49797 | 6008816.5346 | 2120736.2648 | 37.8036347775517 | -122.413705478453 | (37.8036347775517, -122.413705478453) | 3 | 1 | 10 | 308 | 23 | |
| 90624 | 143017 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 655 CHESTNUT ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6008708.0589 | 2120716.6295 | 37.8035747718659 | -122.414079475338 | (37.8035747718659, -122.414079475338) | 3 | 1 | 10 | 308 | 23 | |||
| 112816 | 143016 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 655 CHESTNUT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6008680.5233 | 2120713.7091 | 37.8035652065716 | -122.414174557157 | (37.8035652065716, -122.414174557157) | 3 | 1 | 10 | 308 | 23 | |||
| 142751 | 143023 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 665 Chestnut St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6008630.4585 | 2120708.2854 | 37.8035475022359 | -122.414347425317 | (37.8035475022359, -122.414347425317) | 3 | 1 | 10 | 308 | 23 | |||
| 150454 | 143022 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 675 Chestnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6008611.267 | 2120705.7822 | 37.8035395509937 | -122.414413661372 | (37.8035395509937, -122.414413661372) | 3 | 1 | 10 | 308 | 23 | |||
| 124068 | 143021 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 685 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6008591.686 | 2120703.4993 | 37.8035321827214 | -122.414481260898 | (37.8035321827214, -122.414481260898) | 3 | 1 | 10 | 308 | 23 | |||
| 151130 | 97735 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1150 Francisco St | 14 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/22/2016 02:46:00 PM | 3 | 3x3 | Permit Number 50638 | 6005694.979 | 2120690.49004 | 37.8033333055591 | -122.424504530974 | (37.8033333055591, -122.424504530974) | 5 | 9 | 1 | 28858 | 32 |
| 102223 | 136780 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3601 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6000192.73269 | 2120677.08114 | 37.802984228306 | -122.443544228184 | (37.802984228306, -122.443544228184) | 13 | 9 | 1 | 57 | 17 | |||
| 139971 | 35017 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 25 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1997 12:00:00 AM | Permit Number 38592 | 6001951.42049088 | 2120655.30141734 | 37.803024569063 | -122.43745670493 | (37.803024569063, -122.43745670493) | 13 | 9 | 1 | 57 | 17 | |||
| 23214 | 84608 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1307 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2008 12:00:00 AM | 3x3 | Permit Number 50841 | 6005059.05085072 | 2120549.16999723 | 37.8029093444786 | -122.426695114755 | (37.8029093444786, -122.426695114755) | 13 | 9 | 1 | 57 | 17 | ||
| 193563 | 136786 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3099 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6005074.92093 | 2120531.12006 | 37.8028606812269 | -122.426638909965 | (37.8028606812269, -122.426638909965) | 13 | 9 | 1 | 57 | 17 | |||
| 190944 | 143054 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1731 Grant Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6010429.028 | 2120490.458 | 37.8030502706615 | -122.408107992666 | (37.8030502706615, -122.408107992666) | 3 | 1 | 10 | 308 | 23 | |||
| 38872 | 136788 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3044 Franklin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6005143.48747 | 2120475.2029 | 37.8027110232569 | -122.426397650651 | (37.8027110232569, -122.426397650651) | 13 | 9 | 1 | 57 | 17 | |||
| 77582 | 82889 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1423 Francisco St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 07/01/2009 12:00:00 AM | 3x3 | Permit Number 52339 | 6004509.13864627 | 2120473.3950975 | 37.8026701808582 | -122.42859269053 | (37.8026701808582, -122.42859269053) | 13 | 9 | 1 | 57 | 17 | ||
| 10959 | 143055 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1729 Grant Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6010430.3624 | 2120468.8411 | 37.8029909907013 | -122.408101849493 | (37.8029909907013, -122.408101849493) | 3 | 1 | 10 | 308 | 23 | |||
| 163879 | 136787 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3044 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6005144.52223 | 2120466.04669 | 37.8026859411546 | -122.426393417542 | (37.8026859411546, -122.426393417542) | 13 | 9 | 1 | 57 | 17 | |||
| 161846 | 68970 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3420 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1994 12:00:00 AM | 5 | Permit Number 32960 | 5999798.8127 | 2120325.39323 | 37.8019961143897 | -122.444882095654 | (37.8019961143897, -122.444882095654) | 13 | 9 | 1 | 57 | 17 | |
| 94337 | 251270 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 853 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/2017 12:00:00 AM | 3 | 3x3 | 6008278.12362 | 2120317.86249 | 37.8024557006055 | -122.415539041664 | (37.8024557006055, -122.415539041664) | 5 | 1 | 10 | 308 | 32 | ||
| 10132 | 136901 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2333 Leavenworth St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/24/2020 12:00:00 AM | 3 | Width 5ft | 6007536.47447 | 2120305.57509 | 37.8023802472184 | -122.41810464953 | (37.8023802472184, -122.41810464953) | 5 | 1 | 1 | 28858 | 32 | ||
| 108796 | 143088 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 614 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6009954.5993 | 2120247.1152 | 37.8023555364086 | -122.40973258446 | (37.8023555364086, -122.40973258446) | 3 | 1 | 10 | 308 | 23 | |||
| 52241 | 143090 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 618 Greenwich St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6009917.0126 | 2120239.8067 | 37.8023333626961 | -122.409862137219 | (37.8023333626961, -122.409862137219) | 3 | 1 | 10 | 308 | 23 | |||
| 100609 | 136902 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2213 Jones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6008039.36395 | 2120205.32059 | 37.8021332654887 | -122.41635729467 | (37.8021332654887, -122.41635729467) | 5 | 1 | 10 | 308 | 32 | |||
| 61506 | 83206 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3036-3038 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52341 | 6004708.92286 | 2120041.85386 | 37.8014965841717 | -122.427870568371 | (37.8014965841717, -122.427870568371) | 13 | 9 | 1 | 57 | 17 | |
| 173004 | 136765 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3248 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5999349.57703 | 2120035.43346 | 37.801174314804 | -122.446415785968 | (37.801174314804, -122.446415785968) | 13 | 9 | 1 | 57 | 17 | |||
| 25817 | 83357 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3036-3038 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52341 | 6004710.71346 | 2120028.26822 | 37.8014593828022 | -122.427863403488 | (37.8014593828022, -122.427863403488) | 13 | 9 | 1 | 57 | 17 | |
| 173168 | 81924 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2564X Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/2008 12:00:00 AM | 3x3 | Permit Number 50755 | 6006664.3463364 | 2119981.34630043 | 37.8014408715731 | -122.421099611614 | (37.8014408715731, -122.421099611614) | 5 | 9 | 1 | 28858 | 32 | ||
| 30878 | 136886 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2655 Polk St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 2ft | 6006127.92223 | 2119929.33879 | 37.8012678182029 | -122.422952183303 | (37.8012678182029, -122.422952183303) | 13 | 9 | 1 | 28858 | 32 | |||
| 154085 | 136897 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2507 Larkin St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006673.65133 | 2119907.58338 | 37.80123886184 | -122.421062171681 | (37.80123886184, -122.421062171681) | 5 | 9 | 1 | 28858 | 32 | |||
| 53496 | 84626 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3348 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50854 | 6000840.93962 | 2119902.06373 | 37.8008931831302 | -122.441245461216 | (37.8008931831302, -122.441245461216) | 13 | 9 | 1 | 57 | 17 | |
| 42804 | 81923 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2524X Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50824 | 6006683.22400402 | 2119851.76004091 | 37.8010861247199 | -122.421025080133 | (37.8010861247199, -122.421025080133) | 5 | 9 | 1 | 28858 | 32 | ||
| 86670 | 146397 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3318 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2019 12:00:00 AM | 3 | Width 4ft | Permit Number 780850 | 6000857.39871 | 2119780.85133 | 37.8005613036105 | -122.441179804419 | (37.8005613036105, -122.441179804419) | 13 | 9 | 1 | 57 | 17 | |
| 91447 | 136776 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2600 Richardson Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 5999020.04225 | 2119778.41485 | 37.8004497840758 | -122.447537603903 | (37.8004497840758, -122.447537603903) | 13 | 9 | 1 | 57 | 17 | ||||
| 125382 | 136774 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2600 Francisco St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 5999022.27584 | 2119774.26108 | 37.8004385065862 | -122.447529575653 | (37.8004385065862, -122.447529575653) | 13 | 9 | 1 | 57 | 17 | ||||
| 95669 | 136775 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2600 Francisco St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 5999017.84714 | 2119772.04283 | 37.8004321627783 | -122.447544740905 | (37.8004321627783, -122.447544740905) | 13 | 9 | 1 | 57 | 17 | ||||
| 12024 | 66137 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3248 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/17/1990 12:00:00 AM | 5 | Permit Number 29200 | 5999873.32355 | 2119767.07624 | 37.8004673775197 | -122.444584102586 | (37.8004673775197, -122.444584102586) | 13 | 9 | 1 | 57 | 17 | |
| 57171 | 87956 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3250 Broderick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 50982 | 5999898.4 | 2119763 | 37.800457616115 | -122.44449703515 | (37.800457616115, -122.44449703515) | 13 | 9 | 1 | 57 | 17 | ||
| 76107 | 87069 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2268 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2007 12:00:00 AM | 3x3 | Permit Number 50010 | 6001029.8 | 2119730 | 37.8004314980305 | -122.440579577974 | (37.8004314980305, -122.440579577974) | 13 | 9 | 1 | 57 | 17 | ||
| 125112 | 107511 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2141 Chestnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/18/2014 12:00:00 AM | 3 | 3x3 | 6001625.68296 | 2119729.38155 | 37.8004637136911 | -122.438517544046 | (37.8004637136911, -122.438517544046) | 13 | 9 | 1 | 57 | 17 | ||
| 12230 | 107510 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2141 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/18/2014 12:00:00 AM | 3 | 3x3 | 6001605.27547 | 2119726.96625 | 37.8004559210497 | -122.438587988867 | (37.8004559210497, -122.438587988867) | 13 | 9 | 1 | 57 | 17 | ||
| 179948 | 136891 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1317 Greenwich St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 3ft | 6006598.09728 | 2119723.59286 | 37.8007294111786 | -122.421310549145 | (37.8007294111786, -122.421310549145) | 13 | 9 | 1 | 28858 | 32 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );