18 rows where SiteOrder = 2 and qCaretaker_id = 3 sorted by qCareAssistant

View and edit SQL

Suggested facets: qLegalStatus_id, qSiteInfo, DBH, PlotSize, YCoord, Longitude, Fire Prevention Districts, Police Districts, Supervisor Districts, Neighborhoods (old)

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)
23271 91828 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1941 Harrison St 2 Sidewalk: Curb side : Cutout Tree MTA 3   03/07/2007 12:00:00 AM 3 3x3   6008705.970676 2107189.131 37.7664314036014 -122.413129591178 (37.7664314036014, -122.413129591178) 8 4 7 28853 19
32937 178336 Significant Tree 6 Pinus radiata :: Monterey Pine 15 401 Ocean Ave 2 Sidewalk: Property side : Yard Tree MTA 3     29 Width 8ft   5998664.9682 2091522.93582 37.7228470175482 -122.44673211619 (37.7228470175482, -122.44673211619) 9 7 6 28861 25
34419 116605 Undocumented 4 Ficus Spp. :: 101 1325x 08TH AVE 2 Front Yard : Yard Tree MTA 3           5993613 2106469 37.7635952548206 -122.465280685608 (37.7635952548206, -122.465280685608) 1 8 11 56 12
43658 116348 Undocumented 4 Callistemon viminalis :: Weeping Bottlebrush 60 4051X 24TH ST 2 Sidewalk: Curb side : Cutout Tree MTA 3       3x3   6002850 2101803 37.7513118941202 -122.432999456035 (37.7513118941202, -122.432999456035) 2 4 5 28862 22
44800 120594 Significant Tree 6 Pinus radiata :: Monterey Pine 15 499x Ocean Ave 2 Sidewalk: Curb side : Cutout Tree MTA 3       3x3   5998874 2091543 37.7229140478676 -122.446010982458 (37.7229140478676, -122.446010982458) 9 7 6 28861 25
105476 120996 Undocumented 4 Ficus nitida :: Laurel Fig 53 352 SUTTER ST 2 Sidewalk: Curb side : Cutout Tree MTA 3       3x5   6010871.2 2115571.1 37.789567653219 -122.406231036885 (37.789567653219, -122.406231036885) 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
124516 112376 Significant Tree 6 Eucalyptus sideroxylon :: Red Ironbark 127 801 ULLOA ST 2 Sidewalk: Curb side : Cutout Tree MTA 3     24     5993401 2098089 37.7405736985828 -122.465405140197 (37.7405736985828, -122.465405140197) 1 8 4 59 40
145690 116607 Undocumented 4 Ficus Spp. :: 101 1325x 08TH AVE 2 Sidewalk: Curb side : Cutout Tree MTA 3       3x3   5993613 2106469 37.7635952548206 -122.465280685608 (37.7635952548206, -122.465280685608) 1 8 11 56 12
154580 224422 Property Tree 8 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3255x 24th St 2 Front Yard : Cutout Tree MTA 3     16 Width 3ft   6007298 2102020 37.7521590216883 -122.417633107694 (37.7521590216883, -122.417633107694) 2 4 7 28859 19
156193 27437 Permitted Site 7 Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 1690X Indiana St 2 Sidewalk: Curb side : Cutout Tree MTA 3     6 4X4   6015146.8447845 2100681.5042352 37.7489223309609 -122.390396861105 (37.7489223309609, -122.390396861105) 10 3 8 58 1
159297 106225 Undocumented 4 Ficus nitida :: Laurel Fig 53 340 SUTTER ST 2 Sidewalk: Curb side : Cutout Tree MTA 3     22 3x5   6010923.2 2115578.3 37.7895903312377 -122.406051628897 (37.7895903312377, -122.406051628897) 5 1 10 28857 6
173056 122420 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 2200 San Jose Ave 2 Sidewalk: Curb side : Cutout Tree MTA 3       3x3   5998886 2091075 37.7216297132481 -122.445935857536 (37.7216297132481, -122.445935857536) 9 7 6 28861 25
178605 25402 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 495X Geneva Ave 2 Sidewalk: Curb side : Cutout Tree MTA 3   06/28/1996 12:00:00 AM 6 3X3   5998682.3051661 2090785.318168 37.7208226804469 -122.446619141783 (37.7208226804469, -122.446619141783) 9 7 6 28861 25
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
416 116621 Undocumented 4 Olea europaea :: Olive Tree 9 5732X GEARY BLVD 2 Front Yard : Cutout Tree MTA 3 DPW     3x3   5989254 2112678 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646) 11 6 2 55 26
6915 116579 Significant Tree 6 Shrub :: Shrub 66 3000x 19TH AVE 2 Sidewalk: Property side : Cutout Tree MTA 3 DPW     3x3   5990602 2095184 37.7324354869182 -122.47487091251 (37.7324354869182, -122.47487091251) 1 8 4 64 40
136506 173630 Significant Tree 6 Myoporum laetum :: Myoporum 62 2699x OCEAN AVE 2 Sidewalk: Property side : Cutout Tree MTA 3 DPW     3x3   5990602 2095184 37.7324354869182 -122.47487091251 (37.7324354869182, -122.47487091251) 1 8 4 64 40

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