trees
194,517 rows sorted by TreeID
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 64071 | 100096 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 495 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6006848.2 | 2122207.6 | 37.8075639592102 | -122.42062152066 | (37.8075639592102, -122.42062152066) | 5 | 1 | 1 | 28858 | 32 | |||||
| 57950 | 100097 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 495 Jefferson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6006848.2 | 2122207.6 | 37.8075639592102 | -122.42062152066 | (37.8075639592102, -122.42062152066) | 5 | 1 | 1 | 28858 | 32 | |||||
| 81454 | 100098 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 495 Jefferson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6006848.2 | 2122207.6 | 37.8075639592102 | -122.42062152066 | (37.8075639592102, -122.42062152066) | 5 | 1 | 1 | 28858 | 32 | |||||
| 23589 | 100099 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 495 Jefferson St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6006848.2 | 2122207.6 | 37.8075639592102 | -122.42062152066 | (37.8075639592102, -122.42062152066) | 5 | 1 | 1 | 28858 | 32 | |||||
| 149997 | 1001 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 1731 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 27 | 3X3 | 6001471.07065 | 2092002.59485 | 37.724323951976 | -122.437066353202 | (37.724323951976, -122.437066353202) | 9 | 7 | 6 | 28861 | 25 | |||
| 162681 | 10010 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 174 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/16/2002 12:00:00 AM | 6 | 3x3 | 6005413.24282 | 2107997.40019 | 37.7684653181587 | -122.424576046874 | (37.7684653181587, -122.424576046874) | 8 | 4 | 5 | 28853 | 19 | ||
| 171998 | 100100 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 495 Jefferson St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6006848.2 | 2122207.6 | 37.8075639592102 | -122.42062152066 | (37.8075639592102, -122.42062152066) | 5 | 1 | 1 | 28858 | 32 | |||||
| 122906 | 100101 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 495 Jefferson St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6006848.2 | 2122207.6 | 37.8075639592102 | -122.42062152066 | (37.8075639592102, -122.42062152066) | 5 | 1 | 1 | 28858 | 32 | |||||
| 94746 | 100102 | Undocumented 4 | Ficus carica :: Edible Fig 341 | 495@ Beach Jefferson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6006848.2 | 2122207.6 | 37.8075639592102 | -122.42062152066 | (37.8075639592102, -122.42062152066) | 5 | 1 | 1 | 28858 | 32 | |||||
| 26574 | 100103 | Undocumented 4 | Pittosporum crassifolium :: Karo Tree 95 | 461 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007004.8 | 2122229.7 | 37.8076334645768 | -122.420081138169 | (37.8076334645768, -122.420081138169) | 5 | 1 | 1 | 308 | 32 | |||||
| 181687 | 100104 | Undocumented 4 | Pittosporum crassifolium :: Karo Tree 95 | 461 Jefferson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007004.8 | 2122229.7 | 37.8076334645768 | -122.420081138169 | (37.8076334645768, -122.420081138169) | 5 | 1 | 1 | 308 | 32 | |||||
| 145774 | 100105 | Undocumented 4 | Pittosporum crassifolium :: Karo Tree 95 | 461 Jefferson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007004.8 | 2122229.7 | 37.8076334645768 | -122.420081138169 | (37.8076334645768, -122.420081138169) | 5 | 1 | 1 | 308 | 32 | |||||
| 122731 | 100106 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 461 Jefferson St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007004.8 | 2122229.7 | 37.8076334645768 | -122.420081138169 | (37.8076334645768, -122.420081138169) | 5 | 1 | 1 | 308 | 32 | |||||
| 48222 | 100107 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 461 Jefferson St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007004.8 | 2122229.7 | 37.8076334645768 | -122.420081138169 | (37.8076334645768, -122.420081138169) | 5 | 1 | 1 | 308 | 32 | |||||
| 114077 | 100108 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 461 Jefferson St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007004.8 | 2122229.7 | 37.8076334645768 | -122.420081138169 | (37.8076334645768, -122.420081138169) | 5 | 1 | 1 | 308 | 32 | |||||
| 61684 | 100109 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 333 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007662 | 2121967 | 37.8069491634687 | -122.417788103441 | (37.8069491634687, -122.417788103441) | 5 | 1 | 10 | 308 | 23 | |||||
| 108815 | 10011 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 198 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 2X3 | 6005417.15338 | 2107897.14895 | 37.7681902730979 | -122.424555388522 | (37.7681902730979, -122.424555388522) | 8 | 4 | 5 | 28853 | 19 | |||
| 67964 | 100110 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 333 Jefferson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007662 | 2121967 | 37.8069491634687 | -122.417788103441 | (37.8069491634687, -122.417788103441) | 5 | 1 | 10 | 308 | 23 | |||||
| 81579 | 100111 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 333 Jefferson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007662 | 2121967 | 37.8069491634687 | -122.417788103441 | (37.8069491634687, -122.417788103441) | 5 | 1 | 10 | 308 | 23 | |||||
| 97575 | 100112 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 333 Jefferson St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007662 | 2121967 | 37.8069491634687 | -122.417788103441 | (37.8069491634687, -122.417788103441) | 5 | 1 | 10 | 308 | 23 | |||||
| 67021 | 100113 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 333 Jefferson St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007662 | 2121967 | 37.8069491634687 | -122.417788103441 | (37.8069491634687, -122.417788103441) | 5 | 1 | 10 | 308 | 23 | |||||
| 51202 | 100114 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 333 Jefferson St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007662 | 2121967 | 37.8069491634687 | -122.417788103441 | (37.8069491634687, -122.417788103441) | 5 | 1 | 10 | 308 | 23 | |||||
| 135501 | 100115 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 333 Jefferson St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007662 | 2121967 | 37.8069491634687 | -122.417788103441 | (37.8069491634687, -122.417788103441) | 5 | 1 | 10 | 308 | 23 | |||||
| 149669 | 100116 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 333 Jefferson St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007662 | 2121967 | 37.8069491634687 | -122.417788103441 | (37.8069491634687, -122.417788103441) | 5 | 1 | 10 | 308 | 23 | |||||
| 93715 | 100117 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 333 Jefferson St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007662 | 2121967 | 37.8069491634687 | -122.417788103441 | (37.8069491634687, -122.417788103441) | 5 | 1 | 10 | 308 | 23 | |||||
| 181201 | 100118 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 333 Jefferson St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007662 | 2121967 | 37.8069491634687 | -122.417788103441 | (37.8069491634687, -122.417788103441) | 5 | 1 | 10 | 308 | 23 | |||||
| 68742 | 100119 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 333 Jefferson St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007662 | 2121967 | 37.8069491634687 | -122.417788103441 | (37.8069491634687, -122.417788103441) | 5 | 1 | 10 | 308 | 23 | |||||
| 162104 | 100120 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 333 Jefferson St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6007662 | 2121967 | 37.8069491634687 | -122.417788103441 | (37.8069491634687, -122.417788103441) | 5 | 1 | 10 | 308 | 23 | |||||
| 3096 | 100121 | Significant Tree 6 | Myoporum laetum :: Myoporum 62 | 690 Miramar Ave | 1 | Front Yard : Yard | Tree | Private 2 | 5995444.4 | 2093941.6 | 37.7293035878447 | -122.458039824042 | (37.7293035878447, -122.458039824042) | 9 | 7 | 4 | 28861 | 40 | |||||
| 127087 | 100123 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 690 Miramar Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5995444.4 | 2093941.6 | 37.7293035878447 | -122.458039824042 | (37.7293035878447, -122.458039824042) | 9 | 7 | 4 | 28861 | 40 | |||||
| 21762 | 100124 | Significant Tree 6 | Radermachera sinica :: China Doll Tree 394 | 40@ San Ramon Eastwood Dr | 1 | Front Yard : Yard | Tree | Private 2 | 5995635 | 2092781 | 37.7261278087338 | -122.457296979484 | (37.7261278087338, -122.457296979484) | 9 | 7 | 4 | 28861 | 40 | |||||
| 154195 | 100125 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1800 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 6005967.88782 | 2116944.18436 | 37.7930623076392 | -122.423293649581 | (37.7930623076392, -122.423293649581) | 13 | 9 | 1 | 28858 | 27 | ||||
| 127780 | 100126 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1800 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 6005948.98718 | 2116940.10629 | 37.7930500435754 | -122.423358756926 | (37.7930500435754, -122.423358756926) | 13 | 9 | 1 | 28858 | 27 | ||||
| 56463 | 100127 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1800 Washington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 6005919.01328 | 2116937.33835 | 37.7930407517779 | -122.423462271584 | (37.7930407517779, -122.423462271584) | 13 | 9 | 1 | 28858 | 27 | ||||
| 82331 | 100128 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1800 Washington St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 6005897.30712 | 2116933.8296 | 37.7930298924771 | -122.423537126645 | (37.7930298924771, -122.423537126645) | 13 | 9 | 1 | 28858 | 27 | ||||
| 156977 | 100129 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 155 05th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769024 | 6011082.10119 | 2112775.22352 | 37.7819026320456 | -122.405304366814 | (37.7819026320456, -122.405304366814) | 12 | 2 | 9 | 28853 | 34 | |
| 100677 | 10013 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 215 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x2 | 6005495.275 | 2107715.11687 | 37.7676948680391 | -122.424272225299 | (37.7676948680391, -122.424272225299) | 8 | 4 | 5 | 28853 | 19 | |||
| 181095 | 100130 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 155 05th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769024 | 6011065.09249 | 2112790.58254 | 37.7819438533601 | -122.405364291326 | (37.7819438533601, -122.405364291326) | 12 | 2 | 9 | 28853 | 34 | |
| 143498 | 100131 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 155 05th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769024 | 6011051.59118 | 2112804.91213 | 37.7819824441767 | -122.405412009362 | (37.7819824441767, -122.405412009362) | 12 | 2 | 9 | 28853 | 34 | |
| 70912 | 100132 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 155 05th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769024 | 6011001.43438 | 2112862.15185 | 37.7821368065155 | -122.405589562524 | (37.7821368065155, -122.405589562524) | 12 | 2 | 9 | 28853 | 34 | |
| 109349 | 100133 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 155 05th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769024 | 6010986.38868 | 2112879.38733 | 37.7821832897709 | -122.405642828459 | (37.7821832897709, -122.405642828459) | 12 | 2 | 9 | 28853 | 34 | |
| 181514 | 100134 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 155 05th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769024 | 6010970.10593 | 2112898.88439 | 37.782235913593 | -122.405700533469 | (37.782235913593, -122.405700533469) | 12 | 2 | 9 | 28853 | 34 | |
| 107208 | 100135 | Undocumented 4 | Tree(s) :: 17 | 155 05th St | 1 | Front Yard : Yard | Tree | Private 2 | 11/27/2012 12:00:00 AM | 9 | Permit Number 769351 | 6011029.6 | 2112857.4 | 37.7821253339557 | -122.405491786923 | (37.7821253339557, -122.405491786923) | 12 | 2 | 9 | 28853 | 34 | ||
| 143275 | 100136 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 155 05th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769024 | 6010957.25903 | 2112913.83939 | 37.7822762580963 | -122.405746031954 | (37.7822762580963, -122.405746031954) | 12 | 2 | 9 | 28853 | 34 | |
| 97699 | 100137 | Undocumented 4 | Tree(s) :: 17 | 155 05th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 769024 | 6011029.6 | 2112857.4 | 37.7821253339557 | -122.405491786923 | (37.7821253339557, -122.405491786923) | 12 | 2 | 9 | 28853 | 34 | |||
| 39248 | 100138 | Undocumented 4 | Tree(s) :: 17 | 155 05th St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 769024 | 6011029.6 | 2112857.4 | 37.7821253339557 | -122.405491786923 | (37.7821253339557, -122.405491786923) | 12 | 2 | 9 | 28853 | 34 | |||
| 95526 | 100139 | Property Tree 8 | Tree(s) :: 17 | 155 05th St | 2 | Front Yard : Yard | Tree | Private 2 | Permit Number 769024 | 6011029.6 | 2112857.4 | 37.7821253339557 | -122.405491786923 | (37.7821253339557, -122.405491786923) | 12 | 2 | 9 | 28853 | 34 | ||||
| 5282 | 10014 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 224 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/11/2016 06:44:00 AM | 3 | 2x3 | 6005430.43675 | 2107671.80391 | 37.7675722796594 | -122.424493411759 | (37.7675722796594, -122.424493411759) | 8 | 4 | 5 | 28853 | 19 | ||
| 155249 | 100145 | Undocumented 4 | Liriodendron tulipifera :: Tulip Tree 145 | 222X Cumberland St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6004147.2 | 2104574.7 | 37.7589958235368 | -122.428711154895 | (37.7589958235368, -122.428711154895) | 2 | 4 | 5 | 28862 | 3 | |||||
| 76067 | 100146 | Undocumented 4 | Liriodendron tulipifera :: Tulip Tree 145 | 222X Cumberland St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6004147.2 | 2104574.7 | 37.7589958235368 | -122.428711154895 | (37.7589958235368, -122.428711154895) | 2 | 4 | 5 | 28862 | 3 | |||||
| 96465 | 100147 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 3955 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6003272 | 2105332 | 37.7610256161684 | -122.431792078279 | (37.7610256161684, -122.431792078279) | 2 | 4 | 5 | 28862 | 3 | |||
| 26011 | 100148 | Property Tree 8 | Tree(s) :: 17 | 209 Vicksburg St | Back Yard : Yard | Tree | Private 2 | 6004141 | 2102142 | 37.7523158521071 | -122.428559192815 | (37.7523158521071, -122.428559192815) | 2 | 4 | 5 | 28862 | 22 | ||||||
| 136685 | 100149 | Undocumented 4 | Tree(s) :: 17 | 3975 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6003144 | 2105325 | 37.7609991391758 | -122.432234274425 | (37.7609991391758, -122.432234274425) | 2 | 4 | 5 | 28862 | 3 | |||
| 10710 | 10015 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 232 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/02/2019 12:00:00 AM | 3 | 3x3 | 6005430.70254 | 2107623.59079 | 37.7674399129618 | -122.424489062615 | (37.7674399129618, -122.424489062615) | 8 | 4 | 5 | 28853 | 19 | ||
| 4072 | 100150 | Undocumented 4 | Pyrus calleryana :: Ornamental Pear 44 | 4007 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6002942 | 2105314 | 37.7609574805046 | -122.432932117926 | (37.7609574805046, -122.432932117926) | 2 | 4 | 5 | 28862 | 3 | |||
| 153574 | 100151 | Undocumented 4 | Magnolia spp :: Magnolia 224 | 4047 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 5x5 | Permit Number 776452 | 6002690 | 2105300 | 37.7609047432887 | -122.433802674054 | (37.7609047432887, -122.433802674054) | 2 | 4 | 5 | 28862 | 3 | ||
| 61720 | 100152 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 500X Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6002933.4 | 2105264.1 | 37.7608199793321 | -122.432958296422 | (37.7608199793321, -122.432958296422) | 2 | 4 | 5 | 28862 | 3 | |||
| 48746 | 100153 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 590 08th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Permit Number 780398 | 5993481.43699 | 2111479.23814 | 37.7773444498569 | -122.466099823613 | (37.7773444498569, -122.466099823613) | 11 | 6 | 2 | 54 | 11 | |||
| 41837 | 100154 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 421 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/2012 12:00:00 AM | 2 | 3x3 | Permit Number 768665 | 5995548.20979 | 2113421.38615 | 37.7827960924124 | -122.459090895565 | (37.7827960924124, -122.459090895565) | 11 | 6 | 2 | 54 | 11 | |
| 138493 | 100155 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 421 Arguello Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/2012 12:00:00 AM | 1 | 3x3 | Permit Number 768665 | 5995547.63901 | 2113410.08576 | 37.7827650317513 | -122.459092051698 | (37.7827650317513, -122.459092051698) | 11 | 6 | 2 | 54 | 11 | |
| 185437 | 100156 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 421 Arguello Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/2012 12:00:00 AM | 2 | 3x3 | Permit Number 768665 | 5995549.3318 | 2113386.41255 | 37.7827001287608 | -122.459084480701 | (37.7827001287608, -122.459084480701) | 11 | 6 | 2 | 54 | 11 | |
| 138742 | 100157 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 14 Broderick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6001430.1 | 2108737.2 | 37.7702708737839 | -122.438406367889 | (37.7702708737839, -122.438406367889) | 15 | 5 | 11 | 29492 | 9 | |||||
| 34119 | 100158 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 14 Broderick St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/2012 12:00:00 AM | Permit Number 769008 | 6001430.1 | 2108737.2 | 37.7702708737839 | -122.438406367889 | (37.7702708737839, -122.438406367889) | 15 | 5 | 11 | 29492 | 9 | |||
| 11894 | 10016 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 236 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/11/2016 06:59:00 AM | 3 | 3x3 | 6005434.04749 | 2107587.52272 | 37.7673410675527 | -122.42447492707 | (37.7673410675527, -122.42447492707) | 8 | 4 | 5 | 28853 | 19 | ||
| 94130 | 100160 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1699 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Permit Number 28164 | 6005505.58523 | 2118187.22554 | 37.7964492830571 | -122.424981725648 | (37.7964492830571, -122.424981725648) | 13 | 9 | 1 | 28858 | 27 | |||
| 38359 | 100161 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1699 Vallejo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Permit Number 28164 | 6005519.03005 | 2118189.86695 | 37.7964572951359 | -122.424935391656 | (37.7964572951359, -122.424935391656) | 13 | 9 | 1 | 28858 | 27 | |||
| 115639 | 100162 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1699 Vallejo St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Permit Number 28164 | 6005532.34096 | 2118193.08724 | 37.7964668890905 | -122.424889562218 | (37.7964668890905, -122.424889562218) | 13 | 9 | 1 | 28858 | 27 | |||
| 87452 | 100163 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1814 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 6004278.90656 | 2118759.95598 | 37.7979524872736 | -122.429267157958 | (37.7979524872736, -122.429267157958) | 13 | 9 | 1 | 57 | 17 | ||||
| 68208 | 100164 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 839 Leavenworth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6008231.9319 | 2115379.46118 | 37.7888934760005 | -122.41534908182 | (37.7888934760005, -122.41534908182) | 13 | 1 | 10 | 28858 | 21 | |||
| 99569 | 100165 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 839 Leavenworth St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6008234.89338 | 2115366.55149 | 37.7888581955857 | -122.415337921201 | (37.7888581955857, -122.415337921201) | 13 | 1 | 10 | 28858 | 21 | |||
| 1694 | 100166 | Property Tree 8 | Salix spp :: Willow 203 | 2340 Twin Peaks Blvd | Front Yard : Yard | Tree | Private 2 | Permit Number 769026 | |||||||||||||||
| 159845 | 100167 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 710 El Camino Del Mar | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5986405.6 | 2114870 | 37.7862437457696 | -122.490826667671 | (37.7862437457696, -122.490826667671) | 11 | 6 | 1 | 55 | 33 | |||||
| 171432 | 100168 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 710 El Camino Del Mar | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5986405.6 | 2114870 | 37.7862437457696 | -122.490826667671 | (37.7862437457696, -122.490826667671) | 11 | 6 | 1 | 55 | 33 | |||||
| 164886 | 100169 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 180X Manchester St | Back Yard : Yard | Tree | DPW 1 | Adjacent to rear of property - DPW parcel | 6008242 | 2099158 | 37.7443536844995 | -122.414166136282 | (37.7443536844995, -122.414166136282) | 2 | 7 | 7 | 28859 | 2 | |||||
| 166798 | 10017 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 240 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/24/2012 12:00:00 AM | 1 | 3x3 | 6005435.61743 | 2107572.1515 | 37.7672989505107 | -122.424468403392 | (37.7672989505107, -122.424468403392) | 8 | 4 | 5 | 28853 | 19 | ||
| 171295 | 100170 | DPW Maintained 1 | Tree(s) :: 17 | 2149 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769012 | 5997531 | 2110183 | 37.7740181145799 | -122.451997596236 | (37.7740181145799, -122.451997596236) | 15 | 5 | 11 | 29492 | 16 | |
| 139403 | 100171 | Significant Tree 6 | Quercus suber :: Cork Oak 78 | 109 Edgewood Ave | 1 | Front Yard : Yard | Tree | Private 2 | 5996563.8 | 2106359.1 | 37.763463224844 | -122.455066914463 | (37.763463224844, -122.455066914463) | 15 | 5 | 11 | 29492 | 12 | |||||
| 133313 | 100174 | Undocumented 4 | Tree(s) :: 17 | 50 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2012 12:00:00 AM | 18 | 3x3 | Permit Number 769094 | 6010932.2 | 2114627.3 | 37.7869796149513 | -122.405953468587 | (37.7869796149513, -122.405953468587) | 5 | 10 | 10 | 28857 | 6 | |
| 148324 | 100175 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1140 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2012 12:00:00 AM | 3x3 | Permit Number 768230 | 6001099 | 2109378.2 | 37.772012061027 | -122.439597598173 | (37.772012061027, -122.439597598173) | 15 | 5 | 11 | 29492 | 9 | ||
| 17896 | 100177 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 252 States St | 3 | Front Yard : Yard | Tree | Private 2 | Permit Number 768965 | 6000636 | 2106677.4 | 37.7645699751489 | -122.44100535545 | (37.7645699751489, -122.44100535545) | 15 | 5 | 5 | 28862 | 3 | ||||
| 101769 | 100178 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1270 Sanchez St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/06/2012 12:00:00 AM | 3x3 | 6003851 | 2100874 | 37.7488178049495 | -122.42947164058 | (37.7488178049495, -122.42947164058) | 2 | 4 | 5 | 28862 | 22 | |||
| 84934 | 100179 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1270 Sanchez St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/06/2012 12:00:00 AM | 3x3 | 6003851 | 2100874 | 37.7488178049495 | -122.42947164058 | (37.7488178049495, -122.42947164058) | 2 | 4 | 5 | 28862 | 22 | |||
| 159785 | 10018 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 205 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/28/1993 12:00:00 AM | 6 | 3x3 | 6005510.9123943 | 2107567.8958458 | 37.7672915172207 | -122.424207665862 | (37.7672915172207, -122.424207665862) | 8 | 4 | 5 | 28853 | 19 | ||
| 77968 | 100180 | Undocumented 4 | Liquidambar styraciflua :: American Sweet Gum 37 | 100x BELVEDERE ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997991 | 2108152 | 37.7684678470263 | -122.450259955793 | (37.7684678470263, -122.450259955793) | 15 | 5 | 11 | 29492 | 9 | ||||
| 100479 | 100181 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 230 Ritch St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 6013794.16577 | 2112184.81721 | 37.7804327665865 | -122.39588042504 | (37.7804327665865, -122.39588042504) | 6 | 2 | 9 | 28856 | 34 | ||||
| 2882 | 100182 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 230 Ritch St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 6013808.29227 | 2112170.33848 | 37.7803937971776 | -122.39583053966 | (37.7803937971776, -122.39583053966) | 6 | 2 | 9 | 28856 | 34 | ||||
| 38085 | 100183 | Permitted Site 7 | Tree(s) :: 17 | 956 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003075.2 | 2102641.9 | 37.7536280862965 | -122.432280596021 | (37.7536280862965, -122.432280596021) | 2 | 4 | 5 | 28862 | 22 | ||||
| 126592 | 100184 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 480 Oxford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 6006818.05082 | 2091764.69226 | 37.7239732025834 | -122.418565697766 | (37.7239732025834, -122.418565697766) | 9 | 7 | 7 | 309 | 28 | |||
| 137124 | 100186 | DPW Maintained 1 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 | 2445 HARRISON ST | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 3x3 | 6008897 | 2104213 | 37.7582703522428 | -122.41225848425 | (37.7582703522428, -122.41225848425) | 2 | 4 | 7 | 28859 | 19 | |||
| 111037 | 100187 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 217 Montcalm St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2012 12:00:00 AM | 3x3 | Permit Number 768935 | 6009833.3 | 2099565.6 | 37.7455621186719 | -122.408692480229 | (37.7455621186719, -122.408692480229) | 2 | 7 | 7 | 28859 | 2 | ||
| 168610 | 100188 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 217 Montcalm St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2012 12:00:00 AM | 3x3 | Permit Number 768935 | 6009833.3 | 2099565.6 | 37.7455621186719 | -122.408692480229 | (37.7455621186719, -122.408692480229) | 2 | 7 | 7 | 28859 | 2 | ||
| 84320 | 100189 | DPW Maintained 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 248 | 160 Palm Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | Permit Number 772698 | 5995944.7835 | 2113256.71049 | 37.7823667267913 | -122.457707006716 | (37.7823667267913, -122.457707006716) | 11 | 6 | 1 | 54 | 31 | ||
| 28194 | 10019 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 205 Guerrero St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6005510.9123943 | 2107567.8958458 | 37.7672915172207 | -122.424207665862 | (37.7672915172207, -122.424207665862) | 8 | 4 | 5 | 28853 | 19 | |||
| 34066 | 100190 | Undocumented 4 | Tree(s) :: 17 | 404 Noriega St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 01/07/2016 12:00:00 AM | Permit Number 776979 | 5992802 | 2103239 | 37.754679716601 | -122.467850713731 | (37.754679716601, -122.467850713731) | 1 | 8 | 4 | 56 | 12 | |||
| 58651 | 100191 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1201 Holloway Ave | 1 | Front Yard : Yard | Tree | Private 2 | 5992431.5 | 2091178.1 | 37.7215421255294 | -122.468254640211 | (37.7215421255294, -122.468254640211) | 9 | 8 | 6 | 64 | 24 | |||||
| 75465 | 100192 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 62 Nordhoff St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x6 | 6000448 | 2095531 | 37.7339539318334 | -122.440855946438 | (37.7339539318334, -122.440855946438) | 9 | 7 | 5 | 63 | 40 | ||||
| 28871 | 100193 | Significant Tree 6 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 | 361 Dellbrook Ave | 1 | Front Yard : Yard | Tree | Private 2 | 5997322.2 | 2102403.9 | 37.7526467193673 | -122.45215846969 | (37.7526467193673, -122.45215846969) | 1 | 5 | 4 | 63 | 38 | |||||
| 17949 | 100194 | Significant Tree 6 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 | 361 Dellbrook Ave | 2 | Front Yard : Yard | Tree | Private 2 | 5997322.2 | 2102403.9 | 37.7526467193673 | -122.45215846969 | (37.7526467193673, -122.45215846969) | 1 | 5 | 4 | 63 | 38 | |||||
| 80551 | 100195 | Significant Tree 6 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 | 361 Dellbrook Ave | 3 | Front Yard : Yard | Tree | Private 2 | 5997322.2 | 2102403.9 | 37.7526467193673 | -122.45215846969 | (37.7526467193673, -122.45215846969) | 1 | 5 | 4 | 63 | 38 | |||||
| 102142 | 100197 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 81 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2012 12:00:00 AM | 21 | Permit Number 769099 | 5994240.47669 | 2115083.18474 | 37.7872836759267 | -122.463735720083 | (37.7872836759267, -122.463735720083) | 11 | 6 | 1 | 54 | 11 |
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) );