10 rows where SiteOrder = 1 and qCaretaker_id = 13 sorted by Fire Prevention Districts

View and edit SQL

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)
3020 260513 Property Tree 8 Pinus radiata :: Monterey Pine 15 1990 41st Ave 1 Back Yard : Yard Tree Health Dept 13       10x10   5983703 2101544 37.7494961014415 -122.499191781388 (37.7494961014415, -122.499191781388) 1 8 3 29491 35
55752 86281 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 1350 25th Ave 1 Sidewalk: Curb side : Cutout Tree Health Dept 13   12/12/2006 12:00:00 AM 3 3x3   5988363.654 2106078.2308 37.7622181875649 -122.483407652112 (37.7622181875649, -122.483407652112) 1 8 3 56 35
62617 86163 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1351 24th Ave 1 Sidewalk: Curb side : Cutout Tree Health Dept 13   01/19/2007 12:00:00 AM 3 3x3   5988630.418 2106174.0062 37.7624966829905 -122.482492045676 (37.7624966829905, -122.482492045676) 1 8 3 56 35
45615 251302 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1 Cashmere St 1 Back Yard : Yard Tree Health Dept 13       3x3   6017463 2095772 37.7355700327415 -122.382046041696 (37.7355700327415, -122.382046041696) 10 3 8 58 1
89882 251300 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 100 Whitney Young Cir 1 Back Yard : Yard Tree Health Dept 13       3x3   6016360 2096059 37.7362970999571 -122.385879567348 (37.7362970999571, -122.385879567348) 10 3 8 58 1
92473 18426 Permitted Site 7 Magnolia grandiflora :: Southern Magnolia 19 1001X Potrero Ave 1 Sidewalk: Property side : Cutout Tree Health Dept 13   01/20/2016 12:00:00 AM 30 3X3   6010537.1589047 2103412.4254884 37.7561640514811 -122.406529656376 (37.7561640514811, -122.406529656376) 10 4 8 28859 19
136266 27016 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 1525 Silver Ave 1 Sidewalk: Curb side : Cutout Tree Health Dept 13     18 3X3   6010513.2597857 2094754.7801651 37.7323906999135 -122.4060024251 (37.7323906999135, -122.4060024251) 10 3 7 309 28
12403 17740 DPW Maintained 1 Olea europaea :: Olive Tree 9 1347 Pierce St 1 Sidewalk: Curb side : Cutout Tree Health Dept 13   12/01/1982 12:00:00 AM 6 3X3   6002203.7996 2113272.0173 37.7827663252153 -122.436054698673 (37.7827663252153, -122.436054698673) 15 5 11 29490 41
157655 141187 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1802 Ellis St 1 Sidewalk: Curb side : Cutout Tree Health Dept 13     25 Width 0ft   6002206.3563 2112987.8984 37.7819863518957 -122.436025516484 (37.7819863518957, -122.436025516484) 15 5 11 29490 41
192949 17730 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1301 Pierce St 1 Sidewalk: Curb side : Cutout Tree Health Dept 13     24 3X3   6002241.0395679 2112976.4425925 37.7819568674508 -122.435904708519 (37.7819568674508, -122.435904708519) 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)
);