trees
8,758 rows where qSpecies_id = 16 sorted by YCoord 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 108862 | 68971 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3437 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1994 12:00:00 AM | 10 | Permit Number 32961 | 5999742.33504 | 2120394.44414 | 37.8021824863064 | -122.445082501459 | (37.8021824863064, -122.445082501459) | 13 | 9 | 1 | 57 | 17 | |
| 155349 | 63997 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2313 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/06/1987 12:00:00 AM | 14 | Permit Number 24744 | 6008014.08698 | 2120392.95206 | 37.802647032905 | -122.416458063683 | (37.802647032905, -122.416458063683) | 5 | 1 | 1 | 308 | 32 | |
| 188259 | 131609 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2318 Jones St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6008062.79243 | 2120392.22117 | 37.8026477649427 | -122.416289466003 | (37.8026477649427, -122.416289466003) | 5 | 1 | 10 | 308 | 32 | |||
| 180612 | 68234 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 119 Alhambra St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | 10 | Permit Number 32029 | 6001710.50299 | 2120379.6498 | 37.8022540030844 | -122.438270644189 | (37.8022540030844, -122.438270644189) | 13 | 9 | 1 | 57 | 17 | |
| 5381 | 131608 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2318 Jones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6008064.43802 | 2120372.10874 | 37.8025926337993 | -122.416282346076 | (37.8025926337993, -122.416282346076) | 5 | 1 | 10 | 308 | 32 | |||
| 183135 | 131273 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 123 Alhambra St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6001700.63803 | 2120371.71918 | 37.8022316666158 | -122.438304213185 | (37.8022316666158, -122.438304213185) | 13 | 9 | 1 | 57 | 17 | |||
| 31038 | 131613 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2313 Jones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008016.13424 | 2120368.02715 | 37.8025787105001 | -122.416449212563 | (37.8025787105001, -122.416449212563) | 5 | 1 | 1 | 308 | 32 | |||
| 164368 | 68235 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 123 Alhambra St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | 11 | Permit Number 32030 | 6001689.71032 | 2120361.77725 | 37.8022037471652 | -122.438341315605 | (37.8022037471652, -122.438341315605) | 13 | 9 | 1 | 57 | 17 | |
| 113173 | 131607 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2318 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6008066.96084 | 2120354.64184 | 37.8025448159424 | -122.41627237798 | (37.8025448159424, -122.41627237798) | 5 | 1 | 10 | 308 | 32 | |||
| 164815 | 63994 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 892 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/06/1987 12:00:00 AM | Permit Number 24741 | 6008089.0249437 | 2120337.76800828 | 37.8024997252923 | -122.416194829179 | (37.8024997252923, -122.416194829179) | 5 | 1 | 10 | 308 | 32 | ||
| 54241 | 27394 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2264 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6007125.97571 | 2120126.616 | 37.8018657576659 | -122.419512476126 | (37.8018657576659, -122.419512476126) | 5 | 1 | 1 | 28858 | 32 | |||
| 121292 | 65864 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 33 Toledo Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/1990 12:00:00 AM | 7 | Permit Number 28856 | 6001755.67247 | 2120076.95343 | 37.8014254477747 | -122.438092640468 | (37.8014254477747, -122.438092640468) | 13 | 9 | 1 | 57 | 17 | |
| 178578 | 41220 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 41 Mallorca Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/30/1999 12:00:00 AM | 8 | Permit Number 41927 | 6001922.05236 | 2120065.33061 | 37.8014029953161 | -122.437516059918 | (37.8014029953161, -122.437516059918) | 13 | 9 | 1 | 57 | 17 | |
| 13710 | 41219 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 41 Mallorca Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/30/1999 12:00:00 AM | 7 | Permit Number 41927 | 6001924.51424 | 2120048.48598 | 37.8013568843691 | -122.437506333775 | (37.8013568843691, -122.437506333775) | 13 | 9 | 1 | 57 | 17 | |
| 26719 | 131327 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3401 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6000773.56958 | 2120041.75431 | 37.8012728984789 | -122.441488619015 | (37.8012728984789, -122.441488619015) | 13 | 9 | 1 | 57 | 17 | |||
| 192996 | 65590 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 875 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/1990 12:00:00 AM | 12 | Permit Number 28491 | 6008718.16463 | 2120030.26562 | 37.8016907558706 | -122.413995919601 | (37.8016907558706, -122.413995919601) | 3 | 1 | 10 | 308 | 32 | ||
| 31723 | 65866 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 49 Toledo Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/08/1990 12:00:00 AM | 12 | Permit Number 28858 | 6001681.56159 | 2120025.01141 | 37.8012786136861 | -122.438345373351 | (37.8012786136861, -122.438345373351) | 13 | 9 | 1 | 57 | 17 | |
| 132636 | 249934 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 345 Filbert St | 3 | Front Yard : Yard | Tree | Private 2 | 15 | Width 0ft | 6011220.75334 | 2120024.08669 | 37.8018140268525 | -122.405335332271 | (37.8018140268525, -122.405335332271) | 3 | 1 | 10 | 308 | 23 | |||
| 124756 | 249935 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 345 Filbert St | 4 | Front Yard : Yard | Tree | Private 2 | 13 | Width 0ft | 6011217.60626 | 2120022.59893 | 37.8018097658745 | -122.405346117856 | (37.8018097658745, -122.405346117856) | 3 | 1 | 10 | 308 | 23 | |||
| 61060 | 249932 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 345 Filbert St | 1 | : | Tree | Private 2 | 18 | Width 0ft | 6011228.49404 | 2120021.60131 | 37.8018076353832 | -122.405308370584 | (37.8018076353832, -122.405308370584) | 3 | 1 | 10 | 308 | 23 | |||
| 125640 | 249930 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 345 Filbert St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 0ft | 6011183.60917 | 2120017.47195 | 37.8017937876064 | -122.40546340292 | (37.8017937876064, -122.40546340292) | 3 | 1 | 10 | 308 | 23 | |||
| 76995 | 65827 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2200 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/07/1990 12:00:00 AM | 12 | Permit Number 28817 | 6000734.18919 | 2120000.46428 | 37.8011572834459 | -122.441621927314 | (37.8011572834459, -122.441621927314) | 13 | 9 | 1 | 57 | 17 | |
| 70740 | 131269 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2200 Francisco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6000687.44343 | 2119995.01626 | 37.8011396612154 | -122.441783296284 | (37.8011396612154, -122.441783296284) | 13 | 9 | 1 | 57 | 17 | |||
| 153951 | 65865 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 61 Toledo Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/08/1990 12:00:00 AM | 12 | Permit Number 28857 | 6001619.46387 | 2119982.66015 | 37.8011587961139 | -122.43855722215 | (37.8011587961139, -122.43855722215) | 13 | 9 | 1 | 57 | 17 | |
| 192267 | 53213 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 77 Toledo Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/08/1990 12:00:00 AM | 9 | Permit Number 28860 | 6001508.75338 | 2119947.52013 | 37.801056012589 | -122.438937808027 | (37.801056012589, -122.438937808027) | 13 | 9 | 1 | 57 | 17 | |
| 100922 | 131597 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1064 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6007780.23049 | 2119947.30581 | 37.8014102465383 | -122.417235729063 | (37.8014102465383, -122.417235729063) | 5 | 1 | 10 | 308 | 32 | |||
| 36548 | 131598 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1064 Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6007756.4121 | 2119942.72004 | 37.8013963151439 | -122.417317826381 | (37.8013963151439, -122.417317826381) | 5 | 1 | 10 | 308 | 32 | |||
| 55910 | 131599 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1064 Greenwich St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007728.30298 | 2119938.53926 | 37.80138325428 | -122.41741480026 | (37.80138325428, -122.41741480026) | 5 | 1 | 10 | 308 | 32 | |||
| 114520 | 131600 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1064 Greenwich St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6007712.99123 | 2119937.26744 | 37.8013789006691 | -122.41746769568 | (37.8013789006691, -122.41746769568) | 5 | 1 | 10 | 308 | 32 | |||
| 57158 | 131601 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1064 Greenwich St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6007682.18951 | 2119933.77599 | 37.8013675809 | -122.41757403601 | (37.8013675809, -122.41757403601) | 5 | 1 | 10 | 308 | 32 | |||
| 71897 | 63975 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2200 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1987 12:00:00 AM | Permit Number 24711 | 6007641.78715238 | 2119906.56076139 | 37.8012905812575 | -122.417711916361 | (37.8012905812575, -122.417711916361) | 5 | 1 | 10 | 308 | 32 | ||
| 173789 | 131268 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3212 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5999369.64627 | 2119891.28234 | 37.8007796608042 | -122.446335962139 | (37.8007796608042, -122.446335962139) | 13 | 9 | 1 | 57 | 17 | |||
| 23726 | 63984 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2143 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/06/1987 12:00:00 AM | 14 | Permit Number 24730 | 6008092.26877 | 2119832.2798 | 37.801111963901 | -122.41614778321 | (37.801111963901, -122.41614778321) | 5 | 1 | 1 | 308 | 32 | |
| 183026 | 131582 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2164 Hyde St | 7 | Sidewalk: Curb side : Pot | Tree | Private 2 | 12 | Width 4ft | 6007173.41737 | 2119786.279 | 37.8009339503036 | -122.419324148191 | (37.8009339503036, -122.419324148191) | 5 | 1 | 1 | 28858 | 32 | |||
| 122951 | 131581 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2164 Hyde St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 14 | Width 4ft | 6007176.69217 | 2119762.83713 | 37.8008697692805 | -122.419311152089 | (37.8008697692805, -122.419311152089) | 5 | 1 | 1 | 28858 | 32 | |||
| 185462 | 60888 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 874 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/11/1983 12:00:00 AM | Permit Number 20673 | 6008742.9575772 | 2119735.40688249 | 37.8008825397162 | -122.413889254442 | (37.8008825397162, -122.413889254442) | 3 | 1 | 10 | 308 | 32 | ||
| 161912 | 60889 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 882 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/11/1983 12:00:00 AM | Permit Number 20674 | 6008706.4211303 | 2119730.37321195 | 37.8008666665337 | -122.414015330081 | (37.8008666665337, -122.414015330081) | 3 | 1 | 10 | 308 | 32 | ||
| 35212 | 131274 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2200 Chestnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 6ft | 6001259.5494 | 2119728.7209 | 37.8004410660637 | -122.439784463083 | (37.8004410660637, -122.439784463083) | 13 | 9 | 1 | 57 | 17 | |||
| 46812 | 131625 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2 John Maher St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6012570.48986 | 2119721.62868 | 37.8010589209946 | -122.400643327244 | (37.8010589209946, -122.400643327244) | 3 | 1 | 10 | 28860 | 6 | |||
| 141791 | 131627 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2 John Maher St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6012555.77079 | 2119718.70246 | 37.8010500653777 | -122.400694056186 | (37.8010500653777, -122.400694056186) | 3 | 1 | 10 | 28860 | 6 | |||
| 64069 | 131626 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2 John Maher St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6012570.67215 | 2119713.81663 | 37.8010374811566 | -122.400642147338 | (37.8010374811566, -122.400642147338) | 3 | 1 | 10 | 28860 | 6 | |||
| 128944 | 131628 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2 John Maher St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6012557.32992 | 2119711.54141 | 37.8010304898201 | -122.400688157539 | (37.8010304898201, -122.400688157539) | 3 | 1 | 10 | 28860 | 6 | |||
| 9995 | 60885 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 837 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/12/1983 12:00:00 AM | 11 | Permit Number 20669 | 6008911.6951 | 2119705.40633 | 37.8008096406195 | -122.413303226667 | (37.8008096406195, -122.413303226667) | 3 | 1 | 10 | 308 | 32 | |
| 18218 | 60886 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 843 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/12/1983 12:00:00 AM | 13 | Permit Number 20670 | 6008888.08032 | 2119703.02395 | 37.8008017733536 | -122.413384775392 | (37.8008017733536, -122.413384775392) | 3 | 1 | 10 | 308 | 32 | |
| 3280 | 131640 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 John Maher St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6012516.39598 | 2119702.01834 | 37.8010020586619 | -122.400829137966 | (37.8010020586619, -122.400829137966) | 3 | 1 | 10 | 28860 | 6 | |||
| 110570 | 131629 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 6 John Maher St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6012420.57722 | 2119701.07942 | 37.800994135623 | -122.401160647841 | (37.800994135623, -122.401160647841) | 3 | 1 | 10 | 28860 | 6 | |||
| 114503 | 131631 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 6 John Maher St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6012411.69944 | 2119700.41084 | 37.8009918045935 | -122.401191321931 | (37.8009918045935, -122.401191321931) | 3 | 1 | 10 | 28860 | 6 | |||
| 119983 | 131638 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 John Maher St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6012504.601 | 2119700.39069 | 37.800996931627 | -122.40086983947 | (37.800996931627, -122.40086983947) | 3 | 1 | 10 | 28860 | 6 | |||
| 83245 | 131636 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 John Maher St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6012488.72872 | 2119699.54646 | 37.8009937282283 | -122.400924705329 | (37.8009937282283, -122.400924705329) | 3 | 1 | 10 | 28860 | 6 | |||
| 3720 | 60887 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 847 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/12/1983 12:00:00 AM | 11 | Permit Number 20671 | 6008866.49451 | 2119699.37218 | 37.8007905345249 | -122.413459213167 | (37.8007905345249, -122.413459213167) | 3 | 1 | 10 | 308 | 32 | |
| 83362 | 131634 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 John Maher St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6012476.57757 | 2119697.05581 | 37.800986211703 | -122.400966578661 | (37.800986211703, -122.400966578661) | 3 | 1 | 10 | 28860 | 6 | |||
| 176156 | 131639 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 John Maher St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6012517.79158 | 2119695.20026 | 37.8009834157025 | -122.400823829283 | (37.8009834157025, -122.400823829283) | 3 | 1 | 10 | 28860 | 6 | |||
| 101702 | 131637 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 John Maher St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6012505.47527 | 2119693.07389 | 37.8009768902256 | -122.400866299755 | (37.8009768902256, -122.400866299755) | 3 | 1 | 10 | 28860 | 6 | |||
| 52223 | 131630 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 6 John Maher St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6012421.77135 | 2119692.7375 | 37.8009712973424 | -122.401155929114 | (37.8009712973424, -122.401155929114) | 3 | 1 | 10 | 28860 | 6 | |||
| 165044 | 131635 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 John Maher St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6012489.93167 | 2119691.5224 | 37.800971763197 | -122.400919978499 | (37.800971763197, -122.400919978499) | 3 | 1 | 10 | 28860 | 6 | |||
| 99456 | 131632 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 6 John Maher St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6012412.70963 | 2119691.39368 | 37.8009671020066 | -122.401187192234 | (37.8009671020066, -122.401187192234) | 3 | 1 | 10 | 28860 | 6 | |||
| 88842 | 131633 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 John Maher St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6012478.4844 | 2119690.22702 | 37.8009675678597 | -122.400959500108 | (37.8009675678597, -122.400959500108) | 3 | 1 | 10 | 28860 | 6 | |||
| 82822 | 131267 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3150 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 5999400.53069 | 2119689.18325 | 37.8002265147979 | -122.446214543761 | (37.8002265147979, -122.446214543761) | 13 | 9 | 1 | 57 | 17 | |||
| 127545 | 11121 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2111 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/19/1991 12:00:00 AM | 24 | 3X3 | 6007150.67301 | 2119614.39818 | 37.8004607279458 | -122.419390653056 | (37.8004607279458, -122.419390653056) | 5 | 1 | 1 | 28858 | 32 | ||
| 82042 | 11122 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2111 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/19/1991 12:00:00 AM | 24 | 3X3 | 6007154.50985 | 2119579.5735 | 37.800365324253 | -122.419374904131 | (37.800365324253, -122.419374904131) | 5 | 1 | 1 | 28858 | 32 | ||
| 151656 | 46887 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2111St Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/2002 12:00:00 AM | Permit Number 44943 | 6007161.92485476 | 2119533.4941492 | 37.8002392195925 | -122.419345974509 | (37.8002392195925, -122.419345974509) | 5 | 1 | 1 | 28858 | 32 | ||
| 139196 | 131583 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1232 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007143.44817 | 2119511.49839 | 37.8001777841442 | -122.419408349913 | (37.8001777841442, -122.419408349913) | 5 | 1 | 1 | 28858 | 32 | |||
| 159710 | 68975 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2534 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1994 12:00:00 AM | 8 | Permit Number 32965 | 5999693.83907 | 2119509.67441 | 37.7997503777461 | -122.445186672628 | (37.7997503777461, -122.445186672628) | 13 | 9 | 1 | 57 | 17 | |
| 148310 | 131584 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1232 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6007122.6216 | 2119509.46976 | 37.8001710410099 | -122.419480274097 | (37.8001710410099, -122.419480274097) | 5 | 1 | 1 | 28858 | 32 | |||
| 38526 | 131585 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1232 Filbert St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6007102.45973 | 2119505.49835 | 37.800159000888 | -122.419549760231 | (37.800159000888, -122.419549760231) | 5 | 1 | 1 | 28858 | 32 | |||
| 169986 | 131586 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1232 Filbert St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007078.08306 | 2119502.13944 | 37.8001484050804 | -122.419633874696 | (37.8001484050804, -122.419633874696) | 5 | 1 | 1 | 28858 | 32 | |||
| 146499 | 131587 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1232 Filbert St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007055.31621 | 2119499.97544 | 37.8001411808179 | -122.419712503356 | (37.8001411808179, -122.419712503356) | 5 | 1 | 1 | 28858 | 32 | |||
| 47092 | 131588 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1232 Filbert St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6007034.99645 | 2119496.88446 | 37.8001315491034 | -122.419782598293 | (37.8001315491034, -122.419782598293) | 5 | 1 | 1 | 28858 | 32 | |||
| 120948 | 35239 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1254 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/17/1998 12:00:00 AM | Permit Number 768922 | 6006927.0524577 | 2119483.65526639 | 37.8000891436189 | -122.420155187599 | (37.8000891436189, -122.420155187599) | 5 | 1 | 1 | 28858 | 32 | |||
| 147624 | 121449 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1274 Filbert St | 1 | Front Yard : Yard | Tree | Private 2 | 12 | 10x6 | 6006927.94593 | 2119481.89109 | 37.800084349978 | -122.420151970562 | (37.800084349978, -122.420151970562) | 5 | 1 | 1 | 28858 | 32 | |||
| 55271 | 48585 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1274 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/28/2002 12:00:00 AM | 5 | Permit Number 45899 | 6006912.42304 | 2119480.80648 | 37.800080497273 | -122.420205608818 | (37.800080497273, -122.420205608818) | 5 | 1 | 1 | 28858 | 32 | |
| 75310 | 99238 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1254 Filbert St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 38735 | 6006927 | 2119477 | 37.8000708669817 | -122.420154896537 | (37.8000708669817, -122.420154896537) | 5 | 1 | 1 | 28858 | 32 | ||||
| 135060 | 99237 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1254 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 38735 | 6006927 | 2119477 | 37.8000708669817 | -122.420154896537 | (37.8000708669817, -122.420154896537) | 5 | 1 | 1 | 28858 | 32 | ||||
| 54566 | 48586 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1274 Filbert St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/28/2002 12:00:00 AM | 6 | Permit Number 45899 | 6006865.60625 | 2119474.04928 | 37.8000593056606 | -122.420367133344 | (37.8000593056606, -122.420367133344) | 5 | 1 | 1 | 28858 | 32 | |
| 23021 | 48587 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1274 Filbert St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/28/2002 12:00:00 AM | 8 | Permit Number 45899 | 6006852.18921 | 2119472.5707 | 37.8000544897848 | -122.420413456529 | (37.8000544897848, -122.420413456529) | 5 | 1 | 1 | 28858 | 32 | |
| 75776 | 48584 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1274 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/28/2002 12:00:00 AM | Permit Number 45899 | 6006834.92343945 | 2119470.84575216 | 37.8000487805371 | -122.420473080317 | (37.8000487805371, -122.420473080317) | 5 | 1 | 1 | 28858 | 32 | ||
| 13303 | 131570 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1287 Filbert St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6006804.63948 | 2119416.06365 | 37.7998966560617 | -122.42057398372 | (37.7998966560617, -122.42057398372) | 5 | 1 | 1 | 28858 | 32 | |||
| 29493 | 131569 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1287 Filbert St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6006787.88073 | 2119413.83781 | 37.7998895999842 | -122.420631817308 | (37.7998895999842, -122.420631817308) | 5 | 1 | 1 | 28858 | 32 | |||
| 46593 | 131568 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1287 Filbert St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6006774.5439 | 2119410.68491 | 37.7998801912652 | -122.420677743888 | (37.7998801912652, -122.420677743888) | 5 | 1 | 1 | 28858 | 32 | |||
| 140187 | 131567 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1287 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6006758.51963 | 2119408.32152 | 37.7998727988557 | -122.420733026103 | (37.7998727988557, -122.420733026103) | 5 | 1 | 1 | 28858 | 32 | |||
| 27723 | 131614 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 382 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6011127.68134 | 2119363.27633 | 37.7999943988748 | -122.405610836886 | (37.7999943988748, -122.405610836886) | 3 | 1 | 10 | 308 | 23 | |||
| 1966 | 61296 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2360 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1986 12:00:00 AM | 9 | Permit Number 23055 | 6006748.00387 | 2119357.01746 | 37.7997313381808 | -122.420765770421 | (37.7997313381808, -122.420765770421) | 5 | 9 | 1 | 28858 | 32 | |
| 7106 | 72209 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 315 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/16/2019 12:00:00 AM | 3 | 6011420.02502 | 2119355.99811 | 37.7999907575129 | -122.404598698471 | (37.7999907575129, -122.404598698471) | 3 | 1 | 10 | 308 | 23 | ||
| 135639 | 68921 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 924 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1993 12:00:00 AM | 8 | Permit Number 32905 | 6008518.48289 | 2119354.57614 | 37.7998242642284 | -122.414639068835 | (37.7998242642284, -122.414639068835) | 5 | 1 | 10 | 308 | 32 | |
| 135477 | 110055 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1881 Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6003900.72714 | 2119354.24567 | 37.7995628367073 | -122.43061819507 | (37.7995628367073, -122.43061819507) | 13 | 9 | 1 | 57 | 17 | |||
| 187199 | 60134 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1881 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/1982 12:00:00 AM | 14 | Permit Number 19664 | 6003859.19532 | 2119347.90146 | 37.7995430642214 | -122.430761457096 | (37.7995430642214, -122.430761457096) | 13 | 9 | 1 | 57 | 17 | ||
| 169123 | 35256 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2354 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/17/1998 12:00:00 AM | 6 | Permit Number 38742 | 6006751.34722 | 2119334.30912 | 37.7996691752539 | -122.420752588178 | (37.7996691752539, -122.420752588178) | 5 | 9 | 1 | 28858 | 32 | |
| 13722 | 72210 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 355 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 13 | 6011262.40416 | 2119331.44854 | 37.7999145399845 | -122.405142399827 | (37.7999145399845, -122.405142399827) | 3 | 1 | 10 | 308 | 23 | |||
| 82327 | 74216 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 901 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/23/2008 12:00:00 AM | 3x3 | Permit Number 51732 | 6008662.62801958 | 2119324.4506425 | 37.7997496445018 | -122.414138138868 | (37.7997496445018, -122.414138138868) | 5 | 1 | 10 | 308 | 32 | ||
| 162096 | 72054 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 901 Union St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/23/2008 12:00:00 AM | 3x3 | Permit Number 51732 | 6008662.62801958 | 2119324.4506425 | 37.7997496445018 | -122.414138138868 | (37.7997496445018, -122.414138138868) | 5 | 1 | 10 | 308 | 32 | ||
| 75057 | 131558 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 919 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6008615.40516 | 2119319.21628 | 37.7997326197206 | -122.414301177366 | (37.7997326197206, -122.414301177366) | 5 | 1 | 10 | 308 | 32 | |||
| 73628 | 66087 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 901 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/08/1990 12:00:00 AM | 13 | Permit Number 29131 | 6008573.05299 | 2119313.52327 | 37.7997146090041 | -122.414447328887 | (37.7997146090041, -122.414447328887) | 5 | 1 | 10 | 308 | 32 | ||
| 47832 | 91468 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 411 Green St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | Permit Number 52109 | 6010988.5676 | 2119298.0924 | 37.7998076397926 | -122.406087631017 | (37.7998076397926, -122.406087631017) | 3 | 1 | 10 | 308 | 23 | ||
| 147299 | 91467 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 411 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/17/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52109 | 6010979.3976 | 2119296.703 | 37.7998033119408 | -122.406119264846 | (37.7998033119408, -122.406119264846) | 3 | 1 | 10 | 308 | 23 | |
| 135668 | 50794 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 411 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/17/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52109 | 6010967.4487 | 2119294.2021 | 37.7997957767383 | -122.406160436395 | (37.7997957767383, -122.406160436395) | 3 | 1 | 10 | 308 | 23 | |
| 190705 | 66724 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 985 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/14/1991 12:00:00 AM | 16 | 3x3 | Permit Number 29967 | 6008288.03327 | 2119274.40334 | 37.7995911797528 | -122.415430833761 | (37.7995911797528, -122.415430833761) | 5 | 1 | 10 | 308 | 32 | |
| 177416 | 131578 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1120 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6007609.65535 | 2119231.20648 | 37.7994344198258 | -122.417775208982 | (37.7994344198258, -122.417775208982) | 5 | 1 | 1 | 28858 | 32 | |||
| 124710 | 131579 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1120 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007587.78023 | 2119227.99956 | 37.7994243833885 | -122.41785067739 | (37.7994243833885, -122.41785067739) | 5 | 1 | 1 | 28858 | 32 | |||
| 117436 | 131580 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1120 Union St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6007568.74186 | 2119226.23953 | 37.7994184793493 | -122.417916432217 | (37.7994184793493, -122.417916432217) | 5 | 1 | 1 | 28858 | 32 | |||
| 142918 | 112878 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1358 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6006478.15838 | 2119066.58629 | 37.7989186748263 | -122.421678897082 | (37.7989186748263, -122.421678897082) | 13 | 9 | 1 | 28858 | 32 |
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) );