Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | ||||
17988 | 17988 | 87809 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 3388 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50586 | 6005908.6 | 2098553.3 | 37.7425619734414 | -122.422191602046 | (37.7425619734414, -122.422191602046) | ||
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) | |||
18359 | 18359 | 45033 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 3310 19TH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | 2 | 3x3 | Permit Number 43923 | 6007454.2 | 2105037.1 | 37.7604520749855 | -122.41730672958299 | (37.7604520749855, -122.417306729583) | |
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) | ||
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) | |||
44579 | 44579 | 84428 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 3376 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50585 | 6007059.6670395 | 2105004.14927822 | 37.7603393951154 | -122.418668903501 | (37.7603393951154, -122.418668903501) | ||
53607 | 53607 | 94429 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 5800 03rd St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/29/2010 12:00:00 AM | 3x3 | Permit Number 53653 | 6013849.0 | 2092184.0 | 37.72551786281171 | -122.39428997927601 | (37.7255178628117, -122.394289979276) | ||
61491 | 61491 | 93002 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 250 Valencia St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/15/2008 12:00:00 AM | 3x3 | Permit Number 50388 | 6006066.0 | 2108133.0 | 37.7688744854504 | -122.42232784963001 | (37.7688744854504, -122.42232784963) | ||
62736 | 62736 | 92146 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 728 Jamestown Ave | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 07/08/2009 12:00:00 AM | 3x3 | Permit Number 52458 | 6015302.1 | 2088427.9 | 37.715285014192204 | -122.389004565667 | (37.7152850141922, -122.389004565667) | ||
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) | |||
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) | |||
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) | ||
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) | |||
79737 | 79737 | 107876 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 878 SHOTWELL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6007933.7 | 2102810.7 | 37.754365855539206 | -122.41549072804399 | (37.7543658555392, -122.415490728044) | |||
80562 | 80562 | 102202 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 408 Roosevelt Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2013 12:00:00 AM | 3 | 3x3 | Permit Number 769776 | 5999992.4 | 2106715.5 | 37.764637910001 | -122.443234124093 | (37.764637910001, -122.443234124093) |
81125 | 81125 | 117210 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 620x YORK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009734.0 | 2105398.0 | 37.761571025328294 | -122.409447389709 | (37.7615710253283, -122.409447389709) | ||||
81472 | 81472 | 36734 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 250 Valencia St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/15/2008 12:00:00 AM | 3x3 | Permit Number 50388 | 6006056.66890888 | 2108134.46852817 | 37.768877991321204 | -122.42236022963199 | (37.7688779913212, -122.422360229632) | ||
81803 | 81803 | 107281 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 3545 24TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005985.0 | 2101973.7 | 37.7519579213255 | -122.422170380161 | (37.7519579213255, -122.422170380161) | ||||
82507 | 82507 | 96165 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 42 Putnam St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/2011 12:00:00 AM | 3x3 | Permit Number 767796 | 6009164.0 | 2097229.0 | 37.7391088173015 | -122.41084183088999 | (37.7391088173015, -122.41084183089) | |
82616 | 82616 | 96164 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 42 Putnam St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/2011 12:00:00 AM | 3x3 | Permit Number 767796 | 6009164.0 | 2097229.0 | 37.7391088173015 | -122.41084183088999 | (37.7391088173015, -122.41084183089) | |
82633 | 82633 | 109310 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 99 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772820 | 6006724.0 | 2099085.0 | 37.7440678610189 | -122.41940989424101 | (37.7440678610189, -122.419409894241) |
83466 | 83466 | 36735 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 250 Valencia St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/15/2008 12:00:00 AM | 3x3 | Permit Number 50388 | 6006056.66890888 | 2108134.46852817 | 37.768877991321204 | -122.42236022963199 | (37.7688779913212, -122.422360229632) | ||
83782 | 83782 | 91399 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 76 Keystone Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/31/2009 12:00:00 AM | 3x3 | Permit Number 52095 | 5994157.0 | 2093252.7 | 37.7273379826423 | -122.46244050013 | (37.7273379826423, -122.46244050013) | ||
83818 | 83818 | 110808 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 2X FREELON ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013408.0 | 2111682.0 | 37.7790306545162 | -122.39718109463199 | (37.7790306545162, -122.397181094632) | ||||
84216 | 84216 | 110807 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 2X FREELON ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013408.0 | 2111682.0 | 37.7790306545162 | -122.39718109463199 | (37.7790306545162, -122.397181094632) | ||||
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) | |
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) | |||
84552 | 84552 | 110812 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 2X FREELON ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013408.0 | 2111682.0 | 37.7790306545162 | -122.39718109463199 | (37.7790306545162, -122.397181094632) | ||||
85046 | 85046 | 101944 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 611 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6009843.1 | 2105428.6 | 37.7616611583313 | -122.40907221501699 | (37.7616611583313, -122.409072215017) | |||
85489 | 85489 | 117213 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 620x YORK ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009734.0 | 2105398.0 | 37.761571025328294 | -122.409447389709 | (37.7615710253283, -122.409447389709) | ||||
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) | |||
86404 | 86404 | 102204 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 42 Upper Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/03/2013 12:00:00 AM | 3 | 3x3 | Permit Number 769777 | 5999985.2 | 2107061.7 | 37.7655880783734 | -122.443283894556 | (37.7655880783734, -122.443283894556) |
86701 | 86701 | 95732 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 483 Edinburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767479 | 6003045.8 | 2090902.6 | 37.7213929950365 | -122.43154424747 | (37.7213929950365, -122.43154424747) | |
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) | ||
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) | ||
88450 | 88450 | 36737 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 250 Valencia St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/15/2008 12:00:00 AM | 3x3 | Permit Number 50388 | 6006056.66890888 | 2108134.46852817 | 37.768877991321204 | -122.42236022963199 | (37.7688779913212, -122.422360229632) | ||
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) | |||
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) | |
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) | |||
89587 | 89587 | 110815 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 2X FREELON ST | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013408.0 | 2111682.0 | 37.7790306545162 | -122.39718109463199 | (37.7790306545162, -122.397181094632) | ||||
89668 | 89668 | 52872 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 379@ TOMPKIN Nevada St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/30/2009 12:00:00 AM | 3x3 | Permit Number 52289 | 6008958.88978629 | 2096550.85337252 | 37.7372352710538 | -122.411503113021 | (37.7372352710538, -122.411503113021) | ||
89867 | 89867 | 94427 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 5800 03rd St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/29/2010 12:00:00 AM | 3x3 | Permit Number 53653 | 6013849.0 | 2092184.0 | 37.72551786281171 | -122.39428997927601 | (37.7255178628117, -122.394289979276) | ||
91505 | 91505 | 84149 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 3376 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50585 | 6007059.6670395 | 2105004.14927822 | 37.7603393951154 | -122.418668903501 | (37.7603393951154, -122.418668903501) | ||
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) | |||
92183 | 92183 | 94872 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 3229 Jennings St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/23/2010 12:00:00 AM | 3x3 | Permit Number 53942 | 6013605.0 | 2090171.0 | 37.7199770026118 | -122.394992544907 | (37.7199770026118, -122.394992544907) | ||
92634 | 92634 | 45030 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 3310 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | 2 | 3x3 | Permit Number 43923 | 6007466.67182557 | 2105026.73123369 | 37.7604243064239 | -122.41726286040002 | (37.7604243064239, -122.4172628604) | |
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) | |||
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) | |
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) | ||
94883 | 94883 | 36739 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 250 Valencia St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/15/2008 12:00:00 AM | 3x3 | Permit Number 50388 | 6006056.66890888 | 2108134.46852817 | 37.768877991321204 | -122.42236022963199 | (37.7688779913212, -122.422360229632) | ||
94887 | 94887 | 107079 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 92 Homestead St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/2014 12:00:00 AM | 3x3 | Permit Number 773562 | 6000948.33481 | 2101213.46128 | 37.7495851129185 | -122.439533357227 | (37.7495851129185, -122.439533357227) | |||
94892 | 94892 | 82941 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 705X Tehama St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/29/2011 12:00:00 AM | 3x3 | Permit Number 767578 | 6009380.46605511 | 2110537.73170402 | 37.7756637247842 | -122.41103317126499 | (37.7756637247842, -122.411033171265) | |
95825 | 95825 | 113796 | Section 143 8 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 331 TERESITA BLVD | 2 | Hanging basket : Cutout 29 | Tree 1 | Private 1 | 3x3 | 5997873.0 | 2098382.0 | 37.741635103508294 | -122.44996387489401 | (37.7416351035083, -122.449963874894) | ||||
96013 | 96013 | 104980 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 626X York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 770171 | 6009833.00308 | 2105253.62946 | 37.7611801632772 | -122.409094789719 | (37.7611801632772, -122.409094789719) | |||
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) | ||
96241 | 96241 | 93003 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 250 Valencia St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/15/2008 12:00:00 AM | 3x3 | Permit Number 50388 | 6006066.0 | 2108133.0 | 37.7688744854504 | -122.42232784963001 | (37.7688744854504, -122.42232784963) | ||
96678 | 96678 | 69420 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 2631 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2009 12:00:00 AM | 3x3 | Permit Number 52649 | 6010038.90987973 | 2105005.87245397 | 37.7605114113713 | -122.408365166937 | (37.7605114113713, -122.408365166937) | ||
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) | ||
97899 | 97899 | 93045 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 487 Belvedere St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | Permit Number 53148 | 5998548.0 | 2106357.0 | 37.76357109086079 | -122.448204081475 | (37.7635710908608, -122.448204081475) | ||
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) | |||
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) |
98200 | 98200 | 102210 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 90X Elgin Park | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | Permit Number 769653 | 6005787.0 | 2108557.3 | 37.770023769843704 | -122.42332305888901 | (37.7700237698437, -122.423323058889) | ||
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) | ||||
98446 | 98446 | 99934 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 63 Manchester St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 768712 | 6008250.0 | 2099654.0 | 37.7457160396744 | -122.41417355851002 | (37.7457160396744, -122.41417355851) | |||
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) | ||||
99001 | 99001 | 94426 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 5800 03rd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/29/2010 12:00:00 AM | 3x3 | Permit Number 53653 | 6013849.0 | 2092184.0 | 37.72551786281171 | -122.39428997927601 | (37.7255178628117, -122.394289979276) | ||
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) | |
99707 | 99707 | 93006 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 250 Valencia St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/15/2008 12:00:00 AM | 3x3 | Permit Number 50388 | 6006066.0 | 2108133.0 | 37.7688744854504 | -122.42232784963001 | (37.7688744854504, -122.42232784963) | ||
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) | ||||
101529 | 101529 | 110805 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 2X FREELON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013408.0 | 2111682.0 | 37.7790306545162 | -122.39718109463199 | (37.7790306545162, -122.397181094632) | ||||
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) | |||
103087 | 103087 | 94510 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 2531 28th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/25/2010 12:00:00 AM | 3x3 | Permit Number 53695 | 5987646.3 | 2098052.0 | 37.7401385375939 | -122.485299705684 | (37.7401385375939, -122.485299705684) | |||
103611 | 103611 | 75018 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 25 Elgin Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/28/1997 12:00:00 AM | 3x3 | Permit Number 767139 | 6005836.8050617995 | 2108949.68605393 | 37.7711039786835 | -122.423178679412 | (37.7711039786835, -122.423178679412) | ||
103794 | 103794 | 101945 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 611 York St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/2012 12:00:00 AM | 10 | 3x3 | Permit Number 769515 | 6009843.1 | 2105428.6 | 37.7616611583313 | -122.40907221501699 | (37.7616611583313, -122.409072215017) | |
104177 | 104177 | 102203 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 408 Roosevelt Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2013 12:00:00 AM | 3 | 3x3 | Permit Number 769776 | 5999992.4 | 2106715.5 | 37.764637910001 | -122.443234124093 | (37.764637910001, -122.443234124093) |
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) | ||||
104741 | 104741 | 93004 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 250 Valencia St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/15/2008 12:00:00 AM | 3x3 | Permit Number 50388 | 6006066.0 | 2108133.0 | 37.7688744854504 | -122.42232784963001 | (37.7688744854504, -122.42232784963) | ||
105375 | 105375 | 105675 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 667 Ivy St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 771978 | 6004175.0 | 2110959.5 | 37.7765285144209 | -122.429070243114 | (37.7765285144209, -122.429070243114) | ||||
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) | |
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) | ||
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) | ||||
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) | |
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) | |||
107418 | 107418 | 110810 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 2X FREELON ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013408.0 | 2111682.0 | 37.7790306545162 | -122.39718109463199 | (37.7790306545162, -122.397181094632) | ||||
107816 | 107816 | 92724 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 41 Ford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/25/2009 12:00:00 AM | 3x3 | Permit Number 52959 | 6003346.0 | 2105631.0 | 37.7618507928241 | -122.43155749121999 | (37.7618507928241, -122.43155749122) | ||
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) | |
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) | ||
108229 | 108229 | 57204 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 2450 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2009 12:00:00 AM | 3x3 | Permit Number 52710 | 5992063.41903222 | 2098761.57831598 | 37.7423431948322 | -122.470078897994 | (37.7423431948322, -122.470078897994) | ||
108987 | 108987 | 94168 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 900 Quintara St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/2010 12:00:00 AM | 3x3 | Permit Number 53525 | 5990680.0 | 2101127.0 | 37.7487579569011 | -122.475034924429 | (37.7487579569011, -122.475034924429) | ||
109048 | 109048 | 82863 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 3450 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50587 | 6006545.62237249 | 2104975.62835635 | 37.7602321285391 | -122.420444723128 | (37.7602321285391, -122.420444723128) | ||
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) | ||
109460 | 109460 | 31079 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 90X Elgin Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/04/2016 12:00:00 AM | 4 | 3x3 | Permit Number 769653 | 6005829.36591877 | 2108508.00080397 | 37.769890796995 | -122.42317301085698 | (37.769890796995, -122.423173010857) |
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) | ||
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) | |||
111009 | 111009 | 94873 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 3229 Jennings St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/23/2010 12:00:00 AM | 3x3 | Permit Number 53942 | 6013605.0 | 2090171.0 | 37.7199770026118 | -122.394992544907 | (37.7199770026118, -122.394992544907) | ||
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) | |||
111568 | 111568 | 94421 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 5800 03rd St | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 07/29/2010 12:00:00 AM | 3x3 | Permit Number 53653 | 6013849.0 | 2092184.0 | 37.72551786281171 | -122.39428997927601 | (37.7255178628117, -122.394289979276) |
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");