trees

17 rows where Zip Codes = 28862 and qLegalStatus_id = 10 sorted by qAddress

✎ View and edit SQL

This data as json, CSV (advanced)

Zip Codes ✖

  • 28862 · 17 ✖
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)
111448 111204 Section 143 10 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 168 CLIPPER ST 1 Sidewalk: Curb side : Cutout Tree Private 2   05/27/2015 12:00:00 AM 3 3x3   6004024 2101044 37.7492943788142 -122.428885525131 (37.7492943788142, -122.428885525131) 2 4 5 28862 22
84488 112892 Section 143 10 Cornus nuttallii x florida 'Eddie's White Wonder' :: Eddie's White Wonder Dogwood 373 1X WEBSTER ST 4 Sidewalk: Property side : Yard Tree Private 2       3x3   6004219 2108568 37.7699645303419 -122.428747509741 (37.7699645303419, -122.428747509741) 7 9 5 28862 10
103216 112891 Section 143 10 Cornus nuttallii x florida 'Eddie's White Wonder' :: Eddie's White Wonder Dogwood 373 1X WEBSTER ST 3 Sidewalk: Property side : Yard Tree Private 2       3x3   6004219 2108568 37.7699645303419 -122.428747509741 (37.7699645303419, -122.428747509741) 7 9 5 28862 10
6989 109119 Section 143 10 Ginkgo biloba :: Maidenhair Tree 22 2036x 15TH ST 5 Sidewalk: Curb side : Cutout Tree Private 2       12x6   6003817 2107261 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651) 8 4 5 28862 3
20563 109121 Section 143 10 Ginkgo biloba :: Maidenhair Tree 22 2036x 15TH ST 7 Sidewalk: Curb side : Cutout Tree Private 2       12x6   6003817 2107261 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651) 8 4 5 28862 3
21125 109116 Section 143 10 Ginkgo biloba :: Maidenhair Tree 22 2036x 15TH ST 2 Sidewalk: Curb side : Cutout Tree Private 2       12x6   6003817 2107261 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651) 8 4 5 28862 3
25414 109115 Section 143 10 Ginkgo biloba :: Maidenhair Tree 22 2036x 15TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2       12x6   6003817 2107261 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651) 8 4 5 28862 3
57202 109123 Section 143 10 Ginkgo biloba :: Maidenhair Tree 22 2036x 15TH ST 9 Sidewalk: Curb side : Cutout Tree Private 2       12x6   6003817 2107261 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651) 8 4 5 28862 3
89702 109120 Section 143 10 Ginkgo biloba :: Maidenhair Tree 22 2036x 15TH ST 6 Sidewalk: Curb side : Cutout Tree Private 2       12x6   6003817 2107261 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651) 8 4 5 28862 3
92107 109124 Section 143 10 Ginkgo biloba :: Maidenhair Tree 22 2036x 15TH ST 10 Sidewalk: Curb side : Cutout Tree Private 2       12x6   6003817 2107261 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651) 8 4 5 28862 3
109575 109117 Section 143 10 Ginkgo biloba :: Maidenhair Tree 22 2036x 15TH ST 3 Sidewalk: Curb side : Cutout Tree Private 2       12x6   6003817 2107261 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651) 8 4 5 28862 3
126583 109122 Section 143 10 Ginkgo biloba :: Maidenhair Tree 22 2036x 15TH ST 8 Sidewalk: Curb side : Cutout Tree Private 2       12x6   6003817 2107261 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651) 8 4 5 28862 3
182184 109118 Section 143 10 Ginkgo biloba :: Maidenhair Tree 22 2036x 15TH ST 4 Sidewalk: Curb side : Cutout Tree Private 2       12x6   6003817 2107261 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651) 8 4 5 28862 3
43321 108260 Section 143 10 Liquidambar styraciflua :: American Sweet Gum 37 45 Belcher St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/12/2014 12:00:00 AM 3     6003817.04493 2108084.54469 37.7686143220373 -122.430103370918 (37.7686143220373, -122.430103370918) 7 9 5 28862 3
37646 110789 Section 143 10 Pinus radiata :: Monterey Pine 15 850x SANCHEZ ST 3 Front Yard : Cutout Tree Private 2       3x3   6003717 2103349 37.7556059854845 -122.430111549694 (37.7556059854845, -122.430111549694) 2 4 5 28862 22
94624 110787 Section 143 10 Tree(s) :: 17 850x SANCHEZ ST 1 Front Yard : Cutout Tree Private 2   02/18/2016 12:00:00 AM 3 3x3 Permit Number 777427 6003717 2103349 37.7556059854845 -122.430111549694 (37.7556059854845, -122.430111549694) 2 4 5 28862 22
172048 110788 Section 143 10 Tree(s) :: 17 850x SANCHEZ ST 2 Front Yard : Cutout Tree Private 2   02/18/2016 12:00:00 AM 3 3x3 Permit Number 777427 6003717 2103349 37.7556059854845 -122.430111549694 (37.7556059854845, -122.430111549694) 2 4 5 28862 22

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