trees
251 rows where DBH = 3 and qCaretaker_id = 4 sorted by PlantType
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1047 | 42641 | DPW Maintained 1 | Hymenosporum flavum :: Sweetshade 24 | 1651 Union St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/07/2020 12:11:00 PM | 3 | 5x5 | Permit Number 42688 | 6005090.06351 | 2118821.98656 | 37.7981686950973 | -122.426464740961 | (37.7981686950973, -122.426464740961) | 13 | 9 | 1 | 57 | 17 |
| 1403 | 77662 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 299X Cambridge St | 13 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6006681.78325 | 2093389.68756 | 37.7284274151839 | -122.419151965791 | (37.7284274151839, -122.419151965791) | 9 | 3 | 7 | 309 | 5 | ||
| 2404 | 76334 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 299X Cambridge St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6006750.61437 | 2093170.72103 | 37.7278300567077 | -122.418898489194 | (37.7278300567077, -122.418898489194) | 9 | 3 | 7 | 309 | 5 | ||
| 2474 | 256556 | Property Tree 8 | Acer rubrum :: Red Maple 75 | 3401X 16th St | 5 | Side Yard : Yard | Tree | SFUSD 4 | 02/08/2019 09:18:00 AM | 3 | 3x3 | 6004088 | 2106523 | 37.7643420392989 | -122.429054808288 | (37.7643420392989, -122.429054808288) | 8 | 4 | 5 | 28862 | 3 | ||
| 2999 | 94036 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1300X Lane St | 4 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/14/2019 09:52:00 AM | 3 | 5x5 | 6015673.325 | 2095216.0053 | 37.7339443827642 | -122.388194894968 | (37.7339443827642, -122.388194894968) | 10 | 3 | 8 | 58 | 1 | |
| 3324 | 100985 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2190 Powell St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 03/23/2016 02:34:00 PM | 3 | 3x3 | 6009638.6 | 2121046.2 | 37.8045319114054 | -122.41088257169 | (37.8045319114054, -122.41088257169) | 3 | 1 | 10 | 308 | 23 | |
| 3628 | 76755 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1501X 42nd Ave | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x12 | 5983093.5463 | 2104662.8676 | 37.758023867602 | -122.501529951702 | (37.758023867602, -122.501529951702) | 1 | 8 | 3 | 56 | 35 | ||
| 3937 | 98576 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 301X Francisco St | 14 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/23/2016 02:52:00 PM | 3 | 3x3 | 6009861.3 | 2121227.6 | 37.8050424754696 | -122.410124709263 | (37.8050424754696, -122.410124709263) | 3 | 1 | 10 | 308 | 23 | |
| 4078 | 78328 | DPW Maintained 1 | Celtis australis :: European Hackberry 274 | 50 Pomona St | 19 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6014090.70522 | 2094312.98368 | 37.7313770539035 | -122.393603356926 | (37.7313770539035, -122.393603356926) | 10 | 3 | 8 | 58 | 1 | ||
| 4799 | 95481 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/12/2011 12:00:00 AM | 3 | 3x3 | 5986568.37611 | 2111910.32722 | 37.778126839673 | -122.490045739805 | (37.778126839673, -122.490045739805) | 11 | 6 | 2 | 55 | 26 | |
| 5271 | 78323 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50 Pomona St | 24 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6014072.33534 | 2094216.70422 | 37.7311116693492 | -122.393660129315 | (37.7311116693492, -122.393660129315) | 10 | 3 | 8 | 58 | 1 | ||
| 5745 | 193934 | Property Tree 8 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 101 Whitney Young Cir | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3 | Width 3ft | 6016623.26344 | 2095403.70542 | 37.7345123576517 | -122.384923708478 | (37.7345123576517, -122.384923708478) | 10 | 3 | 8 | 58 | 1 | |||
| 6745 | 74583 | DPW Maintained 1 | Acacia baileyana 'Purpurea' :: Purple-leaf Acacia 26 | 151X Palm Ave | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 01/31/2018 12:00:00 AM | 3 | 3x3 | 5995884.6031 | 2113341.96396 | 37.7825973527613 | -122.457921374418 | (37.7825973527613, -122.457921374418) | 11 | 6 | 1 | 54 | 31 | |
| 7113 | 51366 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50 Pomona St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/12/2004 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014162.99112 | 2094669.44393 | 37.7323598375173 | -122.393378385216 | (37.7323598375173, -122.393378385216) | 10 | 3 | 8 | 58 | 1 |
| 7428 | 78326 | DPW Maintained 1 | Celtis australis :: European Hackberry 274 | 50 Pomona St | 21 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6014084.32077 | 2094282.11607 | 37.7312919429706 | -122.393623269718 | (37.7312919429706, -122.393623269718) | 10 | 3 | 8 | 58 | 1 | ||
| 7794 | 78331 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 50 Pomona St | 16 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6014103.03356 | 2094377.1679 | 37.7315539757311 | -122.393565225657 | (37.7315539757311, -122.393565225657) | 10 | 3 | 8 | 58 | 1 | ||
| 7857 | 78321 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50 Pomona St | 26 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6014066.05948 | 2094191.20422 | 37.7310413028018 | -122.3936800421 | (37.7310413028018, -122.3936800421) | 10 | 3 | 8 | 58 | 1 | ||
| 7953 | 97241 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 260 Madrid St | 12 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 09/07/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767495 | 6003464 | 2092306.9 | 37.7252725856131 | -122.430198780788 | (37.7252725856131, -122.430198780788) | 9 | 7 | 6 | 28861 | 5 |
| 8049 | 51364 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50 Pomona St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/12/2004 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014150.64944 | 2094610.63008 | 37.7321976609735 | -122.393416939157 | (37.7321976609735, -122.393416939157) | 10 | 3 | 8 | 58 | 1 |
| 8094 | 78325 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 50 Pomona St | 22 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6014082.07463 | 2094268.00581 | 37.7312530742586 | -122.393630047885 | (37.7312530742586, -122.393630047885) | 10 | 3 | 8 | 58 | 1 | ||
| 8159 | 78322 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 50 Pomona St | 25 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6014069.27853 | 2094204.92894 | 37.7310791669665 | -122.393669873461 | (37.7310791669665, -122.393669873461) | 10 | 3 | 8 | 58 | 1 | ||
| 8452 | 116055 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 650x Kansas St | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/08/2020 12:00:00 AM | 3 | 4x4 | 6011513.13975 | 2105199.40577 | 37.7611252557522 | -122.403280067548 | (37.7611252557522, -122.403280067548) | 10 | 3 | 8 | 28856 | 29 | |
| 11126 | 51368 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 50 Pomona St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/12/2004 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014172.09212 | 2094713.43563 | 37.7324811353964 | -122.393349998121 | (37.7324811353964, -122.393349998121) | 10 | 3 | 8 | 58 | 1 |
| 11183 | 74883 | DPW Maintained 1 | Acacia baileyana 'Purpurea' :: Purple-leaf Acacia 26 | 151X Palm Ave | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 01/31/2018 12:00:00 AM | 3 | 3x3 | 5995886.83117 | 2113252.75826 | 37.7823525456975 | -122.457907208857 | (37.7823525456975, -122.457907208857) | 11 | 6 | 1 | 54 | 31 | |
| 11450 | 93122 | DPW Maintained 1 | Acacia baileyana 'Purpurea' :: Purple-leaf Acacia 26 | 151X Palm Ave | 14 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 01/31/2018 12:00:00 AM | 3 | 3x3 | 5995895.24901 | 2113041.91566 | 37.7817741116959 | -122.457862824896 | (37.7817741116959, -122.457862824896) | 11 | 6 | 1 | 54 | 31 | |
| 11581 | 98091 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2X Frank Norris St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6007129.63323 | 2115568.12393 | 37.7893494826426 | -122.419176280756 | (37.7893494826426, -122.419176280756) | 13 | 9 | 10 | 28858 | 21 | ||
| 11601 | 95514 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 600X 32nd Ave | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 02/19/2015 02:29:00 PM | 3 | 3x3 | 5985991.7561 | 2111987.56369 | 37.7783052202186 | -122.492046137036 | (37.7783052202186, -122.492046137036) | 11 | 6 | 2 | 55 | 26 | ||
| 11856 | 107887 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 941 Washington St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/03/2014 12:00:00 AM | 3 | 3x3 | Permit Number 771772 | 6010165.08902 | 2117347.11602 | 37.7944046419585 | -122.40879946772 | (37.7944046419585, -122.40879946772) | 3 | 1 | 10 | 28857 | 4 |
| 12599 | 93632 | DPW Maintained 1 | Acacia baileyana 'Purpurea' :: Purple-leaf Acacia 26 | 151X Palm Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 01/31/2018 12:00:00 AM | 3 | 3x3 | Permit Number 53266 | 5995882.07932 | 2113403.99303 | 37.7827675230466 | -122.457934595796 | (37.7827675230466, -122.457934595796) | 11 | 6 | 1 | 54 | 31 |
| 12918 | 42635 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1651 Union St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/07/2020 11:32:00 AM | 3 | 4x5 | Permit Number 42688 | 6005113.34773 | 2118824.42387 | 37.7981767035488 | -122.426384344263 | (37.7981767035488, -122.426384344263) | 13 | 9 | 1 | 57 | 17 |
| 13176 | 78329 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50 Pomona St | 18 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6014093.60126 | 2094328.91133 | 37.7314209489083 | -122.39359445904 | (37.7314209489083, -122.39359445904) | 10 | 3 | 8 | 58 | 1 | ||
| 13195 | 78202 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 50 Pomona St | 27 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6014063.31576 | 2094176.73754 | 37.7310014277784 | -122.393688515509 | (37.7310014277784, -122.393688515509) | 10 | 3 | 8 | 58 | 1 | ||
| 13279 | 108789 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1100-1198X Schwerin St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 773823 | 6009097.13658 | 2087632.54285 | 37.7127552255458 | -122.410395595682 | (37.7127552255458, -122.410395595682) | 9 | 7 | 8 | 309 | 39 | |
| 13398 | 51356 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50 Pomona St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/12/2004 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014174.8382 | 2094728.02379 | 37.7325213440762 | -122.393341524701 | (37.7325213440762, -122.393341524701) | 10 | 3 | 8 | 58 | 1 |
| 13407 | 42632 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1651 Union St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/07/2020 12:07:00 PM | 3 | 4x4 | Permit Number 42688 | 6005134.31421 | 2118828.07494 | 37.7981879136105 | -122.426312054082 | (37.7981879136105, -122.426312054082) | 13 | 9 | 1 | 57 | 17 |
| 14250 | 116051 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 650x Kansas St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 4x4 | 6011500.28754 | 2105307.13541 | 37.7614203394907 | -122.403332096897 | (37.7614203394907, -122.403332096897) | 10 | 3 | 8 | 28856 | 29 | ||
| 14472 | 100972 | DPW Maintained 1 | Potential Site :: Potential Site 48 | 450X Chestnut St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 03/24/2016 07:43:00 AM | 3 | Permit Number 37341 | 6009614 | 2121059.9 | 37.8045681487804 | -122.410968670823 | (37.8045681487804, -122.410968670823) | 3 | 1 | 10 | 308 | 23 | |
| 14678 | 96770 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1300X Lane St | 6 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 12/08/2012 12:00:00 AM | 3 | 3x3 | 6015623.8599 | 2095148.9526 | 37.7337575287133 | -122.388361234061 | (37.7337575287133, -122.388361234061) | 10 | 3 | 8 | 58 | 1 | |
| 14886 | 51359 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 50 Pomona St | 13 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/12/2004 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014112.78564 | 2094416.99761 | 37.7316638818713 | -122.393534297068 | (37.7316638818713, -122.393534297068) | 10 | 3 | 8 | 58 | 1 |
| 15106 | 78327 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50 Pomona St | 20 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6014087.33436 | 2094297.79766 | 37.7313351688787 | -122.393613948242 | (37.7313351688787, -122.393613948242) | 10 | 3 | 8 | 58 | 1 | ||
| 15563 | 42636 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1651 Union St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/07/2020 11:48:00 AM | 3 | 4x5 | Permit Number 42688 | 6005181.30457 | 2118838.80185 | 37.7982200229931 | -122.426150217479 | (37.7982200229931, -122.426150217479) | 13 | 9 | 1 | 57 | 17 |
| 15783 | 78330 | DPW Maintained 1 | Celtis australis :: European Hackberry 274 | 50 Pomona St | 17 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6014096.48223 | 2094344.10726 | 37.7314628339206 | -122.39358556205 | (37.7314628339206, -122.39358556205) | 10 | 3 | 8 | 58 | 1 | ||
| 15793 | 42348 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 380X Flood Ave | 7 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/23/2000 12:00:00 AM | 3 | 8x45 | Permit Number 42547 | 5998132.77434913 | 2094246.31790382 | 37.7302943698097 | -122.448767853229 | (37.7302943698097, -122.448767853229) | 9 | 7 | 4 | 28861 | 40 |
| 16291 | 51365 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 50 Pomona St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/12/2004 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014154.93455 | 2094628.60419 | 37.7322472522973 | -122.393403381858 | (37.7322472522973, -122.393403381858) | 10 | 3 | 8 | 58 | 1 |
| 16535 | 78324 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 50 Pomona St | 23 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6014075.45071 | 2094231.93865 | 37.7311536731068 | -122.393650424725 | (37.7311536731068, -122.393650424725) | 10 | 3 | 8 | 58 | 1 | ||
| 17049 | 112023 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2101x 22nd Ave | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 07/23/2015 12:00:00 AM | 3 | 5x5 | 6011761 | 2103726 | 37.75709344993 | -122.402319220858 | (37.75709344993, -122.402319220858) | 10 | 3 | 8 | 28856 | 29 | ||
| 17413 | 112021 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2101x 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 07/23/2015 12:00:00 AM | 3 | 5x5 | 6011761 | 2103726 | 37.75709344993 | -122.402319220858 | (37.75709344993, -122.402319220858) | 10 | 3 | 8 | 28856 | 29 | ||
| 17603 | 75990 | DPW Maintained 1 | Acer saccharinum :: Silver Maple 271 | 350 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 3 | 3x3 | 6011912.57037 | 2118781.03793 | 37.7984395708796 | -122.402853834756 | (37.7984395708796, -122.402853834756) | 3 | 1 | 10 | 308 | 23 | ||
| 17940 | 42637 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1651 Union St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/07/2020 11:43:00 AM | 3 | 4x4 | Permit Number 42688 | 6005203.48268 | 2118840.06651 | 37.7982247489172 | -122.42607356464 | (37.7982247489172, -122.42607356464) | 13 | 9 | 1 | 57 | 17 |
| 18124 | 95460 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/12/2011 12:00:00 AM | 3 | 3x3 | 5986585.7747 | 2111417.7398 | 37.7767753504668 | -122.489949313769 | (37.7767753504668, -122.489949313769) | 11 | 6 | 2 | 55 | 26 | |
| 18431 | 51369 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50 Pomona St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/12/2004 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014169.21344 | 2094698.3618 | 37.7324395857978 | -122.39335889599 | (37.7324395857978, -122.39335889599) | 10 | 3 | 8 | 58 | 1 |
| 19099 | 113032 | DPW Maintained 1 | Aesculus x carnea 'Briotii' :: Ruby Horse Chestnut 205 | 251 06th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3 | 3x3 | 5993973.41927 | 2113841.38508 | 37.7838586397785 | -122.464569471656 | (37.7838586397785, -122.464569471656) | 11 | 6 | 2 | 54 | 11 | |||
| 19907 | 102028 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 165X Chattanooga St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6004753 | 2102714 | 37.7539210456637 | -122.426483522656 | (37.7539210456637, -122.426483522656) | 2 | 4 | 5 | 28862 | 22 | ||
| 20224 | 98090 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2X Frank Norris St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6007144.43128 | 2115568.9527 | 37.7893525915946 | -122.419125139911 | (37.7893525915946, -122.419125139911) | 13 | 9 | 10 | 28858 | 21 | ||
| 20458 | 42640 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1651 Union St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 09/25/2015 02:08:00 PM | 3 | 3x3 | Permit Number 42688 | 6005273.82097 | 2118847.7065 | 37.7982497015198 | -122.425830717123 | (37.7982497015198, -122.425830717123) | 13 | 9 | 1 | 57 | 17 |
| 20806 | 102022 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 165X Chattanooga St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6004753 | 2102714 | 37.7539210456637 | -122.426483522656 | (37.7539210456637, -122.426483522656) | 2 | 4 | 5 | 28862 | 22 | ||
| 23641 | 43313 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 148X Paris St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/04/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50666 | 6003041.97819 | 2092624.14713 | 37.7261197629015 | -122.431680307904 | (37.7261197629015, -122.431680307904) | 9 | 7 | 6 | 28861 | 5 |
| 24545 | 70470 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 450X Banks St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/18/1994 12:00:00 AM | 3 | 3x4 | 6008487.2849764 | 2096519.17342203 | 37.7371218206329 | -122.413131433288 | (37.7371218206329, -122.413131433288) | 10 | 7 | 7 | 28859 | 2 | |
| 27765 | 37839 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 451 Athens St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/07/1998 12:00:00 AM | 3 | 4x6 | Permit Number 40134 | 6003658.01474 | 2090473.5929 | 37.7202497170415 | -122.42939741397 | (37.7202497170415, -122.42939741397) | 9 | 7 | 6 | 28861 | 5 |
| 30203 | 95755 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 260 Madrid St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 09/07/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767495 | 6003450.90146 | 2092257.04406 | 37.7251349504027 | -122.430240505894 | (37.7251349504027, -122.430240505894) | 9 | 7 | 6 | 28861 | 5 |
| 30221 | 95757 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 260 Madrid St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/25/2017 04:33:00 PM | 3 | 3x3 | Permit Number 767495 | 6003435.4103 | 2092233.16774 | 37.7250685138993 | -122.430292354528 | (37.7250685138993, -122.430292354528) | 9 | 7 | 6 | 28861 | 5 |
| 30823 | 96774 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1300X Lane St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 12/08/2012 12:00:00 AM | 3 | 3x3 | 6015407.2 | 2095381.5 | 37.7343840488548 | -122.389126529878 | (37.7343840488548, -122.389126529878) | 10 | 3 | 8 | 58 | 1 | |
| 32373 | 77649 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1300X Silliman St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/26/1984 12:00:00 AM | 3 | 3x3 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.419224083243 | (37.7290063985797, -122.419224083243) | 9 | 3 | 7 | 309 | 5 | |
| 33305 | 102189 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 3999X Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6008408 | 2096514 | 37.7371031642446 | -122.41340519256 | (37.7371031642446, -122.41340519256) | 10 | 7 | 7 | 28859 | 2 | ||
| 33781 | 95450 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 601X 30th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 5986571.54012 | 2111769.53516 | 37.7777404494553 | -122.49002443627 | (37.7777404494553, -122.49002443627) | 11 | 6 | 2 | 55 | 26 | ||
| 34431 | 256554 | Property Tree 8 | Acer rubrum :: Red Maple 75 | 3401X 16th St | 3 | Side Yard : Yard | Tree | SFUSD 4 | 02/08/2019 09:10:00 AM | 3 | 3x3 | 6004088 | 2106523 | 37.7643420392989 | -122.429054808288 | (37.7643420392989, -122.429054808288) | 8 | 4 | 5 | 28862 | 3 | ||
| 34474 | 95271 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2245 Jones St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/23/2016 02:36:00 PM | 3 | 6x6 | 6007968.5 | 2120121.7 | 37.801899679212 | -122.416596591624 | (37.801899679212, -122.416596591624) | 5 | 1 | 10 | 308 | 32 | |
| 34835 | 71106 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 4235 19th St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/23/2015 07:32:00 AM | 3 | 4x4 | 6001944.69626247 | 2104668.40530987 | 37.7591282168027 | -122.436335144342 | (37.7591282168027, -122.436335144342) | 2 | 4 | 5 | 28862 | 3 | |
| 35858 | 102033 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 165X Chattanooga St | 13 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6004753 | 2102714 | 37.7539210456637 | -122.426483522656 | (37.7539210456637, -122.426483522656) | 2 | 4 | 5 | 28862 | 22 | ||
| 36159 | 37832 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 450X Moscow St | 19 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/22/2006 12:00:00 AM | 3 | 3x3 | Permit Number 48867 | 6003860.1558 | 2090386.44981 | 37.7200218836872 | -122.42869247048 | (37.7200218836872, -122.42869247048) | 9 | 7 | 6 | 28861 | 5 |
| 36285 | 95758 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 260 Madrid St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 09/07/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767495 | 6003422.17585 | 2092210.81209 | 37.7250063806226 | -122.430336510319 | (37.7250063806226, -122.430336510319) | 9 | 7 | 6 | 28861 | 5 |
| 36927 | 95272 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2245 Jones St | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/08/2011 12:00:00 AM | 3 | 3x3 | 6007968.5 | 2120121.7 | 37.801899679212 | -122.416596591624 | (37.801899679212, -122.416596591624) | 5 | 1 | 10 | 308 | 32 | |
| 37102 | 77218 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 499X Hearst Ave | 22 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/15/1999 12:00:00 AM | 3 | 6x50 | 5998132.77434913 | 2094246.31790382 | 37.7302943698097 | -122.448767853229 | (37.7302943698097, -122.448767853229) | 9 | 7 | 4 | 28861 | 40 | |
| 37151 | 77198 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 499X Hearst Ave | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/15/1999 12:00:00 AM | 3 | 3x3 | 5998132.77434913 | 2094246.31790382 | 37.7302943698097 | -122.448767853229 | (37.7302943698097, -122.448767853229) | 9 | 7 | 4 | 28861 | 40 | |
| 38321 | 102024 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 165X Chattanooga St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6004753 | 2102714 | 37.7539210456637 | -122.426483522656 | (37.7539210456637, -122.426483522656) | 2 | 4 | 5 | 28862 | 22 | ||
| 38733 | 98088 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 2X Frank Norris St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6007178.15894 | 2115574.08384 | 37.7893685797349 | -122.419008809929 | (37.7893685797349, -122.419008809929) | 13 | 9 | 10 | 28858 | 21 | ||
| 38894 | 95753 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 260 Madrid St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 09/07/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767495 | 6003478.85461 | 2092303.36569 | 37.7252637225375 | -122.430147177848 | (37.7252637225375, -122.430147177848) | 9 | 7 | 6 | 28861 | 5 |
| 40750 | 30740 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 380 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 01/31/1995 12:00:00 AM | 3 | 3x3 | Permit Number 34630 | 6004184.33514 | 2109844.20882 | 37.7734667268354 | -122.428958416203 | (37.7734667268354, -122.428958416203) | 7 | 9 | 11 | 28852 | 10 |
| 40781 | 99039 | DPW Maintained 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 | 200X Bartlett St | 13 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6006692 | 2102600.1 | 37.7537177245237 | -122.419769910314 | (37.7537177245237, -122.419769910314) | 2 | 4 | 7 | 28859 | 19 | ||
| 41872 | 41128 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2049 Grove St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 08/10/2017 12:00:00 AM | 3 | 6x6 | Permit Number 41868 | 5998020.62854813 | 2110270.29167038 | 37.7742858282579 | -122.450310189268 | (37.7742858282579, -122.450310189268) | 15 | 5 | 11 | 29492 | 16 |
| 42544 | 37824 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 450X Moscow St | 12 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/07/1998 12:00:00 AM | 3 | 3x3 | Permit Number 40134 | 6003906.75378 | 2090460.71651 | 37.7202284408775 | -122.428536688136 | (37.7202284408775, -122.428536688136) | 9 | 7 | 6 | 28861 | 5 |
| 44331 | 95756 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 260 Madrid St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/25/2017 04:16:00 PM | 3 | 3x3 | Permit Number 767495 | 6003442.24703 | 2092244.67659 | 37.7251005018853 | -122.430269541405 | (37.7251005018853, -122.430269541405) | 9 | 7 | 6 | 28861 | 5 |
| 44657 | 99552 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 200X Henry St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 12/28/2016 06:02:00 AM | 3 | 3x3 | 6002211.6 | 2107376.8 | 37.7665799711801 | -122.435605827147 | (37.7665799711801, -122.435605827147) | 15 | 5 | 5 | 28862 | 3 | |
| 44906 | 95475 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 5986561.73612 | 2112070.55828 | 37.7785664008394 | -122.490080498329 | (37.7785664008394, -122.490080498329) | 11 | 6 | 2 | 55 | 26 | ||
| 45066 | 51362 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 50 Pomona St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/12/2004 12:00:00 AM | 3 | 3x3 | Permit Number 47704 | 6014137.60928 | 2094535.47761 | 37.7319905830836 | -122.393456764727 | (37.7319905830836, -122.393456764727) | 10 | 3 | 8 | 58 | 1 |
| 48321 | 108786 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 1100-1198X Schwerin St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 773823 | 6009097.13658 | 2087632.54285 | 37.7127552255458 | -122.410395595682 | (37.7127552255458, -122.410395595682) | 9 | 7 | 8 | 309 | 39 | |
| 48405 | 102030 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 165X Chattanooga St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6004753 | 2102714 | 37.7539210456637 | -122.426483522656 | (37.7539210456637, -122.426483522656) | 2 | 4 | 5 | 28862 | 22 | ||
| 49136 | 42633 | DPW Maintained 1 | Tristania conferta :: 61 | 1651 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/22/2016 02:56:00 PM | 3 | 5x5 | Permit Number 45045 | 6005048.16251 | 2118816.23898 | 37.7981505449739 | -122.426609321383 | (37.7981505449739, -122.426609321383) | 13 | 9 | 1 | 57 | 17 |
| 49228 | 97251 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 301X Excelsior Ave | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 09/07/2011 12:00:00 AM | 3 | 4x4 | Permit Number 767495 | 6003227.5697 | 2092233.02297 | 37.7250563415646 | -122.431010826505 | (37.7250563415646, -122.431010826505) | 9 | 7 | 6 | 28861 | 5 |
| 49986 | 96493 | DPW Maintained 1 | Tree(s) :: 17 | 2500X Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/24/2014 12:00:00 AM | 3 | 5x5 | Permit Number 774006 | 6008744 | 2103690.4 | 37.7568268248396 | -122.412750681409 | (37.7568268248396, -122.412750681409) | 2 | 4 | 7 | 28859 | 19 |
| 50118 | 95752 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 260 Madrid St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/25/2017 03:47:00 PM | 3 | 3x3 | Permit Number 767495 | 6003490.3309 | 2092321.64943 | 37.7253145756058 | -122.430108809186 | (37.7253145756058, -122.430108809186) | 9 | 7 | 6 | 28861 | 5 |
| 50176 | 99498 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 125 Excelsior Ave | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6002794.02408 | 2092508.79842 | 37.7257889832596 | -122.432529234659 | (37.7257889832596, -122.432529234659) | 9 | 7 | 6 | 28861 | 5 | ||
| 51466 | 95482 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 5986568.36529 | 2111879.34223 | 37.7780417630679 | -122.490043497613 | (37.7780417630679, -122.490043497613) | 11 | 6 | 2 | 55 | 26 | ||
| 53024 | 99347 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451X 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 5986832.70752 | 2113173.16715 | 37.7816096708126 | -122.489224205331 | (37.7816096708126, -122.489224205331) | 11 | 6 | 2 | 55 | 26 | ||
| 58864 | 116052 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 650x Kansas St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 01/23/2018 12:00:00 AM | 3 | 4x4 | 6011506.55629 | 2105277.69862 | 37.7613398627543 | -122.403308344903 | (37.7613398627543, -122.403308344903) | 10 | 3 | 8 | 28856 | 29 | |
| 59100 | 46948 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1530 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/01/2002 12:00:00 AM | 3 | 3x25 | Permit Number 44987 | 5982828.25460357 | 2104700.39822601 | 37.7581113313144 | -122.502450205887 | (37.7581113313144, -122.502450205887) | 1 | 8 | 3 | 56 | 35 |
| 61767 | 97068 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1551 Newcomb Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6015475.3 | 2095481.7 | 37.7346629526589 | -122.388898077079 | (37.7346629526589, -122.388898077079) | 10 | 3 | 8 | 58 | 1 | ||
| 63669 | 97067 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1551 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/06/2014 12:00:00 AM | 3 | 3x3 | 6015475.3 | 2095481.7 | 37.7346629526589 | -122.388898077079 | (37.7346629526589, -122.388898077079) | 10 | 3 | 8 | 58 | 1 | |
| 64192 | 99336 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 450 30th Ave | 14 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 5986577.60051 | 2112919.49158 | 37.7808982560395 | -122.490088077428 | (37.7808982560395, -122.490088077428) | 11 | 6 | 2 | 55 | 26 | ||
| 65943 | 32730 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 431 Capitol Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/29/1996 12:00:00 AM | 3 | 3x3 | 5995024.58898 | 2088651.07748 | 37.7147529482781 | -122.459108206688 | (37.7147529482781, -122.459108206688) | 9 | 8 | 6 | 28861 | 24 |
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) );