Street_Tree_List

Data source: data.sfgov.org

8 rows where qAddress = "100 Alemany Blvd", qSiteInfo = 2 and qSpecies = 48

View and edit SQL

Suggested facets: DBH

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
33343 227094 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 100 Alemany Blvd 35 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2     6009153.630890001 2095762.56962 37.7350817355269 -122.410774146024 (37.7350817355269, -122.410774146024)
33605 227093 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 100 Alemany Blvd 31 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 9ft   6009184.481319999 2095791.0539799999 37.7351616771725 -122.41066949551201 (37.7351616771725, -122.410669495512)
41197 227088 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 100 Alemany Blvd 12 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 5ft   6009533.30641 2096029.17809 37.7358350661275 -122.409480276115 (37.7358350661275, -122.409480276115)
59198 227086 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 100 Alemany Blvd 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 5ft   6009619.77164 2096165.8193400002 37.7362150980513 -122.409190969587 (37.7362150980513, -122.409190969587)
134809 227089 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 100 Alemany Blvd 17 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 4ft   6009456.29094 2095946.4902299999 37.735603707435395 -122.409740715285 (37.7356037074354, -122.409740715285)
170337 227090 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 100 Alemany Blvd 22 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 3ft   6009411.625 2095915.20486 37.7355153013828 -122.40989293540702 (37.7355153013828, -122.409892935407)
171127 227091 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 100 Alemany Blvd 29 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 5ft   6009293.034440001 2095834.7354700002 37.735287702767 -122.410297269721 (37.735287702767, -122.410297269721)
171469 227092 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 100 Alemany Blvd 30 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 9ft   6009197.49082 2095788.0482299998 37.7351541534232 -122.410624304588 (37.7351541534232, -122.410624304588)

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 2165.997ms · Data source: data.sfgov.org