8,758 rows where qSpecies_id = 16

View and edit SQL

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)
2563 18769 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 290 Roosevelt Way 1 Sidewalk: Curb side : Cutout Tree Private 2     18 3X3 Permit Number 787822 6000600.23585 2106985.9234 37.765415066877 -122.441151190675 (37.765415066877, -122.441151190675) 15 5 5 29492 3
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
2639 210264 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1201 Irving St 5 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   5991895.36421 2106557.41103 37.7637388043301 -122.471227833003 (37.7637388043301, -122.471227833003) 1 8 11 56 12
2652 18747 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 222 Roosevelt Way 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6000958.79784 2107315.99315 37.7663417741813 -122.439934678663 (37.7663417741813, -122.439934678663) 15 5 5 29492 3
2663 181722 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 2645 Lincoln Way 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   5987446.5903 2107090.374 37.764943837931 -122.486653709544 (37.764943837931, -122.486653709544) 1 8 3 56 35
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
2692 18211 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1575 Post St 6 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6004651.3172937 2114317.5621297 37.7857758731644 -122.427661834419 (37.7857758731644, -122.427661834419) 13 9 11 28858 13
2732 118955 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 750 48th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 4ft   5981074.93145 2110594.12979 37.7741906275321 -122.508951455998 (37.7741906275321, -122.508951455998) 11 6 2 55 26
2738 140731 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 2023 O'Farrell St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/02/2004 12:00:00 AM 12 Width 0ft   6001651.0062 2113204.4884 37.7825494877114 -122.437962288192 (37.7825494877114, -122.437962288192) 15 5 11 29490 41
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
2953 118676 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 4825 Balboa St 3 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5980559.76523 2110909.18852 37.7750253031785 -122.510756894567 (37.7750253031785, -122.510756894567) 11 6 2 55 26
2971 250510 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 75 27th Ave 3 Sidewalk: Curb side : Yard Tree Private 2     12 Width 5ft   5987308.66603 2115522.71145 37.7880886178397 -122.487750306256 (37.7880886178397, -122.487750306256) 11 6 1 55 33
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
3003 131309 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 101 Maple St 2 Sidewalk: Curb side : Pot Tree Private 2     8 Width 3ft   5996544.36803 2115871.17754 37.7895797810398 -122.455821775454 (37.7895797810398, -122.455821775454) 11 6 1 54 31
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
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
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
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
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
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
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
3913 35208 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16   13 Sidewalk: Curb side : Cutout Tree Private 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
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
4197 262260 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 2 Everglade Dr 4 Sidewalk: Property side : Yard Tree Private 2       3x3   5986312 2095495 37.7330398702545 -122.489725113139 (37.7330398702545, -122.489725113139) 1 8 4 64 35
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                      
4298 262513 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 2230 Jerrold Ave 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6012281 2099339 37.74507671213 -122.400212745638 (37.74507671213, -122.400212745638) 10 3 8 58 1
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
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
4401 258690 Property Tree 8 Metrosideros excelsa :: New Zealand Xmas Tree 16 100x Whitney Young Cir 11 Sidewalk: Curb side : Cutout Tree SFUSD 4       3x3   6016360 2096059 37.7362970999571 -122.385879567348 (37.7362970999571, -122.385879567348) 10 3 8 58 1
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
4587 35197 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16   17 Sidewalk: Curb side : Cutout Tree Private 2   02/10/1998 12:00:00 AM     Permit Number 38712                    
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
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
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

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);