Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantType, qCaretaker, qCareAssistant, DBH
| Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 188810 | 188810 | 48419 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2192 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/2002 12:00:00 AM | 5 | Permit Number 45797 | 6002578.00127 | 2118175.76067 | 37.796252000589796 | -122.435110962497 | (37.7962520005898, -122.435110962497) | ||
| 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) | |||
| 188713 | 188713 | 138427 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1901 SUTTER ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6003418.1055 | 2114492.1548 | 37.786185426920795 | -122.431940868192 | (37.7861854269208, -122.431940868192) | |||
| 188523 | 188523 | 248301 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3175 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6006762.6824 | 2099881.3423 | 37.7462566162113 | -122.419332619842 | (37.7462566162113, -122.419332619842) | |||
| 188451 | 188451 | 240178 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 425 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008247.1635300005 | 2096824.3418400001 | 37.737946263300294 | -122.413983226571 | (37.7379462633003, -122.413983226571) | |||
| 188403 | 188403 | 239243 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1301 Potrero Ave | 4 | : 4 | Tree 1 | Private 1 | 15 | Width 3ft | 6010651.8200900005 | 2101663.18223 | 37.751367430767395 | -122.40600989216101 | (37.7513674307674, -122.406009892161) | |||
| 188385 | 188385 | 197096 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 385 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6014371.98869 | 2105338.4156400003 | 37.7616661979483 | -122.39340218937099 | (37.7616661979483, -122.393402189371) | |||
| 188252 | 188252 | 213979 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 254 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5994759.40129 | 2090277.98422 | 37.719204799252296 | -122.46014259431999 | (37.7192047992523, -122.46014259432) | |||
| 188071 | 188071 | 182790 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1791 26th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5988113.3036 | 2103133.9629 | 37.754119452236 | -122.48405759118499 | (37.754119452236, -122.484057591185) | |||
| 187865 | 187865 | 113165 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3902 Clay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 5996094.44333 | 2115248.19615 | 37.787843410013 | -122.457333370439 | (37.787843410013, -122.457333370439) | |||
| 187404 | 187404 | 31226 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2598 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | 6 | Permit Number 34913 | 5992091.73833 | 2097813.94877 | 37.7397428821404 | -122.469911998937 | (37.7397428821404, -122.469911998937) | |
| 187291 | 187291 | 141599 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 30 ASHBURY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5998723.6664 | 2110574.4541 | 37.7751611896291 | -122.447900165728 | (37.7751611896291, -122.447900165728) | |||
| 187135 | 187135 | 239244 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1300 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6010301.835030001 | 2101602.35091 | 37.7511808205419 | -122.40721589920099 | (37.7511808205419, -122.407215899201) | |||
| 187068 | 187068 | 136217 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2901 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001997.91666 | 2118237.1003900003 | 37.7963874672615 | -122.43712256517999 | (37.7963874672615, -122.43712256518) | |||
| 187016 | 187016 | 239284 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2750 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009668.03436 | 2105500.1290599997 | 37.761847752195294 | -122.409682747679 | (37.7618477521953, -122.409682747679) | |||
| 186941 | 186941 | 141626 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1801 GROVE ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5998957.5366 | 2110405.2337 | 37.7747099187277 | -122.44707897901002 | (37.7747099187277, -122.44707897901) | |||
| 186653 | 186653 | 75060 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 390x Utah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1994 12:00:00 AM | 7 | 6010594.46043 | 2106517.2504 | 37.76469240853879 | -122.406550267789 | (37.7646924085388, -122.406550267789) | ||
| 186622 | 186622 | 213959 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 360 Faxon Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5994775.57323 | 2091144.94508 | 37.721586196813995 | -122.460149470543 | (37.721586196814, -122.460149470543) | |||
| 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) | |||
| 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) | ||
| 186343 | 186343 | 136200 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2101 Beach St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6000132.373269999 | 2120911.69707 | 37.803624978161295 | -122.443769967932 | (37.8036249781613, -122.443769967932) | |||
| 186231 | 186231 | 239333 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3258 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6009001.08587 | 2099726.03471 | 37.7459559905813 | -122.411581492612 | (37.7459559905813, -122.411581492612) | |||
| 186161 | 186161 | 197074 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2310 17th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6010495.70996 | 2106480.9898200002 | 37.7645873200617 | -122.406889265436 | (37.7645873200617, -122.406889265436) | |||
| 186113 | 186113 | 240179 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 419 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008252.0977 | 2096866.76003 | 37.7380630114909 | -122.41396916654199 | (37.7380630114909, -122.413969166542) | |||
| 185979 | 185979 | 141928 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1050 MCALLISTER ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6004234.8996 | 2111882.5726 | 37.779066434664294 | -122.428928858602 | (37.7790664346643, -122.428928858602) | |||
| 185942 | 185942 | 69346 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 658 Arkansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/15/1994 12:00:00 AM | 8 | Permit Number 33435 | 6012980.70536 | 2103982.94332 | 37.7578669706033 | -122.39811901029199 | (37.7578669706033, -122.398119010292) | ||
| 185841 | 185841 | 120256 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 140 24th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 5988368.86327 | 2114963.36268 | 37.7866145875471 | -122.48404121988199 | (37.7866145875471, -122.484041219882) | |||
| 185794 | 185794 | 239255 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3445 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6006854.967180001 | 2100851.4733 | 37.7489255735681 | -122.419082309695 | (37.7489255735681, -122.419082309695) | |||
| 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) | |||
| 185384 | 185384 | 42169 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 525 05th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | 9 | Permit Number 42460 | 6012658.26755 | 2111134.8999400004 | 37.777486676607204 | -122.399736313291 | (37.7774866766072, -122.399736313291) | |
| 185363 | 185363 | 136204 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3898 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 5996215.93738 | 2115261.69586 | 37.7878874538988 | -122.45691400297399 | (37.7878874538988, -122.456914002974) | |||
| 185326 | 185326 | 49094 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 140 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2003 12:00:00 AM | 6 | Permit Number 46242 | 5993992.46837 | 2114616.14539 | 37.785987019084295 | -122.464559844416 | (37.7859870190843, -122.464559844416) | ||
| 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) | |||
| 185144 | 185144 | 239317 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1100 Hampshire St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 6ft | 6010240.72628 | 2102744.15996 | 37.7543125548829 | -122.407507713025 | (37.7543125548829, -122.407507713025) | |||
| 184861 | 184861 | 70592 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 312 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/06/1994 12:00:00 AM | 4 | 6004234.1327 | 2091472.6068400003 | 37.7230253908821 | -122.42747709790001 | (37.7230253908821, -122.4274770979) | ||
| 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) | |||
| 184376 | 184376 | 239329 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3215 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6009024.67189 | 2099961.90595 | 37.746604963844206 | -122.411516596636 | (37.7466049638442, -122.411516596636) | |||
| 184348 | 184348 | 213962 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 621 Holloway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5994792.34345 | 2091215.55668 | 37.7217810439445 | -122.460096613778 | (37.7217810439445, -122.460096613778) | |||
| 183463 | 183463 | 239287 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 719 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009892.49651 | 2104739.8354599997 | 37.7597727338352 | -122.40885277595899 | (37.7597727338352, -122.408852775959) | |||
| 183412 | 183412 | 197149 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 58 Whitney Young Cir | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6017152.11734 | 2094978.18509 | 37.7333732007951 | -122.38306566055401 | (37.7333732007951, -122.383065660554) | |||
| 183206 | 183206 | 197098 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 373 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6014370.26401 | 2105387.58342 | 37.761801106151204 | -122.393411595362 | (37.7618011061512, -122.393411595362) | |||
| 183076 | 183076 | 179287 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 97 Still St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6002285.23223 | 2094449.03286 | 37.7310875612396 | -122.43442674840799 | (37.7310875612396, -122.434426748408) | |||
| 183028 | 183028 | 197134 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 220 Newhall St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6016745.12895 | 2098337.97655 | 37.7425760145669 | -122.38470670927299 | (37.7425760145669, -122.384706709273) | |||
| 182814 | 182814 | 240185 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 42 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6001017.63107 | 2106166.1197099998 | 37.76318785445999 | -122.439648742804 | (37.76318785446, -122.439648742804) | |||
| 182525 | 182525 | 179291 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 65 Badger St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6002393.53271 | 2094418.30005 | 37.731009322903 | -122.434050139316 | (37.731009322903, -122.434050139316) | |||
| 182445 | 182445 | 136196 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2102 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002856.44865 | 2118905.6170900003 | 37.7982718041617 | -122.43419968126999 | (37.7982718041617, -122.43419968127) | |||
| 182440 | 182440 | 239295 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 942 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 6ft | 6009930.36914 | 2103706.31975 | 37.7569370536161 | -122.408648882561 | (37.7569370536161, -122.408648882561) | |||
| 181973 | 181973 | 197091 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1098 Pennsylvania Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 5ft | 6014475.63706 | 2102134.7648099996 | 37.7528754202862 | -122.39281957348601 | (37.7528754202862, -122.392819573486) | |||
| 181921 | 181921 | 240165 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 955 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 5998776.9827 | 2106633.40006 | 37.7643431037773 | -122.447432001889 | (37.7643431037773, -122.447432001889) | |||
| 181712 | 181712 | 138466 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1961 SUTTER ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6003221.6099 | 2114462.9101 | 37.7860939869982 | -122.43261860104299 | (37.7860939869982, -122.432618601043) | |||
| 181259 | 181259 | 179308 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 223 Edinburgh St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 3ft | 6003895.65676 | 2092365.8261400003 | 37.7254588232518 | -122.428710784278 | (37.7254588232518, -122.428710784278) | |||
| 181135 | 181135 | 197093 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1098 Pennsylvania Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6014477.98301 | 2102105.11898 | 37.7527941494528 | -122.392809386851 | (37.7527941494528, -122.392809386851) | |||
| 181131 | 181131 | 179318 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2 Merrill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009445.77773 | 2094973.4037900001 | 37.7329312316932 | -122.409708400835 | (37.7329312316932, -122.409708400835) | |||
| 181096 | 181096 | 182748 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1789 30th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5986861.6929 | 2103148.806 | 37.754087259353206 | -122.488386999785 | (37.7540872593532, -122.488386999785) | |||
| 181078 | 181078 | 239315 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1024 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6010214.49456 | 2103222.56761 | 37.7556246873555 | -122.40763215850599 | (37.7556246873555, -122.407632158506) | |||
| 181073 | 181073 | 78383 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1490 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/14/2004 12:00:00 AM | 5 | 6015869.5519 | 2094203.8416 | 37.7311760546893 | -122.387445886397 | (37.7311760546893, -122.387445886397) | ||
| 180761 | 180761 | 200726 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1660 Quesada Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6014855.123 | 2094958.2582 | 37.7331912931628 | -122.39100568396299 | (37.7331912931628, -122.391005683963) | |||
| 180641 | 180641 | 239306 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 130 San Carlos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6006646.904180001 | 2105336.48484 | 37.7612286633914 | -122.420120046409 | (37.7612286633914, -122.420120046409) | |||
| 180496 | 180496 | 197133 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 201 Newhall St | 5 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6016812.9341400005 | 2098272.11729 | 37.742398928158295 | -122.384467670355 | (37.7423989281583, -122.384467670355) | |||
| 180272 | 180272 | 179333 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 21 Drake St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6001438.26403 | 2086921.6489 | 37.710370944937104 | -122.436816206603 | (37.7103709449371, -122.436816206603) | |||
| 180134 | 180134 | 240152 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1520 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5998350.81999 | 2105225.15153 | 37.7604520448521 | -122.448804531031 | (37.7604520448521, -122.448804531031) | |||
| 180097 | 180097 | 239245 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1300 Hampshire St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6010304.47179 | 2101582.19148 | 37.75112561476529 | -122.40720536003799 | (37.7511256147653, -122.407205360038) | |||
| 180069 | 180069 | 136226 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1570 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6004327.39771 | 2120155.21272 | 37.8017862476969 | -122.429198904827 | (37.8017862476969, -122.429198904827) | |||
| 180005 | 180005 | 72279 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 767 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/1996 12:00:00 AM | 6 | 5983194.45467 | 2110583.80622 | 37.7742869998631 | -122.501619002427 | (37.7742869998631, -122.501619002427) | ||
| 179989 | 179989 | 136255 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1422 Vallejo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 2ft | 6006750.35587 | 2118407.27559 | 37.797123718848 | -122.42069017253999 | (37.797123718848, -122.42069017254) | |||
| 179960 | 179960 | 32237 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1624 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/22/1995 12:00:00 AM | 2 | Permit Number 35552 | 6008752.85375 | 2099258.72016 | 37.744658920879004 | -122.412406822926 | (37.744658920879, -122.412406822926) | |
| 179770 | 179770 | 71586 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 121 Goethe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 9 | 5994945.16185 | 2086428.98532 | 37.7086470380903 | -122.459221923276 | (37.7086470380903, -122.459221923276) | ||
| 179110 | 179110 | 240139 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 401 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6003806.32516 | 2100095.51377 | 37.7466777333931 | -122.429570613489 | (37.7466777333931, -122.429570613489) | |||
| 179044 | 179044 | 248303 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3165 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6006799.1058 | 2099943.7824 | 37.7464301139591 | -122.419211100336 | (37.7464301139591, -122.419211100336) | |||
| 179041 | 179041 | 240205 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 148 Moffitt St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6002599.9876 | 2096899.86345 | 37.737834842704004 | -122.433513665818 | (37.737834842704, -122.433513665818) | |||
| 179013 | 179013 | 179324 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 100 Merrill St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009528.37304 | 2094747.8855599998 | 37.7323166349901 | -122.409406936389 | (37.7323166349901, -122.409406936389) | |||
| 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) | |||
| 178850 | 178850 | 239323 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1682 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009284.21433 | 2099547.02413 | 37.7454803445555 | -122.41058982998399 | (37.7454803445555, -122.410589829984) | |||
| 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) | |||
| 178735 | 178735 | 240140 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 401 27th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6003846.00586 | 2100095.72169 | 37.7466805509841 | -122.429433416522 | (37.7466805509841, -122.429433416522) | |||
| 178725 | 178725 | 197106 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1468 25th St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 5ft | 6014394.04215 | 2102037.78794 | 37.752604610114005 | -122.393094961165 | (37.752604610114, -122.393094961165) | |||
| 178696 | 178696 | 136211 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 101 Spruce St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 5997026.34564 | 2115964.00812 | 37.7898623183414 | -122.454160900321 | (37.7898623183414, -122.454160900321) | |||
| 178631 | 178631 | 136215 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3631 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5996865.8825900005 | 2115961.8994 | 37.7898473257367 | -122.454715932203 | (37.7898473257367, -122.454715932203) | |||
| 178628 | 178628 | 200040 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1598 Lane St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6015299.5887 | 2094715.0337 | 37.732548101110794 | -122.389452052823 | (37.7325481011108, -122.389452052823) | |||
| 178581 | 178581 | 32236 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1599 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/22/1995 12:00:00 AM | 5 | Permit Number 35551 | 6008785.95411 | 2099394.95601 | 37.745034851884796 | -122.41230199523599 | (37.7450348518848, -122.412301995236) | |
| 178520 | 178520 | 197119 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 309 Mississippi St | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 6014067.1485 | 2105627.53504 | 37.7624431150761 | -122.394476761399 | (37.7624431150761, -122.394476761399) | |||
| 178466 | 178466 | 197104 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1468 25th St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6014428.85484 | 2102039.8538900004 | 37.752612216591004 | -122.392974716426 | (37.752612216591, -122.392974716426) | |||
| 178446 | 178446 | 179313 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 100 Yale St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6006918.398519999 | 2093488.03593 | 37.728710780776 | -122.418340943684 | (37.728710780776, -122.418340943684) | |||
| 178027 | 178027 | 239339 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 86 Peralta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6010357.16524 | 2100318.41183 | 37.7476585025396 | -122.406934075969 | (37.7476585025396, -122.406934075969) | |||
| 177889 | 177889 | 239322 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1682 Alabama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6009287.32125 | 2099523.77754 | 37.7454166887246 | -122.410577445415 | (37.7454166887246, -122.410577445415) | |||
| 177713 | 177713 | 138287 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2019 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6002887.6089 | 2115262.2788 | 37.7882699032996 | -122.43383131022199 | (37.7882699032996, -122.433831310222) | |||
| 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) | |||
| 177532 | 177532 | 239275 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 313 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6007408.18179 | 2107851.42826 | 37.7681769748154 | -122.41766536398701 | (37.7681769748154, -122.417665363987) | |||
| 177196 | 177196 | 213954 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 360 Faxon Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5994772.0848 | 2091005.96515 | 37.721204390545104 | -122.460151465241 | (37.7212043905451, -122.460151465241) | |||
| 177162 | 177162 | 33638 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 434 Linden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/03/1996 12:00:00 AM | 7 | Permit Number 37733 | 6005306.206 | 2110803.5701 | 37.7761643373284 | -122.42514597541701 | (37.7761643373284, -122.425145975417) | |
| 177088 | 177088 | 91041 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2998 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/10/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50399 | 6006464.746230001 | 2121395.99646 | 37.805313886080604 | -122.421890864574 | (37.8053138860806, -122.421890864574) | |
| 176850 | 176850 | 239265 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 153 Julian Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 1ft | 6006453.3259 | 2106969.77306 | 37.7657023804906 | -122.420905516077 | (37.7657023804906, -122.420905516077) | |||
| 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) | |||
| 176735 | 176735 | 197125 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 31 Apparel Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 8ft | 6011537.38847 | 2097577.661 | 37.7401989607078 | -122.402660197209 | (37.7401989607078, -122.402660197209) | |||
| 176731 | 176731 | 197101 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 37 Arkansas St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 3ft | 6012884.97292 | 2106850.1929599997 | 37.7657344728051 | -122.398651302829 | (37.7657344728051, -122.398651302829) | |||
| 176550 | 176550 | 120252 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 160 24th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 6ft | 5988365.81555 | 2114876.44647 | 37.7863757629455 | -122.484045388081 | (37.7863757629455, -122.484045388081) | |||
| 176449 | 176449 | 197115 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1231 Rhode Island St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6011991.85547 | 2102642.48446 | 37.7541312380906 | -122.40144468342301 | (37.7541312380906, -122.401444683423) | |||
| 176231 | 176231 | 43755 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 264 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2000 12:00:00 AM | 3 | Permit Number 43391 | 5990896.100380001 | 2113625.86147 | 37.783088990728004 | -122.47520000357201 | (37.783088990728, -122.475200003572) | |
| 176183 | 176183 | 239307 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3617 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6005473.39652 | 2104866.5345900003 | 37.759872100843296 | -122.424145292271 | (37.7598721008433, -122.424145292271) | |||
| 176131 | 176131 | 65788 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 201 Laurel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/1990 12:00:00 AM | 7 | Permit Number 28756 | 5998021.12629 | 2115778.19726 | 37.7894091238674 | -122.450705664532 | (37.7894091238674, -122.450705664532) |
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");