Street_Tree_List

Data source: data.sfgov.org

9 rows where SiteOrder = 9 and qCaretaker = 10

View and edit SQL

Suggested facets: qLegalStatus, qSpecies, qSiteInfo, qCareAssistant, PlotSize

SiteOrder

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
2532 246847 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 301 Broderick St 9 : 4 Tree 1 DPW for City Agency 10     9 Width 3ft   6001212.96216 2109784.10249 37.773133053181404 -122.43923249339198 (37.7731330531814, -122.439232493392)
12506 98216 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1501X 42nd Ave 9 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10 SFUSD 6   30 3x12   5983098.741 2104521.6922 37.7576365448231 -122.50150154301201 (37.7576365448231, -122.501501543012)
77610 109992 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 501X Shotwell St 9 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10 DPW 4     3x3   6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022)
89481 98733 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 360 Grove St 9 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10     13 3x3   6006078.7 2111522.5 37.778181953323 -122.422524803295 (37.778181953323, -122.422524803295)
94908 95038 DPW Maintained 3 Ficus nitida :: Laurel Fig 43 3224 Pierce St 9 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10       3x3   6001388.0 2119447.0 37.79967484547421 -122.43931976889999 (37.7996748454742, -122.4393197689)
116544 113872 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 301x BRODERICK ST 9 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10       3x3   6001207.0 2109749.0 37.7730363312645 -122.43925060074899 (37.7730363312645, -122.439250600749)
126528 111776 Undocumented 2 Liquidambar styraciflua :: American Sweet Gum 62 2030x HAYES ST 9 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10 SFUSD 6     5x5.5   5998060.0 2109954.0 37.773419625938295 -122.450151194281 (37.7734196259383, -122.450151194281)
141271 113816 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 4101x 25TH ST 9 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10 SFUSD 6   10 3x3   6002889.0 2101238.0 37.7497627495089 -122.43282423123999 (37.7497627495089, -122.43282423124)
158337 98798 DPW Maintained 3 Magnolia grandiflora :: Southern Magnolia 21 950@Washington Clay St 9 Sidewalk: Curb side : Cutout 1 Tree 1 DPW for City Agency 10   03/16/2012 12:00:00 AM 22 3x3 Permit Number 768771 6010098.5697800005 2117188.54171 37.7939655093431 -122.409018439172 (37.7939655093431, -122.409018439172)

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