Street_Tree_List

Data source: data.sfgov.org

14 rows where PlotSize = "Width 4ft" and qSpecies = 4

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qAddress, SiteOrder, qSiteInfo, DBH

PlotSize ✖

  • Width 4ft · 14 ✖
Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
31025 31025 129553 Undocumented 2 Ligustrum japonicum :: Japanese Privet 4 44 Montgomery St 6 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     4 Width 4ft   6012058.5984 2115646.10201 37.7898399378192 -122.402128014397 (37.7898399378192, -122.402128014397)
34739 34739 129549 Undocumented 2 Ligustrum japonicum :: Japanese Privet 4 44 Montgomery St 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     7 Width 4ft   6012078.1031 2115538.76346 37.78954630017979 -122.40205298038401 (37.7895463001798, -122.402052980384)
34865 34865 129550 Undocumented 2 Ligustrum japonicum :: Japanese Privet 4 44 Montgomery St 3 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     7 Width 4ft   6012076.26306 2115552.15036 37.7895829547447 -122.40206028827 (37.7895829547447, -122.40206028827)
39984 39984 129551 Undocumented 2 Ligustrum japonicum :: Japanese Privet 4 44 Montgomery St 4 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     6 Width 4ft   6012074.07881 2115564.48535 37.789616701801 -122.40206871312 (37.789616701801, -122.40206871312)
40379 40379 129554 Undocumented 2 Ligustrum japonicum :: Japanese Privet 4 44 Montgomery St 7 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     4 Width 4ft   6012057.79655 2115657.86651 37.7898721955983 -122.40213161617599 (37.7898721955983, -122.402131616176)
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)
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)
138207 138207 123058 Undocumented 2 Ligustrum japonicum :: Japanese Privet 4 500 Funston Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 4ft   5991916.77661 2111982.4939599996 37.778635859363206 -122.471549122693 (37.7786358593632, -122.471549122693)
154592 154592 117871 Undocumented 2 Ligustrum japonicum :: Japanese Privet 4 850 40th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 4ft   5983579.8283400005 2110008.29889 37.7727294500776 -122.500243389783 (37.7727294500776, -122.500243389783)
156654 156654 177030 Undocumented 2 Ligustrum japonicum :: Japanese Privet 4 235 Ottawa Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 4ft   5998356.41955 2089266.50528 37.7166337499183 -122.447636347658 (37.7166337499183, -122.447636347658)
166908 166908 129552 Undocumented 2 Ligustrum japonicum :: Japanese Privet 4 44 Montgomery St 5 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     4 Width 4ft   6012061.46033 2115633.25932 37.789804834569296 -122.402117209065 (37.7898048345693, -122.402117209065)
168981 168981 123060 Undocumented 2 Ligustrum japonicum :: Japanese Privet 4 500 Funston Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 4ft   5991917.4637 2111957.21563 37.7785664917216 -122.47154490330601 (37.7785664917216, -122.471544903306)
170003 170003 123059 Undocumented 2 Ligustrum japonicum :: Japanese Privet 4 500 Funston Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 4ft   5991916.7341 2111968.89129 37.7785985076866 -122.47154827826901 (37.7785985076866, -122.471548278269)
171149 171149 191423 Undocumented 2 Ligustrum japonicum :: Japanese Privet 4 872 Rhode Island St 1 : 4 Tree 1 Private 1     4 Width 4ft   6011836.2577599995 2104328.91927 37.758753133763705 -122.402101335126 (37.7587531337637, -122.402101335126)

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