trees
399 rows where qSpecies_id = 2 sorted by SiteOrder
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8599 | 262043 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 245 11th St | : Cutout | Tree | Private 2 | FUF | 04/14/2020 12:00:00 AM | 3 | Permit Number 785251 | 6008265.74007 | 2109435.35593 | 37.7725742877847 | -122.414811260337 | (37.7725742877847, -122.414811260337) | 8 | 2 | 9 | 28853 | 34 | ||
41844 | 108873 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 137 Cole St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/08/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773403 | 5997771.92218 | 2110131.23662 | 37.7738897825389 | -122.451160475717 | (37.7738897825389, -122.451160475717) | 15 | 5 | 11 | 29492 | 16 | |
56473 | 93743 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 875 Howard St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/29/2010 12:00:00 AM | 3x3 | Permit Number 53322 | 6011367.4 | 2112778.7 | 37.7819281242694 | -122.40431760427 | (37.7819281242694, -122.40431760427) | 6 | 2 | 9 | 28853 | 34 | |||
60208 | 108834 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 163 Ney St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774662 | 6004445.49273 | 2094062.11561 | 37.7301475609408 | -122.426930805706 | (37.7301475609408, -122.426930805706) | 9 | 7 | 6 | 28861 | 5 | |
101456 | 88442 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1148 Treat Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2008 12:00:00 AM | 3x3 | Permit Number 51406 | 6008612.9 | 2101850.1 | 37.7517664174328 | -122.413073954345 | (37.7517664174328, -122.413073954345) | 2 | 4 | 7 | 28859 | 19 | |||
108000 | 108709 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 280 Fair Oaks St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773390 | 6005432.93594 | 2102084.07132 | 37.7522298213067 | -122.424087347331 | (37.7522298213067, -122.424087347331) | 2 | 4 | 5 | 28859 | 19 | |
131390 | 108760 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1350 Church St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6004491.73804 | 2101024.57628 | 37.7492675091862 | -122.427266693799 | (37.7492675091862, -122.427266693799) | 2 | 4 | 5 | 28862 | 22 | ||||
174018 | 114091 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1717 15th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/01/2015 12:00:00 AM | Permit Number 775992 | 5991423.2 | 2103752.9 | 37.7560110367904 | -122.472656396727 | (37.7560110367904, -122.472656396727) | 1 | 8 | 4 | 56 | 12 | ||||
177200 | 94896 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1375 Keith St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/23/2010 12:00:00 AM | 3x3 | Permit Number 53955 | 6016208.4 | 2094705 | 37.7325708970962 | -122.386309345138 | (37.7325708970962, -122.386309345138) | 10 | 3 | 8 | 58 | 1 | ||
177568 | 108791 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 323 Edinburgh St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774649 | 6003546.88289 | 2091819.58764 | 37.7239392283561 | -122.429877518865 | (37.7239392283561, -122.429877518865) | 9 | 7 | 6 | 28861 | 5 | |
186849 | 88363 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 2294 31st Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2009 12:00:00 AM | 3x3 | Permit Number 52532 | 5986746.4 | 2099664.8 | 37.7445143908471 | -122.48852965845 | (37.7445143908471, -122.48852965845) | 1 | 8 | 3 | 29491 | 35 | |||
6 | 262166 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 420 Alpha St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 11/16/2020 12:00:00 AM | 3 | ||||||||||||
21 | 264839 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1601 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2020 12:00:00 AM | 3 | 6007819 | 2087884 | 37.7133739406818 | -122.41483104388 | (37.7133739406818, -122.41483104388) | 9 | 7 | 8 | 309 | 39 | |||
1519 | 154406 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1270 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/10/2019 12:00:00 AM | 3 | 4x4 | Permit Number 782729 | 6004450.91353 | 2101490.17776 | 37.7505436337949 | -122.427441030576 | (37.7505436337949, -122.427441030576) | 2 | 4 | 5 | 28862 | 22 | |
1822 | 51694 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1205 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/2005 12:00:00 AM | Permit Number 47971 | 5995825.9822194 | 2092036.11859211 | 37.7240935095077 | -122.456582925823 | (37.7240935095077, -122.456582925823) | 9 | 8 | 4 | 28861 | 40 | |||
3024 | 103847 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1529 Polk St | 1 | Sidewalk: Curb side : Pot | Tree | DPW 1 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006640.1 | 2116184.7 | 37.7910148670423 | -122.420913805894 | (37.7910148670423, -122.420913805894) | 13 | 9 | 10 | 28858 | 21 | ||
3150 | 85599 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1115 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2014 12:00:00 AM | 3 | 3x3 | 6017434.0078 | 2093308.576 | 37.7288043549368 | -122.381974980078 | (37.7288043549368, -122.381974980078) | 10 | 3 | 8 | 58 | 1 | ||
3529 | 79630 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1331 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6011736.35903 | 2102141.72528 | 37.7527420040406 | -122.402293051689 | (37.7527420040406, -122.402293051689) | 10 | 3 | 8 | 28856 | 29 | |||
4497 | 264869 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1655 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/2020 12:00:00 AM | 3 | 4x6 | 5986201 | 2103975 | 37.7563171904504 | -122.490732590523 | (37.7563171904504, -122.490732590523) | 1 | 8 | 3 | 56 | 35 | ||
4809 | 181872 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 2330 34th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/24/2020 12:00:00 AM | 3 | 4x6 | 5985803.3054 | 2099347.2154 | 37.7435873132981 | -122.491767267489 | (37.7435873132981, -122.491767267489) | 1 | 8 | 3 | 29491 | 35 | ||
5494 | 261029 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 863 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/2019 12:00:00 AM | 3 | 4x6 | 5986308 | 2110038 | 37.7729707519219 | -122.490808659035 | (37.7729707519219, -122.490808659035) | 11 | 6 | 2 | 55 | 26 | ||
7622 | 253826 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 701 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 02/22/2018 12:20:00 PM | 3 | 3x3 | |||||||||||
8189 | 151145 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 2900 Mariposa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/09/2020 12:00:00 AM | 3 | Width 4ft | 6008902.66747 | 2105921.7543 | 37.762962519431 | -122.412359660679 | (37.762962519431, -122.412359660679) | 8 | 4 | 7 | 28859 | 19 | ||
8200 | 3929 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 100X Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/18/2014 12:00:00 AM | 3 | 4x4 | 6002188.32938 | 2107609.30269 | 37.7672170447484 | -122.435702952048 | (37.7672170447484, -122.435702952048) | 15 | 5 | 5 | 28862 | 3 | ||
8777 | 18349 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 480 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2006 12:00:00 AM | 3 | 3X3 | 6010308 | 2106081 | 37.7634785336334 | -122.407510304274 | (37.7634785336334, -122.407510304274) | 8 | 4 | 8 | 28859 | 19 | ||
9316 | 262159 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 98 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/07/2019 12:00:00 AM | 3 | ||||||||||||
9751 | 261814 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1622 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2020 12:00:00 AM | 3 | 5x4 | 5985349 | 2104146 | 37.7567369022815 | -122.493691659097 | (37.7567369022815, -122.493691659097) | 1 | 8 | 3 | 56 | 35 | ||
10603 | 18421 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 934 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/10/2013 12:00:00 AM | 3 | 3x3 | 6010449.27067 | 2103789.58404 | 37.7571947273755 | -122.40686018586 | (37.7571947273755, -122.40686018586) | 10 | 4 | 7 | 28859 | 19 | ||
10779 | 49299 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 640 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/16/2020 12:00:00 AM | 3 | Permit Number 46308 | 5981979.10455 | 2111331.16831 | 37.7762675789736 | -122.505878467652 | (37.7762675789736, -122.505878467652) | 11 | 6 | 2 | 55 | 26 | ||
11859 | 262397 | Undocumented 4 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 498 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2020 12:00:00 AM | 3 | 3x3 | 6008907 | 2105964 | 37.7630787595522 | -122.412347662048 | (37.7630787595522, -122.412347662048) | 8 | 4 | 7 | 28859 | 19 | ||
12272 | 117721 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 471 40th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 01/25/2020 11:12:00 AM | 3 | Width 3ft | 5983437.41308 | 2112653.95912 | 37.779985305245 | -122.500931708584 | (37.779985305245, -122.500931708584) | 11 | 6 | 2 | 55 | 26 | ||
12577 | 17385 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1649 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/28/1996 12:00:00 AM | 12 | 6x5 | 6014583.05525 | 2095408.96107 | 37.7344137306531 | -122.391977809509 | (37.7344137306531, -122.391977809509) | 10 | 3 | 8 | 58 | 1 | ||
13050 | 108392 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1382 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/19/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773801 | 6011141.7607 | 2101910.8917 | 37.7520749768049 | -122.404333044887 | (37.7520749768049, -122.404333044887) | 10 | 4 | 8 | 28859 | 19 |
13828 | 144979 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 626 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/2019 12:00:00 AM | 3 | Width 3ft | 5990674.57486 | 2111094.54046 | 37.7761258404607 | -122.47578147193 | (37.7761258404607, -122.47578147193) | 11 | 6 | 2 | 54 | 26 | ||
13904 | 50261 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 31 Highland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/2002 12:00:00 AM | Permit Number 46967 | 6005053.32023027 | 2096760.11488265 | 37.737590014135 | -122.425021354004 | (37.737590014135, -122.425021354004) | 2 | 7 | 5 | 28859 | 2 | ||
15395 | 262455 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1788 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2019 12:00:00 AM | 3 | Width 3ft | 6000684 | 2093777 | 37.7291512919898 | -122.43991430419 | (37.7291512919898, -122.43991430419) | 9 | 7 | 6 | 28861 | 25 | ||
15650 | 261311 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 3368 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/30/2019 12:00:00 AM | 3 | 3x3 | 5998140.71226 | 2116180.16914 | 37.7905196763565 | -122.450320900484 | (37.7905196763565, -122.450320900484) | 13 | 6 | 1 | 54 | 31 | ||
16185 | 182600 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1959 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2020 12:00:00 AM | 3 | 4x4 | 5985980.7032 | 2101896.5884 | 37.7505975691069 | -122.4913414752 | (37.7505975691069, -122.4913414752) | 1 | 8 | 3 | 29491 | 35 | ||
17740 | 96032 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1314 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 3x3 | Permit Number 767671 | 6007241 | 2115796 | 37.7899814452739 | -122.418807131377 | (37.7899814452739, -122.418807131377) | 13 | 9 | 10 | 28858 | 21 | |
18500 | 144214 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 786 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/15/2020 12:25:00 PM | 0 | Width 4ft | 5982943.75928 | 2110448.71022 | 37.7739013377013 | -122.502476188525 | (37.7739013377013, -122.502476188525) | 11 | 6 | 2 | 55 | 26 | ||
19079 | 229898 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 590 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2020 12:00:00 AM | 3 | Width 2ft | Permit Number 787828 | 6001392.90328 | 2100882.89168 | 37.7487027395486 | -122.437972352563 | (37.7487027395486, -122.437972352563) | 2 | 4 | 5 | 28862 | 22 | |
19302 | 18446 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1036 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6010478.12987 | 2103164.08177 | 37.7554788523745 | -122.406716298816 | (37.7554788523745, -122.406716298816) | 10 | 4 | 7 | 28859 | 19 | |||
19434 | 242839 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1151 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/12/2016 05:27:00 AM | 0 | 7x7 | 6005182.83568 | 2101610.74761 | 37.7509160601321 | -122.424918561756 | (37.7509160601321, -122.424918561756) | 2 | 4 | 5 | 28859 | 19 | ||
20524 | 87026 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 863 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/2007 12:00:00 AM | 3x3 | Permit Number 49970 | 6004379 | 2103877 | 37.7570932205384 | -122.427859766577 | (37.7570932205384, -122.427859766577) | 2 | 4 | 5 | 28862 | 3 | ||
22004 | 93263 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1326 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/02/2008 12:00:00 AM | 3 | 3x3 | 6004490 | 2101167 | 37.7496584733742 | -122.427282847994 | (37.7496584733742, -122.427282847994) | 2 | 4 | 5 | 28862 | 22 | ||
22249 | 109286 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1438 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 771727 | 5982826.9 | 2105321.3 | 37.75981607235 | -122.502500845014 | (37.75981607235, -122.502500845014) | 1 | 8 | 3 | 56 | 35 |
22322 | 85732 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 901 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/30/2007 12:00:00 AM | 3 | 3x3 | 6011193.193535 | 2112605.183477 | 37.7814419523203 | -122.404908060988 | (37.7814419523203, -122.404908060988) | 14 | 2 | 9 | 28853 | 34 | ||
22857 | 93269 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1730 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004618 | 2098811 | 37.7431966782063 | -122.426672467078 | (37.7431966782063, -122.426672467078) | 2 | 7 | 5 | 63 | 22 | ||
24373 | 177452 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 404 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6003440.2849 | 2091219.73942 | 37.7222861409715 | -122.430203237092 | (37.7222861409715, -122.430203237092) | 9 | 7 | 6 | 28861 | 5 | |||
25377 | 85589 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1566 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6015069.619532 | 2095135.418187 | 37.7336896386511 | -122.390276478357 | (37.7336896386511, -122.390276478357) | 10 | 3 | 8 | 58 | 1 | ||
28398 | 230376 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 126 Dolores St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6004756.55794 | 2107626.00234 | 37.7674084411732 | -122.426821010098 | (37.7674084411732, -122.426821010098) | 8 | 4 | 5 | 28862 | 3 | |||
29972 | 53133 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 925 Holloway Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | FUF | 08/19/2015 12:00:00 AM | Permit Number 774158 | 5994000.81776041 | 2091173.40830125 | 37.7216197566197 | -122.462829635252 | (37.7216197566197, -122.462829635252) | 9 | 8 | 6 | 64 | 24 | ||
30278 | 10232 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 11 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/30/2002 12:00:00 AM | 8 | 6005984.55063 | 2109644.68395 | 37.7730206127534 | -122.422717019597 | (37.7730206127534, -122.422717019597) | 7 | 9 | 11 | 28852 | 10 | |||
32063 | 230390 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 3431 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6005492.40988 | 2103117.15388 | 37.7550697840629 | -122.423955133335 | (37.7550697840629, -122.423955133335) | 2 | 4 | 5 | 28859 | 19 | |||
35474 | 94638 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 2000X Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/19/2010 12:00:00 AM | 3 | 3x3 | 6012318.2 | 2088514.6 | 37.71535722204 | -122.399324379639 | (37.71535722204, -122.399324379639) | 10 | 7 | 8 | 309 | 39 | ||
36426 | 93271 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1699X Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004711 | 2099043.6 | 37.7438406020251 | -122.426367454995 | (37.7438406020251, -122.426367454995) | 2 | 7 | 5 | 63 | 22 | ||
37463 | 252931 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 71 Edgar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997064 | 2091155 | 37.7217451669512 | -122.452239761545 | (37.7217451669512, -122.452239761545) | 9 | 8 | 6 | 28861 | 24 | ||||
37543 | 230386 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 51 13th St | 1 | : | Tree | Private 2 | 9 | Width 4ft | 6008087.40778 | 2108285.62264 | 37.769407368778 | -122.415346724678 | (37.769407368778, -122.415346724678) | 8 | 4 | 7 | 28853 | 19 | |||
38684 | 85604 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1261 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6016687.610646 | 2093879.449725 | 37.7303306134548 | -122.384595098105 | (37.7303306134548, -122.384595098105) | 10 | 3 | 8 | 58 | 1 | ||
39903 | 18422 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 940 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/09/2016 06:57:00 AM | 3 | 3x3 | 6010451.25485 | 2103753.05423 | 37.7570945357026 | -122.406850749261 | (37.7570945357026, -122.406850749261) | 10 | 4 | 7 | 28859 | 19 | ||
41743 | 18420 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 924 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/14/2013 12:00:00 AM | 3 | 3x3 | 6010442.48956 | 2103839.41038 | 37.7573311599314 | -122.406887149344 | (37.7573311599314, -122.406887149344) | 10 | 4 | 7 | 28859 | 19 | ||
42638 | 230392 | Undocumented 4 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 3416 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6005586.33797 | 2103162.25218 | 37.7551989159029 | -122.423633508794 | (37.7551989159029, -122.423633508794) | 2 | 4 | 5 | 28859 | 19 | |||
42966 | 10342 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 935 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/04/2011 12:00:00 AM | 3 | 4x4 | 6001663.93706 | 2109024.15924 | 37.7710720905099 | -122.437618081823 | (37.7710720905099, -122.437618081823) | 15 | 5 | 11 | 29492 | 9 | ||
43681 | 85727 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1025 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/2007 12:00:00 AM | 3 | 3x3 | 6010365 | 2111820 | 37.7792396944918 | -122.40771784288 | (37.7792396944918, -122.40771784288) | 14 | 2 | 9 | 28853 | 34 | ||
50013 | 93300 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 589X Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/12/2008 12:00:00 AM | 3 | 3x3 | 6004575.9 | 2105667 | 37.7620192734995 | -122.427306317148 | (37.7620192734995, -122.427306317148) | 8 | 4 | 5 | 28862 | 3 | ||
51058 | 96159 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 2 Milton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/2011 12:00:00 AM | 3x3 | Permit Number 767792 | 6003680 | 2095311.9 | 37.7335358734479 | -122.429666314328 | (37.7335358734479, -122.429666314328) | 2 | 7 | 5 | 28861 | 25 | |
52263 | 93252 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1070 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/01/2008 12:00:00 AM | 3 | 3x3 | 6004394 | 2102659 | 37.7537497275294 | -122.427721110855 | (37.7537497275294, -122.427721110855) | 2 | 4 | 5 | 28862 | 22 | ||
52463 | 93286 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1283 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004502 | 2101425 | 37.7503675600759 | -122.427259727267 | (37.7503675600759, -122.427259727267) | 2 | 4 | 5 | 28862 | 22 | ||
57632 | 103843 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1541 Polk St | 1 | Sidewalk: Curb side : Pot | Tree | DPW 1 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006635.7 | 2116216.3 | 37.7911013847793 | -122.420931274285 | (37.7911013847793, -122.420931274285) | 13 | 9 | 10 | 28858 | 21 | ||
58550 | 93288 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1259 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004494 | 2101568 | 37.7507597523824 | -122.427297577126 | (37.7507597523824, -122.427297577126) | 2 | 4 | 5 | 28862 | 22 | ||
59261 | 83828 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 755-757 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2009 12:00:00 AM | Permit Number 52235 | 6009406.96888923 | 2119078.72581504 | 37.7991167247732 | -122.411545064383 | (37.7991167247732, -122.411545064383) | 3 | 1 | 10 | 308 | 4 | |||
59431 | 85827 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1345 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2007 12:00:00 AM | 3 | 3x3 | 6008580 | 2110114 | 37.7744553372704 | -122.413772211324 | (37.7744553372704, -122.413772211324) | 8 | 2 | 9 | 28853 | 34 | ||
60072 | 85828 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 875 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/17/2007 12:00:00 AM | 3 | 3x3 | 6011370.824524 | 2112775.117387 | 37.7819184786136 | -122.404305504694 | (37.7819184786136, -122.404305504694) | 6 | 2 | 9 | 28853 | 34 | ||
60125 | 109530 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 76 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/20/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775000 | 6005863.7 | 2102913.1 | 37.7545304541232 | -122.422656603423 | (37.7545304541232, -122.422656603423) | 2 | 4 | 5 | 28859 | 19 |
61373 | 88349 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 100 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51332 | 6004690.8 | 2092754.8 | 37.7265718296959 | -122.425989720183 | (37.7265718296959, -122.425989720183) | 9 | 7 | 6 | 28861 | 5 | ||
61769 | 93266 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1440 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/02/2008 12:00:00 AM | 3 | 3x3 | 6004482.7 | 2100527.8 | 37.747902965476 | -122.427262565386 | (37.747902965476, -122.427262565386) | 2 | 4 | 5 | 63 | 22 | ||
62082 | 55564 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1X CASELLI AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/2008 12:00:00 AM | 3x3 | Permit Number 50796 | 6000842 | 2104917 | 37.7597480805722 | -122.440166611531 | (37.7597480805722, -122.440166611531) | 2 | 4 | 5 | 28862 | 3 | ||
63660 | 124910 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 3234 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/19/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 780160 | 5998760.11738 | 2116596.00833 | 37.7916968894517 | -122.4482077616 | (37.7916968894517, -122.4482077616) | 11 | 6 | 1 | 54 | 30 | |
63966 | 95388 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 4290 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/24/2011 12:00:00 AM | 3x3 | Permit Number 767255 | 6001987.9 | 2101228 | 37.7496841432906 | -122.43593955208 | (37.7496841432906, -122.43593955208) | 2 | 4 | 5 | 28862 | 22 | |
64762 | 13340 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 230 Mansell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/29/2007 12:00:00 AM | 3 | 3X24 | 6011187.2509688 | 2090638.9738565 | 37.721127222942 | -122.403382822785 | (37.721127222942, -122.403382822785) | 10 | 3 | 7 | 309 | 28 | ||
65044 | 93273 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1679 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004706.9 | 2099119.3 | 37.7440482251279 | -122.426387020617 | (37.7440482251279, -122.426387020617) | 2 | 7 | 5 | 63 | 22 | ||
65551 | 104727 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1079 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 3x3 | Permit Number 770313 | 6004450 | 2102615 | 37.7536320814231 | -122.427524315639 | (37.7536320814231, -122.427524315639) | 2 | 4 | 5 | 28862 | 22 | ||
66728 | 18391 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 874 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/14/2013 12:00:00 AM | 3 | 4x4 | 6010420.6643105 | 2104143.6455038 | 37.7581653002339 | -122.406984073056 | (37.7581653002339, -122.406984073056) | 10 | 4 | 7 | 28859 | 19 | ||
67555 | 93267 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1550 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/02/2008 12:00:00 AM | 3 | 3x3 | 6004563 | 2099865 | 37.7460876105373 | -122.426937693393 | (37.7460876105373, -122.426937693393) | 2 | 7 | 5 | 63 | 22 | ||
68827 | 93281 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1465 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004562 | 2100365 | 37.7474604386711 | -122.426976756198 | (37.7474604386711, -122.426976756198) | 2 | 7 | 5 | 63 | 22 | ||
69419 | 86595 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 2154 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/30/2007 12:00:00 AM | 6 | 3x3 | 6009566 | 2104744 | 37.7597658751742 | -122.409982265203 | (37.7597658751742, -122.409982265203) | 2 | 4 | 7 | 28859 | 19 | ||
69485 | 85584 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1512 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6015354.897796 | 2094923.102787 | 37.7331224832721 | -122.389275358402 | (37.7331224832721, -122.389275358402) | 10 | 3 | 8 | 58 | 1 | ||
70138 | 88771 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 461 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/03/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775199 | 6000624 | 2110522 | 37.7751256013752 | -122.441322740074 | (37.7751256013752, -122.441322740074) | 15 | 5 | 11 | 29492 | 16 | |
72127 | 230394 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 280 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6005433.48505 | 2102088.45121 | 37.7522418784739 | -122.42408575987 | (37.7522418784739, -122.42408575987) | 2 | 4 | 5 | 28859 | 19 | |||
72266 | 93277 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1565 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004670.9 | 2099777.3 | 37.7458529070189 | -122.426558345234 | (37.7458529070189, -122.426558345234) | 2 | 7 | 5 | 63 | 22 | ||
74455 | 94260 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 2850X 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53614 | 6009745.2 | 2104556.4 | 37.7592608098643 | -122.409349258874 | (37.7592608098643, -122.409349258874) | 2 | 4 | 8 | 28859 | 19 | |
74521 | 93293 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1049 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004440 | 2102791 | 37.7541147705659 | -122.42757143594 | (37.7541147705659, -122.42757143594) | 2 | 4 | 5 | 28862 | 22 | ||
76153 | 93291 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1065 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004445 | 2102697 | 37.7538569514077 | -122.427547448283 | (37.7538569514077, -122.427547448283) | 2 | 4 | 5 | 28862 | 22 | ||
77343 | 17426 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1869 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/05/2015 01:06:00 PM | 3 | 3X3 | 6013447.63917 | 2096284.81189 | 37.736755533926 | -122.395964698714 | (37.736755533926, -122.395964698714) | 10 | 3 | 8 | 58 | 1 | ||
77573 | 93260 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1250X Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/02/2008 12:00:00 AM | 3 | 3x3 | 6004401.7 | 2101569.1 | 37.7507575523117 | -122.427616837084 | (37.7507575523117, -122.427616837084) | 2 | 4 | 5 | 28862 | 22 | ||
78957 | 51994 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 3858 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/1977 12:00:00 AM | Permit Number 769135 | 5995734.40748516 | 2115851.40858603 | 37.78947898308 | -122.458622703992 | (37.78947898308, -122.458622703992) | 11 | 6 | 1 | 54 | 31 | |||
79656 | 2 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 850X Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/25/2009 12:00:00 AM | 3 | 3X3 | 5992872.52482 | 2114854.21479 | 37.7865760666822 | -122.468451837381 | (37.7865760666822, -122.468451837381) | 11 | 6 | 1 | 54 | 11 | ||
83634 | 109258 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1290 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773444 | 5982171 | 2106334.4 | 37.7625591927486 | -122.504844313965 | (37.7625591927486, -122.504844313965) | 1 | 8 | 3 | 56 | 35 |
84741 | 230375 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 70 Pearl St | 1 | : | Tree | Private 2 | 9 | Width 4ft | 6005616.00843 | 2108643.76201 | 37.770251521926 | -122.423920665902 | (37.770251521926, -122.423920665902) | 8 | 2 | 5 | 28853 | 19 | |||
86389 | 230391 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 3425 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6005521.318 | 2103117.66656 | 37.7550728237692 | -122.423855197061 | (37.7550728237692, -122.423855197061) | 2 | 4 | 5 | 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) );