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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
23396 | 23396 | 218586 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3666 19th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 3ft | 5990534.77048 | 2091965.7217599999 | 37.7235950079882 | -122.474868513494 | (37.7235950079882, -122.474868513494) | |||
23401 | 23401 | 202171 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 20 Kalmanovitz St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 2ft | 6013157.586080001 | 2093193.49557 | 37.7282512748665 | -122.39675089323799 | (37.7282512748665, -122.396750893238) | |||
23402 | 23402 | 123384 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 735 03rd Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 4ft | 5995024.54572 | 2110548.53973 | 37.7748779041184 | -122.460694283234 | (37.7748779041184, -122.460694283234) | |||
23409 | 23409 | 218091 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 62 Eastwood Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5995658.864080001 | 2092992.02847 | 37.726708612908 | -122.45722974236601 | (37.726708612908, -122.457229742366) | |||
23417 | 23417 | 183167 | Undocumented 2 | :: 54 | 2422 45th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5982411.0498 | 2098597.3573 | 37.741329561902596 | -122.50344114283101 | (37.7413295619026, -122.503441142831) | |||
23425 | 23425 | 236043 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 821 Duboce Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 3ft | 6001824.27489 | 2108233.40905 | 37.768910001429 | -122.43700684760701 | (37.768910001429, -122.437006847607) | |||
23431 | 23431 | 213073 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 50 Castenada Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5994467.524230001 | 2101712.07423 | 37.7505832012692 | -122.46198020334299 | (37.7505832012692, -122.461980203343) | |||
23444 | 23444 | 201445 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 50 Middle Point Rd | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 5ft | 6018205.83588 | 2096062.22823 | 37.7364079387746 | -122.379497902505 | (37.7364079387746, -122.379497902505) | |||
23445 | 23445 | 222731 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 1435 Douglass St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 2ft | 6001402.34337 | 2099545.22287 | 37.7450303552734 | -122.437843913168 | (37.7450303552734, -122.437843913168) | |||
23447 | 23447 | 140934 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 120 JORDAN AVE | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 0ft | 5996249.4558 | 2113606.8719 | 37.7833456744969 | -122.456678312901 | (37.7833456744969, -122.456678312901) | |||
23448 | 23448 | 121887 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 50 18th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 5ft | 5990232.62779 | 2114784.35142 | 37.78623140306821 | -122.47758002792801 | (37.7862314030682, -122.477580027928) | |||
23452 | 23452 | 207071 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1927 08th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 6ft | 5993749.481269999 | 2102344.6615 | 37.752278758765605 | -122.464509159894 | (37.7522787587656, -122.464509159894) | |||
23456 | 23456 | 122922 | Undocumented 2 | Crateagus spp :: Hawthorn 160 | 2 11th Ave | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 6ft | 5992430.88304 | 2114907.16681 | 37.7866959384714 | -122.469983652903 | (37.7866959384714, -122.469983652903) | |||
23481 | 23481 | 218410 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 205 Castenada Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 5994280.90702 | 2100599.38004 | 37.7475172792951 | -122.462544833698 | (37.7475172792951, -122.462544833698) | |||
23485 | 23485 | 206309 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 226 Sadowa St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 3ft | 5994744.569130001 | 2087779.6169999999 | 37.712344021541796 | -122.46001297051599 | (37.7123440215418, -122.460012970516) | |||
23492 | 23492 | 202174 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 100 Kalmanovitz St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | Width 2ft | 6013138.83373 | 2093054.0318599998 | 37.7278672922301 | -122.39680594795401 | (37.7278672922301, -122.396805947954) | |||
23514 | 23514 | 190971 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800 Vermont St | 11 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 42 | 6011272.24417 | 2104307.20268 | 37.7586620081736 | -122.40405043579099 | (37.7586620081736, -122.404050435791) | ||||
23523 | 23523 | 208876 | Undocumented 2 | Malus :: Crab Apple 235 | 24 Sotelo Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5993960.680430001 | 2101012.29566 | 37.7486325942246 | -122.463682112736 | (37.7486325942246, -122.463682112736) | |||
23530 | 23530 | 222049 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 201 Treat Ave | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 6ft | 6008976.23011 | 2107818.47181 | 37.768174596097104 | -122.41223929451401 | (37.7681745960971, -122.412239294514) | |||
23531 | 23531 | 212068 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 65 San Pablo Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | Width 6ft | 5994349.34377 | 2097659.88165 | 37.7394500943456 | -122.46209504585501 | (37.7394500943456, -122.462095045855) | |||
23538 | 23538 | 213933 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2176 16th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5991344.08373 | 2100608.05246 | 37.7473715261751 | -122.472700716564 | (37.7473715261751, -122.472700716564) | |||
23539 | 23539 | 122063 | Undocumented 2 | Ilex spp :: Holly Species 163 | 5 17th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 5ft | 5990505.08019 | 2115005.32961 | 37.786853953760705 | -122.476653573827 | (37.7868539537607, -122.476653573827) | |||
23557 | 23557 | 213451 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4 Cortes Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 3ft | 5993177.52134 | 2099659.6696900004 | 37.7448734694269 | -122.466291957027 | (37.7448734694269, -122.466291957027) | |||
23577 | 23577 | 118033 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 89 Shore View Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 6ft | 5984120.82492 | 2112822.3596099997 | 37.780487786596204 | -122.498579960483 | (37.7804877865962, -122.498579960483) | |||
23592 | 23592 | 218660 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 70 Eastwood Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 3ft | 5995653.32428 | 2093064.51564 | 37.726907327111 | -122.45725413468901 | (37.726907327111, -122.457254134689) | |||
23600 | 23600 | 135193 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 35 Bay St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | Width 8ft | 6010885.4927900005 | 2121705.9799599997 | 37.806413341469 | -122.40661408636801 | (37.806413341469, -122.406614086368) | |||
23638 | 23638 | 179012 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 575 Lisbon St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 6ft | 6001860.73543 | 2090148.2767900003 | 37.719254552441704 | -122.435586742551 | (37.7192545524417, -122.435586742551) | |||
23640 | 23640 | 218911 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 623 Laguna Honda Blvd | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 4ft | 5995731.43182 | 2099885.12493 | 37.745639539837605 | -122.457477374284 | (37.7456395398376, -122.457477374284) | |||
23652 | 23652 | 210826 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 62 Castenada Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 3ft | 5994426.39557 | 2101510.85772 | 37.7500283438364 | -122.462107837801 | (37.7500283438364, -122.462107837801) | |||
23683 | 23683 | 250745 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2850 Lake St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 23 | Width 4ft | 5986584.92122 | 2114476.3273400003 | 37.7851733080538 | -122.490177303062 | (37.7851733080538, -122.490177303062) | |||
23686 | 23686 | 250437 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 95 Seacliff Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 4ft | 5987583.4221 | 2115772.2854400002 | 37.7887898983715 | -122.48681804471902 | (37.7887898983715, -122.486818044719) | |||
23689 | 23689 | 185447 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2400 Sunset Blvd | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 0ft | 5985080.5667 | 2098519.0396 | 37.7412710983901 | -122.494205254183 | (37.7412710983901, -122.494205254183) | |||
23696 | 23696 | 212999 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1639 08th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 5993681.9391 | 2104325.0016900003 | 37.7577123690443 | -122.46488653520201 | (37.7577123690443, -122.464886535202) | |||
23722 | 23722 | 206382 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 6 San Pablo Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 5994455.43125 | 2097793.85045 | 37.7398240468482 | -122.46173795563601 | (37.7398240468482, -122.461737955636) | |||
23724 | 23724 | 181665 | Undocumented 2 | :: 54 | 1275 34th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985511.3315 | 2106531.7973 | 37.7632971348656 | -122.49330603001499 | (37.7632971348656, -122.493306030015) | |||
23735 | 23735 | 213223 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 18 Lobos St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | 5996685.56427 | 2088703.70423 | 37.7149927956564 | -122.45337101855101 | (37.7149927956564, -122.453371018551) | ||||
23738 | 23738 | 215457 | Undocumented 2 | Ulmus americana :: American Elm 119 | 170 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 5ft | 5992608.79004 | 2095578.76173 | 37.7336354943765 | -122.467961730965 | (37.7336354943765, -122.467961730965) | |||
23761 | 23761 | 123510 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2714 Fulton St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | Width 8ft | 5994935.84099 | 2110268.0504400004 | 37.774102650784 | -122.460980795496 | (37.774102650784, -122.460980795496) | |||
23763 | 23763 | 194461 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 2000 25th St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 27 | 6012563.257130001 | 2101880.94422 | 37.7520720792617 | -122.399415164477 | (37.7520720792617, -122.399415164477) | ||||
23769 | 23769 | 133285 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2800 Divisadero St | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 6ft | 6000622.64068 | 2117960.51369 | 37.7955497631676 | -122.44186143746401 | (37.7955497631676, -122.441861437464) | |||
23775 | 23775 | 250341 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 26 25th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 3ft | 5988236.1256800005 | 2115814.85446 | 37.7889448119981 | -122.48456293444599 | (37.7889448119981, -122.484562934446) | |||
23777 | 23777 | 183752 | Undocumented 2 | :: 54 | 2287 27th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5987917.4443 | 2099749.9687 | 37.7448165037016 | -122.484486720736 | (37.7448165037016, -122.484486720736) | |||
23791 | 23791 | 245271 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 217 Ogden Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 6008459.65813 | 2096082.8630400002 | 37.7359222563084 | -122.41319610842501 | (37.7359222563084, -122.413196108425) | |||
23835 | 23835 | 182329 | Undocumented 2 | :: 54 | 1501 34th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985565.7361 | 2104954.3084 | 37.75896897093661 | -122.493001657059 | (37.7589689709366, -122.493001657059) | |||
23876 | 23876 | 218979 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 551 Junipero Serra Blvd | 18 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5991462.95986 | 2093729.88952 | 37.7284927194476 | -122.47178846497101 | (37.7284927194476, -122.471788464971) | |||
23886 | 23886 | 134083 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2500 Vallejo St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 4ft | 6001536.65742 | 2117684.63588 | 37.7948443142773 | -122.43867901012399 | (37.7948443142773, -122.438679010124) | |||
23888 | 23888 | 209236 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 32 Malta Dr | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 3ft | 5999655.9462 | 2095979.13545 | 37.735139265160704 | -122.443626491896 | (37.7351392651607, -122.443626491896) | |||
23898 | 23898 | 246421 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 400 Duncan St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 6003840.654080001 | 2099855.1968900003 | 37.7460198226686 | -122.429434772709 | (37.7460198226686, -122.429434772709) | |||
23904 | 23904 | 122926 | Undocumented 2 | Betula pendula :: European White Birch 146 | 2 11th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 6ft | 5992433.415569999 | 2114874.23335 | 37.7866056586788 | -122.46997249221701 | (37.7866056586788, -122.469972492217) | |||
23910 | 23910 | 118018 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 492 37th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 1ft | 5984413.88926 | 2112528.9426700003 | 37.779699331346 | -122.49754445899099 | (37.779699331346, -122.497544458991) | |||
23912 | 23912 | 118028 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 51 Shore View Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 5984316.15967 | 2112798.24876 | 37.780433038793 | -122.49790243493 | (37.780433038793, -122.49790243493) | |||
23915 | 23915 | 201200 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 700 Folsom St | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 6012679.9726 | 2113219.2905 | 37.7832111428923 | -122.399807626404 | (37.7832111428923, -122.399807626404) | |||
23922 | 23922 | 208951 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 440 Saint Francis Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 40 | Width 10ft | 5993021.57409 | 2096009.5815299999 | 37.734842246953896 | -122.46656593187099 | (37.7348422469539, -122.466565931871) | |||
23926 | 23926 | 181820 | Undocumented 2 | :: 54 | 2299 Santiago St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985846.0311 | 2099546.7997 | 37.7441378151504 | -122.491634223287 | (37.7441378151504, -122.491634223287) | |||
23936 | 23936 | 211142 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 100 Terrace Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 31 | 5993344.399119999 | 2096880.05499 | 37.7372509740365 | -122.465513038912 | (37.7372509740365, -122.465513038912) | ||||
23941 | 23941 | 250276 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 43 United Nations Plz | 17 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 0ft | 6008392.62375 | 2112125.224 | 37.7799671560941 | -122.414562734397 | (37.7799671560941, -122.414562734397) | |||
23950 | 23950 | 184234 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1560 43rd Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 5982828.9188 | 2104533.9152 | 37.7576542549583 | -122.502435587448 | (37.7576542549583, -122.502435587448) | |||
23953 | 23953 | 211938 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 49 Marcela Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 4ft | 5994751.80445 | 2100714.33163 | 37.747860014539704 | -122.46092484170201 | (37.7478600145397, -122.460924841702) | |||
23989 | 23989 | 206572 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 51 Cortes Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5993215.16949 | 2099646.04946 | 37.7448382439064 | -122.466160788211 | (37.7448382439064, -122.466160788211) | |||
24024 | 24024 | 206902 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 901 Monterey Blvd | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5996057.83075 | 2094626.65779 | 37.7312198182223 | -122.45596865725 | (37.7312198182223, -122.45596865725) | |||
24030 | 24030 | 136773 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3700 Clay St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 5ft | 5997087.63405 | 2115382.9814299997 | 37.7882704886466 | -122.453906871501 | (37.7882704886466, -122.453906871501) | |||
24031 | 24031 | 206557 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 517 Laguna Honda Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5995503.23656 | 2100160.4413400004 | 37.7463823798599 | -122.458286357642 | (37.7463823798599, -122.458286357642) | |||
24035 | 24035 | 178607 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 5990327.66617 | 2089955.55198 | 37.7180635775375 | -122.47543773036101 | (37.7180635775375, -122.475437730361) | ||||
24044 | 24044 | 219480 | Undocumented 2 | Ulmus americana :: American Elm 119 | 40 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 8ft | 5992573.35664 | 2096580.23843 | 37.736383252376704 | -122.468157060102 | (37.7363832523767, -122.468157060102) | |||
24050 | 24050 | 209682 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1849 15th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5991553.31162 | 2102854.2151599997 | 37.7535510143851 | -122.472140928188 | (37.7535510143851, -122.472140928188) | |||
24053 | 24053 | 181971 | Undocumented 2 | :: 54 | 2467 34th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985787.1457 | 2098434.4072 | 37.7410800425161 | -122.49175595946801 | (37.7410800425161, -122.491755959468) | |||
24061 | 24061 | 190934 | Undocumented 2 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 1101 25th St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 9ft | 6015168.60212 | 2102024.17667 | 37.752610233591206 | -122.390415424833 | (37.7526102335912, -122.390415424833) | |||
24069 | 24069 | 204989 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 491 Ulloa St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 5995151.4003 | 2098200.0926599996 | 37.7409795263895 | -122.459361016022 | (37.7409795263895, -122.459361016022) | |||
24081 | 24081 | 183742 | Undocumented 2 | :: 54 | 2278 25th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5988578.8889999995 | 2099828.4885 | 37.745070593746796 | -122.482205348546 | (37.7450705937468, -122.482205348546) | |||
24085 | 24085 | 212387 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 95 San Rafael Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 6ft | 5991919.26492 | 2095494.2164099999 | 37.7333635115101 | -122.47033944313499 | (37.7333635115101, -122.470339443135) | |||
24094 | 24094 | 118130 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 3329 Balboa St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5985237.75106 | 2111079.5821 | 37.775768059624504 | -122.494587526681 | (37.7757680596245, -122.494587526681) | |||
24097 | 24097 | 177096 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 0 Serrano Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 32 | 5989524.60255 | 2090740.4518099998 | 37.720172132521206 | -122.47827090148199 | (37.7201721325212, -122.478270901482) | ||||
24099 | 24099 | 250414 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 39 Seacliff Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 4ft | 5987974.43162 | 2115795.37764 | 37.788876091197096 | -122.485466919461 | (37.7888760911971, -122.485466919461) | |||
24101 | 24101 | 141230 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 16 COMMONWEALTH AVE | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 0ft | 5996536.7759 | 2114447.1732 | 37.7856694107907 | -122.45574506618999 | (37.7856694107907, -122.45574506619) | |||
24106 | 24106 | 246790 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 175 Brewster St | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 6010136.6415 | 2098750.10917 | 37.74333994367979 | -122.40758608083901 | (37.7433399436798, -122.407586080839) | ||||
24126 | 24126 | 138818 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 723 Grove St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 0ft | 6004379.6433 | 2111160.4787 | 37.7770919345009 | -122.428376650964 | (37.7770919345009, -122.428376650964) | |||
24131 | 24131 | 230898 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 11 Clarendon Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 2ft | 5998114.42055 | 2104641.61422 | 37.758836276097796 | -122.44958007486 | (37.7588362760978, -122.44958007486) | |||
24148 | 24148 | 182529 | Undocumented 2 | :: 54 | 1583 32nd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986203.973999999 | 2104470.5925 | 37.7576781250927 | -122.490758769583 | (37.7576781250927, -122.490758769583) | |||
24162 | 24162 | 215566 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 250 Santa Paula Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5993936.1007 | 2096327.5375 | 37.735768007292705 | -122.463427186434 | (37.7357680072927, -122.463427186434) | |||
24170 | 24170 | 206058 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 95 Marston Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 5998836.80822 | 2093173.9716299998 | 37.727390192897 | -122.44625681279899 | (37.727390192897, -122.446256812799) | ||||
24183 | 24183 | 175768 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 0 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 5989578.68884 | 2089185.3656400002 | 37.7159053925979 | -122.47797031747801 | (37.7159053925979, -122.477970317478) | ||||
24193 | 24193 | 127237 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1600 Broadway | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 3ft | 6001081.5481199995 | 2117269.05753 | 37.7936773440867 | -122.440223932108 | (37.7936773440867, -122.440223932108) | |||
24206 | 24206 | 181982 | Undocumented 2 | :: 54 | 2479 31st Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986720.0054 | 2098392.2737 | 37.7410188327151 | -122.488527415956 | (37.7410188327151, -122.488527415956) | |||
24210 | 24210 | 243997 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 483 Valley St | 13 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | 6002856.13849 | 2099166.37305 | 37.7440726834043 | -122.432789895044 | (37.7440726834043, -122.432789895044) | ||||
24218 | 24218 | 208954 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 600 Saint Francis Blvd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 30 | Width 8ft | 5993495.97502 | 2095994.9515900002 | 37.7348294415148 | -122.464924714122 | (37.7348294415148, -122.464924714122) | |||
24221 | 24221 | 124585 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 3979 Washington St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 6ft | 5995656.4760300005 | 2115464.7980400003 | 37.788412975773504 | -122.458864334168 | (37.7884129757735, -122.458864334168) | |||
24227 | 24227 | 203475 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2357 16th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5991280.398630001 | 2099387.14513 | 37.7440155431828 | -122.472831922275 | (37.7440155431828, -122.472831922275) | |||
24235 | 24235 | 217813 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 198 Lee Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5996579.91933 | 2091952.01212 | 37.7239058307663 | -122.453970623549 | (37.7239058307663, -122.453970623549) | |||
24238 | 24238 | 223314 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 737 Sanchez St | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 6003692.0750400005 | 2104158.0805900004 | 37.7578261171073 | -122.43025546792101 | (37.7578261171073, -122.430255467921) | |||
24251 | 24251 | 201271 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 200 Kalmanovitz St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 2ft | 6013058.71274 | 2092794.8909900002 | 37.7271512843849 | -122.39706476744301 | (37.7271512843849, -122.397064767443) | |||
24275 | 24275 | 184454 | Undocumented 2 | :: 54 | 2153 48th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981374.6331 | 2100381.1786 | 37.7461664541179 | -122.507156946857 | (37.7461664541179, -122.507156946857) | |||
24278 | 24278 | 183048 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2600 20th Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 0ft | 5990217.9332 | 2097368.8862 | 37.7384123615974 | -122.47635825040301 | (37.7384123615974, -122.476358250403) | |||
24286 | 24286 | 249978 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 13 Napier Ln | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 0ft | 6011650.66928 | 2120187.96882 | 37.8022880343123 | -122.403859153579 | (37.8022880343123, -122.403859153579) | |||
24308 | 24308 | 190929 | Undocumented 2 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 1101 25th St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 9ft | 6015301.73602 | 2102030.54675 | 37.752635108841 | -122.389955465678 | (37.752635108841, -122.389955465678) | |||
24330 | 24330 | 205383 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 64 Ventura Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5994182.66644 | 2101796.2621 | 37.750797955763396 | -122.46297136414101 | (37.7507979557634, -122.462971364141) | |||
24337 | 24337 | 198558 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1709 Newcomb Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 6014602.581680001 | 2096122.3818299999 | 37.73637372225429 | -122.391960171423 | (37.7363737222543, -122.391960171423) | |||
24365 | 24365 | 177331 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 230 Mansell St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 6011147.98766 | 2090617.26897 | 37.7210654327147 | -122.403517019111 | (37.7210654327147, -122.403517019111) | |||
24378 | 24378 | 124854 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 55 Casa Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 3ft | 6001534.02589 | 2121572.74926 | 37.8055198982766 | -122.438966893034 | (37.8055198982766, -122.438966893034) | |||
24379 | 24379 | 241475 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 939 Elizabeth St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 6000376.8686 | 2101955.8656599997 | 37.751591035515496 | -122.441562769933 | (37.7515910355155, -122.441562769933) | |||
24381 | 24381 | 205069 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 851 Junipero Serra Blvd | 17 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5991341.17231 | 2091818.7337900002 | 37.723238113832004 | -122.472070242354 | (37.723238113832, -122.472070242354) |
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");