4,014 rows where qSpecies_id = 40 sorted by Neighborhoods (old)

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) ▼
6813 256911 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 26 Lily St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/07/2019 12:00:00 AM 3 3x3 Permit Number 782765                    
3431 80385 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1754 Fitzgerald Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   8     6011729.10125 2092748.56003 37.7269499630479 -122.401657992736 (37.7269499630479, -122.401657992736) 10 3 8 58 1
3608 71395 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1553 Kirkwood Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     6015450.35777 2096531.9462 37.7375453329415 -122.389057616714 (37.7375453329415, -122.389057616714) 10 3 8 58 1
5062 80388 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1746 Fitzgerald Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   9     6011768.66094 2092717.74347 37.7268675545821 -122.401519069956 (37.7268675545821, -122.401519069956) 10 3 8 58 1
7115 4034 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2150 Cesar Chavez St 8 Sidewalk: Curb side : Cutout Tree DPW 1   04/28/1995 12:00:00 AM 3 3X3   6012617.9559004 2100994.1740901 37.7496402484926 -122.399163766262 (37.7496402484926, -122.399163766262) 10 3 8 58 1
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
103046 4032 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2150 Cesar Chavez St 6 Sidewalk: Curb side : Cutout Tree DPW 1   04/01/1995 12:00:00 AM 3 3X3   6012617.9559004 2100994.1740901 37.7496402484926 -122.399163766262 (37.7496402484926, -122.399163766262) 10 3 8 58 1
104059 6398 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 4X Matthew Ct 2 Sidewalk: Curb side : Cutout Tree DPW 1   02/13/1998 12:00:00 AM 12 3X3   6018041.9202743 2094226.9871977 37.7313596862419 -122.379937152762 (37.7313596862419, -122.379937152762) 10 3 8 58 1
107262 16450 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1395 Newcomb Ave 13 Sidewalk: Curb side : Cutout Tree DPW 1     3 3x3   6016285.996927 2094866.016739 37.7330173117391 -122.386052291775 (37.7330173117391, -122.386052291775) 10 3 8 58 1
108318 196451 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1950 Cesar Chavez St 3 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6013299.05466 2101039.80695 37.7498034800424 -122.396811684714 (37.7498034800424, -122.396811684714) 10 3 8 28856 1
114826 109720 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 91x Jennings Ct 3 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6013003.04663 2089225.87008 37.7173483736975 -122.39700707234 (37.7173483736975, -122.39700707234) 10 3 8 58 1
117759 202308 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 178 Orsi Cir 1 : Tree Private 2     2 Width 2ft   6013012.36975 2092926.2043 37.7275092640335 -122.397234179931 (37.7275092640335, -122.397234179931) 10 3 8 58 1
120351 16451 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1395 Newcomb Ave 14 Sidewalk: Curb side : Cutout Tree DPW 1   09/29/2009 12:00:00 AM 3 3x3   6016285.996927 2094866.016739 37.7330173117391 -122.386052291775 (37.7330173117391, -122.386052291775) 10 3 8 58 1
121388 196464 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1301 Cesar Chavez St 6 : Tree Private 2     9 Width 3ft   6015016.3527 2101061.74011 37.7499591392145 -122.390874677125 (37.7499591392145, -122.390874677125) 10 3 8 58 1
124216 196475 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 58 Ceres St 1 : Tree Private 2     2 Width 3ft   6013844.58264 2093878.59608 37.7301706349557 -122.394423850694 (37.7301706349557, -122.394423850694) 10 3 8 58 1
124323 196466 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1101 Cesar Chavez St 7 : Tree Private 2     6 Width 3ft   6015450.2681 2101056.0343 37.7499675388841 -122.389373764399 (37.7499675388841, -122.389373764399) 10 3 8 58 1
124385 196469 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1001 Cesar Chavez St 1 : Tree Private 2     5 Width 3ft   6015764.4296 2101073.59632 37.750033173207 -122.388288593857 (37.750033173207, -122.388288593857) 10 3 8 58 1
124816 52158 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1418 Underwood Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/31/2005 12:00:00 AM     Permit Number 48350 6015559.23625291 2093031.45294248 37.7279397177829 -122.388436912151 (37.7279397177829, -122.388436912151) 10 3 8 58 1
124827 256030 Undocumented 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1439 Shafter Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6015739 2093499 37.7292334688727 -122.387848068648 (37.7292334688727, -122.387848068648) 10 3 8 58 1
129113 201292 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 82 Lydia Ave 1 : Tree Private 2     2 Width 2ft   6012604.14806 2093027.69229 37.7277651940081 -122.398652533104 (37.7277651940081, -122.398652533104) 10 3 8 58 1
134237 94878 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 56 Ledyard St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/23/2010 12:00:00 AM   3x3 Permit Number 53946 6011673 2095004 37.73313980136 -122.402010422944 (37.73313980136, -122.402010422944) 10 3 8 58 1
134486 196470 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1950 Newcomb Ave 4 Sidewalk: Property side : Yard Tree Private 2     8 Width 9ft   6013295.58948 2097174.20298 37.7391891560441 -122.396552730329 (37.7391891560441, -122.396552730329) 10 3 8 58 1
135218 94946 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
136588 27728 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1200 Cesar Chavez St 5 Sidewalk: Curb side : Cutout Tree DPW 1   03/23/2006 12:00:00 AM 3 3X3   6015202.17288 2101166.08495 37.750255956855 -122.390239385253 (37.750255956855, -122.390239385253) 10 3 8 28856 1
138969 202042 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 52 Exeter St 1 : Tree Private 2     1 Width 3ft   6012532.81359 2090984.99672 37.7221523937885 -122.398755844523 (37.7221523937885, -122.398755844523) 10 3 8 58 1
141200 4051 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2550 Cesar Chavez St 2 Sidewalk: Curb side : Cutout Tree DPW 1   03/23/2006 12:00:00 AM 3 3X3   6011835.74556 2100958.0718 37.749497496525 -122.401866156092 (37.749497496525, -122.401866156092) 10 3 8 58 1
141653 196472 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2500 Newhall St 2 : Tree Private 2     5 Width 3ft   6012828.31305 2093641.68277 37.7294635726784 -122.39792063783 (37.7294635726784, -122.39792063783) 10 3 8 58 1
142295 196471 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1 Middle Point Rd 5 Sidewalk: Property side : Yard Tree Private 2     6 Width 6ft   6018269.46967 2096338.3756 37.7371696942217 -122.379297066815 (37.7371696942217, -122.379297066815) 10 3 8 58 1
145893 196455 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1950 Cesar Chavez St 11 : Tree Private 2     6 Width 3ft   6012871.43703 2101015.96129 37.7497141944763 -122.39828874204 (37.7497141944763, -122.39828874204) 10 3 8 28856 1
150047 196509 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 50 Matthew Ct 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6017994.96949 2094236.9761 37.7313845236547 -122.380100165912 (37.7313845236547, -122.380100165912) 10 3 8 58 1
151292 196510 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 50 Matthew Ct 3 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6017931.22478 2094293.63767 37.7315365882339 -122.380324481997 (37.7315365882339, -122.380324481997) 10 3 8 58 1
153844 39995 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 869 Innes Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/26/2004 12:00:00 AM 6 3x3 Permit Number 47551 6019405.77873 2094282.05396 37.7315860320638 -122.375225801726 (37.7315860320638, -122.375225801726) 10 3 8 58 1
155204 82634 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 863 Meade Ave 3 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
156519 196450 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1950 Cesar Chavez St 1 : Tree Private 2     1 Width 3ft   6013387.24706 2101044.34817 37.7498208576628 -122.3965070277 (37.7498208576628, -122.3965070277) 10 3 8 28856 1
157822 196456 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1950 Cesar Chavez St 12 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6012848.61003 2101014.24206 37.7497082022719 -122.398367558612 (37.7497082022719, -122.398367558612) 10 3 8 28856 1
160003 82703 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 67 Jennings Ct 1 Sidewalk: Curb side : Cutout Tree Private 2   07/09/2009 12:00:00 AM 6 3x3 Permit Number 52500 6012950.17329 2089208.10371 37.7172966473952 -122.39718858698 (37.7172966473952, -122.39718858698) 10 3 8 58 1
160146 196468 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1101 Cesar Chavez St 12 : Tree Private 2     8 Width 3ft   6015629.24905 2101065.86664 37.7500044578413 -122.388755520048 (37.7500044578413, -122.388755520048) 10 3 8 58 1
160198 196465 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1101 Cesar Chavez St 3 : Tree Private 2     3 Width 3ft   6015262.99985 2101056.82815 37.7499593343528 -122.390021408488 (37.7499593343528, -122.390021408488) 10 3 8 58 1
162381 109718 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 91x Jennings Ct 1 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   6013027.72582 2089252.65271 37.7174232872231 -122.396923644015 (37.7174232872231, -122.396923644015) 10 3 8 58 1
163625 4050 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2550 Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree DPW 1   04/01/1995 12:00:00 AM 3 3X3   6011878.42608 2100960.18387 37.7495056776496 -122.401718713171 (37.7495056776496, -122.401718713171) 10 3 8 58 1
164139 196453 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1950 Cesar Chavez St 7 : Tree Private 2     2 Width 3ft   6012987.92898 2101021.89129 37.7497369652948 -122.397886321506 (37.7497369652948, -122.397886321506) 10 3 8 28856 1
167856 196505 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 3536 Jennings St 3 Sidewalk: Curb side : Yard Tree Private 2     2 Width 3ft   6013064.41888 2089502.00277 37.7181099951501 -122.396814283753 (37.7181099951501, -122.396814283753) 10 3 8 58 1
169456 16412 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1200X Newcomb Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   02/20/2008 12:00:00 AM 3 3x3   6016451.798598 2094870.875206 37.7330398269448 -122.385479404945 (37.7330398269448, -122.385479404945) 10 3 8 58 1
169537 4020 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1760 Cesar Chavez St 3 Sidewalk: Curb side : Cutout Tree DPW 1   04/01/1995 12:00:00 AM 3 2X3   6013957.30178 2101067.5315943 37.7499162221241 -122.394537361718 (37.7499162221241, -122.394537361718) 10 3 8 58 1
171132 16413 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1200X Newcomb Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   02/20/2008 12:00:00 AM 3 3x3   6016451.798598 2094870.875206 37.7330398269448 -122.385479404945 (37.7330398269448, -122.385479404945) 10 3 8 58 1
171569 10995 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1544 Hudson Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6016004.21156 2097242.69659 37.7395275952262 -122.387192226744 (37.7395275952262, -122.387192226744) 10 3 8 58 1
173058 202147 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1979 Armstrong Ave 1 Sidewalk: Property side : Yard Tree Private 2     8 Width 7ft   6012955.25231 2093506.82348 37.7291003454988 -122.397472339298 (37.7291003454988, -122.397472339298) 10 3 8 58 1
173375 4018 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1760 Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/01/1995 12:00:00 AM 3 2X3   6013908.29896 2101074.88916 37.7499337000814 -122.394707332299 (37.7499337000814, -122.394707332299) 10 3 8 58 1
178020 82701 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 863 Meade Ave 2 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
179139 4028 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2150 Cesar Chavez St 2 Sidewalk: Curb side : Cutout Tree DPW 1   12/17/2003 12:00:00 AM 3 3X3   6012617.9559004 2100994.1740901 37.7496402484926 -122.399163766262 (37.7496402484926, -122.399163766262) 10 3 8 58 1
180723 256031 Undocumented 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1431 Shafter Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6015779 2093470 37.7291560564579 -122.387707761404 (37.7291560564579, -122.387707761404) 10 3 8 58 1
182681 201275 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 210 Kalmanovitz St 4 Sidewalk: Curb side : Yard Tree Private 2     3 Width 2ft   6013023.37655 2092747.78816 37.7270199824665 -122.397183623634 (37.7270199824665, -122.397183623634) 10 3 8 58 1
183446 22527 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 6600 03rd St 7 Median : Cutout Tree DPW 1     3 3X3   6012847.5284056 2089784.7633559 37.7188743244909 -122.397583806576 (37.7188743244909, -122.397583806576) 10 3 8 58 1
184209 196507 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 65 Whitney Young Cir 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6016757.42802 2094967.10967 37.7333209726796 -122.384429453683 (37.7333209726796, -122.384429453683) 10 3 8 58 1
185279 196454 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 1950 Cesar Chavez St 10 : Tree Private 2     1 Width 3ft   6012891.82767 2101016.42082 37.7497165920542 -122.398218262172 (37.7497165920542, -122.398218262172) 10 3 8 28856 1
185463 109721 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 91x Jennings Ct 4 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   6012983.30026 2089217.17599 37.717323402237 -122.397074717543 (37.717323402237, -122.397074717543) 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)
);