trees
8,298 rows where qLegalStatus_id = 4 sorted by YCoord
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16017 | 254863 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2800 San Jose Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2018 02:34:00 PM | 3 | 3x5 | 5996454 | 2087913 | 37.7128084296521 | -122.454114323504 | (37.7128084296521, -122.454114323504) | 9 | 8 | 6 | 28861 | 24 | ||
| 17023 | 254832 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2800 San Jose Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2018 02:34:00 PM | 3 | 3x3 | 5996454 | 2087913 | 37.7128084296521 | -122.454114323504 | (37.7128084296521, -122.454114323504) | 9 | 8 | 6 | 28861 | 24 | ||
| 17824 | 254830 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2800 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2018 02:34:00 PM | 3 | 3x5 | 5996454 | 2087913 | 37.7128084296521 | -122.454114323504 | (37.7128084296521, -122.454114323504) | 9 | 8 | 6 | 28861 | 24 | ||
| 59804 | 109182 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 634 HURON AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5998040 | 2087925.4 | 37.7129332935716 | -122.448633512376 | (37.7129332935716, -122.448633512376) | 9 | 7 | 6 | 28861 | 25 | |||
| 161955 | 94038 | Undocumented 4 | Cornus florida :: Eastern Dogwood 385 | 227 Capitol Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 5995000.1 | 2087926.4 | 37.7127617466649 | -122.459140406861 | (37.7127617466649, -122.459140406861) | 9 | 8 | 6 | 28861 | 24 | |||
| 107470 | 112520 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 146x ARLETA AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010471 | 2087928 | 37.7136434126305 | -122.405667857285 | (37.7136434126305, -122.405667857285) | 9 | 7 | 8 | 309 | 39 | ||||
| 135717 | 112521 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 146x ARLETA AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010471 | 2087928 | 37.7136434126305 | -122.405667857285 | (37.7136434126305, -122.405667857285) | 9 | 7 | 8 | 309 | 39 | ||||
| 181466 | 108252 | Undocumented 4 | Tree(s) :: 17 | 20 MONETA WAY | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997915.2 | 2087928.9 | 37.7129357668087 | -122.44906511221 | (37.7129357668087, -122.44906511221) | 9 | 7 | 6 | 28861 | 25 | ||||
| 1918 | 262485 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 500X Delta St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6009406 | 2087980 | 37.7137265813857 | -122.409352565386 | (37.7137265813857, -122.409352565386) | 9 | 7 | 8 | 309 | 39 | |||
| 75148 | 105367 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 249 BROAD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 5994550.4 | 2088030.5 | 37.71302171758 | -122.460702242455 | (37.71302171758, -122.460702242455) | 9 | 8 | 6 | 28861 | 24 | |||
| 14439 | 104509 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 80 DICHIERA CT | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | 5998620 | 2088043 | 37.7132893442667 | -122.446637305723 | (37.7132893442667, -122.446637305723) | 9 | 7 | 6 | 28861 | 25 | |||||
| 13163 | 255351 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 700 Brotherhood Way | 32 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x21 | 5991178 | 2088065 | 37.7129218386335 | -122.472360778797 | (37.7129218386335, -122.472360778797) | 1 | 8 | 4 | 64 | 14 | ||||
| 36199 | 255343 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 700 Brotherhood Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x21 | 5991178 | 2088065 | 37.7129218386335 | -122.472360778797 | (37.7129218386335, -122.472360778797) | 1 | 8 | 4 | 64 | 14 | ||||
| 39787 | 255358 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 700 Brotherhood Way | 39 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x21 | 5991178 | 2088065 | 37.7129218386335 | -122.472360778797 | (37.7129218386335, -122.472360778797) | 1 | 8 | 4 | 64 | 14 | ||||
| 56921 | 255350 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 700 Brotherhood Way | 31 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x21 | 5991178 | 2088065 | 37.7129218386335 | -122.472360778797 | (37.7129218386335, -122.472360778797) | 1 | 8 | 4 | 64 | 14 | ||||
| 59019 | 255359 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 700 Brotherhood Way | 40 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x21 | 5991178 | 2088065 | 37.7129218386335 | -122.472360778797 | (37.7129218386335, -122.472360778797) | 1 | 8 | 4 | 64 | 14 | ||||
| 69737 | 255346 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 700 Brotherhood Way | 27 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x21 | 5991178 | 2088065 | 37.7129218386335 | -122.472360778797 | (37.7129218386335, -122.472360778797) | 1 | 8 | 4 | 64 | 14 | ||||
| 71653 | 255362 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 700 Brotherhood Way | 43 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x21 | 5991178 | 2088065 | 37.7129218386335 | -122.472360778797 | (37.7129218386335, -122.472360778797) | 1 | 8 | 4 | 64 | 14 | ||||
| 85877 | 255357 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 700 Brotherhood Way | 38 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x21 | 5991178 | 2088065 | 37.7129218386335 | -122.472360778797 | (37.7129218386335, -122.472360778797) | 1 | 8 | 4 | 64 | 14 | ||||
| 88408 | 255349 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 700 Brotherhood Way | 30 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x21 | 5991178 | 2088065 | 37.7129218386335 | -122.472360778797 | (37.7129218386335, -122.472360778797) | 1 | 8 | 4 | 64 | 14 | ||||
| 93618 | 255344 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 700 Brotherhood Way | 25 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x21 | 5991178 | 2088065 | 37.7129218386335 | -122.472360778797 | (37.7129218386335, -122.472360778797) | 1 | 8 | 4 | 64 | 14 | ||||
| 95564 | 255355 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 700 Brotherhood Way | 36 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x21 | 5991178 | 2088065 | 37.7129218386335 | -122.472360778797 | (37.7129218386335, -122.472360778797) | 1 | 8 | 4 | 64 | 14 | ||||
| 100311 | 255356 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 700 Brotherhood Way | 37 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x21 | 5991178 | 2088065 | 37.7129218386335 | -122.472360778797 | (37.7129218386335, -122.472360778797) | 1 | 8 | 4 | 64 | 14 | ||||
| 114777 | 255353 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 700 Brotherhood Way | 34 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x21 | 5991178 | 2088065 | 37.7129218386335 | -122.472360778797 | (37.7129218386335, -122.472360778797) | 1 | 8 | 4 | 64 | 14 | ||||
| 127684 | 255354 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 700 Brotherhood Way | 35 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x21 | 5991178 | 2088065 | 37.7129218386335 | -122.472360778797 | (37.7129218386335, -122.472360778797) | 1 | 8 | 4 | 64 | 14 | ||||
| 143507 | 255347 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 700 Brotherhood Way | 28 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x21 | 5991178 | 2088065 | 37.7129218386335 | -122.472360778797 | (37.7129218386335, -122.472360778797) | 1 | 8 | 4 | 64 | 14 | ||||
| 145223 | 255360 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 700 Brotherhood Way | 41 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x21 | 5991178 | 2088065 | 37.7129218386335 | -122.472360778797 | (37.7129218386335, -122.472360778797) | 1 | 8 | 4 | 64 | 14 | ||||
| 151097 | 255352 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 700 Brotherhood Way | 33 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x21 | 5991178 | 2088065 | 37.7129218386335 | -122.472360778797 | (37.7129218386335, -122.472360778797) | 1 | 8 | 4 | 64 | 14 | ||||
| 177253 | 255348 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 700 Brotherhood Way | 29 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x21 | 5991178 | 2088065 | 37.7129218386335 | -122.472360778797 | (37.7129218386335, -122.472360778797) | 1 | 8 | 4 | 64 | 14 | ||||
| 177411 | 255345 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 700 Brotherhood Way | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x21 | 5991178 | 2088065 | 37.7129218386335 | -122.472360778797 | (37.7129218386335, -122.472360778797) | 1 | 8 | 4 | 64 | 14 | ||||
| 183883 | 255361 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 700 Brotherhood Way | 42 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x21 | 5991178 | 2088065 | 37.7129218386335 | -122.472360778797 | (37.7129218386335, -122.472360778797) | 1 | 8 | 4 | 64 | 14 | ||||
| 51148 | 105904 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 700X BROTHERHOOD WAY | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 772491 | 5991178.9 | 2088065.4 | 37.7129229890255 | -122.472357697274 | (37.7129229890255, -122.472357697274) | 1 | 8 | 4 | 64 | 14 | |||||
| 116417 | 104205 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 710X Brotherhood Way | 2 | Front Yard : Yard | Tree | DPW 1 | Permit Number 770788 | 5991124.9259 | 2088065.41222 | 37.7129198985758 | -122.472544248538 | (37.7129198985758, -122.472544248538) | 1 | 8 | 4 | 64 | 14 | ||||
| 143404 | 104204 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 710X Brotherhood Way | 1 | Front Yard : Yard | Tree | DPW 1 | Permit Number 770788 | 5991124.9259 | 2088065.41222 | 37.7129198985758 | -122.472544248538 | (37.7129198985758, -122.472544248538) | 1 | 8 | 4 | 64 | 14 | ||||
| 41809 | 106281 | Undocumented 4 | Garrya elliptica 'James Roof' :: James Roof Coast Silktassel Tree 456 | 399X Elliot St | 2 | Unaccepted Street : Yard | Tree | Rec/Park 5 | Permit Number 772905 | 6008798.75873 | 2088103.62049 | 37.7140319762934 | -122.411460149363 | (37.7140319762934, -122.411460149363) | 9 | 7 | 8 | 309 | 39 | ||||
| 85470 | 106280 | Undocumented 4 | Garrya elliptica 'James Roof' :: James Roof Coast Silktassel Tree 456 | 399X Elliot St | 1 | Unaccepted Street : Yard | Tree | Rec/Park 5 | Permit Number 772905 | 6008798.75873 | 2088103.62049 | 37.7140319762934 | -122.411460149363 | (37.7140319762934, -122.411460149363) | 9 | 7 | 8 | 309 | 39 | ||||
| 162309 | 106282 | Undocumented 4 | Garrya elliptica 'James Roof' :: James Roof Coast Silktassel Tree 456 | 399X Elliot St | 3 | Unaccepted Street : Yard | Tree | Rec/Park 5 | Permit Number 772905 | 6008798.75873 | 2088103.62049 | 37.7140319762934 | -122.411460149363 | (37.7140319762934, -122.411460149363) | 9 | 7 | 8 | 309 | 39 | ||||
| 38387 | 113577 | Undocumented 4 | Ficus microcarpa 'Retusa' :: Pot Belly Fig 444 | 301X PLYMOUTH AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995855 | 2088109 | 37.7133122340733 | -122.456198810604 | (37.7133122340733, -122.456198810604) | 9 | 8 | 6 | 28861 | 24 | ||||
| 81194 | 113578 | Undocumented 4 | Ficus microcarpa 'Retusa' :: Pot Belly Fig 444 | 301X PLYMOUTH AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995855 | 2088109 | 37.7133122340733 | -122.456198810604 | (37.7133122340733, -122.456198810604) | 9 | 8 | 6 | 28861 | 24 | ||||
| 92350 | 113575 | Undocumented 4 | Ficus microcarpa 'Retusa' :: Pot Belly Fig 444 | 315X PLYMOUTH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995855 | 2088109 | 37.7133122340733 | -122.456198810604 | (37.7133122340733, -122.456198810604) | 9 | 8 | 6 | 28861 | 24 | ||||
| 162229 | 113576 | Undocumented 4 | Ficus microcarpa 'Retusa' :: Pot Belly Fig 444 | 301X PLYMOUTH AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995855 | 2088109 | 37.7133122340733 | -122.456198810604 | (37.7133122340733, -122.456198810604) | 9 | 8 | 6 | 28861 | 24 | ||||
| 25368 | 108741 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 100x HESTER AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012550 | 2088124 | 37.7142976286929 | -122.398495779076 | (37.7142976286929, -122.398495779076) | 10 | 3 | 8 | 309 | 1 | ||||
| 52334 | 108743 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 120x HESTER AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012550 | 2088124 | 37.7142976286929 | -122.398495779076 | (37.7142976286929, -122.398495779076) | 10 | 3 | 8 | 309 | 1 | ||||
| 76740 | 108752 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 180x HESTER AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012550 | 2088124 | 37.7142976286929 | -122.398495779076 | (37.7142976286929, -122.398495779076) | 10 | 3 | 8 | 309 | 1 | ||||
| 84868 | 108751 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 180x HESTER AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012550 | 2088124 | 37.7142976286929 | -122.398495779076 | (37.7142976286929, -122.398495779076) | 10 | 3 | 8 | 309 | 1 | ||||
| 91873 | 108742 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 100x HESTER AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012550 | 2088124 | 37.7142976286929 | -122.398495779076 | (37.7142976286929, -122.398495779076) | 10 | 3 | 8 | 309 | 1 | ||||
| 99078 | 108747 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 140x HESTER AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012550 | 2088124 | 37.7142976286929 | -122.398495779076 | (37.7142976286929, -122.398495779076) | 10 | 3 | 8 | 309 | 1 | ||||
| 103427 | 108745 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 120x HESTER AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012550 | 2088124 | 37.7142976286929 | -122.398495779076 | (37.7142976286929, -122.398495779076) | 10 | 3 | 8 | 309 | 1 | ||||
| 116178 | 108749 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 180x HESTER AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012550 | 2088124 | 37.7142976286929 | -122.398495779076 | (37.7142976286929, -122.398495779076) | 10 | 3 | 8 | 309 | 1 | ||||
| 131725 | 108756 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 200x HESTER AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012550 | 2088124 | 37.7142976286929 | -122.398495779076 | (37.7142976286929, -122.398495779076) | 10 | 3 | 8 | 309 | 1 | ||||
| 162143 | 108748 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 140x HESTER AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012550 | 2088124 | 37.7142976286929 | -122.398495779076 | (37.7142976286929, -122.398495779076) | 10 | 3 | 8 | 309 | 1 | ||||
| 167105 | 108744 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 120x HESTER AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012550 | 2088124 | 37.7142976286929 | -122.398495779076 | (37.7142976286929, -122.398495779076) | 10 | 3 | 8 | 309 | 1 | ||||
| 185396 | 108746 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 120x HESTER AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012550 | 2088124 | 37.7142976286929 | -122.398495779076 | (37.7142976286929, -122.398495779076) | 10 | 3 | 8 | 309 | 1 | ||||
| 187976 | 108750 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 180x HESTER AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012550 | 2088124 | 37.7142976286929 | -122.398495779076 | (37.7142976286929, -122.398495779076) | 10 | 3 | 8 | 309 | 1 | ||||
| 80100 | 254362 | Undocumented 4 | Washingtonia robusta :: Mexican Fan Palm 72 | 239 Orizaba Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x6 | 5993970 | 2088131 | 37.7132642563577 | -122.462715568818 | (37.7132642563577, -122.462715568818) | 9 | 8 | 6 | 64 | 24 | ||||
| 19806 | 117422 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 50 VERNON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992487 | 2088224 | 37.7134340885283 | -122.467848042178 | (37.7134340885283, -122.467848042178) | 9 | 8 | 6 | 64 | 24 | ||||
| 94127 | 119281 | Undocumented 4 | Leptospermum laevigatum :: Australian Tea Tree 47 | 59x Ralston St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992077 | 2088275 | 37.7135504383964 | -122.469268843393 | (37.7135504383964, -122.469268843393) | 9 | 8 | 6 | 64 | 24 | ||||
| 76023 | 107819 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 75X RALSTON ST | Back Yard : Yard | Tree | Private 2 | 45 | Permit Number 775492 | 5992193 | 2088303 | 37.7136340221674 | -122.468869945866 | (37.7136340221674, -122.468869945866) | 9 | 8 | 6 | 64 | 24 | ||||
| 43136 | 181033 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 39 Curtis St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 4ft | 6000587.53239 | 2088326.47 | 37.7141798831749 | -122.439857163381 | (37.7141798831749, -122.439857163381) | 9 | 7 | 6 | 28861 | 5 | |||
| 142853 | 107503 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 4140 19th Ave | Back Yard : Yard | Tree | Private 2 | 5992157.71887 | 2088336.37745 | 37.7137236301705 | -122.46899431666 | (37.7137236301705, -122.46899431666) | 9 | 8 | 6 | 64 | 24 | ||||||
| 72299 | 200142 | Undocumented 4 | Pinus Spp :: Pine Spp 100 | 700 Jamestown Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6015325.0376 | 2088350.2198 | 37.7150729908419 | -122.388919862472 | (37.7150729908419, -122.388919862472) | 10 | 3 | 8 | 58 | 1 | |||
| 34481 | 201714 | Undocumented 4 | Acacia stenophylla :: Shoestring Acacia 30 | 726 Jamestown Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6015317.96334 | 2088364.51894 | 37.7151118613908 | -122.388945312084 | (37.7151118613908, -122.388945312084) | 10 | 3 | 8 | 58 | 1 | |||
| 177971 | 200796 | Undocumented 4 | Pinus Spp :: Pine Spp 100 | 700 Jamestown Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6015315.685 | 2088368.925 | 37.7151238332906 | -122.388953494511 | (37.7151238332906, -122.388953494511) | 10 | 3 | 8 | 58 | 1 | |||
| 169730 | 93194 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 442 Campbell Ave | 1 | Front Yard : Yard | Tree | Private 2 | 6010752.9 | 2088369 | 37.7148700691491 | -122.404724531269 | (37.7148700691491, -122.404724531269) | 9 | 7 | 8 | 309 | 39 | |||||
| 5077 | 254635 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5330 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2018 02:21:00 PM | 3 | 3x3 | 5999632 | 2088389 | 37.7142971380253 | -122.443164330284 | (37.7142971380253, -122.443164330284) | 9 | 7 | 6 | 28861 | 25 | ||
| 150560 | 201715 | Undocumented 4 | Acacia stenophylla :: Shoestring Acacia 30 | 726 Jamestown Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6015296.60638 | 2088393.85947 | 37.715191240972 | -122.389021178889 | (37.715191240972, -122.389021178889) | 10 | 3 | 8 | 58 | 1 | |||
| 120666 | 110647 | Undocumented 4 | Pittosporum spp :: Pittosporum spp 170 | 300x NAGLEE AVE | 1 | Unaccepted Street : Cutout | Tree | Private 2 | 12 | 3x3 | 5997872 | 2088397 | 37.7142185912398 | -122.449248128432 | (37.7142185912398, -122.449248128432) | 9 | 7 | 6 | 28861 | 25 | |||
| 111878 | 113362 | Undocumented 4 | Tree(s) :: 17 | 115 CHESTER AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/27/2015 12:00:00 AM | 3x3 | Permit Number 776486 | 5991771 | 2088401 | 37.713878716515 | -122.470335649187 | (37.713878716515, -122.470335649187) | 9 | 8 | 6 | 64 | 24 | ||
| 148689 | 200798 | Undocumented 4 | Casuarina cunninghamiana :: Horsetail pine 112 | 700 Jamestown Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6015296.9798 | 2088405.4002 | 37.71522295028 | -122.389020693471 | (37.71522295028, -122.389020693471) | 10 | 3 | 8 | 58 | 1 | |||
| 33460 | 115831 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 1X JUNIPERO SERRA BLVD OFF RAMP | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991168 | 2088425 | 37.713909732222 | -122.472421570074 | (37.713909732222, -122.472421570074) | 1 | 8 | 4 | 64 | 14 | ||||
| 106832 | 115830 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 1X JUNIPERO SERRA BLVD OFF RAMP | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/30/2016 12:00:00 AM | 3 | 3x3 | 5991168 | 2088425 | 37.713909732222 | -122.472421570074 | (37.713909732222, -122.472421570074) | 1 | 8 | 4 | 64 | 14 | ||
| 188894 | 115828 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 65 CHUMASERO DR | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 08/30/2016 12:00:00 AM | 3 | 3x3 | 5991168 | 2088425 | 37.713909732222 | -122.472421570074 | (37.713909732222, -122.472421570074) | 1 | 8 | 4 | 64 | 14 | ||
| 163373 | 109096 | Undocumented 4 | Tree(s) :: 17 | 194 FARALLONES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/01/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779352 | 5995118.3 | 2088431.1 | 37.71415432875 | -122.458768388595 | (37.71415432875, -122.458768388595) | 9 | 8 | 6 | 28861 | 24 | |
| 22815 | 108344 | Undocumented 4 | Tree(s) :: 17 | 268 FARALLONES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/25/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774684 | 5994321.4 | 2088439.9 | 37.7141326548779 | -122.461523399561 | (37.7141326548779, -122.461523399561) | 9 | 8 | 6 | 28861 | 24 | |
| 35837 | 114606 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 36 CURTIS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000494 | 2088444 | 37.7144972695987 | -122.440188869703 | (37.7144972695987, -122.440188869703) | 9 | 7 | 6 | 28861 | 5 | ||||
| 152899 | 109646 | Undocumented 4 | Liquidambar styraciflua :: American Sweet Gum 37 | 30 CURTIS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 3x3 | 6000484.3 | 2088475.7 | 37.7145837584364 | -122.440224668614 | (37.7145837584364, -122.440224668614) | 9 | 7 | 6 | 28861 | 5 | |||
| 73180 | 111309 | Undocumented 4 | Acacia spp :: Acacia Spp 105 | 100x GILROY ST | 1 | Unaccepted Street : Yard | Tree | Private 2 | 30x30 | 6015178 | 2088529 | 37.7155557353625 | -122.389440569451 | (37.7155557353625, -122.389440569451) | 10 | 3 | 8 | 58 | 1 | ||||
| 9144 | 254818 | Undocumented 4 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 2699 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997230 | 2088538 | 37.7145690020879 | -122.451477282388 | (37.7145690020879, -122.451477282388) | 9 | 8 | 6 | 28861 | 24 | ||||
| 15387 | 254816 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2687 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2018 02:34:00 PM | 3 | 3x3 | 5997223 | 2088538 | 37.7145686012354 | -122.451501477097 | (37.7145686012354, -122.451501477097) | 9 | 8 | 6 | 28861 | 24 | ||
| 46062 | 254819 | Undocumented 4 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 2699 San Jose Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997230 | 2088538 | 37.7145690020879 | -122.451477282388 | (37.7145690020879, -122.451477282388) | 9 | 8 | 6 | 28861 | 24 | ||||
| 55281 | 254820 | Undocumented 4 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 2699 San Jose Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997230 | 2088538 | 37.7145690020879 | -122.451477282388 | (37.7145690020879, -122.451477282388) | 9 | 8 | 6 | 28861 | 24 | ||||
| 78221 | 254821 | Undocumented 4 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 2699 San Jose Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997230 | 2088538 | 37.7145690020879 | -122.451477282388 | (37.7145690020879, -122.451477282388) | 9 | 8 | 6 | 28861 | 24 | ||||
| 104957 | 254817 | Undocumented 4 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 2699 San Jose Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997230 | 2088538 | 37.7145690020879 | -122.451477282388 | (37.7145690020879, -122.451477282388) | 9 | 8 | 6 | 28861 | 24 | ||||
| 12482 | 177894 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 350 Rutland St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6010334.18865 | 2088569.51073 | 37.7153972189891 | -122.406185898468 | (37.7153972189891, -122.406185898468) | 9 | 7 | 8 | 309 | 39 | |||
| 61697 | 96800 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 295x Arch St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 5992696 | 2088571 | 37.7143989335186 | -122.467150884655 | (37.7143989335186, -122.467150884655) | 9 | 8 | 6 | 64 | 24 | |||
| 6387 | 114260 | Undocumented 4 | Pinus canariensis :: Canary Island Pine 35 | 800x BROTHERHOOD WAY | 1 | Front Yard : Cutout | Tree | Private 2 | 7 | 5990271 | 2088582 | 37.7142888575797 | -122.475533361779 | (37.7142888575797, -122.475533361779) | 1 | 8 | 4 | 64 | 14 | ||||
| 33801 | 114265 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 800x BROTHERHOOD WAY | 6 | Front Yard : Cutout | Tree | Private 2 | 26 | 5990271 | 2088582 | 37.7142888575797 | -122.475533361779 | (37.7142888575797, -122.475533361779) | 1 | 8 | 4 | 64 | 14 | ||||
| 43604 | 114263 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 800x BROTHERHOOD WAY | 4 | Front Yard : Cutout | Tree | Private 2 | 29 | 5990271 | 2088582 | 37.7142888575797 | -122.475533361779 | (37.7142888575797, -122.475533361779) | 1 | 8 | 4 | 64 | 14 | ||||
| 64580 | 114269 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 800x BROTHERHOOD WAY | 10 | Front Yard : Yard | Tree | Private 2 | 38 | 5990271 | 2088582 | 37.7142888575797 | -122.475533361779 | (37.7142888575797, -122.475533361779) | 1 | 8 | 4 | 64 | 14 | ||||
| 67460 | 114261 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 800x BROTHERHOOD WAY | 2 | Front Yard : Cutout | Tree | Private 2 | 36 | 5990271 | 2088582 | 37.7142888575797 | -122.475533361779 | (37.7142888575797, -122.475533361779) | 1 | 8 | 4 | 64 | 14 | ||||
| 80560 | 114268 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 800x BROTHERHOOD WAY | 9 | Front Yard : Yard | Tree | Private 2 | 30 | 5990271 | 2088582 | 37.7142888575797 | -122.475533361779 | (37.7142888575797, -122.475533361779) | 1 | 8 | 4 | 64 | 14 | ||||
| 81726 | 114266 | Undocumented 4 | Pittosporum spp :: Pittosporum spp 170 | 800x BROTHERHOOD WAY | 7 | Front Yard : Cutout | Tree | Private 2 | 9 | 5990271 | 2088582 | 37.7142888575797 | -122.475533361779 | (37.7142888575797, -122.475533361779) | 1 | 8 | 4 | 64 | 14 | ||||
| 99056 | 114262 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 800x BROTHERHOOD WAY | 3 | Front Yard : Cutout | Tree | Private 2 | 36 | 5990271 | 2088582 | 37.7142888575797 | -122.475533361779 | (37.7142888575797, -122.475533361779) | 1 | 8 | 4 | 64 | 14 | ||||
| 143168 | 114267 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 800x BROTHERHOOD WAY | 8 | Front Yard : Yard | Tree | Private 2 | 50 | 5990271 | 2088582 | 37.7142888575797 | -122.475533361779 | (37.7142888575797, -122.475533361779) | 1 | 8 | 4 | 64 | 14 | ||||
| 160316 | 114264 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 800x BROTHERHOOD WAY | 5 | Front Yard : Cutout | Tree | Private 2 | 32 | 5990271 | 2088582 | 37.7142888575797 | -122.475533361779 | (37.7142888575797, -122.475533361779) | 1 | 8 | 4 | 64 | 14 | ||||
| 55368 | 109658 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 800X BROTHERHOOD WAY | 29 | Median : Cutout | Tree | DPW 1 | 5990271.4 | 2088582.7 | 37.7142908027957 | -122.475532030318 | (37.7142908027957, -122.475532030318) | 1 | 8 | 4 | 64 | 14 | |||||
| 84888 | 109654 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 800X BROTHERHOOD WAY | 25 | Median : Cutout | Tree | DPW 1 | 5990271.4 | 2088582.7 | 37.7142908027957 | -122.475532030318 | (37.7142908027957, -122.475532030318) | 1 | 8 | 4 | 64 | 14 | |||||
| 85555 | 109655 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 800X BROTHERHOOD WAY | 26 | Median : Cutout | Tree | DPW 1 | 5990271.4 | 2088582.7 | 37.7142908027957 | -122.475532030318 | (37.7142908027957, -122.475532030318) | 1 | 8 | 4 | 64 | 14 | |||||
| 95002 | 109656 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 800X BROTHERHOOD WAY | 8 | Median : Cutout | Tree | DPW 1 | 02/27/2015 10:16:00 AM | 3 | 5990271.4 | 2088582.7 | 37.7142908027957 | -122.475532030318 | (37.7142908027957, -122.475532030318) | 1 | 8 | 4 | 64 | 14 | |||
| 100770 | 109653 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 800X BROTHERHOOD WAY | 6 | Median : Cutout | Tree | DPW 1 | 5990271.4 | 2088582.7 | 37.7142908027957 | -122.475532030318 | (37.7142908027957, -122.475532030318) | 1 | 8 | 4 | 64 | 14 |
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) );