trees
858 rows where qSpecies_id = 85 sorted by Fire Prevention Districts descending
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 161990 | 65601 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 112 Maynard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/1990 12:00:00 AM | 12 | Permit Number 28503 | 6004142.9253 | 2093740.45732 | 37.7292472461511 | -122.427953908572 | (37.7292472461511, -122.427953908572) | 9 | 7 | 6 | 28861 | 5 | |
| 162138 | 179606 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 247 Mount Vernon Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | 5998687.8621 | 2089587.24848 | 37.7175333741492 | -122.446513783285 | (37.7175333741492, -122.446513783285) | 9 | 7 | 6 | 28861 | 25 | ||||
| 162995 | 179609 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 801 Excelsior Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 5ft | 6004359.10354 | 2091527.3039 | 37.7231826445422 | -122.427048992729 | (37.7231826445422, -122.427048992729) | 9 | 7 | 6 | 28861 | 5 | |||
| 163572 | 215175 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 120 Bella Vista Way | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 3ft | 5998426.00188 | 2097089.19076 | 37.7381169869985 | -122.447958731229 | (37.7381169869985, -122.447958731229) | 9 | 7 | 4 | 59 | 40 | |||
| 167348 | 215157 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 494 Victoria St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 6ft | 5993275.20314 | 2090415.1347 | 37.7194959008046 | -122.465282818756 | (37.7194959008046, -122.465282818756) | 9 | 8 | 6 | 64 | 24 | |||
| 168748 | 215150 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 484 Faxon Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 5994798.27726 | 2091789.17136 | 37.7233563935592 | -122.460117638123 | (37.7233563935592, -122.460117638123) | 9 | 8 | 4 | 28861 | 24 | |||
| 171325 | 215164 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 240 Manor Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5993888.62602 | 2094081.36964 | 37.7295978486555 | -122.463428371748 | (37.7295978486555, -122.463428371748) | 9 | 8 | 4 | 59 | 40 | |||
| 173763 | 215146 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 143 De Montfort Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5994847.73331 | 2091874.74645 | 37.723594206678 | -122.459952875147 | (37.723594206678, -122.459952875147) | 9 | 8 | 4 | 28861 | 24 | |||
| 177776 | 38158 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 40 Holyoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1998 12:00:00 AM | 8 | Permit Number 40302 | 6009260.79203 | 2094034.01132 | 37.7303414926476 | -122.410281644004 | (37.7303414926476, -122.410281644004) | 9 | 3 | 7 | 309 | 28 | |
| 180831 | 215156 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 218 Thrift St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 10ft | 5994824.14627 | 2089663.55723 | 37.7175214527221 | -122.459874313044 | (37.7175214527221, -122.459874313044) | 9 | 8 | 6 | 28861 | 24 | |||
| 181905 | 68083 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 406 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/24/1994 12:00:00 AM | 14 | Permit Number 780238 | 6000946.91691 | 2092398.90491 | 37.7253823215207 | -122.438906661816 | (37.7253823215207, -122.438906661816) | 9 | 7 | 6 | 28861 | 25 | |
| 182763 | 179613 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 822 Felton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6008554.04655 | 2093192.69194 | 37.7279917674077 | -122.412665516503 | (37.7279917674077, -122.412665516503) | 9 | 3 | 7 | 309 | 28 | |||
| 183549 | 215147 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 484 Faxon Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 5994798.24088 | 2091767.01726 | 37.7232955616299 | -122.460116159654 | (37.7232955616299, -122.460116159654) | 9 | 8 | 4 | 28861 | 24 | |||
| 187555 | 215139 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 810 Darien Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 5993967.99913 | 2094114.77996 | 37.7296941579575 | -122.463156396067 | (37.7296941579575, -122.463156396067) | 9 | 8 | 4 | 59 | 40 | |||
| 188183 | 179601 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 901 Delano Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 6ft | 5998646.13957 | 2089569.69223 | 37.717482785492 | -122.446656735947 | (37.717482785492, -122.446656735947) | 9 | 7 | 6 | 28861 | 25 | |||
| 194165 | 43208 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 33 University St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/11/2000 12:00:00 AM | 9 | Permit Number 43000 | 6007763.04547 | 2093934.70612 | 37.7299847513771 | -122.415452547907 | (37.7299847513771, -122.415452547907) | 9 | 3 | 7 | 309 | 28 | |
| 849 | 51822 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 75 Dore St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2005 12:00:00 AM | 11 | Permit Number 48062 | 6008911.92726 | 2109811.9687 | 37.7736446648878 | -122.412602652111 | (37.7736446648878, -122.412602652111) | 8 | 2 | 9 | 28853 | 34 | ||
| 2254 | 245235 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 53 Dearborn St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6005837.96271 | 2105774.17524 | 37.7623848461922 | -122.422948943959 | (37.7623848461922, -122.422948943959) | 8 | 4 | 5 | 28859 | 19 | |||
| 4561 | 245236 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 53 Dearborn St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6005838.90196 | 2105786.95682 | 37.7624199943988 | -122.422946603908 | (37.7624199943988, -122.422946603908) | 8 | 4 | 5 | 28859 | 19 | |||
| 10632 | 245230 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 24 Dearborn St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6005803.61111 | 2105914.49608 | 37.7627681957301 | -122.423077727748 | (37.7627681957301, -122.423077727748) | 8 | 4 | 5 | 28859 | 19 | |||
| 12232 | 240848 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 450 Florida St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6009181.67793 | 2106295.69441 | 37.7640049263208 | -122.411421075131 | (37.7640049263208, -122.411421075131) | 8 | 4 | 7 | 28859 | 19 | ||||
| 16712 | 240997 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 52 Landers St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6004455.87708 | 2107460.86758 | 37.7669380156921 | -122.42784925625 | (37.7669380156921, -122.42784925625) | 8 | 4 | 5 | 28862 | 3 | |||
| 19679 | 40601 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1745 Alameda St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/2003 12:00:00 AM | 13 | Permit Number 47084 | 6011717.76597 | 2107914.27714 | 37.7685911090192 | -122.402763284706 | (37.7685911090192, -122.402763284706) | 8 | 2 | 8 | 28853 | 20 | |
| 19745 | 240855 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 151 Albion St | 1 | : | Tree | Private 2 | 3 | Width 2ft | 6005930.39356 | 2106374.49675 | 37.7640384026622 | -122.422671922196 | (37.7640384026622, -122.422671922196) | 8 | 4 | 5 | 28859 | 19 | |||
| 20091 | 240883 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 499 14th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6005534.08174 | 2107810.45937 | 37.7679588469372 | -122.424144778774 | (37.7679588469372, -122.424144778774) | 8 | 4 | 5 | 28853 | 19 | |||
| 21581 | 245234 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 53 Dearborn St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6005838.11402 | 2105765.07661 | 37.7623598720354 | -122.422947773934 | (37.7623598720354, -122.422947773934) | 8 | 4 | 5 | 28859 | 19 | |||
| 22133 | 86802 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 3057 17th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/2007 12:00:00 AM | 3x3 | Permit Number 49634 | 6008359 | 2106197 | 37.7636877570953 | -122.414259500664 | (37.7636877570953, -122.414259500664) | 8 | 4 | 7 | 28859 | 19 | |||
| 22257 | 197762 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 967 Natoma St | 1 | : | Tree | Private 2 | 12 | Width 3ft | 6008013.25237 | 2109878.84045 | 37.7737778014386 | -122.41571605105 | (37.7737778014386, -122.41571605105) | 8 | 2 | 9 | 28853 | 34 | |||
| 27267 | 73457 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 33 Rausch St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2015 12:00:00 AM | 3 | Permit Number 774688 | 6009719.27808 | 2110896.03825 | 37.7766665443529 | -122.40988643061 | (37.7766665443529, -122.40988643061) | 8 | 2 | 9 | 28853 | 34 | ||
| 32683 | 245229 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 267 Clinton Park | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6005011.87346 | 2108197.61767 | 37.7689923919147 | -122.425978603426 | (37.7689923919147, -122.425978603426) | 8 | 4 | 5 | 28853 | 19 | |||
| 35734 | 225141 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 145 Albion St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 2ft | 6005929.72911 | 2106381.16026 | 37.7640566615994 | -122.422674693899 | (37.7640566615994, -122.422674693899) | 8 | 4 | 5 | 28859 | 19 | |||
| 37599 | 51826 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 75 Dore St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2005 12:00:00 AM | 15 | Permit Number 48062 | 6008951.49863 | 2109770.91917 | 37.7735341733012 | -122.412462865995 | (37.7735341733012, -122.412462865995) | 8 | 2 | 9 | 28853 | 34 | ||
| 38177 | 36048 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 3057 17th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/1998 12:00:00 AM | 3x3 | Permit Number 49634 | 6008358.98035191 | 2106192.95330852 | 37.7636766447114 | -122.414259282291 | (37.7636766447114, -122.414259282291) | 8 | 4 | 7 | 28859 | 19 | ||
| 43126 | 240859 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 99 Albion St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6005815.33313 | 2106780.63921 | 37.7651470814965 | -122.423098753019 | (37.7651470814965, -122.423098753019) | 8 | 4 | 5 | 28853 | 19 | |||
| 43359 | 240995 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 44 Landers St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6004448.94888 | 2107518.77636 | 37.7670966273258 | -122.427877346558 | (37.7670966273258, -122.427877346558) | 8 | 4 | 5 | 28862 | 3 | |||
| 45740 | 36047 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 3057 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/1998 12:00:00 AM | 3x3 | Permit Number 49634 | 6008358.98035191 | 2106192.95330852 | 37.7636766447114 | -122.414259282291 | (37.7636766447114, -122.414259282291) | 8 | 4 | 7 | 28859 | 19 | ||
| 48698 | 108284 | Undocumented 4 | Syagrus romanzoffianum :: Queen Palm 85 | 1 HENRY ADAMS ST | 9 | Sidewalk: Property side : Cutout | Tree | Private 2 | 16 | 3x3 | 6011517.4 | 2108140.5 | 37.7692010762684 | -122.403472255644 | (37.7692010762684, -122.403472255644) | 8 | 2 | 8 | 28853 | 20 | |||
| 49411 | 51824 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 75 Dore St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2005 12:00:00 AM | 12 | Permit Number 48062 | 6008839.3407 | 2109885.31137 | 37.7738419725734 | -122.412858927409 | (37.7738419725734, -122.412858927409) | 8 | 2 | 9 | 28853 | 34 | ||
| 52108 | 197809 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 41 Dore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6008647.67456 | 2110087.31944 | 37.77438587894 | -122.413536223923 | (37.77438587894, -122.413536223923) | 8 | 2 | 9 | 28853 | 34 | |||
| 52207 | 197781 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1950 18th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 6ft | 6011867.97077 | 2105631.0205 | 37.7623301845026 | -122.402083196704 | (37.7623301845026, -122.402083196704) | 8 | 3 | 8 | 28856 | 29 | |||
| 54197 | 51828 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 75 Dore St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2005 12:00:00 AM | 11 | Permit Number 48062 | 6008816.98399 | 2109909.48162 | 37.7739070834758 | -122.412937972431 | (37.7739070834758, -122.412937972431) | 8 | 2 | 9 | 28853 | 34 | ||
| 56442 | 197808 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 41 Dore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6008660.65845 | 2110075.31719 | 37.7743536526336 | -122.413490461037 | (37.7743536526336, -122.413490461037) | 8 | 2 | 9 | 28853 | 34 | |||
| 57224 | 197782 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1950 18th St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 6ft | 6011843.38352 | 2105630.34808 | 37.7623269658286 | -122.402168188035 | (37.7623269658286, -122.402168188035) | 8 | 3 | 8 | 28856 | 29 | |||
| 59274 | 85361 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 30 Dore St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/2007 12:00:00 AM | 12 | Permit Number 49638 | 6008746.14707 | 2109938.9547 | 37.7739840330773 | -122.413185094432 | (37.7739840330773, -122.413185094432) | 8 | 2 | 9 | 28853 | 34 | ||
| 60324 | 245238 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 3690 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6005055.83253 | 2105475.95262 | 37.761521833391 | -122.425632817714 | (37.761521833391, -122.425632817714) | 8 | 4 | 5 | 28859 | 19 | |||
| 68638 | 57152 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 1548 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/1974 12:00:00 AM | Permit Number 53479 | 6007084.13005826 | 2107360.24310609 | 37.7668100557647 | -122.41875139025 | (37.7668100557647, -122.41875139025) | 8 | 4 | 7 | 28853 | 19 | |||
| 70601 | 240996 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 48 Landers St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6004451.21845 | 2107497.54881 | 37.7670384699769 | -122.42786798372 | (37.7670384699769, -122.42786798372) | 8 | 4 | 5 | 28862 | 3 | |||
| 74181 | 40602 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1745 Alameda St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/2003 12:00:00 AM | 15 | Permit Number 47084 | 6011826.18199 | 2107919.61674 | 37.7686118231125 | -122.40238865592 | (37.7686118231125, -122.40238865592) | 8 | 2 | 8 | 28853 | 20 | |
| 76130 | 245281 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 3057 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008365.23947 | 2106190.88278 | 37.7636713111025 | -122.414237487376 | (37.7636713111025, -122.414237487376) | 8 | 4 | 7 | 28859 | 19 | |||
| 76285 | 240860 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 99 Albion St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6005814.59305 | 2106796.61369 | 37.7651909018693 | -122.423102448325 | (37.7651909018693, -122.423102448325) | 8 | 4 | 5 | 28853 | 19 | |||
| 79636 | 51823 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 75 Dore St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2005 12:00:00 AM | 13 | Permit Number 48062 | 6008893.04946 | 2109829.84045 | 37.7736926770172 | -122.412669217211 | (37.7736926770172, -122.412669217211) | 8 | 2 | 9 | 28853 | 34 | ||
| 86531 | 240994 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 32 Landers St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6004449.41871 | 2107560.35857 | 37.7672108286396 | -122.427878684774 | (37.7672108286396, -122.427878684774) | 8 | 4 | 5 | 28862 | 3 | |||
| 87515 | 225143 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 145 Albion St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 2ft | 6005929.42446 | 2106392.33827 | 37.7640873365867 | -122.422676541996 | (37.7640873365867, -122.422676541996) | 8 | 4 | 5 | 28859 | 19 | |||
| 91531 | 245335 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 3388 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6006951.21125 | 2105579.531 | 37.7619131526828 | -122.419084815214 | (37.7619131526828, -122.419084815214) | 8 | 4 | 7 | 28859 | 19 | |||
| 94083 | 120539 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 32 Landers St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004448.25188 | 2107581.7846 | 37.767269593348 | -122.427884247566 | (37.767269593348, -122.427884247566) | 8 | 4 | 5 | 28862 | 3 | ||||
| 94266 | 245336 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 3382 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6006999.44244 | 2105581.36485 | 37.7619209039545 | -122.418918132189 | (37.7619209039545, -122.418918132189) | 8 | 4 | 7 | 28859 | 19 | |||
| 94951 | 40575 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1745 Alameda St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 16 | Permit Number 42197 | 6011865.56753 | 2107924.68372 | 37.7686279344547 | -122.402252780039 | (37.7686279344547, -122.402252780039) | 8 | 2 | 8 | 28853 | 20 | |
| 98103 | 245233 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 53 Dearborn St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6005839.51386 | 2105750.8995 | 37.7623210240189 | -122.422941924745 | (37.7623210240189, -122.422941924745) | 8 | 4 | 5 | 28859 | 19 | |||
| 100432 | 225144 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 145 Albion St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 2ft | 6005929.78452 | 2106396.85276 | 37.764099752624 | -122.422675617489 | (37.764099752624, -122.422675617489) | 8 | 4 | 5 | 28859 | 19 | |||
| 108295 | 197811 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 41 Dore St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6008628.59591 | 2110107.11154 | 37.7744391520861 | -122.413603620921 | (37.7744391520861, -122.413603620921) | 8 | 2 | 9 | 28853 | 34 | |||
| 109883 | 240849 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 450 Florida St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | 6009178.7151 | 2106293.81333 | 37.7639995951253 | -122.411431189821 | (37.7639995951253, -122.411431189821) | 8 | 4 | 7 | 28859 | 19 | ||||
| 110441 | 51820 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 75 Dore St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2005 12:00:00 AM | 13 | Permit Number 48062 | 6008882.21436 | 2109841.08005 | 37.7737229301921 | -122.412707492378 | (37.7737229301921, -122.412707492378) | 8 | 2 | 9 | 28853 | 34 | ||
| 111936 | 240850 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 450 Florida St | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | 6009190.78397 | 2106226.27054 | 37.763814815036 | -122.411384675059 | (37.763814815036, -122.411384675059) | 8 | 4 | 7 | 28859 | 19 | ||||
| 112644 | 51825 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 75 Dore St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2005 12:00:00 AM | 9 | Permit Number 48062 | 6008869.29878 | 2109856.43438 | 37.7737643646643 | -122.412753255267 | (37.7737643646643, -122.412753255267) | 8 | 2 | 9 | 28853 | 34 | ||
| 113598 | 51831 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 75 Dore St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2005 12:00:00 AM | 12 | Permit Number 48062 | 6008936.17347 | 2109786.08328 | 37.7735749503435 | -122.41251695031 | (37.7735749503435, -122.41251695031) | 8 | 2 | 9 | 28853 | 34 | ||
| 114269 | 245227 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 98 14th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008059.54511 | 2107998.03591 | 37.7686161569496 | -122.415422738079 | (37.7686161569496, -122.415422738079) | 8 | 4 | 7 | 28853 | 19 | |||
| 117787 | 51830 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 75 Dore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2005 12:00:00 AM | 15 | Permit Number 48062 | 6008991.04076 | 2109728.43276 | 37.7734197345703 | -122.41232307986 | (37.7734197345703, -122.41232307986) | 8 | 2 | 9 | 28853 | 34 | ||
| 121058 | 59216 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 42 Landers St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/1983 12:00:00 AM | 16 | 3x3 | Permit Number 20726 | 6004445.43179676 | 2107524.22878238 | 37.7671113993979 | -122.427889900178 | (37.7671113993979, -122.427889900178) | 8 | 4 | 5 | 28862 | 3 | |
| 122872 | 197759 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1275 Harrison St | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | 7 | 6009794.14273 | 2110264.73929 | 37.7749373405286 | -122.409582883362 | (37.7749373405286, -122.409582883362) | 8 | 2 | 9 | 28853 | 34 | ||||
| 124049 | 240852 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2801 Mariposa St | 3 | : | Tree | Private 2 | 12 | Width 3ft | 6009128.42017 | 2105892.10901 | 37.7628937860344 | -122.411576762184 | (37.7628937860344, -122.411576762184) | 8 | 4 | 7 | 28859 | 19 | |||
| 124818 | 240857 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 99 Albion St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6005817.41296 | 2106751.86939 | 37.7650682037548 | -122.423089514295 | (37.7650682037548, -122.423089514295) | 8 | 4 | 5 | 28853 | 19 | |||
| 128350 | 70674 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 33 Rausch St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2015 12:00:00 AM | 3 | Permit Number 774688 | 6009713.37345 | 2110904.22061 | 37.7766886802763 | -122.409907434288 | (37.7766886802763, -122.409907434288) | 8 | 2 | 9 | 28853 | 34 | ||
| 129206 | 40576 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1745 Alameda St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 16 | Permit Number 42197 | 6011845.30553 | 2107921.74272 | 37.7686187280976 | -122.402322658262 | (37.7686187280976, -122.402322658262) | 8 | 2 | 8 | 28853 | 20 | |
| 129768 | 56463 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 495 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6005502.51915575 | 2107805.81880506 | 37.7679443229226 | -122.424253620258 | (37.7679443229226, -122.424253620258) | 8 | 4 | 5 | 28853 | 19 | |||||
| 131971 | 40579 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1745 Alameda St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/2003 12:00:00 AM | 14 | Permit Number 47084 | 6011781.78779 | 2107916.60765 | 37.7686010824916 | -122.402542001114 | (37.7686010824916, -122.402542001114) | 8 | 2 | 8 | 28853 | 20 | |
| 133443 | 197810 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 41 Dore St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6008638.52776 | 2110098.76438 | 37.7744167904456 | -122.413568674158 | (37.7744167904456, -122.413568674158) | 8 | 2 | 9 | 28853 | 34 | |||
| 134210 | 197772 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 370 De Haro St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6011991.34418 | 2106649.17126 | 37.7651326842421 | -122.401728059814 | (37.7651326842421, -122.401728059814) | 8 | 3 | 8 | 28853 | 20 | |||
| 134928 | 245278 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1779 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6008034.93749 | 2108017.16793 | 37.7686673058729 | -122.415509208786 | (37.7686673058729, -122.415509208786) | 8 | 4 | 7 | 28853 | 19 | |||
| 138467 | 40600 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1745 Alameda St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/2003 12:00:00 AM | 16 | Permit Number 47084 | 6011742.75079 | 2107914.88662 | 37.768594177497 | -122.402676906637 | (37.768594177497, -122.402676906637) | 8 | 2 | 8 | 28853 | 20 | |
| 139752 | 40581 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1745 Alameda St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/2003 12:00:00 AM | 18 | Permit Number 47084 | 6011805.12388 | 2107918.92734 | 37.7686087546157 | -122.402461446151 | (37.7686087546157, -122.402461446151) | 8 | 2 | 8 | 28853 | 20 | |
| 142126 | 245228 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 267 Clinton Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6004993.18691 | 2108197.15694 | 37.7689900707609 | -122.426043206255 | (37.7689900707609, -122.426043206255) | 8 | 4 | 5 | 28853 | 19 | |||
| 144871 | 240858 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 99 Albion St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6005816.06228 | 2106764.13272 | 37.7651017997331 | -122.423095057704 | (37.7651017997331, -122.423095057704) | 8 | 4 | 5 | 28853 | 19 | |||
| 149745 | 240853 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2801 Mariposa St | 5 | : | Tree | Private 2 | 13 | Width 3ft | 6009171.61206 | 2105893.21544 | 37.7628992467128 | -122.41142745404 | (37.7628992467128, -122.41142745404) | 8 | 4 | 7 | 28859 | 19 | |||
| 152418 | 86801 | Permitted Site 7 | Syagrus romanzoffianum :: Queen Palm 85 | 3057 17th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/2007 12:00:00 AM | 3x3 | Permit Number 49634 | 6008359 | 2106197 | 37.7636877570953 | -122.414259500664 | (37.7636877570953, -122.414259500664) | 8 | 4 | 7 | 28859 | 19 | |||
| 153181 | 40599 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1745 Alameda St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/09/2003 12:00:00 AM | 15 | Permit Number 47084 | 6011762.41247 | 2107915.88375 | 37.7685980131212 | -122.402608968236 | (37.7685980131212, -122.402608968236) | 8 | 2 | 8 | 28853 | 20 | |
| 155018 | 245232 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 51 Dearborn St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 6ft | 6005861.26231 | 2105689.81649 | 37.7621545316223 | -122.422862363516 | (37.7621545316223, -122.422862363516) | 8 | 4 | 5 | 28859 | 19 | |||
| 156697 | 197807 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 59 Grace St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6008374.50878 | 2110266.71352 | 37.7748631104905 | -122.414493855329 | (37.7748631104905, -122.414493855329) | 8 | 2 | 9 | 28853 | 34 | |||
| 162092 | 240884 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 98 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008092.35816 | 2108001.44003 | 37.7686273481005 | -122.41530948107 | (37.7686273481005, -122.41530948107) | 8 | 4 | 7 | 28853 | 19 | |||
| 163429 | 245237 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 3690 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6005066.37582 | 2105475.84046 | 37.7615221211752 | -122.425596344801 | (37.7615221211752, -122.425596344801) | 8 | 4 | 5 | 28859 | 19 | |||
| 164722 | 51833 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 75 Dore St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2005 12:00:00 AM | 12 | Permit Number 48062 | 6008964.93422 | 2109757.47031 | 37.7734979998699 | -122.412415439325 | (37.7734979998699, -122.412415439325) | 8 | 2 | 9 | 28853 | 34 | ||
| 165006 | 240847 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 450 Florida St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | 6009178.56077 | 2106298.18475 | 37.7640115893856 | -122.411432032456 | (37.7640115893856, -122.411432032456) | 8 | 4 | 7 | 28859 | 19 | ||||
| 165479 | 240856 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 99 Albion St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6005817.66838 | 2106738.29847 | 37.7650309556372 | -122.423087666179 | (37.7650309556372, -122.423087666179) | 8 | 4 | 5 | 28853 | 19 | |||
| 167759 | 245231 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 24 Dearborn St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 2ft | 6005803.549 | 2105901.04894 | 37.7627312695497 | -122.423076986719 | (37.7627312695497, -122.423076986719) | 8 | 4 | 5 | 28859 | 19 | |||
| 169825 | 51821 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 75 Dore St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2005 12:00:00 AM | 15 | Permit Number 48062 | 6008924.41107 | 2109799.01878 | 37.77360980807 | -122.412558552943 | (37.77360980807, -122.412558552943) | 8 | 2 | 9 | 28853 | 34 | ||
| 176408 | 240851 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 2801 Mariposa St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 6009106.41191 | 2105891.62942 | 37.7628912346527 | -122.41165284751 | (37.7628912346527, -122.41165284751) | 8 | 4 | 7 | 28859 | 19 | |||
| 178165 | 225142 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 145 Albion St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 2ft | 6005928.78135 | 2106387.03173 | 37.7640727297977 | -122.422678389203 | (37.7640727297977, -122.422678389203) | 8 | 4 | 5 | 28859 | 19 | |||
| 178227 | 51832 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 75 Dore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2005 12:00:00 AM | 13 | Permit Number 48062 | 6008981.39309 | 2109738.92978 | 37.7734480155424 | -122.412357194742 | (37.7734480155424, -122.412357194742) | 8 | 2 | 9 | 28853 | 34 | ||
| 185282 | 240882 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 499 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6005513.65121 | 2107810.11701 | 37.7679567533317 | -122.424215421419 | (37.7679567533317, -122.424215421419) | 8 | 4 | 5 | 28853 | 19 | |||
| 191633 | 51829 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 75 Dore St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2005 12:00:00 AM | 10 | Permit Number 48062 | 6008854.22415 | 2109872.0726 | 37.7738064574284 | -122.412806506809 | (37.7738064574284, -122.412806506809) | 8 | 2 | 9 | 28853 | 34 | ||
| 192419 | 245280 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 3057 17th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008432.74657 | 2106194.80259 | 37.7636858657207 | -122.414004277878 | (37.7636858657207, -122.414004277878) | 8 | 4 | 7 | 28859 | 19 |
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) );