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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |
| 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) | ||
| 23746 | 23746 | 188514 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1 Mississippi St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6013990.927619999 | 2106981.7626099996 | 37.7661572890446 | -122.394835230264 | (37.7661572890446, -122.394835230264) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 33288 | 33288 | 220075 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 311 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6001146.06945 | 2104525.9934099996 | 37.758691778412704 | -122.43908696419201 | (37.7586917784127, -122.439086964192) | |||
| 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) | |||
| 33878 | 33878 | 220678 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 3607 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006149.55219 | 2104320.61277 | 37.758411280773394 | -122.421768019002 | (37.7584112807734, -122.421768019002) | |||
| 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) | |||
| 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) | |||
| 34990 | 34990 | 124760 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1055 Greenwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007817.3795 | 2119902.3991900003 | 37.8012890341312 | -122.417103992782 | (37.8012890341312, -122.417103992782) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 43321 | 43321 | 220677 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 3625 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006108.91147 | 2104316.6789599997 | 37.758398187543996 | -122.42190829343399 | (37.758398187544, -122.421908293434) | |||
| 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) | |||
| 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) | |||
| 44479 | 44479 | 220686 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 430 Hickory St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6004903.16789 | 2110400.7033700002 | 37.775035387294295 | -122.426511501216 | (37.7750353872943, -122.426511501216) | |||
| 45041 | 45041 | 188518 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 805 Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6011322.68807 | 2104548.86682 | 37.75932838242 | -122.403892982475 | (37.75932838242, -122.403892982475) | |||
| 45254 | 45254 | 220074 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 148 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6002660.22221 | 2105037.36162 | 37.7601819118789 | -122.43388688897 | (37.7601819118789, -122.43388688897) | |||
| 45390 | 45390 | 220087 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 69 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001718.50654 | 2105457.8427 | 37.7612829653482 | -122.437173938027 | (37.7612829653482, -122.437173938027) | |||
| 45531 | 45531 | 220666 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1 Dorland St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6005487.19676 | 2105743.72088 | 37.7622814268651 | -122.42415994852199 | (37.7622814268651, -122.424159948522) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 47618 | 47618 | 220674 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 3548 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6005923.11971 | 2104936.6524900002 | 37.760090010159104 | -122.42259489975201 | (37.7600900101591, -122.422594899752) | |||
| 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) | |||
| 48670 | 48670 | 220058 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 564 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6007852.78726 | 2104670.9495900003 | 37.7594691272161 | -122.415902267384 | (37.7594691272161, -122.415902267384) | |||
| 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) | |||
| 50057 | 50057 | 220672 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 25 Cumberland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6005444.88154 | 2104573.79472 | 37.759066695887 | -122.42422309172701 | (37.759066695887, -122.424223091727) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 53649 | 53649 | 219989 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 936 Clayton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5998793.85425 | 2106724.38466 | 37.7645938887298 | -122.447380197361 | (37.7645938887298, -122.447380197361) | |||
| 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) | |||
| 53685 | 53685 | 220687 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 430 Hickory St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6004894.475319999 | 2110399.44382 | 37.775031437471704 | -122.426541481018 | (37.7750314374717, -122.426541481018) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 56688 | 56688 | 122010 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1342 Cabrillo St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5991362.52356 | 2110673.50037 | 37.775009640229605 | -122.473370979732 | (37.7750096402296, -122.473370979732) | |||
| 58064 | 58064 | 220047 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1201 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5997716.00381 | 2106428.96316 | 37.7637210849721 | -122.451086869165 | (37.7637210849721, -122.451086869165) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 65145 | 65145 | 124758 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1513 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006956.23003 | 2117363.82528 | 37.79427026621129 | -122.419903713582 | (37.7942702662113, -122.419903713582) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 68064 | 68064 | 188520 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 495 Connecticut St | 2 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6013272.40757 | 2104812.59187 | 37.7601612472551 | -122.397168349564 | (37.7601612472551, -122.397168349564) | |||
| 68651 | 68651 | 220688 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 434 Hickory St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6004866.02058 | 2110397.15298 | 37.7750235387365 | -122.426639749043 | (37.7750235387365, -122.426639749043) | |||
| 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) | |||
| 69010 | 69010 | 188521 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 495 Connecticut St | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6013271.447919999 | 2104826.1277799997 | 37.7601983604744 | -122.397172617724 | (37.7601983604744, -122.397172617724) | |||
| 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) | |||
| 72341 | 72341 | 220010 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 3561 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6006555.55006 | 2104341.3837900003 | 37.758491199927 | -122.420365369767 | (37.758491199927, -122.420365369767) | |||
| 74967 | 74967 | 124761 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1055 Greenwich St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007856.93229 | 2119906.6476 | 37.8013029241584 | -122.41696742351101 | (37.8013029241584, -122.416967423511) | |||
| 75192 | 75192 | 220070 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 410 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6003569.73703 | 2105814.1279 | 37.762366296795996 | -122.43079674288 | (37.762366296796, -122.43079674288) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 130794 | 130794 | 188513 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 55 Mississippi St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6013999.87449 | 2106891.97216 | 37.7659112417232 | -122.39479799565399 | (37.7659112417232, -122.394797995654) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 136845 | 136845 | 124750 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 566 Linden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6004650.035 | 2110687.35997 | 37.775808163060205 | -122.42740756863 | (37.7758081630602, -122.42740756863) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 152034 | 152034 | 124751 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 566 Linden St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6004689.62752 | 2110692.77739 | 37.775825277144705 | -122.427270993988 | (37.7758252771447, -122.427270993988) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 153239 | 153239 | 220071 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 3854 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003950.57262 | 2104825.46317 | 37.7596732292507 | -122.429409067394 | (37.7596732292507, -122.429409067394) | |||
| 154694 | 154694 | 220683 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 364 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004832.893569999 | 2109879.94078 | 37.7736015271323 | -122.426717502624 | (37.7736015271323, -122.426717502624) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 157166 | 157166 | 220088 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 18 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6001975.9163 | 2107746.07495 | 37.767580520153 | -122.43644744680701 | (37.767580520153, -122.436447446807) | |||
| 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) | |||
| 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) |
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");