trees

13 rows where SiteOrder = 2, qLegalStatus_id = 4 and qSpecies_id = 5

✎ View and edit SQL

This data as json, CSV (advanced)

qLegalStatus_id ✖

  • Undocumented · 13 ✖

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)
29270 103687 Undocumented 4 Ceratonia siliqua :: Carob 5 903 SHOTWELL ST 2 Sidewalk: Curb side : Cutout Tree Private 2     24 3x3   6008052 2102672 37.7539916655216 -122.415071798268 (37.7539916655216, -122.415071798268) 2 4 7 28859 19
32244 111887 Undocumented 4 Ceratonia siliqua :: Carob 5 140 LUNDYS LN 2 Sidewalk: Curb side : Cutout Tree Private 2     12 3x12   6006709 2098750 37.7431471814186 -122.41943799965 (37.7431471814186, -122.41943799965) 2 7 7 28859 2
42963 97180 Undocumented 4 Ceratonia siliqua :: Carob 5 10X Fremont St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   6013222.5 2116242.1 37.7915413037038 -122.398142826086 (37.7915413037038, -122.398142826086) 12 2 9 28855 6
43272 105450 Undocumented 4 Ceratonia siliqua :: Carob 5 890 Alabama St 2 Sidewalk: Curb side : Cutout Tree Private 2           6009082.7 2103985.1 37.7576550089679 -122.411600148106 (37.7576550089679, -122.411600148106) 2 4 7 28859 19
61904 110184 Undocumented 4 Ceratonia siliqua :: Carob 5 1500x LYON ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5999718 2114083 37.7848515388794 -122.444712796347 (37.7848515388794, -122.444712796347) 15 6 1 29490 31
62148 115558 Undocumented 4 Ceratonia siliqua :: Carob 5 2500x 19TH ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010357 2105131 37.7608727909959 -122.407273854716 (37.7608727909959, -122.407273854716) 10 4 8 28859 19
89068 119742 Undocumented 4 Ceratonia siliqua :: Carob 5 15X Fremont St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013411 2116073 37.7910874921548 -122.39747874957 (37.7910874921548, -122.39747874957) 12 2 9 28855 6
101361 222898 Undocumented 4 Ceratonia siliqua :: Carob 5 2771 22nd St 2 Sidewalk: Curb side : Yard Tree Private 2     21 Width 6ft   6009527.7031 2103333.93064 37.7558919964247 -122.410015170384 (37.7558919964247, -122.410015170384) 2 4 7 28859 19
110855 114592 Undocumented 4 Ceratonia siliqua :: Carob 5 70 LOMITA AVE 2 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   5991433 2104626 37.7584089066312 -122.472686161822 (37.7584089066312, -122.472686161822) 1 8 4 56 12
127110 103340 Undocumented 4 Ceratonia siliqua :: Carob 5 590X 09th St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3 Permit Number 772809 6010323 2108639 37.7705030566796 -122.407638793146 (37.7705030566796, -122.407638793146) 8 2 9 28853 34
149041 113693 Undocumented 4 Ceratonia siliqua :: Carob 5 112 LUNDYS LN 2 Sidewalk: Curb side : Cutout Tree Private 2       3x5   6006814 2098928 37.7436418429474 -122.419087559811 (37.7436418429474, -122.419087559811) 2 7 7 28859 2
153332 96855 Undocumented 4 Ceratonia siliqua :: Carob 5 600 Eugenia Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6007257 2097738 37.740399305054 -122.417471450766 (37.740399305054, -122.417471450766) 2 7 7 28859 2
161171 113383 Undocumented 4 Ceratonia siliqua :: Carob 5 146 CASTENADA AVE 2 Sidewalk: Curb side : Cutout Tree Private 2     7 3x3   5994461 2101055 37.7487786662853 -122.461955122224 (37.7487786662853, -122.461955122224) 1 8 4 29491 40

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