Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||
| 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) | ||
| 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) |
| 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) | ||
| 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) | |
| 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) | |
| 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) | |
| 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) | ||
| 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) | ||
| 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) | |
| 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) | ||
| 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) | |
| 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) | ||
| 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) |
| 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) | |
| 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) | ||
| 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) | ||
| 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) |
| 105028 | 105028 | 32111 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 230 Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1995 12:00:00 AM | Permit Number 770196 | 6003513.5729425 | 2106915.66682873 | 37.7653876747993 | -122.43106961772101 | (37.7653876747993, -122.431069617721) | ||
| 105640 | 105640 | 43407 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 458 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/2000 12:00:00 AM | Permit Number 43150 | 6002175.1657372005 | 2101516.64467827 | 37.7504873295285 | -122.435312625256 | (37.7504873295285, -122.435312625256) | ||
| 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) | |
| 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) | ||
| 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) | ||
| 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) |
| 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) | ||
| 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) | ||
| 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) | |
| 116374 | 116374 | 95641 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 4444 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/04/2011 12:00:00 AM | 3x3 | Permit Number 767410 | 6001257.0 | 2105261.0 | 37.7607162386451 | -122.438755985042 | (37.7607162386451, -122.438755985042) | |
| 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) | ||
| 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) | ||
| 120922 | 120922 | 108531 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 60 Lurline St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773683 | 5991872.4302900005 | 2105034.56834 | 37.7595561547996 | -122.47119619773599 | (37.7595561547996, -122.471196197736) |
| 122382 | 122382 | 50282 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 4128 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/28/2003 12:00:00 AM | Permit Number 46986 | 6002310.55809201 | 2102400.96619241 | 37.7529231541309 | -122.434907664242 | (37.7529231541309, -122.434907664242) | ||
| 122900 | 122900 | 92428 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1606 40th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2009 12:00:00 AM | 3x3 | Permit Number 52819 | 5983797.4 | 2104193.9 | 37.7567775277693 | -122.499061114391 | (37.7567775277693, -122.499061114391) | |
| 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) | ||
| 124891 | 124891 | 95396 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 913 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/2011 12:00:00 AM | 3x3 | Permit Number 767270 | 6003139.0 | 2102931.0 | 37.7544255036425 | -122.432080605043 | (37.7544255036425, -122.432080605043) | |
| 126101 | 126101 | 83665 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 40 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2013 12:00:00 AM | 4 | 3x3 | Permit Number 769772 | 6002625.0 | 2105668.0 | 37.761911493648 | -122.434053786903 | (37.761911493648, -122.434053786903) |
| 127989 | 127989 | 94576 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 3775 21st St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/20/2010 12:00:00 AM | 3x3 | Permit Number 53754 | 6003162.0 | 2103575.0 | 37.7561950785204 | -122.43204705011699 | (37.7561950785204, -122.432047050117) | ||
| 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) |
| 138469 | 138469 | 44787 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 620 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2001 12:00:00 AM | Permit Number 43883 | 6010080.44912755 | 2105396.9401007 | 37.7615875207802 | -122.40824908368799 | (37.7615875207802, -122.408249083688) | ||
| 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) |
| 139461 | 139461 | 33063 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 82-98X Missouri St | 2 | 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) | ||
| 139739 | 139739 | 95561 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 835 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/02/2011 12:00:00 AM | 3x3 | Permit Number 767355 | 6001294.0 | 2101527.0 | 37.7504656822521 | -122.43836049802401 | (37.7504656822521, -122.438360498024) | |
| 139916 | 139916 | 55046 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 3775 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/12/1972 12:00:00 AM | 3x3 | Permit Number 53754 | 6003208.53256552 | 2103569.18124739 | 37.7561817396096 | -122.43188570928899 | (37.7561817396096, -122.431885709289) | |
| 142434 | 142434 | 108527 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 1685 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773678 | 5990568.02917 | 2103933.50348 | 37.7564573872125 | -122.47562701791 | (37.7564573872125, -122.47562701791) |
| 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) | ||
| 144021 | 144021 | 66648 | Permitted Site 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 | 952 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/05/1991 12:00:00 AM | Permit Number 29859 | 6009925.98754531 | 2103657.07059122 | 37.7568015810734 | -122.40866056162399 | (37.7568015810734, -122.408660561624) | ||
| 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) | |
| 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) |
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");