trees
194,517 rows sorted by DBH 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
114469 | 141190 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1771 ELLIS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9999 | Width 0ft | 6002407.0405 | 2112959.471 | 37.7819196963173 | -122.435329208056 | (37.7819196963173, -122.435329208056) | 15 | 5 | 11 | 29490 | 41 | |||
26583 | 108044 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2901X SUNSET BLVD OFF RAMP | 2 | Median : Yard | Tree | DPW 1 | 99 | 5985539 | 2095817 | 37.7338788340947 | -122.492421243764 | (37.7338788340947, -122.492421243764) | 1 | 8 | 4 | 64 | 35 | ||||
30720 | 186155 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1700 Sunset Blvd | 40 | Sidewalk: Property side : Yard | Tree | Private 2 | 99 | Width 0ft | 5984957.7478 | 2103324.5301 | 37.7544584761874 | -122.494984162752 | (37.7544584761874, -122.494984162752) | 1 | 8 | 3 | 56 | 35 | |||
30729 | 98333 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 12X Canyon Dr | 2 | Median : Cutout | Tree | DPW 1 | 99 | 6003235.70781 | 2086338.01389 | 37.7088704018082 | -122.430562249152 | (37.7088704018082, -122.430562249152) | 9 | 7 | 6 | 28861 | 5 | ||||
55229 | 185035 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2701 Sunset Blvd | 61 | Sidewalk: Property side : Yard | Tree | Private 2 | 99 | Width 0ft | 5985023.8956 | 2096287.7176 | 37.7351411700064 | -122.494236773234 | (37.7351411700064, -122.494236773234) | 1 | 8 | 3 | 29491 | 35 | |||
57542 | 184735 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1301 Sunset Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 99 | Width 0ft | 5984680.1977 | 2106291.6891 | 37.7625892162308 | -122.496162889393 | (37.7625892162308, -122.496162889393) | 1 | 8 | 3 | 56 | 35 | |||
62709 | 185074 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2801 Sunset Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 99 | Width 0ft | 5984997.7254 | 2096135.7209 | 37.7347222961152 | -122.494316051543 | (37.7347222961152, -122.494316051543) | 1 | 8 | 3 | 29491 | 35 | |||
92340 | 186402 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1801 Sunset Blvd | 69 | Sidewalk: Property side : Yard | Tree | Private 2 | 99 | Width 0ft | 5984820.6527 | 2102319.266 | 37.7516902715465 | -122.495384132242 | (37.7516902715465, -122.495384132242) | 1 | 8 | 3 | 56 | 35 | |||
123285 | 107037 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1060 Clayton St | 1 | Front Yard : Yard | Tree | Private 2 | 99 | 5998985 | 2106259 | 37.7633269800406 | -122.446685590868 | (37.7633269800406, -122.446685590868) | 15 | 5 | 5 | 29492 | 9 | ||||
136451 | 187008 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2501 Sunset Blvd | 27 | Sidewalk: Property side : Yard | Tree | Private 2 | 99 | Width 0ft | 5984967.4388 | 2098043.05 | 37.7399575385403 | -122.494561323189 | (37.7399575385403, -122.494561323189) | 1 | 8 | 3 | 29491 | 35 | |||
168292 | 186361 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1801 Sunset Blvd | 28 | Sidewalk: Property side : Yard | Tree | Private 2 | 99 | Width 0ft | 5984795.4735 | 2102590.7965 | 37.752434345234 | -122.495491228463 | (37.752434345234, -122.495491228463) | 1 | 8 | 3 | 56 | 35 | |||
171755 | 184346 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1251 Sunset Blvd | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 99 | Width 0ft | 5984686.7384 | 2106407.7493 | 37.7629082680796 | -122.496148830979 | (37.7629082680796, -122.496148830979) | 1 | 8 | 3 | 56 | 35 | |||
178133 | 108046 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2901X SUNSET BLVD ON RAMP | 3 | Median : Yard | Tree | DPW 1 | 99 | 5985273 | 2095807 | 37.7338358213683 | -122.493340136435 | (37.7338358213683, -122.493340136435) | 1 | 8 | 4 | 64 | 35 | ||||
192427 | 185929 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 2000 Sunset Blvd | 72 | Sidewalk: Property side : Yard | Tree | Private 2 | 99 | Width 0ft | 5985012.7201 | 2101493.4926 | 37.7494341681805 | -122.494659074897 | (37.7494341681805, -122.494659074897) | 1 | 8 | 3 | 29491 | 35 | |||
193206 | 186256 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1701 Sunset Blvd | 67 | Sidewalk: Property side : Yard | Tree | Private 2 | 99 | Width 0ft | 5984812.6153 | 2103003.1364 | 37.7535675206606 | -122.495462358835 | (37.7535675206606, -122.495462358835) | 1 | 8 | 3 | 56 | 35 | |||
140443 | 185710 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2101 Sunset Blvd | 42 | Sidewalk: Property side : Yard | Tree | Private 2 | 95 | Width 0ft | 5984848.6658 | 2100421.3565 | 37.7464807716884 | -122.495147319794 | (37.7464807716884, -122.495147319794) | 1 | 8 | 3 | 29491 | 35 | |||
174949 | 3003 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2356 California St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 95 | 3X3 | 6003075.29819 | 2115553.9711 | 37.7890814648974 | -122.433202787296 | (37.7890814648974, -122.433202787296) | 13 | 9 | 1 | 29490 | 27 | |||
189954 | 3057 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2725 California St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 95 | 3X3 | 6001337.5504485 | 2115252.7303217 | 37.7881556043161 | -122.439193558833 | (37.7881556043161, -122.439193558833) | 13 | 6 | 1 | 29490 | 27 | |||
122681 | 217519 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 125 Marston Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 94 | Width 10ft | 5998618.10798 | 2093180.61105 | 37.7273959305753 | -122.447013334218 | (37.7273959305753, -122.447013334218) | 9 | 7 | 4 | 28861 | 40 | |||
374 | 5332 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 125 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 6x7 | 6004849.91389 | 2107615.96816 | 37.7673861676625 | -122.426497389946 | (37.7673861676625, -122.426497389946) | 8 | 4 | 5 | 28862 | 19 | |||
906 | 25069 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1000X Dolores St | 12 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005114.64614 | 2102050.12648 | 37.752118640771 | -122.425185628926 | (37.752118640771, -122.425185628926) | 2 | 4 | 5 | 28862 | 22 | |||
1012 | 24992 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 340 Dolores St | 3 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004882.50848 | 2106257.62148 | 37.7636583150142 | -122.426287928865 | (37.7636583150142, -122.426287928865) | 8 | 4 | 5 | 28859 | 3 | |||
1898 | 1593 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 699 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 5995612.08469 | 2111572.44274 | 37.7777230574603 | -122.458736017911 | (37.7777230574603, -122.458736017911) | 11 | 6 | 2 | 54 | 11 | |||
3912 | 25133 | DPW Maintained 1 | Brahea edulis :: Guadalupe Palm 218 | 1600X Dolores St | 3 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005290.85076 | 2098882.50869 | 37.7434310422981 | -122.424351009516 | (37.7434310422981, -122.424351009516) | 2 | 7 | 5 | 63 | 22 | |||
4143 | 5341 | DPW Maintained 1 | Aesculus x carnea :: Red Horse Chestnut 267 | 170 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 5x5 | 6004776.50982 | 2107393.36664 | 37.7667708074641 | -122.426735430613 | (37.7667708074641, -122.426735430613) | 8 | 4 | 5 | 28862 | 3 | |||
4388 | 12732 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1619 Lake St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 3X3 | 5990481.52989 | 2114717.45643 | 37.7860621686584 | -122.476714011555 | (37.7860621686584, -122.476714011555) | 11 | 6 | 2 | 55 | 26 | |||
5517 | 4664 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 600X Columbus Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 5X5 | 6009692.468 | 2119649.5892 | 37.8007001848924 | -122.410597470914 | (37.8007001848924, -122.410597470914) | 3 | 1 | 10 | 308 | 23 | |||
6635 | 8146 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1000 Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 4X4 | 6002926.0085 | 2111351.5233 | 37.7775341328911 | -122.433418880148 | (37.7775341328911, -122.433418880148) | 15 | 5 | 11 | 29492 | 41 | |||
9158 | 4659 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 600X Columbus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 5X5 | 6009780.1976 | 2119571.0943 | 37.8004895753531 | -122.410288343699 | (37.8004895753531, -122.410288343699) | 3 | 1 | 10 | 308 | 23 | |||
9423 | 25058 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1000X Dolores St | 1 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005092.48697 | 2102458.1018 | 37.753237594342 | -122.425291287561 | (37.753237594342, -122.425291287561) | 2 | 4 | 5 | 28862 | 22 | |||
14485 | 28138 | DPW Maintained 1 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 | 418 Eugenia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 4X5 | 6006975.95767 | 2097881.62293 | 37.7407778444163 | -122.418453367928 | (37.7407778444163, -122.418453367928) | 2 | 7 | 7 | 28859 | 2 | |||
15166 | 10340 | DPW Maintained 1 | Tristania conferta :: 61 | 914 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X4 | 6001716.4806 | 2109101.7503 | 37.7712881236094 | -122.437441889428 | (37.7712881236094, -122.437441889428) | 15 | 5 | 11 | 29492 | 9 | |||
15633 | 25139 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Dolores St | 5 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005326.84877 | 2098252.91312 | 37.7417043484808 | -122.424181770586 | (37.7417043484808, -122.424181770586) | 2 | 7 | 5 | 63 | 7 | |||
17335 | 24980 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 292 Dolores St | 7 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004817.9533669 | 2106647.0197828 | 37.7647238606763 | -122.426538934247 | (37.7647238606763, -122.426538934247) | 8 | 4 | 5 | 28862 | 3 | |||
17759 | 8164 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1108 Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 3x3 | 6002345.91863 | 2111334.94694 | 37.7774556905463 | -122.435424415956 | (37.7774556905463, -122.435424415956) | 15 | 5 | 11 | 29492 | 41 | |||
18337 | 113889 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 1x STORRIE ST | 2 | Sidewalk: Property side : Yard | Tree | DPW 1 | 90 | 6000722 | 2105303 | 37.7608011093363 | -122.440609317727 | (37.7608011093363, -122.440609317727) | 15 | 4 | 5 | 28862 | 3 | ||||
18928 | 25136 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Dolores St | 2 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005320.97591 | 2098341.7574 | 37.7419479631307 | -122.424208394127 | (37.7419479631307, -122.424208394127) | 2 | 7 | 5 | 63 | 7 | |||
19153 | 5691 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1545 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6005346 | 2099395 | 37.7448413407379 | -122.424196757704 | (37.7448413407379, -122.424196757704) | 2 | 7 | 5 | 28859 | 22 | |||
19729 | 25157 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2X Dolores St | 5 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004782.44605 | 2108032.94108 | 37.7685272607631 | -122.426760449752 | (37.7685272607631, -122.426760449752) | 8 | 4 | 5 | 28862 | 3 | |||
20255 | 185965 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2001 Sunset Blvd | 24 | Sidewalk: Property side : Yard | Tree | Private 2 | 90 | Width 0ft | 5984859.6467 | 2101291.1753 | 37.7488696995369 | -122.4951734814 | (37.7488696995369, -122.4951734814) | 1 | 8 | 3 | 29491 | 35 | |||
20644 | 14589 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1221 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 5999408.7715 | 2108648.7165 | 37.7699127394546 | -122.445391746523 | (37.7699127394546, -122.445391746523) | 15 | 5 | 11 | 29492 | 9 | |||
20670 | 24996 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 400X Dolores St | 1 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004898.74738 | 2105973.30508 | 37.7628785677218 | -122.42621152066 | (37.7628785677218, -122.42621152066) | 8 | 4 | 5 | 28859 | 3 | |||
21370 | 25043 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 892X Dolores St | 8 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005007.5951373 | 2103153.9131268 | 37.7551433335372 | -122.425634379859 | (37.7551433335372, -122.425634379859) | 2 | 4 | 5 | 28862 | 22 | |||
22214 | 23712 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 703 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 4X4 | 6003969.6344427 | 2111125.822349 | 37.7769735674529 | -122.429792527426 | (37.7769735674529, -122.429792527426) | 7 | 9 | 11 | 29492 | 10 | |||
22605 | 11290 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1199X Ingalls St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6017612.0195749 | 2093925.7037957 | 37.7305086962257 | -122.381402471608 | (37.7305086962257, -122.381402471608) | 10 | 3 | 8 | 58 | 1 | |||
23101 | 11356 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1339 Ingalls St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6017292.9099838 | 2093920.0801467 | 37.7304756321775 | -122.382505299944 | (37.7304756321775, -122.382505299944) | 10 | 3 | 8 | 58 | 1 | |||
23966 | 25090 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1250X Dolores St | 5 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005182.99372 | 2100845.43458 | 37.7488146961375 | -122.424863573617 | (37.7488146961375, -122.424863573617) | 2 | 4 | 5 | 28859 | 22 | |||
25173 | 5666 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1386 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 4x4 | 6005171.18394 | 2100267.5671 | 37.747227337869 | -122.424863305591 | (37.747227337869, -122.424863305591) | 2 | 7 | 5 | 63 | 22 | |||
25582 | 25084 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1200X Dolores St | 4 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005164.22411 | 2101175.53736 | 37.7497200220711 | -122.424951961675 | (37.7497200220711, -122.424951961675) | 2 | 4 | 5 | 28859 | 22 | |||
25612 | 1467 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 200 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 5995559.29766 | 2114744.31119 | 37.7864291269501 | -122.459148361674 | (37.7864291269501, -122.459148361674) | 11 | 6 | 1 | 54 | 31 | |||
27682 | 27481 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 850X Dolores St | 6 | Median : Cutout | Tree | DPW 1 | 10/04/1999 12:00:00 AM | 90 | 20 | 6005053.38343 | 2103172.36846 | 37.755196594762 | -122.425477343801 | (37.755196594762, -122.425477343801) | 2 | 4 | 5 | 28862 | 22 | ||
27711 | 3410 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 6528 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 3X3 | 5987293.52978 | 2113992.83204 | 37.7838871248275 | -122.487690236342 | (37.7838871248275, -122.487690236342) | 11 | 6 | 1 | 55 | 33 | |||
27899 | 1421 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 50 Arguello Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 3x12 | 5995527.21204 | 2115624.1968 | 37.7888432106719 | -122.459323111848 | (37.7888432106719, -122.459323111848) | 11 | 6 | 1 | 54 | 31 | |||
27996 | 5415 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 430X Dolores St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 6 | 6004853.9708326 | 2105864.857711 | 37.7625782660478 | -122.426358665446 | (37.7625782660478, -122.426358665446) | 8 | 4 | 5 | 28859 | 3 | |||
28060 | 25101 | DPW Maintained 1 | Brahea edulis :: Guadalupe Palm 218 | 1450X Dolores St | 1 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005235.8244 | 2099843.78612 | 37.7460673833025 | -122.424609642834 | (37.7460673833025, -122.424609642834) | 2 | 7 | 5 | 63 | 22 | |||
29599 | 1559 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 552 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 3x3 | 5995643.10859 | 2112475.92175 | 37.7802055542204 | -122.458694119583 | (37.7802055542204, -122.458694119583) | 11 | 6 | 2 | 54 | 16 | |||
30248 | 12543 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 239 Lake St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 5994669.04887 | 2114868.49847 | 37.786718892107 | -122.462237385897 | (37.786718892107, -122.462237385897) | 11 | 6 | 1 | 54 | 11 | |||
30361 | 175 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 5400X California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 3X3 | 5990796.10602 | 2114048.44446 | 37.7842434899767 | -122.475576806045 | (37.7842434899767, -122.475576806045) | 11 | 6 | 2 | 54 | 26 | |||
32681 | 9313 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 99X Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 2X2 | 6001391.6487444 | 2098856.3848919 | 37.7431383606087 | -122.437831565564 | (37.7431383606087, -122.437831565564) | 2 | 7 | 5 | 63 | 7 | |||
32734 | 5631 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1234 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 3X3 | 6005123.01487 | 2101119.88751 | 37.7495648926104 | -122.425090505838 | (37.7495648926104, -122.425090505838) | 2 | 4 | 5 | 28862 | 22 | |||
33120 | 12727 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1600 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 4X4 | 5990457.1993 | 2114785.86556 | 37.7862485896694 | -122.476803188002 | (37.7862485896694, -122.476803188002) | 11 | 6 | 1 | 55 | 33 | |||
33764 | 5347 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 199 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6004867.38316 | 2107258.6385 | 37.7664060136476 | -122.426411520896 | (37.7664060136476, -122.426411520896) | 8 | 4 | 5 | 28862 | 19 | |||
33867 | 25096 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1300X Dolores St | 1 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005188.03023 | 2100718.94336 | 37.7484676648463 | -122.42483715961 | (37.7484676648463, -122.42483715961) | 2 | 4 | 5 | 28859 | 19 | |||
33986 | 24963 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 Dolores St | 4 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004800.73696 | 2107633.50365 | 37.7674315357679 | -122.42666873509 | (37.7674315357679, -122.42666873509) | 8 | 4 | 5 | 28862 | 3 | |||
35072 | 5628 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1217 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X4 | 6005202.88749 | 2101242.53222 | 37.7499061583492 | -122.424823027659 | (37.7499061583492, -122.424823027659) | 2 | 4 | 5 | 28859 | 19 | |||
36800 | 1993 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 162 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 3X3 | 6007301.50891 | 2098085.20202 | 37.7413551489316 | -122.417342154839 | (37.7413551489316, -122.417342154839) | 2 | 7 | 7 | 28859 | 2 | |||
37137 | 24994 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 300 Dolores St | 5 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004873.5625 | 2106448.79257 | 37.7641827195917 | -122.426332482174 | (37.7641827195917, -122.426332482174) | 8 | 4 | 5 | 28859 | 3 | |||
38202 | 5734 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1725 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3x3 | 6005365.37115 | 2098326.96084 | 37.7419098417621 | -122.424053837524 | (37.7419098417621, -122.424053837524) | 2 | 7 | 5 | 28859 | 7 | |||
38652 | 1382 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 601X Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 3X3 | 5995593.50257 | 2112100.09905 | 37.7791707937226 | -122.458838511201 | (37.7791707937226, -122.458838511201) | 11 | 6 | 2 | 54 | 11 | |||
39095 | 25102 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1400X Dolores St | 2 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005226.05485 | 2100086.94121 | 37.7467344797311 | -122.424660718923 | (37.7467344797311, -122.424660718923) | 2 | 7 | 5 | 63 | 22 | |||
39138 | 3336 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 5414 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 3X3 | 5990748.98801 | 2114101.91513 | 37.7843875739705 | -122.475743722006 | (37.7843875739705, -122.475743722006) | 11 | 6 | 2 | 54 | 26 | |||
40260 | 14571 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1101 Masonic Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 5x5 | 5999361.6418 | 2109001.7234 | 37.7708793165263 | -122.445580154944 | (37.7708793165263, -122.445580154944) | 15 | 5 | 11 | 29492 | 9 | |||
40411 | 25151 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2X Dolores St | 4 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004775.21348 | 2108066.24403 | 37.7686182937211 | -122.42678783859 | (37.7686182937211, -122.42678783859) | 8 | 4 | 5 | 28862 | 3 | |||
41860 | 25057 | DPW Maintained 1 | Brahea edulis :: Guadalupe Palm 218 | 900X Dolores St | 12 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005079.27857 | 2102722.52778 | 37.7539629002849 | -122.425355780639 | (37.7539629002849, -122.425355780639) | 2 | 4 | 5 | 28862 | 22 | |||
42002 | 12629 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 841 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 5992807.54616 | 2114798.77579 | 37.7864200929582 | -122.468672610251 | (37.7864200929582, -122.468672610251) | 11 | 6 | 2 | 54 | 11 | |||
42605 | 25098 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1350X Dolores St | 3 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005207.85517 | 2100363.53531 | 37.7474929157794 | -122.424743325238 | (37.7474929157794, -122.424743325238) | 2 | 7 | 5 | 63 | 22 | |||
42792 | 25073 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1100X Dolores St | 4 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005132.2187 | 2101761.89405 | 37.7513282140435 | -122.425104353592 | (37.7513282140435, -122.425104353592) | 2 | 4 | 5 | 28862 | 22 | |||
43770 | 24998 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 450X Dolores St | 3 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004918.80727 | 2105618.72906 | 37.7619061199926 | -122.426116896691 | (37.7619061199926, -122.426116896691) | 8 | 4 | 5 | 28862 | 3 | |||
43860 | 8182 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1218 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6001778.22585 | 2111194.36963 | 37.7770374434445 | -122.437378180533 | (37.7770374434445, -122.437378180533) | 15 | 5 | 11 | 29492 | 41 | |||
44589 | 1636 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 827 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 3x3 | 5995647.41415 | 2110653.56158 | 37.7752020829683 | -122.458547268394 | (37.7752020829683, -122.458547268394) | 11 | 6 | 2 | 54 | 11 | |||
46729 | 25006 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 470X Dolores St | 12 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004864.935088 | 2105663.9116337 | 37.7620271356236 | -122.426306436493 | (37.7620271356236, -122.426306436493) | 8 | 4 | 5 | 28862 | 3 | |||
47489 | 17723 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1300X Pierce St | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 90 | 3X3 | 6002290.56024 | 2112983.34935 | 37.7819786446445 | -122.435733884321 | (37.7819786446445, -122.435733884321) | 15 | 5 | 11 | 29490 | 41 | |||
47545 | 24964 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 198 Dolores St | 5 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004804.6555297 | 2107199.7616194 | 37.7662408057536 | -122.426624291348 | (37.7662408057536, -122.426624291348) | 8 | 4 | 5 | 28862 | 3 | |||
47869 | 5681 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1475 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6005285.89878 | 2099762.93917 | 37.7458482239295 | -122.424430742501 | (37.7458482239295, -122.424430742501) | 2 | 7 | 5 | 28859 | 22 | |||
48611 | 14510 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 500X Masonic Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 6X6 | 5999167.52145 | 2111070.84281 | 37.7765495060171 | -122.446400495731 | (37.7765495060171, -122.446400495731) | 15 | 5 | 11 | 29492 | 16 | |||
49369 | 25015 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 550X Dolores St | 9 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004955.91822 | 2104917.6837 | 37.7599833128008 | -122.42593863935 | (37.7599833128008, -122.42593863935) | 2 | 4 | 5 | 28862 | 3 | |||
50349 | 1608 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 738 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 5995691.98224 | 2111083.1431 | 37.7763841618607 | -122.458424200101 | (37.7763841618607, -122.458424200101) | 11 | 6 | 2 | 54 | 16 | |||
52736 | 13161 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1895 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 3X3 | 6003359.5664 | 2119590.4223 | 37.8001806439695 | -122.432507683341 | (37.8001806439695, -122.432507683341) | 13 | 9 | 1 | 57 | 17 | |||
53196 | 1582 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 633 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 3X3 | 5995604.58017 | 2111830.53845 | 37.778431288562 | -122.458780668658 | (37.778431288562, -122.458780668658) | 11 | 6 | 2 | 54 | 11 | |||
53368 | 5410 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 400 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 4X6 | 6004853.94973 | 2105972.80188 | 37.7628746538756 | -122.426366424394 | (37.7628746538756, -122.426366424394) | 8 | 4 | 5 | 28859 | 3 | |||
53956 | 12603 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 645 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 3X3 | 5993471.58312 | 2114823.45454 | 37.7865261918162 | -122.466377023021 | (37.7865261918162, -122.466377023021) | 11 | 6 | 2 | 54 | 11 | |||
54620 | 8176 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1200 Fulton St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6001924.4605 | 2111208.7057 | 37.7770851190514 | -122.436873336808 | (37.7770851190514, -122.436873336808) | 15 | 5 | 11 | 29492 | 41 | |||
55002 | 13200 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2130X Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6002179.06604 | 2119515.41872 | 37.7999076905723 | -122.436587295662 | (37.7999076905723, -122.436587295662) | 13 | 9 | 1 | 57 | 17 | |||
55170 | 25007 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 500X Dolores St | 1 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004931.59557 | 2105384.62551 | 37.7612640499245 | -122.426056000898 | (37.7612640499245, -122.426056000898) | 2 | 4 | 5 | 28862 | 3 | |||
55390 | 25061 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1000X Dolores St | 4 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005097.79962 | 2102345.06954 | 37.7529275341834 | -122.425264872687 | (37.7529275341834, -122.425264872687) | 2 | 4 | 5 | 28862 | 22 | |||
56194 | 5411 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 400 Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 0 | 6004855.17183 | 2105951.94902 | 37.7628174659634 | -122.426360712783 | (37.7628174659634, -122.426360712783) | 8 | 4 | 5 | 28859 | 3 | |||
56852 | 25063 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1000X Dolores St | 6 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005101.20924 | 2102268.05958 | 37.7527162753581 | -122.425247602115 | (37.7527162753581, -122.425247602115) | 2 | 4 | 5 | 28862 | 22 | |||
57179 | 5423 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 460X Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6004889.2026724 | 2105697.5669462 | 37.7621209168257 | -122.426224900449 | (37.7621209168257, -122.426224900449) | 8 | 4 | 5 | 28862 | 3 | |||
58115 | 24993 | DPW Maintained 1 | Brahea edulis :: Guadalupe Palm 218 | 300 Dolores St | 4 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004868.62064 | 2106470.50414 | 37.7642420550398 | -122.426351120609 | (37.7642420550398, -122.426351120609) | 8 | 4 | 5 | 28859 | 3 | |||
58611 | 8173 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1200 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6001985.2987 | 2111217.5273 | 37.7771127985152 | -122.436663510376 | (37.7771127985152, -122.436663510376) | 15 | 5 | 11 | 29492 | 41 |
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) );