trees
8,758 rows where qSpecies_id = 16 sorted by qCareAssistant 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
7005 | 60053 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1406 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/24/1982 12:00:00 AM | 24 | 3x3 | Permit Number 19552 | 5988377.0869 | 2105705.2719 | 37.7611949257495 | -122.483333852456 | (37.7611949257495, -122.483333852456) | 1 | 8 | 3 | 56 | 35 |
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 | ||
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 | |||
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 | |
8345 | 258530 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2122 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/28/2019 12:00:00 AM | 3 | 3x3 | Permit Number 784316 | 5981434 | 2100610 | 37.7467982300359 | -122.506968637856 | (37.7467982300359, -122.506968637856) | 1 | 8 | 3 | 29491 | 35 |
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 | |
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 | |||
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 | ||
9199 | 59852 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1123 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/1981 12:00:00 AM | 18 | 4x4 | Permit Number 19308 | 6017402.1303 | 2093334.4078 | 37.7288735235199 | -122.382086980049 | (37.7288735235199, -122.382086980049) | 10 | 3 | 8 | 58 | 1 |
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 | |||
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 | |||
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 | |||
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 | ||
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 | |
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 | |||
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 | |||
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 | |
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 | ||||
10224 | 60401 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1537 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 20 | 4x4 | Permit Number 19982 | 6015576.0436 | 2094341.847 | 37.7315387293778 | -122.388470234454 | (37.7315387293778, -122.388470234454) | 10 | 3 | 8 | 58 | 1 |
10249 | 60355 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1219 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 15 | 3x3 | Permit Number 19933 | 6016860.2126 | 2093732.327 | 37.7299361871824 | -122.383988142876 | (37.7299361871824, -122.383988142876) | 10 | 3 | 8 | 58 | 1 |
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 | |
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 | |||
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 | ||
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 | |
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 | |
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 | |||
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |||
13760 | 74588 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1335 Griffith St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6017904.0953 | 2092578.1569 | 37.7268247152753 | -122.380299097717 | (37.7268247152753, -122.380299097717) | 10 | 3 | 8 | 58 | 1 | |||
13791 | 47886 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4737 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2002 12:00:00 AM | 6 | Permit Number 45632 | 5981014.1249 | 2106186.9276 | 37.7620861496896 | -122.508834503155 | (37.7620861496896, -122.508834503155) | 1 | 8 | 3 | 56 | 35 | |
13964 | 42655 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2535 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | 7 | Permit Number 42692 | 5983937.5442 | 2098094.9316 | 37.7400396597472 | -122.498126046785 | (37.7400396597472, -122.498126046785) | 1 | 8 | 3 | 29491 | 35 | |
14078 | 78524 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3550 Santiago St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5981824.7341 | 2099468.7935 | 37.7436877981073 | -122.50553296194 | (37.7436877981073, -122.50553296194) | 1 | 8 | 3 | 29491 | 35 | |||
14148 | 89566 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 5001X Anza St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/2020 12:00:00 AM | 3 | 3x3 | Permit Number 782749 | 5983110.49799 | 2111681.5935 | 37.7772962731377 | -122.501990666002 | (37.7772962731377, -122.501990666002) | 11 | 6 | 2 | 55 | 26 |
14271 | 74932 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1494 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 4.5x6 | 5982503.1091 | 2104954.5575 | 37.7587900699554 | -122.503593501173 | (37.7587900699554, -122.503593501173) | 1 | 8 | 3 | 56 | 35 | ||
14348 | 31622 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2400 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/22/1995 12:00:00 AM | Permit Number 35554 | 5992052.25118753 | 2099087.40328319 | 37.7432371814309 | -122.470141233061 | (37.7432371814309, -122.470141233061) | 1 | 8 | 4 | 29491 | 40 | ||
14477 | 60391 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1466 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 12 | Permit Number 19971 | 6015630.4552 | 2094729.0488 | 37.7326049228687 | -122.388309135448 | (37.7326049228687, -122.388309135448) | 10 | 3 | 8 | 58 | 1 | |
14487 | 79638 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1307 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5982729.5509 | 2106184.5595 | 37.7621806168968 | -122.502901428306 | (37.7621806168968, -122.502901428306) | 1 | 8 | 3 | 56 | 35 | |||
14564 | 75201 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1335 Griffith St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6017848.7148 | 2092502.4066 | 37.7266136638108 | -122.380485286019 | (37.7266136638108, -122.380485286019) | 10 | 3 | 8 | 58 | 1 | |||
14630 | 78288 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 335 Holyoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6009671.33901 | 2092844.10016 | 37.7270972531353 | -122.408778404709 | (37.7270972531353, -122.408778404709) | 10 | 3 | 7 | 309 | 28 | |||
14646 | 78342 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4355 Anza St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5985108.45744 | 2111754.27861 | 37.7776130145544 | -122.49508454206 | (37.7776130145544, -122.49508454206) | 11 | 6 | 2 | 55 | 26 | |||
14756 | 82454 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2925 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5998033.9539 | 2113051.1833 | 37.7819221967761 | -122.450464611064 | (37.7819221967761, -122.450464611064) | 15 | 6 | 2 | 54 | 16 | |||
15025 | 37102 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1200 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | Permit Number 39701 | 5981201.77477995 | 2106888.46207069 | 37.7640234205488 | -122.508237579769 | (37.7640234205488, -122.508237579769) | 1 | 8 | 3 | 56 | 35 | ||
15082 | 75215 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 40 Vega St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 14 | 5999304.897 | 2112369.9402 | 37.7801243384858 | -122.446018736764 | (37.7801243384858, -122.446018736764) | 15 | 5 | 1 | 54 | 16 | |||
15122 | 78380 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1027 Russia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6x4 | 6003865.37713 | 2089493.15016 | 37.7175693740048 | -122.428610778768 | (37.7175693740048, -122.428610778768) | 9 | 7 | 6 | 28861 | 5 | ||
15379 | 71911 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 54 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 6008864.22373 | 2112520.03206 | 37.7810776884121 | -122.41295917575 | (37.7810776884121, -122.41295917575) | 7 | 10 | 9 | 28852 | 36 | |||
15412 | 41620 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2285 Jerrold Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/2002 12:00:00 AM | 7 | Permit Number 44542 | 6011764.26407 | 2099627.4064 | 37.7458397873891 | -122.402019808872 | (37.7458397873891, -122.402019808872) | 10 | 3 | 8 | 58 | 1 | |
15532 | 78806 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 463-473 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5987775.75942 | 2112816.18312 | 37.7806844956402 | -122.485935525167 | (37.7806844956402, -122.485935525167) | 11 | 6 | 2 | 55 | 26 | |||
15595 | 69040 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1477 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1994 12:00:00 AM | 6 | Permit Number 33047 | 5984317.8775 | 2105128.1273 | 37.7593731725357 | -122.497330103941 | (37.7593731725357, -122.497330103941) | 1 | 8 | 3 | 56 | 35 | |
15683 | 69869 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2075 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5982287.0182 | 2100994.7374 | 37.747904810916 | -122.504047526011 | (37.747904810916, -122.504047526011) | 1 | 8 | 3 | 29491 | 35 | |||
15758 | 260531 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1790x 46th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 07/27/2019 12:00:00 AM | 3 | ||||||||||||
15825 | 60408 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1438 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 16 | 3x3 | Permit Number 19989 | 6016124.8888 | 2094009.3762 | 37.7306562300917 | -122.386549578822 | (37.7306562300917, -122.386549578822) | 10 | 3 | 8 | 58 | 1 |
15855 | 73381 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1475 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 5982456.3495 | 2105084.8019 | 37.7591449348846 | -122.503764860601 | (37.7591449348846, -122.503764860601) | 1 | 8 | 3 | 56 | 35 | |||
16061 | 69750 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 805 University St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6008877.58173 | 2090316.9331 | 37.7201136936615 | -122.411343969962 | (37.7201136936615, -122.411343969962) | 9 | 3 | 7 | 309 | 28 | |||
16228 | 70437 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2374 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5983020.7059 | 2098971.1879 | 37.7423918202223 | -122.501360846382 | (37.7423918202223, -122.501360846382) | 1 | 8 | 3 | 29491 | 35 | |||
16296 | 60403 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1547 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 11 | Permit Number 19984 | 6015505.1437 | 2094394.6098 | 37.7316796762211 | -122.388719033204 | (37.7316796762211, -122.388719033204) | 10 | 3 | 8 | 58 | 1 | |
16381 | 60365 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1411 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 12 | Permit Number 19943 | 6015862.9412 | 2094478.9752 | 37.7319311503682 | -122.387487927897 | (37.7319311503682, -122.387487927897) | 10 | 3 | 8 | 58 | 1 | |
16384 | 59855 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1195 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/1981 12:00:00 AM | 14 | Permit Number 19312 | 6017044.3327 | 2093602.6185 | 37.7295902103514 | -122.383342586023 | (37.7295902103514, -122.383342586023) | 10 | 3 | 8 | 58 | 1 | |
16389 | 59849 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1271 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/1981 12:00:00 AM | 16 | 6x6 | Permit Number 19304 | 6016627.7267 | 2093908.2029 | 37.7304062521082 | -122.3848041294 | (37.7304062521082, -122.3848041294) | 10 | 3 | 8 | 58 | 1 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );