trees
979 rows where qSpecies_id = 13 sorted by PlotSize
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 117325 | 30768 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1639 Wallace Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1995 12:00:00 AM | 1 | Permit Number 34648 | 6014552.699 | 2093014.6387 | 37.7278377210513 | -122.391915390574 | (37.7278377210513, -122.391915390574) | 10 | 3 | 8 | 58 | 1 | |
| 118197 | 109493 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1246 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6007532.32765 | 2115464.28758 | 37.789087043374 | -122.417775637962 | (37.789087043374, -122.417775637962) | 13 | 1 | 10 | 28858 | 21 | |||
| 119003 | 84779 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 224 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/2007 12:00:00 AM | 3 | Permit No. 49287 | 6013986.61648 | 2106050.38487 | 37.7635996908854 | -122.394784908699 | (37.7635996908854, -122.394784908699) | 14 | 3 | 8 | 28856 | 29 | ||
| 121381 | 98842 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 313 Maple St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/14/2012 12:00:00 AM | 1 | Permit Number 768890 | 5996633.94495 | 2115242.03804 | 37.7878574732038 | -122.455466360678 | (37.7878574732038, -122.455466360678) | 11 | 6 | 1 | 54 | 31 | ||
| 123198 | 61691 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 61 Lucy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1992 12:00:00 AM | 4 | Permit Number 31258 | 6014147.06906 | 2093799.26826 | 37.7299696274983 | -122.393372558494 | (37.7299696274983, -122.393372558494) | 10 | 3 | 8 | 58 | 1 | |
| 123980 | 95129 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2200@Broderick Beach St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 01/08/2008 12:00:00 AM | 5999690 | 2120891 | 37.8035429078816 | -122.445299328106 | (37.8035429078816, -122.445299328106) | 13 | 9 | 1 | 57 | 17 | ||||
| 125836 | 69450 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 438 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/16/1994 12:00:00 AM | 3 | Permit Number 33560 | 5985645.83858 | 2112922.47586 | 37.780851994355 | -122.493311672832 | (37.780851994355, -122.493311672832) | 11 | 6 | 2 | 55 | 26 | |
| 129691 | 114755 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 89 Karen Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/2015 12:00:00 AM | 1 | Permit Number 777135 | 6010155.72688 | 2091460.80739 | 37.7233261394813 | -122.407006415641 | (37.7233261394813, -122.407006415641) | 10 | 3 | 7 | 309 | 28 | ||
| 131019 | 114688 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 231 Dwight St | 1 | Front Yard : Cutout | Tree | Private 2 | 12/01/2015 12:00:00 AM | Permit Number 774702 | 6010865.8 | 2091429.3 | 37.7232793364177 | -122.404549596707 | (37.7232793364177, -122.404549596707) | 10 | 3 | 7 | 309 | 28 | |||
| 131626 | 84840 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1107 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/20/2007 12:00:00 AM | 7 | Permit No. 49267 | 6009440.82091 | 2117125.31431 | 37.7937550347318 | -122.411289855968 | (37.7937550347318, -122.411289855968) | 3 | 1 | 10 | 28857 | 21 | ||
| 134045 | 47432 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 432 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | 2 | Permit Number 45343 | 5982855.38785 | 2112869.93479 | 37.7805441204791 | -122.50296115463 | (37.7805441204791, -122.50296115463) | 11 | 6 | 2 | 55 | 26 | |
| 136036 | 30800 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 199 Burnside Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/1995 12:00:00 AM | 4 | Permit Number 34666 | 6001059.22701 | 2095245.36746 | 37.7332044430184 | -122.438722291799 | (37.7332044430184, -122.438722291799) | 9 | 7 | 5 | 63 | 40 | |
| 137284 | 46093 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 100 19th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/10/2001 12:00:00 AM | 4 | Permit Number 44465 | 5989926.67635 | 2114640.81602 | 37.785819536272 | -122.478628027687 | (37.785819536272, -122.478628027687) | 11 | 6 | 2 | 55 | 26 | ||
| 137832 | 113270 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1570 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/16/2015 12:00:00 AM | Permit Number 773602 | 6015432.5 | 2094545.1 | 37.7320888656597 | -122.388980682272 | (37.7320888656597, -122.388980682272) | 10 | 3 | 8 | 58 | 1 | |||
| 139506 | 254366 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 79 Ashton Ave | 1 | Front Yard : Yard | Tree | Private 2 | 02/06/2018 12:00:00 AM | 3 | Permit Number 778929 | 5994130.90698 | 2090445.22251 | 37.7196278254181 | -122.462327167234 | (37.7196278254181, -122.462327167234) | 9 | 8 | 6 | 28861 | 24 | ||
| 141670 | 62233 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 120 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/1985 12:00:00 AM | 3 | Permit Number 22359 | 6001435.36273 | 2093541.49048 | 37.7285473793362 | -122.437299929461 | (37.7285473793362, -122.437299929461) | 9 | 7 | 6 | 28861 | 25 | |
| 142902 | 47067 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 604 Webster St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/28/2012 12:00:00 AM | 1 | Permit Number 768780 | 6004041.40702 | 2110873.30571 | 37.7762842830232 | -122.429526231047 | (37.7762842830232, -122.429526231047) | 7 | 9 | 11 | 28852 | 10 | ||
| 142933 | 108091 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2501X 18th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/20/2014 12:00:00 AM | 3 | Permit Number 773081 | 6010179.28671 | 2105483.38874 | 37.7618304231561 | -122.407913339641 | (37.7618304231561, -122.407913339641) | 10 | 4 | 8 | 28859 | 19 | ||
| 144821 | 114986 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1028 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/2015 12:00:00 AM | 1 | Permit Number 770492 | 6001259.4385 | 2086848.65908 | 37.7101603659725 | -122.437429040618 | (37.7101603659725, -122.437429040618) | 9 | 7 | 6 | 28861 | 5 | ||
| 145486 | 70167 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 831 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/12/2015 12:00:00 AM | 3 | Permit Number 773700 | 5981976.78091 | 2110066.45395 | 37.772794906459 | -122.505792724366 | (37.772794906459, -122.505792724366) | 11 | 6 | 2 | 55 | 26 | |
| 147550 | 113269 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1328 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/16/2015 12:00:00 AM | Permit Number 774425 | 6016744.9 | 2093624.7 | 37.7296342890732 | -122.384379303046 | (37.7296342890732, -122.384379303046) | 10 | 3 | 8 | 58 | 1 | |||
| 148719 | 95104 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2200 Beach St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 01/08/2008 12:00:00 AM | 5 | 5999633.73017 | 2120895.6152 | 37.8035523678131 | -122.445494383786 | (37.8035523678131, -122.445494383786) | 13 | 9 | 1 | 57 | 17 | |||
| 149181 | 47068 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 604 Webster St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/28/2012 12:00:00 AM | 1 | Permit Number 768780 | 6004042.80919 | 2110860.8938 | 37.7762502823647 | -122.429520495178 | (37.7762502823647, -122.429520495178) | 7 | 9 | 11 | 28852 | 10 | ||
| 149568 | 95105 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2200 Beach St | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 01/08/2008 12:00:00 AM | 2 | 5999611.30639 | 2120892.81198 | 37.8035433907753 | -122.445571780333 | (37.8035433907753, -122.445571780333) | 13 | 9 | 1 | 57 | 17 | |||
| 151513 | 61491 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 178 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/11/1990 12:00:00 AM | 3 | Permit Number 28869 | 5989634.7512 | 2114171.84464 | 37.7845149192342 | -122.479603669936 | (37.7845149192342, -122.479603669936) | 11 | 6 | 2 | 55 | 26 | |
| 152426 | 450 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 700x 23rd Ave | 10 | Median : Cutout | Tree | DPW 1 | 05/29/2015 01:42:00 PM | 3 | 5988819.93055 | 2110324.80979 | 37.773904673102 | -122.482140704549 | (37.773904673102, -122.482140704549) | 11 | 6 | 2 | 55 | 26 | |||
| 153558 | 34927 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2625 Baker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/31/2012 12:00:00 AM | 3 | Permit Number 768761 | 5999601.94789 | 2117876.97454 | 37.7952621734732 | -122.445387189083 | (37.7952621734732, -122.445387189083) | 13 | 9 | 1 | 57 | 17 | ||
| 153748 | 34942 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 462 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/1997 12:00:00 AM | 8 | Permit Number 38539 | 5995310.64413 | 2112404.55918 | 37.7799904974934 | -122.459839088006 | (37.7799904974934, -122.459839088006) | 11 | 6 | 2 | 54 | 11 | ||
| 154880 | 55172 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3599X 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/19/2013 12:00:00 AM | Permit Number 11079 | 6002961.15352471 | 2106486.99776749 | 37.7641793352608 | -122.432949678981 | (37.7641793352608, -122.432949678981) | 15 | 4 | 5 | 28862 | 3 | |||
| 155635 | 61318 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1419 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/02/2014 12:00:00 AM | 1 | Permit Number 772899 | 6011764.55732 | 2101642.9103 | 37.7513739409742 | -122.402160470048 | (37.7513739409742, -122.402160470048) | 10 | 3 | 8 | 28856 | 29 | |
| 155734 | 105250 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 500 36th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/2014 12:00:00 AM | 1 | Permit Number 771049 | 5984731.6893 | 2112357.91416 | 37.7792483592825 | -122.496432443475 | (37.7792483592825, -122.496432443475) | 11 | 6 | 2 | 55 | 26 | ||
| 157732 | 114754 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 83 Karen Ct | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/2015 12:00:00 AM | Permit Number 777134 | 6010271.6 | 2091687.4 | 37.7239547991887 | -122.406621822462 | (37.7239547991887, -122.406621822462) | 10 | 3 | 7 | 309 | 28 | ||||
| 158442 | 254367 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 79 Ashton Ave | 2 | Front Yard : Yard | Tree | Private 2 | 02/06/2018 12:00:00 AM | 3 | Permit Number 778929 | 5994130.90698 | 2090445.22251 | 37.7196278254181 | -122.462327167234 | (37.7196278254181, -122.462327167234) | 9 | 8 | 6 | 28861 | 24 | ||
| 159186 | 34926 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2625 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/31/2012 12:00:00 AM | 4 | Permit Number 768761 | 5999600.82758 | 2117890.72086 | 37.7952998532682 | -122.445392054402 | (37.7952998532682, -122.445392054402) | 13 | 9 | 1 | 57 | 17 | ||
| 166371 | 31608 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 5 Lucerne St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/06/1995 12:00:00 AM | 4 | Permit Number 35133 | 6012020.8525 | 2109827.45516 | 37.7738611793697 | -122.401849428724 | (37.7738611793697, -122.401849428724) | 14 | 2 | 9 | 28853 | 34 | ||
| 171907 | 59600 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1116 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/26/1981 12:00:00 AM | 9 | Permit Number 19001 | 6015518.08801 | 2103793.04215 | 37.757486543884 | -122.389330342431 | (37.757486543884, -122.389330342431) | 10 | 3 | 8 | 28856 | 29 | ||
| 172305 | 37859 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 127 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/17/2004 12:00:00 AM | 6 | Permit Number 47618 | 6004006.38058 | 2093054.46604 | 37.7273559413142 | -122.428377081834 | (37.7273559413142, -122.428377081834) | 9 | 7 | 6 | 28861 | 5 | |
| 172950 | 87071 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 395 Byxbee St | 2 | Front Yard : Cutout | Tree | Private 2 | 12/18/2007 12:00:00 AM | Permit Number 50011 | 5991947 | 2091188 | 37.7215413135876 | -122.469930130394 | (37.7215413135876, -122.469930130394) | 9 | 8 | 6 | 64 | 24 | |||
| 174661 | 114720 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 465 Woolsey St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/2015 12:00:00 AM | Permit Number 774759 | 6010466.6 | 2091788 | 37.7242419338513 | -122.405954818575 | (37.7242419338513, -122.405954818575) | 10 | 3 | 7 | 309 | 28 | |||
| 184756 | 98077 | Undocumented 4 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 731 Duboce Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6001992.2 | 2108216.2 | 37.7688722929253 | -122.436424775079 | (37.7688722929253, -122.436424775079) | 15 | 5 | 5 | 29492 | 3 | |||||
| 188216 | 87070 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 395 Byxbee St | 1 | Front Yard : Cutout | Tree | Private 2 | 12/18/2007 12:00:00 AM | Permit Number 50011 | 5991947 | 2091188 | 37.7215413135876 | -122.469930130394 | (37.7215413135876, -122.469930130394) | 9 | 8 | 6 | 64 | 24 | |||
| 189937 | 108842 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 420 Woolsey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 772583 | 6010509.54502 | 2091864.19266 | 37.7244535448266 | -122.405811727659 | (37.7244535448266, -122.405811727659) | 10 | 3 | 7 | 309 | 28 | |
| 192239 | 107674 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 133 ELSIE ST | 1 | Front Yard : Yard | Tree | Private 2 | 10/10/2014 12:00:00 AM | 3 | 6007164.4 | 2098513.7 | 37.742523993822 | -122.417846597438 | (37.742523993822, -122.417846597438) | 2 | 7 | 7 | 28859 | 2 | |||
| 24293 | 94928 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 929#4 Broderick St | Sidewalk: Curb side : | Landscaping | Private 2 | 12/08/2010 12:00:00 AM | 3 | 26x6 | Permit Number 54775 | 6000937 | 2111843 | 37.7787705583514 | -122.440334763546 | (37.7787705583514, -122.440334763546) | 15 | 5 | 11 | 29490 | 41 | ||
| 121231 | 27188 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 258 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/2002 12:00:00 AM | 5 | 2X3 | 6002908.14927 | 2093727.2885 | 37.7291411540255 | -122.43222169349 | (37.7291411540255, -122.43222169349) | 9 | 7 | 6 | 28861 | 25 | ||
| 45229 | 13059 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 583 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/28/2015 07:23:00 AM | 3 | 2x2 | 6009557.0524 | 2120495.5376 | 37.8030153566132 | -122.41112585507 | (37.8030153566132, -122.41112585507) | 3 | 1 | 10 | 308 | 23 | ||
| 108505 | 108357 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 250X Pixley St | 2 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 11/02/2018 12:00:00 AM | 3 | 2x4 | Permit Number 773698 | 6002140.21513 | 2118970.44706 | 37.7984091333207 | -122.436682703142 | (37.7984091333207, -122.436682703142) | 13 | 9 | 1 | 57 | 17 | |
| 145251 | 108356 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 250X Pixley St | 1 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 11/02/2018 12:00:00 AM | 3 | 2x4 | Permit Number 773698 | 6002158.91155 | 2118972.60439 | 37.7984161192732 | -122.436618162405 | (37.7984161192732, -122.436618162405) | 13 | 9 | 1 | 57 | 17 | |
| 177003 | 108358 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 250X Pixley St | 3 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 11/02/2018 12:00:00 AM | 3 | 2x4 | Permit Number 773698 | 6002123.02459 | 2118966.98612 | 37.7983986535418 | -122.436741939704 | (37.7983986535418, -122.436741939704) | 13 | 9 | 1 | 57 | 17 | |
| 78363 | 96057 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 110 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2011 12:00:00 AM | 2 | 3.5x6 | Permit Number 767685 | 6006775.4 | 2098937.3 | 37.7436652048745 | -122.419221689065 | (37.7436652048745, -122.419221689065) | 2 | 7 | 7 | 28859 | 2 |
| 5771 | 18021 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2725 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000769.3896 | 2114817.5231 | 37.7869282913907 | -122.441128056615 | (37.7869282913907, -122.441128056615) | 13 | 6 | 1 | 29490 | 27 | |||
| 20416 | 17382 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1627 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/21/2015 12:00:00 AM | 1 | 3X3 | Permit Number 776412 | 6014690.32946 | 2095358.97831 | 37.7342824432881 | -122.39160343105 | (37.7342824432881, -122.39160343105) | 10 | 3 | 8 | 58 | 1 | |
| 56595 | 5717 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1647 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/14/2008 12:00:00 AM | 3 | 3X3 | 6005332.0180626 | 2098744.9227684 | 37.7430555871926 | -122.424198880257 | (37.7430555871926, -122.424198880257) | 2 | 7 | 5 | 28859 | 22 | ||
| 87755 | 4334 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 852 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6001755.94767 | 2095865.71194 | 37.7349473777015 | -122.436357925586 | (37.7349473777015, -122.436357925586) | 2 | 7 | 5 | 63 | 7 | |||
| 107450 | 4378 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2425X Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6006994.61601 | 2120672.53629 | 37.8033573165358 | -122.420005806422 | (37.8033573165358, -122.420005806422) | 5 | 1 | 1 | 28858 | 32 | |||
| 154917 | 26561 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 430 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/10/2007 12:00:00 AM | 3 | 3X3 | 6010306.7503709 | 2097855.6706051 | 37.7408935295991 | -122.406934857164 | (37.7408935295991, -122.406934857164) | 10 | 3 | 7 | 58 | 2 | ||
| 162700 | 136 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1025X 14th St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 9 | 3X3 | 6001971.14414 | 2107605.72409 | 37.7671948800673 | -122.436453906645 | (37.7671948800673, -122.436453906645) | 15 | 5 | 5 | 28862 | 3 | |||
| 172192 | 12725 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1544 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2003 12:00:00 AM | 3 | 3X3 | 5990592.79668 | 2114771.31925 | 37.7862165141869 | -122.476332998319 | (37.7862165141869, -122.476332998319) | 11 | 6 | 1 | 54 | 33 | ||
| 188688 | 13238 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2322 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/15/1998 12:00:00 AM | 3 | 3X3 | 6001219.43305 | 2119376.81704 | 37.7994725475626 | -122.439898035919 | (37.7994725475626, -122.439898035919) | 13 | 9 | 1 | 57 | 17 | ||
| 179581 | 105038 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 46 Atalaya Ter | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/05/2015 12:00:00 AM | 3 | 3X4 | Permit Number 771123 | 5998888.1 | 2110865.6 | 37.7759699989755 | -122.447352315284 | (37.7759699989755, -122.447352315284) | 15 | 6 | 2 | 29492 | 16 | ||
| 67540 | 49737 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 251 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2003 12:00:00 AM | 3 | 3x12 | Permit Number 46536 | 5987104.42255848 | 2114202.9919751 | 37.7844531321546 | -122.488359918659 | (37.7844531321546, -122.488359918659) | 11 | 6 | 1 | 55 | 33 | |
| 101443 | 49736 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 251 28th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2003 12:00:00 AM | 3 | 3x12 | Permit Number 46536 | 5987104.42255848 | 2114202.9919751 | 37.7844531321546 | -122.488359918659 | (37.7844531321546, -122.488359918659) | 11 | 6 | 1 | 55 | 33 | |
| 11428 | 122390 | Undocumented 4 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1958 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x2 | 5991007 | 2102078 | 37.7513881006776 | -122.473973545995 | (37.7513881006776, -122.473973545995) | 1 | 8 | 4 | 29491 | 12 | |||
| 37 | 264963 | Section 806 (d) 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 275 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/2020 12:00:00 AM | 3 | 3x3 | 6005706 | 2110306 | 37.7748207071365 | -122.423727591769 | (37.7748207071365, -122.423727591769) | 7 | 9 | 11 | 28852 | 10 | ||
| 743 | 236478 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 222 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/14/2020 12:00:00 AM | 3 | 3x3 | Permit Number 785288 | 6007898.7538 | 2097586.28669 | 37.7400188220044 | -122.415241775611 | (37.7400188220044, -122.415241775611) | 2 | 7 | 7 | 28859 | 2 | |
| 821 | 261708 | Significant Tree 6 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 20 Entrada Ct | 1 | Front Yard : Yard | Tree | Private 2 | 02/21/2020 12:00:00 AM | 3 | 3x3 | Permit Number 783258 | 5992481.8221 | 2092418.55282 | 37.724951011222 | -122.468170882637 | (37.724951011222, -122.468170882637) | 9 | 8 | 4 | 59 | 40 | |
| 1059 | 262280 | Section 806 (d) 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 10 Niantic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784434 | 5992391 | 2086794 | 37.7095021076955 | -122.468075893068 | (37.7095021076955, -122.468075893068) | 9 | 8 | 4 | 64 | 24 | |
| 1556 | 158441 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 49 Van Buren St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/06/2020 12:00:00 AM | 3 | 3x3 | Permit Number 785489 | 6002069.34164 | 2096386.56921 | 37.7363953338756 | -122.435311658815 | (37.7363953338756, -122.435311658815) | 2 | 7 | 5 | 63 | 7 | |
| 1560 | 258220 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 477 Eucalyptus Dr | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 07/03/2019 12:00:00 AM | 3 | 3x3 | Permit Number 774069 | 5989683 | 2094686 | 37.7310148065902 | -122.478011682019 | (37.7310148065902, -122.478011682019) | 1 | 8 | 4 | 64 | 14 | |
| 1903 | 220552 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 13 Ohlone Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | Permit Number 785489 | 6002169.64489 | 2096371.31931 | 37.7363591568587 | -122.434963778568 | (37.7363591568587, -122.434963778568) | 2 | 7 | 5 | 63 | 7 | ||
| 2285 | 95676 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 232 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/08/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767428 | 6010063.65694 | 2093465.10714 | 37.7288243741431 | -122.407465923318 | (37.7288243741431, -122.407465923318) | 10 | 3 | 7 | 309 | 28 |
| 2825 | 92602 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2201 Baker St | 11 | Sidewalk: Property side : Cutout | Tree | Private 2 | 08/25/2009 12:00:00 AM | 3x3 | Permit Number 52915 | 5999814 | 2116396 | 37.7912079107295 | -122.444546965455 | (37.7912079107295, -122.444546965455) | 13 | 6 | 1 | 29490 | 27 | ||
| 3226 | 107892 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 162 Brewster St | Front Yard : Cutout | Tree | Private 2 | 11/04/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773952 | 6010231.01704 | 2099016.49618 | 37.7440766668365 | -122.407278527778 | (37.7440766668365, -122.407278527778) | 2 | 7 | 7 | 28859 | 2 | ||
| 3880 | 262281 | Section 806 (d) 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 10 Niantic Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784434 | 5992391 | 2086794 | 37.7095021076955 | -122.468075893068 | (37.7095021076955, -122.468075893068) | 9 | 8 | 4 | 64 | 24 | |
| 4377 | 88323 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 125 Lisbon St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51312 | 6003417 | 2092629 | 37.7261543381556 | -122.430384225952 | (37.7261543381556, -122.430384225952) | 9 | 7 | 6 | 28861 | 5 | |||
| 4564 | 264686 | Section 806 (d) 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2455 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/15/2020 12:00:00 AM | 3 | 3x3 | Permit Number 782284 | 5990129.23032 | 2098669.31502 | 37.7419778589065 | -122.476759924113 | (37.7419778589065, -122.476759924113) | 1 | 8 | 3 | 29491 | 35 | |
| 4996 | 255545 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 201X San Carlos St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006716 | 2104916 | 37.7600780028247 | -122.419851234809 | (37.7600780028247, -122.419851234809) | 2 | 4 | 7 | 28859 | 19 | ||||
| 5106 | 147909 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 69 Almaden Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 5995874.31253 | 2112332.21787 | 37.7798242673223 | -122.45788388223 | (37.7798242673223, -122.45788388223) | 11 | 6 | 2 | 54 | 16 | |||
| 5290 | 89193 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 370 03rd St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013271 | 2113050 | 37.7827792408585 | -122.397751016594 | (37.7827792408585, -122.397751016594) | 6 | 2 | 9 | 28856 | 34 | |||||
| 5638 | 89169 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 370 03rd St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013271 | 2113050 | 37.7827792408585 | -122.397751016594 | (37.7827792408585, -122.397751016594) | 6 | 2 | 9 | 28856 | 34 | ||||
| 7146 | 112795 | Section 806 (d) 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1235 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/20/2015 12:00:00 AM | 3x3 | 5983624.1 | 2106731.7 | 37.7637354441658 | -122.499848016409 | (37.7637354441658, -122.499848016409) | 1 | 8 | 3 | 56 | 35 | |||
| 7285 | 261471 | Undocumented 4 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1785 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005616 | 2107209 | 37.7663120077949 | -122.423818660091 | (37.7663120077949, -122.423818660091) | 8 | 4 | 5 | 28853 | 19 | ||||
| 8067 | 106254 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1912X 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | Permit Number 770844 | 6012043 | 2105629 | 37.7623344042956 | -122.401477690357 | (37.7623344042956, -122.401477690357) | 8 | 3 | 8 | 28856 | 29 | ||
| 9598 | 99292 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1300 Minnesota St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2012 12:00:00 AM | 3x3 | Permit Number 768897 | 6015320.4 | 2102511.6 | 37.753957014382 | -122.389924521932 | (37.753957014382, -122.389924521932) | 10 | 3 | 8 | 28856 | 29 | ||
| 9933 | 264897 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 405 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/02/2020 12:00:00 AM | 3 | 3x3 | Permit Number 772749 | 6002446.89331 | 2091087.07144 | 37.7218655485653 | -122.433627676211 | (37.7218655485653, -122.433627676211) | 9 | 7 | 6 | 28861 | 5 | |
| 10118 | 108815 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 474 Munich St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774652 | 6003779.44726 | 2089723.38143 | 37.7181966752665 | -122.428924204145 | (37.7181966752665, -122.428924204145) | 9 | 7 | 6 | 28861 | 5 | |
| 10144 | 97101 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1096@Jones Pine St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008668 | 2115966 | 37.7905284677514 | -122.413881848265 | (37.7905284677514, -122.413881848265) | 5 | 1 | 10 | 28857 | 21 | ||||
| 10565 | 65035 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1205 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/2008 12:00:00 AM | 3x3 | Permit Number 51820 | 6003879.11104946 | 2101261.18670708 | 37.7498825208731 | -122.429402039878 | (37.7498825208731, -122.429402039878) | 2 | 4 | 5 | 28862 | 22 | ||
| 11108 | 86883 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 550 Jersey St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 49808 | 6001589 | 2101474 | 37.750336931821 | -122.43733657342 | (37.750336931821, -122.43733657342) | 2 | 4 | 5 | 28862 | 22 | ||||
| 11319 | 255592 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 199X San Carlos St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/2019 12:00:00 AM | 3 | 3x3 | Permit Number 784421 | 6006714 | 2105007 | 37.7603277549802 | -122.419864609266 | (37.7603277549802, -122.419864609266) | 2 | 4 | 7 | 28859 | 19 | |
| 11800 | 262282 | Section 806 (d) 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 10 Niantic Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784434 | 5992391 | 2086794 | 37.7095021076955 | -122.468075893068 | (37.7095021076955, -122.468075893068) | 9 | 8 | 4 | 64 | 24 | |
| 12106 | 112557 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 35 DOLORES ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/28/2015 12:00:00 AM | 3x3 | 6004913 | 2108042 | 37.7685595148495 | -122.426309519551 | (37.7685595148495, -122.426309519551) | 8 | 4 | 5 | 28853 | 19 | |||
| 12273 | 261709 | Significant Tree 6 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 20 Entrada Ct | 2 | Front Yard : Yard | Tree | Private 2 | 02/21/2020 12:00:00 AM | 3 | 3x3 | Permit Number 783258 | 5992481.8221 | 2092418.55282 | 37.724951011222 | -122.468170882637 | (37.724951011222, -122.468170882637) | 9 | 8 | 4 | 59 | 40 | |
| 12333 | 95563 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 497 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6003239 | 2102086.6 | 37.7521126499553 | -122.431674496468 | (37.7521126499553, -122.431674496468) | 2 | 4 | 5 | 28862 | 22 | |||
| 12397 | 264812 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2270 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2020 12:00:00 AM | 3 | 3x3 | 5989815 | 2099915 | 37.745379953303 | -122.477937465434 | (37.745379953303, -122.477937465434) | 1 | 8 | 3 | 29491 | 35 | ||
| 13984 | 115980 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2x Olmstead St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6011593.71434 | 2091235.60939 | 37.7227881560287 | -122.402019710862 | (37.7227881560287, -122.402019710862) | 10 | 3 | 7 | 309 | 28 | |||
| 14232 | 90568 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1818 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/14/2019 12:00:00 AM | 3 | 3x3 | 5989946.28172 | 2110622.60957 | 37.7747877973492 | -122.478266291409 | (37.7747877973492, -122.478266291409) | 11 | 6 | 2 | 55 | 26 | ||
| 14489 | 255590 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 199X San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/2019 12:00:00 AM | 3 | 3x3 | Permit Number 784421 | 6006714 | 2105007 | 37.7603277549802 | -122.419864609266 | (37.7603277549802, -122.419864609266) | 2 | 4 | 7 | 28859 | 19 | |
| 15592 | 261192 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 600X Benton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007231 | 2095349 | 37.7338381748563 | -122.417392087376 | (37.7338381748563, -122.417392087376) | 2 | 7 | 7 | 28859 | 2 | ||||
| 15864 | 112555 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 35 DOLORES ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/28/2015 12:00:00 AM | 3x3 | 6004913 | 2108042 | 37.7685595148495 | -122.426309519551 | (37.7685595148495, -122.426309519551) | 8 | 4 | 5 | 28853 | 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) );