Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14340 | 14340 | 85536 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 110 12th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2007 12:00:00 AM | 6 | 6007398.398469999 | 2109252.27561 | 37.7720228203246 | -122.41779851218901 | (37.7720228203246, -122.417798512189) | |||
| 15800 | 15800 | 85533 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 110 12th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2007 12:00:00 AM | 6 | 6007332.25294 | 2109288.61069 | 37.7721188652314 | -122.418029891562 | (37.7721188652314, -122.418029891562) | |||
| 58248 | 58248 | 85535 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 110 12th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/29/2007 12:00:00 AM | 5 | 6007364.04136 | 2109271.5858400003 | 37.7720739081089 | -122.41791872548 | (37.7720739081089, -122.41791872548) | |||
| 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) | |||
| 169302 | 169302 | 224081 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 110 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6002846.5301 | 2108989.93169 | 37.771045277952794 | -122.433525010771 | (37.7710452779528, -122.433525010771) | |||
| 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) | |||
| 167336 | 167336 | 142040 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 110 STANYAN BLVD | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5996550.3383 | 2112261.0255 | 37.779667607438604 | -122.455540077752 | (37.7796676074386, -122.455540077752) | |||
| 159759 | 159759 | 124354 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1100 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5992180.38847 | 2111384.61555 | 37.7770094950384 | -122.470593638633 | (37.7770094950384, -122.470593638633) | |||
| 95141 | 95141 | 94172 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1101 Carolina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2010 12:00:00 AM | 3x3 | Permit Number 53593 | 6012553.0 | 2102835.0 | 37.754691137470495 | -122.399517610991 | (37.7546911374705, -122.399517610991) | ||
| 97742 | 97742 | 94173 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1101 Carolina St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2010 12:00:00 AM | 3x3 | Permit Number 53593 | 6012553.0 | 2102835.0 | 37.754691137470495 | -122.399517610991 | (37.7546911374705, -122.399517610991) | ||
| 122727 | 122727 | 94174 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1101 Carolina St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2010 12:00:00 AM | 3x3 | Permit Number 53593 | 6012553.0 | 2102835.0 | 37.754691137470495 | -122.399517610991 | (37.7546911374705, -122.399517610991) | ||
| 57297 | 57297 | 176254 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1101 Girard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6011871.08574 | 2089770.5771299999 | 37.718780952366096 | -122.400958007209 | (37.7187809523661, -122.400958007209) | |||
| 93213 | 93213 | 126532 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1101 Powell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6009864.00363 | 2117536.67962 | 37.7949082686427 | -122.409854651267 | (37.7949082686427, -122.409854651267) | |||
| 150196 | 150196 | 64563 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1101 Powell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/1988 12:00:00 AM | 12 | Permit Number 25455 | 6009863.09945 | 2117549.8357 | 37.794944341360605 | -122.409858709005 | (37.7949443413606, -122.409858709005) | |
| 73786 | 73786 | 94516 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1106X Wisconsin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 08/27/2010 12:00:00 AM | 2 | Permit Number 53703 | 6012787.7377 | 2102360.9473599996 | 37.753402573178896 | -122.39867255379299 | (37.7534025731789, -122.398672553793) | ||
| 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) | |||
| 83628 | 83628 | 90164 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1108 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2008 12:00:00 AM | 3 | 3x3 | 5992192.4340470005 | 2111377.6526 | 37.776991073192 | -122.470551462384 | (37.776991073192, -122.470551462384) | ||
| 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) | ||
| 173885 | 173885 | 81459 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1119 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2007 12:00:00 AM | 1 | 3x3 | Permit Number 49734 | 5989696.8991 | 2098996.9987 | 37.7428525058761 | -122.47827872443001 | (37.7428525058761, -122.47827872443) | |
| 3126 | 3126 | 170290 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 112 Judson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/2017 12:00:00 AM | 3 | Width 3ft | 5999300.3013 | 2093511.3105799998 | 37.7283429067858 | -122.44467875893999 | (37.7283429067858, -122.44467875894) | ||
| 109163 | 109163 | 90165 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1120 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/2008 12:00:00 AM | 3 | 3x3 | 5992092.63811 | 2111382.24215 | 37.776997903811605 | -122.47089701854601 | (37.7769979038116, -122.470897018546) | ||
| 15680 | 15680 | 26834 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1129 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/2008 12:00:00 AM | 3 | 3X3 | 6015470.5845 | 2095986.9202 | 37.7360499235694 | -122.388949641676 | (37.7360499235694, -122.388949641676) | ||
| 87139 | 87139 | 26833 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1133 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/2008 12:00:00 AM | 0 | 3X3 | 6015479.92911 | 2095965.0534700002 | 37.7359903999296 | -122.388915807139 | (37.7359903999296, -122.388915807139) | ||
| 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) | ||
| 29878 | 29878 | 223592 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1142 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009191.70637 | 2102498.92995 | 37.7535804348003 | -122.411118182576 | (37.7535804348003, -122.411118182576) | |||
| 108316 | 108316 | 62958 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1142 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/21/1986 12:00:00 AM | Permit Number 23344 | 6008125.85575238 | 2118255.57771401 | 37.7967846215561 | -122.415919842071 | (37.7967846215561, -122.415919842071) | ||
| 24989 | 24989 | 223551 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1143 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 5997699.39696 | 2106553.80105 | 37.764062907387704 | -122.45115331019 | (37.7640629073877, -122.45115331019) | |||
| 28935 | 28935 | 223424 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 115 Peralta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6010291.05729 | 2100231.54093 | 37.7474162746512 | -122.407156552038 | (37.7474162746512, -122.407156552038) | |||
| 179279 | 179279 | 248256 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 116 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6006785.81091 | 2098870.27842 | 37.743481764973005 | -122.419180937446 | (37.743481764973, -122.419180937446) | |||
| 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) | ||
| 61283 | 61283 | 62959 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1175 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/21/1986 12:00:00 AM | 14 | Permit Number 23345 | 6008001.56121 | 2118185.8038 | 37.796586051068296 | -122.416344986535 | (37.7965860510683, -122.416344986535) | |
| 143139 | 143139 | 65262 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1175 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1989 12:00:00 AM | Permit Number 28063 | 6009506.97444582 | 2102339.79830216 | 37.753161169992794 | -122.410016678829 | (37.7531611699928, -122.410016678829) | ||
| 130480 | 130480 | 224045 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 118 Caselli Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6000330.71148 | 2104908.09647 | 37.7596945117222 | -122.44193426187799 | (37.7596945117222, -122.441934261878) | |||
| 33740 | 33740 | 223519 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 118 Milton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6003743.87449 | 2095119.74297 | 37.7330118702979 | -122.429431783351 | (37.7330118702979, -122.429431783351) | |||
| 93764 | 93764 | 33048 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1192 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | Permit Number 37324 | 6005740.26598795 | 2102030.16267757 | 37.752099147776704 | -122.423020719371 | (37.7520991477767, -122.423020719371) | ||
| 3901 | 3901 | 253246 | Planning Code 138.1 required 4 | Eriobotrya deflexa :: Bronze Loquat 49 | 1192 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/2017 12:00:00 AM | 3 | 4x4 | Permit Number 780462 | 6001173.0 | 2087586.0 | 37.7121800264355 | -122.437780563503 | (37.7121800264355, -122.437780563503) | |
| 29434 | 29434 | 223375 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 12 Lexington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6006422.52922 | 2105783.74221 | 37.7624440827408 | -122.42092782106 | (37.7624440827408, -122.42092782106) | |||
| 4218 | 4218 | 181054 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 120 Brunswick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 09:03:00 AM | 3 | Width 2ft | 6000669.11916 | 2087419.81595 | 37.711695057256605 | -122.439510213951 | (37.7116950572566, -122.439510213951) | ||
| 4304 | 4304 | 181055 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 120 Brunswick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 09:09:00 AM | 3 | Width 2ft | 6000651.24572 | 2087413.96665 | 37.711677979129604 | -122.43957157019899 | (37.7116779791296, -122.439571570199) | ||
| 47689 | 47689 | 189251 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 120 Loomis St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 4ft | 6010844.92077 | 2097998.29295 | 37.7413152397136 | -122.405084094075 | (37.7413152397136, -122.405084094075) | |||
| 70731 | 70731 | 189252 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 120 Loomis St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 4ft | 6010838.98568 | 2097984.0880299998 | 37.74127590426679 | -122.40510361565 | (37.7412759042668, -122.40510361565) | |||
| 134877 | 134877 | 189253 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 120 Loomis St | 3 | : 4 | Tree 1 | Private 1 | 1 | Width 4ft | 6010832.24307 | 2097967.49844 | 37.74122997588171 | -122.405125761461 | (37.7412299758817, -122.405125761461) | |||
| 151331 | 151331 | 189254 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 120 Loomis St | 4 | : 4 | Tree 1 | Private 1 | 1 | Width 4ft | 6010822.293409999 | 2097942.01462 | 37.7411594465586 | -122.405158369988 | (37.7411594465586, -122.405158369988) | |||
| 74059 | 74059 | 31015 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1200 Naples St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/13/1995 12:00:00 AM | 9 | Permit Number 34784 | 6001104.8718 | 2087440.4366099997 | 37.7117764674692 | -122.438005613962 | (37.7117764674692, -122.438005613962) | ||
| 113714 | 113714 | 31017 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1200 Naples St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/13/1995 12:00:00 AM | Permit Number 34784 | 6001138.87641909 | 2087503.16195668 | 37.711950631123294 | -122.43789257478399 | (37.7119506311233, -122.437892574784) | |||
| 139860 | 139860 | 31016 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1200 Naples St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/13/1995 12:00:00 AM | Permit Number 34784 | 6001138.87641909 | 2087503.16195668 | 37.711950631123294 | -122.43789257478399 | (37.7119506311233, -122.437892574784) | |||
| 103363 | 103363 | 57789 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1201 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1988 12:00:00 AM | Permit Number 16716 | 6015407.18997447 | 2095895.9761965 | 37.7357966956695 | -122.389162475837 | (37.7357966956695, -122.389162475837) | ||
| 80867 | 80867 | 46871 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1201 Pacific Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/2002 12:00:00 AM | Permit Number 44934 | 6008372.46317139 | 2117892.13679596 | 37.7958005639716 | -122.41504078297899 | (37.7958005639716, -122.415040782979) | ||
| 122071 | 122071 | 46870 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1201 Pacific Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/2002 12:00:00 AM | Permit Number 44934 | 6008372.46317139 | 2117892.13679596 | 37.7958005639716 | -122.41504078297899 | (37.7958005639716, -122.415040782979) | ||
| 127935 | 127935 | 46869 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1201 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/2002 12:00:00 AM | Permit Number 44934 | 6008372.46317139 | 2117892.13679596 | 37.7958005639716 | -122.41504078297899 | (37.7958005639716, -122.415040782979) | ||
| 149252 | 149252 | 207663 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1201 Willard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 5996706.11666 | 2107295.5599599998 | 37.76604266777311 | -122.454642347884 | (37.7660426677731, -122.454642347884) | |||
| 181830 | 181830 | 207662 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1203 Willard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5996707.43605 | 2107271.27987 | 37.7659760765509 | -122.45463603013799 | (37.7659760765509, -122.454636030138) | |||
| 136213 | 136213 | 207661 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1205 Willard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5996709.68526 | 2107252.63916 | 37.7659250229495 | -122.45462690381599 | (37.7659250229495, -122.454626903816) | |||
| 4183 | 4183 | 180766 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1206 Naples St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/10/2017 09:29:00 AM | 3 | Width 8ft | 6001093.57723 | 2087421.33847 | 37.7117233858917 | -122.438043283865 | (37.7117233858917, -122.438043283865) | ||
| 4210 | 4210 | 251779 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1207 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 09:23:00 AM | 3 | 3x3 | 6001136.0 | 2087356.0 | 37.7115463934242 | -122.437891982586 | (37.7115463934242, -122.437891982586) | ||
| 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) | |||
| 52641 | 52641 | 207623 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1209 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 5995446.62936 | 2107316.27502 | 37.7660272254875 | -122.45900013246401 | (37.7660272254875, -122.459000132464) | |||
| 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) | ||
| 96676 | 96676 | 67192 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1209 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1992 12:00:00 AM | Permit Number 30642 | 5997398.59481409 | 2105779.27985473 | 37.761919041790705 | -122.452137804207 | (37.7619190417907, -122.452137804207) | ||
| 182831 | 182831 | 223448 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1209 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5997400.9085 | 2105772.15119 | 37.7618996008164 | -122.452129287752 | (37.7618996008164, -122.452129287752) | |||
| 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) | |||
| 84246 | 84246 | 84682 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 121 Brighton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/03/2007 12:00:00 AM | 3x3 | Permit Number 49717 | 5996195.09164629 | 2090696.9376961002 | 37.720437620979 | -122.455210247054 | (37.720437620979, -122.455210247054) | ||
| 102733 | 102733 | 47029 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 121 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/02/2002 12:00:00 AM | 5 | Permit Number 778397 | 6003325.68265754 | 2108679.50884572 | 37.7702201068925 | -122.43184543930599 | (37.7702201068925, -122.431845439306) | |
| 122899 | 122899 | 54507 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1216 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/28/1992 12:00:00 AM | Permit Number 30517 | 5995821.5576283 | 2107222.6478093 | 37.7657916947959 | -122.457696564157 | (37.7657916947959, -122.457696564157) | ||
| 164431 | 164431 | 207539 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1216 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5995838.12242 | 2107108.03274 | 37.7654779429827 | -122.457630976687 | (37.7654779429827, -122.457630976687) | |||
| 60106 | 60106 | 207624 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1217 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 6ft | 5995447.45032 | 2107265.73285 | 37.765888496982 | -122.458993633074 | (37.765888496982, -122.458993633074) | |||
| 1861 | 1861 | 251780 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1219 Naples St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001110.0 | 2087312.0 | 37.7114241006266 | -122.437978695611 | (37.7114241006266, -122.437978695611) | ||||
| 30295 | 30295 | 223552 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1219 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5997724.56816 | 2106357.12566 | 37.7635243277135 | -122.451052067198 | (37.7635243277135, -122.451052067198) | |||
| 167884 | 167884 | 88383 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 122 18th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51361 | 5990241.512159999 | 2114541.21965 | 37.78556434694811 | -122.477531513518 | (37.7855643469481, -122.477531513518) | ||
| 137127 | 137127 | 207603 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 122 Brighton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5996240.91229 | 2090722.7587 | 37.7205111481621 | -122.455053725648 | (37.7205111481621, -122.455053725648) | |||
| 140781 | 140781 | 81911 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 122 Brighton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/03/2007 12:00:00 AM | 3X3 | Permit Number 49718 | 5996247.30096369 | 2090708.70815365 | 37.7204729351862 | -122.455030627418 | (37.7204729351862, -122.455030627418) | ||
| 32189 | 32189 | 31714 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 122 Rivoli St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 8 | Permit Number 35214 | 5998115.883119999 | 2105983.06318 | 37.7625196419841 | -122.44967168249799 | (37.7625196419841, -122.449671682498) | |
| 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) | ||
| 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) | |||
| 46094 | 46094 | 207625 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1223 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5995447.2053 | 2107231.58705 | 37.7657947273793 | -122.45899200797301 | (37.7657947273793, -122.458992007973) | |||
| 114165 | 114165 | 50181 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1223 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/18/2003 12:00:00 AM | Permit Number 46888 | 5997714.25979523 | 2106396.55176256 | 37.7636319916344 | -122.4510905637 | (37.7636319916344, -122.4510905637) | |||
| 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) | ||
| 151394 | 151394 | 207540 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1225 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 5994824.854040001 | 2107195.02227 | 37.7656585349505 | -122.461141922776 | (37.7656585349505, -122.461141922776) | |||
| 167984 | 167984 | 223553 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1225 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5997728.13175 | 2106337.92213 | 37.76347180370121 | -122.451038357055 | (37.7634718037012, -122.451038357055) | |||
| 62720 | 62720 | 207622 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1226 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5995492.16828 | 2107225.03182 | 37.7657793129775 | -122.458836016967 | (37.7657793129775, -122.458836016967) | |||
| 124897 | 124897 | 60896 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1226 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/14/1992 12:00:00 AM | Permit Number 20684 | 5995496.17178877 | 2107213.04806332 | 37.765746638805204 | -122.458821302083 | (37.7657466388052, -122.458821302083) | ||
| 4506 | 4506 | 253629 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 123 Eddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6009831.1503800005 | 2113653.7445799997 | 37.7842448233884 | -122.409694124829 | (37.7842448233884, -122.409694124829) | |||||
| 4520 | 4520 | 253628 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 123 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6009831.1503800005 | 2113653.7445799997 | 37.7842448233884 | -122.409694124829 | (37.7842448233884, -122.409694124829) | |||||
| 34265 | 34265 | 207541 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1231 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5994826.21474 | 2107149.24647 | 37.7655329248259 | -122.461133898112 | (37.7655329248259, -122.461133898112) | |||
| 49598 | 49598 | 69056 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1235 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/10/1994 12:00:00 AM | Permit Number 33064 | 5992348.34951393 | 2107046.09564514 | 37.7651067945026 | -122.469696689595 | (37.7651067945026, -122.469696689595) | ||
| 75663 | 75663 | 207649 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1235 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5992350.24318 | 2107007.29573 | 37.765000369682205 | -122.469687315036 | (37.7650003696822, -122.469687315036) | |||
| 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) | |||
| 178330 | 178330 | 207543 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1237 04th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5994827.334430001 | 2107114.10387 | 37.7654364968285 | -122.461127477873 | (37.7654364968285, -122.461127477873) | |||
| 4207 | 4207 | 251781 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1237 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 09:14:00 AM | 3 | 3x3 | 6001070.0 | 2087245.0 | 37.711237858655295 | -122.438112149268 | (37.7112378586553, -122.438112149268) | ||
| 121831 | 121831 | 55450 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1238 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/18/1983 12:00:00 AM | Permit Number 20687 | 5995498.97479315 | 2107131.57167312 | 37.7655230868492 | -122.458805707854 | (37.7655230868492, -122.458805707854) | ||
| 101289 | 101289 | 54727 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1239 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/02/2010 12:00:00 AM | 16 | Permit Number 10570 | 5993898.14221717 | 2107049.18908111 | 37.7652047418661 | -122.464336602201 | (37.7652047418661, -122.464336602201) | ||
| 33933 | 33933 | 207650 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1239 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 5992348.57689 | 2106988.87327 | 37.7649496901864 | -122.469691736987 | (37.7649496901864, -122.469691736987) | |||
| 118452 | 118452 | 69057 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1239 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/10/1994 12:00:00 AM | Permit Number 33065 | 5992349.25716829 | 2107019.71250197 | 37.765034405853704 | -122.46969162939699 | (37.7650344058537, -122.469691629397) | ||
| 111428 | 111428 | 53552 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 124 Majestic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/24/1982 12:00:00 AM | Permit Number 20052 | 5997008.15708783 | 2089291.43789618 | 37.7166250615868 | -122.452298391323 | (37.7166250615868, -122.452298391323) | ||
| 87482 | 87482 | 88794 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1240 05th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/2010 12:00:00 AM | 3x3 | Permit Number 51706 | 5994624.7 | 2107112.8 | 37.765421253667796 | -122.461828244278 | (37.7654212536678, -122.461828244278) | |||
| 30905 | 30905 | 191680 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1241 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017088.63788 | 2093939.5635 | 37.7305178434155 | -122.383212860684 | (37.7305178434155, -122.383212860684) | |||
| 59341 | 59341 | 191681 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1241 Oakdale Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6017111.18893 | 2093915.9080299998 | 37.7304541363294 | -122.383133251796 | (37.7304541363294, -122.383133251796) | |||
| 54790 | 54790 | 207545 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1243 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5994515.71143 | 2107079.97224 | 37.7653248424019 | -122.462202826907 | (37.7653248424019, -122.462202826907) | |||
| 125844 | 125844 | 69058 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1243 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/10/1994 12:00:00 AM | Permit Number 33066 | 5992350.1648235 | 2106993.32933415 | 37.76496201713589 | -122.469686569205 | (37.7649620171359, -122.469686569205) |
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");