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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |
| 118357 | 118357 | 50425 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 26 Holloway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2003 12:00:00 AM | Permit Number 47078 | 5996739.2697017 | 2091227.18329804 | 37.7219247572556 | -122.45336747188999 | (37.7219247572556, -122.45336747189) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 112536 | 112536 | 94430 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 5800 03rd St | 14 | 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) | ||
| 119473 | 119473 | 94422 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 5800 03rd St | 10 | 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) | ||
| 119718 | 119718 | 94425 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 5800 03rd St | 15 | 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) | ||
| 119810 | 119810 | 94428 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 5800 03rd St | 9 | 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) | ||
| 128487 | 128487 | 94424 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 5800 03rd St | 13 | 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) | ||
| 144754 | 144754 | 94431 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 5800 03rd St | 16 | 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) | ||
| 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) | |||
| 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) | ||||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | |||
| 123565 | 123565 | 47958 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 300 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2002 12:00:00 AM | Permit Number 45688 | 5997800.77741149 | 2096297.42452827 | 37.7359072289386 | -122.450063383576 | (37.7359072289386, -122.450063383576) | ||
| 140251 | 140251 | 83377 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 390 Arlington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2008 12:00:00 AM | 3x3 | Permit Number 50471 | 6004079.008179099 | 2096201.47422294 | 37.7360010286865 | -122.42835020948999 | (37.7360010286865, -122.42835020949) | ||
| 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) | |
| 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) | |
| 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) | ||
| 139398 | 139398 | 108932 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 418 Anderson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772806 | 6007857.4 | 2096898.0 | 37.738126614046294 | -122.415336047656 | (37.7381266140463, -122.415336047656) |
| 108785 | 108785 | 63832 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 331 Ellsworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/2012 12:00:00 AM | Permit Number 769403 | 6008107.39821454 | 2097107.9451308998 | 37.73871712498921 | -122.414486527778 | (37.7387171249892, -122.414486527778) | ||
| 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) | |
| 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) | |||
| 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) | ||
| 128836 | 128836 | 50699 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 315 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/16/2004 12:00:00 AM | 12 | 6x8 | Permit Number 47261 | 6006595.62338541 | 2097346.13779241 | 37.7392861034365 | -122.419730437543 | (37.7392861034365, -122.419730437543) | |
| 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) | |||
| 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) | |||
| 120652 | 120652 | 52398 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 28@ MISSION Santa Marina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/15/2005 12:00:00 AM | Permit Number 48519 | 6005791.37113066 | 2097745.41692411 | 37.7403370957557 | -122.422539551549 | (37.7403370957557, -122.422539551549) | ||
| 143239 | 143239 | 47980 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 2558 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2002 12:00:00 AM | Permit Number 45714 | 5992088.46801551 | 2098030.76622139 | 37.7403380187937 | -122.46993908856399 | (37.7403380187937, -122.469939088564) | ||
| 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) | ||
| 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) | |
| 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) | ||||
| 103998 | 103998 | 50125 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 70 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2003 12:00:00 AM | Permit Number 46848 | 5993079.36799121 | 2098627.78111817 | 37.7420345009836 | -122.46655636172301 | (37.7420345009836, -122.466556361723) | ||
| 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) | ||
| 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) | ||
| 139839 | 139839 | 87808 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 3388 Mission St | 1 | 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) | ||
| 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) | ||||
| 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) |
| 145852 | 145852 | 95542 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 537 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/02/2011 12:00:00 AM | 3x3 | Permit Number 767329 | 6002431.0 | 2099434.0 | 37.7447834031825 | -122.43427905661301 | (37.7447834031825, -122.434279056613) | |
| 112806 | 112806 | 102995 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 533 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/2013 12:00:00 AM | 12 | 3x3 | Permit Number 770096 | 6002456.0 | 2099436.0 | 37.7447903136679 | -122.434192754421 | (37.7447903136679, -122.434192754421) | |
| 138837 | 138837 | 102996 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 533 28th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/2013 12:00:00 AM | 3x3 | Permit Number 770096 | 6002456.0 | 2099436.0 | 37.7447903136679 | -122.434192754421 | (37.7447903136679, -122.434192754421) | ||
| 112098 | 112098 | 100401 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 91 Manchester St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 6x4.5 | 6008260.0 | 2099484.0 | 37.7452498191594 | -122.414126954963 | (37.7452498191594, -122.414126954963) | |||
| 108809 | 108809 | 100402 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 70 Manchester St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 8.5x4.5 | 6008217.0 | 2099607.0 | 37.7455851344824 | -122.414284343223 | (37.7455851344824, -122.414284343223) | |||
| 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) | |||
| 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) | |||
| 123199 | 123199 | 102228 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 621 27th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/25/2013 12:00:00 AM | 10 | 2x2 | Permit Number 769631 | 6002457.0 | 2100031.0 | 37.746424100900995 | -122.43423182524401 | (37.746424100901, -122.434231825244) | |
| 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) | ||
| 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) | ||
| 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) | ||
| 112424 | 112424 | 45185 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 90 Montcalm St | 2 | 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) | ||
| 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) | ||
| 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) | ||
| 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) |
| 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) | |
| 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) | |
| 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) | ||
| 125600 | 125600 | 99742 | Undocumented 2 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 511 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001875.0 | 2100872.0 | 37.7487002375378 | -122.436304489265 | (37.7487002375378, -122.436304489265) | ||||
| 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) | ||
| 115007 | 115007 | 94169 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 900 Quintara St | 2 | 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) | ||
| 142173 | 142173 | 94170 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 900 Quintara St | 3 | 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) | ||
| 143468 | 143468 | 94171 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 900 Quintara St | 4 | 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) | ||
| 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) | ||
| 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) |
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");