trees

14 rows where SiteOrder = 5, Supervisor Districts = 9 and qSpecies_id = 5

✎ View and edit SQL

This data as json, CSV (advanced)

Supervisor Districts ✖

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)
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
14738 103343 Undocumented 4 Ceratonia siliqua :: Carob 5 590X 09th St 5 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6010323 2108639 37.7705030566796 -122.407638793146 (37.7705030566796, -122.407638793146) 8 2 9 28853 34
60927 189962 DPW Maintained 1 Ceratonia siliqua :: Carob 5 562 09th St 5 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6010439.90597 2108494.60457 37.7701131234445 -122.407224232334 (37.7701131234445, -122.407224232334) 8 2 9 28853 34
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
89800 188471 DPW Maintained 1 Ceratonia siliqua :: Carob 5 255 12th St 5 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 5ft   6008055.90153 2108933.51614 37.7711845613454 -122.415501579828 (37.7711845613454, -122.415501579828) 8 2 9 28853 19
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
124477 189963 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1000 Brannan St 5 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6010349.36768 2108372.96344 37.7697740574441 -122.40752882731 (37.7697740574441, -122.40752882731) 8 2 9 28853 34
136547 22889 Permitted Site 7 Ceratonia siliqua :: Carob 5 95X Valencia St 5 Sidewalk: Curb side : Cutout Tree Private 2     30 3X3   6006042.93395 2109155.55847 37.7716808854236 -122.422480302267 (37.7716808854236, -122.422480302267) 8 2 9 28853 19
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)
);