Street_Tree_List

Data source: data.sfgov.org

12 rows where DBH = 7 and qSpecies = 178

View and edit SQL

Suggested facets: qAddress, SiteOrder, qSiteInfo, PlotSize

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
60455 197870 Undocumented 2 Syzygium australe :: Eugenia 178 2054 Bancroft Ave 2 : 4 Tree 1 Private 1     7 Width 3ft   6011861.46981 2094041.32078 37.7305070020886 -122.40129120152201 (37.7305070020886, -122.401291201522)
71389 197840 Undocumented 2 Syzygium australe :: Eugenia 178 1600 Bay Shore Blvd 34 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 6ft   6011997.53285 2091285.37995 37.722947345938394 -122.40062728242701 (37.7229473459384, -122.400627282427)
134275 197826 Undocumented 2 Syzygium australe :: Eugenia 178 1600 Bay Shore Blvd 17 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 6ft   6011969.15818 2091380.8270900003 37.7232078417381 -122.40073207055401 (37.7232078417381, -122.400732070554)
135806 215188 Undocumented 2 Syzygium australe :: Eugenia 178 22 Bella Vista Way 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 3ft   5998661.30114 2097007.17978 37.7379052515319 -122.447139286971 (37.7379052515319, -122.447139286971)
147228 215187 Undocumented 2 Syzygium australe :: Eugenia 178 22 Bella Vista Way 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 3ft   5998692.53986 2096988.45855 37.73785563233479 -122.447029932992 (37.7378556323348, -122.447029932992)
156996 197834 Undocumented 2 Syzygium australe :: Eugenia 178 1600 Bay Shore Blvd 27 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 6ft   6011984.73293 2091325.2723299998 37.723056168383295 -122.400674330476 (37.7230561683833, -122.400674330476)
159659 197869 Undocumented 2 Syzygium australe :: Eugenia 178 2054 Bancroft Ave 1 : 4 Tree 1 Private 1     7 Width 3ft   6011879.19718 2094028.42087 37.7304725706398 -122.401229008914 (37.7304725706398, -122.401229008914)
160157 197849 Undocumented 2 Syzygium australe :: Eugenia 178 1600 Bay Shore Blvd 45 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 6ft   6012013.93234 2091229.80813 37.722795671678796 -122.400566690598 (37.7227956716788, -122.400566690598)
169923 197898 Undocumented 2 Syzygium australe :: Eugenia 178 1951 Revere Ave 7 Front Yard : Yard 7 Tree 1 Private 1     7     6013046.295390001 2095878.4741200001 37.73561747786479 -122.397323842332 (37.7356174778648, -122.397323842332)
173247 241006 Undocumented 2 Syzygium australe :: Eugenia 178 47 Fair Oaks St 3 : 4 Tree 1 Private 1     7 Width 3ft   6005404.68806 2103428.4657 37.755919620906404 -122.42428064113301 (37.7559196209064, -122.424280641133)
182350 197823 Undocumented 2 Syzygium australe :: Eugenia 178 1600 Bay Shore Blvd 8 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 6ft   6011949.3976 2091439.17555 37.723366952515995 -122.400804476766 (37.723366952516, -122.400804476766)
188673 197836 Undocumented 2 Syzygium australe :: Eugenia 178 1600 Bay Shore Blvd 29 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 6ft   6011988.43693 2091314.7241 37.7230274116816 -122.40066078576099 (37.7230274116816, -122.400660785761)

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