Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSpecies, qSiteInfo, PlantType, qCaretaker, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes ▼ | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4846 | 4846 | 76677 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 423 Burrows St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/1994 12:00:00 AM | 3 | 6010109.0 | 2093148.0 | 37.7279562025478 | -122.407286823302 | (37.7279562025478, -122.407286823302) | ||
| 7047 | 7047 | 71287 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 225 Ewing Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/16/1982 12:00:00 AM | 6 | 5998480.7052 | 2112368.9268 | 37.780074457240794 | -122.448869905513 | (37.7800744572408, -122.448869905513) | ||
| 7256 | 7256 | 71253 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1436 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/1995 12:00:00 AM | 10 | 3x3 | 6007270.15279 | 2117448.61656 | 37.7945207624857 | -122.418823519012 | (37.7945207624857, -122.418823519012) | |
| 8381 | 8381 | 71797 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2033 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/1995 12:00:00 AM | 6 | 5998131.4502 | 2109940.9744 | 37.7733879494567 | -122.44990310006399 | (37.7733879494567, -122.449903100064) | ||
| 10461 | 10461 | 92319 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 35 | 2788 34th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2008 12:00:00 AM | 3 | 3x3 | 5985889.2586 | 2096423.8922 | 37.7355656712712 | -122.491254961509 | (37.7355656712712, -122.491254961509) | |
| 10582 | 10582 | 69800 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 367 Delano Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2000 12:00:00 AM | 3 | 3x3 | 5999779.7835 | 2091764.7216900003 | 37.7235745268131 | -122.442895800812 | (37.7235745268131, -122.442895800812) | |
| 10597 | 10597 | 92315 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 35 | 2783 34th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2008 12:00:00 AM | 3 | 3x3 | 5985839.9086 | 2096474.3035 | 37.73570120363421 | -122.491429290175 | (37.7357012036342, -122.491429290175) | |
| 10790 | 10790 | 80073 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 35 | 2788 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2008 12:00:00 AM | 3 | 5985889.2586 | 2096432.3825 | 37.735588983385 | -122.49125558617901 | (37.735588983385, -122.491255586179) | ||
| 10899 | 10899 | 92314 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 35 | 2783 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2008 12:00:00 AM | 3 | 3x3 | 5985837.7861 | 2096464.2212 | 37.7356733962807 | -122.491435886509 | (37.7356733962807, -122.491435886509) | |
| 12422 | 12422 | 70297 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 82 Rotteck St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/20/2016 12:00:00 AM | 3 | 6003327.44558 | 2094643.03884 | 37.7316793628021 | -122.43083747856001 | (37.7316793628021, -122.43083747856) | ||
| 12500 | 12500 | 92318 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 35 | 2787 34th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2008 12:00:00 AM | 3 | 3x3 | 5985842.0312 | 2096446.1793 | 37.7356241060746 | -122.49141988222999 | (37.7356241060746, -122.49141988223) | |
| 12690 | 12690 | 92317 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 35 | 2787 34th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2008 12:00:00 AM | 3 | 3x3 | 5985840.9699 | 2096433.9745 | 37.7355905329114 | -122.491422653463 | (37.7355905329114, -122.491422653463) | |
| 13114 | 13114 | 92316 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 35 | 2787 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2008 12:00:00 AM | 3 | 3x3 | 5985840.4393 | 2096424.4229 | 37.7355642757438 | -122.49142378511002 | (37.7355642757438, -122.49142378511) | |
| 23692 | 23692 | 71227 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2270 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1995 12:00:00 AM | 6 | 5987645.1852 | 2099845.9848 | 37.7450642803204 | -122.48543517398599 | (37.7450642803204, -122.485435173986) | ||
| 23887 | 23887 | 83255 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 790 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 1 | 5983253.61867 | 2110435.38712 | 37.773882958787205 | -122.501403365431 | (37.7738829587872, -122.501403365431) | |||
| 23899 | 23899 | 72385 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 686 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/1996 12:00:00 AM | 8 | 5995057.69186 | 2110887.03516 | 37.775809229939206 | -122.460604158861 | (37.7758092299392, -122.460604158861) | ||
| 24726 | 24726 | 72266 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 359 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1996 12:00:00 AM | 12 | 6002393.10905 | 2091502.19798 | 37.7230023412585 | -122.43384325116999 | (37.7230023412585, -122.43384325117) | ||
| 24978 | 24978 | 70667 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 20 Langton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/10/1994 12:00:00 AM | 8 | 6009828.97228 | 2111081.0117200003 | 37.777180585152394 | -122.40952002252399 | (37.7771805851524, -122.409520022524) | ||
| 25010 | 25010 | 78257 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 538 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/2000 12:00:00 AM | 7 | 6003439.3186800005 | 2090205.80452 | 37.7195020449593 | -122.430134279779 | (37.7195020449593, -122.430134279779) | ||
| 25042 | 25042 | 70403 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 215 Oxford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | 18 | 6006511.50188 | 2092924.3025099998 | 37.7271399781258 | -122.419707630826 | (37.7271399781258, -122.419707630826) | ||
| 26028 | 26028 | 78318 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 605 Colby St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/2000 12:00:00 AM | 5 | 3x6 | 6008900.368419999 | 2091273.5690900001 | 37.722741693447105 | -122.411332749116 | (37.7227416934471, -122.411332749116) | |
| 26055 | 26055 | 70169 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 5233 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1993 12:00:00 AM | 3 | 5982394.507019999 | 2111657.31782 | 37.777187531817496 | -122.504465669217 | (37.7771875318175, -122.504465669217) | ||
| 26685 | 26685 | 72437 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 3770 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/1996 12:00:00 AM | 8 | 5996832.97473 | 2115019.84204 | 37.7872588007918 | -122.45476169870001 | (37.7872588007918, -122.4547616987) | ||
| 27208 | 27208 | 78214 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 743 Brussels St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/2000 12:00:00 AM | 5 | 6011081.23974 | 2091316.8573 | 37.722982629931295 | -122.403796950193 | (37.7229826299313, -122.403796950193) | ||
| 27234 | 27234 | 73651 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2484 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/02/1990 12:00:00 AM | 6 | 5989869.6737 | 2098462.6897 | 37.7413954601505 | -122.477642278142 | (37.7413954601505, -122.477642278142) | ||
| 27276 | 27276 | 84392 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2101 Jerrold Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/29/2006 12:00:00 AM | 3 | 6012504.257680001 | 2099077.65785 | 37.744371568599796 | -122.39942241122499 | (37.7443715685998, -122.399422411225) | ||
| 27720 | 27720 | 72005 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1963 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/16/1995 12:00:00 AM | 5 | 5987221.7723 | 2101915.2958 | 37.7507213765199 | -122.487051188188 | (37.7507213765199, -122.487051188188) | ||
| 28035 | 28035 | 73552 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1558 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/1988 12:00:00 AM | 7 | 6000334.7955 | 2110645.2290000003 | 37.775447477965706 | -122.4423320082 | (37.7754474779657, -122.4423320082) | ||
| 28507 | 28507 | 73526 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 807 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/11/1996 12:00:00 AM | 8 | 6009578.52705 | 2116144.74687 | 37.791070356964205 | -122.41074409605899 | (37.7910703569642, -122.410744096059) | ||
| 28586 | 28586 | 69849 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 22 Bernice St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/09/2002 12:00:00 AM | 6 | 6008480.655259999 | 2108494.13228 | 37.7700019816405 | -122.414001247166 | (37.7700019816405, -122.414001247166) | ||
| 28848 | 28848 | 78416 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2959 20th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/2000 12:00:00 AM | 5 | 5990231.308540001 | 2095554.29925 | 37.7334307457305 | -122.47617950378 | (37.7334307457305, -122.47617950378) | ||
| 29045 | 29045 | 78786 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1356 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/2002 12:00:00 AM | 7 | 6001332.0848 | 2110785.1298 | 37.7758884007732 | -122.438892183533 | (37.7758884007732, -122.438892183533) | ||
| 29579 | 29579 | 70603 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 242 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/06/1994 12:00:00 AM | 10 | 6004588.06185 | 2091017.9173400002 | 37.7217969250666 | -122.42622128008999 | (37.7217969250666, -122.42622128009) | ||
| 30204 | 30204 | 74333 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1118 Fitzgerald Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/12/2002 12:00:00 AM | 4 | 6015132.5367 | 2090213.511 | 37.720178552846 | -122.389715298726 | (37.720178552846, -122.389715298726) | ||
| 31181 | 31181 | 73534 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2122 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1995 12:00:00 AM | 2 | 5988232.3443 | 2100841.764 | 37.7478326165783 | -122.483477893757 | (37.7478326165783, -122.483477893757) | ||
| 31893 | 31893 | 79837 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2808 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/2002 12:00:00 AM | 6 | 6006109.456119999 | 2120466.37489 | 37.80274134031279 | -122.42305427704599 | (37.8027413403128, -122.423054277046) | ||
| 32142 | 32142 | 78209 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 602 Girard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/2000 12:00:00 AM | 7 | 6011148.7159 | 2091968.9624700001 | 37.7247769455958 | -122.403609556646 | (37.7247769455958, -122.403609556646) | ||
| 32322 | 32322 | 80604 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 888 Tennessee St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/2002 12:00:00 AM | 3 | 6015452.956 | 2105074.08431 | 37.761000400173295 | -122.38964506649201 | (37.7610004001733, -122.389645066492) | ||
| 32627 | 32627 | 78659 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 238 Ottawa Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/2000 12:00:00 AM | 5 | 5998369.991909999 | 2089313.5256400001 | 37.7167636327026 | -122.447592817774 | (37.7167636327026, -122.447592817774) | ||
| 32900 | 32900 | 78278 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1129 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2000 12:00:00 AM | 3 | 6000344.02965 | 2090524.15486 | 37.720200365833996 | -122.440856356949 | (37.720200365834, -122.440856356949) | ||
| 33147 | 33147 | 78042 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1975 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/2000 12:00:00 AM | 2 | 5986293.4379 | 2101820.6717 | 37.7504073916771 | -122.490254444499 | (37.7504073916771, -122.490254444499) | ||
| 33737 | 33737 | 78509 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 750 Eucalyptus Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/2000 12:00:00 AM | 3 | 5988915.04586 | 2094775.69423 | 37.7312164799499 | -122.48067316246402 | (37.7312164799499, -122.480673162464) | ||
| 34283 | 34283 | 71395 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1553 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1988 12:00:00 AM | 7 | 6015450.35777 | 2096531.9462 | 37.7375453329415 | -122.389057616714 | (37.7375453329415, -122.389057616714) | ||
| 34700 | 34700 | 73853 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 25 Newton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/18/1995 12:00:00 AM | 8 | 6000885.5664 | 2088247.4069700001 | 37.713979754329 | -122.438821382721 | (37.713979754329, -122.438821382721) | ||
| 35355 | 35355 | 70484 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 947 Avalon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/06/1994 12:00:00 AM | 5 | 6005167.83048 | 2092104.0549400002 | 37.724811975074104 | -122.424294379186 | (37.7248119750741, -122.424294379186) | ||
| 35433 | 35433 | 73063 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 774 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/14/1999 12:00:00 AM | 4 | 5992292.3763 | 2110183.95951 | 37.7737192935019 | -122.47011879273799 | (37.7737192935019, -122.470118792738) | ||
| 35596 | 35596 | 79919 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1343 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/2001 12:00:00 AM | 4 | 5988008.149 | 2106155.0675 | 37.762408463106496 | -122.484642830378 | (37.7624084631065, -122.484642830378) | ||
| 36455 | 36455 | 78402 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 593 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/2000 12:00:00 AM | 4 | 5985636.206590001 | 2111885.61878 | 37.7780045190041 | -122.493268584238 | (37.7780045190041, -122.493268584238) | ||
| 37977 | 37977 | 72335 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 775 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1996 12:00:00 AM | 1 | 5988805.09626 | 2110041.06897 | 37.773124736634294 | -122.482171226619 | (37.7731247366343, -122.482171226619) | ||
| 39288 | 39288 | 72315 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 3526 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/1996 12:00:00 AM | 6 | 5997893.64237 | 2115823.01153 | 37.7895248738152 | -122.45114997549601 | (37.7895248738152, -122.451149975496) | ||
| 39418 | 39418 | 78260 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 567 Girard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/2000 12:00:00 AM | 7 | 6011132.1649400005 | 2092178.5330700001 | 37.7253514585786 | -122.40368151051202 | (37.7253514585786, -122.403681510512) | ||
| 39626 | 39626 | 78781 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 75 Laura St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/2000 12:00:00 AM | 0 | 5997342.70536 | 2086993.5441299998 | 37.7103347346378 | -122.450976426135 | (37.7103347346378, -122.450976426135) | ||
| 39677 | 39677 | 71213 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2130 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1995 12:00:00 AM | 1 | 5988234.1964 | 2100800.0919 | 37.7477183038635 | -122.483468434844 | (37.7477183038635, -122.483468434844) | ||
| 39708 | 39708 | 70395 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 190 Madison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | 16 | 6005551.028469999 | 2092833.80452 | 37.72683733826221 | -122.423021551618 | (37.7268373382622, -122.423021551618) | ||
| 40544 | 40544 | 73988 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 3380 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/1996 12:00:00 AM | 6 | 5998684.41396 | 2115276.24554 | 37.7880688417562 | -122.44837461191901 | (37.7880688417562, -122.448374611919) | ||
| 41106 | 41106 | 71157 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 807 Mason St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/11/1996 12:00:00 AM | 7 | 6009578.493009999 | 2116131.05118 | 37.7910327500084 | -122.410743246197 | (37.7910327500084, -122.410743246197) | ||
| 41204 | 41204 | 78480 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 575 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/2000 12:00:00 AM | 2 | 6001855.9620900005 | 2090141.3500299999 | 37.719235261989 | -122.43560274687799 | (37.719235261989, -122.435602746878) | ||
| 41417 | 41417 | 78412 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 3035 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/2000 12:00:00 AM | 6 | 5989072.12667 | 2095062.74941 | 37.732013788304 | -122.480151113209 | (37.732013788304, -122.480151113209) | ||
| 42153 | 42153 | 78510 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 750 Eucalyptus Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/2000 12:00:00 AM | 3 | 5988931.24396 | 2094774.45392 | 37.731214015808796 | -122.480617072624 | (37.7312140158088, -122.480617072624) | ||
| 42214 | 42214 | 70598 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 338 Moscow St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/06/1994 12:00:00 AM | 10 | 6004371.476319999 | 2091185.4336299999 | 37.722244643550894 | -122.426981885324 | (37.7222446435509, -122.426981885324) | ||
| 42481 | 42481 | 71284 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 Atalaya Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/07/1981 12:00:00 AM | 5 | 5998802.9816 | 2111041.8064 | 37.7764489521659 | -122.447659448254 | (37.7764489521659, -122.447659448254) | ||
| 43541 | 43541 | 71166 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2123 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1995 12:00:00 AM | 3 | 5988191.5983 | 2100838.0598 | 37.747820074212 | -122.483618518196 | (37.747820074212, -122.483618518196) | ||
| 43640 | 43640 | 72415 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 3732 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/1996 12:00:00 AM | 8 | 5996986.39697 | 2115040.92964 | 37.787325500813395 | -122.45423241709999 | (37.7873255008134, -122.4542324171) | ||
| 44719 | 44719 | 71322 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 426 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1995 12:00:00 AM | 9 | 6003937.60452 | 2089980.93172 | 37.718912802856 | -122.428395868697 | (37.718912802856, -122.428395868697) | ||
| 44768 | 44768 | 121639 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 195 Otsego Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 14 | 6000575.25086 | 2092201.75917 | 37.7248198513454 | -122.440177342728 | (37.7248198513454, -122.440177342728) | |||
| 45057 | 45057 | 70451 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2683 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/1994 12:00:00 AM | 4 | 5983041.4986 | 2096885.6865 | 37.7366668238827 | -122.5011347377 | (37.7366668238827, -122.5011347377) | ||
| 45060 | 45060 | 70199 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 479-481 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/1996 12:00:00 AM | 7 | 5990281.69585 | 2112130.11385 | 37.778946453452896 | -122.477216227307 | (37.7789464534529, -122.477216227307) | ||
| 45067 | 45067 | 70144 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 8 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/15/1993 12:00:00 AM | 6 | 5991175.64413 | 2115000.10527 | 37.7868784805694 | -122.474333220033 | (37.7868784805694, -122.474333220033) | ||
| 45294 | 45294 | 72250 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 360 London St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1996 12:00:00 AM | 7 | 6002105.68115 | 2091634.84352 | 37.7233502412928 | -122.434846310935 | (37.7233502412928, -122.434846310935) | ||
| 45575 | 45575 | 78381 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 631 Moscow St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/2000 12:00:00 AM | 7 | 6003379.385319999 | 2089522.9059 | 37.7176235608499 | -122.43029275202299 | (37.7176235608499, -122.430292752023) | ||
| 45829 | 45829 | 70117 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 25 Newton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/18/1995 12:00:00 AM | 7 | 6000875.3973900005 | 2088278.84235 | 37.714065490318106 | -122.438858781914 | (37.7140654903181, -122.438858781914) | ||
| 46325 | 46325 | 82058 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2663 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3 | 5988935.079 | 2097218.8486 | 37.737925915904896 | -122.480782703185 | (37.7379259159049, -122.480782703185) | |||
| 46566 | 46566 | 80849 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 688-690 Missouri St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/12/2005 12:00:00 AM | 5 | 6013555.65401 | 2103890.07686 | 37.757643986408894 | -122.39612407477699 | (37.7576439864089, -122.396124074777) | ||
| 46952 | 46952 | 72003 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1991 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/16/1995 12:00:00 AM | 4 | 5987539.672 | 2101751.7111 | 37.75029074773129 | -122.48593987171101 | (37.7502907477313, -122.485939871711) | ||
| 47150 | 47150 | 81654 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1773 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/14/2004 12:00:00 AM | 6 | 6014140.03196 | 2096118.2922200002 | 37.7363368024053 | -122.393559125566 | (37.7363368024053, -122.393559125566) | ||
| 47754 | 47754 | 78568 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1192 Bowdoin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/2000 12:00:00 AM | 9 | 6009666.22083 | 2090670.9365 | 37.7211299140849 | -122.408642858878 | (37.7211299140849, -122.408642858878) | ||
| 48211 | 48211 | 73744 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 35 Almaden Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/1996 12:00:00 AM | 5 | 5995854.8721 | 2112478.1679599998 | 37.7802238906314 | -122.45796169978998 | (37.7802238906314, -122.45796169979) | ||
| 48882 | 48882 | 111292 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 291 14th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 4 | 5991505.832330001 | 2113494.12901 | 37.78276261074429 | -122.47308099011002 | (37.7827626107443, -122.47308099011) | |||
| 48912 | 48912 | 70236 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2028 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1994 12:00:00 AM | 5 | 5998104.2899 | 2110331.105 | 37.7744575935246 | -122.450025174657 | (37.7744575935246, -122.450025174657) | ||
| 49613 | 49613 | 70985 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 3744 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/1996 12:00:00 AM | 8 | 5996925.91149 | 2115035.19353 | 37.787306282296 | -122.454441268476 | (37.787306282296, -122.454441268476) | ||
| 49933 | 49933 | 78363 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 575 Lisbon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/2000 12:00:00 AM | 6 | 6001858.247830001 | 2090145.2543799998 | 37.719246112288104 | -122.43559512512199 | (37.7192461122881, -122.435595125122) | ||
| 50364 | 50364 | 74315 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 50 Delano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2000 12:00:00 AM | 6 | 6000588.288430001 | 2093013.22945 | 37.727048705022895 | -122.440190437741 | (37.7270487050229, -122.440190437741) | ||
| 51040 | 51040 | 80385 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1754 Fitzgerald Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2002 12:00:00 AM | 8 | 6011729.10125 | 2092748.5600299998 | 37.7269499630479 | -122.40165799273599 | (37.7269499630479, -122.401657992736) | ||
| 52984 | 52984 | 69922 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1479 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/17/1990 12:00:00 AM | 6 | 5987109.7204 | 2105224.4854 | 37.7598009776001 | -122.487681752733 | (37.7598009776001, -122.487681752733) | ||
| 53715 | 53715 | 72507 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2135 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/1996 12:00:00 AM | 6 | 5988189.7462 | 2100767.6803 | 37.747626723008295 | -122.48361976345801 | (37.7476267230083, -122.483619763458) | ||
| 54203 | 54203 | 78243 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 30 Delano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2000 12:00:00 AM | 7 | 6000646.02726 | 2093117.37413 | 37.727337949475896 | -122.439998300301 | (37.7273379494759, -122.439998300301) | ||
| 54349 | 54349 | 79894 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 4119 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/20/2001 12:00:00 AM | 7 | 5982716.5012300005 | 2113074.1195 | 37.78109658773229 | -122.503456745272 | (37.7810965877323, -122.503456745272) | ||
| 54694 | 54694 | 70907 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 46 Paramount Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/1996 12:00:00 AM | 7 | 5996464.672119999 | 2111031.60608 | 37.776287028984704 | -122.455747538559 | (37.7762870289847, -122.455747538559) | ||
| 54724 | 54724 | 71209 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2170 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1995 12:00:00 AM | 5 | 5988552.6315 | 2100561.3439 | 37.7470812936995 | -122.48234982645 | (37.7470812936995, -122.48234982645) | ||
| 55122 | 55122 | 71593 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 34 Rhine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 4 | 5994443.94493 | 2086683.2861799998 | 37.70931646014839 | -122.46097260021001 | (37.7093164601484, -122.46097260021) | ||
| 55429 | 55429 | 80602 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 888 Tennessee St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/2002 12:00:00 AM | 3 | 6015452.48136 | 2105039.81643 | 37.760906281622894 | -122.389644314657 | (37.7609062816229, -122.389644314657) | ||
| 55873 | 55873 | 82677 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1627 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/12/2005 12:00:00 AM | 4 | 6014950.6191 | 2094457.8846 | 37.7318226671335 | -122.390640571691 | (37.7318226671335, -122.390640571691) | ||
| 56354 | 56354 | 72253 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 538 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1996 12:00:00 AM | 9 | 6002525.5538800005 | 2090783.37547 | 37.7210361300962 | -122.433334076631 | (37.7210361300962, -122.433334076631) | ||
| 56882 | 56882 | 71807 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2484 21st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/02/1990 12:00:00 AM | 8 | 5989868.5761 | 2098479.5203 | 37.7414416089199 | -122.477647303158 | (37.7414416089199, -122.477647303158) | ||
| 57825 | 57825 | 78914 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 219 Concord St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/2003 12:00:00 AM | 3 | 5999956.6131 | 2087048.59536 | 37.7106351918399 | -122.44194619318 | (37.7106351918399, -122.44194619318) | ||
| 58345 | 58345 | 72333 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 522 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1996 12:00:00 AM | 11 | 5989411.86479 | 2111751.27895 | 37.7778557732807 | -122.48019755247 | (37.7778557732807, -122.48019755247) | ||
| 58403 | 58403 | 72372 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 751 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/1996 12:00:00 AM | 7 | 5990350.04251 | 2110248.78981 | 37.7737848207235 | -122.47684229548099 | (37.7737848207235, -122.476842295481) | ||
| 58748 | 58748 | 121640 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 195 Otsego Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 17 | 6000583.2387 | 2092221.3848599999 | 37.724874193767796 | -122.440151136477 | (37.7248741937678, -122.440151136477) | |||
| 59037 | 59037 | 78388 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 593 33rd Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/2000 12:00:00 AM | 4 | 5985636.69851 | 2111874.46867 | 37.7779739327663 | -122.493266060875 | (37.7779739327663, -122.493266060875) | ||
| 60341 | 60341 | 71286 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 368 Ewing Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/16/1982 12:00:00 AM | 4 | 5998728.4505 | 2112219.5 | 37.7796783347186 | -122.44800208434799 | (37.7796783347186, -122.448002084348) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");