trees
725 rows where qCaretaker_id = 6 sorted by Zip Codes
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes ▼ | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 39383 | 27948 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 999 The Embarcadero | 5 | Median : Cutout | Tree | Port 6 | 02/01/2001 12:00:00 AM | 24 | 4X4 | 6012331.2461069 | 2120536.8810451 | 37.8032840604314 | -122.401528548359 | (37.8032840604314, -122.401528548359) | 3 | 1 | 10 | 28860 | 6 | ||
| 39492 | 27959 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 307X The Embarcadero | 3 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 18 | 6013768.7522982 | 2118400.6344275 | 37.7974985415834 | -122.396404150152 | (37.7974985415834, -122.396404150152) | 3 | 1 | 10 | 28860 | 6 | |||
| 39934 | 25796 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 800X The Embarcadero | 10 | Median : Cutout | Tree | Port 6 | 08/30/1996 12:00:00 AM | 36 | 10 | 6012816.95901 | 2119901.25001 | 37.8015658608918 | -122.399803052325 | (37.8015658608918, -122.399803052325) | 3 | 1 | 10 | 28860 | 6 | ||
| 40350 | 27864 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 900X The Embarcadero | 5 | Median : Cutout | Tree | Port 6 | 12/20/2000 12:00:00 AM | 24 | 6012583.0764321 | 2120386.2715162 | 37.8028845715493 | -122.400646489089 | (37.8028845715493, -122.400646489089) | 3 | 1 | 10 | 28860 | 6 | |||
| 40854 | 27817 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 350X The Embarcadero | 16 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 07/15/1994 12:00:00 AM | 12 | 4x4 | 6013785.7946449 | 2118604.8635638 | 37.7980602547356 | -122.396359500707 | (37.7980602547356, -122.396359500707) | 3 | 1 | 10 | 28860 | 6 | ||
| 41379 | 28039 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1400 The Embarcadero | 7 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6011949.43377 | 2121001.73319 | 37.8045391192453 | -122.402882543817 | (37.8045391192453, -122.402882543817) | 3 | 1 | 10 | 28860 | 6 | ||
| 41530 | 27801 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 650X The Embarcadero | 5 | Median : Cutout | Tree | Port 6 | 07/15/1994 12:00:00 AM | 36 | 15 | 6012967.8705311 | 2119824.4474868 | 37.8013633914033 | -122.399275432078 | (37.8013633914033, -122.399275432078) | 3 | 1 | 10 | 28860 | 6 | ||
| 42430 | 25858 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 800X The Embarcadero | 22 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012435.44801 | 2120409.06301 | 37.8029389168163 | -122.401158965062 | (37.8029389168163, -122.401158965062) | 3 | 1 | 10 | 28860 | 6 | ||
| 43793 | 28030 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 10 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014322.16601 | 2117689.87001 | 37.7955777303512 | -122.394439384649 | (37.7955777303512, -122.394439384649) | 4 | 2 | 10 | 28860 | 6 | ||
| 44069 | 25731 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 501X The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 08/15/1996 12:00:00 AM | 16 | 10 | 6013387.7643744 | 2119020.8269614 | 37.7991802341421 | -122.39776600259 | (37.7991802341421, -122.39776600259) | 3 | 1 | 10 | 28860 | 6 | ||
| 44312 | 27834 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 900X The Embarcadero | 7 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/20/2000 12:00:00 AM | 24 | 6012583.0764321 | 2120386.2715162 | 37.8028845715493 | -122.400646489089 | (37.8028845715493, -122.400646489089) | 3 | 1 | 10 | 28860 | 6 | |||
| 44615 | 27840 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 900X The Embarcadero | 13 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/20/2000 12:00:00 AM | 24 | 6012583.0764321 | 2120386.2715162 | 37.8028845715493 | -122.400646489089 | (37.8028845715493, -122.400646489089) | 3 | 1 | 10 | 28860 | 6 | |||
| 45664 | 27819 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 350X The Embarcadero | 18 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 07/15/1994 12:00:00 AM | 12 | 4x4 | 6013785.7946449 | 2118604.8635638 | 37.7980602547356 | -122.396359500707 | (37.7980602547356, -122.396359500707) | 3 | 1 | 10 | 28860 | 6 | ||
| 45682 | 28024 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 4 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014145.30001 | 2117911.22501 | 37.7961756855245 | -122.39506688845 | (37.7961756855245, -122.39506688845) | 3 | 2 | 10 | 28860 | 6 | ||
| 45704 | 27839 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 900X The Embarcadero | 12 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/20/2000 12:00:00 AM | 24 | 6012583.0764321 | 2120386.2715162 | 37.8028845715493 | -122.400646489089 | (37.8028845715493, -122.400646489089) | 3 | 1 | 10 | 28860 | 6 | |||
| 47018 | 27972 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 300 The Embarcadero | 9 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | 3 | 1 | 10 | 28860 | 6 | ||
| 47535 | 25745 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 801X The Embarcadero | 10 | Median : Cutout | Tree | Port 6 | 08/15/1996 12:00:00 AM | 24 | 10 | 6012632.1664062 | 2120088.9827256 | 37.8020710261606 | -122.400455716884 | (37.8020710261606, -122.400455716884) | 3 | 1 | 10 | 28860 | 6 | ||
| 47845 | 27821 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 350X The Embarcadero | 20 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 07/15/1994 12:00:00 AM | 12 | 4x4 | 6013785.7946449 | 2118604.8635638 | 37.7980602547356 | -122.396359500707 | (37.7980602547356, -122.396359500707) | 3 | 1 | 10 | 28860 | 6 | ||
| 48553 | 28021 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 24 | 4x4 | 6014080.19501 | 2118017.56101 | 37.7964640385194 | -122.395299619332 | (37.7964640385194, -122.395299619332) | 3 | 2 | 10 | 28860 | 6 | ||
| 50297 | 25895 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 500X The Embarcadero | 12 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6013445.7547399 | 2119056.6213274 | 37.7992817461076 | -122.397567846492 | (37.7992817461076, -122.397567846492) | 3 | 1 | 10 | 28860 | 6 | ||
| 51400 | 25637 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 550X The Embarcadero | 2 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 6 | 4X4 | 6013263.8234673 | 2119389.8203611 | 37.8001864990432 | -122.398220785892 | (37.8001864990432, -122.398220785892) | 3 | 1 | 10 | 28860 | 6 | ||
| 51959 | 27803 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 650 The Embarcadero | 6 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 07/15/1994 12:00:00 AM | 12 | 4X4 | 6012967.8705311 | 2119824.4474868 | 37.8013633914033 | -122.399275432078 | (37.8013633914033, -122.399275432078) | 3 | 1 | 10 | 28860 | 6 | ||
| 51967 | 25676 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 350X The Embarcadero | 3 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 12 | 4x4 | 6013785.7946449 | 2118604.8635638 | 37.7980602547356 | -122.396359500707 | (37.7980602547356, -122.396359500707) | 3 | 1 | 10 | 28860 | 6 | ||
| 53273 | 25679 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 350X The Embarcadero | 3 | Median : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 36 | 15 | 6013785.7946449 | 2118604.8635638 | 37.7980602547356 | -122.396359500707 | (37.7980602547356, -122.396359500707) | 3 | 1 | 10 | 28860 | 6 | ||
| 53356 | 27992 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 300 The Embarcadero | 29 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | 3 | 1 | 10 | 28860 | 6 | ||
| 54070 | 26030 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 450X The Embarcadero | 2 | Median : Cutout | Tree | Port 6 | 12/01/2000 12:00:00 AM | 36 | 10 | 6014150.34723 | 2117905.13731 | 37.7961592508003 | -122.395048997307 | (37.7961592508003, -122.395048997307) | 3 | 2 | 10 | 28860 | 6 | ||
| 54159 | 27775 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 299X The Embarcadero | 3 | Median : Cutout | Tree | Port 6 | 12/01/2000 12:00:00 AM | 26 | 6013785.1217042 | 2118375.8431165 | 37.797431381421 | -122.396345768748 | (37.797431381421, -122.396345768748) | 3 | 1 | 10 | 28860 | 6 | |||
| 54424 | 27963 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 1101X The Embarcadero | 3 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 36 | 10 | 6012183.0853805 | 2120808.9629681 | 37.8040228629879 | -122.402060405747 | (37.8040228629879, -122.402060405747) | 3 | 1 | 10 | 28860 | 6 | ||
| 54544 | 27988 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 300 The Embarcadero | 25 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | 3 | 1 | 10 | 28860 | 6 | ||
| 55797 | 25655 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 450X The Embarcadero | 8 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6013579.1997782 | 2118911.837786 | 37.7988916345337 | -122.397095919657 | (37.7988916345337, -122.397095919657) | 3 | 1 | 10 | 28860 | 6 | ||
| 55958 | 25651 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 450X The Embarcadero | 4 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6013579.1997782 | 2118911.837786 | 37.7988916345337 | -122.397095919657 | (37.7988916345337, -122.397095919657) | 3 | 1 | 10 | 28860 | 6 | ||
| 56146 | 25865 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 800X The Embarcadero | 29 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012565.65701 | 2120204.63501 | 37.8023848701418 | -122.400694001959 | (37.8023848701418, -122.400694001959) | 3 | 1 | 10 | 28860 | 6 | ||
| 58129 | 25860 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 800X The Embarcadero | 24 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012500.55201 | 2120312.70801 | 37.8026779810822 | -122.400926896266 | (37.8026779810822, -122.400926896266) | 3 | 1 | 10 | 28860 | 6 | ||
| 58562 | 27965 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 300 The Embarcadero | 2 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | 3 | 1 | 10 | 28860 | 6 | ||
| 58595 | 114506 | Undocumented 4 | Maytenus boaria :: Mayten 58 | 10 LOMBARD ST | 1 | Back Yard : Cutout | Tree | Port 6 | 4x4 | 6011932 | 2120995 | 37.8045196580749 | -122.402942401468 | (37.8045196580749, -122.402942401468) | 3 | 1 | 10 | 28860 | 6 | ||||
| 58643 | 25738 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 801X The Embarcadero | 3 | Median : Cutout | Tree | Port 6 | 08/15/1996 12:00:00 AM | 24 | 10 | 6012632.1664062 | 2120088.9827256 | 37.8020710261606 | -122.400455716884 | (37.8020710261606, -122.400455716884) | 3 | 1 | 10 | 28860 | 6 | ||
| 58849 | 27813 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 350X The Embarcadero | 12 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 07/15/1994 12:00:00 AM | 12 | 4x4 | 6013785.7946449 | 2118604.8635638 | 37.7980602547356 | -122.396359500707 | (37.7980602547356, -122.396359500707) | 3 | 1 | 10 | 28860 | 6 | ||
| 59030 | 27777 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 299X The Embarcadero | 5 | Median : Cutout | Tree | Port 6 | 12/01/2000 12:00:00 AM | 26 | 6013785.1217042 | 2118375.8431165 | 37.797431381421 | -122.396345768748 | (37.797431381421, -122.396345768748) | 3 | 1 | 10 | 28860 | 6 | |||
| 59439 | 25653 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 450X The Embarcadero | 6 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6013579.1997782 | 2118911.837786 | 37.7988916345337 | -122.397095919657 | (37.7988916345337, -122.397095919657) | 3 | 1 | 10 | 28860 | 6 | ||
| 59863 | 25861 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 800X The Embarcadero | 25 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012509.66701 | 2120295.78101 | 37.8026320120732 | -122.400894163602 | (37.8026320120732, -122.400894163602) | 3 | 1 | 10 | 28860 | 6 | ||
| 59958 | 25652 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 450X The Embarcadero | 5 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6013579.1997782 | 2118911.837786 | 37.7988916345337 | -122.397095919657 | (37.7988916345337, -122.397095919657) | 3 | 1 | 10 | 28860 | 6 | ||
| 60088 | 25848 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 800X The Embarcadero | 12 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012397.68801 | 2120467.65601 | 37.8030976923846 | -122.401293754953 | (37.8030976923846, -122.401293754953) | 3 | 1 | 10 | 28860 | 6 | ||
| 61254 | 25806 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1300X The Embarcadero | 2 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/15/1995 12:00:00 AM | 6 | 4X4 | 6012234.78854 | 2120695.21971 | 37.8037134372885 | -122.401873481994 | (37.8037134372885, -122.401873481994) | 3 | 1 | 10 | 28860 | 6 | ||
| 61352 | 27964 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 300 The Embarcadero | 1 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | 3 | 1 | 10 | 28860 | 6 | ||
| 62199 | 25837 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 800X The Embarcadero | 1 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6013209.63865 | 2119244.79078 | 37.7997852642353 | -122.398398105913 | (37.7997852642353, -122.398398105913) | 3 | 1 | 10 | 28860 | 6 | ||
| 63391 | 28043 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1400 The Embarcadero | 11 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6012024.04433 | 2120930.34171 | 37.8043472614676 | -122.402619322118 | (37.8043472614676, -122.402619322118) | 3 | 1 | 10 | 28860 | 6 | ||
| 63944 | 25748 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 1301X The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 08/30/1996 12:00:00 AM | 36 | 10 | 6011423.5148387 | 2121491.4283584 | 37.805854321699 | -122.404737040358 | (37.805854321699, -122.404737040358) | 3 | 1 | 10 | 28860 | 23 | ||
| 64082 | 25669 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 450X The Embarcadero | 2 | Median : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 36 | 15 | 6013579.1997782 | 2118911.837786 | 37.7988916345337 | -122.397095919657 | (37.7988916345337, -122.397095919657) | 3 | 1 | 10 | 28860 | 6 | ||
| 65056 | 28016 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 100 The Embarcadero | 13 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 6 | 3X3 | 6014245.12601 | 2117603.06501 | 37.7953351012525 | -122.394699876607 | (37.7953351012525, -122.394699876607) | 4 | 2 | 10 | 28860 | 6 | ||
| 65902 | 28017 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 100 The Embarcadero | 14 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 6 | 3X3 | 6014258.14701 | 2117577.02301 | 37.7952643199629 | -122.394652996927 | (37.7952643199629, -122.394652996927) | 4 | 2 | 10 | 28860 | 6 | ||
| 66998 | 25838 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 800X The Embarcadero | 2 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6013225.30812 | 2119220.74162 | 37.7997201038678 | -122.398342195061 | (37.7997201038678, -122.398342195061) | 3 | 1 | 10 | 28860 | 6 | ||
| 67382 | 25783 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 500X The Embarcadero | 2 | Median : Cutout | Tree | Port 6 | 08/30/1996 12:00:00 AM | 36 | 10 | 6013938.98446 | 2118296.9177 | 37.7972232315271 | -122.395807826386 | (37.7972232315271, -122.395807826386) | 3 | 1 | 10 | 28860 | 6 | ||
| 67552 | 27792 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 199X The Embarcadero | 9 | Median : Cutout | Tree | Port 6 | 12 | 6014015.4653372 | 2118064.3876984 | 37.7965890133894 | -122.395526881953 | (37.7965890133894, -122.395526881953) | 3 | 1 | 10 | 28860 | 6 | ||||
| 68753 | 27861 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 900X The Embarcadero | 2 | Median : Cutout | Tree | Port 6 | 12/20/2000 12:00:00 AM | 24 | 6012583.0764321 | 2120386.2715162 | 37.8028845715493 | -122.400646489089 | (37.8028845715493, -122.400646489089) | 3 | 1 | 10 | 28860 | 6 | |||
| 68825 | 25847 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 800X The Embarcadero | 11 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012388.57301 | 2120483.28101 | 37.8031400863027 | -122.401326396519 | (37.8031400863027, -122.401326396519) | 3 | 1 | 10 | 28860 | 6 | ||
| 69009 | 25650 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 450X The Embarcadero | 3 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6013579.1997782 | 2118911.837786 | 37.7988916345337 | -122.397095919657 | (37.7988916345337, -122.397095919657) | 3 | 1 | 10 | 28860 | 6 | ||
| 70521 | 27863 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 900X The Embarcadero | 4 | Median : Cutout | Tree | Port 6 | 12/20/2000 12:00:00 AM | 24 | 6012583.0764321 | 2120386.2715162 | 37.8028845715493 | -122.400646489089 | (37.8028845715493, -122.400646489089) | 3 | 1 | 10 | 28860 | 6 | |||
| 70893 | 25866 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 800X The Embarcadero | 30 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012586.49001 | 2120179.89601 | 37.8023181047385 | -122.400620170198 | (37.8023181047385, -122.400620170198) | 3 | 1 | 10 | 28860 | 6 | ||
| 71164 | 25660 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 450X The Embarcadero | 13 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6013579.1997782 | 2118911.837786 | 37.7988916345337 | -122.397095919657 | (37.7988916345337, -122.397095919657) | 3 | 1 | 10 | 28860 | 6 | ||
| 71485 | 27847 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 280 The Embarcadero | 8 | Median : Cutout | Tree | Port 6 | 07/15/1994 12:00:00 AM | 36 | 6013933.6105332 | 2118392.9536833 | 37.7974866246707 | -122.395833154489 | (37.7974866246707, -122.395833154489) | 3 | 1 | 10 | 28860 | 6 | |||
| 72591 | 25797 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 800X The Embarcadero | 11 | Median : Cutout | Tree | Port 6 | 08/30/1996 12:00:00 AM | 36 | 10 | 6012870.34401 | 2119824.42701 | 37.8013578993624 | -122.399612917904 | (37.8013578993624, -122.399612917904) | 3 | 1 | 10 | 28860 | 6 | ||
| 73069 | 28001 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 300 The Embarcadero | 5 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | 3 | 1 | 10 | 28860 | 6 | ||
| 74716 | 27997 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 300 The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | 3 | 1 | 10 | 28860 | 6 | ||
| 75860 | 26029 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 499X The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 12/01/2000 12:00:00 AM | 36 | 10 | 6013385.9217822 | 2119009.0450001 | 37.7991477810775 | -122.397771551765 | (37.7991477810775, -122.397771551765) | 3 | 1 | 10 | 28860 | 6 | ||
| 75919 | 25901 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 500X The Embarcadero | 18 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6013445.7547399 | 2119056.6213274 | 37.7992817461076 | -122.397567846492 | (37.7992817461076, -122.397567846492) | 3 | 1 | 10 | 28860 | 6 | ||
| 76157 | 27823 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 350X The Embarcadero | 22 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 07/15/1994 12:00:00 AM | 12 | 4x4 | 6013785.7946449 | 2118604.8635638 | 37.7980602547356 | -122.396359500707 | (37.7980602547356, -122.396359500707) | 3 | 1 | 10 | 28860 | 6 | ||
| 76168 | 27995 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 300 The Embarcadero | 32 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | 3 | 1 | 10 | 28860 | 6 | ||
| 77477 | 28023 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 3 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 24 | 4x4 | 6014119.25801 | 2117944.86201 | 37.7962665966149 | -122.395159357042 | (37.7962665966149, -122.395159357042) | 3 | 2 | 10 | 28860 | 6 | ||
| 78420 | 25828 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 1100X The Embarcadero | 4 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012224.9996834 | 2120852.6389045 | 37.8041451257683 | -122.401918429695 | (37.8041451257683, -122.401918429695) | 3 | 1 | 10 | 28860 | 6 | ||
| 78548 | 25897 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 500X The Embarcadero | 14 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6013445.7547399 | 2119056.6213274 | 37.7992817461076 | -122.397567846492 | (37.7992817461076, -122.397567846492) | 3 | 1 | 10 | 28860 | 6 | ||
| 79273 | 26024 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 899X The Embarcadero | 8 | Median : Cutout | Tree | Port 6 | 12/01/2000 12:00:00 AM | 36 | 10 | 6012483.6012207 | 2120310.1113669 | 37.8026699057947 | -122.400985372375 | (37.8026699057947, -122.400985372375) | 3 | 1 | 10 | 28860 | 6 | ||
| 80135 | 121444 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 400X The Embarcadero | 1 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 3x3 | 6013767 | 2118587 | 37.7980101597556 | -122.396423283327 | (37.7980101597556, -122.396423283327) | 3 | 1 | 10 | 28860 | 6 | ||||
| 80221 | 27782 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 399X The Embarcadero | 5 | Median : Cutout | Tree | Port 6 | 12/01/2000 12:00:00 AM | 24 | 6013580.1568022 | 2118681.7167588 | 37.7982598302065 | -122.397076463892 | (37.7982598302065, -122.397076463892) | 3 | 1 | 10 | 28860 | 6 | |||
| 80549 | 27865 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 900X The Embarcadero | 6 | Median : Cutout | Tree | Port 6 | 12/20/2000 12:00:00 AM | 24 | 6012583.0764321 | 2120386.2715162 | 37.8028845715493 | -122.400646489089 | (37.8028845715493, -122.400646489089) | 3 | 1 | 10 | 28860 | 6 | |||
| 81184 | 26026 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 599X The Embarcadero | 2 | Median : Cutout | Tree | Port 6 | 12/01/2000 12:00:00 AM | 36 | 4X4 | 6012976.7050293 | 2119636.8551197 | 37.8008488002257 | -122.399231684673 | (37.8008488002257, -122.399231684673) | 3 | 1 | 10 | 28860 | 6 | ||
| 83247 | 27970 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 300 The Embarcadero | 7 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | 3 | 1 | 10 | 28860 | 6 | ||
| 83816 | 25854 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 800X The Embarcadero | 18 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012736.380854 | 2120162.4372415 | 37.8022785256437 | -122.400100244504 | (37.8022785256437, -122.400100244504) | 3 | 1 | 10 | 28860 | 6 | ||
| 83886 | 25638 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 550X The Embarcadero | 3 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 6 | 4X4 | 6013263.8234673 | 2119389.8203611 | 37.8001864990432 | -122.398220785892 | (37.8001864990432, -122.398220785892) | 3 | 1 | 10 | 28860 | 6 | ||
| 83896 | 25657 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 450X The Embarcadero | 10 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6013579.1997782 | 2118911.837786 | 37.7988916345337 | -122.397095919657 | (37.7988916345337, -122.397095919657) | 3 | 1 | 10 | 28860 | 6 | ||
| 84613 | 25886 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 500X The Embarcadero | 3 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6013445.7547399 | 2119056.6213274 | 37.7992817461076 | -122.397567846492 | (37.7992817461076, -122.397567846492) | 3 | 1 | 10 | 28860 | 6 | ||
| 85405 | 25673 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 450X The Embarcadero | 6 | Median : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 36 | 15 | 6013579.1997782 | 2118911.837786 | 37.7988916345337 | -122.397095919657 | (37.7988916345337, -122.397095919657) | 3 | 1 | 10 | 28860 | 6 | ||
| 85932 | 25786 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 500X The Embarcadero | 5 | Median : Cutout | Tree | Port 6 | 08/30/1996 12:00:00 AM | 36 | 10 | 6013445.7547399 | 2119056.6213274 | 37.7992817461076 | -122.397567846492 | (37.7992817461076, -122.397567846492) | 3 | 1 | 10 | 28860 | 6 | ||
| 86217 | 27942 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 699 The Embarcadero | 3 | Median : Cutout | Tree | Port 6 | 02/01/2001 12:00:00 AM | 24 | 6012787.5534626 | 2119857.700218 | 37.8014446443351 | -122.399901749617 | (37.8014446443351, -122.399901749617) | 3 | 1 | 10 | 28860 | 6 | |||
| 86437 | 28032 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 12 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014349.29301 | 2117643.21201 | 37.7954511263865 | -122.394342251353 | (37.7954511263865, -122.394342251353) | 4 | 2 | 10 | 28860 | 6 | ||
| 86553 | 27933 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 799 The Embarcadero | 5 | Median : Cutout | Tree | Port 6 | 02/01/2001 12:00:00 AM | 24 | 10 | 6012635.1983488 | 2120084.4698961 | 37.8020588041016 | -122.400444907677 | (37.8020588041016, -122.400444907677) | 3 | 1 | 10 | 28860 | 6 | ||
| 86608 | 25871 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 800X The Embarcadero | 35 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012660.70901 | 2120071.82301 | 37.8020255014061 | -122.400355739262 | (37.8020255014061, -122.400355739262) | 3 | 1 | 10 | 28860 | 6 | ||
| 86611 | 28044 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1400 The Embarcadero | 12 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6012052.65409 | 2120901.81041 | 37.8042705187194 | -122.402518307585 | (37.8042705187194, -122.402518307585) | 3 | 1 | 10 | 28860 | 6 | ||
| 86897 | 27949 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 999 The Embarcadero | 6 | Median : Cutout | Tree | Port 6 | 02/01/2001 12:00:00 AM | 24 | 4X4 | 6012331.2461069 | 2120536.8810451 | 37.8032840604314 | -122.401528548359 | (37.8032840604314, -122.401528548359) | 3 | 1 | 10 | 28860 | 6 | ||
| 87303 | 25735 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 500X The Embarcadero | 5 | Median : Cutout | Tree | Port 6 | 08/15/1996 12:00:00 AM | 16 | 10 | 6013816.07307 | 2118422.78251 | 37.7975619881486 | -122.396241959692 | (37.7975619881486, -122.396241959692) | 3 | 1 | 10 | 28860 | 6 | ||
| 87567 | 27983 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 300 The Embarcadero | 20 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | 3 | 1 | 10 | 28860 | 6 | ||
| 87626 | 25648 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 450X The Embarcadero | 1 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6013579.1997782 | 2118911.837786 | 37.7988916345337 | -122.397095919657 | (37.7988916345337, -122.397095919657) | 3 | 1 | 10 | 28860 | 6 | ||
| 87700 | 25891 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 500X The Embarcadero | 8 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6013445.7547399 | 2119056.6213274 | 37.7992817461076 | -122.397567846492 | (37.7992817461076, -122.397567846492) | 3 | 1 | 10 | 28860 | 6 | ||
| 87702 | 28035 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1400 The Embarcadero | 3 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6011869.41049 | 2121075.03017 | 37.8047359061888 | -122.403164632367 | (37.8047359061888, -122.403164632367) | 3 | 1 | 10 | 28860 | 6 | ||
| 88068 | 27805 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 350X The Embarcadero | 4 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 11/15/2012 12:00:00 AM | 12 | 4x4 | Permit Number 769363 | 6013785.7946449 | 2118604.8635638 | 37.7980602547356 | -122.396359500707 | (37.7980602547356, -122.396359500707) | 3 | 1 | 10 | 28860 | 6 | |
| 88106 | 27780 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 399X The Embarcadero | 3 | Median : Cutout | Tree | Port 6 | 12/01/2000 12:00:00 AM | 24 | 6013580.1568022 | 2118681.7167588 | 37.7982598302065 | -122.397076463892 | (37.7982598302065, -122.397076463892) | 3 | 1 | 10 | 28860 | 6 | |||
| 88662 | 25662 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 450X The Embarcadero | 15 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6013579.1997782 | 2118911.837786 | 37.7988916345337 | -122.397095919657 | (37.7988916345337, -122.397095919657) | 3 | 1 | 10 | 28860 | 6 | ||
| 89590 | 25813 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1300X The Embarcadero | 9 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/15/1995 12:00:00 AM | 6 | 4X4 | 6012345.50187 | 2120516.10099 | 37.8032277988787 | -122.401477754221 | (37.8032277988787, -122.401477754221) | 3 | 1 | 10 | 28860 | 6 | ||
| 89848 | 28013 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 100 The Embarcadero | 10 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 6 | 3X3 | 6014214.74401 | 2117682.27501 | 37.7955509040886 | -122.394810554146 | (37.7955509040886, -122.394810554146) | 4 | 2 | 10 | 28860 | 6 | ||
| 90066 | 25661 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 450X The Embarcadero | 14 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6013579.1997782 | 2118911.837786 | 37.7988916345337 | -122.397095919657 | (37.7988916345337, -122.397095919657) | 3 | 1 | 10 | 28860 | 6 | ||
| 90125 | 25857 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 800X The Embarcadero | 21 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012423.72901 | 2120427.29201 | 37.8029883154529 | -122.40120080082 | (37.8029883154529, -122.40120080082) | 3 | 1 | 10 | 28860 | 6 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );