Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSpecies, qSiteInfo, qCareAssistant, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies ▲ | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5058 | 5058 | 3648 | Private 5 | Aesculus x carnea 'Briotii' :: Ruby Horse Chestnut 233 | 100X Cargo Way | 84 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 05/31/1996 12:00:00 AM | 3 | 3X3 | 6017409.48154 | 2098690.6025 | 37.7435809736936 | -122.382434078367 | (37.7435809736936, -122.382434078367) | ||
| 22310 | 22310 | 3634 | Private 5 | Aesculus x carnea 'Briotii' :: Ruby Horse Chestnut 233 | 100X Cargo Way | 70 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 3X3 | 6017632.60306 | 2098495.95511 | 37.743058833606604 | -122.38164903679899 | (37.7430588336066, -122.381649036799) | |||
| 22333 | 22333 | 3610 | Private 5 | Aesculus x carnea 'Briotii' :: Ruby Horse Chestnut 233 | 100X Cargo Way | 46 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 3X3 | 6018056.230380001 | 2098180.90993 | 37.742217164400294 | -122.380162344118 | (37.7422171644003, -122.380162344118) | |||
| 22334 | 22334 | 3659 | Permitted Site 1 | Aesculus x carnea 'Briotii' :: Ruby Horse Chestnut 233 | 100X Cargo Way | 95 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12 | 3X3 | 6017251.66004 | 2098826.19142 | 37.7439445542915 | -122.38298922628401 | (37.7439445542915, -122.382989226284) | |||
| 22342 | 22342 | 3584 | Permitted Site 1 | Aesculus x carnea 'Briotii' :: Ruby Horse Chestnut 233 | 100X Cargo Way | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/11/1998 12:00:00 AM | 3 | 3X3 | 6018506.82441 | 2097843.80813 | 37.7413163998229 | -122.378580911506 | (37.7413163998229, -122.378580911506) | ||
| 22343 | 22343 | 3657 | Permitted Site 1 | Aesculus x carnea 'Briotii' :: Ruby Horse Chestnut 233 | 100X Cargo Way | 93 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12 | 3X3 | 6017283.49959 | 2098800.9089200003 | 37.7438768929081 | -122.38287737220199 | (37.7438768929081, -122.382877372202) | |||
| 22347 | 22347 | 3647 | Private 5 | Aesculus x carnea 'Briotii' :: Ruby Horse Chestnut 233 | 100X Cargo Way | 83 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 05/31/1996 12:00:00 AM | 3 | 3X3 | 6017425.17191 | 2098677.66921 | 37.7435463281955 | -122.38237892474599 | (37.7435463281955, -122.382378924746) | ||
| 22349 | 22349 | 3626 | Private 5 | Aesculus x carnea 'Briotii' :: Ruby Horse Chestnut 233 | 100X Cargo Way | 62 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12 | 3X3 | 6017765.800369999 | 2098395.89545 | 37.7427914435713 | -122.38118151611201 | (37.7427914435713, -122.381181516112) | |||
| 4983 | 4983 | 83050 | Private 5 | Rhamnus californica :: Coffeeberry Tree 232 | 100X Cargo Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/04/2006 12:00:00 AM | 1 | 6018877.26977 | 2097567.07885 | 37.7405769700435 | -122.377280830842 | (37.7405769700435, -122.377280830842) | |||
| 100382 | 100382 | 115402 | Permitted Site 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 218 Richland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/29/2016 12:00:00 AM | 3 | Permit Number 776284 | 6005779.9 | 2096086.1 | 37.7357803359495 | -122.42246134044301 | (37.7357803359495, -122.422461340443) | ||
| 17841 | 17841 | 28011 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 100 The Embarcadero | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 6 | 3X3 | 6014191.95801 | 2117739.78401 | 37.795707543335 | -122.394893427962 | (37.795707543335, -122.394893427962) | ||
| 19743 | 19743 | 28006 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 100 The Embarcadero | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 6 | 3X3 | 6014086.70601 | 2117927.50101 | 37.7962171170916 | -122.395270777766 | (37.7962171170916, -122.395270777766) | ||
| 50106 | 50106 | 28049 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1800 The Embarcadero | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6008269.10023 | 2122669.5553900003 | 37.808912348093 | -122.41573688061001 | (37.808912348093, -122.41573688061) | ||
| 77301 | 77301 | 27984 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 300 The Embarcadero | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | ||
| 79049 | 79049 | 27992 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 300 The Embarcadero | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | ||
| 80340 | 80340 | 28045 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1800 The Embarcadero | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6008269.10023 | 2122669.5553900003 | 37.808912348093 | -122.41573688061001 | (37.808912348093, -122.41573688061) | ||
| 82042 | 82042 | 27988 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 300 The Embarcadero | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | ||
| 83494 | 83494 | 27972 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 300 The Embarcadero | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | ||
| 84990 | 84990 | 27964 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 300 The Embarcadero | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | ||
| 85161 | 85161 | 27995 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 300 The Embarcadero | 32 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | ||
| 86476 | 86476 | 27965 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 300 The Embarcadero | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | ||
| 87186 | 87186 | 28016 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 100 The Embarcadero | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 6 | 3X3 | 6014245.12601 | 2117603.06501 | 37.7953351012525 | -122.39469987660699 | (37.7953351012525, -122.394699876607) | ||
| 87468 | 87468 | 28050 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1800 The Embarcadero | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6008269.10023 | 2122669.5553900003 | 37.808912348093 | -122.41573688061001 | (37.808912348093, -122.41573688061) | ||
| 88591 | 88591 | 28047 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1800 The Embarcadero | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6008269.10023 | 2122669.5553900003 | 37.808912348093 | -122.41573688061001 | (37.808912348093, -122.41573688061) | ||
| 89834 | 89834 | 27792 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 199X The Embarcadero | 9 | Median : Cutout 11 | Tree 1 | Port 9 | 12 | 6014015.4653372 | 2118064.3876984 | 37.796589013389394 | -122.39552688195299 | (37.7965890133894, -122.395526881953) | ||||
| 89860 | 89860 | 28053 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1800 The Embarcadero | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6008269.10023 | 2122669.5553900003 | 37.808912348093 | -122.41573688061001 | (37.808912348093, -122.41573688061) | ||
| 90823 | 90823 | 28017 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 100 The Embarcadero | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 6 | 3X3 | 6014258.1470099995 | 2117577.0230099997 | 37.7952643199629 | -122.394652996927 | (37.7952643199629, -122.394652996927) | ||
| 91187 | 91187 | 27983 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 300 The Embarcadero | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | ||
| 92114 | 92114 | 27805 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 350X The Embarcadero | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 11/15/2012 12:00:00 AM | 12 | 4x4 | Permit Number 769363 | 6013785.794644901 | 2118604.8635638 | 37.7980602547356 | -122.39635950070699 | (37.7980602547356, -122.396359500707) | |
| 93769 | 93769 | 28013 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 100 The Embarcadero | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 6 | 3X3 | 6014214.74401 | 2117682.27501 | 37.7955509040886 | -122.394810554146 | (37.7955509040886, -122.394810554146) | ||
| 95144 | 95144 | 27970 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 300 The Embarcadero | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | ||
| 95965 | 95965 | 28046 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1800 The Embarcadero | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6008269.10023 | 2122669.5553900003 | 37.808912348093 | -122.41573688061001 | (37.808912348093, -122.41573688061) | ||
| 98050 | 98050 | 28010 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 100 The Embarcadero | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 6 | 3X3 | 6014178.9370099995 | 2117764.74001 | 37.795775342622704 | -122.39494023205098 | (37.7957753426227, -122.394940232051) | ||
| 100789 | 100789 | 27968 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 300 The Embarcadero | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | ||
| 101933 | 101933 | 27789 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 199X The Embarcadero | 6 | Median : Cutout 11 | Tree 1 | Port 9 | 12 | 6014015.4653372 | 2118064.3876984 | 37.796589013389394 | -122.39552688195299 | (37.7965890133894, -122.395526881953) | ||||
| 102195 | 102195 | 28019 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 100 The Embarcadero | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 6 | 3X3 | 6014278.76301 | 2117533.6200099997 | 37.7951462916621 | -122.39457862095301 | (37.7951462916621, -122.394578620953) | ||
| 102650 | 102650 | 27981 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 300 The Embarcadero | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | ||
| 103910 | 103910 | 27980 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 300 The Embarcadero | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | ||
| 104599 | 104599 | 27791 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 199X The Embarcadero | 8 | Median : Cutout 11 | Tree 1 | Port 9 | 12 | 6014015.4653372 | 2118064.3876984 | 37.796589013389394 | -122.39552688195299 | (37.7965890133894, -122.395526881953) | ||||
| 105561 | 105561 | 27989 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 300 The Embarcadero | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | ||
| 106105 | 106105 | 27982 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 300 The Embarcadero | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | ||
| 106311 | 106311 | 27977 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 300 The Embarcadero | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | ||
| 107429 | 107429 | 27969 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 300 The Embarcadero | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | ||
| 108483 | 108483 | 28012 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 100 The Embarcadero | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 6 | 3X3 | 6014204.97801 | 2117711.57201 | 37.7956308037617 | -122.39484639927299 | (37.7956308037617, -122.394846399273) | ||
| 108926 | 108926 | 27974 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 300 The Embarcadero | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | ||
| 109316 | 109316 | 27979 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 300 The Embarcadero | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | ||
| 109379 | 109379 | 27966 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 300 The Embarcadero | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | ||
| 109454 | 109454 | 28004 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 100 The Embarcadero | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 6 | 3X3 | 6014041.13301 | 2117989.3500099997 | 37.7963844052449 | -122.39543280592 | (37.7963844052449, -122.39543280592) | ||
| 109847 | 109847 | 27985 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 300 The Embarcadero | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | ||
| 112303 | 112303 | 27790 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 199X The Embarcadero | 7 | Median : Cutout 11 | Tree 1 | Port 9 | 12 | 6014015.4653372 | 2118064.3876984 | 37.796589013389394 | -122.39552688195299 | (37.7965890133894, -122.395526881953) | ||||
| 112403 | 112403 | 28055 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1800 The Embarcadero | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6008269.10023 | 2122669.5553900003 | 37.808912348093 | -122.41573688061001 | (37.808912348093, -122.41573688061) | ||
| 113231 | 113231 | 27793 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 199X The Embarcadero | 10 | Median : Cutout 11 | Tree 1 | Port 9 | 12 | 6014015.4653372 | 2118064.3876984 | 37.796589013389394 | -122.39552688195299 | (37.7965890133894, -122.395526881953) | ||||
| 114280 | 114280 | 27978 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 300 The Embarcadero | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | ||
| 115291 | 115291 | 28020 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 100 The Embarcadero | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 6 | 3X3 | 6014303.72001 | 2117502.15301 | 37.795061278092 | -122.394490060779 | (37.795061278092, -122.394490060779) | ||
| 115971 | 115971 | 27990 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 300 The Embarcadero | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | ||
| 116371 | 116371 | 28008 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 100 The Embarcadero | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 6 | 3x3 | 6014135.53401 | 2117846.1200099997 | 37.7959963794451 | -122.39509611853599 | (37.7959963794451, -122.395096118536) | ||
| 117864 | 117864 | 27993 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 300 The Embarcadero | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | ||
| 119039 | 119039 | 27987 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 300 The Embarcadero | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | ||
| 119996 | 119996 | 27976 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 300 The Embarcadero | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | ||
| 120292 | 120292 | 27986 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 300 The Embarcadero | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | ||
| 120923 | 120923 | 28005 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 100 The Embarcadero | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 6 | 3X3 | 6014065.00401 | 2117953.54201 | 37.796287412573 | -122.395347696851 | (37.796287412573, -122.395347696851) | ||
| 121190 | 121190 | 27991 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 300 The Embarcadero | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | ||
| 121432 | 121432 | 28052 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1800 The Embarcadero | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6008269.10023 | 2122669.5553900003 | 37.808912348093 | -122.41573688061001 | (37.808912348093, -122.41573688061) | ||
| 121699 | 121699 | 28018 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 100 The Embarcadero | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 6 | 3X3 | 6014268.99801 | 2117554.23701 | 37.795202358224394 | -122.394613854051 | (37.7952023582244, -122.394613854051) | ||
| 122428 | 122428 | 27971 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 300 The Embarcadero | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | ||
| 124163 | 124163 | 28048 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1800 The Embarcadero | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6008269.10023 | 2122669.5553900003 | 37.808912348093 | -122.41573688061001 | (37.808912348093, -122.41573688061) | ||
| 128043 | 128043 | 27975 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 300 The Embarcadero | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | ||
| 128885 | 128885 | 28014 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 100 The Embarcadero | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 6 | 3X3 | 6014226.68001 | 2117656.2330099996 | 37.795480062520205 | -122.394767428538 | (37.7954800625202, -122.394767428538) | ||
| 138547 | 138547 | 27994 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 300 The Embarcadero | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | ||
| 139187 | 139187 | 27973 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 300 The Embarcadero | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | ||
| 139337 | 139337 | 28015 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 100 The Embarcadero | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 6 | 3X3 | 6014236.44501 | 2117630.19201 | 37.795409102976606 | -122.39473181516001 | (37.7954091029766, -122.39473181516) | ||
| 140583 | 140583 | 28007 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 100 The Embarcadero | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 6 | 3X3 | 6014117.08801 | 2117880.84301 | 37.7960906948417 | -122.395162379187 | (37.7960906948417, -122.395162379187) | ||
| 141929 | 141929 | 27794 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 199X The Embarcadero | 11 | Median : Cutout 11 | Tree 1 | Port 9 | 12 | 6014015.4653372 | 2118064.3876984 | 37.796589013389394 | -122.39552688195299 | (37.7965890133894, -122.395526881953) | ||||
| 142720 | 142720 | 28009 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 100 The Embarcadero | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 6 | 3X3 | 6014164.83101 | 2117791.8670099997 | 37.795849042613604 | -122.394990942689 | (37.7958490426136, -122.394990942689) | ||
| 143432 | 143432 | 28051 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1800 The Embarcadero | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6008269.10023 | 2122669.5553900003 | 37.808912348093 | -122.41573688061001 | (37.808912348093, -122.41573688061) | ||
| 144070 | 144070 | 28054 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1800 The Embarcadero | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6008269.10023 | 2122669.5553900003 | 37.808912348093 | -122.41573688061001 | (37.808912348093, -122.41573688061) | ||
| 145048 | 145048 | 27996 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 300 The Embarcadero | 33 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | ||
| 146030 | 146030 | 27967 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 300 The Embarcadero | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | ||
| 724 | 724 | 25734 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 500X The Embarcadero | 4 | Median : Cutout 11 | Tree 1 | Port 9 | 08/15/1996 12:00:00 AM | 16 | 10 | 6013899.49111 | 2118360.1858599996 | 37.7973947538281 | -122.395948920127 | (37.7973947538281, -122.395948920127) | ||
| 1312 | 1312 | 25735 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 500X The Embarcadero | 5 | Median : Cutout 11 | Tree 1 | Port 9 | 08/15/1996 12:00:00 AM | 16 | 10 | 6013816.07307 | 2118422.78251 | 37.7975619881486 | -122.396241959692 | (37.7975619881486, -122.396241959692) | ||
| 1379 | 1379 | 25668 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 450X The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 36 | 15 | 6014174.0749699995 | 2117868.41683 | 37.796059744425996 | -122.394964320767 | (37.796059744426, -122.394964320767) | ||
| 2027 | 2027 | 25628 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 650 The Embarcadero | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6014034.02503 | 2117986.25531 | 37.796375512586 | -122.39545718430401 | (37.796375512586, -122.395457184304) | ||
| 4067 | 4067 | 25799 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 1300X The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 08/30/1996 12:00:00 AM | 36 | 10 | 6012220.09673 | 2120843.1378 | 37.8041187644177 | -122.401934728525 | (37.8041187644177, -122.401934728525) | ||
| 5331 | 5331 | 25671 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 450X The Embarcadero | 4 | Median : Cutout 11 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 36 | 15 | 6014100.8579 | 2117974.29057 | 37.7963463772386 | -122.395225088169 | (37.7963463772386, -122.395225088169) | ||
| 5467 | 5467 | 27939 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 500X The Embarcadero | 8 | Median : Cutout 11 | Tree 1 | Port 9 | 36 | 4X4 | 6013788.66429 | 2118525.16075 | 37.7978415693921 | -122.396343981507 | (37.7978415693921, -122.396343981507) | |||
| 5785 | 5785 | 25798 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100X The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 08/30/1996 12:00:00 AM | 36 | 10 | 6012871.9305 | 2119823.23547 | 37.801354716114 | -122.39960734420201 | (37.801354716114, -122.399607344202) | ||
| 5927 | 5927 | 25672 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 450X The Embarcadero | 5 | Median : Cutout 11 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 36 | 15 | 6014076.201780001 | 2118013.23421 | 37.796451936061295 | -122.39531313361799 | (37.7964519360613, -122.395313133618) | ||
| 6093 | 6093 | 26031 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 450X The Embarcadero | 3 | Median : Cutout 11 | Tree 1 | Port 9 | 12/01/2000 12:00:00 AM | 36 | 10 | 6014122.12078 | 2117941.0950599997 | 37.7962564126589 | -122.39514918719999 | (37.7962564126589, -122.3951491872) | ||
| 6610 | 6610 | 25631 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 650 The Embarcadero | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6014105.621619999 | 2117876.68788 | 37.7960786481665 | -122.395201764263 | (37.7960786481665, -122.395201764263) | ||
| 6748 | 6748 | 26030 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 450X The Embarcadero | 2 | Median : Cutout 11 | Tree 1 | Port 9 | 12/01/2000 12:00:00 AM | 36 | 10 | 6014150.34723 | 2117905.1373099997 | 37.796159250800294 | -122.395048997307 | (37.7961592508003, -122.395048997307) | ||
| 7009 | 7009 | 27938 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 500X The Embarcadero | 7 | Median : Cutout 11 | Tree 1 | Port 9 | 36 | 4X4 | 6013758.52527 | 2118508.2804400004 | 37.7977935429048 | -122.396447087875 | (37.7977935429048, -122.396447087875) | |||
| 7108 | 7108 | 25783 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 500X The Embarcadero | 2 | Median : Cutout 11 | Tree 1 | Port 9 | 08/30/1996 12:00:00 AM | 36 | 10 | 6013938.98446 | 2118296.9177 | 37.7972232315271 | -122.39580782638599 | (37.7972232315271, -122.395807826386) | ||
| 7340 | 7340 | 25782 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 500X The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 08/15/1996 12:00:00 AM | 36 | 10 | 6013997.3565 | 2118221.08563 | 37.7970182616509 | -122.395600527244 | (37.7970182616509, -122.395600527244) | ||
| 8064 | 8064 | 25629 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 650 The Embarcadero | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6014059.75449 | 2117949.14567 | 37.79627504929729 | -122.39536555327801 | (37.7962750492973, -122.395365553278) | ||
| 8404 | 8404 | 25630 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 650 The Embarcadero | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6014084.49775 | 2117912.38554 | 37.7961754907607 | -122.395277359473 | (37.7961754907607, -122.395277359473) | ||
| 8788 | 8788 | 27937 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 500X The Embarcadero | 6 | Median : Cutout 11 | Tree 1 | Port 9 | 36 | 4X4 | 6013847.17816 | 2118440.8928400003 | 37.797613445554205 | -122.396135596873 | (37.7976134455542, -122.396135596873) | |||
| 8987 | 8987 | 25784 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 500X The Embarcadero | 3 | Median : Cutout 11 | Tree 1 | Port 9 | 08/30/1996 12:00:00 AM | 36 | 10 | 6013869.26975 | 2118339.24702 | 37.797335579338004 | -122.396052026484 | (37.797335579338, -122.396052026484) | ||
| 19785 | 19785 | 25785 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 500X The Embarcadero | 4 | Median : Cutout 11 | Tree 1 | Port 9 | 08/30/1996 12:00:00 AM | 36 | 10 | 6013445.7547399 | 2119056.6213273997 | 37.7992817461076 | -122.39756784649201 | (37.7992817461076, -122.397567846492) | ||
| 44570 | 44570 | 27941 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 699 The Embarcadero | 2 | Median : Cutout 11 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 24 | 6012787.5534626 | 2119857.700218 | 37.801444644335106 | -122.399901749617 | (37.8014446443351, -122.399901749617) | |||
| 69372 | 69372 | 25749 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 1301X The Embarcadero | 2 | Median : Cutout 11 | Tree 1 | Port 9 | 08/30/1996 12:00:00 AM | 36 | 10 | 6011423.5148387 | 2121491.4283584 | 37.805854321699 | -122.40473704035801 | (37.805854321699, -122.404737040358) |
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");