trees

14 rows where SiteOrder = 1, qLegalStatus_id = 4 and qSpecies_id = 5

✎ View and edit SQL

This data as json, CSV (advanced)

qLegalStatus_id ✖

  • Undocumented · 14 ✖

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)
12569 111886 Undocumented 4 Ceratonia siliqua :: Carob 5 140 LUNDYS LN 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x12   6006709 2098750 37.7431471814186 -122.41943799965 (37.7431471814186, -122.41943799965) 2 7 7 28859 2
17663 101489 Undocumented 4 Ceratonia siliqua :: Carob 5 59X Waller St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/26/2012 12:00:00 AM 1 3x3 Permit Number 769087 6005416.7 2109221 37.7718252244657 -122.424651142233 (37.7718252244657, -122.424651142233) 7 9 5 28852 10
24818 97179 Undocumented 4 Ceratonia siliqua :: Carob 5 10X Fremont St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   6013408 2116114 37.7911999015077 -122.397492006217 (37.7911999015077, -122.397492006217) 12 2 9 28855 6
37802 119741 Undocumented 4 Ceratonia siliqua :: Carob 5 15X Fremont St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013411 2116073 37.7910874921548 -122.39747874957 (37.7910874921548, -122.39747874957) 12 2 9 28855 6
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
41358 115360 Undocumented 4 Ceratonia siliqua :: Carob 5 205 ARKANSAS ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x4   6012944 2106057 37.7635598294353 -122.398391479388 (37.7635598294353, -122.398391479388) 14 3 8 28856 29
63652 104633 Undocumented 4 Ceratonia siliqua :: Carob 5 850 Florida St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 3x3   6009360 2104224 37.7583265252915 -122.410657998143 (37.7583265252915, -122.410657998143) 2 4 7 28859 19
82931 110183 Undocumented 4 Ceratonia siliqua :: Carob 5 1500x LYON ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5999718 2114083 37.7848515388794 -122.444712796347 (37.7848515388794, -122.444712796347) 15 6 1 29490 31
86582 105449 Undocumented 4 Ceratonia siliqua :: Carob 5 890 Alabama St 1 Sidewalk: Curb side : Cutout Tree Private 2           6009082.7 2103985.1 37.7576550089679 -122.411600148106 (37.7576550089679, -122.411600148106) 2 4 7 28859 19
97684 115557 Undocumented 4 Ceratonia siliqua :: Carob 5 2500x 19TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010357 2105131 37.7608727909959 -122.407273854716 (37.7608727909959, -122.407273854716) 10 4 8 28859 19
99949 96852 Undocumented 4 Ceratonia siliqua :: Carob 5 1x Bennington St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   6007194 2097789 37.7405357947447 -122.417692894396 (37.7405357947447, -122.417692894396) 2 7 7 28859 2
135947 225081 Undocumented 4 Ceratonia siliqua :: Carob 5 181 College Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6004907.37106 2095955.144 37.7353714997996 -122.425468699532 (37.7353714997996, -122.425468699532) 2 7 5 28861 2
164683 112815 Undocumented 4 Ceratonia siliqua :: Carob 5 10 LOMITA AVE 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5991472 2104830 37.7589712942358 -122.472566156736 (37.7589712942358, -122.472566156736) 1 8 4 56 12
174101 113692 Undocumented 4 Ceratonia siliqua :: Carob 5 112 LUNDYS LN 1 Sidewalk: Curb side : Cutout Tree Private 2     14 3x3   6006814 2098928 37.7436418429474 -122.419087559811 (37.7436418429474, -122.419087559811) 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)
);