trees

11 rows where Neighborhoods (old) = 11 and qCaretaker_id = 4 sorted by qCareAssistant

✎ View and edit SQL

This data as json, CSV (advanced)

These facets timed out: Neighborhoods (old)

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)
297 113036 DPW Maintained 1 Tree(s) :: 17 242X 07TH AVE 1 Sidewalk: Curb side : Cutout Tree SFUSD 4       3x3   5993686 2113852 37.7838712122002 -122.46556459896 (37.7838712122002, -122.46556459896) 11 6 2 54 11
1119 113031 DPW Maintained 1 Quercus suber :: Cork Oak 78 251 06th Ave 2 Sidewalk: Curb side : Cutout Tree SFUSD 4     14 3x3   5993971.49407 2113867.66105 37.7839306754778 -122.464578040665 (37.7839306754778, -122.464578040665) 11 6 2 54 11
10723 113037 DPW Maintained 1 Tree(s) :: 17 242X 07TH AVE 2 Sidewalk: Curb side : Cutout Tree SFUSD 4       3x3   5993686 2113852 37.7838712122002 -122.46556459896 (37.7838712122002, -122.46556459896) 11 6 2 54 11
16772 113034 DPW Maintained 1 Geijera parviflora :: Australian Willow 25 251 06th Ave 5 Sidewalk: Curb side : Cutout Tree SFUSD 4     2 3x3   5993975.1139 2113804.1265 37.7837564355183 -122.464560902617 (37.7837564355183, -122.464560902617) 11 6 2 54 11
18625 113033 DPW Maintained 1 Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 251 06th Ave 4 Sidewalk: Curb side : Cutout Tree SFUSD 4     14 3x3   5993974.82941 2113822.74411 37.7838075380241 -122.464563239136 (37.7838075380241, -122.464563239136) 11 6 2 54 11
19099 113032 DPW Maintained 1 Aesculus x carnea 'Briotii' :: Ruby Horse Chestnut 205 251 06th Ave 3 Sidewalk: Curb side : Cutout Tree SFUSD 4     3 3x3   5993973.41927 2113841.38508 37.7838586397785 -122.464569471656 (37.7838586397785, -122.464569471656) 11 6 2 54 11
75199 113039 DPW Maintained 1 Tree(s) :: 17 242X 07TH AVE 4 Sidewalk: Curb side : Cutout Tree SFUSD 4       3x3   5993686 2113852 37.7838712122002 -122.46556459896 (37.7838712122002, -122.46556459896) 11 6 2 54 11
83242 113035 DPW Maintained 1 Acer buergeranum :: Trident Maple 110 251 06th Ave 6 Sidewalk: Curb side : Cutout Tree SFUSD 4     1 3x3   5993975.80165 2113783.25834 37.7836991768592 -122.464557007516 (37.7836991768592, -122.464557007516) 11 6 2 54 11
89046 113040 DPW Maintained 1 Tree(s) :: 17 242X 07TH AVE 5 Sidewalk: Curb side : Cutout Tree SFUSD 4       3x3   5993686 2113852 37.7838712122002 -122.46556459896 (37.7838712122002, -122.46556459896) 11 6 2 54 11
124230 107423 DPW Maintained 1 Acer buergeranum :: Trident Maple 110 251 06th Ave 1 Sidewalk: Curb side : Cutout Tree SFUSD 4     2 3x3   5993968.46376 2113916.3836 37.7840642796834 -122.464592063385 (37.7840642796834, -122.464592063385) 11 6 2 54 11
144986 113038 DPW Maintained 1 Tree(s) :: 17 242X 07TH AVE 3 Sidewalk: Curb side : Cutout Tree SFUSD 4       3x3   5993686 2113852 37.7838712122002 -122.46556459896 (37.7838712122002, -122.46556459896) 11 6 2 54 11

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