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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 80922 | 80922 | 110524 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 995X Grove St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/2015 12:00:00 AM | 3 | Permit Number 775198 | 6003269.726980001 | 2111024.20368 | 37.7766548889563 | -122.43220646236401 | (37.7766548889563, -122.432206462364) | ||
| 138868 | 138868 | 108376 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 995X Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/2015 12:00:00 AM | 3 | Permit Number 775198 | 6003269.726980001 | 2111024.20368 | 37.7766548889563 | -122.43220646236401 | (37.7766548889563, -122.432206462364) | ||
| 103749 | 103749 | 69409 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 990 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1994 12:00:00 AM | Permit Number 33514 | 6001528.72905075 | 2086815.30428152 | 37.710084087104896 | -122.43649593455099 | (37.7100840871049, -122.436495934551) | ||
| 54424 | 54424 | 197151 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 99 Whitney Young Cir | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6016637.91847 | 2095129.63156 | 37.7337606161438 | -122.384853953468 | (37.7337606161438, -122.384853953468) | |||
| 8100 | 8100 | 14763 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 983 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6004471.7203 | 2111860.4178 | 37.7790190047533 | -122.42810802032601 | (37.7790190047533, -122.428108020326) | |||
| 81949 | 81949 | 59899 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 981 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1993 12:00:00 AM | Permit Number 29266 | 6009986.52664303 | 2103503.60894166 | 37.7563836002421 | -122.408440369707 | (37.7563836002421, -122.408440369707) | ||
| 152159 | 152159 | 239299 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 981 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6009975.32476 | 2103526.84529 | 37.7564467747236 | -122.408480748912 | (37.7564467747236, -122.408480748912) | |||
| 101178 | 101178 | 59895 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 980 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/21/1981 12:00:00 AM | Permit Number 19362 | 6009934.60548185 | 2103500.74659623 | 37.756372833099 | -122.408619730116 | (37.756372833099, -122.408619730116) | ||
| 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) | |||
| 150546 | 150546 | 213943 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 98 Westwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5995156.25779 | 2093258.2613099997 | 37.727410745106 | -122.45898649333799 | (37.727410745106, -122.458986493338) | |||
| 114982 | 114982 | 90392 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 98 12th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/08/2014 12:00:00 AM | 3 | 3x3 | 6007146.175112001 | 2109626.370927 | 37.77303579982821 | -122.418697508419 | (37.7730357998282, -122.418697508419) | ||
| 123502 | 123502 | 90393 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 98 12th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/31/2016 12:00:00 AM | 3 | 3x3 | 6007146.175112001 | 2109626.370927 | 37.77303579982821 | -122.418697508419 | (37.7730357998282, -122.418697508419) | ||
| 53227 | 53227 | 179288 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 97 Still St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6002296.73031 | 2094454.79419 | 37.7311040332072 | -122.434387409368 | (37.7311040332072, -122.434387409368) | |||
| 137886 | 137886 | 179289 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 97 Still St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6002308.41253 | 2094461.38463 | 37.7311227921608 | -122.43434749296101 | (37.7311227921608, -122.434347492961) | |||
| 157489 | 157489 | 179290 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 97 Still St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6002318.3672 | 2094465.3447 | 37.7311342306478 | -122.43431336098601 | (37.7311342306478, -122.434313360986) | |||
| 174223 | 174223 | 179286 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 97 Still St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6002271.23579 | 2094443.82332 | 37.7310724625286 | -122.43447476411801 | (37.7310724625286, -122.434474764118) | |||
| 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) | |||
| 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) | |
| 98467 | 98467 | 24177 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 95X Whitney Young Cir | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 4 | 3X3 | 6016412.1769872 | 2096105.6107163997 | 37.736427970914 | -122.38570241578998 | (37.736427970914, -122.38570241579) | ||
| 106905 | 106905 | 24171 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 95X Whitney Young Cir | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3x3 | 6016412.1769872 | 2096105.6107163997 | 37.736427970914 | -122.38570241578998 | (37.736427970914, -122.38570241579) | ||
| 90171 | 90171 | 59898 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 956 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/21/1981 12:00:00 AM | 9x6 | Permit Number 19365. I marked for a basin expansion. 9'x 6'. SB | 6009927.21867861 | 2103634.73860088 | 37.756740331390205 | -122.40865472852501 | (37.7567403313902, -122.408654728525) | |
| 98703 | 98703 | 88464 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 955X Newhall St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/11/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51410 | 6015306.946426 | 2096847.395831 | 37.7384035424873 | -122.389575486471 | (37.7384035424873, -122.389575486471) | |
| 116084 | 116084 | 88466 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 955X Newhall St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51410 | 6015306.946426 | 2096847.395831 | 37.7384035424873 | -122.389575486471 | (37.7384035424873, -122.389575486471) |
| 63717 | 63717 | 240167 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 955 Clayton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 5998784.85204 | 2106603.32437 | 37.764260973182395 | -122.44740261924 | (37.7642609731824, -122.44740261924) | |||
| 67554 | 67554 | 240166 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 955 Clayton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 5998780.1300099995 | 2106624.27042 | 37.7643182159335 | -122.44742045909099 | (37.7643182159335, -122.447420459091) | |||
| 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) | |||
| 173465 | 173465 | 240164 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 953 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 5998770.20666 | 2106657.712 | 37.764409471033 | -122.447457188295 | (37.764409471033, -122.447457188295) | |||
| 123180 | 123180 | 67166 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 95 Putnam St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1992 12:00:00 AM | Permit Number 30606 | 6009175.78663264 | 2096920.50088171 | 37.738262406618 | -122.410779296402 | (37.738262406618, -122.410779296402) | ||
| 36489 | 36489 | 213993 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 95 Martha Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6000354.21561 | 2095866.7572 | 37.7348705009689 | -122.441204268679 | (37.7348705009689, -122.441204268679) | |||
| 52609 | 52609 | 34250 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 945 Bay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1998 12:00:00 AM | 5 | Permit Number 38731 | 6006204.75677 | 2121056.43709 | 37.8043668775019 | -122.42276644632601 | (37.8043668775019, -122.422766446326) | |
| 135338 | 135338 | 34252 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 945 Bay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1998 12:00:00 AM | 8 | Permit Number 38731 | 6006224.9654 | 2121058.41971 | 37.804373461439795 | -122.42269665353999 | (37.8043734614398, -122.42269665354) | |
| 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) | |
| 147505 | 147505 | 247402 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 944 Page St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 0ft | 6002027.7583 | 2109490.1505 | 37.7723722659737 | -122.436392970615 | (37.7723722659737, -122.436392970615) | |||
| 89683 | 89683 | 59918 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 942 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/24/1981 12:00:00 AM | Permit Number 19387 | 6009922.90971034 | 2103712.90059838 | 37.7569547053635 | -122.40867514442101 | (37.7569547053635, -122.408675144421) | ||
| 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) | |||
| 97668 | 97668 | 109438 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 940 Grove St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/18/2015 12:00:00 AM | 3 | 6003118.8 | 2111045.9 | 37.7767059032045 | -122.43273011286101 | (37.7767059032045, -122.432730112861) | |||
| 78938 | 78938 | 59900 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 938 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/21/1981 12:00:00 AM | Permit Number 19367 | 6009921.67857589 | 2103735.23260959 | 37.7570159551008 | -122.408680977559 | (37.7570159551008, -122.408680977559) | ||
| 114914 | 114914 | 86713 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 938 Garfield St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/24/2007 12:00:00 AM | Permit Number 49699 | 5991527.0 | 2090568.7 | 37.7198165808065 | -122.47133684225099 | (37.7198165808065, -122.471336842251) | ||||
| 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) | |||
| 67599 | 67599 | 239294 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 936 York St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 6ft | 6009927.4277099995 | 2103728.71332 | 37.756998376592 | -122.408660634893 | (37.756998376592, -122.408660634893) | |||
| 103676 | 103676 | 26760 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 930X Monterey Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/22/2008 12:00:00 AM | 3 | 5 | 5995872.4804074 | 2094645.0571617 | 37.731259698358 | -122.456610772668 | (37.731259698358, -122.456610772668) | ||
| 118181 | 118181 | 179285 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 93 Delta St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6010162.36149 | 2089750.0772799999 | 37.7186291998585 | -122.40686296837099 | (37.7186291998585, -122.406862968371) | |||
| 135080 | 135080 | 69741 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 93 Delta St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2002 12:00:00 AM | 5 | 6010157.175969999 | 2089735.57492 | 37.7185890892048 | -122.40687987112601 | (37.7185890892048, -122.406879871126) | ||
| 52547 | 52547 | 136233 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 928 Leavenworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008241.15126 | 2115615.72807 | 37.789542725373295 | -122.415333916531 | (37.7895427253733, -122.415333916531) | |||
| 144326 | 144326 | 136235 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 928 Leavenworth St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008235.611740001 | 2115647.76794 | 37.7896303876902 | -122.41535535186199 | (37.7896303876902, -122.415355351862) | |||
| 156143 | 156143 | 136234 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 928 Leavenworth St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008238.09244 | 2115632.75649 | 37.7895893093397 | -122.41534570573299 | (37.7895893093397, -122.415345705733) | |||
| 165466 | 165466 | 136232 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 928 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008243.34435 | 2115601.8020599997 | 37.789504611209004 | -122.415325342399 | (37.789504611209, -122.415325342399) | |||
| 35804 | 35804 | 239300 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 927 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6009964.45155 | 2103786.9298 | 37.757160299531996 | -122.408536698407 | (37.757160299532, -122.408536698407) | |||
| 125532 | 125532 | 59905 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 925 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/21/1981 12:00:00 AM | Permit Number 19373 | 6009969.290768799 | 2103816.25695251 | 37.7572410963252 | -122.40852203113998 | (37.7572410963252, -122.40852203114) | ||
| 70939 | 70939 | 200236 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 921 Ingerson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6014551.0541 | 2089524.7802 | 37.718255172199896 | -122.39167717639299 | (37.7182551721999, -122.391677176393) | |||
| 91753 | 91753 | 88469 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 921 Ingerson Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51423 | 6014544.1 | 2089500.7 | 37.7181886666833 | -122.39169953123199 | (37.7181886666833, -122.391699531232) | |||
| 98119 | 98119 | 117314 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 910 Clayton St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/06/2016 12:00:00 AM | 3 | 5998775.9 | 2106883.7 | 37.7650303025851 | -122.447453764259 | (37.7650303025851, -122.447453764259) | |||
| 85202 | 85202 | 29137 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 90x Jones St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/19/2005 12:00:00 AM | 3 | 3x3 | 6009115.3969879 | 2112842.7343051997 | 37.781977847913204 | -122.41211305193501 | (37.7819778479132, -122.412113051935) | ||
| 125861 | 125861 | 59896 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 906 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/21/1981 12:00:00 AM | Permit Number 19363 | 6009911.82950519 | 2103913.88861057 | 37.7575059527221 | -122.408727642987 | (37.7575059527221, -122.408727642987) | ||
| 20207 | 20207 | 4337 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 906 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/27/2001 12:00:00 AM | 6 | 3X3 | 6001499.188490001 | 2095960.05903 | 37.735191840439896 | -122.437252384095 | (37.7351918404399, -122.437252384095) | ||
| 56227 | 56227 | 197135 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 901 Newhall St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6015262.92854 | 2096819.7411099998 | 37.738325167482294 | -122.389725749154 | (37.7383251674823, -122.389725749154) | |||
| 73273 | 73273 | 197136 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 901 Newhall St | 4 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6015282.23394 | 2096844.32451 | 37.7383937389821 | -122.38966071648998 | (37.7383937389821, -122.38966071649) | |||
| 96907 | 96907 | 4339 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 901 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/02/2016 07:58:00 AM | 3 | 3X3 | 6001465.6431599995 | 2095917.8806599998 | 37.7350741214051 | -122.437365343013 | (37.7350741214051, -122.437365343013) | ||
| 110363 | 110363 | 116922 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 900x 24TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015390.0 | 2102613.0 | 37.754239296938295 | -122.389690908339 | (37.7542392969383, -122.389690908339) | ||
| 64020 | 64020 | 82025 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 900-904 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/2008 12:00:00 AM | 7 | 3x3 | Permit Number 50637 | 6008560.7244 | 2119705.2270299997 | 37.800789437354496 | -122.41451772334 | (37.8007894373545, -122.41451772334) | |
| 95677 | 95677 | 59892 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 900 York St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | 3x3 | Permit Number 774687 | 6009909.98280438 | 2103947.38661173 | 37.75759782727221 | -122.408736392824 | (37.7575978272722, -122.408736392824) | |
| 113290 | 113290 | 98121 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 900 York St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | Permit Number 774687 | 6009897.0 | 2103882.5 | 37.7574189360449 | -122.40877671518999 | (37.7574189360449, -122.40877671519) | ||
| 133160 | 133160 | 239292 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 900 York St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6009918.7268199995 | 2103885.22613 | 37.7574276383036 | -122.40870176718799 | (37.7574276383036, -122.408701767188) | |||
| 93254 | 93254 | 60828 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 90 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/1983 12:00:00 AM | Permit Number 20507 | 6004536.75040405 | 2101647.15007876 | 37.750979497718895 | -122.427155379561 | (37.7509794977189, -122.427155379561) | ||
| 82224 | 82224 | 67145 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 9 Massasoit St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/1992 12:00:00 AM | Permit Number 775821 | 6010104.62054101 | 2099298.30623793 | 37.7448433809463 | -122.40773544745701 | (37.7448433809463, -122.407735447457) | ||
| 19275 | 19275 | 34240 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 9 Chattanooga St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/1997 12:00:00 AM | Permit Number 38051 | 6004714.42221556 | 2103615.95230322 | 37.7563954143949 | -122.426681158586 | (37.7563954143949, -122.426681158586) | |||
| 84247 | 84247 | 34239 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 9 Chattanooga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/1997 12:00:00 AM | Permit Number 38051 | 6004714.42221556 | 2103615.95230322 | 37.7563954143949 | -122.426681158586 | (37.7563954143949, -122.426681158586) | |||
| 115346 | 115346 | 34241 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 9 Chattanooga St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/1997 12:00:00 AM | Permit Number 38051 | 6004714.42221556 | 2103615.95230322 | 37.7563954143949 | -122.426681158586 | (37.7563954143949, -122.426681158586) | |||
| 140848 | 140848 | 34238 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 9 Chattanooga St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/1997 12:00:00 AM | Permit Number 38051 | 6004714.42221556 | 2103615.95230322 | 37.7563954143949 | -122.426681158586 | (37.7563954143949, -122.426681158586) | |||
| 81307 | 81307 | 20137 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 898 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 01/11/2011 12:00:00 AM | 3 | 8x4 | Permit Number 54088 | 6003009.7075288 | 2111327.5412022998 | 37.777473032235704 | -122.433127623561 | (37.7774730322357, -122.433127623561) | |
| 128038 | 128038 | 7193 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 898 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1992 12:00:00 AM | 6 | 3X3 | 6003489.5579699995 | 2111353.68492 | 37.7775720243799 | -122.431469529604 | (37.7775720243799, -122.431469529604) | ||
| 171856 | 171856 | 139399 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 896 STEINER ST | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 0ft | 6003012.8594 | 2111291.1403 | 37.7773732632111 | -122.433114118747 | (37.7773732632111, -122.433114118747) | |||
| 136061 | 136061 | 139287 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 894 STEINER ST | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 0ft | 6003017.2906 | 2111263.9995 | 37.7772989926884 | -122.43309685014499 | (37.7772989926884, -122.433096850145) | |||
| 102823 | 102823 | 20136 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 890 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 01/11/2011 12:00:00 AM | 3 | 8x4 | Permit Number 54087 | 6003007.0 | 2111306.0 | 37.777413731872 | -122.43313545029301 | (37.777413731872, -122.433135450293) | |
| 17939 | 17939 | 26869 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 890 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/2002 12:00:00 AM | 3 | 3X3 | 6001564.842 | 2095930.60071 | 37.7351146866797 | -122.437023288105 | (37.7351146866797, -122.437023288105) | ||
| 77592 | 77592 | 120516 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 888 Brannan St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011018.0 | 2109170.0 | 37.771999940852105 | -122.40527216982201 | (37.7719999408521, -122.405272169822) | ||||
| 83756 | 83756 | 120515 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 888 Brannan St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011018.0 | 2109170.0 | 37.771999940852105 | -122.40527216982201 | (37.7719999408521, -122.405272169822) | ||||
| 120937 | 120937 | 120517 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 888 Brannan St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011018.0 | 2109170.0 | 37.771999940852105 | -122.40527216982201 | (37.7719999408521, -122.405272169822) | ||||
| 167390 | 167390 | 140612 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 880 Fillmore St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6003492.8085 | 2111354.3072 | 37.777573917234996 | -122.431458329369 | (37.777573917235, -122.431458329369) | |||
| 95835 | 95835 | 67360 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 878 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/19/1994 12:00:00 AM | Permit Number 30849 | 6009901.77638254 | 2104097.66995535 | 37.7580100118956 | -122.40877537631799 | (37.7580100118956, -122.408775376318) | ||
| 135920 | 135920 | 239291 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 876 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 5ft | 6009903.2471199995 | 2104137.06349 | 37.7581182600559 | -122.408773069018 | (37.7581182600559, -122.408773069018) | |||
| 97895 | 97895 | 63879 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 875 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/16/1987 12:00:00 AM | Permit Number 24585 | 6003771.56035728 | 2103192.85822001 | 37.75518034706371 | -122.42991172572901 | (37.7551803470637, -122.429911725729) | ||
| 68448 | 68448 | 197114 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 872 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6011557.94817 | 2104244.48533 | 37.7585057590633 | -122.403057924191 | (37.7585057590633, -122.403057924191) | |||
| 113880 | 113880 | 115805 | Planning Code 138.1 required 4 | Pyrus kawakamii :: Evergreen Pear 82 | 872 Kansas St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | 3x3 | 6011546.4 | 2104246.9 | 37.758511744317296 | -122.40309803301201 | (37.7585117443173, -122.403098033012) | |||
| 74047 | 74047 | 239290 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 870 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6009903.2764800005 | 2104148.96892 | 37.758150951332105 | -122.408773807391 | (37.7581509513321, -122.408773807391) | |||
| 103113 | 103113 | 67359 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 870 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/1992 12:00:00 AM | Permit Number 30848 | 6009899.27100597 | 2104143.60845507 | 37.7581360083504 | -122.408787281934 | (37.7581360083504, -122.408787281934) | ||
| 75017 | 75017 | 140555 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 864 FULTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6003696.4035 | 2111458.3246 | 37.7778710601657 | -122.430761450875 | (37.7778710601657, -122.430761450875) | |||
| 102322 | 102322 | 67358 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 860 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/1992 12:00:00 AM | Permit Number 30846 | 6009896.1392835 | 2104201.03161192 | 37.758293504001706 | -122.408802164019 | (37.7582935040017, -122.408802164019) | ||
| 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) | |||
| 77830 | 77830 | 8119 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 850X Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/14/2007 12:00:00 AM | 3 | 3X3 | 6003699.00422 | 2111459.33104 | 37.777873970946295 | -122.43075252591801 | (37.7778739709463, -122.430752525918) | ||
| 8801 | 8801 | 94278 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 850@Golden Gate Broderick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 6001005.8896 | 2111653.4167 | 37.7782539328231 | -122.440082850024 | (37.7782539328231, -122.440082850024) | ||||
| 8721 | 8721 | 94275 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 850 Broderick St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 6001000.8133 | 2111684.213 | 37.778338202659995 | -122.440102619662 | (37.77833820266, -122.440102619662) | ||||
| 81875 | 81875 | 89298 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 850 Broderick St | 2 | 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) | ||
| 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) | ||
| 95631 | 95631 | 18654 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 85 Reuel Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/04/1998 12:00:00 AM | 3 | 3X4 | 6017364.7700717 | 2096131.8258237 | 37.7365526173752 | -122.382410690517 | (37.7365526173752, -122.382410690517) | ||
| 125389 | 125389 | 18655 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 85 Reuel Ct | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/18/1999 12:00:00 AM | 3 | 3X4 | 6017364.7700717 | 2096131.8258237 | 37.7365526173752 | -122.382410690517 | (37.7365526173752, -122.382410690517) | ||
| 79383 | 79383 | 43386 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 847 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/2000 12:00:00 AM | Permit Number 43133 | 6001928.68244613 | 2101630.19955263 | 37.75078512339571 | -122.436173106924 | (37.7507851233957, -122.436173106924) | ||
| 116602 | 116602 | 43385 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 847 Diamond St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/2000 12:00:00 AM | Permit Number 43133 | 6001928.68244613 | 2101630.19955263 | 37.75078512339571 | -122.436173106924 | (37.7507851233957, -122.436173106924) | ||
| 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) | ||
| 89773 | 89773 | 38663 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 840 Broderick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/01/1998 12:00:00 AM | 5x3 | Permit Number 40585 | 6001023.37265886 | 2111553.49114647 | 37.7779805578681 | -122.44001520291401 | (37.7779805578681, -122.440015202914) |
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");