Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlantDate, PlotSize, PermitNotes
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9205 | 9205 | 90538 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 508 Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/14/2008 12:00:00 AM | 4 | 3x3 | 5993999.75681 | 2110771.22635 | 37.7754303285192 | -122.464255386494 | (37.7754303285192, -122.464255386494) | ||
| 24032 | 24032 | 207660 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1207 Willard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5996711.4694300005 | 2107231.1786 | 37.7658662000893 | -122.454619182239 | (37.7658662000893, -122.454619182239) | |||
| 24712 | 24712 | 189244 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 690 Texas St | 5 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6013923.095430001 | 2103892.83973 | 37.757672010179206 | -122.394853496397 | (37.7576720101792, -122.394853496397) | |||
| 25196 | 25196 | 137812 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1802 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6004857.7279 | 2115477.5519 | 37.7889725883007 | -122.42703036076 | (37.7889725883007, -122.42703036076) | |||
| 25319 | 25319 | 124355 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1108 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 5992124.25378 | 2111386.32559 | 37.7770109442204 | -122.470787948699 | (37.7770109442204, -122.470787948699) | |||
| 25711 | 25711 | 223380 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 800 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009884.795080001 | 2104504.34853 | 37.7591257084916 | -122.40886279708499 | (37.7591257084916, -122.408862797085) | |||
| 26480 | 26480 | 207665 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 315 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 6ft | 5996615.28225 | 2106600.5600799997 | 37.7641291658503 | -122.454906302505 | (37.7641291658503, -122.454906302505) | |||
| 27840 | 27840 | 223489 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 469 Tompkins Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6007880.65482 | 2096572.00473 | 37.737232809540004 | -122.415232573728 | (37.73723280954, -122.415232573728) | |||
| 27900 | 27900 | 111560 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1498x Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6011715.03072 | 2101496.45297 | 37.7509690365089 | -122.402321443274 | (37.7509690365089, -122.402321443274) | |||
| 28172 | 28172 | 64537 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1448 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/1988 12:00:00 AM | 4 | Permit Number 25419 | 6015877.1655 | 2094890.2503 | 37.73306121716389 | -122.38746743202299 | (37.7330612171639, -122.387467432023) | |
| 28671 | 28671 | 207602 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 121 Brighton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5996198.32663 | 2090727.0482700001 | 37.7205204831134 | -122.455201239645 | (37.7205204831134, -122.455201239645) | |||
| 28812 | 28812 | 94752 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 491 Bay Shore Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/28/2010 12:00:00 AM | 4 | 3x3 | 6010356.01767 | 2097548.96974 | 37.7400541518831 | -122.406742898988 | (37.7400541518831, -122.406742898988) | ||
| 29141 | 29141 | 45523 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 153 Jordan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/23/2001 12:00:00 AM | 4 | Permit Number 44284 | 5996204.70963 | 2113340.17454 | 37.782610825272 | -122.456813820837 | (37.782610825272, -122.456813820837) | ||
| 33710 | 33710 | 191077 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 334 12th St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6008423.37153 | 2108669.51917 | 37.770480335524894 | -122.414211801833 | (37.7704803355249, -122.414211801833) | |||
| 34407 | 34407 | 94751 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 491 Bay Shore Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/28/2010 12:00:00 AM | 4 | 3x3 | 6010352.467540001 | 2097498.7285 | 37.739916001622795 | -122.40675163410101 | (37.7399160016228, -122.406751634101) | ||
| 34822 | 34822 | 223580 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 85 Bessie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008370.33425 | 2100060.18297 | 37.746838086126 | -122.413786185095 | (37.746838086126, -122.413786185095) | |||
| 37230 | 37230 | 176261 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 188 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004431.12132 | 2092306.16061 | 37.7253252856153 | -122.42685548290399 | (37.7253252856153, -122.426855482904) | |||
| 39877 | 39877 | 207693 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 10 Madrone Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5992963.53977 | 2099050.31915 | 37.7431879987389 | -122.46698756732599 | (37.7431879987389, -122.466987567326) | |||
| 41937 | 41937 | 90906 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 901X Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2008 12:00:00 AM | 4 | 3x3 | 5992776.28818 | 2110667.73592 | 37.7750755767076 | -122.46848008510901 | (37.7750755767076, -122.468480085109) | ||
| 42078 | 42078 | 52803 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 25@ TEXAS Sierra St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/25/2006 12:00:00 AM | 4 | Permit Number 48835 | 6013662.91964 | 2104110.0408099997 | 37.758253927301396 | -122.395768516112 | (37.7582539273014, -122.395768516112) | ||
| 42624 | 42624 | 223527 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 647 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6002187.40945 | 2102635.2960200002 | 37.753559575019494 | -122.435350295491 | (37.7535595750195, -122.435350295491) | |||
| 43504 | 43504 | 223465 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 857 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5998659.334430001 | 2107218.6486 | 37.7659433250613 | -122.447881050474 | (37.7659433250613, -122.447881050474) | |||
| 43526 | 43526 | 223575 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 179 Wool St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6007390.067919999 | 2097987.37469 | 37.7410915189664 | -122.41702901808901 | (37.7410915189664, -122.417029018089) | |||
| 43978 | 43978 | 207542 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1237 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5994826.3107900005 | 2107131.68473 | 37.76548471038671 | -122.461132292833 | (37.7654847103867, -122.461132292833) | |||
| 44060 | 44060 | 126493 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2901 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003443.9611599995 | 2118340.85925 | 37.796754452719 | -122.43212636085899 | (37.796754452719, -122.432126360859) | |||
| 44316 | 44316 | 191057 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 351 Saint Francis Pl | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 1ft | 6013212.85575 | 2113183.5161599996 | 37.78314260738 | -122.39796154170901 | (37.78314260738, -122.397961541709) | |||
| 44750 | 44750 | 207581 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1251 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5992198.24643 | 2098404.0383900004 | 37.741369274584606 | -122.46958668807301 | (37.7413692745846, -122.469586688073) | |||
| 44800 | 44800 | 176232 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 490 Lisbon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6002153.50763 | 2090617.3285 | 37.7205590883176 | -122.434608262185 | (37.7205590883176, -122.434608262185) | |||
| 45608 | 45608 | 112872 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 599x CENTRAL AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 5999621.0 | 2110473.0 | 37.7749338721416 | -122.44478880475599 | (37.7749338721416, -122.444788804756) | |||
| 46290 | 46290 | 207643 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1541 Funston Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5992162.23499 | 2104876.45393 | 37.759138772946 | -122.47018240438899 | (37.759138772946, -122.470182404389) | |||
| 46309 | 46309 | 224083 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 285 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004355.4783 | 2109071.91707 | 37.7713558875841 | -122.428311353983 | (37.7713558875841, -122.428311353983) | |||
| 46717 | 46717 | 176263 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 728 Burrows St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009121.13665 | 2092884.06532 | 37.7271761560436 | -122.410683275834 | (37.7271761560436, -122.410683275834) | |||
| 47253 | 47253 | 142318 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 551 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5999657.1151 | 2110481.4792 | 37.7749592147956 | -122.444664484942 | (37.7749592147956, -122.444664484942) | |||
| 47424 | 47424 | 207641 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1541 Funston Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5992163.3894 | 2104844.15149 | 37.759050145675104 | -122.470176059699 | (37.7590501456751, -122.470176059699) | |||
| 47562 | 47562 | 59079 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 630 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1980 12:00:00 AM | 4 | Permit Number 18379 | 5993622.03165 | 2110755.91143 | 37.7753664990592 | -122.465560903584 | (37.7753664990592, -122.465560903584) | ||
| 47642 | 47642 | 223589 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 502 Jarboe Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008529.0640199995 | 2096927.2973099998 | 37.738244785178296 | -122.41301583213301 | (37.7382447851783, -122.413015832133) | |||
| 47949 | 47949 | 207615 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 134 Ralston St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5992209.13787 | 2088815.67824 | 37.7150426450832 | -122.46885145275 | (37.7150426450832, -122.46885145275) | |||
| 48042 | 48042 | 88589 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 874 24th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51533 | 5988541.53724 | 2110053.24401 | 37.7731428326728 | -122.48308379276699 | (37.7731428326728, -122.483083792767) | ||
| 48099 | 48099 | 207613 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 171 Caine Ave | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5997069.50028 | 2088848.5087700002 | 37.7154123950516 | -122.45205442099 | (37.7154123950516, -122.45205442099) | |||
| 48140 | 48140 | 207600 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 543 Holloway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5995134.72164 | 2091208.46348 | 37.721781254370896 | -122.458912596054 | (37.7217812543709, -122.458912596054) | |||
| 48277 | 48277 | 207628 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 445 Hugo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5994326.4302199995 | 2106989.87938 | 37.7650665705984 | -122.462850964727 | (37.7650665705984, -122.462850964727) | |||
| 49081 | 49081 | 124479 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 286 Willard St North | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5996254.72028 | 2110859.07081 | 37.7758012412704 | -122.45646133627399 | (37.7758012412704, -122.456461336274) | |||
| 49778 | 49778 | 207584 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 165 Merced Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 5994383.58117 | 2099287.47444 | 37.7439210289412 | -122.462094670844 | (37.7439210289412, -122.462094670844) | |||
| 50611 | 50611 | 223515 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 85 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6005792.03644 | 2102839.8234 | 37.7543252101645 | -122.422899227642 | (37.7543252101645, -122.422899227642) | |||
| 51540 | 51540 | 38100 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1265 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/1998 12:00:00 AM | 4 | Permit Number 40271 | 5987674.53427275 | 2106687.60559412 | 37.76385123223321 | -122.48583575429701 | (37.7638512322332, -122.485835754297) | |
| 52755 | 52755 | 207695 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1222 Plymouth Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5995891.52818 | 2092172.3625 | 37.724471365845105 | -122.456366191771 | (37.7244713658451, -122.456366191771) | |||
| 53316 | 53316 | 207674 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 500 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5993300.45868 | 2105307.6542 | 37.7603884744706 | -122.466277253113 | (37.7603884744706, -122.466277253113) | |||
| 55492 | 55492 | 224071 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 4411 17th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6000023.07731 | 2105733.76605 | 37.7619440614764 | -122.44305750971701 | (37.7619440614764, -122.443057509717) | |||
| 56044 | 56044 | 224051 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3866 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6002622.24205 | 2103582.54742 | 37.7561851862111 | -122.433914254443 | (37.7561851862111, -122.433914254443) | |||
| 57207 | 57207 | 223529 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 4175 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6002046.64832 | 2102339.03335 | 37.752738113593104 | -122.435815881724 | (37.7527381135931, -122.435815881724) | |||
| 57552 | 57552 | 94757 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 491 Bay Shore Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/28/2010 12:00:00 AM | 4 | 3x3 | 6010407.95479 | 2097827.7335900003 | 37.7408224831747 | -122.406582959945 | (37.7408224831747, -122.406582959945) | ||
| 59258 | 59258 | 207593 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 166 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 1ft | 5998975.03938 | 2093802.03245 | 37.7291225947148 | -122.445824099527 | (37.7291225947148, -122.445824099527) | |||
| 59884 | 59884 | 191069 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 396 12th St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6008685.67935 | 2108575.6998799997 | 37.770237460112 | -122.413297838836 | (37.770237460112, -122.413297838836) | |||
| 61189 | 61189 | 191684 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1531 Kirkwood Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6015574.655669999 | 2096443.50916 | 37.7373093922023 | -122.388621684764 | (37.7373093922023, -122.388621684764) | |||
| 62630 | 62630 | 61995 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 3324 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52348 | 6004148.34958 | 2120589.64511 | 37.802968948823704 | -122.429849499548 | (37.8029689488237, -122.429849499548) | |
| 62812 | 62812 | 207673 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 500 Kirkham St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5993279.541619999 | 2105307.7731 | 37.760387594042605 | -122.466349603556 | (37.7603875940426, -122.466349603556) | |||
| 62814 | 62814 | 223511 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3453 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6006534.0585 | 2105513.3698400003 | 37.76170798946679 | -122.42052288872 | (37.7617079894668, -122.42052288872) | |||
| 64113 | 64113 | 38141 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 100 Felton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1998 12:00:00 AM | 4 | Permit Number 40298 | 6010551.388230001 | 2093805.1264900002 | 37.729785283541396 | -122.40580373606001 | (37.7297852835414, -122.40580373606) | |
| 65127 | 65127 | 189243 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 690 Texas St | 4 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6013912.25282 | 2103910.20868 | 37.757719098672 | -122.39489221129999 | (37.757719098672, -122.3948922113) | |||
| 68347 | 68347 | 207640 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1541 Funston Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5992163.90266 | 2104824.9566900004 | 37.758997471471204 | -122.47017288688 | (37.7589974714712, -122.47017288688) | |||
| 68437 | 68437 | 94759 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 491 Bay Shore Blvd | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/28/2010 12:00:00 AM | 4 | 3x3 | 6010436.494630001 | 2097901.6693599997 | 37.7410270915281 | -122.406489488003 | (37.7410270915281, -122.406489488003) | ||
| 68650 | 68650 | 94761 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 491 Bay Shore Blvd | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/28/2010 12:00:00 AM | 4 | 3x3 | 6010473.71758 | 2097978.74448 | 37.741240805519396 | -122.406366213439 | (37.7412408055194, -122.406366213439) | ||
| 71398 | 71398 | 176251 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 25 Ervine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6009692.49199 | 2089304.87658 | 37.717380467816 | -122.408455736945 | (37.717380467816, -122.408455736945) | |||
| 72728 | 72728 | 126522 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3318 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6002338.78522 | 2119619.0030099996 | 37.800201180891 | -122.436042024317 | (37.800201180891, -122.436042024317) | |||
| 74306 | 74306 | 94760 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 491 Bay Shore Blvd | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/28/2010 12:00:00 AM | 4 | 3x3 | 6010454.10107 | 2097938.95969 | 37.7411304676923 | -122.406431238013 | (37.7411304676923, -122.406431238013) | ||
| 74664 | 74664 | 84433 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 778 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/04/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51565 | 5992910.95397 | 2110169.95653 | 37.7737165860391 | -122.467978035553 | (37.7737165860391, -122.467978035553) | |
| 74875 | 74875 | 189272 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1789 Oakdale Ave | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6014048.88892 | 2096189.76773 | 37.7365279946626 | -122.393879249144 | (37.7365279946626, -122.393879249144) | |||
| 75477 | 75477 | 37660 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 486 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/2003 12:00:00 AM | 4 | Permit Number 47116 | 5991908.79894 | 2112136.43002 | 37.7790580641946 | -122.47158794068501 | (37.7790580641946, -122.471587940685) | |
| 76545 | 76545 | 38861 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1550 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | 4 | Permit Number 40688 | 5989338.7682 | 2104794.6769999997 | 37.75875059888261 | -122.479941205975 | (37.7587505988826, -122.479941205975) | |
| 81346 | 81346 | 96928 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 300X Bosworth St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | Permit Number 18811 | 6003740.2 | 2095277.6 | 37.73344510199421 | -122.42945574048201 | (37.7334451019942, -122.429455740482) | ||
| 93988 | 93988 | 59448 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 300X Bosworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1980 12:00:00 AM | 4 | 3x3 | Permit Number 18811 | 6003739.62591886 | 2095283.52491985 | 37.7334613379814 | -122.429458147626 | (37.7334613379814, -122.429458147626) | |
| 105033 | 105033 | 142041 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 110 STANYAN BLVD | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5996542.5421 | 2112281.8153 | 37.7797242433743 | -122.45556855111099 | (37.7797242433743, -122.455568551111) | |||
| 115795 | 115795 | 96927 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 300X Bosworth St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | Permit Number 18811 | 6003740.2 | 2095277.6 | 37.73344510199421 | -122.42945574048201 | (37.7334451019942, -122.429455740482) | ||
| 117739 | 117739 | 96926 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 300X Bosworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | Permit Number 18811 | 6003740.2 | 2095277.6 | 37.73344510199421 | -122.42945574048201 | (37.7334451019942, -122.429455740482) | ||
| 117751 | 117751 | 90541 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 550X Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/14/2008 12:00:00 AM | 4 | 3x3 | 5993951.099186 | 2110760.95535 | 37.7753993224191 | -122.46442295748301 | (37.7753993224191, -122.464422957483) | ||
| 118904 | 118904 | 26139 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1500 Oakdale Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 11/05/2005 12:00:00 AM | 4 | 3x3 | 6015586.393477299 | 2095100.209325 | 37.7336216133372 | -122.388487366626 | (37.7336216133372, -122.388487366626) | ||
| 123635 | 123635 | 90542 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 632 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/14/2008 12:00:00 AM | 4 | 3x3 | 5993688.832385 | 2110751.462082 | 37.7753581349738 | -122.46532950285601 | (37.7753581349738, -122.465329502856) | ||
| 124331 | 124331 | 96929 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 300X Bosworth St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | Permit Number 18811 | 6003740.2 | 2095277.6 | 37.73344510199421 | -122.42945574048201 | (37.7334451019942, -122.429455740482) | ||
| 129732 | 129732 | 223399 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3438 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6005409.07211 | 2103737.92814 | 37.7567695800561 | -122.42428748857701 | (37.7567695800561, -122.424287488577) | |||
| 129837 | 129837 | 94755 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 491 Bay Shore Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/28/2010 12:00:00 AM | 4 | 3x3 | 6010386.24454 | 2097752.48777 | 37.740614659735705 | -122.40665272486 | (37.7406146597357, -122.40665272486) | ||
| 131434 | 131434 | 126509 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2259 Bay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5999989.15096 | 2120195.3405400002 | 37.801649885296 | -122.44421408640699 | (37.801649885296, -122.444214086407) | |||
| 132043 | 132043 | 191105 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2031 26th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6012471.08809 | 2101442.49761 | 37.7508630621826 | -122.39970311841002 | (37.7508630621826, -122.39970311841) | |||
| 134245 | 134245 | 191677 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 110 12th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6007442.31511 | 2109225.32703 | 37.7719512972482 | -122.417644690367 | (37.7719512972482, -122.417644690367) | |||
| 134299 | 134299 | 191672 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 252 12th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6007932.203869999 | 2108945.7392700003 | 37.7712111695782 | -122.41593032173701 | (37.7712111695782, -122.415930321737) | |||
| 138017 | 138017 | 207604 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 146 Brighton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5996244.761969999 | 2090857.98578 | 37.7208826706709 | -122.45505018501999 | (37.7208826706709, -122.45505018502) | |||
| 147140 | 147140 | 94758 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 491 Bay Shore Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/28/2010 12:00:00 AM | 4 | 3x3 | 6010421.02997 | 2097863.75043 | 37.740922109156706 | -122.40654028802601 | (37.7409221091567, -122.406540288026) | ||
| 147410 | 147410 | 94756 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 491 Bay Shore Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/28/2010 12:00:00 AM | 4 | 3x3 | 6010397.45691 | 2097793.22458 | 37.7407271415462 | -122.406616826609 | (37.7407271415462, -122.406616826609) | ||
| 148113 | 148113 | 224102 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 46 Gough St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6006317.414609999 | 2109580.74517 | 37.772863826729996 | -122.421561058002 | (37.77286382673, -122.421561058002) | |||
| 149946 | 149946 | 207644 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1541 Funston Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5992160.10563 | 2104906.0361 | 37.7592198747043 | -122.470191922822 | (37.7592198747043, -122.470191922822) | |||
| 151283 | 151283 | 94750 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 491 Bay Shore Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/28/2010 12:00:00 AM | 4 | 3x3 | 6010344.23931 | 2097413.7217900003 | 37.7396821311114 | -122.406774094665 | (37.7396821311114, -122.406774094665) | ||
| 151475 | 151475 | 37991 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 650 Texas St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/1998 12:00:00 AM | 4 | Permit Number 40210 | 6013832.0389 | 2104017.01631 | 37.7580079087535 | -122.39517710753599 | (37.7580079087535, -122.395177107536) | ||
| 151638 | 151638 | 126555 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1005 Sansome St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6011987.15474 | 2119346.92061 | 37.7999975123406 | -122.402635563904 | (37.7999975123406, -122.402635563904) | |||
| 152189 | 152189 | 123740 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 301 Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 5994649.40915 | 2110738.31442 | 37.775377384738704 | -122.462005714867 | (37.7753773847387, -122.462005714867) | |||
| 152205 | 152205 | 32500 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 738 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/15/1996 12:00:00 AM | 4 | Permit Number 37005 | 6007353.28943 | 2095467.09661 | 37.7341693220512 | -122.416977659594 | (37.7341693220512, -122.416977659594) | |
| 152957 | 152957 | 207691 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 10 Madrone Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5992956.08252 | 2099027.95475 | 37.7431261613357 | -122.46701172671999 | (37.7431261613357, -122.46701172672) | |||
| 153342 | 153342 | 97660 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1911 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/11/2011 12:00:00 AM | 4 | 5x6 | Permit Number 768287 | 5999917.523519999 | 2115611.58092 | 37.7890600079585 | -122.44413238841801 | (37.7890600079585, -122.444132388418) | |
| 155483 | 155483 | 38858 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1539 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | 4 | Permit Number 40685 | 5989290.38339079 | 2104868.56062873 | 37.758950652235605 | -122.48011394820101 | (37.7589506522356, -122.480113948201) | |
| 155884 | 155884 | 87147 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 555 Natoma St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/18/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50132 | 6010000.21916 | 2111782.15708 | 37.7791153596345 | -122.408977105416 | (37.7791153596345, -122.408977105416) | |
| 157731 | 157731 | 223429 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 357 Precita Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008933.85702 | 2100227.2341400003 | 37.747328401883294 | -122.411849371861 | (37.7473284018833, -122.411849371861) | |||
| 158156 | 158156 | 38859 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1543 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | 4 | Permit Number 40686 | 5989291.28049712 | 2104842.48405606 | 37.7588791051043 | -122.480108937189 | (37.7588791051043, -122.480108937189) |
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");