trees
844 rows where qLegalStatus_id = 2 and qSiteInfo = "Sidewalk: Curb side : Cutout" 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12151 | 145130 | Planning Code 138.1 required 2 | Olea europaea :: Olive Tree 9 | 218 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/24/2020 12:00:00 AM | 3 | 4x4 | Permit Number 785634 | 5992772.08387 | 2113986.425 | 37.7841875521538 | -122.468736166845 | (37.7841875521538, -122.468736166845) | 11 | 6 | 2 | 54 | 11 | |
| 4685 | 163919 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 528 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/18/2020 12:00:00 AM | 3 | 4x4 | Permit Number 785290 | 5993187.06549 | 2105302.66577 | 37.7603682343238 | -122.466669061634 | (37.7603682343238, -122.466669061634) | 1 | 8 | 4 | 56 | 12 | |
| 8319 | 260505 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 760 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/14/2019 12:00:00 AM | 3 | 3x3 | Permit Number 784870 | 6007464 | 2105234 | 37.7609932681872 | -122.417286789238 | (37.7609932681872, -122.417286789238) | 2 | 4 | 7 | 28859 | 19 | |
| 9544 | 261378 | Planning Code 138.1 required 2 | Lophostemon confertus :: Brisbane Box 11 | 1762 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784740 | 5990006.33488 | 2103376.99766 | 37.7548967913393 | -122.477528860126 | (37.7548967913393, -122.477528860126) | 1 | 8 | 3 | 56 | 35 | |
| 13240 | 157603 | Planning Code 138.1 required 2 | Magnolia grandiflora 'D.D. Blanchard' :: D.D. Blanchard Southern Magnolia 221 | 16 Fountain St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2020 12:00:00 AM | 3 | 5x5 | Permit Number 784681 | 6000322.25182 | 2101567.57465 | 37.7505217703771 | -122.441723777343 | (37.7505217703771, -122.441723777343) | 2 | 4 | 5 | 28862 | 22 | |
| 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 | |
| 13199 | 261348 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 3300x Alemany Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/13/2020 12:00:00 AM | 3 | 3X3 | Permit Number 784323 | 5994476 | 2087151 | 37.7106025369579 | -122.460895688785 | (37.7106025369579, -122.460895688785) | 9 | 8 | 6 | 28861 | 24 | |
| 16027 | 261349 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 3300x Alemany Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/13/2020 12:00:00 AM | 3 | 3X3 | Permit Number 784323 | 5994476 | 2087151 | 37.7106025369579 | -122.460895688785 | (37.7106025369579, -122.460895688785) | 9 | 8 | 6 | 28861 | 24 | |
| 19087 | 261350 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 299 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/13/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784323 | 5994169 | 2087374 | 37.7111971725927 | -122.461972900974 | (37.7111971725927, -122.461972900974) | 9 | 8 | 6 | 28861 | 24 | |
| 19183 | 261351 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 299 Sagamore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/13/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784323 | 5994169 | 2087374 | 37.7111971725927 | -122.461972900974 | (37.7111971725927, -122.461972900974) | 9 | 8 | 6 | 28861 | 24 | |
| 6587 | 261546 | Planning Code 138.1 required 2 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1955 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/2020 12:00:00 AM | 3 | 3X3 | Permit Number 783144 | 5985360.77923 | 2101907.46183 | 37.750591180724 | -122.493485992107 | (37.750591180724, -122.493485992107) | 1 | 8 | 3 | 29491 | 35 | |
| 104300 | 196537 | Planning Code 138.1 required 2 | Prunus x yedoensis :: Yoshino Cherry 77 | 526 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/04/2019 12:00:00 AM | 3 | Width 3ft | Permit Number 782869 | 6010635.96485 | 2105787.36101 | 37.7626906193079 | -122.406355282166 | (37.7626906193079, -122.406355282166) | 8 | 4 | 8 | 28859 | 19 | |
| 14905 | 260579 | Planning Code 138.1 required 2 | Tree(s) :: 17 | 1662 36th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2019 12:00:00 AM | 3 | 3x3 | Permit Number 782799 | 5985048 | 2103886 | 37.7560054004173 | -122.494713443881 | (37.7560054004173, -122.494713443881) | 1 | 8 | 3 | 56 | 35 | |
| 1519 | 154406 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1270 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/10/2019 12:00:00 AM | 3 | 4x4 | Permit Number 782729 | 6004450.91353 | 2101490.17776 | 37.7505436337949 | -122.427441030576 | (37.7505436337949, -122.427441030576) | 2 | 4 | 5 | 28862 | 22 | |
| 105455 | 256779 | Planning Code 138.1 required 2 | Tree(s) :: 17 | 1231 Grove St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4x4 | Permit Number 782672 | 6001926.50082 | 2110819.32275 | 37.7760160870933 | -122.436838397294 | (37.7760160870933, -122.436838397294) | 15 | 5 | 11 | 29492 | 10 | ||
| 153036 | 256778 | Planning Code 138.1 required 2 | Tree(s) :: 17 | 1231 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4x4 | Permit Number 782672 | 6001926.50082 | 2110819.32275 | 37.7760160870933 | -122.436838397294 | (37.7760160870933, -122.436838397294) | 15 | 5 | 11 | 29492 | 10 | ||
| 82212 | 156914 | Planning Code 138.1 required 2 | Tree(s) :: 17 | 2995 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782654 | 6009047.12311 | 2101072.92433 | 37.7496568330138 | -122.411517443787 | (37.7496568330138, -122.411517443787) | 2 | 4 | 7 | 28859 | 19 | |
| 125934 | 256878 | Planning Code 138.1 required 2 | Podocarpus gracilor :: Fern Pine 51 | 3098 26th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/23/2019 12:00:00 AM | 3 | 3x3 | Permit Number 782654 | 6009121.70897 | 2101021.23838 | 37.7495190982493 | -122.411255871462 | (37.7495190982493, -122.411255871462) | 2 | 4 | 7 | 28859 | 19 | |
| 152203 | 152615 | Planning Code 138.1 required 2 | Podocarpus gracilor :: Fern Pine 51 | 3098 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/23/2019 12:00:00 AM | 3 | 3x3 | Permit Number 782654 | 6009121.70897 | 2101021.23838 | 37.7495190982493 | -122.411255871462 | (37.7495190982493, -122.411255871462) | 2 | 4 | 7 | 28859 | 19 | |
| 179256 | 152616 | Planning Code 138.1 required 2 | Podocarpus gracilor :: Fern Pine 51 | 3098 26th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/23/2019 12:00:00 AM | 3 | 3x3 | Permit Number 782654 | 6009096.56353 | 2101019.92176 | 37.7495140728181 | -122.411342732484 | (37.7495140728181, -122.411342732484) | 2 | 4 | 7 | 28859 | 19 | |
| 124846 | 258137 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 460 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/09/2019 12:00:00 AM | 3 | 3x3 | Permit Number 782442 | 6002949.79782 | 2105560.87431 | 37.7616357801338 | -122.432922786357 | (37.7616357801338, -122.432922786357) | 15 | 4 | 5 | 28862 | 3 | |
| 761 | 224987 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 484 Sanchez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/12/2019 12:00:00 AM | 3 | 4x4 | Permit Number 782366 | 6003591.74199 | 2105457.02251 | 37.7613870178149 | -122.430695151865 | (37.7613870178149, -122.430695151865) | 15 | 4 | 5 | 28862 | 3 | |
| 4536 | 224986 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 484 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/12/2019 12:00:00 AM | 3 | 4x4 | Permit Number 782366 | 6003589.47712 | 2105476.68017 | 37.7614408647212 | -122.430704387917 | (37.7614408647212, -122.430704387917) | 15 | 4 | 5 | 28862 | 3 | |
| 1432 | 228461 | Planning Code 138.1 required 2 | :: 45 | 1813 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | Permit Number 782329 | 6005355.14245 | 2107219.1964 | 37.7663252752163 | -122.424721643507 | (37.7663252752163, -122.424721643507) | 8 | 4 | 5 | 28853 | 19 | ||
| 96451 | 225775 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 577 Castro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | Permit Number 782239 | 6002401.77617 | 2104846.28665 | 37.75964259654 | -122.43476706624 | (37.75964259654, -122.43476706624) | 2 | 4 | 5 | 28862 | 3 | ||
| 141915 | 225774 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 577 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | Permit Number 782239 | 6002400.68275 | 2104833.82508 | 37.7596083179996 | -122.434769956692 | (37.7596083179996, -122.434769956692) | 2 | 4 | 5 | 28862 | 3 | ||
| 84485 | 240578 | Planning Code 138.1 required 2 | Tree(s) :: 17 | 3636 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/17/2019 12:00:00 AM | 3 | 4x4 | Permit Number 782238 | 6004112.69332 | 2103663.95963 | 37.7564931932291 | -122.428765570083 | (37.7564931932291, -122.428765570083) | 2 | 4 | 5 | 28862 | 3 | |
| 22749 | 184649 | Planning Code 138.1 required 2 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1688 42nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | Permit Number 782197 | 5983169.0582 | 2103665.8835 | 37.7552908641291 | -122.501195062681 | (37.7552908641291, -122.501195062681) | 1 | 8 | 3 | 56 | 35 | ||
| 138593 | 56707 | Planning Code 138.1 required 2 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1688 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Permit Number 782197 | 5983170.4061 | 2103643.307 | 37.7552289545408 | -122.501188731534 | (37.7552289545408, -122.501188731534) | 1 | 8 | 3 | 56 | 35 | |||
| 41331 | 14313 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 2190X Market St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/03/2018 12:00:00 AM | 3 | 4x4 | Permit Number 782146 | 6003603.86 | 2107219.9092 | 37.7662281664546 | -122.430779049243 | (37.7662281664546, -122.430779049243) | 7 | 4 | 5 | 28862 | 3 | |
| 133945 | 14312 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 2190X Market St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/03/2018 12:00:00 AM | 3 | 4x4 | Permit Number 782146 | 6003624.7851 | 2107240.8343 | 37.7662868072343 | -122.430708166736 | (37.7662868072343, -122.430708166736) | 7 | 4 | 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 | |
| 161840 | 148099 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 509 Holyoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/19/2018 12:00:00 AM | 3 | 4x4 | Permit Number 782106 | 6009909.13224 | 2092063.05855 | 37.7249659929773 | -122.40790129952 | (37.7249659929773, -122.40790129952) | 10 | 3 | 7 | 309 | 28 | |
| 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 | |
| 167690 | 256776 | Planning Code 138.1 required 2 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 244 Ashton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/13/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781951 | 5994190.23703 | 2091515.08881 | 37.7225688371899 | -122.462199635944 | (37.7225688371899, -122.462199635944) | 9 | 8 | 4 | 28861 | 24 | |
| 16386 | 262532 | Planning Code 138.1 required 2 | Olea europaea :: Olive Tree 9 | 815 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/12/2020 12:00:00 AM | 3 | 4x4 | Permit Number 781917 | 5999987.51846 | 2111668.14853 | 37.7782363548085 | -122.443606817465 | (37.7782363548085, -122.443606817465) | 15 | 5 | 11 | 29490 | 16 | |
| 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 | |
| 71950 | 176972 | Planning Code 138.1 required 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 161 University St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | Permit Number 781886 | 6008005.59306 | 2093164.83572 | 37.7278844827614 | -122.414559571484 | (37.7278844827614, -122.414559571484) | 9 | 3 | 7 | 309 | 28 | ||
| 131553 | 256083 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2187 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/31/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781873 | 5989736 | 2100494 | 37.7469651502436 | -122.478252958666 | (37.7469651502436, -122.478252958666) | 1 | 8 | 3 | 29491 | 35 | |
| 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 | |
| 2678 | 157809 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 647 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2019 12:00:00 AM | 3 | 3x3 | Permit Number 781831 | 6002443.37703 | 2099727.28553 | 37.7455893990301 | -122.4342572226 | (37.7455893990301, -122.4342572226) | 2 | 7 | 5 | 63 | 22 | |
| 79208 | 43753 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 350 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/26/2000 12:00:00 AM | 10 | Permit Number 781765 | 5991242.53743 | 2113051.18607 | 37.781531164196 | -122.473959543362 | (37.781531164196, -122.473959543362) | 11 | 6 | 2 | 54 | 26 | |
| 11330 | 166753 | Planning Code 138.1 required 2 | Schinus molle :: California Pepper 91 | 350 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/26/2019 12:00:00 AM | 3 | 4x4 | Permit Number 781737 | 6002856.72425 | 2101550.76622 | 37.7506197011549 | -122.43295818429 | (37.7506197011549, -122.43295818429) | 2 | 4 | 5 | 28862 | 22 | |
| 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 | |
| 173437 | 255664 | Planning Code 138.1 required 2 | Tree(s) :: 17 | 368 Princeton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781650 | 6007860.32032 | 2092132.7947 | 37.7250425565594 | -122.414988767826 | (37.7250425565594, -122.414988767826) | 9 | 3 | 7 | 309 | 28 | |
| 182124 | 166234 | Planning Code 138.1 required 2 | Tree(s) :: 17 | 2986 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781629 | 6008392.95809 | 2103319.50363 | 37.7557887182862 | -122.413938481678 | (37.7557887182862, -122.413938481678) | 2 | 4 | 7 | 28859 | 19 | |
| 6664 | 226514 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 1225 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/07/2019 12:00:00 AM | 3 | 3x3 | Permit Number 781565 | 6005204.64951 | 2101211.39699 | 37.7498207677153 | -122.424814719741 | (37.7498207677153, -122.424814719741) | 2 | 4 | 5 | 28859 | 19 | |
| 81070 | 256613 | Planning Code 138.1 required 2 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2214 36th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/13/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781468 | 5985177 | 2100108 | 37.745639596763 | -122.493988903155 | (37.745639596763, -122.493988903155) | 1 | 8 | 3 | 29491 | 35 | |
| 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 | |
| 157324 | 32045 | Planning Code 138.1 required 2 | Ginkgo biloba :: Maidenhair Tree 22 | 2979 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/07/2018 12:00:00 AM | 3 | Permit Number 781325 | 5999951.23823 | 2116389.65594 | 37.7911983214916 | -122.444071670681 | (37.7911983214916, -122.444071670681) | 13 | 6 | 1 | 29490 | 27 | ||
| 7193 | 254151 | Planning Code 138.1 required 2 | Tree(s) :: 17 | 201 Steuart St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/09/2018 12:00:00 AM | 3 | 4x4 | Permit Number 781165 | |||||||||||
| 8723 | 254152 | Planning Code 138.1 required 2 | Tree(s) :: 17 | 201 Steuart St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/09/2018 12:00:00 AM | 3 | 4x4 | Permit Number 781165 | |||||||||||
| 9600 | 254154 | Planning Code 138.1 required 2 | Tree(s) :: 17 | 201 Steuart St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/09/2018 12:00:00 AM | 3 | 4x4 | Permit Number 781165 | |||||||||||
| 15617 | 254153 | Planning Code 138.1 required 2 | Tree(s) :: 17 | 201 Steuart St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/09/2018 12:00:00 AM | 3 | 4x4 | Permit Number 781165 | |||||||||||
| 37845 | 256671 | Planning Code 138.1 required 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 423 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2019 12:00:00 AM | 3 | 3x3 | Permit Number 781122 | 5994719 | 2091406 | 37.7222997368586 | -122.460363933092 | (37.7222997368586, -122.460363933092) | 9 | 8 | 4 | 28861 | 24 | |
| 19998 | 69332 | Planning Code 138.1 required 2 | Tilia cordata :: Littleleaf Linden 12 | 160 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/23/1994 12:00:00 AM | 11 | Permit Number 781107 | 6013130.58112 | 2106316.68773 | 37.7642832664742 | -122.397764366249 | (37.7642832664742, -122.397764366249) | 14 | 3 | 8 | 28856 | 29 | ||
| 685 | 151339 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 1411 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/09/2019 12:00:00 AM | 3 | 6x6 | Permit Number 781016 | 6009578.8057 | 2100900.01209 | 37.7492118628581 | -122.409666655187 | (37.7492118628581, -122.409666655187) | 2 | 4 | 7 | 28859 | 19 | |
| 21868 | 221950 | Planning Code 138.1 required 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 31 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | Permit Number 780973 | 6006097.6775 | 2099053.58173 | 37.7439462971915 | -122.421573349947 | (37.7439462971915, -122.421573349947) | 2 | 7 | 7 | 28859 | 2 | ||
| 7195 | 4140 | Planning Code 138.1 required 2 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 3620 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2020 12:00:00 AM | 3 | 3x6 | Permit Number 780969 | 6006062.29639 | 2100597.35658 | 37.7481831571401 | -122.421805323766 | (37.7481831571401, -122.421805323766) | 2 | 4 | 5 | 28859 | 19 | |
| 78246 | 143041 | Planning Code 138.1 required 2 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2000 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/2017 12:00:00 AM | 3 | Width 0ft | Permit Number 780933 | 6009568.471 | 2120534.3867 | 37.8031226669303 | -122.411089086343 | (37.8031226669303, -122.411089086343) | 3 | 1 | 10 | 308 | 23 | |
| 190939 | 13063 | Planning Code 138.1 required 2 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 590 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/2017 12:00:00 AM | 3 | 2X2 | Permit Number 780933 | 6009554.3361 | 2120533.7978 | 37.803120257284 | -122.411137959105 | (37.803120257284, -122.411137959105) | 3 | 1 | 10 | 308 | 23 | |
| 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 | |
| 119839 | 152118 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 44 Woodward St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/26/2018 12:00:00 AM | 3 | 3x3 | Permit Number 780873 | 6006474.76942 | 2108215.62621 | 37.7691244070031 | -122.420919809024 | (37.7691244070031, -122.420919809024) | 8 | 4 | 7 | 28853 | 19 | |
| 639 | 261347 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 3300x Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/13/2020 12:00:00 AM | 3 | 3X3 | Permit Number 780859 | 5994476 | 2087151 | 37.7106025369579 | -122.460895688785 | (37.7106025369579, -122.460895688785) | 9 | 8 | 6 | 28861 | 24 | |
| 14258 | 261352 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 297 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/13/2020 12:00:00 AM | 3 | 3x3 | Permit Number 780859 | 5994172 | 2087374 | 37.7111973453091 | -122.461962532307 | (37.7111973453091, -122.461962532307) | 9 | 8 | 6 | 28861 | 24 | |
| 15290 | 25338 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 3300X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/13/2020 12:00:00 AM | 3 | 3X3 | Permit Number 780859 | 5994476 | 2087151 | 37.7106025369579 | -122.460895688785 | (37.7106025369579, -122.460895688785) | 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 | |
| 41357 | 255423 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 2398X 44th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/2018 12:00:00 AM | 3 | 3x3 | Permit Number 780836 | 5982745 | 2098835 | 37.7420016902952 | -122.502304062071 | (37.7420016902952, -122.502304062071) | 1 | 8 | 3 | 29491 | 35 | |
| 56985 | 255424 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 2398X 44th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/2018 12:00:00 AM | 3 | 3x3 | Permit Number 780836 | 5982745 | 2098835 | 37.7420016902952 | -122.502304062071 | (37.7420016902952, -122.502304062071) | 1 | 8 | 3 | 29491 | 35 | |
| 170704 | 255422 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 2398X 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/2018 12:00:00 AM | 3 | 3x3 | Permit Number 780836 | 5982745 | 2098835 | 37.7420016902952 | -122.502304062071 | (37.7420016902952, -122.502304062071) | 1 | 8 | 3 | 29491 | 35 | |
| 4743 | 167761 | Planning Code 138.1 required 2 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 451 Buena Vista Ave East | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2020 12:00:00 AM | 3 | 4x4 | Permit Number 780770 | 6000439.87639 | 2107208.3352 | 37.7660166188918 | -122.441721798828 | (37.7660166188918, -122.441721798828) | 15 | 5 | 5 | 29492 | 3 | |
| 27355 | 239457 | Planning Code 138.1 required 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 165 Sussex St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/11/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 780743 | 6001959.66963 | 2096487.1672 | 37.7366653238346 | -122.435698035437 | (37.7366653238346, -122.435698035437) | 2 | 7 | 5 | 63 | 7 | |
| 90355 | 222216 | Planning Code 138.1 required 2 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2 Van Buren St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | Width 3ft | Permit Number 780743 | 6002014.89564 | 2096488.79408 | 37.7366729276156 | -122.435507211887 | (37.7366729276156, -122.435507211887) | 2 | 7 | 5 | 63 | 7 | ||
| 115391 | 224618 | Planning Code 138.1 required 2 | Ficus microcarpa :: Chinese Banyan 97 | 165 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 13 | Width 3ft | Permit Number 780743 | 6001936.24436 | 2096476.10277 | 37.7366336128599 | -122.435778235198 | (37.7366336128599, -122.435778235198) | 2 | 7 | 5 | 63 | 7 | ||
| 159683 | 239458 | Planning Code 138.1 required 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 165 Sussex St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/11/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 780743 | 6001977.4736 | 2096494.97635 | 37.7366877772239 | -122.435637038029 | (37.7366877772239, -122.435637038029) | 2 | 7 | 5 | 63 | 7 | |
| 152110 | 239088 | Planning Code 138.1 required 2 | Pyrus calleryana :: Ornamental Pear 44 | 3855 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 13 | 3x3 | Permit Number 780732 | 6004794.15723 | 2100737.40071 | 37.748496089722 | -122.426200479689 | (37.748496089722, -122.426200479689) | 2 | 4 | 5 | 63 | 22 | ||
| 20702 | 37086 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1426 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/22/2017 12:00:00 AM | 3 | Permit Number 780691 | 5981873.63686209 | 2105374.96731705 | 37.7599073668224 | -122.505801636192 | (37.7599073668224, -122.505801636192) | 1 | 8 | 3 | 56 | 35 | |
| 34077 | 256492 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 280 Diamond St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/17/2018 12:00:00 AM | 3 | 3x3 | Permit Number 780675 | 6001741.51076 | 2104267.16046 | 37.7580149486389 | -122.437009129166 | (37.7580149486389, -122.437009129166) | 2 | 4 | 5 | 28862 | 3 | |
| 38312 | 167082 | Planning Code 138.1 required 2 | Pittosporum undulatum :: Victorian Box 36 | 280 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/17/2018 12:00:00 AM | 3 | 3x3 | Permit Number 780675 | 6001741.51076 | 2104267.16046 | 37.7580149486389 | -122.437009129166 | (37.7580149486389, -122.437009129166) | 2 | 4 | 5 | 28862 | 3 | |
| 84809 | 167131 | Planning Code 138.1 required 2 | Magnolia grandiflora :: Southern Magnolia 19 | 4540 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/20/2018 12:00:00 AM | 3 | 3x3 | Permit Number 780648 | 6000902.50099 | 2104660.33643 | 37.7590467894041 | -122.439938965707 | (37.7590467894041, -122.439938965707) | 2 | 4 | 5 | 28862 | 3 | |
| 178223 | 256896 | Planning Code 138.1 required 2 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 470 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2018 12:00:00 AM | 3 | 3x3 | Permit Number 780643 | 5985651.17942 | 2112710.44444 | 37.7802701294342 | -122.493277571063 | (37.7802701294342, -122.493277571063) | 11 | 6 | 2 | 55 | 26 | |
| 1902 | 261997 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 607X Florida St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/2020 12:00:00 AM | 3 | 4x4 | Permit Number 780566 | 6009282 | 2105415 | 37.7615923672124 | -122.411011879772 | (37.7615923672124, -122.411011879772) | 2 | 4 | 7 | 28859 | 19 | |
| 2224 | 236583 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 607X Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/2020 12:00:00 AM | 3 | 4x4 | Permit Number 780566 | 6009282 | 2105415 | 37.7615923672124 | -122.411011879772 | (37.7615923672124, -122.411011879772) | 2 | 4 | 7 | 28859 | 19 | |
| 3426 | 231237 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 2000 Bryant St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/2020 12:00:00 AM | 3 | 4x4 | Permit Number 780566 | 6009518.21853 | 2105339.01767 | 37.7613969805183 | -122.410189528218 | (37.7613969805183, -122.410189528218) | 2 | 4 | 7 | 28859 | 19 | |
| 3779 | 231240 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 2000 Bryant St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/2020 12:00:00 AM | 3 | 4x4 | Permit Number 780566 | 6009523.77815 | 2105243.21899 | 37.7611342507514 | -122.410163536041 | (37.7611342507514, -122.410163536041) | 2 | 4 | 7 | 28859 | 19 | |
| 5042 | 231235 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 2000 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/2020 12:00:00 AM | 3 | 4x4 | Permit Number 780566 | 6009517.2839 | 2105385.27542 | 37.7615239413898 | -122.410196026727 | (37.7615239413898, -122.410196026727) | 2 | 4 | 7 | 28859 | 19 | |
| 7258 | 262001 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 607X Florida St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/2020 12:00:00 AM | 3 | 4x4 | Permit Number 780566 | 6009282 | 2105415 | 37.7615923672124 | -122.411011879772 | (37.7615923672124, -122.411011879772) | 2 | 4 | 7 | 28859 | 19 | |
| 7502 | 236582 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 607 Florida St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/2020 12:00:00 AM | 3 | 4x4 | Permit Number 780566 | 6009292.77734 | 2105398.52034 | 37.7615477221736 | -122.410973441191 | (37.7615477221736, -122.410973441191) | 2 | 4 | 7 | 28859 | 19 | |
| 8936 | 261999 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 607X Florida St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/2020 12:00:00 AM | 3 | 4x4 | Permit Number 780566 | 6009282 | 2105415 | 37.7615923672124 | -122.411011879772 | (37.7615923672124, -122.411011879772) | 2 | 4 | 7 | 28859 | 19 | |
| 9770 | 262000 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 607X Florida St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/2020 12:00:00 AM | 3 | 4x4 | Permit Number 780566 | 6009282 | 2105415 | 37.7615923672124 | -122.411011879772 | (37.7615923672124, -122.411011879772) | 2 | 4 | 7 | 28859 | 19 | |
| 10030 | 261998 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 607X Florida St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/2020 12:00:00 AM | 3 | 4x4 | Permit Number 780566 | 6009282 | 2105415 | 37.7615923672124 | -122.411011879772 | (37.7615923672124, -122.411011879772) | 2 | 4 | 7 | 28859 | 19 | |
| 12391 | 221098 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2815 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/2020 12:00:00 AM | 3 | 4x4 | Permit Number 780566 | 6009314.5684 | 2105431.86525 | 37.7616405016156 | -122.410900429722 | (37.7616405016156, -122.410900429722) | 2 | 4 | 7 | 28859 | 19 | |
| 15138 | 231239 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 2000 Bryant St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/2020 12:00:00 AM | 3 | 4x4 | Permit Number 780566 | 6009523.66683 | 2105264.06886 | 37.7611914935157 | -122.410165393114 | (37.7611914935157, -122.410165393114) | 2 | 4 | 7 | 28859 | 19 | |
| 18826 | 262002 | Planning Code 138.1 required 2 | Platanus x hispanica :: Sycamore: London Plane 27 | 607X Florida St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/2020 12:00:00 AM | 3 | 4x4 | Permit Number 780566 | 6009282 | 2105415 | 37.7615923672124 | -122.411011879772 | (37.7615923672124, -122.411011879772) | 2 | 4 | 7 | 28859 | 19 | |
| 16474 | 253340 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 1045 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/23/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780536 | 6004464 | 2102825 | 37.7542094840672 | -122.427490860103 | (37.7542094840672, -122.427490860103) | 2 | 4 | 5 | 28862 | 22 | |
| 14212 | 253124 | Planning Code 138.1 required 2 | Tree(s) :: 17 | 399x Lexington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/19/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780530 |
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) );