trees
194,517 rows sorted by qLegalStatus_id
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 440 | 204255 | DPW Maintained 1 | Arbutus unedo :: Strawberry Tree 106 | 40 Rossmoor Dr | 1 | : | Tree | Private 2 | 2 | Width 3ft | 5991076.25798 | 2094451.16026 | 37.7304507656815 | -122.473177880653 | (37.7304507656815, -122.473177880653) | 9 | 8 | 4 | 64 | 40 | |||
| 441 | 200380 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 199x Shipley St | 2 | : | Tree | Private 2 | 7 | Width 2ft | 6011866.27149 | 2112076.32254 | 37.7800274232626 | -122.402542323073 | (37.7800274232626, -122.402542323073) | 6 | 2 | 9 | 28856 | 34 | |||
| 442 | 119718 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 102x Octavia St Frontage East | 11 | Median : Cutout | Tree | DPW 1 | 2109802 | 6005691 | 47.2701255040516 | -138.282046982267 | (47.2701255040516, -138.282046982267) | ||||||||||
| 444 | 105900 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 11X ELLIOT ST | 1 | Unaccepted Street : Yard | Tree | DPW 1 | 30 | 6009059 | 2088845 | 37.716082244868 | -122.410612975888 | (37.716082244868, -122.410612975888) | 9 | 7 | 8 | 309 | 18 | ||||
| 446 | 182929 | DPW Maintained 1 | :: 45 | 2635 47th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5981797.6603 | 2097141.2975 | 37.73729554361 | -122.505454091008 | (37.73729554361, -122.505454091008) | 1 | 8 | 3 | 29491 | 35 | |||
| 448 | 17338 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 175X Otis St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/18/1993 12:00:00 AM | 12 | 3X3 | 6006718.5849914 | 2108715.6870946 | 37.7705111956623 | -122.420111956743 | (37.7705111956623, -122.420111956743) | 8 | 2 | 9 | 28853 | 19 | ||
| 449 | 252970 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 101X Whipple Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 04/26/2019 12:00:00 AM | 3 | |||||||||||||
| 450 | 178165 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 10 Brotherhood Way | 20 | Median : Cutout | Tree | Private 2 | 5 | Width 0ft | 5992928.58802 | 2087852.90738 | 37.7124406464989 | -122.466294818667 | (37.7124406464989, -122.466294818667) | 9 | 8 | 4 | 64 | 24 | |||
| 452 | 182004 | DPW Maintained 1 | :: 45 | 3220 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5986004.751 | 2098249.2905 | 37.7405844772428 | -122.490989950641 | (37.7405844772428, -122.490989950641) | 1 | 8 | 3 | 29491 | 35 | |||
| 454 | 11293 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1199X Ingalls St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 6017612.0195749 | 2093925.7037957 | 37.7305086962257 | -122.381402471608 | (37.7305086962257, -122.381402471608) | 10 | 3 | 8 | 58 | 1 | |||
| 455 | 30164 | DPW Maintained 1 | Shrub :: Shrub 66 | 410X Mansell St | 21 | Median : Cutout | Tree | DPW 1 | 0 | POT | 6010678.994322 | 2090457.626596 | 37.7206008798567 | -122.405126964413 | (37.7206008798567, -122.405126964413) | 10 | 3 | 7 | 309 | 28 | |||
| 456 | 247507 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 400x Divisadero St | 2 | Median : Cutout | Tree | DPW 1 | 3 | Width 0ft | 6001724.6395 | 2109878.2699 | 37.7734207168265 | -122.437469283257 | (37.7734207168265, -122.437469283257) | 15 | 5 | 11 | 29492 | 10 | |||
| 457 | 198704 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 1675 Bay Shore Blvd | 2 | : | Tree | Private 2 | 11 | Width 3ft | 6012158.49704 | 2090987.28634 | 37.7221378175792 | -122.400049934761 | (37.7221378175792, -122.400049934761) | 10 | 3 | 8 | 58 | 1 | |||
| 458 | 125288 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 943 Green St | 11 | Side Yard : Yard | Tree | Private 2 | 1 | 6008674.79926 | 2118995.08989 | 37.7988459853112 | -122.414072708211 | (37.7988459853112, -122.414072708211) | 5 | 1 | 10 | 308 | 21 | ||||
| 459 | 192393 | DPW Maintained 1 | Fremontodendron spp :: Flannel Bush Tree 107 | 1 24th St | 25 | : Yard | Tree | Private 2 | 3 | 6017132.65269 | 2102598.12552 | 37.7542949326738 | -122.38366328523 | (37.7542949326738, -122.38366328523) | 10 | 3 | 8 | 28856 | 29 | ||||
| 460 | 182240 | DPW Maintained 1 | :: 45 | 1427 34th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5985548.7085 | 2105482.2958 | 37.7604176820805 | -122.49309944026 | (37.7604176820805, -122.49309944026) | 1 | 8 | 3 | 56 | 35 | |||
| 464 | 173918 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2160X 09th Ave | 6 | Median : Cutout | Tree | DPW 1 | 6x10 | 5993671 | 2100995 | 37.7485684085064 | -122.464682560698 | (37.7485684085064, -122.464682560698) | 1 | 8 | 4 | 29491 | 40 | ||||
| 467 | 211626 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 299x Magellan Ave | 6 | Median : Cutout | Tree | DPW 1 | 6 | Width 6ft | 5994442.33797 | 2100102.58449 | 37.7461624991943 | -122.461950600334 | (37.7461624991943, -122.461950600334) | 1 | 8 | 4 | 29491 | 40 | |||
| 469 | 245799 | DPW Maintained 1 | Corymbia calophylla :: 108 | 50 Church St | 1 | : | Tree | Private 2 | 21 | Width 6ft | 6004070.93701 | 2108481.83175 | 37.7697195522468 | -122.429253511635 | (37.7697195522468, -122.429253511635) | 7 | 9 | 5 | 29492 | 10 | |||
| 470 | 119711 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 102x Octavia St Frontage East | 4 | Median : Cutout | Tree | DPW 1 | 2109802 | 6005691 | 47.2701255040516 | -138.282046982267 | (47.2701255040516, -138.282046982267) | ||||||||||
| 471 | 205972 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 400x Marietta Dr | 49 | Median : Cutout | Tree | DPW 1 | 2 | Width 3ft | 5998976.04571 | 2096922.6715 | 37.7376911903888 | -122.446044988292 | (37.7376911903888, -122.446044988292) | 9 | 7 | 4 | 59 | 40 | |||
| 472 | 221573 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 40 Elgin Park | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6005806.54195 | 2108839.22973 | 37.7707989842145 | -122.423275507581 | (37.7707989842145, -122.423275507581) | 8 | 2 | 5 | 28853 | 19 | |||
| 473 | 175337 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 114 De Long St | 4 | : | Tree | Private 2 | 14 | Width 3ft | 5994455.45704 | 2086824.92953 | 37.7097060419823 | -122.460943071888 | (37.7097060419823, -122.460943071888) | 9 | 8 | 6 | 28861 | 25 | |||
| 474 | 231615 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 123 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5997901.04644 | 2106790.55861 | 37.7647245269317 | -122.450472936196 | (37.7647245269317, -122.450472936196) | 15 | 5 | 11 | 29492 | 9 | |||
| 477 | 113497 | DPW Maintained 1 | Tree(s) :: 17 | 200x MANSELL ST | 3 | Median : Cutout | Tree | DPW 1 | 3x3 | 6011136 | 2090597 | 37.7210091086741 | -122.403557031831 | (37.7210091086741, -122.403557031831) | 10 | 3 | 7 | 309 | 28 | ||||
| 478 | 104347 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 417 31st Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 4x9 | 5986214.92159 | 2113090.52274 | 37.7813466727453 | -122.49135533617 | (37.7813466727453, -122.49135533617) | 11 | 6 | 2 | 55 | 26 | |||
| 480 | 225991 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 99 Laussat St | 2 | : | Tree | Private 2 | 1 | Width 3ft | 6004313.0789 | 2109253.93974 | 37.7718532783246 | -122.428470991768 | (37.7718532783246, -122.428470991768) | 7 | 9 | 11 | 28852 | 10 | |||
| 481 | 119782 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 202x Octavia St Frontage East | 2 | Median : Cutout | Tree | DPW 1 | 2110143 | 6005643 | 47.270172161735 | -138.280681481725 | (47.270172161735, -138.280681481725) | ||||||||||
| 482 | 175383 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3001 Ocean Ave | 1 | : | Tree | Private 2 | 8 | Width 3ft | 5989487.94212 | 2095224.7734 | 37.7324828171076 | -122.478725410769 | (37.7324828171076, -122.478725410769) | 1 | 8 | 4 | 64 | 35 | |||
| 483 | 173928 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 51 Vulcan Stwy | 1 | Front Yard : Cutout | Tree | Private 2 | 6000543 | 2106304 | 37.7635394137592 | -122.441300222472 | (37.7635394137592, -122.441300222472) | 15 | 5 | 5 | 28862 | 3 | |||||
| 484 | 182121 | DPW Maintained 1 | :: 45 | 2516 Ulloa St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5988187.7408 | 2098326.2815 | 37.7409231701359 | -122.483447748483 | (37.7409231701359, -122.483447748483) | 1 | 8 | 3 | 29491 | 35 | |||
| 485 | 251655 | DPW Maintained 1 | Shrub :: Shrub 66 | 300x Chester Ave | 1 | Sidewalk: Property side : Yard | Tree | DPW 1 | 3x3 | 5991691 | 2087193 | 37.7105572148468 | -122.470524229297 | (37.7105572148468, -122.470524229297) | 9 | 8 | 4 | 64 | 24 | ||||
| 486 | 251556 | DPW Maintained 1 | Tree(s) :: 17 | 299 Clinton Park | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004847 | 2108161 | 37.7688825293039 | -122.426546282794 | (37.7688825293039, -122.426546282794) | 8 | 4 | 5 | 28862 | 19 | ||||
| 487 | 5304 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1635 Divisadero St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3X3 | 6001115.9968 | 2113959.0141 | 37.7845907831124 | -122.439867300639 | (37.7845907831124, -122.439867300639) | 15 | 6 | 11 | 29490 | 13 | |||
| 488 | 20353 | DPW Maintained 1 | Acacia decurrens :: Acacia: Silver Wattle 111 | 262X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 60 | |||||||||||||
| 489 | 225574 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 99 Carmelita St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6002579.4442 | 2108765.68107 | 37.7704143837497 | -122.434432832327 | (37.7704143837497, -122.434432832327) | 15 | 5 | 5 | 29492 | 9 | |||
| 490 | 201018 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2427 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6015837.6438 | 2104277.44784 | 37.7588343299688 | -122.388258987278 | (37.7588343299688, -122.388258987278) | 10 | 3 | 8 | 28856 | 29 | |||
| 491 | 246210 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 725 Buena Vista Ave West | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/2019 12:00:00 AM | 3 | Width 0ft | 5999854.0817 | 2107930.8602 | 37.7679670970626 | -122.443799851593 | (37.7679670970626, -122.443799851593) | 15 | 5 | 11 | 29492 | 9 | ||
| 493 | 193117 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1789 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6014368.11598 | 2096649.52963 | 37.737808141841 | -122.39280769162 | (37.737808141841, -122.39280769162) | 10 | 3 | 8 | 58 | 1 | |||
| 494 | 126450 | DPW Maintained 1 | Casuarina cunninghamiana :: Horsetail pine 112 | 2401 Broadway | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 4ft | 6002086.73219 | 2117346.55126 | 37.7939472989795 | -122.436751464412 | (37.7939472989795, -122.436751464412) | 13 | 9 | 1 | 29490 | 27 | |||
| 496 | 6869 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 170 Fell St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/22/2008 12:00:00 AM | 4 | 5x5 | 6006554.4326182 | 2110816.1011215 | 37.7762691791752 | -122.420828904096 | (37.7762691791752, -122.420828904096) | 7 | 9 | 11 | 28852 | 10 | ||
| 497 | 133485 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 100 Spruce St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 5997070.63549 | 2115917.82612 | 37.7897380545196 | -122.454004325646 | (37.7897380545196, -122.454004325646) | 11 | 6 | 1 | 54 | 31 | |||
| 498 | 260403 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 500X Brotherhood Way | 1 | Median : Yard | Tree | Private 2 | 30x30 | 5992691 | 2087881 | 37.712504070633 | -122.467118029673 | (37.712504070633, -122.467118029673) | 9 | 8 | 6 | 64 | 24 | ||||
| 500 | 230695 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 174 Hancock St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6003158.12549 | 2105079.13528 | 37.7603248546353 | -122.432167861868 | (37.7603248546353, -122.432167861868) | 2 | 4 | 5 | 28862 | 3 | |||
| 503 | 64636 | DPW Maintained 1 | Chitalpa tashkentensis :: 114 | 1340 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/1993 12:00:00 AM | 4 | Permit Number 31906 | 6008274 | 2116946 | 37.7931971721852 | -122.415314473397 | (37.7931971721852, -122.415314473397) | 5 | 1 | 10 | 28858 | 21 | ||
| 504 | 78734 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 901 Huron Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5997023.15719 | 2086886.03529 | 37.710021240846 | -122.452073093618 | (37.710021240846, -122.452073093618) | 9 | 7 | 6 | 28861 | 25 | |||
| 505 | 71223 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2245 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5987597.8172 | 2100005.1583 | 37.7454985686348 | -122.485610641464 | (37.7454985686348, -122.485610641464) | 1 | 8 | 3 | 29491 | 35 | |||
| 507 | 195311 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 101 Market St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6013845.70185 | 2116893.75953 | 37.7933653000223 | -122.396032227918 | (37.7933653000223, -122.396032227918) | 12 | 2 | 9 | 28855 | 6 | |||
| 509 | 19905 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY35 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 120ST | |||||||||||||
| 510 | 138618 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1844 BRODERICK ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6000524.7294 | 2115065.5231 | 37.787595296239 | -122.441992330061 | (37.787595296239, -122.441992330061) | 13 | 6 | 1 | 29490 | 27 | |||
| 511 | 23082 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1304 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/01/1990 12:00:00 AM | 12 | 4x4 | 6006396.78239 | 2101930.96357 | 37.7518637944919 | -122.420743341327 | (37.7518637944919, -122.420743341327) | 2 | 4 | 5 | 28859 | 19 | ||
| 512 | 126120 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2843 Larkin St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 5ft | 6006458.53093 | 2121044.25925 | 37.8043477551992 | -122.421887372509 | (37.8043477551992, -122.421887372509) | 5 | 9 | 1 | 28858 | 32 | |||
| 513 | 159793 | DPW Maintained 1 | Ulmus 'Frontier' :: Frontier Elm 115 | 2555 Alemany Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5998756.20778 | 2088659.33531 | 37.7149894402837 | -122.446210834072 | (37.7149894402837, -122.446210834072) | 9 | 7 | 6 | 28861 | 25 | |||
| 516 | 228148 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 330 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6006164.28194 | 2098136.5344 | 37.7414320472565 | -122.421277938832 | (37.7414320472565, -122.421277938832) | 2 | 7 | 7 | 28859 | 2 | |||
| 518 | 70144 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 8 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5991175.64413 | 2115000.10527 | 37.7868784805694 | -122.474333220033 | (37.7868784805694, -122.474333220033) | 11 | 6 | 1 | 54 | 33 | |||
| 519 | 259637 | DPW Maintained 1 | :: 45 | 95 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6010745.67067 | 2087724.79538 | 37.7131008096728 | -122.404704194453 | (37.7131008096728, -122.404704194453) | 9 | 7 | 8 | 309 | 39 | ||
| 520 | 200766 | DPW Maintained 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 | 1901 Lane St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 3x10 | 6014720.1223 | 2093871.3227 | 37.7301992962685 | -122.391396463309 | (37.7301992962685, -122.391396463309) | 10 | 3 | 8 | 58 | 1 | |||
| 522 | 74913 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1600 Cabrillo St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 5990592.63982 | 2110647.77936 | 37.7748944063775 | -122.476032267507 | (37.7748944063775, -122.476032267507) | 11 | 6 | 2 | 55 | 26 | |||
| 526 | 262229 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 1970 Post St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 6002649 | 2114114 | 37.7851034789316 | -122.434574718683 | (37.7851034789316, -122.434574718683) | 13 | 9 | 11 | 29490 | 13 | ||||
| 527 | 32100 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 156 Hartford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1995 12:00:00 AM | 10 | Permit Number 35473 | 6002658.19542 | 2104999.95129 | 37.7600790771166 | -122.433891224619 | (37.7600790771166, -122.433891224619) | 2 | 4 | 5 | 28862 | 3 | |
| 529 | 131532 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 899 Powell St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6009999.72804 | 2116574.87915 | 37.7922750033291 | -122.409317116588 | (37.7922750033291, -122.409317116588) | 5 | 1 | 10 | 28857 | 21 | |||
| 535 | 50166 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 159 Russ St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/11/2003 12:00:00 AM | 3 | 3x3 | Permit Number 46878 | 6010492.5895 | 2111415.08321 | 37.7781350293519 | -122.407247904281 | (37.7781350293519, -122.407247904281) | 14 | 2 | 9 | 28853 | 34 | |
| 536 | 219915 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2812 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6008948.08164 | 2102119.36708 | 37.752524574948 | -122.411933873046 | (37.752524574948, -122.411933873046) | 2 | 4 | 7 | 28859 | 19 | |||
| 537 | 261951 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1X Portola Dr To Clipper St Connetion | 5 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
| 538 | 214628 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1442 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5992754.41359 | 2105631.11276 | 37.7612450859223 | -122.468189283707 | (37.7612450859223, -122.468189283707) | 1 | 8 | 4 | 56 | 12 | |||
| 539 | 178708 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 500 London St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 3 | Width 3ft | 6001593.53028 | 2090821.75006 | 37.721088578565 | -122.436558547244 | (37.721088578565, -122.436558547244) | 9 | 7 | 6 | 28861 | 5 | ||
| 540 | 35140 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 911 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1998 12:00:00 AM | 7 | Permit Number 38670 | 6001882.60594 | 2088665.49745 | 37.7151844124098 | -122.435405132561 | (37.7151844124098, -122.435405132561) | 9 | 7 | 6 | 28861 | 5 | |
| 541 | 225969 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 3599 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | 3x3 | 6005840.01853 | 2101965.47506 | 37.7519271589233 | -122.422671163153 | (37.7519271589233, -122.422671163153) | 2 | 4 | 5 | 28859 | 19 | |||
| 544 | 259763 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2701 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/12/2019 12:00:00 AM | 3 | |||||||||||||
| 545 | 90279 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4338 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5982078.08793 | 2111023.84587 | 37.7754295872152 | -122.505513277346 | (37.7754295872152, -122.505513277346) | 11 | 6 | 2 | 55 | 26 | ||
| 546 | 166267 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3574 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2020 12:00:00 AM | 3 | Width 3ft | 6006475.94954 | 2104385.51361 | 37.7586078842643 | -122.420643797174 | (37.7586078842643, -122.420643797174) | 2 | 4 | 7 | 28859 | 19 | ||
| 547 | 228103 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 291 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6004325 | 2096691 | 37.7373590721786 | -122.427534581259 | (37.7373590721786, -122.427534581259) | 2 | 7 | 5 | 63 | 7 | |||
| 550 | 19742 | DPW Maintained 1 | Melaleuca spp :: Melaleuca spp 117 | 100 STAIRWAY15 | -9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 1OST | |||||||||||||
| 552 | 78931 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2701 Kirkham St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5986423.7343 | 2105012.1654 | 37.7591779705862 | -122.490038592243 | (37.7591779705862, -122.490038592243) | 1 | 8 | 3 | 56 | 35 | |||
| 553 | 12808 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2112 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 5 | 5988878.34651 | 2114712.3148 | 37.7859549296707 | -122.482260152644 | (37.7859549296707, -122.482260152644) | 11 | 6 | 1 | 55 | 33 | |||
| 555 | 133914 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2830 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6000461.7314 | 2116836.01303 | 37.7924530097486 | -122.442337442312 | (37.7924530097486, -122.442337442312) | 13 | 6 | 1 | 29490 | 27 | |||
| 556 | 116312 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1515 Scott St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 6001647.9793 | 2113762.7776 | 37.784082235457 | -122.438012762917 | (37.784082235457, -122.438012762917) | 15 | 6 | 11 | 29490 | 13 | ||||
| 558 | 230313 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 968 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6010194.52879 | 2103588.60829 | 37.7566286356186 | -122.407727015404 | (37.7566286356186, -122.407727015404) | 2 | 4 | 7 | 28859 | 19 | |||
| 559 | 65188 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 259 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/1989 12:00:00 AM | 15 | 3x3 | Permit Number 27172 | 6002967.27009 | 2091905.51259 | 37.7241423183013 | -122.431887278791 | (37.7241423183013, -122.431887278791) | 9 | 7 | 6 | 28861 | 5 |
| 560 | 97763 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 115 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/08/2011 12:00:00 AM | 1 | Permit Number 768298 | 5996511.5635 | 2113681.1555 | 37.783564683267 | -122.455776900676 | (37.783564683267, -122.455776900676) | 11 | 6 | 1 | 54 | 31 | ||
| 561 | 19835 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 100 STAIRWAY25 | 19 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60X | |||||||||||||
| 562 | 18470 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1221 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/21/2003 12:00:00 AM | 12 | 3X3 | 6010619.64201 | 2102143.08548 | 37.7526833394657 | -122.406154975289 | (37.7526833394657, -122.406154975289) | 10 | 4 | 8 | 28859 | 19 | ||
| 564 | 67334 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 801 University St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/21/1992 12:00:00 AM | 12 | Permit Number 30818 | 6008868.73151 | 2090340.18885 | 37.7201770527016 | -122.411376204361 | (37.7201770527016, -122.411376204361) | 9 | 3 | 7 | 309 | 28 | |
| 565 | 170476 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 46 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2019 12:00:00 AM | 3 | Width 3ft | 6003788.04729 | 2094625.21712 | 37.7316565146416 | -122.429243816075 | (37.7316565146416, -122.429243816075) | 9 | 7 | 5 | 28861 | 25 | ||
| 566 | 260237 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2201x 22nd Ave | 33 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/20/2018 12:00:00 AM | 3 | ||||||||||||
| 567 | 181420 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1500 Sunset Blvd | 53 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 0ft | 5984891.1718 | 2104759.369 | 37.7583942485176 | -122.495320206303 | (37.7583942485176, -122.495320206303) | 1 | 8 | 3 | 56 | 35 | |||
| 568 | 78813 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 110 Foote Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5998921.12979 | 2088066.27223 | 37.713370441156 | -122.445598173631 | (37.713370441156, -122.445598173631) | 9 | 7 | 6 | 28861 | 25 | |||
| 570 | 259611 | DPW Maintained 1 | :: 45 | 1420 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6008434.50928 | 2087674.99824 | 37.7128346308013 | -122.412688855365 | (37.7128346308013, -122.412688855365) | 9 | 7 | 8 | 309 | 39 | ||
| 572 | 130258 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 501 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6007346.42047 | 2122267.68592 | 37.8077570059352 | -122.418901572974 | (37.8077570059352, -122.418901572974) | 5 | 1 | 10 | 308 | 23 | |||
| 573 | 227463 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 238 Corbett Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 2ft | 5999836.92244 | 2105557.8617 | 37.7614504560077 | -122.443688706966 | (37.7614504560077, -122.443688706966) | 15 | 5 | 5 | 28862 | 3 | |||
| 574 | 259403 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 1318 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/13/2018 12:00:00 AM | 3 | 5x5 | 6016589.71081 | 2093303.84603 | 37.7287447049521 | -122.384893469396 | (37.7287447049521, -122.384893469396) | 10 | 3 | 8 | 58 | 1 | |
| 575 | 190079 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 800 19th St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 10ft | 6015106.31857 | 2105340.09052 | 37.761711568763 | -122.390862535375 | (37.761711568763, -122.390862535375) | 10 | 3 | 8 | 28856 | 29 | |||
| 576 | 196628 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 147 Natoma St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6012615.71361 | 2114306.35859 | 37.78619239642 | -122.400106306963 | (37.78619239642, -122.400106306963) | 12 | 2 | 9 | 28855 | 6 | |||
| 577 | 205386 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1 Rosewood Dr | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 3ft | 5994512.47364 | 2095959.37509 | 37.7347903147287 | -122.461407773158 | (37.7347903147287, -122.461407773158) | 9 | 8 | 4 | 59 | 40 | |||
| 578 | 221823 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 199X Ogden Ave | 6 | Sidewalk: Curb side : Pot | Tree | Private 2 | 13 | Width 4ft | 6007760.27568 | 2096148.55485 | 37.7360633428545 | -122.415618808282 | (37.7360633428545, -122.415618808282) | 2 | 7 | 7 | 28859 | 2 | |||
| 579 | 41331 | DPW Maintained 1 | Cinnamomum camphora :: Camphor Tree 90 | 1099 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/25/2000 12:00:00 AM | 8 | Permit Number 41989 | 6015098.10078 | 2102956.66001 | 37.7551667237886 | -122.390724391438 | (37.7551667237886, -122.390724391438) | 10 | 3 | 8 | 28856 | 29 | |
| 580 | 65382 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1709 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/29/1989 12:00:00 AM | 9 | Permit Number 28221 | 6000542.2902 | 2114603.4223 | 37.7863274878262 | -122.441898393886 | (37.7863274878262, -122.441898393886) | 13 | 6 | 1 | 29490 | 27 | |
| 581 | 248465 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 772 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5997147.6982 | 2107925.2578 | 37.7677969745346 | -122.453160476336 | (37.7677969745346, -122.453160476336) | 15 | 5 | 11 | 29492 | 9 | |||
| 582 | 20409 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 451X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 10 | |||||||||||||
| 583 | 206275 | DPW Maintained 1 | Tree(s) :: 17 | 531 Saint Francis Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 07/17/2018 12:00:00 AM | 3 | Width 8ft | Permit Number 781881 | 5993329.29471 | 2096110.62255 | 37.7351374332273 | -122.465509381364 | (37.7351374332273, -122.465509381364) | 1 | 8 | 4 | 59 | 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) );