trees
439 rows where qSpecies_id = 148 sorted by PlotSize 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 126905 | 243200 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 220 Valencia St | 1 | : | Tree | Private 2 | 05/08/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 781817 | 6006037.36793 | 2108352.33176 | 37.7694751030168 | -122.422442472745 | (37.7694751030168, -122.422442472745) | 8 | 4 | 5 | 28853 | 19 | |
| 159637 | 123676 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 4620 California St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 782655 | 5993209.68387 | 2114188.73207 | 37.7847683024995 | -122.467236954218 | (37.7847683024995, -122.467236954218) | 11 | 6 | 2 | 54 | 11 | |
| 7301 | 172637 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1675 California St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2013 12:00:00 AM | 3 | Width 3ft | 6006387.36369 | 2115949.63382 | 37.790355184582 | -122.421771561426 | (37.790355184582, -122.421771561426) | 13 | 9 | 10 | 28858 | 21 | ||
| 47413 | 234736 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 200 Henry St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/29/2017 08:58:00 AM | 3 | Width 3ft | 6002089.32864 | 2107372.68693 | 37.7665617321566 | -122.436028447274 | (37.7665617321566, -122.436028447274) | 15 | 5 | 5 | 28862 | 3 | ||
| 120954 | 23883 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1500X Webster St | 6 | Median : Cutout | Tree | DPW 1 | 30 | 6X6 | 6003644.6262703 | 2113904.6308207 | 37.7845850728987 | -122.431115216253 | (37.7845850728987, -122.431115216253) | 13 | 9 | 11 | 29490 | 41 | |||
| 18997 | 146023 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 211 Cornwall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 5x5 | 5994760.92974 | 2114191.03867 | 37.7848640608675 | -122.46187036015 | (37.7848640608675, -122.46187036015) | 11 | 6 | 2 | 54 | 11 | |||
| 61145 | 97531 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 90 07th St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/01/2011 12:00:00 AM | 3 | 5x5 | Permit Number 768281 | 6009381.233023 | 2111863.03951 | 37.7793027506323 | -122.411124154099 | (37.7793027506323, -122.411124154099) | 8 | 2 | 9 | 28853 | 34 | |
| 66289 | 97530 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 90 07th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/01/2011 12:00:00 AM | 3 | 5x5 | Permit Number 768281 | 6009381.233023 | 2111863.03951 | 37.7793027506323 | -122.411124154099 | (37.7793027506323, -122.411124154099) | 8 | 2 | 9 | 28853 | 34 | |
| 71851 | 97533 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 90 07th St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/01/2011 12:00:00 AM | 3 | 5x5 | Permit Number 768281 | 6009381.233023 | 2111863.03951 | 37.7793027506323 | -122.411124154099 | (37.7793027506323, -122.411124154099) | 8 | 2 | 9 | 28853 | 34 | |
| 98088 | 97532 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 90 07th St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/01/2011 12:00:00 AM | 3 | 5x5 | Permit Number 768281 | 6009381.233023 | 2111863.03951 | 37.7793027506323 | -122.411124154099 | (37.7793027506323, -122.411124154099) | 8 | 2 | 9 | 28853 | 34 | |
| 126874 | 5235 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1100 Divisadero St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 5x5 | 6001436.83253 | 2112303.93811 | 37.7800646238097 | -122.438638687165 | (37.7800646238097, -122.438638687165) | 15 | 5 | 11 | 29490 | 41 | |||
| 127325 | 97529 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 90 07th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/01/2011 12:00:00 AM | 3 | 5x5 | Permit Number 768281 | 6009381.233023 | 2111863.03951 | 37.7793027506323 | -122.411124154099 | (37.7793027506323, -122.411124154099) | 8 | 2 | 9 | 28853 | 34 | |
| 2703 | 2795 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 6530X California St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 75 | 5 | 5987349.71414 | 2113973.97564 | 37.783838627391 | -122.487494476151 | (37.783838627391, -122.487494476151) | 11 | 6 | 1 | 55 | 33 | |||
| 50243 | 26639 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 6530X California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/02/1998 12:00:00 AM | 80 | 5 | 5987349.71414 | 2113973.97564 | 37.783838627391 | -122.487494476151 | (37.783838627391, -122.487494476151) | 11 | 6 | 1 | 55 | 33 | ||
| 23054 | 104167 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 2000 Ellis St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/21/2013 12:00:00 AM | 4x4 | Permit Number 768572 | 6001219.4 | 2112910.7 | 37.7817182660666 | -122.43943438946 | (37.7817182660666, -122.43943438946) | 15 | 5 | 11 | 29490 | 41 | ||
| 23858 | 85447 | - 12 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 360Y13 Valencia St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | 8 | 4 | 5 | 28853 | 19 | ||
| 44768 | 85446 | - 12 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 360Y12 Valencia St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | 8 | 4 | 5 | 28853 | 19 | ||
| 53422 | 84564 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1100X Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 5 | 4x4 | Permit Number 769743 | 6003799.76299969 | 2101850.31253229 | 37.7514956297527 | -122.429718442511 | (37.7514956297527, -122.429718442511) | 2 | 4 | 5 | 28862 | 22 |
| 54616 | 13948 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1112X Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/13/1994 12:00:00 AM | 12 | 4x4 | 6008868.4803223 | 2112239.1730786 | 37.7803067555436 | -122.412924586563 | (37.7803067555436, -122.412924586563) | 7 | 2 | 9 | 28852 | 36 | ||
| 58660 | 13940 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1140X Market St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 4x4 | 6008690.2869843 | 2112068.9420038 | 37.7798293375501 | -122.413528998881 | (37.7798293375501, -122.413528998881) | 7 | 2 | 9 | 28852 | 36 | |||
| 58809 | 14170 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1776X Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/11/2015 10:09:00 AM | 3 | 4x4 | 6005777.896097 | 2109293.199395 | 37.7720438591777 | -122.423406872271 | (37.7720438591777, -122.423406872271) | 7 | 2 | 11 | 28852 | 10 | ||
| 64235 | 13870 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1000 Market St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/10/2007 12:00:00 AM | 8 | 4x4 | 6009621.3575962 | 2112944.5572428 | 37.7822858053101 | -122.410369845025 | (37.7822858053101, -122.410369845025) | 14 | 2 | 9 | 28852 | 36 | ||
| 72192 | 85433 | - 12 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 360Y1 Valencia St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | 8 | 4 | 5 | 28853 | 19 | ||
| 75312 | 28323 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 3100 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/10/2004 12:00:00 AM | 11 | 4x4 | 6007076.90394 | 2100561.83623 | 37.7481427912413 | -122.418294317161 | (37.7481427912413, -122.418294317161) | 2 | 4 | 7 | 28859 | 2 | ||
| 76766 | 85437 | - 12 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 360Y4 Valencia St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | 8 | 4 | 5 | 28853 | 19 | ||
| 79095 | 85444 | - 12 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 360Y10 Valencia St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | 8 | 4 | 5 | 28853 | 19 | ||
| 84052 | 13946 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1108 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/08/1999 12:00:00 AM | 12 | 4x4 | 6008893.4024674 | 2112262.9816205 | 37.7803735270406 | -122.412840052753 | (37.7803735270406, -122.412840052753) | 7 | 2 | 9 | 28852 | 36 | ||
| 88068 | 27805 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 350X The Embarcadero | 4 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 11/15/2012 12:00:00 AM | 12 | 4x4 | Permit Number 769363 | 6013785.7946449 | 2118604.8635638 | 37.7980602547356 | -122.396359500707 | (37.7980602547356, -122.396359500707) | 3 | 1 | 10 | 28860 | 6 | |
| 94031 | 85448 | - 12 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 360Y14 Valencia St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | 8 | 4 | 5 | 28853 | 19 | ||
| 95087 | 84562 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1100X Sanchez St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 5 | 4x4 | Permit Number 769743 | 6003799.76299969 | 2101850.31253229 | 37.7514956297527 | -122.429718442511 | (37.7514956297527, -122.429718442511) | 2 | 4 | 5 | 28862 | 22 |
| 96901 | 85439 | - 12 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 360Y5 Valencia St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | 8 | 4 | 5 | 28853 | 19 | ||
| 97976 | 13567 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 484X Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/10/2007 12:00:00 AM | 6 | 4x4 | 6012939.9788554 | 2116125.819916 | 37.791206285852 | -122.399112186297 | (37.791206285852, -122.399112186297) | 4 | 2 | 10 | 28860 | 6 | ||
| 98801 | 84560 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1095X Sanchez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 5 | 4x4 | Permit Number 769743 | 6003825.808508 | 2101903.8292833 | 37.7516440490083 | -122.429632190427 | (37.7516440490083, -122.429632190427) | 2 | 4 | 5 | 28862 | 22 |
| 106090 | 13837 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 972 Market St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/28/2005 12:00:00 AM | 3 | 4x4 | 6009828.8708825 | 2113156.6502082 | 37.7828797927495 | -122.409666913005 | (37.7828797927495, -122.409666913005) | 14 | 2 | 9 | 28852 | 36 | ||
| 109129 | 85445 | - 12 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 360Y11 Valencia St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | 8 | 4 | 5 | 28853 | 19 | ||
| 111192 | 85440 | - 12 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 360Y6 Valencia St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | 8 | 4 | 5 | 28853 | 19 | ||
| 113755 | 85435 | - 12 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 360Y3 Valencia St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 08/07/2006 12:00:00 AM | 3 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | 8 | 4 | 5 | 28853 | 19 | ||
| 116463 | 85443 | - 12 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 360Y9 Valencia St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | 8 | 4 | 5 | 28853 | 19 | |||
| 131372 | 101526 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 2300X Sacramento St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4x4 | 6003597.8 | 2116101.6 | 37.7906147410217 | -122.431434108251 | (37.7906147410217, -122.431434108251) | 13 | 9 | 1 | 29490 | 27 | |||
| 135140 | 84557 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1111X Sanchez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 5 | 4x4 | Permit Number 769743 | 6003828.67431583 | 2101851.90831311 | 37.7515016484692 | -122.429618577466 | (37.7515016484692, -122.429618577466) | 2 | 4 | 5 | 28862 | 22 |
| 146391 | 104166 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 2000 Ellis St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/21/2013 12:00:00 AM | 4x4 | Permit Number 768572 | 6001219.4 | 2112910.7 | 37.7817182660666 | -122.43943438946 | (37.7817182660666, -122.43943438946) | 15 | 5 | 11 | 29490 | 41 | ||
| 147819 | 13927 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1091 Market St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/30/2015 07:43:00 AM | 3 | 4x4 | 6009083.7080174 | 2112335.6900033 | 37.7805838469879 | -122.412186834853 | (37.7805838469879, -122.412186834853) | 14 | 2 | 9 | 28853 | 34 | ||
| 155322 | 13906 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1063 Market St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/22/2016 11:38:00 AM | 3 | 4x4 | 6009266.7492 | 2112493.5891 | 37.7810276692866 | -122.411564765047 | (37.7810276692866, -122.411564765047) | 14 | 2 | 9 | 28853 | 34 | ||
| 155330 | 14031 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1244 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/28/2005 12:00:00 AM | 3 | 4x4 | 6008141.7716697 | 2111544.9362715 | 37.7783597285455 | -122.415389454094 | (37.7783597285455, -122.415389454094) | 7 | 2 | 9 | 28852 | 36 | ||
| 159490 | 104165 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 2000 Ellis St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/21/2013 12:00:00 AM | 4x4 | Permit Number 768572 | 6001219.4 | 2112910.7 | 37.7817182660666 | -122.43943438946 | (37.7817182660666, -122.43943438946) | 15 | 5 | 11 | 29490 | 41 | ||
| 162970 | 14117 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1572X Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/19/2015 12:52:00 PM | 3 | 4x4 | 6006735.3160639 | 2110201.3257307 | 37.7745913473524 | -122.420159536302 | (37.7745913473524, -122.420159536302) | 7 | 2 | 11 | 28852 | 10 | ||
| 165300 | 85441 | - 12 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 360Y7 Valencia St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | 8 | 4 | 5 | 28853 | 19 | ||
| 168283 | 84563 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1100X Sanchez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 5 | 4x4 | Permit Number 769743 | 6003799.76299969 | 2101850.31253229 | 37.7514956297527 | -122.429718442511 | (37.7514956297527, -122.429718442511) | 2 | 4 | 5 | 28862 | 22 |
| 170510 | 85434 | - 12 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 360Y2 Valencia St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 08/23/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | 8 | 4 | 5 | 28853 | 19 | ||
| 175372 | 85442 | - 12 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 360Y8 Valencia St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | 8 | 4 | 5 | 28853 | 19 | ||
| 180891 | 84558 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1111X Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 5 | 4x4 | Permit Number 769743 | 6003828.67431583 | 2101851.90831311 | 37.7515016484692 | -122.429618577466 | (37.7515016484692, -122.429618577466) | 2 | 4 | 5 | 28862 | 22 |
| 192322 | 104164 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 2000 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/21/2013 12:00:00 AM | 4x4 | Permit Number 768572 | 6001219.4 | 2112910.7 | 37.7817182660666 | -122.43943438946 | (37.7817182660666, -122.43943438946) | 15 | 5 | 11 | 29490 | 41 | ||
| 7309 | 14032 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1245 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/10/2012 12:00:00 AM | 3 | 4X4 | 6008153.5614441 | 2111445.1787375 | 37.7780864807987 | -122.415341604846 | (37.7780864807987, -122.415341604846) | 8 | 2 | 9 | 28853 | 34 | ||
| 19974 | 28151 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 100X King St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6015580.6531721 | 2111966.262542 | 37.7799318892041 | -122.38968480475 | (37.7799318892041, -122.38968480475) | 6 | 2 | 9 | 28856 | 20 | |||
| 21275 | 13852 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 989 Market St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 4X4 | 6009747.4153425 | 2112968.1407914 | 37.7823576258181 | -122.409935404775 | (37.7823576258181, -122.409935404775) | 14 | 2 | 9 | 28853 | 34 | |||
| 26656 | 13928 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1091 Market St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/12/2000 12:00:00 AM | 20 | 4X4 | 6009083.7080174 | 2112335.6900033 | 37.7805838469879 | -122.412186834853 | (37.7805838469879, -122.412186834853) | 14 | 2 | 9 | 28853 | 34 | ||
| 27923 | 28655 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 3395 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/29/2004 12:00:00 AM | 3 | 4X4 | 6006036.04282 | 2098446.39955 | 37.7422756364725 | -122.421743350168 | (37.7422756364725, -122.421743350168) | 2 | 7 | 7 | 28859 | 2 | ||
| 29819 | 27975 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 300 The Embarcadero | 12 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | 3 | 1 | 10 | 28860 | 6 | ||
| 32018 | 14183 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1844 Market St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/26/2012 12:00:00 AM | 12 | 4X4 | Permit Number 769087 | 6005554.6579568 | 2109080.5883488 | 37.7714474783148 | -122.424163948162 | (37.7714474783148, -122.424163948162) | 7 | 2 | 5 | 28852 | 10 | |
| 33497 | 27984 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 300 The Embarcadero | 21 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | 3 | 1 | 10 | 28860 | 6 | ||
| 34463 | 28181 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 199X King St | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6014965.0656592 | 2111288.9310025 | 37.7780379351787 | -122.391767040652 | (37.7780379351787, -122.391767040652) | 6 | 2 | 9 | 28856 | 20 | |||
| 35228 | 28154 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 100X King St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6015580.6531721 | 2111966.262542 | 37.7799318892041 | -122.38968480475 | (37.7799318892041, -122.38968480475) | 6 | 2 | 9 | 28856 | 20 | |||
| 36646 | 14315 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 2190X Market St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/22/2000 12:00:00 AM | 6 | 4X4 | 6003585.7913445 | 2107202.1800302 | 37.7661784627239 | -122.430840279858 | (37.7661784627239, -122.430840279858) | 7 | 4 | 5 | 28862 | 3 | ||
| 39391 | 28180 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 199X King St | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6014965.0656592 | 2111288.9310025 | 37.7780379351787 | -122.391767040652 | (37.7780379351787, -122.391767040652) | 6 | 2 | 9 | 28856 | 20 | |||
| 39483 | 28169 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 199X King St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6014965.0656592 | 2111288.9310025 | 37.7780379351787 | -122.391767040652 | (37.7780379351787, -122.391767040652) | 6 | 2 | 9 | 28856 | 20 | |||
| 40360 | 13581 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 525 Market St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6012787.5365724 | 2115865.9219292 | 37.7904841708264 | -122.399621379879 | (37.7904841708264, -122.399621379879) | 12 | 2 | 9 | 28855 | 6 | |||
| 42062 | 13492 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 215 Market St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/28/2005 12:00:00 AM | 6 | 4X4 | 6013729.1406446 | 2116782.463481 | 37.7930532214207 | -122.396427736192 | (37.7930532214207, -122.396427736192) | 12 | 2 | 9 | 28855 | 6 | ||
| 42580 | 28156 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 100X King St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6015580.6531721 | 2111966.262542 | 37.7799318892041 | -122.38968480475 | (37.7799318892041, -122.38968480475) | 6 | 2 | 9 | 28856 | 20 | |||
| 42673 | 28160 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 100X King St | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6015580.6531721 | 2111966.262542 | 37.7799318892041 | -122.38968480475 | (37.7799318892041, -122.38968480475) | 6 | 2 | 9 | 28856 | 20 | |||
| 43063 | 13918 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1077 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/30/2015 08:31:00 AM | 3 | 4X4 | 6009171.9340081 | 2112419.7611149 | 37.7808196363131 | -122.411887560568 | (37.7808196363131, -122.411887560568) | 14 | 2 | 9 | 28853 | 34 | ||
| 45913 | 28158 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 100X King St | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6015580.6531721 | 2111966.262542 | 37.7799318892041 | -122.38968480475 | (37.7799318892041, -122.38968480475) | 6 | 2 | 9 | 28856 | 20 | |||
| 46114 | 13919 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1077 Market St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 4X4 | 6009171.9340081 | 2112419.7611149 | 37.7808196363131 | -122.411887560568 | (37.7808196363131, -122.411887560568) | 14 | 2 | 9 | 28853 | 34 | |||
| 46154 | 14094 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1455 Market St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2004 12:00:00 AM | 3 | 4X4 | 6007204.2526311 | 2110536.5858952 | 37.7755383026332 | -122.418561167244 | (37.7755383026332, -122.418561167244) | 8 | 2 | 9 | 28853 | 34 | ||
| 47018 | 27972 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 300 The Embarcadero | 9 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | 3 | 1 | 10 | 28860 | 6 | ||
| 53356 | 27992 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 300 The Embarcadero | 29 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | 3 | 1 | 10 | 28860 | 6 | ||
| 54544 | 27988 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 300 The Embarcadero | 25 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | 3 | 1 | 10 | 28860 | 6 | ||
| 55209 | 28153 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 100X King St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6015580.6531721 | 2111966.262542 | 37.7799318892041 | -122.38968480475 | (37.7799318892041, -122.38968480475) | 6 | 2 | 9 | 28856 | 20 | |||
| 55995 | 28163 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 100X King St | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6015580.6531721 | 2111966.262542 | 37.7799318892041 | -122.38968480475 | (37.7799318892041, -122.38968480475) | 6 | 2 | 9 | 28856 | 20 | |||
| 58562 | 27965 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 300 The Embarcadero | 2 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | 3 | 1 | 10 | 28860 | 6 | ||
| 60140 | 28161 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 100X King St | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6015580.6531721 | 2111966.262542 | 37.7799318892041 | -122.38968480475 | (37.7799318892041, -122.38968480475) | 6 | 2 | 9 | 28856 | 20 | |||
| 61352 | 27964 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 300 The Embarcadero | 1 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | 3 | 1 | 10 | 28860 | 6 | ||
| 61354 | 24389 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 3641 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/29/2004 12:00:00 AM | 3 | 4X4 | 6005406.19827 | 2096949.60563 | 37.7381302401684 | -122.423814755555 | (37.7381302401684, -122.423814755555) | 2 | 7 | 7 | 28859 | 2 | ||
| 64239 | 28155 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 100X King St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6015580.6531721 | 2111966.262542 | 37.7799318892041 | -122.38968480475 | (37.7799318892041, -122.38968480475) | 6 | 2 | 9 | 28856 | 20 | |||
| 66342 | 14084 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1411 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/27/2015 12:00:00 AM | 3 | 4X4 | Permit Number 775519 | 6007340.8551319 | 2110667.3761307 | 37.7759051108463 | -122.418097899429 | (37.7759051108463, -122.418097899429) | 8 | 2 | 9 | 28853 | 34 | |
| 68947 | 13857 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 991 Market St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/10/2007 12:00:00 AM | 6 | 4X4 | 6009733.8299349 | 2112955.195175 | 37.7823213188284 | -122.409981490315 | (37.7823213188284, -122.409981490315) | 14 | 2 | 9 | 28853 | 34 | ||
| 71285 | 28167 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 199X King St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6014965.0656592 | 2111288.9310025 | 37.7780379351787 | -122.391767040652 | (37.7780379351787, -122.391767040652) | 6 | 2 | 9 | 28856 | 20 | |||
| 72523 | 14128 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1621 Market St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/27/2017 09:15:00 AM | 3 | 4X4 | 6006600.23891 | 2109952.28073 | 37.7738999176888 | -122.420609113022 | (37.7738999176888, -122.420609113022) | 8 | 2 | 9 | 28853 | 19 | ||
| 74683 | 13505 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 245 Market St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/28/2005 12:00:00 AM | 6 | 4X4 | 6013642.6483486 | 2116679.2066582 | 37.7927648888925 | -122.396719764541 | (37.7927648888925, -122.396719764541) | 12 | 2 | 9 | 28855 | 6 | ||
| 74959 | 15604 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 3333 Mission St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/10/2004 12:00:00 AM | 3 | 4X4 | 6006368.01098 | 2098829.09498 | 37.7433451466609 | -122.420622664534 | (37.7433451466609, -122.420622664534) | 2 | 7 | 7 | 28859 | 2 | ||
| 76168 | 27995 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 300 The Embarcadero | 32 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | 3 | 1 | 10 | 28860 | 6 | ||
| 80899 | 13830 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 965 Market St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/10/2007 12:00:00 AM | 3 | 4X4 | 6009908.9307448 | 2113122.0497873 | 37.7827892741888 | -122.409387495448 | (37.7827892741888, -122.409387495448) | 14 | 2 | 9 | 28853 | 34 | ||
| 81270 | 22592 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 785X Franklin St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/14/2002 12:00:00 AM | 3 | 4X4 | 6006155.3095005 | 2112777.9901286 | 37.7816335448796 | -122.422349009875 | (37.7816335448796, -122.422349009875) | 7 | 9 | 11 | 28852 | 41 | ||
| 81731 | 14123 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1615 Market St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/18/2014 02:16:00 PM | 3 | 4X4 | 6006597.57832 | 2109978.9478798 | 37.7739729893435 | -122.420620209869 | (37.7739729893435, -122.420620209869) | 8 | 2 | 9 | 28853 | 19 | ||
| 81937 | 16723 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1075 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/2012 12:00:00 AM | 3 | 4X4 | 6006252.84558 | 2113856.064 | 37.7845991729485 | -122.422088192257 | (37.7845991729485, -122.422088192257) | 7 | 9 | 11 | 28858 | 41 | ||
| 82698 | 13471 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 101 Market St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/01/2005 12:00:00 AM | 20 | 4X4 | 6013989.3283097 | 2117008.9290081 | 37.79368951828 | -122.395543339024 | (37.79368951828, -122.395543339024) | 12 | 2 | 9 | 28855 | 6 | ||
| 83247 | 27970 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 300 The Embarcadero | 7 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | 3 | 1 | 10 | 28860 | 6 | ||
| 87567 | 27983 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 300 The Embarcadero | 20 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | 3 | 1 | 10 | 28860 | 6 | ||
| 88844 | 13503 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 245 Market St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/28/2005 12:00:00 AM | 6 | 4X4 | 6013642.6483486 | 2116679.2066582 | 37.7927648888925 | -122.396719764541 | (37.7927648888925, -122.396719764541) | 12 | 2 | 9 | 28855 | 6 | ||
| 91931 | 13591 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 525 Market St | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/15/2004 12:00:00 AM | 8 | 4X4 | 6012787.5365724 | 2115865.9219292 | 37.7904841708264 | -122.399621379879 | (37.7904841708264, -122.399621379879) | 12 | 2 | 9 | 28855 | 6 | ||
| 93294 | 13520 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 388 Market St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 4X4 | 6013190.8445953 | 2116364.9078359 | 37.7918767419323 | -122.3982609742 | (37.7918767419323, -122.3982609742) | 4 | 2 | 10 | 28860 | 6 |
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) );