Street_Tree_List

Data source: data.sfgov.org

18 rows where PlotSize = "4x4" and qLegalStatus = 8

View and edit SQL

Suggested facets: qSpecies, qAddress, SiteOrder, qSiteInfo, PlantDate, DBH, PermitNotes, XCoord, YCoord, Latitude, Longitude, Location

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
14802 24222 Section 143 8 Quercus suber :: Cork Oak 76 54 Whitney Young Cir 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/07/2010 12:00:00 AM 3 4x4 this is original dpw basin record. 6017205.2608 2094992.48681 37.7334154068844 -122.38288292190398 (37.7334154068844, -122.382882921904)
79719 112585 Section 143 8 Lagunaria patersonii :: Primrose Tree 48 3400x WAWONA ST 6 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       4x4   5982411.0 2096792.0 37.7363725426512 -122.50330767262899 (37.7363725426512, -122.503307672629)
80666 85452 Section 143 8 Tree(s) :: 17 275 Guerrero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/12/2014 12:00:00 AM 3 4x4 Permit Number 774478 6006138.0 2107427.0 37.7669400383946 -122.422028645748 (37.7669400383946, -122.422028645748)
81723 85457 Section 143 8 Tree(s) :: 17 265 Guerrero St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/12/2014 12:00:00 AM 3 4x4 Permit Number 774478 6006135.0 2107486.0 37.7671018691982 -122.42204321408998 (37.7671018691982, -122.42204321409)
82449 112583 Section 143 8 Lagunaria patersonii :: Primrose Tree 48 3400x WAWONA ST 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1     1 4x4   5982411.0 2096792.0 37.7363725426512 -122.50330767262899 (37.7363725426512, -122.503307672629)
86995 85449 Section 143 8 Tree(s) :: 17 287 GUERRERO ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/12/2014 12:00:00 AM 3 4x4 Permit Number 774478 6005798.0 2107491.2 37.7670971345308 -122.42320921716801 (37.7670971345308, -122.423209217168)
95747 85451 Section 143 8 Tree(s) :: 17 281 GUERRERO ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/12/2014 12:00:00 AM 3 4x4 Permit Number 774478 6005518.5 2107341.2 37.7666694929162 -122.424165297356 (37.7666694929162, -122.424165297356)
97717 85456 Section 143 8 Tree(s) :: 17 265 Guerrero St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/12/2014 12:00:00 AM 3 4x4 Permit Number 774478 6006135.0 2107486.0 37.7671018691982 -122.42204321408998 (37.7671018691982, -122.42204321409)
105420 85455 Section 143 8 Tree(s) :: 17 265 Guerrero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/12/2014 12:00:00 AM 3 4x4 Permit Number 774478 6006135.0 2107486.0 37.7671018691982 -122.42204321408998 (37.7671018691982, -122.42204321409)
106507 85450 Section 143 8 Tree(s) :: 17 285 Guerrero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/12/2014 12:00:00 AM 3 4x4 Permit Number 774478 6006141.0 2107369.0 37.7667809533476 -122.42201414851601 (37.7667809533476, -122.422014148516)
107223 85454 Section 143 8 Tree(s) :: 17 269 Guerrero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/12/2014 12:00:00 AM 3 4x4 Permit Number 774478 6006135.0 2107486.0 37.7671018691982 -122.42204321408998 (37.7671018691982, -122.42204321409)
108178 112584 Section 143 8 Lagunaria patersonii :: Primrose Tree 48 3400x WAWONA ST 5 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       4x4   5982411.0 2096792.0 37.7363725426512 -122.50330767262899 (37.7363725426512, -122.503307672629)
108448 85460 Section 143 8 Tree(s) :: 17 245x Guerrero St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/12/2014 12:00:00 AM 3 4x4 Permit Number 774478 6006128.0 2107603.0 37.7674227286224 -122.422075738783 (37.7674227286224, -122.422075738783)
111923 85461 Section 143 8 Tree(s) :: 17 245x Guerrero St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/12/2014 12:00:00 AM 3 4x4 Permit Number 774478 6006128.0 2107603.0 37.7674227286224 -122.422075738783 (37.7674227286224, -122.422075738783)
113705 112586 Section 143 8 Lagunaria patersonii :: Primrose Tree 48 3400x WAWONA ST 7 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       4x4   5982411.0 2096792.0 37.7363725426512 -122.50330767262899 (37.7363725426512, -122.503307672629)
116308 85459 Section 143 8 Tree(s) :: 17 245x Guerrero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/12/2014 12:00:00 AM 3 4x4 Permit Number 774478 6006128.0 2107603.0 37.7674227286224 -122.422075738783 (37.7674227286224, -122.422075738783)
126492 85458 Section 143 8 Tree(s) :: 17 265 Guerrero St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/12/2014 12:00:00 AM 3 4x4 Permit Number 774478 6006135.0 2107486.0 37.7671018691982 -122.42204321408998 (37.7671018691982, -122.42204321409)
140578 85453 Section 143 8 Tree(s) :: 17 271 Guerrero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/12/2014 12:00:00 AM 3 4x4 Permit Number 774478 6006135.0 2107486.0 37.7671018691982 -122.42204321408998 (37.7671018691982, -122.42204321409)

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