trees
6,714 rows where qSpecies_id = 7 sorted by qLegalStatus_id
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9 | 32966 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 556 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/17/2020 12:00:00 AM | 3 | Permit Number 37281 | 6014072.59224 | 2104507.52941 | 37.759368126158 | -122.394379509632 | (37.759368126158, -122.394379509632) | 10 | 3 | 8 | 28856 | 29 | |
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 | |||
491 | 246210 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 725 Buena Vista Ave West | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/2019 12:00:00 AM | 3 | Width 0ft | 5999854.0817 | 2107930.8602 | 37.7679670970626 | -122.443799851593 | (37.7679670970626, -122.443799851593) | 15 | 5 | 11 | 29492 | 9 | ||
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 | |||
560 | 97763 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 115 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/08/2011 12:00:00 AM | 1 | Permit Number 768298 | 5996511.5635 | 2113681.1555 | 37.783564683267 | -122.455776900676 | (37.783564683267, -122.455776900676) | 11 | 6 | 1 | 54 | 31 | ||
587 | 37078 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1318 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | 2 | Permit Number 39680 | 5982466.3981 | 2106106.9098 | 37.7619519432804 | -122.50380580728 | (37.7619519432804, -122.50380580728) | 1 | 8 | 3 | 56 | 35 | |
604 | 20034 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 STAIRWAY51 | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | ST | |||||||||||||
651 | 59344 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 532 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1980 12:00:00 AM | 8 | Permit Number 18692 | 6000155.0247 | 2110781.0357 | 37.7758101209138 | -122.44296363094 | (37.7758101209138, -122.44296363094) | 15 | 5 | 11 | 29492 | 16 | |
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 | |||
752 | 32695 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1106 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | 5 | 3x3 | Permit Number 37103 | 6008138.63139 | 2115547.98028 | 37.7893509440283 | -122.415683826556 | (37.7893509440283, -122.415683826556) | 13 | 1 | 10 | 28858 | 21 |
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 | |||
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 | |||
1235 | 54485 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 524 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/11/1972 12:00:00 AM | 3 | Permit Number 10277 | 5983807.43995 | 2112211.38308 | 37.7787918392432 | -122.499618921418 | (37.7787918392432, -122.499618921418) | 11 | 6 | 2 | 55 | 26 | |
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 | |||
1364 | 253839 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 94 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/12/2011 12:00:00 AM | 3x3 | 6006239 | 2097690 | 37.7402101761268 | -122.42098789234 | (37.7402101761268, -122.42098789234) | 2 | 7 | 7 | 28859 | 2 | |||
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 | ||||
1471 | 68309 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 273 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/27/1993 12:00:00 AM | 5 | Permit Number 32120 | 5990851.78966 | 2113569.99779 | 37.7829330362374 | -122.47534921912 | (37.7829330362374, -122.47534921912) | 11 | 6 | 2 | 54 | 26 | |
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 | |||
1563 | 83933 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1858 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51018 | 6000198.5471 | 2111317.0904 | 37.7772844720096 | -122.442851578579 | (37.7772844720096, -122.442851578579) | 15 | 5 | 11 | 29490 | 16 | |
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 | |||
1789 | 39904 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2807 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/30/2001 12:00:00 AM | 6 | Permit Number 44042 | 6001235.05057 | 2115912.0484 | 37.7899600881353 | -122.439595474174 | (37.7899600881353, -122.439595474174) | 13 | 6 | 1 | 29490 | 27 | |
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 | |||
1813 | 25410 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 153 Duboce Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/22/1996 12:00:00 AM | 3 | 3X3 | 6005712.73498 | 2108443.02914 | 37.7697058178046 | -122.423571815294 | (37.7697058178046, -122.423571815294) | 8 | 4 | 5 | 28853 | 19 | ||
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 | |||
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 | |||
1955 | 55970 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1246 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2017 12:00:00 AM | 3 | Permit Number 12041 | 6008815.91632 | 2116679.99391 | 37.7924972267216 | -122.413420580993 | (37.7924972267216, -122.413420580993) | 5 | 1 | 10 | 28857 | 21 | ||
1971 | 60793 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 300 Ewing Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/14/1983 12:00:00 AM | 7 | Permit Number 20467 | 5998509.2912 | 2112152.7993 | 37.779482661953 | -122.448755442586 | (37.779482661953, -122.448755442586) | 15 | 6 | 2 | 54 | 16 | |
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 | |||
2482 | 31979 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 246 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/30/1995 12:00:00 AM | 7 | Permit Number 35378 | 5995256.47104 | 2113909.90159 | 37.7841206491804 | -122.460135585049 | (37.7841206491804, -122.460135585049) | 11 | 6 | 2 | 54 | 11 | |
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 | |||
2634 | 40957 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 735 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | 7 | Permit Number 42441 | 5990344.94056 | 2110364.54527 | 37.7741023575346 | -122.476868403223 | (37.7741023575346, -122.476868403223) | 11 | 6 | 2 | 55 | 26 | |
2662 | 51421 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 655 05th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/2004 12:00:00 AM | 3 | Permit Number 47745 | 6013248.9695 | 2110513.26704 | 37.7758127253049 | -122.397649253932 | (37.7758127253049, -122.397649253932) | 6 | 2 | 9 | 28856 | 34 | |
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 | |||
3324 | 100985 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2190 Powell St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 03/23/2016 02:34:00 PM | 3 | 3x3 | 6009638.6 | 2121046.2 | 37.8045319114054 | -122.41088257169 | (37.8045319114054, -122.41088257169) | 3 | 1 | 10 | 308 | 23 | |
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 | |||
3539 | 65220 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 438 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/1989 12:00:00 AM | 15 | Permit Number 28007 | 6002076.3517 | 2091079.52692 | 37.7218238013198 | -122.434908002604 | (37.7218238013198, -122.434908002604) | 9 | 7 | 6 | 28861 | 5 | |
3561 | 246211 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 725 Buena Vista Ave West | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/2019 12:00:00 AM | 3 | Width 0ft | 5999847.7223 | 2107912.6904 | 37.7679168446173 | -122.443820542416 | (37.7679168446173, -122.443820542416) | 15 | 5 | 11 | 29492 | 9 | ||
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 | |||
3609 | 68347 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 479 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | 10 | Permit Number 32166 | 5989354.45266 | 2112083.78554 | 37.7787654076266 | -122.480420503546 | (37.7787654076266, -122.480420503546) | 11 | 6 | 2 | 55 | 26 | |
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 | |||
3685 | 42239 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 526 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | 5 | Permit Number 42488 | 6010182.46318 | 2111990.4424 | 37.7796974691974 | -122.408361341411 | (37.7796974691974, -122.408361341411) | 14 | 2 | 9 | 28853 | 34 | |
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 | |||
3940 | 60357 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1265 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 9 | Permit Number 19935 | 6016646.4135 | 2093895.0122 | 37.7303710665679 | -122.384738607351 | (37.7303710665679, -122.384738607351) | 10 | 3 | 8 | 58 | 1 | |
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 |
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) );