Street_Tree_List

Data source: data.sfgov.org

12 rows where qSiteInfo = 7 and qSpecies = 110

View and edit SQL

Suggested facets: qLegalStatus, qAddress, SiteOrder, DBH, PlotSize, XCoord, YCoord, Latitude, Longitude, Location

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
1686 251474 Undocumented 2 Pittosporum eugenioides :: Tarata 110 151 32nd Ave 2 Front Yard : Yard 7 Tree 1 Private 1   05/30/2017 12:00:00 AM 3 3x3 Permit Number 779951 5985659.0 2114437.0 37.78501121016021 -122.493377758762 (37.7850112101602, -122.493377758762)
1694 251475 Undocumented 2 Pittosporum eugenioides :: Tarata 110 151 32nd Ave 3 Front Yard : Yard 7 Tree 1 Private 1   05/30/2017 12:00:00 AM 3 3x3 Permit Number 779951 5985659.0 2114437.0 37.78501121016021 -122.493377758762 (37.7850112101602, -122.493377758762)
1712 251473 Undocumented 2 Pittosporum eugenioides :: Tarata 110 151 32nd Ave 1 Front Yard : Yard 7 Tree 1 Private 1   05/30/2017 12:00:00 AM 3 3x3 Permit Number 779951 5985659.0 2114437.0 37.78501121016021 -122.493377758762 (37.7850112101602, -122.493377758762)
33032 247630 Undocumented 2 Pittosporum eugenioides :: Tarata 110 286 Bradford St 5 Front Yard : Yard 7 Tree 1 Private 1     7     6009492.89578 2096949.07994 37.738358653736206 -122.409684901541 (37.7383586537362, -122.409684901541)
40834 247628 Undocumented 2 Pittosporum eugenioides :: Tarata 110 286 Bradford St 3 Front Yard : Yard 7 Tree 1 Private 1     9     6009493.85882 2096962.27736 37.738394944962394 -122.409682503062 (37.7383949449624, -122.409682503062)
41441 247627 Undocumented 2 Pittosporum eugenioides :: Tarata 110 286 Bradford St 2 Front Yard : Yard 7 Tree 1 Private 1     9     6009494.8200900005 2096968.4162599999 37.7384118549208 -122.40967961262699 (37.7384118549208, -122.409679612627)
52897 132364 Undocumented 2 Pittosporum eugenioides :: Tarata 110 1 Maple St 1 Front Yard : Yard 7 Tree 1 Private 1     13     5996506.6886 2116107.7681400003 37.7902272326358 -122.455969252601 (37.7902272326358, -122.455969252601)
57300 132363 Undocumented 2 Pittosporum eugenioides :: Tarata 110 1 Maple St 2 Front Yard : Yard 7 Tree 1 Private 1     19     5996514.49254 2116105.13934 37.7902204625654 -122.455942061589 (37.7902204625654, -122.455942061589)
74523 194587 Undocumented 2 Pittosporum eugenioides :: Tarata 110 37 Maddux Ave 1 Front Yard : Yard 7 Tree 1 Private 1     3 Width 9ft   6012781.54528 2095521.68187 37.7346230570026 -122.398214166653 (37.7346230570026, -122.398214166653)
97714 102073 Significant Tree 6 Pittosporum eugenioides :: Tarata 110 273 Magellan Ave 3 Front Yard : Yard 7 Tree 1 Private 1           5994674.1 2100293.4 37.7466997707371 -122.461163031194 (37.7466997707371, -122.461163031194)
155600 247629 Undocumented 2 Pittosporum eugenioides :: Tarata 110 286 Bradford St 4 Front Yard : Yard 7 Tree 1 Private 1     12     6009493.3855 2096955.4623099999 37.738376205786096 -122.409683658684 (37.7383762057861, -122.409683658684)
174774 247626 Undocumented 2 Pittosporum eugenioides :: Tarata 110 286 Bradford St 1 Front Yard : Yard 7 Tree 1 Private 1     8     6009494.96271 2096975.4044400002 37.7384310509429 -122.40967961262501 (37.7384310509429, -122.409679612625)

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