trees

416 rows where Police Districts = 8 and qLegalStatus_id = 6 sorted by Supervisor Districts

✎ View and edit SQL

This data as json, CSV (advanced)

Police Districts ✖

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)
24761 101258 Significant Tree 6 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 1049 Irving St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5992548 2106581 37.7638413023971 -122.468972303767 (37.7638413023971, -122.468972303767) 1 8 11 56 12
50301 254481 Significant Tree 6 Juniperus chinensis :: Juniper 113 1274 11th Ave 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   5992738 2106820 37.7645085090972 -122.468332545675 (37.7645085090972, -122.468332545675) 11 8 11 56 12
99362 99847 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 850@14th Ave Judah St 1 Sidewalk: Curb side : Cutout Tree Private 2           5991942 2105939 37.7620435090796 -122.471021481615 (37.7620435090796, -122.471021481615) 1 8 11 56 12
523 92314 Significant Tree 6 Prunus serrulata :: Ornamental Cherry 84 2783 34th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3 3x3   5985837.7861 2096464.2212 37.7356733962807 -122.491435886509 (37.7356733962807, -122.491435886509) 1 8 3 29491 35
1475 80073 Significant Tree 6 Prunus serrulata :: Ornamental Cherry 84 2788 34th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3     5985889.2586 2096432.3825 37.735588983385 -122.491255586179 (37.735588983385, -122.491255586179) 1 8 3 64 35
1697 92318 Significant Tree 6 Prunus serrulata :: Ornamental Cherry 84 2787 34th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3 3x3   5985842.0312 2096446.1793 37.7356241060746 -122.49141988223 (37.7356241060746, -122.49141988223) 1 8 3 29491 35
2591 92319 Significant Tree 6 Prunus serrulata :: Ornamental Cherry 84 2788 34th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3 3x3   5985889.2586 2096423.8922 37.7355656712712 -122.491254961509 (37.7355656712712, -122.491254961509) 1 8 3 64 35
5246 262331 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 2140 Wawona St 1 Back Yard : Cutout Tree Private 2       3x3   5986390 2097232 37.7378137677629 -122.489583137449 (37.7378137677629, -122.489583137449) 1 8 3 29491 35
5577 92312 Significant Tree 6 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 2711 34th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3 3x3   5985822.132 2096946.3119 37.7369961745626 -122.49152548244 (37.7369961745626, -122.49152548244) 1 8 3 29491 35
6931 92315 Significant Tree 6 Prunus serrulata :: Ornamental Cherry 84 2783 34th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3 3x3   5985839.9086 2096474.3035 37.7357012036342 -122.491429290175 (37.7357012036342, -122.491429290175) 1 8 3 29491 35
7291 105130 Significant Tree 6 Tree(s) :: 17 4045 MORAGA ST   Sidewalk: Property side : Yard Tree Private 2           5981665.2 2103465.9 37.7546533409301 -122.506380933635 (37.7546533409301, -122.506380933635) 1 8 3 56 35
8974 260925 Significant Tree 6 Pittosporum crassifolium :: Karo Tree 95 1900 Noriega St 1 Sidewalk: Property side : Yard Tree Private 2       3x3   5987961.4849 2103092.5821 37.7539969916819 -122.484579575666 (37.7539969916819, -122.484579575666) 1 8 3 56 35
10025 264885 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 1279 44th Ave 1 Front Yard : Yard Tree Private 2       3x3 Permit Number 787806 5982392 2106415 37.7627934961857 -122.504085938563 (37.7627934961857, -122.504085938563) 1 8 3 56 35
11618 92317 Significant Tree 6 Prunus serrulata :: Ornamental Cherry 84 2787 34th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3 3x3   5985840.9699 2096433.9745 37.7355905329114 -122.491422653463 (37.7355905329114, -122.491422653463) 1 8 3 29491 35
13252 92316 Significant Tree 6 Prunus serrulata :: Ornamental Cherry 84 2787 34th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3 3x3   5985840.4393 2096424.4229 37.7355642757438 -122.49142378511 (37.7355642757438, -122.49142378511) 1 8 3 29491 35
13325 259319 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 1746 20th Ave 1 Front Yard : Yard Tree Private 2       3x3   5990028 2103516 37.7552797120334 -122.477464095722 (37.7552797120334, -122.477464095722) 1 8 3 56 35
14866 259322 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 1721 19th Ave 1 Front Yard : Yard Tree Private 2   11/25/2019 12:00:00 AM 3 3x3 Permit Number 783194 5990247 2103661 37.7556905489205 -122.476717329726 (37.7556905489205, -122.476717329726) 1 8 3 56 35
31720 254395 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 1286 26th Ave 1 Sidewalk: Property side : Cutout Tree Private 2       3x3 Permit Number 781556 5988061 2106558 37.7635178832746 -122.484489596097 (37.7635178832746, -122.484489596097) 1 8 3 56 35
44150 105208 Significant Tree 6 Myoporum laetum :: Myoporum 62 2694 47TH AVE   Front Yard : Yard Tree Private 2           5981878.3 2096771.8 37.7362857499502 -122.505147911282 (37.7362857499502, -122.505147911282) 1 8 3 29491 35
44754 253482 Significant Tree 6 Juniperus chinensis :: Juniper 113 2179 41st Ave 1 Front Yard : Yard Tree Private 2       3x5   5983532 2100331 37.7461555051432 -122.499693454208 (37.7461555051432, -122.499693454208) 1 8 3 29491 35
45577 92320 Significant Tree 6 Metrosideros excelsa :: New Zealand Xmas Tree 16 2733 Wawona St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/18/2008 12:00:00 AM 3 3x3   5984522 2096783 37.7364716996862 -122.496008508371 (37.7364716996862, -122.496008508371) 1 8 3 29491 35
48743 253145 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 801X Santiago St 1 Side Yard : Yard Tree Private 2           5990274 2099728 37.7448931297685 -122.476336677657 (37.7448931297685, -122.476336677657) 1 8 3 29491 35
52128 112811 Significant Tree 6 Tree(s) :: 17 2023 43rd Ave 1 Front Yard : Yard Tree Private 2           5982877.4 2101339.2 37.7488853101021 -122.502031530859 (37.7488853101021, -122.502031530859) 1 8 3 29491 35
55399 92310 Significant Tree 6 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2591 26th Ave 1 Sidewalk: Property side : Cutout Tree Private 2 FUF 10/18/2008 12:00:00 AM   3x3   5988279 2097698.2 37.7392039339278 -122.483086187221 (37.7392039339278, -122.483086187221) 1 8 3 29491 35
63888 254137 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1619 47th Ave 1 Side Yard : Yard Tree Private 2       6x6   5981543 2104041 37.756225206981 -122.506846181577 (37.756225206981, -122.506846181577) 1 8 3 56 35
83312 254136 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1623 47th Ave 1 Front Yard : Yard Tree Private 2       10x6 Permit Number 781075 5981544 2104016 37.7561566229771 -122.506840869024 (37.7561566229771, -122.506840869024) 1 8 3 56 35
84826 174950 Significant Tree 6 Metrosideros excelsa :: New Zealand Xmas Tree 16 309 Crestlake Dr 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5987294 2096147 37.7348873783654 -122.486377975564 (37.7348873783654, -122.486377975564) 1 8 3 64 35
97021 105907 Significant Tree 6 Pinus Spp :: Pine Spp 100 1837 30TH AVE 1 Front Yard : Yard Tree Private 2     6     5986904 2102674 37.7527860393128 -122.488205804709 (37.7527860393128, -122.488205804709) 1 8 3 56 35
101005 104736 Significant Tree 6 Lagunaria patersonii :: Primrose Tree 6 1499X 44th Ave 1 Front Yard : Yard Tree Private 2         Permit Number 770763 5982473.05016 2105245.16297 37.7595862228156 -122.503718978789 (37.7595862228156, -122.503718978789) 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
112272 105540 Significant Tree 6 Myoporum laetum :: Myoporum 62 2694 47TH AVE 1 Front Yard : Yard Tree Private 2     12     5981878.3 2096771.8 37.7362857499502 -122.505147911282 (37.7362857499502, -122.505147911282) 1 8 3 29491 35
114772 92311 Significant Tree 6 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2211 33rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/18/2008 12:00:00 AM 3 3x3   5986022.3 2100155.2 37.7458186185696 -122.491069496457 (37.7458186185696, -122.491069496457) 1 8 3 29491 35
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
160882 113234 Significant Tree 6 Magnolia grandiflora :: Southern Magnolia 19 2023 43RD AVE 1 Front Yard : Yard Tree Private 2     12 3x3   5982877 2101339 37.7488847374588 -122.502032899239 (37.7488847374588, -122.502032899239) 1 8 3 29491 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
183804 121087 Significant Tree 6 Myoporum laetum :: Myoporum 62 1443 47th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 778784 5981521.32072 2105258.5458 37.7595669638281 -122.507011468719 (37.7595669638281, -122.507011468719) 1 8 3 56 35
187309 106198 Significant Tree 6 Juniperus scopulorum 'Pat :: Juniper Tree 'Pathfinder' 570 2101 42ND AVE 1 Front Yard : Yard Tree Private 2     18     5983206.1 2100796.8 37.7474153345648 -122.500854798087 (37.7474153345648, -122.500854798087) 1 8 3 29491 35
194467 265133 Significant Tree 6 Cordyline australis :: Dracena Palm 64 2166 41st Ave 1 Sidewalk: Property side : Cutout Tree Private 2   01/11/2021 12:00:00 AM 3 3x3 Permit Number 783123 5983589.67085 2100408.11005 37.7463706120083 -122.499499736486 (37.7463706120083, -122.499499736486) 1 8 3 29491 35
63 264975 Significant Tree 6 Pinus radiata :: Monterey Pine 15 445 Ortega St 1 Front Yard : Yard Tree Private 2       10x30   5992686 2102646 37.7530447932571 -122.468208733714 (37.7530447932571, -122.468208733714) 1 8 4 56 12
68 264976 Significant Tree 6 Pinus radiata :: Monterey Pine 15 445 Ortega St 2 Front Yard : Yard Tree Private 2       10x30   5992686 2102646 37.7530447932571 -122.468208733714 (37.7530447932571, -122.468208733714) 1 8 4 56 12
177 253253 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 99X Lopez Ave 4 Front Yard : Yard Tree Private 2       10x10   5994049 2100330 37.746764271907 -122.463327202712 (37.746764271907, -122.463327202712) 1 8 4 29491 40
256 254254 Significant Tree 6 Pinus radiata :: Monterey Pine 15 45X Everglade Dr 1 Sidewalk: Property side : Yard Tree Private 2       3x3   5986312 2095495 37.7330398702545 -122.489725113139 (37.7330398702545, -122.489725113139) 1 8 4 64 35
748 259270 Significant Tree 6 Pinus radiata :: Monterey Pine 15 3580X 19th Ave 8 Sidewalk: Property side : Yard Tree Private 2       3x3 Permit Number 784388 5990529 2092111 37.723993571379 -122.474899060099 (37.723993571379, -122.474899060099) 9 8 4 64 14
797 260459 Significant Tree 6 Tree(s) :: 17 1798X Monterey Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2   10/09/2019 12:00:00 AM 3 5x10 Permit Number 784470 5992678 2095461 37.733316146518 -122.467713892437 (37.733316146518, -122.467713892437) 9 8 4 59 40
821 261708 Significant Tree 6 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 20 Entrada Ct 1 Front Yard : Yard Tree Private 2   02/21/2020 12:00:00 AM 3 3x3 Permit Number 783258 5992481.8221 2092418.55282 37.724951011222 -122.468170882637 (37.724951011222, -122.468170882637) 9 8 4 59 40
891 207770 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 40 Santa Clara Ave 2 Sidewalk: Curb side : Yard Tree Private 2     35 Width 10ft   5993240.61068 2097284.1687 37.7383545825079 -122.465901234858 (37.7383545825079, -122.465901234858) 1 8 4 59 40
1002 260458 Significant Tree 6 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 835 Darien Way 1 Sidewalk: Property side : Yard Tree Private 2   11/19/2019 12:00:00 AM 3 6x10 Permit Number 784514 5994066 2094094 37.7296427463027 -122.462816092129 (37.7296427463027, -122.462816092129) 9 8 4 59 40
1038 259268 Significant Tree 6 Pinus radiata :: Monterey Pine 15 3580X 19th Ave 6 Sidewalk: Property side : Yard Tree Private 2       3x3 Permit Number 784388 5990529 2092111 37.723993571379 -122.474899060099 (37.723993571379, -122.474899060099) 9 8 4 64 14
1901 262254 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 4210 Ocean Ave 7 Sidewalk: Property side : Yard Tree Private 2       3x3 Permit Number 785453 5986512 2095174 37.7321701636719 -122.489010079787 (37.7321701636719, -122.489010079787) 1 8 4 64 35
2183 117295 Significant Tree 6 Tree(s) :: 17 130 CAMBON DR 1 Side Yard : Yard Tree Private 2       3x3   5990450 2089482 37.7167704112637 -122.474980331165 (37.7167704112637, -122.474980331165) 1 8 4 64 14
2657 260570 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 131 Edgehill Way 4 Front Yard : Yard Tree Private 2       3x3   5994866 2098973 37.743085324311 -122.460403807929 (37.743085324311, -122.460403807929) 1 8 4 59 40
4000 79751 Significant Tree 6 Schinus terebinthifolius :: Brazilian Pepper 93 15 Junipero Serra Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2       4x10   5991685.90264393 2095891.27109779 37.7344402285305 -122.471175151585 (37.7344402285305, -122.471175151585) 9 8 4 59 40
4096 261159 Significant Tree 6 Tree(s) :: 17 1100X Moraga St 3 Sidewalk: Property side : Yard Tree Private 2   05/22/2020 12:00:00 AM 3 10x10 Permit Number 784837 5990881 2103853 37.7562544846391 -122.474538790377 (37.7562544846391, -122.474538790377) 1 8 4 56 12
4567 261551 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 135 Fernwood Dr 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5994788 2095004 37.7321829429526 -122.460385989231 (37.7321829429526, -122.460385989231) 9 8 4 59 40
4737 261021 Significant Tree 6 Pinus radiata :: Monterey Pine 15 3440X 19th Ave 2 Back Yard : Yard Tree Private 2       10x10 Permit Number 784857 5990714 2092679 37.7255638768787 -122.474300978757 (37.7255638768787, -122.474300978757) 9 8 4 64 40
5792 260568 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 131 Edgehill Way 2 Front Yard : Yard Tree Private 2       3x3   5994866 2098973 37.743085324311 -122.460403807929 (37.743085324311, -122.460403807929) 1 8 4 59 40
6044 259265 Significant Tree 6 Pinus radiata :: Monterey Pine 15 3580X 19th Ave 3 Sidewalk: Property side : Yard Tree Private 2       3x3 Permit Number 784388 5990529 2092111 37.723993571379 -122.474899060099 (37.723993571379, -122.474899060099) 9 8 4 64 14
6296 260461 Significant Tree 6 Pinus radiata :: Monterey Pine 15 99X Lopez Ave 4 Front Yard : Yard Tree Private 2       10x10 Permit Number 784513 5994049 2100330 37.746764271907 -122.463327202712 (37.746764271907, -122.463327202712) 1 8 4 29491 40
6364 264920 Significant Tree 6 Tree(s) :: 17 99X Everglade Dr 2 Sidewalk: Property side : Cutout Tree Private 2   11/10/2020 12:00:00 AM 3 6x10 Permit Number 785453 5986512 2095174 37.7321701636719 -122.489010079787 (37.7321701636719, -122.489010079787) 1 8 4 64 35
6370 261832 Significant Tree 6 Ilex spp :: Holly Species 81 16 Merced Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5995265 2100184 37.7464333732005 -122.459111852123 (37.7464333732005, -122.459111852123) 1 8 4 59 40
6747 261157 Significant Tree 6 Tree(s) :: 17 1100X Moraga St 1 Sidewalk: Property side : Yard Tree Private 2   05/22/2020 12:00:00 AM 3 10x10 Permit Number 784837 5990881 2103853 37.7562544846391 -122.474538790377 (37.7562544846391, -122.474538790377) 1 8 4 56 12
6915 116579 Significant Tree 6 Shrub :: Shrub 66 3000x 19TH AVE 2 Sidewalk: Property side : Cutout Tree MTA 3 DPW     3x3   5990602 2095184 37.7324354869182 -122.47487091251 (37.7324354869182, -122.47487091251) 1 8 4 64 40
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
7796 264921 Significant Tree 6 Tree(s) :: 17 99X Everglade Dr 3 Sidewalk: Property side : Cutout Tree Private 2   11/10/2020 12:00:00 AM 3 6x10 Permit Number 785453 5986512 2095174 37.7321701636719 -122.489010079787 (37.7321701636719, -122.489010079787) 1 8 4 64 35
8007 261753 Significant Tree 6 Podocarpus gracilor :: Fern Pine 51 127 Edgehill Way 3 Back Yard : Cutout Tree Private 2   02/25/2020 12:00:00 AM 3     5994849.50332 2098967.43632 37.7430690988325 -122.46046044555 (37.7430690988325, -122.46046044555) 1 8 4 59 40
8040 260572 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 131 Edgehill Way 6 Front Yard : Yard Tree Private 2       3x3   5994866 2098973 37.743085324311 -122.460403807929 (37.743085324311, -122.460403807929) 1 8 4 59 40
8965 261020 Significant Tree 6 Pinus radiata :: Monterey Pine 15 3440X 19th Ave 1 Back Yard : Yard Tree Private 2       10x10 Permit Number 784857 5990714 2092679 37.7255638768787 -122.474300978757 (37.7255638768787, -122.474300978757) 9 8 4 64 40
9206 114067 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 6 Higuera Ave 1 Front Yard : Cutout Tree Private 2     20     5987898 2090420 37.7191976939958 -122.48386996767 (37.7191976939958, -122.48386996767) 1 8 4 64 14
9303 259269 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 3580X 19th Ave 7 Sidewalk: Property side : Yard Tree Private 2       3x3   5990529 2092111 37.723993571379 -122.474899060099 (37.723993571379, -122.474899060099) 9 8 4 64 14
9381 261160 Significant Tree 6 Tree(s) :: 17 1100X Moraga St 4 Sidewalk: Property side : Yard Tree Private 2   05/22/2020 12:00:00 AM 3 10x10 Permit Number 784837 5990881 2103853 37.7562544846391 -122.474538790377 (37.7562544846391, -122.474538790377) 1 8 4 56 12
9478 260514 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 3025 22nd Ave 1 Sidewalk: Property side : Yard Tree Private 2       3x3   5989750.29916 2095052.76589 37.7320257582668 -122.477805820702 (37.7320257582668, -122.477805820702) 1 8 4 64 35
9997 104935 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 835 Gonzalez Dr 1 Front Yard : Yard Tree Private 2           5990419 2090610 37.7198658237335 -122.475169782631 (37.7198658237335, -122.475169782631) 1 8 4 64 40
10229 264894 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 56 Keystone Way 1 Back Yard : Yard Tree Private 2       3x3   5994156 2093086 37.7268802074189 -122.462431871086 (37.7268802074189, -122.462431871086) 9 8 4 28861 40
10661 114250 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 131 FONT BLVD 1 Front Yard : Yard Tree Private 2     36     5990844 2088883 37.7151485301311 -122.473574812248 (37.7151485301311, -122.473574812248) 1 8 4 64 14
11182 261019 Significant Tree 6 Pinus radiata :: Monterey Pine 15 3450X 19th Ave 1 Back Yard : Yard Tree Private 2       10x10 Permit Number 784867 5990575 2092822 37.725948465298 -122.47479191789 (37.725948465298, -122.47479191789) 9 8 4 64 14
11254 259267 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 3580X 19th Ave 5 Sidewalk: Property side : Yard Tree Private 2       3x3   5990529 2092111 37.723993571379 -122.474899060099 (37.723993571379, -122.474899060099) 9 8 4 64 14
11391 260515 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 487 Eucalyptus Dr 1 Sidewalk: Property side : Yard Tree Private 2       10x10 Permit Number 784711 5989595 2094714 37.7310865793073 -122.478317956131 (37.7310865793073, -122.478317956131) 1 8 4 64 14
11442 260571 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 131 Edgehill Way 5 Front Yard : Yard Tree Private 2       3x3   5994866 2098973 37.743085324311 -122.460403807929 (37.743085324311, -122.460403807929) 1 8 4 59 40
11628 261752 Significant Tree 6 Podocarpus gracilor :: Fern Pine 51 127 Edgehill Way 2 Back Yard : Cutout Tree Private 2   02/25/2020 12:00:00 AM 3     5994849.50332 2098967.43632 37.7430690988325 -122.46046044555 (37.7430690988325, -122.46046044555) 1 8 4 59 40
11875 260569 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 131 Edgehill Way 3 Front Yard : Yard Tree Private 2       3x3   5994866 2098973 37.743085324311 -122.460403807929 (37.743085324311, -122.460403807929) 1 8 4 59 40
11981 261158 Significant Tree 6 Juniperus californica :: California juniper 295 1100X Moraga St 2 Sidewalk: Property side : Yard Tree Private 2       10x10 Permit Number 784837 5990881 2103853 37.7562544846391 -122.474538790377 (37.7562544846391, -122.474538790377) 1 8 4 56 12
12033 259149 Significant Tree 6 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 150 Lenox Way 1 Front Yard : Yard Tree Private 2       5x5   5993309.4847 2098463.34097 37.7415962663129 -122.465748753199 (37.7415962663129, -122.465748753199) 1 8 4 59 40
12152 255704 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 201X Hernandez Ave 1 Side Yard : Yard Tree Private 2       10x10   5995122 2099706 37.7451126829106 -122.459571712369 (37.7451126829106, -122.459571712369) 1 8 4 59 40
12273 261709 Significant Tree 6 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 20 Entrada Ct 2 Front Yard : Yard Tree Private 2   02/21/2020 12:00:00 AM 3 3x3 Permit Number 783258 5992481.8221 2092418.55282 37.724951011222 -122.468170882637 (37.724951011222, -122.468170882637) 9 8 4 59 40
12287 95982 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 100 Vasquez Ave 1 Back Yard : Yard Tree Private 2           5995122.4 2099706.3 37.7451135296363 -122.459570350972 (37.7451135296363, -122.459570350972) 1 8 4 59 40
12868 111864 Significant Tree 6 Callistemon citrinus :: Lemon Bottlebrush 67 45 Allston Way 1 Front Yard : Yard Tree Private 2   06/26/2015 12:00:00 AM 3   Permit Number 775591 5994228.4 2098418 37.7415247340782 -122.462568190827 (37.7415247340782, -122.462568190827) 1 8 4 59 40
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
13120 258703 Significant Tree 6 Tree(s) :: 17 131X Juan Bautista Cir 2 Sidewalk: Curb side : Yard Tree Private 2   11/25/2019 12:00:00 AM 3 3x3 Permit Number 783241 5989556 2089774 37.7175203194228 -122.478091750656 (37.7175203194228, -122.478091750656) 1 8 4 64 14
13149 260567 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 131 Edgehill Way 1 Front Yard : Yard Tree Private 2       3x3   5994866 2098973 37.743085324311 -122.460403807929 (37.743085324311, -122.460403807929) 1 8 4 59 40
13301 114388 Significant Tree 6 Prunus cerasifera :: Cherry Plum 7 361x ARBALLO DR 1 Front Yard : Yard Tree Private 2     7     5988379 2090615 37.7197611043299 -122.482221632222 (37.7197611043299, -122.482221632222) 1 8 4 64 14
13972 260573 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 129 Edgehill Way 1 Sidewalk: Property side : Yard Tree Private 2       3x3   5994858 2098970 37.7430766268484 -122.460431252252 (37.7430766268484, -122.460431252252) 1 8 4 59 40
14608 259056 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 99 Cedro Ave 1 Front Yard : Yard Tree Private 2   10/09/2019 12:00:00 AM 3 3x3 Permit Number 784357 5992279 2093128 37.7268872622364 -122.468923614031 (37.7268872622364, -122.468923614031) 9 8 4 59 40
14911 264785 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1738 14th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       10x10   5991929 2103547 37.7554749546691 -122.470892190435 (37.7554749546691, -122.470892190435) 1 8 4 56 12
15055 259264 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 3580X 19th Ave 2 Sidewalk: Property side : Yard Tree Private 2       3x3   5990529 2092111 37.723993571379 -122.474899060099 (37.723993571379, -122.474899060099) 9 8 4 64 14
15254 260460 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 1798X Monterey Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2       5x10   5992678 2095461 37.733316146518 -122.467713892437 (37.733316146518, -122.467713892437) 9 8 4 59 40
15671 104278 Significant Tree 6 Acacia spp :: Acacia Spp 105 2 Allston Way 1 Back Yard : Yard Tree Private 2           5994445.1 2098202.2 37.7409446783355 -122.461803277974 (37.7409446783355, -122.461803277974) 1 8 4 59 40
15674 258702 Significant Tree 6 Tree(s) :: 17 131X Juan Bautista Cir 1 Sidewalk: Curb side : Yard Tree Private 2   11/25/2019 12:00:00 AM 3 3x3 Permit Number 783241 5989556 2089774 37.7175203194228 -122.478091750656 (37.7175203194228, -122.478091750656) 1 8 4 64 14
16055 260578 Significant Tree 6 Tree(s) :: 17 1879 Funston Ave 1 Sidewalk: Property side : Cutout Tree Private 2   05/22/2020 12:00:00 AM 3 Width 3ft Permit Number 784834 5992075.37659 2102679.56742 37.7531016753032 -122.470322812874 (37.7531016753032, -122.470322812874) 1 8 4 56 12
16256 260911 Significant Tree 6 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 2035 15th Ave 1 Front Yard : Yard Tree Private 2       Width 3ft   5991575 2101572 37.7500316406912 -122.471972478281 (37.7500316406912, -122.471972478281) 1 8 4 29491 12
16652 258405 Significant Tree 6 Myoporum laetum :: Myoporum 62 15 Junipero Serra Blvd 3 Sidewalk: Curb side : Cutout Tree Private 2       6x10   5991685.90264393 2095891.27109779 37.7344402285305 -122.471175151585 (37.7344402285305, -122.471175151585) 9 8 4 59 40

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