trees
725 rows where qCaretaker_id = 6 sorted by PlotSize
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 153314 | 27896 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 280 The Embarcadero | 26 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 12 | 6015954.339 | 2112951.913 | 37.7826589785254 | -122.388460864103 | (37.7826589785254, -122.388460864103) | 6 | 2 | 9 | 28856 | 6 | |||
| 154730 | 27776 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 299X The Embarcadero | 4 | 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 | |||
| 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 | |||
| 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 | |||
| 160580 | 27888 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 280 The Embarcadero | 18 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 12 | 6015971.527 | 2113185.767 | 37.7833020414658 | -122.388417728009 | (37.7833020414658, -122.388417728009) | 6 | 2 | 9 | 28856 | 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 | |||
| 164907 | 27872 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 280 The Embarcadero | 2 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 12 | 6016007.985 | 2113618.059 | 37.7844910380962 | -122.388321777832 | (37.7844910380962, -122.388321777832) | 6 | 2 | 9 | 28856 | 6 | |||
| 169962 | 83036 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 100X Cargo Way | 16 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/18/2017 02:55:00 PM | 3 | 6018559.56213 | 2097806.04485 | 37.7412156164156 | -122.378395939846 | (37.7412156164156, -122.378395939846) | 10 | 3 | 8 | 58 | 1 | |||
| 170455 | 27887 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 280 The Embarcadero | 17 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 12 | 6015976.214 | 2113235.246 | 37.7834381593837 | -122.388404967313 | (37.7834381593837, -122.388404967313) | 6 | 2 | 9 | 28856 | 6 | |||
| 174840 | 27881 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 280 The Embarcadero | 11 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 12 | 6015990.277 | 2113394.1 | 37.7838751159548 | -122.388367405327 | (37.7838751159548, -122.388367405327) | 6 | 2 | 9 | 28856 | 6 | |||
| 176605 | 27779 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 399X The Embarcadero | 2 | 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 | |||
| 177473 | 83048 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 4 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 04/10/2017 09:41:00 AM | 3 | 6018843.8838 | 2097592.61577 | 37.7406452501696 | -122.3773980395 | (37.7406452501696, -122.3773980395) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | |||
| 179517 | 27905 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 280 The Embarcadero | 35 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 12 | 6015930.902 | 2112710.767 | 37.7819955470034 | -122.388525109177 | (37.7819955470034, -122.388525109177) | 6 | 2 | 9 | 28856 | 6 | |||
| 181577 | 27774 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 299X The Embarcadero | 2 | Median : Cutout | Tree | Port 6 | 12/10/2000 12:00:00 AM | 26 | 6013785.1217042 | 2118375.8431165 | 37.797431381421 | -122.396345768748 | (37.797431381421, -122.396345768748) | 3 | 1 | 10 | 28860 | 6 | |||
| 181820 | 27873 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 280 The Embarcadero | 3 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 12 | 6016004.86 | 2113595.663 | 37.784429370574 | -122.388331025715 | (37.784429370574, -122.388331025715) | 6 | 2 | 9 | 28856 | 6 | |||
| 182394 | 27874 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 280 The Embarcadero | 4 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 12 | 6016004.339 | 2113576.913 | 37.7843778584344 | -122.388331519124 | (37.7843778584344, -122.388331519124) | 6 | 2 | 9 | 28856 | 6 | |||
| 183096 | 27890 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 280 The Embarcadero | 20 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 12 | 6015967.881 | 2113137.85 | 37.7831702701294 | -122.388426996246 | (37.7831702701294, -122.388426996246) | 6 | 2 | 9 | 28856 | 6 | |||
| 183143 | 27786 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 199X The Embarcadero | 3 | Median : Cutout | Tree | Port 6 | 14 | 6014015.4653372 | 2118064.3876984 | 37.7965890133894 | -122.395526881953 | (37.7965890133894, -122.395526881953) | 3 | 1 | 10 | 28860 | 6 | ||||
| 183882 | 27955 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 107X The Embarcadero | 5 | 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 | |||
| 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 | |||
| 186329 | 27794 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 199X The Embarcadero | 11 | Median : Cutout | Tree | Port 6 | 12 | 6014015.4653372 | 2118064.3876984 | 37.7965890133894 | -122.395526881953 | (37.7965890133894, -122.395526881953) | 3 | 1 | 10 | 28860 | 6 | ||||
| 186680 | 27891 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 280 The Embarcadero | 21 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 12 | 6015966.319 | 2113109.725 | 37.7830929586512 | -122.388430436483 | (37.7830929586512, -122.388430436483) | 6 | 2 | 9 | 28856 | 6 | |||
| 186984 | 27880 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 280 The Embarcadero | 10 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 12 | 6015993.402 | 2113417.017 | 37.7839382140346 | -122.388358193918 | (37.7839382140346, -122.388358193918) | 6 | 2 | 9 | 28856 | 6 | |||
| 187079 | 27831 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 900X The Embarcadero | 4 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/20/2000 12:00:00 AM | 24 | 6013146.80764 | 2119335.33451 | 37.8000303753641 | -122.398621883287 | (37.8000303753641, -122.398621883287) | 3 | 1 | 10 | 28860 | 6 | |||
| 192167 | 27954 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 107X The Embarcadero | 4 | 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 | |||
| 193128 | 27787 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 199X The Embarcadero | 4 | Median : Cutout | Tree | Port 6 | 14 | 6014015.4653372 | 2118064.3876984 | 37.7965890133894 | -122.395526881953 | (37.7965890133894, -122.395526881953) | 3 | 1 | 10 | 28860 | 6 | ||||
| 3522 | 25785 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 500X The Embarcadero | 4 | 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 | ||
| 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 | ||
| 8261 | 25749 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 1301X The Embarcadero | 2 | 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 | ||
| 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 | ||
| 18521 | 25799 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1300X The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 08/30/1996 12:00:00 AM | 36 | 10 | 6012220.09673 | 2120843.1378 | 37.8041187644177 | -122.401934728525 | (37.8041187644177, -122.401934728525) | 3 | 1 | 10 | 28860 | 6 | ||
| 20512 | 25787 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 800X The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 08/30/1996 12:00:00 AM | 36 | 10 | 6012271.38601 | 2120709.84401 | 37.8037556344242 | -122.401747862284 | (37.8037556344242, -122.401747862284) | 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 | ||
| 22781 | 26096 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 499X The Embarcadero | 4 | 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 | ||
| 25206 | 25733 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 501X The Embarcadero | 3 | 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 102544 | 27697 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 1100X The Embarcadero | 2 | Median : Cutout | Tree | Port 6 | 36 | 10 | 6012224.9996834 | 2120852.6389045 | 37.8041451257683 | -122.401918429695 | (37.8041451257683, -122.401918429695) | 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 | ||
| 119938 | 25746 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 1101X The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 08/30/1996 12:00:00 AM | 36 | 10 | 6012183.0853805 | 2120808.9629681 | 37.8040228629879 | -122.402060405747 | (37.8040228629879, -122.402060405747) | 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 | ||
| 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 | ||
| 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 | ||
| 124473 | 25803 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 1300X The Embarcadero | 5 | 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 | ||
| 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 | ||
| 133273 | 25782 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 500X The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 08/15/1996 12:00:00 AM | 36 | 10 | 6013997.3565 | 2118221.08563 | 37.7970182616509 | -122.395600527244 | (37.7970182616509, -122.395600527244) | 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 | ||
| 135433 | 25802 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 1300X The Embarcadero | 4 | 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 | ||
| 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 | ||
| 136776 | 25754 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 1301X The Embarcadero | 7 | 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 | ||
| 139782 | 26031 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 450X The Embarcadero | 3 | Median : Cutout | Tree | Port 6 | 12/01/2000 12:00:00 AM | 36 | 10 | 6014122.12078 | 2117941.09506 | 37.7962564126589 | -122.3951491872 | (37.7962564126589, -122.3951491872) | 3 | 2 | 10 | 28860 | 6 | ||
| 140966 | 25732 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 501X The Embarcadero | 2 | 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 | ||
| 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 | ||
| 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 | |||
| 151371 | 25747 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 1101X The Embarcadero | 2 | Median : Cutout | Tree | Port 6 | 08/30/1996 12:00:00 AM | 36 | 10 | 6012183.0853805 | 2120808.9629681 | 37.8040228629879 | -122.402060405747 | (37.8040228629879, -122.402060405747) | 3 | 1 | 10 | 28860 | 6 | ||
| 152086 | 25734 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 500X The Embarcadero | 4 | Median : Cutout | Tree | Port 6 | 08/15/1996 12:00:00 AM | 16 | 10 | 6013899.49111 | 2118360.18586 | 37.7973947538281 | -122.395948920127 | (37.7973947538281, -122.395948920127) | 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 | ||
| 156810 | 25789 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 800X The Embarcadero | 3 | Median : Cutout | Tree | Port 6 | 08/30/1996 12:00:00 AM | 36 | 10 | 6012378.15701 | 2120553.59401 | 37.8033325675946 | -122.401367385829 | (37.8033325675946, -122.401367385829) | 3 | 1 | 10 | 28860 | 6 | ||
| 156843 | 25750 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 1301X The Embarcadero | 3 | 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 | ||
| 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 | ||
| 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 | ||
| 163556 | 25800 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 1300X The Embarcadero | 2 | 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 | ||
| 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 | ||
| 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 | ||
| 167963 | 25788 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 800X The Embarcadero | 2 | Median : Cutout | Tree | Port 6 | 08/30/1996 12:00:00 AM | 36 | 10 | 6012327.37501 | 2120629.11501 | 37.8035370964877 | -122.401548430804 | (37.8035370964877, -122.401548430804) | 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 | ||
| 172222 | 25751 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 1301X The Embarcadero | 4 | 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 | ||
| 172546 | 25784 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 500X The Embarcadero | 3 | Median : Cutout | Tree | Port 6 | 08/30/1996 12:00:00 AM | 36 | 10 | 6013869.26975 | 2118339.24702 | 37.797335579338 | -122.396052026484 | (37.797335579338, -122.396052026484) | 3 | 1 | 10 | 28860 | 6 | ||
| 183652 | 25801 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 1300X The Embarcadero | 3 | 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 34080 | 25644 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 550X The Embarcadero | 2 | 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 | ||
| 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 | ||
| 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 |
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) );