4,014 rows where qSpecies_id = 40 sorted by Supervisor Districts descending

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)
13441 82704 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 67 Jennings Ct 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     6012930.12709 2089200.71503 37.7172752435332 -122.397257359943 (37.7172752435332, -122.397257359943) 10 3 8 58 1
14192 28301 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3336 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2003 12:00:00 AM 8 3X3   6011974.10308 2090046.14983 37.719543365213 -122.400621263274 (37.719543365213, -122.400621263274) 10 7 8 309 28
15749 108724 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 566 Rhode Island St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/02/2015 12:00:00 AM 3 3x3 Permit Number 773100 6011759.6093 2105732.18704 37.7626019164795 -122.402465094694 (37.7626019164795, -122.402465094694) 8 3 8 28856 29
16544 84392 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2101 Jerrold Ave 6 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3     6012504.25768 2099077.65785 37.7443715685998 -122.399422411225 (37.7443715685998, -122.399422411225) 10 3 8 58 1
16871 83424 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 987 De Haro St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3     6012206.17554 2103813.08601 37.7573574093248 -122.400785742066 (37.7573574093248, -122.400785742066) 10 3 8 28856 29
17063 179027 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 376 Ordway St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6010782.01904 2090025.31129 37.719419589727 -122.404740419057 (37.719419589727, -122.404740419057) 10 7 8 309 28
18514 79061 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1006 De Haro St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     6012156.57413 2103666.55961 37.7569523133274 -122.400946989616 (37.7569523133274, -122.400946989616) 10 3 8 28856 29
19539 102037 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3601X Jennings St 3 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3 Permit Number 52501 6012999.572 2089254.628 37.7174271437906 -122.397021097837 (37.7174271437906, -122.397021097837) 10 3 8 58 1
22886 27724 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1200 Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/23/2006 12:00:00 AM 3 3X3   6015353.11348 2101161.82636 37.750252634764 -122.389717121075 (37.750252634764, -122.389717121075) 10 3 8 28856 1
24175 109719 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 91x Jennings Ct 2 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6013017.96817 2089237.91008 37.7173822637496 -122.39695633886 (37.7173822637496, -122.39695633886) 10 3 8 58 1
27189 82702 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 863 Meade Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/08/2009 12:00:00 AM   3x3 Permit Number 52463 6013030.57044013 2089280.70970627 37.7175004844817 -122.396915777424 (37.7175004844817, -122.396915777424) 10 3 8 58 1
29803 105161 Significant Tree 6 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1600X Oakdale Ave 2 Front Yard : Cutout Tree Arts Commission 19     13 3x3   6014869.34112 2095641.83637 37.735069048787 -122.391004288315 (37.735069048787, -122.391004288315) 10 3 8 58 1
29809 47252 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1001 Le Conte Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/16/2011 12:00:00 AM   3x3 Permit Number 767654 6013117.42744406 2089558.25653077 37.718267407089 -122.396634995972 (37.718267407089, -122.396634995972) 10 3 8 58 1
30199 196446 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 701 Wisconsin St 1 : Tree Private 2     4 Width 3ft   6012741.003 2104236.29493 37.7585492646472 -122.398965788556 (37.7585492646472, -122.398965788556) 10 3 8 28856 29
31187 27731 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1100 Cesar Chavez St 3 Sidewalk: Curb side : Cutout Tree DPW 1   03/23/2006 12:00:00 AM 3 3X3   6015524.1696 2101161.19501 37.7502603851148 -122.38912554882 (37.7502603851148, -122.38912554882) 10 3 8 28856 1
31761 196463 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1301 Cesar Chavez St 4 : Tree Private 2     4 Width 3ft   6014925.6309 2101062.89752 37.7499572830217 -122.39118848117 (37.7499572830217, -122.39118848117) 10 3 8 58 1
32351 196476 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2074 Revere Ave 1 Sidewalk: Property side : Yard Tree Private 2     6 Width 3ft   6012584.77785 2096296.25792 37.7367389189762 -122.398948809344 (37.7367389189762, -122.398948809344) 10 3 8 58 1
32715 84213 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 159 Tioga Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/05/2008 12:00:00 AM 6 3x3 Permit Number 50702 6010145.69333 2089116.11525 37.716887537712 -122.406875926694 (37.716887537712, -122.406875926694) 9 7 8 309 39
33364 102039 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3601X Jennings St 5 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3 Permit Number 52501 6012999.572 2089254.628 37.7174271437906 -122.397021097837 (37.7174271437906, -122.397021097837) 10 3 8 58 1
34248 196460 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 364 Missouri St 2 : Tree Private 2     16 Width 3ft   6013463.46293 2105385.87525 37.7617459921168 -122.396547761567 (37.7617459921168, -122.396547761567) 10 3 8 28856 29
34890 196480 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1499 Rankin St 6 Side Yard : Yard Tree Private 2     4 Width 3ft   6012679.65409 2096682.3113 37.737804227083 -122.39864786201 (37.737804227083, -122.39864786201) 10 3 8 58 1
38048 196479 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1499 Rankin St 3 Side Yard : Yard Tree Private 2     3 Width 3ft   6012661.09972 2096663.01157 37.7377502003122 -122.398710659866 (37.7377502003122, -122.398710659866) 10 3 8 58 1
38729 196443 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2309 25th St 4 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6011925.40712 2101842.83313 37.7519318623815 -122.401618279553 (37.7519318623815, -122.401618279553) 10 3 8 28856 29
39148 4016 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 700X Cesar Chavez St 2 Sidewalk: Curb side : Cutout Tree Port 6   03/27/2000 12:00:00 AM 3 3X3   6017358.6966724 2101256.2875006 37.7506230149756 -122.382788188693 (37.7506230149756, -122.382788188693) 10 3 8 58 1
39552 196478 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1499 Rankin St 2 Side Yard : Yard Tree Private 2     2 Width 3ft   6012656.37794 2096656.54864 37.7377321913814 -122.398726532018 (37.7377321913814, -122.398726532018) 10 3 8 58 1
40196 196441 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 768 De Haro St 1 Sidewalk: Property side : Yard Tree Private 2     12     6012093.04476 2104807.3138 37.7600810286241 -122.401246859559 (37.7600810286241, -122.401246859559) 10 3 8 28856 29
40527 14625 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 15 Matthew Ct 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/12/1998 12:00:00 AM 12 3X4   6017974.7726653 2094204.273773 37.7312936151853 -122.380167719121 (37.7312936151853, -122.380167719121) 10 3 8 58 1
41071 178969 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1029 Sunnydale Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   6008570.63643 2086915.27252 37.710756219889 -122.412164693966 (37.710756219889, -122.412164693966) 9 7 8 309 39
42949 53899 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1057 Goettingen St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/02/2009 12:00:00 AM     Permit Number 52970 6011224.04910165 2089865.72837227 37.7190061040508 -122.403201256455 (37.7190061040508, -122.403201256455) 10 7 8 309 28
44028 237080 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1407 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6011199.55068 2101731.468 37.7515855478467 -122.404120571211 (37.7515855478467, -122.404120571211) 10 4 8 28859 19
44806 179033 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 88 Alpha St 1 Sidewalk: Curb side : Yard Tree Private 2     1 Width 5ft   6011104.28456 2088327.78048 37.7147765222032 -122.40350709418 (37.7147765222032, -122.40350709418) 9 7 8 309 39
45071 237079 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1300 San Bruno Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 5ft   6011116.28674 2102209.61891 37.7528937925351 -122.404442163398 (37.7528937925351, -122.404442163398) 10 4 8 28859 19
46888 82918 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3601X Jennings St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/09/2009 12:00:00 AM 5 3x3 Permit Number 52501 6013030.57044013 2089280.70970627 37.7175004844817 -122.396915777424 (37.7175004844817, -122.396915777424) 10 3 8 58 1
49769 83292 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1722 Newcomb Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/02/2009 12:00:00 AM 4 3x3 Permit Number 52353 6014576.18583 2096214.42431 37.7366249865567 -122.392057868392 (37.7366249865567, -122.392057868392) 10 3 8 58 1
50077 109722 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 91x Jennings Ct 5 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6012966.2543 2089212.97453 37.7173109169351 -122.397133343428 (37.7173109169351, -122.397133343428) 10 3 8 58 1
50426 178970 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1029 Sunnydale Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   6008583.66239 2086910.82676 37.7107447436356 -122.412119359132 (37.7107447436356, -122.412119359132) 9 7 8 309 39
50590 39571 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 835 Kansas St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/28/1998 12:00:00 AM 8   Permit Number 40989 6011610.45833 2104449.83114 37.7590725253066 -122.402890761795 (37.7590725253066, -122.402890761795) 10 3 8 28856 29
50913 50957 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 860 Kansas St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/29/2004 12:00:00 AM 3   Permit Number 47450 6011554.87685 2104354.20942 37.7588068655572 -122.403076264082 (37.7588068655572, -122.403076264082) 10 3 8 28856 29
51918 84222 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1099 Sunnydale Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   06/05/2008 12:00:00 AM   3x3 Permit Number 50699 6008536.64493866 2086928.58742632 37.7107908725318 -122.412283117187 (37.7107908725318, -122.412283117187) 9 7 8 309 39
52392 27729 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1100 Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/23/2006 12:00:00 AM 3 3X3   6015622.7491 2101166.85438 37.7502813887778 -122.3887850466 (37.7502813887778, -122.3887850466) 10 3 8 28856 1
54061 196452 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1950 Cesar Chavez St 4 : Tree Private 2     3 Width 3ft   6013266.78575 2101037.18746 37.7497944913407 -122.396923089148 (37.7497944913407, -122.396923089148) 10 3 8 28856 1
54353 92795 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 999 Wisconsin St 4 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3 Permit Number 52022 6012811.72806 2102960.97452 37.7550514540675 -122.398631693097 (37.7550514540675, -122.398631693097) 10 3 8 28856 29
54909 49745 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 34@ LELAND Britton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/04/2003 12:00:00 AM 4   Permit Number 46544 6008556.33506 2087877.23988 37.7133967814171 -122.412282069889 (37.7133967814171, -122.412282069889) 9 7 8 309 39
57134 55259 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2 Britton St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/05/1972 12:00:00 AM 8   Permit Number 11181 6008604.18987 2088002.78931 37.7137441994136 -122.412125533875 (37.7137441994136, -122.412125533875) 9 7 8 309 39
57460 108081 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 626 Potrero Ave 1 Sidewalk: Curb side : Cutout Tree Private 2           6010239.31853 2105432.72154 37.7616946632209 -122.407702139761 (37.7616946632209, -122.407702139761) 10 4 8 28859 19
58370 196473 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2500 Newhall St 3 : Tree Private 2     5 Width 3ft   6012815.80377 2093626.35145 37.7294207793372 -122.397962808852 (37.7294207793372, -122.397962808852) 10 3 8 58 1
58582 179030 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 121 Tucker Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6010311.02154 2088780.05452 37.715974033352 -122.406280800329 (37.715974033352, -122.406280800329) 9 7 8 309 39
59096 202045 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 41 Exeter St 1 : Tree Private 2     1 Width 3ft   6012584.35783 2091031.24341 37.7222822496095 -122.398580911082 (37.7222822496095, -122.398580911082) 10 3 8 58 1
59546 40019 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 12 Latona St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/03/1999 12:00:00 AM 6   Permit Number 41264 6014412.91208 2094585.93232 37.7321444139378 -122.392508504263 (37.7321444139378, -122.392508504263) 10 3 8 58 1
59811 196506 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1301 Newcomb Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6016688.40007 2094936.9316 37.7332342924349 -122.384666003252 (37.7332342924349, -122.384666003252) 10 3 8 58 1
60068 84283 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 156 Tioga Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/05/2008 12:00:00 AM 2 3x3 Permit Number 50701 6010175.00365 2089148.86152 37.7169790922895 -122.406776921235 (37.7169790922895, -122.406776921235) 9 7 8 309 39
60473 37967 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 456 Missouri St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/08/1998 12:00:00 AM 5   Permit Number 40197 6013486.47926 2104950.0016 37.7605504594599 -122.396437603638 (37.7605504594599, -122.396437603638) 10 3 8 28856 29
61096 179036 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 551 Sawyer St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6007618.72078 2086894.99872 37.7106470934606 -122.415453306029 (37.7106470934606, -122.415453306029) 9 7 8 309 39
61693 196458 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1760 Cesar Chavez St 4 : Tree Private 2     4 Width 2ft   6013820.90898 2101070.2514 37.7499161066554 -122.395009208608 (37.7499161066554, -122.395009208608) 10 3 8 58 1
63494 196467 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1101 Cesar Chavez St 8 : Tree Private 2     4 Width 3ft   6015482.81101 2101057.86709 37.7499743755266 -122.389261356351 (37.7499743755266, -122.389261356351) 10 3 8 58 1
64129 196477 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1499 Rankin St 1 Side Yard : Yard Tree Private 2     6 Width 3ft   6012648.61518 2096647.76204 37.7377076327033 -122.398752755335 (37.7377076327033, -122.398752755335) 10 3 8 58 1
64136 121586 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 855 Carolina St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 3x3   6012479.74347 2103984.11738 37.7578422788274 -122.399851639655 (37.7578422788274, -122.399851639655) 10 3 8 28856 29
64309 179034 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 88 Alpha St 2 Sidewalk: Curb side : Yard Tree Private 2     1 Width 5ft   6011090.19294 2088313.27178 37.7147358971229 -122.403554780747 (37.7147358971229, -122.403554780747) 9 7 8 309 39
64315 14623 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 10 Matthew Ct 2 Sidewalk: Curb side : Cutout Tree DPW 1   02/12/1998 12:00:00 AM 6 3X4   6018016.8978124 2094239.2837712 37.7313920698281 -122.380024515102 (37.7313920698281, -122.380024515102) 10 3 8 58 1
65703 95006 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 195 Leland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/07/2013 12:00:00 AM 3 3x3   6009968.4 2087457.4 37.7123231225616 -122.407371876718 (37.7123231225616, -122.407371876718) 9 7 8 309 39
66249 196474 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 74 Neptune St 1 : Tree Private 2     5 Width 3ft   6013054.12657 2093955.76147 37.7303385419805 -122.397161987746 (37.7303385419805, -122.397161987746) 10 3 8 58 1
68166 196440 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1400 Cesar Chavez St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6014910.39402 2101173.59345 37.7502603851252 -122.391248908417 (37.7502603851252, -122.391248908417) 10 3 8 28856 1
69169 82919 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 863 Meade Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/08/2009 12:00:00 AM   3x3 Permit Number 52463 6013030.57044013 2089280.70970627 37.7175004844817 -122.396915777424 (37.7175004844817, -122.396915777424) 10 3 8 58 1
70689 94959 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1059 Evans Ave 1 Sidewalk: Property side : Yard Tree Private 2   12/09/2010 12:00:00 AM       6018613.9 2096078.3 37.7364745658864 -122.378088153142 (37.7364745658864, -122.378088153142) 10 3 8 58 1
72009 43296 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 589 Missouri St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/12/2015 12:00:00 AM 3   Permit Number 775309 6013581.06232 2104334.57728 37.7588659015663 -122.396067351846 (37.7588659015663, -122.396067351846) 10 3 8 28856 29
73535 102038 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3601X Jennings St 4 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3 Permit Number 52501 6012999.572 2089254.628 37.7174271437906 -122.397021097837 (37.7174271437906, -122.397021097837) 10 3 8 58 1
73927 50360 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 807 Kansas St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/22/2003 12:00:00 AM 3   Permit Number 47032 6011601.76017 2104587.37273 37.7594496982747 -122.402930518137 (37.7594496982747, -122.402930518137) 10 3 8 28856 29
74016 94875 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 44 Ledyard St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/23/2010 12:00:00 AM   3x3 Permit Number 53944 6011618 2095077 37.7333371742049 -122.402205704408 (37.7333371742049, -122.402205704408) 10 3 8 58 1
74075 108083 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 626 Potrero Ave 3 Sidewalk: Curb side : Cutout Tree Private 2           6010239.31853 2105432.72154 37.7616946632209 -122.407702139761 (37.7616946632209, -122.407702139761) 10 4 8 28859 19
74954 82374 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 758 Hampshire St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/26/2009 12:00:00 AM   3x3 Permit Number 52210 6010116.01173649 2104758.25368083 37.7598358234012 -122.408081042327 (37.7598358234012, -122.408081042327) 2 4 8 28859 19
75617 237152 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 601 Hampshire St 6 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 5ft   6010131.84271 2105445.94414 37.7617249524607 -122.408074789522 (37.7617249524607, -122.408074789522) 10 4 8 28859 19
75745 28262 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3624 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/20/2003 12:00:00 AM 12 3x3   6012194.48746 2088681.14992 37.7158076389797 -122.399763675165 (37.7158076389797, -122.399763675165) 10 7 8 309 39
77068 82672 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 69 Jennings Ct 2 Sidewalk: Curb side : Cutout Tree Private 2   07/09/2009 12:00:00 AM   3x3 Permit Number 52500 6012954.77206528 2089215.57064421 37.7173174061263 -122.397173214353 (37.7173174061263, -122.397173214353) 10 3 8 58 1
77137 57611 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 356 Connecticut St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/12/1976 12:00:00 AM 13   Permit Number 16500 6013179.72476 2105412.69394 37.7618038355947 -122.397530985864 (37.7618038355947, -122.397530985864) 10 3 8 28856 29
77381 22521 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 6600 03rd St 1 Median : Cutout Tree DPW 1   02/20/1992 12:00:00 AM 3 3X3   6012847.5284056 2089784.7633559 37.7188743244909 -122.397583806576 (37.7188743244909, -122.397583806576) 10 3 8 58 1
78450 94948 Significant Tree 6 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 50 Pomona St   Sidewalk: Property side : Cutout Tree SFUSD 4 FUF 04/04/2009 12:00:00 AM       6014124.7 2094445.3 37.7317422564721 -122.393495086444 (37.7317422564721, -122.393495086444) 10 3 8 58 1
79423 31513 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2513 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/10/1995 12:00:00 AM 15   Permit Number 35071 6011012.0661 2102261.56789 37.7530306081845 -122.404806236834 (37.7530306081845, -122.404806236834) 10 4 8 28859 19
80859 196428 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 506 Utah St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6010626.46866 2105919.55738 37.7630530694618 -122.406397441508 (37.7630530694618, -122.406397441508) 8 4 8 28859 19
81146 50013 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 999 Wisconsin St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/22/2009 12:00:00 AM 2   Permit Number 52022 6012813.23846 2102916.22313 37.7549286606329 -122.398623329429 (37.7549286606329, -122.398623329429) 10 3 8 28856 29
81775 28260 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3562 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2003 12:00:00 AM 12 3x3   6012130.0554759 2089144.2345931 37.7170755844057 -122.400018884967 (37.7170755844057, -122.400018884967) 10 7 8 309 39
82225 196447 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2 Madera St 1 : Tree Private 2     11 Width 3ft   6012994.61219 2103283.12733 37.7559462030644 -122.398021821446 (37.7559462030644, -122.398021821446) 10 3 8 28856 29
82301 62079 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 595 Connecticut St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/22/1985 12:00:00 AM 14   Permit Number 22161 6013301.58361 2104304.12984 37.7587667459021 -122.397031791103 (37.7587667459021, -122.397031791103) 10 3 8 28856 29
83351 96396 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 800 Tennessee St 6 Sidewalk: Curb side : Cutout Tree Private 2   05/17/2011 12:00:00 AM   3x3 Permit Number 767136 6015449.8 2105317.4 37.7616683177051 -122.389672976331 (37.7616683177051, -122.389672976331) 10 3 8 28856 29
84132 196449 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2 Madera St 3 : Tree Private 2     2 Width 3ft   6012958.79837 2103280.94306 37.7559382107998 -122.398145525023 (37.7559382107998, -122.398145525023) 10 3 8 28856 29
84241 84211 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1099 Sunnydale Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   06/05/2008 12:00:00 AM   3x3 Permit Number 50699 6008536.64493866 2086928.58742632 37.7107908725318 -122.412283117187 (37.7107908725318, -122.412283117187) 9 7 8 309 39
87296 196508 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 97 Whitney Young Cir 4 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6016637.34398 2094986.73553 37.7333682203685 -122.384845988159 (37.7333682203685, -122.384845988159) 10 3 8 58 1
87718 196457 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1950 Cesar Chavez St 13 : Tree Private 2     3 Width 3ft   6012824.47283 2101012.76758 37.7497028090569 -122.398450923095 (37.7497028090569, -122.398450923095) 10 3 8 28856 1
88047 178968 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1029 Sunnydale Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   6008554.00356 2086922.92709 37.710776304465 -122.412222721805 (37.710776304465, -122.412222721805) 9 7 8 309 39
88121 28255 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3476 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/25/2003 12:00:00 AM 6 3x3   6012058.00542 2089554.66958 37.7181985388057 -122.400296740219 (37.7181985388057, -122.400296740219) 10 7 8 309 39
88427 179026 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 376 Ordway St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6010795.80251 2090029.68717 37.7194323753865 -122.404693082342 (37.7194323753865, -122.404693082342) 10 7 8 309 28
89163 16435 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1299X Newcomb Ave 4 Sidewalk: Curb side : Cutout Tree DPW 1   02/27/2008 12:00:00 AM 3 3x3   6016431.779935 2094795.010481 37.7328304099415 -122.385543330143 (37.7328304099415, -122.385543330143) 10 3 8 58 1
91881 84197 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 551 Sawyer St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/05/2008 12:00:00 AM 8 3x3 Permit Number 50697 6007614.52495 2086883.32703 37.7106148095844 -122.41546698201 (37.7106148095844, -122.41546698201) 9 7 8 309 39
92879 179031 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 121 Tucker Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6010327.66378 2088774.95095 37.7159609509146 -122.406222917279 (37.7159609509146, -122.406222917279) 9 7 8 309 39
93608 196438 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1300 Cesar Chavez St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6015044.32759 2101169.27402 37.7502559568629 -122.390785451805 (37.7502559568629, -122.390785451805) 10 3 8 28856 1
95019 85071 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 501 York St 2 Sidewalk: Curb side : Cutout Tree Private 2           6009818 2105945 37.7630776692381 -122.409195467269 (37.7630776692381, -122.409195467269) 8 4 8 28859 19
95145 196444 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1200x Kansas St 2 Median : Cutout Tree DPW 1     5 Width 5ft   6011674.76736 2102721.10758 37.7543294225845 -122.402546786399 (37.7543294225845, -122.402546786399) 10 3 8 28856 29
96306 92531 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1298X Kansas St 1 Median : Cutout Tree DPW 1     4     6011695.14318 2102366.06354 37.7533556870153 -122.402451357562 (37.7533556870153, -122.402451357562) 10 3 8 28856 29
100494 94874 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 40 Ledyard St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/23/2010 12:00:00 AM   3x3 Permit Number 53943 6011600 2095102 37.7334048142135 -122.402269692882 (37.7334048142135, -122.402269692882) 10 3 8 58 1
100942 179028 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 535 Leland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6007927.50802 2088265.22189 37.7144267929389 -122.41448296003 (37.7144267929389, -122.41448296003) 9 7 8 309 39
101013 94947 Significant Tree 6 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 50 Pomona St   Sidewalk: Property side : Cutout Tree SFUSD 4 FUF 04/04/2009 12:00:00 AM       6014124.7 2094445.3 37.7317422564721 -122.393495086444 (37.7317422564721, -122.393495086444) 10 3 8 58 1

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