trees

36 rows where Zip Codes = 57 and qLegalStatus_id = 6 sorted by DBH

✎ View and edit SQL

This data as json, CSV (advanced)

These facets timed out: Zip Codes

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)
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
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
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
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
37483 85089 Significant Tree 6 Pyrus kawakamii :: Evergreen Pear 83 1600 Chestnut St 2 Sidewalk: Property side : Cutout Tree Private 2           6004108.1 2120157.9 37.8017812094321 -122.429957968303 (37.8017812094321, -122.429957968303) 13 9 1 57 17
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
43750 253165 Significant Tree 6 Quercus agrifolia :: Coast Live Oak 172 1451 Bay St 3 Front Yard : Yard Tree Private 2       3x3   6003691 2120547 37.8028259466608 -122.431429119577 (37.8028259466608, -122.431429119577) 13 9 1 57 17
46495 85086 Significant Tree 6 Pyrus kawakamii :: Evergreen Pear 83 1600 Chestnut St 2 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
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
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
99727 258388 Significant Tree 6 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 2770 Lombard St 2 Front Yard : Cutout Tree Private 2           5999223 2119112 37.7986315842223 -122.446787313103 (37.7986315842223, -122.446787313103) 13 9 1 57 17
105107 85090 Significant Tree 6 Pyrus kawakamii :: Evergreen Pear 83 1600 Chestnut St 3 Sidewalk: Property side : Cutout Tree Private 2           6004108.1 2120157.9 37.8017812094321 -122.429957968303 (37.8017812094321, -122.429957968303) 13 9 1 57 17
118931 85087 Significant Tree 6 Pyrus kawakamii :: Evergreen Pear 83 1600 Chestnut St 3 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
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
153500 33327 Significant Tree 6 Arbutus unedo :: Strawberry Tree 106 1629 Green St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/13/2010 12:00:00 AM   3x3 Originally issued under Permit Number 51411; permit expired; property changed owners; trees re-posted and permit 53716 issued 6005242.65792202 2118493.60609418 37.7972756709044 -122.425913331435 (37.7972756709044, -122.425913331435) 13 9 1 57 17
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
171446 257980 Significant Tree 6 Ficus nitida :: Laurel Fig 53 2864 Broadway 3 Front Yard : Yard Tree Private 2         Permit Number 782825 5999909.76407 2117098.92712 37.7931434275556 -122.444266160734 (37.7931434275556, -122.444266160734) 13 9 1 57 27
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
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
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
176820 99289 Significant Tree 6 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 845 Marina Blvd 2 Front Yard : Yard Tree Private 2   06/05/2012 12:00:00 AM 1   Permit Number 768788 5998887.79124 2121333.18312 37.8047111982366 -122.448107254257 (37.8047111982366, -122.448107254257) 13 9 1 57 17
185953 126695 Significant Tree 6 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2829 Divisadero St 2 Front Yard : Yard Tree Private 2     11 10x10 Permit Number 779774 6000551.43021 2118023.61416 37.7957189625051 -122.442112369006 (37.7957189625051, -122.442112369006) 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
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
156627 125128 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 2545 Baker St 2 Sidewalk: Property side : Yard Tree Private 2     13 Width 4ft   5999632.15337 2117620.57677 37.7945598973812 -122.44526423016 (37.7945598973812, -122.44526423016) 13 9 1 57 27
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
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
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
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
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
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
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
92540 113772 Significant Tree 6 Magnolia grandiflora :: Southern Magnolia 19 2550 Broadway 4 Sidewalk: Property side : Cutout Tree Private 2     4     6001375.31674 2117310.7972 37.7938086711861 -122.439210462719 (37.7938086711861, -122.439210462719) 13 9 1 57 27
128387 113771 Significant Tree 6 Magnolia grandiflora :: Southern Magnolia 19 2550 Broadway 3 Sidewalk: Property side : Cutout Tree Private 2     5     6001386.1067 2117311.2447 37.7938105138862 -122.439173160634 (37.7938105138862, -122.439173160634) 13 9 1 57 27
172310 113770 Significant Tree 6 Magnolia grandiflora :: Southern Magnolia 19 2550 Broadway 2 Sidewalk: Property side : Cutout Tree Private 2     5     6001403.30227 2117311.89486 37.7938132775122 -122.439113709125 (37.7938132775122, -122.439113709125) 13 9 1 57 27

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