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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
188007 | 188007 | 175344 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2 Brotherhood Way | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 5ft | 5993634.16802 | 2087703.44428 | 37.7120709424008 | -122.463845295648 | (37.7120709424008, -122.463845295648) | |||
187996 | 187996 | 140851 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 571 Euclid Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 0ft | 5996626.4577 | 2113806.2024 | 37.7839146219169 | -122.45538845370001 | (37.7839146219169, -122.4553884537) | |||
187995 | 187995 | 187310 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2200 Sunset Blvd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 24 | Width 0ft | 5985030.9318 | 2099750.1318 | 37.7446484400934 | -122.49446760159401 | (37.7446484400934, -122.494467601594) | |||
187978 | 187978 | 219496 | Undocumented 2 | Ulmus americana :: American Elm 119 | 91 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 8ft | 5992630.2874 | 2096120.09632 | 37.7351231052451 | -122.467926769816 | (37.7351231052451, -122.467926769816) | |||
187967 | 187967 | 123934 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 1 08th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 6ft | 5993312.6143 | 2114933.12795 | 37.7868181510268 | -122.46693498732799 | (37.7868181510268, -122.466934987328) | |||
187964 | 187964 | 133493 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 201 Spruce St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 5ft | 5997075.25575 | 2115566.36113 | 37.7887732905973 | -122.453962946945 | (37.7887732905973, -122.453962946945) | |||
187944 | 187944 | 118504 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 8149 Geary Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | 5981658.42687 | 2112320.40323 | 37.778964846285 | -122.507061160796 | (37.778964846285, -122.507061160796) | ||||
187933 | 187933 | 141037 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 168 JORDAN AVE | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 0ft | 5996266.0384 | 2113205.8421 | 37.7822455054095 | -122.456591933359 | (37.7822455054095, -122.456591933359) | |||
187900 | 187900 | 250616 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 107 28th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 5987080.55182 | 2115289.10715 | 37.7874338997015 | -122.488522355317 | (37.7874338997015, -122.488522355317) | |||
187875 | 187875 | 176055 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 0 Gonzalez Dr | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 24 | 5989270.85841 | 2089380.9981799999 | 37.716424679123705 | -122.479048612712 | (37.7164246791237, -122.479048612712) | ||||
187860 | 187860 | 135064 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 22 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 5ft | 6010496.20464 | 2122220.2308799997 | 37.8078035593512 | -122.407997582726 | (37.8078035593512, -122.407997582726) | |||
187850 | 187850 | 204458 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 390 Magellan Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 3ft | 5993883.60942 | 2099617.77465 | 37.7447991512623 | -122.463847414442 | (37.7447991512623, -122.463847414442) | |||
187833 | 187833 | 204943 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 101 Santa Paula Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 6ft | 5994032.70638 | 2097142.34763 | 37.7380108391394 | -122.46315228886101 | (37.7380108391394, -122.463152288861) | |||
187808 | 187808 | 209513 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 880 Northwood Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 10ft | 5994947.834 | 2093941.9137400002 | 37.729275905752395 | -122.45975650815001 | (37.7292759057524, -122.45975650815) | |||
187803 | 187803 | 182417 | Undocumented 2 | :: 54 | 1544 36th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984999.4264 | 2104687.6498 | 37.758203665254996 | -122.494940531373 | (37.758203665255, -122.494940531373) | |||
187793 | 187793 | 212271 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 851 Junipero Serra Blvd | 20 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 3ft | 5991347.76496 | 2091893.5227299999 | 37.7234438472491 | -122.47205290164699 | (37.7234438472491, -122.472052901647) | |||
187775 | 187775 | 250901 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 262 29th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5986843.4258 | 2114179.11857 | 37.784372351133 | -122.489261109739 | (37.784372351133, -122.489261109739) | |||
187769 | 187769 | 122180 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 100 14th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | Width 3ft | 5991527.0848 | 2114155.02215 | 37.784578471021 | -122.47305567737601 | (37.784578471021, -122.473055677376) | |||
187768 | 187768 | 182630 | Undocumented 2 | :: 54 | 1858 30th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986937.5539 | 2102606.5337 | 37.752602752659705 | -122.488084813705 | (37.7526027526597, -122.488084813705) | |||
187753 | 187753 | 246786 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 175 Brewster St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6010089.416540001 | 2098717.54188 | 37.74324787739471 | -122.407747077462 | (37.7432478773947, -122.407747077462) | ||||
187740 | 187740 | 219493 | Undocumented 2 | Ulmus americana :: American Elm 119 | 90 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 8ft | 5992589.41674 | 2096176.23062 | 37.7352748757434 | -122.468072155131 | (37.7352748757434, -122.468072155131) | |||
187736 | 187736 | 206608 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 2 Sola Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 5994960.813709999 | 2100721.5804 | 37.7478919422595 | -122.460202627649 | (37.7478919422595, -122.460202627649) | |||
187732 | 187732 | 214729 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 620 Faxon Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5994877.75254 | 2092392.95175 | 37.725018800251796 | -122.459886624766 | (37.7250188002518, -122.459886624766) | |||
187713 | 187713 | 214360 | Undocumented 2 | Prunus laurocerasus :: English laurel 227 | 1549 15th Ave | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 5991543.46931 | 2104921.0361599997 | 37.759225392054404 | -122.472325621024 | (37.7592253920544, -122.472325621024) | ||||
187701 | 187701 | 182499 | Undocumented 2 | :: 54 | 1567 35th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985270.2162 | 2104558.8043 | 37.7578657392797 | -122.493994540633 | (37.7578657392797, -122.493994540633) | |||
187686 | 187686 | 179478 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 0 Serrano Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | 5989807.06872 | 2090726.39006 | 37.720149915678 | -122.477293493993 | (37.720149915678, -122.477293493993) | ||||
187682 | 187682 | 218906 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 160 Dorantes Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 5993761.1168599995 | 2099844.95033 | 37.7454158586537 | -122.46428745721 | (37.7454158586537, -122.46428745721) | |||
187678 | 187678 | 130799 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2624 Steiner St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 6002200.357969999 | 2117124.26521 | 37.7933434159171 | -122.43634239249599 | (37.7933434159171, -122.436342392496) | |||
187636 | 187636 | 183293 | Undocumented 2 | :: 54 | 1286 42nd Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5983075.6533 | 2106421.6609 | 37.76285196523921 | -122.50172195396401 | (37.7628519652392, -122.501721953964) | |||
187627 | 187627 | 184329 | Undocumented 2 | :: 54 | 1571 42nd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5983101.4912 | 2104441.3261 | 37.757416043664996 | -122.501486086821 | (37.757416043665, -122.501486086821) | |||
187597 | 187597 | 210976 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 260 Dorantes Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 3ft | 5993323.42332 | 2099719.9683 | 37.7450474513929 | -122.46579183953301 | (37.7450474513929, -122.465791839533) | |||
187587 | 187587 | 219577 | Undocumented 2 | Ulmus americana :: American Elm 119 | 250 Dorantes Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 3ft | 5993372.19825 | 2099725.86442 | 37.745066454055795 | -122.46562361415899 | (37.7450664540558, -122.465623614159) | |||
187571 | 187571 | 250436 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 98 Seacliff Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 4ft | 5987616.8568 | 2115817.96032 | 37.7889172576592 | -122.486705722111 | (37.7889172576592, -122.486705722111) | |||
187567 | 187567 | 218314 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 437 Castenada Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 0ft | 5993129.70143 | 2099920.62697 | 37.7455872325622 | -122.466476271275 | (37.7455872325622, -122.466476271275) | |||
187534 | 187534 | 213472 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 390 Magellan Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5993869.43858 | 2099604.78571 | 37.744762670277204 | -122.463895471497 | (37.7447626702772, -122.463895471497) | |||
187527 | 187527 | 183391 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2670 24th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 5988981.484 | 2097172.4205 | 37.7378011335163 | -122.48061886239599 | (37.7378011335163, -122.480618862396) | |||
187508 | 187508 | 191440 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2212 25th St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 6012152.298359999 | 2101896.5627900003 | 37.75209205051161 | -122.40083742701401 | (37.7520920505116, -122.400837427014) | |||
187493 | 187493 | 183973 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1679 27th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5987776.9086 | 2103868.5958 | 37.756116965025605 | -122.48527481394301 | (37.7561169650256, -122.485274813943) | |||
187472 | 187472 | 193345 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1133 19th St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 3ft | 6014171.26133 | 2105242.63423 | 37.7613920486234 | -122.394089723782 | (37.7613920486234, -122.394089723782) | |||
187453 | 187453 | 238706 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 135 Highland Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 3ft | 6005698.1873 | 2096677.09805 | 37.737398474566895 | -122.422785841118 | (37.7373984745669, -122.422785841118) | |||
187448 | 187448 | 184439 | Undocumented 2 | :: 54 | 2131 45th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5982299.7091 | 2100588.462 | 37.7467900380649 | -122.503973554813 | (37.7467900380649, -122.503973554813) | |||
187444 | 187444 | 178295 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 654 Brotherhood Way | 11 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5990056.81744 | 2088683.0468099997 | 37.7145538887276 | -122.47628102917 | (37.7145538887276, -122.47628102917) | |||
187430 | 187430 | 218414 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 200 Castenada Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5994295.2079300005 | 2100668.92449 | 37.747709054341 | -122.46250042605101 | (37.747709054341, -122.462500426051) | |||
187417 | 187417 | 218328 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 446 Castenada Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 5993017.38918 | 2099944.3564400002 | 37.7456459061356 | -122.46686635132099 | (37.7456459061356, -122.466866351321) | |||
187402 | 187402 | 179964 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 85 South Hill Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 6002952.82685 | 2087126.8782400002 | 37.7110204227269 | -122.431596206017 | (37.7110204227269, -122.431596206017) | |||
187394 | 187394 | 227947 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2700 22nd St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 7ft | 6009924.719330001 | 2103404.59086 | 37.7561082572986 | -122.40864713697901 | (37.7561082572986, -122.408647136979) | |||
187393 | 187393 | 132205 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 12 Greenwich St | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 27 | 6012257.5514 | 2120548.1369 | 37.8033108539845 | -122.401784364564 | (37.8033108539845, -122.401784364564) | ||||
187372 | 187372 | 209194 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 10 Alton Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5994381.32008 | 2101598.31256 | 37.7502658772735 | -122.462270052143 | (37.7502658772735, -122.462270052143) | |||
187366 | 187366 | 204290 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1723 12th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5992460.07118 | 2103823.87562 | 37.756265882372105 | -122.46907574903999 | (37.7562658823721, -122.46907574904) | |||
187361 | 187361 | 182210 | Undocumented 2 | :: 54 | 1590 34th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985631.6222 | 2104402.5116 | 37.757457742400796 | -122.49273315414801 | (37.7574577424008, -122.492733154148) | |||
187360 | 187360 | 185788 | Undocumented 2 | :: 54 | 1911 31st Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986591.7328 | 2102227.8108 | 37.7515427017776 | -122.48925286425501 | (37.7515427017776, -122.489252864255) | |||
187352 | 187352 | 231154 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 114 Nevada St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 3ft | 6009037.91802 | 2097949.68655 | 37.7410805949011 | -122.411328665303 | (37.7410805949011, -122.411328665303) | |||
187326 | 187326 | 131207 | Undocumented 2 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 12 Greenwich St | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 6012263.47251 | 2120560.44048 | 37.803344967053 | -122.40176473957399 | (37.803344967053, -122.401764739574) | ||||
187316 | 187316 | 133599 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3203 Pacific Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 4ft | 5998812.20611 | 2116559.67627 | 37.7916001088964 | -122.448024918608 | (37.7916001088964, -122.448024918608) | |||
187309 | 187309 | 214781 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1723 Monterey Blvd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5992834.3473 | 2095346.2214400002 | 37.733010019498 | -122.467165018866 | (37.733010019498, -122.467165018866) | |||
187306 | 187306 | 140811 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 92 Commonwealth Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 5996557.5888 | 2113916.3587 | 37.784213129993795 | -122.455634678211 | (37.7842131299938, -122.455634678211) | |||
187295 | 187295 | 202124 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 2801 Newhall St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 2ft | 6012530.10914 | 2092948.6060099998 | 37.7275439140005 | -122.398902940345 | (37.7275439140005, -122.398902940345) | |||
187274 | 187274 | 178602 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 654 Brotherhood Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5990447.2893 | 2088474.31285 | 37.7140033930131 | -122.47491618743601 | (37.7140033930131, -122.474916187436) | |||
187265 | 187265 | 183138 | Undocumented 2 | :: 54 | 3521 Santiago St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981925.3562 | 2099416.4074 | 37.7435498815044 | -122.50518115930201 | (37.7435498815044, -122.505181159302) | |||
187264 | 187264 | 182228 | Undocumented 2 | :: 54 | 1674 21st Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5989678.7682 | 2103975.7002 | 37.7565216554044 | -122.478705447978 | (37.7565216554044, -122.478705447978) | |||
187255 | 187255 | 208245 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 75 San Lorenzo Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 6ft | 5993707.19975 | 2097432.52506 | 37.7387888372376 | -122.464298778791 | (37.7387888372376, -122.464298778791) | |||
187250 | 187250 | 181883 | Undocumented 2 | :: 54 | 2362 31st Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986739.9723 | 2099172.336 | 37.7431618411675 | -122.48851569655001 | (37.7431618411675, -122.48851569655) | |||
187245 | 187245 | 222141 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 731 Duboce Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 27 | Width 3ft | 6001982.44217 | 2108239.02454 | 37.768934409012104 | -122.43646016051399 | (37.7689344090121, -122.436460160514) | |||
187226 | 187226 | 250936 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 242 28th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 4ft | 5987145.66978 | 2114320.34633 | 37.7847777601171 | -122.488225846157 | (37.7847777601171, -122.488225846157) | |||
187217 | 187217 | 185849 | Undocumented 2 | :: 54 | 2010 30th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986971.0019 | 2101557.3753 | 37.749723998312895 | -122.487892067667 | (37.7497239983129, -122.487892067667) | |||
187205 | 187205 | 229341 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2384 Bryant St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 6ft | 6009657.1451900005 | 2103466.25311 | 37.7562625782597 | -122.409576854282 | (37.7562625782597, -122.409576854282) | |||
187188 | 187188 | 188879 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 800 Vermont St | 18 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | 6011290.47515 | 2104318.93293 | 37.758695235422294 | -122.40398820989799 | (37.7586952354223, -122.403988209898) | ||||
187184 | 187184 | 205372 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 472 Dewey Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5994775.80206 | 2100091.70194 | 37.74615181075529 | -122.460796743188 | (37.7461518107553, -122.460796743188) | |||
187171 | 187171 | 208972 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 136 Yerba Buena Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 26 | Width 6ft | 5994281.63654 | 2096550.25213 | 37.7363994284866 | -122.462248690521 | (37.7363994284866, -122.462248690521) | |||
187143 | 187143 | 206901 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 901 Monterey Blvd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5996051.82187 | 2094624.9249900002 | 37.7312147154845 | -122.45598930567199 | (37.7312147154845, -122.455989305672) | |||
187127 | 187127 | 195982 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 401 Amador St | 11 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 6018502.102580001 | 2099556.87815 | 37.746019886521296 | -122.378716163238 | (37.7460198865213, -122.378716163238) | ||||
187116 | 187116 | 209527 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 120 Alton Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 5993729.20174 | 2101663.31311 | 37.7504067812521 | -122.464529820919 | (37.7504067812521, -122.464529820919) | |||
187102 | 187102 | 133576 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 200 Laurel St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 3ft | 5998070.26913 | 2115715.74181 | 37.7892404506396 | -122.450531132228 | (37.7892404506396, -122.450531132228) | |||
187073 | 187073 | 220786 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 100 27th St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 6005806.54234 | 2100249.31165 | 37.747213079126 | -122.42266498479601 | (37.747213079126, -122.422664984796) | |||
187070 | 187070 | 186110 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1700 Sunset Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5984921.7411 | 2103055.8274 | 37.7537185848112 | -122.495088868687 | (37.7537185848112, -122.495088868687) | |||
187066 | 187066 | 245846 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 301 Oak St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 6005500.1805 | 2110269.8913 | 37.7747099408336 | -122.424436996012 | (37.7747099408336, -122.424436996012) | |||
187059 | 187059 | 209071 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 10 San Benito Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 22 | Width 8ft | 5992810.81108 | 2096721.9715900002 | 37.7367861270691 | -122.46734639051901 | (37.7367861270691, -122.467346390519) | |||
187044 | 187044 | 233501 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 6 Park Hill Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 3ft | 6001141.15752 | 2107828.11381 | 37.7677583098187 | -122.439340644067 | (37.7677583098187, -122.439340644067) | |||
187026 | 187026 | 250853 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 218 30th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5986526.42947 | 2114357.74439 | 37.7848442973805 | -122.490370936979 | (37.7848442973805, -122.490370936979) | |||
187013 | 187013 | 218061 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2 San Rafael Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 5ft | 5991867.74451 | 2095942.81987 | 37.734592284912 | -122.47055022353099 | (37.734592284912, -122.470550223531) | |||
186962 | 186962 | 218218 | Undocumented 2 | Archontophoenix cunninghamiana :: King Palm 210 | 399 Wawona St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5991827.81177 | 2097037.5043900001 | 37.73759570307 | -122.47076799437201 | (37.73759570307, -122.470767994372) | |||
186948 | 186948 | 188753 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 151 Executive Park Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 3ft | 6014041.0419 | 2087033.9211099998 | 37.7113874378463 | -122.393265880017 | (37.7113874378463, -122.393265880017) | |||
186932 | 186932 | 206415 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 82 Ventura Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | Width 3ft | 5994311.20143 | 2101804.36406 | 37.7508276046147 | -122.46252746956999 | (37.7508276046147, -122.46252746957) | |||
186914 | 186914 | 202176 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 100 Kalmanovitz St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | Width 2ft | 6013132.98284 | 2093010.28184 | 37.7277468379346 | -122.396823108819 | (37.7277468379346, -122.396823108819) | |||
186898 | 186898 | 209512 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 150 San Buenaventura Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 8ft | 5993376.48469 | 2095710.5124 | 37.7340415517796 | -122.465317175573 | (37.7340415517796, -122.465317175573) | |||
186895 | 186895 | 196150 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 502 Missouri St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 8ft | 6013505.49575 | 2104693.9882799997 | 37.7598485610787 | -122.396353889321 | (37.7598485610787, -122.396353889321) | |||
186889 | 186889 | 183225 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2195 Rivera St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 0ft | 5981668.485 | 2100141.7164 | 37.7455262605285 | -122.506123109259 | (37.7455262605285, -122.506123109259) | |||
186888 | 186888 | 175547 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 348 Chicago Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 6ft | 6002373.36986 | 2086487.8856799998 | 37.709233027364995 | -122.433553309758 | (37.709233027365, -122.433553309758) | |||
186863 | 186863 | 131851 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 3601 Baker St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 2ft | 5999147.80126 | 2121174.2853 | 37.8042897678153 | -122.447196024289 | (37.8042897678153, -122.447196024289) | |||
186859 | 186859 | 123006 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 14 06th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5993959.7605 | 2115469.14519 | 37.7883272380259 | -122.464734969158 | (37.7883272380259, -122.464734969158) | |||
186851 | 186851 | 201462 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 221 Catalina St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 5ft | 6017931.88164 | 2096043.5768799998 | 37.736341612873 | -122.380443791448 | (37.736341612873, -122.380443791448) | |||
186846 | 186846 | 203759 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1701 Portola Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 5ft | 5991717.96646 | 2096103.43353 | 37.735024627670896 | -122.471079748847 | (37.7350246276709, -122.471079748847) | |||
186821 | 186821 | 210001 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 153 Vasquez Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5994932.485280001 | 2099460.68455 | 37.744428208809296 | -122.46020924668699 | (37.7444282088093, -122.460209246687) | |||
186812 | 186812 | 219514 | Undocumented 2 | Ulmus americana :: American Elm 119 | 35 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 8ft | 5992615.02777 | 2096610.1814599999 | 37.7364678749865 | -122.468015164161 | (37.7364678749865, -122.468015164161) | |||
186780 | 186780 | 218946 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 15 Merced Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 37 | Width 3ft | 5995278.15169 | 2100133.50673 | 37.7462954873605 | -122.459062719878 | (37.7462954873605, -122.459062719878) | |||
186774 | 186774 | 185814 | Undocumented 2 | :: 54 | 2046 22nd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5989455.7955 | 2101408.9048 | 37.7494609681644 | -122.479288789487 | (37.7494609681644, -122.479288789487) | |||
186769 | 186769 | 217541 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 82 Ventura Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5994344.6097099995 | 2101818.25531 | 37.7508676703211 | -122.462412949005 | (37.7508676703211, -122.462412949005) | |||
186759 | 186759 | 118105 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 3605 Balboa St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 3ft | 5984371.3097 | 2111047.8956 | 37.7756303079856 | -122.497582379578 | (37.7756303079856, -122.497582379578) | |||
186756 | 186756 | 182869 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1847 26th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5988126.7611 | 2102732.0567 | 37.753016709320995 | -122.48398158304701 | (37.753016709321, -122.483981583047) | |||
186744 | 186744 | 135668 | Undocumented 2 | Populus tremuloides :: Quaking aspen 166 | 1214 Montgomery St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 8ft | 6011522.17447 | 2119498.27865 | 37.8003871337117 | -122.404255240203 | (37.8003871337117, -122.404255240203) |
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");