Street_Tree_List

Data source: data.sfgov.org

18 rows where PlotSize = "Width 4ft", qSiteInfo = 10 and qSpecies = 55

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qAddress, SiteOrder, DBH

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
26027 26027 227311 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 405 Beacon St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     7 Width 4ft   6002323.66405 2098293.59277 37.7416460184529 -122.434568676724 (37.7416460184529, -122.434568676724)
29149 29149 226660 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 2 Dolores St 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     3 Width 4ft   6004732.5122 2108095.82328 37.7686970968169 -122.426937645858 (37.7686970968169, -122.426937645858)
34184 34184 129681 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 464 California St 8 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     2 Width 4ft   6012011.03614 2116789.35281 37.7929763782966 -122.402372995143 (37.7929763782966, -122.402372995143)
34507 34507 129677 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 464 California St 4 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     3 Width 4ft   6012069.97592 2116796.7218299997 37.792999901879604 -122.402169577472 (37.7929999018796, -122.402169577472)
37884 37884 226699 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 38 Ramona Ave 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     10 Width 4ft   6005184.56747 2107580.1746400003 37.767306799804004 -122.42533732116001 (37.767306799804, -122.42533732116)
37891 37891 227521 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 1500 Cole St 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     10 Width 4ft   5998355.105169999 2105264.42447 37.7605601235622 -122.448792539459 (37.7605601235622, -122.448792539459)
47017 47017 129614 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 1050 Van Ness Ave 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     4 Width 4ft   6006528.24106 2114177.52587 37.7854973571526 -122.42115824896999 (37.7854973571526, -122.42115824897)
49847 49847 129680 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 464 California St 7 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     3 Width 4ft   6012023.6782599995 2116790.52383 37.792980299349395 -122.40232933485001 (37.7929802993494, -122.40232933485)
51625 51625 129675 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 464 California St 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     3 Width 4ft   6012092.09526 2116799.4138599997 37.79300852816029 -122.402093232241 (37.7930085281603, -122.402093232241)
60893 60893 129592 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 1700 Jackson St 3 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     2 Width 4ft   6005880.07877 2117261.61148 37.79392892673889 -122.42362005315 (37.7939289267389, -122.42362005315)
66370 66370 226659 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 2 Dolores St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     3 Width 4ft   6004732.43221 2108111.34467 37.768739710290205 -122.42693902812799 (37.7687397102902, -122.426939028128)
74224 74224 227312 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 405 Beacon St 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     6 Width 4ft   6002324.80027 2098291.20811 37.7416395352327 -122.43456457759301 (37.7416395352327, -122.434564577593)
130904 130904 129591 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 1700 Jackson St 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     2 Width 4ft   6005908.12306 2117266.84801 37.7939448878875 -122.42352338950899 (37.7939448878875, -122.423523389509)
135533 135533 129679 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 464 California St 6 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     2 Width 4ft   6012036.63622 2116793.11614 37.792988140540004 -122.40228468169799 (37.79298814054, -122.402284681698)
146811 146811 129676 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 464 California St 3 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     3 Width 4ft   6012082.98226 2116799.13729 37.7930072601221 -122.402124744455 (37.7930072601221, -122.402124744455)
155845 155845 129674 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 464 California St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     3 Width 4ft   6012104.09602 2116801.48556 37.793014886365796 -122.402051854416 (37.7930148863658, -122.402051854416)
167437 167437 226661 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 2 Dolores St 3 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     3 Width 4ft   6004732.99983 2108080.69145 37.7686555760307 -122.42693488134199 (37.7686555760307, -122.426934881342)
183307 183307 129678 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 464 California St 5 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     3 Width 4ft   6012048.39516 2116793.1627 37.7929889247624 -122.402243998167 (37.7929889247624, -122.402243998167)

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