trees

5 rows where PlantDate = "12/08/1986 12:00:00 AM" and qSpecies_id = 5

✎ View and edit SQL

This data as json, CSV (advanced)

qCaretaker_id ✖

PlantDate ✖

  • 12/08/1986 12:00:00 AM · 5 ✖
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)
24468 57556 Permitted Site 7 Ceratonia siliqua :: Carob 5 57 Lundy's Ln 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/08/1986 12:00:00 AM     Permit Number 23627 6007019.50965831 2099220.3784742 37.7444562195491 -122.418397682663 (37.7444562195491, -122.418397682663) 2 7 7 28859 2
52185 63117 Permitted Site 7 Ceratonia siliqua :: Carob 5 72 Lundy's Ln 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/08/1986 12:00:00 AM     Permit Number 23624 6006928.92708318 2099162.96302102 37.7442934699851 -122.418706828381 (37.7442934699851, -122.418706828381) 2 7 7 28859 2
72277 58315 Permitted Site 7 Ceratonia siliqua :: Carob 5 86 Lundy's Ln 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/08/1986 12:00:00 AM     Permit Number 23623 6006886.31504247 2099084.89744452 37.7440767201845 -122.418848636603 (37.7440767201845, -122.418848636603) 2 7 7 28859 2
82514 63116 Permitted Site 7 Ceratonia siliqua :: Carob 5 115 Lundy's Ln 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/08/1986 12:00:00 AM     Permit Number 23622 6006844.85682717 2098899.69149034 37.7435658517454 -122.418978856767 (37.7435658517454, -122.418978856767) 2 7 7 28859 2
120856 63118 Permitted Site 7 Ceratonia siliqua :: Carob 5 70 Lundy's Ln 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/08/1986 12:00:00 AM     Permit Number 23625 6006935.01451866 2099174.11524824 37.7443244342333 -122.418686569992 (37.7443244342333, -122.418686569992) 2 7 7 28859 2

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