trees
1,985 rows where qSpecies_id = 83 sorted by qAddress descending
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress ▲ | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
18871 | 108376 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 995X Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/2015 12:00:00 AM | 3 | Permit Number 775198 | 6003269.72698 | 2111024.20368 | 37.7766548889563 | -122.432206462364 | (37.7766548889563, -122.432206462364) | 15 | 9 | 11 | 29492 | 10 | ||
32470 | 110524 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 995X Grove St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/2015 12:00:00 AM | 3 | Permit Number 775198 | 6003269.72698 | 2111024.20368 | 37.7766548889563 | -122.432206462364 | (37.7766548889563, -122.432206462364) | 15 | 9 | 11 | 29492 | 10 | ||
109384 | 69409 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 990 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/1994 12:00:00 AM | Permit Number 33514 | 6001528.72905075 | 2086815.30428152 | 37.7100840871049 | -122.436495934551 | (37.7100840871049, -122.436495934551) | 9 | 7 | 6 | 28861 | 5 | ||
96544 | 197151 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 99 Whitney Young Cir | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6016637.91847 | 2095129.63156 | 37.7337606161438 | -122.384853953468 | (37.7337606161438, -122.384853953468) | 10 | 3 | 8 | 58 | 1 | |||
2151 | 258135 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 988 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 6010589.4479 | 2112082.95565 | 37.7799742710855 | -122.40695991983 | (37.7799742710855, -122.40695991983) | 14 | 2 | 9 | 28853 | 34 | |||
167118 | 14763 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 983 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6004471.7203 | 2111860.4178 | 37.7790190047533 | -122.428108020326 | (37.7790190047533, -122.428108020326) | 7 | 9 | 11 | 29490 | 41 | |||
56241 | 59899 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 981 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1993 12:00:00 AM | Permit Number 29266 | 6009986.52664303 | 2103503.60894166 | 37.7563836002421 | -122.408440369707 | (37.7563836002421, -122.408440369707) | 2 | 4 | 7 | 28859 | 19 | ||
134814 | 239299 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 981 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6009975.32476 | 2103526.84529 | 37.7564467747236 | -122.408480748912 | (37.7564467747236, -122.408480748912) | 2 | 4 | 7 | 28859 | 19 | |||
108859 | 59895 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 980 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/21/1981 12:00:00 AM | Permit Number 19362 | 6009934.60548185 | 2103500.74659623 | 37.756372833099 | -122.408619730116 | (37.756372833099, -122.408619730116) | 2 | 4 | 7 | 28859 | 19 | ||
94497 | 213943 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 98 Westwood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5995156.25779 | 2093258.26131 | 37.727410745106 | -122.458986493338 | (37.727410745106, -122.458986493338) | 9 | 7 | 4 | 28861 | 40 | |||
170943 | 213944 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 98 Westwood Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 5995156.98418 | 2093277.67362 | 37.7274640883802 | -122.458985387177 | (37.7274640883802, -122.458985387177) | 9 | 7 | 4 | 28861 | 40 | |||
8128 | 90393 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 98 12th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/31/2016 12:00:00 AM | 3 | 3x3 | 6007146.175112 | 2109626.370927 | 37.7730357998282 | -122.418697508419 | (37.7730357998282, -122.418697508419) | 8 | 2 | 9 | 28853 | 19 | ||
140812 | 90392 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 98 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/08/2014 12:00:00 AM | 3 | 3x3 | 6007146.175112 | 2109626.370927 | 37.7730357998282 | -122.418697508419 | (37.7730357998282, -122.418697508419) | 8 | 2 | 9 | 28853 | 19 | ||
92858 | 179287 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 97 Still St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6002285.23223 | 2094449.03286 | 37.7310875612396 | -122.434426748408 | (37.7310875612396, -122.434426748408) | 9 | 7 | 5 | 28861 | 25 | |||
149225 | 179288 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 97 Still St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6002296.73031 | 2094454.79419 | 37.7311040332072 | -122.434387409368 | (37.7311040332072, -122.434387409368) | 9 | 7 | 5 | 28861 | 25 | |||
175111 | 179286 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 97 Still St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6002271.23579 | 2094443.82332 | 37.7310724625286 | -122.434474764118 | (37.7310724625286, -122.434474764118) | 9 | 7 | 5 | 28861 | 25 | |||
175515 | 179290 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 97 Still St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6002318.3672 | 2094465.3447 | 37.7311342306478 | -122.434313360986 | (37.7311342306478, -122.434313360986) | 9 | 7 | 5 | 28861 | 25 | |||
176340 | 179289 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 97 Still St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6002308.41253 | 2094461.38463 | 37.7311227921608 | -122.434347492961 | (37.7311227921608, -122.434347492961) | 9 | 7 | 5 | 28861 | 25 | |||
140003 | 30525 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 96 McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/2005 12:00:00 AM | 10 | 3x3 | 6008672.39963745 | 2112539.12321188 | 37.7811193385199 | -122.413624143987 | (37.7811193385199, -122.413624143987) | 7 | 10 | 9 | 28852 | 36 | |
100166 | 24177 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 95X Whitney Young Cir | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2006 12:00:00 AM | 4 | 3X3 | 6016412.1769872 | 2096105.6107164 | 37.736427970914 | -122.38570241579 | (37.736427970914, -122.38570241579) | 10 | 3 | 8 | 58 | 1 | ||
115424 | 24171 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 95X Whitney Young Cir | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2006 12:00:00 AM | 3 | 3x3 | 6016412.1769872 | 2096105.6107164 | 37.736427970914 | -122.38570241579 | (37.736427970914, -122.38570241579) | 10 | 3 | 8 | 58 | 1 | ||
58295 | 59898 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 956 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 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.7567403313902 | -122.408654728525 | (37.7567403313902, -122.408654728525) | 2 | 4 | 7 | 28859 | 19 | |
103323 | 88464 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 955X Newhall St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51410 | 6015306.946426 | 2096847.395831 | 37.7384035424873 | -122.389575486471 | (37.7384035424873, -122.389575486471) | 10 | 3 | 8 | 58 | 1 | |
142222 | 88466 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 955X Newhall St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/11/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51410 | 6015306.946426 | 2096847.395831 | 37.7384035424873 | -122.389575486471 | (37.7384035424873, -122.389575486471) | 10 | 3 | 8 | 58 | 1 |
93691 | 240166 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 955 Clayton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 5998780.13001 | 2106624.27042 | 37.7643182159335 | -122.447420459091 | (37.7643182159335, -122.447420459091) | 15 | 5 | 11 | 29492 | 9 | |||
141329 | 240165 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 955 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 5998776.9827 | 2106633.40006 | 37.7643431037773 | -122.447432001889 | (37.7643431037773, -122.447432001889) | 15 | 5 | 11 | 29492 | 9 | |||
161106 | 240167 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 955 Clayton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 5998784.85204 | 2106603.32437 | 37.7642609731824 | -122.44740261924 | (37.7642609731824, -122.44740261924) | 15 | 5 | 11 | 29492 | 9 | |||
190435 | 240164 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 953 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 5998770.20666 | 2106657.712 | 37.764409471033 | -122.447457188295 | (37.764409471033, -122.447457188295) | 15 | 5 | 11 | 29492 | 9 | |||
167765 | 67166 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 95 Putnam St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/1992 12:00:00 AM | Permit Number 30606 | 6009175.78663264 | 2096920.50088171 | 37.738262406618 | -122.410779296402 | (37.738262406618, -122.410779296402) | 10 | 7 | 7 | 28859 | 2 | ||
190612 | 213993 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 95 Martha Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6000354.21561 | 2095866.7572 | 37.7348705009689 | -122.441204268679 | (37.7348705009689, -122.441204268679) | 9 | 7 | 5 | 63 | 40 | |||
13315 | 34250 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 945 Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/17/1998 12:00:00 AM | 5 | Permit Number 38731 | 6006204.75677 | 2121056.43709 | 37.8043668775019 | -122.422766446326 | (37.8043668775019, -122.422766446326) | 5 | 1 | 1 | 28858 | 32 | |
35557 | 34252 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 945 Bay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/17/1998 12:00:00 AM | 8 | Permit Number 38731 | 6006224.9654 | 2121058.41971 | 37.8043734614398 | -122.42269665354 | (37.8043734614398, -122.42269665354) | 5 | 1 | 1 | 28858 | 32 | |
81997 | 34253 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 945 Bay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/17/1998 12:00:00 AM | 7 | Permit Number 38731 | 6006242.74242 | 2121059.25353 | 37.8043767538414 | -122.422635193862 | (37.8043767538414, -122.422635193862) | 5 | 1 | 1 | 28858 | 32 | |
139056 | 247402 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 944 Page St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 0ft | 6002027.7583 | 2109490.1505 | 37.7723722659737 | -122.436392970615 | (37.7723722659737, -122.436392970615) | 15 | 5 | 11 | 29492 | 9 | |||
51871 | 239295 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 942 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 6ft | 6009930.36914 | 2103706.31975 | 37.7569370536161 | -122.408648882561 | (37.7569370536161, -122.408648882561) | 2 | 4 | 7 | 28859 | 19 | |||
67889 | 59918 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 942 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/24/1981 12:00:00 AM | Permit Number 19387 | 6009922.90971034 | 2103712.90059838 | 37.7569547053635 | -122.408675144421 | (37.7569547053635, -122.408675144421) | 2 | 4 | 7 | 28859 | 19 | ||
51623 | 109438 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 940 Grove St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/18/2015 12:00:00 AM | 3 | 6003118.8 | 2111045.9 | 37.7767059032045 | -122.432730112861 | (37.7767059032045, -122.432730112861) | 15 | 9 | 11 | 29492 | 10 | |||
43527 | 59900 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 938 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/21/1981 12:00:00 AM | Permit Number 19367 | 6009921.67857589 | 2103735.23260959 | 37.7570159551008 | -122.408680977559 | (37.7570159551008, -122.408680977559) | 2 | 4 | 7 | 28859 | 19 | ||
149159 | 86713 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 938 Garfield St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/24/2007 12:00:00 AM | Permit Number 49699 | 5991527 | 2090568.7 | 37.7198165808065 | -122.471336842251 | (37.7198165808065, -122.471336842251) | 9 | 8 | 6 | 64 | 24 | ||||
56729 | 239294 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 936 York St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 6ft | 6009927.42771 | 2103728.71332 | 37.756998376592 | -122.408660634893 | (37.756998376592, -122.408660634893) | 2 | 4 | 7 | 28859 | 19 | |||
128509 | 239293 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 936 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 6ft | 6009925.69316 | 2103743.63786 | 37.757039258881 | -122.408667686482 | (37.757039258881, -122.408667686482) | 2 | 4 | 7 | 28859 | 19 | |||
105100 | 26760 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 930X Monterey Blvd | 4 | Median : Cutout | Tree | DPW 1 | 04/22/2008 12:00:00 AM | 3 | 5 | 5995872.4804074 | 2094645.0571617 | 37.731259698358 | -122.456610772668 | (37.731259698358, -122.456610772668) | 9 | 7 | 4 | 59 | 40 | ||
7723 | 69741 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 93 Delta St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6010157.17597 | 2089735.57492 | 37.7185890892048 | -122.406879871126 | (37.7185890892048, -122.406879871126) | 10 | 7 | 8 | 309 | 39 | |||
193279 | 179285 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 93 Delta St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6010162.36149 | 2089750.07728 | 37.7186291998585 | -122.406862968371 | (37.7186291998585, -122.406862968371) | 10 | 7 | 8 | 309 | 39 | |||
15634 | 136235 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 928 Leavenworth St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008235.61174 | 2115647.76794 | 37.7896303876902 | -122.415355351862 | (37.7896303876902, -122.415355351862) | 5 | 1 | 10 | 28858 | 21 | |||
102607 | 136234 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 928 Leavenworth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008238.09244 | 2115632.75649 | 37.7895893093397 | -122.415345705733 | (37.7895893093397, -122.415345705733) | 5 | 1 | 10 | 28858 | 21 | |||
132384 | 136232 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 928 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008243.34435 | 2115601.80206 | 37.789504611209 | -122.415325342399 | (37.789504611209, -122.415325342399) | 5 | 1 | 10 | 28858 | 21 | |||
134709 | 136233 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 928 Leavenworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008241.15126 | 2115615.72807 | 37.7895427253733 | -122.415333916531 | (37.7895427253733, -122.415333916531) | 5 | 1 | 10 | 28858 | 21 | |||
165785 | 239300 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 927 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6009964.45155 | 2103786.9298 | 37.757160299532 | -122.408536698407 | (37.757160299532, -122.408536698407) | 2 | 4 | 7 | 28859 | 19 | |||
36675 | 59905 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 925 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/21/1981 12:00:00 AM | Permit Number 19373 | 6009969.2907688 | 2103816.25695251 | 37.7572410963252 | -122.40852203114 | (37.7572410963252, -122.40852203114) | 2 | 4 | 7 | 28859 | 19 | ||
87443 | 88469 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 921 Ingerson Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51423 | 6014544.1 | 2089500.7 | 37.7181886666833 | -122.391699531232 | (37.7181886666833, -122.391699531232) | 10 | 3 | 8 | 58 | 1 | |||
100411 | 200236 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 921 Ingerson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6014551.0541 | 2089524.7802 | 37.7182551721999 | -122.391677176393 | (37.7182551721999, -122.391677176393) | 10 | 3 | 8 | 58 | 1 | |||
110729 | 117314 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 910 Clayton St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/06/2016 12:00:00 AM | 3 | 5998775.9 | 2106883.7 | 37.7650303025851 | -122.447453764259 | (37.7650303025851, -122.447453764259) | 15 | 5 | 11 | 29492 | 9 | |||
67141 | 29137 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 90x Jones St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/19/2005 12:00:00 AM | 3 | 3x3 | 6009115.3969879 | 2112842.7343052 | 37.7819778479132 | -122.412113051935 | (37.7819778479132, -122.412113051935) | 14 | 10 | 9 | 28852 | 36 | ||
30900 | 59896 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 906 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/21/1981 12:00:00 AM | Permit Number 19363 | 6009911.82950519 | 2103913.88861057 | 37.7575059527221 | -122.408727642987 | (37.7575059527221, -122.408727642987) | 2 | 4 | 7 | 28859 | 19 | ||
65748 | 4337 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 906 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/2001 12:00:00 AM | 6 | 3X3 | 6001499.18849 | 2095960.05903 | 37.7351918404399 | -122.437252384095 | (37.7351918404399, -122.437252384095) | 2 | 7 | 5 | 63 | 7 | ||
50390 | 197136 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 901 Newhall St | 4 | : | Tree | Private 2 | 6 | Width 3ft | 6015282.23394 | 2096844.32451 | 37.7383937389821 | -122.38966071649 | (37.7383937389821, -122.38966071649) | 10 | 3 | 8 | 58 | 1 | |||
185801 | 197135 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 901 Newhall St | 2 | : | Tree | Private 2 | 5 | Width 3ft | 6015262.92854 | 2096819.74111 | 37.7383251674823 | -122.389725749154 | (37.7383251674823, -122.389725749154) | 10 | 3 | 8 | 58 | 1 | |||
90947 | 4339 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 901 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/02/2016 07:58:00 AM | 3 | 3X3 | 6001465.64316 | 2095917.88066 | 37.7350741214051 | -122.437365343013 | (37.7350741214051, -122.437365343013) | 2 | 7 | 5 | 63 | 7 | ||
147805 | 116922 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 900x 24TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015390 | 2102613 | 37.7542392969383 | -122.389690908339 | (37.7542392969383, -122.389690908339) | 10 | 3 | 8 | 28856 | 29 | ||
65266 | 82025 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 900-904 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2008 12:00:00 AM | 7 | 3x3 | Permit Number 50637 | 6008560.7244 | 2119705.22703 | 37.8007894373545 | -122.41451772334 | (37.8007894373545, -122.41451772334) | 5 | 1 | 10 | 308 | 32 | |
81547 | 59892 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 900 York St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1993 12:00:00 AM | 3x3 | Permit Number 774687 | 6009909.98280438 | 2103947.38661173 | 37.7575978272722 | -122.408736392824 | (37.7575978272722, -122.408736392824) | 2 | 4 | 7 | 28859 | 19 | |
133479 | 98121 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 900 York St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | Permit Number 774687 | 6009897 | 2103882.5 | 37.7574189360449 | -122.40877671519 | (37.7574189360449, -122.40877671519) | 2 | 4 | 7 | 28859 | 19 | ||
164616 | 239292 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 900 York St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6009918.72682 | 2103885.22613 | 37.7574276383036 | -122.408701767188 | (37.7574276383036, -122.408701767188) | 2 | 4 | 7 | 28859 | 19 | |||
87758 | 60828 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 90 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/1983 12:00:00 AM | Permit Number 20507 | 6004536.75040405 | 2101647.15007876 | 37.7509794977189 | -122.427155379561 | (37.7509794977189, -122.427155379561) | 2 | 4 | 5 | 28862 | 22 | ||
39181 | 67145 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 9 Massasoit St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/30/1992 12:00:00 AM | Permit Number 775821 | 6010104.62054101 | 2099298.30623793 | 37.7448433809463 | -122.407735447457 | (37.7448433809463, -122.407735447457) | 2 | 7 | 7 | 28859 | 2 | ||
14223 | 34240 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 9 Chattanooga St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/1997 12:00:00 AM | Permit Number 38051 | 6004714.42221556 | 2103615.95230322 | 37.7563954143949 | -122.426681158586 | (37.7563954143949, -122.426681158586) | 2 | 4 | 5 | 28862 | 22 | |||
52413 | 34239 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 9 Chattanooga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/1997 12:00:00 AM | Permit Number 38051 | 6004714.42221556 | 2103615.95230322 | 37.7563954143949 | -122.426681158586 | (37.7563954143949, -122.426681158586) | 2 | 4 | 5 | 28862 | 22 | |||
145437 | 34241 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 9 Chattanooga St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/1997 12:00:00 AM | Permit Number 38051 | 6004714.42221556 | 2103615.95230322 | 37.7563954143949 | -122.426681158586 | (37.7563954143949, -122.426681158586) | 2 | 4 | 5 | 28862 | 22 | |||
173860 | 34238 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 9 Chattanooga St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/1997 12:00:00 AM | Permit Number 38051 | 6004714.42221556 | 2103615.95230322 | 37.7563954143949 | -122.426681158586 | (37.7563954143949, -122.426681158586) | 2 | 4 | 5 | 28862 | 22 | |||
186997 | 20137 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 898 Steiner St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 01/11/2011 12:00:00 AM | 3 | 8x4 | Permit Number 54088 | 6003009.7075288 | 2111327.5412023 | 37.7774730322357 | -122.433127623561 | (37.7774730322357, -122.433127623561) | 15 | 9 | 11 | 29492 | 10 | |
37742 | 7193 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 898 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/19/1992 12:00:00 AM | 6 | 3X3 | 6003489.55797 | 2111353.68492 | 37.7775720243799 | -122.431469529604 | (37.7775720243799, -122.431469529604) | 7 | 9 | 11 | 29492 | 10 | ||
51039 | 139399 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 896 STEINER ST | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 0ft | 6003012.8594 | 2111291.1403 | 37.7773732632111 | -122.433114118747 | (37.7773732632111, -122.433114118747) | 15 | 9 | 11 | 29492 | 10 | |||
116196 | 139287 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 894 STEINER ST | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 0ft | 6003017.2906 | 2111263.9995 | 37.7772989926884 | -122.433096850145 | (37.7772989926884, -122.433096850145) | 15 | 9 | 11 | 29492 | 10 | |||
33160 | 20136 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 890 Steiner St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 01/11/2011 12:00:00 AM | 3 | 8x4 | Permit Number 54087 | 6003007 | 2111306 | 37.777413731872 | -122.433135450293 | (37.777413731872, -122.433135450293) | 15 | 9 | 11 | 29492 | 10 | |
178690 | 26869 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 890 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/2002 12:00:00 AM | 3 | 3X3 | 6001564.842 | 2095930.60071 | 37.7351146866797 | -122.437023288105 | (37.7351146866797, -122.437023288105) | 2 | 7 | 5 | 63 | 7 | ||
26265 | 120516 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 888 Brannan St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011018 | 2109170 | 37.7719999408521 | -122.405272169822 | (37.7719999408521, -122.405272169822) | 14 | 2 | 9 | 28853 | 34 | ||||
43433 | 120515 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 888 Brannan St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011018 | 2109170 | 37.7719999408521 | -122.405272169822 | (37.7719999408521, -122.405272169822) | 14 | 2 | 9 | 28853 | 34 | ||||
167127 | 120517 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 888 Brannan St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011018 | 2109170 | 37.7719999408521 | -122.405272169822 | (37.7719999408521, -122.405272169822) | 14 | 2 | 9 | 28853 | 34 | ||||
1241 | 140612 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 880 Fillmore St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6003492.8085 | 2111354.3072 | 37.777573917235 | -122.431458329369 | (37.777573917235, -122.431458329369) | 7 | 9 | 11 | 29492 | 10 | |||
95080 | 67360 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 878 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/19/1994 12:00:00 AM | Permit Number 30849 | 6009901.77638254 | 2104097.66995535 | 37.7580100118956 | -122.408775376318 | (37.7580100118956, -122.408775376318) | 2 | 4 | 7 | 28859 | 19 | ||
171048 | 239291 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 876 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 5ft | 6009903.24712 | 2104137.06349 | 37.7581182600559 | -122.408773069018 | (37.7581182600559, -122.408773069018) | 2 | 4 | 7 | 28859 | 19 | |||
96407 | 63879 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 875 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/16/1987 12:00:00 AM | Permit Number 24585 | 6003771.56035728 | 2103192.85822001 | 37.7551803470637 | -122.429911725729 | (37.7551803470637, -122.429911725729) | 2 | 4 | 5 | 28862 | 22 | ||
120592 | 197114 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 872 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6011557.94817 | 2104244.48533 | 37.7585057590633 | -122.403057924191 | (37.7585057590633, -122.403057924191) | 10 | 3 | 8 | 28856 | 29 | |||
142797 | 115805 | Planning Code 138.1 required 2 | Pyrus kawakamii :: Evergreen Pear 83 | 872 Kansas St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | 3x3 | 6011546.4 | 2104246.9 | 37.7585117443173 | -122.403098033012 | (37.7585117443173, -122.403098033012) | 10 | 3 | 8 | 28856 | 29 | |||
17844 | 239290 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 870 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6009903.27648 | 2104148.96892 | 37.7581509513321 | -122.408773807391 | (37.7581509513321, -122.408773807391) | 2 | 4 | 7 | 28859 | 19 | |||
99622 | 67359 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 870 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1992 12:00:00 AM | Permit Number 30848 | 6009899.27100597 | 2104143.60845507 | 37.7581360083504 | -122.408787281934 | (37.7581360083504, -122.408787281934) | 2 | 4 | 7 | 28859 | 19 | ||
35534 | 140555 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 864 FULTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6003696.4035 | 2111458.3246 | 37.7778710601657 | -122.430761450875 | (37.7778710601657, -122.430761450875) | 15 | 9 | 11 | 29492 | 41 | |||
113254 | 67358 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 860 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1992 12:00:00 AM | Permit Number 30846 | 6009896.1392835 | 2104201.03161192 | 37.7582935040017 | -122.408802164019 | (37.7582935040017, -122.408802164019) | 2 | 4 | 7 | 28859 | 19 | ||
45366 | 239339 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 86 Peralta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6010357.16524 | 2100318.41183 | 37.7476585025396 | -122.406934075969 | (37.7476585025396, -122.406934075969) | 2 | 7 | 7 | 28859 | 2 | |||
36501 | 8119 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 850X Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/14/2007 12:00:00 AM | 3 | 3X3 | 6003699.00422 | 2111459.33104 | 37.7778739709463 | -122.430752525918 | (37.7778739709463, -122.430752525918) | 15 | 9 | 11 | 29492 | 41 | ||
154724 | 94278 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 850@Golden Gate Broderick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 6001005.8896 | 2111653.4167 | 37.7782539328231 | -122.440082850024 | (37.7782539328231, -122.440082850024) | 15 | 5 | 11 | 29490 | 41 | ||||
42778 | 89298 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 850 Broderick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/24/2008 12:00:00 AM | 3x3 | Permit Number 51901 | 6001012 | 2111585 | 37.7780664257709 | -122.440056804822 | (37.7780664257709, -122.440056804822) | 15 | 5 | 11 | 29490 | 41 | ||
89727 | 94275 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 850 Broderick St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 6001000.8133 | 2111684.213 | 37.77833820266 | -122.440102619662 | (37.77833820266, -122.440102619662) | 15 | 5 | 11 | 29490 | 41 | ||||
180090 | 89297 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 850 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/24/2008 12:00:00 AM | 3x3 | Permit Number 51901 | 6001012 | 2111585 | 37.7780664257709 | -122.440056804822 | (37.7780664257709, -122.440056804822) | 15 | 5 | 11 | 29490 | 41 | ||
22372 | 18655 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 85 Reuel Ct | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/1999 12:00:00 AM | 3 | 3X4 | 6017364.7700717 | 2096131.8258237 | 37.7365526173752 | -122.382410690517 | (37.7365526173752, -122.382410690517) | 10 | 3 | 8 | 58 | 1 | ||
83643 | 18654 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 85 Reuel Ct | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/04/1998 12:00:00 AM | 3 | 3X4 | 6017364.7700717 | 2096131.8258237 | 37.7365526173752 | -122.382410690517 | (37.7365526173752, -122.382410690517) | 10 | 3 | 8 | 58 | 1 | ||
49393 | 43386 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 847 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/2000 12:00:00 AM | Permit Number 43133 | 6001928.68244613 | 2101630.19955263 | 37.7507851233957 | -122.436173106924 | (37.7507851233957, -122.436173106924) | 2 | 4 | 5 | 28862 | 22 | ||
134882 | 43385 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 847 Diamond St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/2000 12:00:00 AM | Permit Number 43133 | 6001928.68244613 | 2101630.19955263 | 37.7507851233957 | -122.436173106924 | (37.7507851233957, -122.436173106924) | 2 | 4 | 5 | 28862 | 22 | ||
28541 | 51529 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 846 Arkansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2005 12:00:00 AM | 5 | Permit Number 47831 | 6013038.03413 | 2103130.63922 | 37.7555299221754 | -122.397860957035 | (37.7555299221754, -122.397860957035) | 10 | 3 | 8 | 28856 | 29 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );