trees
6,714 rows where qSpecies_id = 7 sorted by qCareAssistant
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 | |||
| 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 | ||
| 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 | ||
| 604 | 20034 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 100 STAIRWAY51 | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | ST | |||||||||||||
| 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 | ||||
| 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 | |||
| 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 | |||
| 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 | ||||
| 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 | |||
| 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 | |||
| 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 | ||||
| 1515 | 31846 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | Permit Number 35298 | ||||||||||||||
| 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 | |||
| 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 | |||
| 1853 | 214288 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 38 Staples Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/23/2000 12:00:00 AM | 13 | Width 3ft | Permit Number 42619 | 5999806.95305 | 2093809.09712 | 37.7291894584065 | -122.442948622496 | (37.7291894584065, -122.442948622496) | 9 | 7 | 4 | 63 | 40 | |
| 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 | |||
| 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 | ||
| 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 | |||
| 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 | |||
| 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 | ||
| 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 | |||
| 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 | |||
| 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 | |||
| 3242 | 43297 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 1501 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2000 12:00:00 AM | Permit Number 43066 | |||||||||||||
| 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 | ||||
| 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 | ||
| 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 | |||
| 3695 | 217936 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 2035 15th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 04/26/2004 12:00:00 AM | 4 | Width 3ft | Permit Number 47390 | 5991589.39044 | 2101578.98372 | 37.7500516488693 | -122.471923224775 | (37.7500516488693, -122.471923224775) | 1 | 8 | 4 | 29491 | 12 | |
| 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 | ||||
| 3803 | 84348 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 3332-3334 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50580 | 6007340.92664153 | 2105019.75450207 | 37.760398074706 | -122.417697261406 | (37.760398074706, -122.417697261406) | 2 | 4 | 7 | 28859 | 19 | ||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||||
| 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 | ||
| 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 | |||
| 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 | ||||
| 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 | |||
| 5243 | 141564 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 500 LYON ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6000161.6495 | 2110729.8447 | 37.7756699411398 | -122.442937037183 | (37.7756699411398, -122.442937037183) | 15 | 5 | 11 | 29492 | 16 | |||
| 5278 | 235936 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 900 Hampshire St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/27/2017 12:00:00 AM | 3 | Width 3ft | 6010180.29259 | 2103880.68421 | 37.7574298137383 | -122.40779684417 | (37.7574298137383, -122.40779684417) | 2 | 4 | 7 | 28859 | 19 | ||
| 5330 | 121676 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 65 Sotelo Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993867 | 2101351 | 37.7495571916966 | -122.464030639739 | (37.7495571916966, -122.464030639739) | 1 | 8 | 4 | 29491 | 40 | ||||
| 5337 | 178722 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 490 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6002144.30749 | 2090601.92472 | 37.7205162706894 | -122.434638963227 | (37.7205162706894, -122.434638963227) | 9 | 7 | 6 | 28861 | 5 | |||
| 5448 | 140339 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1300x WEBSTER ST | 7 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6003689.95 | 2113371.7397 | 37.7831244557567 | -122.430920367043 | (37.7831244557567, -122.430920367043) | 15 | 9 | 11 | 29490 | 41 | |||
| 5463 | 212518 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1845 Monterey Blvd | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5992471.49152 | 2095369.46244 | 37.7330528811753 | -122.468421185611 | (37.7330528811753, -122.468421185611) | 9 | 8 | 4 | 59 | 40 | |||
| 5585 | 100886 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 91 Welsh St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6013501.81999 | 2111894.49362 | 37.7796193360911 | -122.396871432992 | (37.7796193360911, -122.396871432992) | 6 | 2 | 9 | 28856 | 34 | |||
| 5591 | 212726 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1273 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 5ft | 5992975.27742 | 2106809.78649 | 37.7644941673851 | -122.467511131939 | (37.7644941673851, -122.467511131939) | 11 | 8 | 11 | 56 | 12 | |||
| 5673 | 142341 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 501 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6000096.9145 | 2110881.9778 | 37.7760839689842 | -122.443171899624 | (37.7760839689842, -122.443171899624) | 15 | 5 | 11 | 29492 | 16 | |||
| 5714 | 259658 | Undocumented 4 | Prunus cerasifera :: Cherry Plum 7 | 239 Stonecrest Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5990787 | 2092898 | 37.7261694250404 | -122.474064598028 | (37.7261694250404, -122.474064598028) | 9 | 8 | 4 | 64 | 40 | ||||
| 5777 | 236886 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 19 Frederick St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5999794.84017 | 2107740.78747 | 37.7674418258017 | -122.443991102207 | (37.7674418258017, -122.443991102207) | 15 | 5 | 5 | 29492 | 9 | |||
| 5789 | 142614 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 701 GREENWICH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6009469.9119 | 2120131.871 | 37.8020119312896 | -122.411401700731 | (37.8020119312896, -122.411401700731) | 3 | 1 | 10 | 308 | 23 | |||
| 5812 | 237501 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3717 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6003602.08527 | 2103592.54155 | 37.7562681837431 | -122.430526337427 | (37.7562681837431, -122.430526337427) | 2 | 4 | 5 | 28862 | 22 | |||
| 5877 | 51423 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 655 05th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/2004 12:00:00 AM | 2 | 3x3 | Permit Number 52282 | 6013263.01553 | 2110499.58328 | 37.7757759349387 | -122.397599704863 | (37.7757759349387, -122.397599704863) | 6 | 2 | 9 | 28856 | 34 | |
| 5910 | 24288 | Permitted Site 7 | Prunus cerasifera :: Cherry Plum 7 | 340 Winding Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6001280.10777 | 2086581.35963 | 37.7094275956588 | -122.437338476184 | (37.7094275956588, -122.437338476184) | 9 | 7 | 6 | 28861 | 5 | |||
| 6052 | 235985 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 921 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6004398.25101 | 2103505.33732 | 37.7560738114594 | -122.427766708382 | (37.7560738114594, -122.427766708382) | 2 | 4 | 5 | 28862 | 22 | |||
| 6079 | 212891 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1439 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5991128.6884 | 2105597.85808 | 37.7610597509203 | -122.47380949522 | (37.7610597509203, -122.47380949522) | 1 | 8 | 4 | 56 | 12 | |||
| 6135 | 236937 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 342 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008931.13659 | 2096699.45171 | 37.7376417330755 | -122.411609564953 | (37.7376417330755, -122.411609564953) | 10 | 7 | 7 | 28859 | 2 | |||
| 6218 | 214210 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2 Edgehill Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5994958.11276 | 2099177.21478 | 37.7436513456346 | -122.460100100459 | (37.7436513456346, -122.460100100459) | 1 | 8 | 4 | 59 | 40 |
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) );