trees
340 rows where Police Districts = 3 and qSpecies_id = 8
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10 | 264794 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 31 Dwight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2020 12:00:00 AM | 3 | 3x3 | 6011433 | 2091603 | 37.7237879639177 | -122.40260109208 | (37.7237879639177, -122.40260109208) | 10 | 3 | 7 | 309 | 28 | ||
| 32 | 264850 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 172 University St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2020 12:00:00 AM | 3 | 6007951 | 2093149 | 37.7278379340298 | -122.414747181337 | (37.7278379340298, -122.414747181337) | 9 | 3 | 7 | 309 | 5 | |||
| 806 | 189267 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1300 Fairfax Ave | 6 | : | Tree | Private 2 | 1 | Width 4ft | 6017011.55747 | 2097196.03632 | 37.7394552087924 | -122.383705980546 | (37.7394552087924, -122.383705980546) | 10 | 3 | 8 | 58 | 1 | |||
| 1268 | 261097 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1999 Carroll Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2019 12:00:00 AM | 3 | 4x6 | 6012390 | 2093339 | 37.7286080475288 | -122.399414697344 | (37.7286080475288, -122.399414697344) | 10 | 3 | 8 | 58 | 1 | ||
| 1530 | 191101 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2041 26th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6012369.93883 | 2101402.46492 | 37.7507475020033 | -122.400050093052 | (37.7507475020033, -122.400050093052) | 10 | 3 | 8 | 28856 | 1 | |||
| 1793 | 260413 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1510 Jerrold Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6015825 | 2096697 | 37.7380192974637 | -122.387773802776 | (37.7380192974637, -122.387773802776) | 10 | 3 | 8 | 58 | 1 | ||||
| 1997 | 61779 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2227 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/1985 12:00:00 AM | 9 | Permit Number 21800 | 6011831.44367 | 2102306.03776 | 37.7531984774519 | -122.401975779864 | (37.7531984774519, -122.401975779864) | 10 | 3 | 8 | 28856 | 29 | |
| 2148 | 154032 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1662 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6014879.40227 | 2097032.81009 | 37.7388889362706 | -122.391066694069 | (37.7388889362706, -122.391066694069) | 10 | 3 | 8 | 58 | 1 | |||
| 2999 | 94036 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1300X Lane St | 4 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/14/2019 09:52:00 AM | 3 | 5x5 | 6015673.325 | 2095216.0053 | 37.7339443827642 | -122.388194894968 | (37.7339443827642, -122.388194894968) | 10 | 3 | 8 | 58 | 1 | |
| 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 | |||
| 3755 | 200657 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1520 Oakdale Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6015286.398 | 2095330.3246 | 37.7342368342044 | -122.389540612503 | (37.7342368342044, -122.389540612503) | 10 | 3 | 8 | 58 | 1 | |||
| 4551 | 189261 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2215 Newcomb Ave | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6011901.66973 | 2098145.68488 | 37.7417789652237 | -122.401440561855 | (37.7417789652237, -122.401440561855) | 10 | 3 | 8 | 58 | 1 | |||
| 4634 | 61780 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2127 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/1985 12:00:00 AM | 9 | Permit Number 21802 | 6012087.28443 | 2102320.53166 | 37.7532525500908 | -122.401092043975 | (37.7532525500908, -122.401092043975) | 10 | 3 | 8 | 28856 | 29 | |
| 5283 | 71380 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1415 Lane St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6015545.815 | 2094978.0232 | 37.7332838660921 | -122.388619133184 | (37.7332838660921, -122.388619133184) | 10 | 3 | 8 | 58 | 1 | |||
| 5548 | 64543 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1547 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/1988 12:00:00 AM | Permit Number 25426 | 6015321.62159268 | 2095235.25021997 | 37.7339777321734 | -122.389412195042 | (37.7339777321734, -122.389412195042) | 10 | 3 | 8 | 58 | 1 | ||
| 6010 | 162250 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 40 Olmstead St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/2020 12:00:00 AM | 3 | Width 0ft | 6011508.76761 | 2091210.5075 | 37.7227144898747 | -122.402311591215 | (37.7227144898747, -122.402311591215) | 10 | 3 | 7 | 309 | 28 | ||
| 6046 | 81390 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1588 Indiana St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6015103.68734 | 2101191.55999 | 37.750320442739 | -122.390581737352 | (37.750320442739, -122.390581737352) | 10 | 3 | 8 | 28856 | 1 | |||
| 6256 | 25549 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 141 Industrial St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/24/1998 12:00:00 AM | 3 | 2X3 | 6011617.33955 | 2097194.17651 | 37.739150457318 | -122.402356800142 | (37.739150457318, -122.402356800142) | 10 | 3 | 8 | 58 | 1 | ||
| 6326 | 117138 | Section 143 10 | Eriobotrya deflexa :: Bronze Loquat 8 | 2203x NEWCOMB AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011983 | 2098083 | 37.7416113834488 | -122.4011549432 | (37.7416113834488, -122.4011549432) | 10 | 3 | 8 | 58 | 1 | |
| 7390 | 27682 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 141 Industrial St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/19/2009 12:00:00 AM | 3 | 2X3 | 6011440.5288809 | 2097124.3937126 | 37.738948976933 | -122.402963228074 | (37.738948976933, -122.402963228074) | 10 | 3 | 8 | 58 | 1 | ||
| 8512 | 117149 | Section 806 (d) 5 | Eriobotrya deflexa :: Bronze Loquat 8 | 928 Toland St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011929.15518 | 2097982.19203 | 37.7413315821976 | -122.401334038935 | (37.7413315821976, -122.401334038935) | 10 | 3 | 8 | 58 | 1 | |
| 8525 | 117146 | Section 806 (d) 5 | Eriobotrya deflexa :: Bronze Loquat 8 | 928 Toland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011982.52405 | 2098055.99364 | 37.741537203178 | -122.401154691646 | (37.741537203178, -122.401154691646) | 10 | 3 | 8 | 58 | 1 | |
| 9764 | 150815 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 640 Texas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6013813.37874 | 2104087.70708 | 37.7582009725247 | -122.395246594574 | (37.7582009725247, -122.395246594574) | 10 | 3 | 8 | 28856 | 29 | |||
| 10285 | 64550 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1407 Lane St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/1988 12:00:00 AM | 9 | Permit Number 25433 | 6015557.9064 | 2094994.5115 | 37.7333298097375 | -122.388578480063 | (37.7333298097375, -122.388578480063) | 10 | 3 | 8 | 58 | 1 | |
| 10433 | 189238 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2126 24th St | 1 | : | Tree | Private 2 | 13 | Width 3ft | 6012108.67622 | 2102369.63804 | 37.75338857883 | -122.401021516451 | (37.75338857883, -122.401021516451) | 10 | 3 | 8 | 28856 | 29 | |||
| 10674 | 117147 | Section 806 (d) 5 | Eriobotrya deflexa :: Bronze Loquat 8 | 928 Toland St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011972.25416 | 2098042.58697 | 37.7414998183769 | -122.40118925978 | (37.7414998183769, -122.40118925978) | 10 | 3 | 8 | 58 | 1 | |
| 11137 | 46998 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2011 26th St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2002 12:00:00 AM | Permit Number 44999 | 6012426.60175733 | 2101420.79231292 | 37.7508009841444 | -122.399855433268 | (37.7508009841444, -122.399855433268) | 10 | 3 | 8 | 28856 | 1 | |||
| 11488 | 71394 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1549 Kirkwood Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 15 | 6015490.02353 | 2096504.22569 | 37.7374714167655 | -122.388918537456 | (37.7374714167655, -122.388918537456) | 10 | 3 | 8 | 58 | 1 | |||
| 11677 | 26000 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1715 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/25/2012 12:00:00 AM | 3 | 3x3 | 6014353.43695 | 2095957.87317 | 37.7359081801195 | -122.39281007034 | (37.7359081801195, -122.39281007034) | 10 | 3 | 8 | 58 | 1 | ||
| 11678 | 262547 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1329 Egbert Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/20/2020 12:00:00 AM | Width 0ft | 6014600.2068 | 2090881.6643 | 37.7219836364279 | -122.391602089471 | (37.7219836364279, -122.391602089471) | 10 | 3 | 8 | 58 | 1 | |||
| 11903 | 73567 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1549 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 17 | 6015475.76559 | 2096515.71199 | 37.7375021654981 | -122.388968635992 | (37.7375021654981, -122.388968635992) | 10 | 3 | 8 | 58 | 1 | |||
| 12361 | 61778 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2219 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/1985 12:00:00 AM | 13 | Permit Number 21799 | 6011858.65617 | 2102307.02304 | 37.7532027015499 | -122.401881742259 | (37.7532027015499, -122.401881742259) | 10 | 3 | 8 | 28856 | 29 | |
| 13100 | 176239 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 901 Olmstead St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009040.83689 | 2090406.80665 | 37.7203696227506 | -122.410785993677 | (37.7203696227506, -122.410785993677) | 9 | 3 | 7 | 309 | 28 | |||
| 13864 | 38641 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1595 Shafter Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | 16 | 4x10 | Permit Number 40566 | 6014964.8748 | 2094103.3153 | 37.7308498822776 | -122.39056651931 | (37.7308498822776, -122.39056651931) | 10 | 3 | 8 | 58 | 1 |
| 14120 | 11922 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 620X Keith St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/10/2016 12:00:00 AM | 3 | 3X4 | 6017350.6902257 | 2096387.6229349 | 37.7372542074531 | -122.382477163454 | (37.7372542074531, -122.382477163454) | 10 | 3 | 8 | 58 | 1 | ||
| 15768 | 61783 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2104 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/1985 12:00:00 AM | 13 | Permit Number 21805 | 6012173.04745 | 2102374.48428 | 37.7534054761945 | -122.400799246287 | (37.7534054761945, -122.400799246287) | 10 | 3 | 8 | 28856 | 29 | |
| 16058 | 111561 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1498x Kansas St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/28/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779654 | 6011715.78319 | 2101470.38867 | 37.7508975116216 | -122.402317008737 | (37.7508975116216, -122.402317008737) | 10 | 3 | 8 | 28856 | 29 | |
| 16994 | 261098 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1999 Carroll Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2019 12:00:00 AM | 3 | 4x6 | 6012390 | 2093339 | 37.7286080475288 | -122.399414697344 | (37.7286080475288, -122.399414697344) | 10 | 3 | 8 | 58 | 1 | ||
| 18014 | 117148 | Section 806 (d) 5 | Eriobotrya deflexa :: Bronze Loquat 8 | 928 Toland St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011961.8463 | 2098027.63913 | 37.7414581941431 | -122.401224196662 | (37.7414581941431, -122.401224196662) | 10 | 3 | 8 | 58 | 1 | |
| 19092 | 150813 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 25 Sierra St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6013747.19893 | 2104113.81693 | 37.758268983752 | -122.395477303948 | (37.758268983752, -122.395477303948) | 10 | 3 | 8 | 28856 | 29 | |||
| 19307 | 191107 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2021 26th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6012536.97765 | 2101462.04256 | 37.7509204011789 | -122.399476636765 | (37.7509204011789, -122.399476636765) | 10 | 3 | 8 | 28856 | 1 | |||
| 19885 | 191110 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2251 24th St | 3 | : | Tree | Private 2 | 7 | Width 3ft | 6011791.4986 | 2102301.92631 | 37.7531849588319 | -122.40211362974 | (37.7531849588319, -122.40211362974) | 10 | 3 | 8 | 28856 | 29 | |||
| 20316 | 200101 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1528 Yosemite Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6015012.674 | 2092395.4762 | 37.7261631500088 | -122.39028199338 | (37.7261631500088, -122.39028199338) | 10 | 3 | 8 | 58 | 1 | |||
| 21036 | 26579 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 241 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/22/1998 12:00:00 AM | 6 | 3X3 | 6011098.44545 | 2099048.11598 | 37.7442119973787 | -122.40428136282 | (37.7442119973787, -122.40428136282) | 10 | 3 | 8 | 58 | 1 | ||
| 22344 | 189270 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 59 Robblee Ave | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6012477.87962 | 2095853.3507 | 37.735516831132 | -122.39928732315 | (37.735516831132, -122.39928732315) | 10 | 3 | 8 | 58 | 1 | |||
| 23656 | 191084 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1050 18th St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | 6014440.03961 | 2105781.9689 | 37.7628878793072 | -122.393197865211 | (37.7628878793072, -122.393197865211) | 14 | 3 | 8 | 28856 | 29 | ||||
| 24039 | 189257 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2231 Newcomb Ave | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6011833.55798 | 2098197.58892 | 37.7419176820557 | -122.40167971856 | (37.7419176820557, -122.40167971856) | 10 | 3 | 8 | 58 | 1 | |||
| 24529 | 27530 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1898X Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 5 | 3X3 | 6013528.91672 | 2096649.27619 | 37.7377607988237 | -122.395709213912 | (37.7377607988237, -122.395709213912) | 10 | 3 | 8 | 58 | 1 | |||
| 25666 | 84783 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 280 Charter Oak Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2007 12:00:00 AM | 7 | Permit No. 49320 | 6010967.59518 | 2095106.34893 | 37.7333814341037 | -122.404456411357 | (37.7333814341037, -122.404456411357) | 10 | 3 | 8 | 58 | 1 | ||
| 27617 | 26468 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 300X Keith St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/04/1998 12:00:00 AM | 3 | 3X3 | 6017600.4401851 | 2096710.4383408 | 37.7381543871139 | -122.381636098386 | (37.7381543871139, -122.381636098386) | 10 | 3 | 8 | 58 | 1 | ||
| 28331 | 94753 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 491 Bay Shore Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/28/2010 12:00:00 AM | 5 | 3x3 | 6010359.28963 | 2097585.56035 | 37.7401548048867 | -122.406734163873 | (37.7401548048867, -122.406734163873) | 10 | 3 | 8 | 58 | 1 | ||
| 29467 | 191681 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1241 Oakdale Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6017111.18893 | 2093915.90803 | 37.7304541363294 | -122.383133251796 | (37.7304541363294, -122.383133251796) | 10 | 3 | 8 | 58 | 1 | |||
| 29812 | 99390 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1590 Yosemite Ave | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980856 | -122.390639783135 | (37.726418980856, -122.390639783135) | 10 | 3 | 8 | 58 | 1 | ||
| 30232 | 99397 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1590 Yosemite Ave | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980856 | -122.390639783135 | (37.726418980856, -122.390639783135) | 10 | 3 | 8 | 58 | 1 | ||
| 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 | ||
| 31011 | 189240 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 690 Texas St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6013877.57271 | 2103955.2138 | 37.7578407445781 | -122.39501530244 | (37.7578407445781, -122.39501530244) | 10 | 3 | 8 | 28856 | 29 | |||
| 31365 | 189263 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2211 Newcomb Ave | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6011935.60653 | 2098120.24236 | 37.7417109989595 | -122.401321431357 | (37.7417109989595, -122.401321431357) | 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 | |||
| 32256 | 99396 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1590 Yosemite Ave | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980856 | -122.390639783135 | (37.726418980856, -122.390639783135) | 10 | 3 | 8 | 58 | 1 | ||
| 33358 | 189266 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 550 Bay Shore Blvd | 2 | : | Tree | Private 2 | 9 | Width 4ft | 6010210.57589 | 2097161.88665 | 37.7389831663466 | -122.407218500042 | (37.7389831663466, -122.407218500042) | 10 | 3 | 7 | 58 | 2 | |||
| 33503 | 64537 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1448 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/1988 12:00:00 AM | 4 | Permit Number 25419 | 6015877.1655 | 2094890.2503 | 37.7330612171639 | -122.387467432023 | (37.7330612171639, -122.387467432023) | 10 | 3 | 8 | 58 | 1 | |
| 33794 | 191086 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1050 18th St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 10ft | 6014399.78897 | 2105779.8886 | 37.762879931094 | -122.393336933676 | (37.762879931094, -122.393336933676) | 14 | 3 | 8 | 28856 | 29 | |||
| 34407 | 25915 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1800 Oakdale Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/16/2015 12:17:00 PM | 3 | 3X3 | 6013847.66398 | 2096411.7192 | 37.737126242566 | -122.394590512161 | (37.737126242566, -122.394590512161) | 10 | 3 | 8 | 58 | 1 | ||
| 34932 | 25993 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1789 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/25/2012 12:00:00 AM | 3 | 3x3 | 6014037.23638 | 2096196.21513 | 37.7365450503068 | -122.393919988427 | (37.7365450503068, -122.393919988427) | 10 | 3 | 8 | 58 | 1 | ||
| 35198 | 6735 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1300X Fairfax Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/14/2007 12:00:00 AM | 2 | 3x3 | 6017028.4506 | 2097182.15302 | 37.7394180218109 | -122.383646604615 | (37.7394180218109, -122.383646604615) | 10 | 3 | 8 | 58 | 1 | ||
| 36881 | 46985 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2011 26th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2002 12:00:00 AM | 5 | Permit Number 44999 | 6012611.41785 | 2101473.70376 | 37.7509565692018 | -122.399220032275 | (37.7509565692018, -122.399220032275) | 10 | 3 | 8 | 28856 | 1 | ||
| 37386 | 200715 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1463 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6015932.4229 | 2095126.9778 | 37.7337142836816 | -122.387292898181 | (37.7337142836816, -122.387292898181) | 10 | 3 | 8 | 58 | 1 | |||
| 37859 | 46993 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2011 26th St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2002 12:00:00 AM | Permit Number 44999 | 6012426.60175733 | 2101420.79231292 | 37.7508009841444 | -122.399855433268 | (37.7508009841444, -122.399855433268) | 10 | 3 | 8 | 28856 | 1 | |||
| 38059 | 94750 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 491 Bay Shore Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/28/2010 12:00:00 AM | 4 | 3x3 | 6010344.23931 | 2097413.72179 | 37.7396821311114 | -122.406774094665 | (37.7396821311114, -122.406774094665) | 10 | 3 | 8 | 58 | 1 | ||
| 38088 | 99382 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1590 Yosemite Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980856 | -122.390639783135 | (37.726418980856, -122.390639783135) | 10 | 3 | 8 | 58 | 1 | ||
| 38276 | 52807 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 25@ TEXAS Sierra St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2006 12:00:00 AM | Permit Number 48835 | 6013772.92448179 | 2104112.24559711 | 37.7582661000564 | -122.39538822301 | (37.7582661000564, -122.39538822301) | 10 | 3 | 8 | 28856 | 29 | |||
| 39092 | 189256 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2249 Quesada Ave | 2 | : | Tree | Private 2 | 2 | Width 2ft | 6011764.59549 | 2097191.48709 | 37.7391512918904 | -122.401847463703 | (37.7391512918904, -122.401847463703) | 10 | 3 | 8 | 58 | 1 | |||
| 41340 | 26143 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1500 Oakdale Ave | 13 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 02/08/2003 12:00:00 AM | 3 | 3x3 | 6015586.3934773 | 2095100.209325 | 37.7336216133372 | -122.388487366626 | (37.7336216133372, -122.388487366626) | 10 | 3 | 8 | 58 | 1 | ||
| 41449 | 191683 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1578 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6015394.19835 | 2096650.58881 | 37.7378679881277 | -122.389260070301 | (37.7378679881277, -122.389260070301) | 10 | 3 | 8 | 58 | 1 | |||
| 41732 | 114444 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 140 LOOMIS ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6010781 | 2097775 | 37.7406985517125 | -122.405289390042 | (37.7406985517125, -122.405289390042) | 10 | 3 | 8 | 58 | 1 | ||||
| 41775 | 64530 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1400 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/23/2010 12:00:00 AM | 3 | 20x30 | Permit Number 53955 | 6016100.7066 | 2094719.4549 | 37.7326046257158 | -122.386682678289 | (37.7326046257158, -122.386682678289) | 10 | 3 | 8 | 58 | 1 |
| 42729 | 64533 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1423 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/22/1988 12:00:00 AM | Permit Number 25415 | 6015974.60065069 | 2094744.26862441 | 37.732665776815 | -122.387120391311 | (37.732665776815, -122.387120391311) | 10 | 3 | 8 | 58 | 1 | ||
| 42964 | 52803 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 25@ TEXAS Sierra St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2006 12:00:00 AM | 4 | Permit Number 48835 | 6013662.91964 | 2104110.04081 | 37.7582539273014 | -122.395768516112 | (37.7582539273014, -122.395768516112) | 10 | 3 | 8 | 28856 | 29 | ||
| 43724 | 94755 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 491 Bay Shore Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/28/2010 12:00:00 AM | 4 | 3x3 | 6010386.24454 | 2097752.48777 | 37.7406146597357 | -122.40665272486 | (37.7406146597357, -122.40665272486) | 10 | 3 | 8 | 58 | 1 | ||
| 44058 | 94749 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 491 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/28/2010 12:00:00 AM | 3 | 3x3 | 6010338.73158 | 2097355.97289 | 37.7395232568881 | -122.406789069267 | (37.7395232568881, -122.406789069267) | 10 | 3 | 8 | 58 | 1 | ||
| 44374 | 191081 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 901 24th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6015467.86658 | 2102506.20441 | 37.7539503763268 | -122.389414166444 | (37.7539503763268, -122.389414166444) | 10 | 3 | 8 | 28856 | 29 | |||
| 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 | ||
| 44482 | 191104 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2031 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6012452.22687 | 2101435.1702 | 37.7508418912642 | -122.399767828221 | (37.7508418912642, -122.399767828221) | 10 | 3 | 8 | 28856 | 1 | |||
| 45011 | 26562 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 550 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/14/1999 12:00:00 AM | 6 | 3X3 | 6010221.3990328 | 2097223.1768194 | 37.7391520616783 | -122.407185397649 | (37.7391520616783, -122.407185397649) | 10 | 3 | 7 | 58 | 2 | ||
| 45086 | 25999 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1717 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/22/1997 12:00:00 AM | 3 | 3x3 | 6014332.85691 | 2095971.76656 | 37.7359451854222 | -122.392882195975 | (37.7359451854222, -122.392882195975) | 10 | 3 | 8 | 58 | 1 | ||
| 45437 | 111562 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1498x Kansas St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6011716.74502 | 2101442.02185 | 37.7508196762016 | -122.402311688344 | (37.7508196762016, -122.402311688344) | 10 | 3 | 8 | 28856 | 29 | |||
| 45845 | 94748 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 491 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/28/2010 12:00:00 AM | 5 | 3x3 | 6010334.01877 | 2097301.80143 | 37.7393742500178 | -122.40680154737 | (37.7393742500178, -122.40680154737) | 10 | 3 | 8 | 58 | 1 | ||
| 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 | ||
| 46308 | 191085 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1050 18th St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 6014420.63086 | 2105780.43179 | 37.762882580487 | -122.393264886285 | (37.762882580487, -122.393264886285) | 14 | 3 | 8 | 28856 | 29 | ||||
| 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 | ||
| 46476 | 200656 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1518 Oakdale Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6015329.8173 | 2095300.0959 | 37.734156239682 | -122.389388386574 | (37.734156239682, -122.389388386574) | 10 | 3 | 8 | 58 | 1 | |||
| 47493 | 38141 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 100 Felton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1998 12:00:00 AM | 4 | Permit Number 40298 | 6010551.38823 | 2093805.12649 | 37.7297852835414 | -122.40580373606 | (37.7297852835414, -122.40580373606) | 10 | 3 | 7 | 309 | 28 | |
| 47596 | 189239 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 670 Texas St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 6013865.85822 | 2103972.02889 | 37.7578862637531 | -122.39505699409 | (37.7578862637531, -122.39505699409) | 10 | 3 | 8 | 28856 | 29 | |||
| 47946 | 46990 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 2011 26th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2002 12:00:00 AM | Permit Number 44999 | 6012426.60175733 | 2101420.79231292 | 37.7508009841444 | -122.399855433268 | (37.7508009841444, -122.399855433268) | 10 | 3 | 8 | 28856 | 1 | |||
| 48395 | 99378 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1590 Yosemite Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 1 | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980856 | -122.390639783135 | (37.726418980856, -122.390639783135) | 10 | 3 | 8 | 58 | 1 | |
| 48749 | 103917 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1300X Fitzgerald Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/19/2013 12:00:00 AM | Permit Number 770276 | 6014139.7 | 2090933.3 | 37.7220998454463 | -122.393197569728 | (37.7220998454463, -122.393197569728) | 10 | 3 | 8 | 58 | 1 | |||
| 50009 | 29491 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1628X Ingalls St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/05/2015 07:30:00 AM | 3 | 3x3 | 6016725.73414 | 2093293.65862 | 37.7287242549235 | -122.384422514278 | (37.7287242549235, -122.384422514278) | 10 | 3 | 8 | 58 | 1 | ||
| 50221 | 191111 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2251 24th St | 4 | : | Tree | Private 2 | 11 | Width 4ft | 6011810.68033 | 2102303.0748 | 37.7531891829555 | -122.402047375812 | (37.7531891829555, -122.402047375812) | 10 | 3 | 8 | 28856 | 29 | |||
| 50951 | 200658 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1522 Oakdale Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6015268.8104 | 2095344.6145 | 37.7342750961819 | -122.389602416658 | (37.7342750961819, -122.389602416658) | 10 | 3 | 8 | 58 | 1 | |||
| 51068 | 25548 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 141 Industrial St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/06/2013 12:00:00 AM | 3 | 2x3 | 6011568.62841 | 2097178.44526 | 37.7391045433316 | -122.402524116297 | (37.7391045433316, -122.402524116297) | 10 | 3 | 8 | 58 | 1 |
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) );