Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude ▼ | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 139282 | 139282 | 87673 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 2610 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/14/2006 12:00:00 AM | 3 | 3x3 | 6010582.741346 | 2086196.4709060001 | 37.708895230886 | -122.40515978386101 | (37.708895230886, -122.405159783861) | ||
| 94068 | 94068 | 112744 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 235 Bright St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/18/2015 12:00:00 AM | Permit Number 774127 | 5993719.1 | 2088769.4 | 37.7150026970857 | -122.463629063261 | (37.7150026970857, -122.463629063261) | ||
| 114281 | 114281 | 26918 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 2000X Bay Shore Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/19/2010 12:00:00 AM | 3 | 3X3 | 6012375.8565272 | 2088505.2474916999 | 37.7153347551878 | -122.399124435859 | (37.7153347551878, -122.399124435859) | ||
| 127346 | 127346 | 94638 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 2000X Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/19/2010 12:00:00 AM | 3 | 3x3 | 6012318.2 | 2088514.6 | 37.715357222040005 | -122.399324379639 | (37.71535722204, -122.399324379639) | ||
| 98839 | 98839 | 115435 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 563 Lisbon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/01/2016 12:00:00 AM | 3 | Permit Number 777504 | 6001919.8 | 2090201.1 | 37.7194029477524 | -122.43538635551901 | (37.7194029477524, -122.435386355519) | ||
| 91376 | 91376 | 4894 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 745X Mansell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/29/2007 12:00:00 AM | 3 | 3X3 | 6009751.8988059005 | 2090059.5024836997 | 37.7194558413593 | -122.408303589874 | (37.7194558413593, -122.408303589874) | ||
| 146333 | 146333 | 9298 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 135X Mansell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/10/1992 12:00:00 AM | 3 | 3X3 | 6011497.3933157995 | 2090592.5284866001 | 37.7210170109869 | -122.40230748066001 | (37.7210170109869, -122.40230748066) | ||
| 106121 | 106121 | 9308 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 240X Mansell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/29/2007 12:00:00 AM | 3 | 3X100 | 6011154.1519898 | 2090628.8663314 | 37.7210976210121 | -122.403496526224 | (37.7210976210121, -122.403496526224) | ||
| 138373 | 138373 | 9306 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 240X Mansell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/29/2007 12:00:00 AM | 3 | 3X100 | 6011154.1519898 | 2090628.8663314 | 37.7210976210121 | -122.403496526224 | (37.7210976210121, -122.403496526224) | ||
| 90907 | 90907 | 13340 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 230 Mansell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/29/2007 12:00:00 AM | 3 | 3X24 | 6011187.2509688 | 2090638.9738565 | 37.721127222942 | -122.40338282278499 | (37.721127222942, -122.403382822785) | ||
| 144302 | 144302 | 30135 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 220X Mansell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/2007 12:00:00 AM | 3 | 3X30 | 6011221.783783999 | 2090644.291322 | 37.721143752318895 | -122.403263826082 | (37.7211437523189, -122.403263826082) | ||
| 24021 | 24021 | 177451 | Undocumented 2 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 836 Brazil Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6004096.8384300005 | 2090858.43848 | 37.7213312534072 | -122.427907954105 | (37.7213312534072, -122.427907954105) | |||
| 125075 | 125075 | 53133 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 925 Holloway Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 08/19/2015 12:00:00 AM | Permit Number 774158 | 5994000.81776041 | 2091173.40830125 | 37.7216197566197 | -122.46282963525199 | (37.7216197566197, -122.462829635252) | ||
| 2200 | 2200 | 252931 | Undocumented 2 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 71 Edgar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997064.0 | 2091155.0 | 37.7217451669512 | -122.45223976154499 | (37.7217451669512, -122.452239761545) | ||||
| 99829 | 99829 | 95738 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 445 Edinburg St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767484 | 6003120.3 | 2091142.7 | 37.7220564786865 | -122.431303852024 | (37.7220564786865, -122.431303852024) | |
| 172742 | 172742 | 177452 | Undocumented 2 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 404 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6003440.2849 | 2091219.73942 | 37.7222861409715 | -122.430203237092 | (37.7222861409715, -122.430203237092) | |||
| 142073 | 142073 | 108791 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 323 Edinburgh St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774649 | 6003546.88289 | 2091819.58764 | 37.7239392283561 | -122.429877518865 | (37.7239392283561, -122.429877518865) | |
| 18622 | 18622 | 51694 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1205 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2005 12:00:00 AM | Permit Number 47971 | 5995825.9822194 | 2092036.11859211 | 37.7240935095077 | -122.456582925823 | (37.7240935095077, -122.456582925823) | |||
| 78106 | 78106 | 102590 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1205 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 47971 | 5995820.0 | 2092088.8 | 37.724237816628 | -122.4566074133 | (37.724237816628, -122.4566074133) | ||||
| 84744 | 84744 | 88349 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 100 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51332 | 6004690.8 | 2092754.8 | 37.7265718296959 | -122.425989720183 | (37.7265718296959, -122.425989720183) | ||
| 90378 | 90378 | 88350 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 100 Vienna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51332 | 6004690.8 | 2092754.8 | 37.7265718296959 | -122.425989720183 | (37.7265718296959, -122.425989720183) | ||
| 105721 | 105721 | 95660 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 431 Brussels St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/08/2011 12:00:00 AM | 3x3 | Permit Number 767422 | 6010656.7 | 2092697.9 | 37.726750960199794 | -122.40536171554 | (37.7267509601998, -122.40536171554) | |
| 99170 | 99170 | 100432 | Significant Tree 6 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 200X Stonecrest Dr | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990724.7 | 2093134.9 | 37.7268162840874 | -122.47429724264 | (37.7268162840874, -122.47429724264) | |||||
| 114083 | 114083 | 100431 | Significant Tree 6 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 200X Stonecrest Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990724.7 | 2093134.9 | 37.7268162840874 | -122.47429724264 | (37.7268162840874, -122.47429724264) | |||||
| 100161 | 100161 | 85559 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 980 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6018187.977748999 | 2092810.8923689998 | 37.727479421244 | -122.37933387198099 | (37.727479421244, -122.379333871981) | ||
| 120899 | 120899 | 85560 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 980 Palou Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6018187.977748999 | 2092810.8923689998 | 37.727479421244 | -122.37933387198099 | (37.727479421244, -122.379333871981) | ||
| 118293 | 118293 | 85562 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 990 Palou Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6018144.213614 | 2092843.516343 | 37.7275665867834 | -122.379487431767 | (37.7275665867834, -122.379487431767) | ||
| 142002 | 142002 | 85561 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 990 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6018144.213614 | 2092843.516343 | 37.7275665867834 | -122.379487431767 | (37.7275665867834, -122.379487431767) | ||
| 96738 | 96738 | 85598 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1101 Palou Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/08/2014 12:00:00 AM | 3 | 3x3 | 6017523.881587001 | 2093256.0516779998 | 37.728665096277204 | -122.381660625783 | (37.7286650962772, -122.381660625783) | ||
| 120459 | 120459 | 85597 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1101 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2007 12:00:00 AM | 6 | 3x3 | 6017523.881587001 | 2093256.0516779998 | 37.728665096277204 | -122.381660625783 | (37.7286650962772, -122.381660625783) | ||
| 13480 | 13480 | 85599 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1115 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2014 12:00:00 AM | 3 | 3x3 | 6017434.0078 | 2093308.576 | 37.7288043549368 | -122.38197498007798 | (37.7288043549368, -122.381974980078) | ||
| 90759 | 90759 | 108834 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 163 Ney St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774662 | 6004445.49273 | 2094062.1156099997 | 37.73014756094079 | -122.42693080570601 | (37.7301475609408, -122.426930805706) | |
| 84159 | 84159 | 85604 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1261 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6016687.610646 | 2093879.449725 | 37.7303306134548 | -122.384595098105 | (37.7303306134548, -122.384595098105) | ||
| 105434 | 105434 | 85569 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1260 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6016711.517151 | 2093911.5196330003 | 37.7304199931233 | -122.384514682139 | (37.7304199931233, -122.384514682139) | ||
| 143637 | 143637 | 85570 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1260 Palou Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6016711.517151 | 2093911.5196330003 | 37.7304199931233 | -122.384514682139 | (37.7304199931233, -122.384514682139) | ||
| 112715 | 112715 | 85568 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1264 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6016691.22613 | 2093926.645569 | 37.730460403847204 | -122.384585884949 | (37.7304604038472, -122.384585884949) | ||
| 91134 | 91134 | 85567 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1274 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6016640.49857 | 2093964.460415 | 37.730561430483796 | -122.384763892339 | (37.7305614304838, -122.384763892339) | ||
| 144143 | 144143 | 85565 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1276 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6016630.35305 | 2093972.0233900002 | 37.7305816357941 | -122.384799493903 | (37.7305816357941, -122.384799493903) | ||
| 143702 | 143702 | 85577 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1370 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6016127.199744 | 2094347.0989189998 | 37.731583677290004 | -122.38656512948499 | (37.73158367729, -122.386565129485) | ||
| 118353 | 118353 | 85607 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1397 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6015969.720597 | 2094414.6007130002 | 37.7317603044799 | -122.387114277117 | (37.7317603044799, -122.387114277117) | ||
| 93558 | 93558 | 85578 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1388 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6016034.7263629995 | 2094416.0331849998 | 37.7317678372886 | -122.386889636739 | (37.7317678372886, -122.386889636739) | ||
| 120019 | 120019 | 85580 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1458 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6015655.098902999 | 2094699.254039 | 37.7325244779387 | -122.38822185678002 | (37.7325244779387, -122.38822185678) | ||
| 138637 | 138637 | 94896 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1375 Keith St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/23/2010 12:00:00 AM | 3x3 | Permit Number 53955 | 6016208.4 | 2094705.0 | 37.7325708970962 | -122.386309345138 | (37.7325708970962, -122.386309345138) | ||
| 105958 | 105958 | 85583 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1500 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6015418.292964 | 2094875.9215880001 | 37.7329964475839 | -122.389052889382 | (37.7329964475839, -122.389052889382) | ||
| 86667 | 86667 | 85584 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1512 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6015354.897796 | 2094923.102787 | 37.7331224832721 | -122.389275358402 | (37.7331224832721, -122.389275358402) | ||
| 79853 | 79853 | 96159 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 2 Milton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/2011 12:00:00 AM | 3x3 | Permit Number 767792 | 6003680.0 | 2095311.9 | 37.7335358734479 | -122.429666314328 | (37.7335358734479, -122.429666314328) | |
| 105916 | 105916 | 96160 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 2 Milton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/2011 12:00:00 AM | 3x3 | Permit Number 767792 | 6003680.0 | 2095311.9 | 37.7335358734479 | -122.429666314328 | (37.7335358734479, -122.429666314328) | |
| 127595 | 127595 | 85589 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1566 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6015069.619532 | 2095135.4181869999 | 37.7336896386511 | -122.390276478357 | (37.7336896386511, -122.390276478357) | ||
| 138443 | 138443 | 15056 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1441 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/26/2012 12:00:00 AM | 3 | 4x4 | 6015002.0 | 2095363.0 | 37.7343107811298 | -122.390526157796 | (37.7343107811298, -122.390526157796) | ||
| 98990 | 98990 | 96158 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1 Milton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/2011 12:00:00 AM | 3x3 | Permit Number 767791 | 6003728.0 | 2095595.0 | 37.7343159198258 | -122.429520547314 | (37.7343159198258, -122.429520547314) | |
| 15344 | 15344 | 96670 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1425 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/26/2012 12:00:00 AM | 4 | 4x4 | 6015007.7446 | 2095379.2401 | 37.7343556918302 | -122.390507431087 | (37.7343556918302, -122.390507431087) | ||
| 50163 | 50163 | 17385 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1649 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/28/1996 12:00:00 AM | 12 | 6x5 | 6014583.05525 | 2095408.96107 | 37.7344137306531 | -122.39197780950899 | (37.7344137306531, -122.391977809509) | ||
| 91750 | 91750 | 94689 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 218 Roanoke St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53815 | 6003547.0 | 2096007.0 | 37.73543692838779 | -122.43017570506201 | (37.7354369283878, -122.430175705062) | |
| 14910 | 14910 | 17426 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1869 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/05/2015 01:06:00 PM | 3 | 3X3 | 6013447.639169999 | 2096284.8118900002 | 37.736755533926 | -122.39596469871401 | (37.736755533926, -122.395964698714) | ||
| 118815 | 118815 | 11953 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1436 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/27/2007 12:00:00 AM | 6 | 3X4 | 6015854.7568499 | 2096315.1604746997 | 37.7369724919298 | -122.38764428476802 | (37.7369724919298, -122.387644284768) | ||
| 102897 | 102897 | 87853 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 599 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2008 12:00:00 AM | 3x3 | Permit Number 50764 | 6007684.0 | 2096571.0 | 37.7372189966792 | -122.415912430403 | (37.7372189966792, -122.415912430403) | ||
| 113204 | 113204 | 114762 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 27X Highland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/2015 12:00:00 AM | Permit Number 46967 | 6005096.96871 | 2096699.6024099998 | 37.7374263260205 | -122.424866136467 | (37.7374263260205, -122.424866136467) | |||
| 85638 | 85638 | 92584 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 445 Wawona St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/24/2009 12:00:00 AM | 3x3 | Permit Number 52914 | 5991625.0 | 2097033.0 | 37.737571604455205 | -122.471468876287 | (37.7375716044552, -122.471468876287) | ||
| 88751 | 88751 | 92582 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 445 Wawona St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/24/2009 12:00:00 AM | 3x3 | Permit Number 52914 | 5991625.0 | 2097033.0 | 37.737571604455205 | -122.471468876287 | (37.7375716044552, -122.471468876287) | ||
| 90783 | 90783 | 92589 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 445 Wawona St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/24/2009 12:00:00 AM | 3x3 | Permit Number 52914 | 5991625.0 | 2097033.0 | 37.737571604455205 | -122.471468876287 | (37.7375716044552, -122.471468876287) | ||
| 105427 | 105427 | 86795 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 445 Wawona St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/24/2009 12:00:00 AM | 3x3 | Permit Number 52914 | 5991625.0 | 2097033.0 | 37.737571604455205 | -122.471468876287 | (37.7375716044552, -122.471468876287) | ||
| 106942 | 106942 | 92587 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 445 Wawona St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/24/2009 12:00:00 AM | 3x3 | Permit Number 52914 | 5991625.0 | 2097033.0 | 37.737571604455205 | -122.471468876287 | (37.7375716044552, -122.471468876287) | ||
| 110607 | 110607 | 92586 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 445 Wawona St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/24/2009 12:00:00 AM | 3x3 | Permit Number 52914 | 5991625.0 | 2097033.0 | 37.737571604455205 | -122.471468876287 | (37.7375716044552, -122.471468876287) | ||
| 111694 | 111694 | 92580 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 445 Wawona St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/24/2009 12:00:00 AM | 3x3 | Permit Number 52914 | 5991625.0 | 2097033.0 | 37.737571604455205 | -122.471468876287 | (37.7375716044552, -122.471468876287) | ||
| 117359 | 117359 | 92585 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 445 Wawona St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/24/2009 12:00:00 AM | 3x3 | Permit Number 52914 | 5991625.0 | 2097033.0 | 37.737571604455205 | -122.471468876287 | (37.7375716044552, -122.471468876287) | ||
| 120705 | 120705 | 92583 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 445 Wawona St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/24/2009 12:00:00 AM | 3x3 | Permit Number 52914 | 5991625.0 | 2097033.0 | 37.737571604455205 | -122.471468876287 | (37.7375716044552, -122.471468876287) | ||
| 123606 | 123606 | 92588 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 445 Wawona St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/24/2009 12:00:00 AM | 3x3 | Permit Number 52914 | 5991625.0 | 2097033.0 | 37.737571604455205 | -122.471468876287 | (37.7375716044552, -122.471468876287) | ||
| 142121 | 142121 | 86796 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 445 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/24/2009 12:00:00 AM | 3x3 | Permit Number 52914 | 5991625.0 | 2097033.0 | 37.737571604455205 | -122.471468876287 | (37.7375716044552, -122.471468876287) | ||
| 146017 | 146017 | 92581 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 445 Wawona St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/24/2009 12:00:00 AM | 3x3 | Permit Number 52914 | 5991625.0 | 2097033.0 | 37.737571604455205 | -122.471468876287 | (37.7375716044552, -122.471468876287) | ||
| 124075 | 124075 | 50261 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 31 Highland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/2002 12:00:00 AM | Permit Number 46967 | 6005053.32023027 | 2096760.11488265 | 37.737590014135 | -122.425021354004 | (37.737590014135, -122.425021354004) | ||
| 97987 | 97987 | 117395 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 544 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/2016 12:00:00 AM | 3 | Permit Number 778554 | 5991215.4 | 2097083.4 | 37.737686285904296 | -122.47288871789 | (37.7376862859043, -122.47288871789) | ||
| 1124 | 1124 | 29774 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1100X Evans Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/03/2017 12:44:00 PM | 3 | 3x3 | 6018183.3236 | 2096672.8034 | 37.7380832156692 | -122.37961814277901 | (37.7380832156692, -122.379618142779) | ||
| 9231 | 9231 | 6725 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1200X Fairfax Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2008 12:00:00 AM | 3 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | ||
| 113842 | 113842 | 6746 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1300X Fairfax Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/14/2007 12:00:00 AM | 3 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | ||
| 511 | 511 | 251164 | Undocumented 2 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1215 Fairfax Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/2017 01:46:00 PM | 3 | 3x3 | 6017471.0 | 2096747.0 | 37.738247630240295 | -122.382086185189 | (37.7382476302403, -122.382086185189) | ||
| 516 | 516 | 188685 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1300 Evans Ave | 14 | : 4 | Tree 1 | DPW 2 | 04/10/2017 01:01:00 PM | 3 | Width 3ft | 6017863.857919999 | 2096944.2017700002 | 37.738810795988606 | -122.38074156686301 | (37.7388107959886, -122.380741566863) | ||
| 9079 | 9079 | 6769 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1275 Fairfax Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2007 12:00:00 AM | 3 | 3x3 | 6017217.4089567 | 2096970.3613046003 | 37.738846926957706 | -122.382978527185 | (37.7388469269577, -122.382978527185) | ||
| 507 | 507 | 251288 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1335 Fairfax Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 03/18/2017 01:58:00 PM | 3 | 3x3 | 6016828.0 | 2097292.0 | 37.7397085577181 | -122.38434732981199 | (37.7397085577181, -122.384347329812) | |
| 9834 | 9834 | 6787 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1360 Fairfax Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/03/2017 06:55:00 AM | 3 | 3x3 | 6016787.1910829 | 2097353.9213772 | 37.739876324716896 | -122.384492742853 | (37.7398763247169, -122.384492742853) | ||
| 100415 | 100415 | 6784 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1360 Fairfax Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/10/2007 12:00:00 AM | 4 | 3x3 | 6016787.1910829 | 2097353.9213772 | 37.739876324716896 | -122.384492742853 | (37.7398763247169, -122.384492742853) | ||
| 119953 | 119953 | 63015 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 75 Wool St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/16/2014 12:00:00 AM | Permit Number 772837 | 6007421.64921795 | 2097871.12423845 | 37.7407740975251 | -122.41691158671499 | (37.7407740975251, -122.416911586715) | ||
| 77688 | 77688 | 93269 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1730 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004618.0 | 2098811.0 | 37.743196678206296 | -122.42667246707799 | (37.7431966782063, -122.426672467078) | ||
| 125597 | 125597 | 93271 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1699X Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004711.0 | 2099043.6 | 37.7438406020251 | -122.426367454995 | (37.7438406020251, -122.426367454995) | ||
| 101720 | 101720 | 93272 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1689 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004632.0 | 2099057.0 | 37.7438729293821 | -122.42664157265 | (37.7438729293821, -122.42664157265) | ||
| 85134 | 85134 | 93273 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1679 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004706.9 | 2099119.3 | 37.7440482251279 | -122.42638702061701 | (37.7440482251279, -122.426387020617) | ||
| 143631 | 143631 | 88363 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 2294 31st Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2009 12:00:00 AM | 3x3 | Permit Number 52532 | 5986746.4 | 2099664.8 | 37.7445143908471 | -122.48852965844999 | (37.7445143908471, -122.48852965845) | |||
| 109604 | 109604 | 93274 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1613 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004607.0 | 2099503.0 | 37.7450961296299 | -122.426759771954 | (37.7450961296299, -122.426759771954) | ||
| 79518 | 79518 | 29856 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1800X Evans Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/12/2011 12:00:00 AM | 3 | 4x4 | 6014606.392164 | 2099329.1692391 | 37.745179108267 | -122.392171198439 | (37.745179108267, -122.392171198439) | ||
| 98869 | 98869 | 93275 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1607 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004606.0 | 2099539.0 | 37.7451949208192 | -122.42676579302 | (37.7451949208192, -122.42676579302) | ||
| 108745 | 108745 | 93276 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1603 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004604.0 | 2099562.0 | 37.7452579604553 | -122.426774346316 | (37.7452579604553, -122.426774346316) | ||
| 118880 | 118880 | 93268 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1574 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/29/2015 05:47:00 AM | 3 | 3x3 | 6004569.0 | 2099722.0 | 37.7456953047191 | -122.42690676352 | (37.7456953047191, -122.42690676352) | ||
| 84975 | 84975 | 93277 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1565 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004670.9 | 2099777.3 | 37.7458529070189 | -122.426558345234 | (37.7458529070189, -122.426558345234) | ||
| 143516 | 143516 | 93278 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1559 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004592.0 | 2099818.0 | 37.74596019909129 | -122.426834068489 | (37.7459601990913, -122.426834068489) | ||
| 145750 | 145750 | 93279 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1557 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004591.0 | 2099830.0 | 37.745993091787795 | -122.426838380811 | (37.7459930917878, -122.426838380811) | ||
| 85581 | 85581 | 93267 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1550 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/02/2008 12:00:00 AM | 3 | 3x3 | 6004563.0 | 2099865.0 | 37.746087610537295 | -122.426937693393 | (37.7460876105373, -122.426937693393) | ||
| 104974 | 104974 | 95423 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 2187 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/2011 12:00:00 AM | 3x3 | Permit Number 767291 | 5989736.1 | 2100494.0 | 37.7469651560486 | -122.478252612879 | (37.7469651560486, -122.478252612879) | |
| 114770 | 114770 | 93280 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1485 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004568.0 | 2100246.0 | 37.7471340314151 | -122.42694753458099 | (37.7471340314151, -122.426947534581) | ||
| 88852 | 88852 | 93281 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1465 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/04/2008 12:00:00 AM | 3 | 3x3 | 6004562.0 | 2100365.0 | 37.747460438671105 | -122.426976756198 | (37.7474604386711, -122.426976756198) | ||
| 85944 | 85944 | 93266 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1440 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/02/2008 12:00:00 AM | 3 | 3x3 | 6004482.7 | 2100527.8 | 37.747902965476 | -122.42726256538602 | (37.747902965476, -122.427262565386) | ||
| 139844 | 139844 | 93265 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1400X Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/02/2008 12:00:00 AM | 3 | 3x3 | 6004448.1 | 2100692.1 | 37.748352138422796 | -122.42739391326401 | (37.7483521384228, -122.427393913264) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");