Street_Tree_List

Data source: data.sfgov.org

12 rows where qSpecies = 475

View and edit SQL

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

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
82879 2302 DPW Maintained 3 Cupressus arizonica :: Arizona Cypress 475 800X Brotherhood Way 17 Median : Cutout 11 Tree 1 DPW 2     40 14M   5990276.209646201 2088591.5343604 37.7143153385926 -122.47551605113199 (37.7143153385926, -122.475516051132)
89822 2298 DPW Maintained 3 Cupressus arizonica :: Arizona Cypress 475 800X Brotherhood Way 13 Median : Cutout 11 Tree 1 DPW 2     45 14M   5990276.209646201 2088591.5343604 37.7143153385926 -122.47551605113199 (37.7143153385926, -122.475516051132)
89900 2261 DPW Maintained 3 Cupressus arizonica :: Arizona Cypress 475 700X Brotherhood Way 7 Median : Cutout 11 Tree 1 DPW 2     25 14M   5991180.7931196 2088069.9959996997 37.7129357180907 -122.472351488932 (37.7129357180907, -122.472351488932)
101138 2304 DPW Maintained 3 Cupressus arizonica :: Arizona Cypress 475 800X Brotherhood Way 19 Median : Cutout 11 Tree 1 DPW 2     45 14M   5990276.209646201 2088591.5343604 37.7143153385926 -122.47551605113199 (37.7143153385926, -122.475516051132)
105930 2267 DPW Maintained 3 Cupressus arizonica :: Arizona Cypress 475 750X Brotherhood Way 1 Median : Cutout 11 Tree 1 DPW 2     45 14M   5991074.042616099 2088106.2478104 37.71302907778821 -122.47272309171998 (37.7130290777882, -122.47272309172)
107007 2297 DPW Maintained 3 Cupressus arizonica :: Arizona Cypress 475 800X Brotherhood Way 12 Median : Cutout 11 Tree 1 DPW 2     50 14M   5990276.209646201 2088591.5343604 37.7143153385926 -122.47551605113199 (37.7143153385926, -122.475516051132)
112198 2265 DPW Maintained 3 Cupressus arizonica :: Arizona Cypress 475 700X Brotherhood Way 11 Median : Cutout 11 Tree 1 DPW 2     40 14M   5991180.7931196 2088069.9959996997 37.7129357180907 -122.472351488932 (37.7129357180907, -122.472351488932)
123388 2257 DPW Maintained 3 Cupressus arizonica :: Arizona Cypress 475 700X Brotherhood Way 3 Median : Cutout 11 Tree 1 DPW 2     45 14M   5991180.7931196 2088069.9959996997 37.7129357180907 -122.472351488932 (37.7129357180907, -122.472351488932)
126997 2258 DPW Maintained 3 Cupressus arizonica :: Arizona Cypress 475 700X Brotherhood Way 4 Median : Cutout 11 Tree 1 DPW 2     35 14M   5991180.7931196 2088069.9959996997 37.7129357180907 -122.472351488932 (37.7129357180907, -122.472351488932)
127206 2303 DPW Maintained 3 Cupressus arizonica :: Arizona Cypress 475 800X Brotherhood Way 18 Median : Cutout 11 Tree 1 DPW 2     45 14M   5990276.209646201 2088591.5343604 37.7143153385926 -122.47551605113199 (37.7143153385926, -122.475516051132)
139834 2259 DPW Maintained 3 Cupressus arizonica :: Arizona Cypress 475 700X Brotherhood Way 5 Median : Cutout 11 Tree 1 DPW 2     25 14M   5991180.7931196 2088069.9959996997 37.7129357180907 -122.472351488932 (37.7129357180907, -122.472351488932)
140483 2260 DPW Maintained 3 Cupressus arizonica :: Arizona Cypress 475 700X Brotherhood Way 6 Median : Cutout 11 Tree 1 DPW 2     25 14M   5991180.7931196 2088069.9959996997 37.7129357180907 -122.472351488932 (37.7129357180907, -122.472351488932)

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