trees

5 rows where PlotSize = "Width 0ft", SiteOrder = 2 and qSpecies_id = 48 sorted by qCaretaker_id

✎ View and edit SQL

This data as json, CSV (advanced)

SiteOrder ✖

PlotSize ✖

  • Width 0ft · 5 ✖
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)
4184 162705 DPW Maintained 1 Potential Site :: Potential Site 48 700 Grafton Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     0 Width 0ft   5994663.02021 2090597.39113 37.7200762701851 -122.460498876921 (37.7200762701851, -122.460498876921) 9 8 6 28861 24
17451 162712 DPW Maintained 1 Potential Site :: Potential Site 48 850 Grafton Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     0 Width 0ft   5994210.35674 2090607.81746 37.7200788467504 -122.462064325032 (37.7200788467504, -122.462064325032) 9 8 6 28861 24
17487 162702 DPW Maintained 1 Potential Site :: Potential Site 48 650 Grafton Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     0 Width 0ft   5994851.70364 2090594.06409 37.7200779878774 -122.459846425972 (37.7200779878774, -122.459846425972) 9 8 6 28861 24
20245 200985 Undocumented 4 Potential Site :: Potential Site 48 160 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft Permit Number 778623 6015097.3421 2115526.2135 37.7896798923825 -122.391605771311 (37.7896798923825, -122.391605771311) 6 2 9 28855 6
124371 200996 Undocumented 4 Potential Site :: Potential Site 48 150 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft Permit Number 778623 6015175.4889 2115602.3039 37.789893156498 -122.3913407103 (37.789893156498, -122.3913407103) 6 2 9 28855 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)
);