268 rows where qSpecies_id = 77 sorted by Police Districts

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)
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
246 136052 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 1114 Greenwich St 1 Side Yard : Yard Tree Private 2     3     6007569.13805 2119905.68389 37.801284085155 -122.417963252702 (37.801284085155, -122.417963252702) 5 1 1 28858 32
24251 136053 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 1101 Greenwich St 13 Front Yard : Yard Tree Private 2     4     6007566.05683 2119890.57017 37.8012424132723 -122.417972843093 (37.8012424132723, -122.417972843093) 5 1 1 28858 32
177445 136054 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 1101 Greenwich St 14 Front Yard : Yard Tree Private 2     5     6007578.67798 2119880.17499 37.80121458104 -122.417928430959 (37.80121458104, -122.417928430959) 5 1 1 28858 32
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
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
29395 83672 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 76 Santa Fe Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/01/2009 12:00:00 AM 6 3x3 Permit Number 52299 6012122.94965 2095206.11599 37.7337198723641 -122.400469008954 (37.7337198723641, -122.400469008954) 10 3 8 58 1
31602 196549 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 40 Ledyard St 1 : Tree Private 2     7 Width 2ft   6011616.35938 2095078.64568 37.7333416013201 -122.402211492182 (37.7333416013201, -122.402211492182) 10 3 8 58 1
38026 50359 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 1044 Mississippi St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/22/2003 12:00:00 AM 5   Permit Number 47031 6014195.81741 2102278.81797 37.753255413506 -122.3937973317 (37.753255413506, -122.3937973317) 10 3 8 28856 29
42382 84481 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 59 Santa Fe Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/22/2008 12:00:00 AM 4 3x3 Permit Number 50146 6012081.07031 2095312.02235 37.7340083335059 -122.40062123629 (37.7340083335059, -122.40062123629) 10 3 8 58 1
45234 202184 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 1900 Armstrong Ave 4 Sidewalk: Property side : Yard Tree Private 2     6     6013198.98425 2093399.22832 37.7288184790723 -122.396622193069 (37.7288184790723, -122.396622193069) 10 3 8 58 1
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
52161 106889 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 1040 Mariposa St 4 Sidewalk: Curb side : Cutout Tree Private 2   10/14/2014 12:00:00 AM 3   Permit Number 773355 6014125.23342 2106217.58962 37.7640665046851 -122.394317180299 (37.7640665046851, -122.394317180299) 14 3 8 28856 29
52279 196548 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 1828 Illinois St 1 : Tree Private 2     7 Width 4ft   6016259.97415 2100569.45799 37.748676359729 -122.386539809975 (37.748676359729, -122.386539809975) 10 3 8 58 1
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
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
60441 46239 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 1050 Mississippi St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/11/2002 12:00:00 AM 5   Permit Number 44533 6014194.98195 2102252.43023 37.7531829119855 -122.393798374016 (37.7531829119855, -122.393798374016) 10 3 8 28856 29
75753 196539 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 1751 17th St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6012100.68573 2106521.94936 37.7647894624906 -122.401340930463 (37.7647894624906, -122.401340930463) 14 3 8 28856 29
76508 196550 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 44 Ledyard St 1 : Tree Private 2     7 Width 2ft   6011631.22474 2095058.90735 37.7332882337562 -122.402158710982 (37.7332882337562, -122.402158710982) 10 3 8 58 1
77284 44274 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 730 Vermont St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/22/2001 12:00:00 AM 4   Permit Number 43700 6011255.06578 2104741.61874 37.7598538580824 -122.404140420144 (37.7598538580824, -122.404140420144) 10 3 8 28856 29
77776 196541 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 1751 17th St 4 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6012133.24244 2106522.80627 37.7647936317506 -122.401228384779 (37.7647936317506, -122.401228384779) 14 3 8 28856 29
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
93507 114199 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 1701x 17th St 3 Sidewalk: Curb side : Cutout Tree Private 2     2 3x3   6012227.07645 2106528.11077 37.7648134312296 -122.400904207967 (37.7648134312296, -122.400904207967) 14 3 8 28856 29
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
100238 57625 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 1040 Mariposa St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/14/2014 12:00:00 AM 3   Permit Number 773355 6014196.28428 2106222.11039 37.7640828669594 -122.394071750814 (37.7640828669594, -122.394071750814) 14 3 8 28856 29
106942 62466 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 708 Vermont St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/23/2012 12:00:00 AM 2   Permit Number 769096 6011238.859 2104985.8972 37.7605236866263 -122.40421366454 (37.7605236866263, -122.40421366454) 10 3 8 28856 29
114927 196551 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 48 Ledyard St 1 : Tree Private 2     6 Width 2ft   6011647.63932 2095039.33012 37.7332353949856 -122.402100585073 (37.7332353949856, -122.402100585073) 10 3 8 58 1
119039 67591 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 210 Texas St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/05/1992 12:00:00 AM 4   Permit Number 31158 6013702.18081 2106068.08806 37.763632481088 -122.395769929855 (37.763632481088, -122.395769929855) 14 3 8 28856 29
120545 202152 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 1951 Armstrong Ave 1 Sidewalk: Property side : Yard Tree Private 2     5 Width 7ft   6013046.17664 2093441.40359 37.7289257780866 -122.397153419018 (37.7289257780866, -122.397153419018) 10 3 8 58 1
121261 196544 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 1200x Kansas St 1 Median : Cutout Tree DPW 1   05/15/2018 12:10:00 PM 4 Width 5ft   6011674.97402 2102731.27183 37.7543573429212 -122.402546786412 (37.7543573429212, -122.402546786412) 10 3 8 28856 29
135957 40046 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 1732 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/16/2011 12:00:00 AM 5 7.5x2.5 Permit Number 767656 6014557.3351 2095185.10659 37.7337976439298 -122.392051083889 (37.7337976439298, -122.392051083889) 10 3 8 58 1
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
142625 196552 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 56 Ledyard St 1 : Tree Private 2     6 Width 2ft   6011678.30483 2094998.2948 37.7331244321513 -122.401991681687 (37.7331244321513, -122.401991681687) 10 3 8 58 1
149200 96001 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 321 Topeka Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/16/2011 12:00:00 AM 3 3x3 Permit Number 767651 6013592.98879 2094402.89056 37.73159625106 -122.395330363713 (37.73159625106, -122.395330363713) 10 3 8 58 1
152134 196553 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 43 Latona St 1 : Tree Private 2     5 Width 4ft   6014415.54504 2094422.50935 37.7316958338904 -122.392487974535 (37.7316958338904, -122.392487974535) 10 3 8 58 1
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
155378 114198 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 1701x 17th St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 3x3   6012211.95597 2106527.54933 37.7648110462088 -122.400956466675 (37.7648110462088, -122.400956466675) 14 3 8 28856 29
160166 202259 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 1 Kalmanovitz St 51 Sidewalk: Property side : Yard Tree Private 2     9     6013218.01399 2093376.88816 37.7287581966316 -122.396554840154 (37.7287581966316, -122.396554840154) 10 3 8 58 1
160650 196542 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 1751 17th St 5 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6012149.92661 2106523.64769 37.7647968728895 -122.401170737335 (37.7647968728895, -122.401170737335) 14 3 8 28856 29
171028 106887 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 1040 Mariposa St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/14/2014 12:00:00 AM 3   Permit Number 773355 6014179.56003 2106221.50204 37.7640802670231 -122.394129552957 (37.7640802670231, -122.394129552957) 14 3 8 28856 29
174301 51361 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 50 Pomona St 11 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/12/2004 12:00:00 AM 3 3x3 Permit Number 47704 6014122.20154 2094470.50183 37.7318113167403 -122.393505487305 (37.7318113167403, -122.393505487305) 10 3 8 58 1
174567 202188 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 1900 Armstrong Ave 8 Sidewalk: Property side : Yard Tree Private 2     5     6013190.44315 2093406.40364 37.728837705679 -122.39665222323 (37.728837705679, -122.39665222323) 10 3 8 58 1
176792 196538 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 1751 17th St 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6012116.4996 2106522.07184 37.764790681081 -122.401286242662 (37.764790681081, -122.401286242662) 14 3 8 28856 29
180557 96000 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 315 Topeka Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/16/2011 12:00:00 AM 3 3x3 Permit Number 767650 6013581.92641 2094423.84152 37.7316531628455 -122.395370075974 (37.7316531628455, -122.395370075974) 10 3 8 58 1
180977 106888 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 1040 Mariposa St 3 Sidewalk: Curb side : Cutout Tree Private 2   10/14/2014 12:00:00 AM 3   Permit Number 773355 6014142.8658 2106218.65545 37.7640704113316 -122.394256269225 (37.7640704113316, -122.394256269225) 14 3 8 28856 29
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
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
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
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
35128 5454 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 561 Dolores St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/11/2009 12:00:00 AM 3 8   6004988.38949 2105109.00015 37.7605104576133 -122.425839954961 (37.7605104576133, -122.425839954961) 2 4 5 28859 19
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
52717 5516 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 839 Dolores St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/30/2009 12:00:00 AM 3 6X6   6005075.66356 2103479.99989 37.7560425375576 -122.425422183901 (37.7560425375576, -122.425422183901) 2 4 5 28859 19
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
56637 239007 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 2801 20th St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6009827.40599 2104524.43186 37.7591776380486 -122.409062693893 (37.7591776380486, -122.409062693893) 2 4 7 28859 19
70362 4175 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 3812X Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree DPW 1   04/01/1995 12:00:00 AM 6 3X3   6005112.58146 2100504.28147 37.7478739908906 -122.425082788743 (37.7478739908906, -122.425082788743) 2 4 5 63 22
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
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
100212 238582 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 3456 Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6006754.5466 2100607.36077 37.7482496404132 -122.41941224938 (37.7482496404132, -122.41941224938) 2 4 7 28859 19
104300 196537 Planning Code 138.1 required 2 Prunus x yedoensis :: Yoshino Cherry 77 526 Utah St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/04/2019 12:00:00 AM 3 Width 3ft Permit Number 782869 6010635.96485 2105787.36101 37.7626906193079 -122.406355282166 (37.7626906193079, -122.406355282166) 8 4 8 28859 19
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
119873 239006 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 2801 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6009817.72923 2104524.2582 37.7591766191261 -122.409096148662 (37.7591766191261, -122.409096148662) 2 4 7 28859 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
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
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
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
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
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
151721 41603 Permitted Site 7 Prunus x yedoensis :: Yoshino Cherry 77 98X Hoff St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/01/2000 12:00:00 AM 8 3x3 Permit Number 42107 6006559.89893522 2106145.26349714 37.7634444777116 -122.420478371661 (37.7634444777116, -122.420478371661) 8 4 7 28859 19
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
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
162524 239008 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 2801 20th St 3 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6009837.36864 2104524.2797 37.7591777783485 -122.409028227385 (37.7591777783485, -122.409028227385) 2 4 7 28859 19
165707 4211 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 3935 Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3   6004300.14403 2100415.02402 37.7475829828864 -122.427885801087 (37.7475829828864, -122.427885801087) 2 4 5 63 22
165888 238583 DPW Maintained 1 Prunus x yedoensis :: Yoshino Cherry 77 3726 Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6005678.26698 2100537.88452 37.7479981962719 -122.423129060168 (37.7479981962719, -122.423129060168) 2 4 5 28859 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

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