Street_Tree_List

Data source: data.sfgov.org

14 rows where SiteOrder = 2, qCaretaker = 2 and qSpecies = 88

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, qSiteInfo, PlantDate, DBH, PlotSize

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
4168 4168 13059 DPW Maintained 3 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 583 Lombard St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   10/28/2015 07:23:00 AM 3 2x2   6009557.0524 2120495.5376 37.8030153566132 -122.41112585507 (37.8030153566132, -122.41112585507)
4899 4899 109487 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1314 POLK ST 2 Sidewalk: Curb side : Pot 10 Tree 1 DPW 2   10/31/2017 02:27:00 PM 3 3x3   6006825.7 2115468.8 37.7890596427133 -122.420220804515 (37.7890596427133, -122.420220804515)
15461 15461 109908 DPW Maintained 3 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1401 Howard St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   07/18/2015 02:04:00 PM 3 3x3 Permit Number 778313 6008340.42119 2109862.66125 37.773751763372395 -122.414583173274 (37.7737517633724, -122.414583173274)
22057 22057 5393 DPW Maintained 3 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 347 Dolores St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   06/10/2014 12:00:00 AM 3 6x7   6004928.4905 2106245.9446799997 37.7636288523174 -122.426128059965 (37.7636288523174, -122.426128059965)
22965 22965 103768 DPW Maintained 3 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1323 Polk St 2 Sidewalk: Curb side : Pot 10 Tree 1 DPW 2   08/21/2013 12:00:00 AM 3 3x3   6006757.0 2115467.0 37.7890508291132 -122.42045837028401 (37.7890508291132, -122.420458370284)
35824 35824 131007 DPW Maintained 3 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 150x Drumm St 2 Median : Yard 3 Tree 1 DPW 2     4 Width 7ft   6013687.07221 2117423.5151299997 37.7948110573238 -122.396618254944 (37.7948110573238, -122.396618254944)
83122 83122 103782 DPW Maintained 3 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1237 Polk St 2 Sidewalk: Curb side : Pot 10 Tree 1 DPW 2   11/01/2009 12:00:00 AM 3 3x3   6006764.1 2115217.5 37.7883661638156 -122.420416088533 (37.7883661638156, -122.420416088533)
89613 89613 24369 DPW Maintained 3 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 134 Duboce Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   07/19/2016 04:44:00 AM 3 3x3   6005829.420761799 2108507.0022787 37.7698880583785 -122.42317275016899 (37.7698880583785, -122.423172750169)
105089 105089 103774 DPW Maintained 3 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1288 Polk St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   11/01/2009 12:00:00 AM 3 3x3   6006856.2 2115250.5 37.7884619632914 -122.420099779635 (37.7884619632914, -122.420099779635)
112678 112678 103864 DPW Maintained 3 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1435 Polk St 2 Sidewalk: Curb side : Pot 10 Tree 1 DPW 2   08/21/2013 12:00:00 AM 3 3x3   6006674.8 2115856.4 37.790115392534 -122.42077042798 (37.790115392534, -122.42077042798)
116356 116356 26561 DPW Maintained 3 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 430 Bay Shore Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/10/2007 12:00:00 AM 3 3X3   6010306.750370901 2097855.6706051 37.740893529599106 -122.406934857164 (37.7408935295991, -122.406934857164)
122862 122862 103867 DPW Maintained 3 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1411 Polk St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   08/21/2013 12:00:00 AM 3 3x3   6006684.9 2115784.5 37.7899185422019 -122.42073037630101 (37.7899185422019, -122.420730376301)
127702 127702 103787 DPW Maintained 3 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1217 Polk St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   11/01/2009 12:00:00 AM 3 3x3   6006790.1 2115111.0 37.7880752061995 -122.42031857060101 (37.7880752061995, -122.420318570601)
143719 143719 8223 DPW Maintained 3 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1500X Galvez Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/10/2015 08:24:00 AM 3 3x3   6016396.247314 2097296.3974116 37.739696749128896 -122.385840466933 (37.7396967491289, -122.385840466933)

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