trees
7,322 rows where qSpecies_id = 1 sorted by PermitNotes 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 144247 | 21524 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2709X Diamond St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Tree was replanted 02/06/07 | 6002363.91789 | 2096241.56289 | 37.7360139044279 | -122.434282822689 | (37.7360139044279, -122.434282822689) | 2 | 7 | 5 | 63 | 7 | |||
| 115120 | 54050 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2234 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/1972 12:00:00 AM | 7 | Permit Number 9772 | 6000883.53161 | 2116117.87685 | 37.7905052265944 | -122.440826467079 | (37.7905052265944, -122.440826467079) | 13 | 6 | 1 | 29490 | 27 | ||
| 28730 | 54023 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 894 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/1972 12:00:00 AM | 8 | Permit Number 9742 | 5985137.88003 | 2109802.85979 | 37.7722566986547 | -122.494838846537 | (37.7722566986547, -122.494838846537) | 11 | 6 | 2 | 55 | 26 | ||
| 194277 | 180017 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1985 Alemany Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | Permit Number 785142 | 6000882.12551 | 2090726.03967 | 37.7207853271706 | -122.439010804221 | (37.7207853271706, -122.439010804221) | 9 | 7 | 6 | 28861 | 25 | ||
| 12109 | 225886 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 252 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 785090 | 6003516.0044 | 2106734.0164 | 37.7648890444188 | -122.431048241879 | (37.7648890444188, -122.431048241879) | 15 | 4 | 5 | 28862 | 3 | |
| 7830 | 262278 | Section 806 (d) 5 | Tristaniopsis laurina :: Swamp Myrtle 1 | 15 Corona St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/25/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784820 | 5992625 | 2091331 | 37.7219731255806 | -122.467596882777 | (37.7219731255806, -122.467596882777) | 9 | 8 | 4 | 59 | 40 | |
| 9135 | 262279 | Section 806 (d) 5 | Tristaniopsis laurina :: Swamp Myrtle 1 | 15 Corona St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/25/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784820 | 5992625 | 2091331 | 37.7219731255806 | -122.467596882777 | (37.7219731255806, -122.467596882777) | 9 | 8 | 4 | 59 | 40 | |
| 194448 | 265090 | Section 806 (d) 5 | Tristaniopsis laurina :: Swamp Myrtle 1 | 215 Montana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/04/2021 12:00:00 AM | 3 | 3x3 | Permit Number 784731 | 5994883.78198 | 2089306.03852 | 37.7165432206381 | -122.459642300713 | (37.7165432206381, -122.459642300713) | 9 | 8 | 6 | 28861 | 24 | |
| 2574 | 216200 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1650 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/11/2020 12:00:00 AM | 3 | 4x4 | Permit Number 784456 | 5992806.74011 | 2104217.97153 | 37.7573679916535 | -122.467905522425 | (37.7573679916535, -122.467905522425) | 1 | 8 | 4 | 56 | 12 | |
| 18063 | 259659 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4061 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/29/2019 12:00:00 AM | 3 | 3x3 | Permit Number 784440 | 6003514 | 2100377 | 37.7474340728524 | -122.430601526112 | (37.7474340728524, -122.430601526112) | 2 | 4 | 5 | 63 | 22 | |
| 11626 | 262262 | Section 806 (d) 5 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1324 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2020 12:00:00 AM | 3 | 4x4 | Permit Number 784290 | 5993653.14185 | 2106470.72632 | 37.763602309694 | -122.465141974097 | (37.763602309694, -122.465141974097) | 1 | 8 | 11 | 56 | 12 | |
| 14595 | 262138 | Section 806 (d) 5 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1118 Capitol Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/2020 12:00:00 AM | 3 | 3x3 | Permit Number 783072 | 5995073.28586 | 2091364.23184 | 37.7222054253906 | -122.459136235782 | (37.7222054253906, -122.459136235782) | 9 | 8 | 4 | 28861 | 24 | |
| 194517 | 265144 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2166 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 782839 | 5997501.55835 | 2109896.92898 | 37.773230951126 | -122.452078795234 | (37.773230951126, -122.452078795234) | 15 | 5 | 11 | 29492 | 16 | ||
| 194501 | 265145 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2160 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/13/2021 12:00:00 AM | 3 | 3x3 | Permit Number 782838 | 5997529.09133 | 2109900.74605 | 37.7732430089022 | -122.451983830898 | (37.7732430089022, -122.451983830898) | 15 | 5 | 11 | 29492 | 16 | |
| 32851 | 136853 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 628 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/07/2019 12:00:00 AM | 3 | Width 4ft | Permit Number 782762 | 6008257.35293 | 2114172.86388 | 37.7855818817524 | -122.415175683534 | (37.7855818817524, -122.415175683534) | 13 | 10 | 9 | 28858 | 36 |
| 10409 | 256902 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2051 34th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782737 | 5985693.46852 | 2101265.2111 | 37.7488471905551 | -122.492288254945 | (37.7488471905551, -122.492288254945) | 1 | 8 | 3 | 29491 | 35 | |
| 35267 | 256901 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2051 34th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782737 | 5985693.46852 | 2101265.2111 | 37.7488471905551 | -122.492288254945 | (37.7488471905551, -122.492288254945) | 1 | 8 | 3 | 29491 | 35 | |
| 46403 | 256899 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2051 34th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782737 | 5985693.46852 | 2101265.2111 | 37.7488471905551 | -122.492288254945 | (37.7488471905551, -122.492288254945) | 1 | 8 | 3 | 29491 | 35 | |
| 78259 | 256898 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2051 34th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782737 | 5985693.46852 | 2101265.2111 | 37.7488471905551 | -122.492288254945 | (37.7488471905551, -122.492288254945) | 1 | 8 | 3 | 29491 | 35 | |
| 137019 | 256903 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2051 34th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782737 | 5985693.46852 | 2101265.2111 | 37.7488471905551 | -122.492288254945 | (37.7488471905551, -122.492288254945) | 1 | 8 | 3 | 29491 | 35 | |
| 158583 | 256900 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2051 34th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782737 | 5985693.46852 | 2101265.2111 | 37.7488471905551 | -122.492288254945 | (37.7488471905551, -122.492288254945) | 1 | 8 | 3 | 29491 | 35 | |
| 88797 | 139634 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1054 DIVISADERO ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/03/2018 12:00:00 AM | 3 | Width 0ft | Permit Number 782660 | 6001449.7718 | 2112080.966 | 37.7794531349717 | -122.438577943777 | (37.7794531349717, -122.438577943777) | 15 | 5 | 11 | 29490 | 41 |
| 176689 | 256667 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1674 Washington St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782599 | 6006687.27852 | 2117040.19177 | 37.79336649376 | -122.420811331011 | (37.79336649376, -122.420811331011) | 13 | 9 | 10 | 28858 | 32 | |
| 81370 | 256662 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1306 Broadway | : | Tree | Private 2 | FUF | 11/19/2018 12:00:00 AM | 3 | Permit Number 782593 | 6007370.8774 | 2118134.97157 | 37.7964109931986 | -122.418523691035 | (37.7964109931986, -122.418523691035) | 5 | 1 | 10 | 28858 | 32 | ||
| 163320 | 256661 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1306 Broadway | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782593 | 6007370.8774 | 2118134.97157 | 37.7964109931986 | -122.418523691035 | (37.7964109931986, -122.418523691035) | 5 | 1 | 10 | 28858 | 32 | |
| 67799 | 253944 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 307 Detroit St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2018 12:00:00 AM | 3 | 6x8 | Permit Number 782443 | 5999404.44458 | 2094100.81859 | 37.7299675006866 | -122.444361079509 | (37.7299675006866, -122.444361079509) | 9 | 7 | 4 | 28861 | 40 | |
| 10508 | 220252 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1421 Diamond St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/2019 12:00:00 AM | 3 | 3x3 | Permit Number 782294 | 6002022.45837 | 2099900.18777 | 37.7460402480521 | -122.435725060979 | (37.7460402480521, -122.435725060979) | 2 | 7 | 5 | 63 | 22 | |
| 14294 | 220251 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1421 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/2019 12:00:00 AM | 3 | 3x3 | Permit Number 782294 | 6002021.86814 | 2099888.44032 | 37.746007958796 | -122.435726261582 | (37.746007958796, -122.435726261582) | 2 | 7 | 5 | 63 | 22 | |
| 10736 | 262270 | Section 806 (d) 5 | Tristaniopsis laurina :: Swamp Myrtle 1 | 10X Restani Stwy | 4 | Unaccepted Street : Yard | Tree | Private 2 | 06/19/2020 12:00:00 AM | 3 | 3x3 | Permit Number 782248 | 5999595 | 2089918 | 37.7184933152793 | -122.443401977243 | (37.7184933152793, -122.443401977243) | 9 | 7 | 6 | 28861 | 25 | |
| 12694 | 262268 | Section 806 (d) 5 | Tristaniopsis laurina :: Swamp Myrtle 1 | 10X Restani Stwy | 2 | Unaccepted Street : Yard | Tree | Private 2 | 06/19/2020 12:00:00 AM | 3 | 3x3 | Permit Number 782248 | 5999595 | 2089918 | 37.7184933152793 | -122.443401977243 | (37.7184933152793, -122.443401977243) | 9 | 7 | 6 | 28861 | 25 | |
| 14968 | 262269 | Section 806 (d) 5 | Tristaniopsis laurina :: Swamp Myrtle 1 | 10X Restani Stwy | 3 | Unaccepted Street : Yard | Tree | Private 2 | 06/19/2020 12:00:00 AM | 3 | 3x3 | Permit Number 782248 | 5999595 | 2089918 | 37.7184933152793 | -122.443401977243 | (37.7184933152793, -122.443401977243) | 9 | 7 | 6 | 28861 | 25 | |
| 16422 | 262267 | Section 806 (d) 5 | Tristaniopsis laurina :: Swamp Myrtle 1 | 10X Restani Stwy | 1 | Unaccepted Street : Yard | Tree | Private 2 | 06/19/2020 12:00:00 AM | 3 | 3x3 | Permit Number 782248 | 5999595 | 2089918 | 37.7184933152793 | -122.443401977243 | (37.7184933152793, -122.443401977243) | 9 | 7 | 6 | 28861 | 25 | |
| 43715 | 242230 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4388 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2018 12:00:00 AM | 3 | Width 3ft | Permit Number 782166 | 6000091.20852 | 2105784.92288 | 37.762088409862 | -122.442825544881 | (37.762088409862, -122.442825544881) | 15 | 5 | 5 | 28862 | 3 | |
| 143524 | 242231 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4388 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2018 12:00:00 AM | 3 | Width 3ft | Permit Number 782166 | 6000074.93912 | 2105783.33578 | 37.7620831245464 | -122.442881700325 | (37.7620831245464, -122.442881700325) | 15 | 5 | 5 | 28862 | 3 | |
| 148882 | 159485 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 125 Farragut Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/18/2019 12:00:00 AM | 3 | Width 0ft | Permit Number 782109 | 5997299.08146 | 2087363.42174 | 37.7113478362182 | -122.451153855174 | (37.7113478362182, -122.451153855174) | 9 | 7 | 6 | 28861 | 25 | |
| 103069 | 122901 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1550 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782072 | 6015193.36513 | 2093994.46632 | 37.7305636781779 | -122.389768984676 | (37.7305636781779, -122.389768984676) | 10 | 3 | 8 | 58 | 1 |
| 94904 | 255688 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1650 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782071 | 6015027.99096 | 2094815.98763 | 37.7328102378895 | -122.390398090602 | (37.7328102378895, -122.390398090602) | 10 | 3 | 8 | 58 | 1 |
| 38580 | 192619 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 6625 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | Permit Number 782060 | 6012818.98945 | 2089622.52871 | 37.7184272714859 | -122.397671082262 | (37.7184272714859, -122.397671082262) | 10 | 3 | 8 | 58 | 1 | ||
| 5901 | 260465 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3933 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/04/2019 12:00:00 AM | 3 | 3x4 | Permit Number 782033 | 6005003.24747 | 2095750.87761 | 37.7348160467336 | -122.425122689163 | (37.7348160467336, -122.425122689163) | 2 | 7 | 7 | 28861 | 2 | |
| 17490 | 255503 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 335 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781972 | 5997864.63144 | 2093785.59571 | 37.729013998385 | -122.449661668302 | (37.729013998385, -122.449661668302) | 9 | 7 | 4 | 28861 | 40 |
| 103883 | 236115 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 410 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2018 12:00:00 AM | 3 | Width 3ft | Permit Number 781957 | 6003708 | 2109045 | 37.7712453216629 | -122.4305490898 | (37.7712453216629, -122.4305490898) | 15 | 9 | 11 | 29492 | 10 | |
| 68075 | 136107 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2844 Fillmore St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 05/30/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 781955 | 6002576.03515 | 2117998.39641 | 37.7957648926996 | -122.435105073747 | (37.7957648926996, -122.435105073747) | 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 | |
| 63424 | 137431 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2701 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 781934 | 6003520.71542 | 2117748.65471 | 37.7951327628251 | -122.431818468071 | (37.7951327628251, -122.431818468071) | 13 | 9 | 1 | 29490 | 27 | |
| 81759 | 256725 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 432 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/05/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781907 | 5993569.91313 | 2105305.27634 | 37.7603974888061 | -122.465345170025 | (37.7603974888061, -122.465345170025) | 1 | 8 | 11 | 56 | 12 | |
| 83711 | 258012 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 238 Eureka St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/12/2019 12:00:00 AM | 3 | 3x3 | Permit Number 781835 | 6001423.51445 | 2104434.57022 | 37.7584565353532 | -122.438120885556 | (37.7584565353532, -122.438120885556) | 2 | 4 | 5 | 28862 | 3 | |
| 60006 | 257929 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 255 Seneca Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2019 12:00:00 AM | 3 | 3x3 | Permit Number 781730 | 5999620.44198 | 2090680.5387 | 37.7205885233371 | -122.443368776907 | (37.7205885233371, -122.443368776907) | 9 | 7 | 6 | 28861 | 25 | |
| 184858 | 219635 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1530 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/16/2018 12:00:00 AM | 3 | Width 3ft | Permit Number 781720 | 6010169.67142 | 2100374.58731 | 37.7478022546892 | -122.407586382118 | (37.7478022546892, -122.407586382118) | 2 | 7 | 7 | 28859 | 2 | |
| 186904 | 254855 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 22 Jennifer Pl | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/29/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781646 | 6011910.01557 | 2112026.30887 | 37.7798925393586 | -122.402387474086 | (37.7798925393586, -122.402387474086) | 6 | 2 | 9 | 28856 | 34 | |
| 104592 | 254765 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 180 Howth St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/27/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781608 | 5997468.16885 | 2090909.73421 | 37.7210948695788 | -122.450824986799 | (37.7210948695788, -122.450824986799) | 9 | 8 | 6 | 28861 | 24 | |
| 194408 | 254760 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 170 Arch St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | FUF | 03/26/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781604 | 5992729.03192 | 2088323.37985 | 37.7137209347968 | -122.467018722529 | (37.7137209347968, -122.467018722529) | 9 | 8 | 6 | 64 | 24 |
| 8699 | 262221 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 240 Chattanooga St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/2020 12:00:00 AM | 3 | 3x3 | Permit Number 781435 | 6004728 | 2102256 | 37.7526620712812 | -122.426537368454 | (37.7526620712812, -122.426537368454) | 2 | 4 | 5 | 28862 | 22 | |
| 11910 | 262222 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 240 Chattanooga St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/2020 12:00:00 AM | 3 | 3x3 | Permit Number 781435 | 6004728 | 2102256 | 37.7526620712812 | -122.426537368454 | (37.7526620712812, -122.426537368454) | 2 | 4 | 5 | 28862 | 22 | |
| 15413 | 262220 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 240 Chattanooga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/2020 12:00:00 AM | 3 | 3x3 | Permit Number 781435 | 6004728 | 2102256 | 37.7526620712812 | -122.426537368454 | (37.7526620712812, -122.426537368454) | 2 | 4 | 5 | 28862 | 22 | |
| 99548 | 256905 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 338 Princeton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/03/2019 12:00:00 AM | 3 | 3x3 | Permit Number 781421 | 6007824.5446 | 2092249.93927 | 37.7253622000817 | -122.415120729164 | (37.7253622000817, -122.415120729164) | 9 | 3 | 7 | 309 | 28 | |
| 19007 | 216971 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1595 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781395 | 5991715.0131 | 2104457.47271 | 37.7579624956851 | -122.471698563334 | (37.7579624956851, -122.471698563334) | 1 | 8 | 4 | 56 | 12 |
| 20046 | 216968 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1595 15th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781395 | 5991682.07127 | 2104398.96183 | 37.7577999342364 | -122.471808224875 | (37.7577999342364, -122.471808224875) | 1 | 8 | 4 | 56 | 12 |
| 75329 | 216969 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1595 15th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781395 | 5991690.84676 | 2104411.01259 | 37.7578335302007 | -122.471778754094 | (37.7578335302007, -122.471778754094) | 1 | 8 | 4 | 56 | 12 |
| 125401 | 216970 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1595 15th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781395 | 5991700.4649 | 2104425.414 | 37.7578736291783 | -122.471746540383 | (37.7578736291783, -122.471746540383) | 1 | 8 | 4 | 56 | 12 |
| 91264 | 180195 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 34 Mill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781337 | 6010464.67418 | 2089947.4115 | 37.7191879504558 | -122.405831883942 | (37.7191879504558, -122.405831883942) | 10 | 7 | 8 | 309 | 39 |
| 140368 | 85488 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 380 Bacon St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781321 | 6010382.04844 | 2092789.53775 | 37.7269872183833 | -122.406317636561 | (37.7269872183833, -122.406317636561) | 10 | 3 | 7 | 309 | 28 |
| 65905 | 254352 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 96 Alpha St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781320 | 6011026.29864 | 2088238.77352 | 37.7145277707382 | -122.403770388077 | (37.7145277707382, -122.403770388077) | 9 | 7 | 8 | 309 | 39 |
| 180361 | 155277 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2150 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/24/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781256 | 5990718.98102 | 2100751.36677 | 37.7477288250316 | -122.474872715117 | (37.7477288250316, -122.474872715117) | 1 | 8 | 4 | 29491 | 40 |
| 192166 | 232740 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1235 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2018 12:00:00 AM | 3 | 4x4 | Permit Number 781253 | 6003890.57466 | 2101130.85384 | 37.7495253062673 | -122.429353105273 | (37.7495253062673, -122.429353105273) | 2 | 4 | 5 | 28862 | 22 | |
| 18916 | 152848 | Section 806 (d) 5 | Tristaniopsis laurina :: Swamp Myrtle 1 | 160 San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/12/2019 12:00:00 AM | 3 | Width 3ft | Permit Number 781252 | 6006654.74312 | 2105190.58967 | 37.7608285109489 | -122.420082580673 | (37.7608285109489, -122.420082580673) | 2 | 4 | 7 | 28859 | 19 | |
| 39808 | 244734 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 99 Surrey St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781234 | 6002400.58496 | 2096245.1457 | 37.7360258231402 | -122.434156306092 | (37.7360258231402, -122.434156306092) | 2 | 7 | 5 | 63 | 7 |
| 125927 | 218766 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 300 Detroit St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781231 | 5999439.37932 | 2094117.9185 | 37.7300164461993 | -122.444241534638 | (37.7300164461993, -122.444241534638) | 9 | 7 | 4 | 63 | 40 |
| 51399 | 254270 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 399 Melrose Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781229 | 5997471.20201 | 2095517.43055 | 37.7337466879114 | -122.451146618749 | (37.7337466879114, -122.451146618749) | 9 | 7 | 4 | 59 | 40 |
| 187294 | 254194 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1265 Monterey Blvd | 2 | Front Yard : Cutout | Tree | Private 2 | FUF | 01/19/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781221 | 5994091.43615 | 2094320.67109 | 37.7302665946388 | -122.462744594485 | (37.7302665946388, -122.462744594485) | 9 | 8 | 4 | 59 | 40 |
| 179947 | 150991 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 625 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/18/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781210 | 6014147.25028 | 2104231.51584 | 37.75861440256 | -122.394101980628 | (37.75861440256, -122.394101980628) | 10 | 3 | 8 | 28856 | 29 |
| 83568 | 187475 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4399 Mission St | 10 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3 | Width 0ft | Permit Number 781046 | 6003058.899 | 2093390.3112 | 37.7282244365032 | -122.431676490484 | (37.7282244365032, -122.431676490484) | 9 | 7 | 6 | 28861 | 5 | ||
| 8349 | 163331 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 159 Sadowa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/15/2019 12:00:00 AM | 3 | 3x3 | Permit Number 780897 | 5995371.93865 | 2087733.0149 | 37.7122521261194 | -122.45784123641 | (37.7122521261194, -122.45784123641) | 9 | 8 | 6 | 28861 | 24 | |
| 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 | |
| 16367 | 236726 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1614 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780101 | 6002560.74433 | 2100754.3551 | 37.7484161516874 | -122.433924785525 | (37.7484161516874, -122.433924785525) | 2 | 4 | 5 | 28862 | 22 | |
| 67232 | 256000 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 8 Springfield Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 08/21/2018 12:00:00 AM | 3 | 6x10 | Permit Number 780036 | 5986792.13129 | 2095812.03329 | 37.733938381975 | -122.488088482457 | (37.733938381975, -122.488088482457) | 1 | 8 | 4 | 64 | 35 | |
| 23159 | 192045 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 405 Townsend St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 08/14/2017 12:00:00 AM | 3 | Width 8ft | Permit Number 780033 | 6013178.04643 | 2110099.77457 | 37.7746734191738 | -122.397865584934 | (37.7746734191738, -122.397865584934) | 14 | 2 | 9 | 28856 | 20 | |
| 58188 | 192049 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 405 Townsend St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 08/14/2017 12:00:00 AM | 3 | Width 8ft | Permit Number 780033 | 6013269.50597 | 2110186.98089 | 37.7749179610178 | -122.397555323332 | (37.7749179610178, -122.397555323332) | 14 | 2 | 9 | 28856 | 20 | |
| 102697 | 192050 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 405 Townsend St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 08/14/2017 12:00:00 AM | 3 | Width 8ft | Permit Number 780033 | 6013285.99525 | 2110202.74852 | 37.774962173497 | -122.397499389085 | (37.774962173497, -122.397499389085) | 14 | 2 | 9 | 28856 | 20 | |
| 135240 | 192047 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 405 Townsend St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 08/14/2017 12:00:00 AM | 3 | Width 8ft | Permit Number 780033 | 6013240.39967 | 2110155.04551 | 37.7748286529654 | -122.397653768512 | (37.7748286529654, -122.397653768512) | 14 | 2 | 9 | 28856 | 20 | |
| 167558 | 192048 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 405 Townsend St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 08/14/2017 12:00:00 AM | 3 | Width 8ft | Permit Number 780033 | 6013251.73009 | 2110171.56166 | 37.7748746334969 | -122.397615732604 | (37.7748746334969, -122.397615732604) | 14 | 2 | 9 | 28856 | 20 | |
| 187133 | 192046 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 405 Townsend St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 08/14/2017 12:00:00 AM | 3 | Width 8ft | Permit Number 780033 | 6013200.03931 | 2110117.49199 | 37.7747232919731 | -122.39779074965 | (37.7747232919731, -122.39779074965) | 14 | 2 | 9 | 28856 | 20 | |
| 193259 | 151101 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 522 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/06/2018 12:00:00 AM | 3 | 3x3 | Permit Number 779866 | 6004281.12717 | 2110156.88846 | 37.7743307469112 | -122.428645891904 | (37.7743307469112, -122.428645891904) | 7 | 9 | 11 | 28852 | 10 | |
| 53308 | 116632 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2332 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/27/2018 11:42:00 AM | 3 | 3x3 | Permit Number 779740 | 5991403.36215 | 2112037.81363 | 37.7787580362874 | -122.473329239514 | (37.7787580362874, -122.473329239514) | 11 | 6 | 2 | 54 | 26 | |
| 10316 | 142205 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1683 HAYES ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | DPW for City Agency | 3 | Width 0ft | Permit Number 779644 | 5999834.1012 | 2110180.6204 | 37.774143230926 | -122.444030632037 | (37.774143230926, -122.444030632037) | 15 | 5 | 11 | 29492 | 16 | |
| 51647 | 32804 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1683 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/03/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779644 | 5999817.40523345 | 2110171.54968226 | 37.7741173725999 | -122.444087734231 | (37.7741173725999, -122.444087734231) | 15 | 5 | 11 | 29492 | 16 | |
| 25926 | 28538 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4742 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/23/2005 12:00:00 AM | 3 | 3x3 | Permit Number 779458 | 6001538.107 | 2091234.9493 | 37.7222199809558 | -122.436779692563 | (37.7222199809558, -122.436779692563) | 9 | 7 | 6 | 28861 | 25 | |
| 194391 | 109904 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 224 12th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/09/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779440 | 6007796.5595 | 2109021.55143 | 37.7714117049152 | -122.41640489308 | (37.7714117049152, -122.41640489308) | 8 | 2 | 9 | 28853 | 19 | |
| 42043 | 43684 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 583 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/2018 12:00:00 AM | 3 | Permit Number 779365 | 5993748.11926 | 2111537.72758 | 37.7775204281613 | -122.46518153967 | (37.7775204281613, -122.46518153967) | 11 | 6 | 2 | 54 | 11 | |
| 25891 | 136907 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 352 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/06/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779330 | 6011790.69425 | 2119110.61996 | 37.7993377175325 | -122.403298763539 | (37.7993377175325, -122.403298763539) | 3 | 1 | 10 | 308 | 23 | |
| 190724 | 198010 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 213 Clara St | 1 | : | Tree | Private 2 | 1 | Width 3ft | Permit Number 779305 | 6011863.46506 | 2111836.26557 | 37.7793681257663 | -122.402535146491 | (37.7793681257663, -122.402535146491) | 14 | 2 | 9 | 28856 | 34 | ||
| 127700 | 255510 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 118 Circular Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/05/2018 12:00:00 AM | 3 | 3x3 | Permit Number 779301 | 6001282.24432 | 2094484.29682 | 37.7311274034584 | -122.437896768674 | (37.7311274034584, -122.437896768674) | 9 | 7 | 4 | 63 | 40 |
| 47294 | 254847 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 124 Corbett Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/29/2018 12:00:00 AM | 3 | 3x3 | Permit Number 779287 | 6000581.14651 | 2105634.12075 | 37.7617022635467 | -122.441120222786 | (37.7617022635467, -122.441120222786) | 15 | 5 | 5 | 28862 | 3 | |
| 15819 | 151746 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3030 17th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779245 | 6008502.96204 | 2106251.6003 | 37.763845762487 | -122.413765441348 | (37.763845762487, -122.413765441348) | 8 | 4 | 7 | 28859 | 19 | |
| 74821 | 36044 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3030 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779245 | 6008531.98185334 | 2106261.58493121 | 37.7638748076146 | -122.413665776536 | (37.7638748076146, -122.413665776536) | 8 | 4 | 7 | 28859 | 19 | |
| 124014 | 108228 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 390x TREAT AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779245 | 6008492 | 2106262 | 37.763873702058 | -122.413804091523 | (37.763873702058, -122.413804091523) | 8 | 4 | 7 | 28859 | 19 | |
| 177206 | 36045 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3030 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779245 | 6008531.98185334 | 2106261.58493121 | 37.7638748076146 | -122.413665776536 | (37.7638748076146, -122.413665776536) | 8 | 4 | 7 | 28859 | 19 | |
| 156097 | 253105 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1295 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778939 | 5986427 | 2106455 | 37.7631397866436 | -122.490133427734 | (37.7631397866436, -122.490133427734) | 1 | 8 | 3 | 56 | 35 | |
| 812 | 210575 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 222 Ridgewood Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2018 12:00:00 AM | 3 | Width 2ft | Permit Number 778918 | 5996813.55952 | 2094844.51305 | 37.7318613433091 | -122.453371704763 | (37.7318613433091, -122.453371704763) | 9 | 7 | 4 | 59 | 40 | |
| 59910 | 154143 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1766 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2018 12:00:00 AM | 3 | 3x3 | Permit Number 778912 | 6014181.73717 | 2096152.00567 | 37.7364316898536 | -122.393417290775 | (37.7364316898536, -122.393417290775) | 10 | 3 | 8 | 58 | 1 |
| 82891 | 117601 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3150 Turk Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778709 | 5995893 | 2111461 | 37.7774332071911 | -122.457756175704 | (37.7774332071911, -122.457756175704) | 11 | 6 | 2 | 54 | 16 |
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) );