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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 496 | 496 | 245474 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 275 Grattan St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 19 | Width 4ft | 5997377.53226 | 2106405.56262 | 37.7636374489232 | -122.452255843041 | (37.7636374489232, -122.452255843041) | |||
| 514 | 514 | 251312 | Undocumented 2 | :: 54 | 1499 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003369.0 | 2099547.0 | 37.7451468706327 | -122.431043696183 | (37.7451468706327, -122.431043696183) | ||||
| 523 | 523 | 247328 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 696X Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 6003691.2873 | 2110070.3794 | 37.774059815342795 | -122.430680081912 | (37.7740598153428, -122.430680081912) | |||
| 537 | 537 | 195070 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1532 Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008830.0 | 2108632.0 | 37.7704001487298 | -122.41280261366998 | (37.7704001487298, -122.41280261367) | |||
| 539 | 539 | 206615 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 198 Vasquez Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | Permit Number 779324 | 5994758.52704 | 2099346.29484 | 37.7441041156281 | -122.460802465585 | (37.7441041156281, -122.460802465585) | ||
| 541 | 541 | 251317 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 399X 12th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008830.0 | 2108632.0 | 37.7704001487298 | -122.41280261366998 | (37.7704001487298, -122.41280261367) | ||||
| 545 | 545 | 251322 | Undocumented 2 | Betula spp :: Birch 95 | 828 Foerster St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Width 3ft | 5998302.82159 | 2096489.58159 | 37.7364635618398 | -122.448341458403 | (37.7364635618398, -122.448341458403) | ||||
| 549 | 549 | 251321 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 100X Monument Way | 1 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | ||||||||||
| 552 | 552 | 194122 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 963 Minna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007973.0 | 2110046.0 | 37.77423451911571 | -122.41586713001399 | (37.7742345191157, -122.415867130014) | |||
| 553 | 553 | 206616 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 198 Vasquez Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | Permit Number 779324 | 5994742.56026 | 2099334.6803900003 | 37.7440713065495 | -122.460856833195 | (37.7440713065495, -122.460856833195) | ||
| 557 | 557 | 194124 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 963 Minna St | 3 | Sidewalk: Curb side : Hanging Pot 15 | Tree 1 | Private 1 | 9 | Width 3ft | 6007973.0 | 2110046.0 | 37.77423451911571 | -122.41586713001399 | (37.7742345191157, -122.415867130014) | |||
| 558 | 558 | 251320 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 35 Park St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 3ft | 6004965.06472 | 2096463.48809 | 37.7367705580153 | -122.425305393447 | (37.7367705580153, -122.425305393447) | ||||
| 560 | 560 | 131782 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 2646 Union St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | Permit Number 779549 | 6000337.27442 | 2118211.39807 | 37.7962223607332 | -122.442866875924 | (37.7962223607332, -122.442866875924) | ||
| 561 | 561 | 204410 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 450x Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5992920.0 | 2104601.0 | 37.7584262276473 | -122.46754168203998 | (37.7584262276473, -122.46754168204) | |||
| 565 | 565 | 206617 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 198 Garcia Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5994686.63181 | 2099351.09779 | 37.7441131663853 | -122.461051409618 | (37.7441131663853, -122.461051409618) | |||
| 567 | 567 | 195068 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1532 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008830.0 | 2108632.0 | 37.7704001487298 | -122.41280261366998 | (37.7704001487298, -122.41280261367) | |||
| 569 | 569 | 194126 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 963 Minna St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007973.0 | 2110046.0 | 37.77423451911571 | -122.41586713001399 | (37.7742345191157, -122.415867130014) | |||
| 571 | 571 | 206618 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 198 Garcia Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | Permit Number 779324 | 5994673.79551 | 2099409.87557 | 37.7442738167873 | -122.461100053935 | (37.7442738167873, -122.461100053935) | ||
| 572 | 572 | 194125 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 963 Minna St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007973.0 | 2110046.0 | 37.77423451911571 | -122.41586713001399 | (37.7742345191157, -122.415867130014) | |||
| 573 | 573 | 194127 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 963 Minna St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007973.0 | 2110046.0 | 37.77423451911571 | -122.41586713001399 | (37.7742345191157, -122.415867130014) | |||
| 574 | 574 | 194128 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 963 Minna St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007973.0 | 2110046.0 | 37.77423451911571 | -122.41586713001399 | (37.7742345191157, -122.415867130014) | |||
| 575 | 575 | 194123 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 963 Minna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007973.0 | 2110046.0 | 37.77423451911571 | -122.41586713001399 | (37.7742345191157, -122.415867130014) | |||
| 588 | 588 | 251328 | Undocumented 2 | Tree(s) :: 17 | 95x Tompkins Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 779511 | 6007651.0 | 2096616.0 | 37.7373407014575 | -122.416029712695 | (37.7373407014575, -122.416029712695) | |||
| 592 | 592 | 251331 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2232 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003295.0 | 2116396.0 | 37.791405922266996 | -122.43250281523301 | (37.791405922267, -122.432502815233) | ||||
| 593 | 593 | 140072 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 601X Octavia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6005402.0 | 2111410.0 | 37.7778348570605 | -122.424857751543 | (37.7778348570605, -122.424857751543) | |||
| 594 | 594 | 140071 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 601X Octavia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6005402.0 | 2111410.0 | 37.7778348570605 | -122.424857751543 | (37.7778348570605, -122.424857751543) | |||
| 599 | 599 | 251330 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2232 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003295.0 | 2116396.0 | 37.791405922266996 | -122.43250281523301 | (37.791405922267, -122.432502815233) | ||||
| 608 | 608 | 233928 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 8 Octavia St Frontage East | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 29 | Width 8ft | 6005775.18179 | 2109348.30824 | 37.77219502161479 | -122.423420179704 | (37.7721950216148, -122.423420179704) | |||
| 611 | 611 | 140070 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 601X Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6005402.0 | 2111410.0 | 37.7778348570605 | -122.424857751543 | (37.7778348570605, -122.424857751543) | |||
| 623 | 623 | 192249 | Undocumented 2 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 450 11th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | Permit Number 779594 | 6009343.40252 | 2108323.7349799997 | 37.7695825279367 | -122.411004969605 | (37.7695825279367, -122.411004969605) | ||
| 635 | 635 | 251315 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 399X 12th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008830.0 | 2108632.0 | 37.7704001487298 | -122.41280261366998 | (37.7704001487298, -122.41280261367) | ||||
| 637 | 637 | 192270 | Undocumented 2 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 450 11th St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | Permit Number 779594 | 6009046.84186 | 2108631.36839 | 37.770410583217505 | -122.41205250981199 | (37.7704105832175, -122.412052509812) | ||
| 644 | 644 | 251319 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 399X 12th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008830.0 | 2108632.0 | 37.7704001487298 | -122.41280261366998 | (37.7704001487298, -122.41280261367) | ||||
| 645 | 645 | 251316 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 399X 12th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008830.0 | 2108632.0 | 37.7704001487298 | -122.41280261366998 | (37.7704001487298, -122.41280261367) | ||||
| 651 | 651 | 251359 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4050 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5994421.0 | 2112898.0 | 37.7812941506761 | -122.462952553035 | (37.7812941506761, -122.462952553035) | ||||
| 653 | 653 | 144739 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 510 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 3ft | 5989096.969740001 | 2111833.32857 | 37.7780627562405 | -122.481292881664 | (37.7780627562405, -122.481292881664) | |||
| 655 | 655 | 251353 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 510 22nd Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 3ft | 5989096.969740001 | 2111833.32857 | 37.7780627562405 | -122.481292881664 | (37.7780627562405, -122.481292881664) | ||||
| 658 | 658 | 147406 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 515 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | 6x10 | 5989054.53583 | 2111789.60329 | 37.7779402316839 | -122.48143647103201 | (37.7779402316839, -122.481436471032) | |||
| 662 | 662 | 206411 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 241 Ortega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | Permit Number 779935 | 5993240.35303 | 2102520.36003 | 37.752731819221 | -122.466282559112 | (37.752731819221, -122.466282559112) | ||
| 667 | 667 | 251356 | Undocumented 2 | :: 54 | 519 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5989039.0 | 2111772.0 | 37.777890994652296 | -122.481488924787 | (37.7778909946523, -122.481488924787) | ||||
| 692 | 692 | 176334 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 287 Hester Ave | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 34 | 6012223.87562 | 2087782.5469900002 | 37.713341893097 | -122.399599040764 | (37.713341893097, -122.399599040764) | ||||
| 697 | 697 | 251362 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 1300X Stanyan St | 1 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 3x3 | 5997565.0 | 2104877.0 | 37.7594511396077 | -122.451497194349 | (37.7594511396077, -122.451497194349) | ||||
| 701 | 701 | 176335 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 287 Hester Ave | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 17 | 6012233.93602 | 2087774.2056900002 | 37.7133195503322 | -122.399563683027 | (37.7133195503322, -122.399563683027) | ||||
| 752 | 752 | 251380 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 731 Huron Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2x5 | 5997668.0 | 2087467.0 | 37.7116533538928 | -122.449886244657 | (37.7116533538928, -122.449886244657) | ||||
| 761 | 761 | 195041 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 402 06th St | 1 | : 4 | Tree 1 | DPW 2 | 28 | Width 3ft | 6011480.36813 | 2111044.01847 | 37.777171403968296 | -122.40380468436199 | (37.7771714039683, -122.403804684362) | |||
| 767 | 767 | 251382 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 731 Huron Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2x5 | 5997668.0 | 2087467.0 | 37.7116533538928 | -122.449886244657 | (37.7116533538928, -122.449886244657) | ||||
| 769 | 769 | 110848 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2668 Vallejo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | Permit Number 778643 | 6000804.34505 | 2117582.1485 | 37.7945212238167 | -122.441205550194 | (37.7945212238167, -122.441205550194) | ||
| 777 | 777 | 234744 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2455 15th St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12 | Width 3ft | 6001486.4222099995 | 2107220.2274599997 | 37.766108846174795 | -122.438102867577 | (37.7661088461748, -122.438102867577) | |||
| 780 | 780 | 251383 | Undocumented 2 | Persea americana :: Avocado 113 | 49x Milan Ter | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 5997587.0 | 2087495.0 | 37.711725600519706 | -122.450168218052 | (37.7117256005197, -122.450168218052) | ||||
| 782 | 782 | 251385 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 138x Gladeview Way | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5997939.0 | 2102166.0 | 37.7520288182083 | -122.45000833213699 | (37.7520288182083, -122.450008332137) | ||||
| 783 | 783 | 251381 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 731 Huron Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2x5 | 5997668.0 | 2087467.0 | 37.7116533538928 | -122.449886244657 | (37.7116533538928, -122.449886244657) | ||||
| 784 | 784 | 251384 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 138x Gladeview Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5997939.0 | 2102166.0 | 37.7520288182083 | -122.45000833213699 | (37.7520288182083, -122.450008332137) | ||||
| 795 | 795 | 140241 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 160 Ashbury St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5998775.6798 | 2110202.3294 | 37.7741424035345 | -122.44769344620701 | (37.7741424035345, -122.447693446207) | |||
| 810 | 810 | 212202 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 800 Bosworth St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 6001677.26505 | 2095571.4535400001 | 37.734134940976 | -122.43660890297501 | (37.734134940976, -122.436608902975) | ||||
| 818 | 818 | 251389 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 202x Mangels Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5999774.0 | 2095231.0 | 37.7330917931436 | -122.44316462438499 | (37.7330917931436, -122.443164624385) | ||||
| 834 | 834 | 140247 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 Ashbury St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5998760.3863 | 2110325.7376 | 37.77448037673879 | -122.447755234881 | (37.7744803767388, -122.447755234881) | |||
| 851 | 851 | 234149 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3652 23rd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6005288.48907 | 2102558.72214 | 37.753524945734 | -122.42462062893601 | (37.753524945734, -122.424620628936) | |||
| 855 | 855 | 251398 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 299 Townsend St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6013957.0 | 2110872.0 | 37.776837125863 | -122.39522511301901 | (37.776837125863, -122.395225113019) | ||||
| 858 | 858 | 251395 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 2101 26th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6012226.0 | 2101445.0 | 37.750856267744496 | -122.400550836744 | (37.7508562677445, -122.400550836744) | |||||
| 859 | 859 | 251396 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 299 Townsend St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6013957.0 | 2110872.0 | 37.776837125863 | -122.39522511301901 | (37.776837125863, -122.395225113019) | ||||
| 860 | 860 | 189218 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 72 Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Width 4ft | 6016946.50299 | 2094945.8896700002 | 37.7332731602285 | -122.38377428587299 | (37.7332731602285, -122.383774285873) | |||
| 861 | 861 | 109545 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300x Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6006870.4118800005 | 2111707.44564 | 37.778734401395205 | -122.419799104459 | (37.7787344013952, -122.419799104459) | |||
| 865 | 865 | 142552 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 401 FRANCISCO ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6009334.5084 | 2121154.0569 | 37.804811003675105 | -122.411942539139 | (37.8048110036751, -122.411942539139) | |||
| 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) | |||
| 892 | 892 | 251400 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 101 Rhine St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | Width 3ft | 5994375.43496 | 2086552.5575599999 | 37.7089535675334 | -122.461199910156 | (37.7089535675334, -122.461199910156) | ||||
| 895 | 895 | 209148 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 217 Hugo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 5995023.415709999 | 2107016.68952 | 37.7651803042563 | -122.46044222322901 | (37.7651803042563, -122.460442223229) | |||
| 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) | ||||
| 900 | 900 | 140947 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2060 Ofarrell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 6001488.0 | 2113369.0 | 37.7829919235948 | -122.438538008913 | (37.7829919235948, -122.438538008913) | |||
| 902 | 902 | 140944 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2060 Ofarrell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 6001488.0 | 2113369.0 | 37.7829919235948 | -122.438538008913 | (37.7829919235948, -122.438538008913) | |||
| 904 | 904 | 140946 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2060 Ofarrell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6001488.0 | 2113369.0 | 37.7829919235948 | -122.438538008913 | (37.7829919235948, -122.438538008913) | |||
| 907 | 907 | 140952 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2060 Ofarrell St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 6001488.0 | 2113369.0 | 37.7829919235948 | -122.438538008913 | (37.7829919235948, -122.438538008913) | |||
| 908 | 908 | 206337 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 240 Noriega St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 5ft | 5993194.556580001 | 2103260.73418 | 37.7547620531274 | -122.466494737945 | (37.7547620531274, -122.466494737945) | |||
| 912 | 912 | 137817 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2001 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6004275.6077 | 2115310.8412 | 37.7884819087987 | -122.429032528237 | (37.7884819087987, -122.429032528237) | |||
| 913 | 913 | 107355 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2001 Grant Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6010310.1611 | 2121354.7321 | 37.8054166971664 | -122.40858034027201 | (37.8054166971664, -122.408580340272) | |||
| 915 | 915 | 140945 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2060 Ofarrell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 0ft | 6001488.0 | 2113369.0 | 37.7829919235948 | -122.438538008913 | (37.7829919235948, -122.438538008913) | |||
| 918 | 918 | 206336 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 240 Noriega St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 5ft | 5993226.58531 | 2103261.3034200002 | 37.7547654642635 | -122.46638401611 | (37.7547654642635, -122.46638401611) | |||
| 919 | 919 | 140949 | Undocumented 2 | Eucalyptus robusta :: Swamp mahogany 122 | 2060 Ofarrell St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6001488.0 | 2113369.0 | 37.7829919235948 | -122.438538008913 | (37.7829919235948, -122.438538008913) | |||
| 920 | 920 | 206335 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 240 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 5ft | 5993241.59075 | 2103263.0584299997 | 37.7547711488889 | -122.466332251156 | (37.7547711488889, -122.466332251156) | |||
| 922 | 922 | 140943 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2060 Ofarrell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 0ft | 6001488.0 | 2113369.0 | 37.7829919235948 | -122.438538008913 | (37.7829919235948, -122.438538008913) | |||
| 923 | 923 | 210740 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 146 Ramsell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5992981.0390099995 | 2088189.5314 | 37.7133679617255 | -122.46613798048901 | (37.7133679617255, -122.466137980489) | |||
| 924 | 924 | 214223 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 207 Mangels Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5999983.92895 | 2095213.9818900002 | 37.7330570333525 | -122.44243762501199 | (37.7330570333525, -122.442437625012) | |||
| 925 | 925 | 139814 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1652 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 0ft | 6002517.0 | 2112708.0 | 37.7812354643217 | -122.434930809638 | (37.7812354643217, -122.434930809638) | |||
| 927 | 927 | 140951 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2060 Ofarrell St | 9 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 15 | Width 0ft | 6001488.0 | 2113369.0 | 37.7829919235948 | -122.438538008913 | (37.7829919235948, -122.438538008913) | |||
| 929 | 929 | 140950 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2060 Ofarrell St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 0ft | 6001488.0 | 2113369.0 | 37.7829919235948 | -122.438538008913 | (37.7829919235948, -122.438538008913) | |||
| 930 | 930 | 206338 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 240 Noriega St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 5ft | 5993167.1259699995 | 2103261.31068 | 37.7547620531391 | -122.466589641618 | (37.7547620531391, -122.466589641618) | |||
| 933 | 933 | 203966 | Undocumented 2 | Tree(s) :: 17 | 200 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | Permit Number 779992 | 5992562.812059999 | 2097843.65033 | 37.739851654243296 | -122.46828540055901 | (37.7398516542433, -122.468285400559) | ||
| 934 | 934 | 251409 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 95x Andover St | 1 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 3x3 | 6007642.0 | 2098274.0 | 37.741892697320296 | -122.41617822056101 | (37.7418926973203, -122.416178220561) | ||||
| 955 | 955 | 251402 | Undocumented 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 190 University St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007981.0 | 2093052.0 | 37.7275732783897 | -122.41463660892599 | (37.7275732783897, -122.414636608926) | ||||
| 961 | 961 | 251408 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 75 Christmas Tree Point Rd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998776.0 | 2103023.0 | 37.75442978774979 | -122.447175546291 | (37.7544297877498, -122.447175546291) | ||||
| 967 | 967 | 251416 | Undocumented 2 | Potential Site :: Potential Site 29 | 10x Jones St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009207.0 | 2112641.0 | 37.7814290728676 | -122.411781887248 | (37.7814290728676, -122.411781887248) | ||||
| 998 | 998 | 106624 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 156 Commonwealth Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x6 | Permit Number 778450 | 5996579.9247 | 2113340.3647 | 37.78263288517989 | -122.455515759177 | (37.7826328851799, -122.455515759177) | ||
| 999 | 999 | 251422 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 480x De Long St | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 5992963.0 | 2086633.0 | 37.709093057147996 | -122.466087289133 | (37.709093057148, -122.466087289133) | |||||
| 1000 | 1000 | 133103 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2401 Larkin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006658.0 | 2119469.0 | 37.8000337406718 | -122.42108517312599 | (37.8000337406718, -122.421085173126) | |||
| 1006 | 1006 | 232567 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 947 Elizabeth St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 4ft | 6000330.76798 | 2101953.15424 | 37.751580964011204 | -122.441721996685 | (37.7515809640112, -122.441721996685) | |||
| 1029 | 1029 | 251428 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 5030 Diamond Heights Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5999555.0 | 2100128.0 | 37.7465253005744 | -122.444273545879 | (37.7465253005744, -122.444273545879) | ||||
| 1034 | 1034 | 251427 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 5028 Diamond Heights Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5999606.0 | 2100130.0 | 37.7465337016449 | -122.44409733772801 | (37.7465337016449, -122.444097337728) | ||||
| 1047 | 1047 | 200448 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2585 03rd St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6015917.22039 | 2103323.37431 | 37.7562190555923 | -122.387917198143 | (37.7562190555923, -122.387917198143) |
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");