Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantType, qCaretaker, qCareAssistant, DBH
| Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18802 | 18802 | 509 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2753 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6008975.21686 | 2102392.50435 | 37.7532760709475 | -122.411859333666 | (37.7532760709475, -122.411859333666) | |||
| 102752 | 102752 | 1674 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 210 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/2005 12:00:00 AM | 3 | 3X3 | 5994926.2487 | 2111484.88343 | 37.777443199474604 | -122.46110219473499 | (37.7774431994746, -122.461102194735) | ||
| 109483 | 109483 | 1769 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 2000X Bay Shore Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/11/2011 12:00:00 AM | 3 | 3x3 | 6012375.8565272 | 2088505.2474916999 | 37.7153347551878 | -122.399124435859 | (37.7153347551878, -122.399124435859) | ||
| 94821 | 94821 | 2766 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 238 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/17/2016 07:20:00 AM | 3 | 3X3 | 5994832.64296 | 2110801.15039 | 37.775560463187 | -122.46137642704599 | (37.775560463187, -122.461376427046) | ||
| 91177 | 91177 | 2768 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 238 Cabrillo St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2005 12:00:00 AM | 7 | 3X3 | 5994792.462780001 | 2110798.98024 | 37.7755521919136 | -122.461515261652 | (37.7755521919136, -122.461515261652) | ||
| 96985 | 96985 | 2779 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 410 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/17/2016 07:24:00 AM | 3 | 3X3 | 5994373.0105 | 2110784.17458 | 37.775487387663105 | -122.46296516318199 | (37.7754873876631, -122.462965163182) | ||
| 102193 | 102193 | 2781 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 410 Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/05/2015 07:16:00 AM | 3 | 3X3 | 5994323.8414 | 2110783.9733599997 | 37.775484002866996 | -122.463135234951 | (37.775484002867, -122.463135234951) | ||
| 144025 | 144025 | 2782 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 410 Cabrillo St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/22/2011 12:00:00 AM | 3 | 3x3 | 5994308.6202300005 | 2110783.41218 | 37.7754815851777 | -122.463187847484 | (37.7754815851777, -122.463187847484) | ||
| 1100 | 1100 | 2952 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 2001 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6004785.43 | 2115651.1441 | 37.789445140420604 | -122.427292872615 | (37.7894451404206, -122.427292872615) | |||
| 142650 | 142650 | 4333 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 5X Chilton Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001761.4698131 | 2095822.8308426999 | 37.7348299498779 | -122.43633576569799 | (37.7348299498779, -122.436335765698) | |||
| 121032 | 121032 | 4390 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 56 Chilton Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001657.8215553 | 2095631.9001159 | 37.7342998083721 | -122.436680450501 | (37.7342998083721, -122.436680450501) | |||
| 19983 | 19983 | 4397 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1011 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004431.54351 | 2102978.61798 | 37.7546294472032 | -122.427614046667 | (37.7546294472032, -122.427614046667) | |||
| 13238 | 13238 | 4475 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1521 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1992 12:00:00 AM | 6 | 3X3 | 6004596.9832 | 2100011.9105700003 | 37.7464929146108 | -122.426830644527 | (37.7464929146108, -122.426830644527) | ||
| 17112 | 17112 | 5086 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2575 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/2011 12:00:00 AM | 3 | 3x3 | 6002278.04095 | 2096864.42797 | 37.737719273515 | -122.4346242575 | (37.737719273515, -122.4346242575) | ||
| 186164 | 186164 | 5105 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 2638 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/10/2002 12:00:00 AM | 3 | 3X3 | 6002275.8937 | 2096498.7145900002 | 37.7367149871144 | -122.43460553902399 | (37.7367149871144, -122.434605539024) | ||
| 9174 | 9174 | 6373 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2101 Ellis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6000795.1374 | 2112740.1737 | 37.7812258903975 | -122.440889897719 | (37.7812258903975, -122.440889897719) | |||
| 14726 | 14726 | 6733 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1300X Fairfax Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3x3 | 6017061.2899 | 2097158.62505 | 37.7393552338433 | -122.383531422133 | (37.7393552338433, -122.383531422133) | |||
| 14736 | 14736 | 6734 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1300X Fairfax Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6017044.07799 | 2097171.2102099997 | 37.739388838832504 | -122.383591809817 | (37.7393888388325, -122.383591809817) | |||
| 13664 | 13664 | 6735 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1300X Fairfax Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/14/2007 12:00:00 AM | 2 | 3x3 | 6017028.4506 | 2097182.15302 | 37.7394180218109 | -122.383646604615 | (37.7394180218109, -122.383646604615) | ||
| 90346 | 90346 | 6736 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1300X Fairfax Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/30/2011 12:00:00 AM | 2 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | ||
| 91184 | 91184 | 6737 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1300X Fairfax Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/30/2012 12:00:00 AM | 1 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | ||
| 102788 | 102788 | 6738 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1300X Fairfax Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/19/2016 12:00:00 AM | 1 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | ||
| 126413 | 126413 | 7136 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 336X Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2005 12:00:00 AM | 6 | 3X3 | 5994611.623430001 | 2110790.08992 | 37.775517371009 | -122.46214017921899 | (37.775517371009, -122.462140179219) | ||
| 120390 | 120390 | 7141 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 399X Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3X3 | 5994485.13476 | 2110733.5683 | 37.775354894082206 | -122.46257362979601 | (37.7753548940822, -122.462573629796) | |||
| 107665 | 107665 | 7678 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 299X Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/08/2008 12:00:00 AM | 6 | 3x3 | 5994845.54256 | 2110743.0394599997 | 37.7754016484038 | -122.461327591026 | (37.7754016484038, -122.461327591026) | ||
| 9137 | 9137 | 7679 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 299X Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/2008 12:00:00 AM | 18 | 3x3 | 5994818.31491 | 2110743.00765 | 37.7753999939995 | -122.461421774878 | (37.7753999939995, -122.461421774878) | ||
| 90555 | 90555 | 7680 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 299X Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/08/2008 12:00:00 AM | 6 | 3x3 | 5994929.5013 | 2110751.87573 | 37.7754307421541 | -122.46103780069299 | (37.7754307421541, -122.461037800693) | ||
| 77491 | 77491 | 7681 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 315X Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/22/2011 12:00:00 AM | 3 | 3x3 | 5994678.74309 | 2110742.5512099997 | 37.7753907066265 | -122.46190454994301 | (37.7753907066265, -122.461904549943) | ||
| 84462 | 84462 | 7682 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 315X Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/22/2011 12:00:00 AM | 3 | 3x3 | 5994678.74309 | 2110742.5512099997 | 37.7753907066265 | -122.46190454994301 | (37.7753907066265, -122.461904549943) | ||
| 90454 | 90454 | 10192 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1169 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/16/2016 04:46:00 AM | 3 | 3X3 | 6005808.6696938 | 2102164.8077902 | 37.7524727119111 | -122.42279373679199 | (37.7524727119111, -122.422793736792) | ||
| 21586 | 21586 | 10198 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1209 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1991 12:00:00 AM | 3 | 2X2 | 6005820.58037 | 2101870.80495 | 37.7516661199201 | -122.422731656039 | (37.7516661199201, -122.422731656039) | ||
| 21151 | 21151 | 10207 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1273 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 2X2 | 6005836.971940001 | 2101563.9580099997 | 37.7508245136462 | -122.422653168634 | (37.7508245136462, -122.422653168634) | |||
| 19063 | 19063 | 11922 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 620X Keith St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/10/2016 12:00:00 AM | 3 | 3X4 | 6017350.6902257 | 2096387.6229349 | 37.737254207453105 | -122.382477163454 | (37.7372542074531, -122.382477163454) | ||
| 20683 | 20683 | 12972 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 84 Lippard Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001913.39953 | 2095585.0292900002 | 37.734185633051894 | -122.435793484091 | (37.7341856330519, -122.435793484091) | |||
| 8142 | 8142 | 14641 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 600X McAllister St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/01/1998 12:00:00 AM | 8 | 4x4 | 6006147.64251 | 2112148.2738 | 37.77990406506721 | -122.422330778736 | (37.7799040650672, -122.422330778736) | ||
| 119528 | 119528 | 14731 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 912X Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/1997 12:00:00 AM | 6 | 6004848.1679 | 2112085.98552 | 37.7796596496687 | -122.426821804086 | (37.7796596496687, -122.426821804086) | |||
| 85947 | 85947 | 14750 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 940 McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/23/2000 12:00:00 AM | 3 | 4X4 | 6004580.51193 | 2112075.36147 | 37.7796153416711 | -122.427746985107 | (37.7796153416711, -122.427746985107) | ||
| 15766 | 15766 | 15015 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 650 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/14/2014 12:00:00 AM | 6 | 3x3 | 6016271.14274 | 2097128.2420599998 | 37.7392281047953 | -122.38626130881501 | (37.7392281047953, -122.386261308815) | ||
| 14072 | 14072 | 15048 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1119 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/20/2000 12:00:00 AM | 6 | 3X3 | 6015497.5853 | 2096021.456 | 37.7361462484719 | -122.38885869852601 | (37.7361462484719, -122.388858698526) | ||
| 16889 | 16889 | 15051 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1137 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/20/2000 12:00:00 AM | 3 | 8X18 | 6015459.2819 | 2095972.4779 | 37.736009641441 | -122.388987711638 | (37.736009641441, -122.388987711638) | ||
| 15058 | 15058 | 15055 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1224 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 3 | 3x3 | 6015288.0468 | 2095812.3346 | 37.735560427325204 | -122.389568564294 | (37.7355604273252, -122.389568564294) | ||
| 10434 | 10434 | 15775 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 4808 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/05/1997 12:00:00 AM | 10 | 3X3 | Permit Number 773279 | 6001261.3736 | 2090797.0594 | 37.7210019026793 | -122.437704946106 | (37.7210019026793, -122.437704946106) | |
| 10622 | 10622 | 15860 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 5366 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5999545.5765 | 2088270.5652 | 37.7139670145471 | -122.44345454060199 | (37.7139670145471, -122.443454540602) | |||
| 80548 | 80548 | 17169 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1221X Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/10/2007 12:00:00 AM | 3 | 3x3 | 6017071.13101 | 2093953.96501 | 37.7305564196556 | -122.38327438715599 | (37.7305564196556, -122.383274387156) | ||
| 116800 | 116800 | 17171 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1221X Oakdale Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/10/2007 12:00:00 AM | 3 | 3x3 | 6017100.78201 | 2093930.01601 | 37.730492298981794 | -122.383170211952 | (37.7304922989818, -122.383170211952) | ||
| 22381 | 22381 | 17744 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1600X Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6006169.663819999 | 2115620.29477 | 37.789438622529204 | -122.42250137744101 | (37.7894386225292, -122.422501377441) | |||
| 6880 | 6880 | 18913 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 2612 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002139.88643 | 2115759.87525 | 37.789593716919704 | -122.43645393002599 | (37.7895937169197, -122.436453930026) | |||
| 115797 | 115797 | 19295 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 100X Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/2008 12:00:00 AM | 6 | 3X3 | 5995238.34395 | 2110816.5488299998 | 37.7756260846481 | -122.45997413441401 | (37.7756260846481, -122.459974134414) | ||
| 101589 | 101589 | 21338 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 2592X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5985018.1742183 | 2097562.094386 | 37.7386399329486 | -122.494350460592 | (37.7386399329486, -122.494350460592) | |||
| 114416 | 114416 | 21341 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 2592X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5985018.1742183 | 2097562.094386 | 37.7386399329486 | -122.494350460592 | (37.7386399329486, -122.494350460592) | |||
| 139395 | 139395 | 21343 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 2592X Sunset Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5985018.1742183 | 2097562.094386 | 37.7386399329486 | -122.494350460592 | (37.7386399329486, -122.494350460592) | |||
| 20586 | 20586 | 22918 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 333 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6006138.942840001 | 2107682.09275 | 37.7676405157139 | -122.422043508318 | (37.7676405157139, -122.422043508318) | |||
| 120592 | 120592 | 22919 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 333 Valencia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6006146.38467 | 2107662.66758 | 37.7675875985285 | -122.422016387826 | (37.7675875985285, -122.422016387826) | |||
| 115770 | 115770 | 22920 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 333 Valencia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6006146.186319999 | 2107684.7475900003 | 37.767648213804996 | -122.42201864261699 | (37.767648213805, -122.422018642617) | |||
| 106062 | 106062 | 22921 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 333 Valencia St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/1999 12:00:00 AM | 16 | 3X3 | 6006144.43338 | 2107707.65753 | 37.767711020193204 | -122.42202633352 | (37.7677110201932, -122.42202633352) | ||
| 125830 | 125830 | 22922 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 333 Valencia St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3x3 | 6006142.65939 | 2107729.77965 | 37.7677716622264 | -122.42203404127301 | (37.7677716622264, -122.422034041273) | |||
| 15442 | 15442 | 25547 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 141 Industrial St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2014 12:00:00 AM | 3 | 2x3 | 6011520.04511 | 2097161.49572 | 37.7390552910796 | -122.402690904578 | (37.7390552910796, -122.402690904578) | ||
| 14022 | 14022 | 25548 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 141 Industrial St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/06/2013 12:00:00 AM | 3 | 2x3 | 6011568.628409999 | 2097178.44526 | 37.7391045433316 | -122.402524116297 | (37.7391045433316, -122.402524116297) | ||
| 31976 | 31976 | 25549 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 141 Industrial St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/11/2005 12:00:00 AM | 3 | 2X3 | 6011617.33955 | 2097194.1765099997 | 37.739150457318004 | -122.402356800142 | (37.739150457318, -122.402356800142) | ||
| 13618 | 13618 | 25915 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1800 Oakdale Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/16/2015 12:17:00 PM | 3 | 3X3 | 6013847.663980001 | 2096411.7192 | 37.737126242566 | -122.394590512161 | (37.737126242566, -122.394590512161) | ||
| 93189 | 93189 | 25919 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1894X Oakdale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/10/2007 12:00:00 AM | 3 | 3X3 | 6013501.35934 | 2096660.10843 | 37.7377890089073 | -122.395805252575 | (37.7377890089073, -122.395805252575) | ||
| 16874 | 16874 | 25949 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2100 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/10/2007 12:00:00 AM | 3 | 3X3 | 6012331.41548 | 2097539.0273700003 | 37.7401371808736 | -122.399912042617 | (37.7401371808736, -122.399912042617) | ||
| 139056 | 139056 | 25956 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2695X Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 3 | 2x3 | 6011407.61362 | 2098218.7686799997 | 37.741952058974796 | -122.40315399409201 | (37.7419520589748, -122.403153994092) | ||
| 13937 | 13937 | 25993 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1789 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/25/2012 12:00:00 AM | 3 | 3x3 | 6014037.236380001 | 2096196.21513 | 37.736545050306795 | -122.39391998842699 | (37.7365450503068, -122.393919988427) | ||
| 14085 | 14085 | 25999 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1717 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/1997 12:00:00 AM | 3 | 3x3 | 6014332.85691 | 2095971.76656 | 37.7359451854222 | -122.392882195975 | (37.7359451854222, -122.392882195975) | ||
| 13423 | 13423 | 26000 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1715 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/25/2012 12:00:00 AM | 3 | 3x3 | 6014353.43695 | 2095957.87317 | 37.7359081801195 | -122.39281007033999 | (37.7359081801195, -122.39281007034) | ||
| 14918 | 14918 | 26006 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1669 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2000 12:00:00 AM | 3 | 3X3 | 6014649.3702300005 | 2095737.8438 | 37.735320456978705 | -122.391771523335 | (37.7353204569787, -122.391771523335) | ||
| 91673 | 91673 | 26011 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1618X Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Arts Commission 19 | 01/02/1998 12:00:00 AM | 6 | 3X3 | 6014975.06835 | 2095558.9055400002 | 37.7348472038217 | -122.390632955135 | (37.7348472038217, -122.390632955135) | ||
| 14536 | 14536 | 26016 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1690 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/02/2000 12:00:00 AM | 3 | 3X3 | 6014602.53952 | 2095841.2099400002 | 37.735601679469 | -122.39194066153699 | (37.735601679469, -122.391940661537) | ||
| 23103 | 23103 | 26097 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1583X Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/08/2003 12:00:00 AM | 6 | 3x3 | 6015137.4531 | 2095367.1486 | 37.7343296857828 | -122.390058138496 | (37.7343296857828, -122.390058138496) | ||
| 92537 | 92537 | 26099 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1583 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/2000 12:00:00 AM | 6 | 3x3 | 6015122.555480001 | 2095354.2938599999 | 37.7342935630106 | -122.39010874709 | (37.7342935630106, -122.39010874709) | ||
| 16121 | 16121 | 26100 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1577 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6015169.8802 | 2095341.3169 | 37.7342605555935 | -122.38994422273198 | (37.7342605555935, -122.389944222732) | |||
| 109846 | 109846 | 26101 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1567 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/30/2015 08:01:00 AM | 3 | 3x3 | 6015220.652553501 | 2095312.3188681 | 37.7341837485135 | -122.389766660198 | (37.7341837485135, -122.389766660198) | ||
| 16567 | 16567 | 26102 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1563 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6015232.536 | 2095297.3479 | 37.73414330023979 | -122.389724529704 | (37.7341433002398, -122.389724529704) | |||
| 14462 | 14462 | 26105 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1547 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/16/2009 12:00:00 AM | 3 | 3x3 | 6015325.4204 | 2095230.2952 | 37.733964337308 | -122.38939871537501 | (37.733964337308, -122.389398715375) | ||
| 15994 | 15994 | 26106 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1539X Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2000 12:00:00 AM | 12 | 3x3 | 6015355.6491 | 2095208.8603 | 37.733907157322605 | -122.389292708309 | (37.7339071573226, -122.389292708309) | ||
| 14921 | 14921 | 26108 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1509 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/08/2003 12:00:00 AM | 3 | 3x3 | 6015422.1522 | 2095159.3952 | 37.733775022834394 | -122.38905933236099 | (37.7337750228344, -122.389059332361) | ||
| 15177 | 15177 | 26109 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1509 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/09/2010 12:00:00 AM | 3 | 3x3 | 6015436.4421 | 2095148.4030000002 | 37.7337456325918 | -122.389009160289 | (37.7337456325918, -122.389009160289) | ||
| 122459 | 122459 | 26112 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1509 Oakdale Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/08/2003 12:00:00 AM | 3 | 3x3 | 6015459.73624 | 2095054.56513 | 37.7334892639404 | -122.388922075695 | (37.7334892639404, -122.388922075695) | ||
| 16065 | 16065 | 26114 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1505 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/1997 12:00:00 AM | 6 | 3x3 | 6015470.5181 | 2095128.0673 | 37.7336916836833 | -122.38888992918699 | (37.7336916836833, -122.388889929187) | ||
| 13781 | 13781 | 26117 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1487 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/2003 12:00:00 AM | 3 | 3X3 | 6015648.6011 | 2094991.9741 | 37.733327868310205 | -122.38826474357 | (37.7333278683102, -122.38826474357) | ||
| 139816 | 139816 | 26119 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1475 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/08/2003 12:00:00 AM | 3 | 3X3 | 6015692.20395 | 2094932.7691099998 | 37.73316771923471 | -122.388109864863 | (37.7331677192347, -122.388109864863) | ||
| 14680 | 14680 | 26127 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1419 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6015993.0176 | 2094731.6994 | 37.7326322840804 | -122.38705584245199 | (37.7326322840804, -122.387055842452) | |||
| 14081 | 14081 | 26128 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1415 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/09/2010 12:00:00 AM | 3 | 3X3 | 6016013.7391 | 2094719.7689 | 37.7326006727272 | -122.386983370719 | (37.7326006727272, -122.386983370719) | ||
| 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) | ||
| 102647 | 102647 | 26141 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1500 Oakdale Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 03/21/2006 12:00:00 AM | 3 | 3x3 | 6015586.393477299 | 2095100.209325 | 37.7336216133372 | -122.388487366626 | (37.7336216133372, -122.388487366626) | ||
| 89501 | 89501 | 26142 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1500 Oakdale Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 03/21/2006 12:00:00 AM | 3 | 3x3 | 6015586.393477299 | 2095100.209325 | 37.7336216133372 | -122.388487366626 | (37.7336216133372, -122.388487366626) | ||
| 80275 | 80275 | 26143 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1500 Oakdale Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 02/08/2003 12:00:00 AM | 3 | 3x3 | 6015586.393477299 | 2095100.209325 | 37.7336216133372 | -122.388487366626 | (37.7336216133372, -122.388487366626) | ||
| 119515 | 119515 | 26418 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1438 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/1997 12:00:00 AM | 3 | 3 | 6015934.46626 | 2094872.09535 | 37.733014540811 | -122.38726806039699 | (37.733014540811, -122.387268060397) | ||
| 13874 | 13874 | 26433 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1679 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2000 12:00:00 AM | 3 | 3X3 | 6014598.595480001 | 2095777.3145 | 37.7354260166954 | -122.39194983104099 | (37.7354260166954, -122.391949831041) | ||
| 127021 | 127021 | 26468 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 300X Keith St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/04/1998 12:00:00 AM | 3 | 3X3 | 6017600.4401851 | 2096710.4383408 | 37.7381543871139 | -122.381636098386 | (37.7381543871139, -122.381636098386) | ||
| 16117 | 16117 | 26556 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 228 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/09/1998 12:00:00 AM | 12 | 3x3 | 6011088.04001 | 2099355.12223 | 37.7450543887552 | -122.404338947303 | (37.7450543887552, -122.404338947303) | ||
| 81064 | 81064 | 26562 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 550 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/14/1999 12:00:00 AM | 6 | 3X3 | 6010221.3990327995 | 2097223.1768194 | 37.7391520616783 | -122.407185397649 | (37.7391520616783, -122.407185397649) | ||
| 14582 | 14582 | 26572 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 353 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/22/1998 12:00:00 AM | 6 | 3X3 | 6010658.7205300005 | 2098280.84549 | 37.742080657198294 | -122.405747809912 | (37.7420806571983, -122.405747809912) | ||
| 101576 | 101576 | 26574 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 355 Bay Shore Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/18/2006 12:00:00 AM | 3 | 3X3 | 6010658.7520522 | 2098287.1955653 | 37.742098094898 | -122.40574814809999 | (37.742098094898, -122.4057481481) | ||
| 91594 | 91594 | 26576 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 345 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/05/2006 12:00:00 AM | 6 | 3X3 | 6010697.3878905 | 2098349.5702175 | 37.7422715227695 | -122.40561894910101 | (37.7422715227695, -122.405618949101) | ||
| 14884 | 14884 | 26578 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 241 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/22/1998 12:00:00 AM | 6 | 3X3 | 6011090.3987 | 2099026.28851 | 37.7441516142074 | -122.404307650877 | (37.7441516142074, -122.404307650877) | ||
| 13743 | 13743 | 26579 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 241 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/22/1998 12:00:00 AM | 6 | 3X3 | 6011098.44545 | 2099048.11598 | 37.7442119973787 | -122.40428136282 | (37.7442119973787, -122.40428136282) | ||
| 14864 | 14864 | 26580 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 235 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/22/1998 12:00:00 AM | 3 | 3X3 | 6011115.925530001 | 2099106.52375 | 37.7443733492673 | -122.404225030173 | (37.7443733492673, -122.404225030173) | ||
| 14391 | 14391 | 26581 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 235 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6011124.08251 | 2099133.7568 | 37.7444485811329 | -122.404198741189 | (37.7444485811329, -122.404198741189) |
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");