trees
8,758 rows where qSpecies_id = 16 sorted by qLegalStatus_id
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3036 | 258017 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2342 43rd Ave | 1 | Sidewalk: Curb side : | Tree | DPW 1 | 3 | 5983011.19804 | 2099184.33916 | 37.7429765166721 | -122.501409485055 | (37.7429765166721, -122.501409485055) | 1 | 8 | 3 | 29491 | 35 | ||||
3066 | 11935 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 660X Keith St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6017236.56511 | 2096428.9556383 | 37.7373613939034 | -122.382874625964 | (37.7373613939034, -122.382874625964) | 10 | 3 | 8 | 58 | 1 | |||
3074 | 144281 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 690 45th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/16/2020 12:00:00 AM | 3 | Width 3ft | 5981991.18166 | 2111072.85964 | 37.7755590499331 | -122.505817535952 | (37.7755590499331, -122.505817535952) | 11 | 6 | 2 | 55 | 26 | ||
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 | |
3121 | 28070 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3445 Geary Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 5996465.30474 | 2112747.36669 | 37.780998091992 | -122.455869411327 | (37.780998091992, -122.455869411327) | 11 | 6 | 2 | 54 | 16 | |||
3153 | 16204 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 504 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4x4 | 5998737.42681 | 2094729.30283 | 37.7316550910092 | -122.446712233977 | (37.7316550910092, -122.446712233977) | 9 | 7 | 4 | 59 | 40 | |||
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 | |||
3245 | 177750 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1830 Alemany Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 5ft | Permit Number 784881 | 6001125.87502 | 2091373.61723 | 37.7225772947014 | -122.438214605635 | (37.7225772947014, -122.438214605635) | 9 | 7 | 6 | 28861 | 25 | ||
3249 | 9238 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 6400 Geary Blvd | 6 | Median : Cutout | Tree | DPW 1 | 12 | 8M | 5987194.6568724 | 2112586.3612843 | 37.7800195894976 | -122.487928920824 | (37.7800195894976, -122.487928920824) | 11 | 6 | 2 | 55 | 26 | |||
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 | |
3280 | 131640 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 John Maher St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6012516.39598 | 2119702.01834 | 37.8010020586619 | -122.400829137966 | (37.8010020586619, -122.400829137966) | 3 | 1 | 10 | 28860 | 6 | |||
3282 | 232681 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 998 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6009404.5391 | 2103406.76128 | 37.7560850691817 | -122.410446255909 | (37.7560850691817, -122.410446255909) | 2 | 4 | 7 | 28859 | 19 | |||
3290 | 122954 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 201 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5993081.91997 | 2114080.47457 | 37.7844636809028 | -122.467671095614 | (37.7844636809028, -122.467671095614) | 11 | 6 | 2 | 54 | 11 | |||
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 | |||
3318 | 185278 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2601 Sunset Blvd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984958.2606 | 2097437.8471 | 37.7382952768032 | -122.49454845339 | (37.7382952768032, -122.49454845339) | 1 | 8 | 3 | 29491 | 35 | |||
3330 | 213252 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 239 Byxbee St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 6ft | 5991927.67162 | 2090111.22138 | 37.7185836258199 | -122.4699185829 | (37.7185836258199, -122.4699185829) | 9 | 8 | 6 | 64 | 24 | |||
3339 | 19580 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 100 STAIRWAY4 | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 8 | |||||||||||||
3371 | 9374 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 300 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/03/1994 12:00:00 AM | 30 | 2X2 | 6001106.82258 | 2097916.97358 | 37.7405427580332 | -122.438749114996 | (37.7405427580332, -122.438749114996) | 2 | 7 | 5 | 63 | 7 | ||
3401 | 21158 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2300X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10 | 5984964.3463827 | 2099540.4551822 | 37.7440688278009 | -122.494682382207 | (37.7440688278009, -122.494682382207) | 1 | 8 | 3 | 29491 | 35 | |||
3424 | 116715 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2817 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 5999908.2786 | 2114349.9787 | 37.7855954495545 | -122.444073686604 | (37.7855954495545, -122.444073686604) | 15 | 6 | 1 | 29490 | 31 | |||
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 | ||
3473 | 58897 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 250 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/29/1980 12:00:00 AM | 13 | Permit Number 18169 | 6009836.93544 | 2088163.79838 | 37.7142553893523 | -122.407876041144 | (37.7142553893523, -122.407876041144) | 9 | 7 | 8 | 309 | 39 | ||
3536 | 58987 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 530 03rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/1980 12:00:00 AM | 13 | Permit Number 18276 | 5995021.45981 | 2111908.34632 | 37.7786113944275 | -122.460803527373 | (37.7786113944275, -122.460803527373) | 11 | 6 | 2 | 54 | 11 | ||
3548 | 296 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3451X 19th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 2X3 | 5990184.74118 | 2092923.50312 | 37.7262045448252 | -122.476148412917 | (37.7262045448252, -122.476148412917) | 1 | 8 | 4 | 64 | 14 | |||
3604 | 77660 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 299X Cambridge St | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 6006693.80957 | 2093349.88561 | 37.7283188049508 | -122.419107568078 | (37.7283188049508, -122.419107568078) | 9 | 3 | 7 | 309 | 5 | ||
3634 | 20382 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 262X Sunset Blvd | 28 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 60 | |||||||||||||
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 | |
3658 | 140493 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1340 TURK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 6003595.4388 | 2112480.2415 | 37.7806712690813 | -122.431183683552 | (37.7806712690813, -122.431183683552) | 15 | 9 | 11 | 29490 | 41 | |||
3694 | 231406 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 301x Powhattan Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6008008.21538 | 2098169.17057 | 37.7416254437701 | -122.414904545115 | (37.7416254437701, -122.414904545115) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |
3752 | 209923 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 700 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5991036.77148 | 2099253.35889 | 37.7436340939434 | -122.473664564077 | (37.7436340939434, -122.473664564077) | 1 | 8 | 4 | 29491 | 40 | |||
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 | ||
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 | |||
3921 | 12687 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1330 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 50 | 3X3 | 5991313.40727 | 2114800.59643 | 37.7863386650766 | -122.473842035632 | (37.7863386650766, -122.473842035632) | 11 | 6 | 1 | 54 | 33 | |||
3924 | 117653 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 5001 Anza St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/30/2020 12:00:00 AM | 3 | Width 3ft | 5983129.01167 | 2111683.19763 | 37.7773017651933 | -122.501926740971 | (37.7773017651933, -122.501926740971) | 11 | 6 | 2 | 55 | 26 | ||
3997 | 20436 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 495X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 15 | |||||||||||||
3999 | 213261 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 255 Ramsell St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5992959.15066 | 2088902.16567 | 37.7153234215169 | -122.466265391939 | (37.7153234215169, -122.466265391939) | 9 | 8 | 6 | 64 | 24 | |||
4017 | 250443 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 120 Seacliff Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 4ft | 5987542.94428 | 2115793.76045 | 37.7888465026131 | -122.486959668166 | (37.7888465026131, -122.486959668166) | 11 | 6 | 1 | 55 | 33 | |||
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 | |
4035 | 90978 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3051 Balboa St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/13/2008 12:00:00 AM | 3 | 3x3 | 5986104.90225 | 2111110.08173 | 37.7759025178632 | -122.491590119843 | (37.7759025178632, -122.491590119843) | 11 | 6 | 2 | 55 | 26 | ||
4091 | 210316 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 450 Parnassus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5995716.2843 | 2106399.35256 | 37.7635250903217 | -122.458001093579 | (37.7635250903217, -122.458001093579) | 15 | 5 | 11 | 56 | 12 | |||
4107 | 27215 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 430 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6004120.16717 | 2093461.88579 | 37.7284810633405 | -122.428012742214 | (37.7284810633405, -122.428012742214) | 9 | 7 | 6 | 28861 | 5 | |||
4111 | 131305 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 401 Spruce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 6ft | 5997155.69751 | 2115003.89282 | 37.7872335145555 | -122.453644000576 | (37.7872335145555, -122.453644000576) | 11 | 6 | 1 | 54 | 31 | |||
4153 | 19360 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 711 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5992081.20032 | 2089838.16122 | 37.7178427427344 | -122.469368036824 | (37.7178427427344, -122.469368036824) | 9 | 8 | 6 | 64 | 24 | |||
4160 | 194003 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1353 Hudson Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6016963.78411 | 2096284.21898 | 37.7369489007781 | -122.38380769119 | (37.7369489007781, -122.38380769119) | 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 | |||
4256 | 232803 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 12 Beaver St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6002731.51343 | 2106822.30283 | 37.765086973515 | -122.433767904182 | (37.765086973515, -122.433767904182) | 15 | 5 | 5 | 28862 | 3 | |||
4295 | 20447 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 495X Sunset Blvd | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 15 | |||||||||||||
4318 | 232497 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 807 Douglass St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6001287.12628 | 2101684.8467 | 37.7508987005301 | -122.438395575313 | (37.7508987005301, -122.438395575313) | 2 | 4 | 5 | 28862 | 22 | |||
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 | |
4531 | 20442 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 495X Sunset Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 15 | |||||||||||||
4547 | 9087 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 5655 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 5989409.7723 | 2112590.066 | 37.7801587272022 | -122.48026619876 | (37.7801587272022, -122.48026619876) | 11 | 6 | 2 | 55 | 26 | |||
4579 | 177618 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 278 Onondaga Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6000004.08234 | 2091569.41543 | 37.7230510458563 | -122.442106428983 | (37.7230510458563, -122.442106428983) | 9 | 7 | 6 | 28861 | 25 | |||
4584 | 177605 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 30 Ruth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6001479.84547 | 2091684.05861 | 37.7234498223318 | -122.437013225577 | (37.7234498223318, -122.437013225577) | 9 | 7 | 6 | 28861 | 25 | |||
4585 | 210019 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 851 Rockdale Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5996737.87668 | 2098254.3429 | 37.7412195716338 | -122.453879510543 | (37.7412195716338, -122.453879510543) | 9 | 7 | 4 | 59 | 40 | |||
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 | |||
4680 | 200788 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1600 McKinnon Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6015393 | 2095982 | 37.7360321129218 | -122.389217541455 | (37.7360321129218, -122.389217541455) | 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 | |
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 | |||
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 | ||
4867 | 76353 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 299X Cambridge St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 6006742.79477 | 2093189.9157 | 37.7278823207912 | -122.418926882581 | (37.7278823207912, -122.418926882581) | 9 | 3 | 7 | 309 | 5 | ||
4893 | 131541 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1234 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6008553.82207 | 2116816.41978 | 37.7928570994281 | -122.414337095377 | (37.7928570994281, -122.414337095377) | 5 | 1 | 10 | 28857 | 21 | |||
4914 | 245440 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2940 16th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6007168.2123 | 2106770.9942 | 37.7651968502685 | -122.418418777324 | (37.7651968502685, -122.418418777324) | 8 | 4 | 7 | 28853 | 19 | |||
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 | |
5150 | 177697 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 501 Mansell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 6010372.60751 | 2090257.89401 | 37.7200353222515 | -122.406171987774 | (37.7200353222515, -122.406171987774) | 10 | 7 | 8 | 309 | 28 | |||
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 |
5187 | 16150 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 395 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5999449.98722 | 2094649.82142 | 37.7314775324521 | -122.444243069762 | (37.7314775324521, -122.444243069762) | 9 | 7 | 4 | 63 | 40 | |||
5218 | 19581 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 100 STAIRWAY4 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 8 | |||||||||||||
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 | |
5272 | 20437 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 495X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 15 | |||||||||||||
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 | |
5338 | 121017 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 500 Washington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 4x4 | 6012098.89577 | 2117793.01824 | 37.7957371081465 | -122.402139588686 | (37.7957371081465, -122.402139588686) | 3 | 1 | 10 | 28860 | 4 | |||
5354 | 8706 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3100 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5997482.4956 | 2113078.7647 | 37.7819663504933 | -122.452374383353 | (37.7819663504933, -122.452374383353) | 15 | 6 | 1 | 54 | 31 | |||
5381 | 131608 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2318 Jones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6008064.43802 | 2120372.10874 | 37.8025926337993 | -122.416282346076 | (37.8025926337993, -122.416282346076) | 5 | 1 | 10 | 308 | 32 | |||
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 | |
5496 | 131655 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 967 Sacramento St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6010169.62149 | 2116837.55427 | 37.7930057627679 | -122.408747818762 | (37.7930057627679, -122.408747818762) | 3 | 1 | 10 | 28857 | 4 | |||
5500 | 77664 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 299X Cambridge St | 15 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 6006642.94243 | 2093520.00504 | 37.728783051183 | -122.419295481395 | (37.728783051183, -122.419295481395) | 9 | 3 | 7 | 309 | 5 | ||
5507 | 122105 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 315 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 6ft | 5990861.85286 | 2113260.77662 | 37.7820845839552 | -122.475291822165 | (37.7820845839552, -122.475291822165) | 11 | 6 | 2 | 54 | 26 | |||
5512 | 259281 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3891 Sacramento St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | Width 7ft | 5996301.11796 | 2114890.85877 | 37.7868741256738 | -122.456592467462 | (37.7868741256738, -122.456592467462) | 11 | 6 | 1 | 54 | 31 | ||||
5596 | 177677 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 860 Mansell St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 6009316.75189 | 2090057.74751 | 37.7194266458123 | -122.40980761495 | (37.7194266458123, -122.40980761495) | 9 | 3 | 7 | 309 | 28 | |||
5610 | 46958 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1530 43rd Ave | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/01/2002 12:00:00 AM | 7 | 3x25 | Permit Number 44987 | 5982828.25460357 | 2104700.39822601 | 37.7581113313144 | -122.502450205887 | (37.7581113313144, -122.502450205887) | 1 | 8 | 3 | 56 | 35 |
5611 | 139705 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 301 Saint Joseph's Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6000476.8247 | 2113129.5897 | 37.7822769928429 | -122.442019059209 | (37.7822769928429, -122.442019059209) | 15 | 5 | 1 | 29490 | 16 | |||
5620 | 250454 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 200 Seacliff Ave | 1 | : | Tree | Private 2 | 9 | Width 4ft | 5987161.73503 | 2115752.97281 | 37.7887122778945 | -122.488275583153 | (37.7887122778945, -122.488275583153) | 11 | 6 | 1 | 55 | 33 | |||
5665 | 185384 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2300 Sunset Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 0ft | 5985061.3096 | 2099023.7095 | 37.7426556588679 | -122.494309028051 | (37.7426556588679, -122.494309028051) | 1 | 8 | 3 | 29491 | 35 | |||
5672 | 250483 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 475 Seacliff Ave | 6 | : | Tree | Private 2 | 7 | Width 2ft | 5986409.29286 | 2115158.05614 | 37.7870348804072 | -122.490835095073 | (37.7870348804072, -122.490835095073) | 11 | 6 | 1 | 55 | 33 | |||
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 | |
5695 | 77663 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 299X Cambridge St | 14 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 4 | 3x3 | 6006674.08558 | 2093407.54115 | 37.7284760037541 | -122.419179842976 | (37.7284760037541, -122.419179842976) | 9 | 3 | 7 | 309 | 5 | ||
5704 | 247050 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 523 Valley St | 1 | : | Tree | Private 2 | 13 | Width 3ft | 6002490.03893 | 2099140.16558 | 37.7439799534136 | -122.434053911082 | (37.7439799534136, -122.434053911082) | 2 | 7 | 5 | 63 | 22 |
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) );