Street_Tree_List

Data source: data.sfgov.org

14 rows where DBH = 2 and qSpecies = 4

✎ View and edit SQL

This data as json, CSV (advanced)

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

DBH ✖

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
26018 26018 207370 DPW Maintained 3 Ligustrum japonicum :: Japanese Privet 4 501x Ortega St 4 Median : Cutout 11 Tree 1 DPW 2     2 Width 3ft   5992545.91088 2103073.9348400002 37.754211699531005 -122.46872432099501 (37.754211699531, -122.468724320995)
35462 35462 129513 Undocumented 2 Ligustrum japonicum :: Japanese Privet 4 25 Heather Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 2ft   5997331.52493 2114270.89109 37.785230964483105 -122.45298274796998 (37.7852309644831, -122.45298274797)
44640 44640 58940 Permitted Site 1 Ligustrum japonicum :: Japanese Privet 4 1360 Rhode Island St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/30/2005 12:00:00 AM 2   Permit Number 18218 6011963.90217 2102042.40825 37.7524820001659 -122.40149918233801 (37.7524820001659, -122.401499182338)
45848 45848 129548 Undocumented 2 Ligustrum japonicum :: Japanese Privet 4 1 Saroyan Pl 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     2 Width 4ft   6011012.0164 2118485.6729900003 37.7975782452004 -122.405949226574 (37.7975782452004, -122.405949226574)
64468 64468 191428 Undocumented 2 Ligustrum japonicum :: Japanese Privet 4 22 Robblee Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 5ft   6012599.814780001 2095974.63355 37.735856643564404 -122.39887425376001 (37.7358566435644, -122.39887425376)
65210 65210 226642 Undocumented 2 Ligustrum japonicum :: Japanese Privet 4 14 Cumberland St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     2 Width 2ft   6005484.04077 2104618.2918599998 37.759191085608 -122.42409082483101 (37.759191085608, -122.424090824831)
69137 69137 129536 Undocumented 2 Ligustrum japonicum :: Japanese Privet 4 1440 Montgomery St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 4ft   6011432.08366 2120273.70789 37.8025112388511 -122.40462160961599 (37.8025112388511, -122.404621609616)
72309 72309 226644 Undocumented 2 Ligustrum japonicum :: Japanese Privet 4 48 Cumberland St 3 : 4 Tree 1 Private 1     2 Width 2ft   6005321.7767900005 2104616.40188 37.7591767333496 -122.42465187767701 (37.7591767333496, -122.424651877677)
130268 130268 177038 Undocumented 2 Ligustrum japonicum :: Japanese Privet 4 649 Hamilton St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6009808.87936 2091375.19794 37.7230716583033 -122.40819937261801 (37.7230716583033, -122.408199372618)
135694 135694 129558 Undocumented 2 Ligustrum japonicum :: Japanese Privet 4 300 California St 4 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     2 Width 3ft   6012591.8685800005 2116885.11843 37.793271734566005 -122.400370000791 (37.793271734566, -122.400370000791)
160826 160826 129520 Undocumented 2 Ligustrum japonicum :: Japanese Privet 4 3041 Divisadero St 4 : 4 Tree 1 Private 1     2 Width 2ft   6000447.31564 2118755.2398900003 37.7977218795107 -122.442525177605 (37.7977218795107, -122.442525177605)
163344 163344 226643 Undocumented 2 Ligustrum japonicum :: Japanese Privet 4 48 Cumberland St 2 : 4 Tree 1 Private 1     2 Width 2ft   6005334.035069999 2104616.89651 37.75917878378829 -122.42460951781099 (37.7591787837883, -122.424609517811)
172460 172460 75304 Undocumented 2 Ligustrum japonicum :: Japanese Privet 4 240 07th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/10/1994 12:00:00 AM 2     6010043.764880001 2111144.47071 37.7773668617363 -122.408781461497 (37.7773668617363, -122.408781461497)
178970 178970 118574 Undocumented 2 Ligustrum japonicum :: Japanese Privet 4 7900 Geary Blvd 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   5982449.98783 2112431.50605 37.779316488746 -122.50433111328199 (37.779316488746, -122.504331113282)

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