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 ▼ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 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) | |||
| 33613 | 33613 | 181300 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 101 Nueva Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 48 | Width 4ft | 6013063.40285 | 2087533.07945 | 37.712703665812796 | -122.39667984502199 | (37.7127036658128, -122.396679845022) | |||
| 167463 | 167463 | 181301 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 101 Nueva Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | Width 4ft | 6013065.73831 | 2087544.18077 | 37.7127342778318 | -122.39667255061701 | (37.7127342778318, -122.396672550617) | |||
| 147931 | 147931 | 181302 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 101 Nueva Ave | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | Width 4ft | 6013064.24149 | 2087553.26 | 37.712759124299296 | -122.396678360222 | (37.7127591242993, -122.396678360222) | |||
| 168919 | 168919 | 181303 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 101 Nueva Ave | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | Width 4ft | 6013062.584369999 | 2087561.0422 | 37.712780400456 | -122.39668463301399 | (37.712780400456, -122.396684633014) | |||
| 69192 | 69192 | 181299 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 57 Cross St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 51 | Width 2ft | 5999982.25069 | 2088153.56575 | 37.7136706537558 | -122.44193684201001 | (37.7136706537558, -122.44193684201) | |||
| 42051 | 42051 | 217536 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 374 Head St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 8ft | 5993512.184780001 | 2088326.6424900002 | 37.7137750659299 | -122.464312118436 | (37.7137750659299, -122.464312118436) | |||
| 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) | ||||
| 159985 | 159985 | 217535 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 385 Head St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 28 | Width 4ft | 5993463.79196 | 2088414.8734 | 37.714014537420795 | -122.464485782892 | (37.7140145374208, -122.464485782892) | |||
| 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) | ||
| 175681 | 175681 | 217526 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 2 Lobos St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 5996904.366669999 | 2088697.8489599999 | 37.7149892577353 | -122.45261432630899 | (37.7149892577353, -122.452614326309) | ||||
| 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) | ||||
| 41508 | 41508 | 181289 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1705 Cayuga Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 28 | Width 4ft | 5998212.96577 | 2088739.68043 | 37.715179010179 | -122.448094282435 | (37.715179010179, -122.448094282435) | |||
| 134504 | 134504 | 181290 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1705 Cayuga Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 46 | Width 4ft | 5998217.57045 | 2088741.68567 | 37.715184779333896 | -122.44807851103201 | (37.7151847793339, -122.448078511032) | |||
| 71809 | 71809 | 181294 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 286 Foote Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 5998287.94469 | 2088745.65468 | 37.7151996999876 | -122.44783555377501 | (37.7151996999876, -122.447835553775) | |||
| 36612 | 36612 | 181295 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 286 Foote Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 5998268.1836 | 2088765.30253 | 37.7152525189681 | -122.447905270113 | (37.7152525189681, -122.447905270113) | |||
| 170280 | 170280 | 181291 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 290 Foote Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 5998263.62341 | 2088768.79624 | 37.7152618512359 | -122.44792128343799 | (37.7152618512359, -122.447921283438) | |||
| 61519 | 61519 | 181296 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 286 Foote Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 5998263.468169999 | 2088770.77578 | 37.7152672777256 | -122.447921962449 | (37.7152672777256, -122.447921962449) | |||
| 169211 | 169211 | 181292 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 290 Foote Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 4ft | 5998258.97729 | 2088773.0368700002 | 37.7152732294609 | -122.447937647522 | (37.7152732294609, -122.447937647522) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 180482 | 180482 | 217529 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 1x Minerva St | 24 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | Width 0ft | 5996247.03619 | 2089001.7982400001 | 37.7157861460877 | -122.45490827471599 | (37.7157861460877, -122.454908274716) | |||
| 26618 | 26618 | 217527 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 1x Minerva St | 22 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 5996233.42463 | 2089002.36528 | 37.7157869222112 | -122.454955363219 | (37.7157869222112, -122.454955363219) | |||
| 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) | |||
| 131741 | 131741 | 217528 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 1x Minerva St | 23 | Median : Cutout 11 | Tree 1 | DPW 2 | 21 | Width 0ft | 5996239.67179 | 2089002.5174200002 | 37.7157876983267 | -122.454933781265 | (37.7157876983267, -122.454933781265) | |||
| 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) | |||
| 167823 | 167823 | 217524 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 260 Minerva St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 5994388.54564 | 2089047.1940400002 | 37.715804004829394 | -122.461335317482 | (37.7158040048294, -122.461335317482) | |||
| 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) |
| 67603 | 67603 | 181293 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 184 Mount Vernon Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 25 | 5998992.1360599995 | 2089349.9308099998 | 37.7168991290824 | -122.44544499658998 | (37.7168991290824, -122.44544499659) | ||||
| 176248 | 176248 | 217532 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 10 Caine Ave | 12 | : 4 | Tree 1 | Private 1 | 4 | Width 0ft | 5997565.18295 | 2089591.75195 | 37.7174815498251 | -122.450394677186 | (37.7174815498251, -122.450394677186) | |||
| 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) | |||
| 135561 | 135561 | 181297 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 271 Prague St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 8ft | 6004070.036069999 | 2089576.3775900002 | 37.717809478589295 | -122.427909293206 | (37.7178094785893, -122.427909293206) | |||
| 153023 | 153023 | 181306 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 469 Harkness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6010294.74093 | 2089615.03342 | 37.7182658036088 | -122.40639587399599 | (37.7182658036088, -122.406395873996) | |||
| 166547 | 166547 | 200175 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1022 Jamestown Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6013884.9652 | 2089743.6718 | 37.7188192082582 | -122.39399489546699 | (37.7188192082582, -122.393994895467) | |||
| 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) | |||
| 45295 | 45295 | 181298 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 538 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6002983.65718 | 2090496.16604 | 37.7202734951152 | -122.43173005392 | (37.7202734951152, -122.43173005392) | |||
| 148650 | 148650 | 217522 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 143 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 5995315.51814 | 2090865.8028 | 37.7208507807174 | -122.45826284485202 | (37.7208507807174, -122.458262844852) | |||
| 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) | ||||
| 31668 | 31668 | 202074 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1 Gould St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6012682.24985 | 2090663.29707 | 37.721277396617204 | -122.39821671715099 | (37.7212773966172, -122.398216717151) | ||||
| 169656 | 169656 | 202075 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1 Gould St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6012687.555919999 | 2090674.9679400001 | 37.7213097380253 | -122.398199193847 | (37.7213097380253, -122.398199193847) | ||||
| 35442 | 35442 | 202076 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1 Gould St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6012694.00092 | 2090696.52405 | 37.7213692857431 | -122.398178426718 | (37.7213692857431, -122.398178426718) | ||||
| 133882 | 133882 | 202077 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1 Gould St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 6012700.16365 | 2090713.41208 | 37.721416000129 | -122.398158307957 | (37.721416000129, -122.398158307957) | ||||
| 48709 | 48709 | 202079 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1 Gould St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 6012746.01501 | 2090845.03433 | 37.721779962062996 | -122.398009040306 | (37.721779962063, -122.398009040306) | ||||
| 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) | |||
| 162014 | 162014 | 181305 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 700 Brussels St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 10ft | 6010997.70015 | 2091457.1007700001 | 37.723363042265504 | -122.40409559613501 | (37.7233630422655, -122.404095596135) | |||
| 167603 | 167603 | 181304 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 700 Brussels St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 10ft | 6010994.40429 | 2091467.5245700001 | 37.7233914797163 | -122.404107722615 | (37.7233914797163, -122.404107722615) | |||
| 149090 | 149090 | 217520 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 278 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5995672.48262 | 2091833.70797 | 37.7235289240095 | -122.457098912596 | (37.7235289240095, -122.457098912596) | |||
| 146650 | 146650 | 217521 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 290 Miramar Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5995382.791180001 | 2092045.04247 | 37.7240925570105 | -122.458115605177 | (37.7240925570105, -122.458115605177) | |||
| 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) | ||
| 137043 | 137043 | 199617 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1670 Armstrong Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | 6013996.30242 | 2092813.5629900002 | 37.7272547028171 | -122.39382481138 | (37.7272547028171, -122.39382481138) | ||||
| 174141 | 174141 | 217519 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 125 Marston Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 94 | Width 10ft | 5998618.10798 | 2093180.61105 | 37.72739593057529 | -122.447013334218 | (37.7273959305753, -122.447013334218) | |||
| 167168 | 167168 | 199618 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 2399 Lane St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | 6013981.31336 | 2092866.65416 | 37.7273996474538 | -122.393880343621 | (37.7273996474538, -122.393880343621) | ||||
| 50723 | 50723 | 199619 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 2399 Lane St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 22 | 6013984.3244 | 2092869.9258 | 37.727408798052295 | -122.393870163286 | (37.7274087980523, -122.393870163286) | ||||
| 137404 | 137404 | 199620 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 2399 Lane St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 6013988.45481 | 2092875.57425 | 37.7274245370974 | -122.393856279557 | (37.7274245370974, -122.393856279557) | ||||
| 161644 | 161644 | 217517 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 124 Marston Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 5998604.94971 | 2093225.3644700001 | 37.7275180612089 | -122.447062041474 | (37.7275180612089, -122.447062041474) | ||||
| 72611 | 72611 | 217518 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 124 Marston Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 5998600.75769 | 2093225.60072 | 37.727518470385796 | -122.44707655025101 | (37.7275184703858, -122.447076550251) | ||||
| 122228 | 122228 | 217516 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 124 Marston Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 5998607.55261 | 2093227.9967099999 | 37.727525437439205 | -122.44705323261499 | (37.7275254374392, -122.447053232615) | ||||
| 61040 | 61040 | 199621 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 2330 Lane St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 6013971.3633 | 2092946.01515 | 37.7276170037228 | -122.39392029420799 | (37.7276170037228, -122.393920294208) | ||||
| 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) | |||
| 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) | |||
| 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) | ||||
| 71157 | 71157 | 217515 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 181 Staples Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 5998870.21413 | 2093813.7406900001 | 37.7291487568991 | -122.4461873294 | (37.7291487568991, -122.4461873294) | ||||
| 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) | ||||
| 31713 | 31713 | 217509 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 100 Gennessee St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 1ft | 5997469.91402 | 2093889.3478299999 | 37.729276287058795 | -122.45103370846 | (37.7292762870588, -122.45103370846) | |||
| 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) | |
| 148779 | 148779 | 217508 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 419 Flood Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5997977.40544 | 2094065.2765400002 | 37.729788387114795 | -122.449291943769 | (37.7297883871148, -122.449291943769) | |||
| 132174 | 132174 | 217505 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 427 Flood Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 28 | Width 8ft | 5997901.29894 | 2094070.4449599998 | 37.72979822478529 | -122.44955542354401 | (37.7297982247853, -122.449555423544) | |||
| 59626 | 59626 | 217506 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 427 Flood Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 29 | 5997927.13531 | 2094070.23257 | 37.72979911961961 | -122.449466089413 | (37.7297991196196, -122.449466089413) | ||||
| 159178 | 159178 | 217507 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 419 Flood Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 5997977.15972 | 2094069.1904099998 | 37.7297991196211 | -122.449293075119 | (37.7297991196211, -122.449293075119) | |||
| 177863 | 177863 | 217502 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 426 Hearst Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | Width 10ft | 5998544.81231 | 2094412.25403 | 37.7307735449502 | -122.447355326608 | (37.7307735449502, -122.447355326608) | |||
| 61867 | 61867 | 217503 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 426 Hearst Ave | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 13 | Width 10ft | 5998540.33136 | 2094412.3472900002 | 37.7307735449633 | -122.44737082460699 | (37.7307735449633, -122.447370824607) | |||
| 38630 | 38630 | 217501 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 502 Edna St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | Width 4ft | 5998794.71399 | 2094416.16661 | 37.73079856498921 | -122.44649166176501 | (37.7307985649892, -122.446491661765) | |||
| 68903 | 68903 | 217504 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 303 Gennessee St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 2ft | 5997422.28998 | 2094446.0580000002 | 37.7308021541797 | -122.451238481395 | (37.7308021541797, -122.451238481395) | |||
| 158195 | 158195 | 217499 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 414 Detroit St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 30 | 5999453.3652099995 | 2094474.2797299998 | 37.7309957287723 | -122.444218781791 | (37.7309957287723, -122.444218781791) | ||||
| 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) | |
| 155185 | 155185 | 217500 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 433 Detroit St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 27 | Width 10ft | 5999422.35392 | 2094544.1981 | 37.7311859389748 | -122.44433101536501 | (37.7311859389748, -122.444331015365) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 170980 | 170980 | 244001 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 431 Bosworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 2ft | 6003347.56603 | 2095197.5465400002 | 37.73320305537921 | -122.430807475403 | (37.7332030553792, -122.430807475403) | |||
| 147276 | 147276 | 199622 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1799 Revere Ave | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | 6014049.74697 | 2095137.7108200002 | 37.733639310212396 | -122.393802664676 | (37.7336393102124, -122.393802664676) | ||||
| 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) | ||
| 64773 | 64773 | 199615 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 1700x Quesada Ave | 56 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | 6014226.56708 | 2095397.2747900002 | 37.734361844424704 | -122.393209497917 | (37.7343618444247, -122.393209497917) | ||||
| 63803 | 63803 | 199614 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 1700x Quesada Ave | 53 | Median : Yard 3 | Tree 1 | DPW 2 | 16 | 6014257.65945 | 2095401.98638 | 37.734376508759496 | -122.39310233021601 | (37.7343765087595, -122.393102330216) | ||||
| 162907 | 162907 | 217498 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1 Malta Dr | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 5999813.4338 | 2095843.9965700002 | 37.7347771864063 | -122.443072299949 | (37.7347771864063, -122.443072299949) | |||
| 178209 | 178209 | 217497 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1 Malta Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 6ft | 5999813.58139 | 2095851.10387 | 37.7347967097977 | -122.44307229994 | (37.7347967097977, -122.44307229994) | |||
| 170713 | 170713 | 243968 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1200 San Jose Ave | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6004061.61432 | 2095990.9181 | 37.7354219049951 | -122.428395344371 | (37.7354219049951, -122.428395344371) | ||||
| 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) | ||||
| 134025 | 134025 | 243976 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1201 San Jose Ave | 70 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6004556.64322 | 2096143.57753 | 37.735869073092395 | -122.426694711107 | (37.7358690730924, -122.426694711107) | ||||
| 36380 | 36380 | 243977 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1201 San Jose Ave | 74 | Front Yard : Yard 7 | Tree 1 | Private 1 | 21 | 6004578.54944 | 2096162.87225 | 37.73592329053071 | -122.426620346145 | (37.7359232905307, -122.426620346145) | ||||
| 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) | ||||
| 74483 | 74483 | 243979 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1201 San Jose Ave | 78 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 6004594.177069999 | 2096179.3802599998 | 37.735969501297 | -122.42656749031099 | (37.735969501297, -122.426567490311) | ||||
| 32831 | 32831 | 243980 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1201 San Jose Ave | 79 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6004603.12758 | 2096184.7977099998 | 37.7359848823907 | -122.426536930441 | (37.7359848823907, -122.426536930441) | ||||
| 162839 | 162839 | 243981 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1201 San Jose Ave | 80 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 6004609.846480001 | 2096189.0617 | 37.7359969701789 | -122.426514004025 | (37.7359969701789, -122.426514004025) | ||||
| 60603 | 60603 | 247590 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 800 Tompkins Ave | 11 | Front Yard : Yard 7 | Tree 1 | Private 1 | 40 | 6008957.64855 | 2096444.8911599999 | 37.736944252178205 | -122.411499920492 | (37.7369442521782, -122.411499920492) |
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");