Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qSiteInfo, PlantType, qCaretaker, qCareAssistant
qLegalStatus ✖
| Link | rowid | TreeID ▲ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 4700 | 4700 | 253660 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1545 Pine St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/2017 12:00:00 AM | 3 | 4x4 | 6006535.0 | 2115598.0 | 37.789398009701706 | -122.421235768961 | (37.7893980097017, -122.421235768961) | ||
| 4703 | 4703 | 253659 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1545 Pine St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/2017 12:00:00 AM | 3 | 4x4 | 6006535.0 | 2115598.0 | 37.789398009701706 | -122.421235768961 | (37.7893980097017, -122.421235768961) | ||
| 4699 | 4699 | 253658 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1545 Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/2017 12:00:00 AM | 3 | 4x4 | 6006535.0 | 2115598.0 | 37.789398009701706 | -122.421235768961 | (37.7893980097017, -122.421235768961) | ||
| 4702 | 4702 | 253657 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1545 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/2017 12:00:00 AM | 3 | 4x4 | 6006535.0 | 2115598.0 | 37.789398009701706 | -122.421235768961 | (37.7893980097017, -122.421235768961) | ||
| 4709 | 4709 | 253656 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1545 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/2017 12:00:00 AM | 3 | 4x4 | 6006535.0 | 2115598.0 | 37.789398009701706 | -122.421235768961 | (37.7893980097017, -122.421235768961) | ||
| 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 | ||||||
| 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) | ||
| 3832 | 3832 | 253545 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1000 Cayuga Ave | 13 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 09/27/2017 11:58:00 AM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
| 4040 | 4040 | 253539 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1000 Cayuga Ave | 7 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 10/05/2017 04:07:00 PM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
| 3754 | 3754 | 253538 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1000 Cayuga Ave | 6 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 09/22/2017 02:43:00 PM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
| 4116 | 4116 | 253537 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1000 Cayuga Ave | 5 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 10/05/2017 04:02:00 PM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
| 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) | |||
| 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) | ||||
| 4032 | 4032 | 253155 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 546 Ellington Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 11:02:00 AM | 3 | 3x3 | 5997941.0 | 2087090.0 | 37.710633814489604 | -122.44891554828999 | (37.7106338144896, -122.44891554829) | |||
| 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) | ||||
| 4489 | 4489 | 253086 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2849X Alemany Blvd | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/13/2017 10:29:00 AM | 3 | 3X3 | 5997618.33471 | 2088040.74004 | 37.7132258706419 | -122.45009922742399 | (37.7132258706419, -122.450099227424) | ||
| 4500 | 4500 | 253085 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2849X Alemany Blvd | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/13/2017 10:40:00 AM | 3 | 3X3 | 5997618.33471 | 2088040.74004 | 37.7132258706419 | -122.45009922742399 | (37.7132258706419, -122.450099227424) | ||
| 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) | ||||
| 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) | ||||
| 4365 | 4365 | 252899 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 390 San Miguel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2017 12:05:00 PM | 3 | 3x3 | 5997900.0 | 2090079.0 | 37.7188385770119 | -122.449272458694 | (37.7188385770119, -122.449272458694) | ||
| 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) | ||||
| 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) | ||||
| 4274 | 4274 | 252887 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 715 Mount Vernon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 03:23:00 PM | 3 | 3x3 | 5997288.0 | 2090319.0 | 37.719462535966294 | -122.45140518978998 | (37.7194625359663, -122.45140518979) | ||
| 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) | ||||
| 4259 | 4259 | 252872 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5700 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 03:41:00 PM | 3 | 3x3 | 5997704.0 | 2086907.0 | 37.7101177815644 | -122.449721490093 | (37.7101177815644, -122.449721490093) | ||
| 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) | ||||
| 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) | ||||
| 4366 | 4366 | 251751 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 125 South Hill Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2017 08:38:00 AM | 3 | 3x3 | 6003144.0 | 2086928.0 | 37.710485180250004 | -122.430921281744 | (37.71048518025, -122.430921281744) | ||
| 4396 | 4396 | 251750 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 125 South Hill Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2017 08:46:00 AM | 3 | 3x3 | 6003144.0 | 2086928.0 | 37.710485180250004 | -122.430921281744 | (37.71048518025, -122.430921281744) | ||
| 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) | ||||
| 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) | ||||
| 4394 | 4394 | 251740 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 240 Naylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2017 08:43:00 AM | 3 | 3x3 | 6002635.0 | 2086674.0 | 37.709758897844296 | -122.432662361521 | (37.7097588978443, -122.432662361521) | ||
| 4324 | 4324 | 251737 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 228 Chicago Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2017 08:13:00 AM | 3 | 3x3 | 6002872.0 | 2086877.0 | 37.7103297297312 | -122.43185773233601 | (37.7103297297312, -122.431857732336) | ||
| 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) | |||
| 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) | |||
| 1436 | 1436 | 251534 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1818 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/16/2017 12:00:00 AM | 3 | 3x3 | 5983226.0 | 2102732.0 | 37.7527300247516 | -122.500929082058 | (37.7527300247516, -122.500929082058) | ||
| 1180 | 1180 | 251470 | Planning Code 138.1 required 4 | Tristaniopsis laurina :: Swamp Myrtle 37 | 194 Sweeny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2017 12:00:00 AM | 3 | 3x3 | Permit Number 777454 | 6009558.57553 | 2094850.0846799999 | 37.7325989441491 | -122.409309728531 | (37.7325989441491, -122.409309728531) | |
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | ||
| 326 | 326 | 251270 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 853 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/2017 12:00:00 AM | 3 | 3x3 | 6008278.12362 | 2120317.86249 | 37.8024557006055 | -122.415539041664 | (37.8024557006055, -122.415539041664) | ||
| 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) | ||||
| 60660 | 60660 | 251103 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 6246 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5987571.1015 | 2112622.587 | 37.780141007054205 | -122.486629306939 | (37.7801410070542, -122.486629306939) | |||
| 36244 | 36244 | 251055 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 6157 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5987858.6834 | 2112531.5334 | 37.7799077599796 | -122.48562775841499 | (37.7799077599796, -122.485627758415) | |||
| 136235 | 136235 | 251020 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5020 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5991424.1175 | 2112763.09 | 37.7807506477701 | -122.47331035109501 | (37.7807506477701, -122.473310351095) | |||
| 34094 | 34094 | 251017 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5030 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5991367.0673 | 2112760.8788 | 37.7807412728114 | -122.473507552056 | (37.7807412728114, -122.473507552056) | |||
| 45517 | 45517 | 250835 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 280 30th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5986538.16482 | 2114032.7393400003 | 37.7839526123729 | -122.490306420508 | (37.7839526123729, -122.490306420508) | |||
| 41400 | 41400 | 250834 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 280 30th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5986538.23433 | 2114014.62016 | 37.7839028663707 | -122.490304846691 | (37.7839028663707, -122.490304846691) | |||
| 65254 | 65254 | 250828 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 25 Sea View Ter | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 5986384.161669999 | 2114149.1280799997 | 37.784263186935796 | -122.490847774599 | (37.7842631869358, -122.490847774599) | |||
| 26730 | 26730 | 250827 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 25 Sea View Ter | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 5986363.200619999 | 2114147.38088 | 37.7842571650877 | -122.490920162829 | (37.7842571650877, -122.490920162829) | |||
| 135306 | 135306 | 250826 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 25 Sea View Ter | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 5986347.75861 | 2114146.24732 | 37.784253150511 | -122.490973502552 | (37.784253150511, -122.490973502552) | |||
| 39736 | 39736 | 250825 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 25 Sea View Ter | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5986333.40974 | 2114144.72465 | 37.7842481313918 | -122.4910230318 | (37.7842481313918, -122.4910230318) | |||
| 63139 | 63139 | 250824 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 25 Sea View Ter | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 4ft | 5986320.13068 | 2114141.7174299997 | 37.7842390986088 | -122.491068750642 | (37.7842390986088, -122.491068750642) | |||
| 166606 | 166606 | 250811 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 55 Sea View Ter | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5986145.66751 | 2114125.50365 | 37.784184385653894 | -122.491671129117 | (37.7841843856539, -122.491671129117) | |||
| 150018 | 150018 | 250810 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 55 Sea View Ter | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5986123.508640001 | 2114127.60677 | 37.784188865162 | -122.491747944716 | (37.784188865162, -122.491747944716) | |||
| 175565 | 175565 | 250809 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 277 31st Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5986178.89284 | 2114094.27722 | 37.784100588605206 | -122.491553883599 | (37.7841005886052, -122.491553883599) | |||
| 179166 | 179166 | 250794 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 295 31st Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 4ft | 5986187.23327 | 2113970.1581 | 37.7837602806675 | -122.49151588995701 | (37.7837602806675, -122.491515889957) | |||
| 43525 | 43525 | 250638 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2609 Lake St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5987350.36914 | 2114602.8431 | 37.7855653557873 | -122.487538422371 | (37.7855653557873, -122.487538422371) | |||
| 160678 | 160678 | 250312 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3850 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5995774.138280001 | 2115854.75244 | 37.789490447774504 | -122.458485482839 | (37.7894904477745, -122.458485482839) | |||
| 149467 | 149467 | 249817 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1744 Kearny St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6010847.33897 | 2120972.58058 | 37.8043974733193 | -122.40669440752501 | (37.8043974733193, -122.406694407525) | |||
| 60993 | 60993 | 249816 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1744 Kearny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6010853.01699 | 2120942.1518 | 37.8043142410716 | -122.40667261246901 | (37.8043142410716, -122.406672612469) | |||
| 176118 | 176118 | 249541 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1031 Franklin St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6006016.726419999 | 2113765.1480900003 | 37.7843362199808 | -122.42289862237699 | (37.7843362199808, -122.422898622377) | |||
| 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) | ||||
| 62534 | 62534 | 248599 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 488 Frederick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5997338.6319 | 2107447.0907 | 37.7664949911509 | -122.452465552236 | (37.7664949911509, -122.452465552236) | |||
| 51637 | 51637 | 248543 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 262 Frederick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5998786.1549 | 2107649.6834 | 37.767134085844205 | -122.447473434981 | (37.7671340858442, -122.447473434981) | |||
| 188226 | 188226 | 248508 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 164 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5998310.1076 | 2107801.4007 | 37.7675234471952 | -122.449130934869 | (37.7675234471952, -122.449130934869) | |||
| 51281 | 51281 | 248468 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 148 Beulah St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5997366.9465 | 2107798.6753 | 37.76746197476479 | -122.452392991068 | (37.7674619747648, -122.452392991068) | |||
| 163546 | 163546 | 248467 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 148 Beulah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5997381.1794 | 2107802.9149 | 37.7674744310235 | -122.452344067604 | (37.7674744310235, -122.452344067604) | |||
| 168842 | 168842 | 248456 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 738 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 5999090.801 | 2107937.9767 | 37.7679430712087 | -122.44644045643801 | (37.7679430712087, -122.446440456438) | |||
| 185305 | 185305 | 248418 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1757 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5997316.374 | 2108092.7223 | 37.7682664550348 | -122.452589137037 | (37.7682664550348, -122.452589137037) | |||
| 75544 | 75544 | 248357 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 706 Ashbury St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5999045.3766 | 2108260.1868 | 37.7688251841278 | -122.446620758944 | (37.7688251841278, -122.446620758944) | |||
| 37972 | 37972 | 248356 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 706 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5999049.0106 | 2108245.3482 | 37.7687846486643 | -122.446607121502 | (37.7687846486643, -122.446607121502) | |||
| 66457 | 66457 | 248340 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 712 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 5999056.5813 | 2108183.8739 | 37.7686162882269 | -122.44657651166 | (37.7686162882269, -122.44657651166) | |||
| 42640 | 42640 | 248320 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 715 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5999008.2801 | 2108216.1252 | 37.7687020830549 | -122.446745901812 | (37.7687020830549, -122.446745901812) | |||
| 172805 | 172805 | 248315 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1393 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5999111.5448 | 2108343.919 | 37.7690588709609 | -122.446397913229 | (37.7690588709609, -122.446397913229) | |||
| 150903 | 150903 | 248314 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1393 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5999096.1005 | 2108342.1021 | 37.769053000104 | -122.446451203194 | (37.769053000104, -122.446451203194) | |||
| 25345 | 25345 | 248313 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1395 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5999059.4582 | 2108336.6511 | 37.7690359400967 | -122.446577553957 | (37.7690359400967, -122.446577553957) | |||
| 26168 | 26168 | 248282 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 235 Esmeralda Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6006919.41796 | 2098984.8122799997 | 37.743803772639396 | -122.418727077494 | (37.7438037726394, -122.418727077494) | |||
| 167621 | 167621 | 248148 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 26 Massasoit St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6010009.79788 | 2099371.2582799997 | 37.7450383826304 | -122.408068471788 | (37.7450383826304, -122.408068471788) | |||
| 181737 | 181737 | 248104 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 55 Brewster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6010427.14542 | 2099549.7617900004 | 37.7455518730185 | -122.406637928309 | (37.7455518730185, -122.406637928309) | |||
| 59528 | 59528 | 247831 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 87 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6008707.09183 | 2098278.90963 | 37.741966008914794 | -122.412495812649 | (37.7419660089148, -122.412495812649) | |||
| 37779 | 37779 | 247830 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 89 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6008705.5624 | 2098264.24566 | 37.7419256590428 | -122.41250006462799 | (37.7419256590428, -122.412500064628) | |||
| 131390 | 131390 | 247829 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 91 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6008701.825730001 | 2098237.87048 | 37.741853028888706 | -122.4125111209 | (37.7418530288887, -122.4125111209) | |||
| 166954 | 166954 | 247824 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 76 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6008671.78663 | 2098239.06157 | 37.74185461349679 | -122.412615070848 | (37.7418546134968, -122.412615070848) | |||
| 45821 | 45821 | 247817 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 564 30th St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6002957.26382 | 2098344.63275 | 37.7418221102078 | -122.432381547978 | (37.7418221102078, -122.432381547978) | |||
| 185904 | 185904 | 247801 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 462 30th St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6003630.84189 | 2098375.23957 | 37.741944320889104 | -122.430054719445 | (37.7419443208891, -122.430054719445) | |||
| 184794 | 184794 | 247800 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 450 30th St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6003679.98284 | 2098378.58347 | 37.741956285468504 | -122.42988504438298 | (37.7419562854685, -122.429885044383) | |||
| 136856 | 136856 | 247799 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 468 30th St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6003576.37635 | 2098371.38296 | 37.7419306466931 | -122.430242768589 | (37.7419306466931, -122.430242768589) | |||
| 40628 | 40628 | 247798 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 436 30th St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6003746.333330001 | 2098382.8174900003 | 37.7419716683528 | -122.429655927686 | (37.7419716683528, -122.429655927686) | |||
| 31723 | 31723 | 247796 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 410 30th St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6003801.70372 | 2098385.09969 | 37.7419810698755 | -122.429464637397 | (37.7419810698755, -122.429464637397) | |||
| 152950 | 152950 | 247795 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 408 30th St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6003836.77293 | 2098388.1114 | 37.7419913248315 | -122.429343594042 | (37.7419913248315, -122.429343594042) | |||
| 137783 | 137783 | 247787 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 0 30th St | 3 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6004405.04711 | 2098420.28659 | 37.74211182679821 | -122.42738097477199 | (37.7421118267982, -122.427380974772) |
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");