Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location ▼ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 74942 | 74942 | 189463 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1600 Newhall St | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 22 | 6014124.78069 | 2095373.74732 | 37.7342915875929 | -122.393559763171 | (37.7342915875929, -122.393559763171) | ||||
| 147650 | 147650 | 189462 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1600 Newhall St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 18 | 6014132.345380001 | 2095385.42746 | 37.7343240791916 | -122.393534426582 | (37.7343240791916, -122.393534426582) | ||||
| 126347 | 126347 | 117645 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 143 | 2901 21ST AVE | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 5989904.0 | 2095901.0 | 37.734363711699 | -122.477336418651 | (37.734363711699, -122.477336418651) | ||||
| 147254 | 147254 | 211258 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 426 Los Palmos Dr | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 15 | Width 3ft | 5997445.84853 | 2095752.3652400002 | 37.734390310651605 | -122.451251210378 | (37.7343903106516, -122.451251210378) | |||
| 139589 | 139589 | 109576 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 21X STILLINGS AVE | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 60 | 6000417.0 | 2095694.0 | 37.7343997262189 | -122.44097481223999 | (37.7343997262189, -122.44097481224) | ||||
| 68047 | 68047 | 218985 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 735 Foerster St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 15 | Width 3ft | 5998106.15759 | 2095768.84675 | 37.7344733504624 | -122.448969503563 | (37.7344733504624, -122.448969503563) | |||
| 105598 | 105598 | 106227 | Property Tree 7 | Eucalyptus globulus :: Blue Gum 103 | 38 Stanford Heights Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5997884.0 | 2095808.5 | 37.7345695210024 | -122.44974042873999 | (37.7345695210024, -122.44974042874) | |||||
| 28538 | 28538 | 212784 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 739 Foerster St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 17 | Width 3ft | 5998105.0801800005 | 2095806.61255 | 37.734576984727795 | -122.448975948078 | (37.7345769847278, -122.448975948078) | |||
| 68601 | 68601 | 212785 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 743 Foerster St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 12 | Width 3ft | 5998104.46417 | 2095821.7845 | 37.734618608054795 | -122.448979170379 | (37.7346186080548, -122.448979170379) | |||
| 115179 | 115179 | 106275 | Property Tree 7 | Eucalyptus globulus :: Blue Gum 103 | 42 Stanford Heights Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5997882.5 | 2095834.4 | 37.7346405503947 | -122.449747480555 | (37.7346405503947, -122.449747480555) | |||||
| 36699 | 36699 | 218742 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 32 Los Palmos Dr | 6 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | Width 3ft | 5998867.6092 | 2095887.4020200002 | 37.734842393562104 | -122.44634545 | (37.7348423935621, -122.44634545) | |||
| 132146 | 132146 | 218741 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 32 Los Palmos Dr | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | Width 3ft | 5998851.10975 | 2095900.2680400002 | 37.73487677824821 | -122.44640341939 | (37.7348767782482, -122.44640341939) | |||
| 61847 | 61847 | 218740 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 32 Los Palmos Dr | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | Width 3ft | 5998836.63311 | 2095909.61295 | 37.734901610308704 | -122.446454142063 | (37.7349016103087, -122.446454142063) | |||
| 153368 | 153368 | 218739 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 32 Los Palmos Dr | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | Width 3ft | 5998821.443390001 | 2095918.27736 | 37.7349245331257 | -122.446507281187 | (37.7349245331257, -122.446507281187) | |||
| 43628 | 43628 | 218738 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 32 Los Palmos Dr | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | Width 3ft | 5998805.22806 | 2095928.00663 | 37.734950321189 | -122.446564042812 | (37.734950321189, -122.446564042812) | |||
| 149374 | 149374 | 218737 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 32 Los Palmos Dr | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | Width 3ft | 5998790.02414 | 2095935.97535 | 37.7349713329455 | -122.446617181062 | (37.7349713329455, -122.446617181062) | |||
| 112387 | 112387 | 109194 | Property Tree 7 | Quercus agrifolia :: Coast Live Oak 180 | 4705 03rd St | Back Yard : Yard 13 | Tree 1 | Arts Commission 19 | 45 | 6015121.6 | 2095617.0 | 37.7350148477359 | -122.39013039721901 | (37.7350148477359, -122.390130397219) | |||||
| 119700 | 119700 | 100472 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 70 Stanford Heights Ave | Back Yard : Yard 13 | Tree 1 | Private 1 | 5997872.4 | 2096006.9 | 37.735113616296 | -122.44979482672899 | (37.735113616296, -122.449794826729) | ||||||
| 99073 | 99073 | 108311 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 439x ARLINGTON ST | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6003949.9 | 2096014.9 | 37.7354814316621 | -122.42878329168998 | (37.7354814316621, -122.42878329169) | |||||
| 142266 | 142266 | 98139 | Property Tree 7 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 556 Laidley St | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 6003085.0 | 2096041.0 | 37.7355041065287 | -122.431775438062 | (37.7355041065287, -122.431775438062) | |||||
| 883 | 883 | 251306 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1 Cashmere St | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 6017463.0 | 2095772.0 | 37.7355700327415 | -122.382046041696 | (37.7355700327415, -122.382046041696) | ||||
| 885 | 885 | 251305 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1 Cashmere St | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 6017463.0 | 2095772.0 | 37.7355700327415 | -122.382046041696 | (37.7355700327415, -122.382046041696) | ||||
| 887 | 887 | 251303 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1 Cashmere St | 2 | Back Yard : Yard 13 | Tree 1 | Health Dept 8 | 3x3 | 6017463.0 | 2095772.0 | 37.7355700327415 | -122.382046041696 | (37.7355700327415, -122.382046041696) | ||||
| 891 | 891 | 251304 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1 Cashmere St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | Health Dept 5 | 3x3 | 6017463.0 | 2095772.0 | 37.7355700327415 | -122.382046041696 | (37.7355700327415, -122.382046041696) | |||
| 896 | 896 | 251302 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1 Cashmere St | 1 | Back Yard : Yard 13 | Tree 1 | Health Dept 8 | 3x3 | 6017463.0 | 2095772.0 | 37.7355700327415 | -122.382046041696 | (37.7355700327415, -122.382046041696) | ||||
| 47731 | 47731 | 227663 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 6 Unnamed 011 | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 13 | Width 10ft | 6002739.4908 | 2096074.90228 | 37.735577602816896 | -122.432972414242 | (37.7355776028169, -122.432972414242) | |||
| 27928 | 27928 | 231945 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 33 Penny Ln | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 2 | Width 2ft | 6002666.1416 | 2096136.6991599998 | 37.7357431221521 | -122.433230424364 | (37.7357431221521, -122.433230424364) | |||
| 155248 | 155248 | 231944 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 33 Penny Ln | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 9 | Width 2ft | 6002664.28784 | 2096138.10096 | 37.7357468660117 | -122.43323693366001 | (37.7357468660117, -122.43323693366) | |||
| 155846 | 155846 | 231943 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 33 Penny Ln | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 1 | Width 2ft | 6002661.77062 | 2096140.53935 | 37.7357534184718 | -122.43324581083901 | (37.7357534184718, -122.433245810839) | |||
| 62808 | 62808 | 231942 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 31 Penny Ln | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | Width 2ft | 6002659.32372 | 2096145.42523 | 37.735766695166504 | -122.433254619725 | (37.7357666951665, -122.433254619725) | |||
| 132003 | 132003 | 231941 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 31 Penny Ln | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | Width 2ft | 6002655.75902 | 2096147.9144099997 | 37.7357733276597 | -122.43326712208 | (37.7357733276597, -122.43326712208) | |||
| 184761 | 184761 | 231940 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 31 Penny Ln | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | Width 2ft | 6002651.97591 | 2096151.4784799998 | 37.735782899162395 | -122.433280456348 | (37.7357828991624, -122.433280456348) | |||
| 13315 | 13315 | 187668 | Significant Tree 6 | Eriobotrya deflexa :: Bronze Loquat 49 | 100x OGDEN AVE | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6007659.0 | 2096105.0 | 37.7359380573488 | -122.41596587682 | (37.7359380573488, -122.41596587682) | |||||
| 46775 | 46775 | 224477 | Undocumented 2 | Ficus carica :: Edible Fig 201 | 23 Penny Ln | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 7 | Width 2ft | 6002584.32363 | 2096230.7970099999 | 37.735996851473296 | -122.43352002314501 | (37.7359968514733, -122.433520023145) | |||
| 183893 | 183893 | 240363 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 19 Ohlone Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | Width 2ft | 6002113.49716 | 2096265.44164 | 37.7360652530044 | -122.435150333941 | (37.7360652530044, -122.435150333941) | |||
| 30330 | 30330 | 233958 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 19 Penny Ln | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | Width 2ft | 6002544.64531 | 2096274.1188599998 | 37.73611355200129 | -122.433660302082 | (37.7361135520013, -122.433660302082) | |||
| 171592 | 171592 | 223338 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 17 Penny Ln | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 2 | Width 2ft | 6002542.32415 | 2096276.52832 | 37.736120036118706 | -122.433668499417 | (37.7361200361187, -122.433668499417) | |||
| 161192 | 161192 | 233957 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 15 Penny Ln | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | Width 2ft | 6002524.54294 | 2096295.7854099998 | 37.7361719027113 | -122.43373135214199 | (37.7361719027113, -122.433731352142) | |||
| 177217 | 177217 | 245789 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 13 Penny Ln | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 23 | Width 2ft | 6002510.68516 | 2096313.6496700002 | 37.736220167514404 | -122.433780540537 | (37.7362201675144, -122.433780540537) | |||
| 131366 | 131366 | 237944 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 26 Ohlone Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 15 | Width 2ft | 6002164.0262 | 2096336.8178599998 | 37.736264104808 | -122.43498073797701 | (37.736264104808, -122.434980737977) | |||
| 164865 | 164865 | 239558 | Undocumented 2 | Salix lasiolepis :: Arroyo willow 213 | 26 Ohlone Way | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 9 | Width 2ft | 6002169.792830001 | 2096347.5297 | 37.7362938444778 | -122.434961566227 | (37.7362938444778, -122.434961566227) | |||
| 433 | 433 | 251301 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 Whitney Young Cir | 2 | Back Yard : Yard 13 | Tree 1 | Mayor Office of Housing 7 | 3x3 | 6016360.0 | 2096059.0 | 37.736297099957106 | -122.385879567348 | (37.7362970999571, -122.385879567348) | ||||
| 474 | 474 | 251300 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 Whitney Young Cir | 1 | Back Yard : Yard 13 | Tree 1 | Health Dept 8 | 3x3 | 6016360.0 | 2096059.0 | 37.736297099957106 | -122.385879567348 | (37.7362970999571, -122.385879567348) | ||||
| 52362 | 52362 | 237943 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 22 Ohlone Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6 | Width 3ft | 6002178.91966 | 2096366.0304900003 | 37.7363451615923 | -122.43493133373501 | (37.7363451615923, -122.434931333735) | |||
| 163239 | 163239 | 220552 | Undocumented 2 | Aesculus californica :: California Buckeye 338 | 13 Ohlone Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | Width 3ft | 6002169.64489 | 2096371.31931 | 37.736359156858704 | -122.434963778568 | (37.7363591568587, -122.434963778568) | |||
| 122333 | 122333 | 97685 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 84 Coventry Ct | Back Yard : Yard 13 | Tree 1 | Private 1 | 5997084.0 | 2096485.0 | 37.7363812239889 | -122.452555087132 | (37.7363812239889, -122.452555087132) | ||||||
| 71286 | 71286 | 240425 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 5 Penny Ln | 7 | Back Yard : Yard 13 | Tree 1 | Private 1 | 2 | Width 2ft | 6002456.8751300005 | 2096374.3168900001 | 37.736383692152295 | -122.433970918943 | (37.7363836921523, -122.433970918943) | |||
| 73730 | 73730 | 240424 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 5 Penny Ln | 6 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | Width 2ft | 6002452.23233 | 2096379.1355 | 37.7363966594644 | -122.43398731536502 | (37.7363966594644, -122.433987315365) | |||
| 72621 | 72621 | 220551 | Undocumented 2 | Aesculus californica :: California Buckeye 338 | 11 Ohlone Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 21 | Width 5ft | 6002176.285680001 | 2096385.2225400002 | 37.736397708979794 | -122.434941812622 | (37.7363977089798, -122.434941812622) | |||
| 29920 | 29920 | 240423 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 5 Penny Ln | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 2 | Width 2ft | 6002449.92079 | 2096381.9214299999 | 37.7364041778047 | -122.433995506402 | (37.7364041778047, -122.433995506402) | |||
| 188488 | 188488 | 240422 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 5 Penny Ln | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | Width 2ft | 6002442.71855 | 2096389.33655 | 37.7364241292793 | -122.43402093743201 | (37.7364241292793, -122.434020937432) | |||
| 35387 | 35387 | 240421 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 5 Penny Ln | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 2 | Width 2ft | 6002440.8921300005 | 2096392.57557 | 37.736432919229706 | -122.43402748359101 | (37.7364329192297, -122.434027483591) | |||
| 134638 | 134638 | 233923 | Undocumented 2 | Persea americana :: Avocado 113 | 20 Ohlone Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | Width 2ft | 6002185.25785 | 2096400.06868 | 37.736438982481395 | -122.43491185351299 | (37.7364389824814, -122.434911853513) | |||
| 159982 | 159982 | 220096 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 5 Penny Ln | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | Width 2ft | 6002436.28409 | 2096397.8300700001 | 37.736447085360105 | -122.43404379100402 | (37.7364470853601, -122.434043791004) | |||
| 50796 | 50796 | 225251 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 20 Ohlone Way | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 1 | Width 2ft | 6002182.75585 | 2096407.15248 | 37.736458290902796 | -122.43492101042 | (37.7364582909028, -122.43492101042) | |||
| 166281 | 166281 | 220095 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 5 Penny Ln | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 7 | Width 2ft | 6002427.25103 | 2096406.93673 | 37.7364715774983 | -122.43407567285601 | (37.7364715774983, -122.434075672856) | |||
| 187310 | 187310 | 227505 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 11 Ohlone Way | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | Width 2ft | 6002170.3179 | 2096422.89629 | 37.7365008135581 | -122.434965139225 | (37.7365008135581, -122.434965139225) | |||
| 75944 | 75944 | 242822 | Undocumented 2 | Tree(s) :: 17 | 18 Ohlone Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 46 | Width 5ft | 6002178.85689 | 2096424.55585 | 37.7365058551638 | -122.434935735002 | (37.7365058551638, -122.434935735002) | |||
| 174189 | 174189 | 242821 | Undocumented 2 | Tree(s) :: 17 | 18 Ohlone Way | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 37 | Width 5ft | 6002176.86514 | 2096431.6975599998 | 37.7365253515621 | -122.43494313191499 | (37.7365253515621, -122.434943131915) | |||
| 27063 | 27063 | 233956 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 3 Penny Ln | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 1 | Width 2ft | 6002403.3233199995 | 2096434.7165299999 | 37.7365464964208 | -122.434160386288 | (37.7365464964208, -122.434160386288) | |||
| 45661 | 45661 | 233955 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 3 Penny Ln | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | Width 2ft | 6002401.2653 | 2096437.12023 | 37.736552979622104 | -122.434167673516 | (37.7365529796221, -122.434167673516) | |||
| 71556 | 71556 | 227504 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 16 Ohlone Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | Width 2ft | 6002174.41423 | 2096447.2518799999 | 37.7365679209746 | -122.434952717804 | (37.7365679209746, -122.434952717804) | |||
| 136411 | 136411 | 234911 | Undocumented 2 | Populus tremuloides :: Quaking aspen 166 | 3 Penny Ln | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 8 | Width 2ft | 6002388.89555 | 2096450.4938299998 | 37.736588998379105 | -122.434211396756 | (37.7365889983791, -122.434211396756) | |||
| 51612 | 51612 | 234910 | Undocumented 2 | Populus tremuloides :: Quaking aspen 166 | 1 Penny Ln | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 8 | Width 2ft | 6002382.22186 | 2096459.02703 | 37.73661204979621 | -122.43423508039301 | (37.7366120497962, -122.434235080393) | |||
| 143856 | 143856 | 106172 | Significant Tree 6 | Ulmus parvifolia :: Chinese Elm 46 | 150 CONRAD ST | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 14 | 6001768.8 | 2096480.0 | 37.7366348009068 | -122.43635744032801 | (37.7366348009068, -122.436357440328) | ||||
| 136660 | 136660 | 238536 | Undocumented 2 | Prunus spp :: Cherry 84 | 1 Penny Ln | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | Width 2ft | 6002355.478619999 | 2096490.80035 | 37.736697774076 | -122.434329814067 | (37.736697774076, -122.434329814067) | |||
| 110838 | 110838 | 107348 | Private 5 | Private shrub :: Private Shrub 64 | 260 LANSDALE AVE | 1 | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 5995019.0 | 2096651.7 | 37.7367204092857 | -122.459706678853 | (37.7367204092857, -122.459706678853) | |||||
| 141038 | 141038 | 102381 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 258 Molimo Dr | Back Yard : Yard 13 | Tree 1 | Private 1 | 5997615.0 | 2096604.0 | 37.7367383790998 | -122.450727783905 | (37.7367383790998, -122.450727783905) | ||||||
| 158375 | 158375 | 241152 | Undocumented 2 | Tibochina urvilleana :: Princess Flower 260 | 3 Ohlone Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | Width 3ft | 6002150.14382 | 2096511.4000799998 | 37.736742679035004 | -122.435041217385 | (37.736742679035, -122.435041217385) | |||
| 174735 | 174735 | 236183 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1 Penny Ln | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 7 | Width 2ft | 6002335.35488 | 2096511.4177599999 | 37.7367532424671 | -122.434400864109 | (37.7367532424671, -122.434400864109) | |||
| 149582 | 149582 | 231939 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1 Penny Ln | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | Width 2ft | 6002331.25514 | 2096517.0119 | 37.7367683699712 | -122.434415438526 | (37.7367683699712, -122.434415438526) | |||
| 43309 | 43309 | 231938 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1 Penny Ln | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | Width 2ft | 6002328.37989 | 2096518.1207400002 | 37.7367712513805 | -122.43442545876499 | (37.7367712513805, -122.434425458765) | |||
| 181159 | 181159 | 224265 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 58 Poppy Ln | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 38 | 6002671.84671 | 2096513.9082400003 | 37.7367791753169 | -122.433237644116 | (37.7367791753169, -122.433237644116) | ||||
| 54645 | 54645 | 245788 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 59 Poppy Ln | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 8 | Width 2ft | 6002650.36065 | 2096519.5995200002 | 37.736793583358605 | -122.433312337306 | (37.7367935833586, -122.433312337306) | |||
| 71023 | 71023 | 240631 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 57 Poppy Ln | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | Width 2ft | 6002629.35658 | 2096548.6301400003 | 37.7368721031581 | -122.433387031387 | (37.7368721031581, -122.433387031387) | |||
| 44939 | 44939 | 223816 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Ohlone Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 45 | Width 5ft | 6002135.08017 | 2096585.1811900001 | 37.7369444095655 | -122.435098574335 | (37.7369444095655, -122.435098574335) | |||
| 427 | 427 | 251307 | Undocumented 2 | Tree(s) :: 17 | 200 Cashmere St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 6016315.0 | 2096328.0 | 37.7370332293639 | -122.38605389871 | (37.7370332293639, -122.38605389871) | ||||
| 23859 | 23859 | 223337 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 21 Poppy Ln | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | Width 2ft | 6002002.72042 | 2096679.5859400001 | 37.737196106421706 | -122.435562951888 | (37.7371961064217, -122.435562951888) | |||
| 180684 | 180684 | 226835 | Undocumented 2 | Juglans regia :: Walnut: English 348 | 27 Poppy Ln | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | Width 2ft | 6002073.33297 | 2096755.10087 | 37.7374074632877 | -122.43532421245199 | (37.7374074632877, -122.435324212452) | |||
| 50449 | 50449 | 242820 | Undocumented 2 | Tree(s) :: 17 | 37 Poppy Ln | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 17 | Width 2ft | 6002456.61791 | 2096763.3951400002 | 37.7374519967974 | -122.4339996118 | (37.7374519967974, -122.4339996118) | |||
| 68761 | 68761 | 220550 | Undocumented 2 | Aesculus californica :: California Buckeye 338 | 37 Poppy Ln | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | Width 2ft | 6002449.94428 | 2096771.92833 | 37.737475048229705 | -122.43402329543801 | (37.7374750482297, -122.434023295438) | |||
| 160401 | 160401 | 227015 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 29 Poppy Ln | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 1 | Width 2ft | 6002114.09151 | 2096793.82616 | 37.7375161085743 | -122.43518606040399 | (37.7375161085743, -122.435186060404) | |||
| 165645 | 165645 | 227016 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 29 Poppy Ln | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | Width 2ft | 6002117.32476 | 2096797.30121 | 37.7375258338607 | -122.43517513003201 | (37.7375258338607, -122.435175130032) | |||
| 178882 | 178882 | 245780 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 21 Addison St | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 2 | Width 8ft | 6003583.611880001 | 2096848.84807 | 37.7377505249636 | -122.430109160821 | (37.7377505249636, -122.430109160821) | |||
| 184872 | 184872 | 245779 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 21 Addison St | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | Width 8ft | 6003578.068469999 | 2096849.2280400002 | 37.73775125431 | -122.430128354157 | (37.73775125431, -122.430128354157) | |||
| 43212 | 43212 | 245782 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 21 Addison St | 8 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6 | Width 8ft | 6003599.488059999 | 2096849.28505 | 37.7377526239794 | -122.43005430038299 | (37.7377526239794, -122.430054300383) | |||
| 160995 | 160995 | 245783 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 21 Addison St | 10 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6 | Width 8ft | 6003607.92987 | 2096849.5108400001 | 37.73775372205 | -122.430025129081 | (37.73775372205, -122.430025129081) | |||
| 183987 | 183987 | 245781 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 21 Addison St | 6 | Back Yard : Yard 13 | Tree 1 | Private 1 | 17 | Width 8ft | 6003587.5616 | 2096850.22083 | 37.7377545179491 | -122.43009560263799 | (37.7377545179491, -122.430095602638) | |||
| 38814 | 38814 | 221775 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 21 Addison St | 14 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10 | Width 3ft | 6003667.46569 | 2096848.61536 | 37.737754634878 | -122.429819221204 | (37.737754634878, -122.429819221204) | |||
| 54919 | 54919 | 237847 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 21 Addison St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6 | Width 8ft | 6003573.70242 | 2096850.7481 | 37.7377551807635 | -122.430143558104 | (37.7377551807635, -122.430143558104) | |||
| 176501 | 176501 | 245784 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 21 Addison St | 11 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | Width 4ft | 6003626.79774 | 2096849.74169 | 37.7377554244689 | -122.429959910226 | (37.7377554244689, -122.429959910226) | |||
| 27714 | 27714 | 237848 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 21 Addison St | 7 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6 | Width 8ft | 6003593.08721 | 2096850.61715 | 37.7377559191042 | -122.430076526206 | (37.7377559191042, -122.430076526206) | |||
| 43026 | 43026 | 245785 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 21 Addison St | 12 | Back Yard : Yard 13 | Tree 1 | Private 1 | 2 | Width 4ft | 6003634.59217 | 2096849.8681700001 | 37.7377562131711 | -122.42993297014401 | (37.7377562131711, -122.429932970144) | |||
| 177983 | 177983 | 245778 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 21 Addison St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 11 | Width 8ft | 6003567.005919999 | 2096851.6434799999 | 37.7377572599929 | -122.43016677498899 | (37.7377572599929, -122.430166774989) | |||
| 162015 | 162015 | 245786 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 21 Addison St | 13 | Back Yard : Yard 13 | Tree 1 | Private 1 | 2 | Width 3ft | 6003641.8158599995 | 2096850.294 | 37.73775779149221 | -122.429908024732 | (37.7377577914922, -122.429908024732) | |||
| 101635 | 101635 | 121104 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 477 Myra Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 5997298.0 | 2097021.0 | 37.7378652095891 | -122.45185385938998 | (37.7378652095891, -122.45185385939) | ||||
| 96118 | 96118 | 119911 | Undocumented 2 | Tree(s) :: 17 | 67 Rebecca Ln | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 6017125.0 | 2096711.0 | 37.7381296664541 | -122.383279988851 | (37.7381296664541, -122.383279988851) | ||||
| 91632 | 91632 | 87216 | Significant Tree 6 | Robinia x ambigua 'Idahoensis' :: Idaho Pink Locust 502 | 500 Cortland Ave | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 02/08/2008 12:00:00 AM | 3x3 | Permit Number 50224 | 6007640.7 | 2097187.4 | 37.7389090609704 | -122.416105779709 | (37.7389090609704, -122.416105779709) | ||
| 101276 | 101276 | 62912 | Significant Tree 6 | Robinia x ambigua 'Idahoensis' :: Idaho Pink Locust 502 | 500 Cortland Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 02/08/2008 12:00:00 AM | 3x3 | Permit Number 50224 | 6007523.90359428 | 2097218.90762974 | 37.7389890062486 | -122.416511839888 | (37.7389890062486, -122.416511839888) | ||
| 114948 | 114948 | 113440 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 190 BEACON ST | Back Yard : Yard 13 | Tree 1 | Private 1 | 32 | 3x3 | 6003193.0 | 2097540.0 | 37.739626138558705 | -122.43150902083299 | (37.7396261385587, -122.431509020833) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");