Street_Tree_List

Data source: data.sfgov.org

21 rows where PlotSize = "Width 10ft" and qSpecies = 27

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qAddress, SiteOrder, qSiteInfo, DBH, Longitude

PlotSize ✖

  • Width 10ft · 21 ✖
Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
31369 31369 207346 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 628 Edna St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 10ft   5998595.0741 2094889.9944099998 37.7320881793139 -122.44721593437201 (37.7320881793139, -122.447215934372)
36611 36611 207332 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 139 Mangels Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 10ft   6000483.56606 2095198.0934400002 37.7330418734682 -122.44070911276 (37.7330418734682, -122.44070911276)
37229 37229 207260 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 282 Arch St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 10ft   5992744.11171 2089090.22365 37.7158273737034 -122.46702231894 (37.7158273737034, -122.46702231894)
59479 59479 207337 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 114 Melrose Ave 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 10ft   5999331.40158 2095537.8442099998 37.7339090681372 -122.44471684701901 (37.7339090681372, -122.444716847019)
59513 59513 207233 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 422 Orizaba Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 10ft   5994045.888719999 2089197.1437900001 37.7161960040241 -122.462530559657 (37.7161960040241, -122.462530559657)
63132 63132 207265 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 542 Head St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 10ft   5993523.314809999 2089466.4912400001 37.7169054593937 -122.464356356062 (37.7169054593937, -122.464356356062)
63586 63586 207359 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 149 Staples Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 10ft   5999079.1567400005 2093759.91373 37.729012890930704 -122.445461131336 (37.7290128909307, -122.445461131336)
68354 68354 207353 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 678 Joost Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 10ft   5997598.43347 2095021.49363 37.7323922472992 -122.45067100017201 (37.7323922472992, -122.450671000172)
70085 70085 207207 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 101 Foerster St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 10ft   5998074.45641 2093829.28565 37.7291459626917 -122.44893943651199 (37.7291459626917, -122.448939436512)
73643 73643 207345 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 628 Edna St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 10ft   5998591.38299 2094890.7633 37.732090079596794 -122.44722875061399 (37.7320900795968, -122.447228750614)
134996 134996 207348 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 359 Melrose Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 10ft   5997745.23089 2095505.757 37.733730320683605 -122.450198383048 (37.7337303206836, -122.450198383048)
136022 136022 118580 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 7900 Geary Blvd 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 10ft   5982502.32297 2112445.62468 37.7793583322752 -122.504151113367 (37.7793583322752, -122.504151113367)
136134 136134 207263 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 582 Ramsell St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 10ft   5993025.1293 2091125.2182900002 37.7214311932731 -122.46619880075899 (37.7214311932731, -122.466198800759)
150333 150333 207234 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 422 Orizaba Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 10ft   5994046.18721 2089200.86778 37.716206246401896 -122.462529797908 (37.7162062464019, -122.462529797908)
151529 151529 118577 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 7900 Geary Blvd 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 10ft   5982502.68903 2112449.1000200002 37.7793678960656 -122.504150104536 (37.7793678960656, -122.504150104536)
162804 162804 207261 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 274 Arch St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 10ft   5992740.415519999 2089036.58294 37.715679875902296 -122.467031197028 (37.7156798759023, -122.467031197028)
172280 172280 207170 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 100 Vista Verde Ct 7 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 10ft   5999209.0212900005 2096067.6439599998 37.7353567886676 -122.44517802836799 (37.7353567886676, -122.445178028368)
182796 182796 207336 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 114 Melrose Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 10ft   5999335.46736 2095537.54616 37.7339084817781 -122.444702769016 (37.7339084817781, -122.444702769016)
184301 184301 207208 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 101 Foerster St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 10ft   5998074.52147 2093832.4092700002 37.7291545431359 -122.44893943651199 (37.7291545431359, -122.448939436512)
186764 186764 207347 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 383 Melrose Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     17 Width 10ft   5997585.73238 2095504.5869999998 37.73371797929771 -122.45074972953002 (37.7337179792977, -122.45074972953)
188039 188039 207335 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 114 Melrose Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 10ft   5999338.03809 2095537.4927400001 37.7339084817987 -122.444693877414 (37.7339084817987, -122.444693877414)

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