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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 156992 | 253621 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 200x Montcalm St | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 6010036 | 2099760 | 37.7461072494139 | -122.408005278478 | (37.7461072494139, -122.408005278478) | 2 | 7 | 7 | 28859 | 2 | ||||
| 156900 | 120929 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 3995X Alemany Blvd | 12 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3X3 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | ||||
| 156782 | 12711 | Significant Tree 6 | Tree(s) :: 17 | 1449 Lake St | 3 | Front Yard : Cutout | Tree | DPW 1 | 06/01/2000 12:00:00 AM | 3 | 5990998.3321714 | 2114735.5234974 | 37.7861417388427 | -122.474927352046 | (37.7861417388427, -122.474927352046) | 11 | 6 | 2 | 54 | 26 | |||
| 156777 | 114101 | Significant Tree 6 | Betula pendula :: European White Birch 253 | 21x ACEVEDO AVE | 2 | Front Yard : Yard | Tree | Private 2 | 7 | 5988027 | 2090598 | 37.7196939458216 | -122.48343711114 | (37.7196939458216, -122.48343711114) | 1 | 8 | 4 | 64 | 14 | ||||
| 156684 | 105850 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 44 MENDOSA AVE | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 100 | 6x15 | 5993395.1 | 2101192.7 | 37.7490953323683 | -122.465650972372 | (37.7490953323683, -122.465650972372) | 1 | 8 | 4 | 29491 | 40 | |||
| 156652 | 104284 | Significant Tree 6 | Tree(s) :: 17 | 45X Middle Point Rd | 1 | Front Yard : Yard | Tree | Housing Authority 15 | 09/17/2013 12:00:00 AM | Permit Number 770341 | 6018215 | 2095138 | 37.7338706954973 | -122.379402036794 | (37.7338706954973, -122.379402036794) | 10 | 3 | 8 | 58 | 1 | |||
| 156627 | 125128 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 2545 Baker St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 4ft | 5999632.15337 | 2117620.57677 | 37.7945598973812 | -122.44526423016 | (37.7945598973812, -122.44526423016) | 13 | 9 | 1 | 57 | 27 | |||
| 156524 | 101468 | Significant Tree 6 | Cupressocyparis leylandii :: Leyland Cypress 185 | 301 Hazelwood Ave | 3 | Front Yard : Yard | Tree | Private 2 | 5996219.7 | 2095283.8 | 37.7330334614805 | -122.455456526637 | (37.7330334614805, -122.455456526637) | 9 | 7 | 4 | 59 | 40 | |||||
| 156485 | 105434 | Significant Tree 6 | Eriobotrya deflexa :: Bronze Loquat 8 | 4355 ANZA ST | 1 | Back Yard : Yard | Tree | Private 2 | 10 | 5985110.8 | 2111730.2 | 37.7775470387472 | -122.495074662501 | (37.7775470387472, -122.495074662501) | 11 | 6 | 2 | 55 | 26 | ||||
| 156168 | 113153 | Significant Tree 6 | Populus alba :: White Poplar 184 | 55 BRONTE ST | Front Yard : Cutout | Tree | Private 2 | 12 | 3x3 | 6009403 | 2097128 | 37.7388448914729 | -122.410008345842 | (37.7388448914729, -122.410008345842) | 10 | 7 | 7 | 28859 | 2 | ||||
| 156105 | 122412 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 499x Ocean Ave | 9 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 5998874 | 2091543 | 37.7229140478676 | -122.446010982458 | (37.7229140478676, -122.446010982458) | 9 | 7 | 6 | 28861 | 25 | ||||
| 156075 | 258076 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 291 Duboce Ave | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | Width 3ft | 6005037.67201 | 2108401.42033 | 37.7695534429634 | -122.425903876974 | (37.7695534429634, -122.425903876974) | 8 | 4 | 5 | 28853 | 19 | ||||
| 156060 | 253715 | Significant Tree 6 | Pseudotsuga menziesii :: Douglas Fir 285 | 2959 21st Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5x15 | Permit Number 780322 | 5989962 | 2095532 | 37.7333538971055 | -122.477108940264 | (37.7333538971055, -122.477108940264) | 1 | 8 | 4 | 64 | 35 | |||
| 155948 | 102478 | Significant Tree 6 | Afrocarpus gracilior :: Fern Pine 89 | 760 Victoria St | 4 | Front Yard : Yard | Tree | Private 2 | 5993664.7 | 2092172.3 | 37.7243431058269 | -122.464063971167 | (37.7243431058269, -122.464063971167) | 9 | 8 | 4 | 59 | 40 | |||||
| 155662 | 105755 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1100X Divisadero St | 1 | Front Yard : Yard | Tree | Private 2 | 6001418 | 2112151 | 37.7796436231931 | -122.438692875339 | (37.7796436231931, -122.438692875339) | 15 | 5 | 11 | 29490 | 41 | |||||
| 155656 | 105435 | Significant Tree 6 | Tree(s) :: 17 | 610 PARNASSUS AVE | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 03/05/2014 12:00:00 AM | 16 | Permit Number 771221 | 5995151.3 | 2106193.4 | 37.762927120329 | -122.459940260935 | (37.762927120329, -122.459940260935) | 15 | 5 | 11 | 56 | 12 | ||
| 155480 | 116958 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 10x Yerba Buena Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/10/2016 12:00:00 AM | 3 | Permit Number 777762 | 5993642.27748 | 2097056.19499 | 37.7377517864641 | -122.46449593033 | (37.7377517864641, -122.46449593033) | 1 | 8 | 4 | 59 | 40 | ||
| 155327 | 107408 | Significant Tree 6 | Acer japonicum :: Japanese Maple 124 | 10 PEMBERTON PL | 1 | Front Yard : Yard | Tree | Private 2 | 30 | 5998956.5 | 2104566.5 | 37.7586781689727 | -122.446662380642 | (37.7586781689727, -122.446662380642) | 15 | 5 | 5 | 28862 | 12 | ||||
| 155172 | 258233 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 37 | 200x Gough St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6006251 | 2110547 | 37.7755131849671 | -122.421859443165 | (37.7755131849671, -122.421859443165) | 7 | 9 | 11 | 28852 | 10 | ||||
| 155139 | 101440 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 600X Grant Ave | 5 | Front Yard : Yard | Tree | Private 2 | 6010995.6 | 2116632 | 37.7924875884206 | -122.405875386937 | (37.7924875884206, -122.405875386937) | 3 | 1 | 10 | 28857 | 4 | |||||
| 155030 | 113150 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 45 BRONTE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6009384 | 2097185 | 37.7390003361927 | -122.410078062228 | (37.7390003361927, -122.410078062228) | 10 | 7 | 7 | 28859 | 2 | |||
| 154885 | 116096 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 300x EXECUTIVE PARK BLVD | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014482 | 2086919 | 37.7110963749119 | -122.391733773238 | (37.7110963749119, -122.391733773238) | 10 | 3 | 8 | 309 | 1 | ||||
| 154884 | 121182 | Significant Tree 6 | Myoporum laetum :: Myoporum 62 | 1000x Duncan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 775289 | 5999834 | 2099740 | 37.7454758595085 | -122.443280934089 | (37.7454758595085, -122.443280934089) | 2 | 7 | 5 | 63 | 22 | |||
| 154838 | 102479 | Significant Tree 6 | Cupressocyparis leylandii :: Leyland Cypress 185 | 760 Victoria St | 5 | Front Yard : Yard | Tree | Private 2 | 5993664.7 | 2092172.3 | 37.7243431058269 | -122.464063971167 | (37.7243431058269, -122.464063971167) | 9 | 8 | 4 | 59 | 40 | |||||
| 154745 | 114237 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 150 | 99x FONT BLVD | 13 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | 5990948 | 2088640 | 37.7144873339183 | -122.473197635313 | (37.7144873339183, -122.473197635313) | 1 | 8 | 4 | 64 | 14 | ||||
| 154657 | 100850 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1 Estero Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5992057.7 | 2091642.6 | 37.7227959320346 | -122.469580550695 | (37.7227959320346, -122.469580550695) | 9 | 8 | 4 | 59 | 40 | |||||
| 154569 | 103589 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 55X Laguna St | 1 | Front Yard : Yard | Tree | Private 2 | 6005242.6 | 2108960.5 | 37.7711001201992 | -122.425234826708 | (37.7711001201992, -122.425234826708) | 7 | 9 | 5 | 28852 | 10 | |||||
| 154508 | 109210 | Significant Tree 6 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2637 Larkin St | 1 | Front Yard : Yard | Tree | Private 2 | 02/18/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774817 | 6006569.78732 | 2120282.61277 | 37.8022627417937 | -122.421448236261 | (37.8022627417937, -122.421448236261) | 5 | 9 | 1 | 28858 | 32 | |
| 154153 | 105087 | Significant Tree 6 | :: 45 | 344 Fulton St | 7 | Front Yard : Yard | Tree | Private 2 | 6006101.8 | 2111789.5 | 37.7789163735632 | -122.422463868572 | (37.7789163735632, -122.422463868572) | 7 | 9 | 11 | 28852 | 10 | |||||
| 154007 | 105073 | Significant Tree 6 | Myoporum laetum :: Myoporum 62 | 101 LUNDYS LN | 1 | Front Yard : Cutout | Tree | Private 2 | 18 | 6006875 | 2098969 | 37.7437578546964 | -122.418879543436 | (37.7437578546964, -122.418879543436) | 2 | 7 | 7 | 28859 | 2 | ||||
| 153865 | 251633 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 14R Amethyst Way | 2 | Back Yard : Yard | Tree | Private 2 | 5999202 | 2100044 | 37.7462745109784 | -122.445488137723 | (37.7462745109784, -122.445488137723) | 2 | 7 | 5 | 63 | 22 | |||||
| 153818 | 100055 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 401X Tehama St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773313 | 6011330.4 | 2112435.9 | 37.7809848079497 | -122.404421471201 | (37.7809848079497, -122.404421471201) | 14 | 2 | 9 | 28853 | 34 | |
| 153784 | 99733 | Significant Tree 6 | Pyrus calleryana :: Ornamental Pear 44 | 145 Irving St | 1 | 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 | |||
| 153500 | 33327 | Significant Tree 6 | Arbutus unedo :: Strawberry Tree 106 | 1629 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2010 12:00:00 AM | 3x3 | Originally issued under Permit Number 51411; permit expired; property changed owners; trees re-posted and permit 53716 issued | 6005242.65792202 | 2118493.60609418 | 37.7972756709044 | -122.425913331435 | (37.7972756709044, -122.425913331435) | 13 | 9 | 1 | 57 | 17 | ||
| 153493 | 256541 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 126X Warren Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995584 | 2102944 | 37.754029973308 | -122.458208518647 | (37.754029973308, -122.458208518647) | 1 | 5 | 4 | 63 | 12 | ||||
| 153312 | 91106 | Significant Tree 6 | Tree(s) :: 17 | 2650 Turk Blvd | 1 | Front Yard : Yard | Tree | Private 2 | 01/12/2009 12:00:00 AM | On campus | Permit Number 51996 | 5995208 | 2110277 | 37.7741428808777 | -122.460040004978 | (37.7741428808777, -122.460040004978) | 11 | 6 | 2 | 54 | 11 | ||
| 153240 | 107142 | Significant Tree 6 | Aesculus californica :: California Buckeye 168 | 2694 MCALLISTER ST | 2 | Front Yard : Yard | Tree | Private 2 | 48 | 5996297.4 | 2110789.6 | 37.7756129427938 | -122.45630867289 | (37.7756129427938, -122.45630867289) | 11 | 6 | 2 | 54 | 16 | ||||
| 153073 | 94297 | Significant Tree 6 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1150X Fillmore St | 3 | Sidewalk: Property side : Cutout | Tree | Rec/Park 5 | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | 15 | 9 | 11 | 29490 | 41 | |||||
| 152685 | 101980 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 25X Tiffany Ave | 3 | Front Yard : Yard | Tree | Private 2 | 6006415.7 | 2099833.4 | 37.7461054290546 | -122.420529042399 | (37.7461054290546, -122.420529042399) | 2 | 7 | 7 | 28859 | 2 | |||||
| 152541 | 114384 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 83 | 418X SERRANO DR | 2 | Front Yard : Yard | Tree | Private 2 | 6 | 5988379 | 2090615 | 37.7197611043299 | -122.482221632222 | (37.7197611043299, -122.482221632222) | 1 | 8 | 4 | 64 | 14 | ||||
| 152489 | 103652 | Significant Tree 6 | Tree(s) :: 17 | 307X Octavia St | 1 | Front Yard : Yard | Tree | DPW for City Agency 14 | 06/07/2013 12:00:00 AM | Permit Number 770306 | 6005538.74006 | 2110314.20336 | 37.7748337884081 | -122.424306762839 | (37.7748337884081, -122.424306762839) | 7 | 9 | 11 | 28852 | 10 | |||
| 152275 | 103719 | Significant Tree 6 | Eriobotrya deflexa :: Bronze Loquat 8 | 748 Treat Ave | 1 | Front Yard : Cutout | Tree | Private 2 | 8 | 3x3 | 6008496.2 | 2104169 | 37.7581270399512 | -122.413641518528 | (37.7581270399512, -122.413641518528) | 2 | 4 | 7 | 28859 | 19 | |||
| 151937 | 251657 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1050 North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6005628 | 2121390 | 37.8052501972152 | -122.424786108187 | (37.8052501972152, -122.424786108187) | 5 | 1 | 1 | 28858 | 32 | ||||
| 151892 | 92897 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 56 | 208 States St | 1 | Back Yard : Yard | Tree | Private 2 | 08/13/2008 12:00:00 AM | 6000833 | 2106506 | 37.7641105715625 | -122.440311694354 | (37.7641105715625, -122.440311694354) | 15 | 5 | 5 | 28862 | 3 | ||||
| 151692 | 104169 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 470X Roosevelt Way | 1 | Front Yard : Yard | Tree | Private 2 | 5999944.58235 | 2106286.89423 | 37.7634583383964 | -122.443368723848 | (37.7634583383964, -122.443368723848) | 15 | 5 | 5 | 29492 | 3 | |||||
| 151632 | 95299 | 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 | |||
| 151585 | 254728 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 1940 Mission St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | Width 0ft | 6006763.6807 | 2106952.0622 | 37.7656712394659 | -122.419830807079 | (37.7656712394659, -122.419830807079) | 8 | 4 | 7 | 28853 | 19 | ||||
| 151159 | 107322 | Significant Tree 6 | Tree(s) :: 17 | 68 ROSENKRANZ ST | 1 | Front Yard : Yard | Tree | Private 2 | 09/29/2014 12:00:00 AM | 3 | Permit Number 773942 | 6009212 | 2098349 | 37.7421867844178 | -122.410754944355 | (37.7421867844178, -122.410754944355) | 10 | 7 | 7 | 28859 | 2 | ||
| 151110 | 122636 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 3698X 19th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5990586 | 2091171 | 37.7214158684235 | -122.474633449984 | (37.7214158684235, -122.474633449984) | 9 | 8 | 4 | 64 | 40 | ||||
| 150739 | 121178 | Significant Tree 6 | Acacia spp :: Acacia Spp 105 | 990x Duncan St | 2 | Front Yard : Yard | Tree | Private 2 | 3x3 | Permit Number 775289 | 6000056 | 2099639 | 37.7452111944111 | -122.442506045398 | (37.7452111944111, -122.442506045398) | 2 | 7 | 5 | 63 | 22 | |||
| 150406 | 251198 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 900X 14th St | 3 | Front Yard : Yard | Tree | Private 2 | 6002515 | 2107976 | 37.768242455455 | -122.434599270731 | (37.768242455455, -122.434599270731) | 15 | 5 | 5 | 28862 | 3 | |||||
| 150390 | 99101 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 55x Santa Monica Way | 1 | Median : Yard | Tree | Private 2 | 04/07/2012 12:00:00 AM | Permit Number 768464 | 5993693.6 | 2097654.3 | 37.7393969918941 | -122.464361897304 | (37.7393969918941, -122.464361897304) | 1 | 8 | 4 | 59 | 40 | |||
| 150357 | 100434 | Significant Tree 6 | Tree(s) :: 17 | 2430 Sacramento St | 1 | Front Yard : Yard | Tree | Private 2 | 09/24/2012 12:00:00 AM | Permit Number 769154 | 6003168.3 | 2115899 | 37.7900341016439 | -122.432905672523 | (37.7900341016439, -122.432905672523) | 13 | 9 | 1 | 29490 | 27 | |||
| 150154 | 96278 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 55@ Alemany Trumbull St | 6 | Back Yard : Yard | Tree | Private 2 | 2 | 6003898.31997 | 2094328.29867 | 37.7308474854131 | -122.428841421596 | (37.7308474854131, -122.428841421596) | 9 | 7 | 6 | 28861 | 5 | ||||
| 150077 | 107187 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 945 Sacramento St | 3 | Front Yard : Yard | Tree | Private 2 | Permit Number 773422 | 6010352.63458 | 2116759.0624 | 37.7928004918921 | -122.408109042355 | (37.7928004918921, -122.408109042355) | 3 | 1 | 10 | 28857 | 4 | ||||
| 149763 | 112290 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 34 YERBA BUENA AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | 3x3 | Permit Number 776546 | 5993584 | 2097045 | 37.7377176881769 | -122.464696609393 | (37.7377176881769, -122.464696609393) | 1 | 8 | 4 | 59 | 40 | |
| 149707 | 108978 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1 MIGUEL ST | 1 | Front Yard : Yard | Tree | Private 2 | 44 | 6003334.2 | 2097391.9 | 37.7392274919289 | -122.431010244874 | (37.7392274919289, -122.431010244874) | 2 | 7 | 5 | 63 | 7 | ||||
| 149548 | 122416 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 499x Ocean Ave | 13 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 5998874 | 2091543 | 37.7229140478676 | -122.446010982458 | (37.7229140478676, -122.446010982458) | 9 | 7 | 6 | 28861 | 25 | ||||
| 149146 | 105234 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 250 STATES ST | 5 | Front Yard : Yard | Tree | Private 2 | 12 | 6000595.6 | 2106681.2 | 37.7645781078798 | -122.441145360444 | (37.7645781078798, -122.441145360444) | 15 | 5 | 5 | 28862 | 3 | ||||
| 149078 | 117438 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 230 AMBER DR | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 25 | 3X3 | 5999593 | 2099199 | 37.7439766577846 | -122.444075405191 | (37.7439766577846, -122.444075405191) | 2 | 7 | 5 | 63 | 22 | |||
| 149040 | 114068 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 37 | 8 HIGUERA AVE | 1 | Front Yard : Yard | Tree | Private 2 | 20 | 5987898 | 2090420 | 37.7191976939958 | -122.48386996767 | (37.7191976939958, -122.48386996767) | 1 | 8 | 4 | 64 | 14 | ||||
| 149016 | 114404 | Significant Tree 6 | Cedrus atlantica Glauca :: Blue Atlas Cedar 208 | 500X ARBALLO DR | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | 5987859 | 2089716 | 37.7172624174607 | -122.483953179035 | (37.7172624174607, -122.483953179035) | 1 | 8 | 4 | 64 | 14 | |||
| 148884 | 122413 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 499x Ocean Ave | 10 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 5998874 | 2091543 | 37.7229140478676 | -122.446010982458 | (37.7229140478676, -122.446010982458) | 9 | 7 | 6 | 28861 | 25 | ||||
| 148345 | 104684 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 33 08th St | 6 | Front Yard : Yard | Tree | Private 2 | Permit Number 770764 | 6008457.3 | 2111569.1 | 37.7784438055662 | -122.414299630615 | (37.7784438055662, -122.414299630615) | 8 | 2 | 9 | 28853 | 34 | ||||
| 148103 | 112925 | 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 | |||
| 148080 | 88457 | Significant Tree 6 | Tree(s) :: 17 | 2801 Oakdale Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/2008 12:00:00 AM | Permit Number 51417 | 6011007.5 | 2098422.1 | 37.742488010089 | -122.404551775442 | (37.742488010089, -122.404551775442) | 10 | 3 | 8 | 58 | 1 | |||
| 148062 | 85032 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 411 Panorama Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5997300 | 2101977 | 37.7514732863106 | -122.452204440653 | (37.7514732863106, -122.452204440653) | 1 | 5 | 4 | 63 | 38 | |||||
| 147971 | 253973 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2200 Ofarrell St | 2 | 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 | |
| 147948 | 111036 | Significant Tree 6 | Magnolia spp :: Magnolia 224 | 3991-3997 Washington St | 1 | Front Yard : Yard | Tree | Private 2 | 5995610.3 | 2115419.4 | 37.7882856707006 | -122.459020806409 | (37.7882856707006, -122.459020806409) | 11 | 6 | 1 | 54 | 31 | |||||
| 147696 | 258285 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 56 | 36 Amber Dr | 2 | Front Yard : Yard | Tree | Private 2 | 3x3 | 5999567 | 2100009 | 37.7461992398699 | -122.444223501473 | (37.7461992398699, -122.444223501473) | 2 | 7 | 5 | 63 | 22 | ||||
| 147643 | 100770 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 95 | 450 Hayes St | 1 | Back Yard : Yard | Tree | Private 2 | Permit Number 768934 | 6005678.7 | 2111113.4 | 37.7770360905223 | -122.423879452899 | (37.7770360905223, -122.423879452899) | 7 | 9 | 11 | 28852 | 10 | ||||
| 147624 | 121449 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1274 Filbert St | 1 | Front Yard : Yard | Tree | Private 2 | 12 | 10x6 | 6006927.94593 | 2119481.89109 | 37.800084349978 | -122.420151970562 | (37.800084349978, -122.420151970562) | 5 | 1 | 1 | 28858 | 32 | |||
| 147409 | 95215 | Significant Tree 6 | Acer palmatum :: Japanese Maple 216 | 2203 Divisadero St | Front Yard : Yard | Tree | Private 2 | 6000868 | 2115894 | 37.7898896344174 | -122.440864138631 | (37.7898896344174, -122.440864138631) | 13 | 6 | 1 | 29490 | 27 | ||||||
| 147278 | 100431 | Significant Tree 6 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 200X Stonecrest Dr | 1 | Front Yard : Yard | Tree | Private 2 | 5990724.7 | 2093134.9 | 37.7268162840874 | -122.47429724264 | (37.7268162840874, -122.47429724264) | 9 | 8 | 4 | 64 | 40 | |||||
| 147066 | 121377 | Significant Tree 6 | Prunus ilicifoia :: Holly-leaved Cherry 245 | 2701 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001200 | 2116539 | 37.7916795394978 | -122.439761713662 | (37.7916795394978, -122.439761713662) | 13 | 6 | 1 | 29490 | 27 | ||||
| 146707 | 103477 | Significant Tree 6 | Tree(s) :: 17 | 875 El Camino Del Mar | 1 | Front Yard : | Tree | Private 2 | 05/08/2013 12:00:00 AM | Permit Number 770113 | 5985641.7 | 2114972.5 | 37.7864805258078 | -122.493477079739 | (37.7864805258078, -122.493477079739) | 11 | 6 | 1 | 55 | 15 | |||
| 146688 | 110953 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 220 Newhall St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 05/12/2015 12:00:00 AM | 3 | 6016803.8 | 2098347.9 | 37.7426065069695 | -122.384504531053 | (37.7426065069695, -122.384504531053) | 10 | 3 | 8 | 58 | 1 | |||
| 146644 | 105349 | Significant Tree 6 | Tree(s) :: 17 | 151X Spruce St | 1 | Front Yard : Yard | Tree | Private 2 | 01/16/2014 12:00:00 AM | Permit Number 771071 | 5997060.93638 | 2115845.70083 | 37.7895394616557 | -122.45403267224 | (37.7895394616557, -122.45403267224) | 11 | 6 | 1 | 54 | 31 | |||
| 146533 | 104435 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 1601X PORTOLA DR | 4 | Front Yard : Yard | Tree | Private 2 | 16 | 5991823 | 2096240 | 37.7354056792703 | -122.47072655808 | (37.7354056792703, -122.47072655808) | 1 | 8 | 4 | 59 | 40 | ||||
| 146386 | 107343 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 110 JULIAN AVE | 2 | Back Yard : Yard | Tree | Private 2 | 15 | 6006340.8 | 2107214.1 | 37.7663669011591 | -122.421312071366 | (37.7663669011591, -122.421312071366) | 8 | 4 | 7 | 28853 | 19 | ||||
| 146280 | 255793 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 441 Detroit St | 1 | Unaccepted Street : Yard | Tree | Private 2 | 30x30 | Permit Number 782172 | 5999396 | 2094599 | 37.7313349085161 | -122.444426062201 | (37.7313349085161, -122.444426062201) | 9 | 7 | 4 | 59 | 40 | |||
| 146154 | 99098 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 66 Santa Monica Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/2012 12:00:00 AM | Permit Number 768466 | 5993736.6 | 2097303.5 | 37.7384362612216 | -122.464187762983 | (37.7384362612216, -122.464187762983) | 1 | 8 | 4 | 59 | 40 | |||
| 145907 | 187657 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 2072 15th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3x3 | 5991666 | 2101424 | 37.7496305363998 | -122.47164701446 | (37.7496305363998, -122.47164701446) | 1 | 8 | 4 | 29491 | 12 | ||||
| 145840 | 113162 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 1300X STANYAN ST | 1 | Front Yard : Yard | Tree | Private 2 | 40 | 3x3 | 5997565 | 2104877 | 37.7594511396077 | -122.451497194349 | (37.7594511396077, -122.451497194349) | 15 | 5 | 11 | 28862 | 12 | |||
| 145813 | 173616 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 1200X JUNIPERO SERRA BLVD | 15 | Front Yard : Yard | Tree | Private 2 | 01/20/2017 12:00:00 AM | 3 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | |||
| 145770 | 258288 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 56 | 36 Amber Dr | 5 | Front Yard : Yard | Tree | Private 2 | 3x3 | 5999567 | 2100009 | 37.7461992398699 | -122.444223501473 | (37.7461992398699, -122.444223501473) | 2 | 7 | 5 | 63 | 22 | ||||
| 145768 | 98703 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 7070@ 32nd Ave California St | 4 | Front Yard : | Tree | Private 2 | 03/10/2012 12:00:00 AM | Permit Number 767466 | 5985659.5 | 2114437.4 | 37.7850123376907 | -122.493376058427 | (37.7850123376907, -122.493376058427) | 11 | 6 | 1 | 55 | 33 | |||
| 145683 | 112626 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 3430X 23rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 6006285 | 2102686.4 | 37.7539317482446 | -122.421183538041 | (37.7539317482446, -122.421183538041) | 2 | 4 | 5 | 28859 | 19 | ||||
| 145596 | 105870 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 3555 Cesar Chavez St | 5 | Front Yard : Yard | Tree | Private 2 | 6006336.4 | 2100501.8 | 37.7479362343406 | -122.420850697466 | (37.7479362343406, -122.420850697466) | 2 | 7 | 7 | 28859 | 2 | |||||
| 145519 | 173778 | Significant Tree 6 | Tree(s) :: 17 | 99X Cleveland St | 1 | Side Yard : Cutout | Tree | Private 2 | 3x3 | 6010549 | 2110746 | 37.7763010397716 | -122.407005587048 | (37.7763010397716, -122.407005587048) | 14 | 2 | 9 | 28853 | 34 | ||||
| 145466 | 88567 | Significant Tree 6 | Tree(s) :: 17 | 1335 Webster St | 39 | Front Yard : Cutout | Tree | Private 2 | 07/30/2008 12:00:00 AM | Permit Number 51511 | 6003187 | 2113215 | 37.7826655777078 | -122.432649168887 | (37.7826655777078, -122.432649168887) | 15 | 9 | 11 | 29490 | 41 | |||
| 145439 | 116093 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 300x EXECUTIVE PARK BLVD | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014482 | 2086919 | 37.7110963749119 | -122.391733773238 | (37.7110963749119, -122.391733773238) | 10 | 3 | 8 | 309 | 1 | ||||
| 145363 | 251626 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 2R Amethyst Way | 1 | Back Yard : Yard | Tree | Private 2 | 5999263 | 2100016 | 37.7462011119367 | -122.44527519505 | (37.7462011119367, -122.44527519505) | 2 | 7 | 5 | 63 | 22 | |||||
| 145352 | 100578 | Significant Tree 6 | Cedrus atlantica Glauca :: Blue Atlas Cedar 208 | 35 Lloyd St | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 56924 | 6002279.7 | 2108550 | 37.7698051576272 | -122.435454215606 | (37.7698051576272, -122.435454215606) | 15 | 5 | 5 | 29492 | 9 | ||||
| 145282 | 120934 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 3995X Alemany Blvd | 17 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3X3 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | ||||
| 145228 | 173889 | Significant Tree 6 | Gleditsia triacanthos :: Honey Locust 182 | 190 Holladay Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 779949 | 6010824 | 2099939 | 37.7466428319545 | -122.405293064953 | (37.7466428319545, -122.405293064953) | 2 | 7 | 7 | 28859 | 2 | |||
| 145102 | 105085 | Significant Tree 6 | :: 45 | 344 Fulton St | 5 | Front Yard : Yard | Tree | Private 2 | 6006101.8 | 2111789.5 | 37.7789163735632 | -122.422463868572 | (37.7789163735632, -122.422463868572) | 7 | 9 | 11 | 28852 | 10 | |||||
| 144728 | 253098 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1290 Portola Dr | 2 | Sidewalk: Property side : Yard | Tree | DPW 1 | 08/22/2017 12:00:00 AM | 3 | 3x3 | 5994035 | 2097938 | 37.740195634398 | -122.463202075736 | (37.740195634398, -122.463202075736) | 1 | 8 | 4 | 59 | 40 | ||
| 144689 | 253283 | Significant Tree 6 | Ginkgo biloba :: Maidenhair Tree 22 | 673 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005929 | 2099335 | 37.7447094953859 | -122.422176588207 | (37.7447094953859, -122.422176588207) | 2 | 7 | 5 | 28859 | 2 | ||||
| 144656 | 255730 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1450 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002272 | 2111622 | 37.7782396679587 | -122.435700666763 | (37.7782396679587, -122.435700666763) | 15 | 5 | 11 | 29490 | 41 |
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) );