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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
180303 | 180303 | 180413 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1104x Alemany Blvd | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 6003786.93346 | 2094435.4492400002 | 37.731135391684 | -122.42923414026001 | (37.731135391684, -122.42923414026) | |||
180177 | 180177 | 211656 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 200x Terrace Dr | 37 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 5993885.28493 | 2096476.0493 | 37.7361728559925 | -122.463613650077 | (37.7361728559925, -122.463613650077) | ||||
180124 | 180124 | 248649 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2x Lyell St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | 6002995.03876 | 2095080.26155 | 37.732861037793 | -122.43201788462 | (37.732861037793, -122.43201788462) | ||||
180077 | 180077 | 135605 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 450x The Embarcadero | 16 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | 6014374.07873 | 2117690.91849 | 37.795583494923704 | -122.39425982964899 | (37.7955834949237, -122.394259829649) | ||||
180074 | 180074 | 195732 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 250x King St | 16 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | Width 10ft | 6014536.11101 | 2110945.78626 | 37.7770719155794 | -122.39322694208401 | (37.7770719155794, -122.393226942084) | |||
179912 | 179912 | 249490 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1500x Van Ness Ave | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6006241.6595 | 2115852.2639200003 | 37.7900796134287 | -122.42226876779101 | (37.7900796134287, -122.422268767791) | ||||
179789 | 179789 | 234357 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 650x Dolores St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | 6004986.096919999 | 2104380.3629099997 | 37.758509662101204 | -122.425796019476 | (37.7585096621012, -122.425796019476) | ||||
179786 | 179786 | 212148 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 700x Miramar Ave | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 5995395.17866 | 2094120.1752900002 | 37.7297910841891 | -122.45822290508801 | (37.7297910841891, -122.458222905088) | ||||
179442 | 179442 | 220713 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 3250x Cesar Chavez St | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | Width 10ft | 6007871.6853 | 2100572.46831 | 37.7482166910568 | -122.415546734794 | (37.7482166910568, -122.415546734794) | |||
179408 | 179408 | 195734 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 250x King St | 18 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | Width 10ft | 6014485.12564 | 2110898.06022 | 37.776938038003294 | -122.39339997704398 | (37.7769380380033, -122.393399977044) | |||
179167 | 179167 | 135588 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 22x Drumm St | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | Width 7ft | 6013703.14985 | 2117288.7562700002 | 37.794441936008894 | -122.39655317280899 | (37.7944419360089, -122.396553172809) | |||
178958 | 178958 | 195733 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 250x King St | 17 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | Width 10ft | 6014512.42504 | 2110924.16677 | 37.777011237428205 | -122.39330736664301 | (37.7770112374282, -122.393307366643) | |||
178884 | 178884 | 135615 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 450x The Embarcadero | 26 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | 6014281.27914 | 2117801.86987 | 37.795882982666505 | -122.394588708116 | (37.7958829826665, -122.394588708116) | ||||
178806 | 178806 | 220724 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 3100x Cesar Chavez St | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | Width 10ft | 6008766.0875 | 2100575.56898 | 37.7482754383741 | -122.412454127271 | (37.7482754383741, -122.412454127271) | |||
178786 | 178786 | 197766 | DPW Maintained 3 | Syagrus romanzoffianum :: Queen Palm 142 | 1150x Tennessee St | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | Width 8ft | 6015570.19786 | 2103483.2933099996 | 37.756638928352 | -122.38912849679701 | (37.756638928352, -122.389128496797) | |||
178718 | 178718 | 194367 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 310x The Embarcadero | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 32 | Width 8ft | 6016138.88729 | 2114959.31506 | 37.7881810762396 | -122.38796252216999 | (37.7881810762396, -122.38796252217) | |||
178690 | 178690 | 222809 | DPW Maintained 3 | Ceiba speciosa :: Silk floss 335 | 3400x Cesar Chavez St | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | Width 10ft | 6006905.75522 | 2100562.66292 | 37.748135425630394 | -122.418886203547 | (37.7481354256304, -122.418886203547) | |||
178654 | 178654 | 222819 | DPW Maintained 3 | Ceiba speciosa :: Silk floss 335 | 3500x Cesar Chavez St | 12 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 10ft | 6006102.45265 | 2100549.0367799997 | 37.7480527464562 | -122.42166303303001 | (37.7480527464562, -122.42166303303) | |||
178642 | 178642 | 221310 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 3400x Cesar Chavez St | 18 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | Width 10ft | 6006690.61046 | 2100560.2464400004 | 37.748116673857396 | -122.419629996836 | (37.7481166738574, -122.419629996836) | |||
178639 | 178639 | 194661 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 900x Carolina St | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 6012476.239519999 | 2103642.76078 | 37.756904793134204 | -122.399839788377 | (37.7569047931342, -122.399839788377) | ||||
178538 | 178538 | 188740 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 250x Executive Park Blvd | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | Width 8ft | 6014461.35341 | 2086969.95596 | 37.711235143968 | -122.391808694124 | (37.711235143968, -122.391808694124) | |||
178472 | 178472 | 251037 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5317x Geary Blvd | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5990398.0172 | 2112670.1794 | 37.780436072061896 | -122.476853300249 | (37.7804360720619, -122.476853300249) | |||
178416 | 178416 | 129103 | DPW Maintained 3 | Jacaranda mimosifolia :: Jacaranda 52 | 1306x Montgomery St | 29 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 8ft | 6011435.37643 | 2120050.37627 | 37.8018982087863 | -122.40459448426901 | (37.8018982087863, -122.404594484269) | |||
178300 | 178300 | 246552 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 20x Octavia St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | Width 8ft | 6005729.77249 | 2109512.91923 | 37.77264444073 | -122.423588959979 | (37.77264444073, -122.423588959979) | |||
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) | |||
178221 | 178221 | 247571 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 350x Alemany Blvd | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 19 | 6008108.27012 | 2094965.3059 | 37.732833953824205 | -122.414331952177 | (37.7328339538242, -122.414331952177) | ||||
178177 | 178177 | 119934 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 6400x Geary Blvd | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 5986945.272609999 | 2112550.81697 | 37.7799074444019 | -122.488789028183 | (37.7799074444019, -122.488789028183) | ||||
177827 | 177827 | 234351 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 600x Dolores St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 30 | 6004966.99113 | 2104720.1905900002 | 37.759441669116796 | -122.425886285347 | (37.7594416691168, -122.425886285347) | ||||
177771 | 177771 | 221305 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 3400x Cesar Chavez St | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | Width 10ft | 6006848.39499 | 2100562.5972700003 | 37.7481320153776 | -122.419084549026 | (37.7481320153776, -122.419084549026) | |||
177610 | 177610 | 208268 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 950x Portola Dr | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | Width 8ft | 5996154.347999999 | 2098544.9334299997 | 37.741983988173 | -122.455918135114 | (37.741983988173, -122.455918135114) | |||
177575 | 177575 | 220725 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 3100x Cesar Chavez St | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | Width 10ft | 6008748.821819999 | 2100575.53964 | 37.748274388864495 | -122.412513829653 | (37.7482743888645, -122.412513829653) | |||
177543 | 177543 | 214300 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 200x Terrace Dr | 42 | Median : Yard 3 | Tree 1 | DPW 2 | 17 | 5993888.01583 | 2096515.6983900003 | 37.7362818799091 | -122.46360708499701 | (37.7362818799091, -122.463607084997) | ||||
177528 | 177528 | 211105 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2187x 09th Ave | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 41 | 5993636.389719999 | 2101004.93506 | 37.748593692259895 | -122.464802962985 | (37.7485936922599, -122.464802962985) | ||||
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) | |||
177459 | 177459 | 132104 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1400x The Embarcadero | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 19 | Width 10ft | 6012041.8343 | 2121038.82925 | 37.8046461349625 | -122.402565391602 | (37.8046461349625, -122.402565391602) | |||
177458 | 177458 | 221286 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 100x McCoppin St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | Width 7ft | 6005932.045 | 2109110.97186 | 37.77155220509079 | -122.42286070518 | (37.7715522050908, -122.42286070518) | |||
177428 | 177428 | 135583 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 22x Drumm St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | Width 7ft | 6013725.73224 | 2117134.30218 | 37.794019098152205 | -122.396464202864 | (37.7940190981522, -122.396464202864) | |||
177329 | 177329 | 251092 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 6100x Geary Blvd | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5988013.9609 | 2112592.2358 | 37.780083477756705 | -122.485095046206 | (37.7800834777567, -122.485095046206) | |||
177115 | 177115 | 220728 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 3100x Cesar Chavez St | 17 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | Width 10ft | 6008622.10298 | 2100574.90672 | 37.7482655386311 | -122.412951976664 | (37.7482655386311, -122.412951976664) | |||
177078 | 177078 | 220712 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 3250x Cesar Chavez St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | Width 10ft | 6007959.12606 | 2100570.6784200002 | 37.748216691058005 | -122.415244239723 | (37.748216691058, -122.415244239723) | |||
176932 | 176932 | 195722 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 250x King St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | Width 10ft | 6014782.12024 | 2111178.98534 | 37.7777258917748 | -122.392392227319 | (37.7777258917748, -122.392392227319) | |||
176923 | 176923 | 132084 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1200x The Embarcadero | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | Width 10ft | 6012274.61558 | 2120706.35336 | 37.8037462301721 | -122.401736440606 | (37.8037462301721, -122.401736440606) | |||
176894 | 176894 | 218255 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1400x Portola Dr | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | 5992834.72812 | 2097242.26115 | 37.7382160923013 | -122.467301519773 | (37.7382160923013, -122.467301519773) | ||||
176793 | 176793 | 195736 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 250x King St | 20 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | Width 10ft | 6014449.17675 | 2110862.30677 | 37.7768378696968 | -122.393521833393 | (37.7768378696968, -122.393521833393) | |||
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) | |||
176447 | 176447 | 221316 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 3500x Cesar Chavez St | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | Width 10ft | 6006164.906830001 | 2100554.27339 | 37.748070646539 | -122.421447440342 | (37.748070646539, -122.421447440342) | |||
176286 | 176286 | 132079 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1100x The Embarcadero | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | Width 10ft | 6012611.87531 | 2120208.19637 | 37.8023972264213 | -122.40053431322399 | (37.8023972264213, -122.400534313224) | |||
176206 | 176206 | 211110 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 335x Pacheco St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | Width 8ft | 5994195.56932 | 2101082.15648 | 37.7488379463106 | -122.46287494332701 | (37.7488379463106, -122.462874943327) | |||
176176 | 176176 | 209134 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 900x Bosworth St | 20 | Median : Yard 3 | Tree 1 | DPW 2 | 16 | 6001014.7051099995 | 2095735.41705 | 37.7345474725699 | -122.438911322111 | (37.7345474725699, -122.438911322111) | ||||
176097 | 176097 | 190644 | DPW Maintained 3 | Heteromeles arbutifolia :: Toyon 322 | 1427x Innes Ave | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 26 | 6016311.73446 | 2096627.56435 | 37.7378555918516 | -122.38608606604299 | (37.7378555918516, -122.386086066043) | ||||
175996 | 175996 | 208272 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 950x Portola Dr | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | Width 8ft | 5996077.78984 | 2098457.8421099996 | 37.741740462546 | -122.456176551714 | (37.741740462546, -122.456176551714) | |||
175988 | 175988 | 135608 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 450x The Embarcadero | 19 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | 6014300.48384 | 2117708.60482 | 37.7956279664036 | -122.394515721817 | (37.7956279664036, -122.394515721817) | ||||
175803 | 175803 | 129354 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 1306x Montgomery St | 52 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | Width 8ft | 6011388.89614 | 2120338.61388 | 37.8026870410416 | -122.40477563290199 | (37.8026870410416, -122.404775632902) | |||
175789 | 175789 | 204968 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 500x Miramar Ave | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | 5995374.72288 | 2093080.44046 | 37.726935047798705 | -122.45821839946301 | (37.7269350477987, -122.458218399463) | ||||
175659 | 175659 | 213727 | DPW Maintained 3 | Prunus x yedoensis :: Yoshino Cherry 237 | 66x San Lorenzo Way | 12 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | 5993674.25829 | 2097434.3999799998 | 37.7387920864908 | -122.464412810098 | (37.7387920864908, -122.464412810098) | ||||
175644 | 175644 | 211071 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 500x Miramar Ave | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | 5995380.09454 | 2093218.25605 | 37.727313764897 | -122.45820980016899 | (37.727313764897, -122.458209800169) | ||||
175443 | 175443 | 246555 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 20x Octavia St | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | Width 8ft | 6005721.04041 | 2109575.32182 | 37.772815290316295 | -122.423623602744 | (37.7728152903163, -122.423623602744) | |||
175406 | 175406 | 191510 | DPW Maintained 3 | Liquidambar orientalis :: Oriental Sweet Gum 312 | 900x Carolina St | 34 | Median : Yard 3 | Tree 1 | DPW 2 | 26 | 6012478.66144 | 2103273.09419 | 37.7558899046023 | -122.399805455861 | (37.7558899046023, -122.399805455861) | ||||
175369 | 175369 | 188654 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 300x Cargo Way | 12 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | 6017424.39169 | 2098619.4012 | 37.7433862929421 | -122.382377569482 | (37.7433862929421, -122.382377569482) | ||||
175283 | 175283 | 251074 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 5000x Geary Blvd | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5991352.6942 | 2112710.2412 | 37.7806014035471 | -122.473553580301 | (37.7806014035471, -122.473553580301) | |||
175195 | 175195 | 194441 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 900x Carolina St | 39 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 6012501.46554 | 2103105.9446900003 | 37.7554322198433 | -122.399714855461 | (37.7554322198433, -122.399714855461) | ||||
175125 | 175125 | 119933 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 6400x Geary Blvd | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 5986970.48357 | 2112551.91695 | 37.7799119358722 | -122.48870189430001 | (37.7799119358722, -122.4887018943) | ||||
175113 | 175113 | 211119 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 335x Pacheco St | 24 | Median : Yard 3 | Tree 1 | DPW 2 | 16 | Width 8ft | 5994174.87266 | 2101366.65398 | 37.749617912142504 | -122.46296714991999 | (37.7496179121425, -122.46296714992) | |||
175056 | 175056 | 195675 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 102x King St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | Width 10ft | 6015482.36105 | 2111843.26089 | 37.7795887033991 | -122.390016249049 | (37.7795887033991, -122.390016249049) | |||
174960 | 174960 | 200449 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1150x Tennessee St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | Width 8ft | 6015546.9238599995 | 2103710.0991 | 37.7572603985698 | -122.389224824085 | (37.7572603985698, -122.389224824085) | |||
174903 | 174903 | 247035 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 550x Valley St | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | 6002263.72164 | 2099154.77603 | 37.7440072235471 | -122.434837508343 | (37.7440072235471, -122.434837508343) | ||||
174842 | 174842 | 203828 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 200x Terrace Dr | 32 | Median : Yard 3 | Tree 1 | DPW 2 | 16 | 5993850.84574 | 2096478.66288 | 37.7361780477826 | -122.463732909161 | (37.7361780477826, -122.463732909161) | ||||
174740 | 174740 | 210215 | DPW Maintained 3 | Melaleuca styphelliodes :: Paperbark Tree 239 | 198x San Anselmo Ave | 12 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | 5993623.2660300005 | 2096276.33312 | 37.7356093839492 | -122.46450505268 | (37.7356093839492, -122.46450505268) | ||||
174612 | 174612 | 188734 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 250x Executive Park Blvd | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 17 | Width 8ft | 6014314.36158 | 2086981.8522700001 | 37.71125964778079 | -122.39231757011801 | (37.7112596477808, -122.392317570118) | |||
174594 | 174594 | 197878 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 1498x Tennessee St | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | Width 7ft | 6015630.33926 | 2101939.54612 | 37.7524034587597 | -122.388812735827 | (37.7524034587597, -122.388812735827) | |||
174532 | 174532 | 214331 | DPW Maintained 3 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 100x Idora Ave | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 9ft | 5995540.56521 | 2099364.9270200003 | 37.7442002405496 | -122.458099716827 | (37.7442002405496, -122.458099716827) | |||
174328 | 174328 | 234327 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 850x Dolores St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 29 | 6005045.03345 | 2103276.5066400003 | 37.755482062073604 | -122.425513631455 | (37.7554820620736, -122.425513631455) | ||||
174310 | 174310 | 194021 | DPW Maintained 3 | Morus alba :: White Mulberry 112 | 1100x Bay Shore Blvd | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | 6011358.20125 | 2093944.86355 | 37.730214059626 | -122.403024302127 | (37.730214059626, -122.403024302127) | ||||
174200 | 174200 | 221304 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 3400x Cesar Chavez St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | Width 10ft | 6006999.9222099995 | 2100563.83599 | 37.7481439484975 | -122.418560659758 | (37.7481439484975, -122.418560659758) | |||
174181 | 174181 | 242061 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 10x Benton Ave | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 6004744.49443 | 2095004.6976299998 | 37.732752583154394 | -122.42596418912301 | (37.7327525831544, -122.425964189123) | ||||
174163 | 174163 | 125486 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 1237x Robert C Levy Tunl | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | 6007645.270330001 | 2118136.8198 | 37.7964315115565 | -122.417574361577 | (37.7964315115565, -122.417574361577) | ||||
174052 | 174052 | 194319 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 380x The Embarcadero | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 19 | Width 7ft | 6014937.91263 | 2116957.6212 | 37.793601355862705 | -122.392257538577 | (37.7936013558627, -122.392257538577) | |||
174003 | 174003 | 126627 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 350x Washington St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 17 | Width 8ft | 6013882.15291 | 2118048.61881 | 37.796538299751 | -122.39598707025499 | (37.796538299751, -122.395987070255) | |||
173926 | 173926 | 126630 | DPW Maintained 3 | Ficus microcarpa :: Chinese Banyan 94 | 350x Washington St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | Width 8ft | 6013712.21512 | 2118015.33042 | 37.7964374416781 | -122.396572761821 | (37.7964374416781, -122.396572761821) | |||
173829 | 173829 | 197180 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 1300x De Haro St | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | 6012255.350880001 | 2102175.8421 | 37.752864638318 | -122.40050066956499 | (37.752864638318, -122.400500669565) | ||||
173688 | 173688 | 191721 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 1150x Tennessee St | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 50 | 6015559.12531 | 2103608.85918 | 37.75698309171089 | -122.389175557402 | (37.7569830917109, -122.389175557402) | ||||
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) | ||||
173646 | 173646 | 195240 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1400x Evans Ave | 16 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | 6016376.5567 | 2097988.3018 | 37.7415954882544 | -122.385956766892 | (37.7415954882544, -122.385956766892) | ||||
173586 | 173586 | 194339 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 88x King St | 15 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | Width 8ft | 6015964.49017 | 2112481.16819 | 37.781366981449295 | -122.388392878343 | (37.7813669814493, -122.388392878343) | |||
173558 | 173558 | 188762 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 150x Executive Park Blvd | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 28 | Width 8ft | 6014035.24999 | 2087007.2689599998 | 37.71131393444921 | -122.39328403465299 | (37.7113139344492, -122.393284034653) | |||
173545 | 173545 | 197882 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 1498x Tennessee St | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | Width 7ft | 6015650.38756 | 2101941.3683 | 37.752409573246396 | -122.388743532098 | (37.7524095732464, -122.388743532098) | |||
173471 | 173471 | 189328 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 1427x Innes Ave | 21 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | 6016180.048909999 | 2096728.46226 | 37.7381253480046 | -122.386548404801 | (37.7381253480046, -122.386548404801) | ||||
173405 | 173405 | 195719 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 250x King St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | Width 10ft | 6014846.74684 | 2111239.41443 | 37.7778954049955 | -122.39217288717501 | (37.7778954049955, -122.392172887175) | |||
173363 | 173363 | 194027 | DPW Maintained 3 | Morus alba :: White Mulberry 112 | 1100x Bay Shore Blvd | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | 6011379.88735 | 2093929.83608 | 37.730174008312 | -122.40294827345501 | (37.730174008312, -122.402948273455) | ||||
173233 | 173233 | 211130 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 335x Pacheco St | 36 | Median : Yard 3 | Tree 1 | DPW 2 | 48 | Width 8ft | 5994106.02259 | 2101525.20056 | 37.7500492746747 | -122.46321673696 | (37.7500492746747, -122.46321673696) | |||
173206 | 173206 | 251070 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 5200x Geary Blvd | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5990754.7634 | 2112689.2674 | 37.7805091701663 | -122.47562055473499 | (37.7805091701663, -122.475620554735) | |||
173116 | 173116 | 194373 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 310x The Embarcadero | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 29 | Width 8ft | 6016083.2484800005 | 2115225.4963700003 | 37.7889088670017 | -122.38817360834 | (37.7889088670017, -122.38817360834) | |||
173031 | 173031 | 234519 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 5200x Diamond Heights Blvd | 30 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | 6001520.34927 | 2098955.69327 | 37.743418355585206 | -122.437393663999 | (37.7434183555852, -122.437393663999) | ||||
172734 | 172734 | 211640 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 605x Saint Francis Blvd | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 17 | 5993453.729169999 | 2096036.2807900002 | 37.734940485300896 | -122.465073772263 | (37.7349404853009, -122.465073772263) | ||||
172713 | 172713 | 219171 | DPW Maintained 3 | Heteromeles arbutifolia :: Toyon 322 | 1485x Northwood Dr | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | 5995877.5181599995 | 2093932.37838 | 37.72930314352 | -122.456541838346 | (37.72930314352, -122.456541838346) | ||||
172638 | 172638 | 251071 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 5200x Geary Blvd | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5990727.8797 | 2112689.8051 | 37.7805090880033 | -122.47571359647101 | (37.7805090880033, -122.475713596471) | |||
172474 | 172474 | 244816 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 150x Dolores St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 6004817.336069999 | 2107374.8750299998 | 37.766722342083 | -122.42659290246701 | (37.766722342083, -122.426592902467) | ||||
172289 | 172289 | 207711 | DPW Maintained 3 | Eriobotrya japonica :: Edible Loquat 190 | 200x Terrace Dr | 31 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 5993844.07189 | 2096487.62875 | 37.7362022754996 | -122.463756979508 | (37.7362022754996, -122.463756979508) | ||||
172202 | 172202 | 195721 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 250x King St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | Width 10ft | 6014799.00222 | 2111195.13044 | 37.777771160036295 | -122.39233495579599 | (37.7777711600363, -122.392334955796) | |||
172192 | 172192 | 194481 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1300x De Haro St | 17 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6012253.2004 | 2102155.0186 | 37.752807341589296 | -122.400506643765 | (37.7528073415893, -122.400506643765) |
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");