Street_Tree_List

Data source: data.sfgov.org

18 rows where DBH = 11 and qSpecies = 31

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, PlotSize

DBH ✖

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
26722 26722 136742 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 2900 Broderick St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 4ft   6000053.33945 2118542.13589 37.79711428765071 -122.443873120143 (37.7971142876507, -122.443873120143)
27397 27397 241185 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 3781 Cesar Chavez St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 4ft   6005371.2767199995 2100474.34138 37.7478063924621 -122.424186102634 (37.7478063924621, -122.424186102634)
29979 29979 241228 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 128 Laidley St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   6003596.19295 2097670.1680900003 37.740006394279796 -122.43012423703699 (37.7400063942798, -122.430124237037)
34328 34328 241212 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 2801 17th St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   6009052.89196 2106353.81264 37.7641572813666 -122.411870616529 (37.7641572813666, -122.411870616529)
35762 35762 241219 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 4130 Cesar Chavez St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 6ft   6003095.93223 2100399.3712299997 37.7474718059861 -122.432048772745 (37.7474718059861, -122.432048772745)
35806 35806 136746 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 2908 Broderick St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 4ft   6000043.09421 2118605.60705 37.7972879782152 -122.44391313370501 (37.7972879782152, -122.443913133705)
37345 37345 197979 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 601 Wisconsin St 21 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 3ft   6012714.266419999 2104668.82572 37.759735409279706 -122.39908861614599 (37.7597354092797, -122.399088616146)
37691 37691 136745 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 2908 Broderick St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 4ft   6000044.84961 2118592.59728 37.797252356970205 -122.44390612438801 (37.7972523569702, -122.443906124388)
39697 39697 241201 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 26 Carl St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 4ft   5998490.815219999 2107264.4937400003 37.7660595705173 -122.44846722318898 (37.7660595705173, -122.448467223189)
44751 44751 197981 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 601 Wisconsin St 18 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 6ft   6012726.35291 2104657.30852 37.759704459115795 -122.39904600628 (37.7597044591158, -122.39904600628)
68564 68564 241227 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 104 Laidley St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   6003479.820730001 2097757.7557200002 37.7402402980644 -122.430532852122 (37.7402402980644, -122.430532852122)
151347 151347 136741 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 2900 Broderick St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 4ft   6000055.17715 2118534.1134099998 37.797092364871794 -122.44386618458701 (37.7970923648718, -122.443866184587)
157728 157728 215438 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 217 Staples Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 2ft   5998696.43814 2093778.97623 37.7290433761531 -122.44678558449101 (37.7290433761531, -122.446785584491)
162786 162786 143059 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 440 GREENWICH ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 0ft   6010738.656 2120349.8129 37.8026814253217 -122.40702659346701 (37.8026814253217, -122.407026593467)
163040 163040 82715 Permitted Site 1 Trachycarpus fortunei :: Windmill Palm 31 1379 Quesada Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/08/2009 12:00:00 AM 11 3x3 Permit Number 52465 6016442.9825 2093699.9014 37.7298240779238 -122.385428311894 (37.7298240779238, -122.385428311894)
171952 171952 241182 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 1362 Florida St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   6009519.86871 2101254.76714 37.7501826387226 -122.409895500292 (37.7501826387226, -122.409895500292)
178056 178056 136744 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 2906 Broderick St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 4ft   6000047.06944 2118581.72583 37.7972226334754 -122.44389766175101 (37.7972226334754, -122.443897661751)
178574 178574 241189 Undocumented 2 Trachycarpus fortunei :: Windmill Palm 31 415 South Van Ness Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 4ft   6007440.26209 2107242.97401 37.7665081073951 -122.41751127324 (37.7665081073951, -122.41751127324)

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