trees
575 rows where qSpecies_id = 123 sorted by Supervisor Districts
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6080 | 19758 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 100 STAIRWAY15 | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 20ST | |||||||||||||
| 9823 | 19923 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 100 STAIRWAY37 | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 20ST | |||||||||||||
| 15070 | 19922 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 100 STAIRWAY37 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 20ST | |||||||||||||
| 2485 | 59880 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2139 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/20/1981 12:00:00 AM | 10 | Permit Number 19345 | 6002701.87127 | 2118840.74506 | 37.7980849079605 | -122.434729923369 | (37.7980849079605, -122.434729923369) | 13 | 9 | 1 | 57 | 17 | |
| 6340 | 33134 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 3107 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | 10 | Permit Number 37364 | 6001390.00916 | 2119109.09622 | 37.7987471650933 | -122.439288583214 | (37.7987471650933, -122.439288583214) | 13 | 9 | 1 | 57 | 17 | |
| 20202 | 136176 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2134 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6002833.9768 | 2118210.69092 | 37.7963624418193 | -122.434227733841 | (37.7963624418193, -122.434227733841) | 13 | 9 | 1 | 57 | 17 | |||
| 32482 | 65937 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2826 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/1990 12:00:00 AM | 7 | Permit Number 28956 | 5999433.3119 | 2118083.73409 | 37.7958202522453 | -122.445985572784 | (37.7958202522453, -122.445985572784) | 13 | 9 | 1 | 57 | 17 | ||
| 46530 | 136183 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1100 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6006523.02231 | 2120459.93681 | 37.8027469916359 | -122.421622667864 | (37.8027469916359, -122.421622667864) | 5 | 9 | 1 | 28858 | 32 | |||
| 55713 | 136180 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 3134 Baker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5999407.16472 | 2119635.33058 | 37.8000790286731 | -122.446187711617 | (37.8000790286731, -122.446187711617) | 13 | 9 | 1 | 57 | 17 | |||
| 56230 | 136182 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 3140 Baker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5999403.04173 | 2119664.02877 | 37.8001575907471 | -122.446204044176 | (37.8001575907471, -122.446204044176) | 13 | 9 | 1 | 57 | 17 | |||
| 66671 | 38887 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 316 Laurel St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | 6 | Permit Number 40705 | 5998129.65961 | 2115308.75845 | 37.7881263812657 | -122.450296300351 | (37.7881263812657, -122.450296300351) | 13 | 6 | 1 | 54 | 31 | |
| 71899 | 136184 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1100 Chestnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6006503.30451 | 2120455.88239 | 37.8027347473741 | -122.421690613452 | (37.8027347473741, -122.421690613452) | 5 | 9 | 1 | 28858 | 32 | |||
| 74281 | 34259 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 164 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/29/1998 12:00:00 AM | 12 | Permit Number 39598 | 5993996.78061 | 2114472.4725 | 37.7855927810379 | -122.464534489449 | (37.7855927810379, -122.464534489449) | 11 | 6 | 1 | 54 | 11 | |
| 94223 | 136177 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2028 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6003216.31619 | 2118958.46656 | 37.7984373333682 | -122.432958210354 | (37.7984373333682, -122.432958210354) | 13 | 9 | 1 | 57 | 17 | |||
| 106021 | 136178 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2400 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6001367.93231 | 2119047.53981 | 37.798576891075 | -122.439360561339 | (37.798576891075, -122.439360561339) | 13 | 9 | 1 | 57 | 17 | |||
| 106256 | 65755 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 3036 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/20/1990 12:00:00 AM | 14 | Permit Number 28718 | 6004280.73363 | 2119630.96227 | 37.8003441497153 | -122.429322978897 | (37.8003441497153, -122.429322978897) | 13 | 9 | 1 | 57 | 17 | |
| 116025 | 30565 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2245 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1995 12:00:00 AM | 7 | Permit Number 34543 | 6002240.34549 | 2118428.38115 | 37.7969264516424 | -122.436297407498 | (37.7969264516424, -122.436297407498) | 13 | 9 | 1 | 57 | 17 | ||
| 123918 | 34257 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 160 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/29/1998 12:00:00 AM | 9 | Permit Number 39597 | 5993997.84726 | 2114498.92628 | 37.7856654774057 | -122.464532720679 | (37.7856654774057, -122.464532720679) | 11 | 6 | 1 | 54 | 11 | |
| 132385 | 44257 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 122 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/15/2001 12:00:00 AM | 9 | Permit Number 43690 | 5993988.26127 | 2114691.75826 | 37.7861943888941 | -122.464579892109 | (37.7861943888941, -122.464579892109) | 11 | 6 | 1 | 54 | 11 | ||
| 144038 | 38888 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 316 Laurel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | 6 | Permit Number 40705 | 5998132.12011 | 2115294.26521 | 37.7880867274765 | -122.45028674235 | (37.7880867274765, -122.45028674235) | 13 | 6 | 1 | 54 | 31 | |
| 146439 | 136181 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 3140 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5999405.90686 | 2119644.67772 | 37.8001046215781 | -122.446192737013 | (37.8001046215781, -122.446192737013) | 13 | 9 | 1 | 57 | 17 | |||
| 148213 | 136179 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2400 Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6001333.81043 | 2119043.17386 | 37.7985629614603 | -122.439478320365 | (37.7985629614603, -122.439478320365) | 13 | 9 | 1 | 57 | 17 | |||
| 150853 | 34256 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 156 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/29/1998 12:00:00 AM | 4 | Permit Number 39596 | 5993995.61311 | 2114522.39441 | 37.78572978571 | -122.46454215478 | (37.78572978571, -122.46454215478) | 11 | 6 | 1 | 54 | 11 | |
| 155023 | 80092 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1800-1804 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52336 | 6004273.51915 | 2119103.69822 | 37.7988960100912 | -122.429310324527 | (37.7988960100912, -122.429310324527) | 13 | 9 | 1 | 57 | 17 | |
| 169587 | 83336 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1800-1804 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52336 | 6004282.92403 | 2119104.69719 | 37.7988992854406 | -122.429277851819 | (37.7988992854406, -122.429277851819) | 13 | 9 | 1 | 57 | 17 | |
| 180939 | 136175 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 3103 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6001391.85411 | 2119087.81282 | 37.7986888314695 | -122.439280672761 | (37.7986888314695, -122.439280672761) | 13 | 9 | 1 | 57 | 17 | |||
| 4814 | 72022 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 550 Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4x4 | 6010599.26481 | 2116134.30998 | 37.7910988780658 | -122.407211626534 | (37.7910988780658, -122.407211626534) | 5 | 1 | 10 | 28857 | 6 | |||
| 26140 | 136187 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 840 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6010038.55828 | 2116686.60963 | 37.7925839636381 | -122.409190650353 | (37.7925839636381, -122.409190650353) | 3 | 1 | 10 | 28857 | 4 | |||
| 31987 | 39269 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 800 Powell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/16/1998 12:00:00 AM | 5 | Permit Number 40882 | 6010051.67469 | 2116602.92631 | 37.7923549243012 | -122.409139359294 | (37.7923549243012, -122.409139359294) | 3 | 1 | 10 | 28857 | 4 | |
| 39352 | 136186 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 800 Powell St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6010043.14101 | 2116645.97985 | 37.7924726608324 | -122.40917192557 | (37.7924726608324, -122.40917192557) | 3 | 1 | 10 | 28857 | 4 | |||
| 39664 | 94083 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1355 Pacific Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2010 12:00:00 AM | 2 | 3x3 | Permit Number 53468 | 6007661.58372 | 2117803.95708 | 37.7955184712527 | -122.41749431113 | (37.7955184712527, -122.41749431113) | 5 | 1 | 10 | 28858 | 32 | |
| 45296 | 38903 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 800 Powell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/16/1998 12:00:00 AM | 3 | Permit Number 40882 | 6010050.21943 | 2116612.32864 | 37.7923806592989 | -122.409145058308 | (37.7923806592989, -122.409145058308) | 3 | 1 | 10 | 28857 | 4 | |
| 58844 | 29771 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 501X Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6008832.60809 | 2121061.07086 | 37.8045275162019 | -122.413672842682 | (37.8045275162019, -122.413672842682) | 3 | 1 | 10 | 308 | 23 | |||
| 92775 | 136185 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 800 Powell St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6010045.72464 | 2116634.21167 | 37.7924404929984 | -122.409162155311 | (37.7924404929984, -122.409162155311) | 3 | 1 | 10 | 28857 | 4 | |||
| 96568 | 88524 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 840 Powell St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51456 | 6010045 | 2116631 | 37.7924316339339 | -122.409164435867 | (37.7924316339339, -122.409164435867) | 3 | 1 | 10 | 28857 | 4 | |||
| 110684 | 94081 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1355 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53468 | 6007606.52221 | 2117796.21393 | 37.7954941122185 | -122.417684284801 | (37.7954941122185, -122.417684284801) | 5 | 1 | 10 | 28858 | 32 | |
| 147702 | 38904 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 800 Powell St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | 6 | Permit Number 40717 | 6010047.86641 | 2116623.85793 | 37.7924121841197 | -122.409154013767 | (37.7924121841197, -122.409154013767) | 3 | 1 | 10 | 28857 | 4 | |
| 163999 | 94082 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1355 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53468 | 6007647.44648 | 2117801.56463 | 37.7955111067173 | -122.41754305889 | (37.7955111067173, -122.41754305889) | 5 | 1 | 10 | 28858 | 32 | |
| 173251 | 86867 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1386 Pacific Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/2007 12:00:00 AM | 3x3 | Permit Number 49799 | 6007535 | 2117833.1 | 37.7955913672303 | -122.417934380535 | (37.7955913672303, -122.417934380535) | 5 | 1 | 10 | 28858 | 32 | |||
| 182003 | 39270 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 800 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/16/1998 12:00:00 AM | 3 | Permit Number 40882 | 6010056.25648 | 2116573.77784 | 37.7922751463304 | -122.409121448409 | (37.7922751463304, -122.409121448409) | 3 | 1 | 10 | 28857 | 4 | |
| 4479 | 83223 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1446-48 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/09/2016 12:00:00 AM | 3 | 3x3 | Permit Number 50888 | 5993687.91761966 | 2105648.90031529 | 37.7613477954461 | -122.464962006978 | (37.7613477954461, -122.464962006978) | 1 | 8 | 11 | 56 | 12 | |
| 21871 | 246838 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 399 Broderick St | 1 | : | Tree | Private 2 | 5 | Width 4ft | 6001188.47767 | 2109990.61312 | 37.7736986862745 | -122.439331993472 | (37.7736986862745, -122.439331993472) | 15 | 5 | 11 | 29492 | 10 | |||
| 31202 | 246856 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 425 Divisadero St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6001680.71036 | 2109929.19364 | 37.773558043107 | -122.437624887779 | (37.773558043107, -122.437624887779) | 15 | 5 | 11 | 29492 | 10 | |||
| 43779 | 89201 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1627 McAllister St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/2008 12:00:00 AM | 3x3 | Permit Number 51818 | 6001371 | 2111438 | 37.7776832317385 | -122.438804361006 | (37.7776832317385, -122.438804361006) | 15 | 5 | 11 | 29492 | 41 | |||
| 46451 | 87968 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1301 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 51004 | 6001204 | 2110019 | 37.7737775128473 | -122.439280334526 | (37.7737775128473, -122.439280334526) | 15 | 5 | 11 | 29492 | 10 | ||
| 46483 | 83567 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 62 Woodland Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/16/2008 12:00:00 AM | 3x3 | Permit Number 50867 | 5997102.41885097 | 2106267.4466409 | 37.7632424534183 | -122.453197397762 | (37.7632424534183, -122.453197397762) | 15 | 5 | 11 | 29492 | 12 | ||
| 48378 | 213853 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 339 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5996569.29854 | 2106950.59972 | 37.7650876471008 | -122.455090641935 | (37.7650876471008, -122.455090641935) | 15 | 5 | 11 | 29492 | 12 | |||
| 56282 | 87763 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1303 Fell St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6001194 | 2110018 | 37.7737741980345 | -122.439314854348 | (37.7737741980345, -122.439314854348) | 15 | 5 | 11 | 29492 | 10 | |||
| 60565 | 79256 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 627 Frederick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/16/2008 12:00:00 AM | 3x3 | Permit Number 50884 | 5996581.50943321 | 2107294.3742688 | 37.7660322643278 | -122.455073251071 | (37.7660322643278, -122.455073251071) | 15 | 5 | 11 | 29492 | 12 | ||
| 67085 | 241273 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 55 Haight St | 2 | : | Tree | Private 2 | 3 | Width 3ft | 6005874.88911 | 2109629.37494 | 37.7729723901943 | -122.423095264536 | (37.7729723901943, -122.423095264536) | 7 | 9 | 11 | 28852 | 10 | |||
| 68784 | 91130 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 218 Pierce St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2009 12:00:00 AM | 3x3 | Permit Number 52020 | 6002821.3 | 2109296.6 | 37.7718858820629 | -122.433634203014 | (37.7718858820629, -122.433634203014) | 15 | 5 | 11 | 29492 | 9 | ||
| 108145 | 46139 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 206 Downey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51613 | 5998984.25754118 | 2106980.434825 | 37.7653078166494 | -122.446740070916 | (37.7653078166494, -122.446740070916) | 15 | 5 | 11 | 29492 | 9 | ||
| 110190 | 88738 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 218 Pierce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2008 12:00:00 AM | 3x3 | Permit Number 51672 | 6002821.3 | 2109296.6 | 37.7718858820629 | -122.433634203014 | (37.7718858820629, -122.433634203014) | 15 | 5 | 11 | 29492 | 9 | ||
| 143335 | 87451 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 345 Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/14/2007 12:00:00 AM | 3 | 3x3 | 6005911.17036 | 2110956.31285 | 37.7766178884522 | -122.423064096477 | (37.7766178884522, -122.423064096477) | 7 | 9 | 11 | 28852 | 10 | ||
| 152731 | 213852 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1386 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5991160.08427 | 2105986.1579 | 37.7621277372307 | -122.473729238831 | (37.7621277372307, -122.473729238831) | 1 | 8 | 11 | 56 | 12 | |||
| 153745 | 83991 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 62 Woodland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/16/2008 12:00:00 AM | 3x3 | Permit Number 50867 | 5997102.41885097 | 2106267.4466409 | 37.7632424534183 | -122.453197397762 | (37.7632424534183, -122.453197397762) | 15 | 5 | 11 | 29492 | 12 | ||
| 162540 | 87971 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1301 Fell St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 51004 | 6001204 | 2110019 | 37.7737775128473 | -122.439280334526 | (37.7737775128473, -122.439280334526) | 15 | 5 | 11 | 29492 | 10 | ||
| 163157 | 85249 | - 12 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1335 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 07/19/2007 12:00:00 AM | 3 | 3x3 | under 3 yr maintenance agreement. expires 7/19/2010 | 6001350.12437 | 2111060.02557 | 37.7766442216524 | -122.438849483935 | (37.7766442216524, -122.438849483935) | 15 | 5 | 11 | 29492 | 10 |
| 173753 | 87969 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1301 Fell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 51004 | 6001204 | 2110019 | 37.7737775128473 | -122.439280334526 | (37.7737775128473, -122.439280334526) | 15 | 5 | 11 | 29492 | 10 | ||
| 180744 | 87970 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1301 Fell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 51004 | 6001204 | 2110019 | 37.7737775128473 | -122.439280334526 | (37.7737775128473, -122.439280334526) | 15 | 5 | 11 | 29492 | 10 | ||
| 182299 | 87977 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1372 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 51013 | 6001285 | 2110422 | 37.7748886587191 | -122.43902903105 | (37.7748886587191, -122.43902903105) | 15 | 5 | 11 | 29492 | 10 | ||
| 190505 | 85250 | - 12 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1335 Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 07/19/2007 12:00:00 AM | 15 | 3x3 | under 3yr maintenance agreement. Expires 7/19/2010. | 6001350.12437 | 2111060.02557 | 37.7766442216524 | -122.438849483935 | (37.7766442216524, -122.438849483935) | 15 | 5 | 11 | 29492 | 10 |
| 190579 | 241272 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 67 Webster St | 1 | : | Tree | Private 2 | 13 | Width 4ft | 6004275.92505 | 2108860.93687 | 37.7707720854826 | -122.428571490982 | (37.7707720854826, -122.428571490982) | 7 | 9 | 11 | 29492 | 10 | |||
| 3710 | 70389 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1942 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 5989540.17856 | 2110611.69098 | 37.7747342353889 | -122.479670271059 | (37.7747342353889, -122.479670271059) | 11 | 6 | 2 | 55 | 26 | |||
| 5657 | 41933 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 610 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 6 | Permit Number 42292 | 5994729.71498 | 2111330.05881 | 37.7770067806052 | -122.461770835952 | (37.7770067806052, -122.461770835952) | 11 | 6 | 2 | 54 | 11 | |
| 14948 | 90869 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2045 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/19/2008 12:00:00 AM | 3 | 3x3 | 5989208.80531 | 2110541.29026 | 37.7745216791694 | -122.480811390162 | (37.7745216791694, -122.480811390162) | 11 | 6 | 2 | 55 | 26 | ||
| 22012 | 90575 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2008 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5989345.62252 | 2110602.70137 | 37.7746982485552 | -122.480342614213 | (37.7746982485552, -122.480342614213) | 11 | 6 | 2 | 55 | 26 | ||
| 23421 | 90874 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1941 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 5989523.27614 | 2110553.23403 | 37.7745727468597 | -122.479724461021 | (37.7745727468597, -122.479724461021) | 11 | 6 | 2 | 55 | 26 | ||
| 23653 | 90897 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1145 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 5992033.67177 | 2110642.90774 | 37.7749644818454 | -122.471047125233 | (37.7749644818454, -122.471047125233) | 11 | 6 | 2 | 54 | 11 | ||
| 26438 | 90871 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2033 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/19/2008 12:00:00 AM | 3 | 3x3 | 5989249.74132 | 2110541.7912 | 37.7745254339062 | -122.480669822879 | (37.7745254339062, -122.480669822879) | 11 | 6 | 2 | 55 | 26 | ||
| 27091 | 90555 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1150 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/14/2008 12:00:00 AM | 3 | 3x3 | 5992035.9437 | 2110699.81053 | 37.7751208528883 | -122.471043412514 | (37.7751208528883, -122.471043412514) | 11 | 6 | 2 | 54 | 11 | ||
| 27838 | 90576 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2020 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5989294.17784 | 2110601.65647 | 37.7746923899334 | -122.48052049321 | (37.7746923899334, -122.48052049321) | 11 | 6 | 2 | 55 | 26 | ||
| 33458 | 90872 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2027 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/19/2008 12:00:00 AM | 3 | 3x3 | 5989286.8509 | 2110543.19375 | 37.7745314416669 | -122.480541557806 | (37.7745314416669, -122.480541557806) | 11 | 6 | 2 | 55 | 26 | ||
| 34046 | 31982 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 232 03rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/30/1995 12:00:00 AM | 12 | 3x3 | Permit Number 35382 | 5994946.26899 | 2113981.48738 | 37.7842993574965 | -122.461213955921 | (37.7842993574965, -122.461213955921) | 11 | 6 | 2 | 54 | 11 |
| 36193 | 90586 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2200X Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5988739.41652 | 2110581.09487 | 37.7746036774674 | -122.482437994797 | (37.7746036774674, -122.482437994797) | 11 | 6 | 2 | 55 | 26 | ||
| 38813 | 90554 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1150 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/14/2008 12:00:00 AM | 3 | 3x3 | 5992007.5751 | 2110699.64473 | 37.7751187568292 | -122.471141532792 | (37.7751187568292, -122.471141532792) | 11 | 6 | 2 | 54 | 11 | ||
| 39857 | 8913 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 4455X Geary Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 5993194.92162 | 2112721.50101 | 37.7807388335807 | -122.467181309852 | (37.7807388335807, -122.467181309852) | 11 | 6 | 2 | 54 | 11 | |||
| 42514 | 90572 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1932 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5989583.92326 | 2110610.46088 | 37.7747333989447 | -122.479518860914 | (37.7747333989447, -122.479518860914) | 11 | 6 | 2 | 55 | 26 | ||
| 44084 | 41912 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 642 12th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 8 | Permit Number 42274 | 5992258.1025 | 2111064.36491 | 37.7761346671426 | -122.470301476833 | (37.7761346671426, -122.470301476833) | 11 | 6 | 2 | 54 | 11 | |
| 45602 | 65010 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 254 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/17/1989 12:00:00 AM | 7 | Permit Number 26054 | 5989032.72565 | 2113622.95943 | 37.7829728458122 | -122.481646233199 | (37.7829728458122, -122.481646233199) | 11 | 6 | 2 | 55 | 26 | ||
| 48428 | 90571 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1900 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5989655.61233 | 2110613.51621 | 37.7747459519392 | -122.479271100153 | (37.7747459519392, -122.479271100153) | 11 | 6 | 2 | 55 | 26 | ||
| 55070 | 90888 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1643 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2008 12:00:00 AM | 2 | 3x3 | 5990427.38922 | 2110587.78256 | 37.7747200883254 | -122.47659951411 | (37.7747200883254, -122.47659951411) | 11 | 6 | 2 | 55 | 26 | ||
| 61838 | 90896 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1145 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 5992053.33041 | 2110644.47867 | 37.7749699321879 | -122.47097923688 | (37.7749699321879, -122.47097923688) | 11 | 6 | 2 | 54 | 11 | ||
| 62144 | 65529 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1855 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/21/1990 12:00:00 AM | 3 | Permit Number 28417 | 5989796.43775 | 2110560.03757 | 37.7746072923506 | -122.47878004958 | (37.7746072923506, -122.47878004958) | 11 | 6 | 2 | 55 | 26 | ||
| 64123 | 123208 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 400 09th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5993131.19371 | 2112699.04699 | 37.7806735020779 | -122.467400140372 | (37.7806735020779, -122.467400140372) | 11 | 6 | 2 | 54 | 11 | |||
| 67783 | 90864 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2207 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/19/2008 12:00:00 AM | 3 | 3x3 | 5988718.74486 | 2110525.68485 | 37.7744503344144 | -122.482505440318 | (37.7744503344144, -122.482505440318) | 11 | 6 | 2 | 55 | 26 | ||
| 71637 | 88243 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2745 Turk Blvd | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51229 | 5997744.2 | 2111601.2 | 37.7779243335514 | -122.451362410862 | (37.7779243335514, -122.451362410862) | 15 | 6 | 2 | 54 | 16 | |||
| 76553 | 123210 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 400 09th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5993133.98431 | 2112655.94122 | 37.7805553064396 | -122.467387351051 | (37.7805553064396, -122.467387351051) | 11 | 6 | 2 | 54 | 11 | |||
| 77851 | 90569 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1818 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5989920.28238 | 2110623.46415 | 37.7747886345028 | -122.478356290001 | (37.7747886345028, -122.478356290001) | 11 | 6 | 2 | 55 | 26 | ||
| 79595 | 90884 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1751 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 5990130.69935 | 2110573.90659 | 37.7746647760157 | -122.477624799049 | (37.7746647760157, -122.477624799049) | 11 | 6 | 2 | 55 | 26 | ||
| 87429 | 41913 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 642 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 8 | Permit Number 42274 | 5992259.32657 | 2111046.49076 | 37.7760856603427 | -122.470295940533 | (37.7760856603427, -122.470295940533) | 11 | 6 | 2 | 54 | 11 | |
| 88525 | 90879 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1917 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 5989637.04672 | 2110556.02381 | 37.7745870153825 | -122.479331114808 | (37.7745870153825, -122.479331114808) | 11 | 6 | 2 | 55 | 26 | ||
| 89642 | 90894 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1527 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 5990818.86617 | 2110597.98209 | 37.7747707916372 | -122.475246074555 | (37.7747707916372, -122.475246074555) | 11 | 6 | 2 | 54 | 26 | ||
| 100139 | 67314 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 666 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1992 12:00:00 AM | 7 | Permit Number 30795 | 5992883.6827 | 2110925.23066 | 37.77578879069 | -122.468127322089 | (37.77578879069, -122.468127322089) | 11 | 6 | 2 | 54 | 11 | |
| 101968 | 41934 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 615 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 5 | Permit Number 42293 | 5994683.51563 | 2111320.01316 | 37.7769765383201 | -122.461929924013 | (37.7769765383201, -122.461929924013) | 11 | 6 | 2 | 54 | 11 | |
| 103672 | 36967 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 381 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/29/1998 12:00:00 AM | 9 | Permit Number 39594 | 5994314.22367 | 2112999.17695 | 37.7815658043957 | -122.463329288102 | (37.7815658043957, -122.463329288102) | 11 | 6 | 2 | 54 | 11 | |
| 104412 | 119966 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 524 28th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 5987215.94672 | 2112352.18936 | 37.7793778617147 | -122.487838060827 | (37.7793778617147, -122.487838060827) | 11 | 6 | 2 | 55 | 26 | |||
| 106851 | 90892 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1543 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2008 12:00:00 AM | 2 | 3x3 | 5990781.4854 | 2110598.61863 | 37.7747703727015 | -122.475375427468 | (37.7747703727015, -122.475375427468) | 11 | 6 | 2 | 54 | 26 | ||
| 106929 | 67973 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2133 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | 3 | Permit Number 31694 | 5988948.22001 | 2110531.76438 | 37.7744803739464 | -122.481712096768 | (37.7744803739464, -122.481712096768) | 11 | 6 | 2 | 55 | 26 | |
| 109111 | 90583 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2116 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5988996.38069 | 2110588.45382 | 37.7746388278925 | -122.481549654427 | (37.7746388278925, -122.481549654427) | 11 | 6 | 2 | 55 | 26 |
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) );