trees
340 rows where Police Districts = 3 and qSpecies_id = 8 sorted by qSiteInfo
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 56744 | 189271 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1715 Oakdale Ave | 1 | : | Tree | Private 2 | 3 | Width 3ft | 6014352.7466 | 2095957.7571 | 37.7359078230711 | -122.392812449055 | (37.7359078230711, -122.392812449055) | 10 | 3 | 8 | 58 | 1 | |||
| 63346 | 189260 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2223 Newcomb Ave | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6011881.3428 | 2098161.01193 | 37.7418199158556 | -122.401511923044 | (37.7418199158556, -122.401511923044) | 10 | 3 | 8 | 58 | 1 | |||
| 74782 | 191109 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2251 24th St | 2 | : | Tree | Private 2 | 6 | Width 3ft | 6011772.01455 | 2102301.09153 | 37.7531815791754 | -122.402180951204 | (37.7531815791754, -122.402180951204) | 10 | 3 | 8 | 28856 | 29 | |||
| 79630 | 189255 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2249 Quesada Ave | 1 | : | Tree | Private 2 | 3 | Width 2ft | 6011757.21121 | 2097196.19768 | 37.7391638140674 | -122.401873326395 | (37.7391638140674, -122.401873326395) | 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 | |||
| 88009 | 189269 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1600 Oakdale Ave | 1 | : | Tree | Private 2 | 10 | Width 4ft | 6014890.23079 | 2095625.56683 | 37.7350255350863 | -122.390930927939 | (37.7350255350863, -122.390930927939) | 10 | 3 | 8 | 58 | 1 | |||
| 96628 | 189268 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1721 Oakdale Ave | 2 | : | Tree | Private 2 | 7 | Width 3ft | 6014331.30759 | 2095974.08961 | 37.7359514779837 | -122.39288771511 | (37.7359514779837, -122.39288771511) | 10 | 3 | 8 | 58 | 1 | |||
| 97130 | 189241 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 690 Texas St | 2 | : | Tree | Private 2 | 5 | Width 3ft | 6013889.32799 | 2103940.39875 | 37.7578007193328 | -122.394973609851 | (37.7578007193328, -122.394973609851) | 10 | 3 | 8 | 28856 | 29 | |||
| 98398 | 189247 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1645 Bay Shore Blvd | 3 | : | Tree | Private 2 | 11 | Width 3ft | 6012112.47662 | 2091125.23091 | 37.7225140193029 | -122.400218700647 | (37.7225140193029, -122.400218700647) | 10 | 3 | 8 | 58 | 1 | |||
| 107872 | 189264 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2207 Newcomb Ave | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6011951.89121 | 2098108.45094 | 37.7416795307793 | -122.401264295606 | (37.7416795307793, -122.401264295606) | 10 | 3 | 8 | 58 | 1 | |||
| 138524 | 189243 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 690 Texas St | 4 | : | Tree | Private 2 | 4 | Width 3ft | 6013912.25282 | 2103910.20868 | 37.757719098672 | -122.3948922113 | (37.757719098672, -122.3948922113) | 10 | 3 | 8 | 28856 | 29 | |||
| 139451 | 189250 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1301 Bay Shore Blvd | 4 | : | Tree | Private 2 | 11 | Width 5ft | 6011646.80648 | 2093004.20248 | 37.7276473117623 | -122.401960449138 | (37.7276473117623, -122.401960449138) | 10 | 3 | 8 | 58 | 1 | |||
| 152232 | 189242 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 690 Texas St | 3 | : | Tree | Private 2 | 5 | Width 3ft | 6013899.94699 | 2103926.17826 | 37.7577622634227 | -122.394935888703 | (37.7577622634227, -122.394935888703) | 10 | 3 | 8 | 28856 | 29 | |||
| 161725 | 189248 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1575 Bay Shore Blvd | 13 | : | Tree | Private 2 | 5 | Width 3ft | 6011796.69629 | 2092248.5093 | 37.7255806984826 | -122.401389189886 | (37.7255806984826, -122.401389189886) | 10 | 3 | 8 | 58 | 1 | |||
| 164084 | 191108 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2251 24th St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 6011748.82992 | 2102300.63955 | 37.753179044 | -122.402261096995 | (37.753179044, -122.402261096995) | 10 | 3 | 8 | 28856 | 29 | |||
| 175105 | 189249 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1301 Bay Shore Blvd | 3 | : | Tree | Private 2 | 10 | Width 4ft | 6011651.62195 | 2092980.93303 | 37.7275836874237 | -122.401942166815 | (37.7275836874237, -122.401942166815) | 10 | 3 | 8 | 58 | 1 | |||
| 175686 | 189258 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2231 Newcomb Ave | 2 | : | Tree | Private 2 | 1 | Width 3ft | 6011848.21009 | 2098186.58426 | 37.741888283226 | -122.401628282713 | (37.741888283226, -122.401628282713) | 10 | 3 | 8 | 58 | 1 | |||
| 180956 | 191112 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2121 24th St | 2 | : | Tree | Private 2 | 12 | Width 3ft | 6012137.40992 | 2102323.82129 | 37.7532643788521 | -122.400918929861 | (37.7532643788521, -122.400918929861) | 10 | 3 | 8 | 28856 | 29 | |||
| 186728 | 189259 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2227 Newcomb Ave | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6011864.29034 | 2098174.02921 | 37.7418547070232 | -122.401571799894 | (37.7418547070232, -122.401571799894) | 10 | 3 | 8 | 58 | 1 | |||
| 189133 | 189265 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2203 Newcomb Ave | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6011972.28331 | 2098093.92114 | 37.7416407727111 | -122.40119276536 | (37.7416407727111, -122.40119276536) | 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 | |||
| 189516 | 189262 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 2215 Newcomb Ave | 2 | : | Tree | Private 2 | 1 | Width 3ft | 6011918.91443 | 2098133.46059 | 37.7417463620964 | -122.401380076136 | (37.7417463620964, -122.401380076136) | 10 | 3 | 8 | 58 | 1 | |||
| 190937 | 189272 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1789 Oakdale Ave | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6014048.88892 | 2096189.76773 | 37.7365279946626 | -122.393879249144 | (37.7365279946626, -122.393879249144) | 10 | 3 | 8 | 58 | 1 | |||
| 118388 | 191088 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1 01st St | 19 | : Yard | Tree | Private 2 | 18 | 6014455.34951 | 2105889.69248 | 37.7631845152826 | -122.393152451232 | (37.7631845152826, -122.393152451232) | 14 | 3 | 8 | 28856 | 29 | ||||
| 132994 | 117150 | Section 143 10 | Eriobotrya deflexa :: Bronze Loquat 8 | 928 TOLAND ST | 5 | Front Yard : Cutout | Tree | Private 2 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011950 | 2098029 | 37.7414612698949 | -122.401265252936 | (37.7414612698949, -122.401265252936) | 10 | 3 | 8 | 58 | 1 | |
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |
| 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 | |||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | |
| 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 | |||
| 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 |
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) );