trees

16 rows where Neighborhoods (old) = 14, qSiteInfo = "Sidewalk: Curb side : Yard" and qSpecies_id = 35

✎ 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)
267 178174 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 0 Gonzalez Dr 5 Sidewalk: Curb side : Yard Tree Private 2     2     5988358.3694 2089791.63303 37.717499145949 -122.482232652541 (37.717499145949, -122.482232652541) 1 8 4 64 14
19643 105261 Undocumented 4 Pinus canariensis :: Canary Island Pine 35 619 GONZALEZ DR   Sidewalk: Curb side : Yard Tree Private 2     3     5988914.8 2089258.8 37.7160684695332 -122.48027037241 (37.7160684695332, -122.48027037241) 1 8 4 64 14
23338 114378 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 842X GONZALEZ DR 3 Sidewalk: Curb side : Yard Tree Private 2     2     5988421 2089827 37.7175998975755 -122.482018759302 (37.7175998975755, -122.482018759302) 1 8 4 64 14
53879 114377 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 842X GONZALEZ DR 2 Sidewalk: Curb side : Yard Tree Private 2     2     5988421 2089827 37.7175998975755 -122.482018759302 (37.7175998975755, -122.482018759302) 1 8 4 64 14
63516 178176 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 0 Gonzalez Dr 3 Sidewalk: Curb side : Yard Tree Private 2     3     5989163.89955 2089384.56057 37.7164282485354 -122.479418571325 (37.7164282485354, -122.479418571325) 1 8 4 64 14
78181 98278 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 900 Brotherhood Way 500 Sidewalk: Curb side : Yard Tree Private 2   02/07/2012 12:00:00 AM     Permit Number 768594 5988860.9 2088745.5 37.7146559434524 -122.480419123791 (37.7146559434524, -122.480419123791) 1 8 4 64 14
82197 114371 Undocumented 4 Pinus canariensis :: Canary Island Pine 35 821 GONZALEZ DR 2 Sidewalk: Curb side : Yard Tree Private 2     2     5988453 2089765 37.7174315222235 -122.481903612061 (37.7174315222235, -122.481903612061) 1 8 4 64 14
93553 178171 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 0 Gonzalez Dr 8 Sidewalk: Curb side : Yard Tree Private 2     2     5988123.04078 2089845.83927 37.7176342915553 -122.483050036443 (37.7176342915553, -122.483050036443) 1 8 4 64 14
95623 178173 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 0 Gonzalez Dr 4 Sidewalk: Curb side : Yard Tree Private 2     2     5988347.73388 2089792.82325 37.717501795356 -122.482269501364 (37.717501795356, -122.482269501364) 1 8 4 64 14
128412 105268 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 842X GONZALEZ DR 1 Sidewalk: Curb side : Yard Tree Private 2     2     5988421 2089827 37.7175998975755 -122.482018759302 (37.7175998975755, -122.482018759302) 1 8 4 64 14
136696 98279 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 900 Brotherhood Way 501 Sidewalk: Curb side : Yard Tree Private 2   02/07/2012 12:00:00 AM     Permit Number 768594 5988860.9 2088745.5 37.7146559434524 -122.480419123791 (37.7146559434524, -122.480419123791) 1 8 4 64 14
137776 178172 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 0 Gonzalez Dr 7 Sidewalk: Curb side : Yard Tree Private 2     2     5988133.68649 2089845.13121 37.7176329668754 -122.483013187625 (37.7176329668754, -122.483013187625) 1 8 4 64 14
144446 178170 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 0 Serrano Dr 4 Sidewalk: Curb side : Yard Tree Private 2     4     5989035.58475 2090454.34239 37.7193581480518 -122.479940326497 (37.7193581480518, -122.479940326497) 1 8 4 64 14
161266 114370 Undocumented 4 Pinus canariensis :: Canary Island Pine 35 821 GONZALEZ DR 1 Sidewalk: Curb side : Yard Tree Private 2     2     5988453 2089765 37.7174315222235 -122.481903612061 (37.7174315222235, -122.481903612061) 1 8 4 64 14
163611 114372 Undocumented 4 Pinus canariensis :: Canary Island Pine 35 821 GONZALEZ DR 3 Sidewalk: Curb side : Yard Tree Private 2     3     5988453 2089765 37.7174315222235 -122.481903612061 (37.7174315222235, -122.481903612061) 1 8 4 64 14
170489 178175 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 0 Gonzalez Dr 2 Sidewalk: Curb side : Yard Tree Private 2     6     5989026.35056 2089515.50206 37.7167797908382 -122.47990357931 (37.7167797908382, -122.47990357931) 1 8 4 64 14

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