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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||||
| 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) | |
| 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) | |
| 20474 | 20474 | 45183 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 90 Montcalm St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/23/2001 12:00:00 AM | Permit Number 44029 | 6010481.84262238 | 2099977.43671259 | 37.7467292351784 | -122.406478923454 | (37.7467292351784, -122.406478923454) | ||
| 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) | ||
| 58944 | 58944 | 100194 | Significant Tree 6 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 361 Dellbrook Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5997322.2 | 2102403.9 | 37.7526467193673 | -122.45215846969 | (37.7526467193673, -122.45215846969) | |||||
| 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) | |||
| 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) | ||||
| 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) | ||
| 77696 | 77696 | 50501 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 731 Naples St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/2003 12:00:00 AM | Permit Number 47137 | 6002346.93991516 | 2089394.75729347 | 37.717213158613895 | -122.43385228911998 | (37.7172131586139, -122.43385228912) | ||
| 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) | |||
| 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) | ||||
| 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) |
| 80947 | 80947 | 73875 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 450X Banks St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/18/1994 12:00:00 AM | 8 | 3x4 | 6008487.2849764 | 2096519.17342203 | 37.73712182063289 | -122.413131433288 | (37.7371218206329, -122.413131433288) | |
| 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) | ||||
| 82052 | 82052 | 47978 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 2551 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2002 12:00:00 AM | Permit Number 45712 | 5992034.71482162 | 2098081.02537392 | 37.7404729102685 | -122.470128602855 | (37.7404729102685, -122.470128602855) | ||
| 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) | |
| 82587 | 82587 | 50396 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 62 Springfield Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/18/2006 12:00:00 AM | Permit Number 47047 | 5986810.92291605 | 2095425.7307643 | 37.7328787927022 | -122.48799514007798 | (37.7328787927022, -122.487995140078) | ||
| 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) |
| 82657 | 82657 | 52185 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 44 Albion St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/2005 12:00:00 AM | Permit Number 48377 | 6005762.6437766 | 2106998.90164263 | 37.765743404895 | -122.42329650967899 | (37.765743404895, -122.423296509679) | ||
| 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) | ||
| 83762 | 83762 | 104533 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 277 32nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/16/2013 12:00:00 AM | Permit Number 770674 | 5985841.1 | 2114065.7 | 37.7840023776023 | -122.492720403083 | (37.7840023776023, -122.492720403083) | |||
| 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) | |||
| 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) | |||
| 86276 | 86276 | 45184 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 90 Montcalm St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/23/2001 12:00:00 AM | Permit Number 44029 | 6010481.84262238 | 2099977.43671259 | 37.7467292351784 | -122.406478923454 | (37.7467292351784, -122.406478923454) | ||
| 86400 | 86400 | 50500 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 731 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/2003 12:00:00 AM | Permit Number 47137 | 6002346.93991516 | 2089394.75729347 | 37.717213158613895 | -122.43385228911998 | (37.7172131586139, -122.43385228912) | ||
| 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) |
| 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) | ||
| 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) | ||
| 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) | ||||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 92520 | 92520 | 100195 | Significant Tree 6 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 361 Dellbrook Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5997322.2 | 2102403.9 | 37.7526467193673 | -122.45215846969 | (37.7526467193673, -122.45215846969) | |||||
| 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) | |
| 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) | ||||
| 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) | ||
| 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) | ||||
| 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) | |||
| 94312 | 94312 | 33064 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 82-98X Missouri St | 3 | 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) | ||
| 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) | ||
| 96712 | 96712 | 53711 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 4332 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/14/2010 12:00:00 AM | 4x4 | Permit Number 54013 | 6001635.45830725 | 2104703.42170206 | 37.7592067876859 | -122.43740714223301 | (37.7592067876859, -122.437407142233) | ||
| 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) | |||
| 98618 | 98618 | 95141 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 260 Church St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/10/2011 12:00:00 AM | 2.5x2.5 | Permit Number 54074 | 6004098.9 | 2107250.7 | 37.766340745373604 | -122.42906899666299 | (37.7663407453736, -122.429068996663) | ||
| 98719 | 98719 | 102227 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 621 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 2x2 | 6002457.0 | 2100031.0 | 37.746424100900995 | -122.43423182524401 | (37.746424100901, -122.434231825244) | |||
| 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) | ||
| 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) | |||
| 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) | ||||
| 101944 | 101944 | 45186 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 90 Montcalm St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/23/2001 12:00:00 AM | Permit Number 44029 | 6010481.84262238 | 2099977.43671259 | 37.7467292351784 | -122.406478923454 | (37.7467292351784, -122.406478923454) |
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");