268 rows where qSpecies_id = 77 sorted by XCoord

View and edit SQL

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)
120741 31876 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 457 38th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/26/1995 12:00:00 AM 2   Permit Number 35315 5984053.55944 2112762.76101 37.7803202011246 -122.498808255642 (37.7803202011246, -122.498808255642) 11 6 2 55 26
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
120911 118028 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 51 Shore View Ave 1 Sidewalk: Curb side : Yard Tree Private 2     7 Width 4ft   5984316.15967 2112798.24876 37.780433038793 -122.49790243493 (37.780433038793, -122.49790243493) 11 6 2 55 26
116368 118026 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 51 Shore View Ave 3 Sidewalk: Curb side : Yard Tree Private 2     6 Width 4ft   5984344.44515 2112788.18454 37.780407063583 -122.49780384034 (37.780407063583, -122.49780384034) 11 6 2 55 26
183821 63200 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 450 36th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/08/2015 12:00:00 AM 3   Permit Number 775741 5984716.80521 2112828.61382 37.7805398924486 -122.496518676344 (37.7805398924486, -122.496518676344) 11 6 2 55 26
65368 50856 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 743 33rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/08/2004 12:00:00 AM 4   Permit Number 47371 5985677.37672 2110827.17931 37.7751007543065 -122.493048175392 (37.7751007543065, -122.493048175392) 11 6 2 55 26
164743 119967 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 536 28th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   5987220.23089 2112258.31491 37.7791203589842 -122.487816341376 (37.7791203589842, -122.487816341376) 11 6 2 55 26
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
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
118812 90480 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 139 24th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/17/2008 12:00:00 AM 3 3x3   5988320.04401 2115047.37952 37.7868424315213 -122.484216284461 (37.7868424315213, -122.484216284461) 11 6 1 55 33
158164 120284 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 139 24th Ave 3 Sidewalk: Curb side : Yard Tree Private 2     8     5988322.78334 2115034.52421 37.7868072939982 -122.484205864007 (37.7868072939982, -122.484205864007) 11 6 1 55 33
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
59809 45688 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 614 23rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/07/2001 12:00:00 AM 6   Permit Number 44373 5988813.86357 2111116.63856 37.7760784619734 -122.482219714975 (37.7760784619734, -122.482219714975) 11 6 2 55 26
121681 120334 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 16 West Clay St 1 Sidewalk: Curb side : Yard Tree Private 2     7 Width 5ft   5988822.29899 2115016.65173 37.7867872922875 -122.482476367259 (37.7867872922875, -122.482476367259) 11 6 1 55 33
19457 96917 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 2151X Cabrillo St 3 Sidewalk: Curb side : Cutout Tree Private 2   08/09/2011 12:00:00 AM 3 3x3 Permit Number 768104 5988894.20073 2110528.61903 37.7744685962766 -122.481898727171 (37.7744685962766, -122.481898727171) 11 6 2 55 26
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
43016 51309 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 518 20th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/13/2004 12:00:00 AM 7   Permit Number 47675 5989718.85945 2111803.87155 37.7780180115133 -122.479139410746 (37.7780180115133, -122.479139410746) 11 6 2 55 26
122239 97484 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 50 19th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   10/14/2011 12:00:00 AM 3   Permit Number 768208 5989917.9579 2114856.79796 37.7864120557494 -122.4786739918 (37.7864120557494, -122.4786739918) 11 6 1 55 33
59098 98408 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 24 19th Ave 2 Sidewalk: Curb side : Tree Private 2   02/09/2012 12:00:00 AM 3   Permit Number 768590 5989918.49451 2114923.36913 37.7865948726066 -122.478677005621 (37.7865948726066, -122.478677005621) 11 6 1 55 33
108435 98407 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 24 19th Ave 1 Sidewalk: Curb side : Tree Private 2   02/09/2012 12:00:00 AM 3   Permit Number 768590 5989919.44776 2114906.64899 37.7865490191546 -122.478672484402 (37.7865490191546, -122.478672484402) 11 6 1 55 33
25738 97483 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 50 19th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/14/2011 12:00:00 AM 3   Permit Number 768208 5989920.47182 2114841.78 37.7863709666179 -122.478664195663 (37.7863709666179, -122.478664195663) 11 6 1 55 33
146029 98235 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 42 19th Ave 1 Sidewalk: Curb side : Tree Private 2   01/09/2012 12:00:00 AM 3   Permit Number 768620 5989920.54745 2114876.26257 37.7864656504451 -122.47866645673 (37.7864656504451, -122.47866645673) 11 6 1 55 33
115364 105908 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 1237 NORIEGA ST 1 Sidewalk: Curb side : Cutout Tree Private 2   04/15/2014 12:00:00 AM 20 3x3 Permit Number 772682 5990134.3 2103036.1 37.7539682014274 -122.477061416534 (37.7539682014274, -122.477061416534) 1 8 3 56 35
174624 122059 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 20 18th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   5990228.03289 2114906.05857 37.7865653101026 -122.47760482414 (37.7865653101026, -122.47760482414) 11 6 1 55 33
146207 213717 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 1783 16th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 2ft   5991214.07731 2103294.38523 37.7547399684927 -122.47334616449 (37.7547399684927, -122.47334616449) 1 8 4 56 12
56484 122199 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 171 14th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5991475.81854 2114309.23252 37.7849989216744 -122.473244290329 (37.7849989216744, -122.473244290329) 11 6 2 54 26
80211 122200 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 171 14th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   5991476.58631 2114290.78647 37.784948318391 -122.473240288339 (37.784948318391, -122.473240288339) 11 6 2 54 26
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
181865 213730 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 290 San Fernando Way 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   5992101.64901 2095002.48097 37.732023872387 -122.469673110237 (37.732023872387, -122.469673110237) 9 8 4 59 40
187703 99226 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 112 12th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/16/2012 12:00:00 AM 3 3x3 Permit Number 768858 5992130.04894 2114624.94934 37.7859036525669 -122.47100389023 (37.7859036525669, -122.47100389023) 11 6 2 54 11
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
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
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
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
192755 52450 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 672 11th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/27/2005 12:00:00 AM 3 3x3 Permit Number 48563 5992577.48944 2110887.44098 37.7756673423473 -122.469183761515 (37.7756673423473, -122.469183761515) 11 6 2 54 11
186719 213718 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 1705 11th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5992771.0421 2103829.02772 37.7562979917618 -122.468000688697 (37.7562979917618, -122.468000688697) 1 8 4 56 12
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
103313 122967 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 98 09th Ave 2 Sidewalk: Curb side : Yard Tree Private 2     4 Width 5ft   5993050.69162 2114890.11462 37.7866849273422 -122.467838041215 (37.7866849273422, -122.467838041215) 11 6 1 54 11
166572 213719 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 306 Noriega St 3 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5993051.46655 2103255.88389 37.754740477507 -122.466989225694 (37.754740477507, -122.466989225694) 1 8 4 56 12
97447 84400 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 611-613 08th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/04/2008 12:00:00 AM 3 3x3 Permit Number 51577 5993447.66428 2111301.75717 37.7768551863663 -122.466203752377 (37.7768551863663, -122.466203752377) 11 6 2 54 11
63461 213724 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 66x Santa Monica Way 8 Median : Yard Tree DPW 1     8     5993565.41473 2097500.59466 37.7389675657933 -122.46479394281 (37.7389675657933, -122.46479394281) 1 8 4 59 40
88338 213729 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 150 Alton Ave 3 Sidewalk: Curb side : Yard Tree Private 2     2 Width 4ft   5993589.16073 2101660.48807 37.7503909504883 -122.465013883688 (37.7503909504883, -122.465013883688) 1 8 4 29491 40
128274 213723 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 66x Santa Monica Way 6 Median : Yard Tree DPW 1     3     5993589.39355 2097453.93432 37.7388408306314 -122.46470764836 (37.7388408306314, -122.46470764836) 1 8 4 59 40
142227 213722 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 66x Santa Monica Way 5 Median : Yard Tree DPW 1     4     5993592.57964 2097450.02121 37.7388302698944 -122.464696348358 (37.7388302698944, -122.464696348358) 1 8 4 59 40
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
174604 213727 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 66x San Lorenzo Way 12 Median : Yard Tree DPW 1     4     5993674.25829 2097434.39998 37.7387920864908 -122.464412810098 (37.7387920864908, -122.464412810098) 1 8 4 59 40
99174 213728 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 66x San Lorenzo Way 13 Median : Yard Tree DPW 1     2     5993678.60033 2097499.69771 37.7389716280322 -122.464402537152 (37.7389716280322, -122.464402537152) 1 8 4 59 40
188572 213725 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 66x San Lorenzo Way 10 Median : Yard Tree DPW 1     4     5993679.6596 2097491.88512 37.7389502376721 -122.464398307632 (37.7389502376721, -122.464398307632) 1 8 4 59 40
123293 213726 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 66x San Lorenzo Way 11 Median : Yard Tree DPW 1     7     5993681.50314 2097480.63072 37.7389194421692 -122.464391116668 (37.7389194421692, -122.464391116668) 1 8 4 59 40
24291 123575 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 118 05th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   5994297.68738 2114732.87451 37.7863251158785 -122.463512352181 (37.7863251158785, -122.463512352181) 11 6 1 54 11
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
83042 123363 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 770 04th Ave 3 Sidewalk: Curb side : Yard Tree Private 2     6 Width 4ft   5994763.50549 2110414.96281 37.7744961151162 -122.461587583233 (37.7744961151162, -122.461587583233) 11 6 2 54 11
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
183292 123364 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 770 04th Ave 2 Sidewalk: Curb side : Yard Tree Private 2     5 Width 4ft   5994764.09915 2110406.2546 37.7744722388497 -122.461584898177 (37.7744722388497, -122.461584898177) 11 6 2 54 11
184976 213732 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 475 Dewey Blvd 3 Sidewalk: Curb side : Yard Tree Private 2     5 Width 3ft   5994831.427 2100060.8711 37.746070357361 -122.460602166776 (37.746070357361, -122.460602166776) 1 8 4 59 40
140943 38818 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 221 03rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/04/2005 12:00:00 AM 4   Permit Number 47857 5994895.35063 2113953.79381 37.7842203879728 -122.461388106023 (37.7842203879728, -122.461388106023) 11 6 2 54 11
105268 213731 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 72 Merced Ave 1 Sidewalk: Curb side : Yard Tree Private 2     4 Width 3ft   5994987.04868 2099905.16215 37.7456517715262 -122.460052772716 (37.7456517715262, -122.460052772716) 1 8 4 59 40
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
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
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
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
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
181133 52707 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 1@ JACKSON Cherry St 4 Sidewalk: Curb side : Cutout Tree Private 2   03/31/2006 12:00:00 AM 7   Permit Number 48767 5996046.88013 2115983.52672 37.7898596976604 -122.457551152633 (37.7898596976604, -122.457551152633) 11   1 54 31
62806 52709 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 1@ JACKSON Cherry St 3 Sidewalk: Curb side : Cutout Tree Private 2   04/04/2006 12:00:00 AM 8   Permit Number 48767 5996047.33493 2115997.05017 37.7898968555268 -122.457550557933 (37.7898968555268, -122.457550557933) 11   1 54 31
64185 52711 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 1@ JACKSON Cherry St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/04/2006 12:00:00 AM 5   Permit Number 48767 5996055.9612 2115990.01738 37.7898780408886 -122.457520202963 (37.7898780408886, -122.457520202963) 11   1 54 31
114222 52710 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 1@ JACKSON Cherry St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/04/2006 12:00:00 AM 7   Permit Number 48767 5996063.73844 2115999.96188 37.7899057925288 -122.457494014373 (37.7899057925288, -122.457494014373) 11   1 54 31
79306 136048 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 20 Cherry St 7 Sidewalk: Curb side : Yard Tree Private 2     8     5996075.48126 2116002.11474 37.7899123782026 -122.457453541344 (37.7899123782026, -122.457453541344) 11   1 54 31
76440 136047 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 20 Cherry St 6 Sidewalk: Curb side : Yard Tree Private 2     6     5996079.9197 2115992.25742 37.7898855676012 -122.457437471381 (37.7898855676012, -122.457437471381) 11   1 54 31
150831 136046 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 20 Cherry St 5 Sidewalk: Curb side : Yard Tree Private 2     6     5996087.67176 2116001.00322 37.78991002647 -122.45741128312 (37.78991002647, -122.45741128312) 11   1 54 31
126493 84727 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 20 Cherry St 4 Sidewalk: Curb side : Cutout Tree Private 2   04/24/2007 12:00:00 AM 5   Permit No. 49296 5996090.69151 2115989.11998 37.7898775717477 -122.457399975051 (37.7898775717477, -122.457399975051) 11   1 54 31
102636 124378 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 37 Jordan Ave 2 Sidewalk: Curb side : Yard Tree Private 2     4 Width 4ft   5996168.03045 2114275.5227 37.7851769356666 -122.457008391438 (37.7851769356666, -122.457008391438) 11 6 1 54 31
43837 124379 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 37 Jordan Ave 1 Sidewalk: Curb side : Yard Tree Private 2     4 Width 4ft   5996169.18438 2114263.97819 37.785145303794 -122.457003563892 (37.785145303794, -122.457003563892) 11 6 1 54 31
135365 124512 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 2656 McAllister St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   5996425.61433 2110792.8133 37.7756291250409 -122.455865383128 (37.7756291250409, -122.455865383128) 11 6 2 54 16
106048 61899 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 335 Maple St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/21/1985 12:00:00 AM 5   Permit Number 21942 5996649.71832 2115128.18725 37.7875457744774 -122.455403556547 (37.7875457744774, -122.455403556547) 11 6 1 54 31
135030 84901 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 3710 Washington St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/02/2007 12:00:00 AM 5   Permit No. 49300 5996951.85595 2115692.33884 37.7891121155896 -122.454398994017 (37.7891121155896, -122.454398994017) 11 6 1 54 31
84948 107672 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 184 Cook St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/09/2014 12:00:00 AM 3 3x3 Permit Number 773528 5997643.33289 2112648.90363 37.7807952777935 -122.45178694364 (37.7807952777935, -122.45178694364) 15 6 2 54 16
83158 57747 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 3425 Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/19/1977 12:00:00 AM 8   Permit Number 16667 5997831.65027 2116097.2527 37.7902743175622 -122.45138424801 (37.7902743175622, -122.45138424801) 11 6 1 54 31
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
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
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
147580 136044 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 2 Laurel St 7 Sidewalk: Curb side : Yard Tree Private 2     5 Width 5ft   5997978.05362 2116388.40928 37.7910821380693 -122.450898708531 (37.7910821380693, -122.450898708531) 13 6 1 54 31
90085 136045 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 2 Laurel St 6 Sidewalk: Curb side : Yard Tree Private 2     5 Width 5ft   5997979.66837 2116375.74786 37.7910474656235 -122.45089220822 (37.7910474656235, -122.45089220822) 13 6 1 54 31
136645 94793 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 2 Laurel St 5 Sidewalk: Curb side : Cutout Tree Private 2   11/08/2010 12:00:00 AM 5   Permit Number 53892 5997982.2072 2116362.36591 37.7910108676939 -122.450882458672 (37.7910108676939, -122.450882458672) 13 6 1 54 31
118474 136041 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 3399 Jackson St 1 Sidewalk: Property side : Yard Tree Private 2     8 Width 4ft   5998034.28644 2116116.08829 37.7903376361102 -122.450684503481 (37.7903376361102, -122.450684503481) 13 6 1 54 31
158227 136042 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 3399 Jackson St 3 Sidewalk: Property side : Yard Tree Private 2     7 Width 4ft   5998049.07867 2116118.00061 37.7903437335326 -122.450633461567 (37.7903437335326, -122.450633461567) 13 6 1 54 31
193715 250146 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 2501 Lyon St 1 Front Yard : Yard Tree Private 2     4     5999207.44391 2117490.79429 37.7941792970798 -122.446724430609 (37.7941792970798, -122.446724430609) 11   1 57 30
26148 250147 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 2501 Lyon St 2 Front Yard : Yard Tree Private 2     7     5999210.3991 2117472.66602 37.7941296904761 -122.446712900392 (37.7941296904761, -122.446712900392) 11   1 57 30
88103 250148 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 2501 Lyon St 3 Front Yard : Yard Tree Private 2     6     5999211.58041 2117458.26171 37.7940902075462 -122.446707776048 (37.7940902075462, -122.446707776048) 11   1 57 30
152580 250149 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 2501 Lyon St 4 Front Yard : Yard Tree Private 2     6     5999215.63832 2117439.7417 37.794039588317 -122.446692402146 (37.794039588317, -122.446692402146) 11   1 57 30
137971 250150 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 2501 Lyon St 5 Front Yard : Yard Tree Private 2     8     5999218.59352 2117421.61343 37.7939899817095 -122.446680871938 (37.7939899817095, -122.446680871938) 11   1 57 30
57531 250151 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 2501 Lyon St 6 Front Yard : Yard Tree Private 2     6     5999220.87756 2117406.81737 37.7939494861264 -122.446671903881 (37.7939494861264, -122.446671903881) 11   1 57 30
130390 249661 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 2401 Lyon St 13 Front Yard : Yard Tree Private 2     9     5999232.65842 2117208.86838 37.7934066436505 -122.446616892353 (37.7934066436505, -122.446616892353) 11   1 57 30
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
67120 249663 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 2401 Lyon St 15 Front Yard : Yard Tree Private 2     9     5999240.36151 2117161.61527 37.7932773391397 -122.446586837907 (37.7932773391397, -122.446586837907) 11   1 57 30
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
16844 249665 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 2401 Lyon St 17 Front Yard : Yard Tree Private 2     9     5999244.57563 2117118.96584 37.7931604758161 -122.44656918694 (37.7931604758161, -122.44656918694) 11   1 57 30
189111 249666 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 2401 Lyon St 18 Front Yard : Yard Tree Private 2     8     5999246.11095 2117099.98704 37.793108452756 -122.44656250858 (37.793108452756, -122.44656250858) 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
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

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