trees
208 rows where Police Districts = 9 and qLegalStatus_id = 6 sorted by SiteOrder
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7770 | 98170 | Significant Tree 6 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 2324 Sacramento St | Front Yard : Yard | Tree | Private 2 | 12/22/2011 12:00:00 AM | 3 | Permit Number 768454 | 6003670.2 | 2115963.1 | 37.7902385582714 | -122.431173718492 | (37.7902385582714, -122.431173718492) | 13 | 9 | 1 | 29490 | 27 | |||
| 12063 | 95300 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 701 Golden Gate Ave | Front Yard : Yard | Tree | Private 2 | 02/08/2011 12:00:00 AM | 3x3 | Permit Number 767203 | 6006127.5 | 2112421.2 | 37.780652317617 | -122.422419858646 | (37.780652317617, -122.422419858646) | 7 | 9 | 11 | 28852 | 41 | |||
| 62475 | 107113 | Significant Tree 6 | Brahea edulis :: Guadalupe Palm 218 | 2100 MARKET ST | Front Yard : Cutout | Tree | Private 2 | 6004034 | 2107672.1 | 37.7674941340109 | -122.429323526179 | (37.7674941340109, -122.429323526179) | 7 | 9 | 5 | 28862 | 3 | ||||||
| 102859 | 87188 | Significant Tree 6 | Tree(s) :: 17 | 2119 Bush St | Front Yard : Yard | Tree | Private 2 | 01/29/2008 12:00:00 AM | Permit Number 50204 | 6002998 | 2114831 | 37.7870919849741 | -122.433418544226 | (37.7870919849741, -122.433418544226) | 13 | 9 | 11 | 29490 | 27 | ||||
| 116546 | 95242 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 2620 Larkin St | Front Yard : Yard | Tree | Private 2 | 37 | Permit Number 56959 | 6006630 | 2120172 | 37.801962421987 | -122.421232011572 | (37.801962421987, -122.421232011572) | 5 | 9 | 1 | 28858 | 32 | ||||
| 121235 | 86895 | Significant Tree 6 | Tree(s) :: 17 | 321 Haight St | Front Yard : Yard | Tree | Private 2 | 10/26/2007 12:00:00 AM | Permit Number 49844 | 6004599.9 | 2109420.1 | 37.7723257406977 | -122.427490696784 | (37.7723257406977, -122.427490696784) | 7 | 9 | 11 | 28852 | 10 | ||||
| 129276 | 93903 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 72 | 546 Page St | Front Yard : | Tree | Private 2 | 6003947 | 2109752 | 37.7732001072566 | -122.429772814549 | (37.7732001072566, -122.429772814549) | 7 | 9 | 11 | 29492 | 10 | ||||||
| 151632 | 95299 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 701 Golden Gate Ave | Front Yard : Yard | Tree | Private 2 | 02/08/2011 12:00:00 AM | 3x3 | Permit Number 767203 | 6006127.5 | 2112421.2 | 37.780652317617 | -122.422419858646 | (37.780652317617, -122.422419858646) | 7 | 9 | 11 | 28852 | 41 | |||
| 158642 | 94066 | Significant Tree 6 | Palm (unknown Genus) :: Palm Spp 273 | 548 Page St | Front Yard : | Tree | Private 2 | 06/02/2010 12:00:00 AM | Permit Number 53460 | 6003937 | 2109751 | 37.7731967952272 | -122.429807334526 | (37.7731967952272, -122.429807334526) | 7 | 9 | 11 | 29492 | 10 | ||||
| 22 | 262394 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 66 Cleary Ct | 1 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 11/13/2020 12:00:00 AM | 3 | 3x3 | 6004824 | 2113713 | 37.7841256623529 | -122.427021325889 | (37.7841256623529, -122.427021325889) | 13 | 9 | 11 | 28858 | 41 | ||
| 31 | 264951 | Significant Tree 6 | Tree(s) :: 17 | 20X Cleary Ct | 1 | Front Yard : Yard | Tree | Private 2 | 11/13/2020 12:00:00 AM | 3 | 6004818 | 2113712 | 37.7841225773231 | -122.427042012496 | (37.7841225773231, -122.427042012496) | 13 | 9 | 11 | 28858 | 41 | |||
| 64 | 264974 | Significant Tree 6 | Persea americana :: Avocado 34 | 1868 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003954 | 2119422 | 37.7997518904289 | -122.430438688757 | (37.7997518904289, -122.430438688757) | 13 | 9 | 1 | 57 | 17 | ||||
| 69 | 126274 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 1240 Lombard St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | Width 6ft | 6006421.51674 | 2120105.21307 | 37.8017672864012 | -122.421948716173 | (37.8017672864012, -122.421948716173) | 5 | 9 | 1 | 28858 | 32 | |||
| 5414 | 261208 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 109 | 1131 Sutter St | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 6007175 | 2115019 | 37.7878442781586 | -122.418980353142 | (37.7878442781586, -122.418980353142) | 13 | 9 | 10 | 28858 | 21 | ||||
| 10123 | 257894 | Significant Tree 6 | Metrosideros robusta :: Northern Rata Tree 335 | 1776 Vallejo St | 1 | Front Yard : Yard | Tree | Private 2 | 01/27/2020 12:00:00 AM | 3 | 6005064 | 2118169 | 37.7963742870274 | -122.426508408066 | (37.7963742870274, -122.426508408066) | 13 | 9 | 1 | 28858 | 17 | |||
| 10900 | 256098 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1776 Vallejo St | 1 | Front Yard : Cutout | Tree | Private 2 | 6005064.21519 | 2118169.93221 | 37.7963768588038 | -122.426507729874 | (37.7963768588038, -122.426507729874) | 13 | 9 | 1 | 28858 | 17 | |||||
| 12050 | 261306 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 1555 Union St | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 6005549 | 2118864 | 37.7983099861265 | -122.424879674285 | (37.7983099861265, -122.424879674285) | 13 | 9 | 1 | 57 | 17 | ||||
| 12590 | 121368 | Significant Tree 6 | Syagrus romanzoffianum :: Queen Palm 85 | 245 Mallorca Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | Permit Number 778992 | 6001431 | 2120732 | 37.8032055622797 | -122.439263127997 | (37.8032055622797, -122.439263127997) | 13 | 9 | 1 | 57 | 17 | ||
| 13981 | 261996 | Significant Tree 6 | Phoenix spp :: Date palm (species unknown) 255 | 2727 Pierce St | 1 | Front Yard : Yard | Tree | Private 2 | 10/07/2020 12:00:00 AM | 3 | 3x3 | Permit Number 785198 | 6001553 | 2117834 | 37.7952553588401 | -122.438633170174 | (37.7952553588401, -122.438633170174) | 13 | 9 | 1 | 57 | 27 | |
| 14326 | 112045 | Significant Tree 6 | Ulmus parvifolia :: Chinese Elm 31 | 2418 Pacific Ave | 1 | Front Yard : Yard | Tree | Private 2 | 06/26/2020 12:00:00 AM | 3 | 3x3 | Permit Number 785474 | 6002446.95594 | 2117111.03197 | 37.7933210893366 | -122.435488200226 | (37.7933210893366, -122.435488200226) | 13 | 9 | 1 | 29490 | 27 | |
| 15160 | 260680 | Significant Tree 6 | Tree(s) :: 17 | 1450x Laguna St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6004617 | 2113883 | 37.7845807327875 | -122.42774958855 | (37.7845807327875, -122.42774958855) | 13 | 9 | 11 | 28858 | 41 | ||||
| 15591 | 262378 | Significant Tree 6 | Yucca spp :: Yucca 289 | 2172 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002662 | 2118213 | 37.796359019498 | -122.434822974351 | (37.796359019498, -122.434822974351) | 13 | 9 | 1 | 57 | 17 | ||||
| 15911 | 105081 | Significant Tree 6 | :: 45 | 344 Fulton St | 1 | Front Yard : Yard | Tree | Private 2 | 6006101.8 | 2111789.5 | 37.7789163735632 | -122.422463868572 | (37.7789163735632, -122.422463868572) | 7 | 9 | 11 | 28852 | 10 | |||||
| 16717 | 262293 | Significant Tree 6 | Ulmus parvifolia :: Chinese Elm 31 | 2418 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002408 | 2117119 | 37.7933407549318 | -122.435623560602 | (37.7933407549318, -122.435623560602) | 13 | 9 | 1 | 29490 | 27 | ||||
| 17502 | 260902 | Significant Tree 6 | Populus alba :: White Poplar 184 | 1901 Geary Blvd | 1 | Sidewalk: Property side : Cutout | Tree | DPW 1 | Width 0ft | 6002672 | 2113572 | 37.7836165897996 | -122.434456380093 | (37.7836165897996, -122.434456380093) | 13 | 9 | 11 | 29490 | 41 | ||||
| 18899 | 261161 | Significant Tree 6 | Quercus agrifolia :: Coast Live Oak 172 | 2452 Green St | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 6001304 | 2118013 | 37.7957326780501 | -122.439507585878 | (37.7957326780501, -122.439507585878) | 13 | 9 | 1 | 57 | 17 | ||||
| 22976 | 103600 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 50X Hermann St | 1 | Front Yard : Yard | Tree | Private 2 | 6005031.0649 | 2108842.56611 | 37.7707643495235 | -122.425958137982 | (37.7707643495235, -122.425958137982) | 7 | 9 | 5 | 28852 | 10 | |||||
| 25451 | 105226 | Significant Tree 6 | Tree(s) :: 17 | 1150X Golden Gate Ave | 1 | Front Yard : Yard | Tree | Private 2 | 01/02/2014 12:00:00 AM | Permit Number 771276 | 6004329.61165 | 2112216.22051 | 37.7799879097685 | -122.428625001082 | (37.7799879097685, -122.428625001082) | 7 | 9 | 11 | 29490 | 41 | |||
| 39009 | 255287 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 109 | 2758 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999862 | 2117824 | 37.7951315610034 | -122.444483561153 | (37.7951315610034, -122.444483561153) | 13 | 9 | 1 | 57 | 17 | ||||
| 40123 | 256065 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 2800 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/07/2018 12:00:00 AM | 3 | 3x3 | 6002545 | 2117972 | 37.7956906526811 | -122.435210571933 | (37.7956906526811, -122.435210571933) | 13 | 9 | 1 | 57 | 17 | ||
| 41224 | 258232 | Significant Tree 6 | Liquidambar styraciflua :: American Sweet Gum 37 | 200x Gough St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 04/24/2019 12:00:00 AM | 3 | 3x3 | 6006251 | 2110547 | 37.7755131849671 | -122.421859443165 | (37.7755131849671, -122.421859443165) | 7 | 9 | 11 | 28852 | 10 | ||
| 44345 | 253366 | Significant Tree 6 | Ficus carica :: Edible Fig 341 | 20 Laussat St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004582 | 2109434 | 37.7723628942784 | -122.427553605007 | (37.7723628942784, -122.427553605007) | 7 | 9 | 11 | 28852 | 10 | ||||
| 50429 | 99288 | Significant Tree 6 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 845 Marina Blvd | 1 | Front Yard : Yard | Tree | Private 2 | 06/05/2012 12:00:00 AM | 1 | Permit Number 768788 | 5998881.62913 | 2121328.006 | 37.8046966310161 | -122.448128205765 | (37.8046966310161, -122.448128205765) | 13 | 9 | 1 | 57 | 17 | ||
| 56668 | 113769 | Significant Tree 6 | Tree(s) :: 17 | 2550 Broadway | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6001418.65940389 | 2117313.19689891 | 37.7938177263924 | -122.439060665499 | (37.7938177263924, -122.439060665499) | 13 | 9 | 1 | 57 | 27 | |||||
| 60900 | 103616 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 95 | 201X Haight St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6004725 | 2109149 | 37.7715884407354 | -122.427038651796 | (37.7715884407354, -122.427038651796) | 7 | 9 | 11 | 28852 | 10 | |||||
| 72516 | 258223 | Significant Tree 6 | Pinus Spp :: Pine Spp 100 | 53 Starr King Way | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | Width 3ft | Permit Number 782966 | 6005764 | 2113984 | 37.784922869937 | -122.423788535241 | (37.784922869937, -122.423788535241) | 13 | 9 | 11 | 28858 | 41 | |||
| 73226 | 114272 | Significant Tree 6 | Tree(s) :: 17 | 2241 Sacramento St | 1 | Front Yard : Cutout | Tree | Private 2 | 03/22/2016 12:00:00 AM | 3 | 3x6 | Permit Number 776884 | 6004082.4 | 2115905.7 | 37.7901043022718 | -122.429743441495 | (37.7901043022718, -122.429743441495) | 13 | 9 | 1 | 29490 | 27 | |
| 79307 | 255595 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 20x Starr King Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005969 | 2114025 | 37.7850470161942 | -122.423082215486 | (37.7850470161942, -122.423082215486) | 13 | 9 | 11 | 28858 | 41 | ||||
| 80605 | 99830 | Significant Tree 6 | Syzygium paniculatum :: Brush Cherry 243 | 2398@Steiner Broadway | 1 | Front Yard : Cutout | Tree | Private 2 | 6002195.8 | 2117442.8 | 37.7942177709498 | -122.436380971376 | (37.7942177709498, -122.436380971376) | 13 | 9 | 1 | 29490 | 27 | |||||
| 81307 | 96767 | Significant Tree 6 | Ficus microcarpa :: Chinese Banyan 97 | 2229 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Permit Number 768245 | 6003236 | 2116309 | 37.7911636966224 | -122.432700736457 | (37.7911636966224, -122.432700736457) | 13 | 9 | 1 | 29490 | 27 | |||
| 81315 | 104261 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1556X O'Farrell St | 1 | Front Yard : Yard | Tree | Private 2 | 6003781.85581 | 2113525.38813 | 37.783551542878 | -122.430613377711 | (37.783551542878, -122.430613377711) | 13 | 9 | 11 | 29490 | 41 | |||||
| 82071 | 106360 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 1820 POST ST | 1 | Front Yard : Yard | Tree | Private 2 | 30 | 6003351.1 | 2114201.6 | 37.785383838011 | -122.432151932321 | (37.785383838011, -122.432151932321) | 13 | 9 | 11 | 29490 | 13 | ||||
| 83971 | 105071 | Significant Tree 6 | Acacia stenophylla :: Shoestring Acacia 30 | 1808 Vallejo St | 1 | Front Yard : Yard | Tree | Private 2 | 3 | Permit Number 771033 | 6004794.05676 | 2118138.55822 | 37.7962754378239 | -122.427440299436 | (37.7962754378239, -122.427440299436) | 13 | 9 | 1 | 57 | 17 | |||
| 84706 | 103143 | Significant Tree 6 | Ulmus parvifolia :: Chinese Elm 31 | 2620 Buchanan St | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6003626 | 2117322 | 37.7939672460834 | -122.431423695166 | (37.7939672460834, -122.431423695166) | 13 | 9 | 1 | 29490 | 27 | ||||
| 89745 | 85085 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 83 | 1600 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 49476 | 6004108.1 | 2120157.9 | 37.8017812094321 | -122.429957968303 | (37.8017812094321, -122.429957968303) | 13 | 9 | 1 | 57 | 17 | ||||
| 91423 | 99643 | Significant Tree 6 | Magnolia grandiflora :: Southern Magnolia 19 | 1268 Lombard St | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6006289 | 2120073 | 37.8016713630652 | -122.42240499597 | (37.8016713630652, -122.42240499597) | 5 | 9 | 1 | 28858 | 32 | ||||
| 92073 | 98492 | Significant Tree 6 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2149 Laguna St | 1 | Front Yard : Yard | Tree | Private 2 | 6004211.7 | 2116183 | 37.7908730187591 | -122.429315856087 | (37.7908730187591, -122.429315856087) | 13 | 9 | 1 | 29490 | 27 | |||||
| 92359 | 120121 | Significant Tree 6 | Juglans hindsii :: Walnut: Black (n.calif) 457 | 444 Page St | 1 | Front Yard : Yard | Tree | Private 2 | 6004415 | 2109849 | 37.7734929358756 | -122.428160854421 | (37.7734929358756, -122.428160854421) | 7 | 9 | 11 | 28852 | 10 | |||||
| 92381 | 116164 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 2411 OCTAVIA ST | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | 15x4 | 6004495 | 2117637 | 37.7948813682629 | -122.428439330772 | (37.7948813682629, -122.428439330772) | 13 | 9 | 1 | 28858 | 27 | |||
| 95081 | 112874 | Significant Tree 6 | Magnolia grandiflora :: Southern Magnolia 19 | 2636 Vallejo St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 08/25/2015 12:00:00 AM | 13 | 3x3 | Permit Number 776037 | 6000935.48392 | 2117605.97258 | 37.7945941075731 | -122.440753504176 | (37.7945941075731, -122.440753504176) | 13 | 9 | 1 | 57 | 27 | |
| 99529 | 103588 | Significant Tree 6 | Ulmus parvifolia :: Chinese Elm 31 | 101X Laguna St | 1 | Front Yard : Yard | Tree | Private 2 | 6005198.60314 | 2109385.58511 | 37.772264815602 | -122.425417269432 | (37.772264815602, -122.425417269432) | 7 | 9 | 5 | 28852 | 10 | |||||
| 105893 | 116998 | Significant Tree 6 | Eucalyptus sideroxylon :: Red Ironbark 127 | 880x MCALLISTER ST | 1 | Front Yard : Cutout | Tree | Private 2 | 6005306 | 2112177 | 37.779935428414 | -122.425244441442 | (37.779935428414, -122.425244441442) | 7 | 9 | 11 | 28852 | 41 | |||||
| 106415 | 121157 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 350x Octavia St | 1 | Side Yard : Yard | Tree | Private 2 | 6005623 | 2110494 | 37.7753322239184 | -122.424028078477 | (37.7753322239184, -122.424028078477) | 7 | 9 | 11 | 28852 | 10 | |||||
| 106956 | 251495 | Significant Tree 6 | Tree(s) :: 17 | 2448 Clay St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 06/28/2017 12:00:00 AM | 3 | 10x10 | Permit Number 780000 | 6003026 | 2116224 | 37.7909183964794 | -122.433421252488 | (37.7909183964794, -122.433421252488) | 13 | 9 | 1 | 29490 | 27 | |
| 109250 | 107818 | Significant Tree 6 | Ficus Spp. :: 101 | 474 Oak St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3X3 | 6004715.2 | 2110227.8 | 37.7745500089947 | -122.427149405032 | (37.7745500089947, -122.427149405032) | 7 | 9 | 11 | 28852 | 10 | ||||
| 109809 | 106362 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 1645 WEBSTER ST | 1 | Front Yard : Yard | Tree | Private 2 | 12 | 6003301.2 | 2114333.7 | 37.7857437219688 | -122.432334009178 | (37.7857437219688, -122.432334009178) | 13 | 9 | 11 | 29490 | 13 | ||||
| 113506 | 108002 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 72 | 461X Ivy St | 1 | Front Yard : Cutout | Tree | Private 2 | 6005199.36333 | 2111122.83043 | 37.7770349120596 | -122.425538300101 | (37.7770349120596, -122.425538300101) | 7 | 9 | 11 | 28852 | 10 | |||||
| 118707 | 94293 | Significant Tree 6 | Ficus nitida :: Laurel Fig 53 | 1150X Fillmore St | 1 | Sidewalk: Property side : Cutout | Tree | Rec/Park 5 | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | 15 | 9 | 11 | 29490 | 41 | |||||
| 124902 | 257918 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 2200 Vallejo St | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6002990 | 2117900 | 37.7955182191045 | -122.433665645084 | (37.7955182191045, -122.433665645084) | 13 | 9 | 1 | 57 | 17 | ||||
| 125282 | 110236 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 100 BUCHANAN ST | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 05/12/2015 12:00:00 AM | 3 | 3x20 | 6004868.5 | 2109011.4 | 37.7712187378523 | -122.426532477218 | (37.7712187378523, -122.426532477218) | 7 | 9 | 5 | 28852 | 10 | ||
| 133531 | 187642 | Significant Tree 6 | Podocarpus gracilor :: Fern Pine 51 | 2526 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006264 | 2119500 | 37.8000966404513 | -122.42245076966 | (37.8000966404513, -122.42245076966) | 13 | 9 | 1 | 28858 | 32 | ||||
| 139171 | 255246 | Significant Tree 6 | Maytenus boaria :: Mayten 58 | 209x Willow St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6006475 | 2113325 | 37.7831535286214 | -122.421281886667 | (37.7831535286214, -122.421281886667) | 7 | 9 | 11 | 28858 | 41 | ||||
| 147643 | 100770 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 95 | 450 Hayes St | 1 | Back Yard : Yard | Tree | Private 2 | Permit Number 768934 | 6005678.7 | 2111113.4 | 37.7770360905223 | -122.423879452899 | (37.7770360905223, -122.423879452899) | 7 | 9 | 11 | 28852 | 10 | ||||
| 150357 | 100434 | Significant Tree 6 | Tree(s) :: 17 | 2430 Sacramento St | 1 | Front Yard : Yard | Tree | Private 2 | 09/24/2012 12:00:00 AM | Permit Number 769154 | 6003168.3 | 2115899 | 37.7900341016439 | -122.432905672523 | (37.7900341016439, -122.432905672523) | 13 | 9 | 1 | 29490 | 27 | |||
| 152489 | 103652 | Significant Tree 6 | Tree(s) :: 17 | 307X Octavia St | 1 | Front Yard : Yard | Tree | DPW for City Agency 14 | 06/07/2013 12:00:00 AM | Permit Number 770306 | 6005538.74006 | 2110314.20336 | 37.7748337884081 | -122.424306762839 | (37.7748337884081, -122.424306762839) | 7 | 9 | 11 | 28852 | 10 | |||
| 154508 | 109210 | Significant Tree 6 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2637 Larkin St | 1 | Front Yard : Yard | Tree | Private 2 | 02/18/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774817 | 6006569.78732 | 2120282.61277 | 37.8022627417937 | -122.421448236261 | (37.8022627417937, -122.421448236261) | 5 | 9 | 1 | 28858 | 32 | |
| 154569 | 103589 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 55X Laguna St | 1 | Front Yard : Yard | Tree | Private 2 | 6005242.6 | 2108960.5 | 37.7711001201992 | -122.425234826708 | (37.7711001201992, -122.425234826708) | 7 | 9 | 5 | 28852 | 10 | |||||
| 157916 | 110559 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 27 | 320x FULTON ST | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10x36 | 6006080 | 2112015 | 37.7795343118474 | -122.422555311635 | (37.7795343118474, -122.422555311635) | 7 | 9 | 11 | 28852 | 10 | ||||
| 159837 | 253968 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 1401X Laguna St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6004485 | 2113711 | 37.784100995896 | -122.428194001884 | (37.784100995896, -122.428194001884) | 13 | 9 | 11 | 29490 | 41 | ||||
| 162406 | 255994 | Significant Tree 6 | Magnolia grandiflora :: Southern Magnolia 19 | 179 Retiro Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3x3 | 6001908 | 2121813 | 37.8062008335618 | -122.437689923584 | (37.8062008335618, -122.437689923584) | 13 | 9 | 1 | 57 | 17 | ||||
| 164727 | 99894 | Significant Tree 6 | Ulmus pumila :: Siberian Elm 99 | 1636 Bush St | 1 | Front Yard : Yard | Tree | Private 2 | 07/11/2012 12:00:00 AM | Permit Number 768849 | 6005665 | 2115204 | 37.7882670981083 | -122.424217840789 | (37.7882670981083, -122.424217840789) | 13 | 9 | 1 | 28858 | 41 | |||
| 166073 | 112419 | Significant Tree 6 | Picea Spp :: Spruce Spp 200 | 268 Lily St | 1 | Back Yard : Yard | Tree | Private 2 | 07/29/2015 12:00:00 AM | 3 | 6005334.87738 | 2110100.0463 | 37.7742342515583 | -122.424996726643 | (37.7742342515583, -122.424996726643) | 7 | 9 | 11 | 28852 | 10 | |||
| 166311 | 127110 | Significant Tree 6 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 3201 Laguna St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | Width 6ft | 6003718.35126 | 2119752.0994 | 37.8006449063974 | -122.431277695812 | (37.8006449063974, -122.431277695812) | 13 | 9 | 1 | 57 | 17 | |||
| 166780 | 173951 | Significant Tree 6 | Tree(s) :: 17 | 2646 Union St | 1 | Front Yard : Cutout | Tree | Private 2 | 04/11/2017 12:00:00 AM | 3 | 10x10 | Permit Number 779549 | 6000338 | 2118225 | 37.7962597494046 | -122.442865342513 | (37.7962597494046, -122.442865342513) | 13 | 9 | 1 | 57 | 17 | |
| 168909 | 112367 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 2770 Broadway | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 07/23/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774944 | 6000432.43478 | 2117179.73451 | 37.7933951089516 | -122.442463497617 | (37.7933951089516, -122.442463497617) | 13 | 9 | 1 | 57 | 27 | |
| 169126 | 115697 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 1425x LAGUNA ST | 1 | Front Yard : Yard | Tree | Private 2 | 25 | 6004559 | 2113815 | 37.7843907406582 | -122.4279454018 | (37.7843907406582, -122.4279454018) | 13 | 9 | 11 | 29490 | 41 | ||||
| 170978 | 108021 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 72 | 455X Ivy St | 1 | Front Yard : Cutout | Tree | Private 2 | 6005179.30837 | 2111099.83336 | 37.776970634543 | -122.42560603936 | (37.776970634543, -122.42560603936) | 7 | 9 | 11 | 28852 | 10 | |||||
| 172328 | 101741 | Significant Tree 6 | Tree(s) :: 17 | 1590 Broadway | 1 | Front Yard : Yard | Tree | Private 2 | 12/21/2012 12:00:00 AM | Permit Number 769428 | 6006147.8 | 2117991.4 | 37.7959478507639 | -122.422745597666 | (37.7959478507639, -122.422745597666) | 13 | 9 | 10 | 28858 | 32 | |||
| 173520 | 258387 | Significant Tree 6 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 2770 Lombard St | 1 | Front Yard : Cutout | Tree | Private 2 | 5999223 | 2119112 | 37.7986315842223 | -122.446787313103 | (37.7986315842223, -122.446787313103) | 13 | 9 | 1 | 57 | 17 | |||||
| 174521 | 258525 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 95 | 50 Hermann St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6005031 | 2108842 | 37.7707627914543 | -122.425958322168 | (37.7707627914543, -122.425958322168) | 7 | 9 | 5 | 28852 | 10 | |||||
| 177345 | 251411 | Significant Tree 6 | Tree(s) :: 17 | 2751 Buchanan St | 1 | Front Yard : Cutout | Tree | Private 2 | 06/21/2017 12:00:00 AM | 3 | 6x6 | Permit Number 779887 | 6003497 | 2117826 | 37.7953437887296 | -122.431906052505 | (37.7953437887296, -122.431906052505) | 13 | 9 | 1 | 29490 | 27 | |
| 180419 | 105351 | Significant Tree 6 | Pyrus calleryana :: Ornamental Pear 44 | 2040 Jackson St | 1 | Front Yard : Yard | Tree | Private 2 | 01/16/2014 12:00:00 AM | 3 | Permit Number 769933 | 6004399.13095 | 2117053.27366 | 37.7932731788779 | -122.428729419132 | (37.7932731788779, -122.428729419132) | 13 | 9 | 1 | 28858 | 27 | ||
| 182332 | 258021 | Significant Tree 6 | Tree(s) :: 17 | 201x Gough St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6006013 | 2110374 | 37.7750247439455 | -122.422670446803 | (37.7750247439455, -122.422670446803) | 7 | 9 | 11 | 28852 | 10 | ||||
| 182906 | 103611 | Significant Tree 6 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 200X Buchanan St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6004748.9 | 2109266.8 | 37.7719132424086 | -122.426964371637 | (37.7719132424086, -122.426964371637) | 7 | 9 | 5 | 28852 | 10 | |||||
| 184201 | 99827 | Significant Tree 6 | Syzygium paniculatum :: Brush Cherry 243 | 2398 Broadway | 1 | Front Yard : Yard | Tree | Private 2 | 6002195.8 | 2117442.8 | 37.7942177709498 | -122.436380971376 | (37.7942177709498, -122.436380971376) | 13 | 9 | 1 | 29490 | 27 | |||||
| 193247 | 85088 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 83 | 1600 Chestnut St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6004108.1 | 2120157.9 | 37.8017812094321 | -122.429957968303 | (37.8017812094321, -122.429957968303) | 13 | 9 | 1 | 57 | 17 | |||||
| 194298 | 262528 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3400 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/2020 12:00:00 AM | 3 | 3x3 | 6003691 | 2120547 | 37.8028259466608 | -122.431429119577 | (37.8028259466608, -122.431429119577) | 13 | 9 | 1 | 57 | 17 | ||
| 27763 | 105240 | Significant Tree 6 | Tree(s) :: 17 | 20X Cleary Ct | 10 | Front Yard : Yard | Tree | Private 2 | 01/06/2014 12:00:00 AM | Permit Number 770859 | 6005004.4 | 2113886.9 | 37.7846133478309 | -122.426409592351 | (37.7846133478309, -122.426409592351) | 13 | 9 | 11 | 28858 | 41 | |||
| 48151 | 98950 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 95 | 401 Grove St | 10 | Front Yard : Yard | Tree | Private 2 | 6005778.2 | 2111279 | 37.7774964045324 | -122.423547027313 | (37.7774964045324, -122.423547027313) | 7 | 9 | 11 | 28852 | 10 | |||||
| 161677 | 105090 | Significant Tree 6 | :: 45 | 344 Fulton St | 10 | Front Yard : Yard | Tree | Private 2 | 6006101.8 | 2111789.5 | 37.7789163735632 | -122.422463868572 | (37.7789163735632, -122.422463868572) | 7 | 9 | 11 | 28852 | 10 | |||||
| 91093 | 105091 | Significant Tree 6 | :: 45 | 344 Fulton St | 11 | Front Yard : Yard | Tree | Private 2 | 6006101.8 | 2111789.5 | 37.7789163735632 | -122.422463868572 | (37.7789163735632, -122.422463868572) | 7 | 9 | 11 | 28852 | 10 | |||||
| 117572 | 105241 | Significant Tree 6 | Tree(s) :: 17 | 20X Cleary Ct | 11 | Front Yard : Yard | Tree | Private 2 | 01/06/2014 12:00:00 AM | Permit Number 770859 | 6005004.4 | 2113886.9 | 37.7846133478309 | -122.426409592351 | (37.7846133478309, -122.426409592351) | 13 | 9 | 11 | 28858 | 41 | |||
| 140823 | 98951 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 52 | 401 Grove St | 11 | Front Yard : Yard | Tree | Private 2 | 6005778.2 | 2111279 | 37.7774964045324 | -122.423547027313 | (37.7774964045324, -122.423547027313) | 7 | 9 | 11 | 28852 | 10 | |||||
| 117668 | 105242 | Significant Tree 6 | Tree(s) :: 17 | 20X Cleary Ct | 14 | Front Yard : Yard | Tree | Private 2 | 01/06/2014 12:00:00 AM | Permit Number 770859 | 6005004.4 | 2113886.9 | 37.7846133478309 | -122.426409592351 | (37.7846133478309, -122.426409592351) | 13 | 9 | 11 | 28858 | 41 | |||
| 31523 | 98952 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 52 | 302 Ivy St | 18 | Front Yard : Yard | Tree | Private 2 | 6005888.5 | 2111234.3 | 37.7773798943726 | -122.42316228433 | (37.7773798943726, -122.42316228433) | 7 | 9 | 11 | 28852 | 10 | |||||
| 71208 | 98953 | Significant Tree 6 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 302 Ivy St | 19 | Front Yard : Yard | Tree | Private 2 | 6005888.5 | 2111234.3 | 37.7773798943726 | -122.42316228433 | (37.7773798943726, -122.42316228433) | 7 | 9 | 11 | 28852 | 10 | |||||
| 29 | 264952 | Significant Tree 6 | Tree(s) :: 17 | 20X Cleary Ct | 2 | Front Yard : Yard | Tree | Private 2 | 11/13/2020 12:00:00 AM | 3 | 6004818 | 2113712 | 37.7841225773231 | -122.427042012496 | (37.7841225773231, -122.427042012496) | 13 | 9 | 11 | 28858 | 41 | |||
| 8183 | 261995 | Significant Tree 6 | Phoenix spp :: Date palm (species unknown) 255 | 2727 Pierce St | 2 | Front Yard : Yard | Tree | Private 2 | 10/07/2020 12:00:00 AM | 3 | 3x3 | Permit Number 785198 | 6001553 | 2117834 | 37.7952553588401 | -122.438633170174 | (37.7952553588401, -122.438633170174) | 13 | 9 | 1 | 57 | 27 | |
| 20021 | 88145 | Significant Tree 6 | Tree(s) :: 17 | 1475 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2000 12:00:00 AM | 3x3 | Permit Number 51176 | 6003147.8 | 2113351.1 | 37.7830370509294 | -122.43279450975 | (37.7830370509294, -122.43279450975) | 15 | 9 | 11 | 29490 | 41 | ||
| 22018 | 106361 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 1645 WEBSTER ST | 2 | Front Yard : Yard | Tree | Private 2 | 30 | 6003301.2 | 2114333.7 | 37.7857437219688 | -122.432334009178 | (37.7857437219688, -122.432334009178) | 13 | 9 | 11 | 29490 | 13 |
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) );