Street_Tree_List

Data source: data.sfgov.org

19 rows where qSpecies = 162

✎ View and edit SQL

This data as json, CSV (advanced)

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

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
1946 1946 252821 Undocumented 2 Nyssa sylvatica :: Tupelo: Sour Gum 162 47 Miramar Ave   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5995289.0 2090229.0 37.719100747698704 -122.45830844121001 (37.7191007476987, -122.45830844121)
4789 4789 194118 Undocumented 2 Nyssa sylvatica :: Tupelo: Sour Gum 162 211 12th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6007751.48529 2109108.49204 37.771647888463605 -122.4165669671 (37.7716478884636, -122.4165669671)
26414 26414 40062 Permitted Site 1 Nyssa sylvatica :: Tupelo: Sour Gum 162 1331 Thomas Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/19/1999 12:00:00 AM 6   Permit Number 41293 6016170.7214 2092854.0687 37.727486521935504 -122.38631061043101 (37.7274865219355, -122.386310610431)
28432 28432 194114 Undocumented 2 Nyssa sylvatica :: Tupelo: Sour Gum 162 2 13th St 6 : 4 Tree 1 Private 1     2 Width 3ft   6009067.7189 2108343.3728 37.7696209856481 -122.411959940815 (37.7696209856481, -122.411959940815)
30208 30208 210580 Undocumented 2 Nyssa sylvatica :: Tupelo: Sour Gum 162 32 Mesa Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 4ft   5993590.792219999 2100787.0036 37.7479926789146 -122.46494481215001 (37.7479926789146, -122.46494481215)
36888 36888 194115 Undocumented 2 Nyssa sylvatica :: Tupelo: Sour Gum 162 2 13th St 7 : 4 Tree 1 Private 1     2 Width 3ft   6009056.48967 2108344.30218 37.7696229074947 -122.411998848169 (37.7696229074947, -122.411998848169)
41588 41588 210581 Undocumented 2 Nyssa sylvatica :: Tupelo: Sour Gum 162 266 Judson Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 2ft   5998322.77395 2093563.5965599997 37.728430641036795 -122.448061863674 (37.7284306410368, -122.448061863674)
44734 44734 194113 Undocumented 2 Nyssa sylvatica :: Tupelo: Sour Gum 162 2 13th St 5 : 4 Tree 1 Private 1     2 Width 3ft   6009080.3965 2108344.51395 37.769624830241 -122.411916169919 (37.769624830241, -122.411916169919)
47194 47194 47777 Permitted Site 1 Nyssa sylvatica :: Tupelo: Sour Gum 162 1 19th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/11/2002 12:00:00 AM 6 3x3 Permit Number 45553 5989869.17177 2114959.89996 37.7866923120989 -122.478850321209 (37.7866923120989, -122.478850321209)
48091 48091 232430 Undocumented 2 Nyssa sylvatica :: Tupelo: Sour Gum 162 1229 Guerrero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6005825.0918 2101787.73808 37.7514382919622 -122.422710152378 (37.7514382919622, -122.422710152378)
60374 60374 210579 Undocumented 2 Nyssa sylvatica :: Tupelo: Sour Gum 162 32 Mesa Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 4ft   5993577.797809999 2100792.6997700003 37.7480075698936 -122.46499015956199 (37.7480075698936, -122.464990159562)
61638 61638 194110 Undocumented 2 Nyssa sylvatica :: Tupelo: Sour Gum 162 2 13th St 2 : 4 Tree 1 Private 1     2 Width 3ft   6009141.41153 2108337.31676 37.7696084913693 -122.4117046116 (37.7696084913693, -122.4117046116)
70394 70394 232429 Undocumented 2 Nyssa sylvatica :: Tupelo: Sour Gum 162 107 Lexington St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6006467.95168 2105419.9987 37.7614478884368 -122.420744897165 (37.7614478884368, -122.420744897165)
71723 71723 122091 Undocumented 2 Nyssa sylvatica :: Tupelo: Sour Gum 162 755 16th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5990971.02812 2110247.64122 37.7738176695196 -122.474694145175 (37.7738176695196, -122.474694145175)
75514 75514 194109 Undocumented 2 Nyssa sylvatica :: Tupelo: Sour Gum 162 2 13th St 1 : 4 Tree 1 Private 1     2 Width 3ft   6009168.1078699995 2108336.42123 37.7696075299961 -122.41161220625601 (37.7696075299961, -122.411612206256)
101739 101739 194112 Undocumented 2 Nyssa sylvatica :: Tupelo: Sour Gum 162 2 13th St 4 : 4 Tree 1 Private 1     2 Width 3ft   6009091.22432 2108341.1422 37.7696161796668 -122.411878478422 (37.7696161796668, -122.411878478422)
134682 134682 194111 Undocumented 2 Nyssa sylvatica :: Tupelo: Sour Gum 162 2 13th St 3 : 4 Tree 1 Private 1     2 Width 3ft   6009118.96021 2108339.52545 37.7696132964452 -122.411782426316 (37.7696132964452, -122.411782426316)
152938 152938 194117 Undocumented 2 Nyssa sylvatica :: Tupelo: Sour Gum 162 2 13th St 9 : 4 Tree 1 Private 1     2 Width 3ft   6009035.07102 2108345.44011 37.769624830259104 -122.41207301525299 (37.7696248302591, -122.412073015253)
169119 169119 194116 Undocumented 2 Nyssa sylvatica :: Tupelo: Sour Gum 162 2 13th St 8 : 4 Tree 1 Private 1     2 Width 3ft   6009046.64447 2108344.15355 37.7696219470167 -122.412032892001 (37.7696219470167, -122.412032892001)

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