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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 77398 | 77398 | 106965 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 63 BELLE AVE | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5991753.8 | 2086471.1 | 37.7085786821221 | -122.47025464516001 | (37.7085786821221, -122.47025464516) | ||||||
| 84244 | 84244 | 105061 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 163 10TH AVE | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 4x3 | 5992696.3 | 2114396.0 | 37.785307754338 | -122.46902816717301 | (37.785307754338, -122.469028167173) | ||||
| 96282 | 96282 | 104677 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 65 ZIRCON PL | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 770985 | 6002398.2 | 2098694.7 | 37.7427515964219 | -122.43433962698201 | (37.7427515964219, -122.434339626982) | |||||
| 118422 | 118422 | 112428 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2819 JACKSON ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 33 | 3x3 | 6000608.0 | 2116457.0 | 37.7914206746057 | -122.441804136035 | (37.7914206746057, -122.441804136035) | ||||
| 139222 | 139222 | 111092 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 801 GONZALEZ DR | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 06/04/2015 12:00:00 AM | 2 | Permit Number 775593 | 5988333.0 | 2089769.0 | 37.717435525652704 | -122.48231868452 | (37.7174355256527, -122.48231868452) | |||
| 143587 | 143587 | 104820 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 701 CASTRO ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6002463.2 | 2104094.7 | 37.757582407620504 | -122.434500892974 | (37.7575824076205, -122.434500892974) | ||||
| 476 | 476 | 174954 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1400x Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4xt | Permit Number 779898 | 6007316.0 | 2110809.0 | 37.776292577113104 | -122.418193923043 | (37.7762925771131, -122.418193923043) | |||
| 567 | 567 | 195068 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1532 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008830.0 | 2108632.0 | 37.7704001487298 | -122.41280261366998 | (37.7704001487298, -122.41280261367) | |||
| 761 | 761 | 195041 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 402 06th St | 1 | : 4 | Tree 1 | DPW 2 | 28 | Width 3ft | 6011480.36813 | 2111044.01847 | 37.777171403968296 | -122.40380468436199 | (37.7771714039683, -122.403804684362) | |||
| 777 | 777 | 234744 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2455 15th St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12 | Width 3ft | 6001486.4222099995 | 2107220.2274599997 | 37.766108846174795 | -122.438102867577 | (37.7661088461748, -122.438102867577) | |||
| 861 | 861 | 109545 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300x Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6006870.4118800005 | 2111707.44564 | 37.778734401395205 | -122.419799104459 | (37.7787344013952, -122.419799104459) | |||
| 1284 | 1284 | 235428 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2869 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/09/2016 12:00:00 AM | 3 | 3x3 | 6010306.81938 | 2100635.6894799997 | 37.74852686004171 | -122.40713053105101 | (37.7485268600417, -122.407130531051) | ||
| 1285 | 1285 | 234575 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2990 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/09/2016 12:00:00 AM | 3 | Width 3ft | 6009677.1610900005 | 2100624.0529099996 | 37.7484596510092 | -122.409307067568 | (37.7484596510092, -122.409307067568) | ||
| 1291 | 1291 | 234571 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2892 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/09/2017 12:00:00 AM | 3 | 3x4 | 6010196.53099 | 2100680.54575 | 37.7486438528311 | -122.407515070373 | (37.7486438528311, -122.407515070373) | ||
| 1733 | 1733 | 200858 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1133 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6008786.0 | 2112009.0 | 37.7796701249263 | -122.413193644333 | (37.7796701249263, -122.413193644333) | |||
| 1888 | 1888 | 100797 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2471 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6002362.24857 | 2116725.90576 | 37.7922588209311 | -122.435753725979 | (37.7922588209311, -122.435753725979) | |||
| 2299 | 2299 | 253020 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 760 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004216.0 | 2110862.0 | 37.7762631241711 | -122.42892145951299 | (37.7762631241711, -122.428921459513) | ||||
| 2303 | 2303 | 122440 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 599X Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | Permit Number 778941 | 6013669.1059 | 2114077.4124 | 37.785622440131 | -122.39644576664499 | (37.785622440131, -122.396445766645) | ||
| 2324 | 2324 | 195018 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300X 02nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | Permit Number 778941 | 6013610.320719999 | 2113989.12597 | 37.7853767544813 | -122.39664295660499 | (37.7853767544813, -122.396642956605) | ||
| 2331 | 2331 | 122431 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 598X Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 4x4 | Permit Number 778941 | 6013729.7725 | 2114223.4236 | 37.786026729010295 | -122.396246113338 | (37.7860267290103, -122.396246113338) | ||
| 2772 | 2772 | 252949 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 261x Winding Way | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | Permit Number 780594 | 6001774.0 | 2086449.0 | 37.7090922302752 | -122.435622042553 | (37.7090922302752, -122.435622042553) | |||
| 4471 | 4471 | 100799 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2455 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6002438.67863 | 2116735.02721 | 37.7922882071812 | -122.435489929626 | (37.7922882071812, -122.435489929626) | |||
| 4621 | 4621 | 122573 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2014 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4x4 | 6003898.8446 | 2115409.2515 | 37.7887307847056 | -122.430343093484 | (37.7887307847056, -122.430343093484) | |||
| 4639 | 4639 | 102681 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2100 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 4x4 | 6001426.627069999 | 2115693.54787 | 37.7893710438761 | -122.43891697256399 | (37.7893710438761, -122.438916972564) | |||
| 4730 | 4730 | 234655 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 437 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 6x12 | 6002991.56268 | 2105705.90685 | 37.762036373292 | -122.432788699846 | (37.762036373292, -122.432788699846) | |||
| 5139 | 5139 | 235614 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 573 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006249.0 | 2106283.0 | 37.7638051443341 | -122.421563455709 | (37.7638051443341, -122.421563455709) | |||
| 5376 | 5376 | 112253 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3401 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5998472.27762 | 2115859.72352 | 37.789658787381796 | -122.449150614422 | (37.7896587873818, -122.449150614422) | |||
| 5398 | 5398 | 98494 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2820 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 5999556.928169999 | 2118555.98315 | 37.79712398054429 | -122.44559181541099 | (37.7971239805443, -122.445591815411) | |||
| 5470 | 5470 | 100796 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2477 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 6002339.98716 | 2116721.3494700002 | 37.79224504601171 | -122.43583042464199 | (37.7922450460117, -122.435830424642) | |||
| 5609 | 5609 | 105280 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3017 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 6002863.14914 | 2118997.09169 | 37.7985233499191 | -122.43418303843399 | (37.7985233499191, -122.434183038434) | |||
| 5640 | 5640 | 79352 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2909 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/2001 12:00:00 AM | 8 | 3x3 | 5999487.033 | 2114286.0485 | 37.785395874336 | -122.445526470028 | (37.785395874336, -122.445526470028) | |
| 5817 | 5817 | 103362 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1171X Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Rec/Park 7 | 12 | 3x3 | 6009111.87446 | 2116690.2667799997 | 37.7925420462198 | -122.41239727931601 | (37.7925420462198, -122.412397279316) | ||
| 5857 | 5857 | 99700 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1412 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 4x4 | 6007375.87378 | 2117463.43004 | 37.794567388720296 | -122.41845876116301 | (37.7945673887203, -122.418458761163) | |||
| 6077 | 6077 | 100804 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2429 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6002544.40656 | 2116747.89129 | 37.7923295328255 | -122.435125029709 | (37.7923295328255, -122.435125029709) | |||
| 6677 | 6677 | 121686 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1653 Grant Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 6010468.2399 | 2120204.652 | 37.8022677132519 | -122.4079521316 | (37.8022677132519, -122.4079521316) | |||
| 6831 | 6831 | 101231 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3575 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | 3x3 | Permit Number 779254 | 5997777.0237 | 2115106.06857 | 37.7875496613457 | -122.451501728247 | (37.7875496613457, -122.451501728247) | ||
| 6848 | 6848 | 100798 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2469 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6002394.5470900005 | 2116728.58205 | 37.7922680039076 | -122.435642164168 | (37.7922680039076, -122.435642164168) | |||
| 6916 | 6916 | 102685 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2138 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 4x4 | 6001402.82307 | 2115865.31916 | 37.7898413290661 | -122.43901164686399 | (37.7898413290661, -122.439011646864) | |||
| 7073 | 7073 | 112426 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2811 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 6000627.2120900005 | 2116484.87099 | 37.7914982957465 | -122.441739663868 | (37.7914982957465, -122.441739663868) | |||
| 7337 | 7337 | 106720 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1447 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5999672.1743 | 2113882.1261 | 37.7842973761464 | -122.44485689337401 | (37.7842973761464, -122.444856893374) | |||
| 7456 | 7456 | 111007 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 600X Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/15/2015 12:00:00 AM | 3 | Permit Number 776001 | 6007258.06948 | 2121954.7995599997 | 37.8068929247227 | -122.41918512469299 | (37.8068929247227, -122.419185124693) | ||
| 7846 | 7846 | 100800 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2447 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6002472.36157 | 2116739.6820799997 | 37.7923029012016 | -122.435373719219 | (37.7923029012016, -122.435373719219) | |||
| 8168 | 8168 | 105281 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3027 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3x4 | 6002859.316269999 | 2119014.32091 | 37.7985704393358 | -122.43419753370199 | (37.7985704393358, -122.434197533702) | |||
| 8515 | 8515 | 105228 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2947 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6000635.74462 | 2115830.45364 | 37.789701922466996 | -122.441663156727 | (37.789701922467, -122.441663156727) | |||
| 8719 | 8719 | 103512 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1859 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6004140.55979 | 2118340.6063599996 | 37.7967932278873 | -122.429715952028 | (37.7967932278873, -122.429715952028) | |||
| 8876 | 8876 | 95278 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 638 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | Created record for tree on 2/4/2011. Matches others in row planted around same time in 1979. | 6004779.960630001 | 2110916.39736 | 37.7764443911196 | -122.426974438925 | (37.7764443911196, -122.426974438925) | ||
| 8892 | 8892 | 100802 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2441 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6002494.22504 | 2116741.23668 | 37.792308411358 | -122.435298182484 | (37.792308411358, -122.435298182484) | |||
| 9687 | 9687 | 173638 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2590 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001760.0 | 2117029.0 | 37.7930568116395 | -122.43785923271999 | (37.7930568116395, -122.43785923272) | ||||
| 9727 | 9727 | 173664 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 28 Ford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003201.0 | 2105688.0 | 37.7619990815164 | -122.432063058995 | (37.7619990815164, -122.432063058995) | ||||
| 10087 | 10087 | 173835 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 401X Spear St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015881.0 | 2115288.0 | 37.789069279801204 | -122.388877732103 | (37.7890692798012, -122.388877732103) | ||||
| 10127 | 10127 | 173869 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 619 Brussels St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010937.0 | 2091855.0 | 37.72445219957 | -122.40433341923901 | (37.72445219957, -122.404333419239) | ||||
| 13599 | 13599 | 108461 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1001 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6014773.3140199995 | 2103869.90724 | 37.757656280132295 | -122.391911465039 | (37.7576562801323, -122.391911465039) | |||
| 13928 | 13928 | 102944 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 303X 02nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6013989.502309999 | 2113674.68943 | 37.7845344800322 | -122.39530905788901 | (37.7845344800322, -122.395309057889) | |||
| 14211 | 14211 | 104028 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 489 06th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3x3 | 6011824.7251 | 2110690.58952 | 37.776220200934 | -122.40258857790501 | (37.776220200934, -122.402588577905) | |||
| 14784 | 14784 | 114989 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 222 02nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 5x5 | 6013198.096940001 | 2114421.4355 | 37.7865408252518 | -122.39809947610901 | (37.7865408252518, -122.398099476109) | |||
| 14799 | 14799 | 104024 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 710 Wisconsin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | 3x4.5 | 6012689.02007 | 2104172.45371 | 37.758371073873796 | -122.39914108889299 | (37.7583710738738, -122.399141088893) | |||
| 14970 | 14970 | 104031 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 475 06th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3x3 | 6011781.28256 | 2110735.2318599997 | 37.7763403530626 | -122.402741998648 | (37.7763403530626, -122.402741998648) | |||
| 19694 | 19694 | 110273 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 4169 20TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002618.0 | 2104102.0 | 37.7576112377986 | -122.433966054221 | (37.7576112377986, -122.433966054221) | ||||
| 20185 | 20185 | 120130 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 799x Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | |||||||||
| 22851 | 22851 | 134662 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1041 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009494.45696 | 2116717.83067 | 37.7926391918858 | -122.41107547377399 | (37.7926391918858, -122.411075473774) | |||
| 22984 | 22984 | 238609 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 4625 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6000532.14227 | 2101082.14305 | 37.7492008488489 | -122.440963141534 | (37.7492008488489, -122.440963141534) | |||
| 22987 | 22987 | 212768 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5992900.163240001 | 2097835.01221 | 37.739847414828205 | -122.467118363816 | (37.7398474148282, -122.467118363816) | |||
| 22992 | 22992 | 135234 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1255 Battery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 5ft | 6012203.157240001 | 2120302.31676 | 37.802632855975794 | -122.401955307707 | (37.8026328559758, -122.401955307707) | |||
| 23369 | 23369 | 135296 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 786 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6010152.27772 | 2116174.77558 | 37.7911849611618 | -122.408761049592 | (37.7911849611618, -122.408761049592) | |||
| 23411 | 23411 | 195158 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1188 Rhode Island St | 1 | : 4 | Tree 1 | Private 1 | 14 | Width 4ft | 6011916.5871 | 2102892.02207 | 37.7548122137394 | -122.401722520004 | (37.7548122137394, -122.401722520004) | |||
| 23434 | 23434 | 139256 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 760 GROVE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 6004257.0135 | 2111186.6217 | 37.777156776859 | -122.4288027301 | (37.777156776859, -122.4288027301) | |||
| 23454 | 23454 | 238698 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 185 Highland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6005982.07217 | 2096652.69548 | 37.737347483899 | -122.421802584426 | (37.737347483899, -122.421802584426) | |||
| 23518 | 23518 | 247709 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 848 Waller St | 1 | : 4 | Tree 1 | Private 1 | 16 | Width 4ft | 6001610.36211 | 2108740.78692 | 37.7702909742819 | -122.437783100124 | (37.7702909742819, -122.437783100124) | |||
| 23655 | 23655 | 139251 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 750 GROVE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 6004405.5927 | 2111207.184 | 37.7772216441057 | -122.42829021337201 | (37.7772216441057, -122.428290213372) | |||
| 23666 | 23666 | 133773 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2460 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6001271.86663 | 2116824.39868 | 37.7924672604089 | -122.43953352437 | (37.7924672604089, -122.43953352437) | |||
| 23758 | 23758 | 134407 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 700 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6006555.09677 | 2112890.24535 | 37.7819643138508 | -122.420973905924 | (37.7819643138508, -122.420973905924) | |||
| 23800 | 23800 | 234706 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 149 Henry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6002547.448030001 | 2107355.9553900003 | 37.766541806794 | -122.434442698767 | (37.766541806794, -122.434442698767) | |||
| 23927 | 23927 | 235470 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 404 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6004670.44089 | 2109873.60446 | 37.7735749431695 | -122.427278999752 | (37.7735749431695, -122.427278999752) | |||
| 23928 | 23928 | 195605 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 412 The Embarcadero | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6015995.5929 | 2113418.76378 | 37.7839431317002 | -122.388350736099 | (37.7839431317002, -122.388350736099) | |||
| 23965 | 23965 | 235489 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1237 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 5998194.41553 | 2106040.45851 | 37.762681727705896 | -122.44940420436599 | (37.7626817277059, -122.449404204366) | |||
| 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) | ||||
| 24083 | 24083 | 134225 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1998 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6004149.39485 | 2117704.8251900002 | 37.7950480358794 | -122.42964001326901 | (37.7950480358794, -122.429640013269) | |||
| 24135 | 24135 | 133913 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2830 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6000484.259930001 | 2116838.8361299997 | 37.792462045237706 | -122.442259695923 | (37.7924620452377, -122.442259695923) | |||
| 24258 | 24258 | 143098 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 509 GREENWICH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6010404.2897 | 2120259.9447 | 37.8024159528321 | -122.408177333339 | (37.8024159528321, -122.408177333339) | |||
| 24260 | 24260 | 134144 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2295 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6002676.78361 | 2117438.7801099997 | 37.7942340513994 | -122.43471642903098 | (37.7942340513994, -122.434716429031) | |||
| 24318 | 24318 | 195049 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 425 07th St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6011046.10585 | 2110191.14121 | 37.7748053308349 | -122.405246869567 | (37.7748053308349, -122.405246869567) | |||
| 24320 | 24320 | 138946 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 660 HAYES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6004699.1039 | 2110909.2568 | 37.77642021253239 | -122.427253636621 | (37.7764202125324, -122.427253636621) | |||
| 24355 | 24355 | 134160 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2360 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6002891.20572 | 2117172.3454400003 | 37.7935146612267 | -122.433955451478 | (37.7935146612267, -122.433955451478) | |||
| 24371 | 24371 | 195940 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 697 Newhall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6015801.85656 | 2097547.49143 | 37.740353291558 | -122.387913151189 | (37.740353291558, -122.387913151189) | |||
| 24440 | 24440 | 123770 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 831 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5993019.36186 | 2110677.58605 | 37.7751166600746 | -122.467639963578 | (37.7751166600746, -122.467639963578) | |||
| 24467 | 24467 | 142727 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 550 CHESTNUT ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6009250.7248 | 2120840.6441 | 37.8039457495288 | -122.412210317551 | (37.8039457495288, -122.412210317551) | |||
| 24490 | 24490 | 121982 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 320 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5991234.9703 | 2113225.58014 | 37.7820095638392 | -122.47399844937999 | (37.7820095638392, -122.47399844938) | |||
| 24505 | 24505 | 195054 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 820 Bryant St | 1 | : 4 | Tree 1 | Private 1 | 18 | Width 3ft | 6011686.5663 | 2110516.6477900003 | 37.775734882702295 | -122.403054272047 | (37.7757348827023, -122.403054272047) | |||
| 24530 | 24530 | 238689 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 727 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6007396.26644 | 2095434.5824900002 | 37.734082462834394 | -122.416826771336 | (37.7340824628344, -122.416826771336) | |||
| 24536 | 24536 | 112533 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 381 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 5 | 5x5 | 6011666.379930001 | 2118683.35655 | 37.7981576118354 | -122.403698857532 | (37.7981576118354, -122.403698857532) | |||
| 24556 | 24556 | 133802 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2410 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6001776.48972 | 2116721.64212 | 37.7922138242695 | -122.437780153932 | (37.7922138242695, -122.437780153932) | |||
| 24587 | 24587 | 246410 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2168 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6003733.2857 | 2107342.3599 | 37.76657171840971 | -122.430340128044 | (37.7665717184097, -122.430340128044) | |||
| 24612 | 24612 | 133692 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3712 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5996448.94172 | 2115947.9497700003 | 37.7897850998504 | -122.45615749147 | (37.7897850998504, -122.45615749147) | |||
| 24620 | 24620 | 135623 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 62 Maiden Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 1ft | 6011221.310930001 | 2115092.32192 | 37.788272620034704 | -122.404985959132 | (37.7882726200347, -122.404985959132) | |||
| 24766 | 24766 | 133929 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2701 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6000575.43 | 2117144.46308 | 37.79330641240921 | -122.44196619231 | (37.7933064124092, -122.44196619231) | |||
| 24927 | 24927 | 134097 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2576 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 4ft | 6001240.639690001 | 2117642.12953 | 37.7947107586526 | -122.43970022179899 | (37.7947107586526, -122.439700221799) | |||
| 25002 | 25002 | 134469 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 421 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6006332.28881 | 2111533.96918 | 37.778227747662 | -122.421648360595 | (37.778227747662, -122.421648360595) | |||
| 25092 | 25092 | 133898 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2872 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6000454.10341 | 2116506.41493 | 37.7915475848914 | -122.44234016279499 | (37.7915475848914, -122.442340162795) | |||
| 25252 | 25252 | 141395 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 639 GROVE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6004726.3954 | 2111211.233 | 37.77725090854621 | -122.427180742323 | (37.7772509085462, -122.427180742323) | |||
| 25261 | 25261 | 135496 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 702 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6011531.40529 | 2114784.2100299997 | 37.7874439469174 | -122.403891388003 | (37.7874439469174, -122.403891388003) |
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");