82 rows where Police Districts = 8 and qCaretaker_id = 4 sorted by qCareAssistant

View and edit SQL

Police Districts

PlantType

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)
42731 115967 DPW Maintained 1 Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 1599x 30th Ave 4 Sidewalk: Curb side : Cutout Tree SFUSD 4     4 3x3   5986812.8086 2104676.4366 37.7582788637421 -122.488668327875 (37.7582788637421, -122.488668327875) 1 8 3 56 35
49723 115970 DPW Maintained 1 Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 1599x 30TH AVE 7 Sidewalk: Curb side : Cutout Tree SFUSD 4     0 3x3   5986686 2104596 37.7580506061519 -122.489100968136 (37.7580506061519, -122.489100968136) 1 8 3 56 35
51808 111862 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 201x LOBOS ST 4 Sidewalk: Curb side : Cutout Tree SFUSD 4       3x3   5994528 2088713 37.7148944123502 -122.460829096166 (37.7148944123502, -122.460829096166) 9 8 6 28861 24
52455 117257 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1570 31ST AVE 5 Sidewalk: Curb side : Cutout Tree SFUSD 4           5986686.8 2104596 37.7580506528461 -122.489098201432 (37.7580506528461, -122.489098201432) 1 8 3 56 35
57689 117255 DPW Maintained 1 Ulmus pumila :: Siberian Elm 99 1570 31ST AVE 3 Sidewalk: Curb side : Cutout Tree SFUSD 4           5986686.8 2104596 37.7580506528461 -122.489098201432 (37.7580506528461, -122.489098201432) 1 8 3 56 35
60043 111861 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 201x LOBOS ST 3 Sidewalk: Curb side : Cutout Tree SFUSD 4       3x3   5994528 2088713 37.7148944123502 -122.460829096166 (37.7148944123502, -122.460829096166) 9 8 6 28861 24
81017 117256 DPW Maintained 1 Ulmus pumila :: Siberian Elm 99 1570 31ST AVE 4 Sidewalk: Curb side : Cutout Tree SFUSD 4           5986686.8 2104596 37.7580506528461 -122.489098201432 (37.7580506528461, -122.489098201432) 1 8 3 56 35
91388 105784 DPW Maintained 1 Ulmus pumila :: Siberian Elm 99 1570 31ST AVE 1 Sidewalk: Curb side : Cutout Tree SFUSD 4   04/18/2014 12:00:00 AM     Permit Number 772914 5986686.8 2104596 37.7580506528461 -122.489098201432 (37.7580506528461, -122.489098201432) 1 8 3 56 35
92249 115964 DPW Maintained 1 Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 1599x 30TH AVE 1 Sidewalk: Curb side : Cutout Tree SFUSD 4     8 3x3   5986686 2104596 37.7580506061519 -122.489100968136 (37.7580506061519, -122.489100968136) 1 8 3 56 35
106870 117252 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 2500x 34TH AVE 2 Side Yard : Yard Tree SFUSD 4       3x3   5985829 2097874 37.7395437603018 -122.491570003273 (37.7395437603018, -122.491570003273) 1 8 3 29491 35
121060 92961 DPW Maintained 1 Tree(s) :: 17 2051 34th Ave 1 Sidewalk: Curb side : Cutout Tree SFUSD 4   12/24/2009 12:00:00 AM   3x3 Permit Number 53120 5985698.5 2101265.4 37.748848003369 -122.492270870248 (37.748848003369, -122.492270870248) 1 8 3 29491 35
129395 92962 DPW Maintained 1 Tree(s) :: 17 2051 34th Ave 2 Sidewalk: Curb side : Cutout Tree SFUSD 4   12/24/2009 12:00:00 AM   3x3 Permit Number 53120 5985698.5 2101265.4 37.748848003369 -122.492270870248 (37.748848003369, -122.492270870248) 1 8 3 29491 35
132862 111863 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 201x LOBOS ST 5 Sidewalk: Curb side : Cutout Tree SFUSD 4       3x3   5994528 2088713 37.7148944123502 -122.460829096166 (37.7148944123502, -122.460829096166) 9 8 6 28861 24
133744 117251 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 2500x 34TH AVE 1 Side Yard : Yard Tree SFUSD 4       3x3   5985829 2097874 37.7395437603018 -122.491570003273 (37.7395437603018, -122.491570003273) 1 8 3 29491 35
148752 115965 DPW Maintained 1 Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 1599x 30th Ave 2 Sidewalk: Curb side : Cutout Tree SFUSD 4     7 3x3   5986811.649 2104744.2782 37.7584650705211 -122.488677324697 (37.7584650705211, -122.488677324697) 1 8 3 56 35
152290 115971 DPW Maintained 1 Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 1599x 30th Ave 8 Sidewalk: Curb side : Cutout Tree SFUSD 4     4 3x3   5986813.9683 2104572.6448 37.757993947556 -122.488656688385 (37.757993947556, -122.488656688385) 1 8 3 56 35
156729 115973 DPW Maintained 1 Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 1599x 30TH AVE 10 Sidewalk: Curb side : Cutout Tree SFUSD 4     0 3x3   5986686 2104596 37.7580506061519 -122.489100968136 (37.7580506061519, -122.489100968136) 1 8 3 56 35
167675 115968 DPW Maintained 1 Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 1599x 30th Ave 5 Sidewalk: Curb side : Cutout Tree SFUSD 4     6 3x3   5986813.3885 2104648.6042 37.7582024774349 -122.488664276638 (37.7582024774349, -122.488664276638) 1 8 3 56 35
170193 115966 DPW Maintained 1 Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 1599x 30th Ave 3 Sidewalk: Curb side : Cutout Tree SFUSD 4     6 3x3   5986811.649 2104717.0256 37.7583902423484 -122.488675321582 (37.7583902423484, -122.488675321582) 1 8 3 56 35
176886 117253 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 2500x 34TH AVE 3 Side Yard : Yard Tree SFUSD 4       3x3   5985829 2097874 37.7395437603018 -122.491570003273 (37.7395437603018, -122.491570003273) 1 8 3 29491 35
178733 115972 DPW Maintained 1 Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 1599x 30th Ave 9 Sidewalk: Curb side : Cutout Tree SFUSD 4     8 3x3   5986817.4474 2104547.1317 37.7579240985888 -122.488642781125 (37.7579240985888, -122.488642781125) 1 8 3 56 35
178792 115969 DPW Maintained 1 Olea europaea :: Olive Tree 9 1599x 30th Ave 6 Sidewalk: Curb side : Cutout Tree SFUSD 4     2 3x3   5986813.3885 2104627.15 37.7581435700771 -122.488662699732 (37.7581435700771, -122.488662699732) 1 8 3 56 35
184091 92963 Permitted Site 7 Tree(s) :: 17 1515 Quintara St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4   12/24/2009 12:00:00 AM   3x3 Permit Number 53121 5988690.8 2100920.9 37.7480765758445 -122.481898390884 (37.7480765758445, -122.481898390884) 1 8 3 29491 35
2028 76748 DPW Maintained 1 Acacia baileyana :: Bailey's Acacia 122 1501X 42nd Ave 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   7 3x12   5983093.5463 2104693.1195 37.7581069307926 -122.501532189631 (37.7581069307926, -122.501532189631) 1 8 3 56 35
3628 76755 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 1501X 42nd Ave 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   3 3x12   5983093.5463 2104662.8676 37.758023867602 -122.501529951702 (37.758023867602, -122.501529951702) 1 8 3 56 35
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
5633 76756 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 1501X 42nd Ave 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   2 3x12   5983095.0741 2104639.3384 37.757959352781 -122.501522927406 (37.757959352781, -122.501522927406) 1 8 3 56 35
11170 76785 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 1501X 42nd Ave 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   24 3x12   5983097.8243 2104541.5546 37.75769102754 -122.501506182606 (37.75769102754, -122.501506182606) 1 8 3 56 35
14697 76382 DPW Maintained 1 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 1501X 42nd Ave 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   25 3x12   5983091.4072 2104771.8049 37.7583228530818 -122.501545408351 (37.7583228530818, -122.501545408351) 1 8 3 56 35
18929 76784 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1501X 42nd Ave 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   1 3x12   5983097.2131 2104562.028 37.7577472058325 -122.501509810878 (37.7577472058325, -122.501509810878) 1 8 3 56 35
58717 46964 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 3899X Kirkham St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/01/2002 12:00:00 AM 8 3x20 Permit Number 44987 5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35
59100 46948 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1530 43rd Ave 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/01/2002 12:00:00 AM 3 3x25 Permit Number 44987 5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35
61370 76728 DPW Maintained 1 Olea europaea :: Olive Tree 9 200X Farallones St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/20/1989 12:00:00 AM 10 3x3   5995015.41074948 2088495.64250033 37.7143256328225 -122.459128681816 (37.7143256328225, -122.459128681816) 9 8 6 28861 24
62860 32726 DPW Maintained 1 Melaleuca linariifolia :: Flaxleaf Paperbark 103 200X Farallones St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/29/1996 12:00:00 AM 20 6x9 Permit Number 37116 5995015.41074948 2088495.64250033 37.7143256328225 -122.459128681816 (37.7143256328225, -122.459128681816) 9 8 6 28861 24
63621 46967 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 3899X Kirkham St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/01/2002 12:00:00 AM 5 3x20 Permit Number 44987 5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35
65075 76344 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 3899X Kirkham St 12 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/14/1994 12:00:00 AM 12 3x30   5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35
65943 32730 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 431 Capitol Ave 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/29/1996 12:00:00 AM 3 3x3   5995024.58898 2088651.07748 37.7147529482781 -122.459108206688 (37.7147529482781, -122.459108206688) 9 8 6 28861 24
68707 32729 DPW Maintained 1 Melaleuca linariifolia :: Flaxleaf Paperbark 103 200X Farallones St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/29/1996 12:00:00 AM 12 3x3 Permit Number 37116 5995015.41074948 2088495.64250033 37.7143256328225 -122.459128681816 (37.7143256328225, -122.459128681816) 9 8 6 28861 24
70695 46953 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1530 43rd Ave 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/01/2002 12:00:00 AM 6 3x25 Permit Number 44987 5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35
72358 46950 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1530 43rd Ave 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/01/2002 12:00:00 AM 8 3x25 Permit Number 44987 5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35
75380 46955 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1530 43rd Ave 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/01/2002 12:00:00 AM 4 3x25 Permit Number 44987 5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35
77942 32731 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 431 Capitol Ave 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/29/1996 12:00:00 AM 3 3x3   5995024.91433 2088666.61691 37.7147956345921 -122.459108206687 (37.7147956345921, -122.459108206687) 9 8 6 28861 24
78188 46960 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1530 43rd Ave 13 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/01/2002 12:00:00 AM 8 3x25 Permit Number 44987 5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35
79799 46957 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1530 43rd Ave 10 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/01/2002 12:00:00 AM 8 3x25 Permit Number 44987 5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35
81039 46962 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1530 43rd Ave 15 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/01/2002 12:00:00 AM 6 3x25 Permit Number 44987 5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35
87699 76252 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 3899X Kirkham St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/14/1994 12:00:00 AM 8 3x20   5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35
87796 76222 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 3899X Kirkham St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/14/1994 12:00:00 AM 5 3x20   5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35
94599 76762 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 200X Farallones St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/20/1989 12:00:00 AM 10 3x3   5995015.41074948 2088495.64250033 37.7143256328225 -122.459128681816 (37.7143256328225, -122.459128681816) 9 8 6 28861 24
97962 46965 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 3899X Kirkham St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/01/2002 12:00:00 AM 8 3x20 Permit Number 44987 5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35
100065 98885 DPW Maintained 1 Olea europaea :: Olive Tree 9 200X Farallones St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   3 3x3   5994871.8 2088553.5 37.7144762388107 -122.459629241673 (37.7144762388107, -122.459629241673) 9 8 6 28861 24
104330 46952 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1530 43rd Ave 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/01/2002 12:00:00 AM 8 3x25 Permit Number 44987 5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35
104954 95260 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 2290X 14th Ave 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency         5992014.7 2099861.3 37.745359932747 -122.470327420537 (37.745359932747, -122.470327420537) 1 8 4 29491 40
119464 76771 DPW Maintained 1 Olea europaea :: Olive Tree 9 200X Farallones St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/20/1989 12:00:00 AM 14 3x3   5995015.41074948 2088495.64250033 37.7143256328225 -122.459128681816 (37.7143256328225, -122.459128681816) 9 8 6 28861 24
123453 95261 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 2290X 14th Ave 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency         5992014.7 2099861.3 37.745359932747 -122.470327420537 (37.745359932747, -122.470327420537) 1 8 4 29491 40
129428 76768 DPW Maintained 1 Olea europaea :: Olive Tree 9 200X Farallones St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/20/1989 12:00:00 AM 14 3x3   5995015.41074948 2088495.64250033 37.7143256328225 -122.459128681816 (37.7143256328225, -122.459128681816) 9 8 6 28861 24
129766 32725 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 431 Capitol Ave 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/29/1996 12:00:00 AM 3 3x3   5995024.24753 2088599.26436 37.7146106620382 -122.45910563734 (37.7146106620382, -122.45910563734) 9 8 6 28861 24
140619 76757 DPW Maintained 1 Olea europaea :: Olive Tree 9 200X Farallones St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/20/1989 12:00:00 AM 14 3x3   5995015.41074948 2088495.64250033 37.7143256328225 -122.459128681816 (37.7143256328225, -122.459128681816) 9 8 6 28861 24
155449 46966 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 3899X Kirkham St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/01/2002 12:00:00 AM 8 3x20 Permit Number 44987 5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35
157174 46961 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1530 43rd Ave 14 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
158580 95258 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 2290X 14th Ave 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency         5992014.7 2099861.3 37.745359932747 -122.470327420537 (37.745359932747, -122.470327420537) 1 8 4 29491 40
162635 46949 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1530 43rd Ave 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/01/2002 12:00:00 AM 5 3x25 Permit Number 44987 5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35
167652 46951 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 1530 43rd Ave 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/01/2002 12:00:00 AM 8 3x25 Permit Number 44987 5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35
171291 76271 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 3899X Kirkham St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/14/1994 12:00:00 AM 8 3x20   5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35
174971 76749 DPW Maintained 1 Schinus terebinthifolius :: Brazilian Pepper 93 200X Farallones St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/20/1989 12:00:00 AM 8 3x3   5995015.41074948 2088495.64250033 37.7143256328225 -122.459128681816 (37.7143256328225, -122.459128681816) 9 8 6 28861 24
178848 32728 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 431 Capitol Ave 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/29/1996 12:00:00 AM 3 3x3   5995024.59612 2088615.91363 37.714656397048 -122.459105637326 (37.714656397048, -122.459105637326) 9 8 6 28861 24
187263 96085 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 2290X 14th Ave 11 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency         5992014.7 2099861.3 37.745359932747 -122.470327420537 (37.745359932747, -122.470327420537) 1 8 4 29491 40
188359 95262 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 2290X 14th Ave 10 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency         5992014.7 2099861.3 37.745359932747 -122.470327420537 (37.745359932747, -122.470327420537) 1 8 4 29491 40
189611 76325 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 3899X Kirkham St 11 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/14/1994 12:00:00 AM 5 3x20   5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35
190317 95259 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 2290X 14th Ave 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency         5992014.7 2099861.3 37.745359932747 -122.470327420537 (37.745359932747, -122.470327420537) 1 8 4 29491 40
190377 32727 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 431 Capitol Ave 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/29/1996 12:00:00 AM 3 3x3   5995024.97569 2088634.0427 37.7147061970204 -122.459105637321 (37.7147061970204, -122.459105637321) 9 8 6 28861 24
7373 96567 Significant Tree 6 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1101 Eucalyptus Dr   Sidewalk: Property side : Cutout Tree SFUSD 4 FUF       In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.7310370666678 -122.483566221845 (37.7310370666678, -122.483566221845) 1 8 4 64 14
13082 96572 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 1101 Eucalyptus Dr   Sidewalk: Property side : Cutout Tree SFUSD 4 FUF       In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.7310370666678 -122.483566221845 (37.7310370666678, -122.483566221845) 1 8 4 64 14
41336 96569 Significant Tree 6 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1101 Eucalyptus Dr   Sidewalk: Property side : Cutout Tree SFUSD 4 FUF       In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.7310370666678 -122.483566221845 (37.7310370666678, -122.483566221845) 1 8 4 64 14
54868 96570 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 1101 Eucalyptus Dr   Sidewalk: Property side : Cutout Tree SFUSD 4 FUF       In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.7310370666678 -122.483566221845 (37.7310370666678, -122.483566221845) 1 8 4 64 14
57870 96483 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 1101 Eucalyptus Dr   Sidewalk: Property side : Cutout Tree SFUSD 4 FUF       In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.7310370666678 -122.483566221845 (37.7310370666678, -122.483566221845) 1 8 4 64 14
99609 96481 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 1101 Eucalyptus Dr   Sidewalk: Property side : Cutout Tree SFUSD 4 FUF       In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.7310370666678 -122.483566221845 (37.7310370666678, -122.483566221845) 1 8 4 64 14
103743 96568 Significant Tree 6 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1101 Eucalyptus Dr   Sidewalk: Property side : Cutout Tree SFUSD 4 FUF       In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.7310370666678 -122.483566221845 (37.7310370666678, -122.483566221845) 1 8 4 64 14
109546 96484 Significant Tree 6 Quercus agrifolia :: Coast Live Oak 172 1101 Eucalyptus Dr   Sidewalk: Property side : Cutout Tree SFUSD 4 FUF       In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.7310370666678 -122.483566221845 (37.7310370666678, -122.483566221845) 1 8 4 64 14
110019 96485 Significant Tree 6 Quercus agrifolia :: Coast Live Oak 172 1101 Eucalyptus Dr   Sidewalk: Property side : Cutout Tree SFUSD 4 FUF       In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.7310370666678 -122.483566221845 (37.7310370666678, -122.483566221845) 1 8 4 64 14
124067 96482 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 1101 Eucalyptus Dr   Sidewalk: Property side : Cutout Tree SFUSD 4 FUF       In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.7310370666678 -122.483566221845 (37.7310370666678, -122.483566221845) 1 8 4 64 14
135340 96571 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 1101 Eucalyptus Dr   Sidewalk: Property side : Cutout Tree SFUSD 4 FUF       In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.7310370666678 -122.483566221845 (37.7310370666678, -122.483566221845) 1 8 4 64 14
170438 96480 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 1101 Eucalyptus Dr   Sidewalk: Property side : Cutout Tree SFUSD 4 FUF       In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.7310370666678 -122.483566221845 (37.7310370666678, -122.483566221845) 1 8 4 64 14

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