Street_Tree_List

Data source: data.sfgov.org

18 rows where qSiteInfo = 11 and qSpecies = 27

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qAddress, SiteOrder, DBH, PlotSize, XCoord, YCoord, Latitude, Longitude, Location

qSiteInfo ✖

  • Median : Cutout · 18 ✖
Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
20367 20367 29572 DPW Maintained 3 Leptospermum scoparium :: New Zealand Tea Tree 27 400X Junipero Serra Blvd 1 Median : Cutout 11 Tree 1 DPW 2   04/01/2007 12:00:00 AM 3 3X3   5991380.33669 2094272.13717 37.7299768148765 -122.47211360317 (37.7299768148765, -122.47211360317)
21729 21729 29577 DPW Maintained 3 Leptospermum scoparium :: New Zealand Tea Tree 27 400X Junipero Serra Blvd 6 Median : Cutout 11 Tree 1 DPW 2   04/01/2007 12:00:00 AM 3 3X3   5991369.68485 2094223.17677 37.7298417654626 -122.47214686011002 (37.7298417654626, -122.47214686011)
24627 24627 207239 DPW Maintained 3 Leptospermum scoparium :: New Zealand Tea Tree 27 1x Minerva St 43 Median : Cutout 11 Tree 1 DPW 2     13 Width 0ft   5996447.62341 2088998.17361 37.7157876983331 -122.45421469505199 (37.7157876983331, -122.454214695052)
29724 29724 207328 DPW Maintained 3 Leptospermum scoparium :: New Zealand Tea Tree 27 400x Marietta Dr 10 Median : Cutout 11 Tree 1 DPW 2     5 Width 3ft   5999485.75789 2097034.69989 37.738027887567796 -122.444290723035 (37.7380278875678, -122.444290723035)
30605 30605 207238 DPW Maintained 3 Leptospermum scoparium :: New Zealand Tea Tree 27 1x Minerva St 34 Median : Cutout 11 Tree 1 DPW 2     6 Width 0ft   5996327.60089 2088999.83253 37.7157853699672 -122.454629665632 (37.7157853699672, -122.454629665632)
33929 33929 207241 DPW Maintained 3 Leptospermum scoparium :: New Zealand Tea Tree 27 1x Minerva St 46 Median : Cutout 11 Tree 1 DPW 2     6 Width 0ft   5996475.13618 2088997.3163599998 37.7157869221947 -122.45411953688601 (37.7157869221947, -122.454119536886)
65599 65599 207240 DPW Maintained 3 Leptospermum scoparium :: New Zealand Tea Tree 27 1x Minerva St 44 Median : Cutout 11 Tree 1 DPW 2     14 Width 0ft   5996458.70543 2088998.7901400002 37.7157900266684 -122.45417643520001 (37.7157900266684, -122.4541764352)
69603 69603 207236 DPW Maintained 3 Leptospermum scoparium :: New Zealand Tea Tree 27 1x Minerva St 25 Median : Cutout 11 Tree 1 DPW 2     3 Width 0ft   5996258.071 2089000.15441 37.7157822655196 -122.45487001484301 (37.7157822655196, -122.454870014843)
76312 76312 207237 DPW Maintained 3 Leptospermum scoparium :: New Zealand Tea Tree 27 1x Minerva St 33 Median : Cutout 11 Tree 1 DPW 2     15 Width 0ft   5996320.92755 2088998.85833 37.715782312278 -122.454652661299 (37.715782312278, -122.454652661299)
80194 80194 4999 DPW Maintained 3 Leptospermum scoparium :: New Zealand Tea Tree 27 5300 Diamond Heights Blvd 16 Median : Cutout 11 Tree 1 DPW 2     7 12   6001419.5409281 2098992.5811716 37.743513909519294 -122.437744874344 (37.7435139095193, -122.437744874344)
88236 88236 4991 DPW Maintained 3 Leptospermum scoparium :: New Zealand Tea Tree 27 5300 Diamond Heights Blvd 8 Median : Cutout 11 Tree 1 DPW 2     12 12   6001419.5409281 2098992.5811716 37.743513909519294 -122.437744874344 (37.7435139095193, -122.437744874344)
94015 94015 4992 DPW Maintained 3 Leptospermum scoparium :: New Zealand Tea Tree 27 5300 Diamond Heights Blvd 9 Median : Cutout 11 Tree 1 DPW 2     12 12   6001419.5409281 2098992.5811716 37.743513909519294 -122.437744874344 (37.7435139095193, -122.437744874344)
95563 95563 4998 DPW Maintained 3 Leptospermum scoparium :: New Zealand Tea Tree 27 5300 Diamond Heights Blvd 15 Median : Cutout 11 Tree 1 DPW 2     12 12   6001419.5409281 2098992.5811716 37.743513909519294 -122.437744874344 (37.7435139095193, -122.437744874344)
97805 97805 4994 DPW Maintained 3 Leptospermum scoparium :: New Zealand Tea Tree 27 5300 Diamond Heights Blvd 11 Median : Cutout 11 Tree 1 DPW 2     12 12   6001419.5409281 2098992.5811716 37.743513909519294 -122.437744874344 (37.7435139095193, -122.437744874344)
99734 99734 4993 DPW Maintained 3 Leptospermum scoparium :: New Zealand Tea Tree 27 5300 Diamond Heights Blvd 10 Median : Cutout 11 Tree 1 DPW 2     12 12   6001419.5409281 2098992.5811716 37.743513909519294 -122.437744874344 (37.7435139095193, -122.437744874344)
110729 110729 4995 DPW Maintained 3 Leptospermum scoparium :: New Zealand Tea Tree 27 5300 Diamond Heights Blvd 12 Median : Cutout 11 Tree 1 DPW 2     12 12   6001419.5409281 2098992.5811716 37.743513909519294 -122.437744874344 (37.7435139095193, -122.437744874344)
133379 133379 207242 DPW Maintained 3 Leptospermum scoparium :: New Zealand Tea Tree 27 1x Minerva St 53 Median : Cutout 11 Tree 1 DPW 2     8 Width 0ft   5996583.3083 2088999.01444 37.7157977869175 -122.453745768776 (37.7157977869175, -122.453745768776)
143370 143370 5001 DPW Maintained 3 Leptospermum scoparium :: New Zealand Tea Tree 27 5300 Diamond Heights Blvd 18 Median : Cutout 11 Tree 1 DPW 2     12 12   6001419.5409281 2098992.5811716 37.743513909519294 -122.437744874344 (37.7435139095193, -122.437744874344)

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