11 rows where qCaretaker_id = 3 and qLegalStatus_id = 1 sorted by PermitNotes

View and edit SQL

qLegalStatus_id

  • DPW Maintained · 11
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)
22616 116522 DPW Maintained 1 Myoporum laetum :: Myoporum 62 324 08TH AVE 1 Sidewalk: Property side : Cutout Tree MTA 3 DPW for City Agency   8 3x3   5993416 2113304 37.7823509768718 -122.466458848407 (37.7823509768718, -122.466458848407) 11 6 2 54 11
52322 121200 DPW Maintained 1 Corymbia citriodora :: Lemon Scented Gum 384 423 18th Ave 1 Sidewalk: Curb side : Cutout Tree MTA 3       3x3   5990242 2112483 37.7799130778564 -122.477379347216 (37.7799130778564, -122.477379347216) 11 6 2 55 26
55724 106212 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 585X Bush St 5 Sidewalk: Curb side : Cutout Tree MTA 3     12 3x5   6010752.41967 2115858.63176 37.7903505018262 -122.406662277468 (37.7903505018262, -122.406662277468) 5 1 10 28857 6
61507 116527 DPW Maintained 1 Olea europaea :: Olive Tree 9 5732 GEARY BLVD 1 Sidewalk: Curb side : Yard Tree MTA 3 DPW for City Agency     3x3   5989254 2112678 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646) 11 6 2 55 26
96584 106215 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 585X Bush St 3 Sidewalk: Curb side : Cutout Tree MTA 3     14 3x5   6010717.90235 2115854.24398 37.7903365227737 -122.406781396238 (37.7903365227737, -122.406781396238) 5 1 10 28857 6
117321 106216 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 585X Bush St 2 Sidewalk: Curb side : Cutout Tree MTA 3     10 3x5   6010698.10573 2115852.22595 37.7903298740626 -122.406849749212 (37.7903298740626, -122.406849749212) 5 1 10 28857 6
141285 120542 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2450 California St 1 Front Yard : Yard Tree MTA 3 DPW for City Agency         6002644.10897 2115479.97736 37.7888538273233 -122.434689351726 (37.7888538273233, -122.434689351726) 13 9 1 29490 27
156649 251254 DPW Maintained 1 Crataegus laevigata :: English Hawthorn 133 330 09th Ave 1 unknown : Cutout Tree MTA 3       3x3   5993109 2113253 37.7821932251036 -122.467517213871 (37.7821932251036, -122.467517213871) 11 6 2 54 11
161345 106209 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 585X Bush St 7 Sidewalk: Curb side : Cutout Tree MTA 3     16 3x16   6010847.77195 2115873.69146 37.7903971865333 -122.406333425049 (37.7903971865333, -122.406333425049) 5 1 10 28857 6
178661 121201 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 423 18th Ave 2 Sidewalk: Curb side : Cutout Tree MTA 3       3x3   5990242 2112483 37.7799130778564 -122.477379347216 (37.7799130778564, -122.477379347216) 11 6 2 55 26
179300 106217 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 585X Bush St 1 Sidewalk: Curb side : Cutout Tree MTA 3     10 3x5   6010670.9358 2115847.83327 37.7903162925068 -122.406943445993 (37.7903162925068, -122.406943445993) 5 1 10 28857 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)
);