trees
340 rows where Police Districts = 3 and qSpecies_id = 8 sorted by TreeID
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 54558 | 102355 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 176X Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6012524.1 | 2106651 | 37.7651674211522 | -122.399885503722 | (37.7651674211522, -122.399885503722) | 14 | 3 | 8 | 28856 | 20 | |||||
| 89001 | 102356 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 176X Wisconsin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6012524.1 | 2106651 | 37.7651674211522 | -122.399885503722 | (37.7651674211522, -122.399885503722) | 14 | 3 | 8 | 28856 | 20 | |||||
| 119510 | 102645 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1800 Oakdale Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/16/2015 12:33:00 PM | 3 | 3x3 | 6013980.4 | 2096382.2 | 37.7370525675082 | -122.394129514082 | (37.7370525675082, -122.394129514082) | 10 | 3 | 8 | 58 | 1 | ||
| 187500 | 103915 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1300X Fitzgerald Ave | 2 | 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 | |||
| 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 | |||
| 76198 | 103919 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1300X Fitzgerald Ave | 6 | 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 | |||
| 179325 | 103921 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1300X Fitzgerald Ave | 8 | 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 | |||
| 159416 | 103923 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1300X Fitzgerald Ave | 10 | 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 | |||
| 78139 | 106892 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 629 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2014 12:00:00 AM | 1 | Permit Number 773229 | 6014439.75654 | 2104200.5982 | 37.7585457626959 | -122.393088190163 | (37.7585457626959, -122.393088190163) | 10 | 3 | 8 | 28856 | 29 | ||
| 154897 | 111560 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1498x Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6011715.03072 | 2101496.45297 | 37.7509690365089 | -122.402321443274 | (37.7509690365089, -122.402321443274) | 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 | |
| 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 | |||
| 91138 | 114442 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 140 LOOMIS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6010781 | 2097775 | 37.7406985517125 | -122.405289390042 | (37.7406985517125, -122.405289390042) | 10 | 3 | 8 | 58 | 1 | ||||
| 64253 | 114443 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 140 LOOMIS ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6010781 | 2097775 | 37.7406985517125 | -122.405289390042 | (37.7406985517125, -122.405289390042) | 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 | ||||
| 99511 | 114445 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 140 LOOMIS ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6010781 | 2097775 | 37.7406985517125 | -122.405289390042 | (37.7406985517125, -122.405289390042) | 10 | 3 | 8 | 58 | 1 | ||||
| 148937 | 114446 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 367 BAY SHORE BLVD | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6010572 | 2098095 | 37.7415655155901 | -122.406034574078 | (37.7415655155901, -122.406034574078) | 10 | 3 | 8 | 58 | 1 | ||||
| 149422 | 114447 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 367 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 4x4 | 6010564.67556 | 2098126.12029 | 37.7416505555295 | -122.406062091517 | (37.7416505555295, -122.406062091517) | 10 | 3 | 8 | 58 | 1 | |||
| 172911 | 114448 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 367 BAY SHORE BLVD | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6010572 | 2098095 | 37.7415655155901 | -122.406034574078 | (37.7415655155901, -122.406034574078) | 10 | 3 | 8 | 58 | 1 | ||||
| 120511 | 114551 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 815 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/2015 12:00:00 AM | 2 | Permit Number 777069 | 6011882.52063 | 2104552.93824 | 37.759370822322 | -122.401957083855 | (37.759370822322, -122.401957083855) | 10 | 3 | 8 | 28856 | 29 | ||
| 126441 | 117136 | Section 143 10 | Eriobotrya deflexa :: Bronze Loquat 8 | 2203x NEWCOMB AVE | 1 | 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 | |
| 143699 | 117137 | Section 143 10 | Eriobotrya deflexa :: Bronze Loquat 8 | 2203x NEWCOMB AVE | 2 | 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 | |
| 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 | |
| 167623 | 117139 | Section 143 10 | Eriobotrya deflexa :: Bronze Loquat 8 | 2203x NEWCOMB AVE | 4 | 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 | |
| 90738 | 117140 | Section 143 10 | Eriobotrya deflexa :: Bronze Loquat 8 | 2203x NEWCOMB AVE | 5 | 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 | |
| 154253 | 117141 | Section 143 10 | Eriobotrya deflexa :: Bronze Loquat 8 | 2203x NEWCOMB AVE | 6 | 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 | |
| 140065 | 117142 | Section 143 10 | Eriobotrya deflexa :: Bronze Loquat 8 | 2203x NEWCOMB AVE | 7 | 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 | |
| 55582 | 117143 | Section 143 10 | Eriobotrya deflexa :: Bronze Loquat 8 | 2203x NEWCOMB AVE | 8 | 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 | |
| 172332 | 117144 | Section 143 10 | Eriobotrya deflexa :: Bronze Loquat 8 | 2203x NEWCOMB AVE | 9 | 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 | |
| 114728 | 117145 | Section 143 10 | Eriobotrya deflexa :: Bronze Loquat 8 | 2203x NEWCOMB AVE | 10 | 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | ||
| 140260 | 15015 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 650 Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/14/2014 12:00:00 AM | 6 | 3x3 | 6016271.14274 | 2097128.24206 | 37.7392281047953 | -122.386261308815 | (37.7392281047953, -122.386261308815) | 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 | ||
| 192708 | 15051 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1137 Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/20/2000 12:00:00 AM | 3 | 8X18 | 6015459.2819 | 2095972.4779 | 37.736009641441 | -122.388987711638 | (37.736009641441, -122.388987711638) | 10 | 3 | 8 | 58 | 1 | ||
| 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 | ||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||
| 46455 | 17169 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1221X Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/10/2007 12:00:00 AM | 3 | 3x3 | 6017071.13101 | 2093953.96501 | 37.7305564196556 | -122.383274387156 | (37.7305564196556, -122.383274387156) | 10 | 3 | 8 | 58 | 1 | ||
| 163425 | 17171 | Permitted Site 7 | Eriobotrya deflexa :: Bronze Loquat 8 | 1221X Oakdale Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/10/2007 12:00:00 AM | 3 | 3x3 | 6017100.78201 | 2093930.01601 | 37.7304922989818 | -122.383170211952 | (37.7304922989818, -122.383170211952) | 10 | 3 | 8 | 58 | 1 | ||
| 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 | |||
| 72397 | 176240 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 901 Olmstead St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009052.31678 | 2090410.35877 | 37.7203800198047 | -122.41074656201 | (37.7203800198047, -122.41074656201) | 9 | 3 | 7 | 309 | 28 | |||
| 140001 | 176241 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 901 Olmstead St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009064.84821 | 2090413.67882 | 37.7203898385876 | -122.410703479104 | (37.7203898385876, -122.410703479104) | 9 | 3 | 7 | 309 | 28 | |||
| 81467 | 176242 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 901 Olmstead St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6009078.67243 | 2090418.23511 | 37.7204031242939 | -122.41065601467 | (37.7204031242939, -122.41065601467) | 9 | 3 | 7 | 309 | 28 | |||
| 149129 | 176262 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 56 University St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6007768.4416 | 2093799.07984 | 37.7296126542007 | -122.415424294819 | (37.7296126542007, -122.415424294819) | 9 | 3 | 7 | 309 | 28 | |||
| 87986 | 176263 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 728 Burrows St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009121.13665 | 2092884.06532 | 37.7271761560436 | -122.410683275834 | (37.7271761560436, -122.410683275834) | 9 | 3 | 7 | 309 | 28 | |||
| 145332 | 176264 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 165 Brussels St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6010291.19923 | 2093895.21089 | 37.7300180820504 | -122.406709588991 | (37.7300180820504, -122.406709588991) | 10 | 3 | 7 | 309 | 28 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 139174 | 189244 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 690 Texas St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780809 | 6013923.09543 | 2103892.83973 | 37.7576720101792 | -122.394853496397 | (37.7576720101792, -122.394853496397) | 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 3646 | 189251 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 120 Loomis St | 1 | : | Tree | Private 2 | 1 | Width 4ft | 6010844.92077 | 2097998.29295 | 37.7413152397136 | -122.405084094075 | (37.7413152397136, -122.405084094075) | 10 | 3 | 8 | 58 | 1 | |||
| 31692 | 189252 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 120 Loomis St | 2 | : | Tree | Private 2 | 1 | Width 4ft | 6010838.98568 | 2097984.08803 | 37.7412759042668 | -122.40510361565 | (37.7412759042668, -122.40510361565) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 194119 | 191080 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 901 24th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6015525.99309 | 2102510.04982 | 37.7539641575461 | -122.389213417992 | (37.7539641575461, -122.389213417992) | 10 | 3 | 8 | 28856 | 29 | |||
| 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 | |||
| 108786 | 191082 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 901 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6015413.33991 | 2102503.20842 | 37.7539391266996 | -122.389602524941 | (37.7539391266996, -122.389602524941) | 10 | 3 | 8 | 28856 | 29 | |||
| 186400 | 191083 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1050 18th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | 6014452.20409 | 2105784.61715 | 37.7628958266015 | -122.39315597749 | (37.7628958266015, -122.39315597749) | 14 | 3 | 8 | 28856 | 29 | ||||
| 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 | ||||
| 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 | ||||
| 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 | |||
| 124140 | 191087 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1050 18th St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 6014377.05875 | 2105781.79588 | 37.762883905197 | -122.393415683687 | (37.762883905197, -122.393415683687) | 14 | 3 | 8 | 28856 | 29 | ||||
| 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 | ||||
| 141839 | 191089 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 150 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6012552.52179 | 2106660.8958 | 37.7651961772892 | -122.399787893906 | (37.7651961772892, -122.399787893906) | 14 | 3 | 8 | 28856 | 20 | |||
| 161565 | 191090 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 150 Wisconsin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6012554.60334 | 2106645.79178 | 37.765154821059 | -122.399779633629 | (37.765154821059, -122.399779633629) | 14 | 3 | 8 | 28856 | 20 | |||
| 140307 | 191091 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 150 Wisconsin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6012554.29768 | 2106630.73656 | 37.7651134657424 | -122.399779633617 | (37.7651134657424, -122.399779633617) | 14 | 3 | 8 | 28856 | 20 | |||
| 55558 | 191092 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 299 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6014058.4688 | 2105768.40922 | 37.7628294422497 | -122.394516646351 | (37.7628294422497, -122.394516646351) | 14 | 3 | 8 | 28856 | 29 | |||
| 141928 | 191093 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 1951 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6012569.60579 | 2102821.43848 | 37.7546548260739 | -122.399459231268 | (37.7546548260739, -122.399459231268) | 10 | 3 | 8 | 28856 | 29 |
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) );