trees
2,421 rows where qSpecies_id = 8 sorted by qAddress
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10369 | 223584 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 10x Tompkins Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6007576 | 2096576 | 37.7372266531625 | -122.41628619091 | (37.7372266531625, -122.41628619091) | 2 | 7 | 7 | 28859 | 2 | |||
| 15567 | 223585 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 10x Tompkins Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6007519 | 2096543 | 37.7371328370553 | -122.416480929712 | (37.7371328370553, -122.416480929712) | 2 | 7 | 7 | 28859 | 2 | |||
| 87729 | 248098 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 11 Brewster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6010471.50543 | 2099820.33523 | 37.7462972904853 | -122.40650360018 | (37.7462972904853, -122.40650360018) | 2 | 7 | 7 | 28859 | 2 | |||
| 188987 | 216737 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 11 Lee Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/04/2017 02:31:00 PM | 3 | Width 2ft | 5996481.70655 | 2089974.50939 | 37.7184704425356 | -122.454167365558 | (37.7184704425356, -122.454167365558) | 9 | 8 | 6 | 28861 | 24 | ||
| 64496 | 85535 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 110 12th St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/29/2007 12:00:00 AM | 5 | 6007364.04136 | 2109271.58584 | 37.7720739081089 | -122.41791872548 | (37.7720739081089, -122.41791872548) | 8 | 2 | 9 | 28853 | 19 | |||
| 81603 | 85537 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 110 12th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2007 12:00:00 AM | 6 | 6007421.29052 | 2109238.78217 | 37.7719870587743 | -122.417718370032 | (37.7719870587743, -122.417718370032) | 8 | 2 | 9 | 28853 | 19 | |||
| 104744 | 85536 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 110 12th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2007 12:00:00 AM | 6 | 6007398.39847 | 2109252.27561 | 37.7720228203246 | -122.417798512189 | (37.7720228203246, -122.417798512189) | 8 | 2 | 9 | 28853 | 19 | |||
| 108528 | 191677 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 110 12th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6007442.31511 | 2109225.32703 | 37.7719512972482 | -122.417644690367 | (37.7719512972482, -122.417644690367) | 8 | 2 | 9 | 28853 | 19 | |||
| 118077 | 85533 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 110 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2007 12:00:00 AM | 6 | 6007332.25294 | 2109288.61069 | 37.7721188652314 | -122.418029891562 | (37.7721188652314, -122.418029891562) | 8 | 2 | 9 | 28853 | 19 | |||
| 149622 | 85534 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 110 12th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2007 12:00:00 AM | 6 | 6007347.01879 | 2109279.74931 | 37.7720953650306 | -122.417978186861 | (37.7720953650306, -122.417978186861) | 8 | 2 | 9 | 28853 | 19 | |||
| 129901 | 224081 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 110 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6002846.5301 | 2108989.93169 | 37.7710452779528 | -122.433525010771 | (37.7710452779528, -122.433525010771) | 15 | 5 | 11 | 29492 | 9 | |||
| 111996 | 142040 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 110 STANYAN BLVD | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5996550.3383 | 2112261.0255 | 37.7796676074386 | -122.455540077752 | (37.7796676074386, -122.455540077752) | 15 | 6 | 2 | 54 | 16 | |||
| 148806 | 142041 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 110 STANYAN BLVD | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5996542.5421 | 2112281.8153 | 37.7797242433743 | -122.455568551111 | (37.7797242433743, -122.455568551111) | 15 | 6 | 2 | 54 | 16 | |||
| 21414 | 124354 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1100 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5992180.38847 | 2111384.61555 | 37.7770094950384 | -122.470593638633 | (37.7770094950384, -122.470593638633) | 11 | 6 | 2 | 54 | 11 | |||
| 79507 | 94172 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1101 Carolina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2010 12:00:00 AM | 3x3 | Permit Number 53593 | 6012553 | 2102835 | 37.7546911374705 | -122.399517610991 | (37.7546911374705, -122.399517610991) | 10 | 3 | 8 | 28856 | 29 | ||
| 102488 | 94173 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1101 Carolina St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2010 12:00:00 AM | 3x3 | Permit Number 53593 | 6012553 | 2102835 | 37.7546911374705 | -122.399517610991 | (37.7546911374705, -122.399517610991) | 10 | 3 | 8 | 28856 | 29 | ||
| 169572 | 94174 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1101 Carolina St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2010 12:00:00 AM | 3x3 | Permit Number 53593 | 6012553 | 2102835 | 37.7546911374705 | -122.399517610991 | (37.7546911374705, -122.399517610991) | 10 | 3 | 8 | 28856 | 29 | ||
| 172131 | 176254 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1101 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6011871.08574 | 2089770.57713 | 37.7187809523661 | -122.400958007209 | (37.7187809523661, -122.400958007209) | 10 | 7 | 8 | 309 | 39 | |||
| 40787 | 64563 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1101 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/26/1988 12:00:00 AM | 12 | Permit Number 25455 | 6009863.09945 | 2117549.8357 | 37.7949443413606 | -122.409858709005 | (37.7949443413606, -122.409858709005) | 3 | 1 | 10 | 28857 | 4 | |
| 113991 | 126532 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1101 Powell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6009864.00363 | 2117536.67962 | 37.7949082686427 | -122.409854651267 | (37.7949082686427, -122.409854651267) | 3 | 1 | 10 | 28857 | 4 | |||
| 31798 | 154902 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 1101X Ortega St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/2018 12:00:00 AM | 3 | 4x4 | Permit Number 778565 | 5990408 | 2102358 | 37.7521221923779 | -122.476065384407 | (37.7521221923779, -122.476065384407) | 1 | 8 | 4 | 29491 | 12 | |
| 34999 | 154898 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 1101X Ortega St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/2018 12:00:00 AM | 3 | 4x4 | Permit Number 778565 | 5990408 | 2102358 | 37.7521221923779 | -122.476065384407 | (37.7521221923779, -122.476065384407) | 1 | 8 | 4 | 29491 | 12 | |
| 86852 | 154903 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 1101X Ortega St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/2018 12:00:00 AM | 3 | 4x4 | Permit Number 778565 | 5990408 | 2102358 | 37.7521221923779 | -122.476065384407 | (37.7521221923779, -122.476065384407) | 1 | 8 | 4 | 29491 | 12 | |
| 160246 | 254370 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 1101X Ortega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/2018 12:00:00 AM | 3 | 4x4 | Permit Number 778565 | 5990408 | 2102358 | 37.7521221923779 | -122.476065384407 | (37.7521221923779, -122.476065384407) | 1 | 8 | 4 | 29491 | 12 | |
| 44433 | 94516 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1106X Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 08/27/2010 12:00:00 AM | 2 | Permit Number 53703 | 6012787.7377 | 2102360.94736 | 37.7534025731789 | -122.398672553793 | (37.7534025731789, -122.398672553793) | 10 | 3 | 8 | 28856 | 29 | ||
| 40386 | 90164 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1108 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/10/2008 12:00:00 AM | 3 | 3x3 | 5992192.434047 | 2111377.6526 | 37.776991073192 | -122.470551462384 | (37.776991073192, -122.470551462384) | 11 | 6 | 2 | 54 | 11 | ||
| 189860 | 124355 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1108 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 5992124.25378 | 2111386.32559 | 37.7770109442204 | -122.470787948699 | (37.7770109442204, -122.470787948699) | 11 | 6 | 2 | 54 | 11 | |||
| 46268 | 15048 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1119 Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/20/2000 12:00:00 AM | 6 | 3X3 | 6015497.5853 | 2096021.456 | 37.7361462484719 | -122.388858698526 | (37.7361462484719, -122.388858698526) | 10 | 3 | 8 | 58 | 1 | ||
| 146520 | 81459 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1119 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2007 12:00:00 AM | 1 | 3x3 | Permit Number 49734 | 5989696.8991 | 2098996.9987 | 37.7428525058761 | -122.47827872443 | (37.7428525058761, -122.47827872443) | 1 | 8 | 3 | 29491 | 35 | |
| 154681 | 170290 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 112 Judson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/22/2017 12:00:00 AM | 3 | Width 3ft | 5999300.3013 | 2093511.31058 | 37.7283429067858 | -122.44467875894 | (37.7283429067858, -122.44467875894) | 9 | 7 | 4 | 28861 | 40 | ||
| 128841 | 90165 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1120 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/12/2008 12:00:00 AM | 3 | 3x3 | 5992092.63811 | 2111382.24215 | 37.7769979038116 | -122.470897018546 | (37.7769979038116, -122.470897018546) | 11 | 6 | 2 | 54 | 11 | ||
| 118452 | 26834 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1129 Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/2008 12:00:00 AM | 3 | 3X3 | 6015470.5845 | 2095986.9202 | 37.7360499235694 | -122.388949641676 | (37.7360499235694, -122.388949641676) | 10 | 3 | 8 | 58 | 1 | ||
| 65385 | 26833 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1133 Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/22/2008 12:00:00 AM | 0 | 3X3 | 6015479.92911 | 2095965.05347 | 37.7359903999296 | -122.388915807139 | (37.7359903999296, -122.388915807139) | 10 | 3 | 8 | 58 | 1 | ||
| 192708 | 15051 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1137 Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/20/2000 12:00:00 AM | 3 | 8X18 | 6015459.2819 | 2095972.4779 | 37.736009641441 | -122.388987711638 | (37.736009641441, -122.388987711638) | 10 | 3 | 8 | 58 | 1 | ||
| 29054 | 223592 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1142 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009191.70637 | 2102498.92995 | 37.7535804348003 | -122.411118182576 | (37.7535804348003, -122.411118182576) | 2 | 4 | 7 | 28859 | 19 | |||
| 129370 | 62958 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1142 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/21/1986 12:00:00 AM | Permit Number 23344 | 6008125.85575238 | 2118255.57771401 | 37.7967846215561 | -122.415919842071 | (37.7967846215561, -122.415919842071) | 5 | 1 | 10 | 28858 | 21 | ||
| 188006 | 223551 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1143 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 5997699.39696 | 2106553.80105 | 37.7640629073877 | -122.45115331019 | (37.7640629073877, -122.45115331019) | 15 | 5 | 11 | 29492 | 9 | |||
| 86846 | 254804 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1159 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/28/2018 12:00:00 AM | 3 | 3x3 | Permit Number 778103 | 6004469.23164 | 2102144.01452 | 37.7523399531709 | -122.427424258339 | (37.7523399531709, -122.427424258339) | 2 | 4 | 5 | 28862 | 22 |
| 82391 | 248256 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 116 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006785.81091 | 2098870.27842 | 37.743481764973 | -122.419180937446 | (37.743481764973, -122.419180937446) | 2 | 7 | 7 | 28859 | 2 | |||
| 7811 | 10192 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1169 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/16/2016 04:46:00 AM | 3 | 3X3 | 6005805.59526 | 2102140.15786 | 37.7524048554241 | -122.422802617046 | (37.7524048554241, -122.422802617046) | 2 | 4 | 5 | 28859 | 19 | ||
| 37659 | 62959 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1175 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/21/1986 12:00:00 AM | 14 | Permit Number 23345 | 6008001.56121 | 2118185.8038 | 37.7965860510683 | -122.416344986535 | (37.7965860510683, -122.416344986535) | 5 | 1 | 10 | 28858 | 21 | |
| 188702 | 65262 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1175 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/26/1989 12:00:00 AM | Permit Number 28063 | 6009506.97444582 | 2102339.79830216 | 37.7531611699928 | -122.410016678829 | (37.7531611699928, -122.410016678829) | 2 | 4 | 7 | 28859 | 19 | ||
| 83988 | 224045 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 118 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4x4 | 6000330.71148 | 2104908.09647 | 37.7596945117222 | -122.441934261878 | (37.7596945117222, -122.441934261878) | 2 | 4 | 5 | 28862 | 3 | |||
| 96633 | 223519 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 118 Milton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6003743.87449 | 2095119.74297 | 37.7330118702979 | -122.429431783351 | (37.7330118702979, -122.429431783351) | 9 | 7 | 5 | 28861 | 25 | |||
| 78114 | 33048 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1192 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | Permit Number 37324 | 6005740.26598795 | 2102030.16267757 | 37.7520991477767 | -122.423020719371 | (37.7520991477767, -122.423020719371) | 2 | 4 | 5 | 28859 | 19 | ||
| 114847 | 253246 | Planning Code 138.1 required 2 | Eriobotrya deflexa :: Bronze Loquat 8 | 1192 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/2017 12:00:00 AM | 3 | 4x4 | Permit Number 780462 | 6001173 | 2087586 | 37.7121800264355 | -122.437780563503 | (37.7121800264355, -122.437780563503) | 9 | 7 | 6 | 28861 | 5 | |
| 191421 | 223375 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 12 Lexington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6006422.52922 | 2105783.74221 | 37.7624440827408 | -122.42092782106 | (37.7624440827408, -122.42092782106) | 8 | 4 | 7 | 28859 | 19 | |||
| 23320 | 181055 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 120 Brunswick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2017 09:09:00 AM | 3 | Width 2ft | 6000651.24572 | 2087413.96665 | 37.7116779791296 | -122.439571570199 | (37.7116779791296, -122.439571570199) | 9 | 7 | 6 | 28861 | 5 | ||
| 76601 | 181054 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 120 Brunswick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2017 09:03:00 AM | 3 | Width 2ft | 6000669.11916 | 2087419.81595 | 37.7116950572566 | -122.439510213951 | (37.7116950572566, -122.439510213951) | 9 | 7 | 6 | 28861 | 5 | ||
| 3646 | 189251 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 120 Loomis St | 1 | : | Tree | Private 2 | 1 | Width 4ft | 6010844.92077 | 2097998.29295 | 37.7413152397136 | -122.405084094075 | (37.7413152397136, -122.405084094075) | 10 | 3 | 8 | 58 | 1 | |||
| 31692 | 189252 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 120 Loomis St | 2 | : | Tree | Private 2 | 1 | Width 4ft | 6010838.98568 | 2097984.08803 | 37.7412759042668 | -122.40510361565 | (37.7412759042668, -122.40510361565) | 10 | 3 | 8 | 58 | 1 | |||
| 82640 | 189254 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 120 Loomis St | 4 | : | Tree | Private 2 | 1 | Width 4ft | 6010822.29341 | 2097942.01462 | 37.7411594465586 | -122.405158369988 | (37.7411594465586, -122.405158369988) | 10 | 3 | 8 | 58 | 1 | |||
| 189244 | 189253 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 120 Loomis St | 3 | : | Tree | Private 2 | 1 | Width 4ft | 6010832.24307 | 2097967.49844 | 37.7412299758817 | -122.405125761461 | (37.7412299758817, -122.405125761461) | 10 | 3 | 8 | 58 | 1 | |||
| 19771 | 31015 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1200 Naples St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/13/1995 12:00:00 AM | 9 | Permit Number 34784 | 6001104.8718 | 2087440.43661 | 37.7117764674692 | -122.438005613962 | (37.7117764674692, -122.438005613962) | 9 | 7 | 6 | 28861 | 5 | ||
| 138025 | 31017 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1200 Naples St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/13/1995 12:00:00 AM | Permit Number 34784 | 6001138.87641909 | 2087503.16195668 | 37.7119506311233 | -122.437892574784 | (37.7119506311233, -122.437892574784) | 9 | 7 | 6 | 28861 | 5 | |||
| 182996 | 31016 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1200 Naples St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/13/1995 12:00:00 AM | Permit Number 34784 | 6001138.87641909 | 2087503.16195668 | 37.7119506311233 | -122.437892574784 | (37.7119506311233, -122.437892574784) | 9 | 7 | 6 | 28861 | 5 | |||
| 15659 | 26852 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1201 Guerrero St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/19/2016 05:13:00 AM | 3 | 2X2 | 6005817.98305 | 2101925.96787 | 37.7518174380456 | -122.422744557734 | (37.7518174380456, -122.422744557734) | 2 | 4 | 5 | 28859 | 19 | ||
| 112448 | 57789 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1201 Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/21/1988 12:00:00 AM | Permit Number 16716 | 6015407.18997447 | 2095895.9761965 | 37.7357966956695 | -122.389162475837 | (37.7357966956695, -122.389162475837) | 10 | 3 | 8 | 58 | 1 | ||
| 32693 | 46869 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1201 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/2002 12:00:00 AM | Permit Number 44934 | 6008372.46317139 | 2117892.13679596 | 37.7958005639716 | -122.415040782979 | (37.7958005639716, -122.415040782979) | 5 | 1 | 10 | 28858 | 21 | ||
| 53575 | 46871 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1201 Pacific Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/2002 12:00:00 AM | Permit Number 44934 | 6008372.46317139 | 2117892.13679596 | 37.7958005639716 | -122.415040782979 | (37.7958005639716, -122.415040782979) | 5 | 1 | 10 | 28858 | 21 | ||
| 165412 | 46870 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1201 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/2002 12:00:00 AM | Permit Number 44934 | 6008372.46317139 | 2117892.13679596 | 37.7958005639716 | -122.415040782979 | (37.7958005639716, -122.415040782979) | 5 | 1 | 10 | 28858 | 21 | ||
| 78417 | 207663 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1201 Willard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 5996706.11666 | 2107295.55996 | 37.7660426677731 | -122.454642347884 | (37.7660426677731, -122.454642347884) | 15 | 5 | 11 | 29492 | 12 | |||
| 109851 | 207662 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1203 Willard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5996707.43605 | 2107271.27987 | 37.7659760765509 | -122.454636030138 | (37.7659760765509, -122.454636030138) | 15 | 5 | 11 | 29492 | 12 | |||
| 58713 | 207661 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1205 Willard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5996709.68526 | 2107252.63916 | 37.7659250229495 | -122.454626903816 | (37.7659250229495, -122.454626903816) | 15 | 5 | 11 | 29492 | 12 | |||
| 141049 | 180766 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1206 Naples St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/10/2017 09:29:00 AM | 3 | Width 8ft | 6001093.57723 | 2087421.33847 | 37.7117233858917 | -122.438043283865 | (37.7117233858917, -122.438043283865) | 9 | 7 | 6 | 28861 | 5 | ||
| 178064 | 251779 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1207 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2017 09:23:00 AM | 3 | 3x3 | 6001136 | 2087356 | 37.7115463934242 | -122.437891982586 | (37.7115463934242, -122.437891982586) | 9 | 7 | 6 | 28861 | 5 | ||
| 61407 | 207660 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1207 Willard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5996711.46943 | 2107231.1786 | 37.7658662000893 | -122.454619182239 | (37.7658662000893, -122.454619182239) | 15 | 5 | 11 | 29492 | 12 | |||
| 67124 | 207623 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1209 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 5995446.62936 | 2107316.27502 | 37.7660272254875 | -122.459000132464 | (37.7660272254875, -122.459000132464) | 15 | 5 | 11 | 56 | 12 | |||
| 171916 | 10198 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1209 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1991 12:00:00 AM | 3 | 2X2 | 6005820.58037 | 2101870.80495 | 37.7516661199201 | -122.422731656039 | (37.7516661199201, -122.422731656039) | 2 | 4 | 5 | 28859 | 19 | ||
| 59849 | 223448 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1209 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5997400.9085 | 2105772.15119 | 37.7618996008164 | -122.452129287752 | (37.7618996008164, -122.452129287752) | 15 | 5 | 11 | 29492 | 12 | |||
| 77634 | 67192 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1209 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/1992 12:00:00 AM | Permit Number 30642 | 5997398.59481409 | 2105779.27985473 | 37.7619190417907 | -122.452137804207 | (37.7619190417907, -122.452137804207) | 15 | 5 | 11 | 29492 | 12 | ||
| 40210 | 84682 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 121 Brighton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2007 12:00:00 AM | 3x3 | Permit Number 49717 | 5996195.09164629 | 2090696.9376961 | 37.720437620979 | -122.455210247054 | (37.720437620979, -122.455210247054) | 9 | 8 | 6 | 28861 | 24 | ||
| 170509 | 207602 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 121 Brighton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5996198.32663 | 2090727.04827 | 37.7205204831134 | -122.455201239645 | (37.7205204831134, -122.455201239645) | 9 | 8 | 6 | 28861 | 24 | |||
| 98178 | 47029 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 121 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/02/2002 12:00:00 AM | 5 | Permit Number 778397 | 6003325.68265754 | 2108679.50884572 | 37.7702201068925 | -122.431845439306 | (37.7702201068925, -122.431845439306) | 15 | 9 | 5 | 29492 | 9 | |
| 145476 | 207539 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1216 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5995838.12242 | 2107108.03274 | 37.7654779429827 | -122.457630976687 | (37.7654779429827, -122.457630976687) | 15 | 5 | 11 | 29492 | 12 | |||
| 154867 | 54507 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1216 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/28/1992 12:00:00 AM | Permit Number 30517 | 5995821.5576283 | 2107222.6478093 | 37.7657916947959 | -122.457696564157 | (37.7657916947959, -122.457696564157) | 15 | 5 | 11 | 29492 | 12 | ||
| 52633 | 207624 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1217 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 6ft | 5995447.45032 | 2107265.73285 | 37.765888496982 | -122.458993633074 | (37.765888496982, -122.458993633074) | 15 | 5 | 11 | 56 | 12 | |||
| 53756 | 251780 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 1219 Naples St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001110 | 2087312 | 37.7114241006266 | -122.437978695611 | (37.7114241006266, -122.437978695611) | 9 | 7 | 6 | 28861 | 5 | ||||
| 132659 | 223552 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1219 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5997724.56816 | 2106357.12566 | 37.7635243277135 | -122.451052067198 | (37.7635243277135, -122.451052067198) | 15 | 5 | 11 | 29492 | 9 | |||
| 143403 | 88383 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 122 18th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51361 | 5990241.51216 | 2114541.21965 | 37.7855643469481 | -122.477531513518 | (37.7855643469481, -122.477531513518) | 11 | 6 | 2 | 55 | 26 | ||
| 153698 | 207603 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 122 Brighton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5996240.91229 | 2090722.7587 | 37.7205111481621 | -122.455053725648 | (37.7205111481621, -122.455053725648) | 9 | 8 | 6 | 28861 | 24 | |||
| 176058 | 81911 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 122 Brighton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2007 12:00:00 AM | 3X3 | Permit Number 49718 | 5996247.30096369 | 2090708.70815365 | 37.7204729351862 | -122.455030627418 | (37.7204729351862, -122.455030627418) | 9 | 8 | 6 | 28861 | 24 | ||
| 23958 | 31714 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 122 Rivoli St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | 8 | Permit Number 35214 | 5998115.88312 | 2105983.06318 | 37.7625196419841 | -122.449671682498 | (37.7625196419841, -122.449671682498) | 15 | 5 | 11 | 29492 | 9 | |
| 46455 | 17169 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1221X Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/10/2007 12:00:00 AM | 3 | 3x3 | 6017071.13101 | 2093953.96501 | 37.7305564196556 | -122.383274387156 | (37.7305564196556, -122.383274387156) | 10 | 3 | 8 | 58 | 1 | ||
| 163425 | 17171 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1221X Oakdale Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/10/2007 12:00:00 AM | 3 | 3x3 | 6017100.78201 | 2093930.01601 | 37.7304922989818 | -122.383170211952 | (37.7304922989818, -122.383170211952) | 10 | 3 | 8 | 58 | 1 | ||
| 50524 | 207695 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1222 Plymouth Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5995891.52818 | 2092172.3625 | 37.7244713658451 | -122.456366191771 | (37.7244713658451, -122.456366191771) | 9 | 7 | 4 | 28861 | 40 | |||
| 8247 | 261144 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1223 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/2019 11:14:00 AM | 3 | 5982369 | 2106763 | 37.7637476520641 | -122.504191265784 | (37.7637476520641, -122.504191265784) | 1 | 8 | 3 | 56 | 35 | ||
| 138465 | 50181 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1223 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/18/2003 12:00:00 AM | Permit Number 46888 | 5997714.25979523 | 2106396.55176256 | 37.7636319916344 | -122.4510905637 | (37.7636319916344, -122.4510905637) | 15 | 5 | 11 | 29492 | 9 | |||
| 30856 | 15055 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1224 Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2006 12:00:00 AM | 3 | 3x3 | 6015288.0468 | 2095812.3346 | 37.7355604273252 | -122.389568564294 | (37.7355604273252, -122.389568564294) | 10 | 3 | 8 | 58 | 1 | ||
| 103613 | 207540 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1225 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 5994824.85404 | 2107195.02227 | 37.7656585349505 | -122.461141922776 | (37.7656585349505, -122.461141922776) | 15 | 5 | 11 | 56 | 12 | |||
| 32136 | 223553 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1225 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5997728.13175 | 2106337.92213 | 37.7634718037012 | -122.451038357055 | (37.7634718037012, -122.451038357055) | 15 | 5 | 11 | 29492 | 9 | |||
| 25721 | 207622 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1226 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5995492.16828 | 2107225.03182 | 37.7657793129775 | -122.458836016967 | (37.7657793129775, -122.458836016967) | 15 | 5 | 11 | 56 | 12 | |||
| 30387 | 60896 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1226 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/14/1992 12:00:00 AM | Permit Number 20684 | 5995496.17178877 | 2107213.04806332 | 37.7657466388052 | -122.458821302083 | (37.7657466388052, -122.458821302083) | 15 | 5 | 11 | 56 | 12 | ||
| 114137 | 253629 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 123 Eddy St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6009831.15038 | 2113653.74458 | 37.7842448233884 | -122.409694124829 | (37.7842448233884, -122.409694124829) | 14 | 10 | 9 | 28852 | 36 | |||||
| 181047 | 253628 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 123 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6009831.15038 | 2113653.74458 | 37.7842448233884 | -122.409694124829 | (37.7842448233884, -122.409694124829) | 14 | 10 | 9 | 28852 | 36 | |||||
| 67354 | 207541 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1231 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5994826.21474 | 2107149.24647 | 37.7655329248259 | -122.461133898112 | (37.7655329248259, -122.461133898112) | 15 | 5 | 11 | 56 | 12 | |||
| 495 | 69056 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1235 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/10/1994 12:00:00 AM | Permit Number 33064 | 5992348.34951393 | 2107046.09564514 | 37.7651067945026 | -122.469696689595 | (37.7651067945026, -122.469696689595) | 11 | 8 | 11 | 56 | 12 | ||
| 77403 | 207649 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1235 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5992350.24318 | 2107007.29573 | 37.7650003696822 | -122.469687315036 | (37.7650003696822, -122.469687315036) | 11 | 8 | 11 | 56 | 12 | |||
| 101858 | 207543 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1237 04th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5994827.33443 | 2107114.10387 | 37.7654364968285 | -122.461127477873 | (37.7654364968285, -122.461127477873) | 15 | 5 | 11 | 56 | 12 | |||
| 151017 | 207542 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1237 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5994826.31079 | 2107131.68473 | 37.7654847103867 | -122.461132292833 | (37.7654847103867, -122.461132292833) | 15 | 5 | 11 | 56 | 12 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );