trees
4,014 rows where qSpecies_id = 40 sorted by YCoord descending
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord ▲ | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 58554 | 87738 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3200X Van Ness Ave | 10 | Median : Cutout | Tree | DPW 1 | 05/10/2008 12:00:00 AM | 3 | 4x4 | 6005444.64461 | 2121623.98788 | 37.8058823097966 | -122.425437295217 | (37.8058823097966, -122.425437295217) | 5 | 1 | 1 | 28858 | 32 | ||
| 181937 | 87739 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3200X Van Ness Ave | 11 | Median : Cutout | Tree | DPW 1 | 05/10/2008 12:00:00 AM | 3 | 4x4 | 6005433.61853 | 2121623.41722 | 37.8058801199389 | -122.425475412067 | (37.8058801199389, -122.425475412067) | 13 | 1 | 1 | 28858 | 17 | ||
| 93839 | 51935 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 329 Bay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/2005 12:00:00 AM | Permit Number 48161 | 6009200.27838208 | 2121477.92859384 | 37.805692742557 | -122.412429964781 | (37.805692742557, -122.412429964781) | 3 | 1 | 10 | 308 | 23 | |||
| 133521 | 93018 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 963 North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/2010 12:00:00 AM | 3x3 | Permit Number 53140 | 6006134 | 2121397 | 37.805297983444 | -122.423035527254 | (37.805297983444, -122.423035527254) | 5 | 1 | 1 | 28858 | 32 | ||
| 143911 | 88451 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3200X Van Ness Ave | 1 | Median : Cutout | Tree | DPW 1 | 06/07/2008 12:00:00 AM | 3 | 5x12 | 6005480.84439 | 2121378.35155 | 37.8052099010884 | -122.425294529632 | (37.8052099010884, -122.425294529632) | 5 | 1 | 1 | 28858 | 32 | ||
| 193704 | 88452 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3200X Van Ness Ave | 2 | Median : Cutout | Tree | DPW 1 | 06/07/2008 12:00:00 AM | 4 | 5x12 | 6005470.42698 | 2121378.16696 | 37.8052088057127 | -122.425330567252 | (37.8052088057127, -122.425330567252) | 5 | 1 | 1 | 28858 | 17 | ||
| 66320 | 65288 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 41 Rico Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/07/1990 12:00:00 AM | 7 | Permit Number 28836 | 6001457.59323 | 2121333.88235 | 37.8048596843835 | -122.439214266819 | (37.8048596843835, -122.439214266819) | 13 | 9 | 1 | 57 | 17 | |
| 168448 | 135944 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1998 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5999737.82806 | 2121247.80693 | 37.8045253335298 | -122.445159485234 | (37.8045253335298, -122.445159485234) | 13 | 9 | 1 | 57 | 17 | |||
| 96253 | 135945 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1998 Jefferson St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5999716.32151 | 2121244.69535 | 37.8045155623958 | -122.445233686505 | (37.8045155623958, -122.445233686505) | 13 | 9 | 1 | 57 | 17 | |||
| 135045 | 135943 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2056 Jefferson St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 8ft | 5999351.77852 | 2121203.50658 | 37.8043816542415 | -122.446492250814 | (37.8043816542415, -122.446492250814) | 13 | 9 | 1 | 57 | 17 | |||
| 91140 | 52876 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 118@ BEACH Cervantes Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2006 12:00:00 AM | 3 | Permit Number 48887 | 6001354.74762 | 2121139.05445 | 37.8043188860645 | -122.439556198976 | (37.8043188860645, -122.439556198976) | 13 | 9 | 1 | 57 | 17 | ||
| 135207 | 52875 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 118@ BEACH Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2006 12:00:00 AM | 5 | 3x3 | Permit Number 48887 | 6001367.78659 | 2121129.52184 | 37.8042934541427 | -122.439510392889 | (37.8042934541427, -122.439510392889) | 13 | 9 | 1 | 57 | 17 | |
| 112966 | 41181 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1780 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/24/1999 12:00:00 AM | 11 | Permit Number 41899 | 6001559.95191 | 2121091.33566 | 37.8041995397404 | -122.438842652585 | (37.8041995397404, -122.438842652585) | 13 | 9 | 1 | 57 | 17 | |
| 39510 | 41180 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1780 Beach St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/24/1999 12:00:00 AM | 3 | Permit Number 41899 | 6001541.153 | 2121088.1531 | 37.804189731738 | -122.438907479297 | (37.804189731738, -122.438907479297) | 13 | 9 | 1 | 57 | 17 | |
| 31223 | 108693 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1950X Beach St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774617 | 6001046.33677 | 2120996.58295 | 37.8039101397338 | -122.440613252117 | (37.8039101397338, -122.440613252117) | 13 | 9 | 1 | 57 | 17 |
| 118774 | 108694 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1950X Beach St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774617 | 6001046.33677 | 2120996.58295 | 37.8039101397338 | -122.440613252117 | (37.8039101397338, -122.440613252117) | 13 | 9 | 1 | 57 | 17 |
| 184501 | 108692 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1950X Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774617 | 6001046.33677 | 2120996.58295 | 37.8039101397338 | -122.440613252117 | (37.8039101397338, -122.440613252117) | 13 | 9 | 1 | 57 | 17 |
| 57994 | 135928 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1960 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6000881.44205 | 2120995.2314 | 37.8038970374844 | -122.441183782119 | (37.8038970374844, -122.441183782119) | 13 | 9 | 1 | 57 | 17 | |||
| 88618 | 135929 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1960 Beach St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6000857.17484 | 2120992.84894 | 37.8038891135616 | -122.44126758904 | (37.8038891135616, -122.44126758904) | 13 | 9 | 1 | 57 | 17 | |||
| 113555 | 135930 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1960 Beach St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6000826.24021 | 2120988.33796 | 37.8038749654115 | -122.441374316075 | (37.8038749654115, -122.441374316075) | 13 | 9 | 1 | 57 | 17 | |||
| 124864 | 48575 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2275 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/27/2002 12:00:00 AM | 6 | Permit Number 45888 | 5999350.9725 | 2120803.18902 | 37.8032824443927 | -122.446466222664 | (37.8032824443927, -122.446466222664) | 13 | 9 | 1 | 57 | 17 | ||
| 34659 | 135946 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 33 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6001854.08706 | 2120729.80422 | 37.8032235999547 | -122.437798867946 | (37.8032235999547, -122.437798867946) | 13 | 9 | 1 | 57 | 17 | |||
| 162413 | 135947 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 31 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6001885.41156 | 2120707.63326 | 37.8031645054925 | -122.437688879962 | (37.8031645054925, -122.437688879962) | 13 | 9 | 1 | 57 | 17 | |||
| 56041 | 135948 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 31 Cervantes Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6001895.29837 | 2120693.9243 | 37.8031274264634 | -122.437653684066 | (37.8031274264634, -122.437653684066) | 13 | 9 | 1 | 57 | 17 | |||
| 99053 | 116894 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2 Alhambra St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6001897.52549 | 2120678.68583 | 37.8030857122852 | -122.437644885099 | (37.8030857122852, -122.437644885099) | 13 | 9 | 1 | 57 | 17 | |||
| 150885 | 135949 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2 Alhambra St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6001899.24184 | 2120659.238 | 37.8030324112758 | -122.437637552032 | (37.8030324112758, -122.437637552032) | 13 | 9 | 1 | 57 | 17 | |||
| 70404 | 95588 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2153 North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/2009 12:00:00 AM | 3x3 | Permit Number 767378 | 6000457 | 2120611 | 37.802817854966 | -122.442624981194 | (37.802817854966, -122.442624981194) | 13 | 9 | 1 | 57 | 17 | |
| 189194 | 66052 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2153 North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/1990 12:00:00 AM | 5 | Permit Number 29091 | 6000458.6364 | 2120609.13793 | 37.8028128355005 | -122.442619184653 | (37.8028128355005, -122.442619184653) | 13 | 9 | 1 | 57 | 17 | ||
| 96820 | 135927 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3400 Baker St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | 5999297.26526 | 2120520.00382 | 37.8025018265619 | -122.446631690727 | (37.8025018265619, -122.446631690727) | 13 | 9 | 1 | 57 | 17 | ||||
| 173420 | 136018 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 11 Greenwich St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | 6012250.39299 | 2120519.5939 | 37.8032320823636 | -122.401807129095 | (37.8032320823636, -122.401807129095) | 3 | 1 | 10 | 28860 | 6 | ||||
| 102732 | 135931 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1361 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004797.09073 | 2120517.98623 | 37.8028089081649 | -122.42759940931 | (37.8028089081649, -122.42759940931) | 13 | 9 | 1 | 57 | 17 | |||
| 148491 | 136019 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 11 Greenwich St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | 6012283.42018 | 2120515.08235 | 37.8032215378072 | -122.401692519489 | (37.8032215378072, -122.401692519489) | 3 | 1 | 10 | 28860 | 6 | ||||
| 54600 | 82096 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1363 Francisco St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 07/01/2009 12:00:00 AM | 3x3 | Permit Number 52338 | 6004802.97001971 | 2120513.88344233 | 37.8027979755173 | -122.427578771479 | (37.8027979755173, -122.427578771479) | 13 | 9 | 1 | 57 | 17 | ||
| 73417 | 136013 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1001 Chestnut St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006984.71597 | 2120484.67695 | 37.8028409447119 | -122.420026726469 | (37.8028409447119, -122.420026726469) | 5 | 1 | 1 | 28858 | 32 | |||
| 4080 | 136012 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1001 Chestnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006953.33762 | 2120481.80968 | 37.802831303989 | -122.420135108266 | (37.802831303989, -122.420135108266) | 5 | 1 | 1 | 28858 | 32 | |||
| 24604 | 13087 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 710 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/19/2006 12:00:00 AM | 3 | 3X3 | 6008944.94841 | 2120470.56712 | 37.8029124483908 | -122.413242294464 | (37.8029124483908, -122.413242294464) | 3 | 1 | 10 | 308 | 23 | ||
| 50857 | 26729 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 710 Lombard St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6008944.94841 | 2120470.56712 | 37.8029124483908 | -122.413242294464 | (37.8029124483908, -122.413242294464) | 3 | 1 | 10 | 308 | 23 | |||
| 153659 | 26727 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 710 Lombard St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6008944.94841 | 2120470.56712 | 37.8029124483908 | -122.413242294464 | (37.8029124483908, -122.413242294464) | 3 | 1 | 10 | 308 | 23 | |||
| 158921 | 13086 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 710 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6008944.94841 | 2120470.56712 | 37.8029124483908 | -122.413242294464 | (37.8029124483908, -122.413242294464) | 3 | 1 | 10 | 308 | 23 | |||
| 173193 | 26728 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 710 Lombard St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6008944.94841 | 2120470.56712 | 37.8029124483908 | -122.413242294464 | (37.8029124483908, -122.413242294464) | 3 | 1 | 10 | 308 | 23 | |||
| 93231 | 249855 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 241 Greenwich St | 1 | Front Yard : Yard | Tree | Private 2 | 3 | Width 0ft | 6011547.42399 | 2120404.90985 | 37.8028779329365 | -122.404231712119 | (37.8028779329365, -122.404231712119) | 3 | 1 | 10 | 308 | 23 | |||
| 192256 | 35253 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2250 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/17/1998 12:00:00 AM | 16 | Permit Number 38739 | 6008088.43141 | 2120207.50426 | 37.8021420203875 | -122.416187651964 | (37.8021420203875, -122.416187651964) | 5 | 1 | 10 | 308 | 32 | |
| 139985 | 250003 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 232 Filbert St | 1 | Side Yard : Yard | Tree | Private 2 | 11 | Width 0ft | 6011516.94138 | 2120107.55399 | 37.8020597630161 | -122.404316256511 | (37.8020597630161, -122.404316256511) | 3 | 1 | 10 | 308 | 23 | |||
| 44977 | 14411 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2001X Mason St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/13/2001 12:00:00 AM | 6 | 3X3 | 6009024.63169 | 2120105.21371 | 37.8019137522347 | -122.412940701134 | (37.8019137522347, -122.412940701134) | 3 | 1 | 10 | 308 | 32 | ||
| 168862 | 14410 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2001X Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/13/2001 12:00:00 AM | 6 | 3X3 | 6009024.63169 | 2120105.21371 | 37.8019137522347 | -122.412940701134 | (37.8019137522347, -122.412940701134) | 3 | 1 | 10 | 308 | 32 | ||
| 45422 | 66088 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2229 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/08/1990 12:00:00 AM | 12 | Permit Number 29132 | 6007569.63634 | 2120087.67012 | 37.8017838015514 | -122.417974436664 | (37.8017838015514, -122.417974436664) | 5 | 1 | 1 | 28858 | 32 | |
| 144336 | 249940 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 331 Filbert St | 2 | Front Yard : Yard | Tree | Private 2 | 4 | Width 0ft | 6011278.90186 | 2120029.10977 | 37.8018310698943 | -122.405134464188 | (37.8018310698943, -122.405134464188) | 3 | 1 | 10 | 308 | 23 | |||
| 68471 | 249941 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 331 Filbert St | 3 | Front Yard : Yard | Tree | Private 2 | 13 | Width 0ft | 6011275.70767 | 2120025.2952 | 37.8018204174494 | -122.405145248872 | (37.8018204174494, -122.405145248872) | 3 | 1 | 10 | 308 | 23 | |||
| 83992 | 136008 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 979 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6008203.73321 | 2119954.656 | 37.8014542449694 | -122.415770737051 | (37.8014542449694, -122.415770737051) | 5 | 1 | 10 | 308 | 32 | |||
| 171714 | 135950 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3012 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6004722.9901 | 2119938.49945 | 37.8012135953823 | -122.427814520823 | (37.8012135953823, -122.427814520823) | 13 | 9 | 1 | 57 | 17 | |||
| 739 | 38480 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2515 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/1998 12:00:00 AM | 9 | Permit Number 40479 | 5999797.20513 | 2119471.52027 | 37.7996515161494 | -122.444826245059 | (37.7996515161494, -122.444826245059) | 13 | 9 | 1 | 57 | 17 | ||
| 159616 | 136016 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 290 Green St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6011568.90675 | 2119422.06779 | 37.8001804883964 | -122.40408816056 | (37.8001804883964, -122.40408816056) | 3 | 1 | 10 | 308 | 23 | |||
| 13292 | 136017 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 290 Green St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6011553.12596 | 2119421.08108 | 37.8001768973966 | -122.404142699051 | (37.8001768973966, -122.404142699051) | 3 | 1 | 10 | 308 | 23 | |||
| 16209 | 262261 | - 12 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 290 Green St | : | Tree | Private 2 | FUF | 06/18/2020 12:00:00 AM | 3 | Permit Number 785454 | 6011550.34746 | 2119418.71162 | 37.8001702361868 | -122.404152146942 | (37.8001702361868, -122.404152146942) | 3 | 1 | 10 | 308 | 23 | ||
| 141662 | 34478 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 755 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | 16 | Permit Number 38205 | 6009336.13836 | 2119417.92641 | 37.8000441124981 | -122.411814144501 | (37.8000441124981, -122.411814144501) | 3 | 1 | 10 | 308 | 4 | |
| 79124 | 34480 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 771 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | 18 | Permit Number 38207 | 6009276.26447 | 2119410.9605 | 37.8000216267413 | -122.412020839304 | (37.8000216267413, -122.412020839304) | 3 | 1 | 10 | 308 | 4 | |
| 73681 | 113953 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1665 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 6009606.74508 | 2119405.96484 | 37.8000264462311 | -122.41087689265 | (37.8000264462311, -122.41087689265) | 3 | 1 | 10 | 308 | 4 | |||
| 176507 | 136014 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 14 Havens St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 8ft | 6007575.68988 | 2119392.22094 | 37.7998746136871 | -122.417904161874 | (37.7998746136871, -122.417904161874) | 5 | 1 | 1 | 28858 | 32 | |||
| 171289 | 136015 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 14 Havens St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6007560.5835 | 2119380.86157 | 37.7998425735334 | -122.417955630044 | (37.7998425735334, -122.417955630044) | 5 | 1 | 1 | 28858 | 32 | |||
| 9300 | 34481 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 839 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | 9 | Permit Number 38208 | 6008950.87239 | 2119364.89119 | 37.7998768700862 | -122.413143564642 | (37.7998768700862, -122.413143564642) | 3 | 1 | 10 | 308 | 32 | |
| 116891 | 34484 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 845 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | 6 | Permit Number 38210 | 6008932.65781 | 2119362.16351 | 37.7998683579931 | -122.413206401149 | (37.7998683579931, -122.413206401149) | 3 | 1 | 10 | 308 | 32 | |
| 84092 | 34483 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 845 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | 8 | Permit Number 38210 | 6008918.61834 | 2119360.64227 | 37.7998633928514 | -122.413254875509 | (37.7998633928514, -122.413254875509) | 3 | 1 | 10 | 308 | 32 | |
| 68503 | 136007 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 851 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6008899.0755 | 2119356.39222 | 37.7998506260751 | -122.413322200567 | (37.7998506260751, -122.413322200567) | 3 | 1 | 10 | 308 | 32 | |||
| 45463 | 34485 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 851 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | 8 | Permit Number 38211 | 6008882.96668 | 2119355.1714 | 37.7998463695797 | -122.413377856913 | (37.7998463695797, -122.413377856913) | 3 | 1 | 10 | 308 | 32 | |
| 33713 | 64938 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2810 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1989 12:00:00 AM | 11 | Permit Number 25967 | 6004818.34721 | 2119246.75761 | 37.7993196438369 | -122.427435236266 | (37.7993196438369, -122.427435236266) | 13 | 9 | 1 | 57 | 17 | |
| 80306 | 104072 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3020 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/06/2013 12:00:00 AM | 4 | 3x3 | Permit Number 770362 | 6003851.5174 | 2119222.18029 | 37.7991974313859 | -122.430779048741 | (37.7991974313859, -122.430779048741) | 13 | 9 | 1 | 57 | 17 | |
| 83080 | 135915 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2909 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004293.78648 | 2119207.639 | 37.7991825520948 | -122.429247608494 | (37.7991825520948, -122.429247608494) | 13 | 9 | 1 | 57 | 17 | |||
| 17129 | 33142 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3148 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | 8 | Permit Number 37368 | 6001934.81136 | 2119023.66644 | 37.7985435846779 | -122.437397274777 | (37.7985435846779, -122.437397274777) | 13 | 9 | 1 | 57 | 17 | |
| 18789 | 71443 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 924 Sansome St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6012090.03782 | 2119001.59006 | 37.7990550614973 | -122.402255254071 | (37.7990550614973, -122.402255254071) | 3 | 1 | 10 | 28860 | 6 | |||
| 157300 | 33140 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3143 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | 6 | Permit Number 37367 | 6001896.074 | 2118984.29093 | 37.7984332675401 | -122.437528496644 | (37.7984332675401, -122.437528496644) | 13 | 9 | 1 | 57 | 17 | |
| 110826 | 33141 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3143 Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | 9 | Permit Number 37367 | 6001898.22805 | 2118969.04221 | 37.7983915210181 | -122.437519950413 | (37.7983915210181, -122.437519950413) | 13 | 9 | 1 | 57 | 17 | |
| 13432 | 48426 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3130 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2002 12:00:00 AM | 9 | Permit Number 45804 | 6001942.58238 | 2118964.92546 | 37.7983827391207 | -122.437366176208 | (37.7983827391207, -122.437366176208) | 13 | 9 | 1 | 57 | 17 | |
| 24571 | 29668 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2500 Van Ness Ave | 3 | Median : Cutout | Tree | DPW 1 | 12/09/2004 12:00:00 AM | 6 | 6005837.0202043 | 2118942.4447679 | 37.7985416396102 | -122.423888617279 | (37.7985416396102, -122.423888617279) | 13 | 9 | 10 | 28858 | 32 | |||
| 69685 | 23487 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2500X Van Ness Ave | 2 | Median : Cutout | Tree | DPW 1 | 01/25/2008 12:00:00 AM | 3 | 9 | 6005837.0202043 | 2118942.4447679 | 37.7985416396102 | -122.423888617279 | (37.7985416396102, -122.423888617279) | 13 | 9 | 10 | 28858 | 32 | ||
| 97434 | 23488 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2500X Van Ness Ave | 4 | Median : Cutout | Tree | DPW 1 | 12/09/2004 12:00:00 AM | 6 | 9 | 6005837.0202043 | 2118942.4447679 | 37.7985416396102 | -122.423888617279 | (37.7985416396102, -122.423888617279) | 13 | 9 | 10 | 28858 | 32 | ||
| 166393 | 23489 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2500X Van Ness Ave | 5 | Median : Cutout | Tree | DPW 1 | 12/09/2004 12:00:00 AM | 6 | 9 | 6005837.0202043 | 2118942.4447679 | 37.7985416396102 | -122.423888617279 | (37.7985416396102, -122.423888617279) | 13 | 9 | 10 | 28858 | 32 | ||
| 89667 | 135924 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 273 Pixley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6002069.33792 | 2118935.23427 | 37.7983084200504 | -122.436925437376 | (37.7983084200504, -122.436925437376) | 13 | 9 | 1 | 57 | 17 | |||
| 48761 | 135923 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 299 Pixley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6001988.80401 | 2118923.8728 | 37.7982726468322 | -122.437203294605 | (37.7982726468322, -122.437203294605) | 13 | 9 | 1 | 57 | 17 | |||
| 74709 | 135926 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2575 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6000595.0032 | 2118891.41204 | 37.7981041894114 | -122.442023918863 | (37.7981041894114, -122.442023918863) | 13 | 9 | 1 | 57 | 17 | |||
| 31944 | 94585 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2725 Greenwich St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/29/2010 12:00:00 AM | 3x3 | Permit Number 53761 | 5999865 | 2118793 | 37.7977923490456 | -122.444542858 | (37.7977923490456, -122.444542858) | 13 | 9 | 1 | 57 | 17 | |||
| 11792 | 135925 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2725 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5999832.27617 | 2118786.40209 | 37.7977723656638 | -122.444655616678 | (37.7977723656638, -122.444655616678) | 13 | 9 | 1 | 57 | 17 | |||
| 143173 | 42840 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1828 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/03/2000 12:00:00 AM | 5 | Permit Number 42772 | 6008289.65137 | 2118753.27916 | 37.7981603934451 | -122.415388321908 | (37.7981603934451, -122.415388321908) | 5 | 1 | 10 | 308 | 21 | |
| 165313 | 64351 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2829 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/13/1988 12:00:00 AM | 10 | Permit Number 25187 | 5999331.75802 | 2118714.36409 | 37.7975459946103 | -122.446382356375 | (37.7975459946103, -122.446382356375) | 13 | 9 | 1 | 57 | 17 | ||
| 167469 | 51995 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2837 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/29/2005 12:00:00 AM | 11 | Permit Number 48213 | 5999309.41845 | 2118712.36147 | 37.7975392200233 | -122.446459512793 | (37.7975392200233, -122.446459512793) | 13 | 9 | 1 | 57 | 17 | ||
| 43969 | 135922 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2440 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6001259.6305 | 2118684.30492 | 37.7975733798607 | -122.439709263576 | (37.7975733798607, -122.439709263576) | 13 | 9 | 1 | 57 | 17 | |||
| 21136 | 46595 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2480 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2002 12:00:00 AM | 3 | Permit Number 45794 | 6001119.43156 | 2118662.96193 | 37.7975067967595 | -122.440192856927 | (37.7975067967595, -122.440192856927) | 13 | 9 | 1 | 57 | 17 | |
| 86033 | 46596 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2480 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2002 12:00:00 AM | 3 | Permit Number 45794 | 6001101.66117 | 2118661.22174 | 37.7975010069291 | -122.440254222167 | (37.7975010069291, -122.440254222167) | 13 | 9 | 1 | 57 | 17 | |
| 112019 | 48418 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2490 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2002 12:00:00 AM | 5 | Permit Number 45796 | 6001083.86892 | 2118658.42768 | 37.7974923221726 | -122.440315587421 | (37.7974923221726, -122.440315587421) | 13 | 9 | 1 | 57 | 17 | |
| 23937 | 48415 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2475 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2002 12:00:00 AM | 8 | Permit Number 45793 | 6001140.73556 | 2118622.32163 | 37.7973964220563 | -122.440116223893 | (37.7973964220563, -122.440116223893) | 13 | 9 | 1 | 57 | 17 | |
| 126258 | 135921 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2495 Filbert St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6001125.35407 | 2118620.11363 | 37.797389483787 | -122.440169289291 | (37.797389483787, -122.440169289291) | 13 | 9 | 1 | 57 | 17 | |||
| 58099 | 135920 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2495 Filbert St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6001110.69798 | 2118617.54309 | 37.7973815913536 | -122.440219818601 | (37.7973815913536, -122.440219818601) | 13 | 9 | 1 | 57 | 17 | |||
| 154688 | 136009 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1173 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007981.41109 | 2118539.47865 | 37.797556021142 | -122.416439775085 | (37.797556021142, -122.416439775085) | 5 | 1 | 10 | 28858 | 21 | |||
| 153934 | 66515 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1173 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/1991 12:00:00 AM | 7 | Permit Number 29681 | 6007962.75323 | 2118537.74133 | 37.7975502016423 | -122.41650421331 | (37.7975502016423, -122.41650421331) | 5 | 1 | 10 | 28858 | 21 | ||
| 8095 | 67626 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1334 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/14/1992 12:00:00 AM | 7 | Permit Number 31212 | 6007155.75192 | 2118470.9352 | 37.7973213520513 | -122.419291917399 | (37.7973213520513, -122.419291917399) | 5 | 1 | 10 | 28858 | 32 | |
| 97160 | 136010 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1761 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6007314.88578 | 2118424.776 | 37.7972035714369 | -122.418737997073 | (37.7972035714369, -122.418737997073) | 5 | 1 | 10 | 28858 | 32 | |||
| 46209 | 136011 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1761 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007318.32314 | 2118399.04204 | 37.7971331059516 | -122.418724276998 | (37.7971331059516, -122.418724276998) | 5 | 1 | 10 | 28858 | 32 | |||
| 147654 | 108702 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2382 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772586 | 6001605.97197 | 2118381.98302 | 37.7967629901963 | -122.438489159966 | (37.7967629901963, -122.438489159966) | 13 | 9 | 1 | 57 | 17 |
| 144490 | 94744 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1801 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/03/2010 12:00:00 AM | 4 | 3x3 | Permit Number 53879 | 6004279.92071 | 2118358.49437 | 37.7968502341069 | -122.429235007194 | (37.7968502341069, -122.429235007194) | 13 | 9 | 1 | 57 | 17 | |
| 58549 | 135919 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2355 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001720.67059 | 2118356.50999 | 37.7966995715863 | -122.438090451527 | (37.7966995715863, -122.438090451527) | 13 | 9 | 1 | 57 | 17 | |||
| 70014 | 135918 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2355 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001698.12763 | 2118353.29773 | 37.7966894695005 | -122.438168224898 | (37.7966894695005, -122.438168224898) | 13 | 9 | 1 | 57 | 17 |
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) );