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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4383 | 4383 | 253609 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 318 Utah St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | Width 4ft | Permit Number 780845 | 6010580.39617 | 2106780.39752 | 37.7654141639451 | -122.40661745795299 | (37.7654141639451, -122.406617457953) | |||
| 138309 | 138309 | 119670 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 699x Missouri St | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6013712.0 | 2104098.0 | 37.7582235960409 | -122.39559792996201 | (37.7582235960409, -122.395597929962) | |||||
| 40924 | 40924 | 217538 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 2 Castenada Ave | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5994399.3644900005 | 2101801.93145 | 37.750826002039105 | -122.46222241953998 | (37.7508260020391, -122.46222241954) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 51800 | 51800 | 74618 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 2650 Fulton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1993 12:00:00 AM | 2 | 5995104.27879 | 2110288.95981 | 37.7741697532931 | -122.460399659179 | (37.7741697532931, -122.460399659179) | ||
| 53782 | 53782 | 141022 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 170 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5998548.3551 | 2112697.1941 | 37.7809796623886 | -122.448659524594 | (37.7809796623886, -122.448659524594) | |||
| 68836 | 68836 | 217525 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 2 Lobos St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 5996931.31529 | 2088711.9750400002 | 37.7150295887309 | -122.452522199764 | (37.7150295887309, -122.452522199764) | ||||
| 71444 | 71444 | 45455 | Permitted Site 1 | Yucca gloriosa :: Spanish Dagger 224 | 258 Parker Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Permit Number 44240 | 5997038.9938 | 2112669.4435 | 37.780817044183294 | -122.453879118533 | (37.7808170441833, -122.453879118533) | |||
| 73665 | 73665 | 141021 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 160 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5998570.6909 | 2112701.5936 | 37.7809930194286 | -122.448582571297 | (37.7809930194286, -122.448582571297) | |||
| 90674 | 90674 | 47490 | Permitted Site 1 | Yucca gloriosa :: Spanish Dagger 224 | 99X LYELL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/19/2002 12:00:00 AM | 2 | 3x3 | Permit Number 45384 | 6003192.0 | 2094433.0 | 37.7310949685834 | -122.431290753374 | (37.7310949685834, -122.431290753374) | |
| 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) | |||
| 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) | |||
| 168215 | 168215 | 217514 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 181 Staples Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 5998875.02726 | 2093813.8040200002 | 37.7291492056601 | -122.44617069463001 | (37.7291492056601, -122.44617069463) | ||||
| 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) | |||
| 171843 | 171843 | 217512 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 181 Staples Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 5998882.8177 | 2093813.39274 | 37.7291485212785 | -122.44614373296801 | (37.7291485212785, -122.446143732968) | ||||
| 181580 | 181580 | 217513 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 181 Staples Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 5998878.5265 | 2093813.54586 | 37.7291486966488 | -122.446158578953 | (37.7291486966488, -122.446158578953) | ||||
| 182910 | 182910 | 217510 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 212 Staples Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5998646.23648 | 2093807.3059900003 | 37.7291182950515 | -122.446961172636 | (37.7291182950515, -122.446961172636) | |||
| 28230 | 28230 | 243963 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 3450 26th St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 6006727.57204 | 2100887.26512 | 37.7490166748846 | -122.419525382284 | (37.7490166748846, -122.419525382284) | |||
| 32691 | 32691 | 199592 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1453 Rhode Island St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6012056.44689 | 2101608.80688 | 37.751296588469295 | -122.40114867968799 | (37.7512965884693, -122.401148679688) | ||||
| 32746 | 32746 | 243960 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1485 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009591.25577 | 2100642.20365 | 37.7485046755637 | -122.40960540867201 | (37.7485046755637, -122.409605408672) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 56278 | 56278 | 137513 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 3801 Webster St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 6ft | 6002487.07577 | 2121653.7277599997 | 37.805796422742795 | -122.435674534362 | (37.8057964227428, -122.435674534362) | |||
| 60240 | 60240 | 199522 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 1150x Tennessee St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6015555.37035 | 2103675.62885 | 37.757166218851104 | -122.389193205711 | (37.7571662188511, -122.389193205711) | |||
| 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) | ||
| 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) | |||
| 68748 | 68748 | 142406 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 10 MAYFAIR DR | 21 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5997813.4721 | 2114548.5306 | 37.7860208967808 | -122.451335398225 | (37.7860208967808, -122.451335398225) | |||
| 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) | |||
| 77123 | 77123 | 200489 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1086 Jamestown Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 6013557.4449 | 2089988.7054 | 37.719473813471204 | -122.395144165456 | (37.7194738134712, -122.395144165456) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 113161 | 113161 | 29538 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 2600X Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6015154.806658401 | 2091194.1931941002 | 37.7228725479476 | -122.389706778167 | (37.7228725479476, -122.389706778167) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 130739 | 130739 | 199576 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 1300x De Haro St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 6ft | 6012291.12869 | 2102166.26661 | 37.752840341307504 | -122.40037626996 | (37.7528403413075, -122.40037626996) | |||
| 134615 | 134615 | 46635 | Permitted Site 1 | Yucca gloriosa :: Spanish Dagger 224 | 1571 Underwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2002 12:00:00 AM | 3 | Permit Number 44756 | 6014716.9997 | 2093587.5042 | 37.729419814580105 | -122.39138742541799 | (37.7294198145801, -122.391387425418) | |
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 146635 | 146635 | 199581 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 800 Vermont St | 36 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 6011269.47396 | 2104166.61707 | 37.7582758365713 | -122.40405012282801 | (37.7582758365713, -122.404050122828) | |||
| 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) | ||
| 152353 | 152353 | 217530 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 1x Minerva St | 28 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 5996285.62534 | 2089001.27472 | 37.7157869222129 | -122.454774855787 | (37.7157869222129, -122.454774855787) | |||
| 156085 | 156085 | 199616 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1999 Revere Ave | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | 6013002.21254 | 2095907.198 | 37.735693893246896 | -122.397478268519 | (37.7356938932469, -122.397478268519) | ||||
| 157310 | 157310 | 217539 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 2 Castenada Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5994385.9326599995 | 2101818.26452 | 37.750870075096394 | -122.462270052135 | (37.7508700750964, -122.462270052135) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 163824 | 163824 | 217523 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 208 Minerva St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 3ft | 5994934.27382 | 2089035.0177799999 | 37.715801965169604 | -122.459448160326 | (37.7158019651696, -122.459448160326) | |||
| 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) | |||
| 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) | |||
| 167592 | 167592 | 72625 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1501 25th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/01/1997 12:00:00 AM | 3 | 6014103.8148 | 2101960.5614400003 | 37.7523764359486 | -122.39409321944099 | (37.7523764359486, -122.394093219441) | ||
| 167819 | 167819 | 199520 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 900 Cesar Chavez St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6016073.017659999 | 2101191.4647 | 37.7503739092406 | -122.387229690715 | (37.7503739092406, -122.387229690715) | |||
| 169312 | 169312 | 217511 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 212 Staples Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5998689.47199 | 2093806.9285 | 37.7291197285738 | -122.44681167741699 | (37.7291197285738, -122.446811677417) | |||
| 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) | |||
| 170866 | 170866 | 243982 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 200 Kingston St | 16 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6006211.87378 | 2098086.29455 | 37.741296782931 | -122.42110981598499 | (37.741296782931, -122.421109815985) | ||||
| 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) | |||
| 183892 | 183892 | 244007 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 784 Duncan St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 6ft | 6001417.55877 | 2099722.5015 | 37.7455179856587 | -122.437803995867 | (37.7455179856587, -122.437803995867) | |||
| 185822 | 185822 | 243962 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 3450 26th St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 6006732.96766 | 2100887.37814 | 37.7490172891268 | -122.419506732173 | (37.7490172891268, -122.419506732173) | |||
| 186769 | 186769 | 217541 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 82 Ventura Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5994344.6097099995 | 2101818.25531 | 37.7508676703211 | -122.462412949005 | (37.7508676703211, -122.462412949005) | |||
| 26033 | 26033 | 246779 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 398 Franconia St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 8ft | 6009874.45509 | 2098802.1456299997 | 37.74346814475479 | -122.408496327841 | (37.7434681447548, -122.408496327841) | |||
| 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) | |||
| 27786 | 27786 | 243964 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 979 San Bruno Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 6011092.59342 | 2103787.62329 | 37.7572253196086 | -122.40463517678002 | (37.7572253196086, -122.40463517678) | |||
| 29481 | 29481 | 217531 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 1x Minerva St | 38 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 0ft | 5996362.99834 | 2088995.98421 | 37.715776833598596 | -122.45450703858299 | (37.7157768335986, -122.454507038583) | |||
| 33825 | 33825 | 199536 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 101 Pennsylvania Ave | 13 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6014326.65854 | 2106427.7746900003 | 37.7646548213741 | -122.3936352163 | (37.7646548213741, -122.3936352163) | ||||
| 33831 | 33831 | 201522 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 863 Innes Ave | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 6019436.4693599995 | 2094253.9637900002 | 37.7315105906351 | -122.375117750879 | (37.7315105906351, -122.375117750879) | |||
| 35089 | 35089 | 243978 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1201 San Jose Ave | 76 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6004588.46206 | 2096170.32088 | 37.7359443031923 | -122.42658660449601 | (37.7359443031923, -122.426586604496) | ||||
| 38015 | 38015 | 199539 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 101 Pennsylvania Ave | 29 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6014306.32543 | 2106588.22491 | 37.765094252633205 | -122.393716774935 | (37.7650942526332, -122.393716774935) | ||||
| 39448 | 39448 | 199541 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 101 Pennsylvania Ave | 34 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6014267.9908 | 2106682.1532 | 37.7653500288033 | -122.39385594139799 | (37.7653500288033, -122.393855941398) | ||||
| 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) | ||
| 43575 | 43575 | 199537 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 101 Pennsylvania Ave | 16 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6014323.98726 | 2106464.8847 | 37.764756568894796 | -122.393647053167 | (37.7647565688948, -122.393647053167) | ||||
| 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) | |||
| 47050 | 47050 | 217540 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 2 Castenada Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5994380.2329400005 | 2101825.97168 | 37.7508909088044 | -122.462290321068 | (37.7508909088044, -122.462290321068) | |||
| 74158 | 74158 | 138257 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 2600 GEARY BLVD | 2 | unknown : Yard 19 | Tree 1 | Private 1 | 4 | Width 0ft | 5999359.7213 | 2113228.3471 | 37.7824844323354 | -122.445890830511 | (37.7824844323354, -122.445890830511) | |||
| 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) | ||
| 121246 | 121246 | 199538 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 101 Pennsylvania Ave | 18 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6014323.6703699995 | 2106494.67035 | 37.7648383361526 | -122.39365023409401 | (37.7648383361526, -122.393650234094) | ||||
| 131176 | 131176 | 113843 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1709 Revere Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 5x5 | 6014550.227530001 | 2094753.9924400002 | 37.732613497603104 | -122.392045518911 | (37.7326134976031, -122.392045518911) | |||
| 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) |
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");