trees

9 rows where SiteOrder = 2 and qCaretaker_id = 13 sorted by PermitNotes

✎ View and edit SQL

This data as json, CSV (advanced)

SiteOrder ✖

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)
39292 18395 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 19 1001X Potrero Ave 2 Sidewalk: Property side : Cutout Tree Health Dept 13     18 3x3   6010583.31237 2102829.86253 37.7545670450388 -122.406328995892 (37.7545670450388, -122.406328995892) 10 4 8 28859 19
42674 17731 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1301 Pierce St 2 Sidewalk: Curb side : Cutout Tree Health Dept 13     18 3X3   6002241.0395679 2112976.4425925 37.7819568674508 -122.435904708519 (37.7819568674508, -122.435904708519) 15 5 11 29490 41
90642 27017 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 1525 Silver Ave 2 Sidewalk: Curb side : Cutout Tree Health Dept 13     12 3X3   6010513.2597857 2094754.7801651 37.7323906999135 -122.4060024251 (37.7323906999135, -122.4060024251) 10 3 7 309 28
117271 18427 Permitted Site 7 Magnolia grandiflora :: Southern Magnolia 19 1001X Potrero Ave 2 Sidewalk: Property side : Cutout Tree Health Dept 13     40 3X3   6010537.1589047 2103412.4254884 37.7561640514811 -122.406529656376 (37.7561640514811, -122.406529656376) 10 4 8 28859 19
130715 251303 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1 Cashmere St 2 Back Yard : Yard Tree Health Dept 13       3x3   6017463 2095772 37.7355700327415 -122.382046041696 (37.7355700327415, -122.382046041696) 10 3 8 58 1
133931 86164 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1351 24th Ave 2 Sidewalk: Curb side : Cutout Tree Health Dept 13   01/19/2007 12:00:00 AM 3 3x3   5988630.418 2106137.2111 37.7623956536559 -122.482489349436 (37.7623956536559, -122.482489349436) 1 8 3 56 35
134301 17741 DPW Maintained 1 Olea europaea :: Olive Tree 9 1347 Pierce St 2 Sidewalk: Curb side : Cutout Tree Health Dept 13     6 3X3   6002204.1761 2113255.0755 37.7827198287143 -122.436052183441 (37.7827198287143, -122.436052183441) 15 5 11 29490 41
164794 86282 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1350 25th Ave 2 Sidewalk: Curb side : Cutout Tree Health Dept 13   12/12/2006 12:00:00 AM 3 3x3   5988362.5718 2106125.3068 37.7623473824459 -122.48341484618 (37.7623473824459, -122.48341484618) 1 8 3 56 35
183203 17737 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 1802X Ellis St 2 Sidewalk: Curb side : Cutout Tree Health Dept 13     12 3X3   6002240.5506838 2112991.3064345 37.78199765203 -122.435907463701 (37.78199765203, -122.435907463701) 15 5 11 29490 41

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