251 rows where DBH = 3 and qCaretaker_id = 4 sorted by Zip Codes

View and edit SQL

DBH

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)
40750 30740 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 380 Webster St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 01/31/1995 12:00:00 AM 3 3x3 Permit Number 34630 6004184.33514 2109844.20882 37.7734667268354 -122.428958416203 (37.7734667268354, -122.428958416203) 7 9 11 28852 10
72831 30743 DPW Maintained 1 Callistemon viminalis :: Weeping Bottlebrush 60 490X Page St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 01/31/1995 12:00:00 AM 3 3x3 Permit Number 34630 6004161.50647736 2110040.16949733 37.7740034947051 -122.429051358355 (37.7740034947051, -122.429051358355) 7 9 11 28852 10
97737 30738 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 380 Webster St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 01/31/1995 12:00:00 AM 3 3x3 Permit Number 34630 6004189.67673 2109821.80854 37.773405523492 -122.428938341537 (37.773405523492, -122.428938341537) 7 9 11 28852 10
8452 116055 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 650x Kansas St 11 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/08/2020 12:00:00 AM 3 4x4   6011513.13975 2105199.40577 37.7611252557522 -122.403280067548 (37.7611252557522, -122.403280067548) 10 3 8 28856 29
14250 116051 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 650x Kansas St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   3 4x4   6011500.28754 2105307.13541 37.7614203394907 -122.403332096897 (37.7614203394907, -122.403332096897) 10 3 8 28856 29
17049 112023 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2101x 22nd Ave 3 Sidewalk: Curb side : Cutout Tree SFUSD 4   07/23/2015 12:00:00 AM 3 5x5   6011761 2103726 37.75709344993 -122.402319220858 (37.75709344993, -122.402319220858) 10 3 8 28856 29
17413 112021 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2101x 22nd Ave 1 Sidewalk: Curb side : Cutout Tree SFUSD 4   07/23/2015 12:00:00 AM 3 5x5   6011761 2103726 37.75709344993 -122.402319220858 (37.75709344993, -122.402319220858) 10 3 8 28856 29
58864 116052 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 650x Kansas St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 01/23/2018 12:00:00 AM 3 4x4   6011506.55629 2105277.69862 37.7613398627543 -122.403308344903 (37.7613398627543, -122.403308344903) 10 3 8 28856 29
89512 116065 DPW Maintained 1 Podocarpus gracilor :: Fern Pine 51 693 Vermont St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 03/30/2018 12:00:00 AM 3 8x7   6011274.01561 2105377.63125 37.7616012651139 -122.404119643106 (37.7616012651139, -122.404119643106) 10 3 8 28856 29
102329 91788 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 830X Harrison St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4   03/07/2007 12:00:00 AM 3 3x3   6012494.965717 2112152.388469 37.7802713613915 -122.400372717325 (37.7802713613915, -122.400372717325) 6 2 9 28856 34
106425 116064 DPW Maintained 1 Podocarpus gracilor :: Fern Pine 51 693 Vermont St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 03/30/2018 12:00:00 AM 3 8x7   6011272.30638 2105412.17877 37.7616960293658 -122.404127986133 (37.7616960293658, -122.404127986133) 10 3 8 28856 29
127080 112029 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2101x 22nd Ave 9 Sidewalk: Curb side : Cutout Tree SFUSD 4   07/23/2015 12:00:00 AM 3 9x9   6011761 2103726 37.75709344993 -122.402319220858 (37.75709344993, -122.402319220858) 10 3 8 28856 29
174726 112028 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 2101x 22nd Ave 8 Sidewalk: Curb side : Cutout Tree SFUSD 4   07/23/2015 12:00:00 AM 3 9x9   6011761 2103726 37.75709344993 -122.402319220858 (37.75709344993, -122.402319220858) 10 3 8 28856 29
180684 116050 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 650x Kansas St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   3 4x4   6011499.79329 2105331.08163 37.7614860628578 -122.403335490949 (37.7614860628578, -122.403335490949) 10 3 8 28856 29
187598 112025 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 2101x 22nd Ave 5 Sidewalk: Curb side : Cutout Tree SFUSD 4   07/23/2015 12:00:00 AM 3 5x5   6011761 2103726 37.75709344993 -122.402319220858 (37.75709344993, -122.402319220858) 10 3 8 28856 29
11856 107887 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 941 Washington St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/03/2014 12:00:00 AM 3 3x3 Permit Number 771772 6010165.08902 2117347.11602 37.7944046419585 -122.40879946772 (37.7944046419585, -122.40879946772) 3 1 10 28857 4
171481 107886 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 22 941 Washington St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/03/2014 12:00:00 AM 3 3x3 Permit Number 771772 6010165.08902 2117347.11602 37.7944046419585 -122.40879946772 (37.7944046419585, -122.40879946772) 3 1 10 28857 4
11581 98091 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 2X Frank Norris St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   3 3x3   6007129.63323 2115568.12393 37.7893494826426 -122.419176280756 (37.7893494826426, -122.419176280756) 13 9 10 28858 21
20224 98090 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 2X Frank Norris St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   3 3x3   6007144.43128 2115568.9527 37.7893525915946 -122.419125139911 (37.7893525915946, -122.419125139911) 13 9 10 28858 21
38733 98088 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 2X Frank Norris St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   3 3x3   6007178.15894 2115574.08384 37.7893685797349 -122.419008809929 (37.7893685797349, -122.419008809929) 13 9 10 28858 21
73331 97736 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1150 Francisco St 15 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 01/31/2017 12:02:00 PM 3 3x3 Permit Number 50638 6005674.32361 2120686.81612 37.8033220514443 -122.424575748272 (37.8033220514443, -122.424575748272) 5 9 1 28858 32
142043 97731 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1150 Francisco St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   3 3x3 Permit Number 50638 6005778.11415 2120709.05822 37.8033889834786 -122.424218159845 (37.8033889834786, -122.424218159845) 5 9 1 28858 32
150198 98089 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 2X Frank Norris St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   3 3x3   6007160.90241 2115572.1732 37.7893623618415 -122.419068380099 (37.7893623618415, -122.419068380099) 13 9 10 28858 21
151130 97735 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1150 Francisco St 14 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/22/2016 02:46:00 PM 3 3x3 Permit Number 50638 6005694.979 2120690.49004 37.8033333055591 -122.424504530974 (37.8033333055591, -122.424504530974) 5 9 1 28858 32
24545 70470 Undocumented 4 Ligustrum lucidum :: Glossy Privet 57 450X Banks St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/18/1994 12:00:00 AM 3 3x4   6008487.2849764 2096519.17342203 37.7371218206329 -122.413131433288 (37.7371218206329, -122.413131433288) 10 7 7 28859 2
33305 102189 Undocumented 4 Ligustrum lucidum :: Glossy Privet 57 3999X Folsom St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   3 3x3   6008408 2096514 37.7371031642446 -122.41340519256 (37.7371031642446, -122.41340519256) 10 7 7 28859 2
40781 99039 DPW Maintained 1 Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 200X Bartlett St 13 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   3 3x3   6006692 2102600.1 37.7537177245237 -122.419769910314 (37.7537177245237, -122.419769910314) 2 4 7 28859 19
49986 96493 DPW Maintained 1 Tree(s) :: 17 2500X Harrison St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/24/2014 12:00:00 AM 3 5x5 Permit Number 774006 6008744 2103690.4 37.7568268248396 -122.412750681409 (37.7568268248396, -122.412750681409) 2 4 7 28859 19
78897 102155 Undocumented 4 Ligustrum lucidum :: Glossy Privet 57 450X Banks St 10 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   3 3x4   6008490.5 2096648.5 37.7374771037155 -122.413129459512 (37.7374771037155, -122.413129459512) 10 7 7 28859 2
87632 98968 DPW Maintained 1 Eriobotrya deflexa :: Bronze Loquat 8 825 Shotwell St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/16/2015 08:08:00 AM 3 3x3 Permit Number 53353 6008234.2 2102998.9 37.7548994960031 -122.414464835105 (37.7548994960031, -122.414464835105) 2 4 7 28859 19
100826 78999 Undocumented 4 Ligustrum lucidum :: Glossy Privet 57 555 Tompkins Ave 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/18/1994 12:00:00 AM 3 3x3   6008487.2849764 2096519.17342203 37.7371218206329 -122.413131433288 (37.7371218206329, -122.413131433288) 10 7 7 28859 2
101825 97903 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 375X Precita Ave 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   3 3x3   6008901.5 2100225.6 37.7473220995732 -122.411961145064 (37.7473220995732, -122.411961145064) 2 7 7 28859 2
103551 102191 Undocumented 4 Ligustrum lucidum :: Glossy Privet 57 3999X Folsom St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   3 3x3   6008408 2096514 37.7371031642446 -122.41340519256 (37.7371031642446, -122.41340519256) 10 7 7 28859 2
104727 78992 Undocumented 4 Ligustrum lucidum :: Glossy Privet 57 450X Banks St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/18/1994 12:00:00 AM 3 3x4   6008487.2849764 2096519.17342203 37.7371218206329 -122.413131433288 (37.7371218206329, -122.413131433288) 10 7 7 28859 2
108397 102154 Undocumented 4 Ligustrum lucidum :: Glossy Privet 57 450X Banks St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   3 3x4   6008490.5 2096648.5 37.7374771037155 -122.413129459512 (37.7374771037155, -122.413129459512) 10 7 7 28859 2
109710 97896 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 375X Precita Ave 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   3 3x3   6008901.5 2100225.6 37.7473220995732 -122.411961145064 (37.7473220995732, -122.411961145064) 2 7 7 28859 2
126964 97897 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 375X Precita Ave 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   3 3x3   6008901.5 2100225.6 37.7473220995732 -122.411961145064 (37.7473220995732, -122.411961145064) 2 7 7 28859 2
129647 40250 DPW Maintained 1 Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 3351X 23rd St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/13/1999 12:00:00 AM 3 3x3 Permit Number 41415 6006702.84210434 2102592.14346256 37.7536964884672 -122.419731851285 (37.7536964884672, -122.419731851285) 2 4 7 28859 19
151372 74109 Undocumented 4 Ligustrum lucidum :: Glossy Privet 57 555 Tompkins Ave 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/18/1994 12:00:00 AM 3 3x3   6008487.2849764 2096519.17342203 37.7371218206329 -122.413131433288 (37.7371218206329, -122.413131433288) 10 7 7 28859 2
153285 102156 Undocumented 4 Ligustrum lucidum :: Glossy Privet 57 450X Banks St 11 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   3 3x4   6008490.5 2096648.5 37.7374771037155 -122.413129459512 (37.7374771037155, -122.413129459512) 10 7 7 28859 2
155971 73874 Undocumented 4 Ligustrum lucidum :: Glossy Privet 57 450X Banks St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/18/1994 12:00:00 AM 3 3x4   6008487.2849764 2096519.17342203 37.7371218206329 -122.413131433288 (37.7371218206329, -122.413131433288) 10 7 7 28859 2
163770 98938 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1400X San Bruno Ave 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   3 3x3   6011147.5 2101806.3 37.7517881116631 -122.404305836485 (37.7517881116631, -122.404305836485) 10 4 8 28859 19
169010 102195 Undocumented 4 Ligustrum lucidum :: Glossy Privet 57 3999X Folsom St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   3 3x3   6008408 2096514 37.7371031642446 -122.41340519256 (37.7371031642446, -122.41340519256) 10 7 7 28859 2
176008 74108 Undocumented 4 Ligustrum lucidum :: Glossy Privet 57 555 Tompkins Ave 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/18/1994 12:00:00 AM 3 3x3   6008487.2849764 2096519.17342203 37.7371218206329 -122.413131433288 (37.7371218206329, -122.413131433288) 10 7 7 28859 2
183831 102192 Undocumented 4 Ligustrum lucidum :: Glossy Privet 57 3999X Folsom St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   3 3x3   6008408 2096514 37.7371031642446 -122.41340519256 (37.7371031642446, -122.41340519256) 10 7 7 28859 2
189482 97895 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 375X Precita Ave 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   3 3x3   6008901.5 2100225.6 37.7473220995732 -122.411961145064 (37.7473220995732, -122.411961145064) 2 7 7 28859 2
7953 97241 DPW Maintained 1 Quercus agrifolia :: Coast Live Oak 172 260 Madrid St 12 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 09/07/2011 12:00:00 AM 3 3x3 Permit Number 767495 6003464 2092306.9 37.7252725856131 -122.430198780788 (37.7252725856131, -122.430198780788) 9 7 6 28861 5
15793 42348 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 380X Flood Ave 7 Sidewalk: Property side : Cutout Tree SFUSD 4 DPW for City Agency 06/23/2000 12:00:00 AM 3 8x45 Permit Number 42547 5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
23641 43313 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 148X Paris St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/04/2008 12:00:00 AM 3 3x3 Permit Number 50666 6003041.97819 2092624.14713 37.7261197629015 -122.431680307904 (37.7261197629015, -122.431680307904) 9 7 6 28861 5
27765 37839 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 451 Athens St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 07/07/1998 12:00:00 AM 3 4x6 Permit Number 40134 6003658.01474 2090473.5929 37.7202497170415 -122.42939741397 (37.7202497170415, -122.42939741397) 9 7 6 28861 5
30203 95755 DPW Maintained 1 Quercus agrifolia :: Coast Live Oak 172 260 Madrid St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 09/07/2011 12:00:00 AM 3 3x3 Permit Number 767495 6003450.90146 2092257.04406 37.7251349504027 -122.430240505894 (37.7251349504027, -122.430240505894) 9 7 6 28861 5
30221 95757 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 260 Madrid St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/25/2017 04:33:00 PM 3 3x3 Permit Number 767495 6003435.4103 2092233.16774 37.7250685138993 -122.430292354528 (37.7250685138993, -122.430292354528) 9 7 6 28861 5
36159 37832 DPW Maintained 1 Acacia baileyana :: Bailey's Acacia 122 450X Moscow St 19 Sidewalk: Property side : Cutout Tree SFUSD 4 DPW for City Agency 06/22/2006 12:00:00 AM 3 3x3 Permit Number 48867 6003860.1558 2090386.44981 37.7200218836872 -122.42869247048 (37.7200218836872, -122.42869247048) 9 7 6 28861 5
36285 95758 DPW Maintained 1 Quercus agrifolia :: Coast Live Oak 172 260 Madrid St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 09/07/2011 12:00:00 AM 3 3x3 Permit Number 767495 6003422.17585 2092210.81209 37.7250063806226 -122.430336510319 (37.7250063806226, -122.430336510319) 9 7 6 28861 5
37102 77218 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 499X Hearst Ave 22 Sidewalk: Property side : Cutout Tree SFUSD 4 DPW for City Agency 05/15/1999 12:00:00 AM 3 6x50   5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
37151 77198 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 499X Hearst Ave 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 05/15/1999 12:00:00 AM 3 3x3   5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
38894 95753 DPW Maintained 1 Quercus agrifolia :: Coast Live Oak 172 260 Madrid St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 09/07/2011 12:00:00 AM 3 3x3 Permit Number 767495 6003478.85461 2092303.36569 37.7252637225375 -122.430147177848 (37.7252637225375, -122.430147177848) 9 7 6 28861 5
42544 37824 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 450X Moscow St 12 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 07/07/1998 12:00:00 AM 3 3x3 Permit Number 40134 6003906.75378 2090460.71651 37.7202284408775 -122.428536688136 (37.7202284408775, -122.428536688136) 9 7 6 28861 5
44331 95756 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 260 Madrid St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/25/2017 04:16:00 PM 3 3x3 Permit Number 767495 6003442.24703 2092244.67659 37.7251005018853 -122.430269541405 (37.7251005018853, -122.430269541405) 9 7 6 28861 5
49228 97251 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 301X Excelsior Ave 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 09/07/2011 12:00:00 AM 3 4x4 Permit Number 767495 6003227.5697 2092233.02297 37.7250563415646 -122.431010826505 (37.7250563415646, -122.431010826505) 9 7 6 28861 5
50118 95752 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 260 Madrid St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/25/2017 03:47:00 PM 3 3x3 Permit Number 767495 6003490.3309 2092321.64943 37.7253145756058 -122.430108809186 (37.7253145756058, -122.430108809186) 9 7 6 28861 5
50176 99498 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 125 Excelsior Ave 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   3 3x3   6002794.02408 2092508.79842 37.7257889832596 -122.432529234659 (37.7257889832596, -122.432529234659) 9 7 6 28861 5
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
67335 97240 DPW Maintained 1 Quercus agrifolia :: Coast Live Oak 172 260 Madrid St 11 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 09/07/2011 12:00:00 AM 3 3x3 Permit Number 767495 6003400.64895 2092179.59067 37.7249194341684 -122.430408699814 (37.7249194341684, -122.430408699814) 9 7 6 28861 5
76214 37822 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 450X Moscow St 10 Sidewalk: Property side : Cutout Tree SFUSD 4 DPW for City Agency 10/11/2017 09:46:00 AM 3 3x3 Permit Number 40134 6003933.77466 2090481.79158 37.7202878374987 -122.428444787301 (37.7202878374987, -122.428444787301) 9 7 6 28861 5
76622 95754 DPW Maintained 1 Quercus agrifolia :: Coast Live Oak 172 260 Madrid St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 09/07/2011 12:00:00 AM 3 3x3 Permit Number 767495 6003464.56282 2092279.46461 37.7251972860232 -122.43019487879 (37.7251972860232, -122.43019487879) 9 7 6 28861 5
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
80956 97248 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 301X Excelsior Ave 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 09/07/2011 12:00:00 AM 3 4x4 Permit Number 767495 6003299.02479 2092188.30414 37.7249376022835 -122.430760624301 (37.7249376022835, -122.430760624301) 9 7 6 28861 5
84190 253150 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 450X Moscow St 3 Sidewalk: Property side : Cutout Tree SFUSD 4 DPW for City Agency 10/11/2017 09:41:00 AM 3 3x3   6003965.72194 2090553.13154 37.7204855291627 -122.428339438009 (37.7204855291627, -122.428339438009) 9 7 6 28861 5
90004 97245 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 301X Excelsior Ave 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/25/2017 04:18:00 PM 3 4x4 Permit Number 767495 6003351.72812 2092154.84242 37.7248487096971 -122.430576048361 (37.7248487096971, -122.430576048361) 9 7 6 28861 5
98004 37838 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 451 Athens St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 07/07/1998 12:00:00 AM 3 4x6 Permit Number 40134 6003644.26117 2090451.27602 37.7201876611143 -122.429443364835 (37.7201876611143, -122.429443364835) 9 7 6 28861 5
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
103631 37819 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 450X Moscow St 7 Sidewalk: Property side : Cutout Tree SFUSD 4 DPW for City Agency 07/07/1998 12:00:00 AM 3 3x3 Permit Number 40134 6003953.55423 2090513.34715 37.7203756014419 -122.428378663762 (37.7203756014419, -122.428378663762) 9 7 6 28861 5
106561 97238 Property Tree 8 Olea europaea :: Olive Tree 9 125 Excelsior Ave 1 Sidewalk: Property side : Yard Tree SFUSD 4 FUF 09/07/2011 12:00:00 AM 3 3x3 Permit Number 767513 6002911 2092621.3 37.7261045201699 -122.432132888294 (37.7261045201699, -122.432132888294) 9 7 6 28861 5
118902 97239 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 260 Madrid St 10 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/25/2017 03:49:00 PM 3 3x3 Permit Number 767495 6003412.15812 2092196.84002 37.7249674489828 -122.430370144078 (37.7249674489828, -122.430370144078) 9 7 6 28861 5
119161 37821 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 450X Moscow St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 07/07/1998 12:00:00 AM 3 3x3 Permit Number 40134 6003927.90297 2090495.79555 37.7203259570536 -122.428466081444 (37.7203259570536, -122.428466081444) 9 7 6 28861 5
121431 97249 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 301X Excelsior Ave 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 09/07/2011 12:00:00 AM 3 4x4 Permit Number 767495 6003279.34346 2092200.52554 37.7249700444293 -122.430829532173 (37.7249700444293, -122.430829532173) 9 7 6 28861 5
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
141169 97246 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 301X Excelsior Ave 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/25/2017 04:11:00 PM 3 4x4 Permit Number 767495 6003334.6314 2092165.82905 37.7248779079737 -122.430635933307 (37.7248779079737, -122.430635933307) 9 7 6 28861 5
145588 95750 DPW Maintained 1 Quercus agrifolia :: Coast Live Oak 172 260 Madrid St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 09/07/2011 12:00:00 AM 3 3x3 Permit Number 767495 6003564.18987 2092436.84432 37.7256350580097 -122.429861698861 (37.7256350580097, -122.429861698861) 9 7 6 28861 5
153384 43310 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 150X Paris St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/04/2008 12:00:00 AM 3 3x3 Permit Number 50666 6002773.36898986 2092525.07870875 37.7258325139415 -122.432601800105 (37.7258325139415, -122.432601800105) 9 7 6 28861 5
154114 37833 DPW Maintained 1 Acacia baileyana :: Bailey's Acacia 122 450X Moscow St 20 Sidewalk: Property side : Cutout Tree SFUSD 4 DPW for City Agency 07/07/1998 12:00:00 AM 3 3x3 Permit Number 40134 6003832.66245 2090342.46114 37.7198995444156 -122.428784371324 (37.7198995444156, -122.428784371324) 9 7 6 28861 5
158362 97250 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 301X Excelsior Ave 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 09/07/2011 12:00:00 AM 3 4x4 Permit Number 767495 6003264.30376 2092207.68877 37.724988860924 -122.430882033691 (37.724988860924, -122.430882033691) 9 7 6 28861 5
160859 42357 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 380X Flood Ave 16 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/23/2000 12:00:00 AM 3 3x3 Permit Number 42547 5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
163627 253146 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 260 Madrid St 12 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/25/2017 04:29:00 PM 3 3x3 Permit Number 767495 6003400.64895 2092179.59067 37.7249194341684 -122.430408699814 (37.7249194341684, -122.430408699814) 9 7 6 28861 5
163795 37830 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 451 Athens St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 07/09/2007 12:00:00 AM 3 6x6 Permit Number 49480 6003635.85955 2090436.92041 37.7201477680848 -122.429471383195 (37.7201477680848, -122.429471383195) 9 7 6 28861 5
169000 37827 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 450X Moscow St 15 Sidewalk: Property side : Cutout Tree SFUSD 4 DPW for City Agency 07/07/1998 12:00:00 AM 3 3x3 Permit Number 40134 6003888.33038 2090432.03853 37.7201486548235 -122.428598328547 (37.7201486548235, -122.428598328547) 9 7 6 28861 5
176834 37820 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 450X Moscow St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 07/07/1998 12:00:00 AM 3 3x3 Permit Number 40134 6003945.80086 2090498.97809 37.7203357084188 -122.428404441018 (37.7203357084188, -122.428404441018) 9 7 6 28861 5
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
181911 37840 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 451 Athens St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 07/09/2007 12:00:00 AM 3 4x6 Permit Number 49480 6003672.4294 2090496.54171 37.7203135455184 -122.429349222898 (37.7203135455184, -122.429349222898) 9 7 6 28861 5
182392 97247 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 301X Excelsior Ave 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 09/07/2011 12:00:00 AM 3 4x4 Permit Number 767495 6003399 2092092 37.7246788362927 -122.430408153397 (37.7246788362927, -122.430408153397) 9 7 6 28861 5
183530 95751 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 260 Madrid St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/25/2017 04:36:00 PM 3 3x3 Permit Number 767495 6003552.81378 2092420.08444 37.7255883948789 -122.429899830124 (37.7255883948789, -122.429899830124) 9 7 6 28861 5
189866 37825 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 450X Moscow St 13 Sidewalk: Property side : Cutout Tree SFUSD 4 DPW for City Agency 07/07/1998 12:00:00 AM 3 3x3 Permit Number 40134 6003912.01731 2090448.66207 37.7201956398999 -122.428517635078 (37.7201956398999, -122.428517635078) 9 7 6 28861 5
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
194422 37823 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 450X Moscow St 11 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 10/11/2017 09:49:00 AM 3 3x3 Permit Number 40134 6003922.69393 2090463.29382 37.7202364196636 -122.428481771941 (37.7202364196636, -122.428481771941) 9 7 6 28861 5
194434 37829 DPW Maintained 1 Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 450X Moscow St 17 Sidewalk: Property side : Cutout Tree SFUSD 4 DPW for City Agency 10/11/2017 09:54:00 AM 3 3x3 Permit Number 40134 6003878.28183 2090416.42534 37.7201052157501 -122.428631950629 (37.7201052157501, -122.428631950629) 9 7 6 28861 5
2474 256556 Property Tree 8 Acer rubrum :: Red Maple 75 3401X 16th St 5 Side Yard : Yard Tree SFUSD 4   02/08/2019 09:18:00 AM 3 3x3   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3
19907 102028 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 165X Chattanooga St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   3 3x3   6004753 2102714 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656) 2 4 5 28862 22
20806 102022 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 165X Chattanooga St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   3 3x3   6004753 2102714 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656) 2 4 5 28862 22
34431 256554 Property Tree 8 Acer rubrum :: Red Maple 75 3401X 16th St 3 Side Yard : Yard Tree SFUSD 4   02/08/2019 09:10:00 AM 3 3x3   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3

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