11 rows where Fire Prevention Districts = 8, SiteOrder = 1 and qSpecies_id = 5

View and edit SQL

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)
7 188479 Prune Opt Out 3 Ceratonia siliqua :: Carob 5 2208 Mariposa St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft Permit Number 787847 6010817.79084 2106032.71885 37.7633744862602 -122.405743691032 (37.7633744862602, -122.405743691032) 8 4 8 28859 19
24938 188478 DPW Maintained 1 Ceratonia siliqua :: Carob 5 499 San Bruno Ave 1 Sidewalk: Curb side : Yard Tree Private 2     13 Width 3ft   6010892.5271 2106015.01328 37.7633300498768 -122.405483954234 (37.7633300498768, -122.405483954234) 8 4 8 28856 19
30088 5432 DPW Maintained 1 Ceratonia siliqua :: Carob 5 499 Dolores St 1 Sidewalk: Curb side : Cutout Tree Private 2     36 3X3   6004968.15127 2105494.35348 37.7615674029223 -122.425937381218 (37.7615674029223, -122.425937381218) 8 4 5 28859 19
38377 189958 DPW Maintained 1 Ceratonia siliqua :: Carob 5 562 09th St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6010386.69691 2108550.07878 37.7702624648584 -122.407412194212 (37.7702624648584, -122.407412194212) 8 2 9 28853 34
40377 103339 Undocumented 4 Ceratonia siliqua :: Carob 5 590X 09th St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6010323 2108639 37.7705030566796 -122.407638793146 (37.7705030566796, -122.407638793146) 8 2 9 28853 34
76472 225100 DPW Maintained 1 Ceratonia siliqua :: Carob 5 75 Valencia St 1 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 5ft   6006056.75092 2109200.3154 37.7718045566698 -122.422435689168 (37.7718045566698, -122.422435689168) 8 2 9 28853 19
86068 188467 DPW Maintained 1 Ceratonia siliqua :: Carob 5 255 12th St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 5ft   6008105.35323 2108904.54782 37.77110780062 -122.415328472924 (37.77110780062, -122.415328472924) 8 2 9 28853 19
90289 22896 Permitted Site 7 Ceratonia siliqua :: Carob 5 201 Valencia St 1 Sidewalk: Curb side : Cutout Tree Private 2     25 2X2   6006117.69751 2108447.07837 37.7697397858216 -122.422171347799 (37.7697397858216, -122.422171347799) 8 4 7 28853 19
115285 222894 DPW Maintained 1 Ceratonia siliqua :: Carob 5 3080 16th St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/14/1989 12:00:00 AM 14 Width 3ft Permit Number 27054 6006296.82054 2106727.45524 37.765028210007 -122.421429624803 (37.765028210007, -122.421429624803) 8 4 7 28853 19
151186 222896 DPW Maintained 1 Ceratonia siliqua :: Carob 5 115 Julian Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 4ft   6006441.81181 2107164.43854 37.7662362369242 -122.420959163358 (37.7662362369242, -122.420959163358) 8 4 7 28853 19
182345 222884 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1 Valencia St 1 : Tree Private 2     18 Width 5ft   6006058.17228 2109199.11331 37.7718013362 -122.422430687153 (37.7718013362, -122.422430687153) 8 2 9 28853 19

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