Street_Tree_List

Data source: data.sfgov.org

12 rows where DBH = 2 and qSpecies = 42

✎ 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
42028 42028 188510 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 101 Pennsylvania Ave 25 Front Yard : Yard 7 Tree 1 Private 1     2     6014318.1653 2106535.6894400003 37.76495065967789 -122.39367214607401 (37.7649506596779, -122.393672146074)
49864 49864 203621 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 21 Juanita Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 2ft   5997303.382119999 2099336.74248 37.7442239835511 -122.452002277389 (37.7442239835511, -122.452002277389)
50887 50887 43172 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 370 Madison St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/11/2000 12:00:00 AM 2   Permit Number 42981 6005806.0739 2092004.6857099999 37.7245751476096 -122.42208098844101 (37.7245751476096, -122.422080988441)
52495 52495 220079 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 4021 20th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6003566.56829 2104171.42308 37.7578556427516 -122.43069047448799 (37.7578556427516, -122.430690474488)
55738 55738 188509 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 101 Pennsylvania Ave 12 Front Yard : Yard 7 Tree 1 Private 1     2     6014325.646980001 2106424.64729 37.7646461780098 -122.393638496141 (37.7646461780098, -122.393638496141)
59298 59298 203625 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 15 Teresita Blvd 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   5997311.4729 2099621.76413 37.7450070466421 -122.45199486067499 (37.7450070466421, -122.451994860675)
93809 93809 203623 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 15 Teresita Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   5997330.81089 2099592.0734900003 37.744926631064 -122.45192585212 (37.744926631064, -122.45192585212)
136911 136911 220680 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 54 Fair Oaks St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6005359.13512 2103393.3623900004 37.7558206631137 -122.424435681558 (37.7558206631137, -122.424435681558)
152179 152179 220084 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 3580 21st St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6004538.52309 2103691.84305 37.7565938462521 -122.427294885373 (37.7565938462521, -122.427294885373)
167841 167841 43170 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 364 Madison St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/11/2000 12:00:00 AM 2   Permit Number 42979 6005800.19112 2092023.1560099998 37.724625531232796 -122.42210263603701 (37.7246255312328, -122.422102636037)
177773 177773 188511 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 101 Pennsylvania Ave 33 Front Yard : Yard 7 Tree 1 Private 1     2     6014272.76615 2106665.73514 37.7653052137955 -122.393838275126 (37.7653052137955, -122.393838275126)
183611 183611 220078 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 4021 20th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6003547.22001 2104169.9563599997 37.7578505193113 -122.430757284236 (37.7578505193113, -122.430757284236)

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