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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3801 | 183067 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2642 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | SFUSD | 8 | Width 0ft | 5983405.3697 | 2096822.8928 | 37.736515769554 | -122.499872058038 | (37.736515769554, -122.499872058038) | 1 | 8 | 3 | 29491 | 35 | ||
42549 | 98221 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1501X 42nd Ave | 16 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 6 | 3x25 | 5982958.4 | 2104692.7 | 37.758097840563 | -122.50199954491 | (37.758097840563, -122.50199954491) | 1 | 8 | 3 | 56 | 35 | ||
62704 | 98219 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1501X 42nd Ave | 13 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 4 | 3x25 | 5982958.4 | 2104692.7 | 37.758097840563 | -122.50199954491 | (37.758097840563, -122.50199954491) | 1 | 8 | 3 | 56 | 35 | ||
73737 | 113813 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4101x 25TH ST | 6 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 5 | 3x3 | 6002889 | 2101238 | 37.7497627495089 | -122.43282423124 | (37.7497627495089, -122.43282423124) | 2 | 4 | 5 | 28862 | 22 | ||
154938 | 113811 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4101x 25TH ST | 4 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 5 | 3x3 | 6002889 | 2101238 | 37.7497627495089 | -122.43282423124 | (37.7497627495089, -122.43282423124) | 2 | 4 | 5 | 28862 | 22 | ||
177608 | 113816 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4101x 25TH ST | 9 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | SFUSD | 10 | 3x3 | 6002889 | 2101238 | 37.7497627495089 | -122.43282423124 | (37.7497627495089, -122.43282423124) | 2 | 4 | 5 | 28862 | 22 | ||
1542 | 261489 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1100X Portola Dr | 3 | Median : Cutout | Tree | DPW 1 | Private | 3x3 | 5995262 | 2098056 | 37.7405902419398 | -122.458968175006 | (37.7405902419398, -122.458968175006) | 1 | 7 | 4 | 59 | 40 | |||
4790 | 102992 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 633 Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 5 | 3x3 | 5993571.87038 | 2110700.08123 | 37.7752103110101 | -122.465730364497 | (37.7752103110101, -122.465730364497) | 11 | 6 | 2 | 54 | 11 | ||
171910 | 91184 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 Fell St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 10/16/2008 12:00:00 AM | 5 | Permit Number 51891 | 6007394.40571 | 2110929.76906 | 37.776628592972 | -122.417931258428 | (37.776628592972, -122.417931258428) | 7 | 9 | 9 | 28852 | 36 | |
554 | 63105 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 86 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1987 12:00:00 AM | Permit Number 23825 | 6006733.57538349 | 2099199.19959074 | 37.7443819667232 | -122.41938488452 | (37.7443819667232, -122.41938488452) | 2 | 7 | 7 | 28859 | 2 | ||
564 | 67334 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 801 University St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/21/1992 12:00:00 AM | 12 | Permit Number 30818 | 6008868.73151 | 2090340.18885 | 37.7201770527016 | -122.411376204361 | (37.7201770527016, -122.411376204361) | 9 | 3 | 7 | 309 | 28 | |
656 | 37103 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1200 48th Ave | 2 | 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 | ||
715 | 67254 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2107 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1994 12:00:00 AM | 4 | Permit Number 32998 | 5981675.3208 | 2100708.9402 | 37.7470841010946 | -122.506141523298 | (37.7470841010946, -122.506141523298) | 1 | 8 | 3 | 29491 | 35 | |
865 | 65062 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 481 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/31/1989 12:00:00 AM | Permit Number 27018 | 5982198.4613122 | 2112526.22921648 | 37.7795617740877 | -122.505208255718 | (37.7795617740877, -122.505208255718) | 11 | 6 | 2 | 55 | 26 | ||
896 | 184943 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2000 41st Ave | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | FUF | 12/12/2019 12:00:00 AM | 3 | 3x10 | 5983552 | 2101519 | 37.7494185989562 | -122.499712087956 | (37.7494185989562, -122.499712087956) | 1 | 8 | 3 | 29491 | 35 | |
915 | 40138 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1501 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/1979 12:00:00 AM | 12 | Permit Number 41341 | 5982776.0706 | 2104863.9918 | 37.7585574465855 | -122.502642786425 | (37.7585574465855, -122.502642786425) | 1 | 8 | 3 | 56 | 35 | |
962 | 41611 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2285 Jerrold Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/2002 12:00:00 AM | 6 | Permit Number 44542 | 6011801.95167 | 2099599.86034 | 37.7457662552178 | -122.401887553691 | (37.7457662552178, -122.401887553691) | 10 | 3 | 8 | 58 | 1 | |
1001 | 70458 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3222 Santiago St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5982856.1897 | 2099504.4786 | 37.74384642674 | -122.501969135738 | (37.74384642674, -122.501969135738) | 1 | 8 | 3 | 29491 | 35 | |||
1009 | 41623 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2285 Jerrold Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/2002 12:00:00 AM | 5 | Permit Number 44542 | 6011709.24435 | 2099669.58737 | 37.745952536283 | -122.402213025506 | (37.745952536283, -122.402213025506) | 10 | 3 | 8 | 58 | 1 | |
1213 | 31454 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 625 Douglass St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/01/1995 12:00:00 AM | 16 | Permit Number 35026 | 6001228.91963 | 2102742.34175 | 37.7537990168301 | -122.438672624946 | (37.7537990168301, -122.438672624946) | 2 | 4 | 5 | 28862 | 22 | |
1254 | 61578 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 740 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/23/1984 12:00:00 AM | 13 | Permit Number 21541 | 6012694.18956 | 2104059.23085 | 37.7580604768161 | -122.399115263054 | (37.7580604768161, -122.399115263054) | 10 | 3 | 8 | 28856 | 29 | |
1274 | 78340 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4355 Anza St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5985152.99367 | 2111756.8586 | 37.7776227056539 | -122.494930668748 | (37.7776227056539, -122.494930668748) | 11 | 6 | 2 | 55 | 26 | |||
1317 | 71329 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 346 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6003746.38005 | 2089169.34853 | 37.7166735503194 | -122.428999024181 | (37.7166735503194, -122.428999024181) | 9 | 7 | 6 | 28861 | 5 | |||
1394 | 60245 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2501 Lincoln Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/23/1982 12:00:00 AM | 15 | Permit Number 19797 | 5987888.319 | 2107103.366 | 37.7650052514475 | -122.485126853783 | (37.7650052514475, -122.485126853783) | 1 | 8 | 3 | 56 | 35 | |
1440 | 60253 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1258 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/23/1982 12:00:00 AM | 12 | Permit Number 19805 | 5988032.4773 | 2106727.2678 | 37.7639809852919 | -122.484600662652 | (37.7639809852919, -122.484600662652) | 1 | 8 | 3 | 56 | 35 | |
1466 | 61584 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 779 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/23/1984 12:00:00 AM | 17 | Permit Number 21548 | 6012760.83948 | 2103909.15662 | 37.7576521198591 | -122.398874224986 | (37.7576521198591, -122.398874224986) | 10 | 3 | 8 | 28856 | 29 | |
1485 | 70364 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4039 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 5982287.6338 | 2104871.478 | 37.7585492864556 | -122.504332547004 | (37.7585492864556, -122.504332547004) | 1 | 8 | 3 | 56 | 35 | |||
1610 | 60248 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1238 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/23/1982 12:00:00 AM | 14 | Permit Number 19800 | 5988026.3501 | 2106852.875 | 37.7643255113996 | -122.48463106882 | (37.7643255113996, -122.48463106882) | 1 | 8 | 3 | 56 | 35 | |
1621 | 71826 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1559 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 13 | 5988678.2006 | 2104711.6203 | 37.7584841471685 | -122.482219640193 | (37.7584841471685, -122.482219640193) | 1 | 8 | 3 | 56 | 35 | |||
1629 | 73716 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 946 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 14 | 3x3 | 6012746.53827 | 2103105.12598 | 37.7554436304258 | -122.398867256125 | (37.7554436304258, -122.398867256125) | 10 | 3 | 8 | 28856 | 29 | ||
1717 | 61572 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 900 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/23/1984 12:00:00 AM | 14 | Permit Number 21533 | 6012736.84256 | 2103280.10738 | 37.7559235509547 | -122.39891306758 | (37.7559235509547, -122.39891306758) | 10 | 3 | 8 | 28856 | 29 | |
1874 | 78526 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3550 Santiago St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5981863.3141 | 2099471.5008 | 37.7436975019585 | -122.505399764525 | (37.7436975019585, -122.505399764525) | 1 | 8 | 3 | 29491 | 35 | |||
1909 | 72386 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 350 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 3x3 | 6012294.64496 | 2118148.60765 | 37.7967243955558 | -122.401487260038 | (37.7967243955558, -122.401487260038) | 3 | 1 | 10 | 28860 | 4 | ||
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 | |
2020 | 61588 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 803 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/23/1984 12:00:00 AM | 15 | Permit Number 21555 | 6012773.15046 | 2103707.15078 | 37.7570981419736 | -122.398817471471 | (37.7570981419736, -122.398817471471) | 10 | 3 | 8 | 28856 | 29 | |
2021 | 40151 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1232 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/12/2000 12:00:00 AM | 1 | Permit Number 43635 | 5982132.3748 | 2106725.7272 | 37.7636313927747 | -122.505006903253 | (37.7636313927747, -122.505006903253) | 1 | 8 | 3 | 56 | 35 | |
2042 | 71413 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1207 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6016921.2196 | 2093689.4573 | 37.7298218479605 | -122.38377424868 | (37.7298218479605, -122.38377424868) | 10 | 3 | 8 | 58 | 1 | |||
2182 | 83139 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 101X Whitney Young Cir | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6016637.95414 | 2095483.71733 | 37.7347328669128 | -122.384878489677 | (37.7347328669128, -122.384878489677) | 10 | 3 | 8 | 58 | 1 | |||
2228 | 48000 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1901 16th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2002 12:00:00 AM | Permit Number 45728 | 5991233.33873947 | 2102463.46573508 | 37.752459596695 | -122.47321895744 | (37.752459596695, -122.47321895744) | 1 | 8 | 4 | 29491 | 12 | ||
2373 | 183738 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2271 35th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | FUF | 09/26/2020 12:00:00 AM | 3 | 4x6 | 5985432.7595 | 2099768.105 | 37.7447212985473 | -122.493079504102 | (37.7447212985473, -122.493079504102) | 1 | 8 | 3 | 29491 | 35 | |
2401 | 75310 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 40 Vega St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 14 | 5999369.874 | 2112377.7239 | 37.7801494207177 | -122.445794512547 | (37.7801494207177, -122.445794512547) | 15 | 5 | 1 | 54 | 16 | |||
2422 | 80046 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2325 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6001817.74148 | 2118715.85745 | 37.7976917657091 | -122.437780314931 | (37.7976917657091, -122.437780314931) | 13 | 9 | 1 | 57 | 17 | |||
2425 | 31630 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2482 Great Hwy | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/22/1995 12:00:00 AM | Permit Number 35147 | 5981478.22688702 | 2098193.22560061 | 37.7401650446812 | -122.506636494986 | (37.7401650446812, -122.506636494986) | 1 | 8 | 3 | 29491 | 35 | ||
2515 | 71240 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1929 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 19 | 6001514.7914 | 2112836.7931 | 37.781532142896 | -122.438407179792 | (37.781532142896, -122.438407179792) | 15 | 5 | 11 | 29490 | 41 | |||
2547 | 38368 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4245 Lawton St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/1998 12:00:00 AM | 3 | Permit Number 40431 | 5981092.1865 | 2104150.2665 | 37.7564986636188 | -122.508413331792 | (37.7564986636188, -122.508413331792) | 1 | 8 | 3 | 56 | 35 | |
2618 | 38070 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2495 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/1998 12:00:00 AM | 7 | Permit Number 40259 | 6000679.6833 | 2114111.2164 | 37.7849838454949 | -122.441387719132 | (37.7849838454949, -122.441387719132) | 15 | 6 | 11 | 29490 | 13 | |
2680 | 71821 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1270 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 13 | 5988034.775 | 2106656.0393 | 37.7637855451579 | -122.484587490638 | (37.7637855451579, -122.484587490638) | 1 | 8 | 3 | 56 | 35 | |||
2749 | 60098 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3349 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/19/1982 12:00:00 AM | 12 | Permit Number 19599 | 5998205.44012 | 2116147.0262 | 37.7904323787895 | -122.450094557236 | (37.7904323787895, -122.450094557236) | 13 | 6 | 1 | 54 | 31 | |
2972 | 74792 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 749 Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6007023.88187 | 2113548.27609 | 37.783797519769 | -122.419398818026 | (37.783797519769, -122.419398818026) | 7 | 9 | 9 | 28858 | 36 | |||
2973 | 60363 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1375 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 16 | 3x3 | Permit Number 19941 | 6016067.5333 | 2094325.1307 | 37.7315200536551 | -122.38676987853 | (37.7315200536551, -122.38676987853) | 10 | 3 | 8 | 58 | 1 |
3082 | 67279 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 419 Peru Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/18/1992 12:00:00 AM | 14 | Permit Number 30755 | 6004653.1094 | 2092898.46061 | 37.7269641597687 | -122.42613023813 | (37.7269641597687, -122.42613023813) | 9 | 7 | 6 | 28861 | 5 | |
3103 | 60359 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1313 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/27/1982 12:00:00 AM | 9 | Permit Number 19937 | 6016370.5081 | 2094099.468 | 37.7309171984938 | -122.385706704196 | (37.7309171984938, -122.385706704196) | 10 | 3 | 8 | 58 | 1 | |
3178 | 83368 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1129 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6011680.56998 | 2103127.21797 | 37.7554448364124 | -122.40255527513 | (37.7554448364124, -122.40255527513) | 10 | 3 | 8 | 28856 | 29 | |||
3260 | 41618 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2285 Jerrold Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/2002 12:00:00 AM | 8 | Permit Number 44542 | 6011819.02152 | 2099587.0159 | 37.7457319397853 | -122.401827625556 | (37.7457319397853, -122.401827625556) | 10 | 3 | 8 | 58 | 1 | |
3317 | 75134 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 40 Vega St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 13 | 5999276.808 | 2112366.556 | 37.7801134423261 | -122.44611566553 | (37.7801134423261, -122.44611566553) | 15 | 5 | 1 | 54 | 16 | |||
3432 | 60254 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1282 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/23/1982 12:00:00 AM | 13 | Permit Number 19806 | 5988036.3068 | 2106574.0882 | 37.7635606190909 | -122.484576181107 | (37.7635606190909, -122.484576181107) | 1 | 8 | 3 | 56 | 35 | |
3458 | 260537 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1238 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 07/27/2019 12:00:00 AM | 3 | 5982443.47735 | 2106679.23386 | 37.7635220339644 | -122.503927471267 | (37.7635220339644, -122.503927471267) | 1 | 8 | 3 | 56 | 35 | ||
3650 | 72105 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3024 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 13 | 5997692.6555 | 2113106.1769 | 37.7820536550082 | -122.451649308253 | (37.7820536550082, -122.451649308253) | 15 | 6 | 1 | 54 | 31 | |||
3651 | 61582 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 610 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/23/1984 12:00:00 AM | 15 | Permit Number 21545 | 6012664.32169 | 2104605.59333 | 37.759559003666 | -122.399256912572 | (37.759559003666, -122.399256912572) | 10 | 3 | 8 | 28856 | 29 | |
3702 | 61568 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1105 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/23/1984 12:00:00 AM | 15 | Permit Number 21528 | 6012846.16445 | 2102376.66137 | 37.753448975498 | -122.398471602981 | (37.753448975498, -122.398471602981) | 10 | 3 | 8 | 28856 | 29 | |
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 | |
3734 | 67984 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 35 Broad St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | Permit Number 31708 | 5996379.31437828 | 2088033.23094013 | 37.713134273022 | -122.454381139129 | (37.713134273022, -122.454381139129) | 9 | 8 | 6 | 28861 | 24 | ||
3811 | 32184 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 191 Lakeshore Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1995 12:00:00 AM | Permit Number 35516 | 5984219.12182319 | 2094256.3665376 | 37.7295164954065 | -122.49686924842 | (37.7295164954065, -122.49686924842) | 1 | 8 | 4 | 64 | 35 | ||
3859 | 75387 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 40 Vega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5999425.0368 | 2112388.5534 | 37.7801823052034 | -122.445604458946 | (37.7801823052034, -122.445604458946) | 15 | 5 | 1 | 54 | 16 | |||
4026 | 60353 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1183 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 11 | Permit Number 19931 | 6017103.6909 | 2093557.0007 | 37.729468233098 | -122.383134202737 | (37.729468233098, -122.383134202737) | 10 | 3 | 8 | 58 | 1 | |
4193 | 66459 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 26 Wood St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/09/1991 12:00:00 AM | 12 | Permit Number 29609 | 5998393.1041 | 2113638.7682 | 37.7835561003446 | -122.449264468811 | (37.7835561003446, -122.449264468811) | 15 | 6 | 1 | 54 | 31 | |
4208 | 60380 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1330 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 16 | Permit Number 19960 | 6016326.29547 | 2094210.25675 | 37.7312189557853 | -122.385867275362 | (37.7312189557853, -122.385867275362) | 10 | 3 | 8 | 58 | 1 | |
4211 | 69761 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3621 Rivera St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5981890.0592 | 2100093.2822 | 37.7454063146777 | -122.50535336411 | (37.7454063146777, -122.50535336411) | 1 | 8 | 3 | 29491 | 35 | |||
4225 | 78616 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 240 Wayland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6010824.43374 | 2092444.67892 | 37.7260650445568 | -122.404764042448 | (37.7260650445568, -122.404764042448) | 10 | 3 | 7 | 309 | 28 | |||
4351 | 65141 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 430 Point Lobos Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1989 12:00:00 AM | Permit Number 27116 | 5981364.99930459 | 2112708.09753982 | 37.7800120543584 | -122.508105008848 | (37.7800120543584, -122.508105008848) | 11 | 6 | 2 | 55 | 26 | ||
4526 | 41616 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2285 Jerrold Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/2002 12:00:00 AM | 7 | Permit Number 44542 | 6011852.88096 | 2099562.22592 | 37.7456657613751 | -122.401708801727 | (37.7456657613751, -122.401708801727) | 10 | 3 | 8 | 58 | 1 | |
4629 | 79880 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1874 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5981353.9893 | 2102319.4895 | 37.7514872949963 | -122.507372114024 | (37.7514872949963, -122.507372114024) | 1 | 8 | 3 | 56 | 35 | |||
4631 | 71412 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1347 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 14 | 6016206.5271 | 2094219.1986 | 37.731236879718 | -122.38628196304 | (37.731236879718, -122.38628196304) | 10 | 3 | 8 | 58 | 1 | |||
4707 | 60404 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1559 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 12 | Permit Number 19985 | 6015464.4723 | 2094423.1896 | 37.7317558964013 | -122.388861638128 | (37.7317558964013, -122.388861638128) | 10 | 3 | 8 | 58 | 1 | |
4715 | 34359 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1827 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38115 | 6004598.72588548 | 2098167.19179023 | 37.7414278382274 | -122.426693274937 | (37.7414278382274, -122.426693274937) | 2 | 7 | 5 | 63 | 7 | ||
4774 | 81182 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2119 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 5982918.3441 | 2100688.6349 | 37.7471014440375 | -122.501841820419 | (37.7471014440375, -122.501841820419) | 1 | 8 | 3 | 29491 | 35 | |||
4927 | 60400 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1515 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 9 | Permit Number 19981 | 6015674.9738 | 2094268.7486 | 37.731343497592 | -122.388123111176 | (37.731343497592, -122.388123111176) | 10 | 3 | 8 | 58 | 1 | |
4942 | 60050 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1446 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/24/1982 12:00:00 AM | 14 | Permit Number 19548 | 5988385.7954 | 2105465.1018 | 37.7605359907495 | -122.483286128086 | (37.7605359907495, -122.483286128086) | 1 | 8 | 3 | 56 | 35 | |
4967 | 61581 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 640 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/23/1984 12:00:00 AM | 16 | Permit Number 21544 | 6012673.53684 | 2104479.8966 | 37.7592143816602 | -122.399216218276 | (37.7592143816602, -122.399216218276) | 10 | 3 | 8 | 28856 | 29 | |
5039 | 43055 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2183 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/07/2000 12:00:00 AM | 7 | Permit Number 42905 | 5981687.8424 | 2100251.3939 | 37.7458285438516 | -122.506064306101 | (37.7458285438516, -122.506064306101) | 1 | 8 | 3 | 29491 | 35 | |
5155 | 60379 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1294 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 13 | Permit Number 19959 | 6016555.73606 | 2094038.62564 | 37.7307603851837 | -122.385062097043 | (37.7307603851837, -122.385062097043) | 10 | 3 | 8 | 58 | 1 | |
5171 | 108539 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 401-423X Wheeler Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773817 | 6011972.2839 | 2086844.73133 | 37.710752810564 | -122.400402802668 | (37.710752810564, -122.400402802668) | 10 | 3 | 8 | 309 | 1 |
5233 | 65185 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 247 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/1989 12:00:00 AM | 9 | Permit Number 27169 | 6003009.64323 | 2091977.07087 | 37.7243412033768 | -122.43174590807 | (37.7243412033768, -122.43174590807) | 9 | 7 | 6 | 28861 | 5 | |
5326 | 59848 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1263 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/1981 12:00:00 AM | 15 | Permit Number 19303 | 6016663.4515 | 2093881.8215 | 37.7303357898053 | -122.384678785547 | (37.7303357898053, -122.384678785547) | 10 | 3 | 8 | 58 | 1 | |
5362 | 109193 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4124 Moraga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773525 | ||||||||||
5436 | 59846 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1243 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/1981 12:00:00 AM | 13 | Permit Number 19301 | 6016762.3817 | 2093805.9751 | 37.7301330013468 | -122.384331486532 | (37.7301330013468, -122.384331486532) | 10 | 3 | 8 | 58 | 1 | |
5681 | 60249 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1254 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/23/1982 12:00:00 AM | 13 | Permit Number 19801 | 5988030.9455 | 2106760.2014 | 37.7640713227243 | -122.484608376536 | (37.7640713227243, -122.484608376536) | 1 | 8 | 3 | 56 | 35 | |
5819 | 37136 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4641 Lincoln Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | 7 | 3x3 | Permit Number 39718 | 5981284.3022 | 2106878.7818 | 37.7640017042438 | -122.507951428358 | (37.7640017042438, -122.507951428358) | 1 | 8 | 3 | 56 | 35 |
5889 | 37810 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1746 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/2002 12:00:00 AM | Permit Number 44738 | 5981328.72954544 | 2103184.35370388 | 37.7538604793554 | -122.507523629232 | (37.7538604793554, -122.507523629232) | 1 | 8 | 3 | 56 | 35 | ||
6017 | 68305 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2146 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | 7 | Permit Number 32116 | 5981725.4073 | 2100475.4291 | 37.7464458932007 | -122.505951021438 | (37.7464458932007, -122.505951021438) | 1 | 8 | 3 | 29491 | 35 | |
6164 | 68307 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2167 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | Permit Number 32118 | 5981682.0022594 | 2100343.28066189 | 37.7460804954734 | -122.506091311951 | (37.7460804954734, -122.506091311951) | 1 | 8 | 3 | 29491 | 35 | ||
6202 | 35215 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 14 Shore View Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/10/1998 12:00:00 AM | 8 | Permit Number 38719 | 5984575.36767 | 2112876.98496 | 37.7806644184241 | -122.497011539732 | (37.7806644184241, -122.497011539732) | 11 | 6 | 2 | 55 | 26 | |
6483 | 60247 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1234 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/23/1982 12:00:00 AM | 14 | Permit Number 19799 | 5988027.8819 | 2106876.6178 | 37.7643907918226 | -122.484627512544 | (37.7643907918226, -122.484627512544) | 1 | 8 | 3 | 56 | 35 | |
6516 | 78525 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3550 Santiago St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5981839.963 | 2099470.1472 | 37.7436924112004 | -122.505480405304 | (37.7436924112004, -122.505480405304) | 1 | 8 | 3 | 29491 | 35 | |||
6563 | 71813 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3353 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 13 | 5998192.69497 | 2116144.55888 | 37.7904248748608 | -122.450138476504 | (37.7904248748608, -122.450138476504) | 13 | 6 | 1 | 54 | 31 | |||
6685 | 68314 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3815 Quintara St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | 7 | Permit Number 32127 | 5981596.2993 | 2100763.5953 | 37.7472295165668 | -122.506418820774 | (37.7472295165668, -122.506418820774) | 1 | 8 | 3 | 29491 | 35 | |
6763 | 78304 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4355 Anza St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5985168.78138 | 2111757.58069 | 37.7776256124831 | -122.494876107778 | (37.7776256124831, -122.494876107778) | 11 | 6 | 2 | 55 | 26 | |||
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 |
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) );