trees
1,626 rows where qSpecies_id = 53 sorted by SiteOrder
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 34775 | 14651 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 655X McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3x3 | 6006015.9359491 | 2112078.013352 | 37.7797037167615 | -122.422781416289 | (37.7797037167615, -122.422781416289) | 7 | 9 | 11 | 28852 | 10 | |||
| 35016 | 120999 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 390 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x6 | 6010815 | 2115725 | 37.7899870820688 | -122.406436332672 | (37.7899870820688, -122.406436332672) | 5 | 1 | 10 | 28857 | 6 | ||||
| 35372 | 94058 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1401X 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 5993648 | 2105942 | 37.7621502689837 | -122.465121353228 | (37.7621502689837, -122.465121353228) | 1 | 8 | 11 | 56 | 12 | |||
| 35407 | 94294 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1150X Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Rec/Park | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | 15 | 9 | 11 | 29490 | 41 | ||||
| 35689 | 7151 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 708 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003574.54383 | 2110759.08622 | 37.775944219835 | -122.431133084506 | (37.775944219835, -122.431133084506) | 7 | 9 | 11 | 29492 | 10 | |||
| 35952 | 120884 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2140x 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011295 | 2105636 | 37.7623118602886 | -122.404065249735 | (37.7623118602886, -122.404065249735) | 8 | 3 | 8 | 28856 | 29 | ||||
| 36005 | 111369 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 724 IRVING ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993485 | 2106687 | 37.7641864431876 | -122.465739233402 | (37.7641864431876, -122.465739233402) | 11 | 8 | 11 | 56 | 12 | ||||
| 36280 | 110558 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1X Otis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Tree is at very corner of Otis and Mission; at 12 St and S Van Ness Intersection | 6007165.9 | 2109609 | 37.7729892139286 | -122.418628045346 | (37.7729892139286, -122.418628045346) | 8 | 2 | 9 | 28853 | 19 | |||
| 36315 | 4701 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 841 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6008961.46783 | 2120321.2947 | 37.8025035109944 | -122.41317456692 | (37.8025035109944, -122.41317456692) | 3 | 1 | 10 | 308 | 23 | |||
| 37710 | 4753 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1250 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 4X4 | 6007719.65165 | 2121534.55679 | 37.8057650284682 | -122.417557918763 | (37.8057650284682, -122.417557918763) | 5 | 1 | 10 | 308 | 23 | |||
| 37838 | 102503 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 290X Hermann St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x9 | 6003881.1 | 2108703.5 | 37.7703174504719 | -122.429925966233 | (37.7703174504719, -122.429925966233) | 7 | 9 | 11 | 29492 | 10 | ||||
| 38287 | 22723 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1401X Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 3 | 4x4 | 6003306.8488585 | 2112395.4775226 | 37.7804221702729 | -122.43217599894 | (37.7804221702729, -122.43217599894) | 15 | 9 | 11 | 29490 | 41 | |||
| 38445 | 4501 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1748 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4x4 | 6004612.9512322 | 2098708.9638206 | 37.74291622476 | -122.4266826598 | (37.74291622476, -122.4266826598) | 2 | 7 | 5 | 63 | 22 | |||
| 38468 | 111626 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 11X SOUTH VAN NESS AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007074 | 2110234 | 37.7747001403616 | -122.418990277193 | (37.7747001403616, -122.418990277193) | 8 | 2 | 9 | 28853 | 19 | ||||
| 38510 | 19240 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 701 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 8x6 | 6002037.68577 | 2110909.98609 | 37.7762713444054 | -122.436460270394 | (37.7762713444054, -122.436460270394) | 15 | 5 | 11 | 29492 | 10 | |||
| 38651 | 113775 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1712 BAKER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6000121 | 2114885 | 37.7870766118482 | -122.443376178084 | (37.7870766118482, -122.443376178084) | 13 | 6 | 1 | 29490 | 27 | |||
| 38715 | 120144 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1X Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008026 | 2111839 | 37.7791606496002 | -122.415810780563 | (37.7791606496002, -122.415810780563) | 7 | 10 | 9 | 28852 | 36 | ||||
| 39288 | 116011 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1448 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/09/2016 12:00:00 AM | 3 | 6000920 | 2110390.8 | 37.7747822166773 | -122.440289401956 | (37.7747822166773, -122.440289401956) | 15 | 5 | 11 | 29492 | 10 | |||
| 39309 | 61493 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 3149 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/19/1984 12:00:00 AM | Permit Number 777095 | 5999649.96958977 | 2116015.59113069 | 37.7901540469754 | -122.445087143888 | (37.7901540469754, -122.445087143888) | 13 | 6 | 1 | 29490 | 27 | |||
| 39760 | 21735 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1980 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x4 | 6003153.81629 | 2114507.53827 | 37.7862126798287 | -122.432856338004 | (37.7862126798287, -122.432856338004) | 13 | 9 | 11 | 29490 | 27 | |||
| 39764 | 11100 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1960 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3X3 | 6007273.5320198 | 2119093.4977666 | 37.7990373853425 | -122.418928545127 | (37.7990373853425, -122.418928545127) | 5 | 1 | 10 | 28858 | 32 | |||
| 40345 | 17320 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 99X Otis St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6006684.07559 | 2109163.06169 | 37.7717376353271 | -122.420263082185 | (37.7717376353271, -122.420263082185) | 8 | 2 | 9 | 28853 | 19 | |||
| 40606 | 18940 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2770 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6001564.88968 | 2115697.48907 | 37.7893897308811 | -122.438438883241 | (37.7893897308811, -122.438438883241) | 13 | 6 | 1 | 29490 | 27 | |||
| 40868 | 173774 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2239 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002625 | 2107043 | 37.7656869095489 | -122.434152085943 | (37.7656869095489, -122.434152085943) | 15 | 5 | 5 | 28862 | 3 | ||||
| 41221 | 96947 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 900X Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 6x6 | 6007389 | 2101516 | 37.750780272338 | -122.417282702809 | (37.750780272338, -122.417282702809) | 2 | 4 | 7 | 28859 | 19 | |||
| 41634 | 13254 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2408 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/1993 12:00:00 AM | 45 | 3X3 | 6000832.23006 | 2119380.36917 | 37.7994602521243 | -122.441238147567 | (37.7994602521243, -122.441238147567) | 13 | 9 | 1 | 57 | 17 | ||
| 41963 | 21634 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1629 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6004806.293908 | 2114684.9896753 | 37.786793502462 | -122.427151839633 | (37.786793502462, -122.427151839633) | 13 | 9 | 11 | 28858 | 13 | |||
| 42506 | 121635 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 506 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/2017 12:00:00 AM | 3 | 3x3 | 5992560 | 2111978 | 37.7786607112968 | -122.469323657797 | (37.7786607112968, -122.469323657797) | 11 | 6 | 2 | 54 | 11 | ||
| 43367 | 116602 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3260x 16TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 9x9 | 6005124 | 2106632 | 37.764699916645 | -122.425479329399 | (37.764699916645, -122.425479329399) | 8 | 4 | 5 | 28859 | 19 | |||
| 43513 | 120964 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1145x Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003243 | 2101623 | 37.7508399403415 | -122.43162756863 | (37.7508399403415, -122.43162756863) | 2 | 4 | 5 | 28862 | 22 | ||||
| 43860 | 8182 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1218 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6001778.22585 | 2111194.36963 | 37.7770374434445 | -122.437378180533 | (37.7770374434445, -122.437378180533) | 15 | 5 | 11 | 29492 | 41 | |||
| 43945 | 573 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2990 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | Permit Number 776380 | 6009007.86528 | 2102243.77418 | 37.7528695228517 | -122.411735919997 | (37.7528695228517, -122.411735919997) | 2 | 4 | 7 | 28859 | 19 | ||
| 43983 | 10710 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 17X Hollis St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003901.15311 | 2113362.61867 | 37.7831113762968 | -122.430189039187 | (37.7831113762968, -122.430189039187) | 7 | 9 | 11 | 29490 | 41 | |||
| 43985 | 111817 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 80 ORD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | 6000817 | 2105938 | 37.7625500726099 | -122.440326296311 | (37.7625500726099, -122.440326296311) | 15 | 5 | 5 | 28862 | 3 | |||
| 44100 | 115215 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3395x 21ST ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/24/2016 12:00:00 AM | 3 | 9x5 | Permit Number 779049 | 6005778 | 2103691 | 37.7566615513452 | -122.423008263345 | (37.7566615513452, -122.423008263345) | 2 | 4 | 5 | 28859 | 19 | |
| 44231 | 57108 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 280 Chattanooga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/1974 12:00:00 AM | 24 | 6x6 | Permit Number 14378 | 6004748.38429029 | 2102046.50032189 | 37.7520879863161 | -122.426451960244 | (37.7520879863161, -122.426451960244) | 2 | 4 | 5 | 28862 | 22 | |
| 44451 | 96734 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 520 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3.5 | 6007401.6 | 2106571.6 | 37.7646624959011 | -122.417597409955 | (37.7646624959011, -122.417597409955) | 8 | 4 | 7 | 28859 | 19 | |||
| 44509 | 60715 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 30 Oakwood St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/1983 12:00:00 AM | 24 | 3x3 | Permit Number 20368 | 6005215.9296478 | 2105282.4178358 | 37.7609994776864 | -122.425065336381 | (37.7609994776864, -122.425065336381) | 2 | 4 | 5 | 28859 | 19 | |
| 44695 | 525 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2829 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6009855.90033 | 2102163.70478 | 37.7526972066188 | -122.408797595672 | (37.7526972066188, -122.408797595672) | 2 | 4 | 7 | 28859 | 19 | |||
| 45235 | 15147 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 895X Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | 12 | 4x4 | 6010810.7123748 | 2113108.5528643 | 37.7828026992214 | -122.406266743907 | (37.7828026992214, -122.406266743907) | 12 | 2 | 9 | 28853 | 34 | |||
| 45836 | 9661 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 112 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6006079.13931 | 2110176.88384 | 37.7744872417771 | -122.422427647286 | (37.7744872417771, -122.422427647286) | 7 | 9 | 11 | 28852 | 10 | |||
| 46032 | 121039 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2101 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006363 | 2118098 | 37.7962526868942 | -122.422008539697 | (37.7962526868942, -122.422008539697) | 13 | 9 | 10 | 28858 | 32 | ||||
| 46932 | 17830 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1961 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004561.39396 | 2115345.0767756 | 37.7885920838825 | -122.428046192771 | (37.7885920838825, -122.428046192771) | 13 | 9 | 11 | 28858 | 27 | |||
| 47161 | 18304 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 100 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6010232.4387225 | 2107842.1672579 | 37.7683100673499 | -122.407895847634 | (37.7683100673499, -122.407895847634) | 8 | 4 | 8 | 28853 | 19 | |||
| 48272 | 95217 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 135 Albion St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6005910 | 2106464 | 37.7642830068396 | -122.422748818687 | (37.7642830068396, -122.422748818687) | 8 | 4 | 5 | 28859 | 19 | |||
| 48350 | 111430 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 500X PRESIDIO AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999200 | 2114887 | 37.7870295394193 | -122.446562765799 | (37.7870295394193, -122.446562765799) | 15 | 6 | 1 | 29490 | 31 | ||||
| 48551 | 18500 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 519X Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4X4 | 6010154.14929 | 2115557.66128 | 37.7894906186413 | -122.408711019419 | (37.7894906186413, -122.408711019419) | 5 | 1 | 10 | 28857 | 21 | |||
| 48721 | 9675 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 235 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/19/1981 12:00:00 AM | 12 | 3X3 | 6005972.11971 | 2110519.21136 | 37.7754211527567 | -122.422822183014 | (37.7754211527567, -122.422822183014) | 7 | 9 | 11 | 28852 | 10 | ||
| 49286 | 21956 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2475 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x9 | 6015841.22266 | 2104083.69236 | 37.7583025169931 | -122.388233087559 | (37.7583025169931, -122.388233087559) | 10 | 3 | 8 | 28856 | 29 | |||
| 49311 | 8762 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3360 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5996663.11405 | 2112992.0555 | 37.7816812935668 | -122.455202782638 | (37.7816812935668, -122.455202782638) | 11 | 6 | 1 | 54 | 31 | |||
| 49389 | 11091 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1906 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 70 | 3X3 | 6007294.23278 | 2118880.01642 | 37.7984523847496 | -122.418841764779 | (37.7984523847496, -122.418841764779) | 5 | 1 | 10 | 28858 | 32 | |||
| 49890 | 52592 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 327CALIFORNIA 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 48686 | 5988048.64326864 | 2113784.56845539 | 37.7833593060301 | -122.48506257055 | (37.7833593060301, -122.48506257055) | 11 | 6 | 2 | 55 | 26 | ||||
| 50489 | 18364 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 598 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3x3 | 6010361.2141646 | 2105516.7578044 | 37.7619322307219 | -122.407286474232 | (37.7619322307219, -122.407286474232) | 8 | 4 | 8 | 28859 | 19 | |||
| 50702 | 11103 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1995X Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3X3 | 6007217.8875 | 2119096.40041 | 37.7990422218557 | -122.419121300277 | (37.7990422218557, -122.419121300277) | 5 | 1 | 10 | 28858 | 32 | |||
| 50734 | 21952 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2455 03RD ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 4x9 | 6015836.2 | 2104173 | 37.7585474584562 | -122.388256691115 | (37.7585474584562, -122.388256691115) | 10 | 3 | 8 | 28856 | 29 | |||
| 50755 | 7185 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 865 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003457.39592 | 2111275.80383 | 37.7773563593355 | -122.431575227386 | (37.7773563593355, -122.431575227386) | 15 | 9 | 11 | 29492 | 10 | |||
| 50788 | 113510 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 320 TURK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008411 | 2113171 | 37.7828396386737 | -122.414573186563 | (37.7828396386737, -122.414573186563) | 7 | 10 | 9 | 28852 | 36 | ||||
| 50801 | 95033 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3224 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6001388 | 2119447 | 37.7996748454742 | -122.4393197689 | (37.7996748454742, -122.4393197689) | 13 | 9 | 1 | 57 | 17 | ||||
| 50810 | 20244 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1801X Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6002529.5506914 | 2114404.1561918 | 37.7858933925245 | -122.435008734319 | (37.7858933925245, -122.435008734319) | 13 | 9 | 1 | 29490 | 27 | |||
| 51471 | 20141 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1001 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002903.1358 | 2111776.1473 | 37.7786987467479 | -122.433528357436 | (37.7786987467479, -122.433528357436) | 15 | 9 | 11 | 29490 | 41 | |||
| 51694 | 173776 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 89 Eureka St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001439 | 2105287 | 37.7607979807122 | -122.438128392537 | (37.7607979807122, -122.438128392537) | 15 | 4 | 5 | 28862 | 3 | ||||
| 51940 | 665 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3297X 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 6007079.62061 | 2102029.84762 | 37.7521737701718 | -122.418388996947 | (37.7521737701718, -122.418388996947) | 2 | 4 | 7 | 28859 | 19 | |||
| 52416 | 6378 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 310 Elm St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6006136.3622128 | 2112667.0618885 | 37.7813278942368 | -122.422406674363 | (37.7813278942368, -122.422406674363) | 7 | 9 | 11 | 28852 | 41 | |||
| 52462 | 116125 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2500X Keith St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6014198.52795 | 2092093.45262 | 37.7252886606488 | -122.393075349238 | (37.7252886606488, -122.393075349238) | 10 | 3 | 8 | 58 | 1 | |||||
| 52589 | 11046 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1560 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3X3 | 6007462.42749 | 2117742.73439 | 37.7953391611566 | -122.418179084924 | (37.7953391611566, -122.418179084924) | 5 | 1 | 10 | 28858 | 32 | |||
| 52658 | 4626 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 419 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6010254.83162 | 2118999.33253 | 37.7989462519709 | -122.408605554576 | (37.7989462519709, -122.408605554576) | 3 | 1 | 10 | 308 | 4 | |||
| 52775 | 18497 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 501 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 4X4 | 6010150.58942 | 2115513.37022 | 37.7893688066449 | -122.408720210327 | (37.7893688066449, -122.408720210327) | 5 | 1 | 10 | 28857 | 21 | |||
| 52966 | 66275 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1065 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1990 12:00:00 AM | 3x3 | Permit Number 768678 | 6007678.31560988 | 2109516.6646006 | 37.7727645184447 | -122.416848989215 | (37.7727645184447, -122.416848989215) | 8 | 2 | 9 | 28853 | 19 | ||
| 53386 | 55163 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1328 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/1993 12:00:00 AM | Permit Number 31912 | 6002514.24849197 | 2101716.89965545 | 37.751056432833 | -122.434154367056 | (37.751056432833, -122.434154367056) | 2 | 4 | 5 | 28862 | 22 | |||
| 53504 | 11175 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2740 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 36 | 3X3 | Permit Number 769071 | 6006912.1976315 | 2121679.9811894 | 37.8061188596167 | -122.420362567782 | (37.8061188596167, -122.420362567782) | 5 | 1 | 1 | 28858 | 32 | ||
| 53550 | 18383 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 804 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 28 | 3x3 | 6010399.792436 | 2104541.9824298 | 37.7592578761131 | -122.407084334673 | (37.7592578761131, -122.407084334673) | 10 | 4 | 7 | 28859 | 19 | |||
| 53774 | 20090 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2075X Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 5997085.68869 | 2109091.58753 | 37.7709958615587 | -122.453459178714 | (37.7709958615587, -122.453459178714) | 15 | 5 | 11 | 29492 | 9 | |||
| 54470 | 101758 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 45X 11th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6007389.6 | 2110351.2 | 37.7750397101602 | -122.417906860029 | (37.7750397101602, -122.417906860029) | 8 | 2 | 9 | 28853 | 34 | |||
| 54854 | 18511 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 626 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 6010143.9604039 | 2115933.8512359 | 37.7905229751065 | -122.408772822924 | (37.7905229751065, -122.408772822924) | 5 | 1 | 10 | 28857 | 21 | |||
| 55261 | 11108 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2022 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3X3 | 6007226.47271 | 2119353.11491 | 37.799747578786 | -122.419109811467 | (37.799747578786, -122.419109811467) | 5 | 1 | 1 | 28858 | 32 | |||
| 55414 | 61158 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 3347 20TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1983 12:00:00 AM | 12 | 5x5 | Permit Number 21016 | 6007930.5 | 2104397.2 | 37.758721842404 | -122.415614115387 | (37.758721842404, -122.415614115387) | 2 | 4 | 7 | 28859 | 19 |
| 55561 | 99240 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 560X Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 10 | 4x4 | 6008281 | 2113828 | 37.7846362978531 | -122.415069452341 | (37.7846362978531, -122.415069452341) | 7 | 10 | 9 | 28858 | 36 | |||
| 55775 | 44125 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 431 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 43629 | 6012046.82946857 | 2118068.4414971 | 37.796490448112 | -122.402339123693 | (37.796490448112, -122.402339123693) | 3 | 1 | 10 | 28860 | 4 | ||||
| 56045 | 108604 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 625 LEAVENWORTH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6008310.7 | 2114660.6 | 37.7869240847944 | -122.415025652231 | (37.7869240847944, -122.415025652231) | 13 | 1 | 9 | 28858 | 36 | |||
| 57513 | 12263 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 640 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6004991.72568 | 2111198.95935 | 37.7772322091826 | -122.426262005109 | (37.7772322091826, -122.426262005109) | 7 | 9 | 11 | 28852 | 10 | |||
| 57759 | 4493 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1616 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6004570.9658455 | 2099475.4807252 | 37.7450185306318 | -122.426882412261 | (37.7450185306318, -122.426882412261) | 2 | 7 | 5 | 63 | 22 | |||
| 57818 | 111388 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 298x CLINTON PARK | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6004911 | 2108307 | 37.7692870280045 | -122.426335307428 | (37.7692870280045, -122.426335307428) | 8 | 4 | 5 | 28862 | 19 | |||
| 58111 | 258045 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1250 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/2019 12:00:00 AM | 3 | 3x3 | 6007719 | 2121534 | 37.805763462997 | -122.417560134413 | (37.805763462997, -122.417560134413) | 5 | 1 | 10 | 308 | 23 | ||
| 59221 | 48449 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1971 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/2002 12:00:00 AM | Permit Number 45821 | 6004348.70626507 | 2107156.39257844 | 37.7660959373339 | -122.428198241647 | (37.7660959373339, -122.428198241647) | 8 | 4 | 5 | 28862 | 3 | |||
| 59324 | 94216 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1X Tehama St | 1 | Sidewalk: Property side : Pot | Tree | Private 2 | 06/25/2010 12:00:00 AM | 2x3 | Permit Number 53568 | 6013910.7 | 2114841.3 | 37.7877333404996 | -122.395663455814 | (37.7877333404996, -122.395663455814) | 6 | 2 | 9 | 28855 | 6 | ||
| 60087 | 86905 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 36 Camp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2007 12:00:00 AM | 3x3 | Permit Number 49869 | 6005775 | 2106383 | 37.7640529822515 | -122.423209987967 | (37.7640529822515, -122.423209987967) | 8 | 4 | 5 | 28859 | 19 | ||
| 60410 | 111206 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3100x 19TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6008781 | 2105093 | 37.7606801217813 | -122.412721875792 | (37.7606801217813, -122.412721875792) | 2 | 4 | 7 | 28859 | 19 | |||
| 60538 | 32649 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 379 TEHAMA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/28/2005 12:00:00 AM | 8 | Permit Number 37086 | 6011447 | 2112547 | 37.7812963779039 | -122.404025912764 | (37.7812963779039, -122.404025912764) | 6 | 2 | 9 | 28853 | 34 | |
| 60833 | 102647 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 221 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x9 | 6002283 | 2109227 | 37.7716642197307 | -122.435491238531 | (37.7716642197307, -122.435491238531) | 15 | 5 | 11 | 29492 | 9 | ||||
| 60853 | 97999 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 30 Eagle St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6000135 | 2104379 | 37.7582305885461 | -122.442573139957 | (37.7582305885461, -122.442573139957) | 2 | 4 | 5 | 28862 | 3 | |||
| 61113 | 57802 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 107 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/26/1988 12:00:00 AM | 8 | 3x3 | Permit Number 25561 | 6000622.33928566 | 2102551.03510935 | 37.7532392091702 | -122.440756591601 | (37.7532392091702, -122.440756591601) | 2 | 4 | 5 | 28862 | 22 | |
| 61171 | 16895 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 371 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6005249.75731 | 2110166.87775 | 37.7744129459718 | -122.425295929281 | (37.7744129459718, -122.425295929281) | 7 | 9 | 11 | 28852 | 10 | |||
| 61232 | 12996 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 340 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6010677.76597 | 2120690.63206 | 37.8036138232581 | -122.407261344489 | (37.8036138232581, -122.407261344489) | 3 | 1 | 10 | 308 | 23 | |||
| 61233 | 28383 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 286 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 6006047.68288 | 2107930.23885 | 37.7683167183705 | -122.422376798825 | (37.7683167183705, -122.422376798825) | 8 | 4 | 5 | 28853 | 19 | ||||
| 61417 | 7288 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1860 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 5x5 | 6003020.21181 | 2114689.03027 | 37.7867034322579 | -122.433331547756 | (37.7867034322579, -122.433331547756) | 13 | 9 | 11 | 29490 | 27 | |||
| 61483 | 17037 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1200X Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6001158.18128 | 2109720.4277 | 37.7729551007398 | -122.439417421896 | (37.7729551007398, -122.439417421896) | 15 | 5 | 11 | 29492 | 10 | |||
| 61629 | 117600 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 565 39TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 5983700 | 2111975 | 37.7781364952795 | -122.499973114435 | (37.7781364952795, -122.499973114435) | 11 | 6 | 2 | 55 | 26 | |||
| 61686 | 100705 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 220X 01st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/2012 12:00:00 AM | 3x3 | Permit Number 768932 | 6013902 | 2115015 | 37.7882097965006 | -122.395705731652 | (37.7882097965006, -122.395705731652) | 6 | 2 | 9 | 28855 | 6 | ||
| 61784 | 59066 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1658 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/16/1980 12:00:00 AM | Permit Number 18361 | 6003975.177671 | 2098610.37486855 | 37.7426094440159 | -122.428880876877 | (37.7426094440159, -122.428880876877) | 2 | 7 | 5 | 63 | 22 | |||
| 62512 | 21625 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1610 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6004858.21198 | 2114748.18478 | 37.7869699562504 | -122.426976717781 | (37.7869699562504, -122.426976717781) | 13 | 9 | 11 | 28858 | 27 |
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) );