Street_Tree_List

Data source: data.sfgov.org

17 rows where qCaretaker = 6 and qSiteInfo = 8

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, qSpecies, qAddress, SiteOrder, DBH, PlotSize, XCoord, YCoord, Latitude, Longitude, Location

qCaretaker ✖

  • MTA · 17 ✖
Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
901 901 224716 Property Tree 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 3255x 24th St 5 Front Yard : Cutout 8 Tree 1 MTA 6     13 Width 3ft   6007298.0 2102020.0 37.7521590216883 -122.417633107694 (37.7521590216883, -122.417633107694)
905 905 224715 Property Tree 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 3255x 24th St 4 Front Yard : Cutout 8 Tree 1 MTA 6     12 Width 3ft   6007298.0 2102020.0 37.7521590216883 -122.417633107694 (37.7521590216883, -122.417633107694)
914 914 225888 Property Tree 7 Fraxinus uhdei 'Tomlinson' :: Tomlinson Ash 121 3255x 24th St 1 Front Yard : Cutout 8 Tree 1 MTA 6     32 6x6   6007298.0 2102020.0 37.7521590216883 -122.417633107694 (37.7521590216883, -122.417633107694)
916 916 224714 Property Tree 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 3255x 24th St 3 Front Yard : Cutout 8 Tree 1 MTA 6     11 Width 3ft   6007298.0 2102020.0 37.7521590216883 -122.417633107694 (37.7521590216883, -122.417633107694)
928 928 224422 Property Tree 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 3255x 24th St 2 Front Yard : Cutout 8 Tree 1 MTA 6     16 Width 3ft   6007298.0 2102020.0 37.7521590216883 -122.417633107694 (37.7521590216883, -122.417633107694)
58682 58682 116625 Undocumented 2 Olea europaea :: Olive Tree 41 5732X GEARY BLVD 6 Front Yard : Cutout 8 Tree 1 MTA 6 DPW 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
84743 84743 116631 Undocumented 2 Olea europaea :: Olive Tree 41 5732X GEARY BLVD 12 Front Yard : Cutout 8 Tree 1 MTA 6 DPW 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
96632 96632 116628 Undocumented 2 Olea europaea :: Olive Tree 41 5732X GEARY BLVD 9 Front Yard : Cutout 8 Tree 1 MTA 6 DPW 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
98906 98906 116629 Undocumented 2 Olea europaea :: Olive Tree 41 5732X GEARY BLVD 10 Front Yard : Cutout 8 Tree 1 MTA 6 DPW 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
100355 100355 116620 Undocumented 2 Olea europaea :: Olive Tree 41 5732X GEARY BLVD 1 Front Yard : Cutout 8 Tree 1 MTA 6 DPW 4   12 3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
111008 111008 116626 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 5732X GEARY BLVD 7 Front Yard : Cutout 8 Tree 1 MTA 6 DPW 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
113343 113343 116624 Undocumented 2 Olea europaea :: Olive Tree 41 5732X GEARY BLVD 5 Front Yard : Cutout 8 Tree 1 MTA 6 DPW 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
119101 119101 116621 Undocumented 2 Olea europaea :: Olive Tree 41 5732X GEARY BLVD 2 Front Yard : Cutout 8 Tree 1 MTA 6 DPW 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
123257 123257 116622 Undocumented 2 Olea europaea :: Olive Tree 41 5732X GEARY BLVD 3 Front Yard : Cutout 8 Tree 1 MTA 6 DPW 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
124339 124339 116630 Undocumented 2 Olea europaea :: Olive Tree 41 5732X GEARY BLVD 11 Front Yard : Cutout 8 Tree 1 MTA 6 DPW 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
125790 125790 116627 Undocumented 2 Olea europaea :: Olive Tree 41 5732X GEARY BLVD 8 Front Yard : Cutout 8 Tree 1 MTA 6 DPW 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)
142683 142683 116623 Undocumented 2 Olea europaea :: Olive Tree 41 5732X GEARY BLVD 4 Front Yard : Cutout 8 Tree 1 MTA 6 DPW 4     3x3   5989254.0 2112678.0 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646)

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