trees
194,517 rows sorted by SiteOrder
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7310 | 96412 | Significant Tree 6 | Acer palmatum :: Japanese Maple 216 | 185 Chilton Ave | Front Yard : Yard | Tree | Private 2 | 05/18/2011 12:00:00 AM | Permit Number 767805 | 6001587.1 | 2095138.7 | 37.732941575251 | -122.436889661497 | (37.732941575251, -122.436889661497) | 9 | 7 | 5 | 63 | 40 | ||||
| 7333 | 262326 | Undocumented 4 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 10 Roemer Way | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5998623 | 2086576 | 37.7092614661016 | -122.446521459005 | (37.7092614661016, -122.446521459005) | 9 | 7 | 6 | 28861 | 5 | |||||
| 7373 | 96567 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.7310370666678 | -122.483566221845 | (37.7310370666678, -122.483566221845) | 1 | 8 | 4 | 64 | 14 | ||||
| 7388 | 29904 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 580 Fell St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6004657.19551 | 2110576.88809 | 37.7755052392808 | -122.427374927138 | (37.7755052392808, -122.427374927138) | 7 | 9 | 11 | 28852 | 10 | ||||||
| 7425 | 260849 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 765 34th Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5985374.15255 | 2110672.13132 | 37.774657298519 | -122.494085649617 | (37.774657298519, -122.494085649617) | 11 | 6 | 2 | 55 | 26 | |||
| 7475 | 260914 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1165 Oak St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/21/2019 12:00:00 AM | 3 | 6001427.67727 | 2109710.45692 | 37.7729430567741 | -122.438484490103 | (37.7729430567741, -122.438484490103) | 15 | 5 | 11 | 29492 | 9 | |||
| 7665 | 107118 | Undocumented 4 | Tree(s) :: 17 | 49 Elsie St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/2014 12:00:00 AM | 6x3 | Permit Number 773429 | 6007534.56738 | 2099145.89717 | 37.7442806914439 | -122.41661143894 | (37.7442806914439, -122.41661143894) | 2 | 7 | 7 | 28859 | 2 | |||
| 7701 | 97237 | Property Tree 8 | Olea europaea :: Olive Tree 9 | 125 Excelsior Ave | Sidewalk: Property side : Yard | Tree | SFUSD 4 | FUF | 09/07/2011 12:00:00 AM | Permit Number 767513 | 6002911 | 2092621.3 | 37.7261045201699 | -122.432132888294 | (37.7261045201699, -122.432132888294) | 9 | 7 | 6 | 28861 | 5 | |||
| 7770 | 98170 | Significant Tree 6 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 2324 Sacramento St | Front Yard : Yard | Tree | Private 2 | 12/22/2011 12:00:00 AM | 3 | Permit Number 768454 | 6003670.2 | 2115963.1 | 37.7902385582714 | -122.431173718492 | (37.7902385582714, -122.431173718492) | 13 | 9 | 1 | 29490 | 27 | |||
| 7789 | 259629 | DPW Maintained 1 | :: 45 | 18 Arleta Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | 6011290.10954 | 2087489.4095 | 37.7124849020689 | -122.402805875722 | (37.7124849020689, -122.402805875722) | 9 | 7 | 8 | 309 | 39 | |||
| 8082 | 96598 | Property Tree 8 | Citrus × meyeri 'Improved' :: Improved Meyer Lemon 317 | 325 Sanchez St | Sidewalk: Property side : Cutout | tree | SFUSD 4 | FUF | 6003898 | 2106263.7 | 37.7636193068731 | -122.429693469686 | (37.7636193068731, -122.429693469686) | 8 | 4 | 5 | 28862 | 3 | |||||
| 8192 | 258125 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 731 Woolsey St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 3x5 | 6009632.88512 | 2091554.43402 | 37.7235539468335 | -122.408820391364 | (37.7235539468335, -122.408820391364) | 9 | 3 | 7 | 309 | 28 | |||
| 8281 | 87805 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 21 Mallorca Way | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50570 | 6001886.8 | 2119949.6 | 37.8010832252731 | -122.437629755692 | (37.8010832252731, -122.437629755692) | 13 | 9 | 1 | 57 | 17 | |||
| 8305 | 86762 | Permitted Site 7 | Tree(s) :: 17 | 500 Brotherhood Way | unknown : Yard | Tree | Private 2 | 10/04/2007 12:00:00 AM | Permit Number 49739 | 5992573.4 | 2087955 | 37.7127004679185 | -122.467529866031 | (37.7127004679185, -122.467529866031) | 9 | 8 | 6 | 64 | 24 | ||||
| 8317 | 260848 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 754 34th Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5985411.75213 | 2110738.83335 | 37.7748426432981 | -122.493960503851 | (37.7748426432981, -122.493960503851) | 11 | 6 | 2 | 55 | 26 | |||
| 8362 | 96178 | Permitted Site 7 | Citrus aurantifolia 'Bearss' :: Seedless Lime 290 | Unaccepted Street : Cutout | Tree | Private 2 | 04/04/2011 12:00:00 AM | 3x3 | Permit Number 767810 | ||||||||||||||
| 8384 | 104821 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2173 15TH ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 6003063.7 | 2107068.1 | 37.7657807169148 | -122.432636512343 | (37.7657807169148, -122.432636512343) | 15 | 5 | 5 | 28862 | 3 | |||||
| 8520 | 108716 | Permitted Site 7 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 | 201 Randall St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773302 | 6004213.21698 | 2097517.41416 | 37.7396218942487 | -122.427979939698 | (37.7396218942487, -122.427979939698) | 2 | 7 | 5 | 63 | 7 | |
| 8544 | 256668 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1835 Hyde St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782601 | |||||||||||
| 8593 | 91087 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 134 Ralston St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2008 12:00:00 AM | 3x3 | Permit Number 51982 | 5992207 | 2088764 | 37.7149006256244 | -122.46885508368 | (37.7149006256244, -122.46885508368) | 9 | 8 | 6 | 64 | 24 | |||
| 8599 | 262043 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 245 11th St | : Cutout | Tree | Private 2 | FUF | 04/14/2020 12:00:00 AM | 3 | Permit Number 785251 | 6008265.74007 | 2109435.35593 | 37.7725742877847 | -122.414811260337 | (37.7725742877847, -122.414811260337) | 8 | 2 | 9 | 28853 | 34 | ||
| 8600 | 260856 | DPW Maintained 1 | Tree(s) :: 17 | 626 33rd Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 5985689.47211 | 2111611.95975 | 37.7772562449138 | -122.493064158363 | (37.7772562449138, -122.493064158363) | 11 | 6 | 2 | 55 | 26 | |||||
| 8700 | 106117 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 405 Lisbon St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/24/2014 12:00:00 AM | 3x3 | Permit Number 772749 | 6002458.5 | 2091056.7 | 37.7217828139374 | -122.433585385445 | (37.7217828139374, -122.433585385445) | 9 | 7 | 6 | 28861 | 5 | |||
| 8860 | 260613 | DPW Maintained 1 | Tree(s) :: 17 | 1271 Revere Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6016832.40592 | 2093073.03805 | 37.7281243722496 | -122.384038382899 | (37.7281243722496, -122.384038382899) | 10 | 3 | 8 | 58 | 1 | |||
| 8887 | 261586 | Undocumented 4 | Calocedrus decurrens :: Incense Cedar 206 | 20 Aptos Ave | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5993103 | 2094790 | 37.7314982775013 | -122.466195816439 | (37.7314982775013, -122.466195816439) | 9 | 8 | 4 | 59 | 40 | |||||
| 8909 | 259799 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1345 Brussels St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | 6011890.92519 | 2088681.18109 | 37.7157907972077 | -122.400812935252 | (37.7157907972077, -122.400812935252) | 10 | 7 | 8 | 309 | 39 | |||
| 8911 | 87411 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 898X Ellis St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/22/2008 12:00:00 AM | 3 | 3x3 | 6006570.640875 | 2113589.260791 | 37.7838845156579 | -122.420969775985 | (37.7838845156579, -122.420969775985) | 7 | 9 | 9 | 28858 | 36 | |||
| 8975 | 256665 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 1381 Filbert St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/2018 12:00:00 AM | 3 | 5x5 | Permit Number 782595 | 6006338.70929 | 2119347.35531 | 37.7996817310416 | -122.422181395696 | (37.7996817310416, -122.422181395696) | 13 | 9 | 1 | 28858 | 32 | |
| 9009 | 258692 | Property Tree 8 | Pinus canariensis :: Canary Island Pine 35 | 100x Whitney Young Cir | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x3 | 6016360 | 2096059 | 37.7362970999571 | -122.385879567348 | (37.7362970999571, -122.385879567348) | 10 | 3 | 8 | 58 | 1 | |||||
| 9277 | 85291 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 7350 Geary Blvd | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2007 12:00:00 AM | 2 | 4x72 | Permit Number 49578 | 5984127.30348 | 2112512.4695 | 37.779637298343 | -122.498534651264 | (37.779637298343, -122.498534651264) | 11 | 6 | 2 | 55 | 26 | ||
| 9283 | 94134 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 18 Nebraska St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2010 12:00:00 AM | 3x3 | Permit Number 53498 | 6009291 | 2097948 | 37.7410901551317 | -122.410453476975 | (37.7410901551317, -122.410453476975) | 10 | 7 | 7 | 28859 | 2 | |||
| 9345 | 259797 | DPW Maintained 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 | 568 Brussels St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 04/27/2019 12:00:00 AM | 3 | 6010803.65234 | 2092086.8288 | 37.7250813008862 | -122.404810700268 | (37.7250813008862, -122.404810700268) | 10 | 3 | 7 | 309 | 28 | |||
| 9358 | 252934 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 78 Edgar Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997141 | 2091229 | 37.7219527643602 | -122.451978930217 | (37.7219527643602, -122.451978930217) | 9 | 8 | 6 | 28861 | 24 | |||||
| 9380 | 259601 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 1606 Newcomb Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6015178 | 2095783 | 37.7354737780225 | -122.389946992713 | (37.7354737780225, -122.389946992713) | 10 | 3 | 8 | 58 | 1 | |||||
| 9408 | 259103 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 625 Visitacion Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | 6010501.76504 | 2086856.29359 | 37.7107024439005 | -122.405486089504 | (37.7107024439005, -122.405486089504) | 9 | 7 | 8 | 309 | 39 | |||
| 9454 | 260881 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 751 33rd Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5985678.2622 | 2110774.56948 | 37.7749563544765 | -122.493041236092 | (37.7749563544765, -122.493041236092) | 11 | 6 | 2 | 55 | 26 | |||
| 9531 | 258361 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 508 Silliman St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 4x5 | 6009293.67894 | 2093897.78594 | 37.7299692902001 | -122.410158335055 | (37.7299692902001, -122.410158335055) | 9 | 3 | 7 | 309 | 28 | ||||
| 9573 | 108831 | Permitted Site 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 46 Ney St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | Permit Number 774658 | 6003763.1265 | 2093992.42876 | 37.7299176091889 | -122.429284866217 | (37.7299176091889, -122.429284866217) | 9 | 7 | 6 | 28861 | 5 | |||
| 9576 | 258366 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 816 Silliman St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 4x5 | 6008411.83681 | 2093627.45022 | 37.7291775379757 | -122.413187871426 | (37.7291775379757, -122.413187871426) | 9 | 3 | 7 | 309 | 28 | ||||
| 9674 | 97174 | Significant Tree 6 | Tristaniopsis laurina :: Swamp Myrtle 1 | 26 Gilbert St | Sidewalk: Property side : Cutout | Tree | Private 2 | FUF | 6011445.1 | 2110013.2 | 37.7743390438118 | -122.40385413458 | (37.7743390438118, -122.40385413458) | 14 | 2 | 9 | 28853 | 34 | |||||
| 10043 | 264733 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1367 De Haro St | Median : Cutout | Tree | DPW 1 | 3x3 | 6012260 | 2102130 | 37.7527390251575 | -122.400481372119 | (37.7527390251575, -122.400481372119) | 10 | 3 | 8 | 28856 | 29 | |||||
| 10067 | 88529 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51479 | ||||||||||||||
| 10084 | 91045 | Permitted Site 7 | Pyrus calleryana 'Redspire' :: Ornamental Pear Tree 'Redspire' 292 | 1100X Chestnut St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/09/2006 12:00:00 AM | 3x3 | Permit Number 48418 | 6006545 | 2120445 | 37.8027072182013 | -122.42154555229 | (37.8027072182013, -122.42154555229) | 5 | 9 | 1 | 28858 | 32 | |||
| 10118 | 108815 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 474 Munich St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774652 | 6003779.44726 | 2089723.38143 | 37.7181966752665 | -122.428924204145 | (37.7181966752665, -122.428924204145) | 9 | 7 | 6 | 28861 | 5 | |
| 10126 | 88578 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1799 Cabrillo St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/2008 12:00:00 AM | 1 | 3x3 | Permit Number 51517 | 5990110.26399 | 2110629.43192 | 37.7748160474001 | -122.477699547866 | (37.7748160474001, -122.477699547866) | 11 | 6 | 2 | 55 | 26 | ||
| 10379 | 95953 | Significant Tree 6 | Tree(s) :: 17 | 499 Buena Vista East Ave | Front Yard : Yard | Tree | Private 2 | 03/18/2011 12:00:00 AM | 21 | Permit Number 57015 | 6000177 | 2107098 | 37.7656986843565 | -122.442623109531 | (37.7656986843565, -122.442623109531) | 15 | 5 | 5 | 29492 | 3 | |||
| 10409 | 256902 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2051 34th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782737 | 5985693.46852 | 2101265.2111 | 37.7488471905551 | -122.492288254945 | (37.7488471905551, -122.492288254945) | 1 | 8 | 3 | 29491 | 35 | |
| 10436 | 105254 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 130 GONZALEZ DR | Front Yard : Yard | Tree | Private 2 | 2 | 5990327 | 2090136 | 37.7185590045312 | -122.47545320092 | (37.7185590045312, -122.47545320092) | 1 | 8 | 4 | 64 | 14 | |||||
| 10488 | 260919 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 630 Cole St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/21/2019 12:00:00 AM | 3 | 5997903.7812 | 2108434.36371 | 37.7692381539002 | -122.450581995995 | (37.7692381539002, -122.450581995995) | 15 | 5 | 11 | 29492 | 9 | |||
| 10535 | 258146 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1048 Folsom St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 6010642.12041 | 2111257.36423 | 37.7777103373451 | -122.406719502289 | (37.7777103373451, -122.406719502289) | 14 | 2 | 9 | 28853 | 34 | ||||
| 10600 | 254532 | Permitted Site 7 | Olea europaea 'Majestic Beauty' :: Majestic Beauty Fruitless Olive 23 | 154 Arleta Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781436 | |||||||||||
| 10744 | 260918 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 469 Frederick St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/21/2019 12:00:00 AM | 3 | 5997465.89984 | 2107424.38822 | 37.7664399466471 | -122.452023719463 | (37.7664399466471, -122.452023719463) | 15 | 5 | 11 | 29492 | 9 | |||
| 10747 | 260852 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 629 33rd Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/13/2020 12:00:00 AM | 3 | 5985649.89934 | 2111597.68044 | 37.7772147235644 | -122.493199999111 | (37.7772147235644, -122.493199999111) | 11 | 6 | 2 | 55 | 26 | |||
| 10957 | 253622 | DPW Maintained 1 | Pittosporum spp :: Pittosporum spp 170 | 300x Naglee Ave | Unaccepted Street : Yard | Tree | Private 2 | ||||||||||||||||
| 11017 | 88581 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 515 21st Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51523 | 5989364.70117 | 2111797.63767 | 37.777980320812 | -122.480364100125 | (37.777980320812, -122.480364100125) | 11 | 6 | 2 | 55 | 26 | ||
| 11108 | 86883 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 550 Jersey St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 49808 | 6001589 | 2101474 | 37.750336931821 | -122.43733657342 | (37.750336931821, -122.43733657342) | 2 | 4 | 5 | 28862 | 22 | ||||
| 11282 | 258111 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1647 23rd Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 5989010.97347 | 2104127.32105 | 37.756899168939 | -122.481025994257 | (37.756899168939, -122.481025994257) | 1 | 8 | 3 | 56 | 35 | ||||||
| 11448 | 96234 | Permitted Site 7 | Tree(s) :: 17 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 04/15/2011 12:00:00 AM | Permit Number 767856 | |||||||||||||||
| 11533 | 259758 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1547 Innes Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/13/2018 12:00:00 AM | 3 | 6015798.86195 | 2096987.35115 | 37.7388150947049 | -122.387884430038 | (37.7388150947049, -122.387884430038) | 10 | 3 | 8 | 58 | 1 | |||
| 11572 | 96179 | Permitted Site 7 | Prunus domestica 'Santa Rosa' :: Santa Rosa Plum 158 | Unaccepted Street : Cutout | Tree | Private 2 | 3x3 | Permit Number 767811 | |||||||||||||||
| 11682 | 89044 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 44 Surrey St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51783 | 6002618 | 2096049 | 37.7354995892493 | -122.433390603486 | (37.7354995892493, -122.433390603486) | 2 | 7 | 5 | 63 | 7 | ||||
| 11689 | 260606 | DPW Maintained 1 | Tree(s) :: 17 | 1038 Ingerson Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6013981.83254 | 2090017.73229 | 37.7195771072229 | -122.393679232644 | (37.7195771072229, -122.393679232644) | 10 | 3 | 8 | 58 | 1 | |||
| 11701 | 87286 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1272 42nd Ave | Sidewalk: Property side : Yard | Tree | Private 2 | 03/18/2007 12:00:00 AM | Permit Number 50303 | 5983096.8 | 2106514.6 | 37.7631083916796 | -122.501655692289 | (37.7631083916796, -122.501655692289) | 1 | 8 | 3 | 56 | 35 | ||||
| 11835 | 259749 | DPW Maintained 1 | Tilia tomentosa :: Silver Linden 217 | 1611 La Salle Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/13/2018 12:00:00 AM | 3 | 6015459.97414 | 2096191.98269 | 37.7366123953782 | -122.389000639089 | (37.7366123953782, -122.389000639089) | 10 | 3 | 8 | 58 | 1 | |||
| 11972 | 99201 | DPW Maintained 1 | Tree(s) :: 17 | 4016 26th St | Sidewalk: Curb side : Cutout | Landscaping | DPW 1 | FUF | 04/12/2012 12:00:00 AM | 6x10.5 | Permit Number 768835 | 6003752.7 | 2100736.7 | 37.7484352450997 | -122.429801769855 | (37.7484352450997, -122.429801769855) | 2 | 4 | 5 | 28862 | 22 | ||
| 12037 | 260602 | DPW Maintained 1 | Tree(s) :: 17 | 1152 Ingerson Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6013444.93607 | 2090417.98033 | 37.7206462592683 | -122.395563129546 | (37.7206462592683, -122.395563129546) | 10 | 3 | 8 | 58 | 1 | |||
| 12063 | 95300 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 701 Golden Gate Ave | Front Yard : Yard | Tree | Private 2 | 02/08/2011 12:00:00 AM | 3x3 | Permit Number 767203 | 6006127.5 | 2112421.2 | 37.780652317617 | -122.422419858646 | (37.780652317617, -122.422419858646) | 7 | 9 | 11 | 28852 | 41 | |||
| 12231 | 96231 | Permitted Site 7 | Tree(s) :: 17 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | |||||||||||||||||
| 12237 | 88560 | Permitted Site 7 | Prunus spp :: Cherry 68 | 2901 Pierce St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2008 12:00:00 AM | 3x3 | Permit Number 51505 | 6001501 | 2118350 | 37.7966692015857 | -122.438850093229 | (37.7966692015857, -122.438850093229) | 13 | 9 | 1 | 57 | 17 | |||
| 12244 | 261985 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 1500x Bancroft Ave | Front Yard : Yard | Tree | Private 2 | 6014696 | 2091834 | 37.7246038778524 | -122.391337493735 | (37.7246038778524, -122.391337493735) | 10 | 3 | 8 | 58 | 1 | ||||||
| 12300 | 93053 | Permitted Site 7 | Pinus Spp :: Pine Spp 100 | Front Yard : Yard | Tree | Private 2 | 04/28/2010 12:00:00 AM | 36 | Permit Number 53387 | ||||||||||||||
| 12345 | 107864 | Permitted Site 7 | Tree(s) :: 17 | 362 BRANNAN ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014441.4 | 2112297.4 | 37.7807778793576 | -122.393649202889 | (37.7807778793576, -122.393649202889) | 6 | 2 | 9 | 28856 | 6 | |||||
| 12387 | 88728 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 68 Pontiac St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2008 12:00:00 AM | 3x3 | Permit Number 51663 | 6010467.8 | 2117974.1 | 37.7961431384766 | -122.407796278381 | (37.7961431384766, -122.407796278381) | 3 | 1 | 10 | 308 | 4 | |||
| 12615 | 87685 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 118 Virginia Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/23/2008 12:00:00 AM | 4x4 | Permit Number 776560 | 6006594.8 | 2098480.6 | 37.7424010366351 | -122.419813761733 | (37.7424010366351, -122.419813761733) | 2 | 7 | 7 | 28859 | 2 | |||
| 12682 | 260425 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 508 Dwight St | Unaccepted Street : Yard | Tree | DPW 1 | FUF | 08/17/2019 12:00:00 AM | 3 | 6010099.90949 | 2091269.80828 | 37.7227985719868 | -122.407185909529 | (37.7227985719868, -122.407185909529) | 10 | 3 | 7 | 309 | 28 | |||
| 12888 | 260885 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 639 32nd Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5985963.68769 | 2111543.65127 | 37.7770847226637 | -122.49211054124 | (37.7770847226637, -122.49211054124) | 11 | 6 | 2 | 55 | 26 | |||
| 12976 | 260626 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1546 Van Dyke Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6014701.33267 | 2093312.36998 | 37.7286634818435 | -122.391422361758 | (37.7286634818435, -122.391422361758) | 10 | 3 | 8 | 58 | 1 | |||
| 13046 | 112126 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 8245 Geary Blvd | Sidewalk: Curb side : Cutout | Tree | Private 2 | 55 | 3x3 | 5981385.27932 | 2112314.25515 | 37.7789318748139 | -122.508005614464 | (37.7789318748139, -122.508005614464) | 11 | 6 | 2 | 55 | 26 | ||||
| 13082 | 96572 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.7310370666678 | -122.483566221845 | (37.7310370666678, -122.483566221845) | 1 | 8 | 4 | 64 | 14 | ||||
| 13104 | 88055 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 52 Robblee Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/24/2008 12:00:00 AM | 3x3 | Permit Number 51065 | 6012498 | 2095923.9 | 37.7357116661186 | -122.399222709682 | (37.7357116661186, -122.399222709682) | 10 | 3 | 8 | 58 | 1 | |||
| 13212 | 87784 | Permitted Site 7 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 48 Santa Ysabel Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50524 | 6000929.5 | 2093152.6 | 37.7274508049284 | -122.439020861215 | (37.7274508049284, -122.439020861215) | 9 | 7 | 6 | 28861 | 25 | |||
| 13376 | 29902 | DPW Maintained 1 | Tree(s) :: 17 | 1716 Divisadero St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6001149.68281092 | 2114264.52722613 | 37.7854315611698 | -122.439772670022 | (37.7854315611698, -122.439772670022) | 15 | 6 | 1 | 29490 | 27 | ||||||
| 13614 | 258670 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 152 Kensington Way | Front Yard : Yard | Tree | Private 2 | 3x3 | 5994743 | 2098651 | 37.7421941161526 | -122.460805774677 | (37.7421941161526, -122.460805774677) | 1 | 8 | 4 | 59 | 40 | |||||
| 13632 | 258133 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 2579 29th Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 3x5 | 5987367.52261 | 2097738.52962 | 37.7392615861063 | -122.486240585494 | (37.7392615861063, -122.486240585494) | 1 | 8 | 3 | 29491 | 35 | |||
| 13705 | 258131 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 290 Holyoke St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 3x5 | 6009566.32704 | 2093048.73199 | 37.7276532465172 | -122.409155864667 | (37.7276532465172, -122.409155864667) | 10 | 3 | 7 | 309 | 28 | |||
| 13863 | 108832 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 60 Ney St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774659 | 6003833.887 | 2093995.50335 | 37.7299300570357 | -122.429040457944 | (37.7299300570357, -122.429040457944) | 9 | 7 | 6 | 28861 | 5 | |
| 13988 | 106896 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 2958 SLOAT BLVD | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5981703.3 | 2096579.8 | 37.7357482722765 | -122.505738719186 | (37.7357482722765, -122.505738719186) | 1 | 8 | 3 | 29491 | 35 | ||||||
| 14084 | 258134 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 131 Woolsey St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 4x5 | 6011357.19142 | 2092082.52958 | 37.7251004206417 | -122.402896861649 | (37.7251004206417, -122.402896861649) | 10 | 3 | 7 | 309 | 28 | |||
| 14217 | 107031 | Undocumented 4 | Tree(s) :: 17 | 4022 19TH ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x4 | 6002868.3 | 2104782.6 | 37.7594942034983 | -122.433149044029 | (37.7594942034983, -122.433149044029) | 2 | 4 | 5 | 28862 | 3 | |||||
| 14247 | 256666 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1406 California St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782597 | |||||||||||
| 14367 | 86754 | Permitted Site 7 | Tree(s) :: 17 | 1376 06th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2007 12:00:00 AM | Permit Number 49715 | 5994310.3 | 2106169.4 | 37.7628128189867 | -122.462847225894 | (37.7628128189867, -122.462847225894) | 1 | 5 | 11 | 56 | 12 | ||||
| 14439 | 104509 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 80 DICHIERA CT | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | 5998620 | 2088043 | 37.7132893442667 | -122.446637305723 | (37.7132893442667, -122.446637305723) | 9 | 7 | 6 | 28861 | 25 | |||||
| 14442 | 260627 | DPW Maintained 1 | Tree(s) :: 17 | 1557 Hudson Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6015914.7542 | 2097249.1447 | 37.7395403460526 | -122.387501983912 | (37.7395403460526, -122.387501983912) | 10 | 3 | 8 | 58 | 1 | |||
| 14736 | 92056 | Significant Tree 6 | Quercus agrifolia :: Coast Live Oak 172 | 1001 Potrero Ave | Sidewalk: Property side : Yard | Tree | Private 2 | 06/16/2009 12:00:00 AM | Permit Number 52180 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | 10 | 4 | 8 | 28859 | 19 | ||||
| 14781 | 256563 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2504 Bush St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/24/2019 12:00:00 AM | 3 | 3x3 | 6001466 | 2114633 | 37.7864612926293 | -122.438704721697 | (37.7864612926293, -122.438704721697) | 13 | 6 | 1 | 29490 | 27 | |||
| 14870 | 87142 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 54 Homestead St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/2008 12:00:00 AM | 3x3 | Permit Number 50130 | 6000955 | 2101398 | 37.7500921913505 | -122.439523535984 | (37.7500921913505, -122.439523535984) | 2 | 4 | 5 | 28862 | 22 | |||
| 14943 | 260853 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 626 33rd Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5985689.47211 | 2111611.95975 | 37.7772562449138 | -122.493064158363 | (37.7772562449138, -122.493064158363) | 11 | 6 | 2 | 55 | 26 | |||
| 15100 | 86751 | Permitted Site 7 | Tree(s) :: 17 | 81 Parker Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2007 12:00:00 AM | Permit Number 49713 | 5996801.8 | 2114038.7 | 37.7845630578844 | -122.454798641129 | (37.7845630578844, -122.454798641129) | 11 | 6 | 1 | 54 | 31 | ||||
| 15168 | 259102 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 619 Visitacion Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | 6010517.89431 | 2086850.21293 | 37.7106866494876 | -122.405429914879 | (37.7106866494876, -122.405429914879) | 9 | 7 | 8 | 309 | 39 | |||
| 15172 | 260605 | DPW Maintained 1 | Tree(s) :: 17 | 1042 Ingerson Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6013961.37936 | 2090032.97981 | 37.719617837314 | -122.393750999085 | (37.719617837314, -122.393750999085) | 10 | 3 | 8 | 58 | 1 |
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) );