Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location ▼ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 165659 | 165659 | 203641 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 608 Garfield St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 5992400.09934 | 2090515.7050700001 | 37.7197215370907 | -122.468315017932 | (37.7197215370907, -122.468315017932) | |||
| 173115 | 173115 | 203638 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 750 Grafton Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5994537.11563 | 2090599.0913099998 | 37.720073694513104 | -122.46093420637101 | (37.7200736945131, -122.460934206371) | |||
| 148974 | 148974 | 174958 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 60 Onondaga Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6000890.31977 | 2091107.65045 | 37.7218336102096 | -122.439009814053 | (37.7218336102096, -122.439009814053) | |||
| 149197 | 149197 | 203647 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 70 Manor Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 5993596.72892 | 2093377.0999599998 | 37.7276472749004 | -122.46438636913099 | (37.7276472749004, -122.464386369131) | |||
| 27343 | 27343 | 203223 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 25 Upland Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5994463.96401 | 2093754.2883099997 | 37.7287328942013 | -122.461415680898 | (37.7287328942013, -122.461415680898) | |||
| 34582 | 34582 | 174966 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 44 Hamilton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6009006.884330001 | 2093841.0199900002 | 37.729797343475596 | -122.411145814235 | (37.7297973434756, -122.411145814235) | |||
| 178200 | 178200 | 203649 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1390 Monterey Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 5993852.26622 | 2094804.8663700002 | 37.731582298063394 | -122.46360655802201 | (37.7315822980634, -122.463606558022) | |||
| 157925 | 157925 | 203650 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1390 Monterey Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 3ft | 5993848.38247 | 2094813.0241599998 | 37.7316044735649 | -122.46362057664699 | (37.7316044735649, -122.463620576647) | |||
| 151268 | 151268 | 203651 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1390 Monterey Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 5993846.97887 | 2094818.6059299998 | 37.731619718855704 | -122.46362583408701 | (37.7316197188557, -122.463625834087) | |||
| 166210 | 166210 | 203659 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 628 Edna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5998583.28764 | 2094893.18321 | 37.7320962615306 | -122.44725691200199 | (37.7320962615306, -122.447256912002) | |||
| 179419 | 179419 | 203660 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 634 Edna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5998582.52704 | 2094910.5588200002 | 37.732143927389295 | -122.44726079165399 | (37.7321439273893, -122.447260791654) | |||
| 132310 | 132310 | 203658 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 531 Foerster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5998103.1876300005 | 2095162.16833 | 37.732807386054795 | -122.448936084745 | (37.7328073860548, -122.448936084745) | |||
| 31819 | 31819 | 220062 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 430 College Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 3ft | 6005376.5701 | 2095055.5296099999 | 37.7329278583224 | -122.423782556133 | (37.7329278583224, -122.423782556133) | |||
| 187683 | 187683 | 188523 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 65 Whitney Young Cir | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6017281.36531 | 2094970.41702 | 37.733359012210606 | -122.382618269437 | (37.7333590122106, -122.382618269437) | |||
| 178617 | 178617 | 188524 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 65 Whitney Young Cir | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6017319.36932 | 2094988.95682 | 37.7334120182438 | -122.38248816719299 | (37.7334120182438, -122.382488167193) | |||
| 41095 | 41095 | 220673 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 100 Alemany Blvd | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6009345.21028 | 2095878.12902 | 37.735409776738294 | -122.410119940478 | (37.7354097767383, -122.410119940478) | |||
| 156715 | 156715 | 220671 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 100 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6009657.24605 | 2096276.1729599999 | 37.7365202047272 | -122.409069188799 | (37.7365202047272, -122.409069188799) | |||
| 154734 | 154734 | 203652 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 400x Marietta Dr | 38 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 3ft | 5999131.48243 | 2096996.51385 | 37.737902818863795 | -122.445512879233 | (37.7379028188638, -122.445512879233) | |||
| 185200 | 185200 | 220017 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 78 Berkeley Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6001185.230140001 | 2097348.08527 | 37.7389851844145 | -122.438437264296 | (37.7389851844145, -122.438437264296) | |||
| 33112 | 33112 | 220001 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 88 Santa Marina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006158.19776 | 2097552.9133 | 37.7398292116563 | -122.4212575422 | (37.7398292116563, -122.4212575422) | |||
| 162065 | 162065 | 220000 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 62 Santa Marina St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006013.90538 | 2097631.08265 | 37.7400357112669 | -122.421761996217 | (37.7400357112669, -122.421761996217) | |||
| 47962 | 47962 | 219999 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 62 Santa Marina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6005999.49716 | 2097639.92479 | 37.740059177277004 | -122.421812441905 | (37.740059177277, -122.421812441905) | |||
| 152367 | 152367 | 219998 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 60 Santa Marina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6005981.24616 | 2097649.7003900004 | 37.7400849896219 | -122.421876240696 | (37.7400849896219, -122.421876240696) | |||
| 55582 | 55582 | 220093 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1754 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6003963.29373 | 2098007.80301 | 37.7409542473406 | -122.428879018678 | (37.7409542473406, -122.428879018678) | |||
| 135277 | 135277 | 220051 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 501 Eugenia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6006788.71567 | 2098008.71009 | 37.741116254798605 | -122.419109793907 | (37.7411162547986, -122.419109793907) | |||
| 129876 | 129876 | 220050 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 301 Eugenia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6006755.518130001 | 2098027.45978 | 37.741165867704 | -122.41922590896799 | (37.741165867704, -122.419225908968) | |||
| 169675 | 169675 | 203643 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2479 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5991370.41192 | 2098543.97685 | 37.7417056300124 | -122.47245922253201 | (37.7417056300124, -122.472459222532) | |||
| 30672 | 30672 | 220054 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 300 Virginia Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 6006920.61613 | 2098340.82095 | 37.742035584087795 | -122.418677274846 | (37.7420355840878, -122.418677274846) | |||
| 152749 | 152749 | 203644 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2450 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5991098.76282 | 2098712.81343 | 37.742153485208796 | -122.47341079698799 | (37.7421534852088, -122.473410796988) | |||
| 32938 | 32938 | 203645 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2450 17th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5991098.28096 | 2098726.3101 | 37.7421905156936 | -122.473413447294 | (37.7421905156936, -122.473413447294) | |||
| 161989 | 161989 | 219992 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 101 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007124.70017 | 2098812.5831299997 | 37.7433424258272 | -122.41800505138501 | (37.7433424258272, -122.418005051385) | |||
| 179662 | 179662 | 203222 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 120 Taraval St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5993081.79545 | 2099194.6713799997 | 37.7435911783029 | -122.466589164064 | (37.7435911783029, -122.466589164064) | |||
| 67828 | 67828 | 219994 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 49 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6007506.429690001 | 2099145.6461 | 37.7442784195283 | -122.41670871553801 | (37.7442784195283, -122.416708715538) | |||
| 171522 | 171522 | 220055 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 32 Elsie St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007497.36019 | 2099175.1634299997 | 37.7443589574154 | -122.416742166726 | (37.7443589574154, -122.416742166726) | |||
| 28541 | 28541 | 220690 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 330 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003721.786040001 | 2099258.64688 | 37.7443751038286 | -122.42980326002 | (37.7443751038286, -122.42980326002) | |||
| 26472 | 26472 | 220689 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 119 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004994.550369999 | 2099284.37518 | 37.744517739909 | -122.42540413451401 | (37.744517739909, -122.425404134514) | |||
| 151042 | 151042 | 203622 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 15 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5997339.998380001 | 2099579.33016 | 37.7448921672303 | -122.45189316446002 | (37.7448921672303, -122.45189316446) | |||
| 93809 | 93809 | 203623 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 15 Teresita Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5997330.81089 | 2099592.0734900003 | 37.744926631064 | -122.45192585212 | (37.744926631064, -122.45192585212) | |||
| 53857 | 53857 | 220052 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 50 Coleridge St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006851.995619999 | 2099403.94647 | 37.7449508246175 | -122.418989930439 | (37.7449508246175, -122.418989930439) | |||
| 43667 | 43667 | 203624 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 15 Teresita Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5997319.6106 | 2099609.0427 | 37.7449725828299 | -122.45196580449199 | (37.7449725828299, -122.451965804492) | |||
| 59298 | 59298 | 203625 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 15 Teresita Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5997311.4729 | 2099621.76413 | 37.7450070466421 | -122.45199486067499 | (37.7450070466421, -122.451994860675) | |||
| 50333 | 50333 | 220053 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 50 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006880.915569999 | 2099461.25928 | 37.7451098211639 | -122.418893994368 | (37.7451098211639, -122.418893994368) | |||
| 47237 | 47237 | 220016 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 70 Quartz Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5998965.77386 | 2099787.09557 | 37.74555562500829 | -122.44628649854201 | (37.7455556250083, -122.446286498542) | |||
| 67963 | 67963 | 220015 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 70 Quartz Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5998973.5201 | 2099794.49518 | 37.745576384946 | -122.44626024553601 | (37.745576384946, -122.446260245536) | |||
| 135734 | 135734 | 219995 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1426 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007991.10477 | 2099694.15634 | 37.745811754609896 | -122.415071624753 | (37.7458117546099, -122.415071624753) | |||
| 62900 | 62900 | 203646 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 45 Dorantes Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5994072.18954 | 2100047.28757 | 37.745989350944 | -122.463226505408 | (37.745989350944, -122.463226505408) | |||
| 170817 | 170817 | 220681 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 3223 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6009028.25622 | 2099907.20942 | 37.74645498032329 | -122.41150033867201 | (37.7464549803233, -122.411500338672) | |||
| 188982 | 188982 | 220022 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1334 Diamond St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001965.3710900005 | 2100066.86744 | 37.746494668288996 | -122.435934385359 | (37.746494668289, -122.435934385359) | |||
| 33357 | 33357 | 220021 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1334 Diamond St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001964.613530001 | 2100084.23013 | 37.7465422991033 | -122.435938247064 | (37.7465422991033, -122.435938247064) | |||
| 173012 | 173012 | 220020 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1334 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6001963.20475 | 2100104.97494 | 37.7465991794258 | -122.435944602583 | (37.7465991794258, -122.435944602583) | |||
| 172135 | 172135 | 220019 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 4326 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6001759.60763 | 2100322.6693 | 37.747185348536895 | -122.436664198694 | (37.7471853485369, -122.436664198694) | |||
| 184798 | 184798 | 248081 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1624 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6010444.64523 | 2100169.33268 | 37.7472540585408 | -122.40662106962799 | (37.7472540585408, -122.406621069628) | |||
| 183618 | 183618 | 220682 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1624 Florida St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009643.101369999 | 2100250.00573 | 37.7474306916674 | -122.40939845218 | (37.7474306916674, -122.40939845218) | |||
| 188075 | 188075 | 220035 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1711 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6002636.34581 | 2100467.82106 | 37.7476336866458 | -122.433642882219 | (37.7476336866458, -122.433642882219) | |||
| 49170 | 49170 | 220036 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1711 Castro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6002636.29383 | 2100481.40221 | 37.747670974341396 | -122.43364403244 | (37.7476709743414, -122.43364403244) | |||
| 177028 | 177028 | 220692 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 3951 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6004169.986740001 | 2100702.91409 | 37.7483660981244 | -122.42835639293999 | (37.7483660981244, -122.42835639294) | |||
| 135419 | 135419 | 220693 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 3897 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6004694.52758 | 2100732.52355 | 37.7484770663623 | -122.426544650217 | (37.7484770663623, -122.426544650217) | |||
| 175760 | 175760 | 220061 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 496 Bartlett St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006778.4719 | 2100919.5429 | 37.749108169217294 | -122.41935165935101 | (37.7491081692173, -122.419351659351) | |||
| 133071 | 133071 | 203620 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 358 Pacheco St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5994207.97815 | 2101247.70705 | 37.7492932209146 | -122.46284404261101 | (37.7492932209146, -122.462844042611) | |||
| 162456 | 162456 | 220024 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 4273 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6002125.33793 | 2101175.24323 | 37.749547092337 | -122.435460513693 | (37.749547092337, -122.435460513693) | |||
| 72259 | 72259 | 220008 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 3447 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6006809.37202 | 2101432.95646 | 37.7505196263839 | -122.419281221778 | (37.7505196263839, -122.419281221778) | |||
| 167885 | 167885 | 220009 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 3447 25th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006820.56616 | 2101433.2332200003 | 37.750521016743896 | -122.419242531131 | (37.7505210167439, -122.419242531131) | |||
| 185361 | 185361 | 220004 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1142 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008637.13035 | 2101883.29537 | 37.751858924657796 | -122.412992509104 | (37.7518589246578, -122.412992509104) | |||
| 147911 | 147911 | 220060 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 3505 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006048.59787 | 2101976.73727 | 37.751969847944295 | -122.42195066499599 | (37.7519698479443, -122.421950664996) | |||
| 176834 | 176834 | 220059 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 3505 24th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006111.03304 | 2101975.99077 | 37.75197131922489 | -122.42173470182101 | (37.7519713192249, -122.421734701821) | |||
| 53450 | 53450 | 220065 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 561 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6002722.15364 | 2102085.17478 | 37.7520794267235 | -122.43346172547501 | (37.7520794267235, -122.433461725475) | |||
| 59933 | 59933 | 220069 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1047 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6003827.33604 | 2102174.6628400004 | 37.7523877808826 | -122.42964622220501 | (37.7523877808826, -122.429646222205) | |||
| 62851 | 62851 | 203648 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1907 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5993437.25696 | 2102479.71785 | 37.7526315852957 | -122.46559868313 | (37.7526315852957, -122.46559868313) | |||
| 44341 | 44341 | 220066 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1109 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6002537.114630001 | 2102291.1496200003 | 37.7526344847082 | -122.434116340213 | (37.7526344847082, -122.434116340213) | |||
| 47068 | 47068 | 220057 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 938 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007984.69118 | 2102236.05472 | 37.752790875909 | -122.41527371052099 | (37.752790875909, -122.415273710521) | |||
| 53977 | 53977 | 220014 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 60 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6005833.61465 | 2102298.65201 | 37.7528416246662 | -122.422716983617 | (37.7528416246662, -122.422716983617) | |||
| 155839 | 155839 | 220013 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 58 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6005865.660759999 | 2102301.94093 | 37.7528524632741 | -122.42260639578998 | (37.7528524632741, -122.42260639579) | |||
| 158356 | 158356 | 220012 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 30 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006012.224219999 | 2102309.19405 | 37.7528806462302 | -122.42210006667601 | (37.7528806462302, -122.422100066676) | |||
| 42523 | 42523 | 220064 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 4086 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6002590.76073 | 2102413.7777400003 | 37.7529742368948 | -122.43393958746701 | (37.7529742368948, -122.433939587467) | |||
| 58771 | 58771 | 220011 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 110 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006153.26604 | 2102345.16587 | 37.7529873705964 | -122.421614871629 | (37.7529873705964, -122.421614871629) | |||
| 146931 | 146931 | 220695 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 3706 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6004965.60953 | 2102543.32238 | 37.7534644213631 | -122.425736121051 | (37.7534644213631, -122.425736121051) | |||
| 38287 | 38287 | 220026 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 685 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6001902.38031 | 2102621.8344 | 37.753506421492 | -122.436335023459 | (37.753506421492, -122.436335023459) | |||
| 130349 | 130349 | 220027 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 685 Alvarado St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001922.66093 | 2102622.7782400004 | 37.7535101653675 | -122.43626495635701 | (37.7535101653675, -122.436264956357) | |||
| 129705 | 129705 | 220028 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 685 Alvarado St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001938.58535 | 2102624.90259 | 37.7535169030985 | -122.436210038379 | (37.7535169030985, -122.436210038379) | |||
| 63361 | 63361 | 220063 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 930 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003095.90411 | 2102839.48353 | 37.75417177772871 | -122.432223106309 | (37.7541717777287, -122.432223106309) | |||
| 2852 | 2852 | 215287 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 335 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | Permit Number 780412 | 5992944.71929 | 2103190.50616 | 37.7545548052666 | -122.46735363008301 | (37.7545548052666, -122.467353630083) | ||
| 136032 | 136032 | 188517 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2000 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6012457.67401 | 2102853.6351799998 | 37.7547369917341 | -122.399848584652 | (37.7547369917341, -122.399848584652) | |||
| 53663 | 53663 | 220045 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 160 Marview Way | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5998323.68704 | 2103258.27383 | 37.755049936933 | -122.448756699664 | (37.755049936933, -122.448756699664) | |||
| 136911 | 136911 | 220680 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 54 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6005359.13512 | 2103393.3623900004 | 37.7558206631137 | -122.424435681558 | (37.7558206631137, -122.424435681558) | |||
| 47075 | 47075 | 220067 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 3781 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003185.70208 | 2103572.60316 | 37.756189841101296 | -122.431964909158 | (37.7561898411013, -122.431964909158) | |||
| 68889 | 68889 | 220068 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 3749 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6003417.1638 | 2103582.09113 | 37.756229011985 | -122.43116511330601 | (37.756229011985, -122.431165113306) | |||
| 133605 | 133605 | 220082 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 780 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003052.51993 | 2103630.15774 | 37.7563403210743 | -122.43242960863701 | (37.7563403210743, -122.432429608637) | |||
| 40035 | 40035 | 220081 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 780 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003049.24321 | 2103668.76893 | 37.756446152387795 | -122.432443698342 | (37.7564461523878, -122.432443698342) | |||
| 152179 | 152179 | 220084 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 3580 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6004538.52309 | 2103691.84305 | 37.7565938462521 | -122.427294885373 | (37.7565938462521, -122.427294885373) | |||
| 188761 | 188761 | 220670 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 948 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009928.95694 | 2103687.06035 | 37.7568840925314 | -122.408652407882 | (37.7568840925314, -122.408652407882) | |||
| 170794 | 170794 | 220080 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 517 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002959.284990001 | 2103850.36087 | 37.756939658960206 | -122.432767777111 | (37.7569396589602, -122.432767777111) | |||
| 148095 | 148095 | 220085 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 223 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004732.04309 | 2103949.70152 | 37.757312807464 | -122.42664398483299 | (37.757312807464, -122.426643984833) | |||
| 76199 | 76199 | 220046 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 170 Saint Germain Ave | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5997546.7288 | 2104141.22433 | 37.7574298380281 | -122.451507313917 | (37.7574298380281, -122.451507313917) | |||
| 34367 | 34367 | 220083 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 4133 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6002828.79114 | 2104135.9049299997 | 37.7577162927799 | -122.43323947601401 | (37.7577162927799, -122.433239476014) | |||
| 67640 | 67640 | 220077 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 4160 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6002637.75275 | 2104169.9909900003 | 37.7577990456928 | -122.433902601035 | (37.7577990456928, -122.433902601035) | |||
| 183611 | 183611 | 220078 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 4021 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6003547.22001 | 2104169.9563599997 | 37.7578505193113 | -122.430757284236 | (37.7578505193113, -122.430757284236) | |||
| 52495 | 52495 | 220079 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 4021 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6003566.56829 | 2104171.42308 | 37.7578556427516 | -122.43069047448799 | (37.7578556427516, -122.430690474488) | |||
| 117 | 117 | 220007 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 929 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/12/2015 03:22:00 PM | 1 | Width 3ft | Permit Number 24134 | 6006336.25046 | 2104153.4311599997 | 37.7579627654961 | -122.421110461684 | (37.7579627654961, -122.421110461684) | |
| 187340 | 187340 | 220676 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 3681 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6005782.66085 | 2104298.9799099998 | 37.7583311853523 | -122.423035356192 | (37.7583311853523, -122.423035356192) | |||
| 152597 | 152597 | 220675 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 3681 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6005766.61271 | 2104299.30973 | 37.758331185361 | -122.423090881238 | (37.758331185361, -122.423090881238) |
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");