Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qSiteInfo, qCaretaker, PlantDate, DBH, PlotSize, PermitNotes
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 78 | 78 | 251199 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 900X 14th St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3X3 | 6002515.0 | 2107976.0 | 37.768242455454995 | -122.43459927073098 | (37.768242455455, -122.434599270731) | ||||
| 277 | 277 | 251265 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 3630x 19th Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 779147 | |||||||||
| 363 | 363 | 119608 | Significant Tree 6 | Cupressocyparis leylandii :: Leyland Cypress 34 | 299x Avalon Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | ||||||||||
| 1631 | 1631 | 251621 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 72R Amber Dr | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999318.0 | 2100030.0 | 37.746242691915 | -122.445086018875 | (37.746242691915, -122.445086018875) | |||||
| 1708 | 1708 | 251660 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1050 North Point St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x6 | 6005628.0 | 2121390.0 | 37.8052501972152 | -122.424786108187 | (37.8052501972152, -122.424786108187) | ||||
| 1935 | 1935 | 252836 | Significant Tree 6 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 98 Prosper St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6003330.0 | 2106021.0 | 37.7629207320267 | -122.43164067381399 | (37.7629207320267, -122.431640673814) | |||||
| 1947 | 1947 | 252825 | Significant Tree 6 | Ilex spp :: Holly Species 163 | 3852 17th St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6003330.0 | 2106021.0 | 37.7629207320267 | -122.43164067381399 | (37.7629207320267, -122.431640673814) | |||||
| 2854 | 2854 | 253253 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 99X Lopez Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10x10 | 5994049.0 | 2100330.0 | 37.746764271907 | -122.46332720271201 | (37.746764271907, -122.463327202712) | ||||
| 3811 | 3811 | 177743 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 401 Ocean Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | MTA 6 | 37 | 5998700.41574 | 2091522.98281 | 37.722849171448395 | -122.446609585371 | (37.7228491714484, -122.446609585371) | ||||
| 4549 | 4549 | 226945 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 998 Chenery St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 1ft | 6001140.61217 | 2096125.6115299999 | 37.735626018710896 | -122.438503967885 | (37.7356260187109, -122.438503967885) | |||
| 9743 | 9743 | 173674 | Significant Tree 6 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 299x Beale St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014575.0 | 2115523.0 | 37.789642061391 | -122.39341281176901 | (37.789642061391, -122.393412811769) | ||||
| 12113 | 12113 | 103660 | Significant Tree 6 | Tree(s) :: 17 | 350X Hickory St | 4 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 06/07/2013 12:00:00 AM | Permit Number 770306 | |||||||
| 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) | |||||
| 15902 | 15902 | 108047 | Significant Tree 6 | Ginkgo biloba :: Maidenhair Tree 44 | 1301 Evans Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2015 12:00:00 AM | 3 | 3x3 | 6017036.144669999 | 2097442.01922 | 37.7401319873023 | -122.383638088928 | (37.7401319873023, -122.383638088928) | ||
| 54137 | 54137 | 106873 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 38 08th St | 4 | Front Yard : Cutout 8 | Tree 1 | Private 1 | Permit Number 769156 | 6008506.93846 | 2111466.3623599997 | 37.7781645006636 | -122.41412064163201 | (37.7781645006636, -122.414120641632) | ||||
| 58626 | 58626 | 101743 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 15 | 1590 Broadway | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/21/2012 12:00:00 AM | 12 | Permit Number 769428 | 6006129.33795 | 2117976.30804 | 37.795905370388205 | -122.422808406898 | (37.7959053703882, -122.422808406898) | ||
| 66608 | 66608 | 113772 | Significant Tree 6 | Magnolia grandiflora :: Southern Magnolia 21 | 2550 Broadway | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 4 | 6001375.31674 | 2117310.7972 | 37.793808671186106 | -122.439210462719 | (37.7938086711861, -122.439210462719) | ||||
| 78513 | 78513 | 113727 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 1580 Valencia St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006496.0 | 2100402.0 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | |||||
| 78531 | 78531 | 104869 | Significant Tree 6 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 411 Holladay Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 770735 | 6010309.7 | 2098610.5 | 37.7429662928376 | -122.406977848202 | (37.7429662928376, -122.406977848202) | ||||
| 79254 | 79254 | 104682 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 33 08th St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 770764 | 6008457.3 | 2111569.1 | 37.7784438055662 | -122.414299630615 | (37.7784438055662, -122.414299630615) | ||||
| 80545 | 80545 | 114228 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 140 | 99x FONT BLVD | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 5990948.0 | 2088640.0 | 37.71448733391829 | -122.473197635313 | (37.7144873339183, -122.473197635313) | ||||
| 84536 | 84536 | 106945 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 1150 LOMBARD ST | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | Permit Number 773092 | 6006825.0 | 2120436.8 | 37.8027004869705 | -122.420576026126 | (37.8027004869705, -122.420576026126) | |||
| 85774 | 85774 | 100552 | Significant Tree 6 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 4443 19th St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6001193.1 | 2104609.9 | 37.7589248414166 | -122.43893032447399 | (37.7589248414166, -122.438930324474) | |||||
| 85903 | 85903 | 105084 | Significant Tree 6 | :: 54 | 344 Fulton St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006101.8 | 2111789.5 | 37.778916373563206 | -122.42246386857201 | (37.7789163735632, -122.422463868572) | |||||
| 86774 | 86774 | 122640 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 3630X 19th Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x8 | 5990614.0 | 2091411.0 | 37.7220764711857 | -122.47455416918999 | (37.7220764711857, -122.47455416919) | ||||
| 87119 | 87119 | 112572 | Significant Tree 6 | Cordyline australis :: Dracena Palm 141 | 162 GRAND VIEW AVE | 4 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 6000754.0 | 2103380.0 | 37.7555228430156 | -122.440360729392 | (37.7555228430156, -122.440360729392) | ||||
| 87953 | 87953 | 105869 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 3555 Cesar Chavez St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006336.4 | 2100501.8 | 37.7479362343406 | -122.420850697466 | (37.7479362343406, -122.420850697466) | |||||
| 89334 | 89334 | 116094 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 300x EXECUTIVE PARK BLVD | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014482.0 | 2086919.0 | 37.7110963749119 | -122.39173377323799 | (37.7110963749119, -122.391733773238) | ||||
| 89972 | 89972 | 114147 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1200x JUNIPERO SERRA BLVD | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 91812 | 91812 | 107986 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 2401x SCOTT ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001257.0 | 2116757.0 | 37.7922813550603 | -122.439580129378 | (37.7922813550603, -122.439580129378) | ||||
| 93266 | 93266 | 114407 | Significant Tree 6 | Calocedrus decurrens :: Incense Cedar 177 | 500X ARBALLO DR | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5987859.0 | 2089716.0 | 37.7172624174607 | -122.483953179035 | (37.7172624174607, -122.483953179035) | ||||
| 96972 | 96972 | 120593 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 499x Ocean Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 34 | 3x3 | 5998874.0 | 2091543.0 | 37.722914047867604 | -122.446010982458 | (37.7229140478676, -122.446010982458) | |||
| 100981 | 100981 | 103655 | Significant Tree 6 | Tree(s) :: 17 | 307X Octavia St | 4 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | 06/07/2013 12:00:00 AM | Permit Number 770306 | 6005538.74006 | 2110314.2033599997 | 37.7748337884081 | -122.424306762839 | (37.7748337884081, -122.424306762839) | |||
| 101280 | 101280 | 113045 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 500 RAYMOND AVE | 4 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | 6008527.0 | 2088690.0 | 37.7156268060035 | -122.412440877248 | (37.7156268060035, -122.412440877248) | ||||
| 102851 | 102851 | 121175 | Significant Tree 6 | Tree(s) :: 17 | 950 Duncan St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6000333.0 | 2099683.0 | 37.7453477932295 | -122.44155138616101 | (37.7453477932295, -122.441551386161) | ||||
| 102985 | 102985 | 110842 | Significant Tree 6 | Tree(s) :: 17 | 2037 TURK BLVD | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6000252.0 | 2111948.0 | 37.779019836036206 | -122.442711981138 | (37.7790198360362, -122.442711981138) | |||||
| 103556 | 103556 | 102074 | Significant Tree 6 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 273 Magellan Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5994674.1 | 2100293.4 | 37.7466997707371 | -122.461163031194 | (37.7466997707371, -122.461163031194) | |||||
| 104788 | 104788 | 121183 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1000x Duncan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 775289 | 5999834.0 | 2099740.0 | 37.7454758595085 | -122.44328093408899 | (37.7454758595085, -122.443280934089) | |||
| 105295 | 105295 | 111766 | Significant Tree 6 | Taxodium mucronatum :: Montezuma Cypress 333 | 1860 HAYES ST | 4 | Front Yard : Yard 7 | Tree 1 | SFUSD 4 | 5998973.0 | 2110255.0 | 37.774298298931704 | -122.44701467467199 | (37.7742982989317, -122.447014674672) | |||||
| 105346 | 105346 | 115752 | Significant Tree 6 | Acer rubrum :: Red Maple 6 | 100 Yerba Buena Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776558 | 5994139.5 | 2096643.4 | 37.7366470041966 | -122.462746867769 | (37.7366470041966, -122.462746867769) | ||
| 107460 | 107460 | 121171 | Significant Tree 6 | Tree(s) :: 17 | 900x Duncan St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6000584.0 | 2099647.0 | 37.745263242779004 | -122.44068088983101 | (37.745263242779, -122.440680889831) | ||||
| 107857 | 107857 | 94299 | Significant Tree 6 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 1150X Fillmore St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Rec/Park 3 | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | |||||
| 108305 | 108305 | 107139 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 700X Stevenson St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/31/2014 12:00:00 AM | Permit Number 769156 | 6008444.340419999 | 2111440.4280000003 | 37.778089774899705 | -122.41433535624701 | (37.7780897748997, -122.414335356247) | |||
| 108310 | 108310 | 121160 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 350x Octavia St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6005623.0 | 2110494.0 | 37.7753322239184 | -122.42402807847701 | (37.7753322239184, -122.424028078477) | |||||
| 108992 | 108992 | 88147 | Significant Tree 6 | Tree(s) :: 17 | 1475 Fillmore St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2000 12:00:00 AM | 3x3 | Permit Number 51176 | 6003147.8 | 2113351.1 | 37.7830370509294 | -122.43279450975001 | (37.7830370509294, -122.43279450975) | ||
| 110125 | 110125 | 116836 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 1750 Geneva Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6004521.4 | 2087037.7 | 37.710864341935 | -122.42616849363998 | (37.710864341935, -122.42616849364) | |||||
| 110409 | 110409 | 98703 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 7070@ 32nd Ave California St | 4 | Front Yard : 25 | Tree 1 | Private 1 | 03/10/2012 12:00:00 AM | Permit Number 767466 | 5985659.5 | 2114437.4 | 37.7850123376907 | -122.49337605842699 | (37.7850123376907, -122.493376058427) | |||
| 111156 | 111156 | 116535 | Significant Tree 6 | Tree(s) :: 17 | 598x MOUNT VERNON AVE | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 05/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777833 | 5997754.0 | 2090179.0 | 37.7191048016003 | -122.449784323005 | (37.7191048016003, -122.449784323005) | |
| 111585 | 111585 | 88455 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 2801 Oakdale Ave | 4 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | Permit Number 51417 | 6011007.5 | 2098422.1 | 37.742488010089005 | -122.40455177544202 | (37.742488010089, -122.404551775442) | |||
| 112089 | 112089 | 104435 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 1601X PORTOLA DR | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 5991823.0 | 2096240.0 | 37.73540567927029 | -122.47072655808 | (37.7354056792703, -122.47072655808) | ||||
| 112502 | 112502 | 104150 | Significant Tree 6 | Tree(s) :: 17 | 1710-1738 Diamond St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 768304 | 6001979.7 | 2099047.6 | 37.743696813668706 | -122.43581192261101 | (37.7436968136687, -122.435811922611) | ||||
| 114318 | 114318 | 103614 | Significant Tree 6 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 200X Buchanan St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6004748.9 | 2109266.8 | 37.7719132424086 | -122.426964371637 | (37.7719132424086, -122.426964371637) | |||||
| 117245 | 117245 | 116958 | Significant Tree 6 | Acer rubrum :: Red Maple 6 | 10x Yerba Buena Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/10/2016 12:00:00 AM | 3 | Permit Number 777762 | 5993642.277480001 | 2097056.1949900002 | 37.7377517864641 | -122.46449593033 | (37.7377517864641, -122.46449593033) | ||
| 117761 | 117761 | 101439 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 600X Grant Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6010995.6 | 2116632.0 | 37.7924875884206 | -122.40587538693701 | (37.7924875884206, -122.405875386937) | |||||
| 118374 | 118374 | 93206 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 400 Masonic Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 02/24/2010 12:00:00 AM | Permit Number 53203 | 5999124.7 | 2111407.5 | 37.777471434329904 | -122.446572853901 | (37.7774714343299, -122.446572853901) | |||
| 119061 | 119061 | 98288 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 300 Mangels Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 01/24/2012 12:00:00 AM | Permit Number 768637 | 5999381.8 | 2095276.6 | 37.7331946288913 | -122.444523835506 | (37.7331946288913, -122.444523835506) | |||
| 120789 | 120789 | 120921 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 143 | 3995X Alemany Blvd | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3X3 | 5992394.0 | 2087287.0 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | ||||
| 121106 | 121106 | 102478 | Significant Tree 6 | Afrocarpus gracilior :: Fern Pine 70 | 760 Victoria St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5993664.7 | 2092172.3 | 37.7243431058269 | -122.464063971167 | (37.7243431058269, -122.464063971167) | |||||
| 121815 | 121815 | 112772 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 1X HOWTH ST | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5998027.0 | 2091524.0 | 37.722813474972206 | -122.44893750468901 | (37.7228134749722, -122.448937504689) | ||||
| 124450 | 124450 | 112484 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 40 | 1275 Columbus Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 08/03/2015 12:00:00 AM | 6007539.6 | 2121483.9 | 37.8056158049656 | -122.418177422209 | (37.8056158049656, -122.418177422209) | ||||
| 124990 | 124990 | 107541 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 2 GARFIELD ST | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 36 | 5993976.6 | 2090624.3 | 37.7201106425596 | -122.46287353180901 | (37.7201106425596, -122.462873531809) | ||||
| 125443 | 125443 | 110737 | Significant Tree 6 | Taxodium mucronatum :: Montezuma Cypress 333 | 1299x PERSIA AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 3x3 | 6004594.0 | 2089787.0 | 37.71841743015371 | -122.42611316787901 | (37.7184174301537, -122.426113167879) | ||||
| 125535 | 125535 | 116090 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 5 | 98x WOODWARD ST | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 6006422.0 | 2107919.0 | 37.7683069672649 | -122.421081271108 | (37.7683069672649, -122.421081271108) | ||||
| 128434 | 128434 | 105863 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 26 | 3615-3623X Cesar Chavez St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6005538.0 | 2100417.0 | 37.747658358497404 | -122.423605504909 | (37.7476583584974, -122.423605504909) | |||||
| 128646 | 128646 | 92900 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 103 | 208 States St | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 08/13/2008 12:00:00 AM | 6000833.0 | 2106506.0 | 37.7641105715625 | -122.440311694354 | (37.7641105715625, -122.440311694354) | ||||
| 129467 | 129467 | 101981 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 25 | 25X Tiffany Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006415.7 | 2099833.4 | 37.7461054290546 | -122.42052904239901 | (37.7461054290546, -122.420529042399) | |||||
| 139196 | 139196 | 72854 | Significant Tree 6 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 24 Lunado Way | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/26/1998 12:00:00 AM | 5991516.52955398 | 2091408.89207172 | 37.722122935753106 | -122.47143422303499 | (37.7221229357531, -122.471434223035) | ||||
| 139418 | 139418 | 100697 | Significant Tree 6 | Liriodendron tulipifera :: Tulip Tree 85 | 200X 01st St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/05/2012 12:00:00 AM | Permit Number 768932 | 6013804.4 | 2114954.0 | 37.7880368749487 | -122.396039137137 | (37.7880368749487, -122.396039137137) | |||
| 140648 | 140648 | 104282 | Significant Tree 6 | Tree(s) :: 17 | 150X Middle Point Rd | 4 | Front Yard : Yard 7 | Tree 1 | Housing Authority 20 | 09/17/2013 12:00:00 AM | Permit Number 770341 | 6018215.0 | 2095138.0 | 37.733870695497295 | -122.37940203679399 | (37.7338706954973, -122.379402036794) | |||
| 142007 | 142007 | 106310 | Significant Tree 6 | Pinus canariensis :: Canary Island Pine 71 | 99X Clearfield Dr | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 04/15/2014 12:00:00 AM | Permit Number 772542 | 5985798.26078 | 2095453.4648400003 | 37.73289581695511 | -122.49149816384899 | (37.7328958169551, -122.491498163849) | |||
| 146074 | 146074 | 94447 | Significant Tree 6 | Tree(s) :: 17 | 1103 Gough St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 08/06/2010 12:00:00 AM | 3x3 | Permit Number 53668 | 6005549.7 | 2113553.5 | 37.7837287235103 | -122.424499312595 | (37.7837287235103, -122.424499312595) | ||
| 168767 | 168767 | 96276 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 35 | 55@ Alemany Trumbull St | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 2 | 6003946.78636 | 2094329.77315 | 37.730854277083104 | -122.428673970523 | (37.7308542770831, -122.428673970523) |
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");