Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlantDate, PlotSize
Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
186437 | 186437 | 71320 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 326 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1995 12:00:00 AM | 11 | 6004289.26563 | 2090538.0021799998 | 37.720462289783896 | -122.42721997362601 | (37.7204622897839, -122.427219973626) | ||
185509 | 185509 | 240181 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3399 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6004284.27774 | 2106554.82474 | 37.7644405309357 | -122.42837820690201 | (37.7644405309357, -122.428378206902) | |||
185244 | 185244 | 179316 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 209 Sweeny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6009472.2037 | 2094777.58995 | 37.7323950495839 | -122.40960322331199 | (37.7323950495839, -122.409603223312) | |||
178821 | 178821 | 136242 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1679 Washington St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6006678.63942 | 2116999.88567 | 37.7932553363267 | -122.420838360099 | (37.7932553363267, -122.420838360099) | |||
177551 | 177551 | 213972 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1061 Capitol Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5995029.65711 | 2091072.52436 | 37.721401958108295 | -122.459265935174 | (37.7214019581083, -122.459265935174) | |||
176770 | 176770 | 239360 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1301 Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6003913.69662 | 2100667.88359 | 37.7482554068595 | -122.429240140544 | (37.7482554068595, -122.429240140544) | |||
173878 | 173878 | 240175 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 449 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008238.06241 | 2096739.7432799998 | 37.7377134629997 | -122.414008710659 | (37.7377134629997, -122.414008710659) | |||
168559 | 168559 | 179317 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 213 Gaven St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6009388.38978 | 2094971.87362 | 37.7329238140651 | -122.40990669864999 | (37.7329238140651, -122.40990669865) | |||
167912 | 167912 | 137712 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1693 MCALLISTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6001117.7986 | 2111396.751 | 37.7775555640701 | -122.43967731101101 | (37.7775555640701, -122.439677311011) | |||
167199 | 167199 | 239258 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 455 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6005532.11414 | 2101023.4503599997 | 37.749323199804394 | -122.423668969944 | (37.7493231998044, -122.423668969944) | |||
166527 | 166527 | 197112 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2051 23rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6012308.80023 | 2102801.3144400003 | 37.754585029698504 | -122.400359759302 | (37.7545850296985, -122.400359759302) | |||
165461 | 165461 | 240193 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 44 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6004261.16012 | 2097999.70879 | 37.740948877501204 | -122.42784852959998 | (37.7409488775012, -122.4278485296) | |||
164273 | 164273 | 136230 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3100 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6004683.10116 | 2120231.33167 | 37.8020153805639 | -122.427973432847 | (37.8020153805639, -122.427973432847) | |||
161356 | 161356 | 179312 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 407 Cambridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6006926.51281 | 2092590.5645700002 | 37.726246975603 | -122.41824928748001 | (37.726246975603, -122.41824928748) | |||
158844 | 158844 | 136254 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 804 North Point St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6006813.5477 | 2121550.30022 | 37.8057572293748 | -122.420694750958 | (37.8057572293748, -122.420694750958) | |||
158757 | 158757 | 72128 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2012 23rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/25/1984 12:00:00 AM | 11 | 6012399.20292 | 2102851.6444 | 37.7547282656006 | -122.400050655116 | (37.7547282656006, -122.400050655116) | ||
156029 | 156029 | 62003 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1446 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/18/1994 12:00:00 AM | 11 | Permit Number 33451 | 6004382.288930001 | 2120508.49846 | 37.8027593860996 | -122.429034158913 | (37.8027593860996, -122.429034158913) | |
154817 | 154817 | 240133 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 0 Chattanooga St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6004672.52486 | 2103529.70008 | 37.756156217245604 | -122.426819912015 | (37.7561562172456, -122.426819912015) | |||
154312 | 154312 | 239301 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1277 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6010336.55809 | 2101801.57143 | 37.7517297793105 | -122.407109863745 | (37.7517297793105, -122.407109863745) | |||
153669 | 153669 | 142216 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 401 CENTRAL AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5999738.1536 | 2109958.1912 | 37.7735270230304 | -122.444346542631 | (37.7735270230304, -122.444346542631) | |||
153317 | 153317 | 179315 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 100 Hamilton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6009040.95061 | 2093717.83367 | 37.729461010514605 | -122.411019345266 | (37.7294610105146, -122.411019345266) | |||
152159 | 152159 | 239299 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 981 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6009975.32476 | 2103526.84529 | 37.7564467747236 | -122.408480748912 | (37.7564467747236, -122.408480748912) | |||
150643 | 150643 | 67577 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 331 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/1992 12:00:00 AM | 11 | Permit Number 31140 | 6013234.31664 | 2105505.14292 | 37.762060719736795 | -122.397348656429 | (37.7620607197368, -122.397348656429) | |
149171 | 149171 | 42714 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 419 Thornton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 11 | Permit Number 42727 | 6013037.066980001 | 2094313.85012 | 37.731320830081 | -122.39724606626301 | (37.731320830081, -122.397246066263) | |
148254 | 148254 | 123265 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 460 07th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5993761.50417 | 2112485.6321900003 | 37.780123890844706 | -122.465204105338 | (37.7801238908447, -122.465204105338) | |||
148251 | 148251 | 55344 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1518 Bacon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/25/1972 12:00:00 AM | 11 | Permit Number 11275 | 6007044.75091 | 2091766.9119900002 | 37.723992057772 | -122.417782186794 | (37.723992057772, -122.417782186794) | ||
143665 | 143665 | 179304 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 210 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6003900.76299 | 2092464.46075 | 37.7257299409794 | -122.428700160583 | (37.7257299409794, -122.428700160583) | |||
137145 | 137145 | 213941 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 173 Merced Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 5994356.4044699995 | 2099261.98747 | 37.743849483363206 | -122.46218679288799 | (37.7438494833632, -122.462186792888) | |||
136254 | 136254 | 239280 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 352 Lexington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6006524.26929 | 2104030.9306799998 | 37.7576370049615 | -122.420451516722 | (37.7576370049615, -122.420451516722) | |||
134067 | 134067 | 197110 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 600 De Haro St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 6012050.80748 | 2105527.2247200003 | 37.7620553876595 | -122.40144353408701 | (37.7620553876595, -122.401443534087) | ||||
132440 | 132440 | 137888 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2034 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6002938.4973 | 2115326.6052 | 37.788449414784104 | -122.433659844142 | (37.7884494147841, -122.433659844142) | |||
131192 | 131192 | 138423 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1901 SUTTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6003270.9151 | 2114467.7439 | 37.7861100553795 | -122.43244836372699 | (37.7861100553795, -122.432448363727) | |||
131145 | 131145 | 213991 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1 Merced Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 3ft | 5995344.90173 | 2100199.2685 | 37.7464798897511 | -122.458836668093 | (37.7464798897511, -122.458836668093) | |||
131135 | 131135 | 58801 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 136 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/20/1979 12:00:00 AM | 11 | Permit Number 18050 | 5992752.10846 | 2114546.65003 | 37.7857246222932 | -122.468846055179 | (37.7857246222932, -122.468846055179) | ||
129543 | 129543 | 239328 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3213 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6009023.80643 | 2099996.2581700003 | 37.74669923889321 | -122.411522015935 | (37.7466992388932, -122.411522015935) | |||
124104 | 124104 | 213976 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1061 Capitol Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5995023.46765 | 2090970.5982400002 | 37.7211217374705 | -122.459279952923 | (37.7211217374705, -122.459279952923) | |||
90234 | 90234 | 21723 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1935 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/23/1990 12:00:00 AM | 11 | 4X4 | 6003389.836 | 2114488.046 | 37.7861725425441 | -122.432038379652 | (37.7861725425441, -122.432038379652) | ||
76559 | 76559 | 239304 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 821 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6009936.73456 | 2104250.32887 | 37.758431136907795 | -122.40866524479901 | (37.7584311369078, -122.408665244799) | |||
72140 | 72140 | 239356 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 111 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6005135.00311 | 2098711.3374 | 37.7429522432585 | -122.42487771633101 | (37.7429522432585, -122.424877716331) | |||
70076 | 70076 | 239335 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3206 Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008987.26449 | 2099969.0979 | 37.7466226130369 | -122.411646456035 | (37.7466226130369, -122.411646456035) | |||
69300 | 69300 | 179323 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 100 Merrill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6009520.85663 | 2094768.8785700002 | 37.7323738561678 | -122.409434403484 | (37.7323738561678, -122.409434403484) | |||
68853 | 68853 | 239319 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 53 Norwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6009012.44939 | 2099437.10451 | 37.745163289459995 | -122.4115217893 | (37.74516328946, -122.4115217893) | |||
68615 | 68615 | 240151 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1526 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 5998354.70751 | 2105195.37647 | 37.760370512299 | -122.448788941261 | (37.760370512299, -122.448788941261) | |||
66176 | 66176 | 62995 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 828 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/17/1986 12:00:00 AM | 11 | Permit Number 23397 | 6009184.70363 | 2115820.64878 | 37.7901583733657 | -122.412083801744 | (37.7901583733657, -122.412083801744) | ||
65359 | 65359 | 213940 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2526 14th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5992077.65136 | 2098235.486 | 37.7408995020175 | -122.46999139020599 | (37.7408995020175, -122.469991390206) | |||
63717 | 63717 | 240167 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 955 Clayton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 5998784.85204 | 2106603.32437 | 37.764260973182395 | -122.44740261924 | (37.7642609731824, -122.44740261924) | |||
63053 | 63053 | 240137 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 466 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6003486.65901 | 2100127.7633700003 | 37.7467481782042 | -122.43067828687201 | (37.7467481782042, -122.430678286872) | |||
62846 | 62846 | 240171 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 457 Anderson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6007878.36492 | 2096720.03268 | 37.7376391331344 | -122.415250966654 | (37.7376391331344, -122.415250966654) | |||
61299 | 61299 | 240157 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 563 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5998602.31996 | 2105951.33852 | 37.762460351486794 | -122.44798699779601 | (37.7624603514868, -122.447986997796) | |||
59697 | 59697 | 240149 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1515 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 5998302.63561 | 2105242.38335 | 37.7604966035517 | -122.448972419165 | (37.7604966035517, -122.448972419165) | |||
59382 | 59382 | 213975 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1061 Capitol Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5995024.51997 | 2091003.2487299999 | 37.7212114484221 | -122.45927867859501 | (37.7212114484221, -122.459278678595) | |||
58193 | 58193 | 138286 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2027 FILLMORE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6002884.377 | 2115289.0168 | 37.788343135637795 | -122.433844403927 | (37.7883431356378, -122.433844403927) | |||
57487 | 57487 | 240150 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1537 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 5998310.40334 | 2105182.48783 | 37.760332589688 | -122.448941239673 | (37.760332589688, -122.448941239673) | |||
56253 | 56253 | 138334 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1971 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6002917.5822 | 2115096.7114 | 37.7878169981836 | -122.43371576970101 | (37.7878169981836, -122.433715769701) | |||
55899 | 55899 | 239259 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 455 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6005530.597 | 2101040.15381 | 37.749368977999 | -122.423675403717 | (37.749368977999, -122.423675403717) | |||
55365 | 55365 | 240183 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3371 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6004376.30162 | 2106560.65422 | 37.764461744133 | -122.428060337037 | (37.764461744133, -122.428060337037) | |||
54454 | 54454 | 239342 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 249 Mullen Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6010242.3381900005 | 2100031.5164900003 | 37.7468643247282 | -122.40731092156 | (37.7468643247282, -122.40731092156) | |||
54021 | 54021 | 248025 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 443 Franconia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6009980.9710099995 | 2098457.93236 | 37.7425289746384 | -122.408103750406 | (37.7425289746384, -122.408103750406) | |||
51017 | 51017 | 69367 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3630 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/18/1994 12:00:00 AM | 11 | Permit Number 33461 | 6002617.53648 | 2121095.37594 | 37.8042707453542 | -122.435183094434 | (37.8042707453542, -122.435183094434) | |
49521 | 49521 | 240131 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 0 Chattanooga St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6004671.7789900005 | 2103561.17999 | 37.7562426115098 | -122.426824733295 | (37.7562426115098, -122.426824733295) | |||
46311 | 46311 | 136201 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 20 Retiro Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6001803.6012 | 2121217.14439 | 37.8045588359743 | -122.438008504412 | (37.8045588359743, -122.438008504412) | |||
39609 | 39609 | 42172 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 525 05th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/2000 12:00:00 AM | 11 | Permit Number 42460 | 6012593.26461 | 2111204.07737 | 37.7776729981365 | -122.399966040597 | (37.7776729981365, -122.399966040597) | ||
31500 | 31500 | 69354 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1342 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/18/1994 12:00:00 AM | 11 | Permit Number 33445 | 6004870.03416 | 2120576.9578 | 37.8029749544875 | -122.427351191008 | (37.8029749544875, -122.427351191008) | |
30857 | 30857 | 239336 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3206 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008986.81884 | 2099989.0905299997 | 37.74667748337421 | -122.41164940941201 | (37.7466774833742, -122.411649409412) | |||
30856 | 30856 | 197169 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2 Baldwin Ct | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 4ft | 6017690.0216 | 2093651.3665 | 37.7297597257339 | -122.38111373781 | (37.7297597257339, -122.38111373781) | |||
29146 | 29146 | 179293 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 180 Edinburgh St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6004018.855 | 2092658.23186 | 37.7262686762461 | -122.428305729646 | (37.7262686762461, -122.428305729646) | |||
28424 | 28424 | 239318 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2765 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6010143.74039 | 2102787.8018900002 | 37.7544269567524 | -122.407846193561 | (37.7544269567524, -122.407846193561) | |||
27611 | 27611 | 239367 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 17 Chattanooga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6004711.71138 | 2103517.26847 | 37.756124298509896 | -122.42668350644101 | (37.7561242985099, -122.426683506441) | |||
26447 | 26447 | 213937 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 155 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5992856.26396 | 2098093.99646 | 37.740555986160494 | -122.467288974202 | (37.7405559861605, -122.467288974202) | |||
26025 | 26025 | 136191 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2914 Fillmore St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6002535.252730001 | 2118218.14981 | 37.7963659626655 | -122.435261914602 | (37.7963659626655, -122.435261914602) | |||
24461 | 24461 | 138424 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1901 SUTTER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6003330.8547 | 2114478.3784 | 37.786142653739 | -122.432241748584 | (37.786142653739, -122.432241748584) | |||
23326 | 23326 | 14782 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1037 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11 | 4X4 | 6004198.5372 | 2111824.0669 | 37.7789037342236 | -122.429050478372 | (37.7789037342236, -122.429050478372) |
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");