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

View and edit SQL

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)
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
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
34293 111094 Significant Tree 6 Pinus radiata :: Monterey Pine 15 150x FONT BLVD   Sidewalk: Curb side : Cutout Tree Private 2   06/04/2015 12:00:00 AM 30 3x3 Permit Number 775594 5990976 2089133 37.7158426125161 -122.473136789074 (37.7158426125161, -122.473136789074) 1 8 4 64 14
39757 104892 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 201 Gonzalez Dr   Front Yard : Yard Tree Private 2           5990435 2090585 37.7197981072685 -122.475112652722 (37.7197981072685, -122.475112652722) 1 8 4 64 40
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
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
50522 93931 Significant Tree 6 Pinus Spp :: Pine Spp 100     Front Yard : Yard Tree Private 2   04/28/2010 12:00:00 AM     Permit Number 53387 5990375.96797 2090932.55284 37.7207489795508 -122.475342064841 (37.7207489795508, -122.475342064841) 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
81747 107245 Significant Tree 6 Tree(s) :: 17 140 CEDRO AVE   Front Yard : Yard Tree Private 2           5991993.7 2093259.3 37.7272312918526 -122.469919436342 (37.7272312918526, -122.469919436342) 9 8 4 59 40
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
101112 110321 Significant Tree 6 Ilex opaca :: American Holly 473 1x SAN PABLO AVE   Sidewalk: Curb side : Cutout Tree Private 2   04/06/2015 12:00:00 AM 3 3x3 Permit Number 774750 5994773 2097898 37.740128291439 -122.460647489756 (37.740128291439, -122.460647489756) 9 8 4 59 40
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
105498 93932 Significant Tree 6 Pinus Spp :: Pine Spp 100     Front Yard : Yard Tree Private 2   04/28/2010 12:00:00 AM     Permit Number 53387 5990375.96797 2090932.55284 37.7207489795508 -122.475342064841 (37.7207489795508, -122.475342064841) 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
125248 106038 Significant Tree 6 Washingtonia robusta :: Mexican Fan Palm 72 230 Lakeview Ave   Front Yard : Yard Tree Private 2         Permit Number 772456 5997013.1 2089546.6 37.7173259605404 -122.452299707743 (37.7173259605404, -122.452299707743) 9 8 6 28861 24
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
183573 104808 Significant Tree 6 Ilex aquifolium :: European Holly 390 1665 08th Ave   Front Yard : Yard Tree Private 2     40     5993673.5 2104163.7 37.7572689897716 -122.464904006701 (37.7572689897716, -122.464904006701) 1 8 4 56 12
183605 104761 Significant Tree 6 Ilex aquifolium :: European Holly 390 1665 18TH AVE   Front Yard : Yard Tree Private 2     50 9x9   5990543.2 2104073 37.756838968238 -122.475723071248 (37.756838968238, -122.475723071248) 1 8 4 56 12
186272 104762 Significant Tree 6 Ilex aquifolium :: European Holly 390 1665 18TH AVE   Front Yard : Yard Tree Private 2     50 9x9   5990543.2 2104073 37.756838968238 -122.475723071248 (37.756838968238, -122.475723071248) 1 8 4 56 12
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
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
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
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
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
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
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
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
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
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
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
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
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
9908 215094 Significant Tree 6 Podocarpus gracilor :: Fern Pine 51 218 Sadowa St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/13/2017 12:00:00 AM 3 Width 5ft Permit Number 779008 5994821.63014 2087784.20309 37.7123610457095 -122.459746958272 (37.7123610457095, -122.459746958272) 9 8 6 28861 24
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
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
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
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
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
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
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
15657 259657 Significant Tree 6 Tree(s) :: 17 132 Sagamore St 1 Front Yard : Yard Tree Private 2       3x3   5995545 2087474 37.7115508726991 -122.457224363425 (37.7115508726991, -122.457224363425) 9 8 6 28861 24
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
18957 259263 Significant Tree 6 Pinus radiata :: Monterey Pine 15 3580X 19th Ave 1 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
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
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
20037 100423 Significant Tree 6 Leptospermum laevigatum :: Australian Tea Tree 47 155 Winston Dr 1 Front Yard : Yard Tree Private 2           5990788 2093142.6 37.7268410933597 -122.474078979965 (37.7268410933597, -122.474078979965) 9 8 4 64 40
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
21303 115100 Significant Tree 6 Tree(s) :: 17 710 PACHECO ST 1 Front Yard : Cutout Tree Private 2   02/04/2016 12:00:00 AM 3 3x3 Permit Number 777305 5992727 2102215 37.7518637464828 -122.468035600741 (37.7518637464828, -122.468035600741) 1 8 4 29491 12
22895 256572 Significant Tree 6 Ilex aquifolium :: European Holly 390 175 Castenada Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5994536 2100823 37.748145970457 -122.461678955671 (37.748145970457, -122.461678955671) 1 8 4 29491 40
23985 114387 Significant Tree 6 Prunus cerasifera :: Cherry Plum 7 417x ARBALLO DR 1 Sidewalk: Curb side : Yard Tree Private 2     7     5988152 2090574 37.7196353223366 -122.483003277928 (37.7196353223366, -122.483003277928) 1 8 4 64 14
24927 107413 Significant Tree 6 Pseudotsuga menziesii :: Douglas Fir 285 276 Yerba Buena Ave 1 Front Yard : Yard Tree Private 2     28     5995080.66446 2095640.15746 37.7339465073544 -122.459420244296 (37.7339465073544, -122.459420244296) 9 8 4 59 40
26401 114389 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 345x ARBALLO DR 1 Front Yard : Yard Tree Private 2     8     5988176 2090635 37.7198042094326 -122.48292478788 (37.7198042094326, -122.48292478788) 1 8 4 64 14
28198 106364 Significant Tree 6 Eucalyptus sideroxylon :: Red Ironbark 127 155 BORICA ST 1 Front Yard : Yard Tree Private 2           5992696 2092292.5 37.7246172684066 -122.467421338179 (37.7246172684066, -122.467421338179) 9 8 4 59 40
30556 104909 Significant Tree 6 Pinus radiata :: Monterey Pine 15 533 Gonzalez Dr 1 Front Yard : Yard Tree Private 2           5990435 2090585 37.7197981072685 -122.475112652722 (37.7197981072685, -122.475112652722) 1 8 4 64 40
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
34088 256489 Significant Tree 6 Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 2198X Monterey Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2       5x10   5991651 2095488 37.7333309287491 -122.471266448142 (37.7333309287491, -122.471266448142) 9 8 4 59 40
34238 1283 Significant Tree 6 Ginkgo biloba :: Maidenhair Tree 22 3995X Alemany Blvd 1 Sidewalk: Property side : Cutout Tree Private 2     10 10x10   5992081.50866 2087171.04221 37.7105194967412 -122.469172961285 (37.7105194967412, -122.469172961285) 9 8 4 64 24
35440 97955 Significant Tree 6 Liquidambar styraciflua 'Slender Silhoutte' :: Upright Liquidambar 438 2 Mendosa Ave 1 Front Yard : Yard Tree Private 2   12/05/2011 12:00:00 AM     Permit Number 768165 5993624.4 2101138.5 37.7489597362933 -122.464854121346 (37.7489597362933, -122.464854121346) 1 8 4 29491 40
36915 117645 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 2901 21ST AVE 1 Back Yard : Yard Tree Private 2       3x3   5989904 2095901 37.734363711699 -122.477336418651 (37.734363711699, -122.477336418651) 1 8 4 64 35
37232 256765 Significant Tree 6 Tree(s) :: 17 355 Serrano Dr 1 Sidewalk: Property side : Yard Tree Private 2   01/15/2019 12:00:00 AM 3 3x3 Permit Number 782555 5988732 2090042 37.7182083166364 -122.480959519123 (37.7182083166364, -122.480959519123) 1 8 4 64 14
38129 114239 Significant Tree 6 Acacia longifolia :: Golden Wattle 150 1300x JUNIPERO SERRA BLVD 1 Sidewalk: Curb side : Yard Tree Private 2     28     5991168 2088425 37.713909732222 -122.472421570074 (37.713909732222, -122.472421570074) 1 8 4 64 14
40036 104493 Significant Tree 6 Acer circinatum :: Vine Maple 452 171 SAN MARCOS AVE 1 Front Yard : Yard Tree Private 2         Permit Number 770388 5993514 2100282 37.7466016393389 -122.465173679454 (37.7466016393389, -122.465173679454) 1 8 4 29491 40
40307 86910 Significant Tree 6 Ilex spp :: Holly Species 81 1 Urbano Dr 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 49875 5993901 2092133 37.7242488135215 -122.463244271267 (37.7242488135215, -122.463244271267) 9 8 4 59 40
41877 114072 Significant Tree 6 Magnolia grandiflora :: Southern Magnolia 19 454 ARBALLO DR 1 Sidewalk: Curb side : Yard Tree Private 2     4     5987903 2090420 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784) 1 8 4 64 14
42536 97945 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 2 Mendosa Ave 1 Front Yard : Yard Tree Private 2         Permit Number 768165 5993624.4 2101138.5 37.7489597362933 -122.464854121346 (37.7489597362933, -122.464854121346) 1 8 4 29491 40
43088 112378 Significant Tree 6 :: 45 1850 19TH AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   5990394 2102783 37.7532883185876 -122.476144836826 (37.7532883185876, -122.476144836826) 1 8 4 56 12
43131 116576 Significant Tree 6 Eucalyptus Spp :: Eucalyptus 52 2500x OCEAN AVE 1 Sidewalk: Property side : Yard Tree MTA 3 DPW   30 10X10   5991377 2094742 37.7312667472315 -122.472159374256 (37.7312667472315, -122.472159374256) 1 8 4 64 40
43517 88608 Significant Tree 6 Tree(s) :: 17 350 Urbano Dr 1 Front Yard : Cutout Tree Private 2   08/01/2008 12:00:00 AM     Permit Number 51562 5991996 2092560 37.7253113201117 -122.469860593138 (37.7253113201117, -122.469860593138) 9 8 4 59 40
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
46153 209002 Significant Tree 6 Tree(s) :: 17 115 Yerba Buena Ave 1 Sidewalk: Curb side : Yard Tree Private 2   07/17/2018 12:00:00 AM 3 Width 4ft Permit Number 781950 5994125 2096751 37.7369416119865 -122.462804803775 (37.7369416119865, -122.462804803775) 9 8 4 59 40
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
48765 98082 Significant Tree 6 Pinus Spp :: Pine Spp 100 525 Grafton Ave 1 Sidewalk: Property side : Cutout Tree Private 2           5995193.7 2090526.9 37.7199132334677 -122.45865940878 (37.7199132334677, -122.45865940878) 9 8 6 28861 24

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