Street_Tree_List

Data source: data.sfgov.org

11 rows where PlotSize = "Width 0ft" and qSpecies = 58

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, qAddress, qSiteInfo, qCaretaker, DBH

PlotSize ✖

  • Width 0ft · 11 ✖
Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
34874 34874 175804 DPW Maintained 3 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 500x Mansell St 7 Median : Cutout 11 Tree 1 DPW 2     12 Width 0ft   6010489.90873 2090338.0061700002 37.72026185429429 -122.40577215548402 (37.7202618542943, -122.405772155484)
38028 38028 204732 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 700 Junipero Serra Blvd 92 : 4 Tree 1 Private 1     9 Width 0ft   5991226.61275 2092125.57221 37.7240739859998 -122.472488607886 (37.7240739859998, -122.472488607886)
43676 43676 204727 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 300 Junipero Serra Blvd 38 : 4 Tree 1 Private 1     4 Width 0ft   5991391.65527 2094396.58957 37.73031918497 -122.47208354153798 (37.73031918497, -122.472083541538)
68906 68906 204731 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 400 Junipero Serra Blvd 25 : 4 Tree 1 Private 1     5 Width 0ft   5991352.35851 2093912.8371599999 37.728988647895 -122.472184145999 (37.728988647895, -122.472184145999)
72067 72067 204730 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 400 Junipero Serra Blvd 20 : 4 Tree 1 Private 1     7 Width 0ft   5991365.099780001 2094040.0062400002 37.7293385597172 -122.472149364714 (37.7293385597172, -122.472149364714)
129739 129739 204728 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 400 Junipero Serra Blvd 13 : 4 Tree 1 Private 1     2 Width 0ft   5991366.51565 2094145.3724 37.729627950748295 -122.47215214722401 (37.7296279507483, -122.472152147224)
135308 135308 204726 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 300 Junipero Serra Blvd 30 : 4 Tree 1 Private 1     5 Width 0ft   5991392.43358 2094433.51883 37.7304206284982 -122.472083541544 (37.7304206284982, -122.472083541544)
154057 154057 204723 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 300 Junipero Serra Blvd 12 : 4 Tree 1 Private 1     5 Width 0ft   5991397.3981 2094531.5501400002 37.7306900851772 -122.47207352129801 (37.7306900851772, -122.472073521298)
170368 170368 204724 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 300 Junipero Serra Blvd 21 : 4 Tree 1 Private 1     8 Width 0ft   5991391.18592 2094484.3447599998 37.730560111554496 -122.47209155808999 (37.7305601115545, -122.47209155809)
170450 170450 204725 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 300 Junipero Serra Blvd 29 : 4 Tree 1 Private 1     5 Width 0ft   5991390.23736 2094439.33755 37.730436478151496 -122.47209155807501 (37.7304364781515, -122.472091558075)
188538 188538 204729 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 400 Junipero Serra Blvd 16 : 4 Tree 1 Private 1     1 Width 0ft   5991368.5463 2094108.06034 37.729525618690204 -122.47214240847 (37.7295256186902, -122.47214240847)

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