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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 21110 | 21110 | 4447 | Permitted Site 1 | Yucca gloriosa :: Spanish Dagger 224 | 1361 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 6004544.06336 | 2100936.2409900003 | 37.7490279200058 | -122.42707946086 | (37.7490279200058, -122.42707946086) | |||
| 7376 | 7376 | 8465 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 1900 Geary Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 48 | 8 | 6002373.3675 | 2113709.4137 | 37.783976936809104 | -122.435499366282 | (37.7839769368091, -122.435499366282) | |||
| 19203 | 19203 | 26914 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 10 Caine Ave | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 10 | 5997577.15723 | 2089606.82913 | 37.7175236335794 | -122.45035437405599 | (37.7175236335794, -122.450354374056) | |||
| 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) | |||
| 152241 | 152241 | 30689 | Permitted Site 1 | Yucca gloriosa :: Spanish Dagger 224 | 529 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | 12 | Permit Number 34609 | 6004554.59281 | 2110367.64108 | 37.7749248947896 | -122.427714942511 | (37.7749248947896, -122.427714942511) | |
| 188262 | 188262 | 32743 | Permitted Site 1 | Yucca gloriosa :: Spanish Dagger 224 | 31 Montana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 12 | 3x3 | Permit Number 37126 | 5996349.198890001 | 2089288.18101 | 37.7165783462864 | -122.454575832225 | (37.7165783462864, -122.454575832225) |
| 30315 | 30315 | 32956 | Permitted Site 1 | Yucca gloriosa :: Spanish Dagger 224 | 1218 Mariposa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 12 | 3x8 | Permit Number 37270 | 6013588.683209999 | 2106187.45016 | 37.763953908676896 | -122.39617085120301 | (37.7639539086769, -122.396170851203) |
| 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) | ||
| 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) | |
| 123412 | 123412 | 38815 | Permitted Site 1 | Yucca gloriosa :: Spanish Dagger 224 | 204 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/1998 12:00:00 AM | 8 | Permit Number 40651 | 5994944.16478 | 2114141.25002 | 37.78473790153421 | -122.461232820546 | (37.7847379015342, -122.461232820546) | |
| 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) | |
| 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) | |||
| 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) | |
| 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) | |
| 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) | |
| 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) | ||
| 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) | ||
| 75856 | 75856 | 57578 | Permitted Site 1 | Yucca gloriosa :: Spanish Dagger 224 | 1900X 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/23/1976 12:00:00 AM | 20 | Permit Number 16445 | 6012021.89492 | 2105637.6019900003 | 37.762356845824705 | -122.401551289982 | (37.7623568458247, -122.401551289982) | ||
| 163841 | 163841 | 57583 | Permitted Site 1 | Yucca gloriosa :: Spanish Dagger 224 | 2001 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1976 12:00:00 AM | 31 | Permit Number 16451 | 6011409.07768 | 2106483.20737 | 37.764644474674 | -122.403730310432 | (37.764644474674, -122.403730310432) | ||
| 42362 | 42362 | 61510 | Permitted Site 1 | Yucca gloriosa :: Spanish Dagger 224 | 1237 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/25/1984 12:00:00 AM | 23 | Permit Number 21466 | 6012274.20726 | 2102601.29078 | 37.754033879279 | -122.40046534240601 | (37.754033879279, -122.400465342406) | |
| 135295 | 135295 | 61786 | Permitted Site 1 | Yucca gloriosa :: Spanish Dagger 224 | 1453 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1985 12:00:00 AM | 5 | Permit Number 21808 | 6012048.53726 | 2101599.7362 | 37.7512712410927 | -122.40117539492701 | (37.7512712410927, -122.401175394927) | |
| 155215 | 155215 | 65394 | Permitted Site 1 | Yucca gloriosa :: Spanish Dagger 224 | 290 Napoleon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/02/1989 12:00:00 AM | 53 | Permit Number 28237 | 6011952.10102 | 2099776.9681 | 37.746260933607104 | -122.401380800085 | (37.7462609336071, -122.401380800085) | ||
| 57015 | 57015 | 72610 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1501 25th St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/01/1997 12:00:00 AM | 5 | 6014116.81236 | 2101967.79317 | 37.7523970151345 | -122.39404877763201 | (37.7523970151345, -122.394048777632) | ||
| 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) | ||
| 182383 | 182383 | 73713 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1265 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/25/1984 12:00:00 AM | 27 | 6012277.51673 | 2102506.0830599996 | 37.7537726442006 | -122.400447210275 | (37.7537726442006, -122.400447210275) | ||
| 183335 | 183335 | 73730 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1799 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/18/1990 12:00:00 AM | 19 | 6014041.4845 | 2095157.5814099999 | 37.733693411618205 | -122.393832621075 | (37.7336934116182, -122.393832621075) | ||
| 34809 | 34809 | 74063 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 130 Alpha St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/21/1998 12:00:00 AM | 12 | 6010946.7362 | 2088147.19919 | 37.714271881112296 | -122.404038948741 | (37.7142718811123, -122.404038948741) | ||
| 65838 | 65838 | 74275 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 130 Alpha St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/21/1998 12:00:00 AM | 12 | 6010944.700130001 | 2088154.7138 | 37.714292400951 | -122.40404651475401 | (37.714292400951, -122.404046514754) | ||
| 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) | ||
| 60978 | 60978 | 78261 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 414 Holyoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/2000 12:00:00 AM | 50 | 6009735.35322 | 2092462.5528099998 | 37.7260531896995 | -122.408530204426 | (37.7260531896995, -122.408530204426) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 163577 | 163577 | 92398 | Permitted Site 1 | Yucca gloriosa :: Spanish Dagger 224 | 1919 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/29/2009 12:00:00 AM | 12 | 3x3 | Permit Number 52800 | 6012329.06895 | 2103729.7014200003 | 37.757135307361295 | -122.400354868801 | (37.7571353073613, -122.400354868801) | |
| 115946 | 115946 | 98813 | Permitted Site 1 | Yucca gloriosa :: Spanish Dagger 224 | 290 Napoleon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | 3x3 | 6011920.40954 | 2099763.4920200002 | 37.7462221629395 | -122.40148943908702 | (37.7462221629395, -122.401489439087) | |||
| 153004 | 153004 | 98814 | Permitted Site 1 | Yucca gloriosa :: Spanish Dagger 224 | 290 Napoleon St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | 3x3 | 6011900.23089 | 2099755.59596 | 37.7461993561215 | -122.401558659925 | (37.7461993561215, -122.401558659925) | |||
| 59468 | 59468 | 98817 | Permitted Site 1 | Yucca gloriosa :: Spanish Dagger 224 | 290 Napoleon St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3x3 | 6011799.60927 | 2099715.83427 | 37.7460845639436 | -122.401903804432 | (37.7460845639436, -122.401903804432) | |||
| 167849 | 167849 | 104212 | Permitted Site 1 | Yucca gloriosa :: Spanish Dagger 224 | 1117 De Haro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 6012239.80468 | 2103199.03133 | 37.7556732255654 | -122.400626303066 | (37.7556732255654, -122.400626303066) | ||||
| 59061 | 59061 | 106254 | Permitted Site 1 | Yucca gloriosa :: Spanish Dagger 224 | 1900X 18th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Permit Number 770844 | 6011963.420530001 | 2105634.8239700003 | 37.76234595501379 | -122.40175333704599 | (37.7623459550138, -122.401753337046) | |||
| 14751 | 14751 | 108262 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 1x Gould St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6012679.649230001 | 2090646.14976 | 37.7212301687063 | -122.39822450437799 | (37.7212301687063, -122.398224504378) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) |
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");