6 rows where SiteOrder = 2 and qCaretaker_id = 15

View and edit SQL

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)
34585 104280 Significant Tree 6 Tree(s) :: 17 150X Middle Point Rd 2 Front Yard : Yard Tree Housing Authority 15   09/17/2013 12:00:00 AM     Permit Number 770341 6018215 2095138 37.7338706954973 -122.379402036794 (37.7338706954973, -122.379402036794) 10 3 8 58 1
58440 112748 Undocumented 4 Magnolia grandiflora :: Southern Magnolia 19 135X TRENTON ST 2 Sidewalk: Curb side : Cutout Tree Housing Authority 15 Private     3x3   6009947 2118097 37.7964514227226 -122.409607037418 (37.7964514227226, -122.409607037418) 3 1 10 308 4
85966 112510 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 699x WILLOW ST 2 Sidewalk: Curb side : Cutout Tree Housing Authority 15 DPW     2x2   6004423 2113018 37.7821946822097 -122.42835909049 (37.7821946822097, -122.42835909049) 7 9 11 29490 41
140018 98738 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1150 Scott St 2 Sidewalk: Curb side : Cutout Tree Housing Authority 15 DPW for City Agency   3 4X4   6001885.6171 2112431.4484 37.7804402546102 -122.437095273073 (37.7804402546102, -122.437095273073) 15 5 11 29490 41
148170 95362 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 775X Broadway 2 Sidewalk: Curb side : Cutout Tree Housing Authority 15 DPW for City Agency     3x3 Permit Number 778058 6009884 2118395.5 37.7972675002992 -122.409846113399 (37.7972675002992, -122.409846113399) 3 1 10 308 4
155752 115341 Undocumented 4 Pyrus calleryana :: Ornamental Pear 44 1514 SUNNYDALE AVE 2 Sidewalk: Property side : Yard Tree Housing Authority 15 Private     3x3   6006572 2087815 37.7131143345755 -122.419136228821 (37.7131143345755, -122.419136228821) 9 7 8 309 39

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