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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 80438 | 80438 | 27893 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015963.194 | 2113042.017 | 37.7829068745448 | -122.388436520394 | (37.7829068745448, -122.388436520394) | |||
| 80608 | 80608 | 25651 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 450X The Embarcadero | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6013579.1997782 | 2118911.837786 | 37.7988916345337 | -122.397095919657 | (37.7988916345337, -122.397095919657) | ||
| 80718 | 80718 | 27834 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 900X The Embarcadero | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/20/2000 12:00:00 AM | 24 | 6012583.0764321 | 2120386.2715161997 | 37.8028845715493 | -122.400646489089 | (37.8028845715493, -122.400646489089) | |||
| 80770 | 80770 | 27817 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 350X The Embarcadero | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 07/15/1994 12:00:00 AM | 12 | 4x4 | 6013785.794644901 | 2118604.8635638 | 37.7980602547356 | -122.39635950070699 | (37.7980602547356, -122.396359500707) | ||
| 80801 | 80801 | 27819 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 350X The Embarcadero | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 07/15/1994 12:00:00 AM | 12 | 4x4 | 6013785.794644901 | 2118604.8635638 | 37.7980602547356 | -122.39635950070699 | (37.7980602547356, -122.396359500707) | ||
| 80951 | 80951 | 25637 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 550X The Embarcadero | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 6 | 4X4 | 6013263.823467299 | 2119389.8203611 | 37.8001864990432 | -122.398220785892 | (37.8001864990432, -122.398220785892) | ||
| 81058 | 81058 | 25655 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 450X The Embarcadero | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6013579.1997782 | 2118911.837786 | 37.7988916345337 | -122.397095919657 | (37.7988916345337, -122.397095919657) | ||
| 81408 | 81408 | 27915 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 The Embarcadero | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015885.75101 | 2112369.77501 | 37.7810567572813 | -122.38865750159401 | (37.7810567572813, -122.388657501594) | ||
| 81888 | 81888 | 27821 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 350X The Embarcadero | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 07/15/1994 12:00:00 AM | 12 | 4x4 | 6013785.794644901 | 2118604.8635638 | 37.7980602547356 | -122.39635950070699 | (37.7980602547356, -122.396359500707) | ||
| 82200 | 82200 | 25676 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 350X The Embarcadero | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4x4 | 6013785.794644901 | 2118604.8635638 | 37.7980602547356 | -122.39635950070699 | (37.7980602547356, -122.396359500707) | ||
| 82424 | 82424 | 27839 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 900X The Embarcadero | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/20/2000 12:00:00 AM | 24 | 6012583.0764321 | 2120386.2715161997 | 37.8028845715493 | -122.400646489089 | (37.8028845715493, -122.400646489089) | |||
| 82957 | 82957 | 27840 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 900X The Embarcadero | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/20/2000 12:00:00 AM | 24 | 6012583.0764321 | 2120386.2715161997 | 37.8028845715493 | -122.400646489089 | (37.8028845715493, -122.400646489089) | |||
| 83033 | 83033 | 27803 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 650 The Embarcadero | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 07/15/1994 12:00:00 AM | 12 | 4X4 | 6012967.8705311 | 2119824.4474868 | 37.8013633914033 | -122.399275432078 | (37.8013633914033, -122.399275432078) | ||
| 83311 | 83311 | 27705 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1501X The Embarcadero | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 6010670.1386196995 | 2122042.3573555 | 37.807324899499 | -122.407383090822 | (37.807324899499, -122.407383090822) | ||||
| 83768 | 83768 | 27906 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 36 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015925.694 | 2112692.017 | 37.7819437751015 | -122.38854181744 | (37.7819437751015, -122.38854181744) | |||
| 83992 | 83992 | 25626 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800 The Embarcadero | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6015143.78201 | 2116618.69801 | 37.7926821803134 | -122.391521501856 | (37.7926821803134, -122.391521501856) | ||
| 84010 | 84010 | 27922 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 The Embarcadero | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015798.94501 | 2112218.95001 | 37.7806378144268 | -122.388947276171 | (37.7806378144268, -122.388947276171) | ||
| 84036 | 84036 | 27864 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 900X The Embarcadero | 5 | Median : Cutout 11 | Tree 1 | Port 9 | 12/20/2000 12:00:00 AM | 24 | 6012583.0764321 | 2120386.2715161997 | 37.8028845715493 | -122.400646489089 | (37.8028845715493, -122.400646489089) | |||
| 84193 | 84193 | 25858 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012435.4480099995 | 2120409.0630099997 | 37.802938916816295 | -122.40115896506201 | (37.8029389168163, -122.401158965062) | ||
| 84408 | 84408 | 25895 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 500X The Embarcadero | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6013445.7547399 | 2119056.6213273997 | 37.7992817461076 | -122.39756784649201 | (37.7992817461076, -122.397567846492) | ||
| 85025 | 85025 | 25615 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800 The Embarcadero | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6014865.13601 | 2116922.0830099997 | 37.793499734993894 | -122.39250686670401 | (37.7934997349939, -122.392506866704) | ||
| 85287 | 85287 | 25623 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800 The Embarcadero | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6015040.91701 | 2116748.90601 | 37.793033991285796 | -122.391886530718 | (37.7930339912858, -122.391886530718) | ||
| 85455 | 85455 | 25653 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 450X The Embarcadero | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6013579.1997782 | 2118911.837786 | 37.7988916345337 | -122.397095919657 | (37.7988916345337, -122.397095919657) | ||
| 85492 | 85492 | 27923 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 The Embarcadero | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015780.499009999 | 2112201.5890099998 | 37.780589122550204 | -122.38900987778901 | (37.7805891225502, -122.389009877789) | ||
| 85814 | 85814 | 27885 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015984.5479999995 | 2113289.413 | 37.7835873515787 | -122.388379916552 | (37.7835873515787, -122.388379916552) | |||
| 86119 | 86119 | 25861 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012509.66701 | 2120295.78101 | 37.802632012073204 | -122.400894163602 | (37.8026320120732, -122.400894163602) | ||
| 86353 | 86353 | 25848 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012397.68801 | 2120467.65601 | 37.803097692384604 | -122.401293754953 | (37.8030976923846, -122.401293754953) | ||
| 86606 | 86606 | 27928 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 The Embarcadero | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015611.22801 | 2112036.65901 | 37.7801268774736 | -122.389583949745 | (37.7801268774736, -122.389583949745) | ||
| 86704 | 86704 | 27813 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 350X The Embarcadero | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 07/15/1994 12:00:00 AM | 12 | 4x4 | 6013785.794644901 | 2118604.8635638 | 37.7980602547356 | -122.39635950070699 | (37.7980602547356, -122.396359500707) | ||
| 86722 | 86722 | 25901 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 500X The Embarcadero | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6013445.7547399 | 2119056.6213273997 | 37.7992817461076 | -122.39756784649201 | (37.7992817461076, -122.397567846492) | ||
| 86828 | 86828 | 25818 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1300X The Embarcadero | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/15/1995 12:00:00 AM | 6 | 4X4 | 6011529.7175275 | 2121574.5346243 | 37.8060884463757 | -122.404375360949 | (37.8060884463757, -122.404375360949) | ||
| 86833 | 86833 | 27886 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015979.339 | 2113269.621 | 37.7835327185594 | -122.388396555982 | (37.7835327185594, -122.388396555982) | |||
| 87036 | 87036 | 27900 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015944.964 | 2112842.538 | 37.7823581398375 | -122.388485661103 | (37.7823581398375, -122.388485661103) | |||
| 87440 | 87440 | 25866 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012586.49001 | 2120179.89601 | 37.8023181047385 | -122.400620170198 | (37.8023181047385, -122.400620170198) | ||
| 87777 | 87777 | 25847 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012388.5730099995 | 2120483.28101 | 37.803140086302705 | -122.401326396519 | (37.8031400863027, -122.401326396519) | ||
| 88104 | 88104 | 25650 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 450X The Embarcadero | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6013579.1997782 | 2118911.837786 | 37.7988916345337 | -122.397095919657 | (37.7988916345337, -122.397095919657) | ||
| 88547 | 88547 | 27883 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015986.631 | 2113340.455 | 37.7837276168383 | -122.388376273801 | (37.7837276168383, -122.388376273801) | |||
| 89385 | 89385 | 27863 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 900X The Embarcadero | 4 | Median : Cutout 11 | Tree 1 | Port 9 | 12/20/2000 12:00:00 AM | 24 | 6012583.0764321 | 2120386.2715161997 | 37.8028845715493 | -122.400646489089 | (37.8028845715493, -122.400646489089) | |||
| 90157 | 90157 | 25660 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 450X The Embarcadero | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6013579.1997782 | 2118911.837786 | 37.7988916345337 | -122.397095919657 | (37.7988916345337, -122.397095919657) | ||
| 90241 | 90241 | 27861 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 900X The Embarcadero | 2 | Median : Cutout 11 | Tree 1 | Port 9 | 12/20/2000 12:00:00 AM | 24 | 6012583.0764321 | 2120386.2715161997 | 37.8028845715493 | -122.400646489089 | (37.8028845715493, -122.400646489089) | |||
| 90272 | 90272 | 25652 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 450X The Embarcadero | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6013579.1997782 | 2118911.837786 | 37.7988916345337 | -122.397095919657 | (37.7988916345337, -122.397095919657) | ||
| 90715 | 90715 | 27823 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 350X The Embarcadero | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 07/15/1994 12:00:00 AM | 12 | 4x4 | 6013785.794644901 | 2118604.8635638 | 37.7980602547356 | -122.39635950070699 | (37.7980602547356, -122.396359500707) | ||
| 90808 | 90808 | 25618 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800 The Embarcadero | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6014901.59401 | 2116884.32301 | 37.7933980793798 | -122.392378075877 | (37.7933980793798, -122.392378075877) | ||
| 90852 | 90852 | 25860 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012500.55201 | 2120312.7080099997 | 37.8026779810822 | -122.400926896266 | (37.8026779810822, -122.400926896266) | ||
| 91091 | 91091 | 25822 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1300X The Embarcadero | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/15/1995 12:00:00 AM | 6 | 4X4 | 6011529.7175275 | 2121574.5346243 | 37.8060884463757 | -122.404375360949 | (37.8060884463757, -122.404375360949) | ||
| 91466 | 91466 | 25854 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012736.380854 | 2120162.4372415002 | 37.8022785256437 | -122.40010024450399 | (37.8022785256437, -122.400100244504) | ||
| 92547 | 92547 | 25817 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1300X The Embarcadero | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/15/1995 12:00:00 AM | 6 | 4X4 | 6011529.7175275 | 2121574.5346243 | 37.8060884463757 | -122.404375360949 | (37.8060884463757, -122.404375360949) | ||
| 92649 | 92649 | 25621 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800 The Embarcadero | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6014992.74001 | 2116800.99001 | 37.7931743271891 | -122.39205687118401 | (37.7931743271891, -122.392056871184) | ||
| 92956 | 92956 | 25834 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1100X The Embarcadero | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012224.999683401 | 2120852.6389045 | 37.8041451257683 | -122.401918429695 | (37.8041451257683, -122.401918429695) | ||
| 93059 | 93059 | 121444 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 400X The Embarcadero | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 3x3 | 6013767.0 | 2118587.0 | 37.7980101597556 | -122.39642328332701 | (37.7980101597556, -122.396423283327) | ||||
| 93341 | 93341 | 25642 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 550X The Embarcadero | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 6 | 4X4 | 6013263.823467299 | 2119389.8203611 | 37.8001864990432 | -122.398220785892 | (37.8001864990432, -122.398220785892) | ||
| 93368 | 93368 | 25662 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 450X The Embarcadero | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6013579.1997782 | 2118911.837786 | 37.7988916345337 | -122.397095919657 | (37.7988916345337, -122.397095919657) | ||
| 93395 | 93395 | 27838 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 900X The Embarcadero | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/20/2000 12:00:00 AM | 24 | 6012583.0764321 | 2120386.2715161997 | 37.8028845715493 | -122.400646489089 | (37.8028845715493, -122.400646489089) | |||
| 93427 | 93427 | 27925 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 The Embarcadero | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015664.3970099995 | 2112091.99701 | 37.7802817711748 | -122.38940387795401 | (37.7802817711748, -122.389403877954) | ||
| 93489 | 93489 | 25638 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 550X The Embarcadero | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 6 | 4X4 | 6013263.823467299 | 2119389.8203611 | 37.8001864990432 | -122.398220785892 | (37.8001864990432, -122.398220785892) | ||
| 93631 | 93631 | 27878 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015996.527000001 | 2113472.746 | 37.784091406469 | -122.388351273372 | (37.784091406469, -122.388351273372) | |||
| 93827 | 93827 | 25657 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 450X The Embarcadero | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6013579.1997782 | 2118911.837786 | 37.7988916345337 | -122.397095919657 | (37.7988916345337, -122.397095919657) | ||
| 94071 | 94071 | 25815 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1300X The Embarcadero | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/15/1995 12:00:00 AM | 6 | 4X4 | 6011529.7175275 | 2121574.5346243 | 37.8060884463757 | -122.404375360949 | (37.8060884463757, -122.404375360949) | ||
| 94501 | 94501 | 25661 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 450X The Embarcadero | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6013579.1997782 | 2118911.837786 | 37.7988916345337 | -122.397095919657 | (37.7988916345337, -122.397095919657) | ||
| 94542 | 94542 | 25886 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 500X The Embarcadero | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6013445.7547399 | 2119056.6213273997 | 37.7992817461076 | -122.39756784649201 | (37.7992817461076, -122.397567846492) | ||
| 94559 | 94559 | 27704 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1501X The Embarcadero | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 6010670.1386196995 | 2122042.3573555 | 37.807324899499 | -122.407383090822 | (37.807324899499, -122.407383090822) | ||||
| 94571 | 94571 | 25828 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1100X The Embarcadero | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012224.999683401 | 2120852.6389045 | 37.8041451257683 | -122.401918429695 | (37.8041451257683, -122.401918429695) | ||
| 94742 | 94742 | 27897 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015953.2979999995 | 2112914.413 | 37.782555954267295 | -122.388461847258 | (37.7825559542673, -122.388461847258) | |||
| 94947 | 94947 | 27865 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 900X The Embarcadero | 6 | Median : Cutout 11 | Tree 1 | Port 9 | 12/20/2000 12:00:00 AM | 24 | 6012583.0764321 | 2120386.2715161997 | 37.8028845715493 | -122.400646489089 | (37.8028845715493, -122.400646489089) | |||
| 95176 | 95176 | 121470 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 120X The Embarcadero | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 8 | 4x4 | 6015452.0 | 2116243.0 | 37.7916677028969 | -122.39042878384599 | (37.7916677028969, -122.390428783846) | |||
| 95284 | 95284 | 27898 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015948.61 | 2112884.725 | 37.7824741779053 | -122.388475992994 | (37.7824741779053, -122.388475992994) | |||
| 95459 | 95459 | 25648 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 450X The Embarcadero | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6013579.1997782 | 2118911.837786 | 37.7988916345337 | -122.397095919657 | (37.7988916345337, -122.397095919657) | ||
| 96010 | 96010 | 27926 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 The Embarcadero | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015645.95101 | 2112072.4660099996 | 37.7802271207192 | -122.38946632738501 | (37.7802271207192, -122.389466327385) | ||
| 96156 | 96156 | 25891 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 500X The Embarcadero | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6013445.7547399 | 2119056.6213273997 | 37.7992817461076 | -122.39756784649201 | (37.7992817461076, -122.397567846492) | ||
| 96679 | 96679 | 25871 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 35 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012660.709009999 | 2120071.82301 | 37.8020255014061 | -122.40035573926201 | (37.8020255014061, -122.400355739262) | ||
| 96916 | 96916 | 25857 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012423.72901 | 2120427.29201 | 37.8029883154529 | -122.40120080081999 | (37.8029883154529, -122.40120080082) | ||
| 96988 | 96988 | 25897 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 500X The Embarcadero | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6013445.7547399 | 2119056.6213273997 | 37.7992817461076 | -122.39756784649201 | (37.7992817461076, -122.397567846492) | ||
| 97196 | 97196 | 27892 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015966.319 | 2113080.559 | 37.7830128753765 | -122.388428400104 | (37.7830128753765, -122.388428400104) | |||
| 97787 | 97787 | 25873 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 37 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012698.46901 | 2120014.53101 | 37.8018702969661 | -122.40022104474899 | (37.8018702969661, -122.400221044749) | ||
| 97842 | 97842 | 25889 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 500X The Embarcadero | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6013445.7547399 | 2119056.6213273997 | 37.7992817461076 | -122.39756784649201 | (37.7992817461076, -122.397567846492) | ||
| 97855 | 97855 | 27802 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 650 The Embarcadero | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 07/15/1994 12:00:00 AM | 12 | 4X4 | 6012967.8705311 | 2119824.4474868 | 37.8013633914033 | -122.399275432078 | (37.8013633914033, -122.399275432078) | ||
| 98351 | 98351 | 25663 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 450X The Embarcadero | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6013579.1997782 | 2118911.837786 | 37.7988916345337 | -122.397095919657 | (37.7988916345337, -122.397095919657) | ||
| 99026 | 99026 | 27918 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 The Embarcadero | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015851.02901 | 2112300.33101 | 37.7808641552493 | -122.388772773994 | (37.7808641552493, -122.388772773994) | ||
| 99713 | 99713 | 25641 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 550X The Embarcadero | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 6 | 4X4 | 6013263.823467299 | 2119389.8203611 | 37.8001864990432 | -122.398220785892 | (37.8001864990432, -122.398220785892) | ||
| 100591 | 100591 | 27879 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015993.9229999995 | 2113447.225 | 37.784021187263896 | -122.388358500511 | (37.7840211872639, -122.388358500511) | |||
| 100902 | 100902 | 27706 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1801 The Embarcadero | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 6008269.247115 | 2122709.555122 | 37.8090221854411 | -122.415739206432 | (37.8090221854411, -122.415739206432) | ||||
| 101348 | 101348 | 27884 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015985.589 | 2013289.4130000002 | 37.5090039879895 | -122.38142014589701 | (37.5090039879895, -122.381420145897) | |||
| 101771 | 101771 | 27820 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 350X The Embarcadero | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 07/15/1994 12:00:00 AM | 12 | 4x4 | 6013785.794644901 | 2118604.8635638 | 37.7980602547356 | -122.39635950070699 | (37.7980602547356, -122.396359500707) | ||
| 102002 | 102002 | 27810 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 350X The Embarcadero | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 07/15/1994 12:00:00 AM | 12 | 4x4 | 6013785.794644901 | 2118604.8635638 | 37.7980602547356 | -122.39635950070699 | (37.7980602547356, -122.396359500707) | ||
| 102163 | 102163 | 25654 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 450X The Embarcadero | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6013579.1997782 | 2118911.837786 | 37.7988916345337 | -122.397095919657 | (37.7988916345337, -122.397095919657) | ||
| 102728 | 102728 | 25833 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1100X The Embarcadero | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012224.999683401 | 2120852.6389045 | 37.8041451257683 | -122.401918429695 | (37.8041451257683, -122.401918429695) | ||
| 102906 | 102906 | 27894 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015959.027000001 | 2113012.85 | 37.7828265576108 | -122.388448900144 | (37.7828265576108, -122.388448900144) | |||
| 103119 | 103119 | 25885 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 500X The Embarcadero | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6013445.7547399 | 2119056.6213273997 | 37.7992817461076 | -122.39756784649201 | (37.7992817461076, -122.397567846492) | ||
| 103466 | 103466 | 27818 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 350X The Embarcadero | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 07/15/1994 12:00:00 AM | 12 | 4x4 | 6013785.794644901 | 2118604.8635638 | 37.7980602547356 | -122.39635950070699 | (37.7980602547356, -122.396359500707) | ||
| 103527 | 103527 | 27912 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 The Embarcadero | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015910.70801 | 2112444.6450099996 | 37.781263716620394 | -122.388576389848 | (37.7812637166204, -122.388576389848) | ||
| 103821 | 103821 | 27836 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 900X The Embarcadero | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/20/2000 12:00:00 AM | 24 | 6012583.0764321 | 2120386.2715161997 | 37.8028845715493 | -122.400646489089 | (37.8028845715493, -122.400646489089) | |||
| 104305 | 104305 | 25814 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1300X The Embarcadero | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/15/1995 12:00:00 AM | 6 | 4X4 | 6011529.7175275 | 2121574.5346243 | 37.8060884463757 | -122.404375360949 | (37.8060884463757, -122.404375360949) | ||
| 104379 | 104379 | 25636 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 550X The Embarcadero | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 6 | 4X4 | 6013263.823467299 | 2119389.8203611 | 37.8001864990432 | -122.398220785892 | (37.8001864990432, -122.398220785892) | ||
| 104427 | 104427 | 27901 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015942.36 | 2112820.142 | 37.7822965011504 | -122.38849310613999 | (37.7822965011504, -122.38849310614) | |||
| 104685 | 104685 | 25862 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012521.38601 | 2120273.64601 | 37.8025718883944 | -122.400852053664 | (37.8025718883944, -122.400852053664) | ||
| 104698 | 104698 | 27952 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 107X The Embarcadero | 2 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 6 | 6014670.2880903 | 2117144.019363 | 37.7940982979938 | -122.39319659791501 | (37.7940982979938, -122.393196597915) | |||
| 106687 | 106687 | 25659 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 450X The Embarcadero | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6013579.1997782 | 2118911.837786 | 37.7988916345337 | -122.397095919657 | (37.7988916345337, -122.397095919657) | ||
| 106752 | 106752 | 15087 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 30 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 4X4 | 6014680.683616 | 2116874.398416 | 37.7933585592202 | -122.393141753221 | (37.7933585592202, -122.393141753221) | |||
| 106951 | 106951 | 27956 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 107X The Embarcadero | 6 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 6 | 6014670.2880903 | 2117144.019363 | 37.7940982979938 | -122.39319659791501 | (37.7940982979938, -122.393196597915) | |||
| 107193 | 107193 | 27833 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 900X The Embarcadero | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/20/2000 12:00:00 AM | 24 | 6012583.0764321 | 2120386.2715161997 | 37.8028845715493 | -122.400646489089 | (37.8028845715493, -122.400646489089) |
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");