Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, PlantDate, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▼ | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 47354 | 47354 | 119238 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 4701 Cabrillo St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5980953.58736 | 2110230.22563 | 37.773184299817096 | -122.509344168 | (37.7731842998171, -122.509344168) | |||
| 171429 | 171429 | 118684 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 684 48th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 2ft | 5981039.03921 | 2111092.68807 | 37.775557405741296 | -122.50911264072799 | (37.7755574057413, -122.509112640728) | |||
| 76996 | 76996 | 37145 | Permitted Site 1 | Yucca gloriosa :: Spanish Dagger 224 | 755 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/1998 12:00:00 AM | 4 | Permit Number 39727 | 5981030.6614 | 2110569.17364 | 37.7741194954723 | -122.50910273769199 | (37.7741194954723, -122.509102737692) | ||
| 130619 | 130619 | 119216 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 771 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5981035.7876 | 2110451.80706 | 37.773797543586895 | -122.509076288613 | (37.7737975435869, -122.509076288613) | |||
| 126476 | 126476 | 90722 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 4650X Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5981131.941430001 | 2110306.4934400003 | 37.773404223233904 | -122.508732892327 | (37.7734042232339, -122.508732892327) | ||
| 128060 | 128060 | 90721 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 4650X Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5981150.165159999 | 2110306.92668 | 37.7734064869384 | -122.508669887159 | (37.7734064869384, -122.508669887159) | ||
| 159085 | 159085 | 118618 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 498 47th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5981320.9946 | 2112426.20878 | 37.7792354783169 | -122.50823630902799 | (37.7792354783169, -122.508236309028) | |||
| 159941 | 159941 | 118619 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 498 47th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5981321.44116 | 2112409.25336 | 37.779188950072104 | -122.508233505359 | (37.7791889500721, -122.508233505359) | |||
| 35129 | 35129 | 118620 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 498 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5981322.23843 | 2112396.05597 | 37.7791527609309 | -122.50822976748199 | (37.7791527609309, -122.508229767482) | |||
| 154967 | 154967 | 119144 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 637 47th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 31 | Width 2ft | 5981304.908009999 | 2111421.80977 | 37.7764767475665 | -122.508217386884 | (37.7764767475665, -122.508217386884) | |||
| 93763 | 93763 | 90729 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 4601X Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5981296.19925 | 2110254.1964 | 37.7732703114755 | -122.508160828969 | (37.7732703114755, -122.508160828969) | ||
| 26561 | 26561 | 79997 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 8250 Geary Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2002 12:00:00 AM | 6 | 5981344.9471 | 2112403.2124900003 | 37.7791737487824 | -122.50815174160499 | (37.7791737487824, -122.508151741605) | ||
| 34569 | 34569 | 183314 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1298 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5981216.5568 | 2106353.9637 | 37.7625567133131 | -122.50814677987101 | (37.7625567133131, -122.508146779871) | |||
| 168947 | 168947 | 79998 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 8250 Geary Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2002 12:00:00 AM | 4 | 5981347.81694 | 2112377.495 | 37.7791033052806 | -122.50813990451401 | (37.7791033052806, -122.508139904514) | ||
| 108464 | 108464 | 90718 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 4606 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5981306.68716 | 2110312.4984 | 37.773431009678895 | -122.50812887858801 | (37.7734310096789, -122.508128878588) | ||
| 139067 | 139067 | 90717 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 4600X Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5981323.93536 | 2110313.64162 | 37.7734351649753 | -122.50806930052099 | (37.7734351649753, -122.508069300521) | ||
| 32599 | 32599 | 84910 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 5546 Anza St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/03/2007 12:00:00 AM | 18 | Permit No. 49266 | 5981366.54955 | 2111678.1896 | 37.7771843232036 | -122.50802318732 | (37.7771843232036, -122.50802318732) | ||
| 147049 | 147049 | 79999 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 8250 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2002 12:00:00 AM | 3 | 5981389.70051 | 2112378.3 | 37.7791079835189 | -122.50799507452 | (37.7791079835189, -122.50799507452) | ||
| 88733 | 88733 | 90730 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 4575X Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5981423.242190001 | 2110260.00092 | 37.773293734399 | -122.507721808797 | (37.773293734399, -122.507721808797) | ||
| 24256 | 24256 | 119131 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 543 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 34 | Width 3ft | 5981597.43697 | 2112021.89729 | 37.778141644974 | -122.50724999386298 | (37.778141644974, -122.507249993863) | |||
| 120834 | 120834 | 90736 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 4501X Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5981602.49176 | 2110266.28486 | 37.77332154692 | -122.507102237161 | (37.77332154692, -122.507102237161) | ||
| 140329 | 140329 | 90712 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 4508 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5981619.82432 | 2110323.60403 | 37.773479949383294 | -122.50704653532101 | (37.7734799493833, -122.507046535321) | ||
| 109433 | 109433 | 90737 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 4501X Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5981620.20205 | 2110267.22621 | 37.773325174636 | -122.507041045742 | (37.773325174636, -122.507041045742) | ||
| 144018 | 144018 | 90711 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 4500 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5981635.19797 | 2110323.94692 | 37.773481796264 | -122.506993382003 | (37.773481796264, -122.506993382003) | ||
| 88681 | 88681 | 90738 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 4451X Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5981732.83736 | 2110270.97597 | 37.7733421032725 | -122.506651709597 | (37.7733421032725, -122.506651709597) | ||
| 142970 | 142970 | 90710 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 4450 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5981744.51954 | 2110327.1512700003 | 37.773497032089 | -122.50661546708 | (37.773497032089, -122.50661546708) | ||
| 111566 | 111566 | 90739 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 4451X Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5981746.10841 | 2110271.13179 | 37.7733433125324 | -122.50660581555 | (37.7733433125324, -122.50660581555) | ||
| 52825 | 52825 | 183106 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 3634 Santiago St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5981552.8121 | 2099457.4563 | 37.7436406629553 | -122.50647234563 | (37.7436406629553, -122.50647234563) | |||
| 114807 | 114807 | 90744 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 4401 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5981925.61643 | 2110279.1737 | 37.7733759612739 | -122.505985479448 | (37.7733759612739, -122.505985479448) | ||
| 181985 | 181985 | 47839 | Permitted Site 1 | Yucca gloriosa :: Spanish Dagger 224 | 4400 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/14/2002 12:00:00 AM | 8 | Permit Number 45601 | 5981941.89951 | 2110334.18546 | 37.7735279659603 | -122.50593323432501 | (37.7735279659603, -122.505933234325) | |
| 91720 | 91720 | 90745 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 4345 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5982053.54954 | 2110284.79915 | 37.7733989368092 | -122.505543365519 | (37.7733989368092, -122.505543365519) | ||
| 149730 | 149730 | 184417 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 3719 Quintara St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5981894.6182 | 2100773.2403 | 37.7472735583342 | -122.50538798932502 | (37.7472735583342, -122.505387989325) | |||
| 46657 | 46657 | 184419 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 3715 Quintara St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5981926.4298 | 2100773.5787 | 37.7472763594104 | -122.50527801414302 | (37.7472763594104, -122.505278014143) | |||
| 136484 | 136484 | 184420 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 3713 Quintara St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5981946.7351 | 2100775.6093 | 37.7472831296643 | -122.505207951598 | (37.7472831296643, -122.505207951598) | |||
| 60452 | 60452 | 118436 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 5301 Anza St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Width 3ft | 5982204.13343 | 2111649.9956900002 | 37.77715622810079 | -122.50512367797701 | (37.7771562281008, -122.505123677977) | |||
| 125453 | 125453 | 91012 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 4301X Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/24/2008 12:00:00 AM | 3 | 3x3 | 5982213.29166 | 2110288.86252 | 37.7734194931658 | -122.504991105508 | (37.7734194931658, -122.504991105508) | ||
| 36007 | 36007 | 38374 | Permitted Site 1 | Yucca gloriosa :: Spanish Dagger 224 | 3805 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/1998 12:00:00 AM | 5 | Permit Number 40433 | 5982188.1991 | 2102815.1083 | 37.7528972278417 | -122.504524079724 | (37.7528972278417, -122.504524079724) | |
| 108366 | 108366 | 91013 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 4243 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/24/2008 12:00:00 AM | 3 | 3x3 | 5982353.14616 | 2110293.5731900004 | 37.773440654471 | -122.504507686123 | (37.773440654471, -122.504507686123) | ||
| 66645 | 66645 | 89559 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 5227 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5982413.61439 | 2111658.5087 | 37.777191925470206 | -122.504399660112 | (37.7771919254702, -122.504399660112) | ||
| 42615 | 42615 | 184630 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1811 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5982223.7334 | 2102787.8653 | 37.752824516298496 | -122.50439917945499 | (37.7528245162985, -122.504399179455) | |||
| 42825 | 42825 | 55063 | Permitted Site 1 | Yucca gloriosa :: Spanish Dagger 224 | 599X 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/13/1972 12:00:00 AM | 4 | Permit Number 10952 | 5982538.31905 | 2111794.35525 | 37.7775722542249 | -122.50397833859199 | (37.7775722542249, -122.503978338592) | ||
| 182662 | 182662 | 119005 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 599 43rd Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 5982538.33316 | 2111759.97199 | 37.777477848688605 | -122.50397574245501 | (37.7774778486886, -122.503975742455) | |||
| 108855 | 108855 | 90703 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 4200X Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5982542.19786 | 2110357.81222 | 37.773628154302294 | -122.503858498829 | (37.7736281543023, -122.503858498829) | ||
| 116905 | 116905 | 91014 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 4139 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/24/2008 12:00:00 AM | 3 | 3x3 | 5982669.850769999 | 2110306.1682599997 | 37.7734938602238 | -122.503413110518 | (37.7734938602238, -122.503413110518) | ||
| 97898 | 97898 | 90702 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 4150 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5982693.082780001 | 2110362.14824 | 37.7736489307149 | -122.503336894741 | (37.7736489307149, -122.503336894741) | ||
| 50559 | 50559 | 117694 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 400 42nd Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 4ft | 5982857.55848 | 2113059.74766 | 37.7810654184436 | -122.502967701532 | (37.7810654184436, -122.502967701532) | |||
| 181654 | 181654 | 117696 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 4049 Clement St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 7ft | 5982902.7944 | 2113073.3838299997 | 37.781105517967895 | -122.50281222023399 | (37.7811055179679, -122.502812220234) | |||
| 40458 | 40458 | 117951 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 4101 Cabrillo St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5982854.39017 | 2110311.68646 | 37.7735198584795 | -122.50277518090799 | (37.7735198584795, -122.502775180908) | |||
| 38187 | 38187 | 51651 | Permitted Site 1 | Yucca gloriosa :: Spanish Dagger 224 | 570 42nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/2005 12:00:00 AM | 16 | Permit Number 47934 | 5982889.2977 | 2111913.98983 | 37.7779213685412 | -122.502773063589 | (37.7779213685412, -122.502773063589) | ||
| 82199 | 82199 | 90695 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 4100X Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5982874.37736 | 2110367.17949 | 37.773673400846704 | -122.50271015187 | (37.7736734008467, -122.50271015187) | ||
| 99932 | 99932 | 90693 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 4046 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5982986.41354 | 2110371.00337 | 37.773690483490206 | -122.50232289085 | (37.7736904834902, -122.50232289085) | ||
| 168932 | 168932 | 117950 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 4045 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5983004.753819999 | 2110316.66923 | 37.7735423752614 | -122.50225542826999 | (37.7735423752614, -122.50225542827) | |||
| 91363 | 91363 | 91015 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 4001X Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/24/2008 12:00:00 AM | 3 | 3x3 | 5983165.84214 | 2110322.7958400003 | 37.773568660348296 | -122.501698662328 | (37.7735686603483, -122.501698662328) | ||
| 143900 | 143900 | 90686 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 4000X Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5983182.62546 | 2110378.7442099997 | 37.7737232641716 | -122.501644747223 | (37.7737232641716, -122.501644747223) | ||
| 164994 | 164994 | 117722 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 475 40th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5983440.15975 | 2112634.89847 | 37.7799331315357 | -122.500920796748 | (37.7799331315357, -122.500920796748) | |||
| 85136 | 85136 | 89524 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 4840X Anza St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/26/2008 12:00:00 AM | 3 | 3x3 | 5983565.288790001 | 2111753.60264 | 37.7775206958325 | -122.50042274829201 | (37.7775206958325, -122.500422748292) | ||
| 186075 | 186075 | 117834 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 822 39th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5983882.02948 | 2110196.57614 | 37.773264138174504 | -122.49921197381799 | (37.7732641381745, -122.499211973818) | |||
| 45620 | 45620 | 117833 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 822 39th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5983882.02568 | 2110188.1448 | 37.7732409879174 | -122.49921136383699 | (37.7732409879174, -122.499211363837) | |||
| 158759 | 158759 | 117778 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 7414 Geary Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 3ft | 5983986.79106 | 2112513.3697200003 | 37.7796315288324 | -122.49902080334499 | (37.7796315288324, -122.499020803345) | |||
| 41169 | 41169 | 117777 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 7414 Geary Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 41 | Width 3ft | 5983996.528940001 | 2112514.84276 | 37.7796361445772 | -122.498987225205 | (37.7796361445772, -122.498987225205) | |||
| 84419 | 84419 | 89512 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 4700X Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/26/2008 12:00:00 AM | 3 | 3x3 | 5984063.36258 | 2111770.60585 | 37.777596605922106 | -122.498701028226 | (37.7775966059221, -122.498701028226) | ||
| 131702 | 131702 | 185509 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 2211 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5983864.8947 | 2100088.8725 | 37.745510217618104 | -122.498524482427 | (37.7455102176181, -122.498524482427) | |||
| 164761 | 164761 | 186195 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1701 Sunset Blvd | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984791.7238 | 2103544.8431 | 37.7550536742495 | -122.49557455701999 | (37.7550536742495, -122.49557455702) | |||
| 161910 | 161910 | 186078 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1901 Sunset Blvd | 24 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984848.2409 | 2102021.6754 | 37.7508747848324 | -122.495266786117 | (37.7508747848324, -122.495266786117) | |||
| 48406 | 48406 | 118206 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 599 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5985063.76803 | 2111840.93131 | 37.77784832160889 | -122.495245527349 | (37.7778483216089, -122.495245527349) | |||
| 68677 | 68677 | 182688 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1706 36th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5985037.7029 | 2103552.115 | 37.7550880417782 | -122.49472443917699 | (37.7550880417782, -122.494724439177) | |||
| 76603 | 76603 | 182687 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1706 36th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5985038.8153 | 2103544.8846 | 37.755068254208496 | -122.494720059194 | (37.7550682542085, -122.494720059194) | |||
| 180209 | 180209 | 119593 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 3145 Cabrillo St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 3ft | 5985832.002780001 | 2110410.0358599997 | 37.7739644387456 | -122.492482570938 | (37.7739644387456, -122.492482570938) | |||
| 161574 | 161574 | 185259 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 2101 Vicente St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5986433.9654 | 2097526.8372 | 37.738625879253505 | -122.489452803287 | (37.7386258792535, -122.489452803287) | |||
| 159735 | 159735 | 185260 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 2101 Vicente St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5986447.7621 | 2097526.8372 | 37.738626684671004 | -122.48940510152201 | (37.738626684671, -122.489405101522) | |||
| 36308 | 36308 | 183492 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 2526 32nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5986467.5023 | 2098045.3062 | 37.7400514152255 | -122.489374961874 | (37.7400514152255, -122.489374961874) | |||
| 164914 | 164914 | 183491 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 2526 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5986467.9493 | 2098039.2717 | 37.7400348721869 | -122.48937297276001 | (37.7400348721869, -122.48937297276) | |||
| 136603 | 136603 | 119968 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 540 28th Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 15 | Width 3ft | 5987220.74694 | 2112250.93523 | 37.7791001265755 | -122.487814013837 | (37.7791001265755, -122.487814013837) | |||
| 132766 | 132766 | 119970 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 542 28th Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 20 | Width 3ft | 5987221.67588 | 2112220.77085 | 37.779017357921205 | -122.487808583512 | (37.7790173579212, -122.487808583512) | |||
| 49645 | 49645 | 119969 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 540 28th Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 15 | Width 3ft | 5987222.6278800005 | 2112233.92491 | 37.7790535307721 | -122.48780625689501 | (37.7790535307721, -122.487806256895) | |||
| 164089 | 164089 | 119971 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 552 28th Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 20 | Width 3ft | 5987224.33596 | 2112187.66675 | 37.77892661860329 | -122.487796948534 | (37.7789266186033, -122.487796948534) | |||
| 175394 | 175394 | 120084 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 401 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5987761.35278 | 2113240.07553 | 37.7818475445369 | -122.486016488538 | (37.7818475445369, -122.486016488538) | |||
| 29138 | 29138 | 120087 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 401 26th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 5987764.76806 | 2113165.6978700003 | 37.7816435236065 | -122.48599921215299 | (37.7816435236065, -122.485999212153) | |||
| 71044 | 71044 | 183750 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 2275 28th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 0ft | 5987604.2183 | 2099806.9382 | 37.744954681905206 | -122.48557396346901 | (37.7449546819052, -122.485573963469) | |||
| 46784 | 46784 | 182104 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 2434 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5987687.8918 | 2098712.0823 | 37.7419533724178 | -122.485204320572 | (37.7419533724178, -122.485204320572) | |||
| 137211 | 137211 | 181821 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 2318 25th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5988590.0864 | 2099524.6468 | 37.7442369757948 | -122.482144374813 | (37.7442369757948, -122.482144374813) | |||
| 43779 | 43779 | 182636 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1634 Ortega St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5988875.299 | 2102432.4985 | 37.7522377520489 | -122.481371089356 | (37.7522377520489, -122.481371089356) | |||
| 25369 | 25369 | 43795 | Permitted Site 1 | Yucca gloriosa :: Spanish Dagger 224 | 787 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2000 12:00:00 AM | 8 | Permit Number 43425 | 5989119.53165 | 2109999.14868 | 37.773027918987104 | -122.48108049667499 | (37.7730279189871, -122.481080496675) | |
| 49790 | 49790 | 120767 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 4544 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 5989217.26728 | 2109917.39654 | 37.772809131283005 | -122.48073643476299 | (37.772809131283, -122.480736434763) | |||
| 67514 | 67514 | 113714 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 498x 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 5989413.63244 | 2111977.09724 | 37.778475910189705 | -122.480207969324 | (37.7784759101897, -122.480207969324) | |||
| 182715 | 182715 | 181309 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 3001 Ocean Ave | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5989502.80382 | 2095226.84947 | 37.732489380377004 | -122.47867418268801 | (37.732489380377, -122.478674182688) | |||
| 170046 | 170046 | 181310 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 3001 Ocean Ave | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5989516.32728 | 2095227.01255 | 37.7324906133438 | -122.47862744131201 | (37.7324906133438, -122.478627441312) | |||
| 94036 | 94036 | 121634 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 349 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 5990532.0 | 2113054.0 | 37.7814977082044 | -122.47641784169501 | (37.7814977082044, -122.476417841695) | |||
| 132454 | 132454 | 122074 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 347 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5990561.10649 | 2113058.51415 | 37.781511790806796 | -122.476317478147 | (37.7815117908068, -122.476317478147) | |||
| 34196 | 34196 | 217490 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1219 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 5991058.25824 | 2105170.14194 | 37.759881276613 | -122.47402187283501 | (37.759881276613, -122.474021872835) | |||
| 50483 | 50483 | 217491 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1213 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 3ft | 5991098.23401 | 2105172.09937 | 37.75988896672371 | -122.47388376033301 | (37.7598889667237, -122.473883760333) | |||
| 46921 | 46921 | 217492 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1211 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 5991111.7446099995 | 2105172.65449 | 37.7598912734774 | -122.47383707471799 | (37.7598912734774, -122.473837074718) | |||
| 134865 | 134865 | 217488 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1444 16th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | Width 4ft | 5991174.83832 | 2105560.10023 | 37.76095875075529 | -122.473647129814 | (37.7609587507553, -122.473647129814) | |||
| 167925 | 167925 | 217489 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1454 16th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 5ft | 5991178.64998 | 2105485.00303 | 37.760752774553396 | -122.473628468877 | (37.7607527745534, -122.473628468877) | |||
| 75698 | 75698 | 217493 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1501 15th Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | 5991534.00074 | 2105121.21234 | 37.7597744749213 | -122.472372960446 | (37.7597744749213, -122.472372960446) | ||||
| 25761 | 25761 | 217537 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 89 Ralston St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 18 | 5992163.635980001 | 2088434.33055 | 37.713992927605204 | -122.468980989298 | (37.7139929276052, -122.468980989298) | ||||
| 48104 | 48104 | 217533 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 167 Vernon St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | Width 10ft | 5992432.2504900005 | 2088990.3581400001 | 37.7155351614814 | -122.468092986116 | (37.7155351614814, -122.468092986116) | |||
| 167271 | 167271 | 217534 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 167 Vernon St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 10ft | 5992432.86148 | 2088983.1245400002 | 37.715515335049794 | -122.468090348403 | (37.7155153350498, -122.468090348403) | |||
| 27760 | 27760 | 181308 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 36 Ramsell St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 5992982.57261 | 2087488.7140000002 | 37.711443773193395 | -122.466081784571 | (37.7114437731934, -122.466081784571) | |||
| 182707 | 182707 | 181307 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 36 Ramsell St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 5992982.17561 | 2087469.81954 | 37.7113918706115 | -122.466081784562 | (37.7113918706115, -122.466081784562) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");