trees
725 rows where qCaretaker_id = 6 sorted by XCoord
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||
| 122612 | 25856 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 800X The Embarcadero | 20 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012409.40701 | 2120449.42701 | 37.803048293782 | -122.401251919072 | (37.803048293782, -122.401251919072) | 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 | ||
| 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 | ||
| 7822 | 26018 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 899X The Embarcadero | 2 | 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 | ||
| 35010 | 26023 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 899X The Embarcadero | 7 | 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 | ||
| 38339 | 26022 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 899X The Embarcadero | 6 | 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 | ||
| 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 | ||
| 91496 | 26017 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 899X The Embarcadero | 1 | 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 | ||
| 167274 | 26019 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 899X The Embarcadero | 3 | 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 | ||
| 188941 | 26021 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 899X The Embarcadero | 5 | 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 | ||
| 189449 | 26020 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 899X The Embarcadero | 4 | 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 | ||
| 134320 | 25859 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 800X The Embarcadero | 23 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012484.92701 | 2120334.84401 | 37.8027378895954 | -122.400982523223 | (37.8027378895954, -122.400982523223) | 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 | ||
| 131654 | 25790 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 800X The Embarcadero | 4 | Median : Cutout | Tree | Port 6 | 08/30/1996 12:00:00 AM | 36 | 10 | 6012501.85401 | 2120373.90601 | 37.8028460885889 | -122.400926692934 | (37.8028460885889, -122.400926692934) | 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 | ||
| 119296 | 25862 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 800X The Embarcadero | 26 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012521.38601 | 2120273.64601 | 37.8025718883944 | -122.400852053664 | (37.8025718883944, -122.400852053664) | 3 | 1 | 10 | 28860 | 6 | ||
| 177354 | 25863 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 800X The Embarcadero | 27 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012533.10401 | 2120250.20801 | 37.8025081869215 | -122.40080985566 | (37.8025081869215, -122.40080985566) | 3 | 1 | 10 | 28860 | 6 | ||
| 181437 | 25864 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 800X The Embarcadero | 28 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012543.52101 | 2120234.58301 | 37.8024658654756 | -122.400772709073 | (37.8024658654756, -122.400772709073) | 3 | 1 | 10 | 28860 | 6 | ||
| 157640 | 25791 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 800X The Embarcadero | 5 | Median : Cutout | Tree | Port 6 | 08/30/1996 12:00:00 AM | 36 | 10 | 6012561.75001 | 2120285.36501 | 37.802606317276 | -122.400713196915 | (37.802606317276, -122.400713196915) | 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 | ||
| 33243 | 27860 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 900X The Embarcadero | 1 | 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 | |||
| 36585 | 27837 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 900X The Embarcadero | 10 | 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 93693 | 27838 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 900X The Embarcadero | 11 | 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 | |||
| 119858 | 27836 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 900X The Embarcadero | 9 | 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 | |||
| 126901 | 27833 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 900X The Embarcadero | 6 | 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 | |||
| 129889 | 27862 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 900X The Embarcadero | 3 | 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 | |||
| 162873 | 27835 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 900X The Embarcadero | 8 | 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 | |||
| 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 | ||
| 183579 | 25867 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 800X The Embarcadero | 31 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012598.20901 | 2120160.36501 | 37.8022651309127 | -122.400578243689 | (37.8022651309127, -122.400578243689) | 3 | 1 | 10 | 28860 | 6 | ||
| 30754 | 25792 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 800X The Embarcadero | 6 | Median : Cutout | Tree | Port 6 | 08/30/1996 12:00:00 AM | 36 | 10 | 6012611.22901 | 2120208.54201 | 37.8023981394217 | -122.400536574048 | (37.8023981394217, -122.400536574048) | 3 | 1 | 10 | 28860 | 6 | ||
| 158308 | 25868 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 800X The Embarcadero | 32 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012612.53201 | 2120139.53101 | 37.8022087245701 | -122.400527214502 | (37.8022087245701, -122.400527214502) | 3 | 1 | 10 | 28860 | 6 | ||
| 26319 | 25869 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 800X The Embarcadero | 33 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012630.76101 | 2120113.49001 | 37.8021382388668 | -122.400462302704 | (37.8021382388668, -122.400462302704) | 3 | 1 | 10 | 28860 | 6 | ||
| 28610 | 25736 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 801X The Embarcadero | 1 | 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 | ||
| 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 | ||
| 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 | ||
| 99231 | 25742 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 801X The Embarcadero | 7 | 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 | ||
| 99532 | 25737 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 801X The Embarcadero | 2 | 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 | ||
| 124324 | 25741 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 801X The Embarcadero | 6 | 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 | ||
| 133427 | 25744 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 801X The Embarcadero | 9 | 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 | ||
| 145567 | 25743 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 801X The Embarcadero | 8 | 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 | ||
| 146265 | 27698 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 801X The Embarcadero | 11 | Median : Cutout | Tree | Port 6 | 24 | 10 | 6012632.1664062 | 2120088.9827256 | 37.8020710261606 | -122.400455716884 | (37.8020710261606, -122.400455716884) | 3 | 1 | 10 | 28860 | 6 | |||
| 161637 | 25739 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 801X The Embarcadero | 4 | 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 | ||
| 186350 | 25740 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 801X The Embarcadero | 5 | 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 | ||
| 18148 | 27929 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 799 The Embarcadero | 1 | 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 | ||
| 25850 | 27930 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 799 The Embarcadero | 2 | 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 | ||
| 34341 | 27931 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 799 The Embarcadero | 3 | 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 | ||
| 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 | ||
| 143696 | 27932 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 799 The Embarcadero | 4 | 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 | ||
| 164979 | 27935 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 799 The Embarcadero | 7 | 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 | ||
| 171707 | 27934 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 799 The Embarcadero | 6 | 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 | ||
| 155919 | 25870 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 800X The Embarcadero | 34 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012643.78201 | 2120092.65601 | 37.8020817598664 | -122.400415779263 | (37.8020817598664, -122.400415779263) | 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 | ||
| 124280 | 25793 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 800X The Embarcadero | 7 | Median : Cutout | Tree | Port 6 | 08/30/1996 12:00:00 AM | 36 | 10 | 6012660.70901 | 2120133.02101 | 37.802193536328 | -122.400360040215 | (37.802193536328, -122.400360040215) | 3 | 1 | 10 | 28860 | 6 | ||
| 140728 | 25872 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 800X The Embarcadero | 36 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012680.24001 | 2120040.57301 | 37.8019407855515 | -122.400285956154 | (37.8019407855515, -122.400285956154) | 3 | 1 | 10 | 28860 | 6 | ||
| 95957 | 25873 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 800X The Embarcadero | 37 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012698.46901 | 2120014.53101 | 37.8018702969661 | -122.400221044749 | (37.8018702969661, -122.400221044749) | 3 | 1 | 10 | 28860 | 6 | ||
| 35602 | 25874 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 800X The Embarcadero | 38 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012710.18801 | 2119997.60401 | 37.8018244729495 | -122.400179301768 | (37.8018244729495, -122.400179301768) | 3 | 1 | 10 | 28860 | 6 | ||
| 152632 | 25794 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 800X The Embarcadero | 8 | Median : Cutout | Tree | Port 6 | 08/30/1996 12:00:00 AM | 36 | 10 | 6012712.79201 | 2120057.50001 | 37.8019890781012 | -122.400174499685 | (37.8019890781012, -122.400174499685) | 3 | 1 | 10 | 28860 | 6 | ||
| 184519 | 25875 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 800X The Embarcadero | 39 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012723.20901 | 2119979.37501 | 37.8017751465356 | -122.400132961793 | (37.8017751465356, -122.400132961793) | 3 | 1 | 10 | 28860 | 6 | ||
| 156362 | 25876 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 800X The Embarcadero | 40 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012733.62501 | 2119959.84401 | 37.8017220998814 | -122.400095544948 | (37.8017220998814, -122.400095544948) | 3 | 1 | 10 | 28860 | 6 | ||
| 9595 | 25849 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 800X The Embarcadero | 13 | 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 | ||
| 22946 | 25855 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 800X The Embarcadero | 19 | 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 | ||
| 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 | ||
| 125507 | 25851 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 800X The Embarcadero | 15 | 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 | ||
| 165126 | 25853 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 800X The Embarcadero | 17 | 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 | ||
| 176233 | 25850 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 800X The Embarcadero | 14 | 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 | ||
| 183897 | 25852 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 800X The Embarcadero | 16 | 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 | ||
| 28098 | 25877 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 800X The Embarcadero | 41 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012751.85401 | 2119935.10401 | 37.8016551861664 | -122.400030725403 | (37.8016551861664, -122.400030725403) | 3 | 1 | 10 | 28860 | 6 | ||
| 158954 | 25878 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 800X The Embarcadero | 42 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012763.57301 | 2119911.66701 | 37.8015914871903 | -122.399988525233 | (37.8015914871903, -122.399988525233) | 3 | 1 | 10 | 28860 | 6 | ||
| 22525 | 25795 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 800X The Embarcadero | 9 | Median : Cutout | Tree | Port 6 | 08/30/1996 12:00:00 AM | 36 | 10 | 6012764.87501 | 2119980.67701 | 37.8017810445969 | -122.399988868692 | (37.8017810445969, -122.399988868692) | 3 | 1 | 10 | 28860 | 6 | ||
| 36506 | 25879 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 800X The Embarcadero | 43 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012777.89601 | 2119890.83301 | 37.8015350805856 | -122.399937496957 | (37.8015350805856, -122.399937496957) | 3 | 1 | 10 | 28860 | 6 | ||
| 2509 | 27941 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 699 The Embarcadero | 2 | 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 | |||
| 20840 | 27943 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 699 The Embarcadero | 4 | 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 | |||
| 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 | |||
| 157357 | 27940 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 699 The Embarcadero | 1 | 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 | |||
| 189960 | 25880 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 800X The Embarcadero | 44 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012790.91701 | 2119868.69801 | 37.8014750291394 | -122.399890882882 | (37.8014750291394, -122.399890882882) | 3 | 1 | 10 | 28860 | 6 | ||
| 176880 | 25882 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 800X The Embarcadero | 46 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012807.84401 | 2119847.86501 | 37.8014187704055 | -122.39983084377 | (37.8014187704055, -122.39983084377) | 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 | ||
| 184168 | 25883 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 800X The Embarcadero | 47 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012823.46901 | 2119825.72901 | 37.8013588613344 | -122.39977521873 | (37.8013588613344, -122.39977521873) | 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 | ||
| 136674 | 25798 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1100X The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 08/30/1996 12:00:00 AM | 36 | 10 | 6012871.9305 | 2119823.23547 | 37.801354716114 | -122.399607344202 | (37.801354716114, -122.399607344202) | 3 | 1 | 10 | 28860 | 6 | ||
| 38507 | 25634 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 650X The Embarcadero | 3 | Median : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 36 | 15 | 6012967.8705311 | 2119824.4474868 | 37.8013633914033 | -122.399275432078 | (37.8013633914033, -122.399275432078) | 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 | ||
| 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 | ||
| 102919 | 27802 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 650 The Embarcadero | 5 | 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 | ||
| 143658 | 25635 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 650X The Embarcadero | 4 | Median : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 36 | 15 | 6012967.8705311 | 2119824.4474868 | 37.8013633914033 | -122.399275432078 | (37.8013633914033, -122.399275432078) | 3 | 1 | 10 | 28860 | 6 | ||
| 156624 | 25633 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 650X The Embarcadero | 2 | Median : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 36 | 15 | 6012967.8705311 | 2119824.4474868 | 37.8013633914033 | -122.399275432078 | (37.8013633914033, -122.399275432078) | 3 | 1 | 10 | 28860 | 6 | ||
| 179338 | 25632 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 650X The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 36 | 15 | 6012967.8705311 | 2119824.4474868 | 37.8013633914033 | -122.399275432078 | (37.8013633914033, -122.399275432078) | 3 | 1 | 10 | 28860 | 6 | ||
| 24155 | 26028 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 599X The Embarcadero | 4 | 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 | ||
| 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 | ||
| 137662 | 27936 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 599X The Embarcadero | 5 | Median : Cutout | Tree | Port 6 | 36 | 4X4 | 6012976.7050293 | 2119636.8551197 | 37.8008488002257 | -122.399231684673 | (37.8008488002257, -122.399231684673) | 3 | 1 | 10 | 28860 | 6 | |||
| 189286 | 26027 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 599X The Embarcadero | 3 | 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 | ||
| 190771 | 26025 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 599X The Embarcadero | 1 | 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 |
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) );