Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes ▼ | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 61031 | 61031 | 78658 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 650 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/2000 12:00:00 AM | 7 | 6012076.113030001 | 2105354.08238 | 37.761581389203 | -122.401343843369 | (37.761581389203, -122.401343843369) | ||
| 62438 | 62438 | 73489 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 45 Newton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/18/1995 12:00:00 AM | 7 | 6000901.50106 | 2088195.8414200002 | 37.713839073386104 | -122.438762613813 | (37.7138390733861, -122.438762613813) | ||
| 62983 | 62983 | 78496 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 837 Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/2000 12:00:00 AM | 4 | 6011334.80311 | 2104438.72087 | 37.7590266229899 | -122.403843331831 | (37.7590266229899, -122.403843331831) | ||
| 63192 | 63192 | 73419 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 608 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1996 12:00:00 AM | 5 | 5988811.35353 | 2111153.65157 | 37.7761799433929 | -122.48223111012 | (37.7761799433929, -122.48223111012) | ||
| 63896 | 63896 | 71218 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2271 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1995 12:00:00 AM | 7 | 5988222.5624 | 2099870.3089 | 37.745164689130604 | -122.483440513109 | (37.7451646891306, -122.483440513109) | ||
| 65257 | 65257 | 70994 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2419 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1995 12:00:00 AM | 7 | 5989807.1077 | 2098888.9436 | 37.742562211693894 | -122.47788976061199 | (37.7425622116939, -122.477889760612) | ||
| 65433 | 65433 | 72295 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 142 Freelon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/1996 12:00:00 AM | 4 | 6013238.890240001 | 2111406.12615 | 37.7782637520155 | -122.39774676201901 | (37.7782637520155, -122.397746762019) | ||
| 65893 | 65893 | 71939 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 3380 Sacramento St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/1996 12:00:00 AM | 6 | 5998663.45134 | 2115273.98643 | 37.788061440327 | -122.44844697584601 | (37.788061440327, -122.448446975846) | ||
| 66361 | 66361 | 72296 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 146 Freelon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/1996 12:00:00 AM | 9 | 6013222.13416 | 2111389.89822 | 37.7782182607083 | -122.397803589275 | (37.7782182607083, -122.397803589275) | ||
| 66886 | 66886 | 70849 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 342 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1996 12:00:00 AM | 8 | 6002406.02923 | 2091608.4235099999 | 37.723294745932705 | -122.43380617753799 | (37.7232947459327, -122.433806177538) | ||
| 68533 | 68533 | 84610 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 535 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/16/2006 12:00:00 AM | 5 | 5987793.08995 | 2112320.51653 | 37.779324545193504 | -122.48583917997499 | (37.7793245451935, -122.485839179975) | ||
| 72443 | 72443 | 72336 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 778 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1996 12:00:00 AM | 2 | 5988856.368369999 | 2110023.7743599997 | 37.7730802324948 | -122.481992604718 | (37.7730802324948, -122.481992604718) | ||
| 72721 | 72721 | 72129 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1183 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/25/1984 12:00:00 AM | 8 | 6012255.77606 | 2102909.56429 | 37.754879303143504 | -122.40055073574499 | (37.7548793031435, -122.400550735745) | ||
| 73480 | 73480 | 72247 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 463 Lisbon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1996 12:00:00 AM | 8 | 6002254.00349 | 2090778.2369799998 | 37.721006611639204 | -122.434272377969 | (37.7210066116392, -122.434272377969) | ||
| 74155 | 74155 | 78475 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 3075 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/2000 12:00:00 AM | 4 | 5989336.6982 | 2094888.29675 | 37.731550155411504 | -122.479223685537 | (37.7315501554115, -122.479223685537) | ||
| 74408 | 74408 | 83942 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1118 Fitzgerald Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/29/2006 12:00:00 AM | 3 | 6015103.3012 | 2090231.7832 | 37.72022710350421 | -122.389817632552 | (37.7202271035042, -122.389817632552) | ||
| 75237 | 75237 | 78471 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 62 Colby St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/16/2000 12:00:00 AM | 6 | 6007985.29967 | 2093778.54228 | 37.7295684489024 | -122.414673138765 | (37.7295684489024, -122.414673138765) | ||
| 76707 | 76707 | 70037 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 75 Cook St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/03/1990 12:00:00 AM | 8 | 5997501.9549 | 2113240.3611 | 37.7824111665106 | -122.452318727664 | (37.7824111665106, -122.452318727664) | ||
| 77340 | 77340 | 112100 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 200X RICHLAND AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10 | 6006012.0 | 2096107.0 | 37.7358508133721 | -122.421660362723 | (37.7358508133721, -122.421660362723) | |||
| 78997 | 78997 | 112099 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 200X RICHLAND AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6 | 6006012.0 | 2096107.0 | 37.7358508133721 | -122.421660362723 | (37.7358508133721, -122.421660362723) | |||
| 80264 | 80264 | 116708 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2699 18th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6009829.68874677 | 2105460.44811296 | 37.7617478547189 | -122.40912084667299 | (37.7617478547189, -122.409120846673) | ||||
| 82303 | 82303 | 116707 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2699 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6009829.68874677 | 2105460.44811296 | 37.7617478547189 | -122.40912084667299 | (37.7617478547189, -122.409120846673) | ||||
| 83862 | 83862 | 121571 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 35 Woodward St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6006513.38590805 | 2108286.22014995 | 37.7693204178219 | -122.420791248972 | (37.7693204178219, -122.420791248972) | ||||
| 95909 | 95909 | 72416 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 3764 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/1996 12:00:00 AM | 8 | 5996845.41624 | 2115021.6406900003 | 37.7872644530409 | -122.454718783966 | (37.7872644530409, -122.454718783966) | ||
| 101824 | 101824 | 80603 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 888 Tennessee St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/2002 12:00:00 AM | 4 | 6015452.3757 | 2105055.8553299997 | 37.7609503151357 | -122.389645800319 | (37.7609503151357, -122.389645800319) | ||
| 103586 | 103586 | 56625 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1220 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/19/1987 12:00:00 AM | 6001937.86252386 | 2100536.90799986 | 37.747783725843895 | -122.436063136304 | (37.7477837258439, -122.436063136304) | |||
| 106592 | 106592 | 112101 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 200X RICHLAND AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 4 | 6006012.0 | 2096107.0 | 37.7358508133721 | -122.421660362723 | (37.7358508133721, -122.421660362723) | |||
| 108021 | 108021 | 112102 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 200X RICHLAND AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5 | 6006012.0 | 2096107.0 | 37.7358508133721 | -122.421660362723 | (37.7358508133721, -122.421660362723) | |||
| 113514 | 113514 | 113368 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 90 Bronte St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6009303.14527846 | 2096925.28322047 | 37.738282678059605 | -122.41033928886101 | (37.7382826780596, -122.410339288861) | ||||
| 120043 | 120043 | 79075 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 48 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/19/2001 12:00:00 AM | 7 | 6004984.949680001 | 2093183.06085 | 37.7277643594307 | -122.425003312057 | (37.7277643594307, -122.425003312057) | ||
| 126754 | 126754 | 70910 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 45 Newton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/18/1995 12:00:00 AM | 8 | 6000896.54528 | 2088212.43618 | 37.7138843569546 | -122.43878093122 | (37.7138843569546, -122.43878093122) | ||
| 130109 | 130109 | 78715 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 190 Schwerin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2000 12:00:00 AM | 5 | 6008812.7369 | 2086938.0409099997 | 37.710832318719504 | -122.411329543927 | (37.7108323187195, -122.411329543927) | ||
| 130457 | 130457 | 80599 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 888 Tennessee St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/2002 12:00:00 AM | 3 | 6015456.308730001 | 2104984.78613 | 37.760755392471104 | -122.389627233831 | (37.7607553924711, -122.389627233831) | ||
| 131220 | 131220 | 71313 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 511 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/1988 12:00:00 AM | 8 | 6000110.1474 | 2110767.8868 | 37.775771458645 | -122.44311792788 | (37.775771458645, -122.44311792788) | ||
| 131493 | 131493 | 70597 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 335 Moscow St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/06/1994 12:00:00 AM | 9 | 6004431.1841 | 2091192.53872 | 37.722267528596 | -122.42677599542101 | (37.722267528596, -122.426775995421) | ||
| 132317 | 132317 | 71316 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 558 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1995 12:00:00 AM | 13 | 6003372.2866 | 2090101.06042 | 37.7192106439431 | -122.43035851582701 | (37.7192106439431, -122.430358515827) | ||
| 133766 | 133766 | 71441 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 900 Sansome St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1995 12:00:00 AM | 6 | 6012101.83844 | 2118902.5962 | 37.7987839069199 | -122.40220745600901 | (37.7987839069199, -122.402207456009) | ||
| 136253 | 136253 | 71285 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 270 Ewing Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/16/1982 12:00:00 AM | 4 | 5998459.8578 | 2112234.4023 | 37.7797038956885 | -122.44893233274901 | (37.7797038956885, -122.448932332749) | ||
| 136955 | 136955 | 79204 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 175 Langton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/09/2002 12:00:00 AM | 4 | 6010493.03003 | 2110416.65916 | 37.7753936142481 | -122.40717598278499 | (37.7753936142481, -122.407175982785) |
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");