trees
1,732 rows where qLegalStatus_id = 6 sorted by Fire Prevention Districts descending
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts ▲ | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 748 | 259270 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3580X 19th Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | Permit Number 784388 | 5990529 | 2092111 | 37.723993571379 | -122.474899060099 | (37.723993571379, -122.474899060099) | 9 | 8 | 4 | 64 | 14 | |||
| 797 | 260459 | Significant Tree 6 | Tree(s) :: 17 | 1798X Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/09/2019 12:00:00 AM | 3 | 5x10 | Permit Number 784470 | 5992678 | 2095461 | 37.733316146518 | -122.467713892437 | (37.733316146518, -122.467713892437) | 9 | 8 | 4 | 59 | 40 | |
| 821 | 261708 | Significant Tree 6 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 20 Entrada Ct | 1 | Front Yard : Yard | Tree | Private 2 | 02/21/2020 12:00:00 AM | 3 | 3x3 | Permit Number 783258 | 5992481.8221 | 2092418.55282 | 37.724951011222 | -122.468170882637 | (37.724951011222, -122.468170882637) | 9 | 8 | 4 | 59 | 40 | |
| 873 | 113043 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 500 RAYMOND AVE | 2 | Front Yard : Cutout | Tree | Private 2 | 10/06/2015 12:00:00 AM | 3x3 | 6008527 | 2088690 | 37.7156268060035 | -122.412440877248 | (37.7156268060035, -122.412440877248) | 9 | 7 | 8 | 309 | 18 | |||
| 1002 | 260458 | Significant Tree 6 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 835 Darien Way | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11/19/2019 12:00:00 AM | 3 | 6x10 | Permit Number 784514 | 5994066 | 2094094 | 37.7296427463027 | -122.462816092129 | (37.7296427463027, -122.462816092129) | 9 | 8 | 4 | 59 | 40 | |
| 1038 | 259268 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3580X 19th Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | Permit Number 784388 | 5990529 | 2092111 | 37.723993571379 | -122.474899060099 | (37.723993571379, -122.474899060099) | 9 | 8 | 4 | 64 | 14 | |||
| 1377 | 262327 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 10X Sickles Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x10 | 5996833 | 2086575 | 37.709156314989 | -122.452707876493 | (37.709156314989, -122.452707876493) | 9 | 7 | 6 | 28861 | 25 | ||||
| 1679 | 262328 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 10X Sickles Ave | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x10 | 5996833 | 2086575 | 37.709156314989 | -122.452707876493 | (37.709156314989, -122.452707876493) | 9 | 7 | 6 | 28861 | 25 | ||||
| 1773 | 116537 | Significant Tree 6 | Tree(s) :: 17 | 598x MOUNT VERNON AVE | 6 | Back Yard : Yard | Tree | Private 2 | 05/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777833 | 5997754 | 2090179 | 37.7191048016003 | -122.449784323005 | (37.7191048016003, -122.449784323005) | 9 | 8 | 6 | 28861 | 24 | |
| 3054 | 109568 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 95 Nordhoff St | 1 | Back Yard : Yard | Tree | Private 2 | Permit Number 777169 | 6000348.8 | 2095645.6 | 37.7342629464917 | -122.441207129815 | (37.7342629464917, -122.441207129815) | 9 | 7 | 5 | 63 | 40 | ||||
| 3096 | 100121 | Significant Tree 6 | Myoporum laetum :: Myoporum 62 | 690 Miramar Ave | 1 | Front Yard : Yard | Tree | Private 2 | 5995444.4 | 2093941.6 | 37.7293035878447 | -122.458039824042 | (37.7293035878447, -122.458039824042) | 9 | 7 | 4 | 28861 | 40 | |||||
| 3842 | 109772 | Significant Tree 6 | Yucca elephantipes :: Giant Yucca 268 | 2200x SAN JOSE AVE | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3x3 | 5998886 | 2091075 | 37.7216297132481 | -122.445935857536 | (37.7216297132481, -122.445935857536) | 9 | 7 | 6 | 28861 | 25 | |||
| 4000 | 79751 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 15 Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x10 | 5991685.90264393 | 2095891.27109779 | 37.7344402285305 | -122.471175151585 | (37.7344402285305, -122.471175151585) | 9 | 8 | 4 | 59 | 40 | ||||
| 4567 | 261551 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 135 Fernwood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994788 | 2095004 | 37.7321829429526 | -122.460385989231 | (37.7321829429526, -122.460385989231) | 9 | 8 | 4 | 59 | 40 | ||||
| 4724 | 262586 | Significant Tree 6 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2 Byron Ct | 1 | Front Yard : Yard | Tree | Private 2 | 08/19/2020 12:00:00 AM | 3 | 8x8 | Permit Number 781313 | 5999459.72778 | 2086749.57445 | 37.7097858201455 | -122.443642066205 | (37.7097858201455, -122.443642066205) | 9 | 7 | 6 | 28861 | 5 | |
| 4737 | 261021 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3440X 19th Ave | 2 | Back Yard : Yard | Tree | Private 2 | 10x10 | Permit Number 784857 | 5990714 | 2092679 | 37.7255638768787 | -122.474300978757 | (37.7255638768787, -122.474300978757) | 9 | 8 | 4 | 64 | 40 | |||
| 4898 | 211279 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 350 Joost Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 28 | Width 10ft | 5999756.13451 | 2094992.8184 | 37.7324367835174 | -122.443209289192 | (37.7324367835174, -122.443209289192) | 9 | 7 | 4 | 63 | 40 | |||
| 6044 | 259265 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3580X 19th Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | Permit Number 784388 | 5990529 | 2092111 | 37.723993571379 | -122.474899060099 | (37.723993571379, -122.474899060099) | 9 | 8 | 4 | 64 | 14 | |||
| 7288 | 264692 | Significant Tree 6 | Quercus agrifolia :: Coast Live Oak 172 | 1500 Plymouth Ave | 1 | Side Yard : Yard | Tree | Private 2 | 10x10 | 5995893.6658 | 2094152.61505 | 37.7299087874515 | -122.456501934539 | (37.7299087874515, -122.456501934539) | 9 | 7 | 4 | 28861 | 40 | ||||
| 7310 | 96412 | Significant Tree 6 | Acer palmatum :: Japanese Maple 216 | 185 Chilton Ave | Front Yard : Yard | Tree | Private 2 | 05/18/2011 12:00:00 AM | Permit Number 767805 | 6001587.1 | 2095138.7 | 37.732941575251 | -122.436889661497 | (37.732941575251, -122.436889661497) | 9 | 7 | 5 | 63 | 40 | ||||
| 7631 | 256540 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 379X Cresta Vista Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997117 | 2096261 | 37.7357680647268 | -122.452424833384 | (37.7357680647268, -122.452424833384) | 9 | 7 | 4 | 59 | 40 | ||||
| 7906 | 262219 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 21X Stillings Ave | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 6000348 | 2095645 | 37.7342612534616 | -122.441209852629 | (37.7342612534616, -122.441209852629) | 9 | 7 | 5 | 63 | 40 | ||||
| 8751 | 262427 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 1 Avalon Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002848 | 2093194 | 37.7276734535 | -122.432391560875 | (37.7276734535, -122.432391560875) | 9 | 7 | 6 | 28861 | 5 | ||||
| 8965 | 261020 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3440X 19th Ave | 1 | Back Yard : Yard | Tree | Private 2 | 10x10 | Permit Number 784857 | 5990714 | 2092679 | 37.7255638768787 | -122.474300978757 | (37.7255638768787, -122.474300978757) | 9 | 8 | 4 | 64 | 40 | |||
| 9303 | 259269 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 3580X 19th Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5990529 | 2092111 | 37.723993571379 | -122.474899060099 | (37.723993571379, -122.474899060099) | 9 | 8 | 4 | 64 | 14 | ||||
| 9495 | 261033 | Significant Tree 6 | Tree(s) :: 17 | 551 Los Palmos Dr | 1 | Front Yard : Yard | Tree | Private 2 | 01/14/2020 12:00:00 AM | 3 | 10x10 | Permit Number 784596 | 5996615 | 2095626 | 37.7339957349096 | -122.454114584985 | (37.7339957349096, -122.454114584985) | 9 | 7 | 4 | 59 | 40 | |
| 9862 | 114526 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1 TIOGA AVE | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6011351 | 2088602 | 37.7155432513192 | -122.402673611341 | (37.7155432513192, -122.402673611341) | 9 | 7 | 8 | 309 | 39 | |||||
| 9908 | 215094 | Significant Tree 6 | Podocarpus gracilor :: Fern Pine 51 | 218 Sadowa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/13/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 779008 | 5994821.63014 | 2087784.20309 | 37.7123610457095 | -122.459746958272 | (37.7123610457095, -122.459746958272) | 9 | 8 | 6 | 28861 | 24 | |
| 10088 | 253978 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 441 Detroit St | 1 | Unaccepted Street : Yard | Tree | Private 2 | 3x10 | 5999396 | 2094599 | 37.7313349085161 | -122.444426062201 | (37.7313349085161, -122.444426062201) | 9 | 7 | 4 | 59 | 40 | ||||
| 10229 | 264894 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 56 Keystone Way | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 5994156 | 2093086 | 37.7268802074189 | -122.462431871086 | (37.7268802074189, -122.462431871086) | 9 | 8 | 4 | 28861 | 40 | ||||
| 11014 | 262425 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 1 Avalon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002848 | 2093194 | 37.7276734535 | -122.432391560875 | (37.7276734535, -122.432391560875) | 9 | 7 | 6 | 28861 | 5 | ||||
| 11182 | 261019 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3450X 19th Ave | 1 | Back Yard : Yard | Tree | Private 2 | 10x10 | Permit Number 784867 | 5990575 | 2092822 | 37.725948465298 | -122.47479191789 | (37.725948465298, -122.47479191789) | 9 | 8 | 4 | 64 | 14 | |||
| 11254 | 259267 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 3580X 19th Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5990529 | 2092111 | 37.723993571379 | -122.474899060099 | (37.723993571379, -122.474899060099) | 9 | 8 | 4 | 64 | 14 | ||||
| 12273 | 261709 | Significant Tree 6 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 20 Entrada Ct | 2 | Front Yard : Yard | Tree | Private 2 | 02/21/2020 12:00:00 AM | 3 | 3x3 | Permit Number 783258 | 5992481.8221 | 2092418.55282 | 37.724951011222 | -122.468170882637 | (37.724951011222, -122.468170882637) | 9 | 8 | 4 | 59 | 40 | |
| 12289 | 254085 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 411 Lansdale Ave | 1 | Front Yard : Cutout | Tree | Private 2 | 6x6 | 5995707 | 2096451 | 37.7362088759349 | -122.457313463895 | (37.7362088759349, -122.457313463895) | 9 | 7 | 4 | 59 | 40 | ||||
| 13617 | 82366 | Significant Tree 6 | Trachycarpus fortunei :: Windmill Palm 116 | 51 Princeton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6007564.92616 | 2093725.05049 | 37.7293979446509 | -122.416122630059 | (37.7293979446509, -122.416122630059) | 9 | 3 | 7 | 309 | 28 | |||
| 13663 | 258677 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 109 | 607 Congo St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10x10 | 6000094 | 2095817 | 37.7347190533418 | -122.442100351643 | (37.7347190533418, -122.442100351643) | 9 | 7 | 4 | 63 | 40 | ||||
| 14356 | 264786 | Significant Tree 6 | Cedrus atlantica :: Atlas Cedar 233 | 451 Yerba Buena Ave | 1 | Front Yard : Cutout | Tree | Private 2 | 10x10 | 5995368 | 2094795 | 37.7316424274687 | -122.458365690275 | (37.7316424274687, -122.458365690275) | 9 | 7 | 4 | 59 | 40 | ||||
| 14608 | 259056 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 99 Cedro Ave | 1 | Front Yard : Yard | Tree | Private 2 | 10/09/2019 12:00:00 AM | 3 | 3x3 | Permit Number 784357 | 5992279 | 2093128 | 37.7268872622364 | -122.468923614031 | (37.7268872622364, -122.468923614031) | 9 | 8 | 4 | 59 | 40 | |
| 14780 | 262330 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 10X Sickles Ave | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x10 | 5996833 | 2086575 | 37.709156314989 | -122.452707876493 | (37.709156314989, -122.452707876493) | 9 | 7 | 6 | 28861 | 25 | ||||
| 15055 | 259264 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 3580X 19th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5990529 | 2092111 | 37.723993571379 | -122.474899060099 | (37.723993571379, -122.474899060099) | 9 | 8 | 4 | 64 | 14 | ||||
| 15224 | 264691 | Significant Tree 6 | Leucodendron argenteum :: Silver Tree 46 | 1560 Plymouth Ave | 1 | Front Yard : Yard | Tree | Private 2 | 10x10 | 5995798 | 2094356 | 37.730461740667 | -122.45684736471 | (37.730461740667, -122.45684736471) | 9 | 7 | 4 | 28861 | 40 | ||||
| 15254 | 260460 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1798X Monterey Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x10 | 5992678 | 2095461 | 37.733316146518 | -122.467713892437 | (37.733316146518, -122.467713892437) | 9 | 8 | 4 | 59 | 40 | ||||
| 15657 | 259657 | Significant Tree 6 | Tree(s) :: 17 | 132 Sagamore St | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 5995545 | 2087474 | 37.7115508726991 | -122.457224363425 | (37.7115508726991, -122.457224363425) | 9 | 8 | 6 | 28861 | 24 | ||||
| 15980 | 262426 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 1 Avalon Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002848 | 2093194 | 37.7276734535 | -122.432391560875 | (37.7276734535, -122.432391560875) | 9 | 7 | 6 | 28861 | 5 | ||||
| 16429 | 262110 | Significant Tree 6 | Phoenix dactylifera :: Date Palm 87 | 25 Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002200 | 2092574 | 37.7259343081174 | -122.434587389509 | (37.7259343081174, -122.434587389509) | 9 | 7 | 6 | 28861 | 25 | ||||
| 16652 | 258405 | Significant Tree 6 | Myoporum laetum :: Myoporum 62 | 15 Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x10 | 5991685.90264393 | 2095891.27109779 | 37.7344402285305 | -122.471175151585 | (37.7344402285305, -122.471175151585) | 9 | 8 | 4 | 59 | 40 | ||||
| 17333 | 259266 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3580X 19th Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | Permit Number 784388 | 5990529 | 2092111 | 37.723993571379 | -122.474899060099 | (37.723993571379, -122.474899060099) | 9 | 8 | 4 | 64 | 14 | |||
| 18601 | 262329 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 10X Sickles Ave | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x10 | 5996833 | 2086575 | 37.709156314989 | -122.452707876493 | (37.709156314989, -122.452707876493) | 9 | 7 | 6 | 28861 | 25 | ||||
| 18957 | 259263 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3580X 19th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | Permit Number 784388 | 5990529 | 2092111 | 37.723993571379 | -122.474899060099 | (37.723993571379, -122.474899060099) | 9 | 8 | 4 | 64 | 14 | |||
| 20037 | 100423 | Significant Tree 6 | Leptospermum laevigatum :: Australian Tea Tree 47 | 155 Winston Dr | 1 | Front Yard : Yard | Tree | Private 2 | 5990788 | 2093142.6 | 37.7268410933597 | -122.474078979965 | (37.7268410933597, -122.474078979965) | 9 | 8 | 4 | 64 | 40 | |||||
| 21096 | 253953 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 11X Ravenwood Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10x10 | 5994792 | 2096029 | 37.7349975719357 | -122.460446404237 | (37.7349975719357, -122.460446404237) | 9 | 8 | 4 | 59 | 40 | ||||
| 21762 | 100124 | Significant Tree 6 | Radermachera sinica :: China Doll Tree 394 | 40@ San Ramon Eastwood Dr | 1 | Front Yard : Yard | Tree | Private 2 | 5995635 | 2092781 | 37.7261278087338 | -122.457296979484 | (37.7261278087338, -122.457296979484) | 9 | 7 | 4 | 28861 | 40 | |||||
| 22688 | 120924 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 3995X Alemany Blvd | 7 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3X3 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | ||||
| 23065 | 98547 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 555@Rio Teresita Blvd | 3 | Front Yard : Yard | Tree | Private 2 | 5999006.5 | 2097247.3 | 37.7385842819574 | -122.445963035448 | (37.7385842819574, -122.445963035448) | 9 | 7 | 4 | 59 | 40 | |||||
| 23427 | 107541 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 2 GARFIELD ST | 4 | Back Yard : Yard | Tree | Private 2 | 36 | 5993976.6 | 2090624.3 | 37.7201106425596 | -122.462873531809 | (37.7201106425596, -122.462873531809) | 9 | 8 | 6 | 64 | 24 | ||||
| 24927 | 107413 | Significant Tree 6 | Pseudotsuga menziesii :: Douglas Fir 285 | 276 Yerba Buena Ave | 1 | Front Yard : Yard | Tree | Private 2 | 28 | 5995080.66446 | 2095640.15746 | 37.7339465073544 | -122.459420244296 | (37.7339465073544, -122.459420244296) | 9 | 8 | 4 | 59 | 40 | ||||
| 26477 | 253808 | Significant Tree 6 | Tree(s) :: 17 | 2 Garfield St | 2 | Side Yard : Yard | Tree | Private 2 | 09/14/2018 12:00:00 AM | 3 | 10x10 | Permit Number 780744 | 5993976 | 2090624 | 37.7201097842726 | -122.462875584037 | (37.7201097842726, -122.462875584037) | 9 | 8 | 6 | 64 | 24 | |
| 28198 | 106364 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 127 | 155 BORICA ST | 1 | Front Yard : Yard | Tree | Private 2 | 5992696 | 2092292.5 | 37.7246172684066 | -122.467421338179 | (37.7246172684066, -122.467421338179) | 9 | 8 | 4 | 59 | 40 | |||||
| 28942 | 110737 | Significant Tree 6 | Taxodium mucronatum :: Montezuma Cypress 400 | 1299x PERSIA AVE | 4 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6004594 | 2089787 | 37.7184174301537 | -122.426113167879 | (37.7184174301537, -122.426113167879) | 9 | 7 | 8 | 309 | 18 | ||||
| 29379 | 254551 | Significant Tree 6 | Cordyline australis :: Dracena Palm 64 | 1433 Cayuga Ave | 1 | Front Yard : Cutout | Tree | Private 2 | 6x6 | 5999129 | 2089595 | 37.7175798453783 | -122.444989533853 | (37.7175798453783, -122.444989533853) | 9 | 7 | 6 | 28861 | 25 | ||||
| 29607 | 101467 | Significant Tree 6 | Cupressocyparis leylandii :: Leyland Cypress 185 | 301 Hazelwood Ave | 2 | Front Yard : Yard | Tree | Private 2 | 5996219.7 | 2095283.8 | 37.7330334614805 | -122.455456526637 | (37.7330334614805, -122.455456526637) | 9 | 7 | 4 | 59 | 40 | |||||
| 32937 | 178336 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 401 Ocean Ave | 2 | Sidewalk: Property side : Yard | Tree | MTA 3 | 29 | Width 8ft | 5998664.9682 | 2091522.93582 | 37.7228470175482 | -122.44673211619 | (37.7228470175482, -122.44673211619) | 9 | 7 | 6 | 28861 | 25 | |||
| 34088 | 256489 | Significant Tree 6 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 | 2198X Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x10 | 5991651 | 2095488 | 37.7333309287491 | -122.471266448142 | (37.7333309287491, -122.471266448142) | 9 | 8 | 4 | 59 | 40 | ||||
| 34238 | 1283 | Significant Tree 6 | Ginkgo biloba :: Maidenhair Tree 22 | 3995X Alemany Blvd | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 10 | 10x10 | 5992081.50866 | 2087171.04221 | 37.7105194967412 | -122.469172961285 | (37.7105194967412, -122.469172961285) | 9 | 8 | 4 | 64 | 24 | |||
| 34696 | 253950 | Significant Tree 6 | Cedrus atlantica :: Atlas Cedar 233 | 431 Yerba Buena Ave | 1 | Front Yard : Cutout | Tree | Private 2 | 10x10 | 5995366 | 2094904 | 37.7319416000564 | -122.458380491445 | (37.7319416000564, -122.458380491445) | 9 | 7 | 4 | 59 | 40 | ||||
| 36038 | 115661 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 341 HAZELWOOD AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 5996066 | 2095432 | 37.7334315621613 | -122.455998615118 | (37.7334315621613, -122.455998615118) | 9 | 7 | 4 | 59 | 40 | |||
| 36628 | 177109 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 401 Ocean Ave | 16 | Sidewalk: Property side : Yard | Tree | MTA 3 | 6 | Width 5ft | 5998958.08532 | 2091518.52367 | 37.7228516427597 | -122.445718558684 | (37.7228516427597, -122.445718558684) | 9 | 7 | 6 | 28861 | 25 | |||
| 37139 | 98289 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 300 Mangels Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 01/24/2012 12:00:00 AM | Permit Number 768637 | 5999381.8 | 2095276.6 | 37.7331946288913 | -122.444523835506 | (37.7331946288913, -122.444523835506) | 9 | 7 | 4 | 59 | 40 | |||
| 38717 | 98546 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 555@Rio Teresita Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5999006.5 | 2097247.3 | 37.7385842819574 | -122.445963035448 | (37.7385842819574, -122.445963035448) | 9 | 7 | 4 | 59 | 40 | |||||
| 39321 | 120597 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 499x Ocean Ave | 5 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 5998874 | 2091543 | 37.7229140478676 | -122.446010982458 | (37.7229140478676, -122.446010982458) | 9 | 7 | 6 | 28861 | 25 | ||||
| 39767 | 254934 | Significant Tree 6 | Cedrus atlantica Glauca :: Blue Atlas Cedar 208 | 755 Ocean Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x6 | 5998003.33154 | 2091542.89024 | 37.7228639895457 | -122.449020681299 | (37.7228639895457, -122.449020681299) | 9 | 7 | 4 | 28861 | 24 | ||||
| 39795 | 116833 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 1750 Geneva Ave | 1 | Front Yard : Yard | Tree | Private 2 | 6004521.4 | 2087037.7 | 37.710864341935 | -122.42616849364 | (37.710864341935, -122.42616849364) | 9 | 7 | 6 | 309 | 5 | |||||
| 40307 | 86910 | Significant Tree 6 | Ilex spp :: Holly Species 81 | 1 Urbano Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 49875 | 5993901 | 2092133 | 37.7242488135215 | -122.463244271267 | (37.7242488135215, -122.463244271267) | 9 | 8 | 4 | 59 | 40 | |||
| 43517 | 88608 | Significant Tree 6 | Tree(s) :: 17 | 350 Urbano Dr | 1 | Front Yard : Cutout | Tree | Private 2 | 08/01/2008 12:00:00 AM | Permit Number 51562 | 5991996 | 2092560 | 37.7253113201117 | -122.469860593138 | (37.7253113201117, -122.469860593138) | 9 | 8 | 4 | 59 | 40 | |||
| 44800 | 120594 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 499x Ocean Ave | 2 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 5998874 | 2091543 | 37.7229140478676 | -122.446010982458 | (37.7229140478676, -122.446010982458) | 9 | 7 | 6 | 28861 | 25 | ||||
| 46153 | 209002 | Significant Tree 6 | Tree(s) :: 17 | 115 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 07/17/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 781950 | 5994125 | 2096751 | 37.7369416119865 | -122.462804803775 | (37.7369416119865, -122.462804803775) | 9 | 8 | 4 | 59 | 40 | |
| 47041 | 177110 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 401 Ocean Ave | 17 | Sidewalk: Property side : Yard | Tree | MTA 3 | 6 | Width 5ft | 5998978.57855 | 2091518.53644 | 37.722852847868 | -122.445647719081 | (37.722852847868, -122.445647719081) | 9 | 7 | 6 | 28861 | 25 | |||
| 47402 | 120930 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3995X Alemany Blvd | 13 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3X3 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | ||||
| 47483 | 113358 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 702 Foerster St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5998153.40008835 | 2095558.62470631 | 37.7338988325043 | -122.448791034412 | (37.7338988325043, -122.448791034412) | 9 | 7 | 4 | 59 | 40 | |||||
| 47565 | 116834 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 1750 Geneva Ave | 2 | Front Yard : Yard | Tree | Private 2 | 6004521.4 | 2087037.7 | 37.710864341935 | -122.42616849364 | (37.710864341935, -122.42616849364) | 9 | 7 | 6 | 309 | 5 | |||||
| 47809 | 116010 | Significant Tree 6 | Syzygium paniculatum :: Brush Cherry 243 | 199x SAN BUENAVENTURA WAY | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993547 | 2095667 | 37.7339319096844 | -122.464724497297 | (37.7339319096844, -122.464724497297) | 9 | 8 | 4 | 59 | 40 | ||||
| 48765 | 98082 | Significant Tree 6 | Pinus Spp :: Pine Spp 100 | 525 Grafton Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5995193.7 | 2090526.9 | 37.7199132334677 | -122.45865940878 | (37.7199132334677, -122.45865940878) | 9 | 8 | 6 | 28861 | 24 | |||||
| 48955 | 255537 | Significant Tree 6 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 93X Monterey Blvd | 1 | Side Yard : Cutout | Tree | Private 2 | 10x10 | 6001470 | 2094575 | 37.7313871286154 | -122.437254157834 | (37.7313871286154, -122.437254157834) | 9 | 7 | 4 | 63 | 40 | ||||
| 49633 | 177105 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 401 Ocean Ave | 12 | Sidewalk: Property side : Yard | Tree | MTA 3 | 4 | Width 5ft | 5998924.5969 | 2091518.78116 | 37.7228504376811 | -122.445834339179 | (37.7228504376811, -122.445834339179) | 9 | 7 | 6 | 28861 | 25 | |||
| 50856 | 1263 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3995X Alemany Blvd | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 12/02/1998 12:00:00 AM | 10 | 3X3 | Permit Number 778829 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | |
| 51080 | 120925 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3995X Alemany Blvd | 8 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3X3 | Permit Number 778829 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | |||
| 51266 | 255290 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3353 19th Ave | 1 | Side Yard : Cutout | Tree | Private 2 | 3x3 | 5990801 | 2093784 | 37.7286029699614 | -122.474080817952 | (37.7286029699614, -122.474080817952) | 9 | 8 | 4 | 64 | 40 | ||||
| 52054 | 255462 | Significant Tree 6 | Tree(s) :: 17 | 98 Saint Francis Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/24/2018 12:00:00 AM | 3 | 10x5 | Permit Number 777805 | 5992112.53458 | 2095987.97644 | 37.7347304251367 | -122.469707196177 | (37.7347304251367, -122.469707196177) | 9 | 8 | 4 | 59 | 40 | |
| 54303 | 178335 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 401 Ocean Ave | 1 | Sidewalk: Property side : Yard | Tree | MTA 3 | 33 | Width 8ft | 5998656.04486 | 2091523.12147 | 37.7228470175503 | -122.446762975526 | (37.7228470175503, -122.446762975526) | 9 | 7 | 6 | 28861 | 25 | |||
| 54695 | 256491 | Significant Tree 6 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 | 2198X Monterey Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x10 | 5991651 | 2095488 | 37.7333309287491 | -122.471266448142 | (37.7333309287491, -122.471266448142) | 9 | 8 | 4 | 59 | 40 | ||||
| 56399 | 254401 | Significant Tree 6 | Cedrus atlantica Glauca :: Blue Atlas Cedar 208 | 755 Ocean Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | Permit Number 779678 | 5998027 | 2091524 | 37.7228134749722 | -122.448937504689 | (37.7228134749722, -122.448937504689) | 9 | 7 | 4 | 28861 | 24 | |||
| 57339 | 177108 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 401 Ocean Ave | 15 | Sidewalk: Property side : Yard | Tree | MTA 3 | 5 | Width 5ft | 5998950.80755 | 2091518.23612 | 37.7228504376851 | -122.44574369564 | (37.7228504376851, -122.44574369564) | 9 | 7 | 6 | 28861 | 25 | |||
| 57424 | 101476 | Significant Tree 6 | :: 45 | 541 Congo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/2015 12:00:00 AM | 3 | Permit Number 775316 | 6000089 | 2095440.1 | 37.7336838892166 | -122.442090592963 | (37.7336838892166, -122.442090592963) | 9 | 7 | 4 | 63 | 40 | ||
| 58651 | 100191 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1201 Holloway Ave | 1 | Front Yard : Yard | Tree | Private 2 | 5992431.5 | 2091178.1 | 37.7215421255294 | -122.468254640211 | (37.7215421255294, -122.468254640211) | 9 | 8 | 6 | 64 | 24 | |||||
| 59395 | 114525 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1 TIOGA AVE | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6011351 | 2088602 | 37.7155432513192 | -122.402673611341 | (37.7155432513192, -122.402673611341) | 9 | 7 | 8 | 309 | 39 | |||||
| 59778 | 112374 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 52 | 1247 Bosworth St | 1 | Front Yard : Yard | Tree | Private 2 | 20x20 | Permit Number 775819 | 6000424.11007 | 2096055.79143 | 37.7353935258967 | -122.440976176652 | (37.7353935258967, -122.440976176652) | 9 | 7 | 4 | 63 | 40 | |||
| 59933 | 122637 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 3630X 19th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x8 | 5990614 | 2091411 | 37.7220764711857 | -122.47455416919 | (37.7220764711857, -122.47455416919) | 9 | 8 | 4 | 64 | 40 | ||||
| 60656 | 120926 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 3995X Alemany Blvd | 9 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3X3 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | ||||
| 61064 | 253428 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 3 Valletta Ct | 1 | Side Yard : Cutout | Tree | Private 2 | 6x10 | Permit Number 780575 | 5999319 | 2096479 | 37.7364925519579 | -122.444827352142 | (37.7364925519579, -122.444827352142) | 9 | 7 | 4 | 63 | 40 |
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) );