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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 193429 | 96036 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1498 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 3x3 | Permit Number 767675 | 6006383 | 2118353 | 37.7969539806541 | -122.421957458925 | (37.7969539806541, -122.421957458925) | 13 | 9 | 10 | 28858 | 32 | |
| 133111 | 11071 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1769 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4X4 | 6007332 | 2118349 | 37.7969964730533 | -122.418673401001 | (37.7969964730533, -122.418673401001) | 5 | 1 | 10 | 28858 | 32 | |||
| 72492 | 136004 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1027 Broadway | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 19 | Width 3ft | 6008655.55584 | 2118272.73317 | 37.7968614918226 | -122.41408816573 | (37.7968614918226, -122.41408816573) | 5 | 1 | 10 | 308 | 21 | |||
| 93641 | 135916 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2042 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003243.98792 | 2118266.01922 | 37.7965376216713 | -122.432812964457 | (37.7965376216713, -122.432812964457) | 13 | 9 | 1 | 57 | 17 | |||
| 47096 | 69243 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2021 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/22/1994 12:00:00 AM | 16 | Permit Number 33307 | 6003282.73155 | 2118223.78108 | 37.7964238439467 | -122.432675884388 | (37.7964238439467, -122.432675884388) | 13 | 9 | 1 | 57 | 17 | ||
| 140300 | 136005 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1237x Robert C Levy Tunl | 9 | Median : Yard | Tree | DPW 1 | 3 | 6007661.46268 | 2118150.4985 | 37.7964699809712 | -122.417519302367 | (37.7964699809712, -122.417519302367) | 5 | 1 | 10 | 28858 | 32 | ||||
| 59393 | 50792 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2740 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Permit Number 47317 | 5999864.3976 | 2118141.20218 | 37.7960026509676 | -122.444498073449 | (37.7960026509676, -122.444498073449) | 13 | 9 | 1 | 57 | 17 | |||
| 30319 | 136006 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1237x Robert C Levy Tunl | 10 | Median : Yard | Tree | DPW 1 | 3 | 6007669.82361 | 2118117.13537 | 37.7963788445653 | -122.417488005977 | (37.7963788445653, -122.417488005977) | 5 | 1 | 10 | 28858 | 32 | ||||
| 38841 | 48912 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1930 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/22/2002 12:00:00 AM | 2 | 3x3 | Permit Number 46107 | 6004309.09705 | 2118070.5094 | 37.7960611527628 | -122.429113506091 | (37.7960611527628, -122.429113506091) | 13 | 9 | 1 | 57 | 17 |
| 158690 | 135917 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2350 Green St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 3ft | 6001679.33795 | 2118057.34258 | 37.7958757853901 | -122.438212029083 | (37.7958757853901, -122.438212029083) | 13 | 9 | 1 | 57 | 17 | |||
| 134505 | 38505 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1123 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/26/1998 12:00:00 AM | 9 | Permit Number 40496 | 6008719.38643 | 2117949.78915 | 37.7959783521792 | -122.413844440467 | (37.7959783521792, -122.413844440467) | 5 | 1 | 10 | 308 | 21 | ||
| 73667 | 64340 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2118 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/13/1988 12:00:00 AM | 12 | 3x3 | Permit Number 25169 | 6003411.36684 | 2117944.79381 | 37.7956651110998 | -122.432210844949 | (37.7956651110998, -122.432210844949) | 13 | 9 | 1 | 57 | 17 | |
| 35093 | 135973 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2118 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6003393.93756 | 2117943.36114 | 37.7956601891322 | -122.432271050962 | (37.7956601891322, -122.432271050962) | 13 | 9 | 1 | 57 | 17 | |||
| 62335 | 135977 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2065 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6003684.73578 | 2117929.31477 | 37.7956381053729 | -122.431263834562 | (37.7956381053729, -122.431263834562) | 13 | 9 | 1 | 29490 | 27 | |||
| 96627 | 135967 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2831 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6002534.88565 | 2117883.88227 | 37.7954481298799 | -122.435239263394 | (37.7954481298799, -122.435239263394) | 13 | 9 | 1 | 57 | 17 | |||
| 43530 | 135968 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2831 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6002535.74001 | 2117875.30124 | 37.7954246171123 | -122.435235693088 | (37.7954246171123, -122.435235693088) | 13 | 9 | 1 | 57 | 17 | |||
| 189841 | 135969 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2831 Fillmore St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6002539.26746 | 2117862.89665 | 37.7953907576358 | -122.435222599839 | (37.7953907576358, -122.435222599839) | 13 | 9 | 1 | 57 | 17 | |||
| 120825 | 34255 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2280 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/23/2016 12:00:00 AM | 3 | 6x4 | Permit Number 779106 | 6002701.36974 | 2117843.10011 | 37.7953456053627 | -122.434660283471 | (37.7953456053627, -122.434660283471) | 13 | 9 | 1 | 57 | 17 | |
| 96108 | 135970 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2300 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6002518.2577 | 2117817.87673 | 37.7952659515087 | -122.435292075163 | (37.7952659515087, -122.435292075163) | 13 | 9 | 1 | 57 | 17 | |||
| 48711 | 135971 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2300 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6002511.97848 | 2117816.96734 | 37.7952630979691 | -122.435313737159 | (37.7952630979691, -122.435313737159) | 13 | 9 | 1 | 57 | 17 | |||
| 53836 | 117560 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2304 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/30/2016 12:00:00 AM | 3 | 4x4 | Permit Number 778613 | 6002499.39832 | 2117814.1104 | 37.7952545391263 | -122.435357062003 | (37.7952545391263, -122.435357062003) | 13 | 9 | 1 | 57 | 17 | |
| 145043 | 135972 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2304 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6002483.01544 | 2117812.37138 | 37.7952488338219 | -122.435413624843 | (37.7952488338219, -122.435413624843) | 13 | 9 | 1 | 57 | 17 | |||
| 81108 | 49149 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2721 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/2003 12:00:00 AM | 8 | Permit Number 46272 | 6001579.27273 | 2117782.40416 | 37.7951151846669 | -122.438538563903 | (37.7951151846669, -122.438538563903) | 13 | 9 | 1 | 57 | 27 | ||
| 4116 | 262380 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1100 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008843.96123 | 2117672.51917 | 37.7952240323069 | -122.413393767718 | (37.7952240323069, -122.413393767718) | 5 | 1 | 10 | 308 | 21 | ||||
| 14535 | 119254 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1100 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6008843.96123 | 2117672.51917 | 37.7952240323069 | -122.413393767718 | (37.7952240323069, -122.413393767718) | 5 | 1 | 10 | 308 | 21 | |||
| 176731 | 17356 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2200 Franklin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6005536.16539 | 2117610.65272 | 37.7948678872914 | -122.424834871756 | (37.7948678872914, -122.424834871756) | 13 | 9 | 1 | 28858 | 27 | |||
| 123692 | 17355 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2200 Franklin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6005540.30706 | 2117584.3351 | 37.7947958596827 | -122.424818667772 | (37.7947958596827, -122.424818667772) | 13 | 9 | 1 | 28858 | 27 | |||
| 162106 | 17354 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2200 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6005542.87933 | 2117567.08542 | 37.7947486417029 | -122.424808539584 | (37.7947486417029, -122.424808539584) | 13 | 9 | 1 | 28858 | 27 | |||
| 170697 | 54378 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2105 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/07/2013 12:00:00 AM | 3 | 0 | Permit Number 769000 | 6003486.81156 | 2117545.01589 | 37.7945717009834 | -122.431921232674 | (37.7945717009834, -122.431921232674) | 13 | 9 | 1 | 29490 | 27 | |
| 104181 | 98790 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 950x CLAY ST | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3x3 | Permit Number 768771 | 6010160 | 2117472 | 37.7947472579955 | -122.408825891367 | (37.7947472579955, -122.408825891367) | 3 | 1 | 10 | 28857 | 4 | ||
| 37392 | 96373 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1315 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/17/2011 12:00:00 AM | 8 | 3x3 | Permit Number 768288 | 6008912.46348 | 2117456.9297 | 37.7946359224745 | -122.413141486295 | (37.7946359224745, -122.413141486295) | 5 | 1 | 10 | 28857 | 21 | |
| 17111 | 71253 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1436 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 3x3 | 6007270.15279 | 2117448.61656 | 37.7945207624857 | -122.418823519012 | (37.7945207624857, -122.418823519012) | 5 | 1 | 10 | 28858 | 32 | ||
| 51110 | 49515 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2360@ FILLMORE Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/23/2003 12:00:00 AM | 4 | Permit Number 46421 | 6002343.25635 | 2117445.35992 | 37.7942331772802 | -122.435870940009 | (37.7942331772802, -122.435870940009) | 13 | 9 | 1 | 29490 | 27 | ||
| 177201 | 96374 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1315 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/17/2011 12:00:00 AM | 8 | 3x3 | Permit Number 768288 | 6008916.21068 | 2117429.19629 | 37.7945599836999 | -122.413126558466 | (37.7945599836999, -122.413126558466) | 5 | 1 | 10 | 28857 | 21 | |
| 25934 | 135966 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2610 Scott St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6001187.63413 | 2117406.94715 | 37.7940619922234 | -122.439866757361 | (37.7940619922234, -122.439866757361) | 13 | 9 | 1 | 57 | 27 | |||
| 30472 | 100032 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1199 Mason St | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 08/02/2012 12:00:00 AM | 3x3 | Permit Number 769129 | 6009411 | 2117399.5 | 37.7945062091547 | -122.411412418869 | (37.7945062091547, -122.411412418869) | 3 | 1 | 10 | 28857 | 21 | ||
| 71695 | 100034 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1199@Washington Mason St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 08/02/2012 12:00:00 AM | Permit Number 769129 | 6009411 | 2117399.5 | 37.7945062091547 | -122.411412418869 | (37.7945062091547, -122.411412418869) | 3 | 1 | 10 | 28857 | 21 | |||
| 143356 | 100035 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1199@Washington Mason St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 08/02/2012 12:00:00 AM | Permit Number 769129 | 6009411 | 2117399.5 | 37.7945062091547 | -122.411412418869 | (37.7945062091547, -122.411412418869) | 3 | 1 | 10 | 28857 | 21 | |||
| 151278 | 100037 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1199@Washington Mason St | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 08/02/2012 12:00:00 AM | Permit Number 769129 | 6009411 | 2117399.5 | 37.7945062091547 | -122.411412418869 | (37.7945062091547, -122.411412418869) | 3 | 1 | 10 | 28857 | 21 | |||
| 153256 | 100033 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1199 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 08/02/2012 12:00:00 AM | Permit Number 769129 | 6009411 | 2117399.5 | 37.7945062091547 | -122.411412418869 | (37.7945062091547, -122.411412418869) | 3 | 1 | 10 | 28857 | 21 | |||
| 178352 | 100036 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1199@Washington Mason St | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 08/02/2012 12:00:00 AM | Permit Number 769129 | 6009411 | 2117399.5 | 37.7945062091547 | -122.411412418869 | (37.7945062091547, -122.411412418869) | 3 | 1 | 10 | 28857 | 21 | |||
| 192359 | 135959 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2980 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 5999366.62942 | 2117378.52806 | 37.793880135816 | -122.446165554106 | (37.793880135816, -122.446165554106) | 13 | 9 | 1 | 57 | 27 | |||
| 16183 | 135997 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1101 Washington St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6009336.40364 | 2117377.1493 | 37.7944406553528 | -122.411668952587 | (37.7944406553528, -122.411668952587) | 3 | 1 | 10 | 28857 | 21 | |||
| 151203 | 135960 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2980 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 5999353.02383 | 2117377.12096 | 37.7938754952995 | -122.446212529304 | (37.7938754952995, -122.446212529304) | 13 | 9 | 1 | 57 | 27 | |||
| 8166 | 135996 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1101 Washington St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6009314.46183 | 2117374.97438 | 37.7944334526921 | -122.411744720456 | (37.7944334526921, -122.411744720456) | 3 | 1 | 10 | 28857 | 21 | |||
| 13277 | 135995 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1101 Washington St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6009287.1824 | 2117369.66466 | 37.7944173431466 | -122.411838735572 | (37.7944173431466, -122.411838735572) | 3 | 1 | 10 | 28857 | 21 | |||
| 1598 | 135994 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1101 Washington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6009269.53041 | 2117367.69461 | 37.7944109435695 | -122.411899674537 | (37.7944109435695, -122.411899674537) | 3 | 1 | 10 | 28857 | 21 | |||
| 19515 | 135993 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1101 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6009221.31733 | 2117360.97425 | 37.794389786122 | -122.412066023053 | (37.794389786122, -122.412066023053) | 3 | 1 | 10 | 28857 | 21 | |||
| 10833 | 135992 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1101 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6009196.7187 | 2117357.70571 | 37.7943794313202 | -122.412150906452 | (37.7943794313202, -122.412150906452) | 3 | 1 | 10 | 28857 | 21 | |||
| 42087 | 88407 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1199 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 08/02/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769129 | 6009407.88363 | 2117347.72867 | 37.7943638829406 | -122.411419542685 | (37.7943638829406, -122.411419542685) | 3 | 1 | 10 | 28857 | 21 | |
| 114399 | 135958 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2961 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 5999426.86428 | 2117337.28078 | 37.7937703214002 | -122.445954168467 | (37.7937703214002, -122.445954168467) | 13 | 9 | 1 | 57 | 27 | |||
| 193127 | 135962 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2600 Divisadero St | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6000720.81325 | 2117333.08986 | 37.7938326156312 | -122.441476699387 | (37.7938326156312, -122.441476699387) | 13 | 9 | 1 | 57 | 27 | |||
| 40378 | 135957 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2961 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 5999402.43366 | 2117332.15593 | 37.7937548548653 | -122.446038331519 | (37.7937548548653, -122.446038331519) | 13 | 9 | 1 | 57 | 27 | |||
| 180788 | 88408 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1199 Mason St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 08/02/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769129 | 6009412.43491 | 2117319.72378 | 37.7942872436256 | -122.411401815264 | (37.7942872436256, -122.411401815264) | 3 | 1 | 10 | 28857 | 21 | |
| 156207 | 135964 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2574 Broadway | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6001301.48342 | 2117308.30173 | 37.7937976176176 | -122.439465753262 | (37.7937976176176, -122.439465753262) | 13 | 9 | 1 | 57 | 27 | |||
| 56781 | 135965 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2574 Broadway | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6001290.6793 | 2117307.18376 | 37.7937939330834 | -122.439503056242 | (37.7937939330834, -122.439503056242) | 13 | 9 | 1 | 57 | 27 | |||
| 11139 | 57395 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1415 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/15/1994 12:00:00 AM | 4 | Permit Number 33423 | 6007958.46126 | 2117300.9237 | 37.7941539658926 | -122.416431412305 | (37.7941539658926, -122.416431412305) | 5 | 1 | 10 | 28858 | 32 | ||
| 32309 | 88409 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1199 Mason St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 08/02/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769129 | 6009413.9789 | 2117291.03714 | 37.7942085637169 | -122.41139444529 | (37.7942085637169, -122.41139444529) | 3 | 1 | 10 | 28857 | 21 | |
| 87213 | 100031 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1199 Mason St | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 08/02/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769129 | 6009418.42249 | 2117262.251 | 37.7941297732341 | -122.411377035334 | (37.7941297732341, -122.411377035334) | 3 | 1 | 10 | 28857 | 21 | |
| 147598 | 135963 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2517 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 6001390.29582 | 2117256.32875 | 37.793659967376 | -122.439154728128 | (37.793659967376, -122.439154728128) | 13 | 9 | 1 | 29490 | 27 | |||
| 11026 | 53052 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2517@ SCOTT Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/27/2006 12:00:00 AM | 5 | Permit Number 49029 | 6001372.25817 | 2117256.0832 | 37.7936582667653 | -122.439217122188 | (37.7936582667653, -122.439217122188) | 13 | 9 | 1 | 29490 | 27 | |
| 105143 | 135961 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2600 Divisadero St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6000735.77189 | 2117237.48779 | 37.7935709695869 | -122.441418078004 | (37.7935709695869, -122.441418078004) | 13 | 9 | 1 | 57 | 27 | |||
| 132324 | 135974 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2266 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6003300.9204 | 2117230.69268 | 37.793698110328 | -122.432541977147 | (37.793698110328, -122.432541977147) | 13 | 9 | 1 | 29490 | 27 | |||
| 73001 | 98796 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 950@Washington Clay St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 03/16/2012 12:00:00 AM | 3 | 3x3 | Permit Number 768771 | 6010177.18626 | 2117200.01626 | 37.7940014192822 | -122.408747227007 | (37.7940014192822, -122.408747227007) | 3 | 1 | 10 | 28857 | 4 | |
| 67796 | 33273 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1121 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/13/1996 12:00:00 AM | 7 | Permit Number 37442 | 6009382.25638 | 2117052.96271 | 37.7935530901583 | -122.411487381259 | (37.7935530901583, -122.411487381259) | 3 | 1 | 10 | 28857 | 21 | |
| 33557 | 135998 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1043 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009470.07385 | 2116888.98279 | 37.7931077665596 | -122.411171935935 | (37.7931077665596, -122.411171935935) | 3 | 1 | 10 | 28857 | 21 | |||
| 100186 | 135999 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1043 Mason St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009475.36486 | 2116853.62807 | 37.7930109878303 | -122.411151130141 | (37.7930109878303, -122.411151130141) | 3 | 1 | 10 | 28857 | 21 | |||
| 58470 | 136000 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1043 Mason St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009476.57256 | 2116845.84647 | 37.7929896891793 | -122.411146401493 | (37.7929896891793, -122.411146401493) | 3 | 1 | 10 | 28857 | 21 | |||
| 78840 | 136001 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1043 Mason St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009476.76834 | 2116835.36375 | 37.7929609171614 | -122.411144983273 | (37.7929609171614, -122.411144983273) | 3 | 1 | 10 | 28857 | 21 | |||
| 26102 | 136002 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1043 Mason St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6009478.99985 | 2116817.49063 | 37.7929119670677 | -122.411135999022 | (37.7929119670677, -122.411135999022) | 3 | 1 | 10 | 28857 | 21 | |||
| 130066 | 136003 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1043 Mason St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009481.94772 | 2116801.23595 | 37.7928675009884 | -122.411124650506 | (37.7928675009884, -122.411124650506) | 3 | 1 | 10 | 28857 | 21 | |||
| 50563 | 88416 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1100 Sacramento St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51386 | 6009510 | 2116776 | 37.7927997823299 | -122.411025804578 | (37.7927997823299, -122.411025804578) | 3 | 1 | 10 | 28857 | 21 | ||
| 91852 | 88421 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1100 Sacramento St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51386 | 6009510 | 2116776 | 37.7927997823299 | -122.411025804578 | (37.7927997823299, -122.411025804578) | 3 | 1 | 10 | 28857 | 21 | ||
| 137212 | 88418 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1100 Sacramento St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51386 | 6009510 | 2116776 | 37.7927997823299 | -122.411025804578 | (37.7927997823299, -122.411025804578) | 3 | 1 | 10 | 28857 | 21 | ||
| 153077 | 88417 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1100 Sacramento St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51386 | 6009510 | 2116776 | 37.7927997823299 | -122.411025804578 | (37.7927997823299, -122.411025804578) | 3 | 1 | 10 | 28857 | 21 | ||
| 156455 | 88419 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1100 Sacramento St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51386 | 6009510 | 2116776 | 37.7927997823299 | -122.411025804578 | (37.7927997823299, -122.411025804578) | 3 | 1 | 10 | 28857 | 21 | ||
| 191235 | 88420 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1100 Sacramento St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51386 | 6009510 | 2116776 | 37.7927997823299 | -122.411025804578 | (37.7927997823299, -122.411025804578) | 3 | 1 | 10 | 28857 | 21 | ||
| 105885 | 88412 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1100 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51386 | 6009452.7788 | 2116769.6537 | 37.7927791479928 | -122.411223344786 | (37.7927791479928, -122.411223344786) | 3 | 1 | 10 | 28857 | 21 | |
| 103353 | 88413 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1100 Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51386 | 6009439.10659 | 2116768.27237 | 37.7927745884158 | -122.411270553799 | (37.7927745884158, -122.411270553799) | 3 | 1 | 10 | 28857 | 21 | |
| 35235 | 88414 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1100 Sacramento St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51386 | 6009411.74152 | 2116765.8223 | 37.7927663263429 | -122.41136506535 | (37.7927663263429, -122.41136506535) | 3 | 1 | 10 | 28857 | 21 | |
| 29561 | 88415 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1100 Sacramento St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51386 | 6009399.28346 | 2116763.19844 | 37.7927584231235 | -122.411407985496 | (37.7927584231235, -122.411407985496) | 3 | 1 | 10 | 28857 | 21 | |
| 129220 | 111197 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2317 Washington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 6003620.63323 | 2116569.07161 | 37.7918995930282 | -122.431388491405 | (37.7918995930282, -122.431388491405) | 13 | 9 | 1 | 29490 | 27 | ||||
| 130599 | 105719 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2317 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775548 | 6003614.61217 | 2116568.84347 | 37.7918986253737 | -122.431409307988 | (37.7918986253737, -122.431409307988) | 13 | 9 | 1 | 29490 | 27 | |
| 105736 | 99740 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2770 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/01/2012 12:00:00 AM | 3x3 | Permit Number 768985 | 6000934 | 2116568 | 37.7917440216798 | -122.440684150501 | (37.7917440216798, -122.440684150501) | 13 | 6 | 1 | 29490 | 27 | ||
| 142216 | 99741 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2770 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/01/2012 12:00:00 AM | 3x3 | Permit Number 768985 | 6000934 | 2116568 | 37.7917440216798 | -122.440684150501 | (37.7917440216798, -122.440684150501) | 13 | 6 | 1 | 29490 | 27 | ||
| 180377 | 111196 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2317 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/27/2015 12:00:00 AM | 3 | Permit Number 775548 | 6003599.35024 | 2116566.69152 | 37.7918918516902 | -122.431461960596 | (37.7918918516902, -122.431461960596) | 13 | 9 | 1 | 29490 | 27 | ||
| 94279 | 135976 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2319 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6003577.71337 | 2116564.31874 | 37.7918841103205 | -122.43153665472 | (37.7918841103205, -122.43153665472) | 13 | 9 | 1 | 29490 | 27 | |||
| 175938 | 135975 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2325 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6003558.57482 | 2116562.95168 | 37.79187927196 | -122.431602776473 | (37.79187927196, -122.431602776473) | 13 | 9 | 1 | 29490 | 27 | |||
| 66708 | 39922 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2335 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/1999 12:00:00 AM | 6 | Permit Number 41196 | 6003527.33622 | 2116558.3105 | 37.7918647577979 | -122.431710530526 | (37.7918647577979, -122.431710530526) | 13 | 9 | 1 | 29490 | 27 | |
| 115280 | 36752 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2579 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/1999 12:00:00 AM | 5 | Permit Number 41197 | 6002410.05116 | 2116400.74901 | 37.7913687394284 | -122.435565056287 | (37.7913687394284, -122.435565056287) | 13 | 9 | 1 | 29490 | 27 | |
| 100266 | 36753 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2579 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/1999 12:00:00 AM | 8 | Permit Number 41197 | 6002394.06342 | 2116399.40669 | 37.7913641456997 | -122.435620277371 | (37.7913641456997, -122.435620277371) | 13 | 9 | 1 | 29490 | 27 | |
| 80154 | 135938 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 20 Walnut St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 5998466.03707 | 2116398.73144 | 37.7911384032693 | -122.44921105427 | (37.7911384032693, -122.44921105427) | 13 | 6 | 1 | 54 | 31 | |||
| 184890 | 135939 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 20 Walnut St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 5998471.02227 | 2116380.33284 | 37.7910881707365 | -122.449192479647 | (37.7910881707365, -122.449192479647) | 13 | 6 | 1 | 54 | 31 | |||
| 79234 | 51284 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2205 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/24/2004 12:00:00 AM | 4 | Permit Number 47656 | 6000322.72568 | 2116238.1776 | 37.7908035865572 | -122.442775457127 | (37.7908035865572, -122.442775457127) | 13 | 6 | 1 | 29490 | 27 | ||
| 3266 | 48394 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2520 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/23/2002 12:00:00 AM | 14 | Permit Number 45776 | 6002671.64848 | 2116160.62189 | 37.7907242663701 | -122.434642758376 | (37.7907242663701, -122.434642758376) | 13 | 9 | 1 | 29490 | 27 | |
| 87651 | 135933 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 98 Spruce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5997039.44005 | 2116145.17864 | 37.7903605148824 | -122.45412868571 | (37.7903605148824, -122.45412868571) | 11 | 6 | 1 | 54 | 31 | |||
| 11733 | 135934 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 98 Spruce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5997041.86737 | 2116129.80097 | 37.7903184311097 | -122.454119176269 | (37.7903184311097, -122.454119176269) | 11 | 6 | 1 | 54 | 31 | |||
| 159313 | 46513 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2563 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/2002 12:00:00 AM | 4 | Permit Number 44679 | 6002506.83642 | 2116089.37205 | 37.790519274906 | -122.435207900427 | (37.790519274906, -122.435207900427) | 13 | 9 | 1 | 29490 | 27 | ||
| 28964 | 135935 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 98 Spruce St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5997049.33252 | 2116083.66446 | 37.7901921806791 | -122.45409001394 | (37.7901921806791, -122.45409001394) | 11 | 6 | 1 | 54 | 31 | |||
| 35793 | 7950 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1735 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2008 12:00:00 AM | 3 | 3X3 | 6005696.54994 | 2116082.67925 | 37.7906815134801 | -122.424171198144 | (37.7906815134801, -122.424171198144) | 13 | 9 | 1 | 28858 | 27 |
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) );