trees
1,732 rows where qLegalStatus_id = 6 sorted by Fire Prevention Districts
This data as json, CSV (advanced)
qSiteInfo ✖
- Front Yard : Yard 688
- Sidewalk: Curb side : Cutout 257
- Sidewalk: Property side : Yard 202
- Sidewalk: Property side : Cutout 183
- Front Yard : Cutout 112
- Back Yard : Yard 110
- Side Yard : Yard 54
- Sidewalk: Curb side : Yard 53
- Back Yard : Cutout 15
- Front Yard : 15
- Side Yard : Cutout 13
- Sidewalk: Curb side : Pot 6
- Median : Yard 5
- Sidewalk: Property side : 5
- Unaccepted Street : Yard 5
- : Cutout 4
- : 1
- Front Yard : Pot 1
- Hanging basket : Yard 1
- unknown : Cutout 1
- unknown : Yard 1
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
84 | 254457 | Significant Tree 6 | Dodonaea viscosa :: Hop Bush 43 | 1055X Duncan St | 2 | Side Yard : Yard | Tree | Private 2 | |||||||||||||||
394 | 119605 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 299x Avalon Ave | 1 | Front Yard : Yard | Tree | Private 2 | |||||||||||||||
1051 | 251262 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 3630x 19th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 779147 | ||||||||||||||
2100 | 253677 | Significant Tree 6 | Pinus canariensis :: Canary Island Pine 35 | 199X Kissling St | 1 | Side Yard : Cutout | Tree | Private 2 | 5x10 | ||||||||||||||
3171 | 119608 | Significant Tree 6 | Cupressocyparis leylandii :: Leyland Cypress 185 | 299x Avalon Ave | 4 | Front Yard : Yard | Tree | Private 2 | |||||||||||||||
3182 | 261252 | Significant Tree 6 | Banksia integrifolia :: Coast Banksia 21 | 100 Collins St | 1 | Front Yard : Cutout | Tree | Private 2 | 12/18/2019 12:00:00 AM | 3 | |||||||||||||
4934 | 103659 | Significant Tree 6 | Tree(s) :: 17 | 350X Hickory St | 3 | Front Yard : Yard | Tree | DPW for City Agency 14 | DPW | 06/07/2013 12:00:00 AM | Permit Number 770306 | ||||||||||||
5510 | 104813 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 1601X Portola Dr | 5 | Front Yard : Yard | Tree | Private 2 | |||||||||||||||
5622 | 251139 | Significant Tree 6 | Tree(s) :: 17 | 621X Gough St | 1 | Back Yard : Yard | Tree | Private 2 | 03/10/2017 12:00:00 AM | 3 | Permit Number 779685 | ||||||||||||
6834 | 103660 | Significant Tree 6 | Tree(s) :: 17 | 350X Hickory St | 4 | Front Yard : Yard | Tree | DPW for City Agency 14 | DPW | 06/07/2013 12:00:00 AM | Permit Number 770306 | ||||||||||||
7039 | 119606 | Significant Tree 6 | Myoporum laetum :: Myoporum 62 | 299x Avalon Ave | 2 | Front Yard : Yard | Tree | Private 2 | |||||||||||||||
7389 | 119599 | Significant Tree 6 | Cupressocyparis leylandii :: Leyland Cypress 185 | 4357x Mission St | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 774415 | ||||||||||||||
7411 | 103658 | Significant Tree 6 | Tree(s) :: 17 | 350X Hickory St | 2 | Front Yard : Yard | Tree | DPW for City Agency 14 | DPW | 06/07/2013 12:00:00 AM | Permit Number 770306 | ||||||||||||
8509 | 103668 | Significant Tree 6 | Tree(s) :: 17 | 350X Hickory St | 6 | Front Yard : Yard | Tree | DPW for City Agency 14 | DPW | 06/07/2013 12:00:00 AM | Permit Number 770306 | ||||||||||||
8535 | 251265 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 3630x 19th Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 779147 | ||||||||||||||
11338 | 85030 | Significant Tree 6 | Tree(s) :: 17 | 411 Panama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2007 12:00:00 AM | Permit Number 49384 | |||||||||||||
13434 | 260582 | Significant Tree 6 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 | 2101X Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/25/2019 12:00:00 AM | 3 | 5x5 | Permit Number 782628 | |||||||||||
13805 | 119600 | Significant Tree 6 | Cupressocyparis leylandii :: Leyland Cypress 185 | 4357x Mission St | 2 | Front Yard : Yard | Tree | Private 2 | Permit Number 774415 | ||||||||||||||
14241 | 251264 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 3630x 19th Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 779147 | ||||||||||||||
14456 | 103661 | Significant Tree 6 | Tree(s) :: 17 | 350X Hickory St | 5 | Front Yard : Yard | Tree | DPW for City Agency 14 | DPW | 06/07/2013 12:00:00 AM | Permit Number 770306 | ||||||||||||
15093 | 119607 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 299x Avalon Ave | 3 | Front Yard : Yard | Tree | Private 2 | |||||||||||||||
15289 | 119601 | Significant Tree 6 | Cupressocyparis leylandii :: Leyland Cypress 185 | 4357x Mission St | 3 | Front Yard : Yard | Tree | Private 2 | Permit Number 774415 | ||||||||||||||
15795 | 251263 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 3630x 19th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 779147 | ||||||||||||||
16207 | 254459 | Significant Tree 6 | Tree(s) :: 17 | 1055X Duncan St | 4 | Side Yard : Yard | Tree | Private 2 | 02/15/2018 12:00:00 AM | 3 | Permit Number 780800 | ||||||||||||
18988 | 103657 | Significant Tree 6 | Tree(s) :: 17 | 350X Hickory St | 1 | Front Yard : Yard | Tree | DPW for City Agency 14 | DPW | 06/07/2013 12:00:00 AM | Permit Number 770306 | ||||||||||||
19367 | 254458 | Significant Tree 6 | Tree(s) :: 17 | 1055X Duncan St | 3 | Side Yard : Yard | Tree | Private 2 | 02/15/2018 12:00:00 AM | 3 | Permit Number 780800 | ||||||||||||
19573 | 254456 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 1055X Duncan St | 1 | Side Yard : Yard | Tree | Private 2 | |||||||||||||||
127144 | 258338 | Significant Tree 6 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 209 Spear St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | |||||||||||||||
194363 | 265042 | Significant Tree 6 | Tree(s) :: 17 | 1000X Mandalay Ln | 2 | Unaccepted Street : Yard | Tree | Private 2 | 12/17/2020 12:00:00 AM | 3 | 10x010 | Permit Number 787936 | |||||||||||
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 | ||||
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 | ||
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 | |||
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 | ||
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 | ||||
2352 | 101748 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 700X Panorama Dr | 1 | Back Yard : Yard | Tree | Private 2 | 5997177.2 | 2102739.1 | 37.7535587877907 | -122.452684092588 | (37.7535587877907, -122.452684092588) | 1 | 5 | 4 | 63 | 38 | |||||
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 | ||
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 | ||||
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 | |
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 | ||
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 | ||||
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 | ||||
6519 | 251515 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 99x Mountview Ct | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 5997620 | 2100449 | 37.7472961010623 | -122.450987675073 | (37.7472961010623, -122.450987675073) | 1 | 5 | 4 | 63 | 38 | ||||
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 | |||
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 | ||||||
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 | ||||
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 | ||||
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 | ||||
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 | |||||
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 | |||
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 | ||||
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 | ||||
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 | ||
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 | ||||
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 | ||||
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 | ||
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 | ||||
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 | ||||
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 | ||||
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 | |
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 | ||||
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 | ||||
17188 | 260389 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 56 | 101 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10x6 | 5993303.46118 | 2096918.61416 | 37.7373544866644 | -122.465657379584 | (37.7373544866644, -122.465657379584) | 1 | 8 | 4 | 59 | 40 | ||||
17429 | 103965 | Significant Tree 6 | Tree(s) :: 17 | 141 Marview Way | 1 | Front Yard : Yard | Tree | Private 2 | 07/11/2013 12:00:00 AM | Permit Number 770303 | 5998318.6 | 2103174 | 37.7548182509721 | -122.448768222318 | (37.7548182509721, -122.448768222318) | 1 | 5 | 4 | 63 | 38 | |||
17949 | 100194 | Significant Tree 6 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 | 361 Dellbrook Ave | 2 | Front Yard : Yard | Tree | Private 2 | 5997322.2 | 2102403.9 | 37.7526467193673 | -122.45215846969 | (37.7526467193673, -122.45215846969) | 1 | 5 | 4 | 63 | 38 | |||||
18983 | 262256 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4210 Ocean Ave | 9 | 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 | |||
19112 | 261751 | Significant Tree 6 | Podocarpus gracilor :: Fern Pine 51 | 127 Edgehill Way | 1 | 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 | |||
19246 | 253252 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 99X Lopez Ave | 3 | 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 | |||
19388 | 114226 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 150 | 99x FONT BLVD | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | 5990948 | 2088640 | 37.7144873339183 | -122.473197635313 | (37.7144873339183, -122.473197635313) | 1 | 8 | 4 | 64 | 14 | ||||
19616 | 262407 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 300 Font Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6x5 | 5990018 | 2089729 | 37.7174235665943 | -122.476491559856 | (37.7174235665943, -122.476491559856) | 1 | 8 | 4 | 64 | 14 | ||||
19844 | 254259 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 45X Everglade Dr | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5986312 | 2095495 | 37.7330398702545 | -122.489725113139 | (37.7330398702545, -122.489725113139) | 1 | 8 | 4 | 64 | 35 | ||||
20043 | 116577 | Significant Tree 6 | Shrub :: Shrub 66 | 3000x 19TH AVE | 1 | Sidewalk: Property side : Cutout | Tree | MTA 3 | DPW | 30 | 3x3 | 5990602 | 2095184 | 37.7324354869182 | -122.47487091251 | (37.7324354869182, -122.47487091251) | 1 | 8 | 4 | 64 | 40 | ||
20150 | 256573 | Significant Tree 6 | Quercus agrifolia :: Coast Live Oak 172 | 145 Castenada Ave | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 5994569 | 2100949 | 37.74849383418 | -122.461573977381 | (37.74849383418, -122.461573977381) | 1 | 8 | 4 | 29491 | 40 | ||||
20972 | 254094 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 320 Magellan Ave | 1 | Front Yard : Yard | Tree | Private 2 | 10x10 | Permit Number 781012 | 5994209 | 2099943 | 37.7457108840866 | -122.462745872627 | (37.7457108840866, -122.462745872627) | 1 | 8 | 4 | 29491 | 40 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );