trees
27,746 rows where qCaretaker_id = 1 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||
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 | ||||
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 | ||||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
58771 | 25047 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 900X Dolores St | 1 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005062.19129 | 2103039.48532 | 37.7548322263474 | -122.425437427413 | (37.7548322263474, -122.425437427413) | 2 | 4 | 5 | 28862 | 22 | |||
58822 | 25066 | DPW Maintained 1 | Washingtonia robusta :: Mexican Fan Palm 72 | 1000X Dolores St | 9 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005105.41948 | 2102158.55982 | 37.7524158523077 | -122.425225251269 | (37.7524158523077, -122.425225251269) | 2 | 4 | 5 | 28862 | 22 | |||
61252 | 5701 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1573 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 5X5 | 6005320.34173 | 2099180.98827 | 37.7442522645292 | -122.424270261189 | (37.7442522645292, -122.424270261189) | 2 | 7 | 5 | 28859 | 22 | |||
63593 | 25152 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 50X Dolores St | 5 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004796.34623 | 2107853.39536 | 37.768035057311 | -122.42669958274 | (37.768035057311, -122.42669958274) | 8 | 4 | 5 | 28862 | 3 | |||
63885 | 14497 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 350 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 5999071.4256 | 2111558.1482 | 37.7778820323449 | -122.446767989356 | (37.7778820323449, -122.446767989356) | 15 | 5 | 11 | 54 | 16 | |||
65481 | 8174 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1200 Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6001968.8724 | 2111216.0063 | 37.7771076887262 | -122.436720225115 | (37.7771076887262, -122.436720225115) | 15 | 5 | 11 | 29492 | 41 | |||
66930 | 25109 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1496 Dolores St | 2 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005218.8222955 | 2099617.195839 | 37.7454442580108 | -122.424652317948 | (37.7454442580108, -122.424652317948) | 2 | 7 | 5 | 63 | 22 | |||
68276 | 25044 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 892X Dolores St | 9 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005007.5951373 | 2103153.9131268 | 37.7551433335372 | -122.425634379859 | (37.7551433335372, -122.425634379859) | 2 | 4 | 5 | 28862 | 22 | |||
72293 | 25123 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1550 Dolores St | 4 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005274.82817 | 2099143.28527 | 37.7441461706217 | -122.424424956245 | (37.7441461706217, -122.424424956245) | 2 | 7 | 5 | 63 | 22 | |||
73104 | 5386 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 325X Dolores St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6004919.4864142 | 2106495.5645768 | 37.7643137401636 | -122.426176974515 | (37.7643137401636, -122.426176974515) | 8 | 4 | 5 | 28859 | 19 | |||
74776 | 5398 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 347 Dolores St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6004916.74294 | 2106419.98328 | 37.7641060568743 | -122.426181082194 | (37.7641060568743, -122.426181082194) | 8 | 4 | 5 | 28859 | 19 | |||
75098 | 24975 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 200 Dolores St | 2 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004832.79825 | 2107115.15692 | 37.7660100925102 | -122.426520926121 | (37.7660100925102, -122.426520926121) | 8 | 4 | 5 | 28862 | 3 | |||
75622 | 24981 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 292 Dolores St | 8 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004817.9533669 | 2106647.0197828 | 37.7647238606763 | -122.426538934247 | (37.7647238606763, -122.426538934247) | 8 | 4 | 5 | 28862 | 3 | |||
76421 | 10473 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1632 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3x3 | 5998321.0771 | 2108628.9487 | 37.7697963108216 | -122.449152617838 | (37.7697963108216, -122.449152617838) | 15 | 5 | 11 | 29492 | 9 | |||
79675 | 12637 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 906 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 5992634.642 | 2114847.92041 | 37.7865450406826 | -122.469274388054 | (37.7865450406826, -122.469274388054) | 11 | 6 | 1 | 54 | 11 | |||
82072 | 5626 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1212 Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6005119.51713 | 2101140.67706 | 37.7496217783286 | -122.425104080197 | (37.7496217783286, -122.425104080197) | 2 | 4 | 5 | 28862 | 22 | |||
82146 | 11339 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1279 Ingalls St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6017412.9471167 | 2093950.7223454 | 37.7305663998171 | -122.382092440811 | (37.7305663998171, -122.382092440811) | 10 | 3 | 8 | 58 | 1 | |||
82400 | 25038 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 800X Dolores St | 2 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005033.4036 | 2103578.19486 | 37.756309770193 | -122.425575321353 | (37.756309770193, -122.425575321353) | 2 | 4 | 5 | 28862 | 22 | |||
83481 | 12696 | DPW Maintained 1 | Hakea laurina :: Sea Urchin Tree 370 | 1352 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 5991211.41269 | 2114825.51279 | 37.7864011704317 | -122.474196725991 | (37.7864011704317, -122.474196725991) | 11 | 6 | 1 | 54 | 33 | |||
83648 | 25562 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 50X Industrial St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 4X4 | 6012204.29417 | 2097469.52586 | 37.7399392564551 | -122.400346698766 | (37.7399392564551, -122.400346698766) | 10 | 3 | 8 | 58 | 1 | |||
83756 | 24968 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 Dolores St | 9 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004810.58196 | 2107534.13104 | 37.7671592390347 | -122.426627605497 | (37.7671592390347, -122.426627605497) | 8 | 4 | 5 | 28862 | 3 | |||
85525 | 25154 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 50X Dolores St | 2 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004786.45589 | 2107937.06969 | 37.7682642477152 | -122.426739751839 | (37.7682642477152, -122.426739751839) | 8 | 4 | 5 | 28862 | 3 | |||
85810 | 13105 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1530 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/26/1993 12:00:00 AM | 90 | 3X3 | 6004999.0901 | 2119899.25 | 37.8011214413621 | -122.426856296775 | (37.8011214413621, -122.426856296775) | 13 | 9 | 1 | 57 | 17 | ||
86137 | 25116 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1500X Dolores St | 3 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005256.05434 | 2099495.31423 | 37.7451117016422 | -122.424514907343 | (37.7451117016422, -122.424514907343) | 2 | 7 | 5 | 63 | 22 | |||
86509 | 25040 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 800X Dolores St | 4 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005037.47438 | 2103495.56554 | 37.7560831194465 | -122.425555362685 | (37.7560831194465, -122.425555362685) | 2 | 4 | 5 | 28862 | 22 | |||
86521 | 25013 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 550X Dolores St | 7 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6004948.90557 | 2104970.06821 | 37.7601267519689 | -122.425966621772 | (37.7601267519689, -122.425966621772) | 2 | 4 | 5 | 28862 | 3 | |||
86563 | 25122 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1550 Dolores St | 3 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005275.20405 | 2099188.47337 | 37.7442702680707 | -122.42442687003 | (37.7442702680707, -122.42442687003) | 2 | 7 | 5 | 63 | 22 | |||
87103 | 14421 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2X Masonic Ave | 9 | Median : Cutout | Tree | DPW 1 | 90 | 3X3 | 5998843.9665 | 2113055.4136 | 37.7819801389805 | -122.447662657424 | (37.7819801389805, -122.447662657424) | 15 | 5 | 2 | 54 | 16 | |||
87906 | 10055 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 432 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X2 | 6005503.26278 | 2106415.24362 | 37.7641261764966 | -122.424152141508 | (37.7641261764966, -122.424152141508) | 8 | 4 | 5 | 28859 | 19 | |||
88665 | 5559 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 984 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6005041.33516 | 2102650.51852 | 37.7537630358578 | -122.425481873703 | (37.7537630358578, -122.425481873703) | 2 | 4 | 5 | 28862 | 22 | |||
89100 | 10367 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1190 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X4 | 6000483.5353 | 2108928.9047 | 37.7707433605012 | -122.441694282188 | (37.7707433605012, -122.441694282188) | 15 | 5 | 11 | 29492 | 9 | |||
91501 | 12995 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 336 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6010707.244 | 2120695.2086 | 37.8036280390364 | -122.407159656622 | (37.8036280390364, -122.407159656622) | 3 | 1 | 10 | 308 | 23 | |||
92493 | 25140 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1750X Dolores St | 6 | Median : Cutout | Tree | DPW 1 | 90 | 20 | 6005337.96039 | 2097982.38921 | 37.7409621784698 | -122.424124115947 | (37.7409621784698, -122.424124115947) | 2 | 7 | 5 | 63 | 7 |
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) );