trees

268 rows where qSpecies_id = 77 sorted by DBH

✎ View and edit SQL

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)
3654 47498 Permitted Site 7 Prunus x yedoensis :: Yoshino Cherry 77 2550 Lyon St 13 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/14/2002 12:00:00 AM     Permit Number 45389 5999248.3915837 2117560.95181211 37.7943742700193 -122.446587797735 (37.7943742700193, -122.446587797735) 13 9 1 57 27
14337 47497 Permitted Site 7 Prunus x yedoensis :: Yoshino Cherry 77 2550 Lyon St 14 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/14/2002 12:00:00 AM     Permit Number 45389 5999248.3915837 2117560.95181211 37.7943742700193 -122.446587797735 (37.7943742700193, -122.446587797735) 13 9 1 57 27
21481 41610 Permitted Site 7 Prunus x yedoensis :: Yoshino Cherry 77 3338 17th St 4 Sidewalk: Curb side : Cutout Tree Private 2   06/01/2000 12:00:00 AM     Permit Number 42107 6006559.89893522 2106145.26349714 37.7634444777116 -122.420478371661 (37.7634444777116, -122.420478371661) 8 4 7 28859 19
24773 98036 Permitted Site 7 Prunus x yedoensis :: Yoshino Cherry 77 2242 Steiner St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/05/2011 12:00:00 AM     Permit Number 768378 6002381.4 2115984.8 37.7902250230638 -122.43563441767 (37.7902250230638, -122.43563441767) 13 9 1 29490 27
37380 47499 Permitted Site 7 Prunus x yedoensis :: Yoshino Cherry 77 2550 Lyon St 12 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/14/2002 12:00:00 AM     Permit Number 45389 5999248.3915837 2117560.95181211 37.7943742700193 -122.446587797735 (37.7943742700193, -122.446587797735) 13 9 1 57 27
41965 47508 Permitted Site 7 Prunus x yedoensis :: Yoshino Cherry 77 2550 Lyon St 8 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/14/2002 12:00:00 AM     Permit Number 45389 5999248.3915837 2117560.95181211 37.7943742700193 -122.446587797735 (37.7943742700193, -122.446587797735) 13 9 1 57 27
43615 114880 Permitted Site 7 Prunus x yedoensis :: Yoshino Cherry 77 1687 Alabama St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/17/2015 12:00:00 AM   3x3   6009362.4 2099644 37.7457510020701 -122.4103263211 (37.7457510020701, -122.4103263211) 2 7 7 28859 2
55306 47505 Permitted Site 7 Prunus x yedoensis :: Yoshino Cherry 77 2550 Lyon St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/14/2002 12:00:00 AM     Permit Number 45389 5999248.3915837 2117560.95181211 37.7943742700193 -122.446587797735 (37.7943742700193, -122.446587797735) 13 9 1 57 27
60987 47504 Permitted Site 7 Prunus x yedoensis :: Yoshino Cherry 77 2550 Lyon St 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/14/2002 12:00:00 AM     Permit Number 45389 5999248.3915837 2117560.95181211 37.7943742700193 -122.446587797735 (37.7943742700193, -122.446587797735) 13 9 1 57 27
62744 47503 Permitted Site 7 Prunus x yedoensis :: Yoshino Cherry 77 2550 Lyon St 6 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/14/2002 12:00:00 AM     Permit Number 45389 5999248.3915837 2117560.95181211 37.7943742700193 -122.446587797735 (37.7943742700193, -122.446587797735) 13 9 1 57 27
64342 35854 Permitted Site 7 Prunus x yedoensis :: Yoshino Cherry 77 142 Russia Ave 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/02/1998 12:00:00 AM     Permit Number 39074 6001729.76297614 2090780.38588209 37.7209827425077 -122.436084672938 (37.7209827425077, -122.436084672938) 9 7 6 28861 5
69930 57837 Permitted Site 7 Prunus x yedoensis :: Yoshino Cherry 77 1339 05th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/13/2009 12:00:00 AM   3x3 Permit Number 52005 5994540.33028408 2106409.85629846 37.763486295989 -122.46206907635 (37.763486295989, -122.46206907635) 1 5 11 56 12
80871 46546 Permitted Site 7 Prunus x yedoensis :: Yoshino Cherry 77 637 Natoma St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/01/2002 12:00:00 AM     Permit Number 44689 6009489.66445837 2111279.62627541 37.7777069157879 -122.410707830593 (37.7777069157879, -122.410707830593) 8 2 9 28853 34
83140 41607 Permitted Site 7 Prunus x yedoensis :: Yoshino Cherry 77 3338 17th St 3 Sidewalk: Curb side : Cutout Tree Private 2   06/01/2000 12:00:00 AM     Permit Number 42107 6006559.89893522 2106145.26349714 37.7634444777116 -122.420478371661 (37.7634444777116, -122.420478371661) 8 4 7 28859 19
84425 41604 Permitted Site 7 Prunus x yedoensis :: Yoshino Cherry 77 3338 17th St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/01/2000 12:00:00 AM     Permit Number 42107 6006559.89893522 2106145.26349714 37.7634444777116 -122.420478371661 (37.7634444777116, -122.420478371661) 8 4 7 28859 19
101900 47502 Permitted Site 7 Prunus x yedoensis :: Yoshino Cherry 77 2550 Lyon St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/14/2002 12:00:00 AM     Permit Number 45389 5999248.3915837 2117560.95181211 37.7943742700193 -122.446587797735 (37.7943742700193, -122.446587797735) 13 9 1 57 27
104730 47500 Permitted Site 7 Prunus x yedoensis :: Yoshino Cherry 77 2550 Lyon St 11 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/14/2002 12:00:00 AM     Permit Number 45389 5999248.3915837 2117560.95181211 37.7943742700193 -122.446587797735 (37.7943742700193, -122.446587797735) 13 9 1 57 27
125981 47506 Permitted Site 7 Prunus x yedoensis :: Yoshino Cherry 77 2550 Lyon St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/14/2002 12:00:00 AM     Permit Number 45389 5999248.3915837 2117560.95181211 37.7943742700193 -122.446587797735 (37.7943742700193, -122.446587797735) 13 9 1 57 27
130605 35852 Permitted Site 7 Prunus x yedoensis :: Yoshino Cherry 77 142 Russia Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/02/1998 12:00:00 AM     Permit Number 39074 6001729.76297614 2090780.38588209 37.7209827425077 -122.436084672938 (37.7209827425077, -122.436084672938) 9 7 6 28861 5
132173 85064 Permitted Site 7 Prunus x yedoensis :: Yoshino Cherry 77 57 Elizabeth St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/05/2007 12:00:00 AM     Permit Number 49430 6005948 2102270 37.7527694058254 -122.422319381816 (37.7527694058254, -122.422319381816) 2 4 5 28859 19
134097 47496 Permitted Site 7 Prunus x yedoensis :: Yoshino Cherry 77 2550 Lyon St 7 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/14/2002 12:00:00 AM     Permit Number 45389 5999248.3915837 2117560.95181211 37.7943742700193 -122.446587797735 (37.7943742700193, -122.446587797735) 13 9 1 57 27
137712 35083 Permitted Site 7 Prunus x yedoensis :: Yoshino Cherry 77 1541 12th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/12/2001 12:00:00 AM     Permit Number 43889 5992419.71878294 2104964.13539049 37.7593944056925 -122.46929829243 (37.7593944056925, -122.46929829243) 1 8 4 56 12
139200 44049 Permitted Site 7 Prunus x yedoensis :: Yoshino Cherry 77 3388 17th St 3 Sidewalk: Curb side : Cutout Tree Private 2   10/19/2000 12:00:00 AM     Permit Number 43579 6006265.44420171 2106129.68857398 37.7633851144388 -122.421495691304 (37.7633851144388, -122.421495691304) 8 4 7 28859 19
143199 44048 Permitted Site 7 Prunus x yedoensis :: Yoshino Cherry 77 3388 17th St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/19/2000 12:00:00 AM     Permit Number 43579 6006265.44420171 2106129.68857398 37.7633851144388 -122.421495691304 (37.7633851144388, -122.421495691304) 8 4 7 28859 19
147009 41609 Permitted Site 7 Prunus x yedoensis :: Yoshino Cherry 77 3338 17th St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/01/2000 12:00:00 AM     Permit Number 42107 6006559.89893522 2106145.26349714 37.7634444777116 -122.420478371661 (37.7634444777116, -122.420478371661) 8 4 7 28859 19
147761 35082 Permitted Site 7 Prunus x yedoensis :: Yoshino Cherry 77 1541 12th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/12/2001 12:00:00 AM     Permit Number 43889 5992419.71878294 2104964.13539049 37.7593944056925 -122.46929829243 (37.7593944056925, -122.46929829243) 1 8 4 56 12
152123 43636 Permitted Site 7 Prunus x yedoensis :: Yoshino Cherry 77 375 Bartlett St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/24/2000 12:00:00 AM     Permit Number 43286 6006792.72953639 2101606.12998031 37.750994184096 -122.419351056484 (37.750994184096, -122.419351056484) 2 4 7 28859 19
169272 35855 Permitted Site 7 Prunus x yedoensis :: Yoshino Cherry 77 142 Russia Ave 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/02/1998 12:00:00 AM     Permit Number 39074 6001729.76297614 2090780.38588209 37.7209827425077 -122.436084672938 (37.7209827425077, -122.436084672938) 9 7 6 28861 5
169847 47509 Permitted Site 7 Prunus x yedoensis :: Yoshino Cherry 77 2550 Lyon St 9 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/14/2002 12:00:00 AM     Permit Number 45389 5999248.3915837 2117560.95181211 37.7943742700193 -122.446587797735 (37.7943742700193, -122.446587797735) 13 9 1 57 27
172511 47507 Permitted Site 7 Prunus x yedoensis :: Yoshino Cherry 77 2550 Lyon St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/14/2002 12:00:00 AM     Permit Number 45389 5999248.3915837 2117560.95181211 37.7943742700193 -122.446587797735 (37.7943742700193, -122.446587797735) 13 9 1 57 27
186374 46545 Permitted Site 7 Prunus x yedoensis :: Yoshino Cherry 77 637 Natoma St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/01/2002 12:00:00 AM     Permit Number 44689 6009489.66445837 2111279.62627541 37.7777069157879 -122.410707830593 (37.7777069157879, -122.410707830593) 8 2 9 28853 34
188992 44050 Permitted Site 7 Prunus x yedoensis :: Yoshino Cherry 77 3388 17th St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/19/2000 12:00:00 AM     Permit Number 43579 6006265.44420171 2106129.68857398 37.7633851144388 -122.421495691304 (37.7633851144388, -122.421495691304) 8 4 7 28859 19
191629 47501 Permitted Site 7 Prunus x yedoensis :: Yoshino Cherry 77 2550 Lyon St 10 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/14/2002 12:00:00 AM     Permit Number 45389 5999248.3915837 2117560.95181211 37.7943742700193 -122.446587797735 (37.7943742700193, -122.446587797735) 13 9 1 57 27
4262 213721 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 66x Santa Monica Way 2 Median : Yard Tree DPW 1     1     5993647.57824 2097426.08398 37.7387677148629 -122.464504452814 (37.7387677148629, -122.464504452814) 1 8 4 59 40
17624 120418 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 779 23rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   5988805.2712 2110017.74707 37.7730607113316 -122.482168912555 (37.7730607113316, -122.482168912555) 11 6 2 55 26
24045 141370 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 430 BRODERICK ST 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   6001204.6932 2110218.0701 37.7743241488087 -122.439292208301 (37.7743241488087, -122.439292208301) 15 5 11 29492 10
25428 238585 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 73 Fair Oaks St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   6005403.58671 2103307.08135 37.7555862656019 -122.424275817175 (37.7555862656019, -122.424275817175) 2 4 5 28859 19
29597 238598 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 51 Julian Ave 7 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 5ft   6006428.46561 2107477.24993 37.7670943907258 -122.421027537902 (37.7670943907258, -122.421027537902) 8 4 7 28853 19
30515 238584 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 73 Fair Oaks St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   6005403.70836 2103296.31784 37.7555567183818 -122.42427463098 (37.7555567183818, -122.42427463098) 2 4 5 28859 19
33456 239029 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 26 Harry St 8 Sidewalk: Property side : Yard Tree Private 2     1 Width 8ft   6003326.30087 2097748.91757 37.7402073325128 -122.431063031234 (37.7402073325128, -122.431063031234) 2 7 5 63 7
36420 124156 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 970 Anza St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   5995846.07339 2112226.83412 37.7795332890719 -122.457973944713 (37.7795332890719, -122.457973944713) 11 6 2 54 16
39652 124172 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 81 Almaden Ct 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   5995886.79128 2112251.90704 37.7796044719959 -122.457834899878 (37.7796044719959, -122.457834899878) 11 6 2 54 16
43319 239004 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 1299 York St 3 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6010075.23485 2101730.69719 37.751520546657 -122.40800856074 (37.751520546657, -122.40800856074) 2 4 7 28859 19
46845 238593 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 51 Julian Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 5ft   6006434.12493 2107338.12771 37.7667127130356 -122.420998084205 (37.7667127130356, -122.420998084205) 8 4 7 28853 19
51859 238588 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 1600 15th St 8 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 5ft   6006604.02075 2107329.38217 37.7666982753322 -122.420409821465 (37.7666982753322, -122.420409821465) 8 4 7 28853 19
51956 196545 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 938 Rhode Island St 1 : Tree Private 2     1 Width 4ft   6011854.06587 2104027.62304 37.7579268348784 -122.402018565106 (37.7579268348784, -122.402018565106) 10 3 8 28856 29
57891 196540 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 1751 17th St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6012078.91363 2106521.10785 37.7647859371415 -122.401416175823 (37.7647859371415, -122.401416175823) 14 3 8 28856 29
60025 124684 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 3899 Jackson St 2 Sidewalk: Property side : Yard Tree Private 2     1 Width 8ft   5995566.4285 2115772.64492 37.7892530636592 -122.459198183151 (37.7892530636592, -122.459198183151) 11 6 1 54 31
63795 124683 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 3899 Jackson St 3 Sidewalk: Property side : Yard Tree Private 2     1 Width 8ft   5995553.12452 2115771.60073 37.7892494317403 -122.459244137371 (37.7892494317403, -122.459244137371) 11 6 1 54 31
75784 82345 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 254 Dublin St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2016 12:00:00 AM 1 3x3 Permit Number 774176 6003940.30685 2088972.31262 37.7161435078943 -122.428314680584 (37.7161435078943, -122.428314680584) 9 7 6 28861 5
79691 124155 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 970 Anza St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   5995858.43793 2112228.39454 37.7795382839593 -122.457931283713 (37.7795382839593, -122.457931283713) 11 6 2 54 16
80849 238589 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 1600 15th St 9 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 5ft   6006580.76101 2107327.1643 37.7666908748181 -122.420490115647 (37.7666908748181, -122.420490115647) 8 4 7 28853 19
96537 239010 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 60 Peralta Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6010651.97236 2100432.84922 37.747989214748 -122.405922704693 (37.747989214748, -122.405922704693) 2 7 7 28859 2
99570 114197 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 1701x 17th St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 3x3   6012196.35096 2106527.32725 37.7648095659429 -122.4010104251 (37.7648095659429, -122.4010104251) 14 3 8 28856 29
113302 238592 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 1600 15th St 12 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 5ft   6006502.41381 2107324.73135 37.7666797789728 -122.420760932989 (37.7666797789728, -122.420760932989) 8 4 7 28853 19
121757 238594 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 51 Julian Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 5ft   6006432.46991 2107376.01737 37.7668166557888 -122.421006499155 (37.7668166557888, -122.421006499155) 8 4 7 28853 19
129057 238591 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 1600 15th St 11 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 5ft   6006521.80542 2107326.31519 37.7666852207654 -122.420693973056 (37.7666852207654, -122.420693973056) 8 4 7 28853 19
136463 213720 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 398 San Leandro Way 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   5992203.97011 2094317.89279 37.7301500773614 -122.469269557468 (37.7301500773614, -122.469269557468) 9 8 4 59 40
138650 239009 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 60 Peralta Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6010637.01006 2100427.5195 37.7479737436878 -122.405974068569 (37.7479737436878, -122.405974068569) 2 7 7 28859 2
140257 114200 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 1701x 17th St 4 Sidewalk: Curb side : Cutout Tree Private 2     1 3x3   6012241.34164 2106528.09119 37.7648141731694 -122.400854866677 (37.7648141731694, -122.400854866677) 14 3 8 28856 29
140665 246630 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 3320 Harrison St 1 Front Yard : Yard Tree Private 2     1     6009028.43524 2099278.75412 37.7447293908617 -122.411455327621 (37.7447293908617, -122.411455327621) 2 7 7 28859 2
143442 141371 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 430 BRODERICK ST 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   6001203.2035 2110227.5052 37.7743499704497 -122.439298037861 (37.7743499704497, -122.439298037861) 15 5 11 29492 10
152029 123081 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 756 12th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 4ft   5992285.07246 2110293.11916 37.7740185941965 -122.470152007973 (37.7740185941965, -122.470152007973) 11 6 2 54 11
154619 114678 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 726 Brussels St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/01/2015 12:00:00 AM 1   Permit Number 774712 6011027.75702 2091361.80007 37.7231030455441 -122.40398499124 (37.7231030455441, -122.40398499124) 10 3 7 309 28
162237 238597 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 51 Julian Ave 6 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 5ft   6006428.61387 2107454.83624 37.7670328563946 -122.421025433495 (37.7670328563946, -122.421025433495) 8 4 7 28853 19
168356 238590 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 1600 15th St 10 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 5ft   6006558.68339 2107326.24442 37.7666871048439 -122.420566413202 (37.7666871048439, -122.420566413202) 8 4 7 28853 19
170138 239019 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 539 Hickory St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6004833.64681 2110391.58665 37.7750064246485 -122.426751340518 (37.7750064246485, -122.426751340518) 7 9 11 28852 10
180974 239003 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 2392 Bryant St 1 Sidewalk: Curb side : Yard Tree Private 2     1 Width 6ft   6009661.58461 2103420.7224 37.7561378099155 -122.409558287803 (37.7561378099155, -122.409558287803) 2 4 7 28859 19
181473 46559 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 2631 23rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/02/2002 12:00:00 AM 1   Permit Number 44696 5989232.26129309 2097435.52728728 37.7385381283555 -122.479771060435 (37.7385381283555, -122.479771060435) 1 8 3 29491 35
187043 239011 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 54 Peralta Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6010666.51854 2100440.55381 37.7480111833878 -122.405872946996 (37.7480111833878, -122.405872946996) 2 7 7 28859 2
188738 238595 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 51 Julian Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 5ft   6006430.43554 2107395.44142 37.7668698749586 -122.421014915008 (37.7668698749586, -122.421014915008) 8 4 7 28853 19
189062 238596 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 51 Julian Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 5ft   6006429.49363 2107423.62513 37.7669472076635 -122.421020174242 (37.7669472076635, -122.421020174242) 8 4 7 28853 19
15965 136043 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 3425 Jackson St 2 Sidewalk: Curb side : Yard Tree Private 2     10 Width 4ft   5997844.87788 2116098.17267 37.7902776009696 -122.451338548042 (37.7902776009696, -122.451338548042) 11 6 1 54 31
51211 122964 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 98 09th Ave 5 Sidewalk: Curb side : Yard Tree Private 2     10 Width 5ft   5993049.94359 2114912.63546 37.7867467201865 -122.467842267803 (37.7867467201865, -122.467842267803) 11 6 1 54 11
84016 196547 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 970 Wisconsin St 1 : Tree Private 2     10 Width 6ft   6012751.32394 2103003.67516 37.7551653352247 -122.398843585967 (37.7551653352247, -122.398843585967) 10 3 8 28856 29
94425 115309 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 500x Linden St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 2x2   6004961.03279 2110755.75124 37.776013533141 -122.426336618167 (37.776013533141, -122.426336618167) 7 9 11 28852 10
123301 249636 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 2400 Lyon St 2 Side Yard : Yard Tree Private 2     10     5999299.54264 2117085.08931 37.7930705993714 -122.446376560233 (37.7930705993714, -122.446376560233) 13 9 1 57 27
124046 44512 Permitted Site 7 Prunus x yedoensis :: Yoshino Cherry 77 131 Fairmount St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/26/2001 12:00:00 AM 10 4x4 Permit Number 43806 6004687.03371464 2097226.29740092 37.7388493482812 -122.426320962915 (37.7388493482812, -122.426320962915) 2 7 5 63 7
129753 238587 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 88 Hoff St 3 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6006547.66375 2106304.16095 37.763880083309 -122.420531969171 (37.763880083309, -122.420531969171) 8 4 7 28859 19
141006 120282 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 129 24th Ave 12 Front Yard : Yard Tree Private 2     10     5988304.19862 2115114.50046 37.7870258038912 -122.484276029631 (37.7870258038912, -122.484276029631) 11 6 1 55 33
145142 249664 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 2401 Lyon St 16 Front Yard : Yard Tree Private 2     10     5999241.54149 2117138.79958 37.7932147607016 -122.446581112841 (37.7932147607016, -122.446581112841) 11   1 57 30
182789 123365 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 770 04th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     10 Width 4ft   5994764.07466 2110395.82025 37.7744435874791 -122.461584226231 (37.7744435874791, -122.461584226231) 11 6 2 54 11
67698 249638 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 2400 Lyon St 5 Side Yard : Yard Tree Private 2     11     5999293.71803 2117149.90797 37.7932482415769 -122.446401378842 (37.7932482415769, -122.446401378842) 13 9 1 57 27
90248 249642 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 2460 Lyon St 2 Front Yard : Yard Tree Private 2     11     5999289.16084 2117209.34278 37.7934111735351 -122.446421424722 (37.7934111735351, -122.446421424722) 13 9 1 57 27
10454 106790 Undocumented 4 Prunus x yedoensis :: Yoshino Cherry 77 174 FAIRMOUNT ST 1 Sidewalk: Curb side : Cutout Tree Private 2     12 5x6   6004503.2 2097272.2 37.7389649933023 -122.426959842808 (37.7389649933023, -122.426959842808) 2 7 5 63 7
116012 249662 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 2401 Lyon St 14 Front Yard : Yard Tree Private 2     12     5999235.55005 2117182.17249 37.7933335089853 -122.446604965544 (37.7933335089853, -122.446604965544) 11   1 57 30
133564 249667 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 2401 Lyon St 19 Front Yard : Yard Tree Private 2     12     5999247.61227 2117079.36111 37.7930519051704 -122.446555829313 (37.7930519051704, -122.446555829313) 11   1 57 30
144554 28271 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 1227 Dolores St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 5   6005204.12074 2101185.69152 37.7497501565604 -122.424814719731 (37.7497501565604, -122.424814719731) 2 4 5 28859 19
22137 120283 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 139 24th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     13     5988317.15466 2115062.63745 37.786884157218 -122.484227400222 (37.786884157218, -122.484227400222) 11 6 1 55 33
119804 136040 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 55 Laurel St 7 Sidewalk: Curb side : Yard Tree Private 2     13 Width 5ft   5997963.88145 2116192.9912 37.7905447607719 -122.450933646298 (37.7905447607719, -122.450933646298) 11 6 1 54 31
102967 39863 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 55 Laurel St 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/06/1999 12:00:00 AM 14   Permit Number 41168 5997961.8347 2116210.86321 37.7905937153799 -122.450942017156 (37.7905937153799, -122.450942017156) 11 6 1 54 31
127095 32222 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 623 Precita Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/22/1995 12:00:00 AM 15   Permit Number 35543 6009718.6984 2100387.54672 37.7478125842885 -122.40914674543 (37.7478125842885, -122.40914674543) 2 7 7 28859 2
26278 239005 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 250 Fair Oaks St 2 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 5ft   6005423.80449 2102247.03404 37.7526767636284 -122.424130513718 (37.7526767636284, -122.424130513718) 2 4 5 28859 19
22259 31877 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 457 38th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   06/26/1995 12:00:00 AM 2   Permit Number 35315 5984054.95538 2112747.63581 37.7802787535999 -122.498802308795 (37.7802787535999, -122.498802308795) 11 6 2 55 26
30391 239020 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 482 Hickory St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 2ft   6004672.88732 2110370.92399 37.7749405996584 -122.427305970394 (37.7749405996584, -122.427305970394) 7 9 11 28852 10
32892 238578 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 149 Buchanan St 1 : Tree Private 2     2 Width 3ft   6004732.39628 2109051.52361 37.7713212124262 -122.427006123859 (37.7713212124262, -122.427006123859) 7 9 11 28852 10
48308 136039 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 3434 Broderick St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   5999787.69729 2120389.72868 37.8021721279018 -122.44492518757 (37.8021721279018, -122.44492518757) 13 9 1 57 17
54637 238586 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 991 San Bruno Ave 1 Sidewalk: Property side : Yard Tree Private 2     2 Width 6ft   6011096.08107 2103736.70014 37.7570856908704 -122.404619530365 (37.7570856908704, -122.404619530365) 10 4 8 28859 19
56628 196546 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 1017 Rhode Island St 1 : Tree Private 2     2 Width 3ft   6011946.26987 2103466.67493 37.7563917406915 -122.401660256322 (37.7563917406915, -122.401660256322) 10 3 8 28856 29
70516 123029 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 730 Funston Ave 2 Sidewalk: Curb side : Yard Tree Private 2     2 Width 3ft   5991968.39214 2110452.13533 37.7744368966539 -122.471259036935 (37.7744368966539, -122.471259036935) 11 6 2 54 11

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);