trees
575 rows where qSpecies_id = 123 sorted by Fire Prevention Districts 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 599 | 78256 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 754 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6002680.72455 | 2088998.08405 | 37.7161429170478 | -122.432670234864 | (37.7161429170478, -122.432670234864) | 9 | 7 | 6 | 28861 | 5 | |||
| 6926 | 96580 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 401x Otsego Ave | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 05/14/2011 12:00:00 AM | 3x3 | 6000208.5 | 2091425.4 | 37.7226672598955 | -122.441389471398 | (37.7226672598955, -122.441389471398) | 9 | 7 | 6 | 28861 | 25 | |||
| 13645 | 70110 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 79 Stoneyford Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6006114.15907 | 2093862.38939 | 37.7296933683514 | -122.421147824905 | (37.7296933683514, -122.421147824905) | 9 | 7 | 7 | 28861 | 5 | |||
| 16550 | 88330 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 544 London St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51318 | 6001416.8 | 2090660.3 | 37.7206352284922 | -122.437157897339 | (37.7206352284922, -122.437157897339) | 9 | 7 | 6 | 28861 | 5 | |||
| 23905 | 96578 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 401x Otsego Ave | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 05/14/2011 12:00:00 AM | 3x3 | 6000208.5 | 2091425.4 | 37.7226672598955 | -122.441389471398 | (37.7226672598955, -122.441389471398) | 9 | 7 | 6 | 28861 | 25 | |||
| 27312 | 88136 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 321 Los Palmos Dr | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/03/2008 12:00:00 AM | 3x3 | Permit Number 51162 | 5997690 | 2096237 | 37.7357349780848 | -122.450442028597 | (37.7357349780848, -122.450442028597) | 9 | 7 | 4 | 59 | 40 | |||
| 31248 | 96579 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 401x Otsego Ave | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 05/14/2011 12:00:00 AM | 3x3 | 6000208.5 | 2091425.4 | 37.7226672598955 | -122.441389471398 | (37.7226672598955, -122.441389471398) | 9 | 7 | 6 | 28861 | 25 | |||
| 32350 | 84048 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1006 Capitol Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2007 12:00:00 AM | 3x3 | Permit Number 49723 | 5995065.73258922 | 2090627.8481306 | 37.7201830572422 | -122.459109050516 | (37.7201830572422, -122.459109050516) | 9 | 8 | 6 | 28861 | 24 | ||
| 39809 | 88509 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 896 Darien Way | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51444 | 5994359.2 | 2093914.2 | 37.7291659423967 | -122.461789444316 | (37.7291659423967, -122.461789444316) | 9 | 8 | 4 | 59 | 40 | ||
| 40738 | 100424 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 200X Stonecrest Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x6 | 5990724.7 | 2093134.9 | 37.7268162840874 | -122.47429724264 | (37.7268162840874, -122.47429724264) | 9 | 8 | 4 | 64 | 40 | ||||
| 47551 | 84204 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 655 Sunnydale Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50698 | 6009691.88445474 | 2086493.84620901 | 37.7096619192865 | -122.408259684415 | (37.7096619192865, -122.408259684415) | 9 | 7 | 8 | 309 | 39 | ||
| 47581 | 88507 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 896 Darien Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51444 | 5994359.2 | 2093914.2 | 37.7291659423967 | -122.461789444316 | (37.7291659423967, -122.461789444316) | 9 | 8 | 4 | 59 | 40 | ||
| 51900 | 40680 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 227 Maynard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/10/1999 12:00:00 AM | 11 | Permit Number 41663 | 6004891.01488 | 2093810.36977 | 37.7294815042584 | -122.425372669006 | (37.7294815042584, -122.425372669006) | 9 | 7 | 6 | 28861 | 5 | |
| 60226 | 100425 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 200X Stonecrest Dr | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x6 | 5990724.7 | 2093134.9 | 37.7268162840874 | -122.47429724264 | (37.7268162840874, -122.47429724264) | 9 | 8 | 4 | 64 | 40 | ||||
| 60418 | 88523 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 10 Valdez Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51454 | 5996417 | 2093827.6 | 37.7290464055545 | -122.454669245202 | (37.7290464055545, -122.454669245202) | 9 | 7 | 4 | 28861 | 40 | |||
| 61889 | 84203 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 655 Sunnydale Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50698 | 6009691.88445474 | 2086493.84620901 | 37.7096619192865 | -122.408259684415 | (37.7096619192865, -122.408259684415) | 9 | 7 | 8 | 309 | 39 | ||
| 66880 | 88511 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 896 Darien Way | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51444 | 5994359.2 | 2093914.2 | 37.7291659423967 | -122.461789444316 | (37.7291659423967, -122.461789444316) | 9 | 8 | 4 | 59 | 40 | ||
| 69913 | 81225 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 225 Jules Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2007 12:00:00 AM | 3x3 | Permit Number 49728 | 5994438.42452426 | 2091412.78636228 | 37.7223022264954 | -122.461334300987 | (37.7223022264954, -122.461334300987) | 9 | 8 | 4 | 28861 | 24 | ||
| 71898 | 88508 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 896 Darien Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51444 | 5994359.2 | 2093914.2 | 37.7291659423967 | -122.461789444316 | (37.7291659423967, -122.461789444316) | 9 | 8 | 4 | 59 | 40 | ||
| 80433 | 84200 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 655 Sunnydale Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50698 | 6009691.88445474 | 2086493.84620901 | 37.7096619192865 | -122.408259684415 | (37.7096619192865, -122.408259684415) | 9 | 7 | 8 | 309 | 39 | ||
| 84189 | 83512 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 271 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2007 12:00:00 AM | 3x3 | Permit Number 49725 | 5994714.51593994 | 2090381.39140811 | 37.719486148882 | -122.460305233079 | (37.719486148882, -122.460305233079) | 9 | 8 | 6 | 28861 | 24 | ||
| 86529 | 179278 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 223 Pioche St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006228.66725 | 2093396.90262 | 37.7284216981869 | -122.420718924746 | (37.7284216981869, -122.420718924746) | 9 | 7 | 7 | 309 | 5 | |||
| 88850 | 88346 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 351 Vienna St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51331 | 6003903 | 2091384 | 37.7227633616233 | -122.428615443614 | (37.7227633616233, -122.428615443614) | 9 | 7 | 6 | 28861 | 5 | |||
| 91782 | 88337 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 686 Naples St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51324 | 6002465 | 2089669 | 37.7179728672328 | -122.433463798527 | (37.7179728672328, -122.433463798527) | 9 | 7 | 6 | 28861 | 5 | |||
| 96159 | 88510 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 896 Darien Way | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51444 | 5994359.2 | 2093914.2 | 37.7291659423967 | -122.461789444316 | (37.7291659423967, -122.461789444316) | 9 | 8 | 4 | 59 | 40 | ||
| 101659 | 87845 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 6 Minerva St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/10/2008 12:00:00 AM | 3x3 | Permit Number 50752 | 5996525.4 | 2089078.3 | 37.7160121664781 | -122.453951648081 | (37.7160121664781, -122.453951648081) | 9 | 8 | 6 | 28861 | 24 | |||
| 103146 | 49557 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 62 Arco Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/05/2003 12:00:00 AM | 7 | Permit Number 46446 | 5999409.77309 | 2093045.09949 | 37.7270690458815 | -122.444266822659 | (37.7270690458815, -122.444266822659) | 9 | 7 | 6 | 28861 | 25 | ||
| 115556 | 50665 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1 Santa Ynez Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/07/2004 12:00:00 AM | 5 | Permit Number 47244 | 6000927.33064 | 2091848.93503 | 37.7238711151562 | -122.438934974279 | (37.7238711151562, -122.438934974279) | 9 | 7 | 6 | 28861 | 25 | ||
| 118233 | 179275 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 716 Peru Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6005245.16074 | 2092477.21394 | 37.7258409541933 | -122.424053582122 | (37.7258409541933, -122.424053582122) | 9 | 7 | 6 | 309 | 5 | |||
| 121788 | 213854 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 494 Mangels Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 5998170.4747 | 2095280.37565 | 37.7331358031646 | -122.448711968308 | (37.7331358031646, -122.448711968308) | 9 | 7 | 4 | 59 | 40 | ||||
| 125579 | 62067 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 240 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 50979 | 6009906.39574025 | 2087592.17070432 | 37.7126897048858 | -122.40759567922 | (37.7126897048858, -122.40759567922) | 9 | 7 | 8 | 309 | 39 | ||
| 132731 | 26278 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1828 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/08/1998 12:00:00 AM | 3 | 6000476.90225 | 2093497.19967 | 37.7283712336437 | -122.440610195428 | (37.7283712336437, -122.440610195428) | 9 | 7 | 6 | 28861 | 25 | |||
| 140091 | 88138 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 181 Marietta Dr | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2008 12:00:00 AM | 3x3 | Permit Number 51166 | 5998804 | 2097893 | 37.7403456543781 | -122.446709627058 | (37.7403456543781, -122.446709627058) | 9 | 7 | 4 | 59 | 40 | |||
| 145828 | 84205 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 655 Sunnydale Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50698 | 6009691.88445474 | 2086493.84620901 | 37.7096619192865 | -122.408259684415 | (37.7096619192865, -122.408259684415) | 9 | 7 | 8 | 309 | 39 | ||
| 151959 | 81505 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 30 Lee Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2007 12:00:00 AM | 3x3 | Permit Number 49730 | 5996533.25550088 | 2090072.07142613 | 37.7187412808671 | -122.453996225339 | (37.7187412808671, -122.453996225339) | 9 | 8 | 6 | 28861 | 24 | ||
| 152881 | 84199 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 655 Sunnydale Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50698 | 6009691.88445474 | 2086493.84620901 | 37.7096619192865 | -122.408259684415 | (37.7096619192865, -122.408259684415) | 9 | 7 | 8 | 309 | 39 | ||
| 161073 | 84202 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 655 Sunnydale Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50698 | 6009691.88445474 | 2086493.84620901 | 37.7096619192865 | -122.408259684415 | (37.7096619192865, -122.408259684415) | 9 | 7 | 8 | 309 | 39 | ||
| 164480 | 84201 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 655 Sunnydale Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50698 | 6009691.88445474 | 2086493.84620901 | 37.7096619192865 | -122.408259684415 | (37.7096619192865, -122.408259684415) | 9 | 7 | 8 | 309 | 39 | ||
| 166189 | 96581 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 401x Otsego Ave | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 05/14/2011 12:00:00 AM | 3x3 | 6000208.5 | 2091425.4 | 37.7226672598955 | -122.441389471398 | (37.7226672598955, -122.441389471398) | 9 | 7 | 6 | 28861 | 25 | |||
| 170652 | 179279 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 223 Pioche St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6006275.12702 | 2093408.77207 | 37.7284569075468 | -122.420559152977 | (37.7284569075468, -122.420559152977) | 9 | 7 | 7 | 309 | 5 | |||
| 171562 | 88315 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 157 Edinburg St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51306 | 6004192.4 | 2092727.9 | 37.7264697879052 | -122.427710754996 | (37.7264697879052, -122.427710754996) | 9 | 7 | 6 | 28861 | 5 | |||
| 172028 | 96582 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 401x Otsego Ave | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 05/14/2011 12:00:00 AM | 3x3 | 6000208.5 | 2091425.4 | 37.7226672598955 | -122.441389471398 | (37.7226672598955, -122.441389471398) | 9 | 7 | 6 | 28861 | 25 | |||
| 172506 | 88317 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 670 Edinburg St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51308 | 6002238.5 | 2089937.8 | 37.7186980790536 | -122.434265915388 | (37.7186980790536, -122.434265915388) | 9 | 7 | 6 | 28861 | 5 | |||
| 172942 | 84198 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 655 Sunnydale Ave | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50698 | 6009691.88445474 | 2086493.84620901 | 37.7096619192865 | -122.408259684415 | (37.7096619192865, -122.408259684415) | 9 | 7 | 8 | 309 | 39 | ||
| 178993 | 179276 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 716 Peru Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6005258.78381 | 2092467.95462 | 37.7258162992748 | -122.424005829932 | (37.7258162992748, -122.424005829932) | 9 | 7 | 6 | 309 | 5 | |||
| 180009 | 88506 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 896 Darien Way | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51444 | 5994359.2 | 2093914.2 | 37.7291659423967 | -122.461789444316 | (37.7291659423967, -122.461789444316) | 9 | 8 | 4 | 59 | 40 | |||
| 180230 | 96584 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 401x Otsego Ave | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 05/14/2011 12:00:00 AM | 3x3 | 6000208.5 | 2091425.4 | 37.7226672598955 | -122.441389471398 | (37.7226672598955, -122.441389471398) | 9 | 7 | 6 | 28861 | 25 | |||
| 193441 | 179277 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 716 Peru Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6005276.23831 | 2092458.42558 | 37.7257911200544 | -122.423944813618 | (37.7257911200544, -122.423944813618) | 9 | 7 | 6 | 309 | 5 | |||
| 1297 | 241324 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 490 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/16/2019 12:00:00 AM | 3 | Width 3ft | 6007395.81182 | 2106861.74234 | 37.765458833278 | -122.417637995807 | (37.765458833278, -122.417637995807) | 8 | 4 | 7 | 28853 | 19 | ||
| 5764 | 241323 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 490 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/16/2019 12:00:00 AM | 3 | Width 3ft | 6007394.41265 | 2106888.07859 | 37.7655310677289 | -122.417644702035 | (37.7655310677289, -122.417644702035) | 8 | 4 | 7 | 28853 | 19 | ||
| 7907 | 91707 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 99 South Van Ness Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007261.828778 | 2109331.862933 | 37.7722336617279 | -122.418276562246 | (37.7722336617279, -122.418276562246) | 8 | 2 | 9 | 28853 | 19 | ||
| 9813 | 201661 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 149 Dore St | 1 | : | Tree | Private 2 | 3 | Width 2ft | 6009207.44548 | 2109499.94346 | 37.7728044975557 | -122.411558355748 | (37.7728044975557, -122.411558355748) | 8 | 2 | 9 | 28853 | 34 | |||
| 11610 | 241384 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2169 Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6008146.34247 | 2105906.05304 | 37.7628769363446 | -122.414974425147 | (37.7628769363446, -122.414974425147) | 8 | 4 | 7 | 28859 | 19 | |||
| 15558 | 91677 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 599 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007489.042117 | 2106191.625958 | 37.7636240956729 | -122.417268041752 | (37.7636240956729, -122.417268041752) | 8 | 4 | 7 | 28859 | 19 | |||
| 15597 | 91581 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 200x South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007370.010963 | 2108444.137303 | 37.7698022661703 | -122.417839412441 | (37.7698022661703, -122.417839412441) | 8 | 4 | 9 | 28853 | 19 | ||
| 16583 | 241346 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2601 Mariposa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 6ft | 6009581.66758 | 2105919.15522 | 37.7629934624139 | -122.410011039795 | (37.7629934624139, -122.410011039795) | 8 | 4 | 8 | 28859 | 19 | |||
| 20067 | 91584 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 324 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 9 | 3x3 | 6007359.06414 | 2107782.395856 | 37.7679846640127 | -122.417830363455 | (37.7679846640127, -122.417830363455) | 8 | 4 | 7 | 28853 | 19 | ||
| 22095 | 241295 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1350 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007154.42592 | 2107655.79566 | 37.7676255312226 | -122.418529207767 | (37.7676255312226, -122.418529207767) | 8 | 4 | 7 | 28853 | 19 | |||
| 22150 | 91686 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 377 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007415.631785 | 2107493.688708 | 37.7671951252581 | -122.417614236777 | (37.7671951252581, -122.417614236777) | 8 | 4 | 7 | 28853 | 19 | |||
| 23759 | 95623 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 201 Capp St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/04/2011 12:00:00 AM | 3x3 | Permit Number 767388 | 6007162.9 | 2106147.3 | 37.7634840327412 | -122.418392924595 | (37.7634840327412, -122.418392924595) | 8 | 4 | 7 | 28859 | 19 | |
| 24904 | 91704 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 99 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007261.828778 | 2109331.862933 | 37.7722336617279 | -122.418276562246 | (37.7722336617279, -122.418276562246) | 8 | 2 | 9 | 28853 | 19 | ||
| 29419 | 91588 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 400x South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007384.392817 | 2107339.273033 | 37.7667693781679 | -122.417711341871 | (37.7667693781679, -122.417711341871) | 8 | 4 | 7 | 28853 | 19 | |||
| 37335 | 241348 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2601 Mariposa St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 6ft | 6009609.90256 | 2105923.09061 | 37.7630058505491 | -122.409913662092 | (37.7630058505491, -122.409913662092) | 8 | 4 | 8 | 28859 | 19 | |||
| 42736 | 241305 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 697 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 5 | Width 3ft | 6007530.22491 | 2105637.84626 | 37.7621058621135 | -122.417086361543 | (37.7621058621135, -122.417086361543) | 8 | 4 | 7 | 28859 | 19 | ||
| 43080 | 241352 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2601 Mariposa St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 6ft | 6009685.74216 | 2105928.63246 | 37.7630253172965 | -122.409651748936 | (37.7630253172965, -122.409651748936) | 8 | 4 | 8 | 28859 | 19 | |||
| 45380 | 91682 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 425 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 6 | 3x3 | 6007432.064539 | 2107206.199481 | 37.766406671896 | -122.417537020573 | (37.766406671896, -122.417537020573) | 8 | 4 | 7 | 28853 | 19 | |||
| 46855 | 91705 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 99 South Van Ness Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007261.828778 | 2109331.862933 | 37.7722336617279 | -122.418276562246 | (37.7722336617279, -122.418276562246) | 8 | 2 | 9 | 28853 | 19 | ||
| 49326 | 91582 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 270x South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007359 | 2108191 | 37.7691065911809 | -122.417859552844 | (37.7691065911809, -122.417859552844) | 8 | 4 | 7 | 28853 | 19 | ||
| 50595 | 241318 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 280 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007336.81249 | 2108065.49507 | 37.7687607355409 | -122.417927400355 | (37.7687607355409, -122.417927400355) | 8 | 4 | 7 | 28853 | 19 | |||
| 52753 | 241325 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 425 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007441.87524 | 2107194.22963 | 37.766374357512 | -122.417502238664 | (37.766374357512, -122.417502238664) | 8 | 4 | 7 | 28853 | 19 | |||
| 52926 | 241317 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 270 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007335.93397 | 2108086.9588 | 37.7688196204438 | -122.417931960818 | (37.7688196204438, -122.417931960818) | 8 | 4 | 7 | 28853 | 19 | |||
| 53988 | 91694 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 245 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007404.295323 | 2108246.270012 | 37.7692608986091 | -122.417706796624 | (37.7692608986091, -122.417706796624) | 8 | 4 | 7 | 28853 | 19 | ||
| 56814 | 241333 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 259 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007398.77752 | 2108173.34419 | 37.7690603509832 | -122.417720712761 | (37.7690603509832, -122.417720712761) | 8 | 4 | 7 | 28853 | 19 | |||
| 59371 | 91679 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 565 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 8 | 3x3 | 6007478.430249 | 2106383.249501 | 37.7641496522652 | -122.417318325278 | (37.7641496522652, -122.417318325278) | 8 | 4 | 7 | 28859 | 19 | ||
| 59684 | 91684 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 387 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 03/01/2007 12:00:00 AM | 5 | 3x3 | 6007418.830408 | 2107437.729103 | 37.7670416532981 | -122.41759920657 | (37.7670416532981, -122.41759920657) | 8 | 4 | 7 | 28853 | 19 | ||
| 60684 | 241329 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 349 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007417.32507 | 2107664.81767 | 37.7676651004942 | -122.417620510295 | (37.7676651004942, -122.417620510295) | 8 | 4 | 7 | 28853 | 19 | |||
| 62289 | 91591 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 490 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 8 | 3x3 | 6007414.001232 | 2106821.277656 | 37.7653487502341 | -122.41757221445 | (37.7653487502341, -122.41757221445) | 8 | 4 | 7 | 28853 | 19 | ||
| 67006 | 91687 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 373 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 5 | 3x3 | 6007414.352338 | 2107516.072508 | 37.7672565139252 | -122.417620248867 | (37.7672565139252, -122.417620248867) | 8 | 4 | 7 | 28853 | 19 | |||
| 74482 | 91579 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 170 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/19/2013 01:09:00 PM | 3 | 3x3 | 6007322.882921 | 2108766.782992 | 37.7706855226421 | -122.418025303656 | (37.7706855226421, -122.418025303656) | 8 | 2 | 9 | 28853 | 19 | |||
| 80479 | 91680 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 565 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 9 | 3x3 | 6007478.430249 | 2106383.249501 | 37.7641496522652 | -122.417318325278 | (37.7641496522652, -122.417318325278) | 8 | 4 | 7 | 28859 | 19 | ||
| 80892 | 120913 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 499X South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 5 | 3x3 | 6007431 | 2106864 | 37.7654670122947 | -122.41751644763 | (37.7654670122947, -122.41751644763) | 8 | 4 | 7 | 28853 | 19 | |||
| 83333 | 196981 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2460 Alameda St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009761.09751 | 2107855.1809 | 37.7683194004524 | -122.409527097504 | (37.7683194004524, -122.409527097504) | 8 | 4 | 8 | 28853 | 19 | |||
| 84099 | 91688 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 349 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 9 | 3x3 | 6007406.675646 | 2107650.375519 | 37.7676248464865 | -122.417656321662 | (37.7676248464865, -122.417656321662) | 8 | 4 | 7 | 28853 | 19 | |||
| 86391 | 241321 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 356 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007355.98691 | 2107612.7207 | 37.7675186027402 | -122.417828978541 | (37.7675186027402, -122.417828978541) | 8 | 4 | 7 | 28853 | 19 | |||
| 87205 | 91675 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 637 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 9 | 3x3 | 6007502.174043 | 2105954.495988 | 37.7629737307137 | -122.41720581807 | (37.7629737307137, -122.41720581807) | 8 | 4 | 7 | 28859 | 19 | |||
| 87745 | 241345 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2601 Mariposa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 6ft | 6009569.08803 | 2105916.84613 | 37.7629864171226 | -122.410054385304 | (37.7629864171226, -122.410054385304) | 8 | 4 | 8 | 28859 | 19 | |||
| 88350 | 91701 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 101x South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007269.02291 | 2109328.047293 | 37.7722235898389 | -122.41825140648 | (37.7722235898389, -122.41825140648) | 8 | 2 | 9 | 28853 | 19 | |||
| 89764 | 241327 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 377 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6007424.50403 | 2107516.88319 | 37.7672593111026 | -122.417585193005 | (37.7672593111026, -122.417585193005) | 8 | 4 | 7 | 28853 | 19 | |||
| 90022 | 91674 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 697 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007520.814164 | 2105617.901611 | 37.7620505693283 | -122.417117496488 | (37.7620505693283, -122.417117496488) | 8 | 4 | 7 | 28859 | 19 | |||
| 91402 | 241353 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2601 Mariposa St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 6ft | 6009702.25291 | 2105928.94008 | 37.7630270871447 | -122.409594665358 | (37.7630270871447, -122.409594665358) | 8 | 4 | 8 | 28859 | 19 | |||
| 91934 | 91678 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 565 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 8 | 3x3 | 6007478.430249 | 2106383.249501 | 37.7641496522652 | -122.417318325278 | (37.7641496522652, -122.417318325278) | 8 | 4 | 7 | 28859 | 19 | ||
| 93792 | 241347 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2601 Mariposa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 6ft | 6009595.63011 | 2105921.4482 | 37.7630005409651 | -122.409962909868 | (37.7630005409651, -122.409962909868) | 8 | 4 | 8 | 28859 | 19 | |||
| 95270 | 241307 | Undocumented 4 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 629 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007511.70266 | 2105973.00163 | 37.7630250789657 | -122.417174173153 | (37.7630250789657, -122.417174173153) | 8 | 4 | 7 | 28859 | 19 | |||
| 95941 | 91580 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 200x South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007370.010963 | 2108444.137303 | 37.7698022661703 | -122.417839412441 | (37.7698022661703, -122.417839412441) | 8 | 4 | 9 | 28853 | 19 | ||
| 96550 | 91587 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 362 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 4 | 3x3 | 6007371.2189 | 2107569.74946 | 37.7674014710001 | -122.417773246729 | (37.7674014710001, -122.417773246729) | 8 | 4 | 7 | 28853 | 19 | |||
| 99873 | 35784 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 401 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51612 | 6004919.48722825 | 2106038.70275083 | 37.7630593064236 | -122.426144444701 | (37.7630593064236, -122.426144444701) | 8 | 4 | 5 | 28859 | 19 | ||
| 105405 | 91590 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 490 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 9 | 3x3 | 6007414.001232 | 2106821.277656 | 37.7653487502341 | -122.41757221445 | (37.7653487502341, -122.41757221445) | 8 | 4 | 7 | 28853 | 19 | ||
| 105683 | 241297 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1534 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6007142.6566 | 2107359.78421 | 37.7668120908263 | -122.418548923599 | (37.7668120908263, -122.418548923599) | 8 | 4 | 7 | 28853 | 19 | |||
| 106489 | 91706 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 99 South Van Ness Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007261.828778 | 2109331.862933 | 37.7722336617279 | -122.418276562246 | (37.7722336617279, -122.418276562246) | 8 | 2 | 9 | 28853 | 19 | ||
| 111775 | 241385 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2169 Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6008146.20784 | 2105935.07496 | 37.7629566162671 | -122.41497694503 | (37.7629566162671, -122.41497694503) | 8 | 4 | 7 | 28859 | 19 |
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) );