trees
194,517 rows sorted by rowid 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 194417 | 265061 | Section 806 (d) 5 | Prunus serrulata :: Ornamental Cherry 84 | 48 Miraloma Dr | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6x6 | 5994833.01253 | 2097558.21258 | 37.7391987718964 | -122.46041537824 | (37.7391987718964, -122.46041537824) | 9 | 7 | 4 | 59 | 40 | ||||
| 194416 | 179075 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2 Edinburgh St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/27/2017 08:37:00 AM | 3 | Width 3ft | 6004489 | 2093431 | 37.7284171179042 | -122.426735469001 | (37.7284171179042, -122.426735469001) | 9 | 7 | 6 | 28861 | 5 | ||
| 194415 | 178030 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 745 Brazil Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/11/2017 10:06:00 AM | 3 | Width 3ft | 6003911.3035 | 2091023.37584 | 37.7217736371229 | -122.428561047149 | (37.7217736371229, -122.428561047149) | 9 | 7 | 6 | 28861 | 5 | |
| 194414 | 160553 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 490 France Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/2017 03:20:00 PM | 3 | Width 0ft | 6002152 | 2089716 | 37.7180841555313 | -122.434549060041 | (37.7180841555313, -122.434549060041) | 9 | 7 | 6 | 28861 | 5 | |
| 194413 | 265067 | DPW Maintained 1 | Zelkova serrata :: Sawleaf Zelkova 302 | 500 France Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | Width 0ft | 6002272.40257 | 2089666.1121 | 37.7179540086612 | -122.434129316516 | (37.7179540086612, -122.434129316516) | 9 | 7 | 6 | 28861 | 5 | |||
| 194412 | 265063 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 475@ STILLMAN 04th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6013048.0931 | 2112046.23235 | 37.7800107102631 | -122.398451730656 | (37.7800107102631, -122.398451730656) | 6 | 2 | 9 | 28856 | 34 | |||||
| 194411 | 236860 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1506 Willard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | Permit Number 785228 | 5996892.19398 | 2106024.42834 | 37.7625631359112 | -122.453906940775 | (37.7625631359112, -122.453906940775) | 15 | 5 | 11 | 29492 | 12 | ||
| 194410 | 265060 | Section 806 (d) 5 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 48 Miraloma Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12/28/2020 12:00:00 AM | 3 | 6x6 | Permit Number 782253 | 5994833.01253 | 2097558.21258 | 37.7391987718964 | -122.46041537824 | (37.7391987718964, -122.46041537824) | 9 | 7 | 4 | 59 | 40 | |
| 194409 | 176258 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 09:09:00 AM | 3 | Width 3ft | 6004489 | 2093431 | 37.7284171179042 | -122.426735469001 | (37.7284171179042, -122.426735469001) | 9 | 7 | 6 | 28861 | 5 | ||
| 194408 | 254760 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 170 Arch St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | FUF | 03/26/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781604 | 5992729.03192 | 2088323.37985 | 37.7137209347968 | -122.467018722529 | (37.7137209347968, -122.467018722529) | 9 | 8 | 6 | 64 | 24 |
| 194407 | 265071 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 430 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000887 | 2092304 | 37.7251183251209 | -122.439106989741 | (37.7251183251209, -122.439106989741) | 9 | 7 | 6 | 28861 | 25 | ||||
| 194406 | 265062 | Undocumented 4 | Podocarpus gracilor :: Fern Pine 51 | 285 Arch St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992682 | 2089081 | 37.7157984624799 | -122.46723633367 | (37.7157984624799, -122.46723633367) | 9 | 8 | 6 | 64 | 24 | ||||
| 194405 | 265066 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 475@ STILLMAN 04th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6013048.0931 | 2112046.23235 | 37.7800107102631 | -122.398451730656 | (37.7800107102631, -122.398451730656) | 6 | 2 | 9 | 28856 | 34 | |||||
| 194404 | 162800 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 37 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/22/2020 12:00:00 AM | 3 | 4x6 | 5996614.18155 | 2090524.98833 | 37.7199895242736 | -122.453749186181 | (37.7199895242736, -122.453749186181) | 9 | 8 | 6 | 28861 | 24 | ||
| 194403 | 265059 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 1190 Mason St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/23/2020 12:00:00 AM | 3 | 4x4 | Permit Number 781590 | |||||||||||
| 194402 | 265049 | Private 9 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1595 Oak St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/23/2020 12:00:00 AM | 3 | 5x5 | 5999367.57953 | 2109424.62482 | 37.7720408355473 | -122.445590032014 | (37.7720408355473, -122.445590032014) | 15 | 5 | 11 | 29492 | 9 | ||
| 194401 | 265056 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 1085 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/23/2020 12:00:00 AM | 3 | 4x4 | Permit Number 781590 | 6009500.70465 | 2117396.93811 | 37.794504205778 | -122.41110184732 | (37.794504205778, -122.41110184732) | 3 | 1 | 10 | 28857 | 21 | |
| 194400 | 265055 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 1085 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/23/2020 12:00:00 AM | 3 | 4x4 | Permit Number 781590 | 6009500.70465 | 2117396.93811 | 37.794504205778 | -122.41110184732 | (37.794504205778, -122.41110184732) | 3 | 1 | 10 | 28857 | 21 | |
| 194399 | 183700 | DPW Maintained 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 | 1351 42nd Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5983050 | 2105938 | 37.7615224629013 | -122.501774892125 | (37.7615224629013, -122.501774892125) | 1 | 8 | 3 | 56 | 35 | |||
| 194398 | 162836 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 95 Lee Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/2020 12:00:00 AM | 0 | 4x6 | 5996489.45825 | 2090475.5577 | 37.7198466480955 | -122.454176740991 | (37.7198466480955, -122.454176740991) | 9 | 8 | 6 | 28861 | 24 | |
| 194397 | 160660 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 118 Russia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/08/2017 12:00:00 AM | 3 | Width 0ft | 6001728.7088 | 2090784.69907 | 37.7209945256629 | -122.436088625395 | (37.7209945256629, -122.436088625395) | 9 | 7 | 6 | 28861 | 5 | ||
| 194396 | 265058 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 1190 Mason St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/23/2020 12:00:00 AM | 3 | 4x4 | Permit Number 781590 | |||||||||||
| 194395 | 183689 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1351 42nd Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5983050 | 2105938 | 37.7615224629013 | -122.501774892125 | (37.7615224629013, -122.501774892125) | 1 | 8 | 3 | 56 | 35 | |||
| 194394 | 160700 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 932 Russia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/08/2017 12:00:00 AM | 3 | Width 0ft | 6003612.41439 | 2089600.12112 | 37.7178487735724 | -122.429492779881 | (37.7178487735724, -122.429492779881) | 9 | 7 | 6 | 28861 | 5 | ||
| 194393 | 254878 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3156 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2020 11:28:00 AM | 3 | 3x6 | 5995145 | 2086533 | 37.708944125162 | -122.458538785751 | (37.708944125162, -122.458538785751) | 9 | 8 | 6 | 28861 | 25 | ||
| 194392 | 162798 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 107 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2020 12:00:00 AM | 3 | 4x6 | 5996432.70685 | 2090525.92628 | 37.7199816938867 | -122.454376546047 | (37.7199816938867, -122.454376546047) | 9 | 8 | 6 | 28861 | 24 | ||
| 194391 | 109904 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 224 12th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/09/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779440 | 6007796.5595 | 2109021.55143 | 37.7714117049152 | -122.41640489308 | (37.7714117049152, -122.41640489308) | 8 | 2 | 9 | 28853 | 19 | |
| 194390 | 8397 | DPW Maintained 1 | Cupressocyparis leylandii :: Leyland Cypress 185 | 1500 Geary Blvd | 8 | Median : Cutout | Tree | DPW 1 | 18 | 8 | 6004036.9348 | 2113953.0096 | 37.7847401317276 | -122.429761413143 | (37.7847401317276, -122.429761413143) | 13 | 9 | 11 | 29490 | 41 | |||
| 194389 | 265057 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 1190 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/23/2020 12:00:00 AM | 3 | 4x4 | Permit Number 781590 | |||||||||||
| 194388 | 162793 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 201 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2020 12:00:00 AM | 3 | 4x6 | 5996142.86432 | 2090531.62526 | 37.7199807154151 | -122.455378837768 | (37.7199807154151, -122.455378837768) | 9 | 8 | 6 | 28861 | 24 | ||
| 194387 | 183688 | DPW Maintained 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 | 1351 42nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5983050 | 2105938 | 37.7615224629013 | -122.501774892125 | (37.7615224629013, -122.501774892125) | 1 | 8 | 3 | 56 | 35 | |||
| 194386 | 73728 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1714 Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/24/2020 11:22:00 AM | 3 | Permit Number 782600 | 6010056.6035 | 2120001.6041 | 37.8016871392069 | -122.409362262219 | (37.8016871392069, -122.409362262219) | 3 | 1 | 10 | 308 | 23 | |
| 194385 | 115926 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 355 Bryant St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2020 11:25:00 AM | 3 | 3x3 | 6014797.50176 | 2113407.35792 | 37.7838453529251 | -122.392494926324 | (37.7838453529251, -122.392494926324) | 6 | 2 | 9 | 28856 | 6 | ||
| 194384 | 254279 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 80X Junipero Serra Blvd | 3 | Median : Yard | Tree | Private 2 | 12/24/2020 01:32:00 PM | 3 | 3x3 | 5991405 | 2095520 | 37.733404559811 | -122.472119261767 | (37.733404559811, -122.472119261767) | 1 | 8 | 4 | 64 | 40 | ||
| 194383 | 170708 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 77 Delano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/08/2017 12:00:00 AM | 3 | Width 3ft | 6000579.72538 | 2092917.63724 | 37.7267857432424 | -122.440213187895 | (37.7267857432424, -122.440213187895) | 9 | 7 | 6 | 28861 | 25 | ||
| 194382 | 259013 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 131 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2020 12:00:00 AM | 3 | 4x6 | 5996343 | 2090506 | 37.7199218359789 | -122.45468519116 | (37.7199218359789, -122.45468519116) | 9 | 8 | 6 | 28861 | 24 | ||
| 194381 | 259007 | DPW Maintained 1 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 | 44 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2020 12:00:00 AM | 3 | 4x4 | 5996586 | 2090578 | 37.720133466152 | -122.453850425827 | (37.720133466152, -122.453850425827) | 9 | 8 | 6 | 28861 | 24 | ||
| 194380 | 255779 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 45 Niagara Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 04/08/2017 12:00:00 AM | 3 | 3x3 | 5999808 | 2089058 | 37.7161440949055 | -122.442604012325 | (37.7161440949055, -122.442604012325) | 9 | 7 | 6 | 28861 | 25 | |
| 194379 | 68392 | DPW Maintained 1 | Olea Majestic Beauty :: 183 | 240 Cotter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779249 | 6001623.41455 | 2093933.04413 | 37.7296331848184 | -122.436677841421 | (37.7296331848184, -122.436677841421) | 9 | 7 | 6 | 28861 | 25 |
| 194378 | 162678 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 208 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2020 12:00:00 AM | 3 | 4x6 | 5996153.38061 | 2090571.45956 | 37.7200906944144 | -122.455345364123 | (37.7200906944144, -122.455345364123) | 9 | 8 | 6 | 28861 | 24 | ||
| 194377 | 171274 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 134 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/2017 12:00:00 AM | 3 | Width 3ft | 6004391.75762 | 2092740.75057 | 37.726516347746 | -122.427022498699 | (37.726516347746, -122.427022498699) | 9 | 7 | 6 | 28861 | 5 | ||
| 194376 | 171271 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 330 Peru Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/08/2017 12:00:00 AM | 3 | Width 3ft | 6004457.49043 | 2092972.68503 | 37.7271569051579 | -122.426811773162 | (37.7271569051579, -122.426811773162) | 9 | 7 | 6 | 28861 | 5 | ||
| 194375 | 206127 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 207 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/11/2008 12:00:00 AM | 4 | Width 3ft | 5995066.94571 | 2106670.30306 | 37.7642317209355 | -122.460266565852 | (37.7642317209355, -122.460266565852) | 15 | 5 | 11 | 56 | 12 | ||
| 194374 | 265048 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 959 Kirkham St | 1 | Front Yard : Yard | Tree | Private 2 | 20x20 | 5991956 | 2105209 | 37.7600399316741 | -122.470919881603 | (37.7600399316741, -122.470919881603) | 1 | 8 | 4 | 56 | 12 | ||||
| 194373 | 53965 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 753 Davis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 17 | Permit Number 9680 | 6013049.65631 | 2119205.04164 | 37.799667209323 | -122.39894891638 | (37.799667209323, -122.39894891638) | 3 | 1 | 10 | 28860 | 6 | ||
| 194372 | 37826 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 450X Moscow St | 14 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/07/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40134 | 6003896.37457 | 2090444.78719 | 37.7201841150858 | -122.428571430748 | (37.7201841150858, -122.428571430748) | 9 | 7 | 6 | 28861 | 5 |
| 194371 | 205154 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 200 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/10/2008 12:00:00 AM | 7 | Width 3ft | 5995104.98822 | 2106728.27185 | 37.7643930764078 | -122.460139188574 | (37.7643930764078, -122.460139188574) | 15 | 5 | 11 | 56 | 12 | ||
| 194370 | 258049 | DPW Maintained 1 | Olea europaea 'Swan Hill' :: Olive 161 | 576 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 5x6 | Cross streets are also Jasper to Stockton; site is directly across from Via Ferlinghetti (alley) | 6010185.99879 | 2119580.18301 | 37.8005372695328 | -122.408884743211 | (37.8005372695328, -122.408884743211) | 3 | 1 | 10 | 308 | 23 | |||
| 194369 | 239983 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 4093 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6002641.47002 | 2101787.20604 | 37.7512566972432 | -122.433719446911 | (37.7512566972432, -122.433719446911) | 2 | 4 | 5 | 28862 | 22 | |||
| 194368 | 206128 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 207 Irving St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/11/2008 12:00:00 AM | 2 | Width 3ft | 5995094.6325 | 2106669.72305 | 37.7642317209303 | -122.46017076378 | (37.7642317209303, -122.46017076378) | 15 | 5 | 11 | 56 | 12 | ||
| 194367 | 56573 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 250 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/29/2019 12:00:00 AM | 3 | 5x5 | 6010068.531 | 2121298.26 | 37.8052481034096 | -122.409412549107 | (37.8052481034096, -122.409412549107) | 3 | 1 | 10 | 308 | 23 | ||
| 194366 | 265027 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 2623 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 3x3 | 5997622 | 2089116 | 37.7161784966097 | -122.450164015076 | (37.7161784966097, -122.450164015076) | 9 | 8 | 6 | 28861 | 24 | |||
| 194365 | 265036 | Undocumented 4 | Potential Site :: Potential Site 48 | 1250X Alabama St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009246 | 2101881 | 37.7518867820544 | -122.410886782822 | (37.7518867820544, -122.410886782822) | 2 | 4 | 7 | 28859 | 19 | |||||
| 194364 | 265034 | Undocumented 4 | Potential Site :: Potential Site 48 | 3012 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009402 | 2101646 | 37.7512502705876 | -122.410330719668 | (37.7512502705876, -122.410330719668) | 2 | 4 | 7 | 28859 | 19 | ||||
| 194363 | 265042 | Significant Tree 6 | Tree(s) :: 17 | 1000X Mandalay Ln | 2 | Unaccepted Street : Yard | Tree | Private 2 | 12/17/2020 12:00:00 AM | 3 | 10x010 | Permit Number 787936 | |||||||||||
| 194362 | 265015 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 303 Goettingen St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 2ft | 6010297.36317 | 2092850.16177 | 37.7271489416555 | -122.406614663752 | (37.7271489416555, -122.406614663752) | 10 | 3 | 7 | 309 | 28 | ||||
| 194361 | 265029 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2611 San Jose Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 12/05/1997 12:00:00 AM | 3x3 | 5997671 | 2089167 | 37.7163213347739 | -122.449998321991 | (37.7163213347739, -122.449998321991) | 9 | 8 | 6 | 28861 | 24 | ||
| 194360 | 265028 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2621 San Jose Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997640 | 2089142 | 37.7162509166522 | -122.450103671662 | (37.7162509166522, -122.450103671662) | 9 | 8 | 6 | 28861 | 24 | ||||
| 194359 | 262298 | Significant Tree 6 | Tree(s) :: 17 | 1000X Mandalay Ln | 1 | Side Yard : Yard | Tree | Private 2 | 12/17/2020 12:00:00 AM | 3 | 10x10 | Permit Number 787936 | 5991616 | 2101838 | 37.7507643799851 | -122.471850083311 | (37.7507643799851, -122.471850083311) | 1 | 8 | 4 | 29491 | 12 | |
| 194358 | 265019 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 303 Goettingen St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 2ft | 6010297.36317 | 2092850.16177 | 37.7271489416555 | -122.406614663752 | (37.7271489416555, -122.406614663752) | 10 | 3 | 7 | 309 | 28 | ||||
| 194357 | 265018 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 303 Goettingen St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 2ft | 6010297.36317 | 2092850.16177 | 37.7271489416555 | -122.406614663752 | (37.7271489416555, -122.406614663752) | 10 | 3 | 7 | 309 | 28 | ||||
| 194356 | 224589 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 2765 16th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6008256.05874 | 2106775.28704 | 37.7652698164603 | -122.414656469826 | (37.7652698164603, -122.414656469826) | 8 | 4 | 7 | 28859 | 19 | |||
| 194355 | 265020 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 303 Goettingen St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 2ft | 6010297.36317 | 2092850.16177 | 37.7271489416555 | -122.406614663752 | (37.7271489416555, -122.406614663752) | 10 | 3 | 7 | 309 | 28 | ||||
| 194354 | 265021 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 303 Goettingen St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 2ft | 6010297.36317 | 2092850.16177 | 37.7271489416555 | -122.406614663752 | (37.7271489416555, -122.406614663752) | 10 | 3 | 7 | 309 | 28 | ||||
| 194353 | 265038 | Undocumented 4 | Potential Site :: Potential Site 48 | 1250X Alabama St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009246 | 2101881 | 37.7518867820544 | -122.410886782822 | (37.7518867820544, -122.410886782822) | 2 | 4 | 7 | 28859 | 19 | |||||
| 194352 | 265022 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 99 Harlan Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6011098 | 2115736 | 37.7900331129851 | -122.405457946913 | (37.7900331129851, -122.405457946913) | 5 | 1 | 10 | 28857 | 6 | ||||
| 194351 | 265046 | Section 806 (d) 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1250 Eucalyptus Dr | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 12/17/2020 12:00:00 AM | 3 | 5x10 | Permit Number 781946 | 5987698.06233 | 2094734.87015 | 37.7310335805158 | -122.484877445397 | (37.7310335805158, -122.484877445397) | 1 | 8 | 4 | 64 | 35 | |
| 194350 | 265014 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 303 Goettingen St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 2ft | 6010297.36317 | 2092850.16177 | 37.7271489416555 | -122.406614663752 | (37.7271489416555, -122.406614663752) | 10 | 3 | 7 | 309 | 28 | ||||
| 194349 | 265045 | Section 806 (d) 5 | Tree(s) :: 17 | 1250 Eucalyptus Dr | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 12/17/2020 12:00:00 AM | 3 | 5x10 | Permit Number 781946 | 5987698.06233 | 2094734.87015 | 37.7310335805158 | -122.484877445397 | (37.7310335805158, -122.484877445397) | 1 | 8 | 4 | 64 | 35 | |
| 194348 | 265030 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2611 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 12/05/1997 12:00:00 AM | 3x3 | 5997671 | 2089167 | 37.7163213347739 | -122.449998321991 | (37.7163213347739, -122.449998321991) | 9 | 8 | 6 | 28861 | 24 | ||
| 194347 | 159854 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 71 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/2020 12:00:00 AM | 3 | 4x6 | 6001434.62769 | 2091757.97581 | 37.7236502119613 | -122.437174824773 | (37.7236502119613, -122.437174824773) | 9 | 7 | 6 | 28861 | 25 | ||
| 194346 | 265043 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 1250 Eucalyptus Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12/17/2020 12:00:00 AM | 3 | 5x10 | Permit Number 781946 | 5987698.06233 | 2094734.87015 | 37.7310335805158 | -122.484877445397 | (37.7310335805158, -122.484877445397) | 1 | 8 | 4 | 64 | 35 | |
| 194345 | 265012 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 303 Goettingen St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 2ft | 6010297.36317 | 2092850.16177 | 37.7271489416555 | -122.406614663752 | (37.7271489416555, -122.406614663752) | 10 | 3 | 7 | 309 | 28 | ||||
| 194344 | 124321 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 115 Jordan Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12/16/2020 12:00:00 AM | 3 | Width 3ft | 5996193.40211 | 2113658.22839 | 37.7834834671867 | -122.456875951009 | (37.7834834671867, -122.456875951009) | 11 | 6 | 1 | 54 | 31 | ||
| 194343 | 265044 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 1250 Eucalyptus Dr | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 12/17/2020 12:00:00 AM | 3 | 5x10 | Permit Number 781946 | 5987698.06233 | 2094734.87015 | 37.7310335805158 | -122.484877445397 | (37.7310335805158, -122.484877445397) | 1 | 8 | 4 | 64 | 35 | |
| 194342 | 265013 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 303 Goettingen St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 2ft | 6010297.36317 | 2092850.16177 | 37.7271489416555 | -122.406614663752 | (37.7271489416555, -122.406614663752) | 10 | 3 | 7 | 309 | 28 | ||||
| 194341 | 265017 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 303 Goettingen St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 2ft | 6010297.36317 | 2092850.16177 | 37.7271489416555 | -122.406614663752 | (37.7271489416555, -122.406614663752) | 10 | 3 | 7 | 309 | 28 | ||||
| 194340 | 265026 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2621 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 11/07/2001 12:00:00 AM | 3x3 | 5997640 | 2089142 | 37.7162509166522 | -122.450103671662 | (37.7162509166522, -122.450103671662) | 9 | 8 | 6 | 28861 | 24 | ||
| 194339 | 265037 | Undocumented 4 | Potential Site :: Potential Site 48 | 1250X Alabama St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009246 | 2101881 | 37.7518867820544 | -122.410886782822 | (37.7518867820544, -122.410886782822) | 2 | 4 | 7 | 28859 | 19 | |||||
| 194338 | 265025 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 99 Harlan Pl | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6011098 | 2115736 | 37.7900331129851 | -122.405457946913 | (37.7900331129851, -122.405457946913) | 5 | 1 | 10 | 28857 | 6 | ||||
| 194337 | 265035 | Undocumented 4 | Potential Site :: Potential Site 48 | 1250X Alabama St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009246 | 2101881 | 37.7518867820544 | -122.410886782822 | (37.7518867820544, -122.410886782822) | 2 | 4 | 7 | 28859 | 19 | |||||
| 194336 | 265016 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 303 Goettingen St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 2ft | 6010297.36317 | 2092850.16177 | 37.7271489416555 | -122.406614663752 | (37.7271489416555, -122.406614663752) | 10 | 3 | 7 | 309 | 28 | ||||
| 194335 | 265024 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 99 Harlan Pl | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6011098 | 2115736 | 37.7900331129851 | -122.405457946913 | (37.7900331129851, -122.405457946913) | 5 | 1 | 10 | 28857 | 6 | ||||
| 194334 | 265023 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 99 Harlan Pl | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6011098 | 2115736 | 37.7900331129851 | -122.405457946913 | (37.7900331129851, -122.405457946913) | 5 | 1 | 10 | 28857 | 6 | ||||
| 194333 | 238518 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 210 Surrey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6002025.02718 | 2096169.57182 | 37.7357969924364 | -122.435449354007 | (37.7357969924364, -122.435449354007) | 2 | 7 | 5 | 63 | 7 | |||
| 194332 | 237618 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 395 Eureka St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/11/2020 12:00:00 AM | 3 | 3x3 | Permit Number 787900 | 6001516.02196 | 2103550.89224 | 37.756035430207 | -122.437737665468 | (37.756035430207, -122.437737665468) | 2 | 4 | 5 | 28862 | 3 | |
| 194331 | 143216 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 217 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6010256 | 2121247 | 37.8051178581324 | -122.408760167658 | (37.8051178581324, -122.408760167658) | 3 | 1 | 10 | 308 | 23 | |||
| 194330 | 265002 | Significant Tree 6 | :: Tree 573 | 1445 San Bruno Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5x5 | 6011217 | 2101257 | 37.7502837374969 | -122.404026841996 | (37.7502837374969, -122.404026841996) | 10 | 4 | 8 | 28859 | 19 | ||||
| 194329 | 54859 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1830 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/10/1972 12:00:00 AM | 25 | Permit Number 10718 | 5999038.10946992 | 2110464.35352985 | 37.7748768498196 | -122.446804517086 | (37.7748768498196, -122.446804517086) | 15 | 5 | 11 | 29492 | 16 | ||
| 194328 | 258403 | Section 806 (d) 5 | Eriobotrya deflexa :: Bronze Loquat 8 | 1052 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/10/2019 12:00:00 AM | 3 | 3x5 | 6011869 | 2103486 | 37.7564404909426 | -122.401928842587 | (37.7564404909426, -122.401928842587) | 10 | 3 | 8 | 28856 | 29 | ||
| 194327 | 163429 | DPW Maintained 1 | Cassia leptophylla :: Gold Medallion Tree 152 | 426 Capitol Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/2020 12:00:00 AM | 3 | 4x6 | 5995056.70261 | 2088533.80912 | 37.714432803101 | -122.458988723671 | (37.714432803101, -122.458988723671) | 9 | 8 | 6 | 28861 | 24 | ||
| 194326 | 139658 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1654 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6001647 | 2111894 | 37.7789509909807 | -122.437882254054 | (37.7789509909807, -122.437882254054) | 15 | 5 | 11 | 29490 | 41 | |||
| 194325 | 163425 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 402X Capitol Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/2020 12:00:00 AM | 3 | 4x6 | 5995055.45495 | 2088438.70724 | 37.7141716040183 | -122.458986154313 | (37.7141716040183, -122.458986154313) | 9 | 8 | 6 | 28861 | 24 | ||
| 194324 | 163428 | DPW Maintained 1 | Olea Majestic Beauty :: 183 | 416 Capitol Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/2020 12:00:00 AM | 0 | 4x6 | 5995056.18363 | 2088509.02002 | 37.7143647082391 | -122.458988723675 | (37.7143647082391, -122.458988723675) | 9 | 8 | 6 | 28861 | 24 | ||
| 194323 | 264998 | DPW Maintained 1 | :: Tree 573 | 712 Francisco St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007843 | 2120971 | 37.8042245839852 | -122.417091095202 | (37.8042245839852, -122.417091095202) | 5 | 1 | 1 | 308 | 32 | |||||
| 194322 | 236900 | DPW Maintained 1 | :: Tree 573 | 240 Alma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5997562.78425 | 2106158.57847 | 37.7629699037624 | -122.451597300975 | (37.7629699037624, -122.451597300975) | 15 | 5 | 11 | 29492 | 9 | |||
| 194321 | 212968 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 403 Irving St | 5 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6 | 6x8 | 5994507.69841 | 2106650.30443 | 37.7641446251863 | -122.462199378021 | (37.7641446251863, -122.462199378021) | 1 | 5 | 11 | 56 | 12 | |||
| 194320 | 206251 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 450 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/2020 05:08:00 PM | 3 | 4x6 | Permit Number 780527 | 5994371.92355 | 2106700.48715 | 37.7642745952224 | -122.462672621052 | (37.7642745952224, -122.462672621052) | 11 | 5 | 11 | 56 | 12 | |
| 194319 | 252846 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1500 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/2020 12:00:00 AM | 3 | 3x3 | 6008908 | 2108725 | 37.7706598827985 | -122.412539385599 | (37.7706598827985, -122.412539385599) | 8 | 2 | 9 | 28853 | 19 | ||
| 194318 | 264973 | Section 806 (d) 5 | Lophostemon confertus :: Brisbane Box 11 | 3135 Pierce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 781901 | 6001403 | 2119193 | 37.7989782820217 | -122.43924964791 | (37.7989782820217, -122.43924964791) | 13 | 9 | 1 | 57 | 17 |
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) );