trees
6,714 rows where qSpecies_id = 7 sorted by PlantDate
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
72 | 135801 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 16 Phoenix Ter | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 2ft | 6008610.92916 | 2117913.61927 | 37.7958729471262 | -122.414217164494 | (37.7958729471262, -122.414217164494) | 5 | 1 | 10 | 308 | 21 | |||
95 | 261359 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3 Bache St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007238 | 2095678 | 37.7347419306018 | -122.417391193891 | (37.7347419306018, -122.417391193891) | 2 | 7 | 7 | 28859 | 2 | ||||
97 | 261358 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2x Bache St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007175 | 2095707 | 37.7348180134015 | -122.417611061749 | (37.7348180134015, -122.417611061749) | 2 | 7 | 7 | 28859 | 2 | ||||
152 | 235666 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1301 Jessie St | 4 | : | Tree | Private 2 | 3 | Width 2ft | 6006462.25734 | 2109005.38337 | 37.7712921868165 | -122.421019169707 | (37.7712921868165, -122.421019169707) | 8 | 2 | 9 | 28853 | 19 | |||
189 | 178694 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 184 Mount Vernon Ave | 7 | Side Yard : Yard | Tree | Private 2 | 9 | 5998957.82756 | 2089383.479 | 37.7169892861082 | -122.445565994978 | (37.7169892861082, -122.445565994978) | 9 | 7 | 6 | 28861 | 25 | ||||
199 | 237529 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1197 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003874.24561 | 2101347.66783 | 37.7501197023675 | -122.429425031242 | (37.7501197023675, -122.429425031242) | 2 | 4 | 5 | 28862 | 22 | |||
211 | 196303 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 249 Shipley St | 1 | : | Tree | Private 2 | 1 | Width 5ft | 6011469.59111 | 2111688.37468 | 37.7789400547713 | -122.403887319468 | (37.7789400547713, -122.403887319468) | 14 | 2 | 9 | 28856 | 34 | |||
259 | 196282 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1 25th St | 13 | : Yard | Tree | Private 2 | 12 | 6015015.25562 | 2102205.64875 | 37.7531000097757 | -122.390958410295 | (37.7531000097757, -122.390958410295) | 10 | 3 | 8 | 28856 | 29 | ||||
312 | 201949 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1650 Carroll Ave | 18 | : | Tree | Private 2 | 2 | Width 3ft | 6013468.57071 | 2092447.06427 | 37.7262190300648 | -122.395623522912 | (37.7262190300648, -122.395623522912) | 10 | 3 | 8 | 58 | 1 | |||
332 | 182987 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1975 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5989890.895 | 2098325.8493 | 37.7410209633467 | -122.477558903564 | (37.7410209633467, -122.477558903564) | 1 | 8 | 3 | 29491 | 35 | |||
389 | 121965 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 20 15th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 5991180.37033 | 2114963.80683 | 37.7867790889821 | -122.474314218886 | (37.7867790889821, -122.474314218886) | 11 | 6 | 1 | 54 | 33 | ||||
437 | 202267 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 28 Orsi Cir | 1 | : | Tree | Private 2 | 5 | Width 2ft | 6013033.98272 | 2093207.99375 | 37.7282842035544 | -122.397179214247 | (37.7282842035544, -122.397179214247) | 10 | 3 | 8 | 58 | 1 | |||
518 | 70144 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 8 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5991175.64413 | 2115000.10527 | 37.7868784805694 | -122.474333220033 | (37.7868784805694, -122.474333220033) | 11 | 6 | 1 | 54 | 33 | |||
604 | 20034 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 STAIRWAY51 | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | ST | |||||||||||||
681 | 71797 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2033 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5998131.4502 | 2109940.9744 | 37.7733879494567 | -122.449903100064 | (37.7733879494567, -122.449903100064) | 15 | 5 | 11 | 29492 | 16 | |||
726 | 213079 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 127 Castenada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5994523.12061 | 2101041.16824 | 37.7487442639422 | -122.461739308234 | (37.7487442639422, -122.461739308234) | 1 | 8 | 4 | 29491 | 40 | |||
816 | 248050 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 38 Rutledge St | 7 | Side Yard : Yard | Tree | Private 2 | 5 | 6010496.13368 | 2099436.61391 | 37.7452450531093 | -122.406391405264 | (37.7452450531093, -122.406391405264) | 2 | 7 | 7 | 28859 | 2 | ||||
839 | 71209 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2170 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5988552.6315 | 2100561.3439 | 37.7470812936995 | -122.48234982645 | (37.7470812936995, -122.48234982645) | 1 | 8 | 3 | 29491 | 35 | |||
902 | 213099 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 48 Brentwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5996420.67751 | 2095562.94637 | 37.733811460225 | -122.454781859719 | (37.733811460225, -122.454781859719) | 9 | 7 | 4 | 59 | 40 | |||
967 | 78568 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1192 Bowdoin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6009666.22083 | 2090670.9365 | 37.7211299140849 | -122.408642858878 | (37.7211299140849, -122.408642858878) | 9 | 3 | 7 | 309 | 28 | |||
994 | 236914 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 341 Moultrie St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007736.81458 | 2097491.93265 | 37.7397506441775 | -122.415795016921 | (37.7397506441775, -122.415795016921) | 2 | 7 | 7 | 28859 | 2 | |||
996 | 70145 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 32 15th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5991181.63526 | 2114912.21638 | 37.7866375092707 | -122.474306076539 | (37.7866375092707, -122.474306076539) | 11 | 6 | 1 | 54 | 33 | |||
1000 | 52636 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 185@ BELMONT Edgewood Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 48718 | 5996563.25999555 | 2105933.66378054 | 37.7622950546263 | -122.455038038603 | (37.7622950546263, -122.455038038603) | 15 | 5 | 11 | 29492 | 12 | ||||
1074 | 80599 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 888 Tennessee St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6015456.30873 | 2104984.78613 | 37.7607553924711 | -122.389627233831 | (37.7607553924711, -122.389627233831) | 10 | 3 | 8 | 28856 | 29 | |||
1128 | 178845 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 543 Sawyer St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007634.8415 | 2086934.39681 | 37.7107561785306 | -122.415400376427 | (37.7107561785306, -122.415400376427) | 9 | 7 | 8 | 309 | 39 | |||
1159 | 70451 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2683 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5983041.4986 | 2096885.6865 | 37.7366668238827 | -122.5011347377 | (37.7366668238827, -122.5011347377) | 1 | 8 | 3 | 29491 | 35 | |||
1236 | 78452 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3075 23rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5989337.22841 | 2094863.71499 | 37.7314826909771 | -122.479220054956 | (37.7314826909771, -122.479220054956) | 1 | 8 | 4 | 64 | 35 | |||
1243 | 237775 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 51 States St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001962.65396 | 2106203.64248 | 37.763344625173 | -122.43638291504 | (37.763344625173, -122.43638291504) | 15 | 5 | 5 | 28862 | 3 | |||
1251 | 218033 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 70 Wawona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5993104.01352 | 2098691.4194 | 37.7422106578044 | -122.466475770336 | (37.7422106578044, -122.466475770336) | 1 | 8 | 4 | 59 | 40 | |||
1276 | 72277 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 819 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5983524.1138 | 2110218.5518 | 37.7733034736496 | -122.500451657892 | (37.7733034736496, -122.500451657892) | 11 | 6 | 2 | 55 | 26 | |||
1429 | 237519 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 155 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6004137.76382 | 2100992.35213 | 37.7491590042859 | -122.428488446692 | (37.7491590042859, -122.428488446692) | 2 | 4 | 5 | 28862 | 22 | |||
1470 | 261195 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 600X Benton Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007231 | 2095349 | 37.7338381748563 | -122.417392087376 | (37.7338381748563, -122.417392087376) | 2 | 7 | 7 | 28859 | 2 | ||||
1550 | 201970 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1651 Carroll Ave | 21 | : | Tree | Private 2 | 3 | Width 3ft | 6013765.00423 | 2092206.62002 | 37.7255753034535 | -122.39458193082 | (37.7255753034535, -122.39458193082) | 10 | 3 | 8 | 58 | 1 | |||
1756 | 217968 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2535 17th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5991076.46377 | 2098128.02027 | 37.74054650193 | -122.473445254517 | (37.74054650193, -122.473445254517) | 1 | 8 | 4 | 29491 | 40 | |||
1775 | 196240 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 477 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6010588.30864 | 2112340.27099 | 37.7806807348789 | -122.406982002622 | (37.7806807348789, -122.406982002622) | 14 | 2 | 9 | 28853 | 34 | |||
1797 | 72003 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1991 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5987539.672 | 2101751.7111 | 37.7502907477313 | -122.485939871711 | (37.7502907477313, -122.485939871711) | 1 | 8 | 3 | 29491 | 35 | |||
1801 | 73988 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3380 Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5998684.41396 | 2115276.24554 | 37.7880688417562 | -122.448374611919 | (37.7880688417562, -122.448374611919) | 13 | 6 | 1 | 54 | 31 | |||
1836 | 214279 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 422 Edna St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5998780.00952 | 2094220.12118 | 37.7302594304325 | -122.446528398166 | (37.7302594304325, -122.446528398166) | 9 | 7 | 4 | 28861 | 40 | |||
1844 | 212645 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 385 Vernon St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 6ft | 5992447.95571 | 2090426.49221 | 37.7194793442858 | -122.468143110712 | (37.7194793442858, -122.468143110712) | 9 | 8 | 6 | 64 | 24 | |||
1922 | 260512 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 180 Stratford Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5990850 | 2091280 | 37.7217304489912 | -122.473728831815 | (37.7217304489912, -122.473728831815) | 9 | 8 | 4 | 64 | 40 | ||||
1931 | 213034 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 119 Edgewood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5996575.5142 | 2106308.44603 | 37.7633248140133 | -122.455022738629 | (37.7633248140133, -122.455022738629) | 15 | 5 | 11 | 29492 | 12 | |||
2046 | 72250 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 360 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6002105.68115 | 2091634.84352 | 37.7233502412928 | -122.434846310935 | (37.7233502412928, -122.434846310935) | 9 | 7 | 6 | 28861 | 5 | |||
2068 | 214271 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 519 Gennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5997445.19027 | 2095126.33403 | 37.7326713410914 | -122.451208353186 | (37.7326713410914, -122.451208353186) | 9 | 7 | 4 | 59 | 40 | |||
2132 | 235898 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3623 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 6x5 | 6005449.14976 | 2104867.03319 | 37.7598721008326 | -122.424229185527 | (37.7598721008326, -122.424229185527) | 2 | 4 | 5 | 28859 | 19 | |||
2141 | 70199 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 479-481 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5990281.69585 | 2112130.11385 | 37.7789464534529 | -122.477216227307 | (37.7789464534529, -122.477216227307) | 11 | 6 | 2 | 55 | 26 | |||
2255 | 236751 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 420 Collingwood St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | 6002101.36864 | 2103370.60532 | 37.7555736715096 | -122.435700446513 | (37.7555736715096, -122.435700446513) | 2 | 4 | 5 | 28862 | 22 | ||||
2298 | 248463 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 130 Beulah St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5997448.7103 | 2107810.4856 | 37.7674990867904 | -122.452111034778 | (37.7674990867904, -122.452111034778) | 15 | 5 | 11 | 29492 | 9 | |||
2423 | 183529 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2590 26th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 0ft | 5988341.8215 | 2097699.5391 | 37.7392112662203 | -122.482869079468 | (37.7392112662203, -122.482869079468) | 1 | 8 | 3 | 29491 | 35 | |||
2505 | 196318 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 323 11th St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6008553.79261 | 2109149.29537 | 37.7718050135221 | -122.413794615322 | (37.7718050135221, -122.413794615322) | 8 | 2 | 9 | 28853 | 34 | |||
2535 | 70599 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 346 Moscow St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6004344.49924 | 2091141.9903 | 37.7221238322355 | -122.427072045934 | (37.7221238322355, -122.427072045934) | 9 | 7 | 6 | 28861 | 5 | |||
2596 | 70483 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 939 Avalon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6005126.74678 | 2092081.98496 | 37.7247490558006 | -122.424434831697 | (37.7247490558006, -122.424434831697) | 9 | 7 | 6 | 28861 | 5 | |||
2669 | 248462 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 130 Beulah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | Permit Number 779787 | 5997458.098 | 2107812.3026 | 37.767504613553 | -122.45207869525 | (37.767504613553, -122.45207869525) | 15 | 5 | 11 | 29492 | 9 | ||
2712 | 84610 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 535 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5987793.08995 | 2112320.51653 | 37.7793245451935 | -122.485839179975 | (37.7793245451935, -122.485839179975) | 11 | 6 | 2 | 55 | 26 | |||
2811 | 246987 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 70 Clipper St | 1 | : | Tree | Private 2 | 11 | Width 3ft | 6004726.23458 | 2101068.69852 | 37.7494019174823 | -122.426458941248 | (37.7494019174823, -122.426458941248) | 2 | 4 | 5 | 28862 | 22 | |||
2821 | 212702 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1350 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5994593.65798 | 2106323.94898 | 37.7632534869818 | -122.461878404565 | (37.7632534869818, -122.461878404565) | 15 | 5 | 11 | 56 | 12 | |||
2922 | 72315 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3526 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5997893.64237 | 2115823.01153 | 37.7895248738152 | -122.451149975496 | (37.7895248738152, -122.451149975496) | 11 | 6 | 1 | 54 | 31 | |||
2984 | 261389 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 611 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010649.76194 | 2118553.23001 | 37.7977434736118 | -122.407207494731 | (37.7977434736118, -122.407207494731) | 3 | 1 | 10 | 308 | 4 | |||||
2987 | 212886 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1941 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 1ft | 5990935.1255 | 2102170.56129 | 37.7516380862328 | -122.474228847281 | (37.7516380862328, -122.474228847281) | 1 | 8 | 4 | 29491 | 12 | |||
3010 | 124046 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 723 12th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 5992224.36446 | 2110496.07608 | 37.7745723492368 | -122.470376788909 | (37.7745723492368, -122.470376788909) | 11 | 6 | 2 | 54 | 11 | |||
3055 | 20039 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 STAIRWAY51 | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | ST | |||||||||||||
3087 | 201271 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 200 Kalmanovitz St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 2ft | 6013058.71274 | 2092794.89099 | 37.7271512843849 | -122.397064767443 | (37.7271512843849, -122.397064767443) | 10 | 3 | 8 | 58 | 1 | |||
3116 | 71316 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 558 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 13 | 6003372.2866 | 2090101.06042 | 37.7192106439431 | -122.430358515827 | (37.7192106439431, -122.430358515827) | 9 | 7 | 6 | 28861 | 5 | |||
3128 | 236759 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 239 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6004655.95554 | 2096917.75381 | 37.7380004006851 | -122.426406454101 | (37.7380004006851, -122.426406454101) | 2 | 7 | 5 | 63 | 7 | |||
3173 | 78509 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 750 Eucalyptus Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5988915.04586 | 2094775.69423 | 37.7312164799499 | -122.480673162464 | (37.7312164799499, -122.480673162464) | 1 | 8 | 4 | 64 | 35 | |||
3278 | 72888 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2506 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5989566.1304 | 2098258.2718 | 37.7408165618747 | -122.478676867492 | (37.7408165618747, -122.478676867492) | 1 | 8 | 3 | 29491 | 35 | |||
3291 | 237670 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 69 Henry St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6003090.82539 | 2107383.74854 | 37.7666489493115 | -122.432565239916 | (37.7666489493115, -122.432565239916) | 15 | 5 | 5 | 28862 | 3 | |||
3299 | 178756 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 47 Garrison Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6008299.13366 | 2086795.43914 | 37.7104119441216 | -122.413094604643 | (37.7104119441216, -122.413094604643) | 9 | 7 | 8 | 309 | 39 | |||
3353 | 261197 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 690x Benton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007331 | 2095336 | 37.7338081055982 | -122.417045435619 | (37.7338081055982, -122.417045435619) | 2 | 7 | 7 | 28859 | 2 | ||||
3475 | 78427 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 721 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6001123.96924 | 2089480.39079 | 37.7173788130682 | -122.438085642862 | (37.7173788130682, -122.438085642862) | 9 | 7 | 6 | 28861 | 5 | |||
3582 | 71321 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 336 Munich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6004246.97959 | 2090473.39754 | 37.7202825081141 | -122.427361543098 | (37.7202825081141, -122.427361543098) | 9 | 7 | 6 | 28861 | 5 | |||
3643 | 202263 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 8 Orsi Cir | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 2ft | 6013104.38405 | 2093156.20787 | 37.7281459291672 | -122.396932202872 | (37.7281459291672, -122.396932202872) | 10 | 3 | 8 | 58 | 1 | |||
3723 | 260511 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 199X Stratford Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5990954 | 2091213 | 37.7215525064104 | -122.47336445039 | (37.7215525064104, -122.47336445039) | 9 | 8 | 4 | 64 | 40 | ||||
3756 | 261450 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 302 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006908 | 2095729 | 37.7348633927281 | -122.418535734777 | (37.7348633927281, -122.418535734777) | 2 | 7 | 7 | 28859 | 2 | ||||
3895 | 78222 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1186 Bowdoin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6009661.32539 | 2090689.78042 | 37.7211813813865 | -122.408661109741 | (37.7211813813865, -122.408661109741) | 9 | 3 | 7 | 309 | 28 | |||
3923 | 25589 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1380X Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 40 | 3X3 | 6009160.7320011 | 2097455.9675675 | 37.7397318376167 | -122.410869155933 | (37.7397318376167, -122.410869155933) | 10 | 7 | 7 | 28859 | 2 | |||
3972 | 73489 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 45 Newton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6000901.50106 | 2088195.84142 | 37.7138390733861 | -122.438762613813 | (37.7138390733861, -122.438762613813) | 9 | 7 | 6 | 28861 | 5 | |||
3989 | 218019 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 645 Santiago St | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 3ft | 5990820.54277 | 2099711.93527 | 37.7448807008818 | -122.474445681024 | (37.7448807008818, -122.474445681024) | 1 | 8 | 4 | 29491 | 40 | |||
4085 | 212397 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 35 San Rafael Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 6ft | 5991907.97112 | 2095768.21214 | 37.7341151819682 | -122.470398435962 | (37.7341151819682, -122.470398435962) | 9 | 8 | 4 | 59 | 40 | |||
4104 | 78658 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 650 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6012076.11303 | 2105354.08238 | 37.761581389203 | -122.401343843369 | (37.761581389203, -122.401343843369) | 10 | 3 | 8 | 28856 | 29 | |||
4181 | 142314 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1685 Grove St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5999759.4558 | 2110518.5336 | 37.7750667961639 | -122.444313131138 | (37.7750667961639, -122.444313131138) | 15 | 5 | 11 | 29492 | 16 | |||
4188 | 236744 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 4201 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6001442.35648 | 2103342.9897 | 37.7554603910923 | -122.437977533533 | (37.7554603910923, -122.437977533533) | 2 | 4 | 5 | 28862 | 22 | |||
4248 | 261193 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 600X Benton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007231 | 2095349 | 37.7338381748563 | -122.417392087376 | (37.7338381748563, -122.417392087376) | 2 | 7 | 7 | 28859 | 2 | ||||
4349 | 212581 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 698 Hearst Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 5996847.55389 | 2094438.38996 | 37.7307481750846 | -122.453224871536 | (37.7307481750846, -122.453224871536) | 9 | 7 | 4 | 59 | 40 | |||
4424 | 261436 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 375 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6007268 | 2095787 | 37.7350429085654 | -122.417295195055 | (37.7350429085654, -122.417295195055) | 2 | 7 | 7 | 28859 | 2 | ||||
4448 | 202285 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 20 Issleib Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 2ft | 6012731.44947 | 2093293.25918 | 37.7285014779546 | -122.398231071208 | (37.7285014779546, -122.398231071208) | 10 | 3 | 8 | 58 | 1 | |||
4609 | 236279 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 342 Capp St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007175.75737 | 2105294.6184 | 37.761143491293 | -122.418287995211 | (37.761143491293, -122.418287995211) | 2 | 4 | 7 | 28859 | 19 | |||
4679 | 236258 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 900 Alabama St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009116.08466 | 2103840.92057 | 37.7572609975042 | -122.411474503866 | (37.7572609975042, -122.411474503866) | 2 | 4 | 7 | 28859 | 19 | |||
4741 | 236777 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 540 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003149.68066 | 2096096.4709 | 37.7356600832353 | -122.431555771598 | (37.7356600832353, -122.431555771598) | 2 | 7 | 5 | 63 | 7 | |||
4775 | 218083 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 281 Magellan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 5994638.85855 | 2100259.1397 | 37.7466036724264 | -122.461282408569 | (37.7466036724264, -122.461282408569) | 1 | 8 | 4 | 29491 | 40 | |||
4777 | 261199 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 690x Benton Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007331 | 2095336 | 37.7338081055982 | -122.417045435619 | (37.7338081055982, -122.417045435619) | 2 | 7 | 7 | 28859 | 2 | ||||
4779 | 73552 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1558 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6000334.7955 | 2110645.229 | 37.7754474779657 | -122.4423320082 | (37.7754474779657, -122.4423320082) | 15 | 5 | 11 | 29492 | 16 | |||
4793 | 235921 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2549 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | Permit Number 782939 | 6010182.2586 | 2105017.82125 | 37.7605522464049 | -122.407870229727 | (37.7605522464049, -122.407870229727) | 10 | 4 | 8 | 28859 | 19 | ||
4921 | 71593 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 34 Rhine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5994443.94493 | 2086683.28618 | 37.7093164601484 | -122.46097260021 | (37.7093164601484, -122.46097260021) | 9 | 8 | 6 | 28861 | 25 | |||
4948 | 212696 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1342 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5994280.27927 | 2106365.59 | 37.7633497765027 | -122.462965291019 | (37.7633497765027, -122.462965291019) | 1 | 5 | 11 | 56 | 12 | |||
4963 | 72437 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3770 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5996832.97473 | 2115019.84204 | 37.7872588007918 | -122.4547616987 | (37.7872588007918, -122.4547616987) | 11 | 6 | 1 | 54 | 31 | |||
4991 | 20043 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 STAIRWAY51 | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | ST | |||||||||||||
5018 | 261361 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3 Bache St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007238 | 2095678 | 37.7347419306018 | -122.417391193891 | (37.7347419306018, -122.417391193891) | 2 | 7 | 7 | 28859 | 2 | ||||
5034 | 71218 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2271 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5988222.5624 | 2099870.3089 | 37.7451646891306 | -122.483440513109 | (37.7451646891306, -122.483440513109) | 1 | 8 | 3 | 29491 | 35 | |||
5057 | 72416 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3764 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5996845.41624 | 2115021.64069 | 37.7872644530409 | -122.454718783966 | (37.7872644530409, -122.454718783966) | 11 | 6 | 1 | 54 | 31 | |||
5104 | 212915 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 830 Pacheco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5992359.15804 | 2102812.51637 | 37.7534831218714 | -122.469351125951 | (37.7534831218714, -122.469351125951) | 1 | 8 | 4 | 56 | 12 |
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) );