trees
8,298 rows where qLegalStatus_id = 4 sorted by Location
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||||
| 46286 | 111319 | Undocumented 4 | Eucalyptus sideroxylon :: Red Ironbark 127 | 200x PENINSULA AVE | 2 | Unaccepted Street : Yard | Tree | Private 2 | 6012569 | 2087626 | 37.7129312780718 | -122.398395185538 | (37.7129312780718, -122.398395185538) | 10 | 3 | 8 | 309 | 1 | |||||
| 73281 | 111318 | Undocumented 4 | Eucalyptus sideroxylon :: Red Ironbark 127 | 200x PENINSULA AVE | 1 | Unaccepted Street : Yard | Tree | Private 2 | 6012569 | 2087626 | 37.7129312780718 | -122.398395185538 | (37.7129312780718, -122.398395185538) | 10 | 3 | 8 | 309 | 1 | |||||
| 164541 | 111320 | Undocumented 4 | Eucalyptus sideroxylon :: Red Ironbark 127 | 200x PENINSULA AVE | 3 | Unaccepted Street : Yard | Tree | Private 2 | 6012569 | 2087626 | 37.7129312780718 | -122.398395185538 | (37.7129312780718, -122.398395185538) | 10 | 3 | 8 | 309 | 1 | |||||
| 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 | |||
| 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 | ||||
| 46272 | 112621 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 226x HESTER AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012667 | 2087636 | 37.7129641948773 | -122.398057164184 | (37.7129641948773, -122.398057164184) | 10 | 3 | 8 | 309 | 1 | ||||
| 134710 | 112622 | Undocumented 4 | Corymbia citriodora :: Lemon Scented Gum 384 | 226x HESTER AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012667 | 2087636 | 37.7129641948773 | -122.398057164184 | (37.7129641948773, -122.398057164184) | 10 | 3 | 8 | 309 | 1 | ||||
| 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 | |||
| 86958 | 112623 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 228 HESTER AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x2 | 6012539 | 2087662 | 37.7130284556779 | -122.398501400627 | (37.7130284556779, -122.398501400627) | 10 | 3 | 8 | 309 | 1 | ||||
| 155752 | 115341 | Undocumented 4 | Pyrus calleryana :: Ornamental Pear 44 | 1514 SUNNYDALE AVE | 2 | Sidewalk: Property side : Yard | Tree | Housing Authority 15 | Private | 3x3 | 6006572 | 2087815 | 37.7131143345755 | -122.419136228821 | (37.7131143345755, -122.419136228821) | 9 | 7 | 8 | 309 | 39 | |||
| 82563 | 104649 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 200 Wheeler Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6012242.2 | 2087732.7 | 37.7132060446128 | -122.399532207425 | (37.7132060446128, -122.399532207425) | 10 | 3 | 8 | 309 | 1 | |||||
| 117848 | 111916 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 125 TUNNEL AVE | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6012052 | 2087737 | 37.7132072479286 | -122.400189909434 | (37.7132072479286, -122.400189909434) | 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 | ||||
| 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 | |||||
| 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 | ||||
| 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 | ||||
| 123948 | 75029 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 141X Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | FUF | 02/24/2016 12:00:00 AM | 3 | This record is for lthe ot between 141-143 Arleta Ave. | 6010470.01061258 | 2087860.00753073 | 37.7134566637798 | -122.405666490875 | (37.7134566637798, -122.405666490875) | 9 | 7 | 8 | 309 | 39 | |
| 132603 | 74892 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 141X Arleta Ave | 2 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | FUF | 02/24/2016 12:00:00 AM | 3 | This is for the trees adjacent to the lot between 141-143 Arleta | 6010470.01061258 | 2087860.00753073 | 37.7134566637798 | -122.405666490875 | (37.7134566637798, -122.405666490875) | 9 | 7 | 8 | 309 | 39 | |
| 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 | ||||
| 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 | ||||
| 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 | ||||||
| 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 | |||
| 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 | ||
| 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 | ||
| 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 | ||||
| 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 | |
| 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 | |
| 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 | |||
| 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 | |||
| 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 | |||||
| 107479 | 109648 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 800X BROTHERHOOD WAY | 1 | Median : Cutout | Tree | DPW 1 | 5990271.4 | 2088582.7 | 37.7142908027957 | -122.475532030318 | (37.7142908027957, -122.475532030318) | 1 | 8 | 4 | 64 | 14 | |||||
| 123780 | 109649 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 800X BROTHERHOOD WAY | 2 | Median : Cutout | Tree | DPW 1 | 5990271.4 | 2088582.7 | 37.7142908027957 | -122.475532030318 | (37.7142908027957, -122.475532030318) | 1 | 8 | 4 | 64 | 14 | |||||
| 134843 | 109659 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 800X BROTHERHOOD WAY | 30 | Median : Cutout | Tree | DPW 1 | 5990271.4 | 2088582.7 | 37.7142908027957 | -122.475532030318 | (37.7142908027957, -122.475532030318) | 1 | 8 | 4 | 64 | 14 | |||||
| 141356 | 109657 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 800X BROTHERHOOD WAY | 28 | Median : Cutout | Tree | DPW 1 | 5990271.4 | 2088582.7 | 37.7142908027957 | -122.475532030318 | (37.7142908027957, -122.475532030318) | 1 | 8 | 4 | 64 | 14 | |||||
| 142400 | 109650 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 800X BROTHERHOOD WAY | 21 | Median : Cutout | Tree | DPW 1 | 5990271.4 | 2088582.7 | 37.7142908027957 | -122.475532030318 | (37.7142908027957, -122.475532030318) | 1 | 8 | 4 | 64 | 14 | |||||
| 174778 | 109652 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 800X BROTHERHOOD WAY | 23 | Median : Cutout | Tree | DPW 1 | 5990271.4 | 2088582.7 | 37.7142908027957 | -122.475532030318 | (37.7142908027957, -122.475532030318) | 1 | 8 | 4 | 64 | 14 | |||||
| 193545 | 109651 | Undocumented 4 | Cupressus macrocarpa :: Monterey Cypress 41 | 800X BROTHERHOOD WAY | 22 | Median : Cutout | Tree | DPW 1 | 5990271.4 | 2088582.7 | 37.7142908027957 | -122.475532030318 | (37.7142908027957, -122.475532030318) | 1 | 8 | 4 | 64 | 14 | |||||
| 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 | ||
| 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 | ||||
| 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 | |||
| 89101 | 114259 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 801x BROTHERHOOD WAY | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 28 | 5989805 | 2088661 | 37.7144787470114 | -122.477149792402 | (37.7144787470114, -122.477149792402) | 1 | 8 | 4 | 64 | 14 | ||||
| 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 | ||||
| 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 | ||
| 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 | ||||
| 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 | ||||
| 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 |
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) );