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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 70107 | 70107 | 182614 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1866 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5989725.7736 | 2102651.2747 | 37.752887864299105 | -122.47844604391199 | (37.7528878642991, -122.478446043912) | |||
| 31314 | 31314 | 52821 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2850@ ANZA Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2016 12:00:00 AM | 1 | Permit Number 775537 | 5989762.54787 | 2111977.16007 | 37.7784963508186 | -122.479000957003 | (37.7784963508186, -122.479000957003) | ||
| 76323 | 76323 | 52820 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2850@ ANZA Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2016 12:00:00 AM | 1 | Permit Number 775537 | 5989777.027869999 | 2111978.2933900002 | 37.778500303461 | -122.478950948669 | (37.778500303461, -122.478950948669) | ||
| 61152 | 61152 | 90191 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1860X Balboa St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/26/2008 12:00:00 AM | 3 | 3x3 | 5989777.17693 | 2111298.4454200002 | 37.776633638000604 | -122.478900695137 | (37.7766336380006, -122.478900695137) | |||
| 85511 | 85511 | 90328 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1849X Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/27/2008 12:00:00 AM | 3 | 3x3 | 5989790.54801 | 2111243.58929 | 37.7764837946672 | -122.478850428089 | (37.7764837946672, -122.478850428089) | ||
| 139205 | 139205 | 90190 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1844 Balboa St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/26/2008 12:00:00 AM | 3 | 3x3 | 5989791.50296 | 2111298.5559400003 | 37.7766347733354 | -122.47885114584801 | (37.7766347733354, -122.478851145848) | |||
| 113659 | 113659 | 90189 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1844 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/26/2008 12:00:00 AM | 3 | 3x3 | 5989807.272530001 | 2111298.22245 | 37.7766347733404 | -122.478796570506 | (37.7766347733404, -122.478796570506) | ||
| 114544 | 114544 | 90329 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1849X Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/27/2008 12:00:00 AM | 3 | 3x3 | 5989811.500469999 | 2111242.93957 | 37.776483227335795 | -122.47877790082799 | (37.7764832273358, -122.478777900828) | ||
| 94858 | 94858 | 90330 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1831 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/27/2008 12:00:00 AM | 2 | 3x3 | 5989853.25507 | 2111244.33044 | 37.7764894706591 | -122.478633563095 | (37.7764894706591, -122.478633563095) | ||
| 93029 | 93029 | 90188 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1828 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/26/2008 12:00:00 AM | 3 | 3x3 | 5989860.89772 | 2111301.4295099997 | 37.776646692652996 | -122.47861130193998 | (37.776646692653, -122.47861130194) | ||
| 81865 | 81865 | 90187 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1826 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/26/2008 12:00:00 AM | 3 | 3x3 | 5989876.689130001 | 2111302.12921 | 37.776649530669 | -122.478556726612 | (37.776649530669, -122.478556726612) | ||
| 121356 | 121356 | 90331 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1821 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/27/2008 12:00:00 AM | 3 | 3x3 | 5989897.565230001 | 2111248.76817 | 37.776504228007205 | -122.478480607879 | (37.7765042280072, -122.478480607879) | ||
| 90394 | 90394 | 75463 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1806 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/22/2013 12:00:00 AM | 3 | 3x3 | 5989925.9266 | 2111303.98207 | 37.7766574766255 | -122.47838653717 | (37.7766574766255, -122.47838653717) | ||
| 86269 | 86269 | 47258 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1290 20TH AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | Permit Number 45199 | 5989944.0 | 2106611.0 | 37.763772878653995 | -122.477980844758 | (37.763772878654, -122.477980844758) | ||
| 138945 | 138945 | 117440 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1290 20TH AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5989944.0 | 2106611.0 | 37.763772878653995 | -122.477980844758 | (37.763772878654, -122.477980844758) | ||||
| 119864 | 119864 | 90332 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1751 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2008 12:00:00 AM | 3 | 3x3 | 5990079.80484 | 2111253.6764700003 | 37.7765282832532 | -122.477850554666 | (37.7765282832532, -122.477850554666) | ||
| 184164 | 184164 | 72399 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 794-798 19th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/27/2013 12:00:00 AM | 3 | 3x3 | Permit Number 769948 | 5990094.17599 | 2109997.0392299998 | 37.7730787370976 | -122.477708963104 | (37.7730787370976, -122.477708963104) |
| 117860 | 117860 | 90333 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1751 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2008 12:00:00 AM | 3 | 3x3 | 5990096.08573 | 2111253.98064 | 37.77653006330829 | -122.477794257242 | (37.7765300633083, -122.477794257242) | ||
| 112328 | 112328 | 111742 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1737 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2016 12:00:00 AM | 3 | 3x3 | Permit Number 776572 | 5990114.7617 | 2111254.66631 | 37.776533029826396 | -122.477729702528 | (37.7765330298264, -122.477729702528) | |
| 148128 | 148128 | 111743 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1737 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 5990130.37359 | 2111254.12016 | 37.7765324362559 | -122.477675657167 | (37.7765324362559, -122.477675657167) | |||
| 32606 | 32606 | 122015 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1799 Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5990132.5051 | 2110630.3352900003 | 37.7748198185001 | -122.477622678128 | (37.7748198185001, -122.477622678128) | |||
| 186042 | 186042 | 72426 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 4250X Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/1996 12:00:00 AM | 11 | 3x3 | Permit Number 773790 | 5990138.03134 | 2109951.66223 | 37.772956689267204 | -122.47755394624 | (37.7729566892672, -122.47755394624) |
| 162989 | 162989 | 111744 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1737 Balboa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 5990148.869080001 | 2111256.53838 | 37.77654014934021 | -122.47761185344 | (37.7765401493402, -122.47761185344) | |||
| 110811 | 110811 | 90186 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1720 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/26/2008 12:00:00 AM | 3 | 3x3 | 5990170.599330001 | 2111312.57301 | 37.7766952659717 | -122.477540779648 | (37.7766952659717, -122.477540779648) | ||
| 101792 | 101792 | 90334 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1751 Balboa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2008 12:00:00 AM | 1 | 3x3 | 5990179.8300830005 | 2111264.66899 | 37.7765642703859 | -122.47750534597799 | (37.7765642703859, -122.477505345978) | ||
| 104747 | 104747 | 90336 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1751 Balboa St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/22/2013 12:00:00 AM | 1 | 3x3 | 5990179.8300830005 | 2111264.66899 | 37.7765642703859 | -122.47750534597799 | (37.7765642703859, -122.477505345978) | ||
| 127566 | 127566 | 90335 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1751 Balboa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2008 12:00:00 AM | 1 | 3x3 | 5990179.8300830005 | 2111264.66899 | 37.7765642703859 | -122.47750534597799 | (37.7765642703859, -122.477505345978) | ||
| 115510 | 115510 | 90185 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1720 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/26/2008 12:00:00 AM | 3 | 3x3 | 5990201.353999999 | 2111313.50618 | 37.77669961279479 | -122.477434459536 | (37.7766996127948, -122.477434459536) | ||
| 147286 | 147286 | 122276 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1718 Balboa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5990220.4447099995 | 2111314.15807 | 37.7767025104298 | -122.477368467498 | (37.7767025104298, -122.477368467498) | |||
| 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) | ||
| 78597 | 78597 | 48554 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 378 18th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/21/2015 12:00:00 AM | Permit Number 776479 | 5990306.99232217 | 2112830.037025 | 37.7808697161231 | -122.477179880009 | (37.7808697161231, -122.477179880009) | |||
| 124136 | 124136 | 114796 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 719 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/10/2015 12:00:00 AM | Permit Number 775428 | 5990315.8 | 2110460.7 | 37.7743646815998 | -122.476976231877 | (37.7743646815998, -122.476976231877) | |||
| 173375 | 173375 | 122031 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 719 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5990343.842999999 | 2110450.87965 | 37.7743393443985 | -122.47687850925699 | (37.7743393443985, -122.476878509257) | |||
| 77377 | 77377 | 90183 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1650 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/26/2008 12:00:00 AM | 3 | 3x3 | 5990402.31364 | 2111319.28606 | 37.776727141439 | -122.476739710576 | (37.776727141439, -122.476739710576) | ||
| 28415 | 28415 | 90182 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1650 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/26/2008 12:00:00 AM | 3 | 3x3 | 5990417.752119999 | 2111322.65396 | 37.7767372842601 | -122.47668655097799 | (37.7767372842601, -122.476686550978) | ||
| 82289 | 82289 | 90181 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1640 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/26/2008 12:00:00 AM | 3 | 3x3 | 5990451.673780001 | 2111322.99271 | 37.776740181884605 | -122.476569231876 | (37.7767401818846, -122.476569231876) | ||
| 121381 | 121381 | 90180 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1630 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/26/2008 12:00:00 AM | 3 | 3x3 | 5990474.44986 | 2111322.51161 | 37.7767401818998 | -122.476490408326 | (37.7767401818998, -122.476490408326) | ||
| 102298 | 102298 | 90337 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1629 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/22/2013 12:00:00 AM | 3 | 3x3 | 5990482.39564 | 2111267.2104 | 37.7765888008267 | -122.476458881036 | (37.7765888008267, -122.476458881036) | ||
| 47846 | 47846 | 207531 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1325 18th Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5990492.61494 | 2106135.1233599996 | 37.76249807624271 | -122.476048615548 | (37.7624980762427, -122.476048615548) | |||
| 28440 | 28440 | 122307 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1617 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5990526.29521 | 2111270.38864 | 37.7766000733292 | -122.47630725349701 | (37.7766000733292, -122.476307253497) | |||
| 87735 | 87735 | 90339 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1617 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2008 12:00:00 AM | 3 | 3x3 | 5990541.50098 | 2111271.1479 | 37.7766030398525 | -122.476254708345 | (37.7766030398525, -122.476254708345) | ||
| 65443 | 65443 | 122306 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1609 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5990561.02616 | 2111270.9517099997 | 37.7766036334271 | -122.476187151446 | (37.7766036334271, -122.476187151446) | |||
| 116004 | 116004 | 90179 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1612 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/26/2008 12:00:00 AM | 3 | 3x3 | 5990564.13249 | 2111328.53275 | 37.776761915259705 | -122.476180612609 | (37.7767619152597, -122.476180612609) | ||
| 119148 | 119148 | 94155 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1863 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/2010 12:00:00 AM | 3x3 | Permit Number 53541 | 5990589.8 | 2102714.0 | 37.7531102147949 | -122.475462689636 | (37.7531102147949, -122.475462689636) | ||
| 139737 | 139737 | 90338 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1617 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2008 12:00:00 AM | 3 | 3x3 | 5990591.656258 | 2111279.589406 | 37.7766291263166 | -122.47608182516001 | (37.7766291263166, -122.47608182516) | ||
| 81382 | 81382 | 112862 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1732 ULLOA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 5990594.0 | 2098423.0 | 37.7413284897401 | -122.47513493887301 | (37.7413284897401, -122.475134938873) | |||
| 26575 | 26575 | 207688 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1732 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5990596.01765 | 2098405.20532 | 37.7412797470716 | -122.47512666388799 | (37.7412797470716, -122.475126663888) | |||
| 76788 | 76788 | 207577 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1863 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5990606.99166 | 2102703.3769 | 37.753082043103596 | -122.475402462551 | (37.7530820431036, -122.475402462551) | |||
| 128917 | 128917 | 90340 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1609 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2008 12:00:00 AM | 3 | 3x3 | 5990615.55567 | 2111280.455278 | 37.7766328895552 | -122.475999214233 | (37.7766328895552, -122.475999214233) | ||
| 50142 | 50142 | 207671 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1734 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5990626.77188 | 2103577.88918 | 37.7554843697179 | -122.475397903889 | (37.7554843697179, -122.475397903889) | |||
| 82340 | 82340 | 37491 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1653 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1998 12:00:00 AM | Permit Number 39960 | 5990646.15475208 | 2106518.49529305 | 37.7635596145943 | -122.47554557705799 | (37.7635596145943, -122.475545577058) | ||
| 138710 | 138710 | 115293 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2167 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2016 12:00:00 AM | Permit Number 776197 | 5990660.3 | 2100644.0 | 37.7474306230823 | -122.47506779234502 | (37.7474306230823, -122.475067792345) | |||
| 33927 | 33927 | 207670 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1946 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5990672.18333 | 2102133.32849 | 37.751520618601106 | -122.475135407975 | (37.7515206186011, -122.475135407975) | |||
| 103191 | 103191 | 50911 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1946 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/2004 12:00:00 AM | Permit Number 47414 | 5990675.27966813 | 2102143.29452462 | 37.751548162175006 | -122.47512542803001 | (37.751548162175, -122.47512542803) | ||
| 82155 | 82155 | 64881 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1732 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/22/1989 12:00:00 AM | 10 | 3X3 | Permit Number 25903 | 5990675.59164589 | 2098407.0770941004 | 37.741289498102105 | -122.474851664533 | (37.7412894981021, -122.474851664533) |
| 48360 | 48360 | 207679 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2167 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5990677.2269 | 2100653.21825 | 37.7474569149997 | -122.475009933665 | (37.7474569149997, -122.475009933665) | |||
| 93781 | 93781 | 37489 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1639 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1998 12:00:00 AM | Permit Number 39958 | 5990687.69704484 | 2106519.91830078 | 37.763565929909895 | -122.47540200080401 | (37.7635659299099, -122.475402000804) | ||
| 103190 | 103190 | 90341 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1551X Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/22/2013 12:00:00 AM | 3 | 3x3 | 5990704.93298 | 2111272.88253 | 37.7766172788416 | -122.47568948210501 | (37.7766172788416, -122.475689482105) | ||
| 110098 | 110098 | 64850 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2419 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1989 12:00:00 AM | Permit Number 25865 | 5990734.04742599 | 2098925.10305057 | 37.74271525125079 | -122.474687346453 | (37.7427152512508, -122.474687346453) | ||
| 144313 | 144313 | 64849 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2427 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1989 12:00:00 AM | Permit Number 25864 | 5990735.82464568 | 2098873.0190570997 | 37.7425723450195 | -122.474677400881 | (37.7425723450195, -122.474677400881) | ||
| 144873 | 144873 | 64883 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2431 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/22/1989 12:00:00 AM | Permit Number 25908 | 5990736.71325553 | 2098846.97706037 | 37.7425008919022 | -122.474672428109 | (37.7425008919022, -122.474672428109) | ||
| 33452 | 33452 | 207684 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2419 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5990737.5825 | 2098918.54589 | 37.7426974518186 | -122.474674644836 | (37.7426974518186, -122.474674644836) | |||
| 171465 | 171465 | 101127 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1500 Clement St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 5990738.2441 | 2113419.6790299998 | 37.7825137204538 | -122.475731055208 | (37.7825137204538, -122.475731055208) | |||
| 56710 | 56710 | 207685 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2431 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5990740.98987 | 2098842.82853 | 37.7424897489131 | -122.47465733828501 | (37.7424897489131, -122.474657338285) | |||
| 121053 | 121053 | 64892 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2451 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/1989 12:00:00 AM | Permit Number 25918 | 5990741.15630477 | 2098716.76707671 | 37.7421436262999 | -122.47464756439301 | (37.7421436262999, -122.474647564393) | ||
| 26513 | 26513 | 207686 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2451 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5990741.806609999 | 2098714.09627 | 37.742136330634 | -122.474645120982 | (37.742136330634, -122.474645120982) | |||
| 80107 | 80107 | 90178 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1542 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/26/2008 12:00:00 AM | 3 | 3x3 | 5990743.86008 | 2111332.6529200003 | 37.7767836486034 | -122.475559188643 | (37.7767836486034, -122.475559188643) | ||
| 140526 | 140526 | 51547 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2475 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/01/2005 12:00:00 AM | Permit Number 47846 | 5990746.48796302 | 2098560.51512066 | 37.7417149076087 | -122.47461772825301 | (37.7417149076087, -122.474617728253) | ||
| 127406 | 127406 | 64890 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2479 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/1989 12:00:00 AM | Permit Number 25916 | 5990747.37657328 | 2098534.47311176 | 37.741643454445295 | -122.47461275559401 | (37.7416434544453, -122.474612755594) | ||
| 185386 | 185386 | 207687 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2479 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5990748.39034 | 2098537.74279 | 37.7416524908805 | -122.474609488939 | (37.7416524908805, -122.474609488939) | |||
| 43044 | 43044 | 101126 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1500 Clement St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 5990758.62584 | 2113423.68557 | 37.7825259029155 | -122.47566083662 | (37.7825259029155, -122.47566083662) | |||
| 139465 | 139465 | 90177 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1542 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/26/2008 12:00:00 AM | 3 | 3x3 | 5990761.33941 | 2111332.28389 | 37.776783648613794 | -122.475498696085 | (37.7767836486138, -122.475498696085) | ||
| 132491 | 132491 | 207683 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2430 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5990785.45213 | 2098828.98971 | 37.7424543273065 | -122.474502592844 | (37.7424543273065, -122.474502592844) | |||
| 66576 | 66576 | 68236 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1515 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/27/1993 12:00:00 AM | 9 | Permit Number 32031 | 5990787.04658 | 2113362.94185 | 37.7823607651124 | -122.47555807743099 | (37.7823607651124, -122.475558077431) | |
| 148939 | 148939 | 207682 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2462 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5990792.7433 | 2098630.33856 | 37.741909304862794 | -122.474462888654 | (37.7419093048628, -122.474462888654) | |||
| 82767 | 82767 | 90176 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1528 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/17/2016 07:32:00 AM | 3 | 3x3 | 5990794.25741 | 2111335.28271 | 37.776793790701 | -122.47538504305 | (37.776793790701, -122.47538504305) | ||
| 47807 | 47807 | 101124 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1500 Clement St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 5990795.23328 | 2113422.41957 | 37.782524549011704 | -122.47553409958599 | (37.7825245490117, -122.475534099586) | |||
| 142458 | 142458 | 64891 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2462 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/1989 12:00:00 AM | Permit Number 25917 | 5990795.79188789 | 2098640.41442028 | 37.741937147211 | -122.47445308286699 | (37.741937147211, -122.474453082867) | ||
| 184408 | 184408 | 101123 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1500 Clement St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 5990813.05778 | 2113422.53635 | 37.78252590291729 | -122.475472443708 | (37.7825259029173, -122.475472443708) | |||
| 150522 | 150522 | 95601 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 131 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/03/2011 12:00:00 AM | 2 | Permit Number 767201 | 5990817.89228 | 2114523.5069 | 37.78554914201 | -122.475536133375 | (37.78554914201, -122.475536133375) | ||
| 128592 | 128592 | 90343 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1521 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2008 12:00:00 AM | 3 | 3x3 | 5990837.83753 | 2111277.85575 | 37.776638638059296 | -122.47523009442101 | (37.7766386380593, -122.475230094421) | ||
| 147331 | 147331 | 207534 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1531 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5990839.1284300005 | 2104968.89337 | 37.7593160059549 | -122.474765039286 | (37.7593160059549, -122.474765039286) | |||
| 149397 | 149397 | 207535 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1531 17th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5990841.25621 | 2104949.97528 | 37.7592641852056 | -122.47475629966499 | (37.7592641852056, -122.474756299665) | |||
| 137434 | 137434 | 207689 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2686 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5990843.09068 | 2097123.05577 | 37.7377736096576 | -122.474178849468 | (37.7377736096576, -122.474178849468) | |||
| 169627 | 169627 | 101129 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 295X 16th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 5990852.81168 | 2113469.73907 | 37.782657812852705 | -122.47533836119699 | (37.7826578128527, -122.475338361197) | |||
| 116129 | 116129 | 88379 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 351 16th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51357 | 5990853.6 | 2113045.1 | 37.7814919173335 | -122.475304621963 | (37.7814919173335, -122.475304621963) | |||
| 87063 | 87063 | 100358 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 295X 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5990859.3 | 2113441.8 | 37.782581476001 | -122.475313874173 | (37.782581476001, -122.475313874173) | ||||
| 120890 | 120890 | 100359 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 295X 16th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2012 12:00:00 AM | 3x3 | 5990859.3 | 2113441.8 | 37.782581476001 | -122.475313874173 | (37.782581476001, -122.475313874173) | |||
| 124608 | 124608 | 90175 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1500X Balboa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/26/2008 12:00:00 AM | 3 | 3x3 | 5990861.10816 | 2111339.14839 | 37.776808279582895 | -122.47515407091998 | (37.7768082795829, -122.47515407092) | ||
| 70462 | 70462 | 81627 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 351 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3 | 5990871.84274 | 2113035.63499 | 37.781466986417605 | -122.475240820306 | (37.7814669864176, -122.475240820306) | |||
| 103841 | 103841 | 90174 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1500X Balboa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/26/2008 12:00:00 AM | 3 | 3x3 | 5990878.07998 | 2111339.8457299997 | 37.7768111779313 | -122.475095411818 | (37.7768111779313, -122.475095411818) | ||
| 96330 | 96330 | 90173 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1500X Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/26/2008 12:00:00 AM | 3 | 3x3 | 5990892.89979 | 2111339.00513 | 37.7768097287694 | -122.475044084791 | (37.7768097287694, -122.475044084791) | ||
| 48566 | 48566 | 90172 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1500X Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/26/2008 12:00:00 AM | 3 | 3x3 | 5990908.22712 | 2111337.0984900002 | 37.7768053819444 | -122.474990924283 | (37.7768053819444, -122.474990924283) | ||
| 183991 | 183991 | 207532 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1638 17th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5990908.40478 | 2104231.6006400003 | 37.757295609713005 | -122.474471644475 | (37.757295609713, -122.474471644475) | |||
| 66992 | 66992 | 207533 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1638 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5990908.41918 | 2104245.94994 | 37.7573350099278 | -122.474472641826 | (37.7573350099278, -122.474472641826) | |||
| 138265 | 138265 | 88556 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 623 16th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2008 12:00:00 AM | 3x3 | Permit Number 51501 | 5990912.1 | 2111136.5 | 37.776254817936504 | -122.47496288065201 | (37.7762548179365, -122.474962880652) | |||
| 110679 | 110679 | 50894 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1638 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/2004 12:00:00 AM | Permit Number 47404 | 5990914.17502957 | 2104244.6173878997 | 37.7573316845763 | -122.47445263879 | (37.7573316845763, -122.47445263879) | ||
| 117901 | 117901 | 50895 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1638 17th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/2004 12:00:00 AM | Permit Number 47404 | 5990914.17502957 | 2104244.6173878997 | 37.7573316845763 | -122.47445263879 | (37.7573316845763, -122.47445263879) | ||
| 54290 | 54290 | 56166 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 623 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/03/1973 12:00:00 AM | 6 | Permit Number 12274 | 5990937.74428 | 2111139.59084 | 37.7762647906594 | -122.474874396612 | (37.7762647906594, -122.474874396612) | ||
| 149745 | 149745 | 56170 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 657 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/03/1973 12:00:00 AM | 3 | Permit Number 12278 | 5990945.58459 | 2110914.19297 | 37.7756463641696 | -122.474830819328 | (37.7756463641696, -122.474830819328) |
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");