Street_Tree_List

Data source: data.sfgov.org

16 rows where DBH = 4 and qSpecies = 4

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qAddress, SiteOrder, qSiteInfo, PlotSize

DBH ✖

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)
37818 37818 226638 Undocumented 2 Ligustrum japonicum :: Japanese Privet 4 201 Coso Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 2ft   6007716.3532 2099510.6976099997 37.74529257420679 -122.41600868956301 (37.7452925742068, -122.416008689563)
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)
47134 47134 129521 Undocumented 2 Ligustrum japonicum :: Japanese Privet 4 2222 Bay St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6000122.02291 2120260.78291 37.8018371520253 -122.443758994388 (37.8018371520253, -122.443758994388)
48699 48699 129547 Undocumented 2 Ligustrum japonicum :: Japanese Privet 4 13 Miller Pl 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 1ft   6010075.14286 2116919.1763 37.7932245849005 -122.40908048339399 (37.7932245849005, -122.409080483394)
54794 54794 119044 Undocumented 2 Ligustrum japonicum :: Japanese Privet 4 591 44th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   5982228.00989 2111743.54314 37.7774144867655 -122.50504801740401 (37.7774144867655, -122.505048017404)
132877 132877 117693 Undocumented 2 Ligustrum japonicum :: Japanese Privet 4 435 42nd Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   5982808.8484 2112817.53757 37.7803975176735 -122.503118273577 (37.7803975176735, -122.503118273577)
133137 133137 191429 Undocumented 2 Ligustrum japonicum :: Japanese Privet 4 2399 Lane St 7 Side Yard : Yard 17 Tree 1 Private 1     4     6013991.75526 2092879.9064599997 37.7274366158882 -122.393845172923 (37.7274366158882, -122.393845172923)
150604 150604 177029 Undocumented 2 Ligustrum japonicum :: Japanese Privet 4 123 Seneca Ave 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     4 Width 0ft   6000050.7624699995 2090072.63848 37.7189438978236 -122.441837691751 (37.7189438978236, -122.441837691751)
161411 161411 129557 Undocumented 2 Ligustrum japonicum :: Japanese Privet 4 300 California St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     4 Width 3ft   6012628.75569 2116888.8810400004 37.7932841227067 -122.40024263249201 (37.7932841227067, -122.400242632492)
166596 166596 207366 Undocumented 2 Ligustrum japonicum :: Japanese Privet 4 1263 17th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   5990777.74909 2106795.52344 37.7643278872345 -122.475110663153 (37.7643278872345, -122.475110663153)
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)
170716 170716 218286 Undocumented 2 Ligustrum japonicum :: Japanese Privet 4 1 Woodacre Dr 10 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4     5991335.90639 2095594.8050900002 37.7336059570417 -122.472363586812 (37.7336059570417, -122.472363586812)
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)
174209 174209 191427 Undocumented 2 Ligustrum japonicum :: Japanese Privet 4 1627 20th St 1 : 4 Tree 1 Private 1     4 Width 3ft   6013091.09687 2104712.62895 37.7598766756903 -122.39778840962099 (37.7598766756903, -122.397788409621)
188033 188033 226640 Undocumented 2 Ligustrum japonicum :: Japanese Privet 4 10 Crescent Ave 2 Side Yard : Yard 17 Tree 1 Private 1     4 Width 3ft   6005282.96903 2095902.7994400002 37.7352489878562 -122.42416639485799 (37.7352489878562, -122.424166394858)

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