Street_Tree_List

Data source: data.sfgov.org

14 rows where DBH = 11 and qSpecies = 85

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: 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
23670 23670 129807 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 901 Sacramento St 6 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     11 Width 3ft   6010390.20829 2116866.53247 37.793097682469394 -122.407986617304 (37.7930976824694, -122.407986617304)
35845 35845 129762 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 2222 Polk St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 4ft   6006368.54903 2118610.8656 37.797661199562995 -122.422025790757 (37.797661199563, -122.422025790757)
36798 36798 129763 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 1379 Green St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 4ft   6006382.65003 2118656.3506099996 37.7977868852004 -122.421980230217 (37.7977868852004, -122.421980230217)
55972 55972 129835 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 733 Front St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 4ft   6012779.55401 2118654.25305 37.7981398214472 -122.399844877638 (37.7981398214472, -122.399844877638)
72002 72002 129820 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 241 Battery St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   6012651.85549 2117070.09364 37.7937829775554 -122.400175437873 (37.7937829775554, -122.400175437873)
72713 72713 208168 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 2590 16th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   5991441.450619999 2097800.63089 37.7396687033598 -122.472159425416 (37.7396687033598, -122.472159425416)
105063 105063 200347 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 900 Phelps St 9 : 4 Tree 1 Private 1     11 Width 4ft   6014556.031830001 2097054.78425 37.7389313231291 -122.392186304173 (37.7389313231291, -122.392186304173)
133126 133126 200353 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 900 Phelps St 17 : 4 Tree 1 Private 1     11 Width 5ft   6014392.43301 2096834.63166 37.738317744462 -122.392736560653 (37.738317744462, -122.392736560653)
134397 134397 129803 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 901 Sacramento St 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     11 Width 3ft   6010302.01456 2116853.58579 37.7930571958732 -122.408290860643 (37.7930571958732, -122.408290860643)
134636 134636 200355 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 900 Phelps St 19 : 4 Tree 1 Private 1     11 Width 5ft   6014345.08354 2096773.3910700001 37.7381469605042 -122.392895989784 (37.7381469605042, -122.392895989784)
149570 149570 129755 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 2407 Clay St 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   6003208.43493 2116180.994 37.7908106615232 -122.432786962347 (37.7908106615232, -122.432786962347)
153734 153734 129816 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 433 Sacramento St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   6012609.05006 2117170.5257599996 37.7940563534572 -122.400330606896 (37.7940563534572, -122.400330606896)
164517 164517 200354 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 900 Phelps St 18 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 5ft   6014359.7983 2096791.80766 37.7381983459865 -122.392846401168 (37.7381983459865, -122.392846401168)
178038 178038 129844 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 750 Battery St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 4ft   6012469.34241 2118758.9010099997 37.7984098608851 -122.40092566398899 (37.7984098608851, -122.400925663989)

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