Street_Tree_List

Data source: data.sfgov.org

10 rows where DBH = 5 and qSpecies = 110

View and edit SQL

Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, PlotSize

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
25630 194576 Undocumented 2 Pittosporum eugenioides :: Tarata 110 572 Missouri St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     5 Width 4ft   6013508.15849 2104424.13067 37.7591077391483 -122.396325765734 (37.7591077391483, -122.396325765734)
46330 178393 Undocumented 2 Pittosporum eugenioides :: Tarata 110 73 Capistrano Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5     6001400.33163 2093764.0907400001 37.729156597198795 -122.437436967259 (37.7291565971988, -122.437436967259)
69150 194582 Undocumented 2 Pittosporum eugenioides :: Tarata 110 618 Missouri St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     5 Width 4ft   6013519.11255 2104217.1828099997 37.7585401149596 -122.39627337661001 (37.7585401149596, -122.39627337661)
93214 132388 Undocumented 2 Pittosporum eugenioides :: Tarata 110 1468 Greenwich St 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 2ft   6005798.70292 2119672.07683 37.800542860316 -122.424073122581 (37.800542860316, -122.424073122581)
100796 64213 Permitted Site 1 Pittosporum eugenioides :: Tarata 110 1625 Carroll Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/15/1988 12:00:00 AM 5   Permit Number 25004 6013920.481000001 2092092.5018 37.7252706002708 -122.39403647132099 (37.7252706002708, -122.394036471321)
130991 211451 Undocumented 2 Pittosporum eugenioides :: Tarata 110 151 Lippard Ave 12 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6001863.37782 2095280.7937599998 37.7333474307441 -122.435944662819 (37.7333474307441, -122.435944662819)
135796 233974 Undocumented 2 Pittosporum eugenioides :: Tarata 110 2315 15th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6002049.59534 2107034.31873 37.7656303987394 -122.436141661111 (37.7656303987394, -122.436141661111)
166409 187083 Undocumented 2 Pittosporum eugenioides :: Tarata 110 2600 Sunset Blvd 19 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 0ft   5985170.5104 2097012.8962 37.7371408955553 -122.49378330233499 (37.7371408955553, -122.493783302335)
177634 132387 Undocumented 2 Pittosporum eugenioides :: Tarata 110 1468 Greenwich St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 2ft   6005806.0966 2119662.42569 37.8005167781868 -122.424046850703 (37.8005167781868, -122.424046850703)
179351 211452 Undocumented 2 Pittosporum eugenioides :: Tarata 110 151 Lippard Ave 14 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6001868.44075 2095314.06759 37.7334390806456 -122.435929538915 (37.7334390806456, -122.435929538915)

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