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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 112600 | 112600 | 113194 | DPW Maintained 3 | Pinus thunbergii :: Japanese Black Pine 306 | 699X Noe St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6003039.779709999 | 2104315.51778 | 37.7582214335608 | -122.432522620301 | (37.7582214335608, -122.432522620301) | ||||
| 113148 | 113148 | 104375 | Undocumented 2 | Tree(s) :: 17 | 30 GARDENSIDE DR | 1 | Median : Yard 3 | Landscaping 2 | Private 1 | 50x50 | 5999465.0 | 2102094.0 | 37.7519183246276 | -122.444726043725 | (37.7519183246276, -122.444726043725) | ||||
| 113179 | 113179 | 108043 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2901X SUNSET BLVD OFF RAMP | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 30 | 5985539.0 | 2095817.0 | 37.7338788340947 | -122.492421243764 | (37.7338788340947, -122.492421243764) | ||||
| 115289 | 115289 | 105020 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 101X ORD ST | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6000863.0 | 2105739.0 | 37.7620062865301 | -122.44015292861602 | (37.7620062865301, -122.440152928616) | ||||
| 116375 | 116375 | 99101 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 55x Santa Monica Way | 1 | Median : Yard 3 | Tree 1 | Private 1 | 04/07/2012 12:00:00 AM | Permit Number 768464 | 5993693.6 | 2097654.3 | 37.739396991894104 | -122.464361897304 | (37.7393969918941, -122.464361897304) | |||
| 118289 | 118289 | 114805 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 210X GELLERT DR | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 3x3 | 5985389.0 | 2094462.0 | 37.73014959142171 | -122.492840061243 | (37.7301495914217, -122.492840061243) | |||
| 120340 | 120340 | 96144 | DPW Maintained 3 | Tree(s) :: 17 | 1484X Innes Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6016157.8 | 2096794.1 | 37.7383043442369 | -122.386629906827 | (37.7383043442369, -122.386629906827) | ||||
| 121860 | 121860 | 102111 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 18 Saturn St | 1 | Median : Yard 3 | Tree 1 | Private 1 | 24 | 6000559.0 | 2106017.0 | 37.7627522940794 | -122.441224290546 | (37.7627522940794, -122.441224290546) | ||||
| 122322 | 122322 | 105909 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1864X 14TH AVE | 1 | Median : Yard 3 | Tree 1 | Rec/Park 3 | 14 | 5991829.0 | 2102804.0 | 37.7534290869332 | -122.47118388851999 | (37.7534290869332, -122.47118388852) | ||||
| 123683 | 123683 | 99488 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 800X Miramar Ave | 1 | Median : Yard 3 | Tree 1 | Private 1 | 01/15/2013 12:00:00 AM | 30 | 15x280 | Permit Number 769506 | 5995450.2 | 2094280.5 | 37.7302344585425 | -122.458044289565 | (37.7302344585425, -122.458044289565) | |
| 123736 | 123736 | 234368 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1750x Dolores St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | 6005333.75186 | 2098133.92444 | 37.7413780222889 | -122.42414944174 | (37.7413780222889, -122.42414944174) | ||||
| 123989 | 123989 | 215225 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 500x Miramar Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 39 | 5995372.41973 | 2092668.0374099999 | 37.7258025558202 | -122.458196526156 | (37.7258025558202, -122.458196526156) | ||||
| 127178 | 127178 | 108238 | Undocumented 2 | Tree(s) :: 17 | 764x JUNIPERO SERRA BLVD | 1 | Median : Yard 3 | Tree 1 | Private 1 | 5991289.6 | 2092496.8 | 37.7250969308873 | -122.47229792145599 | (37.7250969308873, -122.472297921456) | |||||
| 131405 | 131405 | 194320 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 400x The Embarcadero | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | Width 7ft | 6014831.89764 | 2117081.36813 | 37.7939352489635 | -122.392633022622 | (37.7939352489635, -122.392633022622) | |||
| 131484 | 131484 | 132028 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 33x Battery St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | 6012842.61776 | 2116100.99756 | 37.7911327033699 | -122.39944731163901 | (37.7911327033699, -122.399447311639) | ||||
| 133406 | 133406 | 221302 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 3400x Cesar Chavez St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | Width 10ft | 6007028.6086800005 | 2100564.17932 | 37.7481465061591 | -122.418461487031 | (37.7481465061591, -122.418461487031) | |||
| 133649 | 133649 | 234347 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 550x Dolores St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 28 | 6004944.62757 | 2105117.25917 | 37.760530661773 | -122.425991895418 | (37.760530661773, -122.425991895418) | ||||
| 133666 | 133666 | 135589 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 150x Drumm St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | Width 7ft | 6013690.1191300005 | 2117409.79568 | 37.79477355652 | -122.396606749907 | (37.79477355652, -122.396606749907) | |||
| 134092 | 134092 | 194378 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 300x The Embarcadero | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | Width 8ft | 6015852.133669999 | 2115594.9283 | 37.7899104347693 | -122.388999044794 | (37.7899104347693, -122.388999044794) | |||
| 135502 | 135502 | 249477 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1300x Van Ness Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 19 | 6006355.55828 | 2115049.12823 | 37.7878808258785 | -122.421817614792 | (37.7878808258785, -122.421817614792) | ||||
| 135572 | 135572 | 221334 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 90x Peralta Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | Width 10ft | 6010340.53234 | 2100283.1811900004 | 37.747560836176 | -122.406989109071 | (37.747560836176, -122.406989109071) | |||
| 135595 | 135595 | 248774 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 10x Lyell St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | Width 10ft | 6003001.138169999 | 2095064.3103599998 | 37.7328175852443 | -122.43199565878 | (37.7328175852443, -122.43199565878) | |||
| 136109 | 136109 | 223862 | DPW Maintained 3 | Cussonia spicata :: Cabbage tree 325 | 3700x Cesar Chavez St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | Width 10ft | 6005812.2615 | 2100535.54919 | 37.7479993446903 | -122.42266554600401 | (37.7479993446903, -122.422665546004) | |||
| 136110 | 136110 | 178033 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1378x Geneva Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | 6002471.97564 | 2087830.38013 | 37.712924818104 | -122.433308378475 | (37.712924818104, -122.433308378475) | ||||
| 136198 | 136198 | 247576 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 350x Alemany Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | 6008435.75806 | 2095170.56175 | 37.733415932988 | -122.413214248635 | (37.733415932988, -122.413214248635) | ||||
| 136588 | 136588 | 196772 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 1200x Owen St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | 6013659.43182 | 2108608.5315799997 | 37.770605597593395 | -122.396095834269 | (37.7706055975934, -122.396095834269) | ||||
| 136852 | 136852 | 212119 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2101x Monterey Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 30 | Width 10ft | 5991843.73604 | 2095437.8769099999 | 37.7332044502098 | -122.47059646305 | (37.7332044502098, -122.47059646305) | |||
| 138030 | 138030 | 242370 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 90x McCoppin St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | Width 10ft | 6006121.14049 | 2109126.61017 | 37.7716058118802 | -122.422207723609 | (37.7716058118802, -122.422207723609) | |||
| 138714 | 138714 | 99482 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 700X Miramar Ave | 1 | Median : Yard 3 | Tree 1 | Private 1 | 01/15/2013 12:00:00 AM | 30 | 15x280 | Permit Number 769506 | 5995446.3 | 2094052.9 | 37.7296092999141 | -122.458041307204 | (37.7296092999141, -122.458041307204) | |
| 140384 | 140384 | 104978 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 66X San Lorenzo Way | 1 | Median : Yard 3 | Tree 1 | Private 1 | Permit Number 770332 | 5993690.5 | 2097533.7 | 37.7390656757525 | -122.46436386193301 | (37.7390656757525, -122.464363861933) | ||||
| 141156 | 141156 | 104399 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2440X 37th Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 5984875.46821 | 2098521.80546 | 37.7412666886784 | -122.49491460561501 | (37.7412666886784, -122.494914605615) | |||||
| 141372 | 141372 | 104398 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 3525X Ulloa St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 48 | 5985120.1668300005 | 2098189.34613 | 37.7403681660846 | -122.494044040088 | (37.7403681660846, -122.494044040088) | ||||
| 141717 | 141717 | 111239 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 399x LIBERTY ST | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 40 | 3x3 | 6003700.0 | 2103889.0 | 37.7570877346209 | -122.430208863755 | (37.7570877346209, -122.430208863755) | |||
| 142482 | 142482 | 96128 | DPW Maintained 3 | Tree(s) :: 17 | 1420X Innes Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6016441.6 | 2096581.1 | 37.7377351967413 | -122.385633815961 | (37.7377351967413, -122.385633815961) | ||||
| 142588 | 142588 | 104374 | Undocumented 2 | Tree(s) :: 17 | 22 GARDENSIDE DR | 1 | Median : Yard 3 | Landscaping 2 | Private 1 | 50x50 | 5999468.0 | 2101996.0 | 37.7516494117124 | -122.444708626009 | (37.7516494117124, -122.444708626009) | ||||
| 144760 | 144760 | 104926 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 810 Gonzalez Dr | 1 | Median : Yard 3 | Tree 1 | Private 1 | 5990385.0 | 2090588.0 | 37.7198034465129 | -122.47528570222 | (37.7198034465129, -122.47528570222) | |||||
| 145598 | 145598 | 96143 | DPW Maintained 3 | Tree(s) :: 17 | 1470X Innes Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6016219.9 | 2096747.5 | 37.738179827823 | -122.38641194538201 | (37.738179827823, -122.386411945382) | ||||
| 146005 | 146005 | 191802 | DPW Maintained 3 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 180x Bay Shore Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | 6011170.05761 | 2099578.4094700003 | 37.745672070114395 | -122.404071054532 | (37.7456720701144, -122.404071054532) | ||||
| 148993 | 148993 | 212151 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800x Miramar Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 5995396.67937 | 2094269.52475 | 37.7302012478931 | -122.458228522241 | (37.7302012478931, -122.458228522241) | ||||
| 149997 | 149997 | 221282 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 100x McCoppin St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | Width 7ft | 6005974.66789 | 2109113.44306 | 37.7715613952811 | -122.42271344567301 | (37.7715613952811, -122.422713445673) | |||
| 150963 | 150963 | 211108 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 335x Pacheco St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | Width 8ft | 5994231.73864 | 2100997.1049200003 | 37.748606499504106 | -122.462743701679 | (37.7486064995041, -122.462743701679) | |||
| 151880 | 151880 | 251078 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 5100x Geary Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5991099.7276 | 2112702.723 | 37.7805661077577 | -122.474428154783 | (37.7805661077577, -122.474428154783) | |||
| 152768 | 152768 | 194354 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 380x The Embarcadero | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | Width 8ft | 6016129.928040001 | 2113821.08982 | 37.7850552711313 | -122.387914064893 | (37.7850552711313, -122.387914064893) | |||
| 155002 | 155002 | 195465 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 450x The Embarcadero | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | 6014600.5066599995 | 2117288.76118 | 37.794491848365205 | -122.39344818519899 | (37.7944918483652, -122.393448185199) | ||||
| 156264 | 156264 | 212113 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1902x Monterey Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 26 | Width 10ft | 5992332.7127 | 2095408.39507 | 37.7331517634298 | -122.46890380855899 | (37.7331517634298, -122.468903808559) | |||
| 156879 | 156879 | 233941 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 370x Dolores St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 32 | 6004887.91201 | 2106172.4684599997 | 37.7634248105293 | -122.426263176805 | (37.7634248105293, -122.426263176805) | ||||
| 157626 | 157626 | 251106 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 6300x Geary Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5987426.0529 | 2112570.9396 | 37.779990741259 | -122.48712729528201 | (37.779990741259, -122.487127295282) | |||
| 157761 | 157761 | 116545 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1041x Naples St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 3x3 | 6001537.057630001 | 2088100.5912 | 37.7136136745151 | -122.436559085032 | (37.7136136745151, -122.436559085032) | |||
| 158486 | 158486 | 221320 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 3200x Cesar Chavez St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | Width 10ft | 6008271.26847 | 2100572.43199 | 37.7482390437115 | -122.414164981352 | (37.7482390437115, -122.414164981352) | |||
| 159868 | 159868 | 190994 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 50x Dedman Ct | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 37 | 6016552.89235 | 2096279.67285 | 37.736913695911 | -122.385228023775 | (37.736913695911, -122.385228023775) | ||||
| 160297 | 160297 | 211599 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 500x Saint Francis Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 17 | 5993337.92227 | 2096074.08591 | 37.7350376103014 | -122.46547689966499 | (37.7350376103014, -122.465476899665) | ||||
| 160700 | 160700 | 211630 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 605x Saint Francis Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 28 | 5993569.69584 | 2096076.2401 | 37.7350568899517 | -122.464675738601 | (37.7350568899517, -122.464675738601) | ||||
| 160927 | 160927 | 242373 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2x McCoppin St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | Width 9ft | 6006573.34583 | 2109150.3275 | 37.771696430266 | -122.420645200112 | (37.771696430266, -122.420645200112) | |||
| 161954 | 161954 | 234349 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 600x Dolores St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 29 | 6004962.28051 | 2104795.65924 | 37.7596486220069 | -122.42590794909599 | (37.7596486220069, -122.425907949096) | ||||
| 162038 | 162038 | 211594 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 500x Saint Francis Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | 5993241.397369999 | 2096024.08182 | 37.7348947439874 | -122.465806985911 | (37.7348947439874, -122.465806985911) | ||||
| 164068 | 164068 | 221311 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 3500x Cesar Chavez St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | Width 10ft | 6006340.93025 | 2100564.31807 | 37.7481081500844 | -122.42083946986799 | (37.7481081500844, -122.420839469868) | |||
| 164848 | 164848 | 234326 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 850x Dolores St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | 6005043.60607 | 2103360.12702 | 37.755711583428294 | -122.425524518639 | (37.7557115834283, -122.425524518639) | ||||
| 164866 | 164866 | 125484 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 1237x Robert C Levy Tunl | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 6007648.69076 | 2118115.73393 | 37.796373807471 | -122.41756103092699 | (37.796373807471, -122.417561030927) | ||||
| 166867 | 166867 | 132106 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1500x The Embarcadero | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | Width 10ft | 6011673.52168 | 2121373.1691 | 37.8055435810345 | -122.40386352159099 | (37.8055435810345, -122.403863521591) | |||
| 167787 | 167787 | 234517 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 10x Benton Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 29 | 6004828.724280001 | 2095028.54608 | 37.7328228256069 | -122.425674682059 | (37.7328228256069, -122.425674682059) | ||||
| 167933 | 167933 | 209105 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 600x Faxon Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 31 | 5994942.183230001 | 2092612.57817 | 37.7256255467665 | -122.459679796903 | (37.7256255467665, -122.459679796903) | ||||
| 168306 | 168306 | 206810 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 66x Santa Monica Way | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | 5993662.74276 | 2097416.4076799997 | 37.7387420203269 | -122.464451319071 | (37.7387420203269, -122.464451319071) | ||||
| 169889 | 169889 | 249473 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1100x Van Ness Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | 6006432.644069999 | 2114489.3949 | 37.7863482830936 | -122.42151114382901 | (37.7863482830936, -122.421511143829) | ||||
| 170554 | 170554 | 228078 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 200x College Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | Width 10ft | 6005173.9664 | 2095916.21021 | 37.7352796556316 | -122.424544210856 | (37.7352796556316, -122.424544210856) | |||
| 173687 | 173687 | 247023 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 550x Valley St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | 6002381.071819999 | 2099185.81683 | 37.7440991162756 | -122.43443395738599 | (37.7440991162756, -122.434433957386) | ||||
| 176711 | 176711 | 251042 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 5500x Geary Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5989852.8157 | 2112655.9311 | 37.7803653089721 | -122.47873834484899 | (37.7803653089721, -122.478738344849) | |||
| 177514 | 177514 | 177792 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 290x Rolph St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | Width 8ft | 6001464.09036 | 2088085.72956 | 37.7135687209947 | -122.43681022251499 | (37.7135687209947, -122.436810222515) | |||
| 178229 | 178229 | 246557 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2x Octavia St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | Width 7ft | 6005728.07536 | 2109359.1735900003 | 37.7722221964256 | -122.4235838977 | (37.7722221964256, -122.4235838977) | |||
| 182720 | 182720 | 247577 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 300x Alemany Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 44 | 6008700.9232 | 2095336.3735 | 37.7338860994661 | -122.41230921050501 | (37.7338860994661, -122.412309210505) | ||||
| 184455 | 184455 | 220705 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 3300x Cesar Chavez St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | Width 10ft | 6007530.958190001 | 2100569.16609 | 37.748188465819794 | -122.416724727984 | (37.7481884658198, -122.416724727984) | |||
| 185624 | 185624 | 212116 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2001x Monterey Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 26 | Width 10ft | 5992083.71687 | 2095423.23256 | 37.7331781144806 | -122.469765726035 | (37.7331781144806, -122.469765726035) | |||
| 187052 | 187052 | 251050 | DPW Maintained 3 | Pinus Spp :: Pine Spp 105 | 5800x Geary Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | Width 10ft | 5988878.2157 | 2112618.8979 | 37.780206989324796 | -122.48210718666901 | (37.7802069893248, -122.482107186669) | |||
| 187577 | 187577 | 205961 | DPW Maintained 3 | Cedrus deodara :: Deodar Cedar 129 | 600x Wildwood Way | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 16 | 5995381.06521 | 2093316.38835 | 37.7275832683311 | -122.458213544042 | (37.7275832683311, -122.458213544042) | ||||
| 187703 | 187703 | 187521 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 100x Mary Teresa St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | Width 9ft | 6012597.41848 | 2087914.4030799998 | 37.7137247587658 | -122.398317184005 | (37.7137247587658, -122.398317184005) | |||
| 187741 | 187741 | 248647 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2x Lyell St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | 6002988.020959999 | 2095088.4577900001 | 37.73288314494071 | -122.432042732011 | (37.7328831449407, -122.432042732011) | ||||
| 188939 | 188939 | 212143 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 650x Miramar Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 5995395.28868 | 2093711.39383 | 37.7286686754144 | -122.45819295046199 | (37.7286686754144, -122.458192950462) | ||||
| 749 | 749 | 251374 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 401 Portola Dr | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 5998962.0 | 2100210.0 | 37.7467166026546 | -122.446329965078 | (37.7467166026546, -122.446329965078) | |||||
| 9925 | 9925 | 173735 | Undocumented 2 | Tree(s) :: 17 | 2500X Lyon St | 2 | Median : Yard 3 | Tree 1 | Private 1 | 01/10/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779102 | 5999276.0 | 2117538.0 | 37.794312827392396 | -122.446490617691 | (37.7943128273924, -122.446490617691) | |
| 22832 | 22832 | 251108 | Landmark tree 9 | Phoenix canariensis :: Canary Island Date Palm 100 | 1700X Quesada Ave | 2 | Median : Yard 3 | Tree 1 | DPW 2 | ||||||||||
| 24462 | 24462 | 211631 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 605x Saint Francis Blvd | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | 5993552.90123 | 2096075.99565 | 37.735055250506704 | -122.464733785358 | (37.7350552505067, -122.464733785358) | ||||
| 24519 | 24519 | 206820 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 335x Pacheco St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 28 | Width 8ft | 5994214.91647 | 2101031.13143 | 37.7486989587999 | -122.462804340247 | (37.7486989587999, -122.462804340247) | |||
| 25604 | 25604 | 250134 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 2550x Lyon St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 5999224.86929 | 2117537.18532 | 37.7943076699218 | -122.446667476532 | (37.7943076699218, -122.446667476532) | ||||
| 26465 | 26465 | 213721 | DPW Maintained 3 | Prunus x yedoensis :: Yoshino Cherry 237 | 66x Santa Monica Way | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | 5993647.57824 | 2097426.08398 | 37.7387677148629 | -122.46450445281401 | (37.7387677148629, -122.464504452814) | ||||
| 26492 | 26492 | 242374 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2x McCoppin St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | Width 9ft | 6006546.0037 | 2109148.1970900004 | 37.771689039651896 | -122.42073962714899 | (37.7716890396519, -122.420739627149) | |||
| 26820 | 26820 | 212114 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1902x Monterey Blvd | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 36 | Width 10ft | 5992265.63325 | 2095412.1953200002 | 37.7331583221951 | -122.46913599464399 | (37.7331583221951, -122.469135994644) | |||
| 27286 | 27286 | 132113 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1000x The Embarcadero | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | Width 10ft | 6013330.52243 | 2119204.92075 | 37.7996825238869 | -122.39797700193701 | (37.7996825238869, -122.397977001937) | |||
| 27830 | 27830 | 195766 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 700x King St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | Width 8ft | 6014104.3852699995 | 2110532.00713 | 37.7759117775522 | -122.394691443959 | (37.7759117775522, -122.394691443959) | |||
| 27995 | 27995 | 211600 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 500x Saint Francis Blvd | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | 5993318.7926 | 2096075.03242 | 37.7350391058631 | -122.465543105951 | (37.7350391058631, -122.465543105951) | ||||
| 29345 | 29345 | 196269 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 50x Dedman Ct | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6016851.53049 | 2096187.80946 | 37.7366779736991 | -122.38418909364599 | (37.7366779736991, -122.384189093646) | ||||
| 29486 | 29486 | 212111 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1802x Monterey Blvd | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | Width 10ft | 5992507.56631 | 2095396.9538900002 | 37.7331304494932 | -122.46829846591801 | (37.7331304494932, -122.468298465918) | |||
| 29492 | 29492 | 194379 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 300x The Embarcadero | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 30 | Width 8ft | 6015888.45756 | 2115624.95631 | 37.7899948982019 | -122.388875463533 | (37.7899948982019, -122.388875463533) | |||
| 31237 | 31237 | 124292 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4401x Cornwall St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | Width 7ft | 5993800.52883 | 2114192.89776 | 37.7848138297402 | -122.465193144089 | (37.7848138297402, -122.465193144089) | |||
| 31865 | 31865 | 195466 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 450x The Embarcadero | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | 6014635.8418 | 2117314.36588 | 37.794564116081204 | -122.393327712917 | (37.7945641160812, -122.393327712917) | ||||
| 32049 | 32049 | 211072 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 602x Miramar Ave | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 35 | 5995382.34021 | 2093429.0746900002 | 37.7278927511259 | -122.45821728880699 | (37.7278927511259, -122.458217288807) | ||||
| 32359 | 32359 | 191816 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1300x De Haro St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 6012277.20441 | 2102232.55885 | 37.7530215888816 | -122.40042907904899 | (37.7530215888816, -122.400429079049) | ||||
| 32767 | 32767 | 221303 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 3400x Cesar Chavez St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | Width 10ft | 6007015.521380001 | 2100564.44765 | 37.7481465061704 | -122.4185067616 | (37.7481465061704, -122.4185067616) | |||
| 33038 | 33038 | 217725 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 150x Lincoln Way | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | Width 8ft | 5995229.4341400005 | 2107380.1669099997 | 37.766190168267 | -122.45975599017099 | (37.766190168267, -122.459755990171) | |||
| 33946 | 33946 | 211008 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 700x Bosworth St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 33 | Width 10ft | 6002060.330030001 | 2095430.49234 | 37.7337696552405 | -122.435274449372 | (37.7337696552405, -122.435274449372) | |||
| 34570 | 34570 | 251048 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 5700x Geary Blvd | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5989255.4598 | 2112633.0799 | 37.7802678632993 | -122.480803179963 | (37.7802678632993, -122.480803179963) | |||
| 35512 | 35512 | 249464 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 900x Van Ness Ave | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | 6006534.583819999 | 2113721.77463 | 37.7842463336479 | -122.421103932595 | (37.7842463336479, -122.421103932595) |
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");