trees
8,758 rows where qSpecies_id = 16 sorted by SiteOrder
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
2863 | 143418 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 575 Kearny St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 0ft | 6011374.2644 | 2116814.4836 | 37.7930098144506 | -122.404578041099 | (37.7930098144506, -122.404578041099) | 3 | 1 | 10 | 28857 | 4 | |||
2926 | 183551 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1200 Vicente St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 5989202.4612 | 2097677.5503 | 37.7392009295048 | -122.479891799473 | (37.7392009295048, -122.479891799473) | 1 | 8 | 3 | 29491 | 35 | |||
2945 | 98684 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 40 Bay View St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6014207 | 2094775 | 37.7326521179743 | -122.393233618799 | (37.7326521179743, -122.393233618799) | 10 | 3 | 8 | 58 | 1 | |||||
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 |
3007 | 27222 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 371 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 13 | 3x3 | 6003827.51824 | 2093508.67438 | 37.7285929731823 | -122.429027779127 | (37.7285929731823, -122.429027779127) | 9 | 7 | 6 | 28861 | 5 | |||
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 | ||||
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 | |
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 | |||
3264 | 1125 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2466 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | 3X3 | 5998958.39293 | 2088881.75103 | 37.7156116878713 | -122.445527983003 | (37.7156116878713, -122.445527983003) | 9 | 7 | 6 | 28861 | 25 | |||
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 | |||
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 | |||
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 | ||
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 | ||
3496 | 98500 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1670 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5990941.3 | 2104038.3 | 37.7567667631156 | -122.474343775715 | (37.7567667631156, -122.474343775715) | 1 | 8 | 4 | 56 | 12 | ||||
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 | ||
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 | |||
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 | ||
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 | ||
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 | ||
3825 | 263630 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1020 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000550 | 2112598 | 37.7808215534457 | -122.441727743189 | (37.7808215534457, -122.441727743189) | 15 | 5 | 1 | 29490 | 16 | ||||
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 | |||
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 | |||
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 | |
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 | |||
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 | |||
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 | ||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |
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 | |||
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 | |
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 | |||
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 | |||
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 | |
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 | |||
5708 | 120015 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 351 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 4ft | 5986818.7431 | 2113586.36762 | 37.7827433860635 | -122.48930290495 | (37.7827433860635, -122.48930290495) | 11 | 6 | 2 | 55 | 26 | |||
5730 | 144279 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 690 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/16/2020 12:00:00 AM | 3 | Width 3ft | 5981990.61575 | 2111117.56689 | 37.7756817696347 | -122.505822808694 | (37.7756817696347, -122.505822808694) | 11 | 6 | 2 | 55 | 26 | ||
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 | ||
6011 | 186520 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1501 Sunset Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 26 | Width 0ft | 5984772.6613 | 2104877.4166 | 37.7587114348302 | -122.495738769506 | (37.7587114348302, -122.495738769506) | 1 | 8 | 3 | 56 | 35 | |||
6015 | 16176 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 438 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5999154.53701 | 2094721.74383 | 37.731658154085 | -122.445269662966 | (37.731658154085, -122.445269662966) | 9 | 7 | 4 | 59 | 40 | |||
6016 | 96544 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 100@ Front St Pine St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 08/29/2019 12:00:00 AM | 3 | Permit Number 784583 | 6013029.74558 | 2116576.80835 | 37.7924495959214 | -122.398833259061 | (37.7924495959214, -122.398833259061) | 4 | 1 | 10 | 28860 | 6 | ||
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 | |
6030 | 19323 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 200 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X5 | 5993467.32802 | 2089853.93143 | 37.7179660496774 | -122.4645779904 | (37.7179660496774, -122.4645779904) | 9 | 8 | 6 | 64 | 24 | |||
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 | |
6224 | 200787 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1600 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 0ft | 6015393 | 2095982 | 37.7360321129218 | -122.389217541455 | (37.7360321129218, -122.389217541455) | 10 | 3 | 8 | 58 | 1 | |||
6251 | 60411 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1548 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/1982 12:00:00 AM | 11 | Permit Number 19992 | 6015521.632 | 2094461.6625 | 37.73186470328 | -122.388666708344 | (37.73186470328, -122.388666708344) | 10 | 3 | 8 | 58 | 1 | ||
6271 | 15012 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1492X Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6016294.2605501 | 2097022.8093396 | 37.7389398874772 | -122.386174028839 | (37.7389398874772, -122.386174028839) | 10 | 3 | 8 | 58 | 1 | |||
6302 | 38481 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1116 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/1998 12:00:00 AM | Permit Number 40480 | 6017830.40993478 | 2092735.6877236 | 37.727253198437 | -122.380564773574 | (37.727253198437, -122.380564773574) | 10 | 3 | 8 | 58 | 1 | |||
6328 | 209930 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2445 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5992320.715 | 2098815.39655 | 37.742505836878 | -122.469193170828 | (37.742505836878, -122.469193170828) | 1 | 8 | 4 | 29491 | 40 | |||
6346 | 232604 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 509 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/28/1989 12:00:00 AM | 14 | Width 3ft | Permit Number 28219 | 6003467.96193 | 2095980.6299 | 37.7353600451305 | -122.430447088284 | (37.7353600451305, -122.430447088284) | 2 | 7 | 5 | 63 | 7 | |
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 | |
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 | |
6756 | 247422 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1017 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6002479.5264 | 2110196.8042 | 37.7743382213836 | -122.434880809366 | (37.7743382213836, -122.434880809366) | 15 | 5 | 11 | 29492 | 10 | |||
6780 | 31935 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1330 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1995 12:00:00 AM | 6 | Permit Number 35351 | 5981536.6923 | 2106016.9784 | 37.7616503077312 | -122.507014568071 | (37.7616503077312, -122.507014568071) | 1 | 8 | 3 | 56 | 35 | |
6784 | 60048 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1463 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/24/1982 12:00:00 AM | 14 | Permit Number 19546 | 5988345.982 | 2105367.5756 | 37.7602658931923 | -122.483416673161 | (37.7602658931923, -122.483416673161) | 1 | 8 | 3 | 56 | 35 | |
6800 | 65190 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 263 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/1989 12:00:00 AM | 14 | Permit Number 27174 | 6002953.3046 | 2091886.83764 | 37.7240902493544 | -122.431934222489 | (37.7240902493544, -122.431934222489) | 9 | 7 | 6 | 28861 | 5 | |
6869 | 51982 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 660 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/2005 12:00:00 AM | Permit Number 48204 | 6007266.85815782 | 2113345.5415055 | 37.7832545419232 | -122.4185438282 | (37.7832545419232, -122.4185438282) | 7 | 9 | 9 | 28858 | 36 | |||
6976 | 59854 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1182 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/1981 12:00:00 AM | 18 | Permit Number 19310 | 6017139.45768 | 2093603.92018 | 37.7295990411395 | -122.38301381645 | (37.7295990411395, -122.38301381645) | 10 | 3 | 8 | 58 | 1 | |
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 |
7034 | 184301 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1546 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5981896.8997 | 2104553.6198 | 37.7576535496395 | -122.505660295506 | (37.7576535496395, -122.505660295506) | 1 | 8 | 3 | 56 | 35 |
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) );