trees
1,732 rows where qLegalStatus_id = 6 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 170620 | 101979 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 25X Tiffany Ave | 2 | Front Yard : Yard | Tree | Private 2 | 6006415.7 | 2099833.4 | 37.7461054290546 | -122.420529042399 | (37.7461054290546, -122.420529042399) | 2 | 7 | 7 | 28859 | 2 | |||||
| 170538 | 88146 | Significant Tree 6 | Tree(s) :: 17 | 1475 Fillmore St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2000 12:00:00 AM | 3x3 | Permit Number 51176 | 6003147.8 | 2113351.1 | 37.7830370509294 | -122.43279450975 | (37.7830370509294, -122.43279450975) | 15 | 9 | 11 | 29490 | 41 | ||
| 170533 | 115941 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 3401x 17TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 3x3 | 6006069 | 2106010 | 37.7630453994978 | -122.422166625338 | (37.7630453994978, -122.422166625338) | 8 | 4 | 5 | 28859 | 19 | ||||
| 170444 | 116097 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 300x EXECUTIVE PARK BLVD | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014482 | 2086919 | 37.7110963749119 | -122.391733773238 | (37.7110963749119, -122.391733773238) | 10 | 3 | 8 | 309 | 1 | ||||
| 170438 | 96480 | 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 = Tree not requiring permit; tree meets 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 | ||||
| 170160 | 107835 | Significant Tree 6 | Salix babylonica :: Weeping Willow 308 | 100X SUSSEX ST | 1 | Front Yard : Yard | Tree | Private 2 | 13 | 6002188 | 2096682 | 37.7372132564844 | -122.434922529204 | (37.7372132564844, -122.434922529204) | 2 | 7 | 5 | 63 | 7 | ||||
| 169778 | 255656 | Significant Tree 6 | Tree(s) :: 17 | 5827 Diamond Heights Blvd | 1 | Front Yard : Yard | Tree | Private 2 | 12/28/2018 12:00:00 AM | 3 | 12x12 | Permit Number 781981 | 6000844 | 2096795 | 37.7374471263095 | -122.439577439508 | (37.7374471263095, -122.439577439508) | 2 | 7 | 5 | 63 | 7 | |
| 169643 | 251606 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 52R Amber Dr | 1 | Back Yard : Yard | Tree | Private 2 | 5999455 | 2100046 | 37.7462944425817 | -122.444613441074 | (37.7462944425817, -122.444613441074) | 2 | 7 | 5 | 63 | 22 | |||||
| 169388 | 104432 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 52 | 1601X PORTOLA DR | 1 | Front Yard : Yard | Tree | Private 2 | 14 | 5991823 | 2096240 | 37.7354056792703 | -122.47072655808 | (37.7354056792703, -122.47072655808) | 1 | 8 | 4 | 59 | 40 | ||||
| 169126 | 115697 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 1425x LAGUNA ST | 1 | Front Yard : Yard | Tree | Private 2 | 25 | 6004559 | 2113815 | 37.7843907406582 | -122.4279454018 | (37.7843907406582, -122.4279454018) | 13 | 9 | 11 | 29490 | 41 | ||||
| 168909 | 112367 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 2770 Broadway | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 07/23/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774944 | 6000432.43478 | 2117179.73451 | 37.7933951089516 | -122.442463497617 | (37.7933951089516, -122.442463497617) | 13 | 9 | 1 | 57 | 27 | |
| 168619 | 255596 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 20x Starr King Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005969 | 2114025 | 37.7850470161942 | -122.423082215486 | (37.7850470161942, -122.423082215486) | 13 | 9 | 11 | 28858 | 41 | ||||
| 168489 | 254935 | Significant Tree 6 | Cedrus atlantica Glauca :: Blue Atlas Cedar 208 | 755 Ocean Ave | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x6 | Permit Number 779678 | 5998003.33154 | 2091542.89024 | 37.7228639895457 | -122.449020681299 | (37.7228639895457, -122.449020681299) | 9 | 7 | 4 | 28861 | 24 | |||
| 168413 | 106611 | Significant Tree 6 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1154 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4x4 | 6011908.79849 | 2103025.72201 | 37.7551788898075 | -122.401758852609 | (37.7551788898075, -122.401758852609) | 10 | 3 | 8 | 28856 | 29 | |||
| 168382 | 255283 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 320 Magellan Ave | 4 | Front Yard : Yard | Tree | Private 2 | 05/01/2018 12:00:00 AM | 3 | 10x20 | Permit Number 781012 | 5994287.14264 | 2099988.88368 | 37.7458413694018 | -122.462478996433 | (37.7458413694018, -122.462478996433) | 1 | 8 | 4 | 29491 | 40 | |
| 168357 | 104148 | Significant Tree 6 | Tree(s) :: 17 | 1710-1738 Diamond St | 2 | Front Yard : Yard | Tree | Private 2 | Permit Number 768304 | 6001979.7 | 2099047.6 | 37.7436968136687 | -122.435811922611 | (37.7436968136687, -122.435811922611) | 2 | 7 | 5 | 63 | 22 | ||||
| 168346 | 251480 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 51 Peralta Ave | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6010641 | 2100362 | 37.7477940646116 | -122.405955656592 | (37.7477940646116, -122.405955656592) | 2 | 7 | 7 | 28859 | 2 | ||||
| 168323 | 99734 | Significant Tree 6 | Pyrus calleryana :: Ornamental Pear 44 | 145 Irving St | 2 | Front Yard : Yard | Tree | Private 2 | 08/21/2012 12:00:00 AM | Permit Number 768746 | 5995340.8 | 2106458.8 | 37.76366673695 | -122.45930407086 | (37.76366673695, -122.45930407086) | 15 | 5 | 11 | 56 | 12 | |||
| 168009 | 254385 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 178X Warren Dr | 1 | Side Yard : Yard | Tree | Private 2 | 3x3 | 5995100 | 2102878 | 37.7538209308694 | -122.459877514706 | (37.7538209308694, -122.459877514706) | 1 | 5 | 4 | 63 | 12 | ||||
| 167870 | 251608 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 56R Amber Dr | 1 | Back Yard : Yard | Tree | Private 2 | 5999423 | 2100048 | 37.7462981080439 | -122.44472423658 | (37.7462981080439, -122.44472423658) | 2 | 7 | 5 | 63 | 22 | |||||
| 167818 | 99950 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1545 05th Ave | 1 | Front Yard : Yard | Tree | Private 2 | 08/14/2012 12:00:00 AM | Permit Number 768941 | 5994712.1 | 2105033.7 | 37.7597176147703 | -122.461375215787 | (37.7597176147703, -122.461375215787) | 1 | 5 | 4 | 56 | 12 | |||
| 167754 | 107159 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 1000 ESMERALDA AVE | Front Yard : Yard | Tree | Private 2 | 6009839 | 2098688 | 37.7431527400861 | -122.408610872619 | (37.7431527400861, -122.408610872619) | 10 | 7 | 7 | 28859 | 2 | ||||||
| 167525 | 258528 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 50 Hermann St | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6005031 | 2108842 | 37.7707627914543 | -122.425958322168 | (37.7707627914543, -122.425958322168) | 7 | 9 | 5 | 28852 | 10 | |||||
| 167489 | 104452 | Significant Tree 6 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1045 Mission St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 2x6 | Permit Number 770594 | 6009749.9 | 2112056.4 | 37.7798543407434 | -122.409862429103 | (37.7798543407434, -122.409862429103) | 14 | 2 | 9 | 28853 | 34 | |||
| 167444 | 105083 | Significant Tree 6 | :: 45 | 344 Fulton St | 3 | Front Yard : Yard | Tree | Private 2 | 6006101.8 | 2111789.5 | 37.7789163735632 | -122.422463868572 | (37.7789163735632, -122.422463868572) | 7 | 9 | 11 | 28852 | 10 | |||||
| 167295 | 223958 | Significant Tree 6 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 98 Seward St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 3ft | 6000714.90104 | 2104629.88079 | 37.7589524846915 | -122.440585589054 | (37.7589524846915, -122.440585589054) | 2 | 4 | 5 | 28862 | 38 | |||
| 167115 | 112487 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 52 | 1275 Columbus Ave | 7 | Front Yard : Yard | Tree | Private 2 | 6007539.6 | 2121483.9 | 37.8056158049656 | -122.418177422209 | (37.8056158049656, -122.418177422209) | 5 | 1 | 1 | 308 | 32 | |||||
| 166995 | 115091 | Significant Tree 6 | Tree(s) :: 17 | 121 Topaz Way | 2 | Front Yard : Yard | Tree | Private 2 | 01/11/2016 12:00:00 AM | Permit Number 776934 | 6001846.4 | 2098050 | 37.7409500647868 | -122.436201464472 | (37.7409500647868, -122.436201464472) | 2 | 7 | 5 | 63 | 7 | |||
| 166922 | 103307 | Significant Tree 6 | Pyrus spp :: Pear Tree 281 | 1467 Willard St | 1 | Front Yard : Yard | Tree | Private 2 | 04/02/2013 12:00:00 AM | 5 | 6x6 | Permit Number 768689 | 5996817.5 | 2106175 | 37.7629722844649 | -122.454176154627 | (37.7629722844649, -122.454176154627) | 15 | 5 | 11 | 29492 | 12 | |
| 166780 | 173951 | Significant Tree 6 | Tree(s) :: 17 | 2646 Union St | 1 | Front Yard : Cutout | Tree | Private 2 | 04/11/2017 12:00:00 AM | 3 | 10x10 | Permit Number 779549 | 6000338 | 2118225 | 37.7962597494046 | -122.442865342513 | (37.7962597494046, -122.442865342513) | 13 | 9 | 1 | 57 | 17 | |
| 166722 | 112928 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 2X Noe St | Sidewalk: Property side : Yard | Tree | Private 2 | 08/27/2015 12:00:00 AM | 3x3 | Permit Number 775129 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.433490232023 | (37.7683199626551, -122.433490232023) | 15 | 5 | 5 | 28862 | 3 | |||
| 166311 | 127110 | Significant Tree 6 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 3201 Laguna St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | Width 6ft | 6003718.35126 | 2119752.0994 | 37.8006449063974 | -122.431277695812 | (37.8006449063974, -122.431277695812) | 13 | 9 | 1 | 57 | 17 | |||
| 166166 | 120598 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 499x Ocean Ave | 6 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 5998874 | 2091543 | 37.7229140478676 | -122.446010982458 | (37.7229140478676, -122.446010982458) | 9 | 7 | 6 | 28861 | 25 | ||||
| 166073 | 112419 | Significant Tree 6 | Picea Spp :: Spruce Spp 200 | 268 Lily St | 1 | Back Yard : Yard | Tree | Private 2 | 07/29/2015 12:00:00 AM | 3 | 6005334.87738 | 2110100.0463 | 37.7742342515583 | -122.424996726643 | (37.7742342515583, -122.424996726643) | 7 | 9 | 11 | 28852 | 10 | |||
| 165618 | 105227 | Significant Tree 6 | Tree(s) :: 17 | 1150X Golden Gate Ave | 2 | Front Yard : Yard | Tree | Private 2 | 01/02/2014 12:00:00 AM | Permit Number 771276 | 6004329.61165 | 2112216.22051 | 37.7799879097685 | -122.428625001082 | (37.7799879097685, -122.428625001082) | 7 | 9 | 11 | 29490 | 41 | |||
| 165425 | 96275 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 84 | 55@ Alemany Trumbull St | 3 | Back Yard : Yard | Tree | Private 2 | 3 | 6003967.55773 | 2094330.40491 | 37.73085718729 | -122.428602205549 | (37.73085718729, -122.428602205549) | 9 | 7 | 6 | 28861 | 5 | ||||
| 165386 | 112772 | Significant Tree 6 | Myoporum laetum :: Myoporum 62 | 1X HOWTH ST | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5998027 | 2091524 | 37.7228134749722 | -122.448937504689 | (37.7228134749722, -122.448937504689) | 9 | 7 | 4 | 28861 | 24 | ||||
| 165218 | 114145 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 150 | 1200x JUNIPERO SERRA BLVD | 2 | Front Yard : Yard | Tree | Private 2 | 6 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | ||||
| 165161 | 98288 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 300 Mangels Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 01/24/2012 12:00:00 AM | Permit Number 768637 | 5999381.8 | 2095276.6 | 37.7331946288913 | -122.444523835506 | (37.7331946288913, -122.444523835506) | 9 | 7 | 4 | 59 | 40 | |||
| 165013 | 85367 | Significant Tree 6 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1990 09th Ave | 1 | Front Yard : Cutout | Tree | Private 2 | 08/17/2007 12:00:00 AM | Permit Number 49643 | 5993523.3 | 2101996.8 | 37.7513105791605 | -122.465266058842 | (37.7513105791605, -122.465266058842) | 1 | 8 | 4 | 29491 | 12 | |||
| 164851 | 103422 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 1365 Portola Dr | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 769779 | 5993416.2 | 2097683.7 | 37.7394617231066 | -122.465323151466 | (37.7394617231066, -122.465323151466) | 1 | 8 | 4 | 59 | 40 | ||||
| 164727 | 99894 | Significant Tree 6 | Ulmus pumila :: Siberian Elm 99 | 1636 Bush St | 1 | Front Yard : Yard | Tree | Private 2 | 07/11/2012 12:00:00 AM | Permit Number 768849 | 6005665 | 2115204 | 37.7882670981083 | -122.424217840789 | (37.7882670981083, -122.424217840789) | 13 | 9 | 1 | 28858 | 41 | |||
| 164452 | 117027 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 109 | 731 CLAYTON ST | 1 | Front Yard : Cutout | Tree | Private 2 | 5998515 | 2108057 | 37.7682369747157 | -122.448440651351 | (37.7682369747157, -122.448440651351) | 15 | 5 | 11 | 29492 | 9 | |||||
| 164393 | 120551 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1485 Fairfax Ave | 1 | Front Yard : Yard | Tree | Private 2 | 6016296 | 2097688 | 37.7407664622153 | -122.386214376382 | (37.7407664622153, -122.386214376382) | 10 | 3 | 8 | 58 | 1 | |||||
| 164291 | 253651 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 131 Font Blvd | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5990844 | 2088883 | 37.7151485301311 | -122.473574812248 | (37.7151485301311, -122.473574812248) | 1 | 8 | 4 | 64 | 14 | ||||
| 163996 | 258199 | Significant Tree 6 | Populus spp :: Poplar Spp 262 | 598X Alemany Blvd | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6006099.613365 | 2094764.868461 | 37.732170557365 | -122.421262171784 | (37.732170557365, -122.421262171784) | 2 | 7 | 7 | 28861 | 2 | ||||
| 163986 | 121133 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1050 North Point St | 1 | Front Yard : Yard | Tree | Private 2 | 20 | 3x10 | 6005628 | 2121390 | 37.8052501972152 | -122.424786108187 | (37.8052501972152, -122.424786108187) | 5 | 1 | 1 | 28858 | 32 | |||
| 163821 | 87242 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 4131 Geary Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 50271 | 5994116.9 | 2112250.5 | 37.7794987690846 | -122.46395756624 | (37.7794987690846, -122.46395756624) | 11 | 6 | 2 | 54 | 11 | ||||
| 163794 | 100464 | Significant Tree 6 | Pyrus calleryana :: Ornamental Pear 44 | 145 Irving St | 3 | Front Yard : Yard | Tree | Private 2 | 08/21/2012 12:00:00 AM | Permit Number 768746 | 5995340.8 | 2106458.8 | 37.76366673695 | -122.45930407086 | (37.76366673695, -122.45930407086) | 15 | 5 | 11 | 56 | 12 | |||
| 163659 | 102019 | Significant Tree 6 | Melaleuca quinquenervia :: Cajeput 10 | 3028 Market St | 1 | Front Yard : Yard | Tree | Private 2 | 30 | 4x14 | 6000376.7 | 2105451.5 | 37.7611891846044 | -122.44181421161 | (37.7611891846044, -122.44181421161) | 15 | 5 | 5 | 28862 | 3 | |||
| 163295 | 253972 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2200 Ofarrell St | 1 | Front Yard : Yard | Tree | Private 2 | 01/05/2018 12:00:00 AM | 3 | 3x3 | Permit Number 780724 | 6000775 | 2113124 | 37.7822786323031 | -122.440987106931 | (37.7822786323031, -122.440987106931) | 15 | 5 | 1 | 29490 | 41 | |
| 163180 | 254675 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 44X Starview Way | 3 | Back Yard : Yard | Tree | Private 2 | 10x10 | 5997596 | 2101581 | 37.7504029202392 | -122.451152286969 | (37.7504029202392, -122.451152286969) | 1 | 5 | 4 | 63 | 38 | ||||
| 162950 | 122415 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 499x Ocean Ave | 12 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 5998874 | 2091543 | 37.7229140478676 | -122.446010982458 | (37.7229140478676, -122.446010982458) | 9 | 7 | 6 | 28861 | 25 | ||||
| 162612 | 101203 | Significant Tree 6 | Tree(s) :: 17 | 7070 California St | 2 | Front Yard : | Tree | Private 2 | 10/03/2012 12:00:00 AM | Permit Number 769231 | 5985659.5 | 2114437.4 | 37.7850123376907 | -122.493376058427 | (37.7850123376907, -122.493376058427) | 11 | 6 | 1 | 55 | 33 | |||
| 162530 | 96328 | Significant Tree 6 | Cordyline australis :: Dracena Palm 64 | 296 Randall St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 767829 | 6003708 | 2097940 | 37.7407536226533 | -122.429756895294 | (37.7407536226533, -122.429756895294) | 2 | 7 | 5 | 63 | 7 | ||||
| 162461 | 120921 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 3995X Alemany Blvd | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3X3 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | ||||
| 162406 | 255994 | Significant Tree 6 | Magnolia grandiflora :: Southern Magnolia 19 | 179 Retiro Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3x3 | 6001908 | 2121813 | 37.8062008335618 | -122.437689923584 | (37.8062008335618, -122.437689923584) | 13 | 9 | 1 | 57 | 17 | ||||
| 162331 | 97175 | 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 | |||||
| 162123 | 120936 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 3995X Alemany Blvd | 19 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3X3 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | ||||
| 162063 | 113132 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 109 | 1375 FAIRFAX AVE | 1 | Front Yard : Yard | Tree | Private 2 | 6016814 | 2097238 | 37.7395595104895 | -122.384391976269 | (37.7395595104895, -122.384391976269) | 10 | 3 | 8 | 58 | 1 | |||||
| 162024 | 122639 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 3630X 19th Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x8 | 5990614 | 2091411 | 37.7220764711857 | -122.47455416919 | (37.7220764711857, -122.47455416919) | 9 | 8 | 4 | 64 | 40 | ||||
| 161834 | 107985 | Significant Tree 6 | Podocarpus gracilor :: Fern Pine 51 | 2401x SCOTT ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001096 | 2116670 | 37.7920333111805 | -122.440130949989 | (37.7920333111805, -122.440130949989) | 13 | 6 | 1 | 29490 | 27 | ||||
| 161712 | 92964 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 380 Valdez Ave | 1 | Front Yard : Yard | Tree | Private 2 | 17 | 5995792.2 | 2095482.9 | 37.7335556021648 | -122.456948893253 | (37.7335556021648, -122.456948893253) | 9 | 7 | 4 | 59 | 40 | ||||
| 161677 | 105090 | Significant Tree 6 | :: 45 | 344 Fulton St | 10 | Front Yard : Yard | Tree | Private 2 | 6006101.8 | 2111789.5 | 37.7789163735632 | -122.422463868572 | (37.7789163735632, -122.422463868572) | 7 | 9 | 11 | 28852 | 10 | |||||
| 161563 | 116580 | Significant Tree 6 | Shrub :: Shrub 66 | 3000x 19TH AVE | 3 | Sidewalk: Property side : Cutout | Landscaping | MTA 3 | DPW | 3x3 | 5990602 | 2095184 | 37.7324354869182 | -122.47487091251 | (37.7324354869182, -122.47487091251) | 1 | 8 | 4 | 64 | 40 | |||
| 161427 | 92055 | Significant Tree 6 | Quercus agrifolia :: Coast Live Oak 172 | 1001 Potrero Ave | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 52180 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | 10 | 4 | 8 | 28859 | 19 | |||||
| 161250 | 114073 | Significant Tree 6 | Betula pendula :: European White Birch 253 | 18x HIGUERA AVE | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 5988029 | 2090212 | 37.7186342037977 | -122.483401916227 | (37.7186342037977, -122.483401916227) | 1 | 8 | 4 | 64 | 14 | ||||
| 161031 | 101439 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 600X Grant Ave | 4 | Front Yard : Yard | Tree | Private 2 | 6010995.6 | 2116632 | 37.7924875884206 | -122.405875386937 | (37.7924875884206, -122.405875386937) | 3 | 1 | 10 | 28857 | 4 | |||||
| 160994 | 253716 | Significant Tree 6 | Magnolia grandiflora :: Southern Magnolia 19 | 2959 21st Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5x15 | 5989962 | 2095532 | 37.7333538971055 | -122.477108940264 | (37.7333538971055, -122.477108940264) | 1 | 8 | 4 | 64 | 35 | ||||
| 160978 | 112451 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 109 | 1526 MASONIC AVE | 1 | Front Yard : Cutout | Tree | Private 2 | 3x6 | 5999767 | 2107205 | 37.7659690994291 | -122.444048894864 | (37.7659690994291, -122.444048894864) | 15 | 5 | 5 | 29492 | 9 | ||||
| 160882 | 113234 | Significant Tree 6 | Magnolia grandiflora :: Southern Magnolia 19 | 2023 43RD AVE | 1 | Front Yard : Yard | Tree | Private 2 | 12 | 3x3 | 5982877 | 2101339 | 37.7488847374588 | -122.502032899239 | (37.7488847374588, -122.502032899239) | 1 | 8 | 3 | 29491 | 35 | |||
| 160817 | 252823 | Significant Tree 6 | Maytenus boaria :: Mayten 58 | 3852 17th St | 2 | Front Yard : Yard | Tree | Private 2 | 6003330 | 2106021 | 37.7629207320267 | -122.431640673814 | (37.7629207320267, -122.431640673814) | 15 | 4 | 5 | 28862 | 3 | |||||
| 160583 | 104899 | Significant Tree 6 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 314 Gonzalez Dr | 2 | Front Yard : Yard | Tree | Private 2 | 5990401 | 2090562 | 37.7197329843514 | -122.475228499286 | (37.7197329843514, -122.475228499286) | 1 | 8 | 4 | 64 | 14 | |||||
| 160307 | 110393 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 451 LOS PALMOS DR | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x8 | 5997298 | 2095759 | 37.7344000615683 | -122.451762846846 | (37.7344000615683, -122.451762846846) | 9 | 7 | 4 | 59 | 40 | ||||
| 160060 | 258238 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 37 | 200x Gough St | 7 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6006251 | 2110547 | 37.7755131849671 | -122.421859443165 | (37.7755131849671, -122.421859443165) | 7 | 9 | 11 | 28852 | 10 | ||||
| 159982 | 102589 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 5157 Diamond Heights Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 6000788.8 | 2100195.2 | 37.7467801300642 | -122.440012028415 | (37.7467801300642, -122.440012028415) | 2 | 4 | 5 | 63 | 22 | ||||
| 159837 | 253968 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 1401X Laguna St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6004485 | 2113711 | 37.784100995896 | -122.428194001884 | (37.784100995896, -122.428194001884) | 13 | 9 | 11 | 29490 | 41 | ||||
| 159825 | 96276 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 84 | 55@ Alemany Trumbull St | 4 | Back Yard : Yard | Tree | Private 2 | 2 | 6003946.78636 | 2094329.77315 | 37.7308542770831 | -122.428673970523 | (37.7308542770831, -122.428673970523) | 9 | 7 | 6 | 28861 | 5 | ||||
| 159746 | 253286 | Significant Tree 6 | Tree(s) :: 17 | 40 Mendosa Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/2017 12:00:00 AM | 3 | 6x10 | Permit Number 780599 | 5993445 | 2101187 | 37.7490825597194 | -122.465478005037 | (37.7490825597194, -122.465478005037) | 1 | 8 | 4 | 29491 | 40 | |
| 159697 | 226945 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 998 Chenery St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 21 | Width 1ft | 6001140.61217 | 2096125.61153 | 37.7356260187109 | -122.438503967885 | (37.7356260187109, -122.438503967885) | 2 | 7 | 5 | 63 | 7 | |||
| 159425 | 258291 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 56 | 36 Amber Dr | 8 | Front Yard : Yard | Tree | Private 2 | 3x3 | 5999567 | 2100009 | 37.7461992398699 | -122.444223501473 | (37.7461992398699, -122.444223501473) | 2 | 7 | 5 | 63 | 22 | ||||
| 159259 | 104674 | Significant Tree 6 | Taxus baccata :: Irish Yew 86 | 3649-3651 17TH ST | 1 | Front Yard : Yard | Tree | Private 2 | 20 | Permit Number 770917 | 6004555.5 | 2105964.3 | 37.7628344347284 | -122.427398052716 | (37.7628344347284, -122.427398052716) | 8 | 4 | 5 | 28862 | 3 | |||
| 159232 | 105859 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1580 Valencia St | 18 | Front Yard : Yard | Tree | Private 2 | 6006496 | 2100402 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | 2 | 7 | 7 | 28859 | 2 | |||||
| 159155 | 104908 | Significant Tree 6 | Myoporum laetum :: Myoporum 62 | 500 Gonzalez Dr | 1 | Front Yard : Yard | Tree | Private 2 | 5990401 | 2090562 | 37.7197329843514 | -122.475228499286 | (37.7197329843514, -122.475228499286) | 1 | 8 | 4 | 64 | 14 | |||||
| 158642 | 94066 | Significant Tree 6 | Palm (unknown Genus) :: Palm Spp 273 | 548 Page St | Front Yard : | Tree | Private 2 | 06/02/2010 12:00:00 AM | Permit Number 53460 | 6003937 | 2109751 | 37.7731967952272 | -122.429807334526 | (37.7731967952272, -122.429807334526) | 7 | 9 | 11 | 29492 | 10 | ||||
| 158598 | 117249 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 299x GRAYSTONE TER | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 5999641 | 2104067 | 37.7573457417117 | -122.44425918093 | (37.7573457417117, -122.44425918093) | 2 | 5 | 5 | 28862 | 3 | |||
| 158462 | 173887 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 72 | 2931 20th St | 2 | Front Yard : Yard | Tree | Private 2 | 6009454 | 2104482 | 37.7590402047035 | -122.410351120118 | (37.7590402047035, -122.410351120118) | 2 | 4 | 7 | 28859 | 19 | |||||
| 158256 | 104037 | Significant Tree 6 | Tree(s) :: 17 | 520X Oak Park Dr | 2 | Front Yard : Yard | Tree | Private 2 | 5995008.5 | 2103700.7 | 37.7560745928775 | -122.460253542676 | (37.7560745928775, -122.460253542676) | 1 | 5 | 4 | 63 | 12 | |||||
| 158156 | 93206 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 400 Masonic Ave | 4 | Front Yard : Yard | Tree | Private 2 | 02/24/2010 12:00:00 AM | Permit Number 53203 | 5999124.7 | 2111407.5 | 37.7774714343299 | -122.446572853901 | (37.7774714343299, -122.446572853901) | 15 | 5 | 11 | 29492 | 16 | |||
| 158154 | 258096 | Significant Tree 6 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 941 Mission St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 05/13/2019 12:00:00 AM | 3 | 3x3 | 6010493.2294 | 2112796.27211 | 37.7819274857178 | -122.407343084927 | (37.7819274857178, -122.407343084927) | 14 | 2 | 9 | 28853 | 34 | ||
| 158054 | 105754 | Significant Tree 6 | Tree(s) :: 17 | 1899X Eddy St | 2 | Front Yard : Yard | Tree | Private 2 | 02/21/2014 12:00:00 AM | Permit Number 772599 | 6001374.8 | 2112478.6 | 37.7805406719806 | -122.438865805362 | (37.7805406719806, -122.438865805362) | 15 | 5 | 11 | 29490 | 41 | |||
| 157916 | 110559 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 320x FULTON ST | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10x36 | 6006080 | 2112015 | 37.7795343118474 | -122.422555311635 | (37.7795343118474, -122.422555311635) | 7 | 9 | 11 | 28852 | 10 | ||||
| 157806 | 95777 | Significant Tree 6 | Acer palmatum 'Sango Kaku' :: Coral Bark Maple 550 | 30 Onondaga Ave | Front Yard : Yard | Tree | Private 2 | 03/11/2011 12:00:00 AM | Permit Number 767524 | 6001190.6 | 2091111.6 | 37.7218615356817 | -122.437972107548 | (37.7218615356817, -122.437972107548) | 9 | 7 | 6 | 28861 | 25 | ||||
| 157788 | 251660 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1050 North Point St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6005628 | 2121390 | 37.8052501972152 | -122.424786108187 | (37.8052501972152, -122.424786108187) | 5 | 1 | 1 | 28858 | 32 | ||||
| 157634 | 85365 | Significant Tree 6 | Myoporum laetum :: Myoporum 62 | 66 Clarendon Ave | 1 | Front Yard : Cutout | Tree | Private 2 | 08/17/2007 12:00:00 AM | Permit Number 49641 | 5997837.8 | 2104660.2 | 37.7588714791444 | -122.450538092312 | (37.7588714791444, -122.450538092312) | 15 | 5 | 11 | 28862 | 12 | |||
| 157517 | 112488 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 52 | 1275 Columbus Ave | 8 | Front Yard : Yard | Tree | Private 2 | 6007539.6 | 2121483.9 | 37.8056158049656 | -122.418177422209 | (37.8056158049656, -122.418177422209) | 5 | 1 | 1 | 308 | 32 | |||||
| 157383 | 110560 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 320x FULTON ST | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10x36 | 6006080 | 2112015 | 37.7795343118474 | -122.422555311635 | (37.7795343118474, -122.422555311635) | 7 | 9 | 11 | 28852 | 10 | ||||
| 157354 | 187637 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 875 El Camino Del Mar | 1 | Side Yard : Yard | Tree | Private 2 | 10x10 | 5985641 | 2114972 | 37.786479112006 | -122.493479464676 | (37.786479112006, -122.493479464676) | 11 | 6 | 1 | 55 | 15 | ||||
| 157181 | 101138 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1290 Portola Dr | 1 | Front Yard : Yard | Tree | Private 2 | 5994035.6 | 2097938.3 | 37.7401964926879 | -122.463200022957 | (37.7401964926879, -122.463200022957) | 1 | 8 | 4 | 59 | 40 | |||||
| 157045 | 105845 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 355 Buena Vista Ave | Front Yard : Yard | Tree | Private 2 | 6000886.5 | 2107736.6 | 37.767492540377 | -122.440214908068 | (37.767492540377, -122.440214908068) | 15 | 5 | 5 | 29492 | 3 |
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) );