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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
26475 | 26475 | 196593 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 966 Natoma St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6007961.50634 | 2109867.3377900003 | 37.7737433088451 | -122.41589423462798 | (37.7737433088451, -122.415894234628) | |||
26511 | 26511 | 218506 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 331 Tara St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5997624.737980001 | 2089991.46593 | 37.7185824800643 | -122.450217619562 | (37.7185824800643, -122.450217619562) | |||
26547 | 26547 | 212674 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 641 Garfield St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5992267.89136 | 2090473.0375 | 37.719596745362395 | -122.46876890666 | (37.7195967453624, -122.46876890666) | |||
26551 | 26551 | 247735 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3 Broderick St | 1 | : 4 | Tree 1 | Private 1 | 20 | Width 4ft | 6001364.01922 | 2108734.36535 | 37.770259331626896 | -122.43863473741199 | (37.7702593316269, -122.438634737412) | |||
26563 | 26563 | 246795 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 195 Brewster St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 2ft | 6010198.18555 | 2098814.08058 | 37.7435190400824 | -122.407377785258 | (37.7435190400824, -122.407377785258) | |||
26615 | 26615 | 201282 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 46 Lydia Ave | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6012790.052209999 | 2092889.91673 | 37.727397246266605 | -122.398000193676 | (37.7273972462666, -122.398000193676) | |||
26733 | 26733 | 188939 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2225 Jerrold Ave | 1 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6012171.90247 | 2099321.56683 | 37.745022760504206 | -122.400588763562 | (37.7450227605042, -122.400588763562) | |||
26748 | 26748 | 246425 | Undocumented 2 | Magnolia x soulangiana :: Saucer Magnolia 92 | 438 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6003653.22825 | 2099843.03322 | 37.745975810733796 | -122.43008199861099 | (37.7459758107338, -122.430081998611) | |||
26804 | 26804 | 250105 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1688 Pine St | 1 | : 4 | Tree 1 | Private 1 | 18 | Width 4ft | 6005949.70174 | 2115586.76552 | 37.7893341482864 | -122.423260038317 | (37.7893341482864, -122.423260038317) | |||
26845 | 26845 | 195029 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 603 02nd St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6013830.29257 | 2113762.02506 | 37.7847654277311 | -122.39586599541599 | (37.7847654277311, -122.395865995416) | |||
27020 | 27020 | 193809 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 283 Texas St | 1 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6013777.6703699995 | 2105799.42073 | 37.762898978733894 | -122.395490009551 | (37.7628989787339, -122.395490009551) | |||
27082 | 27082 | 193812 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 596 Mississippi St | 1 | : 4 | Tree 1 | Private 1 | 17 | Width 4ft | 6014080.0948 | 2104357.2434 | 37.75895589042771 | -122.39434303940399 | (37.7589558904277, -122.394343039404) | |||
27084 | 27084 | 224623 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 1323 Clayton St | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 5999023.60773 | 2105026.39376 | 37.759944756159996 | -122.44646337809601 | (37.75994475616, -122.446463378096) | |||
27087 | 27087 | 191234 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1600 Newhall St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 6014153.116769999 | 2095403.12134 | 37.734373817081796 | -122.39346385049299 | (37.7343738170818, -122.393463850493) | |||
27118 | 27118 | 219852 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 160 Saint Germain Ave | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5997608.48937 | 2104144.50247 | 37.7574423754904 | -122.451293958747 | (37.7574423754904, -122.451293958747) | |||
27153 | 27153 | 197239 | Undocumented 2 | Quercus suber :: Cork Oak 76 | 830 Rhode Island St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 6ft | 6011827.26305 | 2104492.53285 | 37.7592018783746 | -122.40214394588999 | (37.7592018783746, -122.40214394589) | |||
27170 | 27170 | 211520 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 136 Caine Ave | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 10ft | 5997136.50298 | 2089006.99788 | 37.7158514071876 | -122.451834257948 | (37.7158514071876, -122.451834257948) | |||
27292 | 27292 | 250990 | Undocumented 2 | Melaleuca nesophila :: Pink Melaleuca 93 | 418 45th Ave | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5981922.57195 | 2112909.00953 | 37.7805965385427 | -122.50619104959299 | (37.7805965385427, -122.506191049593) | |||
27293 | 27293 | 200401 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 482 09th St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6010012.1355099995 | 2109044.8007400003 | 37.7715998853661 | -122.40874271332501 | (37.7715998853661, -122.408742713325) | |||
27313 | 27313 | 247224 | Undocumented 2 | Schinus molle :: California Pepper 138 | 135 Divisadero St | 1 | : 4 | Tree 1 | Private 1 | 14 | Width 3ft | 6001887.60725 | 2108459.11842 | 37.7695333431173 | -122.436803945272 | (37.7695333431173, -122.436803945272) | |||
27314 | 27314 | 218570 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 98 Rossmoor Dr | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5990761.96187 | 2094481.85885 | 37.7305168532543 | -122.47426667546002 | (37.7305168532543, -122.47426667546) | |||
27319 | 27319 | 246424 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 418 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 17 | Width 4ft | 6003710.7768 | 2099847.4001700003 | 37.7459910605319 | -122.429883314964 | (37.7459910605319, -122.429883314964) | |||
27358 | 27358 | 202320 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 155 Orsi Cir | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 2ft | 6012974.90873 | 2093002.4411400002 | 37.727716509204 | -122.397369027877 | (37.727716509204, -122.397369027877) | |||
27360 | 27360 | 191232 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 2055 Silver Ave | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6012617.37339 | 2096166.05375 | 37.7363832218132 | -122.39882697638201 | (37.7363832218132, -122.398826976382) | |||
27386 | 27386 | 220596 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 452 Shotwell St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6007814.59662 | 2105186.38117 | 37.7608822364448 | -122.416070852512 | (37.7608822364448, -122.416070852512) | |||
27518 | 27518 | 191712 | Undocumented 2 | Eriobotrya deflexa 'Coppertone' :: Coppertone Loquat 272 | 18 Robblee Ave | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 1ft | 6012627.22621 | 2095983.93227 | 37.7358837032551 | -122.39878013339501 | (37.7358837032551, -122.398780133395) | |||
27602 | 27602 | 178277 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 900 Brotherhood Way | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 0ft | 5987671.03855 | 2088779.0413099998 | 37.7146788207357 | -122.484534178617 | (37.7146788207357, -122.484534178617) | |||
27627 | 27627 | 195043 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 377 06th St | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6011353.00653 | 2111183.55828 | 37.777547432096206 | -122.404255094506 | (37.7775474320962, -122.404255094506) | |||
27710 | 27710 | 247815 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 536 30th St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6003101.83098 | 2098352.54128 | 37.7418520216442 | -122.43188224706101 | (37.7418520216442, -122.431882247061) | |||
27724 | 27724 | 204090 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 520 Garfield St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5992622.63923 | 2090513.2598299999 | 37.7197276740608 | -122.46754560564501 | (37.7197276740608, -122.467545605645) | |||
27799 | 27799 | 208686 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 207 Lakeview Ave | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5997054.6676199995 | 2089435.45045 | 37.7170231509855 | -122.45214801343201 | (37.7170231509855, -122.452148013432) | |||
27836 | 27836 | 201298 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 65 Lydia Ave | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 2ft | 6012703.34992 | 2092907.69585 | 37.727441234813 | -122.398301172475 | (37.727441234813, -122.398301172475) | |||
27851 | 27851 | 189007 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1739 La Salle Ave | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6014800.47126 | 2096669.79143 | 37.7378877812889 | -122.39131423337 | (37.7378877812889, -122.39131423337) | |||
27858 | 27858 | 198136 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 27 Bridgeview Dr | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 2ft | 6014000.75949 | 2095429.8898900002 | 37.7344388515748 | -122.393992476471 | (37.7344388515748, -122.393992476471) | |||
27862 | 27862 | 194050 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2246 Jerrold Ave | 1 | : 4 | Tree 1 | Private 1 | 23 | Width 6ft | 6012135.46921 | 2099441.05415 | 37.7453488151107 | -122.400723136672 | (37.7453488151107, -122.400723136672) | |||
27867 | 27867 | 241239 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 McCoppin St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6005928.367769999 | 2109150.09439 | 37.7716594186857 | -122.42287620587601 | (37.7716594186857, -122.422876205876) | |||
27885 | 27885 | 210725 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 20 Edgar Ave | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5997113.75654 | 2090895.52443 | 37.7210355581178 | -122.452049055632 | (37.7210355581178, -122.452049055632) | |||
27893 | 27893 | 217747 | Undocumented 2 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 625 Frederick St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5996570.53056 | 2107292.29818 | 37.7660259340648 | -122.455111074526 | (37.7660259340648, -122.455111074526) | |||
27920 | 27920 | 219161 | Undocumented 2 | Hakea suaveolens :: Sweet Hakea Tree 14 | 521 Bright St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 5993760.1338 | 2090633.97995 | 37.720124750843794 | -122.463622478709 | (37.7201247508438, -122.463622478709) | |||
28114 | 28114 | 210164 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 556 Ramsell St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5993014.635559999 | 2090870.2943400003 | 37.7207306285937 | -122.466216557854 | (37.7207306285937, -122.466216557854) | |||
28139 | 28139 | 247240 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 921 Buena Vista Ave West | 1 | : 4 | Tree 1 | Private 1 | 17 | Width 3ft | 6000040.78347 | 2108630.8128400003 | 37.7698996387736 | -122.443204350999 | (37.7698996387736, -122.443204350999) | |||
28254 | 28254 | 235714 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 575 Florida St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6009284.05083 | 2105508.94115 | 37.761850423188704 | -122.41101142226499 | (37.7618504231887, -122.411011422265) | |||
28359 | 28359 | 192990 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 540 Texas St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6013786.51835 | 2104548.48696 | 37.7594646800698 | -122.39537176939301 | (37.7594646800698, -122.395371769393) | |||
28372 | 28372 | 204655 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 452 Victoria St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5993265.60688 | 2090192.2995 | 37.7188834957636 | -122.46529981143298 | (37.7188834957636, -122.465299811433) | |||
28397 | 28397 | 249531 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 246 Myrtle St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6006201.54989 | 2114050.0866900003 | 37.7851290182315 | -122.42227944813601 | (37.7851290182315, -122.422279448136) | |||
28441 | 28441 | 189265 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2203 Newcomb Ave | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6011972.28331 | 2098093.92114 | 37.7416407727111 | -122.40119276536001 | (37.7416407727111, -122.40119276536) | |||
28479 | 28479 | 213820 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 938 Garfield St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 5991536.52061 | 2090526.4339400001 | 37.7197010793166 | -122.471300855268 | (37.7197010793166, -122.471300855268) | |||
28526 | 28526 | 218250 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2751 14th Ave | 1 | : 4 | Tree 1 | Private 1 | 14 | Width 3ft | 5992235.80201 | 2097238.62713 | 37.738171520993 | -122.469372026199 | (37.738171520993, -122.469372026199) | |||
28632 | 28632 | 198138 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 134 Bridgeview Dr | 1 | : 4 | Tree 1 | Private 1 | 15 | Width 3ft | 6013340.1556400005 | 2095686.7025099997 | 37.7351072690864 | -122.396294410852 | (37.7351072690864, -122.396294410852) | |||
28661 | 28661 | 189257 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2231 Newcomb Ave | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6011833.55798 | 2098197.58892 | 37.7419176820557 | -122.40167971856 | (37.7419176820557, -122.40167971856) | |||
28700 | 28700 | 189264 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2207 Newcomb Ave | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6011951.89121 | 2098108.4509400004 | 37.741679530779294 | -122.401264295606 | (37.7416795307793, -122.401264295606) | |||
28715 | 28715 | 188370 | Undocumented 2 | Carpinus betulus :: European Hornbeam 296 | 412 Connecticut St | 1 | : 4 | Tree 1 | Private 1 | 14 | Width 3ft | 6013195.070169999 | 2105113.9405 | 37.760984378759495 | -122.397456959072 | (37.7609843787595, -122.397456959072) | |||
28758 | 28758 | 129906 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 536 Fell St | 1 | : 4 | Tree 1 | Private 1 | 16 | Width 3ft | 6004841.59685 | 2110577.9768 | 37.7755186559901 | -122.426737115928 | (37.7755186559901, -122.426737115928) | |||
28826 | 28826 | 247019 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 530 Valley St | 1 | : 4 | Tree 1 | Private 1 | 17 | Width 3ft | 6002475.46095 | 2099175.15499 | 37.744075198804204 | -122.43410681909799 | (37.7440751988042, -122.434106819098) | |||
28932 | 28932 | 188976 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2000 Thomas Ave | 1 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6012701.46766 | 2095447.24575 | 37.734414210138 | -122.398485802392 | (37.734414210138, -122.398485802392) | |||
29018 | 29018 | 247759 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 75 Alpine Ter | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6001668.74952 | 2108376.80716 | 37.7692948959648 | -122.437555068929 | (37.7692948959648, -122.437555068929) | |||
29065 | 29065 | 234039 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 93 Scott St | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 4ft | 6002347.866230001 | 2108745.44445 | 37.770345671048204 | -122.435232412346 | (37.7703456710482, -122.435232412346) | |||
29127 | 29127 | 250321 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 247 27th Ave | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 5987414.73446 | 2114306.1636799998 | 37.7847545126541 | -122.487293940769 | (37.7847545126541, -122.487293940769) | |||
29228 | 29228 | 213269 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 58 Ralston St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5992208.01745 | 2088290.25795 | 37.7135999031885 | -122.468817113946 | (37.7135999031885, -122.468817113946) | |||
29237 | 29237 | 196145 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 356 Arkansas St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6012905.6272599995 | 2105323.15012 | 37.7615427021613 | -122.398472702866 | (37.7615427021613, -122.398472702866) | |||
29242 | 29242 | 246450 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 425 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6003711.71796 | 2099797.01906 | 37.7458527789913 | -122.429876467534 | (37.7458527789913, -122.429876467534) | |||
29277 | 29277 | 188956 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1706 La Salle Ave | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 6014961.30392 | 2096622.74747 | 37.737767532934896 | -122.39075486493799 | (37.7377675329349, -122.390754864938) | |||
29418 | 29418 | 247623 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 261 Bradford St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 4ft | 6009541.508359999 | 2097060.7150400002 | 37.738667903594205 | -122.409524699022 | (37.7386679035942, -122.409524699022) | |||
29460 | 29460 | 191230 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1251 Newhall St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6014739.49892 | 2096121.8776900002 | 37.7363799383901 | -122.391486752132 | (37.7363799383901, -122.391486752132) | |||
29466 | 29466 | 250525 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 80 26th Ave | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 4ft | 5987725.71266 | 2115440.30097 | 37.7878866588866 | -122.486301363544 | (37.7878866588866, -122.486301363544) | |||
29514 | 29514 | 247770 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 827 Waller St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6001730.80568 | 2108705.46895 | 37.77020084782 | -122.437363957589 | (37.77020084782, -122.437363957589) | |||
29547 | 29547 | 218232 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 371 Wawona St | 1 | : 4 | Tree 1 | Private 1 | 33 | Width 2ft | 5991901.5455 | 2097060.86466 | 37.7376641082099 | -122.47051476505 | (37.7376641082099, -122.47051476505) | |||
29565 | 29565 | 212676 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 124 Sargent St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 5993606.85369 | 2089199.82617 | 37.7161780760225 | -122.464048258239 | (37.7161780760225, -122.464048258239) | |||
29571 | 29571 | 194075 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 30 Dorman Ave | 1 | : 4 | Tree 1 | Private 1 | 3 | 6011495.74471 | 2097425.71535 | 37.739779425186704 | -122.402793501934 | (37.7397794251867, -122.402793501934) | ||||
29631 | 29631 | 250970 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 6932 California St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 4ft | 5985996.4910699995 | 2113927.35673 | 37.7836316119485 | -122.49217262437 | (37.7836316119485, -122.49217262437) | |||
29678 | 29678 | 239070 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 170 Rose St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6005772.351980001 | 2109825.6817 | 37.773505614422895 | -122.423463911935 | (37.7735056144229, -122.423463911935) | |||
29734 | 29734 | 249449 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 250 Olive St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6006158.32839 | 2113696.95162 | 37.7841569581316 | -122.422403881033 | (37.7841569581316, -122.422403881033) | |||
29741 | 29741 | 196461 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 615 Mississippi St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6014144.28645 | 2104277.08263 | 37.7587393543665 | -122.39411542098999 | (37.7587393543665, -122.39411542099) | |||
29777 | 29777 | 249369 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 651 Jones St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6008783.9414800005 | 2114861.19472 | 37.787501451385204 | -122.413402530727 | (37.7875014513852, -122.413402530727) | |||
29796 | 29796 | 188856 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 355 11th St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6008743.51462 | 2108952.72037 | 37.77127591719079 | -122.413124449536 | (37.7712759171908, -122.413124449536) | |||
29840 | 29840 | 246959 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2173 15th St | 1 | : 4 | Tree 1 | Private 1 | 22 | Width 4ft | 6003061.26496 | 2107089.31896 | 37.7658388409276 | -122.43264645046699 | (37.7658388409276, -122.432646450467) | |||
29865 | 29865 | 197031 | Undocumented 2 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 1950 Donner Ave | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6011564.47329 | 2093570.84173 | 37.729198590121 | -122.40228490112301 | (37.729198590121, -122.402284901123) | |||
29892 | 29892 | 247666 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 136 Divisadero St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6001948.31125 | 2108443.5233 | 37.7694939725921 | -122.436592856397 | (37.7694939725921, -122.436592856397) | |||
29994 | 29994 | 218514 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 312 Vernon St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5992482.71781 | 2089883.86567 | 37.71799143124971 | -122.467983503544 | (37.7179914312497, -122.467983503544) | |||
30043 | 30043 | 193801 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 776 Wisconsin St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6012701.04475 | 2103917.58098 | 37.7576719193319 | -122.39908161224899 | (37.7576719193319, -122.399081612249) | |||
30049 | 30049 | 222884 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1 Valencia St | 1 | : 4 | Tree 1 | Private 1 | 18 | Width 5ft | 6006058.1722800005 | 2109199.11331 | 37.7718013362 | -122.422430687153 | (37.7718013362, -122.422430687153) | |||
30257 | 30257 | 214113 | Undocumented 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 232 Garfield St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5993322.79937 | 2090505.62474 | 37.719747109313104 | -122.46512486633999 | (37.7197471093131, -122.46512486634) | |||
30296 | 30296 | 202045 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 41 Exeter St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6012584.35783 | 2091031.2434099999 | 37.7222822496095 | -122.39858091108201 | (37.7222822496095, -122.398580911082) | |||
30302 | 30302 | 175150 | Undocumented 2 | Aesculus x carnea :: Red Horse Chestnut 194 | 141 Goethe St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5994849.69598 | 2086516.03158 | 37.708880557851 | -122.45955816357299 | (37.708880557851, -122.459558163573) | |||
30393 | 30393 | 175390 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3087 22nd Ave | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 2ft | 5989889.400330001 | 2094791.98233 | 37.7313177849745 | -122.477305871364 | (37.7313177849745, -122.477305871364) | |||
30430 | 30430 | 190662 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1498 Fairfax Ave | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6016277.57069 | 2097744.40559 | 37.7409203204163 | -122.386282030116 | (37.7409203204163, -122.386282030116) | |||
30439 | 30439 | 246993 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 55 Clipper St | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 6004785.89781 | 2101026.3383400002 | 37.7492889788082 | -122.426249608749 | (37.7492889788082, -122.426249608749) | |||
30441 | 30441 | 196549 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 40 Ledyard St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 2ft | 6011616.35938 | 2095078.6456799998 | 37.7333416013201 | -122.402211492182 | (37.7333416013201, -122.402211492182) | |||
30483 | 30483 | 187888 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1799 Indiana St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 5ft | 6015216.20725 | 2100273.8122 | 37.747806741405 | -122.390128525805 | (37.747806741405, -122.390128525805) | |||
30518 | 30518 | 179954 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 40 Tomaso Ct | 1 | : 4 | Tree 1 | Private 1 | 23 | Width 2ft | 6009197.20014 | 2086405.9588 | 37.709392885454 | -122.409963207553 | (37.709392885454, -122.409963207553) | |||
30598 | 30598 | 247170 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 145 Buena Vista Ave East | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 4ft | 6001370.95103 | 2108474.04291 | 37.7695449452612 | -122.438592105046 | (37.7695449452612, -122.438592105046) | |||
30639 | 30639 | 188038 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 811 Rhode Island St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 6ft | 6011881.03364 | 2104580.1042400002 | 37.7594453311486 | -122.401964136345 | (37.7594453311486, -122.401964136345) | |||
30711 | 30711 | 247235 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 49 Castro St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | 6002189.582769999 | 2108332.3938700003 | 37.7692025463843 | -122.435750357108 | (37.7692025463843, -122.435750357108) | |||
30783 | 30783 | 202270 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 38 Orsi Cir | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 6012994.98381 | 2093237.0284400003 | 37.728361755688894 | -122.39731607130301 | (37.7283617556889, -122.397316071303) | |||
30800 | 30800 | 193660 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1728 Oakdale Ave | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6014387.04364 | 2096004.28587 | 37.736037486423605 | -122.392697123571 | (37.7360374864236, -122.392697123571) | |||
30953 | 30953 | 204049 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 6 Geneva Ave | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 5997346.16193 | 2091404.9638200002 | 37.7224476691055 | -122.451282424964 | (37.7224476691055, -122.451282424964) | |||
31006 | 31006 | 202273 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 50 Orsi Cir | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 6012938.89237 | 2093280.23143 | 37.7284772592045 | -122.397513012032 | (37.7284772592045, -122.397513012032) | |||
31009 | 31009 | 201796 | Undocumented 2 | Zelkova serrata :: Sawleaf Zelkova 174 | 50 Jerrold Ave | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 5ft | 6021152.60745 | 2092710.04539 | 37.727365560462395 | -122.369078036218 | (37.7273655604624, -122.369078036218) | |||
31016 | 31016 | 238039 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 89 Elgin Park | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6005843.94387 | 2108584.75014 | 37.7701023549756 | -122.423128042119 | (37.7701023549756, -122.423128042119) | |||
31134 | 31134 | 246971 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 281 Noe St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 4ft | 6002932.26985 | 2106723.06084 | 37.7648258688387 | -122.433066446456 | (37.7648258688387, -122.433066446456) |
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");