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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
101001 | 101001 | 117071 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 10 JOY ST | 1 | Unaccepted Street : Cutout 20 | Tree 1 | Private 1 | 3x3 | 6010420.0 | 2098909.0 | 37.7437920807055 | -122.406617489968 | (37.7437920807055, -122.406617489968) | ||||
114551 | 114551 | 95142 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1020 Geary St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/10/2011 12:00:00 AM | 3 | 3x3 | Permit Number 54075 | 6006837.0 | 2114321.0 | 37.7859087030895 | -122.420100217722 | (37.7859087030895, -122.420100217722) | |
98055 | 98055 | 81777 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1028-1030 Geary St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/06/2012 12:00:00 AM | 5 | 3x3 | Permit Number 768981 | 6006794.60823814 | 2114319.27887682 | 37.785901588737104 | -122.420246759613 | (37.7859015887371, -122.420246759613) |
84447 | 84447 | 98446 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1117 Howard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Looks like it was planted at same time as tree no. 1 which permit was issued for. | 6009758.0 | 2111239.0 | 37.7776104068373 | -122.409776693812 | (37.7776104068373, -122.409776693812) | |||
110959 | 110959 | 82675 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1175 Gilman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2009 12:00:00 AM | 3x3 | Permit Number 52488 | 6014632.30522662 | 2090165.00558289 | 37.7200176149462 | -122.39144105640699 | (37.7200176149462, -122.391441056407) | ||
85783 | 85783 | 99725 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1195X Greenwich St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 17x15 | 6007168.5 | 2119816.6 | 37.8010169271687 | -122.419343316605 | (37.8010169271687, -122.419343316605) | |||
103595 | 103595 | 99722 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1195X Greenwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 17x15 | 6007168.5 | 2119816.6 | 37.8010169271687 | -122.419343316605 | (37.8010169271687, -122.419343316605) | |||
108423 | 108423 | 99724 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1195X Greenwich St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 17x15 | 6007168.5 | 2119816.6 | 37.8010169271687 | -122.419343316605 | (37.8010169271687, -122.419343316605) | |||
120776 | 120776 | 99721 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1195X Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 17x15 | 6007168.5 | 2119816.6 | 37.8010169271687 | -122.419343316605 | (37.8010169271687, -122.419343316605) | |||
121490 | 121490 | 99723 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1195X Greenwich St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 17x15 | 6007168.5 | 2119816.6 | 37.8010169271687 | -122.419343316605 | (37.8010169271687, -122.419343316605) | |||
93276 | 93276 | 100093 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 11X Shotwell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6007856.7 | 2107724.0 | 37.7678523153445 | -122.416104954993 | (37.7678523153445, -122.416104954993) | |||
102318 | 102318 | 100091 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 11X Shotwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6007856.7 | 2107724.0 | 37.7678523153445 | -122.416104954993 | (37.7678523153445, -122.416104954993) | |||
91796 | 91796 | 42591 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 121 Junipero Serra Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42664 | 5991652.84779157 | 2095347.0788301998 | 37.7329441015396 | -122.471249796136 | (37.7329441015396, -122.471249796136) | ||
90072 | 90072 | 54092 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 130 San Rafael Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/06/2011 12:00:00 AM | Permit Number 768262 | 5991854.42006361 | 2095289.1308882 | 37.7327966487645 | -122.47054869605 | (37.7327966487645, -122.47054869605) | |||
110837 | 110837 | 97422 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 130 San Rafael Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/06/2011 12:00:00 AM | 2x2 | Permit Number 768262 | 5991847.6 | 2095285.1 | 37.7327851865934 | -122.470571981031 | (37.7327851865934, -122.470571981031) | ||
86433 | 86433 | 33060 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1300 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/2003 12:00:00 AM | Permit Number 47189 | 6013414.11525102 | 2106644.78468583 | 37.7651999335347 | -122.3968066986 | (37.7651999335347, -122.3968066986) | ||
123569 | 123569 | 108880 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1301X JESSIE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006447.0 | 2109024.0 | 37.7713424435686 | -122.421073267678 | (37.7713424435686, -122.421073267678) | ||||
139778 | 139778 | 108879 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1301X JESSIE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006447.0 | 2109024.0 | 37.7713424435686 | -122.421073267678 | (37.7713424435686, -122.421073267678) | ||||
120903 | 120903 | 108881 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1301x JESSIE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006447.0 | 2109024.0 | 37.7713424435686 | -122.421073267678 | (37.7713424435686, -122.421073267678) | ||||
126566 | 126566 | 108882 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1301x JESSIE ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006447.0 | 2109024.0 | 37.7713424435686 | -122.421073267678 | (37.7713424435686, -122.421073267678) | ||||
128954 | 128954 | 108884 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1301x JESSIE ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006447.0 | 2109024.0 | 37.7713424435686 | -122.421073267678 | (37.7713424435686, -122.421073267678) | ||||
128499 | 128499 | 96724 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1357 Alabama St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/06/2011 12:00:00 AM | Permit Number 767997 | 6009298.0 | 2101259.0 | 37.750181824318204 | -122.410663037771 | (37.7501818243182, -122.410663037771) | ||||
145637 | 145637 | 86753 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1376 06th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2009 12:00:00 AM | 3x3 | Permit Number 52654 | 5994310.3 | 2106169.4 | 37.7628128189867 | -122.462847225894 | (37.7628128189867, -122.462847225894) | |||
106989 | 106989 | 106814 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1382 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007675.9 | 2101620.4 | 37.75108306814229 | -122.416297967978 | (37.7510830681423, -122.416297967978) | ||||
84248 | 84248 | 94824 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1391 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/10/2010 12:00:00 AM | 3x3 | Permit Number 53904 | 5990789.3 | 2105954.6 | 37.762019606095 | -122.475009322669 | (37.762019606095, -122.475009322669) | |
77504 | 77504 | 47908 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1394on Pierce McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52419 | 6002488.12877118 | 2111638.62757639 | 37.7782975970335 | -122.434954188456 | (37.7782975970335, -122.434954188456) | ||
106131 | 106131 | 47910 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1394on Pierce McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52419 | 6002488.12877118 | 2111638.62757639 | 37.7782975970335 | -122.434954188456 | (37.7782975970335, -122.434954188456) | ||
128476 | 128476 | 100894 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1400 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 6008828.0 | 2109520.0 | 37.7728382767515 | -122.412872323828 | (37.7728382767515, -122.412872323828) | |||
94230 | 94230 | 72891 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 143 Valdez Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 09/01/2011 12:00:00 AM | Permit Number 768196 | 5996238.58765499 | 2094412.40177524 | 37.7306418958229 | -122.455328273496 | (37.7306418958229, -122.455328273496) | |||
117301 | 117301 | 72691 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 143 Valdez Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 09/01/2011 12:00:00 AM | Permit Number 768196 | 5996238.58765499 | 2094412.40177524 | 37.7306418958229 | -122.455328273496 | (37.7306418958229, -122.455328273496) | |||
108080 | 108080 | 57465 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1439 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/16/1976 12:00:00 AM | 20 | 3x3 | Permit Number 16313 | 5994563.72083648 | 2105730.98306422 | 37.7616236328643 | -122.46193894552799 | (37.7616236328643, -122.461938945528) | |
118692 | 118692 | 60397 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1445 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2009 12:00:00 AM | 3x3 | Permit Number 52466 | 6016065.49318693 | 2093986.4863783 | 37.730590090931294 | -122.38675332477 | (37.7305900909313, -122.38675332477) | ||
109145 | 109145 | 55376 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1491 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/1972 12:00:00 AM | 3x3 | Permit Number 11313 | 5993646.25927439 | 2105360.40659062 | 37.760553264764 | -122.465085130446 | (37.760553264764, -122.465085130446) | ||
127476 | 127476 | 98989 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1491 08th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 11313 | 5993631.9 | 2105378.7 | 37.7606026656916 | -122.46513612094601 | (37.7606026656916, -122.465136120946) | |||
121867 | 121867 | 105125 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1520 WILLARD ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 2x4 | Permit Number 771187 | 5996927.9 | 2105971.4 | 37.7624195807215 | -122.453779617781 | (37.7624195807215, -122.453779617781) | ||
88932 | 88932 | 96056 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1532 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767684 | 6009571.0 | 2100485.0 | 37.7480718940124 | -122.40966435882099 | (37.7480718940124, -122.409664358821) | |
100521 | 100521 | 94534 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1545@ Post St Divisadero St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/01/2010 12:00:00 AM | Permit Number 53714 | 6001163.0 | 2113666.0 | 37.7837889169409 | -122.439683671841 | (37.7837889169409, -122.439683671841) | |||
106514 | 106514 | 94533 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1545@ Post St Divisadero St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/01/2010 12:00:00 AM | Permit Number 53714 | 6001163.0 | 2113666.0 | 37.7837889169409 | -122.439683671841 | (37.7837889169409, -122.439683671841) | |||
144532 | 144532 | 56773 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1590X McKinnon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/23/2010 12:00:00 AM | 3x3 | Permit Number 53948 | 6015510.638170599 | 2096034.20336208 | 37.736181973612 | -122.38881445867901 | (37.736181973612, -122.388814458679) | |
93361 | 93361 | 42709 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1600 Union St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/15/2010 12:00:00 AM | 3x3 | Permit Number 53744 | 6005315.92998199 | 2118904.40480493 | 37.7984077601464 | -122.42568904485 | (37.7984077601464, -122.42568904485) | |
99069 | 99069 | 42707 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1600 Union St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/15/2010 12:00:00 AM | 3x3 | Permit Number 53744 | 6005315.92998199 | 2118904.40480493 | 37.7984077601464 | -122.42568904485 | (37.7984077601464, -122.42568904485) | |
105951 | 105951 | 42711 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1600 Union St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/15/2010 12:00:00 AM | 3x3 | Permit Number 53744 | 6005315.92998199 | 2118904.40480493 | 37.7984077601464 | -122.42568904485 | (37.7984077601464, -122.42568904485) | |
122900 | 122900 | 92428 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1606 40th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2009 12:00:00 AM | 3x3 | Permit Number 52819 | 5983797.4 | 2104193.9 | 37.7567775277693 | -122.499061114391 | (37.7567775277693, -122.499061114391) | |
129151 | 129151 | 108927 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1612 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773055 | 6010381.6 | 2100196.5 | 37.7473251266072 | -122.406840990737 | (37.7473251266072, -122.406840990737) |
139412 | 139412 | 82676 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1621 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/09/2009 12:00:00 AM | 3x3 | Permit Number 52504 | 6014985.81451712 | 2094439.95411177 | 37.7317753861847 | -122.390517640406 | (37.7317753861847, -122.390517640406) | ||
141997 | 141997 | 83322 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1630 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/2010 12:00:00 AM | 3x3 | Permit Number 53558 | 5992802.78725609 | 2104361.64977018 | 37.757762266381 | -122.467929643141 | (37.757762266381, -122.467929643141) | ||
142434 | 142434 | 108527 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1685 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773678 | 5990568.02917 | 2103933.50348 | 37.7564573872125 | -122.47562701791 | (37.7564573872125, -122.47562701791) |
87788 | 87788 | 94151 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1719 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/2010 12:00:00 AM | 3x3 | Permit Number 53546 | 5991153.7 | 2103679.7 | 37.7557944451048 | -122.47358306865101 | (37.7557944451048, -122.473583068651) | ||
98334 | 98334 | 98504 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1720 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006632.0 | 2116686.0 | 37.7923908555977 | -122.420977439548 | (37.7923908555977, -122.420977439548) | ||||
108109 | 108109 | 84473 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 173 Laidley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50476 | 6004035.61598466 | 2097396.11275514 | 37.7392787789652 | -122.428585363223 | (37.7392787789652, -122.428585363223) | ||
119160 | 119160 | 87771 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 173 Laidley St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50476 | 6004033.0 | 2097383.0 | 37.7392426262863 | -122.42859347367599 | (37.7392426262863, -122.428593473676) | |||
24679 | 24679 | 83385 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1743 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/2010 12:00:00 AM | 3x3 | Permit Number 53553 | 5992776.43619882 | 2103602.82847895 | 37.7556772189572 | -122.467965581747 | (37.7556772189572, -122.467965581747) | ||
93603 | 93603 | 37154 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 175 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/12/2010 12:00:00 AM | 3x3 | Permit Number 53678 | 6005395.05541488 | 2100179.52375956 | 37.7469982334442 | -122.424082914114 | (37.7469982334442, -122.424082914114) | ||
91846 | 91846 | 116189 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1751 CARROLL AVE | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6013485.0 | 2092424.0 | 37.72615661412179 | -122.395565112125 | (37.7261566141218, -122.395565112125) | |||
139654 | 139654 | 116183 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1751 CARROLL AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x15 | 6013485.0 | 2092424.0 | 37.72615661412179 | -122.395565112125 | (37.7261566141218, -122.395565112125) | |||
96064 | 96064 | 111890 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 176X PERALTA AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 25 | 3x3 | 6009847.0 | 2100071.0 | 37.7469506034955 | -122.408680755084 | (37.7469506034955, -122.408680755084) | ||
114299 | 114299 | 113254 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 178 Edgewood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/16/2015 12:00:00 AM | Permit Number 774289 | 5996632.6 | 2106029.8 | 37.762562997849706 | -122.454805165139 | (37.7625629978497, -122.454805165139) | |||
105180 | 105180 | 95781 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1864 08th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/12/2011 12:00:00 AM | Permit Number 58773 | 5993804.7 | 2102837.8 | 37.7536359736806 | -122.46435400663401 | (37.7536359736806, -122.464354006634) | |||
142491 | 142491 | 82800 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1942 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/2010 12:00:00 AM | 3x3 | Permit Number 53540 | 5990674.38979657 | 2102169.39971398 | 37.751619788601296 | -122.47513041081899 | (37.7516197886013, -122.475130410819) | ||
18083 | 18083 | 110821 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1X WELSH ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6013408.0 | 2111682.0 | 37.7790306545162 | -122.39718109463199 | (37.7790306545162, -122.397181094632) | |||
69382 | 69382 | 110827 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1X WELSH ST | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6013408.0 | 2111682.0 | 37.7790306545162 | -122.39718109463199 | (37.7790306545162, -122.397181094632) | |||
98894 | 98894 | 110828 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1X WELSH ST | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013408.0 | 2111682.0 | 37.7790306545162 | -122.39718109463199 | (37.7790306545162, -122.397181094632) | ||||
104610 | 104610 | 110818 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1X WELSH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013408.0 | 2111682.0 | 37.7790306545162 | -122.39718109463199 | (37.7790306545162, -122.397181094632) | ||||
107239 | 107239 | 110820 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1X WELSH ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6013408.0 | 2111682.0 | 37.7790306545162 | -122.39718109463199 | (37.7790306545162, -122.397181094632) | |||
129346 | 129346 | 110822 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1X WELSH ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6013408.0 | 2111682.0 | 37.7790306545162 | -122.39718109463199 | (37.7790306545162, -122.397181094632) | |||
106996 | 106996 | 33815 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 200 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/2004 12:00:00 AM | 12 | 3x3 | Permit Number 47361 | 6006849.4113767 | 2097983.16030049 | 37.7410495186328 | -122.418898117948 | (37.7410495186328, -122.418898117948) | |
110984 | 110984 | 95158 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 200 San Jose Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 54076 | 6006077.0 | 2101949.0 | 37.7518952895514 | -122.421850476115 | (37.7518952895514, -122.421850476115) | |||
37395 | 37395 | 94780 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 200X Loomis St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/28/2010 12:00:00 AM | 3x3 | 6010555.4 | 2097635.9 | 37.740303997417 | -122.406059635863 | (37.740303997417, -122.406059635863) | |||
65797 | 65797 | 94769 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 200X Loomis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/28/2010 12:00:00 AM | 3x3 | 6010555.4 | 2097635.9 | 37.740303997417 | -122.406059635863 | (37.740303997417, -122.406059635863) | |||
78215 | 78215 | 94783 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 200X Loomis St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/28/2010 12:00:00 AM | 3x3 | 6010555.4 | 2097635.9 | 37.740303997417 | -122.406059635863 | (37.740303997417, -122.406059635863) | |||
79142 | 79142 | 94774 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 200X Loomis St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/28/2010 12:00:00 AM | 3x3 | 6010555.4 | 2097635.9 | 37.740303997417 | -122.406059635863 | (37.740303997417, -122.406059635863) | |||
85720 | 85720 | 94770 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 200X Loomis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/28/2010 12:00:00 AM | 3x3 | 6010555.4 | 2097635.9 | 37.740303997417 | -122.406059635863 | (37.740303997417, -122.406059635863) | |||
88907 | 88907 | 94777 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 200X Loomis St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/28/2010 12:00:00 AM | 3x3 | 6010555.4 | 2097635.9 | 37.740303997417 | -122.406059635863 | (37.740303997417, -122.406059635863) | |||
89454 | 89454 | 94775 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 200X Loomis St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/28/2010 12:00:00 AM | 3x3 | 6010555.4 | 2097635.9 | 37.740303997417 | -122.406059635863 | (37.740303997417, -122.406059635863) | |||
97928 | 97928 | 94778 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 200X Loomis St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/28/2010 12:00:00 AM | 3x3 | 6010555.4 | 2097635.9 | 37.740303997417 | -122.406059635863 | (37.740303997417, -122.406059635863) | |||
111308 | 111308 | 94779 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 200X Loomis St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/28/2010 12:00:00 AM | 3x3 | 6010555.4 | 2097635.9 | 37.740303997417 | -122.406059635863 | (37.740303997417, -122.406059635863) | |||
111502 | 111502 | 94776 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 200X Loomis St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/28/2010 12:00:00 AM | 3x3 | 6010555.4 | 2097635.9 | 37.740303997417 | -122.406059635863 | (37.740303997417, -122.406059635863) | |||
112591 | 112591 | 94773 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 200X Loomis St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/28/2010 12:00:00 AM | 3x3 | 6010555.4 | 2097635.9 | 37.740303997417 | -122.406059635863 | (37.740303997417, -122.406059635863) | |||
112764 | 112764 | 94782 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 200X Loomis St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/28/2010 12:00:00 AM | 3x3 | 6010555.4 | 2097635.9 | 37.740303997417 | -122.406059635863 | (37.740303997417, -122.406059635863) | |||
140573 | 140573 | 94768 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 200X Loomis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/28/2010 12:00:00 AM | 3x3 | 6010555.4 | 2097635.9 | 37.740303997417 | -122.406059635863 | (37.740303997417, -122.406059635863) | |||
141209 | 141209 | 94781 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 200X Loomis St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/28/2010 12:00:00 AM | 3x3 | 6010555.4 | 2097635.9 | 37.740303997417 | -122.406059635863 | (37.740303997417, -122.406059635863) | |||
142271 | 142271 | 94772 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 200X Loomis St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/28/2010 12:00:00 AM | 3x3 | 6010555.4 | 2097635.9 | 37.740303997417 | -122.406059635863 | (37.740303997417, -122.406059635863) | |||
142655 | 142655 | 94771 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 200X Loomis St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/28/2010 12:00:00 AM | 3x3 | 6010555.4 | 2097635.9 | 37.740303997417 | -122.406059635863 | (37.740303997417, -122.406059635863) | |||
77471 | 77471 | 100428 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 200X Stonecrest Dr | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2.5x4 | 5990724.7 | 2093134.9 | 37.7268162840874 | -122.47429724264 | (37.7268162840874, -122.47429724264) | ||||
88537 | 88537 | 100426 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 200X Stonecrest Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2.5x4 | 5990724.7 | 2093134.9 | 37.7268162840874 | -122.47429724264 | (37.7268162840874, -122.47429724264) | ||||
93522 | 93522 | 100427 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 200X Stonecrest Dr | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2.5x4 | 5990724.7 | 2093134.9 | 37.7268162840874 | -122.47429724264 | (37.7268162840874, -122.47429724264) | ||||
93898 | 93898 | 100429 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 200X Stonecrest Dr | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2.5x4 | 5990724.7 | 2093134.9 | 37.7268162840874 | -122.47429724264 | (37.7268162840874, -122.47429724264) | ||||
120201 | 120201 | 100430 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 200X Stonecrest Dr | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2.5x4 | 5990724.7 | 2093134.9 | 37.7268162840874 | -122.47429724264 | (37.7268162840874, -122.47429724264) | ||||
2754 | 2754 | 253208 | DPW Maintained 3 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 201x Shipley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6011752.0 | 2111938.0 | 37.7796412414558 | -122.402927910408 | (37.7796412414558, -122.402927910408) | ||||
141153 | 141153 | 50880 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 2035 15th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2004 12:00:00 AM | Permit Number 47390 | 5991589.50004972 | 2101572.19756465 | 37.7500330221911 | -122.47192235120501 | (37.7500330221911, -122.471922351205) | |||
79434 | 79434 | 105048 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 205 Carl St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3X3 | Permit Number 771190 | 5997152.5 | 2107007.0 | 37.765275948780605 | -122.453077573625 | (37.7652759487806, -122.453077573625) | ||||
3604 | 3604 | 236813 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 207 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/13/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 771190 | 5997138.1422 | 2107019.95988 | 37.7653107104358 | -122.453128169228 | (37.7653107104358, -122.453128169228) | |
117694 | 117694 | 106552 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 207 Los Palmos Dr | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/08/2014 12:00:00 AM | 3X3 | Permit Number 768265 | 5998005.6 | 2096224.8 | 37.7357195377121 | -122.44935000292601 | (37.7357195377121, -122.449350002926) | |||
87026 | 87026 | 94152 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 2075 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/2010 12:00:00 AM | 3x3 | Permit Number 53545 | 5991258.5 | 2101318.0 | 37.7493159033344 | -122.47304842091499 | (37.7493159033344, -122.473048420915) | ||
104624 | 104624 | 115872 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 211 Edgewood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/29/2016 12:00:00 AM | 3 | Permit Number 771795 | 5996543.2 | 2105806.0 | 37.7619433716087 | -122.455098192614 | (37.7619433716087, -122.455098192614) | ||
106469 | 106469 | 50885 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 2127 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/2004 12:00:00 AM | Permit Number 47394 | 5991285.70524254 | 2100933.45919482 | 37.7482616292065 | -122.472926308365 | (37.7482616292065, -122.472926308365) | ||
113596 | 113596 | 50935 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 2140 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/07/2011 12:00:00 AM | 3x3 | Permit Number 767415 | 5991665.93715326 | 2100855.12914226 | 37.7480685606743 | -122.471605782529 | (37.7480685606743, -122.471605782529) | |
128428 | 128428 | 95139 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 217 States St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/10/2011 12:00:00 AM | 3x3 | Permit Number 54073 | 6000763.0 | 2106514.0 | 37.764128551802 | -122.440554377209 | (37.764128551802, -122.440554377209) | ||
122838 | 122838 | 57178 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 219 States St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/10/2011 12:00:00 AM | 3x3 | Permit Number 54073 | 6000772.77457474 | 2106496.84625241 | 37.764082008440596 | -122.440519339477 | (37.7640820084406, -122.440519339477) | ||
97523 | 97523 | 49398 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 226@ DANVERS Caselli Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/2010 12:00:00 AM | 3x3 | Permit Number 53717 | 5999940.69424532 | 2104865.65120183 | 37.7595557350724 | -122.44328008497801 | (37.7595557350724, -122.443280084978) |
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");