Data source: data.sfgov.org
This data as json, CSV (advanced)
| 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) | ||
| 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) | |
| 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) | ||
| 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) | |
| 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) | ||
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | ||
| 175706 | 175706 | 64667 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 155 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/1989 12:00:00 AM | 7 | Permit Number 27077 | 5988959.0752 | 2114316.0403299998 | 37.784871567471704 | -122.48195181759701 | (37.7848715674717, -122.481951817597) | |
| 175241 | 175241 | 35263 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2314 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2009 12:00:00 AM | 6 | 3x3 | Permit Number 52291 | 6006344.46456 | 2118787.78744 | 37.7981456238821 | -122.422121705266 | (37.7981456238821, -122.422121705266) | |
| 174554 | 174554 | 85486 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 380 Bacon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/05/2007 12:00:00 AM | 5 | Permit Number 49676 | 6010415.33133 | 2092799.63405 | 37.7270168024731 | -122.406203288666 | (37.7270168024731, -122.406203288666) | ||
| 174429 | 174429 | 35739 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 378 Hale St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/15/1998 12:00:00 AM | 9 | Permit Number 39013 | 6008634.39829 | 2094282.55173 | 37.7309887985962 | -122.41246474286999 | (37.7309887985962, -122.41246474287) | |
| 174380 | 174380 | 56156 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 471 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/1973 12:00:00 AM | 12 | Permit Number 12264 | 5990899.19855 | 2112188.99411 | 37.779143929860204 | -122.475084359841 | (37.7791439298602, -122.475084359841) | ||
| 173914 | 173914 | 52631 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1725@ POLK Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/2006 12:00:00 AM | 3 | Permit Number 48716 | 6006396.26388 | 2116959.2497900003 | 37.7931278403295 | -122.421812512039 | (37.7931278403295, -122.421812512039) | ||
| 173304 | 173304 | 65517 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2028 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/09/1990 12:00:00 AM | 9 | Permit Number 28403 | 6003226.452219999 | 2118960.15524 | 37.7984425449573 | -122.43292325730499 | (37.7984425449573, -122.432923257305) | ||
| 172968 | 172968 | 39937 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 327 Arleta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 7 | 3x3 | Permit Number 50713 | 6009355.370709999 | 2088298.86848 | 37.7145992918994 | -122.40955005091499 | (37.7145992918994, -122.409550050915) | |
| 171356 | 171356 | 51529 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 846 Arkansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2005 12:00:00 AM | 5 | Permit Number 47831 | 6013038.0341300005 | 2103130.6392200002 | 37.7555299221754 | -122.39786095703501 | (37.7555299221754, -122.397860957035) | ||
| 171342 | 171342 | 69369 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3715 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/18/1994 12:00:00 AM | 7 | Permit Number 33463 | 6002534.674819999 | 2121358.09542 | 37.804987398007704 | -122.43548864898099 | (37.8049873980077, -122.435488648981) | |
| 170669 | 170669 | 53032 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 35GOLDENGATE Temescal Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/06/2006 12:00:00 AM | 2 | 3x3 | Permit Number 49011 | 5997444.5897 | 2111409.0141 | 37.7773794808628 | -122.45238499119301 | (37.7773794808628, -122.452384991193) | |
| 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) | |||
| 169460 | 169460 | 56218 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 475 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/03/1973 12:00:00 AM | 9 | Permit Number 12339 | 5990899.771790001 | 2112161.89837 | 37.779069565646 | -122.475080398267 | (37.779069565646, -122.475080398267) | ||
| 169415 | 169415 | 41926 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 444 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | 7 | Permit Number 42286 | 5994688.62474 | 2112489.12651 | 37.7801869053866 | -122.46199705059601 | (37.7801869053866, -122.461997050596) | |
| 169277 | 169277 | 30566 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2245 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1995 12:00:00 AM | 9 | Permit Number 34543 | 6002231.0779 | 2118426.8867900004 | 37.796921821948 | -122.436329368507 | (37.796921821948, -122.436329368507) | ||
| 166963 | 166963 | 69319 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1490 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/23/1994 12:00:00 AM | 8 | Permit Number 33400 | 6004756.29564 | 2120212.83745 | 37.801968740827206 | -122.42771882665899 | (37.8019687408272, -122.427718826659) | ||
| 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) | |
| 165345 | 165345 | 52196 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1205 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/2013 12:00:00 AM | 2 | Permit Number 770878 | 6007126.92706 | 2119460.55943 | 37.800036988073295 | -122.419461903656 | (37.8000369880733, -122.419461903656) | ||
| 165260 | 165260 | 54444 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 626 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/1972 12:00:00 AM | 15 | Permit Number 10222 | 6014089.82372 | 2104201.41345 | 37.7585285559536 | -122.394298481614 | (37.7585285559536, -122.394298481614) | ||
| 164073 | 164073 | 97605 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 445 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/27/2011 12:00:00 AM | 2 | 3x3 | Permit Number 768351 | 6005728.0342 | 2111001.8882 | 37.7767326912067 | -122.42370085981301 | (37.7767326912067, -122.423700859813) | |
| 164016 | 164016 | 42171 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 525 05th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/2000 12:00:00 AM | 8 | Permit Number 42460 | 6012613.23479 | 2111182.9254900003 | 37.7776160332845 | -122.399895470812 | (37.7776160332845, -122.399895470812) | ||
| 162268 | 162268 | 56219 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 479 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/03/1973 12:00:00 AM | 6 | Permit Number 12340 | 5990900.9414099995 | 2112135.93012 | 37.7789983317715 | -122.475074455932 | (37.7789983317715, -122.475074455932) | ||
| 162161 | 162161 | 91042 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2998 Larkin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/10/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50399 | 6006462.588380001 | 2121409.81945 | 37.8053517187772 | -122.421899314626 | (37.8053517187772, -122.421899314626) | |
| 162145 | 162145 | 60407 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1430 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/22/1983 12:00:00 AM | 6 | Permit Number 19988 | 6016156.6712 | 2093985.1354 | 37.7305914290757 | -122.38643801167801 | (37.7305914290757, -122.386438011678) | |
| 161956 | 161956 | 65112 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 367 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/1989 12:00:00 AM | 9 | Permit Number 27081 | 5989323.93516 | 2112879.29731 | 37.78094788727989 | -122.48058432391001 | (37.7809478872799, -122.48058432391) | |
| 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) | ||
| 161198 | 161198 | 32200 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1548 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/22/1995 12:00:00 AM | 9 | Permit Number 35525 | 6009311.87257 | 2100296.5048 | 37.7475398037183 | -122.410547106778 | (37.7475398037183, -122.410547106778) | |
| 161197 | 161197 | 48810 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1082Street Pennsylvania Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2002 12:00:00 AM | 5 | Permit Number 46042 | 6014469.89088 | 2102291.4479400003 | 37.753305319601495 | -122.392850405821 | (37.7533053196015, -122.392850405821) | ||
| 160970 | 160970 | 59713 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1155 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/18/1981 12:00:00 AM | 7 | 3x3 | Permit Number 19144 | 6008363.54406 | 2115876.33125 | 37.790265156173504 | -122.414928901463 | (37.7902651561735, -122.414928901463) | |
| 160870 | 160870 | 32575 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1557 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/22/1996 12:00:00 AM | 8 | Permit Number 37049 | 6003995.39147 | 2099192.64268 | 37.7442093614769 | -122.428852485076 | (37.7442093614769, -122.428852485076) | ||
| 160765 | 160765 | 68930 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 768 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 5 | Permit Number 32914 | 5993218.422259999 | 2110247.19429 | 37.7739464110699 | -122.466920079783 | (37.7739464110699, -122.466920079783) | |
| 159656 | 159656 | 42168 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 525 05th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/2000 12:00:00 AM | 9 | Permit Number 42460 | 6012645.95751 | 2111148.5484599997 | 37.7775234660795 | -122.399779856677 | (37.7775234660795, -122.399779856677) | ||
| 158817 | 158817 | 61793 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2104 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1985 12:00:00 AM | 14 | Permit Number 21816 | 6012153.01638 | 2102841.4950099997 | 37.7546866683749 | -122.40090132743201 | (37.7546866683749, -122.400901327432) | |
| 158714 | 158714 | 35136 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 714 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/1998 12:00:00 AM | 13 | Permit Number 38666 | 6002360.3768 | 2089504.48193 | 37.7175152006551 | -122.43381368236 | (37.7175152006551, -122.43381368236) | |
| 158473 | 158473 | 34253 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 945 Bay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1998 12:00:00 AM | 7 | Permit Number 38731 | 6006242.74242 | 2121059.25353 | 37.8043767538414 | -122.42263519386199 | (37.8043767538414, -122.422635193862) | |
| 157386 | 157386 | 49548 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2434@ TARAVAL 21st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2003 12:00:00 AM | 1 | Permit Number 46439 | 5989857.9655 | 2098790.1552 | 37.742293916006 | -122.47770669165199 | (37.742293916006, -122.477706691652) | ||
| 157228 | 157228 | 39955 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 273 Teddy Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/1999 12:00:00 AM | 9 | Permit Number 41217 | 6009804.77414 | 2088411.3721599998 | 37.7149333756547 | -122.408004652316 | (37.7149333756547, -122.408004652316) | |
| 157108 | 157108 | 101338 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 600 Chestnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1993 12:00:00 AM | 3 | Permit Number 32655 | 6008893.4466 | 2120790.6495 | 37.80378842303661 | -122.413443168222 | (37.8037884230366, -122.413443168222) | ||
| 156985 | 156985 | 65109 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 145 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/2000 12:00:00 AM | 5 | Permit Number 27078 | 5988958.234730001 | 2114388.99376 | 37.7850718280894 | -122.481960071321 | (37.7850718280894, -122.481960071321) | |
| 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) | |
| 155527 | 155527 | 56681 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2245 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 6002229.691000001 | 2118425.2879 | 37.79691735301029 | -122.436334053014 | (37.7969173530103, -122.436334053014) | ||||
| 155477 | 155477 | 65116 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 130 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/1989 12:00:00 AM | 3 | Permit Number 27086 | 5989313.29751 | 2114460.89745 | 37.7852898986689 | -122.480736945877 | (37.7852898986689, -122.480736945877) | |
| 151838 | 151838 | 62004 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1468 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/18/1994 12:00:00 AM | 8 | Permit Number 33452 | 6004296.2409 | 2120497.97462 | 37.8027256192439 | -122.42933117801701 | (37.8027256192439, -122.429331178017) | |
| 151617 | 151617 | 48799 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1082Street Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2002 12:00:00 AM | 5 | Permit Number 46042 | 6014465.83632 | 2102364.69447 | 37.753506213741396 | -122.392869551502 | (37.7535062137414, -122.392869551502) | ||
| 151589 | 151589 | 48815 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1082Street Pennsylvania Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2002 12:00:00 AM | 5 | Permit Number 46042 | 6014467.97393 | 2102326.82142 | 37.7534023411579 | -122.392859509671 | (37.7534023411579, -122.392859509671) | ||
| 151544 | 151544 | 61576 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2019 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/25/1984 12:00:00 AM | 7 | Permit Number 21538 | 6012377.336080001 | 2102802.45934 | 37.754591994948 | -122.400122823023 | (37.754591994948, -122.400122823023) | |
| 150866 | 150866 | 48811 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1082Street Pennsylvania Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2002 12:00:00 AM | 7 | Permit Number 46042 | 6014468.770930001 | 2102318.37211 | 37.7533791854235 | -122.392856162375 | (37.7533791854235, -122.392856162375) | ||
| 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) | |
| 150627 | 150627 | 32284 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 31 Temescal Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52573 | 5997438.818 | 2111434.025 | 37.77744782360929 | -122.45240676257099 | (37.7774478236093, -122.452406762571) |
| 150579 | 150579 | 61560 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2117 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/25/1984 12:00:00 AM | 9 | Permit Number 21520 | 6012109.3133 | 2102790.6962200003 | 37.7545447481545 | -122.401048896306 | (37.7545447481545, -122.401048896306) | |
| 149670 | 149670 | 30617 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1625 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | 5 | Permit Number 34579 | 6008161.857999999 | 2108672.7086 | 37.7704744001626 | -122.41511660718399 | (37.7704744001626, -122.415116607184) | |
| 149613 | 149613 | 69318 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1466 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1994 12:00:00 AM | 12 | Permit Number 33399 | 6004829.35126 | 2120222.0032 | 37.801998039833606 | -122.427466672957 | (37.8019980398336, -122.427466672957) | |
| 149179 | 149179 | 85485 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 380 Bacon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/05/2007 12:00:00 AM | 5 | Permit Number 49676 | 6010430.57281 | 2092804.2489200002 | 37.72703032647411 | -122.40615092385299 | (37.7270303264741, -122.406150923853) | ||
| 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) | |
| 148823 | 148823 | 99598 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3001 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Permit Number 17057 | 6002874.08515 | 2118929.42484 | 37.7983381750246 | -122.434140356598 | (37.7983381750246, -122.434140356598) | |||
| 148769 | 148769 | 50669 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3130 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/2004 12:00:00 AM | 9 | Permit Number 47247 | 6002419.67533 | 2119034.32922 | 37.798600414646295 | -122.435720259485 | (37.7986004146463, -122.435720259485) | ||
| 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) | ||
| 147739 | 147739 | 42170 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 525 05th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/2000 12:00:00 AM | 12 | Permit Number 42460 | 6012634.74531 | 2111162.8232 | 37.7775620361946 | -122.399819646269 | (37.7775620361946, -122.399819646269) | ||
| 147265 | 147265 | 48809 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1082Street Pennsylvania Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2002 12:00:00 AM | 3 | Permit Number 46042 | 6014468.625469999 | 2102279.9042599997 | 37.753273552832205 | -122.392853974356 | (37.7532735528322, -122.392853974356) | ||
| 146854 | 146854 | 68934 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 691 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 6 | Permit Number 32918 | 5992842.27322 | 2110813.31617 | 37.77547911209629 | -122.46826242331001 | (37.7754791120963, -122.46826242331) | |
| 146830 | 146830 | 30616 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1621 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | 7 | Permit Number 34577 | 6008176.3922 | 2108702.7792 | 37.7705577837388 | -122.415068461945 | (37.7705577837388, -122.415068461945) | |
| 146318 | 146318 | 8938 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 4649X Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 5992558.61151 | 2112698.79101 | 37.7806397269512 | -122.469380940837 | (37.7806397269512, -122.469380940837) | |||
| 146304 | 146304 | 60120 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 231 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/1982 12:00:00 AM | Permit Number 19647 | 6004727.57850512 | 2096979.14667455 | 37.7381730200844 | -122.426163187426 | (37.7381730200844, -122.426163187426) | ||
| 146269 | 146269 | 24686 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 6599X Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 03/15/2006 12:00:00 AM | 3 | 3X3 | 5986563.55545 | 2112507.59289 | 37.77976647962429 | -122.49010635929599 | (37.7797664796243, -122.490106359296) | ||
| 146104 | 146104 | 100411 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 201x Linden St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/16/2012 12:00:00 AM | Permit Number 767727 | 6006435.0 | 2110776.0 | 37.7761523386864 | -122.421239206856 | (37.7761523386864, -122.421239206856) | |||
| 145984 | 145984 | 48987 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 466 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/06/2002 12:00:00 AM | Permit Number 46174 | 6003488.63823047 | 2100126.88002521 | 37.7467458648752 | -122.43067137990101 | (37.7467458648752, -122.430671379901) | ||
| 145886 | 145886 | 93824 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 178 Bluxome St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2010 12:00:00 AM | 3x3 | Permit Number 53343 | 6012557.4 | 2110038.2 | 37.7744697656056 | -122.40000821426001 | (37.7744697656056, -122.40000821426) | ||
| 145798 | 145798 | 60620 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 221 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/12/1983 12:00:00 AM | Permit Number 20245 | 6004788.53237408 | 2097060.23831103 | 37.7383991243874 | -122.425958210014 | (37.7383991243874, -122.425958210014) | ||
| 145487 | 145487 | 31193 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 218 Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/21/1995 12:00:00 AM | Permit Number 34886 | 6011113.20919467 | 2107342.89093281 | 37.766988438672705 | -122.40481417533 | (37.7669884386727, -122.40481417533) | |||
| 145425 | 145425 | 88491 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1600 Quesada Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51434 | 6015245.7 | 2094684.2 | 37.732460450023495 | -122.38963620788401 | (37.7324604500235, -122.389636207884) | ||
| 145295 | 145295 | 121096 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1691 McAllister St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6001097.0 | 2111345.0 | 37.7774122850927 | -122.439745549 | (37.7774122850927, -122.439745549) | |||
| 145278 | 145278 | 95794 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1330 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/2011 12:00:00 AM | 3x3 | Permit Number 767537 | 6010317.0 | 2101466.0 | 37.750807279737295 | -122.407153846535 | (37.7508072797373, -122.407153846535) | |
| 145149 | 145149 | 60625 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 315 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/12/1983 12:00:00 AM | Permit Number 20250 | 6004228.6895082 | 2096570.52426476 | 37.7370228251858 | -122.427858989442 | (37.7370228251858, -122.427858989442) | ||
| 145070 | 145070 | 55270 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 809 Pacheco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | Permit Number 32396 | 5992382.44974981 | 2102648.13821757 | 37.7530331280839 | -122.46925861560499 | (37.7530331280839, -122.469258615605) | ||
| 144943 | 144943 | 93830 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 178 Bluxome St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2010 12:00:00 AM | 3x3 | Permit Number 53343 | 6012557.4 | 2110038.2 | 37.7744697656056 | -122.40000821426001 | (37.7744697656056, -122.40000821426) | ||
| 144864 | 144864 | 102763 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 50X Hill Point Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/26/2013 12:00:00 AM | 3x3 | Permit Number 769605 | 5996378.1 | 2106680.6 | 37.7643353262738 | -122.45573242834699 | (37.7643353262738, -122.455732428347) | |
| 144769 | 144769 | 689 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1299X Potrero Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 3X3 | 6010664.761195901 | 2101498.8811325002 | 37.7509170198962 | -122.40595356703501 | (37.7509170198962, -122.405953567035) | |||
| 144565 | 144565 | 63870 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 419 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/10/1993 12:00:00 AM | Permit Number 32273 | 6003609.32170221 | 2103297.27758201 | 37.7554578688081 | -122.43048024454599 | (37.7554578688081, -122.430480244546) | ||
| 144246 | 144246 | 63532 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 628 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/10/1987 12:00:00 AM | Permit Number 24145 | 6007867.26222803 | 2104262.24708917 | 37.7583477377727 | -122.41582326523 | (37.7583477377727, -122.41582326523) | ||
| 144155 | 144155 | 69099 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1666 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/10/1994 12:00:00 AM | Permit Number 33114 | 5992500.81143839 | 2104116.17668169 | 37.7570708187185 | -122.46895612748199 | (37.7570708187185, -122.468956127482) | ||
| 144146 | 144146 | 63300 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3258 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1987 12:00:00 AM | Permit Number 23866 | 6008993.47564343 | 2099710.49085964 | 37.7459128837168 | -122.411606709796 | (37.7459128837168, -122.411606709796) | ||
| 144104 | 144104 | 34354 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 48 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38110 | 6004856.72316011 | 2098008.93815891 | 37.7410078927245 | -122.425789947549 | (37.7410078927245, -122.425789947549) | ||
| 143528 | 143528 | 96049 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1653 Alabama St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767679 | 6009324.0 | 2099841.0 | 37.7462897680072 | -122.410473011409 | (37.7462897680072, -122.410473011409) | |
| 143395 | 143395 | 63706 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 634 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1987 12:00:00 AM | 5x4 | Permit Number 24367 | 6007869.12350013 | 2104228.71879898 | 37.7582557814133 | -122.415814454004 | (37.7582557814133, -122.415814454004) | |
| 143216 | 143216 | 90389 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 68 12th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/21/2008 12:00:00 AM | 3 | 3x3 | 6006999.109217 | 2109777.167755 | 37.773441570749895 | -122.419216927652 | (37.7734415707499, -122.419216927652) | ||
| 143152 | 143152 | 109439 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 800x STEINER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/18/2015 12:00:00 AM | 3 | 3.5x6.5 | 6003118.0 | 2111045.0 | 37.7767033866571 | -122.432732815988 | (37.7767033866571, -122.432732815988) | ||
| 142894 | 142894 | 60126 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 357 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/1982 12:00:00 AM | Permit Number 19654 | 6004078.30552924 | 2096452.47745436 | 37.7366901868966 | -122.42837052323799 | (37.7366901868966, -122.428370523238) | ||
| 142790 | 142790 | 93823 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 178 Bluxome St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2010 12:00:00 AM | 3x3 | Permit Number 53343 | 6012557.4 | 2110038.2 | 37.7744697656056 | -122.40000821426001 | (37.7744697656056, -122.40000821426) | ||
| 142512 | 142512 | 89297 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 850 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/24/2008 12:00:00 AM | 3x3 | Permit Number 51901 | 6001012.0 | 2111585.0 | 37.778066425770895 | -122.440056804822 | (37.7780664257709, -122.440056804822) |
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");