Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
PlantType ✖
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 390 | 390 | 251276 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1175X Hudson Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 03/09/1998 12:00:00 AM | 3x3 | 6017547.0 | 2094834.0 | 37.732999109091 | -122.381690402626 | (37.732999109091, -122.381690402626) | ||
| 391 | 391 | 251275 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1175x Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 09/16/2011 12:00:00 AM | 3x3 | 6017547.0 | 2094834.0 | 37.732999109091 | -122.381690402626 | (37.732999109091, -122.381690402626) | ||
| 1094 | 1094 | 251442 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2700x San Jose Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/17/2006 12:00:00 AM | Width 3ft | 5997075.0 | 2088509.0 | 37.7144804976148 | -122.452010931306 | (37.7144804976148, -122.452010931306) | |||
| 1097 | 1097 | 251443 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2700x San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/17/2006 12:00:00 AM | Width 3ft | 5997075.0 | 2088509.0 | 37.7144804976148 | -122.452010931306 | (37.7144804976148, -122.452010931306) | |||
| 1129 | 1129 | 251457 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 758 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001327.0 | 2092594.0 | 37.7259396258956 | -122.437606717792 | (37.7259396258956, -122.437606717792) | ||||
| 1540 | 1540 | 251588 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1430 17th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5990886.0 | 2105639.0 | 37.7611586563939 | -122.47465184359501 | (37.7611586563939, -122.474651843595) | ||||
| 1649 | 1649 | 251584 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2679 San Jose Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/16/1997 12:00:00 AM | 3x3 | 5997280.0 | 2088608.0 | 37.714764069005604 | -122.45130950851002 | (37.7147640690056, -122.45130950851) | |||
| 1758 | 1758 | 251601 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2679 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/16/1997 12:00:00 AM | 3x3 | 5997280.0 | 2088608.0 | 37.714764069005604 | -122.45130950851002 | (37.7147640690056, -122.45130950851) | |||
| 1833 | 1833 | 251748 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2 South Hill Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002576.6751 | 2087720.0510900002 | 37.7126278178947 | -122.43293862581999 | (37.7126278178947, -122.43293862582) | ||||
| 2106 | 2106 | 252882 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 726 El Camino Del Mar | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 4ft | 5986349.68151 | 2114864.86182 | 37.786226371002705 | -122.491019750162 | (37.7862263710027, -122.491019750162) | ||||
| 2118 | 2118 | 252900 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 598 Mount Vernon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997754.0 | 2090179.0 | 37.7191048016003 | -122.449784323005 | (37.7191048016003, -122.449784323005) | ||||
| 2119 | 2119 | 252901 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 598 Mount Vernon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997754.0 | 2090179.0 | 37.7191048016003 | -122.449784323005 | (37.7191048016003, -122.449784323005) | ||||
| 2286 | 2286 | 252896 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 501x Mount Vernon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997879.0 | 2089997.0 | 37.7186122227881 | -122.44933914222901 | (37.7186122227881, -122.449339142229) | ||||
| 2287 | 2287 | 252897 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 501x Mount Vernon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997879.0 | 2089997.0 | 37.7186122227881 | -122.44933914222901 | (37.7186122227881, -122.449339142229) | ||||
| 2590 | 2590 | 253131 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 277 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 3ft | 6003684.78158 | 2092034.78148 | 37.724537911193295 | -122.429416163945 | (37.7245379111933, -122.429416163945) | ||||
| 2867 | 2867 | 253263 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2425 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991946.0 | 2094328.0 | 37.730162918760904 | -122.470162120918 | (37.7301629187609, -122.470162120918) | ||||
| 2896 | 2896 | 253266 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2411 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/26/1996 12:00:00 AM | 3x3 | 5992016.868969999 | 2094311.4593 | 37.730121598969205 | -122.469915916098 | (37.7301215989692, -122.469915916098) | |||
| 3423 | 3423 | 251752 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 128 South Hill Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | Width 6ft | 6003064.16129 | 2086909.24662 | 37.7104291634552 | -122.431195883608 | (37.7104291634552, -122.431195883608) | ||||
| 3439 | 3439 | 251741 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 300 Naylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002771.0 | 2086560.0 | 37.7094535905361 | -122.432184185389 | (37.7094535905361, -122.432184185389) | ||||
| 3488 | 3488 | 251753 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 128 South Hill Blvd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | Width 6ft | 6003064.16129 | 2086909.24662 | 37.7104291634552 | -122.431195883608 | (37.7104291634552, -122.431195883608) | ||||
| 3868 | 3868 | 253576 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2622 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/2015 12:00:00 AM | 3x3 | Permit Number 774112 | 5986417.0 | 2105735.0 | 37.7611622818619 | -122.49011505097 | (37.7611622818619, -122.49011505097) | ||
| 4538 | 4538 | 253635 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 830 Oak St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 02/22/2008 12:00:00 AM | 6003018.63904 | 2109969.70237 | 37.7737452502421 | -122.43299969185101 | (37.7737452502421, -122.432999691851) | ||||
| 4555 | 4555 | 253633 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1907 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/21/2016 12:00:00 AM | 3x3 | Permit Number 777409 | ||||||
| 4721 | 4721 | 253670 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1063 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001095.0 | 2086792.0 | 37.7099954426001 | -122.437993315946 | (37.7099954426001, -122.437993315946) | ||||
| 4736 | 4736 | 253671 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1063 Prague St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001095.0 | 2086792.0 | 37.7099954426001 | -122.437993315946 | (37.7099954426001, -122.437993315946) | ||||
| 4844 | 4844 | 253688 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 999 Natoma St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6007970.79373767 | 2109754.69864739 | 37.7734345505501 | -122.415854130267 | (37.7734345505501, -122.415854130267) | ||||
| 4848 | 4848 | 31890 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 999 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/2006 12:00:00 AM | Permit Number 35322 | 6007970.79373767 | 2109754.69864739 | 37.7734345505501 | -122.415854130267 | (37.7734345505501, -122.415854130267) | ||
| 5214 | 5214 | 253835 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3353 19th Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 3ft | 5990554.425319999 | 2094179.3629700001 | 37.7296742505655 | -122.47496207986099 | (37.7296742505655, -122.474962079861) | ||||
| 6543 | 6543 | 137954 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1615 SUTTER ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 6004801.2336 | 2114685.8103 | 37.7867954695312 | -122.427169405594 | (37.7867954695312, -122.427169405594) | ||||
| 7270 | 7270 | 98268 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 401X Esmeralda Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | ||||||||
| 7799 | 7799 | 36854 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 9099 | 9099 | 36836 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 9535 | 9535 | 36839 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 9547 | 9547 | 68821 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 300 Detroit St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/30/1993 12:00:00 AM | Permit Number 770629 | 5999450.20473491 | 2094083.18160524 | 37.7299216843992 | -122.44420161479799 | (37.7299216843992, -122.444201614798) | ||
| 9718 | 9718 | 105047 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 278 Capitol Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5995102.4 | 2087946.7 | 37.7128233663074 | -122.458788296392 | (37.7128233663074, -122.458788296392) | |||||
| 10076 | 10076 | 142645 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2380 Mason St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6008890.0639 | 2121379.5977 | 37.805405337199 | -122.41349655223 | (37.805405337199, -122.41349655223) | |||||
| 10115 | 10115 | 173855 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 511 Cordova St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5xt | 6002114.0 | 2086554.0 | 37.7093998431938 | -122.43445445536699 | (37.7093998431938, -122.434454455367) | ||||
| 13906 | 13906 | 36837 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 15723 | 15723 | 36838 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 16572 | 16572 | 36840 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39538 | |||||||||
| 18081 | 18081 | 104069 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1340 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/06/2013 12:00:00 AM | 3x3 | Permit Number 770297 | 6007143.4 | 2107674.1 | 37.7676751698972 | -122.418568643249 | (37.7676751698972, -122.418568643249) | ||
| 18156 | 18156 | 49101 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 601 Brannan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2003 12:00:00 AM | Permit Number 46246 | 6012933.18722113 | 2110757.22353588 | 37.7764649850887 | -122.398758756879 | (37.7764649850887, -122.398758756879) | |||
| 18382 | 18382 | 36313 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 110 Colon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1998 12:00:00 AM | Permit Number 39291 | 5996172.05456486 | 2093809.43581436 | 37.7289824784834 | -122.455514723268 | (37.7289824784834, -122.455514723268) | ||
| 19027 | 19027 | 97174 | Significant Tree 6 | Tristaniopsis laurina :: Swamp Myrtle 37 | 26 Gilbert St | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 6011445.1 | 2110013.2 | 37.7743390438118 | -122.40385413458 | (37.7743390438118, -122.40385413458) | |||||
| 19128 | 19128 | 95689 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2415 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/08/2011 12:00:00 AM | 3x3 | Permit Number 767440 | 5982968.9 | 2098671.4 | 37.7415656423265 | -122.501517800216 | (37.7415656423265, -122.501517800216) | |
| 19354 | 19354 | 95439 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1874 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/2011 12:00:00 AM | 3x3 | Permit Number 767301 | 5986339.2 | 2102491.9 | 37.7522530747906 | -122.490145565656 | (37.7522530747906, -122.490145565656) | |
| 19423 | 19423 | 32825 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4388 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37183 | 6000688.62823937 | 2102311.71658566 | 37.752585873246005 | -122.440510188354 | (37.752585873246, -122.440510188354) | ||
| 19614 | 19614 | 96252 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 301X Lee Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/18/2011 12:00:00 AM | Permit Number 56953 | 5996248.46954 | 2091917.7406900001 | 37.7237927195289 | -122.45511390994899 | (37.7237927195289, -122.455113909949) | |||
| 19673 | 19673 | 39412 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 401Bldg #8 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40928 | 6004636.26366245 | 2109802.84186708 | 37.773378713416 | -122.427392181999 | (37.773378713416, -122.427392181999) | |||
| 20114 | 20114 | 51278 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 200 REVISED Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50924 | 6008254.72294648 | 2097673.72494943 | 37.7402789076073 | -122.414017161022 | (37.7402789076073, -122.414017161022) | ||
| 20373 | 20373 | 101208 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 800X Illinois St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10/03/2012 12:00:00 AM | Permit Number 769306 | 6015895.4 | 2105131.7 | 37.7611831239758 | -122.38811885268801 | (37.7611831239758, -122.388118852688) | |||
| 21233 | 21233 | 44035 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1147 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/02/2000 12:00:00 AM | Permit Number 43570 | 6003860.00449326 | 2101604.35206058 | 37.75082369093 | -122.429492581147 | (37.75082369093, -122.429492581147) | |||
| 22373 | 22373 | 249319 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1424 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007287.0 | 2117809.0 | 37.795511234235704 | -122.41879079594 | (37.7955112342357, -122.41879079594) | ||||
| 22898 | 22898 | 251143 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 164 South Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014077.0 | 2112469.0 | 37.781228798518 | -122.39492187068599 | (37.781228798518, -122.394921870686) | ||||
| 28448 | 28448 | 37169 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 151 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/1998 12:00:00 AM | Permit Number 39743 | 6005565.93572779 | 2099898.57048032 | 37.746236446392295 | -122.423472053683 | (37.7462364463923, -122.423472053683) | ||
| 30143 | 30143 | 36755 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1735 Silver Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39521 | 6011153.23525132 | 2095168.62195256 | 37.733562795365 | -122.403818978685 | (37.733562795365, -122.403818978685) | |||
| 38341 | 38341 | 83767 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 280 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2008 12:00:00 AM | 3x3 | Permit Number 51874 | 6004709.30002437 | 2099902.50025003 | 37.74619884890121 | -122.42643447623001 | (37.7461988489012, -122.42643447623) | ||
| 42988 | 42988 | 32159 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 600 Linden St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1995 12:00:00 AM | Permit Number 35508 | 6004513.09393523 | 2110705.7048246004 | 37.77585078754 | -122.42788259011999 | (37.77585078754, -122.42788259012) | |||
| 46259 | 46259 | 88675 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 601 25th St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | ||
| 47438 | 47438 | 109891 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1398x MARIPOSA ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013218.0 | 2106201.0 | 37.7639704813344 | -122.397453893083 | (37.7639704813344, -122.397453893083) | ||||
| 47995 | 47995 | 36757 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1578 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1998 12:00:00 AM | Permit Number 39522 | 5993099.35503511 | 2104739.07158377 | 37.758815689701294 | -122.46693143538602 | (37.7588156897013, -122.466931435386) | |||
| 49964 | 49964 | 37157 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 88 29th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/1998 12:00:00 AM | Permit Number 39737 | 6005841.01788139 | 2099087.47125623 | 37.7440248746354 | -122.422463228878 | (37.7440248746354, -122.422463228878) | |||
| 51265 | 51265 | 101709 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 95X Milton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003767.7 | 2095277.7 | 37.7334469335284 | -122.42936067235901 | (37.7334469335284, -122.429360672359) | ||||
| 53600 | 53600 | 95249 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 483 22nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5989019.4 | 2112018.5 | 37.778566675209 | -122.48157478549999 | (37.778566675209, -122.4815747855) | ||||
| 54624 | 54624 | 101207 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 800X Illinois St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10/03/2012 12:00:00 AM | Permit Number 769306 | 6015895.4 | 2105131.7 | 37.7611831239758 | -122.38811885268801 | (37.7611831239758, -122.388118852688) | |||
| 58951 | 58951 | 107381 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 14 MOSS ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6010161.8 | 2111354.5 | 37.7779501635385 | -122.408387955783 | (37.7779501635385, -122.408387955783) | ||||||
| 58963 | 58963 | 54330 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1257 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/16/2012 12:00:00 AM | Permit Number 769330 | 5994831.50805386 | 2106979.48216267 | 37.7650671008227 | -122.46110328368299 | (37.7650671008227, -122.461103283683) | |||
| 65721 | 65721 | 110863 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1608 20TH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013178.0 | 2104809.0 | 37.760146128604205 | -122.397494610871 | (37.7601461286042, -122.397494610871) | ||||
| 69380 | 69380 | 47114 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 65 Ellsworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/03/2002 12:00:00 AM | Permit Number 45098 | 6008176.043402901 | 2098254.72889507 | 37.7418697970416 | -122.414330302805 | (37.7418697970416, -122.414330302805) | ||
| 72216 | 72216 | 32816 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3770 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37175 | 6003302.6047116 | 2103041.70072149 | 37.7547387357637 | -122.43152272046301 | (37.7547387357637, -122.431522720463) | ||
| 75295 | 75295 | 88331 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 635 Madrid St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51319 | 6002224.0 | 2090226.0 | 37.7194885890815 | -122.434336629443 | (37.7194885890815, -122.434336629443) | |||
| 76408 | 76408 | 30900 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 312 Hoffman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/13/1995 12:00:00 AM | Permit Number 34727 | 6000605.10855575 | 2101945.95840013 | 37.751576833453896 | -122.440772778765 | (37.7515768334539, -122.440772778765) | |||
| 77168 | 77168 | 36983 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4135 California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | Permit Number 39607 | 5994802.83395529 | 2114343.04174012 | 37.785283832500504 | -122.461736411306 | (37.7852838325005, -122.461736411306) | ||
| 77735 | 77735 | 40293 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3695X 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1999 12:00:00 AM | Permit Number 41437 | 6005149.32455817 | 2101953.724968 | 37.75185590358821 | -122.425058847152 | (37.7518559035882, -122.425058847152) | ||
| 77781 | 77781 | 40025 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 201 Middle Point Rd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1999 12:00:00 AM | Permit Number 41269 | 6018237.888375901 | 2095348.52577329 | 37.7344500201686 | -122.37933752244801 | (37.7344500201686, -122.379337522448) | ||
| 77981 | 77981 | 42208 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 735 Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42478 | 6013099.95011607 | 2112666.9423578 | 37.7817179260512 | -122.398315895959 | (37.7817179260512, -122.398315895959) | ||
| 78008 | 78008 | 95527 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2320 Ortega St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/2011 12:00:00 AM | 3x3 | Permit Number 767318 | 5986850.0 | 2102357.0 | 37.7519124926116 | -122.48836924935699 | (37.7519124926116, -122.488369249357) | |
| 78137 | 78137 | 100334 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1X Gorham St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2x9 | 6002317.2 | 2094130.8 | 37.73021558083929 | -122.43429348768 | (37.7302155808393, -122.43429348768) | ||||
| 78248 | 78248 | 88677 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 601 25th St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51637 | 6016776.9 | 2102119.9 | 37.7529621548081 | -122.384860265748 | (37.7529621548081, -122.384860265748) | ||
| 78340 | 78340 | 38765 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/1998 12:00:00 AM | Permit Number 40634 | 6001679.43660737 | 2094405.04903571 | 37.7309323858205 | -122.436517937945 | (37.7309323858205, -122.436517937945) | ||||
| 78426 | 78426 | 38262 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3049 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/1998 12:00:00 AM | Permit Number 40365 | 6009221.80428817 | 2104486.03920004 | 37.759038276445395 | -122.411154451212 | (37.7590382764454, -122.411154451212) | ||
| 78578 | 78578 | 95716 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 950 Avalon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767471 | 6005194.4 | 2092000.5 | 37.7245291361369 | -122.424195170047 | (37.7245291361369, -122.424195170047) | |
| 78582 | 78582 | 30652 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 18 Lafayette St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/1995 12:00:00 AM | Permit Number 34589 | 6007404.25014155 | 2109701.49866568 | 37.773256609499896 | -122.417810118831 | (37.7732566094999, -122.417810118831) | |||
| 78755 | 78755 | 36294 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 74 Rossmoor Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/1998 12:00:00 AM | Permit Number 39284 | 5990814.34200545 | 2094529.58563397 | 37.7306509333598 | -122.474089072475 | (37.7306509333598, -122.474089072475) | |||
| 78793 | 78793 | 36400 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 95 Greenwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39329 | 5996171.38037302 | 2093732.38222171 | 37.7287708691135 | -122.45551148705098 | (37.7287708691135, -122.455511487051) | ||
| 78821 | 78821 | 98652 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 801@Jones Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 49829 | 6008750.0 | 2115238.0 | 37.7885341615981 | -122.41354662193399 | (37.7885341615981, -122.413546621934) | |||
| 78872 | 78872 | 32162 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 600 Linden St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1995 12:00:00 AM | Permit Number 35508 | 6004513.09393523 | 2110705.7048246004 | 37.77585078754 | -122.42788259011999 | (37.77585078754, -122.42788259012) | |||
| 78983 | 78983 | 37486 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1353 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1998 12:00:00 AM | Permit Number 39955 | 5990795.20359731 | 2106190.41144038 | 37.7626674234032 | -122.475006118896 | (37.7626674234032, -122.475006118896) | ||
| 79063 | 79063 | 89042 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 740 Taylor St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/06/2008 12:00:00 AM | 3x3 | Permit Number 51781 | 6009231.0 | 2115470.0 | 37.789198174235295 | -122.411898830301 | (37.7891981742353, -122.411898830301) | |||
| 79159 | 79159 | 87985 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2101 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 51024 | 5999495.7 | 2111498.4 | 37.777742206872894 | -122.44529598388701 | (37.7777422068729, -122.445295983887) | ||
| 79186 | 79186 | 37161 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 88 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/1998 12:00:00 AM | Permit Number 39737 | 6005841.01788139 | 2099087.47125623 | 37.7440248746354 | -122.422463228878 | (37.7440248746354, -122.422463228878) | |||
| 79203 | 79203 | 33732 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 73 Germania St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1996 12:00:00 AM | Permit Number 37795 | 6003855.80093987 | 2108827.04659377 | 37.7706552465529 | -122.43002229012801 | (37.7706552465529, -122.430022290128) | |||
| 79228 | 79228 | 36231 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1485 Yosemite Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/24/2001 12:00:00 AM | Permit Number 39263 | 6015221.12155905 | 2092170.90026948 | 37.7255580692538 | -122.389545718534 | (37.7255580692538, -122.389545718534) | ||
| 79293 | 79293 | 36208 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1455 Yosemite Ave | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/05/1998 12:00:00 AM | Permit Number 39262 | 6015374.49012429 | 2092056.56629028 | 37.7252526334632 | -122.389007552668 | (37.7252526334632, -122.389007552668) | ||
| 79300 | 79300 | 38329 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1334 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/08/1998 12:00:00 AM | Permit Number 40383 | 6007137.73543764 | 2107714.01420189 | 37.7677844459894 | -122.418591067048 | (37.7677844459894, -122.418591067048) | ||
| 79511 | 79511 | 83990 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 549 Laidley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50485 | 6003149.67149919 | 2096039.38573025 | 37.7355033398719 | -122.431551729165 | (37.7355033398719, -122.431551729165) | ||
| 79588 | 79588 | 34550 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3661 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/1997 12:00:00 AM | Permit Number 38259 | 6008500.27144352 | 2097840.49973377 | 37.7407506227309 | -122.41317993964701 | (37.7407506227309, -122.413179939647) | ||
| 79591 | 79591 | 81923 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2524X Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50824 | 6006683.22400402 | 2119851.76004091 | 37.801086124719895 | -122.421025080133 | (37.8010861247199, -122.421025080133) | ||
| 79607 | 79607 | 91098 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 535 Oxford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/06/2009 12:00:00 AM | 3x3 | Permit Number 51988 | 6007027.8 | 2091471.2 | 37.7231791421759 | -122.41781983223301 | (37.7231791421759, -122.417819832233) | ||
| 79679 | 79679 | 110226 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 195x CHURCH ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004291.0 | 2107903.0 | 37.7681426760471 | -122.42845105700899 | (37.7681426760471, -122.428451057009) |
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");