trees
163,064 rows where qCaretaker_id = 2 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
268 | 247892 | DPW Maintained 1 | :: 45 | 1283 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6000447.0072 | 2109223.9761 | 37.7715514711219 | -122.441841814274 | (37.7715514711219, -122.441841814274) | 15 | 5 | 11 | 29492 | 9 | |||
269 | 194187 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1100 19th St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 4ft | 6014241.14855 | 2105287.11165 | 37.7615180580268 | -122.393851124637 | (37.7615180580268, -122.393851124637) | 10 | 3 | 8 | 28856 | 29 | |||
270 | 182815 | DPW Maintained 1 | :: 45 | 2111 Noriega St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5987460.7639 | 2102999.1421 | 37.7537112584365 | -122.486304306666 | (37.7537112584365, -122.486304306666) | 1 | 8 | 3 | 56 | 35 | |||
272 | 232035 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 39 Scott St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 6002379.25876 | 2108512.04182 | 37.769706587622 | -122.435107129612 | (37.769706587622, -122.435107129612) | 15 | 5 | 5 | 29492 | 9 | |||
274 | 232433 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 100 Church St | 2 | : | Tree | Private 2 | 7 | Width 3ft | 6004078.25972 | 2108290.75217 | 37.7691953086514 | -122.429214555715 | (37.7691953086514, -122.429214555715) | 7 | 9 | 5 | 28862 | 3 | |||
275 | 193456 | DPW Maintained 1 | Malus :: Crab Apple 82 | 185 Hampshire St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 5ft | 6010023.67884 | 2107445.71101 | 37.76720979983 | -122.40858996078 | (37.76720979983, -122.40858996078) | 8 | 4 | 8 | 28853 | 19 | |||
276 | 182945 | DPW Maintained 1 | :: 45 | 2691 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5981809.5051 | 2096798.8146 | 37.7363558765881 | -122.50538776138 | (37.7363558765881, -122.50538776138) | 1 | 8 | 3 | 29491 | 35 | |||
278 | 247719 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 12 Broderick St | 1 | : | Tree | Private 2 | 2 | Width 3ft | 6001402.47389 | 2108783.95066 | 37.770397668046 | -122.438505276404 | (37.770397668046, -122.438505276404) | 15 | 5 | 11 | 29492 | 9 | |||
279 | 182423 | DPW Maintained 1 | :: 45 | 1539 25th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5988365.4024 | 2104835.4768 | 37.7588060244513 | -122.483310502266 | (37.7588060244513, -122.483310502266) | 1 | 8 | 3 | 56 | 35 | |||
281 | 136194 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2914 Fillmore St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6002528.73575 | 2118269.03723 | 37.7965053162169 | -122.435288106477 | (37.7965053162169, -122.435288106477) | 13 | 9 | 1 | 57 | 17 | |||
283 | 78989 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2319 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 5988235.2891 | 2099507.8812 | 37.7441702991504 | -122.483369943638 | (37.7441702991504, -122.483369943638) | 1 | 8 | 3 | 29491 | 35 | |||
284 | 142846 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1249 POLK ST | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 8 | Width 0ft | 6006785.3377 | 2115265.4346 | 37.7884989771715 | -122.420346012985 | (37.7884989771715, -122.420346012985) | 13 | 9 | 10 | 28858 | 21 | |||
287 | 39813 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2000 41st Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/12/2019 12:00:00 AM | 3 | 3x10 | Permit Number 41144 | 5983552 | 2101519 | 37.7494185989562 | -122.499712087956 | (37.7494185989562, -122.499712087956) | 1 | 8 | 3 | 29491 | 35 |
288 | 125298 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 822 Pacific Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6010056.95509 | 2118170.07703 | 37.7966582351325 | -122.409231726859 | (37.7966582351325, -122.409231726859) | 3 | 1 | 10 | 308 | 4 | |||
290 | 72670 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 203 04th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 5994586.71732 | 2114106.61682 | 37.7846222306097 | -122.462466948558 | (37.7846222306097, -122.462466948558) | 11 | 6 | 2 | 54 | 11 | |||
291 | 210733 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 239 Ramsell St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5992956.15258 | 2088805.34296 | 37.7150573966491 | -122.466268722147 | (37.7150573966491, -122.466268722147) | 9 | 8 | 6 | 64 | 24 | |||
292 | 141019 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 400 Anza St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 5997825.3169 | 2112597.8673 | 37.7806655664219 | -122.451153693978 | (37.7806655664219, -122.451153693978) | 15 | 6 | 2 | 54 | 16 | |||
295 | 200164 | DPW Maintained 1 | :: 45 | 1027 Ingerson Ave | 1 | unknown : Yard | Tree | Private 2 | 0 | Width 0ft | 6014014.4798 | 2089939.2839 | 37.7193635176037 | -122.393560894555 | (37.7193635176037, -122.393560894555) | 10 | 3 | 8 | 58 | 1 | |||
296 | 185842 | DPW Maintained 1 | :: 45 | 2000 35th Ave | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5985421.3197 | 2101412.6246 | 37.7492360339251 | -122.493240190301 | (37.7492360339251, -122.493240190301) | 1 | 8 | 3 | 29491 | 35 | |||
302 | 184152 | DPW Maintained 1 | :: 45 | 1585 44th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5982483.9557 | 2104316.7349 | 37.7570376635662 | -122.503612507973 | (37.7570376635662, -122.503612507973) | 1 | 8 | 3 | 56 | 35 | |||
310 | 218546 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 25 Elmhurst Dr | 5 | : | Tree | Private 2 | 7 | Width 3ft | 5991216.07157 | 2094485.7269 | 37.730553771324 | -122.472697049151 | (37.730553771324, -122.472697049151) | 9 | 8 | 4 | 64 | 40 | |||
311 | 138787 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2714 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 6000799 | 2114887 | 37.7871207435599 | -122.441030597921 | (37.7871207435599, -122.441030597921) | 13 | 6 | 1 | 29490 | 27 | |||
312 | 201949 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1650 Carroll Ave | 18 | : | Tree | Private 2 | 2 | Width 3ft | 6013468.57071 | 2092447.06427 | 37.7262190300648 | -122.395623522912 | (37.7262190300648, -122.395623522912) | 10 | 3 | 8 | 58 | 1 | |||
314 | 184219 | DPW Maintained 1 | :: 45 | 3439 Kirkham St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5984114.8945 | 2104934.4274 | 37.7588294281219 | -122.498017803137 | (37.7588294281219, -122.498017803137) | 1 | 8 | 3 | 56 | 35 | |||
316 | 245380 | DPW Maintained 1 | :: 45 | 3620 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6005334.5439 | 2097112.3285 | 37.7385729952273 | -122.424074069598 | (37.7385729952273, -122.424074069598) | 2 | 7 | 5 | 28859 | 2 | |||
317 | 189161 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 109 Kissling St | 4 | : | Tree | Private 2 | 2 | Width 3ft | 6008149.50016 | 2109391.65635 | 37.7724477670719 | -122.415210253457 | (37.7724477670719, -122.415210253457) | 8 | 2 | 9 | 28853 | 19 | |||
318 | 190050 | DPW Maintained 1 | Cinnamomum camphora :: Camphor Tree 90 | 601 Amador St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6016946.57228 | 2099501.56467 | 37.7457821291547 | -122.384091181786 | (37.7457821291547, -122.384091181786) | 10 | 3 | 8 | 58 | 1 | |||
320 | 228444 | DPW Maintained 1 | :: 45 | 399 Haight St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6004268.91864 | 2109406.82097 | 37.7722705538615 | -122.428634644993 | (37.7722705538615, -122.428634644993) | 7 | 9 | 11 | 28852 | 10 | |||
321 | 219060 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 221 Congo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6000072.85251 | 2094491.10418 | 37.731077247812 | -122.442078323383 | (37.731077247812, -122.442078323383) | 9 | 7 | 4 | 63 | 40 | |||
322 | 131741 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 2901 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6000273.04756 | 2116436.32711 | 37.7913448210684 | -122.44296157632 | (37.7913448210684, -122.44296157632) | 13 | 6 | 1 | 29490 | 27 | |||
324 | 97786 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 810 Battery St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6012446.82878 | 2118928.41788 | 37.7988740576432 | -122.401015485586 | (37.7988740576432, -122.401015485586) | 3 | 1 | 10 | 28860 | 6 | |||
325 | 248307 | DPW Maintained 1 | :: 45 | 1323 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5999369.7066 | 2108379.5015 | 37.7691713129844 | -122.445507509409 | (37.7691713129844, -122.445507509409) | 15 | 5 | 11 | 29492 | 9 | |||
327 | 182422 | DPW Maintained 1 | :: 45 | 1534 28th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5987477.4649 | 2104817.3887 | 37.7587046434176 | -122.486380033207 | (37.7587046434176, -122.486380033207) | 1 | 8 | 3 | 56 | 35 | |||
328 | 197129 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 400 Newhall St | 11 | : | Tree | Private 2 | 5 | Width 3ft | 6015974.4503 | 2097856.83037 | 37.7412122331485 | -122.387337958305 | (37.7412122331485, -122.387337958305) | 10 | 3 | 8 | 58 | 1 | |||
330 | 250773 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 259 32nd Ave | 1 | : | Tree | Private 2 | 14 | Width 3ft | 5985865.92055 | 2114194.89594 | 37.7843585636424 | -122.492644052605 | (37.7843585636424, -122.492644052605) | 11 | 6 | 1 | 55 | 33 | |||
331 | 194117 | DPW Maintained 1 | Nyssa sylvatica :: Tupelo: Sour Gum 92 | 2 13th St | 9 | : | Tree | Private 2 | 2 | Width 3ft | 6009035.07102 | 2108345.44011 | 37.7696248302591 | -122.412073015253 | (37.7696248302591, -122.412073015253) | 8 | 4 | 9 | 28853 | 19 | |||
332 | 182987 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1975 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5989890.895 | 2098325.8493 | 37.7410209633467 | -122.477558903564 | (37.7410209633467, -122.477558903564) | 1 | 8 | 3 | 29491 | 35 | |||
334 | 162296 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 299 Olmstead St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/2020 12:00:00 AM | 3 | Width 0ft | 6010920.41592 | 2090984.45712 | 37.7220609417541 | -122.40432950351 | (37.7220609417541, -122.40432950351) | 10 | 3 | 7 | 309 | 28 | ||
336 | 189035 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 50 Russ St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6010091.10409 | 2111787.20644 | 37.7791343146469 | -122.408663052281 | (37.7791343146469, -122.408663052281) | 14 | 2 | 9 | 28853 | 34 | |||
337 | 193188 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 401 Harrison St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 4ft | 6014838.37703 | 2114321.79559 | 37.7863584598262 | -122.392417493778 | (37.7863584598262, -122.392417493778) | 6 | 2 | 9 | 28855 | 6 | |||
338 | 212500 | DPW Maintained 1 | Tree(s) :: 17 | 51 Sotelo Ave | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/09/2019 12:00:00 AM | 3 | Width 4ft | Permit Number 784592 | 5993879 | 2101255 | 37.7492942917049 | -122.463982175947 | (37.7492942917049, -122.463982175947) | 1 | 8 | 4 | 29491 | 40 | |
346 | 251273 | DPW Maintained 1 | Acer negundo :: Box Elder 94 | 1301X 07th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993949 | 2106317 | 37.7631972735035 | -122.464107541423 | (37.7631972735035, -122.464107541423) | 1 | 5 | 11 | 56 | 12 | ||||
349 | 253694 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 536 Octavia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005450 | 2111168 | 37.7771730951376 | -122.424674483112 | (37.7771730951376, -122.424674483112) | 7 | 9 | 11 | 28852 | 10 | ||||
351 | 182685 | DPW Maintained 1 | :: 45 | 1709 34th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5985611.9744 | 2103558.0646 | 37.7551379747053 | -122.492738908785 | (37.7551379747053, -122.492738908785) | 1 | 8 | 3 | 56 | 35 | |||
352 | 98788 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3601X Laguna St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6003538.80686 | 2121150.47161 | 37.804474295204 | -122.431998903525 | (37.804474295204, -122.431998903525) | 13 | 9 | 1 | 57 | 17 | |||
354 | 141882 | DPW Maintained 1 | :: 45 | 1160 WEBSTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6003839.6945 | 2112655.4467 | 37.7811661774464 | -122.430351190021 | (37.7811661774464, -122.430351190021) | 7 | 9 | 11 | 29490 | 41 | |||
355 | 229322 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2771 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 6ft | 6009868 | 2101202 | 37.7500572563342 | -122.408687913648 | (37.7500572563342, -122.408687913648) | 2 | 4 | 7 | 28859 | 19 | |||
356 | 233580 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1317 Clayton St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 5999035.80578 | 2105154.14715 | 37.7602962318988 | -122.44643038196 | (37.7602962318988, -122.44643038196) | 15 | 5 | 5 | 28862 | 12 | |||
357 | 232461 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1300 San Jose Ave | 12 | Front Yard : Yard | Tree | Private 2 | 11 | 6003612.68018 | 2095726.39764 | 37.7346701778724 | -122.429928614715 | (37.7346701778724, -122.429928614715) | 2 | 7 | 5 | 63 | 7 | ||||
358 | 222991 | DPW Maintained 1 | Cotoneaster SPP :: Cotoneaster 96 | 502 28th St | 7 | Sidewalk: Curb side : Pot | Tree | Private 2 | 24 | 6002568.09263 | 2099485.22731 | 37.7449318417374 | -122.433808677655 | (37.7449318417374, -122.433808677655) | 2 | 7 | 5 | 63 | 22 | ||||
360 | 181895 | DPW Maintained 1 | :: 45 | 2366 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5986431.1624 | 2099136.6325 | 37.7430457847891 | -122.489580839702 | (37.7430457847891, -122.489580839702) | 1 | 8 | 3 | 29491 | 35 | |||
363 | 234091 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 460 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6005712.20409 | 2107866.30498 | 37.7681222411638 | -122.423532643536 | (37.7681222411638, -122.423532643536) | 8 | 4 | 5 | 28853 | 19 | |||
367 | 183862 | DPW Maintained 1 | :: 45 | 2239 32nd Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5986357.5018 | 2099996.4101 | 37.7454022028518 | -122.489898755555 | (37.7454022028518, -122.489898755555) | 1 | 8 | 3 | 29491 | 35 | |||
368 | 234039 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 93 Scott St | 1 | : | Tree | Private 2 | 12 | Width 4ft | 6002347.86623 | 2108745.44445 | 37.7703456710482 | -122.435232412346 | (37.7703456710482, -122.435232412346) | 15 | 5 | 5 | 29492 | 9 | |||
370 | 183768 | DPW Maintained 1 | :: 45 | 2295 28th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5987606.9921 | 2099698.5467 | 37.744657229257 | -122.485556419265 | (37.744657229257, -122.485556419265) | 1 | 8 | 3 | 29491 | 35 | |||
372 | 189871 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 400 Newhall St | 9 | : | Tree | Private 2 | 7 | Width 3ft | 6016028.58203 | 2097927.48174 | 37.7414092251604 | -122.387155715173 | (37.7414092251604, -122.387155715173) | 10 | 3 | 8 | 58 | 1 | |||
373 | 200940 | DPW Maintained 1 | :: 45 | 1515 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6008432.2434 | 2109068.8895 | 37.7715774111529 | -122.414209373869 | (37.7715774111529, -122.414209373869) | 8 | 2 | 9 | 28853 | 19 | |||
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 | |||
377 | 142111 | DPW Maintained 1 | :: 45 | 36 HEMWAY TER | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5998636.7696 | 2110968.1942 | 37.7762373313333 | -122.448229118378 | (37.7762373313333, -122.448229118378) | 15 | 6 | 2 | 29492 | 16 | |||
378 | 182780 | DPW Maintained 1 | :: 45 | 1743 34th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5985620.0055 | 2103342.2275 | 37.7545458149545 | -122.492695239531 | (37.7545458149545, -122.492695239531) | 1 | 8 | 3 | 56 | 35 | |||
379 | 215760 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 811 Congo St | 21 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 10ft | 6000555.25402 | 2095877.7313 | 37.734912082925 | -122.440509997443 | (37.734912082925, -122.440509997443) | 9 | 7 | 4 | 63 | 40 | |||
381 | 136202 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1337 Francisco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6004913.0684 | 2120534.02336 | 37.8028595013299 | -122.427199210075 | (37.8028595013299, -122.427199210075) | 13 | 9 | 1 | 57 | 17 | |||
385 | 138469 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1701 PIERCE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6002045.7135 | 2114397.2192 | 37.7858468609583 | -122.43668217767 | (37.7858468609583, -122.43668217767) | 13 | 6 | 1 | 29490 | 27 | |||
386 | 143336 | DPW Maintained 1 | :: 45 | 1858 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6004106.6848 | 2118733.7418 | 37.797870758582 | -122.429861223474 | (37.797870758582, -122.429861223474) | 13 | 9 | 1 | 57 | 17 | |||
388 | 109369 | DPW Maintained 1 | :: 45 | 2061 Hyde St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | FUF | 02/11/2015 12:00:00 AM | 3 | 5x6 | 6007159.6 | 2119443.7 | 37.7999925365465 | -122.419347645872 | (37.7999925365465, -122.419347645872) | 5 | 1 | 1 | 28858 | 32 | |
389 | 121965 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 20 15th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 5991180.37033 | 2114963.80683 | 37.7867790889821 | -122.474314218886 | (37.7867790889821, -122.474314218886) | 11 | 6 | 1 | 54 | 33 | ||||
391 | 104857 | DPW Maintained 1 | :: 45 | 2555 46th Ave | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 5982069.8 | 2097707.6 | 37.7388664658919 | -122.504555139124 | (37.7388664658919, -122.504555139124) | 1 | 8 | 3 | 29491 | 35 | ||||||
393 | 182533 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1581 34th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5985582.1491 | 2104457.0825 | 37.7576046859901 | -122.492908268983 | (37.7576046859901, -122.492908268983) | 1 | 8 | 3 | 56 | 35 | |||
396 | 182481 | DPW Maintained 1 | :: 45 | 1556 36th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5985002.9582 | 2104611.8375 | 37.7579957124827 | -122.494922727233 | (37.7579957124827, -122.494922727233) | 1 | 8 | 3 | 56 | 35 | |||
397 | 253904 | DPW Maintained 1 | :: 45 | 3637 Sacramento St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5997456 | 2115038 | 37.7873443747179 | -122.4526074861 | (37.7873443747179, -122.4526074861) | 11 | 6 | 1 | 54 | 31 | ||||
398 | 234490 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 4053 20th St | 1 | Front Yard : Yard | Tree | Private 2 | 13 | Width 3ft | 6003306.74467 | 2104167.50736 | 37.7578301676468 | -122.43158877311 | (37.7578301676468, -122.43158877311) | 2 | 4 | 5 | 28862 | 3 | |||
401 | 183745 | DPW Maintained 1 | :: 45 | 2267 32nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5986363.4761 | 2099812.4858 | 37.7448975449574 | -122.489864573201 | (37.7448975449574, -122.489864573201) | 1 | 8 | 3 | 29491 | 35 | |||
402 | 183817 | DPW Maintained 1 | :: 45 | 2133 Rivera St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 0ft | 5986490.2175 | 2100252.0265 | 37.7461118053863 | -122.489458644673 | (37.7461118053863, -122.489458644673) | 1 | 8 | 3 | 29491 | 35 | |||
404 | 182349 | DPW Maintained 1 | :: 45 | 3125 Kirkham St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5985217.5678 | 2104973.2387 | 37.759000580496 | -122.494207164319 | (37.759000580496, -122.494207164319) | 1 | 8 | 3 | 56 | 35 | |||
409 | 187885 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1600 Indiana St | 23 | : | Tree | Private 2 | 3 | Width 3ft | 6015152.38977 | 2100397.43257 | 37.748142637288 | -122.390357841268 | (37.748142637288, -122.390357841268) | 10 | 3 | 8 | 58 | 1 | |||
410 | 183338 | DPW Maintained 1 | :: 45 | 1200 La Playa | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5980889.0479 | 2106803.3028 | 37.7637711641625 | -122.509312865514 | (37.7637711641625, -122.509312865514) | 1 | 8 | 3 | 56 | 35 | |||
411 | 247779 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 254 30th St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6004930.81683 | 2098452.72536 | 37.7422306182373 | -122.42556533529 | (37.7422306182373, -122.42556533529) | 2 | 7 | 5 | 63 | 22 | |||
415 | 190934 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1101 25th St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 9ft | 6015168.60212 | 2102024.17667 | 37.7526102335912 | -122.390415424833 | (37.7526102335912, -122.390415424833) | 10 | 3 | 8 | 28856 | 1 | |||
418 | 191568 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1610 Innes Ave | 7 | : | Tree | Private 2 | 6 | Width 3ft | 6015230.3015 | 2097471.78413 | 37.7401137346697 | -122.389884091895 | (37.7401137346697, -122.389884091895) | 10 | 3 | 8 | 58 | 1 | |||
420 | 35740 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 9 Princeton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/15/1998 12:00:00 AM | 12 | Permit Number 39014 | 6007525.01662 | 2093953.73286 | 37.7300236128799 | -122.416276791867 | (37.7300236128799, -122.416276791867) | 9 | 3 | 7 | 309 | 28 | |
421 | 65202 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 415 Moscow St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/1989 12:00:00 AM | 29 | Permit Number 27188 | 6004121.81538 | 2090701.65991 | 37.7209021868562 | -122.4278104505 | (37.7209021868562, -122.4278104505) | 9 | 7 | 6 | 28861 | 5 | |
422 | 113225 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 970JONES Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 3x3 | 6008828.65356 | 2115644.68399 | 37.7896552332384 | -122.413303262628 | (37.7896552332384, -122.413303262628) | 5 | 1 | 10 | 28858 | 21 | ||
423 | 140125 | DPW Maintained 1 | :: 45 | 1321 Divisadero St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6001271.8045 | 2112891.6174 | 37.7816688523257 | -122.439251726799 | (37.7816688523257, -122.439251726799) | 15 | 5 | 11 | 29490 | 41 | |||
426 | 183962 | DPW Maintained 1 | :: 45 | 2158 22nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5989481.017 | 2100669.218 | 37.7474314478739 | -122.479147472521 | (37.7474314478739, -122.479147472521) | 1 | 8 | 3 | 29491 | 35 | |||
432 | 196351 | DPW Maintained 1 | Prunus lyonii :: Catalina Cherry 104 | 1900 19th St | 20 | Front Yard : Yard | Tree | Private 2 | 3 | 6011965.48 | 2105145.22305 | 37.7610017347515 | -122.401711799169 | (37.7610017347515, -122.401711799169) | 10 | 3 | 8 | 28856 | 29 | ||||
437 | 202267 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 28 Orsi Cir | 1 | : | Tree | Private 2 | 5 | Width 2ft | 6013033.98272 | 2093207.99375 | 37.7282842035544 | -122.397179214247 | (37.7282842035544, -122.397179214247) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 |
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) );