home / trees

Street_Tree_List

Data source: data.sfgov.org

6,701 rows where qSpecies = 43

View and edit SQL

Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, Fire Prevention Districts, Police Districts, Supervisor Districts, Zip Codes

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods
181 10018 Permitted Site 2 Prunus cerasifera :: Cherry Plum 43 205 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   09/28/1993 12:00:00 AM 6 3x3   6005510.9123943 2107567.8958458 37.767291517220706 -122.42420766586201 (37.7672915172207, -122.424207665862) 8 4 5 28853 19
191 10019 Permitted Site 2 Prunus cerasifera :: Cherry Plum 43 205 Guerrero St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     6 3x3   6005510.9123943 2107567.8958458 37.767291517220706 -122.42420766586201 (37.7672915172207, -122.424207665862) 8 4 5 28853 19
276 100286 Undocumented 3 Prunus cerasifera :: Cherry Plum 43 1435 06th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           5994228.1 2105736.9 37.7616205515651 -122.463100142071 (37.7616205515651, -122.463100142071) 1 5 11 56 12
335 100349 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 43 551 Naples St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   08/07/2012 12:00:00 AM 2 3x3 Permit Number 769104 6002969.9885599995 2090393.63163 37.7199911835241 -122.431769984714 (37.7199911835241, -122.431769984714) 9 7 6 28861 5
359 10039 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 43 360 Guerrero St 2 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   01/25/1991 12:00:00 AM 20 3X3   6005477.1925800005 2106955.99773 37.765609486820004 -122.424280773358 (37.76560948682, -122.424280773358) 8 4 5 28853 19
370 10040 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 43 360 Guerrero St 3 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     12 3X3   6005476.568580001 2106925.6543400004 37.7655261358546 -122.424280773346 (37.7655261358546, -122.424280773346) 8 4 5 28853 19
377 10041 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 43 360 Guerrero St 4 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   02/02/1991 12:00:00 AM 20 3X3   6005475.31081 2106892.46038 37.765434922114295 -122.42428276264299 (37.7654349221143, -122.424282762643) 8 4 5 28853 19
386 10042 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 43 360 Guerrero St 5 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     20 3X3   6005475.5325 2106875.27322 37.7653877427782 -122.424280773365 (37.7653877427782, -122.424280773365) 8 4 5 28853 19
406 10045 Permitted Site 2 Prunus cerasifera :: Cherry Plum 43 375 Guerrero St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   03/11/2007 12:00:00 AM 6 2X2   6005552.9439989 2106809.2959801997 37.7652109557568 -122.424008332395 (37.7652109557568, -122.424008332395) 8 4 5 28853 19
411 100460 Undocumented 3 Prunus cerasifera :: Cherry Plum 43 24 Woodland Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   5997085.6 2106503.4 37.7638893573064 -122.453272603676 (37.7638893573064, -122.453272603676) 15 5 11 29492 12
583 10064 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 43 512 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   01/01/1991 12:00:00 AM 30 3X3   6005527.25593 2105966.68025 37.762895882361 -122.42403725491 (37.762895882361, -122.42403725491) 8 4 5 28859 19
686 10077 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 43 611 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     12 3x3   6005621.78486 2105416.8204099997 37.761391433480895 -122.423671214664 (37.7613914334809, -122.423671214664) 2 4 5 28859 19
734 10082 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 43 635 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     12 2X2   6005631.678069999 2105272.5638099997 37.7609958972634 -122.42362674139 (37.7609958972634, -122.42362674139) 2 4 5 28859 19
782 100883 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 43 91 Welsh St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     6 3x3   6013382.01151 2111778.63358 37.779294541435796 -122.397277778167 (37.7792945414358, -122.397277778167) 6 2 9 28856 34
784 100885 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 43 91 Welsh St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   12/28/2017 12:00:00 AM 3 3x3   6013481.274680001 2111873.9835900003 37.779561876626296 -122.396941070175 (37.7795618766263, -122.396941070175) 6 2 9 28856 34
785 100886 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 43 91 Welsh St 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     6 3x3   6013501.81999 2111894.49362 37.7796193360911 -122.396871432992 (37.7796193360911, -122.396871432992) 6 2 9 28856 34
786 100887 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 43 91 Welsh St 6 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     6 3x3   6013527.06662 2111917.77164 37.7796846574549 -122.39678572578899 (37.7796846574549, -122.396785725789) 6 2 9 28856 34
793 100893 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 43 91 Welsh St 12 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     6 3x3   6013651.46361 2112030.89517 37.7800021918959 -122.396363310639 (37.7800021918959, -122.396363310639) 6 2 9 28856 34
808 100908 Permitted Site 2 Prunus cerasifera :: Cherry Plum 43 1800 Folsom St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     20 3x3 Permit Number 30965 6007972.0 2107962.0 37.76851228983521 -122.415722998498 (37.7685122898352, -122.415722998498) 8 4 7 28853 19
832 10097 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 43 744 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     30 2X2   6005593.39843 2104652.72108 37.759291793936896 -122.423715061076 (37.7592917939369, -122.423715061076) 2 4 5 28859 19
846 100983 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 43 2190 Powell St 4 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW 3     3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169) 3 1 10 308 23
847 100984 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 43 2190 Powell St 5 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW 3     3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169) 3 1 10 308 23
849 100987 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 43 2190 Powell St 8 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW 3     3x3   6009638.6 2121046.2 37.8045319114054 -122.41088257168998 (37.8045319114054, -122.41088257169) 3 1 10 308 23
851 10099 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 43 750 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   05/22/1995 12:00:00 AM 30 2x2   6005606.10854 2104557.89173 37.7590321322447 -122.423664360924 (37.7590321322447, -122.423664360924) 2 4 5 28859 19
859 10100 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 43 750 Guerrero St 2 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   05/22/1995 12:00:00 AM 40 2x2   6005607.26399 2104540.55602 37.758984597670896 -122.423659132264 (37.7589845976709, -122.423659132264) 2 4 5 28859 19
916 10106 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 43 785 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     12 2X2   6005679.329609999 2104414.6071 37.7586428391006 -122.42340094141399 (37.7586428391006, -122.423400941414) 2 4 5 28859 19
953 10111 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 43 817 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     6 2x2   6005691.67507 2104204.22323 37.758065870971706 -122.423343289458 (37.7580658709717, -122.423343289458) 2 4 5 28859 19
974 10113 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 43 827 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     3 3X3   6005696.52511 2104103.91625 37.757790725171 -122.423319385483 (37.757790725171, -122.423319385483) 2 4 5 28859 19
985 10114 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 43 827 Guerrero St 2 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     12 3x3   6005696.25247 2104120.31934 37.7578357488369 -122.423321494416 (37.7578357488369, -122.423321494416) 2 4 5 28859 19
996 10115 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 43 827 Guerrero St 3 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     3 3x3   6005698.17392 2104144.57278 37.75790245155879 -122.42331657330901 (37.7579024515588, -122.423316573309) 2 4 5 28859 19
1018 10117 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 43 845 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     12 3X3   6005699.222580001 2104067.01691 37.757689560440795 -122.42330743349301 (37.7576895604408, -122.423307433493) 2 4 5 28859 19
1029 10118 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 43 845 Guerrero St 2 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   02/01/1990 12:00:00 AM 3 3X3   6005704.2510557 2104056.9285895 37.7576621440613 -122.423289325813 (37.7576621440613, -122.423289325813) 2 4 5 28859 19
1040 10119 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 43 850 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   07/06/1992 12:00:00 AM 18 3X3   6005631.880167 2104012.3184419 37.757535570368 -122.423536442741 (37.757535570368, -122.423536442741) 2 4 5 28859 19
1229 10140 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 43 906 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   01/19/1991 12:00:00 AM 8 2x2   6005653.96599 2103626.9979 37.7564788166491 -122.423432668582 (37.7564788166491, -122.423432668582) 2 4 5 28859 19
1240 10141 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 43 906 Guerrero St 2 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     12 2x2   6005654.69613 2103615.0906 37.7564461631881 -122.423429297021 (37.7564461631881, -122.423429297021) 2 4 5 28859 19
1250 10142 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 43 915 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     6 2x2   6005723.61297 2103645.6305400003 37.7565339082426 -122.42319312877599 (37.7565339082426, -122.423193128776) 2 4 5 28859 19
1435 101623 Permitted Site 2 Prunus cerasifera :: Cherry Plum 43 80 Homestead St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 11/05/2012 12:00:00 AM   4x4 Permit Number 769409 6000945.5 2101263.6 37.749722620490395 -122.43954675389901 (37.7497226204904, -122.439546753899) 2 4 5 28862 22
1476 10167 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 43 1021 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     12 2X2   6005764.985230001 2102811.5808900003 37.7542461363638 -122.422990770503 (37.7542461363638, -122.422990770503) 2 4 5 28859 19
1498 101694 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 43 265X Stanyan St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     1 3x3   5996668.18061 2111006.52263 37.7762298334399 -122.45504173762698 (37.7762298334399, -122.455041737627) 11 6 2 54 16
1499 101695 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 43 265X Stanyan St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3 3x3   5996669.11429 2110994.57124 37.7761970716147 -122.455037643993 (37.7761970716147, -122.455037643993) 11 6 2 54 16
1662 10193 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 43 1170 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     10 2x2   6005736.259869999 2102154.58599 37.752440559408896 -122.42304341594699 (37.7524405594089, -122.423043415947) 2 4 5 28859 19
1743 102021 Permitted Site 2 Prunus cerasifera :: Cherry Plum 43 139 Saturn St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     8 3x3   5999859.0 2105985.0 37.7626245310548 -122.443643035925 (37.7626245310548, -122.443643035925) 15 5 5 28862 3
1766 102045 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 43 2853 Vallejo St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     8 1x1 Permit Number 769645 5999896.35932 2117404.6933 37.7939822160532 -122.444334525426 (37.7939822160532, -122.444334525426) 13 9 1 57 27
1768 102047 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 43 2853 Vallejo St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     8 1x1 Permit Number 769645 5999920.96714 2117404.7453400004 37.7939837628837 -122.444249383927 (37.7939837628837, -122.444249383927) 13 9 1 57 27
1806 102085 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 43 475 20th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 07/09/2009 12:00:00 AM 4   Permit Number 52516 5989662.20818 2112129.83383 37.7789097231702 -122.47935923836599 (37.7789097231702, -122.479359238366) 11 6 2 55 26
1817 10210 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 43 1306 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   06/02/1992 12:00:00 AM 18 2X2   6005782.73241 2101317.8159 37.7501456037461 -122.42282324301901 (37.7501456037461, -122.422823243019) 2 4 5 28859 19
1875 102164 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 43 152 Venus St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     10 3x3   6012823.11721 2094145.77539 37.730847417966 -122.397973948736 (37.730847417966, -122.397973948736) 10 3 8 58 1
1965 10225 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 43 1399 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     12 3X3   6005877.37579 2100867.12021 37.748913436323704 -122.422463939564 (37.7489134363237, -122.422463939564) 2 4 5 28859 19
2084 102377 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 43 870 39th Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Rec/Park 3     3     5983889.8768 2109995.31333 37.7727119887219 -122.49916995510901 (37.7727119887219, -122.499169955109) 11 6 2 55 26
2085 102378 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 43 870 39th Ave 4 Sidewalk: Curb side : Cutout 2 Tree 1 Rec/Park 3     2     5983886.84831 2110037.48525 37.7728276030319 -122.499183547509 (37.7728276030319, -122.499183547509) 11 6 2 55 26
2329 102628 Permitted Site 2 Prunus cerasifera :: Cherry Plum 43 100 Freelon St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 02/07/2013 12:00:00 AM   3x3 Permit Number 769972 6013417.4 2111578.2 37.778746166691 -122.397141295625 (37.778746166691, -122.397141295625) 6 2 9 28856 34
2470 102782 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 43 2485 Union St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     6 3x3   6001163.50399 2118281.2047900003 37.7964611010649 -122.44001296732 (37.7964611010649, -122.44001296732) 13 9 1 57 17
2653 102986 Permitted Site 2 Prunus cerasifera :: Cherry Plum 43 1459 Willard St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   03/14/2013 12:00:00 AM   3x3 Permit Number 769945 5996811.8 2106244.7 37.763163336042794 -122.45420090344 (37.7631633360428, -122.45420090344) 15 5 11 29492 12
2656 102989 Permitted Site 2 Prunus cerasifera :: Cherry Plum 43 161 Edgewood Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/24/2015 12:00:00 AM   3x3   5996558.2 2106100.3 37.762752304882895 -122.45506758085199 (37.7627523048829, -122.455067580852) 15 5 11 29492 12
2658 102990 Permitted Site 2 Prunus cerasifera :: Cherry Plum 43 161 Edgewood Ave 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/24/2015 12:00:00 AM   3x3   5996558.2 2106100.3 37.762752304882895 -122.45506758085199 (37.7627523048829, -122.455067580852) 15 5 11 29492 12
3251 103621 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 43 3982 Sacramento St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   12/11/2013 12:00:00 AM 12 3x3 Permit Number 771038 5995737.809859999 2114868.57006 37.7867805691894 -122.458539756662 (37.7867805691894, -122.458539756662) 11 6 1 54 31
3576 103959 Undocumented 3 Prunus cerasifera :: Cherry Plum 43 460X Lily St 1 unknown : Pot 16 Tree 1 Private 2           6004484.08045 2109981.44374 37.773860502373 -122.427931334456 (37.773860502373, -122.427931334456) 7 9 11 28852 10
3977 104476 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 43 350X Pacific Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   10/09/2013 12:00:00 AM 3 3x3 Permit Number 767241 6012304.0596 2118478.64735 37.7976311307414 -122.401477889986 (37.7976311307414, -122.401477889986) 3 1 10 28860 6
3978 104477 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 43 350X Pacific Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   10/09/2013 12:00:00 AM 3 3x3 Permit Number 767241 6012286.1108800005 2118476.9378299997 37.7976254353175 -122.401539877573 (37.7976254353175, -122.401539877573) 3 1 10 28860 6
3995 104496 Undocumented 3 Prunus cerasifera :: Cherry Plum 43 825 Shrader St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       6x6   5997621.0 2107726.0 37.76727697855971 -122.45150901605899 (37.7672769785597, -122.451509016059) 15 5 11 29492 9
4645 105252 Permitted Site 2 Prunus cerasifera :: Cherry Plum 43 1875 Union St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2         Permit Number 770851 6004061.8803 2118683.0933 37.7977291534815 -122.43001264475201 (37.7977291534815, -122.430012644752) 13 9 1 57 17
4672 105287 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 43 2567 Union St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     10 3x3 Permit Number 770757 6000732.18991 2118218.3862900003 37.796264055100295 -122.441500892961 (37.7962640551003, -122.441500892961) 13 9 1 57 17
4673 105288 Undocumented 3 Prunus cerasifera :: Cherry Plum 43 2567 Union St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6000728.1 2118193.8 37.7961963146182 -122.441513279672 (37.7961963146182, -122.441513279672) 13 9 1 57 17
5393 106161 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 43 827 North Point St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   03/31/2014 12:00:00 AM 3 3x3 Permit Number 770049 6006757.57528 2121490.3236599998 37.8055893943007 -122.42088419136499 (37.8055893943007, -122.420884191365) 5 1 1 28858 32
5927 106848 Undocumented 3 Prunus cerasifera :: Cherry Plum 43 2637 Pierce St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       6x9   6001627.0 2117446.0 37.7941942213429 -122.43834930801701 (37.7941942213429, -122.438349308017) 13 9 1 57 27
5932 106859 Undocumented 3 Prunus cerasifera :: Cherry Plum 43 946 RHODE ISLAND ST   Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   12/02/2015 12:00:00 AM 14 3x3 Permit Number 773008 6011839.2 2104029.4 37.7579308843014 -122.402070102772 (37.7579308843014, -122.402070102772) 10 3 8 28856 29
6026 106947 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 43 2710 Baker St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/02/2014 12:00:00 AM 1 3x3   5999608.44981 2118168.47191 37.796062919022205 -122.445385661119 (37.7960629190222, -122.445385661119) 13 9 1 57 17
6027 106948 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 43 2710 Baker St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/02/2014 12:00:00 AM 1 3x3   5999606.41459 2118186.75395 37.7961130004661 -122.445394018543 (37.7961130004661, -122.445394018543) 13 9 1 57 17
6589 107635 Significant Tree 4 Prunus cerasifera :: Cherry Plum 43 1150 Lombard St 10 Front Yard : Yard 4 Tree 1 Private 2   10/01/2014 12:00:00 AM 3   Permit Number 773092 6006825.00646 2120436.80144 37.8027004912885 -122.42057600387301 (37.8027004912885, -122.420576003873) 5 1 1 28858 32
7090 108204 Undocumented 3 Prunus cerasifera :: Cherry Plum 43 1192 Page St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6000914.97169 2109351.778 37.7719290371123 -122.440232269589 (37.7719290371123, -122.440232269589) 15 5 11 29492 9
7091 108205 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 43 1192 Page St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   12/03/2014 12:00:00 AM 3   Permit Number 774208 6000914.97169 2109351.778 37.7719290371123 -122.440232269589 (37.7719290371123, -122.440232269589) 15 5 11 29492 9
7092 108206 Undocumented 3 Prunus cerasifera :: Cherry Plum 43 1192 Page St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6000914.97169 2109351.778 37.7719290371123 -122.440232269589 (37.7719290371123, -122.440232269589) 15 5 11 29492 9
7363 108485 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 43 41 Langton St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     6 3x3   6009911.00607 2111023.57735 37.7770274800675 -122.40923218641599 (37.7770274800675, -122.409232186416) 8 2 9 28853 34
7441 108559 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 43 247 Theresa St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/24/2014 12:00:00 AM 3 3x3 Permit Number 773718 6001785.96966 2094072.85918 37.7300263216596 -122.43612587350701 (37.7300263216596, -122.436125873507) 9 7 6 28861 25
7845 108944 Permitted Site 2 Prunus cerasifera :: Cherry Plum 43 105 Richland Ave 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   01/15/2015 12:00:00 AM 3 4x4 Permit Number 772521 6005294.9 2096235.5 37.7361631827636 -122.424148798432 (37.7361631827636, -122.424148798432) 2 7 7 28859 2
8226 109320 Undocumented 3 Prunus cerasifera :: Cherry Plum 43 3110 23RD ST 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/02/2015 12:00:00 AM 7 3x3   6008224.7 2102742.2 37.7541941223175 -122.414479525681 (37.7541941223175, -122.414479525681) 2 4 7 28859 19
8281 109381 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 43 11 17th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     2 3x3   5990493.41695 2114971.95587 37.7867616423246 -122.476691486324 (37.7867616423246, -122.476691486324) 11 6 1 55 33
8454 109597 Permitted Site 2 Prunus cerasifera :: Cherry Plum 43 1050 South Van Ness Ave 8 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6007567.1 2103584.6 37.756470195368294 -122.416813352731 (37.7564701953683, -122.416813352731) 2 4 7 28859 19
8455 109598 Permitted Site 2 Prunus cerasifera :: Cherry Plum 43 1050 South Van Ness Ave 9 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6007567.1 2103584.6 37.756470195368294 -122.416813352731 (37.7564701953683, -122.416813352731) 2 4 7 28859 19
8828 110146 Undocumented 3 Prunus cerasifera :: Cherry Plum 43 64 WOODLAND AVE 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     7 3x15   5997139.6 2106104.1 37.76279607600021 -122.45305700914801 (37.7627960760002, -122.453057009148) 15 5 11 29492 12
8832 110150 Permitted Site 2 Prunus cerasifera :: Cherry Plum 43 101 Woodland Ave 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     20     5997047.9 2105929.4 37.762311138426206 -122.45336155194201 (37.7623111384262, -122.453361551942) 15 5 11 29492 12
8833 110151 Undocumented 3 Prunus cerasifera :: Cherry Plum 43 87 WOODLAND AVE 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     5 3x3   5997070.7 2106047.1 37.76263561957521 -122.45329119340201 (37.7626356195752, -122.453291193402) 15 5 11 29492 12
8834 110152 Undocumented 3 Prunus cerasifera :: Cherry Plum 43 87 WOODLAND AVE 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     7 3x3   5997070.7 2106047.1 37.76263561957521 -122.45329119340201 (37.7626356195752, -122.453291193402) 15 5 11 29492 12
8880 110203 Undocumented 3 Prunus cerasifera :: Cherry Plum 43 82 POTOMAC ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6003128.3 2108821.4 37.770598514051706 -122.432538320625 (37.7705985140517, -122.432538320625) 15 5 5 29492 9
8947 110275 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 43 2612 Scott St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/08/2016 12:00:00 AM 3   Permit Number 778382 6001183.56283 2117454.33561 37.794191876798 -122.43988424377 (37.794191876798, -122.43988424377) 13 9 1 57 27
9622 111025 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 43 699x 36th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3 3x3   5984730.84558 2111224.06012 37.7761350733047 -122.496351676847 (37.7761350733047, -122.496351676847) 11 6 2 55 26
9672 111070 Significant Tree 4 Prunus cerasifera :: Cherry Plum 43 1836 08TH AVE 2 Front Yard : Cutout 10 Tree 1 Private 2     2 3x15   5993799.0 2102987.0 37.7540453100112 -122.464384550175 (37.7540453100112, -122.464384550175) 1 8 4 56 12
9714 111111 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 43 274 Shipley St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     1 3x3   6011331.28551 2111595.46543 37.7786772198139 -122.404359235093 (37.7786772198139, -122.404359235093) 14 2 9 28856 34
9896 111292 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 43 291 14th Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2   4     5991505.832330001 2113494.12901 37.78276261074429 -122.47308099011002 (37.7827626107443, -122.47308099011) 11 6 2 54 26
9955 111368 Undocumented 3 Prunus cerasifera :: Cherry Plum 43 24 MELROSE AVE 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     5 3x3   5999942.0 2095537.0 37.7339415754871 -122.44260576857599 (37.7339415754871, -122.442605768576) 9 7 4 63 40
10445 111962 Undocumented 3 Prunus cerasifera :: Cherry Plum 43 100x PROSPECT AVE 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     12 6x9   6006854.0 2098911.0 37.74359741722861 -122.418948043759 (37.7435974172286, -122.418948043759) 2 7 7 28859 2
10446 111963 Undocumented 3 Prunus cerasifera :: Cherry Plum 43 100x PROSPECT AVE 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     12 6x9   6006854.0 2098911.0 37.74359741722861 -122.418948043759 (37.7435974172286, -122.418948043759) 2 7 7 28859 2
10548 112099 Permitted Site 2 Prunus cerasifera :: Cherry Plum 43 200X RICHLAND AVE 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2   6     6006012.0 2096107.0 37.7358508133721 -122.421660362723 (37.7358508133721, -122.421660362723) 2 7 7 28859 2
10551 112100 Permitted Site 2 Prunus cerasifera :: Cherry Plum 43 200X RICHLAND AVE 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2   10     6006012.0 2096107.0 37.7358508133721 -122.421660362723 (37.7358508133721, -122.421660362723) 2 7 7 28859 2
10552 112101 Permitted Site 2 Prunus cerasifera :: Cherry Plum 43 200X RICHLAND AVE 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2   4     6006012.0 2096107.0 37.7358508133721 -122.421660362723 (37.7358508133721, -122.421660362723) 2 7 7 28859 2
10553 112102 Permitted Site 2 Prunus cerasifera :: Cherry Plum 43 200X RICHLAND AVE 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2   5     6006012.0 2096107.0 37.7358508133721 -122.421660362723 (37.7358508133721, -122.421660362723) 2 7 7 28859 2
10819 112368 Section 143 6 Prunus cerasifera :: Cherry Plum 43 550 Jessie St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/24/2015 12:00:00 AM 3 3x3   6009683.8 2112475.6 37.7810016601266 -122.410120702727 (37.7810016601266, -122.410120702727) 14 2 9 28853 34
10820 112369 Section 143 6 Prunus cerasifera :: Cherry Plum 43 550 Jessie St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/24/2015 12:00:00 AM 3 3x3   6009683.8 2112475.6 37.7810016601266 -122.410120702727 (37.7810016601266, -122.410120702727) 14 2 9 28853 34
10822 112370 Section 143 6 Prunus cerasifera :: Cherry Plum 43 550 Jessie St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/24/2015 12:00:00 AM 3 3x3   6009683.8 2112475.6 37.7810016601266 -122.410120702727 (37.7810016601266, -122.410120702727) 14 2 9 28853 34
10823 112371 Section 143 6 Prunus cerasifera :: Cherry Plum 43 550 Jessie St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/24/2015 12:00:00 AM 3 3x3   6009683.8 2112475.6 37.7810016601266 -122.410120702727 (37.7810016601266, -122.410120702727) 14 2 9 28853 34

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" REAL,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" REAL,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT,
  "Fire Prevention Districts" INTEGER,
  "Police Districts" INTEGER,
  "Supervisor Districts" INTEGER,
  "Zip Codes" INTEGER,
  "Neighborhoods" INTEGER
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id))
Powered by Datasette · Query took 198.215ms · Data source: data.sfgov.org