trees
117 rows where Police Districts = 6 and qLegalStatus_id = 6
This data as json, CSV (advanced)
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
50 | 264964 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 3641 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | 5996989 | 2114619 | 37.7861671437011 | -122.454192924446 | (37.7861671437011, -122.454192924446) | 11 | 6 | 1 | 54 | 31 | ||||
1248 | 260958 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 3790 California St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | Width 3ft | 5996359 | 2114633 | 37.786169437555 | -122.456373557771 | (37.786169437555, -122.456373557771) | 11 | 6 | 1 | 54 | 31 | ||||
1408 | 260469 | Significant Tree 6 | Cupressocyparis leylandii :: Leyland Cypress 185 | 1 Masonic Ave | 4 | Side Yard : Yard | Tree | Private 2 | 5998961 | 2113697 | 37.7837484562249 | -122.447303968308 | (37.7837484562249, -122.447303968308) | 15 | 6 | 1 | 54 | 31 | |||||
1427 | 260648 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 3891 Sacramento St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | Width 7ft | 5996301.11796 | 2114890.85877 | 37.7868741256738 | -122.456592467462 | (37.7868741256738, -122.456592467462) | 11 | 6 | 1 | 54 | 31 | ||||
1875 | 261661 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 741 30th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | FUF | 5986614 | 2110873 | 37.7752812973329 | -122.489811603249 | (37.7752812973329, -122.489811603249) | 11 | 6 | 2 | 55 | 26 | ||||
3184 | 260470 | Significant Tree 6 | Cupressocyparis leylandii :: Leyland Cypress 185 | 1 Masonic Ave | 5 | Side Yard : Yard | Tree | Private 2 | 5998961 | 2113697 | 37.7837484562249 | -122.447303968308 | (37.7837484562249, -122.447303968308) | 15 | 6 | 1 | 54 | 31 | |||||
3188 | 260646 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 3905 Sacramento St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5996106 | 2114850 | 37.7867507340863 | -122.457264569448 | (37.7867507340863, -122.457264569448) | 11 | 6 | 1 | 54 | 31 | ||||
3724 | 260475 | Significant Tree 6 | Acer spp :: Maple 88 | 520 Laurel St | 3 | Side Yard : Cutout | Tree | Private 2 | Width 4ft | 5998188 | 2114710 | 37.7864856873194 | -122.450051281182 | (37.7864856873194, -122.450051281182) | 11 | 6 | 1 | 54 | 31 | ||||
4071 | 260649 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 3891 Sacramento St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | Width 7ft | 5996301.11796 | 2114890.85877 | 37.7868741256738 | -122.456592467462 | (37.7868741256738, -122.456592467462) | 11 | 6 | 1 | 54 | 31 | ||||
5115 | 260959 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 400 Cherry St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | Width 9ft | 5996243 | 2114742 | 37.7864620624436 | -122.456782770891 | (37.7864620624436, -122.456782770891) | 11 | 6 | 1 | 54 | 31 | ||||
6097 | 95161 | Significant Tree 6 | Acer palmatum :: Japanese Maple 216 | 2721 Pacific Ave | Front Yard : Yard | Tree | Private 2 | Permit Number 54078 | 6001026.7 | 2116843.3 | 37.7925052022591 | -122.440383162252 | (37.7925052022591, -122.440383162252) | 13 | 6 | 1 | 29490 | 27 | |||||
6867 | 260482 | Significant Tree 6 | Prunus cerasifera :: Cherry Plum 7 | 3333 California St | 4 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3X3 | 5998571 | 2114839 | 37.7868617958727 | -122.448735497123 | (37.7868617958727, -122.448735497123) | 15 | 6 | 1 | 54 | 31 | ||||
6928 | 260474 | Significant Tree 6 | Acer spp :: Maple 88 | 520 Laurel St | 2 | Side Yard : Cutout | Tree | Private 2 | Width 4ft | 5998188 | 2114710 | 37.7864856873194 | -122.450051281182 | (37.7864856873194, -122.450051281182) | 11 | 6 | 1 | 54 | 31 | ||||
7030 | 260467 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 1 Masonic Ave | 2 | Side Yard : Yard | Tree | Private 2 | 5998961 | 2113697 | 37.7837484562249 | -122.447303968308 | (37.7837484562249, -122.447303968308) | 15 | 6 | 1 | 54 | 31 | |||||
7835 | 258799 | Significant Tree 6 | Taxus baccata :: Irish Yew 86 | 566 29th Ave | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 5986943 | 2112080 | 37.7786145821325 | -122.488762272653 | (37.7786145821325, -122.488762272653) | 11 | 6 | 2 | 55 | 26 | ||||
8456 | 99698 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 127 | 1750 Divisadero St | 1 | Front Yard : Cutout | Tree | Private 2 | 6001124 | 2114376 | 37.7857361748448 | -122.439869519979 | (37.7857361748448, -122.439869519979) | 15 | 6 | 1 | 29490 | 27 | |||||
10213 | 260647 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 3905 Sacramento St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5996106 | 2114850 | 37.7867507340863 | -122.457264569448 | (37.7867507340863, -122.457264569448) | 11 | 6 | 1 | 54 | 31 | ||||
10395 | 260478 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 3333 California St | 8 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3X3 | 5998571 | 2114839 | 37.7868617958727 | -122.448735497123 | (37.7868617958727, -122.448735497123) | 15 | 6 | 1 | 54 | 31 | ||||
11407 | 260477 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 3333 California St | 7 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3X3 | 5998571 | 2114839 | 37.7868617958727 | -122.448735497123 | (37.7868617958727, -122.448735497123) | 15 | 6 | 1 | 54 | 31 | ||||
11487 | 260838 | Significant Tree 6 | Ficus nitida :: Laurel Fig 53 | 399 Laurel St | 1 | Side Yard : Cutout | Tree | Private 2 | 3x3 | 5998076 | 2115238 | 37.7879290262693 | -122.45047684944 | (37.7879290262693, -122.45047684944) | 11 | 6 | 1 | 54 | 31 | ||||
11600 | 260651 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 3751 Sacramento St | 2 | Front Yard : Cutout | Tree | Private 2 | Width 3ft | 5996933 | 2115011 | 37.7872402598449 | -122.454414995547 | (37.7872402598449, -122.454414995547) | 11 | 6 | 1 | 54 | 31 | ||||
12411 | 260714 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 2290 Lyon St | 1 | Back Yard : Cutout | Tree | Private 2 | 3x3 | Permit Number 784756 | 5999390 | 2116615 | 37.7917850243096 | -122.446029746387 | (37.7917850243096, -122.446029746387) | 13 | 6 | 1 | 29490 | 27 | |||
12431 | 262225 | Significant Tree 6 | Cupressus spp :: Cypress species 337 | 2450 Golden Gate Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | Width 7ft | 5997659.54255 | 2111324.05825 | 37.7771585265736 | -122.451635273045 | (37.7771585265736, -122.451635273045) | 15 | 6 | 2 | 54 | 16 | ||||
12511 | 260840 | Significant Tree 6 | Ficus nitida :: Laurel Fig 53 | 399 Laurel St | 3 | Side Yard : Cutout | Tree | Private 2 | 3x3 | 5998076 | 2115238 | 37.7879290262693 | -122.45047684944 | (37.7879290262693, -122.45047684944) | 11 | 6 | 1 | 54 | 31 | ||||
12545 | 260484 | Significant Tree 6 | Prunus cerasifera :: Cherry Plum 7 | 3333 California St | 6 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3X3 | 5998571 | 2114839 | 37.7868617958727 | -122.448735497123 | (37.7868617958727, -122.448735497123) | 15 | 6 | 1 | 54 | 31 | ||||
13058 | 260903 | Significant Tree 6 | Taxus baccata :: Irish Yew 86 | 51 Shore View Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | Width 4ft | 5984536 | 2112849 | 37.7805852728313 | -122.497145662996 | (37.7805852728313, -122.497145662996) | 11 | 6 | 2 | 55 | 26 | ||||
14136 | 112391 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 52 | 2201X LYON ST | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x12 | 5999307 | 2116423 | 37.7912531030346 | -122.446303107227 | (37.7912531030346, -122.446303107227) | 13 | 6 | 1 | 29490 | 31 | ||||
14823 | 260479 | Significant Tree 6 | Prunus cerasifera :: Cherry Plum 7 | 3333 California St | 1 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3X3 | 5998571 | 2114839 | 37.7868617958727 | -122.448735497123 | (37.7868617958727, -122.448735497123) | 15 | 6 | 1 | 54 | 31 | ||||
14900 | 260476 | Significant Tree 6 | Acer spp :: Maple 88 | 520 Laurel St | 4 | Side Yard : Cutout | Tree | Private 2 | Width 4ft | 5998188 | 2114710 | 37.7864856873194 | -122.450051281182 | (37.7864856873194, -122.450051281182) | 11 | 6 | 1 | 54 | 31 | ||||
15148 | 260466 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 1 Masonic Ave | 1 | Side Yard : Yard | Tree | Private 2 | 5998961 | 2113697 | 37.7837484562249 | -122.447303968308 | (37.7837484562249, -122.447303968308) | 15 | 6 | 1 | 54 | 31 | |||||
15393 | 260480 | Significant Tree 6 | Prunus cerasifera :: Cherry Plum 7 | 3333 California St | 2 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3X3 | 5998571 | 2114839 | 37.7868617958727 | -122.448735497123 | (37.7868617958727, -122.448735497123) | 15 | 6 | 1 | 54 | 31 | ||||
16021 | 260481 | Significant Tree 6 | Prunus cerasifera :: Cherry Plum 7 | 3333 California St | 3 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3X3 | 5998571 | 2114839 | 37.7868617958727 | -122.448735497123 | (37.7868617958727, -122.448735497123) | 15 | 6 | 1 | 54 | 31 | ||||
16043 | 260472 | Significant Tree 6 | Cupressocyparis leylandii :: Leyland Cypress 185 | 1 Masonic Ave | 7 | Side Yard : Yard | Tree | Private 2 | 5998961 | 2113697 | 37.7837484562249 | -122.447303968308 | (37.7837484562249, -122.447303968308) | 15 | 6 | 1 | 54 | 31 | |||||
16147 | 260471 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 Masonic Ave | 6 | Side Yard : Yard | Tree | Private 2 | 5998961 | 2113697 | 37.7837484562249 | -122.447303968308 | (37.7837484562249, -122.447303968308) | 15 | 6 | 1 | 54 | 31 | |||||
16260 | 260650 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 3751 Sacramento St | 1 | Front Yard : Cutout | Tree | Private 2 | Width 3ft | 5996933 | 2115011 | 37.7872402598449 | -122.454414995547 | (37.7872402598449, -122.454414995547) | 11 | 6 | 1 | 54 | 31 | ||||
17264 | 260645 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 127 | 3905 Sacramento St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5996106 | 2114850 | 37.7867507340863 | -122.457264569448 | (37.7867507340863, -122.457264569448) | 11 | 6 | 1 | 54 | 31 | ||||
17369 | 260483 | Significant Tree 6 | Prunus cerasifera :: Cherry Plum 7 | 3333 California St | 5 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3X3 | 5998571 | 2114839 | 37.7868617958727 | -122.448735497123 | (37.7868617958727, -122.448735497123) | 15 | 6 | 1 | 54 | 31 | ||||
17671 | 260957 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 3790 California St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | Width 3ft | 5996359 | 2114633 | 37.786169437555 | -122.456373557771 | (37.786169437555, -122.456373557771) | 11 | 6 | 1 | 54 | 31 | ||||
17941 | 258800 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 566 29th Ave | 2 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 5986943 | 2112080 | 37.7786145821325 | -122.488762272653 | (37.7786145821325, -122.488762272653) | 11 | 6 | 2 | 55 | 26 | ||||
18482 | 260468 | Significant Tree 6 | Cupressocyparis leylandii :: Leyland Cypress 185 | 1 Masonic Ave | 3 | Side Yard : Yard | Tree | Private 2 | 5998961 | 2113697 | 37.7837484562249 | -122.447303968308 | (37.7837484562249, -122.447303968308) | 15 | 6 | 1 | 54 | 31 | |||||
18519 | 260473 | Significant Tree 6 | Quercus agrifolia :: Coast Live Oak 172 | 520 Laurel St | 1 | Side Yard : Cutout | Tree | Private 2 | Width 4ft | 5998188 | 2114710 | 37.7864856873194 | -122.450051281182 | (37.7864856873194, -122.450051281182) | 11 | 6 | 1 | 54 | 31 | ||||
18680 | 262301 | Significant Tree 6 | Ficus microcarpa :: Chinese Banyan 97 | 2117 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000330 | 2116040 | 37.7902598573453 | -122.44273605224 | (37.7902598573453, -122.44273605224) | 13 | 6 | 1 | 29490 | 27 | ||||
19027 | 260904 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4228 Geary Blvd | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | Width 4ft | 5993841 | 2112866 | 37.7811728620679 | -122.464956727678 | (37.7811728620679, -122.464956727678) | 11 | 6 | 2 | 54 | 11 | ||||
24819 | 122688 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 2590 Pacific Ave | 1 | Front Yard : Yard | Tree | Private 2 | 16 | 3x8 | 6001760 | 2117029 | 37.7930568116395 | -122.43785923272 | (37.7930568116395, -122.43785923272) | 13 | 6 | 1 | 29490 | 27 | |||
26906 | 110476 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3700 Washington St | 1 | Back Yard : Yard | Tree | Private 2 | 04/16/2015 12:00:00 AM | 3 | 10x10 | Permit Number 774729 | 5997015.1 | 2115715 | 37.7891779638687 | -122.454181816252 | (37.7891779638687, -122.454181816252) | 11 | 6 | 1 | 54 | 31 | |
27860 | 107983 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 2405x Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6001231.00707 | 2116743.47753 | 37.7922427464694 | -122.439669095376 | (37.7922427464694, -122.439669095376) | 13 | 6 | 1 | 29490 | 27 | |||
28531 | 173636 | Significant Tree 6 | Tree(s) :: 17 | 2590 Pacific Ave | 2 | Front Yard : Yard | Tree | Private 2 | 05/11/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779167 | 6001760 | 2117029 | 37.7930568116395 | -122.43785923272 | (37.7930568116395, -122.43785923272) | 13 | 6 | 1 | 29490 | 27 | |
32335 | 173635 | Significant Tree 6 | Tree(s) :: 17 | 2590 Pacific Ave | 1 | Front Yard : Cutout | Tree | Private 2 | 05/11/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779167 | 6001760 | 2117029 | 37.7930568116395 | -122.43785923272 | (37.7930568116395, -122.43785923272) | 13 | 6 | 1 | 29490 | 27 | |
32630 | 85060 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 7070 California St | 1 | Front Yard : Cutout | Tree | Private 2 | 07/03/2007 12:00:00 AM | Permit Number 49405 | 5985878 | 2113896 | 37.7835385880022 | -122.492580242312 | (37.7835385880022, -122.492580242312) | 11 | 6 | 2 | 55 | 26 | |||
32725 | 106972 | Significant Tree 6 | Tree(s) :: 17 | 464 46TH AVE | 3 | Front Yard : Yard | Tree | Private 2 | 08/07/2014 12:00:00 AM | Permit Number 773827 | 5981646.2 | 2112608 | 37.7797537818913 | -122.507124798545 | (37.7797537818913, -122.507124798545) | 11 | 6 | 2 | 55 | 26 | |||
41301 | 108215 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 865 EL CAMINO DEL MAR | 1 | Front Yard : Yard | Tree | Private 2 | 5985761 | 2114995 | 37.7865492821054 | -122.493065995445 | (37.7865492821054, -122.493065995445) | 11 | 6 | 1 | 55 | 33 | |||||
44979 | 39247 | Significant Tree 6 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 | 3524 Jackson St | 1 | Front Yard : Cutout | Tree | Private 2 | 08/22/2002 12:00:00 AM | 5x10 | Permit Number 772836 | 5997387.02929021 | 2116081.37513577 | 37.7902052526208 | -122.452921449726 | (37.7902052526208, -122.452921449726) | 11 | 6 | 1 | 54 | 31 | ||
45774 | 114249 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 52 | 499x 24TH AVE | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5988415 | 2112957 | 37.7811083698872 | -122.483734439284 | (37.7811083698872, -122.483734439284) | 11 | 6 | 2 | 55 | 26 | ||||
47695 | 104013 | Significant Tree 6 | Fremontodendron spp :: Flannel Bush Tree 107 | 3978 Sacramento St | 1 | Front Yard : Yard | Tree | Private 2 | 07/24/2013 12:00:00 AM | Permit Number 770312 | 5995753.1 | 2114886.6 | 37.7868309532778 | -122.458488162336 | (37.7868309532778, -122.458488162336) | 11 | 6 | 1 | 54 | 31 | |||
48200 | 108097 | Significant Tree 6 | Tree(s) :: 17 | 3370 Washington St | 2 | Front Yard : Cutout | Tree | Private 2 | 5998663.3699 | 2115944.31994 | 37.789901994506 | -122.448495552231 | (37.789901994506, -122.448495552231) | 13 | 6 | 1 | 54 | 31 | |||||
49235 | 110583 | Significant Tree 6 | Phoenix canariensis :: Canary Island Date Palm 160 | 46 COOK ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 36 | 5997534 | 2113434 | 37.782944683725 | -122.452221842699 | (37.782944683725, -122.452221842699) | 15 | 6 | 1 | 54 | 31 | ||||
55810 | 116521 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 70 BEAUMONT AVE | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 3x3 | 5996728 | 2112568 | 37.7805206716372 | -122.454947659336 | (37.7805206716372, -122.454947659336) | 11 | 6 | 2 | 54 | 16 | |||
58472 | 104728 | Significant Tree 6 | Tree(s) :: 17 | 3212 Jackson St | 1 | Front Yard : Cutout | Tree | Private 2 | 11/06/2013 12:00:00 AM | Permit Number 770525 | 5998810.5 | 2116292.9 | 37.7908675143955 | -122.448011605492 | (37.7908675143955, -122.448011605492) | 13 | 6 | 1 | 54 | 31 | |||
59834 | 253717 | Significant Tree 6 | Pinus Spp :: Pine Spp 100 | 4101 Balboa St | 1 | Back Yard : Yard | Tree | Private 2 | 01/08/2018 12:00:00 AM | 3 | Permit Number 780863 | 5982822 | 2110967 | 37.7753172554615 | -122.50293574331 | (37.7753172554615, -122.50293574331) | 11 | 6 | 2 | 55 | 26 | ||
59898 | 108211 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 524 45th Ave | 2 | Front Yard : Yard | Tree | Private 2 | Permit Number 773704 | 5981973.19232 | 2112153.30127 | 37.7785245664452 | -122.505959887315 | (37.7785245664452, -122.505959887315) | 11 | 6 | 2 | 55 | 26 | ||||
59956 | 255159 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 4150 Clement St | 1 | Front Yard : Yard | Tree | Private 2 | 5983115 | 2113126 | 37.7812624555251 | -122.502082001527 | (37.7812624555251, -122.502082001527) | 11 | 6 | 2 | 55 | 15 | |||||
61291 | 113491 | Significant Tree 6 | Dodonaea viscosa :: Hop Bush 43 | 366x 07TH AVE | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 12/07/2015 12:00:00 AM | 6 | 3x3 | Permit Number 776681 | 5993712 | 2113143 | 37.7819259902039 | -122.465423128165 | (37.7819259902039, -122.465423128165) | 11 | 6 | 2 | 54 | 11 | |
61403 | 111037 | Significant Tree 6 | Magnolia spp :: Magnolia 224 | 3991-3997 Washington St | 2 | Front Yard : Yard | Tree | Private 2 | 5995610.3 | 2115419.4 | 37.7882856707006 | -122.459020806409 | (37.7882856707006, -122.459020806409) | 11 | 6 | 1 | 54 | 31 | |||||
68924 | 113937 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 800 EL CAMINO DEL MAR | 1 | Front Yard : Yard | Tree | Private 2 | 35 | 5985966 | 2115003 | 37.7865832348262 | -122.492357345241 | (37.7865832348262, -122.492357345241) | 11 | 6 | 1 | 55 | 33 | ||||
72773 | 112366 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2224 Baker St | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | Permit Number 775823 | 5999858.5 | 2116547.8 | 37.791627252722 | -122.444403911295 | (37.791627252722, -122.444403911295) | 13 | 6 | 1 | 29490 | 27 | |||
76263 | 85093 | Significant Tree 6 | Tree(s) :: 17 | 100 32nd Ave | 2 | Front Yard : Yard | Tree | Private 2 | 12/18/2009 12:00:00 AM | Permit Number 53112 | 5985781.7 | 2114962.8 | 37.7864620808454 | -122.49299200677 | (37.7864620808454, -122.49299200677) | 11 | 6 | 1 | 55 | 33 | |||
78031 | 91107 | Significant Tree 6 | Tree(s) :: 17 | 2650 Turk Blvd | 2 | Front Yard : Yard | Tree | Private 2 | 01/12/2009 12:00:00 AM | On campus | Permit Number 51996 | 5995208 | 2110277 | 37.7741428808777 | -122.460040004978 | (37.7741428808777, -122.460040004978) | 11 | 6 | 2 | 54 | 11 | ||
81784 | 93874 | Significant Tree 6 | Pistacia chinensis :: Chinese Pistache 32 | 2614 Sacramento St | Front Yard : | Tree | Private 2 | 04/14/2010 12:00:00 AM | Permit Number 53370 | 6002291 | 2115777 | 37.7896493226209 | -122.435932319436 | (37.7896493226209, -122.435932319436) | 13 | 6 | 1 | 29490 | 27 | ||||
82918 | 107986 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 2401x SCOTT ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001257 | 2116757 | 37.7922813550603 | -122.439580129378 | (37.7922813550603, -122.439580129378) | 13 | 6 | 1 | 29490 | 27 | ||||
85997 | 111996 | Significant Tree 6 | Tree(s) :: 17 | 501 Point Lobos Ave | Front Yard : Yard | Tree | Private 2 | 07/08/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775626 | 5981249.6 | 2112592.5 | 37.7796878572283 | -122.508495636007 | (37.7796878572283, -122.508495636007) | 11 | 6 | 2 | 55 | 26 | ||
86650 | 102302 | Significant Tree 6 | Tree(s) :: 17 | 740X 31st Ave | 1 | Front Yard : Yard | Tree | Private 2 | 01/14/2013 12:00:00 AM | Permit Number 769784 | 5986476.3 | 2110809.8 | 37.7750997269751 | -122.490283282468 | (37.7750997269751, -122.490283282468) | 11 | 6 | 2 | 55 | 26 | |||
87883 | 120156 | Significant Tree 6 | Ficus nitida :: Laurel Fig 53 | 758 10th Ave | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 10 | 5992930 | 2110298 | 37.7740692588728 | -122.467921468059 | (37.7740692588728, -122.467921468059) | 11 | 6 | 2 | 54 | 11 | ||||
90328 | 96835 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 6001 Geary Blvd | 1 | Front Yard : Cutout | Tree | Private 2 | 5988352.4 | 2112527.1 | 37.779924341439 | -122.483919468894 | (37.779924341439, -122.483919468894) | 11 | 6 | 2 | 55 | 26 | |||||
90493 | 108096 | Significant Tree 6 | Ficus rubiginosa :: Port Jackson Fig 339 | 3370 Washington St | 1 | Front Yard : Cutout | Tree | Private 2 | 17 | Permit Number 773610 | 5998674.83986 | 2115933.37372 | 37.7898725948813 | -122.448455078738 | (37.7898725948813, -122.448455078738) | 13 | 6 | 1 | 54 | 31 | |||
94461 | 98038 | Significant Tree 6 | Tree(s) :: 17 | 147 Lake St | 1 | Front Yard : Yard | Tree | Private 2 | 12/09/2011 12:00:00 AM | Permit Number 768423 | 5994977.2 | 2114852.5 | 37.7866927029397 | -122.461170103848 | (37.7866927029397, -122.461170103848) | 11 | 6 | 1 | 54 | 11 | |||
95953 | 95234 | Significant Tree 6 | Tree(s) :: 17 | 7 Almaden Ct | Front Yard : Yard | Tree | Private 2 | 01/25/2011 12:00:00 AM | Permit Number 767129 | 5995849 | 2112535 | 37.7803795989447 | -122.457986127959 | (37.7803795989447, -122.457986127959) | 11 | 6 | 2 | 54 | 16 | ||||
98322 | 107720 | Significant Tree 6 | Tree(s) :: 17 | 2301x Baker St | 3 | Front Yard : Yard | Tree | Private 2 | 10/20/2014 12:00:00 AM | 3 | Permit Number 773397 | 5999765.63181 | 2116886.19958 | 37.7925511097437 | -122.44474956777 | (37.7925511097437, -122.44474956777) | 13 | 6 | 1 | 29490 | 27 | ||
104499 | 107984 | Significant Tree 6 | Podocarpus gracilor :: Fern Pine 51 | 2401x SCOTT ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001096 | 2116670 | 37.7920333111805 | -122.440130949989 | (37.7920333111805, -122.440130949989) | 13 | 6 | 1 | 29490 | 27 | ||||
104764 | 115564 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 84 | 3524 Jackson St | 2 | Front Yard : Cutout | Tree | Private 2 | 5x10 | 5997387.02929021 | 2116081.37513577 | 37.7902052526208 | -122.452921449726 | (37.7902052526208, -122.452921449726) | 11 | 6 | 1 | 54 | 31 | ||||
105054 | 100572 | Significant Tree 6 | Magnolia grandiflora :: Southern Magnolia 19 | 3020 Washington St | 1 | Front Yard : Yard | Tree | Private 2 | 3 | Permit Number 769157 | 6000180.60876 | 2116141.82829 | 37.790530933705 | -122.443260250183 | (37.790530933705, -122.443260250183) | 13 | 6 | 1 | 29490 | 27 | |||
108809 | 187638 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 875 El Camino Del Mar | 2 | Side Yard : Yard | Tree | Private 2 | 10x10 | 5985641 | 2114972 | 37.786479112006 | -122.493479464676 | (37.786479112006, -122.493479464676) | 11 | 6 | 1 | 55 | 15 | ||||
115527 | 122689 | Significant Tree 6 | Aesculus hippocastanum :: White Horsechestnut 190 | 2590 Pacific Ave | 2 | Front Yard : Yard | Tree | Private 2 | 12 | 3x8 | 6001760 | 2117029 | 37.7930568116395 | -122.43785923272 | (37.7930568116395, -122.43785923272) | 13 | 6 | 1 | 29490 | 27 | |||
117508 | 121242 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 701 16th Ave | 1 | Back Yard : Cutout | Tree | Private 2 | 36 | 5990933 | 2110561 | 37.7746758635803 | -122.474848566269 | (37.7746758635803, -122.474848566269) | 11 | 6 | 2 | 54 | 26 | ||||
119552 | 101202 | Significant Tree 6 | Tree(s) :: 17 | 7070 California St | 1 | Front Yard : | Tree | Private 2 | 10/03/2012 12:00:00 AM | Permit Number 769231 | 5985659.5 | 2114437.4 | 37.7850123376907 | -122.493376058427 | (37.7850123376907, -122.493376058427) | 11 | 6 | 1 | 55 | 33 | |||
122238 | 254735 | Significant Tree 6 | Afrocarpus gracilior :: Fern Pine 89 | 363 14th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | Permit Number 781538 | 5991507 | 2112990 | 37.781378479082 | -122.473040175374 | (37.781378479082, -122.473040175374) | 11 | 6 | 2 | 54 | 26 | ||||
124269 | 256872 | Significant Tree 6 | Tree(s) :: 17 | 2401X Golden Gate Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 05/13/2019 12:00:00 AM | 3 | 3x3 | Permit Number 782666 | 5997871 | 2111315 | 37.7771457625148 | -122.450903124986 | (37.7771457625148, -122.450903124986) | 15 | 6 | 2 | 29492 | 16 | |
127638 | 98241 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 3760 Washington St | 1 | Front Yard : Yard | Tree | Private 2 | 01/10/2012 12:00:00 AM | 9 | Permit Number 768462 | 5996814.46778 | 2115674.04938 | 37.7890540175629 | -122.45487301497 | (37.7890540175629, -122.45487301497) | 11 | 6 | 1 | 54 | 31 | ||
127746 | 120952 | Significant Tree 6 | Tree(s) :: 17 | 100X 32nd Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 08/30/2016 12:00:00 AM | 3 | 10x10 | Permit Number 778529 | 5985781 | 2114962 | 37.7864598433405 | -122.492994369609 | (37.7864598433405, -122.492994369609) | 11 | 6 | 1 | 55 | 33 | |
128000 | 104003 | Significant Tree 6 | Acer palmatum 'Sango Kaku' :: Coral Bark Maple 550 | 2109 Steiner St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 07/17/2013 12:00:00 AM | Permit Number 767176 | 6002333.5 | 2115633.4 | 37.7892574480846 | -122.435774995524 | (37.7892574480846, -122.435774995524) | 13 | 6 | 1 | 29490 | 27 | |||
134012 | 117417 | Significant Tree 6 | Magnolia grandiflora :: Southern Magnolia 19 | 2835 Washington St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x10 | Permit Number 778177 | 6001153.1 | 2116153.5 | 37.7906183870332 | -122.439896334555 | (37.7906183870332, -122.439896334555) | 13 | 6 | 1 | 29490 | 27 | |||
135701 | 102604 | Significant Tree 6 | Tree(s) :: 17 | 401 45th Ave | 1 | Front Yard : Yard | Tree | Private 2 | 02/06/2013 12:00:00 AM | Permit Number 769720 | 5981859.7 | 2112893.4 | 37.7805499779863 | -122.506407391963 | (37.7805499779863, -122.506407391963) | 11 | 6 | 2 | 55 | 26 | |||
137101 | 251410 | Significant Tree 6 | Magnolia grandiflora :: Southern Magnolia 19 | 2777 Pine St | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | Permit Number 779015 | 6000658 | 2114782 | 37.7868244087741 | -122.441510888069 | (37.7868244087741, -122.441510888069) | 13 | 6 | 1 | 29490 | 27 | |||
137332 | 112057 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 37 | 762 FUNSTON AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 5991999 | 2110277 | 37.7739577928787 | -122.47114039751 | (37.7739577928787, -122.47114039751) | 11 | 6 | 2 | 54 | 11 | |||
138623 | 91110 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 2650 Turk Blvd | 1 | Front Yard : Yard | Tree | Private 2 | On Campus | 5998086.4 | 2111055.5 | 37.7764455713486 | -122.450139282915 | (37.7764455713486, -122.450139282915) | 15 | 6 | 2 | 29492 | 16 | ||||
144517 | 112363 | Significant Tree 6 | Cedrus atlantica :: Atlas Cedar 233 | 540 10th Ave | 3 | Front Yard : Yard | Tree | Private 2 | 24 | 6x6 | 5992860.82014 | 2111778.58973 | 37.778130563709 | -122.468268503132 | (37.778130563709, -122.468268503132) | 11 | 6 | 2 | 54 | 11 | |||
145768 | 98703 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 7070@ 32nd Ave California St | 4 | Front Yard : | Tree | Private 2 | 03/10/2012 12:00:00 AM | Permit Number 767466 | 5985659.5 | 2114437.4 | 37.7850123376907 | -122.493376058427 | (37.7850123376907, -122.493376058427) | 11 | 6 | 1 | 55 | 33 | |||
146644 | 105349 | Significant Tree 6 | Tree(s) :: 17 | 151X Spruce St | 1 | Front Yard : Yard | Tree | Private 2 | 01/16/2014 12:00:00 AM | Permit Number 771071 | 5997060.93638 | 2115845.70083 | 37.7895394616557 | -122.45403267224 | (37.7895394616557, -122.45403267224) | 11 | 6 | 1 | 54 | 31 | |||
146707 | 103477 | Significant Tree 6 | Tree(s) :: 17 | 875 El Camino Del Mar | 1 | Front Yard : | Tree | Private 2 | 05/08/2013 12:00:00 AM | Permit Number 770113 | 5985641.7 | 2114972.5 | 37.7864805258078 | -122.493477079739 | (37.7864805258078, -122.493477079739) | 11 | 6 | 1 | 55 | 15 | |||
147066 | 121377 | Significant Tree 6 | Prunus ilicifoia :: Holly-leaved Cherry 245 | 2701 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001200 | 2116539 | 37.7916795394978 | -122.439761713662 | (37.7916795394978, -122.439761713662) | 13 | 6 | 1 | 29490 | 27 | ||||
147409 | 95215 | Significant Tree 6 | Acer palmatum :: Japanese Maple 216 | 2203 Divisadero St | Front Yard : Yard | Tree | Private 2 | 6000868 | 2115894 | 37.7898896344174 | -122.440864138631 | (37.7898896344174, -122.440864138631) | 13 | 6 | 1 | 29490 | 27 |
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) );