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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 82557 | 82557 | 11728 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 900X Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2000 12:00:00 AM | 3 | 2x3 | 5991216.9689233005 | 2091217.0890623 | 37.7215789580388 | -122.472455744827 | (37.7215789580388, -122.472455744827) | ||
| 86439 | 86439 | 11729 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 900X Junipero Serra Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/18/2008 12:00:00 AM | 3 | 2x2 | 5991216.9689233005 | 2091217.0890623 | 37.7215789580388 | -122.472455744827 | (37.7215789580388, -122.472455744827) | ||
| 104505 | 104505 | 11733 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 900X Junipero Serra Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/18/2008 12:00:00 AM | 3 | 4x6 | 5991216.9689233005 | 2091217.0890623 | 37.7215789580388 | -122.472455744827 | (37.7215789580388, -122.472455744827) | ||
| 89499 | 89499 | 11734 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 900X Junipero Serra Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/03/2014 12:00:00 AM | 3 | 2X2 | 5991216.9689233005 | 2091217.0890623 | 37.7215789580388 | -122.472455744827 | (37.7215789580388, -122.472455744827) | ||
| 125007 | 125007 | 11736 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 900X Junipero Serra Blvd | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/03/2014 12:00:00 AM | 3 | 3x3 | 5991216.9689233005 | 2091217.0890623 | 37.7215789580388 | -122.472455744827 | (37.7215789580388, -122.472455744827) | ||
| 125038 | 125038 | 11738 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 900X Junipero Serra Blvd | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2000 12:00:00 AM | 3 | 2x2 | 5991216.9689233005 | 2091217.0890623 | 37.7215789580388 | -122.472455744827 | (37.7215789580388, -122.472455744827) | ||
| 144504 | 144504 | 11739 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 900X Junipero Serra Blvd | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 2x2 | 5991216.9689233005 | 2091217.0890623 | 37.7215789580388 | -122.472455744827 | (37.7215789580388, -122.472455744827) | |||
| 123241 | 123241 | 11742 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 900X Junipero Serra Blvd | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/03/2014 12:00:00 AM | 3 | 2x2 | 5991216.9689233005 | 2091217.0890623 | 37.7215789580388 | -122.472455744827 | (37.7215789580388, -122.472455744827) | ||
| 124013 | 124013 | 11743 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 900X Junipero Serra Blvd | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 2x2 | 5991216.9689233005 | 2091217.0890623 | 37.7215789580388 | -122.472455744827 | (37.7215789580388, -122.472455744827) | |||
| 139334 | 139334 | 11744 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 900X Junipero Serra Blvd | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/01/2006 12:00:00 AM | 3 | 2x2 | 5991216.9689233005 | 2091217.0890623 | 37.7215789580388 | -122.472455744827 | (37.7215789580388, -122.472455744827) | ||
| 20123 | 20123 | 11745 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 700X Junipero Serra Blvd | 28 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 2X2 | 5991283.014280001 | 2092711.56765 | 37.7256862482988 | -122.472336336474 | (37.7256862482988, -122.472336336474) | |||
| 21943 | 21943 | 11749 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 700X Junipero Serra Blvd | 32 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991277.44671 | 2092637.4154400001 | 37.725482322545 | -122.472350179738 | (37.725482322545, -122.472350179738) | ||
| 20481 | 20481 | 11750 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 700X Junipero Serra Blvd | 33 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 6X6 | 5991277.22617 | 2092626.95248 | 37.725453581094996 | -122.472350179722 | (37.725453581095, -122.472350179722) | ||
| 18049 | 18049 | 11751 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 700X Junipero Serra Blvd | 34 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 2X2 | 5991273.90921 | 2092612.06859 | 37.7254125216598 | -122.47236056150801 | (37.7254125216598, -122.472360561508) | ||
| 21425 | 21425 | 11754 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 700X Junipero Serra Blvd | 37 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 6X6 | 5991270.92454 | 2092589.2026099998 | 37.725349564621204 | -122.472369212969 | (37.7253495646212, -122.472369212969) | ||
| 101927 | 101927 | 11761 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 999X Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 5991260.9047733005 | 2090529.2081036 | 37.719692749400394 | -122.47225375374799 | (37.7196927494004, -122.472253753748) | ||
| 116303 | 116303 | 11786 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1199X Junipero Serra Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 03/17/2001 12:00:00 AM | 6 | 3x4 | 5991174.554565701 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | ||
| 9944 | 9944 | 11821 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1299X Junipero Serra Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 2 | 3 | 5991432.171815401 | 2088660.0347764 | 37.7145703669544 | -122.47152561846501 | (37.7145703669544, -122.471525618465) | ||
| 9947 | 9947 | 11824 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1299X Junipero Serra Blvd | 14 | Sidewalk: Curb side : Yard 2 | Tree 1 | PUC 13 | 03/13/2013 12:00:00 AM | 2 | 3 | 5991432.171815401 | 2088660.0347764 | 37.7145703669544 | -122.47152561846501 | (37.7145703669544, -122.471525618465) | ||
| 123146 | 123146 | 12703 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1421 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/01/1992 12:00:00 AM | 35 | 3x3 | 5991025.24257 | 2114733.5652799997 | 37.7861379215877 | -122.474834107162 | (37.7861379215877, -122.474834107162) | ||
| 102354 | 102354 | 12707 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1445 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/01/2000 12:00:00 AM | 11 | 3X3 | 5990956.97552 | 2114731.55744 | 37.7861284523845 | -122.47507014401 | (37.7861284523845, -122.47507014401) | ||
| 48561 | 48561 | 12710 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1449 Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/01/2000 12:00:00 AM | 20 | 3 | 5990916.72609 | 2114727.92382 | 37.7861161427082 | -122.475209129549 | (37.7861161427082, -122.475209129549) | ||
| 146303 | 146303 | 12841 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2320 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 5988199.43005 | 2114686.83525 | 37.7858454563295 | -122.484607119014 | (37.7858454563295, -122.484607119014) | |||
| 127635 | 127635 | 12844 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2334 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/22/2004 12:00:00 AM | 12 | 3X3 | 5988170.1967 | 2114688.1291099996 | 37.7858473064355 | -122.484708351946 | (37.7858473064355, -122.484708351946) | ||
| 100753 | 100753 | 12935 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 6668X 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/01/2012 12:00:00 AM | 12 | 3X3 | Permit Number 769234 | 6012786.96414 | 2089718.1285700002 | 37.718687986142704 | -122.397788483239 | (37.7186879861427, -122.397788483239) | |
| 102888 | 102888 | 12937 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 6668X 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/01/2012 12:00:00 AM | 12 | 3X3 | Permit Number 769234 | 6012764.34579 | 2089682.40405 | 37.7185886341534 | -122.397864161679 | (37.7185886341534, -122.397864161679) | |
| 46603 | 46603 | 12945 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 25 Lillian St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | 6 | 3X3 | 6017779.247832701 | 2094371.1041299999 | 37.7317409092053 | -122.380855284503 | (37.7317409092053, -122.380855284503) | ||
| 88739 | 88739 | 12975 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 813X Bosworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/21/2008 12:00:00 AM | 3 | 3X3 | 6001855.03583 | 2095443.26968 | 37.7337930783426 | -122.435985125326 | (37.7337930783426, -122.435985125326) | ||
| 58957 | 58957 | 13334 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 180X Mansell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/04/2007 12:00:00 AM | 6 | 3x3 | 6011307.378806599 | 2090675.6576073999 | 37.7212346577996 | -122.402970152249 | (37.7212346577996, -122.402970152249) | ||
| 117124 | 117124 | 13335 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 180X Mansell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/05/1997 12:00:00 AM | 3 | 3x3 | 6011307.378806599 | 2090675.6576073999 | 37.7212346577996 | -122.402970152249 | (37.7212346577996, -122.402970152249) | ||
| 12279 | 12279 | 13336 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 201 Mansell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/10/1997 12:00:00 AM | 9 | 3X3 | 6011177.6215699995 | 2090502.44045 | 37.720751792334205 | -122.40340650860901 | (37.7207517923342, -122.403406508609) | ||
| 120693 | 120693 | 13343 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 330X Mansell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/10/2007 12:00:00 AM | 6 | 3x3 | 6010899.8052946 | 2090551.1958461998 | 37.7208701436228 | -122.404370269004 | (37.7208701436228, -122.404370269004) | ||
| 85122 | 85122 | 13344 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 400X Mansell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/15/1999 12:00:00 AM | 3 | 3X3 | 6010720.094806201 | 2090454.3579236 | 37.7205942023632 | -122.40498466222 | (37.7205942023632, -122.40498466222) | ||
| 101318 | 101318 | 13345 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 400X Mansell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/15/1999 12:00:00 AM | 3 | 3X3 | 6010720.094806201 | 2090454.3579236 | 37.7205942023632 | -122.40498466222 | (37.7205942023632, -122.40498466222) | ||
| 109747 | 109747 | 13351 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 455X Mansell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/19/1996 12:00:00 AM | 3 | 3X3 | 6010582.9719844 | 2090313.2894209998 | 37.7201991911465 | -122.405448725144 | (37.7201991911465, -122.405448725144) | ||
| 94637 | 94637 | 13353 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 475X Mansell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/06/2000 12:00:00 AM | 9 | 3X3 | 6010520.0274426 | 2090294.0678992001 | 37.720142893136796 | -122.405664951367 | (37.7201428931368, -122.405664951367) | ||
| 102053 | 102053 | 13363 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 810X Mansell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/10/1992 12:00:00 AM | 6 | 3x6 | 6009474.592829499 | 2090115.9752153999 | 37.7195953714032 | -122.40926612164199 | (37.7195953714032, -122.409266121642) | ||
| 13207 | 13207 | 13370 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 900 Mansell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2003 12:00:00 AM | 10 | 3X50 | 6009179.45689 | 2090013.7342599998 | 37.719298099396894 | -122.410279089032 | (37.7192980993969, -122.410279089032) | ||
| 92208 | 92208 | 13378 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1000X Mansell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 01/13/2000 12:00:00 AM | 3 | 3X3 | 6008956.780581599 | 2089957.5006014 | 37.7191312087569 | -122.411044830527 | (37.7191312087569, -122.411044830527) | ||
| 119188 | 119188 | 13379 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1000X Mansell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3 | 3X3 | 6008956.780581599 | 2089957.5006014 | 37.7191312087569 | -122.411044830527 | (37.7191312087569, -122.411044830527) | |||
| 78664 | 78664 | 13380 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1000X Mansell St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3 | 3X3 | 6008956.780581599 | 2089957.5006014 | 37.7191312087569 | -122.411044830527 | (37.7191312087569, -122.411044830527) | |||
| 126625 | 126625 | 13385 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1000X Mansell St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3 | 3X3 | 6008956.780581599 | 2089957.5006014 | 37.7191312087569 | -122.411044830527 | (37.7191312087569, -122.411044830527) | |||
| 14273 | 14273 | 14873 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1409 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/28/2006 12:00:00 AM | 12 | 3X3 | 6016102.3381 | 2095358.409 | 37.734359155897295 | -122.386721579123 | (37.7343591558973, -122.386721579123) | ||
| 12301 | 12301 | 15694 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 4200 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/19/1995 12:00:00 AM | 10 | 3x3 | 6003454.34297 | 2093966.93362 | 37.7298301192653 | -122.430350548736 | (37.7298301192653, -122.430350548736) | ||
| 22056 | 22056 | 16608 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 106 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 6002826.848230001 | 2107609.5605599997 | 37.7672540005999 | -122.43349442931999 | (37.7672540005999, -122.43349442932) | ||||
| 71279 | 71279 | 16610 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 106 Noe St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2014 12:00:00 AM | 8 | 3x3 | 6002827.08532 | 2107587.4381 | 37.76719327117971 | -122.43349202814801 | (37.7671932711797, -122.433492028148) | ||
| 77959 | 77959 | 16742 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1735X O'Farrell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6003067.524180001 | 2113392.76277 | 37.783146893199394 | -122.433075208633 | (37.7831468931994, -122.433075208633) | |||
| 105261 | 105261 | 16743 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1735X O'Farrell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6003112.88898 | 2113403.1855900004 | 37.7831780847955 | -122.432919009773 | (37.7831780847955, -122.432919009773) | |||
| 9307 | 9307 | 18043 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2817 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/25/2011 12:00:00 AM | 6 | 3x3 | 6000257.4375 | 2114746.9392 | 37.7867053122561 | -122.442894218022 | (37.7867053122561, -122.442894218022) | ||
| 8175 | 8175 | 18056 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2872 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6000171.5399 | 2114786.4403 | 37.7868088744704 | -122.44319424037701 | (37.7868088744704, -122.443194240377) | |||
| 20339 | 20339 | 18573 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 406X Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/08/2005 12:00:00 AM | 7 | 3X3 | 5992946.9206 | 2089859.91497 | 37.7179524645256 | -122.466377230742 | (37.7179524645256, -122.466377230742) | ||
| 17583 | 17583 | 18586 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 307 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3X3 | 5993137.1732 | 2088487.6954 | 37.7141956555284 | -122.46561997911999 | (37.7141956555284, -122.46561997912) | |||
| 23219 | 23219 | 18598 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 446 Randolph St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/25/1996 12:00:00 AM | 1 | 3X3 | 5992801.704 | 2088553.3928 | 37.7143566894868 | -122.466784253638 | (37.7143566894868, -122.466784253638) | ||
| 119679 | 119679 | 18801 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 11X Lillian St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X4 | 6017716.103612999 | 2094281.8506439999 | 37.7314923513917 | -122.381067386029 | (37.7314923513917, -122.381067386029) | ||
| 8295 | 8295 | 18867 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2245 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/16/2014 12:00:00 AM | 3 | 3X3 | 6003997.87429 | 2115967.42809 | 37.790269005258004 | -122.43004029884399 | (37.790269005258, -122.430040298844) | ||
| 7013 | 7013 | 18868 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2245 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/27/2014 12:05:00 PM | 3 | 3X4 | 6004021.14791 | 2115967.48717 | 37.7902704855414 | -122.42995977804199 | (37.7902704855414, -122.429959778042) | ||
| 145606 | 145606 | 19318 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 101 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 5993758.5543723 | 2089809.6356688999 | 37.717861208645296 | -122.46356814314 | (37.7178612086453, -122.46356814314) | |||
| 16942 | 16942 | 19326 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 221 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/08/2000 12:00:00 AM | 3 | 3X3 | 5993385.67 | 2089823.67731 | 37.717878271336396 | -122.46485804827499 | (37.7178782713364, -122.464858048275) | ||
| 17870 | 17870 | 19328 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 233 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/28/2001 12:00:00 AM | 3 | 3x3 | 5993347.44444 | 2089823.33825 | 37.717875136319996 | -122.46499015148001 | (37.71787513632, -122.46499015148) | ||
| 21961 | 21961 | 19330 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 239 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/16/1998 12:00:00 AM | 6 | 3x3 | 5993302.3667 | 2089824.28491 | 37.7178751363023 | -122.46514603277399 | (37.7178751363023, -122.465146032774) | ||
| 99759 | 99759 | 19336 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 409 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/16/1998 12:00:00 AM | 12 | 3X3 | 5992959.4278287 | 2089819.7347793 | 37.717842861108 | -122.46633108054701 | (37.717842861108, -122.466331080547) | ||
| 21289 | 21289 | 19338 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 415 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/2005 12:00:00 AM | 3 | 3X3 | 5992879.00654 | 2089828.9932799998 | 37.717863642070796 | -122.466609731553 | (37.7178636420708, -122.466609731553) | ||
| 11241 | 11241 | 19489 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 355X Mansell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6010833.1058 | 2090397.5651099999 | 37.7204445776412 | -122.40459002092301 | (37.7204445776412, -122.404590020923) | |||
| 15455 | 15455 | 21869 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1900 03rd St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/25/1995 12:00:00 AM | 3 | 3X3 | 6015637.96156 | 2106775.3986299997 | 37.7656820989701 | -122.38912400199301 | (37.7656820989701, -122.389124001993) | ||
| 16251 | 16251 | 21871 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1900 03rd St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/18/2008 12:00:00 AM | 3 | 3X3 | 6015639.475459999 | 2106732.0802700003 | 37.765563240070705 | -122.389115740804 | (37.7655632400707, -122.389115740804) | ||
| 15036 | 15036 | 21873 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1900 03rd St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/25/1995 12:00:00 AM | 3 | 3X3 | 6015642.92121 | 2106680.0028 | 37.765420437641 | -122.38910018611999 | (37.765420437641, -122.38910018612) | ||
| 16291 | 16291 | 21875 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1900 03rd St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/25/1995 12:00:00 AM | 3 | 3X3 | 6015645.87724 | 2106637.96445 | 37.7653051733068 | -122.38908702634701 | (37.7653051733068, -122.389087026347) | ||
| 14175 | 14175 | 21877 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1900 03rd St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/25/1995 12:00:00 AM | 3 | 3X3 | 6015647.435959999 | 2106591.54612 | 37.7651778050355 | -122.389078393773 | (37.7651778050355, -122.389078393773) | ||
| 14201 | 14201 | 21879 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1900 03rd St | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/25/1995 12:00:00 AM | 3 | 3X3 | 6015650.0093 | 2106548.41403 | 37.765059516307296 | -122.38906648134599 | (37.7650595163073, -122.389066481346) | ||
| 92092 | 92092 | 24393 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 699X Junipero Serra Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 5991405.981861901 | 2093130.1790735 | 37.7268427672434 | -122.47194174766199 | (37.7268427672434, -122.471941747662) | ||
| 125729 | 125729 | 24394 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 699X Junipero Serra Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 5991405.981861901 | 2093130.1790735 | 37.7268427672434 | -122.47194174766199 | (37.7268427672434, -122.471941747662) | ||
| 124387 | 124387 | 24396 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 699X Junipero Serra Blvd | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 5991405.981861901 | 2093130.1790735 | 37.7268427672434 | -122.47194174766199 | (37.7268427672434, -122.471941747662) | ||
| 101722 | 101722 | 24397 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 699X Junipero Serra Blvd | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 5991405.981861901 | 2093130.1790735 | 37.7268427672434 | -122.47194174766199 | (37.7268427672434, -122.471941747662) | ||
| 125010 | 125010 | 24410 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1199X Junipero Serra Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 5991174.554565701 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | ||
| 13593 | 13593 | 24443 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1900 03rd St | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2007 12:00:00 AM | 3 | 3X3 | 6015653.1254 | 2106493.0518799997 | 37.7649076765652 | -122.389051837691 | (37.7649076765652, -122.389051837691) | ||
| 86548 | 86548 | 24457 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 999X Junipero Serra Blvd | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 5991260.9047733005 | 2090529.2081036 | 37.719692749400394 | -122.47225375374799 | (37.7196927494004, -122.472253753748) | ||
| 79410 | 79410 | 24459 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1199X Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 5991174.554565701 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | ||
| 94360 | 94360 | 24461 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1199X Junipero Serra Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 5991174.554565701 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | ||
| 9578 | 9578 | 24736 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 7630 Geary Blvd To Point Lobos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/15/2015 12:00:00 AM | 1 | 3x3 | Permit Number 774506 | 5983286.15671 | 2112505.7286099996 | 37.7795694254676 | -122.501443995349 | (37.7795694254676, -122.501443995349) | |
| 145719 | 145719 | 24795 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 7623 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/01/2015 10:36:00 AM | 3 | 3x3 | 5983335.39442 | 2112375.61281 | 37.77921505706129 | -122.501264036739 | (37.7792150570613, -122.501264036739) | ||
| 84524 | 84524 | 25348 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 30X Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/21/1996 12:00:00 AM | 12 | 3X3 | 5997206.49294 | 2091471.76417 | 37.7226230889599 | -122.45177004270398 | (37.7226230889599, -122.451770042704) | ||
| 96493 | 96493 | 25349 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 40X Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/18/2003 12:00:00 AM | 3 | 3X3 | 5997270.77757 | 2091437.16647 | 37.722531773344706 | -122.45154533174801 | (37.7225317733447, -122.451545331748) | ||
| 98562 | 98562 | 25350 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 50X Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/1996 12:00:00 AM | 6 | 3X3 | 5997335.0622 | 2091402.56877 | 37.7224404572995 | -122.451320621345 | (37.7224404572995, -122.451320621345) | ||
| 107656 | 107656 | 25351 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 60 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/1996 12:00:00 AM | 6 | 3X3 | 5997399.34683 | 2091367.97106 | 37.7223491407969 | -122.451095911492 | (37.7223491407969, -122.451095911492) | ||
| 10750 | 10750 | 25354 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 600 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/21/1996 12:00:00 AM | 16 | 3X3 | 5999152.66634 | 2090412.41545 | 37.719825631818296 | -122.44496645924102 | (37.7198256318183, -122.444966459241) | ||
| 11948 | 11948 | 25355 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 600 Geneva Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/2001 12:00:00 AM | 8 | 2X3 | 5999172.673169999 | 2090392.4667 | 37.7197719989595 | -122.44489586965099 | (37.7197719989595, -122.444895869651) | ||
| 11667 | 11667 | 25357 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 826 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/27/1996 12:00:00 AM | 30 | 3X3 | 6000014.56048 | 2089501.0524099998 | 37.7173723892107 | -122.44192182424999 | (37.7173723892107, -122.44192182425) | ||
| 12083 | 12083 | 25360 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 960 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/03/2016 08:23:00 AM | 3 | 3x3 | 6000506.71785 | 2088949.98974 | 37.715887327923795 | -122.440181174736 | (37.7158873279238, -122.440181174736) | ||
| 12666 | 12666 | 25361 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 968 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2013 12:00:00 AM | 3 | 3x3 | 6000527.06071 | 2088936.736 | 37.7158520942878 | -122.44010991066901 | (37.7158520942878, -122.440109910669) | ||
| 12610 | 12610 | 25367 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1034 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/1996 12:00:00 AM | 15 | 3x3 | 6000865.40343 | 2088735.44534 | 37.715318651499096 | -122.438926026914 | (37.7153186514991, -122.438926026914) | ||
| 11956 | 11956 | 25368 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1040 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/1996 12:00:00 AM | 16 | 3X3 | 6000898.99381 | 2088714.73107 | 37.7152636858484 | -122.438808440557 | (37.7152636858484, -122.438808440557) | ||
| 12215 | 12215 | 25370 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1100 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/1996 12:00:00 AM | 14 | 3X3 | 6001209.09194 | 2088530.7104900002 | 37.7147760437566 | -122.43772343639401 | (37.7147760437566, -122.437723436394) | ||
| 12131 | 12131 | 25371 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1128 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/1996 12:00:00 AM | 20 | 3X3 | 6001319.11795 | 2088467.3510200002 | 37.7146083282968 | -122.437338607489 | (37.7146083282968, -122.437338607489) | ||
| 12655 | 12655 | 25376 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1276 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/04/1998 12:00:00 AM | 18 | 3x3 | 6002007.30225 | 2088058.64573 | 37.713525212695295 | -122.43493075454701 | (37.7135252126953, -122.434930754547) | ||
| 10815 | 10815 | 25377 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1300 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/21/1996 12:00:00 AM | 25 | 3X3 | 6002148.44357 | 2087979.2462400002 | 37.7133152120062 | -122.434437247081 | (37.7133152120062, -122.434437247081) | ||
| 10859 | 10859 | 25378 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1306 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/21/1996 12:00:00 AM | 25 | 3X3 | 6002172.85724 | 2087963.34277 | 37.7132729303733 | -122.43435172877301 | (37.7132729303733, -122.434351728773) | ||
| 11077 | 11077 | 25379 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1306 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/2014 12:00:00 AM | 25 | 3x3 | Permit Number 770716 | 6002169.48596 | 2087962.88023 | 37.7132714689796 | -122.434363348013 | (37.7132714689796, -122.434363348013) | |
| 17041 | 17041 | 25380 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1315 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/04/2003 12:00:00 AM | 12 | 3X3 | 6002230.1892099995 | 2088039.8009400002 | 37.713486121789295 | -122.434159032437 | (37.7134861217893, -122.434159032437) | ||
| 119991 | 119991 | 25382 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1261 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/1996 12:00:00 AM | 18 | 3X3 | 6001957.72657 | 2088181.8724900002 | 37.7138607512084 | -122.435110913643 | (37.7138607512084, -122.435110913643) | ||
| 115091 | 115091 | 25383 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1261 Geneva Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/1997 12:00:00 AM | 17 | 3X3 | 6001957.72657 | 2088181.8724900002 | 37.7138607512084 | -122.435110913643 | (37.7138607512084, -122.435110913643) |
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");