Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCareAssistant, PlantDate, PlotSize, PermitNotes
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3834 | 3834 | 244219 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 588 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5998052.0 | 2108644.0 | 37.76982224415679 | -122.450084429151 | (37.7698222441568, -122.450084429151) | |||
6697 | 6697 | 7312 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1940 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6002968.6362 | 2115073.8773 | 37.7877571983499 | -122.433537500112 | (37.7877571983499, -122.433537500112) | |||
7900 | 7900 | 4617 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 348 Columbus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/1995 12:00:00 AM | 10 | 3x3 | 6010597.9091 | 2118822.5443 | 37.7984800429378 | -122.40740591699 | (37.7984800429378, -122.40740591699) | ||
10418 | 10418 | 77647 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1300X Silliman St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/26/1984 12:00:00 AM | 10 | 3x3 | 6006841.82551 | 2093150.82877 | 37.7277805724005 | -122.418581759638 | (37.7277805724005, -122.418581759638) | |
23128 | 23128 | 4406 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1060 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 3X3 | 6004384.57785 | 2102734.51473 | 37.7539565402887 | -122.42775907492799 | (37.7539565402887, -122.427759074928) | |||
25584 | 25584 | 123293 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 566 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5994099.84027 | 2111646.79244 | 37.7778401670229 | -122.46397274776301 | (37.7778401670229, -122.463972747763) | |||
25963 | 25963 | 179311 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 427 Cambridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6006943.30245 | 2092535.62338 | 37.7260970640242 | -122.418187352968 | (37.7260970640242, -122.418187352968) | |||
26041 | 26041 | 239277 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 150 Lexington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006452.39888 | 2105218.17632 | 37.760892854741996 | -122.420784359417 | (37.760892854742, -122.420784359417) | |||
29246 | 29246 | 138000 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1932 FILLMORE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6002970.878 | 2115057.2879 | 37.78771177526961 | -122.433528557906 | (37.7877117752696, -122.433528557906) | |||
29544 | 29544 | 213971 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1061 Capitol Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5995026.07265 | 2091112.6142099998 | 37.7215118291791 | -122.459281227253 | (37.7215118291791, -122.459281227253) | |||
30146 | 30146 | 44337 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1386 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/06/2001 12:00:00 AM | 10 | Permit Number 43722 | 6016111.020719999 | 2094370.93672 | 37.7316482354559 | -122.386622725671 | (37.7316482354559, -122.386622725671) | ||
30190 | 30190 | 136213 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 107 Spruce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5997027.70911 | 2115921.73522 | 37.78974632646779 | -122.45415312837099 | (37.7897463264678, -122.454153128371) | |||
30274 | 30274 | 239311 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 464 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6005494.12674 | 2100990.71225 | 37.7492311640921 | -122.423798003785 | (37.7492311640921, -122.423798003785) | |||
31164 | 31164 | 240161 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 504 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5998591.56873 | 2106281.83073 | 37.7633671855679 | -122.448047979048 | (37.7633671855679, -122.448047979048) | |||
31313 | 31313 | 56220 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 483 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/03/1973 12:00:00 AM | 10 | Permit Number 12342 | 5990901.62894 | 2112114.24855 | 37.7789388399986 | -122.475070494342 | (37.7789388399986, -122.475070494342) | ||
35422 | 35422 | 239293 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 936 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 6ft | 6009925.69316 | 2103743.6378599997 | 37.757039258881 | -122.40866768648199 | (37.757039258881, -122.408667686482) | |||
36074 | 36074 | 240200 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 57 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6002464.85342 | 2096514.646 | 37.736769456354 | -122.43395336236401 | (37.736769456354, -122.433953362364) | |||
36783 | 36783 | 136264 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1600 Montgomery St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 6011327.59811 | 2121029.0502400002 | 37.804579383680895 | -122.40503639942601 | (37.8045793836809, -122.405036399426) | |||
38945 | 38945 | 239368 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 7 Chattanooga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6004707.84944 | 2103578.58278 | 37.7562924348615 | -122.426701228489 | (37.7562924348615, -122.426701228489) | |||
39309 | 39309 | 70680 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 330 Utah St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1994 12:00:00 AM | 10 | 6010584.43859 | 2106698.38492 | 37.7651892021367 | -122.406597696229 | (37.7651892021367, -122.406597696229) | ||
39329 | 39329 | 213917 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1651 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5992756.585530001 | 2104219.0263799997 | 37.7573679916487 | -122.46807905201 | (37.7573679916487, -122.46807905201) | |||
39644 | 39644 | 121918 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 434 17th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 1ft | 5990628.47281 | 2112418.69115 | 37.7797589204997 | -122.47603768167 | (37.7797589204997, -122.47603768167) | |||
41318 | 41318 | 240143 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 109 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 5998171.35185 | 2106192.58759 | 37.763098116497204 | -122.449494935145 | (37.7630981164972, -122.449494935145) | |||
42701 | 42701 | 136231 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 828 Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6009179.0642099995 | 2115849.5687700002 | 37.790237464224894 | -122.412105358482 | (37.7902374642249, -122.412105358482) | |||
43340 | 43340 | 239340 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 255 Mullen Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6010272.59019 | 2100048.52485 | 37.746912719065 | -122.407207511226 | (37.746912719065, -122.407207511226) | |||
44437 | 44437 | 120251 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 160 24th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 6ft | 5988366.40775 | 2114885.43189 | 37.7864004688283 | -122.48404399839899 | (37.7864004688283, -122.484043998399) | |||
52370 | 52370 | 239349 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 524 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6003127.51447 | 2098934.59686 | 37.7434516673581 | -122.431834992216 | (37.7434516673581, -122.431834992216) | |||
52646 | 52646 | 136218 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2901 Steiner St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6002000.868319999 | 2118219.4196099997 | 37.7963390882297 | -122.437111085304 | (37.7963390882297, -122.437111085304) | |||
54351 | 54351 | 239344 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 221 Mullen Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6010109.73807 | 2099963.72008 | 37.746670748365 | -122.40776466280899 | (37.746670748365, -122.407764662809) | |||
56189 | 56189 | 240144 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1207 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 5998176.37667 | 2106172.1274099997 | 37.7630422254456 | -122.449476081756 | (37.7630422254456, -122.449476081756) | |||
56601 | 56601 | 240163 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 499 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5998551.61498 | 2106310.67674 | 37.7634441054949 | -122.448188242691 | (37.7634441054949, -122.448188242691) | |||
57011 | 57011 | 136263 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1600 Montgomery St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 6011331.32037 | 2121003.20622 | 37.804508630427 | -122.40502169731 | (37.804508630427, -122.40502169731) | |||
58178 | 58178 | 179302 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 200 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6003690.09434 | 2092638.18195 | 37.7261950154772 | -122.429440808968 | (37.7261950154772, -122.429440808968) | |||
58670 | 58670 | 240174 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 455 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008235.53885 | 2096703.3498099998 | 37.7376133927535 | -122.414014861994 | (37.7376133927535, -122.414014861994) | |||
59413 | 59413 | 70593 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 314 Athens St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/06/1994 12:00:00 AM | 10 | 6004216.40489 | 2091443.51048 | 37.722944495983 | -122.427536307463 | (37.722944495983, -122.427536307463) | ||
59563 | 59563 | 136228 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1695 North Point St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6002671.67342 | 2120917.48858 | 37.8037853875576 | -122.43498301955401 | (37.8037853875576, -122.434983019554) | |||
60301 | 60301 | 213927 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 15 Hill Point Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5996327.91302 | 2106768.63925 | 37.764574179173 | -122.455912374956 | (37.764574179173, -122.455912374956) | |||
65075 | 65075 | 240148 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1407 Cole St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5998258.05957 | 2105587.56322 | 37.761441831488 | -122.44915145438601 | (37.761441831488, -122.449151454386) | |||
65822 | 65822 | 74096 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1133 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/29/1994 12:00:00 AM | 10 | 6001902.78384 | 2087667.7277099998 | 37.712445903022704 | -122.435264062185 | (37.7124459030227, -122.435264062185) | ||
66614 | 66614 | 136269 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 220 Joice St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6010214.18023 | 2117016.1329200002 | 37.7934985921435 | -122.408606245692 | (37.7934985921435, -122.408606245692) | |||
66699 | 66699 | 136270 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 232 Joice St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6010211.84194 | 2117041.25544 | 37.7935674415409 | -122.40861610945299 | (37.7935674415409, -122.408616109453) | |||
70444 | 70444 | 213938 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 159 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5992850.99558 | 2098086.47375 | 37.7405350265634 | -122.467306643206 | (37.7405350265634, -122.467306643206) | |||
70956 | 70956 | 240142 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 137 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 5997839.49621 | 2106779.6286400002 | 37.7646909930258 | -122.450685033183 | (37.7646909930258, -122.450685033183) | |||
72873 | 72873 | 213944 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 98 Westwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 5995156.984180001 | 2093277.67362 | 37.7274640883802 | -122.458985387177 | (37.7274640883802, -122.458985387177) | |||
77045 | 77045 | 120249 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 164 24th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 6ft | 5988365.91336 | 2114852.64965 | 37.786310429345704 | -122.48404330399599 | (37.7863104293457, -122.484043303996) | |||
78482 | 78482 | 7334 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 2095X Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 3X3 | 6002864.90775 | 2115441.94118 | 37.7887619221715 | -122.433922699489 | (37.7887619221715, -122.433922699489) | |||
84091 | 84091 | 8916 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 4455X Geary Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 5993207.14557 | 2112702.93338 | 37.7806885575202 | -122.467137671277 | (37.7806885575202, -122.467137671277) | |||
87818 | 87818 | 102145 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 0X Ford St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6003601.0 | 2105679.0 | 37.7619970392507 | -122.430678972901 | (37.7619970392507, -122.430678972901) | |||
88779 | 88779 | 41683 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 68 Mars St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | 10 | Permit Number 42137 | 5999567.20857147 | 2105392.00369761 | 37.760979664179104 | -122.44460961092501 | (37.7609796641791, -122.444609610925) | |
99067 | 99067 | 102143 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 442 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6003585.0 | 2105673.0 | 37.761979658220206 | -122.43073388246799 | (37.7619796582202, -122.430733882468) | |||
101671 | 101671 | 114903 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3261 23rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6007278.07200017 | 2102623.89370267 | 37.7538160547365 | -122.41774482262699 | (37.7538160547365, -122.417744822627) | |||
103412 | 103412 | 7310 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1930 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/22/2011 12:00:00 AM | 10 | 3x3 | 6002973.84302 | 2114998.5825 | 37.7875507533927 | -122.433514102581 | (37.7875507533927, -122.433514102581) | ||
107668 | 107668 | 30657 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 35 Lafayette St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | 10 | 3x3 | Permit Number 34590 | 6007536.63957853 | 2109665.02696878 | 37.773163916329295 | -122.41734957960699 | (37.7731639163293, -122.417349579607) |
115333 | 115333 | 30525 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 96 McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/2005 12:00:00 AM | 10 | 3x3 | 6008672.39963745 | 2112539.12321188 | 37.7811193385199 | -122.41362414398701 | (37.7811193385199, -122.413624143987) | |
116838 | 116838 | 10455 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1555 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3X3 | 5998706.29238 | 2108552.28682 | 37.7696078418555 | -122.44781465392599 | (37.7696078418555, -122.447814653926) | |||
117317 | 117317 | 115488 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1393 YORK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6010176.0 | 2101093.0 | 37.7497752121793 | -122.407615143394 | (37.7497752121793, -122.407615143394) | |||
124995 | 124995 | 7316 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2000 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3X3 | 6002972.254319999 | 2115230.97031 | 37.788188741068204 | -122.433536213059 | (37.7881887410682, -122.433536213059) | |||
125584 | 125584 | 30655 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 35 Lafayette St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | 10 | 3x3 | Permit Number 34590 | 6007536.63957853 | 2109665.02696878 | 37.773163916329295 | -122.41734957960699 | (37.7731639163293, -122.417349579607) |
130001 | 130001 | 240156 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 507 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 5998563.13557 | 2106225.25844 | 37.7632102269035 | -122.448142245984 | (37.7632102269035, -122.448142245984) | |||
132548 | 132548 | 136193 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2914 Fillmore St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6002531.20881 | 2118254.41346 | 37.79646530358411 | -122.43527850261002 | (37.7964653035841, -122.43527850261) | |||
133737 | 133737 | 240172 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 553 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008195.53017 | 2096250.8800700002 | 37.73636876251379 | -122.414121189761 | (37.7363687625138, -122.414121189761) | |||
134133 | 134133 | 138456 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1901 FILLMORE ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6002949.306 | 2114858.1502 | 37.7871637698126 | -122.43358895561899 | (37.7871637698126, -122.433588955619) | |||
134330 | 134330 | 239371 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3541 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6004752.24565 | 2103660.80314 | 37.75652070258361 | -122.42655354540399 | (37.7565207025836, -122.426553545404) | |||
134770 | 134770 | 179307 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 263 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6003768.55013 | 2092162.8049599999 | 37.724894177618 | -122.429135711245 | (37.724894177618, -122.429135711245) | |||
135839 | 135839 | 197070 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2224 Mariposa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6010762.18372 | 2106028.80224 | 37.7633606223146 | -122.40593574303301 | (37.7633606223146, -122.405935743033) | |||
136079 | 136079 | 72127 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2110 23rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/25/1984 12:00:00 AM | 10 | 6012120.035209999 | 2102839.43148 | 37.7546791626274 | -122.401015240957 | (37.7546791626274, -122.401015240957) | ||
136568 | 136568 | 136260 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 740 Francisco St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 6007759.94756 | 2120993.00482 | 37.8042803312301 | -122.417380065732 | (37.8042803312301, -122.417380065732) | |||
137657 | 137657 | 197111 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 600 De Haro St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 6012057.756469999 | 2105514.57714 | 37.762021047941204 | -122.401418611192 | (37.7620210479412, -122.401418611192) | ||||
142130 | 142130 | 30656 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 35 Lafayette St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | 10 | 3x3 | Permit Number 34590 | 6007536.63957853 | 2109665.02696878 | 37.773163916329295 | -122.41734957960699 | (37.7731639163293, -122.417349579607) |
146977 | 146977 | 136192 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2914 Fillmore St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6002533.36728 | 2118236.78125 | 37.796417012690505 | -122.43526977200199 | (37.7964170126905, -122.435269772002) | |||
147868 | 147868 | 113164 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3902 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 5996104.12061 | 2115248.7957599997 | 37.7878456121944 | -122.457299932451 | (37.7878456121944, -122.457299932451) | |||
149420 | 149420 | 136190 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2914 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6002538.23525 | 2118203.76672 | 37.7963266398053 | -122.43525056515499 | (37.7963266398053, -122.435250565155) | |||
153252 | 153252 | 246026 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 8 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5998207.6 | 2108524.1023 | 37.7695019383238 | -122.44953757446899 | (37.7695019383238, -122.449537574469) | |||
160304 | 160304 | 247591 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 800 Tompkins Ave | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 6008974.65943 | 2096434.5209700002 | 37.736916732029705 | -122.411440373668 | (37.7369167320297, -122.411440373668) | ||||
161261 | 161261 | 48960 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2038 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2002 12:00:00 AM | 10 | Permit Number 46146 | 6003159.19812 | 2118949.28174 | 37.7984088743259 | -122.433155199676 | (37.7984088743259, -122.433155199676) | ||
163550 | 163550 | 113166 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3902 Clay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 5996084.69058 | 2115243.98919 | 37.7878312986742 | -122.457366808459 | (37.7878312986742, -122.457366808459) | |||
164262 | 164262 | 240162 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 497 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5998550.13742 | 2106327.4431 | 37.763490057236204 | -122.448194560431 | (37.7634900572362, -122.448194560431) | |||
166156 | 166156 | 67528 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1306 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/22/1992 12:00:00 AM | 10 | Permit Number 31066 | 6013997.6079400005 | 2104810.58865 | 37.760196092391 | -122.394660066634 | (37.760196092391, -122.394660066634) | |
169703 | 169703 | 36194 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 107 Spruce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Permit Number 39260 | 5997029.24357 | 2115938.23155 | 37.7897917089598 | -122.454149011282 | (37.7897917089598, -122.454149011282) | |||
171604 | 171604 | 239341 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 249 Mullen Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6010255.29799 | 2100038.54541 | 37.746884349931705 | -122.407266602985 | (37.7468843499317, -122.407266602985) | |||
171759 | 171759 | 240146 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1217 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 5998179.2817400005 | 2106131.69521 | 37.7629313749956 | -122.449463120725 | (37.7629313749956, -122.449463120725) | |||
172877 | 172877 | 213968 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1061 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5995026.496169999 | 2091185.65951 | 37.7217124184688 | -122.459285050266 | (37.7217124184688, -122.459285050266) | |||
173604 | 173604 | 240189 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 49 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6004299.90436 | 2097973.73041 | 37.7408797385189 | -122.427712715772 | (37.7408797385189, -122.427712715772) | |||
174480 | 174480 | 213955 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 360 Faxon Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5994772.87853 | 2091030.08167 | 37.721270654392 | -122.460150467873 | (37.721270654392, -122.460150467873) | |||
176007 | 176007 | 240176 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 437 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008241.87185 | 2096776.8693400002 | 37.737815616996606 | -122.41399816519301 | (37.7378156169966, -122.413998165193) | |||
178942 | 178942 | 239347 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 527 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6003128.434719999 | 2098886.3113700002 | 37.7433191387728 | -122.431828363289 | (37.7433191387728, -122.431828363289) | |||
184836 | 184836 | 240182 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3399 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6004311.1947099995 | 2106557.83586 | 37.7644503218386 | -122.42828532312299 | (37.7644503218386, -122.428285323123) | |||
186441 | 186441 | 248005 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 444 Franconia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6009949.03766 | 2098432.55716 | 37.7424575118092 | -122.408212377719 | (37.7424575118092, -122.408212377719) | |||
188730 | 188730 | 136221 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2901 Steiner St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6002012.26452 | 2118128.8819999998 | 37.7960911433324 | -122.437065166822 | (37.7960911433324, -122.437065166822) |
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");