Street_Tree_List

Data source: data.sfgov.org

18 rows where DBH = 28, qSiteInfo = 3 and qSpecies = 100

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qAddress, SiteOrder

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
25996 25996 194361 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 380x The Embarcadero 8 Median : Yard 3 Tree 1 DPW 2     28 Width 8ft   6016114.70966 2114269.45463 37.786285536482296 -122.38799801482 (37.7862855364823, -122.38799801482)
27594 27594 194293 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1700x Quesada Ave 46 Median : Yard 3 Tree 1 DPW 2     28     6014318.796490001 2095319.19207 37.7341525685742 -122.392885167337 (37.7341525685742, -122.392885167337)
33192 33192 194377 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 310x The Embarcadero 14 Median : Yard 3 Tree 1 DPW 2     28 Width 8ft   6016027.16358 2115370.7776 37.789304668530896 -122.388377800289 (37.7893046685309, -122.388377800289)
63682 63682 194360 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 380x The Embarcadero 7 Median : Yard 3 Tree 1 DPW 2     28 Width 8ft   6016108.030590001 2114179.2623099997 37.786037518748 -122.388014826737 (37.786037518748, -122.388014826737)
66121 66121 194352 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 418x The Embarcadero 12 Median : Yard 3 Tree 1 DPW 2     28 Width 8ft   6016055.63748 2113520.42583 37.7842255997618 -122.388150099168 (37.7842255997618, -122.388150099168)
76527 76527 194370 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 310x The Embarcadero 7 Median : Yard 3 Tree 1 DPW 2     28 Width 8ft   6016163.96985 2115051.82185 37.788436468407 -122.387882197423 (37.788436468407, -122.387882197423)
130206 130206 194374 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 310x The Embarcadero 11 Median : Yard 3 Tree 1 DPW 2     28 Width 8ft   6016126.62936 2115234.83636 37.788936915964705 -122.388024167087 (37.7889369159647, -122.388024167087)
133649 133649 234347 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 550x Dolores St 1 Median : Yard 3 Tree 1 DPW 2     28     6004944.62757 2105117.25917 37.760530661773 -122.425991895418 (37.760530661773, -122.425991895418)
138222 138222 194356 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 380x The Embarcadero 3 Median : Yard 3 Tree 1 DPW 2     28 Width 8ft   6016092.96172 2113985.53296 37.7855047469016 -122.38805343733401 (37.7855047469016, -122.388053437334)
147393 147393 194355 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 380x The Embarcadero 2 Median : Yard 3 Tree 1 DPW 2     28 Width 8ft   6016135.3126300005 2113894.74213 37.785257802049706 -122.38790057687001 (37.7852578020497, -122.38790057687)
151971 151971 194274 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1150x Tennessee St 17 Median : Yard 3 Tree 1 DPW 2     28     6015578.255919999 2103421.32087 37.756469211897 -122.389096301947 (37.756469211897, -122.389096301947)
153149 153149 194381 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 300x The Embarcadero 4 Median : Yard 3 Tree 1 DPW 2     28 Width 8ft   6015827.50848 2115690.11268 37.79017042428 -122.389090895237 (37.79017042428, -122.389090895237)
153572 153572 194344 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 418x The Embarcadero 4 Median : Yard 3 Tree 1 DPW 2     28 Width 8ft   6016049.59347 2112931.0937900003 37.7826070916921 -122.38812986802 (37.7826070916921, -122.38812986802)
157962 157962 194366 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 310x The Embarcadero 3 Median : Yard 3 Tree 1 DPW 2     28 Width 8ft   6016195.859569999 2114866.22772 37.78792863564279 -122.387758908461 (37.7879286356428, -122.387758908461)
158245 158245 194357 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 380x King St 4 Median : Yard 3 Tree 1 DPW 2     28 Width 8ft   6016143.59514 2113983.21728 37.7855011936686 -122.387878097405 (37.7855011936686, -122.387878097405)
163146 163146 194345 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 418x The Embarcadero 5 Median : Yard 3 Tree 1 DPW 2     28 Width 8ft   6016011.38638 2113034.09815 37.7828878015789 -122.388269240457 (37.7828878015789, -122.388269240457)
164799 164799 194376 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 310x The Embarcadero 13 Median : Yard 3 Tree 1 DPW 2     28 Width 8ft   6016101.40226 2115318.33028 37.789164773592205 -122.38811727930201 (37.7891647735922, -122.388117279302)
170290 170290 194382 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 300x The Embarcadero 5 Median : Yard 3 Tree 1 DPW 2     28 Width 8ft   6015730.53426 2115716.1031299997 37.7902364120368 -122.389428237241 (37.7902364120368, -122.389428237241)

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