trees
725 rows where qCaretaker_id = 6 sorted by Supervisor Districts
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 87271 | 27884 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 280 The Embarcadero | 14 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 12 | 6015985.589 | 2013289.413 | 37.5090039879895 | -122.381420145897 | (37.5090039879895, -122.381420145897) | 28590 | |||||||
| 129891 | 106680 | Permitted Site 7 | Tree(s) :: 17 | 2200 LYON ST | 2 | Sidewalk: Curb side : Cutout | Tree | Port 6 | Private | 06/24/2014 12:00:00 AM | 20 | 3x3 | Permit Number 773028 | 5999398.2 | 2116386.7 | 37.7911586409716 | -122.445984946853 | (37.7911586409716, -122.445984946853) | 13 | 6 | 1 | 29490 | 27 |
| 1742 | 28048 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1800 The Embarcadero | 4 | 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 | ||
| 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 | |||
| 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 | ||
| 6693 | 25675 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 350X The Embarcadero | 2 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 12 | 4x4 | 6013785.7946449 | 2118604.8635638 | 37.7980602547356 | -122.396359500707 | (37.7980602547356, -122.396359500707) | 3 | 1 | 10 | 28860 | 6 | ||
| 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 | ||
| 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 | ||
| 9326 | 27814 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 350X The Embarcadero | 13 | 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 | ||
| 9569 | 25843 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 800X The Embarcadero | 7 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6013291.71436 | 2119122.7738 | 37.7994548065492 | -122.398105526769 | (37.7994548065492, -122.398105526769) | 3 | 1 | 10 | 28860 | 6 | ||
| 9581 | 28011 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 100 The Embarcadero | 8 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 6 | 3X3 | 6014191.95801 | 2117739.78401 | 37.795707543335 | -122.394893427962 | (37.795707543335, -122.394893427962) | 4 | 2 | 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 | ||
| 11134 | 28042 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1400 The Embarcadero | 10 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6012004.18493 | 2120947.51548 | 37.804393307678 | -122.4026892561 | (37.804393307678, -122.4026892561) | 3 | 1 | 10 | 28860 | 6 | ||
| 11651 | 28006 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 100 The Embarcadero | 3 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 6 | 3X3 | 6014086.70601 | 2117927.50101 | 37.7962171170916 | -122.395270777766 | (37.7962171170916, -122.395270777766) | 3 | 2 | 10 | 28860 | 6 | ||
| 16204 | 114507 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 10 LOMBARD ST | 2 | Back Yard : Cutout | Tree | Port 6 | 4x4 | 6011932 | 2120995 | 37.8045196580749 | -122.402942401468 | (37.8045196580749, -122.402942401468) | 3 | 1 | 10 | 28860 | 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 | ||
| 17327 | 25839 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 800X The Embarcadero | 3 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6013239.73897 | 2119198.12663 | 37.7996588123662 | -122.398290671092 | (37.7996588123662, -122.398290671092) | 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 | ||
| 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 | ||
| 20337 | 28014 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 100 The Embarcadero | 11 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 6 | 3X3 | 6014226.68001 | 2117656.23301 | 37.7954800625202 | -122.394767428538 | (37.7954800625202, -122.394767428538) | 4 | 2 | 10 | 28860 | 6 | ||
| 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 | ||
| 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 | ||
| 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 | |||
| 20863 | 25816 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 1300X The Embarcadero | 12 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/15/1995 12:00:00 AM | 6 | 4X4 | 6011529.7175275 | 2121574.5346243 | 37.8060884463757 | -122.404375360949 | (37.8060884463757, -122.404375360949) | 3 | 1 | 10 | 308 | 23 | ||
| 21026 | 114508 | Undocumented 4 | Maytenus boaria :: Mayten 58 | 10 LOMBARD ST | 3 | Back Yard : Cutout | Tree | Port 6 | 4x4 | 6011932 | 2120995 | 37.8045196580749 | -122.402942401468 | (37.8045196580749, -122.402942401468) | 3 | 1 | 10 | 28860 | 6 | ||||
| 21464 | 25831 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 1100X The Embarcadero | 7 | 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 | ||
| 21692 | 25812 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1300X The Embarcadero | 8 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/15/1995 12:00:00 AM | 6 | 4X4 | 6012332.09199 | 2120538.66398 | 37.803289003136 | -122.401525746517 | (37.803289003136, -122.401525746517) | 3 | 1 | 10 | 28860 | 6 | ||
| 22521 | 25890 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 500X The Embarcadero | 7 | 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 | ||
| 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 | ||
| 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 | ||
| 23736 | 25826 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 1100X The Embarcadero | 2 | 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 | ||
| 23927 | 27766 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 399X The Embarcadero | 1 | 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 | |||
| 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 | ||
| 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 | ||
| 25228 | 27953 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 107X The Embarcadero | 3 | 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 | |||
| 25332 | 25835 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 1100X The Embarcadero | 11 | 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 | ||
| 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 | ||
| 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 | ||
| 27053 | 28041 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1400 The Embarcadero | 9 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6011990.99673 | 2120961.47906 | 37.8044309119265 | -122.402735877865 | (37.8044309119265, -122.402735877865) | 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 | ||
| 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 | ||
| 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 | ||
| 28642 | 27958 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 307X The Embarcadero | 2 | 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 | |||
| 29089 | 27944 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 999 The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 24 | 4X4 | 6012331.2461069 | 2120536.8810451 | 37.8032840604314 | -122.401528548359 | (37.8032840604314, -122.401528548359) | 3 | 1 | 10 | 28860 | 6 | |||
| 29819 | 27975 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 300 The Embarcadero | 12 | 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 | ||
| 30214 | 25674 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 350X The Embarcadero | 1 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 12 | 4x4 | 6013785.7946449 | 2118604.8635638 | 37.7980602547356 | -122.396359500707 | (37.7980602547356, -122.396359500707) | 3 | 1 | 10 | 28860 | 6 | ||
| 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 | ||
| 32127 | 25894 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 500X The Embarcadero | 11 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/30/1996 12:00:00 AM | 6 | 4X4 | 6013445.7547399 | 2119056.6213274 | 37.7992817461076 | -122.397567846492 | (37.7992817461076, -122.397567846492) | 3 | 1 | 10 | 28860 | 6 | ||
| 32522 | 28040 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1400 The Embarcadero | 8 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6011973.34792 | 2120976.9306 | 37.8044723526732 | -122.402798040815 | (37.8044723526732, -122.402798040815) | 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 | |||
| 33497 | 27984 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 300 The Embarcadero | 21 | 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 | ||
| 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 | ||
| 34314 | 25821 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 1300X The Embarcadero | 17 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/15/1995 12:00:00 AM | 6 | 4X4 | 6011529.7175275 | 2121574.5346243 | 37.8060884463757 | -122.404375360949 | (37.8060884463757, -122.404375360949) | 3 | 1 | 10 | 308 | 23 | ||
| 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 | ||
| 34864 | 25666 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 450X The Embarcadero | 19 | 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | |||
| 36777 | 27795 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 900X The Embarcadero | 1 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 24 | 6013107.19159 | 2119396.29372 | 37.8001955475498 | -122.398763251324 | (37.8001955475498, -122.398763251324) | 3 | 1 | 10 | 28860 | 6 | |||
| 37127 | 25820 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 1300X The Embarcadero | 16 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/15/1995 12:00:00 AM | 6 | 4X4 | 6011529.7175275 | 2121574.5346243 | 37.8060884463757 | -122.404375360949 | (37.8060884463757, -122.404375360949) | 3 | 1 | 10 | 308 | 23 | ||
| 37374 | 25903 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 500X The Embarcadero | 20 | 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 | ||
| 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 | ||
| 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 | ||
| 39383 | 27948 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 999 The Embarcadero | 5 | Median : Cutout | Tree | Port 6 | 02/01/2001 12:00:00 AM | 24 | 4X4 | 6012331.2461069 | 2120536.8810451 | 37.8032840604314 | -122.401528548359 | (37.8032840604314, -122.401528548359) | 3 | 1 | 10 | 28860 | 6 | ||
| 39492 | 27959 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 307X The Embarcadero | 3 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 18 | 6013768.7522982 | 2118400.6344275 | 37.7974985415834 | -122.396404150152 | (37.7974985415834, -122.396404150152) | 3 | 1 | 10 | 28860 | 6 | |||
| 39934 | 25796 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 800X The Embarcadero | 10 | Median : Cutout | Tree | Port 6 | 08/30/1996 12:00:00 AM | 36 | 10 | 6012816.95901 | 2119901.25001 | 37.8015658608918 | -122.399803052325 | (37.8015658608918, -122.399803052325) | 3 | 1 | 10 | 28860 | 6 | ||
| 40350 | 27864 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 900X The Embarcadero | 5 | Median : Cutout | Tree | Port 6 | 12/20/2000 12:00:00 AM | 24 | 6012583.0764321 | 2120386.2715162 | 37.8028845715493 | -122.400646489089 | (37.8028845715493, -122.400646489089) | 3 | 1 | 10 | 28860 | 6 | |||
| 40854 | 27817 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 350X The Embarcadero | 16 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 07/15/1994 12:00:00 AM | 12 | 4x4 | 6013785.7946449 | 2118604.8635638 | 37.7980602547356 | -122.396359500707 | (37.7980602547356, -122.396359500707) | 3 | 1 | 10 | 28860 | 6 | ||
| 41379 | 28039 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1400 The Embarcadero | 7 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6011949.43377 | 2121001.73319 | 37.8045391192453 | -122.402882543817 | (37.8045391192453, -122.402882543817) | 3 | 1 | 10 | 28860 | 6 | ||
| 41530 | 27801 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 650X The Embarcadero | 5 | Median : Cutout | Tree | Port 6 | 07/15/1994 12:00:00 AM | 36 | 15 | 6012967.8705311 | 2119824.4474868 | 37.8013633914033 | -122.399275432078 | (37.8013633914033, -122.399275432078) | 3 | 1 | 10 | 28860 | 6 | ||
| 42430 | 25858 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 800X The Embarcadero | 22 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012435.44801 | 2120409.06301 | 37.8029389168163 | -122.401158965062 | (37.8029389168163, -122.401158965062) | 3 | 1 | 10 | 28860 | 6 | ||
| 43793 | 28030 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 10 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014322.16601 | 2117689.87001 | 37.7955777303512 | -122.394439384649 | (37.7955777303512, -122.394439384649) | 4 | 2 | 10 | 28860 | 6 | ||
| 44069 | 25731 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 501X The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 08/15/1996 12:00:00 AM | 16 | 10 | 6013387.7643744 | 2119020.8269614 | 37.7991802341421 | -122.39776600259 | (37.7991802341421, -122.39776600259) | 3 | 1 | 10 | 28860 | 6 | ||
| 44312 | 27834 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 900X The Embarcadero | 7 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/20/2000 12:00:00 AM | 24 | 6012583.0764321 | 2120386.2715162 | 37.8028845715493 | -122.400646489089 | (37.8028845715493, -122.400646489089) | 3 | 1 | 10 | 28860 | 6 | |||
| 44615 | 27840 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 900X The Embarcadero | 13 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/20/2000 12:00:00 AM | 24 | 6012583.0764321 | 2120386.2715162 | 37.8028845715493 | -122.400646489089 | (37.8028845715493, -122.400646489089) | 3 | 1 | 10 | 28860 | 6 | |||
| 45664 | 27819 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 350X The Embarcadero | 18 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 07/15/1994 12:00:00 AM | 12 | 4x4 | 6013785.7946449 | 2118604.8635638 | 37.7980602547356 | -122.396359500707 | (37.7980602547356, -122.396359500707) | 3 | 1 | 10 | 28860 | 6 | ||
| 45682 | 28024 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 4 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014145.30001 | 2117911.22501 | 37.7961756855245 | -122.39506688845 | (37.7961756855245, -122.39506688845) | 3 | 2 | 10 | 28860 | 6 | ||
| 45704 | 27839 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 900X The Embarcadero | 12 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/20/2000 12:00:00 AM | 24 | 6012583.0764321 | 2120386.2715162 | 37.8028845715493 | -122.400646489089 | (37.8028845715493, -122.400646489089) | 3 | 1 | 10 | 28860 | 6 | |||
| 47018 | 27972 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 300 The Embarcadero | 9 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | 3 | 1 | 10 | 28860 | 6 | ||
| 47535 | 25745 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 801X The Embarcadero | 10 | Median : Cutout | Tree | Port 6 | 08/15/1996 12:00:00 AM | 24 | 10 | 6012632.1664062 | 2120088.9827256 | 37.8020710261606 | -122.400455716884 | (37.8020710261606, -122.400455716884) | 3 | 1 | 10 | 28860 | 6 | ||
| 47845 | 27821 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 350X The Embarcadero | 20 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 07/15/1994 12:00:00 AM | 12 | 4x4 | 6013785.7946449 | 2118604.8635638 | 37.7980602547356 | -122.396359500707 | (37.7980602547356, -122.396359500707) | 3 | 1 | 10 | 28860 | 6 | ||
| 48553 | 28021 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 1 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 24 | 4x4 | 6014080.19501 | 2118017.56101 | 37.7964640385194 | -122.395299619332 | (37.7964640385194, -122.395299619332) | 3 | 2 | 10 | 28860 | 6 | ||
| 49192 | 27705 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 1501X The Embarcadero | 2 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 6 | 6010670.1386197 | 2122042.3573555 | 37.807324899499 | -122.407383090822 | (37.807324899499, -122.407383090822) | 3 | 1 | 10 | 308 | 23 | ||||
| 50297 | 25895 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 500X The Embarcadero | 12 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6013445.7547399 | 2119056.6213274 | 37.7992817461076 | -122.397567846492 | (37.7992817461076, -122.397567846492) | 3 | 1 | 10 | 28860 | 6 | ||
| 51400 | 25637 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 550X The Embarcadero | 2 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 6 | 4X4 | 6013263.8234673 | 2119389.8203611 | 37.8001864990432 | -122.398220785892 | (37.8001864990432, -122.398220785892) | 3 | 1 | 10 | 28860 | 6 | ||
| 51959 | 27803 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 650 The Embarcadero | 6 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 07/15/1994 12:00:00 AM | 12 | 4X4 | 6012967.8705311 | 2119824.4474868 | 37.8013633914033 | -122.399275432078 | (37.8013633914033, -122.399275432078) | 3 | 1 | 10 | 28860 | 6 | ||
| 51967 | 25676 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 350X The Embarcadero | 3 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 12 | 4x4 | 6013785.7946449 | 2118604.8635638 | 37.7980602547356 | -122.396359500707 | (37.7980602547356, -122.396359500707) | 3 | 1 | 10 | 28860 | 6 | ||
| 51968 | 15089 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 30 Mission St | 4 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 6 | 4X4 | 6014680.683616 | 2116874.398416 | 37.7933585592202 | -122.393141753221 | (37.7933585592202, -122.393141753221) | 12 | 2 | 10 | 28855 | 6 | |||
| 52938 | 28045 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1800 The Embarcadero | 1 | 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 | ||
| 53273 | 25679 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 350X The Embarcadero | 3 | Median : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 36 | 15 | 6013785.7946449 | 2118604.8635638 | 37.7980602547356 | -122.396359500707 | (37.7980602547356, -122.396359500707) | 3 | 1 | 10 | 28860 | 6 | ||
| 53356 | 27992 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 300 The Embarcadero | 29 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | 3 | 1 | 10 | 28860 | 6 | ||
| 54070 | 26030 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 450X The Embarcadero | 2 | Median : Cutout | Tree | Port 6 | 12/01/2000 12:00:00 AM | 36 | 10 | 6014150.34723 | 2117905.13731 | 37.7961592508003 | -122.395048997307 | (37.7961592508003, -122.395048997307) | 3 | 2 | 10 | 28860 | 6 | ||
| 54159 | 27775 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 299X The Embarcadero | 3 | Median : Cutout | Tree | Port 6 | 12/01/2000 12:00:00 AM | 26 | 6013785.1217042 | 2118375.8431165 | 37.797431381421 | -122.396345768748 | (37.797431381421, -122.396345768748) | 3 | 1 | 10 | 28860 | 6 | |||
| 54424 | 27963 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 1101X The Embarcadero | 3 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 36 | 10 | 6012183.0853805 | 2120808.9629681 | 37.8040228629879 | -122.402060405747 | (37.8040228629879, -122.402060405747) | 3 | 1 | 10 | 28860 | 6 | ||
| 54544 | 27988 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 300 The Embarcadero | 25 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | 3 | 1 | 10 | 28860 | 6 |
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) );