Street_Tree_List

Data source: data.sfgov.org

4 rows where DBH = 8, SiteOrder = 2 and qSpecies = 48

View and edit SQL

Suggested facets: qLegalStatus, PlotSize

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
35906 227555 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 4611 19th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6000604.66017 2104640.67953 37.7589758571809 -122.440967627376 (37.7589758571809, -122.440967627376)
55777 49803 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 101 Mississippi St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/11/2003 12:00:00 AM 8   Permit Number 46598 6014016.82872 2106570.58674 37.7650297307661 -122.394716845308 (37.7650297307661, -122.394716845308)
171343 83264 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 483 Paris St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/01/2009 12:00:00 AM 8 3x3 Permit Number 52321 6001958.211069999 2090814.3138299999 37.721088877137795 -122.43529742254 (37.7210888771378, -122.43529742254)
188753 129387 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 2507 Larkin St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6006679.63776 2119843.90732 37.801064360981606 -122.42103693222602 (37.8010643609816, -122.421036932226)

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" TEXT,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" TEXT,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");
Powered by Datasette · Query took 502.352ms · Data source: data.sfgov.org