trees
4,014 rows where qSpecies_id = 40 sorted by TreeID
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |
| 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 | ||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 57105 | 10022 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 282 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/01/2003 12:00:00 AM | 3 | 2x2 | 6005445.78054 | 2107378.48496 | 37.7667677623348 | -122.424419474005 | (37.7667677623348, -122.424419474005) | 8 | 4 | 5 | 28853 | 19 | ||
| 115286 | 100355 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 591 Waller St | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 12/30/2014 12:00:00 AM | 3 | 27x6 | Permit Number 769031 | 6002899.6 | 2108847.2 | 37.7706563827164 | -122.43333123962 | (37.7706563827164, -122.43333123962) | 15 | 5 | 5 | 29492 | 9 | ||
| 17831 | 10059 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 481 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/04/2010 12:00:00 AM | 3 | 3X3 | 6005579.31828 | 2106221.19384 | 37.7635976557175 | -122.42387528793 | (37.7635976557175, -122.42387528793) | 8 | 4 | 5 | 28859 | 19 | ||
| 77010 | 10085 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 648 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/29/1998 12:00:00 AM | 13 | 3x2 | 6005571.80442 | 2105186.72531 | 37.7607568250935 | -122.423827714701 | (37.7607568250935, -122.423827714701) | 2 | 4 | 5 | 28859 | 19 | ||
| 163775 | 100870 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 23 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/18/2012 12:00:00 AM | 1 | 3x3 | Permit Number 769325 | 5995481.9791 | 2111446.40578 | 37.7773695144675 | -122.459176965843 | (37.7773695144675, -122.459176965843) | 11 | 6 | 2 | 54 | 11 | |
| 176980 | 101011 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 83 Santa Ynez Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 10 | 6x10 | 6000610.71791 | 2092062.1351 | 37.724438494726 | -122.440044730491 | (37.724438494726, -122.440044730491) | 9 | 7 | 6 | 28861 | 25 | |||
| 193521 | 10102 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 771 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2003 12:00:00 AM | 3 | 2X2 | 6005674.23902 | 2104513.09601 | 37.7589129792732 | -122.423425548652 | (37.7589129792732, -122.423425548652) | 2 | 4 | 5 | 28859 | 19 | ||
| 91034 | 101319 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2-4 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 6x5 | 6003417 | 2108348 | 37.7693150407363 | -122.431505903511 | (37.7693150407363, -122.431505903511) | 15 | 9 | 5 | 28862 | 10 | |||
| 140231 | 101655 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 200X Vasquez Ave | 2 | Median : Cutout | Tree | DPW 1 | 6 | 8 | 5994672.47713 | 2099264.801 | 37.7438754024487 | -122.461094099214 | (37.7438754024487, -122.461094099214) | 1 | 8 | 4 | 59 | 40 | |||
| 61092 | 10178 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1086 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/29/2001 12:00:00 AM | 16 | 2X2 | 6005705.19862 | 2102704.3683 | 37.7539483816144 | -122.423189907382 | (37.7539483816144, -122.423189907382) | 2 | 4 | 5 | 28859 | 19 | ||
| 167659 | 10191 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1163 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/1991 12:00:00 AM | 12 | 2X3 | 6005802.7182 | 2102181.70358 | 37.7525187680511 | -122.422815518735 | (37.7525187680511, -122.422815518735) | 2 | 4 | 5 | 28859 | 19 | ||
| 14998 | 101958 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 200X Ripley St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/12/2013 12:00:00 AM | 3x3 | Permit Number 770180 | 6009339 | 2099105 | 37.744269714821 | -122.410369184032 | (37.744269714821, -122.410369184032) | 2 | 7 | 7 | 28859 | 2 | ||
| 153466 | 10197 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1201 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/2004 12:00:00 AM | 3 | 2X2 | 6005817.7414 | 2101914.20762 | 37.7517851334751 | -122.422744557723 | (37.7517851334751, -122.422744557723) | 2 | 4 | 5 | 28859 | 19 | ||
| 177284 | 10199 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1212 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 2X2 | 6005752.31611 | 2101874.30524 | 37.7516718791661 | -122.422967971788 | (37.7516718791661, -122.422967971788) | 2 | 4 | 5 | 28859 | 19 | |||
| 191654 | 102036 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3601X Jennings St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | Permit Number 52501 | 6012999.572 | 2089254.628 | 37.7174271437906 | -122.397021097837 | (37.7174271437906, -122.397021097837) | 10 | 3 | 8 | 58 | 1 | ||
| 19539 | 102037 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3601X Jennings St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | Permit Number 52501 | 6012999.572 | 2089254.628 | 37.7174271437906 | -122.397021097837 | (37.7174271437906, -122.397021097837) | 10 | 3 | 8 | 58 | 1 | ||
| 73535 | 102038 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3601X Jennings St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | Permit Number 52501 | 6012999.572 | 2089254.628 | 37.7174271437906 | -122.397021097837 | (37.7174271437906, -122.397021097837) | 10 | 3 | 8 | 58 | 1 | ||
| 33364 | 102039 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3601X Jennings St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | Permit Number 52501 | 6012999.572 | 2089254.628 | 37.7174271437906 | -122.397021097837 | (37.7174271437906, -122.397021097837) | 10 | 3 | 8 | 58 | 1 | ||
| 182043 | 10208 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1286 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/28/1991 12:00:00 AM | 3 | 2X2 | 6005769.15445 | 2101526.21369 | 37.7507170500487 | -122.422885005752 | (37.7507170500487, -122.422885005752) | 2 | 4 | 5 | 28859 | 19 | ||
| 135610 | 10215 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1335 Guerrero St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/24/2000 12:00:00 AM | 6 | 3X3 | 6005858.33864 | 2101181.45988 | 37.749775467064 | -122.422552103702 | (37.749775467064, -122.422552103702) | 2 | 4 | 5 | 28859 | 19 | ||
| 28138 | 10217 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1351 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/08/2002 12:00:00 AM | 6 | 3X3 | 6005868.4867153 | 2101104.801102 | 37.7495655521395 | -122.422511564697 | (37.7495655521395, -122.422511564697) | 2 | 4 | 5 | 28859 | 19 | ||
| 187812 | 102171 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 9X Hattie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769765 | 6000621 | 2105580.9 | 37.7615584024391 | -122.440978567809 | (37.7615584024391, -122.440978567809) | 15 | 5 | 5 | 28862 | 3 |
| 79494 | 102172 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 9X Hattie St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769765 | 6000621 | 2105580.9 | 37.7615584024391 | -122.440978567809 | (37.7615584024391, -122.440978567809) | 15 | 5 | 5 | 28862 | 3 |
| 109169 | 10219 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1361 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/2002 12:00:00 AM | 6 | 3X3 | 6005865.11973 | 2101072.64646 | 37.7494770729178 | -122.422520923317 | (37.7494770729178, -122.422520923317) | 2 | 4 | 5 | 28859 | 19 | ||
| 22152 | 10228 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1411 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/02/2002 12:00:00 AM | 6 | 3X3 | 6005886.64477 | 2100667.53648 | 37.7483659479448 | -122.422417708118 | (37.7483659479448, -122.422417708118) | 2 | 4 | 5 | 28859 | 19 | ||
| 3312 | 102758 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1392 09TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 5993422.3 | 2106025.2 | 37.7623656970292 | -122.465908002531 | (37.7623656970292, -122.465908002531) | 1 | 8 | 11 | 56 | 12 | |||
| 192046 | 102844 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1471 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/16/2013 12:00:00 AM | 3x3 | Permit Number 770146 | 6003321 | 2099676 | 37.7454983546222 | -122.431218877952 | (37.7454983546222, -122.431218877952) | 2 | 7 | 5 | 63 | 22 | ||
| 108764 | 103040 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 450X Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6005621.8 | 2110912.7 | 37.7764818047314 | -122.424062011758 | (37.7764818047314, -122.424062011758) | 7 | 9 | 11 | 28852 | 10 | |||
| 48274 | 103042 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 450X Octavia St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6005621.8 | 2110912.7 | 37.7764818047314 | -122.424062011758 | (37.7764818047314, -122.424062011758) | 7 | 9 | 11 | 28852 | 10 | |||
| 22969 | 103049 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 400X Octavia St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6005072 | 2110257 | 37.7746503556504 | -122.425917242315 | (37.7746503556504, -122.425917242315) | 7 | 9 | 11 | 28852 | 10 | |||
| 31840 | 103051 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 400X Octavia St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 5 | 3x3 | 6005072 | 2110257 | 37.7746503556504 | -122.425917242315 | (37.7746503556504, -122.425917242315) | 7 | 9 | 11 | 28852 | 10 | |||
| 181673 | 103052 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 400X Octavia St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 5 | 3x3 | 6005072 | 2110257 | 37.7746503556504 | -122.425917242315 | (37.7746503556504, -122.425917242315) | 7 | 9 | 11 | 28852 | 10 | |||
| 166480 | 103078 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 445 Octavia St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6005464 | 2110963 | 37.7766110057417 | -122.424611466414 | (37.7766110057417, -122.424611466414) | 7 | 9 | 11 | 28852 | 10 | |||
| 185269 | 103079 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 445 Octavia St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6005464 | 2110963 | 37.7766110057417 | -122.424611466414 | (37.7766110057417, -122.424611466414) | 7 | 9 | 11 | 28852 | 10 | |||
| 141008 | 103080 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 445 Octavia St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6005464 | 2110963 | 37.7766110057417 | -122.424611466414 | (37.7766110057417, -122.424611466414) | 7 | 9 | 11 | 28852 | 10 | |||
| 145221 | 103081 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 445 Octavia St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6005464 | 2110963 | 37.7766110057417 | -122.424611466414 | (37.7766110057417, -122.424611466414) | 7 | 9 | 11 | 28852 | 10 | |||
| 65214 | 103112 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 539 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/21/2013 12:00:00 AM | 3x3 | Permit Number 770029 | 5994732.2 | 2092139.3 | 37.7243139617339 | -122.460371410138 | (37.7243139617339, -122.460371410138) | 9 | 8 | 4 | 28861 | 24 | ||
| 177592 | 103235 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 116 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/03/2013 12:00:00 AM | 5 | Permit Number 770114 | 5998278 | 2110273 | 37.7743079905046 | -122.44942009354 | (37.7743079905046, -122.44942009354) | 15 | 5 | 11 | 29492 | 16 | ||
| 123875 | 103273 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 76-78 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/28/2013 12:00:00 AM | 3x3 | Permit Number 768961 | 6001664.7 | 2105412.5 | 37.7611554066092 | -122.437356784873 | (37.7611554066092, -122.437356784873) | 15 | 4 | 5 | 28862 | 3 | |
| 117444 | 10331 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 838 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/12/2007 12:00:00 AM | 8 | 5x5 | 6002106.05232 | 2109235.22443 | 37.7716767506941 | -122.436103899002 | (37.7716767506941, -122.436103899002) | 15 | 5 | 11 | 29492 | 9 | ||
| 16956 | 103454 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 284 24th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/2019 12:00:00 AM | 3 | 3x3 | 5988396.69633 | 2114118.88325 | 37.7842975073391 | -122.483882980771 | (37.7842975073391, -122.483882980771) | 11 | 6 | 2 | 55 | 26 | ||
| 72031 | 103497 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1850X Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/12/2014 12:00:00 AM | 1 | 3x3 | Permit Number 771036 | 5989824.39083 | 2110619.3957 | 37.7747718964667 | -122.47868769738 | (37.7747718964667, -122.47868769738) | 11 | 6 | 2 | 55 | 26 | |
| 192680 | 103498 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1850X Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/12/2014 12:00:00 AM | 1 | 3x3 | Permit Number 771036 | 5989807.55073 | 2110619.14229 | 37.7747702228876 | -122.478745931564 | (37.7747702228876, -122.478745931564) | 11 | 6 | 2 | 55 | 26 | |
| 96447 | 103499 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1850X Cabrillo St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/12/2014 12:00:00 AM | 1 | 3x3 | Permit Number 771036 | 5989789.80565 | 2110619.51755 | 37.7747702228862 | -122.478807342211 | (37.7747702228862, -122.478807342211) | 11 | 6 | 2 | 55 | 26 | |
| 79193 | 103760 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 100X Austin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006758.9 | 2115521.2 | 37.7891997559918 | -122.420455645258 | (37.7891997559918, -122.420455645258) | 13 | 9 | 10 | 28858 | 21 | ||
| 113233 | 103761 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 106X Austin St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006685.57502 | 2115508.13748 | 37.7891597571573 | -122.420708413481 | (37.7891597571573, -122.420708413481) | 13 | 9 | 10 | 28858 | 21 | ||
| 186298 | 103762 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 90X Frank Norris St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6007013.605 | 2115541.6847 | 37.7892703521256 | -122.419575849271 | (37.7892703521256, -122.419575849271) | 13 | 9 | 10 | 28858 | 21 | ||
| 147227 | 103763 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 90X Frank Norris St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6007013.605 | 2115541.6847 | 37.7892703521256 | -122.419575849271 | (37.7892703521256, -122.419575849271) | 13 | 9 | 10 | 28858 | 21 | ||
| 119335 | 103764 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 90X Frank Norris St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6007013.605 | 2115541.6847 | 37.7892703521256 | -122.419575849271 | (37.7892703521256, -122.419575849271) | 13 | 9 | 10 | 28858 | 21 | ||
| 28084 | 103765 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 101X Austin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006551.29204 | 2115477.084 | 37.7890669227742 | -122.42117081077 | (37.7890669227742, -122.42117081077) | 13 | 9 | 10 | 28858 | 21 | ||
| 20779 | 103766 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 101X Austin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006706.11036 | 2115484.69473 | 37.7890965465282 | -122.420635698799 | (37.7890965465282, -122.420635698799) | 13 | 9 | 10 | 28858 | 21 | ||
| 72117 | 103776 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 90X Fern St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6007061.73741 | 2115197.31568 | 37.7883275106802 | -122.41938487644 | (37.7883275106802, -122.41938487644) | 13 | 9 | 10 | 28858 | 21 | ||
| 23842 | 103777 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 90X Fern St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6007061.73741 | 2115197.31568 | 37.7883275106802 | -122.41938487644 | (37.7883275106802, -122.41938487644) | 13 | 9 | 10 | 28858 | 21 | ||
| 128134 | 103778 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 90X Fern St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6007061.73741 | 2115197.31568 | 37.7883275106802 | -122.41938487644 | (37.7883275106802, -122.41938487644) | 13 | 9 | 10 | 28858 | 21 | ||
| 68044 | 103784 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 103X Fern St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006741.56415 | 2115141.24736 | 37.7881555229055 | -122.420488644345 | (37.7881555229055, -122.420488644345) | 13 | 9 | 10 | 28858 | 21 | ||
| 63425 | 103785 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 103X Fern St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006767.43674 | 2115144.46398 | 37.7881658129506 | -122.420399357843 | (37.7881658129506, -122.420399357843) | 13 | 9 | 10 | 28858 | 21 | ||
| 189169 | 103788 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 99X Fern St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6007061.73741 | 2115197.31568 | 37.7883275106802 | -122.41938487644 | (37.7883275106802, -122.41938487644) | 13 | 9 | 10 | 28858 | 21 | ||
| 123507 | 103789 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 99X Fern St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6007061.73741 | 2115197.31568 | 37.7883275106802 | -122.41938487644 | (37.7883275106802, -122.41938487644) | 13 | 9 | 10 | 28858 | 21 | ||
| 81435 | 103790 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 99X Fern St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6007061.73741 | 2115197.31568 | 37.7883275106802 | -122.41938487644 | (37.7883275106802, -122.41938487644) | 13 | 9 | 10 | 28858 | 21 | ||
| 89069 | 103803 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 98X Hemlock St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6007001.17193 | 2114849.48816 | 37.7873690504995 | -122.419569735969 | (37.7873690504995, -122.419569735969) | 13 | 9 | 10 | 28858 | 21 | ||
| 146672 | 103804 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 98X Hemlock St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006974.73956 | 2114845.21209 | 37.7873558205593 | -122.419660883156 | (37.7873558205593, -122.419660883156) | 13 | 9 | 10 | 28858 | 21 | ||
| 100395 | 103805 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 98X Hemlock St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006953.73656 | 2114843.50125 | 37.7873499398897 | -122.41973342787 | (37.7873499398897, -122.41973342787) | 13 | 9 | 10 | 28858 | 21 | ||
| 60607 | 103806 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 98X Hemlock St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006930.58351 | 2114841.83487 | 37.7873440601297 | -122.419813414468 | (37.7873440601297, -122.419813414468) | 13 | 9 | 10 | 28858 | 21 | ||
| 188159 | 103814 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 99X Hemlock St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006931.25215 | 2114822.01169 | 37.7872896682178 | -122.41980969397 | (37.7872896682178, -122.41980969397) | 13 | 9 | 10 | 28858 | 21 | ||
| 61746 | 103815 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 99X Hemlock St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006959.84507 | 2114826.77891 | 37.7873043685578 | -122.419711106691 | (37.7873043685578, -122.419711106691) | 13 | 9 | 10 | 28858 | 21 | ||
| 133115 | 103831 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 98X Myrtle St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6007204.79066 | 2114178.2136 | 37.7855373621017 | -122.418817630423 | (37.7855373621017, -122.418817630423) | 13 | 9 | 9 | 28858 | 36 | ||
| 109043 | 103832 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 98X Myrtle St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6007204.79066 | 2114178.2136 | 37.7855373621017 | -122.418817630423 | (37.7855373621017, -122.418817630423) | 13 | 9 | 9 | 28858 | 36 | ||
| 122072 | 103833 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 98X Myrtle St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6007204.79066 | 2114178.2136 | 37.7855373621017 | -122.418817630423 | (37.7855373621017, -122.418817630423) | 13 | 9 | 9 | 28858 | 36 | ||
| 94442 | 103875 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 106X Austin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006702.4202 | 2115509.69435 | 37.7891649813311 | -122.42065024171 | (37.7891649813311, -122.42065024171) | 13 | 9 | 10 | 28858 | 21 | ||
| 124856 | 103876 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 106X Austin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006716.01893 | 2115511.31786 | 37.7891702054911 | -122.420603306998 | (37.7891702054911, -122.420603306998) | 13 | 9 | 10 | 28858 | 21 | ||
| 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 | |
| 45846 | 104075 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 340X Juanita Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2x3 | 5995047.73702 | 2097534.72021 | 37.7391466176195 | -122.459671261566 | (37.7391466176195, -122.459671261566) | 9 | 7 | 4 | 59 | 40 | |||
| 190060 | 104076 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 340X Juanita Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2x3 | 5995047.73702 | 2097534.72021 | 37.7391466176195 | -122.459671261566 | (37.7391466176195, -122.459671261566) | 9 | 7 | 4 | 59 | 40 | |||
| 19275 | 104234 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 298X Shrader St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/16/2015 12:00:00 AM | 3 | 6x6 | Permit Number 771309 | 5997366.55609 | 2109687.30332 | 37.7726476392362 | -122.452530652813 | (37.7726476392362, -122.452530652813) | 15 | 5 | 11 | 29492 | 16 | |
| 49146 | 104249 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 8 Octavia St Frontage East | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4 | 4x4 | 6005716.34743 | 2109200.23605 | 37.771785130185 | -122.423613163533 | (37.771785130185, -122.423613163533) | 7 | 2 | 11 | 28852 | 10 | |||
| 89932 | 104250 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 8x Octavia St Frontage East | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4 | 4x4 | 6005716.34743 | 2109200.23605 | 37.771785130185 | -122.423613163533 | (37.771785130185, -122.423613163533) | 7 | 2 | 11 | 28852 | 10 | |||
| 165233 | 104251 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 8X Octavia St Frontage East | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4 | 4x4 | 6005716.34743 | 2109200.23605 | 37.771785130185 | -122.423613163533 | (37.771785130185, -122.423613163533) | 7 | 2 | 11 | 28852 | 10 | |||
| 115591 | 104252 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 8X Octavia St Frontage East | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4 | 4x4 | 6005716.34743 | 2109200.23605 | 37.771785130185 | -122.423613163533 | (37.771785130185, -122.423613163533) | 7 | 2 | 11 | 28852 | 10 | |||
| 188046 | 104253 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 8X Octavia St Frontage East | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4 | 4x4 | 6005716.34743 | 2109200.23605 | 37.771785130185 | -122.423613163533 | (37.771785130185, -122.423613163533) | 7 | 2 | 11 | 28852 | 10 | |||
| 185536 | 104254 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 8X Octavia St Frontage East | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4 | 4x4 | 6005716.34743 | 2109200.23605 | 37.771785130185 | -122.423613163533 | (37.771785130185, -122.423613163533) | 7 | 2 | 11 | 28852 | 10 | |||
| 10602 | 104255 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 8X Octavia St Frontage East | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 4x4 | 6005716.34743 | 2109200.23605 | 37.771785130185 | -122.423613163533 | (37.771785130185, -122.423613163533) | 7 | 2 | 11 | 28852 | 10 | |||
| 73934 | 104256 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 8X Octavia St Frontage East | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 4x4 | 6005716.34743 | 2109200.23605 | 37.771785130185 | -122.423613163533 | (37.771785130185, -122.423613163533) | 7 | 2 | 11 | 28852 | 10 | |||
| 188115 | 104360 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 57 Stillman St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013954.4 | 2112927.1 | 37.7824798185974 | -122.39537811084 | (37.7824798185974, -122.39537811084) | 6 | 2 | 9 | 28856 | 6 | ||||
| 130909 | 104361 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 57 Stillman St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013954.4 | 2112927.1 | 37.7824798185974 | -122.39537811084 | (37.7824798185974, -122.39537811084) | 6 | 2 | 9 | 28856 | 6 | ||||
| 173357 | 104362 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 57 Stillman St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013954.4 | 2112927.1 | 37.7824798185974 | -122.39537811084 | (37.7824798185974, -122.39537811084) | 6 | 2 | 9 | 28856 | 6 | ||||
| 47299 | 104364 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 57 Stillman St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013954.4 | 2112927.1 | 37.7824798185974 | -122.39537811084 | (37.7824798185974, -122.39537811084) | 6 | 2 | 9 | 28856 | 6 | ||||
| 180426 | 104366 | Undocumented 4 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 57 Stillman St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013954.4 | 2112927.1 | 37.7824798185974 | -122.39537811084 | (37.7824798185974, -122.39537811084) | 6 | 2 | 9 | 28856 | 6 | ||||
| 108854 | 104446 | Private 9 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2490X Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6008214.39649 | 2104163.75253 | 37.7580968032353 | -122.41461574816 | (37.7580968032353, -122.41461574816) | 2 | 4 | 7 | 28859 | 19 | ||||
| 34779 | 104448 | Private 9 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2490X Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6008214.39649 | 2104163.75253 | 37.7580968032353 | -122.41461574816 | (37.7580968032353, -122.41461574816) | 2 | 4 | 7 | 28859 | 19 | ||||
| 148261 | 104667 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 172 Clipper St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | FUF | 01/19/2016 12:00:00 AM | 6x12 | Permit Number 777366 | 6003998.6 | 2101043.1 | 37.7492904699227 | -122.42897329467 | (37.7492904699227, -122.42897329467) | 2 | 4 | 5 | 28862 | 22 | |
| 84450 | 104867 | Significant Tree 6 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 411 Holladay Ave | 2 | Front Yard : Yard | Tree | Private 2 | Permit Number 770735 | 6010309.7 | 2098610.5 | 37.7429662928376 | -122.406977848202 | (37.7429662928376, -122.406977848202) | 10 | 7 | 7 | 28859 | 2 | ||||
| 52276 | 104869 | Significant Tree 6 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 411 Holladay Ave | 4 | Front Yard : Yard | Tree | Private 2 | Permit Number 770735 | 6010309.7 | 2098610.5 | 37.7429662928376 | -122.406977848202 | (37.7429662928376, -122.406977848202) | 10 | 7 | 7 | 28859 | 2 | ||||
| 191703 | 104979 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 423 Tehama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 2x3 | 6011155.37894 | 2112276.30906 | 37.7805368262604 | -122.405015718617 | (37.7805368262604, -122.405015718617) | 14 | 2 | 9 | 28853 | 34 |
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) );