trees

9 rows where Neighborhoods (old) = 6, SiteOrder = 5 and qSpecies_id = 5

✎ View and edit SQL

This data as json, CSV (advanced)

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)
6962 189948 DPW Maintained 1 Ceratonia siliqua :: Carob 5 162 Spear St 5 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 1ft   6014781.22378 2116142.62721 37.7913548700732 -122.392742658052 (37.7913548700732, -122.392742658052) 12 2 9 28855 6
80077 106029 DPW Maintained 1 Ceratonia siliqua :: Carob 5 180 Howard St 5 Sidewalk: Curb side : Cutout Tree Private 2   02/05/2015 12:00:00 AM 14 3x3 Permit Number 770222 6014636.89755 2115962.51686 37.7908523118267 -122.393229418798 (37.7908523118267, -122.393229418798) 12 2 9 28855 6
101550 119745 Undocumented 4 Ceratonia siliqua :: Carob 5 15X Fremont St 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013411 2116073 37.7910874921548 -122.39747874957 (37.7910874921548, -122.39747874957) 12 2 9 28855 6
105981 106036 Permitted Site 7 Ceratonia siliqua :: Carob 5 195X Main St 5 Sidewalk: Curb side : Cutout Tree Private 2   02/05/2015 12:00:00 AM   3x3 Permit Number 770222 6014366.74772 2116104.57878 37.7912273690908 -122.394174082061 (37.7912273690908, -122.394174082061) 12 2 9 28855 6
113987 189951 DPW Maintained 1 Ceratonia siliqua :: Carob 5 120 Howard St 5 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 1ft   6014728.34644 2116051.81938 37.7911025958469 -122.392919257911 (37.7911025958469, -122.392919257911) 12 2 9 28855 6
144602 189930 DPW Maintained 1 Ceratonia siliqua :: Carob 5 43 Fremont St 5 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 5ft   6013282.15015 2116252.99602 37.7915745438725 -122.397937200642 (37.7915745438725, -122.397937200642) 12 2 9 28855 6
156238 189936 DPW Maintained 1 Ceratonia siliqua :: Carob 5 28 Fremont St 5 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 5ft   6013261.48411 2116177.89779 37.7913671907995 -122.398003434816 (37.7913671907995, -122.398003434816) 12 2 9 28855 6
158873 97183 Undocumented 4 Ceratonia siliqua :: Carob 5 10X Fremont St 5 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
186270 119739 DPW Maintained 1 Ceratonia siliqua :: Carob 5 45 Fremont St 5 Sidewalk: Curb side : Cutout Tree Private 2     8     6013469.82728 2116055.87494 37.7910437460335 -122.397274006392 (37.7910437460335, -122.397274006392) 12 2 9 28855 6

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