trees
4,014 rows where qSpecies_id = 40 sorted by Supervisor Districts descending
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts ▲ | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );