Street_Tree_List

Data source: data.sfgov.org

19 rows where DBH = 11 and qSpecies = 56

✎ View and edit SQL

This data as json, CSV (advanced)

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

DBH ✖

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
29546 29546 51129 Permitted Site 1 Koelreuteria paniculata :: Golden Rain Tree 56 420@ 6TH ST Berry St 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/27/2004 12:00:00 AM 11   Permit Number 47557 6012752.45555 2108845.8204 37.771206634319604 -122.399249755781 (37.7712066343196, -122.399249755781)
30841 30841 191185 Undocumented 2 Koelreuteria paniculata :: Golden Rain Tree 56 455 Berry St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 5ft   6012824.91108 2108848.72466 37.771218646544796 -122.398999331472 (37.7712186465448, -122.398999331472)
31442 31442 190876 Undocumented 2 Koelreuteria paniculata :: Golden Rain Tree 56 200 Berry St 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 5ft   6014000.4231 2110033.4394799997 37.7745370423846 -122.395016150475 (37.7745370423846, -122.395016150475)
39775 39775 190883 Undocumented 2 Koelreuteria paniculata :: Golden Rain Tree 56 200 Berry St 15 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 5ft   6013873.47298 2109914.30542 37.774202866892296 -122.39544695094101 (37.7742028668923, -122.395446950941)
42670 42670 85223 Permitted Site 1 Koelreuteria paniculata :: Golden Rain Tree 56 355 Berry St 1 : 4 Tree 1 Private 1   07/19/2007 12:00:00 AM 11   Permit Number 49539 6013205.26566 2109218.0492700003 37.7722539164092 -122.397709569661 (37.7722539164092, -122.397709569661)
43589 43589 85228 Permitted Site 1 Koelreuteria paniculata :: Golden Rain Tree 56 355 Berry St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/19/2007 12:00:00 AM 11   Permit Number 49539 6013295.28168 2109303.69122 37.7724940821684 -122.397404201236 (37.7724940821684, -122.397404201236)
49243 49243 190866 Undocumented 2 Koelreuteria paniculata :: Golden Rain Tree 56 180 Berry St 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 5ft   6014217.98901 2110241.26669 37.77511978508729 -122.39427809576799 (37.7751197850873, -122.394278095768)
58070 58070 190867 Undocumented 2 Koelreuteria paniculata :: Golden Rain Tree 56 180 Berry St 11 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 5ft   6014182.028630001 2110206.1993400003 37.775021499078704 -122.394400035746 (37.7750214990787, -122.394400035746)
71692 71692 191189 Undocumented 2 Koelreuteria paniculata :: Golden Rain Tree 56 401 Berry St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 5ft   6012941.17318 2108959.67719 37.77152977510529 -122.398604960769 (37.7715297751053, -122.398604960769)
129961 129961 190839 Undocumented 2 Koelreuteria paniculata :: Golden Rain Tree 56 150 Berry St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 5ft   6015047.6106 2111033.73325 37.7773418012199 -122.391463640434 (37.7773418012199, -122.391463640434)
131734 131734 190878 Undocumented 2 Koelreuteria paniculata :: Golden Rain Tree 56 200 Berry St 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 5ft   6013965.63522 2109999.0413900004 37.7744406584436 -122.395134079478 (37.7744406584436, -122.395134079478)
133485 133485 190865 Undocumented 2 Koelreuteria paniculata :: Golden Rain Tree 56 180 Berry St 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 5ft   6014236.68547 2110259.82497 37.7751717811919 -122.39421471965099 (37.7751717811919, -122.394214719651)
166088 166088 190834 Undocumented 2 Koelreuteria paniculata :: Golden Rain Tree 56 703 San Bruno Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   6011015.81631 2105024.6924 37.760617744045206 -122.40498780276 (37.7606177440452, -122.40498780276)
169870 169870 190862 Undocumented 2 Koelreuteria paniculata :: Golden Rain Tree 56 180 Berry St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 5ft   6014289.87185 2110309.5547 37.7753112840173 -122.394034216714 (37.7753112840173, -122.394034216714)
172546 172546 85229 Permitted Site 1 Koelreuteria paniculata :: Golden Rain Tree 56 355 Berry St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/19/2007 12:00:00 AM 11   Permit Number 49539 6013312.02436 2109319.91751 37.7725395680802 -122.39734742435199 (37.7725395680802, -122.397347424352)
183780 183780 119659 Undocumented 2 Koelreuteria paniculata :: Golden Rain Tree 56 401X Berry St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 3x3   6012884.61917 2108905.3838400003 37.7713775468798 -122.398796774473 (37.7713775468798, -122.398796774473)
186155 186155 190885 Undocumented 2 Koelreuteria paniculata :: Golden Rain Tree 56 255 Berry St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 5ft   6013937.025669999 2109920.0269400002 37.774222111483795 -122.395227510053 (37.7742221114838, -122.395227510053)
187257 187257 190881 Undocumented 2 Koelreuteria paniculata :: Golden Rain Tree 56 200 Berry St 13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 5ft   6013910.78759 2109947.4980099997 37.774296081645396 -122.395320197769 (37.7742960816454, -122.395320197769)
188200 188200 190842 Undocumented 2 Koelreuteria paniculata :: Golden Rain Tree 56 150 Berry St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 5ft   6014886.13724 2110878.3396 37.776906161529205 -122.39201136443998 (37.7769061615292, -122.39201136444)

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