trees
725 rows where qCaretaker_id = 6 sorted by SiteOrder descending
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 145456 | 27950 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 999 The Embarcadero | 7 | 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 | ||
| 145831 | 27790 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 199X The Embarcadero | 7 | Median : Cutout | Tree | Port 6 | 12 | 6014015.4653372 | 2118064.3876984 | 37.7965890133894 | -122.395526881953 | (37.7965890133894, -122.395526881953) | 3 | 1 | 10 | 28860 | 6 | ||||
| 149272 | 22083 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3240 03rd St | 7 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/07/1995 12:00:00 AM | 3 | 6015972.44529 | 2100358.98918 | 37.7480825346922 | -122.38751940999 | (37.7480825346922, -122.38751940999) | 10 | 3 | 8 | 58 | 1 | |||
| 155785 | 27846 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 280 The Embarcadero | 7 | 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 | |||
| 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 | ||
| 167386 | 27852 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 7 | Median : Cutout | Tree | Port 6 | 07/15/1994 12:00:00 AM | 12 | 3X3 | 6015817.39201 | 2112182.05801 | 37.7805375397414 | -122.388880882265 | (37.7805375397414, -122.388880882265) | 6 | 2 | 9 | 28856 | 20 | ||
| 174733 | 3572 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 7 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 04/10/2017 09:42:00 AM | 3 | 3X3 | 6018980.3390981 | 2097500.2540781 | 37.7403991596993 | -122.376919818221 | (37.7403991596993, -122.376919818221) | 10 | 3 | 8 | 58 | 1 | ||
| 178787 | 27808 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 350X The Embarcadero | 7 | 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 | ||
| 180464 | 27938 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 500X The Embarcadero | 7 | Median : Cutout | Tree | Port 6 | 36 | 4X4 | 6013758.52527 | 2118508.28044 | 37.7977935429048 | -122.396447087875 | (37.7977935429048, -122.396447087875) | 3 | 1 | 10 | 28860 | 6 | |||
| 183471 | 28051 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1800 The Embarcadero | 7 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6008269.10023 | 2122669.55539 | 37.808912348093 | -122.41573688061 | (37.808912348093, -122.41573688061) | 3 | 1 | 10 | 308 | 23 | ||
| 189347 | 27913 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 100 The Embarcadero | 7 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015902.02701 | 2112416.43301 | 37.7811857717037 | -122.388604452195 | (37.7811857717037, -122.388604452195) | 6 | 2 | 9 | 28856 | 20 | ||
| 58070 | 3633 | DPW Maintained 1 | Quercus ilex :: Holly Oak 305 | 100X Cargo Way | 69 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 6 | 3X3 | 6017649.0599 | 2098484.04513 | 37.7430270398604 | -122.381591304811 | (37.7430270398604, -122.381591304811) | 10 | 3 | 8 | 58 | 1 | |||
| 35545 | 3632 | DPW Maintained 1 | Quercus ilex :: Holly Oak 305 | 100X Cargo Way | 68 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 6 | 3X3 | 6017663.5913 | 2098472.76802 | 37.7429968775117 | -122.381540274588 | (37.7429968775117, -122.381540274588) | 10 | 3 | 8 | 58 | 1 | |||
| 96934 | 3631 | DPW Maintained 1 | Quercus ilex :: Holly Oak 305 | 100X Cargo Way | 67 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 05/01/2017 03:27:00 PM | 3 | 3X3 | 6017682.09522 | 2098458.88711 | 37.7429597849556 | -122.381475327351 | (37.7429597849556, -122.381475327351) | 10 | 3 | 8 | 58 | 1 | ||
| 171667 | 3630 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 100X Cargo Way | 66 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12 | 3X3 | 6017698.24794 | 2098446.68655 | 37.7429271764597 | -122.381418626885 | (37.7429271764597, -122.381418626885) | 10 | 3 | 8 | 58 | 1 | |||
| 33883 | 3629 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 100X Cargo Way | 65 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 6 | 3X3 | 6017712.66324 | 2098437.04484 | 37.7429014981049 | -122.381368111942 | (37.7429014981049, -122.381368111942) | 10 | 3 | 8 | 58 | 1 | |||
| 10762 | 3628 | DPW Maintained 1 | Quercus ilex :: Holly Oak 305 | 100X Cargo Way | 64 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 6 | 3X3 | 6017730.69941 | 2098422.13413 | 37.7428615520079 | -122.381304710649 | (37.7428615520079, -122.381304710649) | 10 | 3 | 8 | 58 | 1 | |||
| 163469 | 3627 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 100X Cargo Way | 63 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 04/06/2016 12:00:00 AM | 3 | 3X3 | 6017747.14415 | 2098409.63099 | 37.7428281287262 | -122.381246979566 | (37.7428281287262, -122.381246979566) | 10 | 3 | 8 | 58 | 1 | ||
| 95018 | 3626 | DPW Maintained 1 | Aesculus x carnea 'Briotii' :: Ruby Horse Chestnut 205 | 100X Cargo Way | 62 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12 | 3X3 | 6017765.80037 | 2098395.89545 | 37.7427914435713 | -122.381181516112 | (37.7427914435713, -122.381181516112) | 10 | 3 | 8 | 58 | 1 | |||
| 76120 | 3625 | DPW Maintained 1 | Quercus ilex :: Holly Oak 305 | 100X Cargo Way | 61 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 6 | 3X3 | 6017781.37492 | 2098384.59743 | 37.7427612812112 | -122.38112687781 | (37.7427612812112, -122.38112687781) | 10 | 3 | 8 | 58 | 1 | |||
| 144478 | 3624 | DPW Maintained 1 | Quercus ilex :: Holly Oak 305 | 100X Cargo Way | 60 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 05/01/2017 03:25:00 PM | 3 | 3X3 | 6017797.96297 | 2098371.79437 | 37.7427270422324 | -122.381068630506 | (37.7427270422324, -122.381068630506) | 10 | 3 | 8 | 58 | 1 | ||
| 13681 | 27548 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1301X Illinois St | 6 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 01/05/2001 12:00:00 AM | 8 | 3X3 | 6016173.411126 | 2103023.95301 | 37.7554110972717 | -122.387010312465 | (37.7554110972717, -122.387010312465) | 10 | 3 | 8 | 28856 | 29 | ||
| 14831 | 195631 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 416 The Embarcadero | 6 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 9 | Width 4ft | 6015940.74399 | 2112714.61706 | 37.782006663809 | -122.388491328916 | (37.782006663809, -122.388491328916) | 6 | 2 | 9 | 28856 | 6 | ||
| 17161 | 28026 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 6 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014253.80701 | 2117776.67601 | 37.795812278914 | -122.394682002417 | (37.795812278914, -122.394682002417) | 4 | 2 | 10 | 28860 | 6 | ||
| 18840 | 83046 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 100X Cargo Way | 6 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 1 | 6018811.25128 | 2097616.11187 | 37.740707968002 | -122.377512501614 | (37.740707968002, -122.377512501614) | 10 | 3 | 8 | 58 | 1 | ||||
| 20390 | 25830 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 1100X The Embarcadero | 6 | 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 | ||
| 26774 | 27876 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 280 The Embarcadero | 6 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 12 | 6016002.256 | 2113521.705 | 37.784226154296 | -122.38833487113 | (37.784226154296, -122.38833487113) | 6 | 2 | 9 | 28856 | 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 | ||
| 35731 | 27807 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 350X The Embarcadero | 6 | 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 61953 | 22093 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 3400X 03rd St | 6 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 3 | 3X3 | 6016015.95987 | 2099423.81611 | 37.745517153054 | -122.387303712363 | (37.745517153054, -122.387303712363) | 10 | 3 | 8 | 58 | 1 | |||
| 63150 | 28050 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1800 The Embarcadero | 6 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6008269.10023 | 2122669.55539 | 37.808912348093 | -122.41573688061 | (37.808912348093, -122.41573688061) | 3 | 1 | 10 | 308 | 23 | ||
| 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 | |||
| 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 | ||
| 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 | ||
| 91415 | 25682 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 350X The Embarcadero | 6 | 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 | ||
| 94659 | 28038 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1400 The Embarcadero | 6 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6011930.42206 | 2121019.16916 | 37.8045859325698 | -122.402949563068 | (37.8045859325698, -122.402949563068) | 3 | 1 | 10 | 28860 | 6 | ||
| 97148 | 25842 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 800X The Embarcadero | 6 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6013279.13707 | 2119139.97441 | 37.7995013347818 | -122.398150256355 | (37.7995013347818, -122.398150256355) | 3 | 1 | 10 | 28860 | 6 | ||
| 101136 | 27845 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 280 The Embarcadero | 6 | 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 | |||
| 101265 | 27778 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 299X The Embarcadero | 6 | 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 | |||
| 105336 | 27540 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1300 Illinois St | 6 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 01/24/2004 12:00:00 AM | 15 | 3X3 | 6016127.14698 | 2102787.87807 | 37.7547603233662 | -122.38715384385 | (37.7547603233662, -122.38715384385) | 10 | 3 | 8 | 28856 | 29 | ||
| 109758 | 25889 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 500X The Embarcadero | 6 | 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 | ||
| 110174 | 27789 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 199X The Embarcadero | 6 | Median : Cutout | Tree | Port 6 | 12 | 6014015.4653372 | 2118064.3876984 | 37.7965890133894 | -122.395526881953 | (37.7965890133894, -122.395526881953) | 3 | 1 | 10 | 28860 | 6 | ||||
| 110261 | 25641 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 550X The Embarcadero | 6 | 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 | ||
| 110967 | 27912 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 100 The Embarcadero | 6 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015910.70801 | 2112444.64501 | 37.7812637166204 | -122.388576389848 | (37.7812637166204, -122.388576389848) | 6 | 2 | 9 | 28856 | 20 | ||
| 123037 | 25810 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1300X The Embarcadero | 6 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/15/1995 12:00:00 AM | 6 | 4X4 | 6012292.79565 | 2120604.39505 | 37.8034672919492 | -122.401666356441 | (37.8034672919492, -122.401666356441) | 3 | 1 | 10 | 28860 | 6 | ||
| 124002 | 25804 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 1300X The Embarcadero | 6 | Median : Cutout | Tree | Port 6 | 08/30/1996 12:00:00 AM | 36 | 10 | 6011529.7175275 | 2121574.5346243 | 37.8060884463757 | -122.404375360949 | (37.8060884463757, -122.404375360949) | 3 | 1 | 10 | 308 | 23 | ||
| 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 | ||
| 124639 | 27956 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 107X The Embarcadero | 6 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 6 | 6014670.2880903 | 2117144.019363 | 37.7940982979938 | -122.393196597915 | (37.7940982979938, -122.393196597915) | 12 | 2 | 10 | 28855 | 6 | |||
| 125818 | 27969 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 300 The Embarcadero | 6 | 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 | ||
| 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 | |||
| 129077 | 28002 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 300 The Embarcadero | 6 | 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 | ||
| 140014 | 27804 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 550X The Embarcadero | 6 | Median : Cutout | Tree | Port 6 | 07/15/1994 12:00:00 AM | 36 | 15 | 6013263.8234673 | 2119389.8203611 | 37.8001864990432 | -122.398220785892 | (37.8001864990432, -122.398220785892) | 3 | 1 | 10 | 28860 | 6 | ||
| 143845 | 25620 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 800 The Embarcadero | 6 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6014974.51101 | 2116817.91701 | 37.793219792707 | -122.392121129495 | (37.793219792707, -122.392121129495) | 12 | 2 | 9 | 28855 | 6 | ||
| 145935 | 27555 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1299X Illinois St | 6 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/10/1999 12:00:00 AM | 12 | 3X3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) | 10 | 3 | 8 | 28856 | 29 | ||
| 147220 | 27937 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 500X The Embarcadero | 6 | Median : Cutout | Tree | Port 6 | 36 | 4X4 | 6013847.17816 | 2118440.89284 | 37.7976134455542 | -122.396135596873 | (37.7976134455542, -122.396135596873) | 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 | ||
| 171833 | 27851 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 6 | Median : Cutout | Tree | Port 6 | 07/15/1994 12:00:00 AM | 12 | 3X3 | 6015857.53901 | 2112236.31101 | 37.7806887314792 | -122.388745782008 | (37.7806887314792, -122.388745782008) | 6 | 2 | 9 | 28856 | 20 | ||
| 178405 | 27783 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 399X The Embarcadero | 6 | 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 | |||
| 178553 | 3571 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 100X Cargo Way | 6 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/01/2006 12:00:00 AM | 3 | 3X3 | 6018980.3390981 | 2097500.2540781 | 37.7403991596993 | -122.376919818221 | (37.7403991596993, -122.376919818221) | 10 | 3 | 8 | 58 | 1 | ||
| 181478 | 28009 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 100 The Embarcadero | 6 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 6 | 3X3 | 6014164.83101 | 2117791.86701 | 37.7958490426136 | -122.394990942689 | (37.7958490426136, -122.394990942689) | 4 | 1 | 10 | 28860 | 6 | ||
| 185888 | 27962 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 307X The Embarcadero | 6 | 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 | |||
| 190203 | 25753 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 1301X The Embarcadero | 6 | 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 | ||
| 140989 | 3623 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 100X Cargo Way | 59 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6017813.51979 | 2098359.75553 | 37.7426948446985 | -122.38101400211 | (37.7426948446985, -122.38101400211) | 10 | 3 | 8 | 58 | 1 | ||
| 7035 | 3622 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 58 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 6 | 3X3 | 6017832.21147 | 2098347.65106 | 37.7426626399605 | -122.380948529647 | (37.7426626399605, -122.380948529647) | 10 | 3 | 8 | 58 | 1 | |||
| 94243 | 3621 | DPW Maintained 1 | Quercus ilex :: Holly Oak 305 | 100X Cargo Way | 57 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 05/01/2017 03:22:00 PM | 3 | 3X3 | 6017849.66978 | 2098333.64293 | 37.7426251400454 | -122.380887189608 | (37.7426251400454, -122.380887189608) | 10 | 3 | 8 | 58 | 1 | ||
| 99580 | 3620 | DPW Maintained 1 | Quercus ilex :: Holly Oak 305 | 100X Cargo Way | 56 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 05/01/2017 03:20:00 PM | 3 | 3X3 | 6017867.03936 | 2098322.52996 | 37.7425955847281 | -122.380826357655 | (37.7425955847281, -122.380826357655) | 10 | 3 | 8 | 58 | 1 | ||
| 132588 | 3619 | DPW Maintained 1 | Quercus ilex :: Holly Oak 305 | 100X Cargo Way | 55 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 6 | 3X3 | 6017883.84962 | 2098309.76703 | 37.7425614680523 | -122.380767345063 | (37.7425614680523, -122.380767345063) | 10 | 3 | 8 | 58 | 1 | |||
| 70222 | 3618 | DPW Maintained 1 | Quercus ilex :: Holly Oak 305 | 100X Cargo Way | 54 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12 | 3X3 | 6017899.85524 | 2098296.735 | 37.7425265680461 | -122.380711096061 | (37.7425265680461, -122.380711096061) | 10 | 3 | 8 | 58 | 1 | |||
| 146418 | 3617 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 100X Cargo Way | 53 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 05/01/2017 03:16:00 PM | 3 | 3X3 | 6017937.25359 | 2098269.56212 | 37.7424540206388 | -122.380579893948 | (37.7424540206388, -122.380579893948) | 10 | 3 | 8 | 58 | 1 | ||
| 124660 | 3616 | Permitted Site 7 | Quercus ilex :: Holly Oak 305 | 100X Cargo Way | 52 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12 | 3X3 | 6017954.33608 | 2098256.07975 | 37.7424179434233 | -122.380519890289 | (37.7424179434233, -122.380519890289) | 10 | 3 | 8 | 58 | 1 | |||
| 107143 | 3615 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 100X Cargo Way | 51 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6017970.88261 | 2098244.46459 | 37.7423869635862 | -122.380461869644 | (37.7423869635862, -122.380461869644) | 10 | 3 | 8 | 58 | 1 | ||
| 112320 | 3614 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 50 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12 | 3X3 | 6017985.84349 | 2098232.4529 | 37.7423548074344 | -122.380409304248 | (37.7423548074344, -122.380409304248) | 10 | 3 | 8 | 58 | 1 | |||
| 9221 | 28049 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1800 The Embarcadero | 5 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6008269.10023 | 2122669.55539 | 37.808912348093 | -122.41573688061 | (37.808912348093, -122.41573688061) | 3 | 1 | 10 | 308 | 23 | ||
| 9540 | 83049 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 100X Cargo Way | 5 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 11 | 6018864.16071 | 2097578.25634 | 37.7406069390666 | -122.377326932804 | (37.7406069390666, -122.377326932804) | 10 | 3 | 8 | 58 | 1 | ||||
| 28206 | 28025 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 5 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014170.25601 | 2117873.24701 | 37.7960727946079 | -122.394977873693 | (37.7960727946079, -122.394977873693) | 3 | 2 | 10 | 28860 | 6 | ||
| 35250 | 25647 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 550X The Embarcadero | 5 | Median : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 36 | 15 | 6013263.8234673 | 2119389.8203611 | 37.8001864990432 | -122.398220785892 | (37.8001864990432, -122.398220785892) | 3 | 1 | 10 | 28860 | 6 | ||
| 35347 | 3691 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 200X Cargo Way | 5 | Median : Cutout | Tree | Port 6 | 12 | 8 | 6017218.5539168 | 2098854.5663776 | 37.7440206368399 | -122.383105675332 | (37.7440206368399, -122.383105675332) | 10 | 3 | 8 | 58 | 1 | |||
| 35877 | 27875 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 280 The Embarcadero | 5 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 12 | 6016001.735 | 2113547.225 | 37.7842961975919 | -122.388338455378 | (37.7842961975919, -122.388338455378) | 6 | 2 | 9 | 28856 | 6 | |||
| 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 | ||
| 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 | |||
| 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 | ||
| 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 | |||
| 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 | ||
| 64821 | 27539 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1300 Illinois St | 5 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/30/2006 12:00:00 AM | 6 | 3X3 | 6016127.14698 | 2102787.87807 | 37.7547603233662 | -122.38715384385 | (37.7547603233662, -122.38715384385) | 10 | 3 | 8 | 28856 | 29 | ||
| 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 | ||
| 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 | |||
| 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 | ||
| 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 | ||
| 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 | ||
| 88902 | 27870 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 800 The Embarcadero | 5 | Median : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 24 | 4X4 | 6015155.50001 | 2116672.08301 | 37.7928294135533 | -122.391484690649 | (37.7928294135533, -122.391484690649) | 12 | 2 | 9 | 28855 | 6 | ||
| 94059 | 28037 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1400 The Embarcadero | 5 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6011908.75369 | 2121039.95348 | 37.8046417912539 | -122.403026011743 | (37.8046417912539, -122.403026011743) | 3 | 1 | 10 | 28860 | 6 | ||
| 95726 | 27968 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 300 The Embarcadero | 5 | 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 | ||
| 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 | ||
| 104870 | 22081 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3240 03rd St | 5 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/07/1995 12:00:00 AM | 3 | 3X3 | 6015967.58513 | 2100424.02181 | 37.7482608315927 | -122.387540752722 | (37.7482608315927, -122.387540752722) | 10 | 3 | 8 | 58 | 1 | ||
| 109278 | 3570 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 100X Cargo Way | 5 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12 | 3X3 | 6018980.3390981 | 2097500.2540781 | 37.7403991596993 | -122.376919818221 | (37.7403991596993, -122.376919818221) | 10 | 3 | 8 | 58 | 1 | |||
| 109754 | 25809 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1300X The Embarcadero | 5 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/15/1995 12:00:00 AM | 6 | 4X4 | 6012278.63673 | 2120626.00413 | 37.8035258351232 | -122.40171687406 | (37.8035258351232, -122.40171687406) | 3 | 1 | 10 | 28860 | 6 | ||
| 109952 | 25752 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 1301X The Embarcadero | 5 | 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 |
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) );