Street_Tree_List

Data source: data.sfgov.org

17 rows where DBH = 23, qSiteInfo = 3 and qSpecies = 100

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qAddress, SiteOrder, PlotSize

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
25390 25390 132077 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1100x The Embarcadero 7 Median : Yard 3 Tree 1 DPW 2     23 Width 10ft   6012714.4120000005 2120058.1365799997 37.8019909162964 -122.400168938451 (37.8019909162964, -122.400168938451)
27355 27355 234354 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 650x Dolores St 1 Median : Yard 3 Tree 1 DPW 2     23     6004979.813630001 2104508.3497200003 37.7588607286626 -122.425826859935 (37.7588607286626, -122.425826859935)
32862 32862 132075 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1100x The Embarcadero 3 Median : Yard 3 Tree 1 DPW 2     23 Width 10ft   6012816.85763 2119903.53523 37.8015721299035 -122.399803563704 (37.8015721299035, -122.399803563704)
61544 61544 132098 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1100x The Embarcadero 12 Median : Yard 3 Tree 1 DPW 2     23 Width 10ft   6012646.4501 2120224.08688 37.802442786052396 -122.40041578348699 (37.8024427860524, -122.400415783487)
62709 62709 132071 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1000x The Embarcadero 3 Median : Yard 3 Tree 1 DPW 2     23 Width 10ft   6013261.919290001 2119233.02284 37.7997558644996 -122.39821636821199 (37.7997558644996, -122.398216368212)
68393 68393 132116 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1000x The Embarcadero 8 Median : Yard 3 Tree 1 DPW 2     23 Width 10ft   6013189.6161 2119421.22304 37.800268589579204 -122.39847977871901 (37.8002685895792, -122.398479778719)
70617 70617 132083 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1200x The Embarcadero 3 Median : Yard 3 Tree 1 DPW 2     23 Width 10ft   6012328.94165 2120621.527 37.8035163490725 -122.401542475719 (37.8035163490725, -122.401542475719)
76777 76777 132095 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1100x The Embarcadero 6 Median : Yard 3 Tree 1 DPW 2     23 Width 10ft   6012798.77066 2120004.26494 37.801847701082394 -122.39987323058901 (37.8018477010824, -122.399873230589)
131012 131012 234358 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 650x Dolores St 5 Median : Yard 3 Tree 1 DPW 2     23     6004991.05597 2104342.31446 37.7584054702508 -122.425776160656 (37.7584054702508, -122.425776160656)
131405 131405 194320 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 400x The Embarcadero 1 Median : Yard 3 Tree 1 DPW 2     23 Width 7ft   6014831.89764 2117081.36813 37.7939352489635 -122.392633022622 (37.7939352489635, -122.392633022622)
132937 132937 234364 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1150x Dolores St 6 Median : Yard 3 Tree 1 DPW 2     23     6005148.136969999 2101464.62312 37.7505128760752 -122.425028157637 (37.7505128760752, -122.425028157637)
147998 147998 132115 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1000x The Embarcadero 6 Median : Yard 3 Tree 1 DPW 2     23 Width 10ft   6013243.85901 2119336.7003900004 37.8000395322586 -122.398286142085 (37.8000395322586, -122.398286142085)
150698 150698 234330 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 900x Dolores St 15 Median : Yard 3 Tree 1 DPW 2     23     6005083.062580001 2102603.58555 37.7536365264144 -122.42533423108699 (37.7536365264144, -122.425334231087)
153490 153490 132085 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1300x The Embarcadero 2 Median : Yard 3 Tree 1 DPW 2     23 Width 10ft   6012153.585109999 2120867.04559 37.8041806971541 -122.402166580042 (37.8041806971541, -122.402166580042)
155474 155474 132089 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1500x The Embarcadero 6 Median : Yard 3 Tree 1 DPW 2     23 Width 10ft   6011437.6783 2121540.455 37.805989728403894 -122.404691478852 (37.8059897284039, -122.404691478852)
167096 167096 234328 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 850x Dolores St 4 Median : Yard 3 Tree 1 DPW 2     23     6005051.1738 2103243.46642 37.7553916882954 -122.425490044948 (37.7553916882954, -122.425490044948)
168748 168748 132110 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1500x The Embarcadero 9 Median : Yard 3 Tree 1 DPW 2     23 Width 10ft   6011374.63029 2121626.67271 37.8062229369941 -122.404915741893 (37.8062229369941, -122.404915741893)

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