Street_Tree_List

Data source: data.sfgov.org

15 rows where qSiteInfo = 2 and qSpecies = 274

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qAddress, SiteOrder, DBH, PlotSize

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
33302 33302 203617 Undocumented 2 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 185 Castenada Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   5994473.17466 2100793.8774900003 37.7480623907666 -122.46189409053899 (37.7480623907666, -122.461894090539)
34354 34354 203616 Undocumented 2 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 185 Castenada Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   5994461.2194300005 2100782.80797 37.7480313083953 -122.46193462839199 (37.7480313083953, -122.461934628392)
42665 42665 203612 Undocumented 2 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 1675 15th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 3ft   5991397.55944 2103884.0392299998 37.7563696263767 -122.472754630933 (37.7563696263767, -122.472754630933)
53131 53131 203609 Undocumented 2 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 120 Quintara St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 3ft   5993075.95674 2101213.4251599996 37.7491338250612 -122.46675607013901 (37.7491338250612, -122.466756070139)
53899 53899 175227 Undocumented 2 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 225 Naylor St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 6ft   6002635.08266 2086756.92621 37.709986599863 -122.43266799554199 (37.709986599863, -122.432667995542)
58808 58808 203618 Undocumented 2 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 185 Castenada Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   5994486.24709 2100807.40007 37.74810027292239 -122.461849867291 (37.7481002729224, -122.461849867291)
59797 59797 120754 Undocumented 2 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 25 20th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1     5989551.609019999 2114996.4613099997 37.7867742543083 -122.47995167641301 (37.7867742543083, -122.479951676413)
68151 68151 203613 Undocumented 2 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 1762 14th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 3ft   5991879.53156 2103437.46302 37.755171333717 -122.471055286375 (37.755171333717, -122.471055286375)
69004 69004 175219 Undocumented 2 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 100 Morse St 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 1ft   6000840.49126 2087951.89335 37.7131657752649 -122.43895601391199 (37.7131657752649, -122.438956013912)
131651 131651 189235 Undocumented 2 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 1634 Jerrold Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 5ft   6015126.7090300005 2097207.07467 37.7393811514086 -122.390223786492 (37.7393811514086, -122.390223786492)
146524 146524 189229 Undocumented 2 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 1459 Rhode Island St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1     6012049.051519999 2101579.4163599997 37.7512154759161 -122.40117218884899 (37.7512154759161, -122.401172188849)
156150 156150 203608 Undocumented 2 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 2007 15th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 3ft   5991583.6607 2101714.46197 37.7504233054064 -122.471952911395 (37.7504233054064, -122.471952911395)
161097 161097 125566 Undocumented 2 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 2809 Buchanan St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 4ft   6003481.18787 2118079.55095 37.7960390779962 -122.431978879228 (37.7960390779962, -122.431978879228)
174756 174756 203615 Undocumented 2 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 240 Colon Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   5996037.383230001 2094398.48179 37.7305921283128 -122.45602285758899 (37.7305921283128, -122.456022857589)
176692 176692 203607 Undocumented 2 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 2007 15th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 3ft   5991582.5756 2101730.87003 37.750468294886296 -122.471957859468 (37.7504682948863, -122.471957859468)

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