trees
8,758 rows where qSpecies_id = 16 sorted by PlotSize
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6780 | 31935 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1330 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1995 12:00:00 AM | 6 | Permit Number 35351 | 5981536.6923 | 2106016.9784 | 37.7616503077312 | -122.507014568071 | (37.7616503077312, -122.507014568071) | 1 | 8 | 3 | 56 | 35 | |
| 6784 | 60048 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1463 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/24/1982 12:00:00 AM | 14 | Permit Number 19546 | 5988345.982 | 2105367.5756 | 37.7602658931923 | -122.483416673161 | (37.7602658931923, -122.483416673161) | 1 | 8 | 3 | 56 | 35 | |
| 6800 | 65190 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 263 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/1989 12:00:00 AM | 14 | Permit Number 27174 | 6002953.3046 | 2091886.83764 | 37.7240902493544 | -122.431934222489 | (37.7240902493544, -122.431934222489) | 9 | 7 | 6 | 28861 | 5 | |
| 6869 | 51982 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 660 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/2005 12:00:00 AM | Permit Number 48204 | 6007266.85815782 | 2113345.5415055 | 37.7832545419232 | -122.4185438282 | (37.7832545419232, -122.4185438282) | 7 | 9 | 9 | 28858 | 36 | |||
| 6976 | 59854 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1182 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/1981 12:00:00 AM | 18 | Permit Number 19310 | 6017139.45768 | 2093603.92018 | 37.7295990411395 | -122.38301381645 | (37.7295990411395, -122.38301381645) | 10 | 3 | 8 | 58 | 1 | |
| 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 | ||
| 7313 | 33583 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 151 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/1996 12:00:00 AM | Permit Number 37691 | 6007181.85623533 | 2098126.23586774 | 37.7414610860553 | -122.417758780801 | (37.7414610860553, -122.417758780801) | 2 | 7 | 7 | 28859 | 2 | |||
| 7474 | 35177 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
| 7562 | 61590 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 909 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/23/1984 12:00:00 AM | 11 | Permit Number 21557 | 6012793.74418 | 2103295.37957 | 37.7559686555484 | -122.398717353534 | (37.7559686555484, -122.398717353534) | 10 | 3 | 8 | 28856 | 29 | |
| 7611 | 70362 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3934 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5982621.9145 | 2104937.2986 | 37.7587496661055 | -122.503181346298 | (37.7587496661055, -122.503181346298) | 1 | 8 | 3 | 56 | 35 | |||
| 7688 | 58773 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1185 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/1979 12:00:00 AM | 17 | Permit Number 18016 | 6011971.93292 | 2102954.59115 | 37.7549871030883 | -122.401535514949 | (37.7549871030883, -122.401535514949) | 10 | 3 | 8 | 28856 | 29 | ||
| 7734 | 61566 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1111 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/23/1984 12:00:00 AM | 13 | Permit Number 21526 | 6012850.93763 | 2102313.95355 | 37.7532770593148 | -122.398450696442 | (37.7532770593148, -122.398450696442) | 10 | 3 | 8 | 28856 | 29 | |
| 7875 | 71825 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1555 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 14 | 5988675.2864 | 2104754.3629 | 37.758601337299 | -122.482232850163 | (37.758601337299, -122.482232850163) | 1 | 8 | 3 | 56 | 35 | |||
| 7949 | 61573 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 939 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/23/1984 12:00:00 AM | 13 | Permit Number 21534 | 6012798.72555 | 2103171.42619 | 37.7556285841179 | -122.398691427883 | (37.7556285841179, -122.398691427883) | 10 | 3 | 8 | 28856 | 29 | |
| 7982 | 65224 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 424 Russia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/1989 12:00:00 AM | 15 | Permit Number 28011 | 6002436.63551 | 2090340.67814 | 37.7198155369321 | -122.433609818641 | (37.7198155369321, -122.433609818641) | 9 | 7 | 6 | 28861 | 5 | |
| 8085 | 60360 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1327 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 13 | Permit Number 19938 | 6016306.2035 | 2094147.2843 | 37.7310449340747 | -122.385932349662 | (37.7310449340747, -122.385932349662) | 10 | 3 | 8 | 58 | 1 | |
| 8406 | 41624 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2285 Jerrold Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/2002 12:00:00 AM | 5 | Permit Number 46000 | 6011690.97977 | 2099682.45584 | 37.745986850809 | -122.402277086926 | (37.745986850809, -122.402277086926) | 10 | 3 | 8 | 58 | 1 | |
| 8472 | 65709 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 142 Pope St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/1990 12:00:00 AM | Permit Number 28638 | 6000250.18995538 | 2088032.18663542 | 37.7133526386349 | -122.44100204672 | (37.7133526386349, -122.44100204672) | 9 | 7 | 6 | 28861 | 5 | ||
| 8478 | 63679 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3900 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1987 12:00:00 AM | 11 | Permit Number 24332 | 5982744.7336 | 2104942.115 | 37.7587701092211 | -122.502756944956 | (37.7587701092211, -122.502756944956) | 1 | 8 | 3 | 56 | 35 | |
| 8588 | 61586 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 895 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/23/1984 12:00:00 AM | 13 | Permit Number 21550 | 6012788.74443 | 2103337.06012 | 37.7560828226837 | -122.3987375694 | (37.7560828226837, -122.3987375694) | 10 | 3 | 8 | 28856 | 29 | |
| 8609 | 31455 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 625 Douglass St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/01/1995 12:00:00 AM | 14 | Permit Number 35026 | 6001232.34718 | 2102698.03632 | 37.7536775597828 | -122.438657597283 | (37.7536775597828, -122.438657597283) | 2 | 4 | 5 | 28862 | 22 | |
| 8676 | 34246 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 38056 | |||||||||||||||
| 8718 | 74934 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 747 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6007018.6844 | 2113571.6653 | 37.7838614481007 | -122.419418459219 | (37.7838614481007, -122.419418459219) | 7 | 9 | 9 | 28858 | 36 | |||
| 8762 | 97574 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 501x Presidio Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5999116.8 | 2114959.9 | 37.7872249510267 | -122.4468558657 | (37.7872249510267, -122.4468558657) | 15 | 6 | 1 | 54 | 31 | |||||
| 8806 | 41617 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2285 Jerrold Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/18/2020 12:00:00 AM | 4 | Permit Number 44542 | 6011837.54866 | 2099572.35682 | 37.7456927230357 | -122.401762530825 | (37.7456927230357, -122.401762530825) | 10 | 3 | 8 | 58 | 1 | |
| 8815 | 60244 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1211 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/23/1982 12:00:00 AM | 14 | Permit Number 19796 | 5987977.3326 | 2107012.5647 | 37.764761120752 | -122.484812320079 | (37.764761120752, -122.484812320079) | 1 | 8 | 3 | 56 | 35 | |
| 8839 | 60946 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1422 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/09/1983 12:00:00 AM | Permit Number 20749 | 5990554.23882352 | 2105697.78860744 | 37.7613008451159 | -122.475803544713 | (37.7613008451159, -122.475803544713) | 1 | 8 | 4 | 56 | 12 | ||
| 9207 | 78507 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 465 Brussels St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6010703.64551 | 2092552.92571 | 37.7263555156731 | -122.4051892212 | (37.7263555156731, -122.4051892212) | 10 | 3 | 7 | 309 | 28 | |||
| 9261 | 61896 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 19 Holyoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/15/1985 12:00:00 AM | 11 | Permit Number 21939 | 6009273.47888 | 2094140.55724 | 37.7306347561928 | -122.410245303295 | (37.7306347561928, -122.410245303295) | 9 | 3 | 7 | 309 | 28 | ||
| 9321 | 70250 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1475 44th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 5982457.955 | 2105055.9033 | 37.759065681929 | -122.503757167883 | (37.759065681929, -122.503757167883) | 1 | 8 | 3 | 56 | 35 | |||
| 9329 | 78804 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 463 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5987773.67277 | 2112847.71573 | 37.780770953663 | -122.485945059015 | (37.780770953663, -122.485945059015) | 11 | 6 | 2 | 55 | 26 | |||
| 9346 | 66616 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2450 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/1991 12:00:00 AM | 3 | Permit Number 29819 | 5985544.9203 | 2098918.2658 | 37.742394428205 | -122.492629101957 | (37.742394428205, -122.492629101957) | 1 | 8 | 3 | 29491 | 35 | ||
| 9347 | 114899 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1545 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/22/2015 12:00:00 AM | Permit Number 774413 | 5981525.9 | 2104542.4 | 37.7576009016243 | -122.506942509341 | (37.7576009016243, -122.506942509341) | 1 | 8 | 3 | 56 | 35 | |||
| 9491 | 72305 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3662 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5997266.67895 | 2115407.36737 | 37.7883477098214 | -122.453289170381 | (37.7883477098214, -122.453289170381) | 11 | 6 | 1 | 54 | 31 | |||
| 9535 | 124144 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4100x Geary Blvd | 6 | Median : Yard | Tree | DPW 1 | 14 | 5994110.98895 | 2112812.22704 | 37.7810407796467 | -122.464018802579 | (37.7810407796467, -122.464018802579) | 11 | 6 | 2 | 54 | 11 | ||||
| 9540 | 83049 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 100X Cargo Way | 5 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 11 | 6018864.16071 | 2097578.25634 | 37.7406069390666 | -122.377326932804 | (37.7406069390666, -122.377326932804) | 10 | 3 | 8 | 58 | 1 | ||||
| 9613 | 68469 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2766 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1993 12:00:00 AM | Permit Number 32334 | 6009569.05217042 | 2103972.19360753 | 37.757646840311 | -122.409917225443 | (37.757646840311, -122.409917225443) | 2 | 4 | 7 | 28859 | 19 | ||
| 9631 | 35176 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
| 9656 | 38138 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 423 Burrows St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1998 12:00:00 AM | 11 | Permit Number 40297 | 6010013.18685 | 2093111.14841 | 37.7278496529363 | -122.407615456286 | (37.7278496529363, -122.407615456286) | 10 | 3 | 7 | 309 | 28 | |
| 9679 | 111947 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 95 SEACLIFF AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 5987570 | 2115773 | 37.7887910778243 | -122.486864535179 | (37.7887910778243, -122.486864535179) | 11 | 6 | 1 | 55 | 33 | ||||
| 9728 | 74639 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 749 Polk St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6007029.8225 | 2113512.73169 | 37.7837002581006 | -122.419375743216 | (37.7837002581006, -122.419375743216) | 7 | 9 | 9 | 28858 | 36 | |||
| 9763 | 111086 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 582X Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5996560.16999 | 2095740.09269 | 37.7343058616961 | -122.454312386561 | (37.7343058616961, -122.454312386561) | 9 | 7 | 4 | 59 | 40 | |||||
| 9844 | 78523 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3550 Santiago St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5981811.5356 | 2099469.1319 | 37.7436879505195 | -122.505578623462 | (37.7436879505195, -122.505578623462) | 1 | 8 | 3 | 29491 | 35 | |||
| 9856 | 35210 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
| 9884 | 73155 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1539 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5984024.4181 | 2104677.685 | 37.7581191804023 | -122.498311745037 | (37.7581191804023, -122.498311745037) | 1 | 8 | 3 | 56 | 35 | |||
| 9926 | 80088 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2325 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6001799.98611 | 2118713.99662 | 37.7976856467424 | -122.437841619893 | (37.7976856467424, -122.437841619893) | 13 | 9 | 1 | 57 | 17 | |||
| 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 | |
| 10010 | 41581 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 291 18th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/2000 12:00:00 AM | Permit Number 42092 | 5990233.66540637 | 2113445.43887164 | 37.7825551838187 | -122.477478543034 | (37.7825551838187, -122.477478543034) | 11 | 6 | 2 | 55 | 26 | |||
| 10031 | 35174 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
| 10041 | 261145 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3425 Quintara St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5982854.31136486 | 2100808.2311864 | 37.7474260606989 | -122.502072085099 | (37.7474260606989, -122.502072085099) | 1 | 8 | 3 | 29491 | 35 | ||||
| 10252 | 61567 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1109 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/23/1984 12:00:00 AM | 12 | Permit Number 21527 | 6012849.03318 | 2102339.27738 | 37.7533464869733 | -122.398459059258 | (37.7533464869733, -122.398459059258) | 10 | 3 | 8 | 28856 | 29 | |
| 10392 | 111979 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 39 SEACLIFF AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5987939 | 2115796 | 37.788875735681 | -122.485589552136 | (37.788875735681, -122.485589552136) | 11 | 6 | 1 | 55 | 33 | |||||
| 10436 | 105254 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 130 GONZALEZ DR | Front Yard : Yard | Tree | Private 2 | 2 | 5990327 | 2090136 | 37.7185590045312 | -122.47545320092 | (37.7185590045312, -122.47545320092) | 1 | 8 | 4 | 64 | 14 | |||||
| 10476 | 70493 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 53 La Grande Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6005304.47442 | 2091965.67161 | 37.7244397195916 | -122.423812181596 | (37.7244397195916, -122.423812181596) | 9 | 7 | 6 | 309 | 5 | |||
| 10516 | 102842 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1101X Portola Dr | 8 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
| 10551 | 35179 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
| 10584 | 60431 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 454 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1982 12:00:00 AM | Permit Number 20015 | 6003628.53966279 | 2098964.72203761 | 37.7435627733769 | -122.430104722556 | (37.7435627733769, -122.430104722556) | 2 | 7 | 5 | 63 | 22 | ||
| 10702 | 60375 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1491 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 13 | Permit Number 19953 | 6015455.6786 | 2094782.3612 | 37.7327416219249 | -122.38891710664 | (37.7327416219249, -122.38891710664) | 10 | 3 | 8 | 58 | 1 | |
| 10785 | 71410 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1505 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 18 | 6015694.2103 | 2094255.0083 | 37.7313068352663 | -122.38805564796 | (37.7313068352663, -122.38805564796) | 10 | 3 | 8 | 58 | 1 | |||
| 10863 | 56635 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1919 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/04/1982 12:00:00 AM | Permit Number 20078 | 6001606.33187064 | 2112849.40553557 | 37.7815719798524 | -122.438091398042 | (37.7815719798524, -122.438091398042) | 15 | 5 | 11 | 29490 | 41 | ||
| 10900 | 256098 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1776 Vallejo St | 1 | Front Yard : Cutout | Tree | Private 2 | 6005064.21519 | 2118169.93221 | 37.7963768588038 | -122.426507729874 | (37.7963768588038, -122.426507729874) | 13 | 9 | 1 | 28858 | 17 | |||||
| 10914 | 80704 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3124 Turk Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5995997.04045 | 2111450.94518 | 37.7774115756637 | -122.457395540163 | (37.7774115756637, -122.457395540163) | 11 | 6 | 2 | 54 | 16 | |||
| 10964 | 41622 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2285 Jerrold Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/2002 12:00:00 AM | 4 | Permit Number 44542 | 6011727.78319 | 2099655.52277 | 37.7459149527148 | -122.402147931707 | (37.7459149527148, -122.402147931707) | 10 | 3 | 8 | 58 | 1 | |
| 10979 | 35203 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
| 11024 | 60241 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1275 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/23/1982 12:00:00 AM | 12 | Permit Number 19793 | 5987989.2041 | 2106633.4453 | 37.763720854288 | -122.484743446939 | (37.763720854288, -122.484743446939) | 1 | 8 | 3 | 56 | 35 | |
| 11159 | 40216 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 531 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/1999 12:00:00 AM | 6 | Permit Number 41395 | 5981594.18311 | 2112099.84077 | 37.77835546311 | -122.507267034014 | (37.77835546311, -122.507267034014) | 11 | 6 | 2 | 55 | 26 | |
| 11227 | 106481 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 301X LAWTON ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5993233 | 2104592 | 37.7584195821345 | -122.466458543785 | (37.7584195821345, -122.466458543785) | 1 | 8 | 4 | 56 | 12 | |||||
| 11287 | 72312 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3839 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5995843.90542 | 2115819.74251 | 37.7893983291806 | -122.458241562721 | (37.7893983291806, -122.458241562721) | 11 | 6 | 1 | 54 | 31 | |||
| 11355 | 70358 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3833 Lawton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5982319.9846 | 2104190.4495 | 37.7566812777905 | -122.504170218425 | (37.7566812777905, -122.504170218425) | 1 | 8 | 3 | 56 | 35 | |||
| 11384 | 258014 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4222 Moraga Ave | 1 | Sidewalk: Curb side : | Tree | DPW 1 | |||||||||||||||
| 11439 | 71820 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1262 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 5988034.0091 | 2106701.9931 | 37.7639116770979 | -122.484593510615 | (37.7639116770979, -122.484593510615) | 1 | 8 | 3 | 56 | 35 | |||
| 11521 | 61583 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 693 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/23/1984 12:00:00 AM | 16 | Permit Number 21546 | 6012739.37676 | 2104289.95716 | 37.7586965187374 | -122.398975179254 | (37.7586965187374, -122.398975179254) | 10 | 3 | 8 | 28856 | 29 | |
| 11528 | 213133 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 530 Flood Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | 5997236.23471 | 2094134.25097 | 37.7299353516323 | -122.451859215049 | (37.7299353516323, -122.451859215049) | 9 | 7 | 4 | 28861 | 40 | ||||
| 11690 | 35212 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
| 11773 | 59839 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1201 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/1981 12:00:00 AM | 3 | Permit Number 19293 | 6016946.5018 | 2093669.1216 | 37.7297674076459 | -122.383685429115 | (37.7297674076459, -122.383685429115) | 10 | 3 | 8 | 58 | 1 | |
| 11807 | 70932 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 250 23rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 14 | 5988727.46903 | 2113517.26751 | 37.7826648905872 | -122.482694534783 | (37.7826648905872, -122.482694534783) | 11 | 6 | 2 | 55 | 26 | |||
| 11862 | 260530 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1790x 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 07/27/2019 12:00:00 AM | 3 | ||||||||||||
| 11884 | 47747 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4250 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/30/2002 12:00:00 AM | 5 | Permit Number 45528 | 5982389.08626 | 2110352.01137 | 37.7736032226209 | -122.504387696378 | (37.7736032226209, -122.504387696378) | 11 | 6 | 2 | 55 | 26 | |
| 11988 | 64663 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 763 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/16/1988 12:00:00 AM | 11 | Permit Number 25592 | 5994719.47478 | 2110406.61059 | 37.7744706476124 | -122.461739287117 | (37.7744706476124, -122.461739287117) | 11 | 6 | 2 | 54 | 11 | ||
| 12020 | 32737 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 223 Farallones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | 5 | Permit Number 37120 | 5994748.23288 | 2088380.20466 | 37.7139933044225 | -122.460043789395 | (37.7139933044225, -122.460043789395) | 9 | 8 | 6 | 28861 | 24 | |
| 12084 | 70424 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1473 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5982456.3495 | 2105108.4827 | 37.7592099556411 | -122.503766614405 | (37.7592099556411, -122.503766614405) | 1 | 8 | 3 | 56 | 35 | |||
| 12135 | 41621 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2285 Jerrold Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/2002 12:00:00 AM | 8 | Permit Number 44542 | 6011745.13959 | 2099642.07767 | 37.7458790041264 | -122.402086970256 | (37.7458790041264, -122.402086970256) | 10 | 3 | 8 | 58 | 1 | |
| 12185 | 30909 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 125 De Montfort Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | 8 | Permit Number 34731 | 5994911.53291 | 2091873.96272 | 37.7235957238357 | -122.459732275923 | (37.7235957238357, -122.459732275923) | 9 | 8 | 4 | 28861 | 24 | |
| 12303 | 37089 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1235 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | 3 | Permit Number 39689 | 5981471.2295 | 2106667.1818 | 37.7634317237416 | -122.507289213813 | (37.7634317237416, -122.507289213813) | 1 | 8 | 3 | 56 | 35 | |
| 12386 | 73495 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 250 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 5988730.14838 | 2113498.62278 | 37.7826138532986 | -122.482683898749 | (37.7826138532986, -122.482683898749) | 11 | 6 | 2 | 55 | 26 | |||
| 12474 | 51019 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 251 Ramsell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2004 12:00:00 AM | Permit Number 47497 | 5992948.45681034 | 2088862.24435583 | 37.7152131901669 | -122.466299454682 | (37.7152131901669, -122.466299454682) | 9 | 8 | 6 | 64 | 24 | |||
| 12637 | 61564 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1133 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/23/1984 12:00:00 AM | 11 | Permit Number 21524 | 6012854.46592 | 2102240.95089 | 37.7530768063709 | -122.398433372797 | (37.7530768063709, -122.398433372797) | 10 | 3 | 8 | 28856 | 29 | |
| 12671 | 72120 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3440 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 13 | 5996351.3207 | 2112939.5041 | 37.7815191079205 | -122.456277632841 | (37.7815191079205, -122.456277632841) | 11 | 6 | 1 | 54 | 31 | |||
| 12818 | 41626 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2285 Jerrold Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/2002 12:00:00 AM | 7 | Permit Number 46000 | 6011671.24586 | 2099696.54444 | 37.7460244334925 | -122.402346314957 | (37.7460244334925, -122.402346314957) | 10 | 3 | 8 | 58 | 1 | |
| 12844 | 35183 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
| 13063 | 61571 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 901 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/23/1984 12:00:00 AM | 13 | Permit Number 21532 | 6012789.51451 | 2103320.13583 | 37.7560363951799 | -122.398733718512 | (37.7560363951799, -122.398733718512) | 10 | 3 | 8 | 28856 | 29 | |
| 13107 | 72287 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3814 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5983731.23615 | 2111080.74705 | 37.7756829689732 | -122.499798944694 | (37.7756829689732, -122.499798944694) | 11 | 6 | 2 | 55 | 26 | |||
| 13196 | 46378 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2270 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/05/2002 12:00:00 AM | 3 | Permit Number 44615 | 5982995.4513 | 2099678.43 | 37.7443322293912 | -122.501500475193 | (37.7443322293912, -122.501500475193) | 1 | 8 | 3 | 29491 | 35 | |
| 13204 | 61565 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1127 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/23/1984 12:00:00 AM | 15 | Permit Number 21525 | 6012854.07356 | 2102264.17995 | 37.7531405664834 | -122.39843635946 | (37.7531405664834, -122.39843635946) | 10 | 3 | 8 | 28856 | 29 | |
| 13254 | 74488 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2334 42nd Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 5983318.4565 | 2099328.1281 | 37.7433893618735 | -122.500357715236 | (37.7433893618735, -122.500357715236) | 1 | 8 | 3 | 29491 | 35 | |||
| 13287 | 75339 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 288 Eddy St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 15 | Permit Number 768105 | 6009126.26844 | 2113603.03631 | 37.7840660654432 | -122.41212919142 | (37.7840660654432, -122.41212919142) | 14 | 10 | 9 | 28852 | 36 | ||
| 13300 | 63559 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3655 Lawton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/1987 12:00:00 AM | 7 | Permit Number 24181 | 5982862.532 | 2104209.7007 | 37.7567660283709 | -122.502295347911 | (37.7567660283709, -122.502295347911) | 1 | 8 | 3 | 56 | 35 | |
| 13314 | 75092 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 288 Eddy St | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 16 | 6009056.34359 | 2113588.95965 | 37.7840234906369 | -122.412370111692 | (37.7840234906369, -122.412370111692) | 14 | 10 | 9 | 28852 | 36 | ||||
| 13414 | 40204 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 456 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/05/1999 12:00:00 AM | 8 | Permit Number 41386 | 5982550.06876 | 2112706.22643 | 37.7800766758746 | -122.504005251207 | (37.7800766758746, -122.504005251207) | 11 | 6 | 2 | 55 | 26 | |
| 13418 | 111948 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 75 SEACLIFF AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | 5987695 | 2115788 | 37.7888395504461 | -122.486433160149 | (37.7888395504461, -122.486433160149) | 11 | 6 | 1 | 55 | 33 |
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) );