Street_Tree_List

Data source: data.sfgov.org

35 rows where qCaretaker = 7

View and edit SQL

Suggested facets: qLegalStatus, qSpecies, qAddress, SiteOrder, qSiteInfo, PlantDate, DBH, PlotSize, 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
433 251301 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 100 Whitney Young Cir 2 Back Yard : Yard 13 Tree 1 Mayor Office of Housing 7       3x3   6016360.0 2096059.0 37.736297099957106 -122.385879567348 (37.7362970999571, -122.385879567348)
917 8555 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 2141 Geary Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 Mayor Office of Housing 7     18 3X3   6001312.669 2113446.883 37.7831957953331 -122.43915016448999 (37.7831957953331, -122.43915016449)
1415 9957 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 165X Grove St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Mayor Office of Housing 7     18 4x4   6007023.214790001 2111521.59802 37.778232715494205 -122.41925731148399 (37.7782327154942, -122.419257311484)
4670 9956 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 155 Grove St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Mayor Office of Housing 7     12 4X4   6007076.052730001 2111529.8614 37.7782583803491 -122.41907511154801 (37.7782583803491, -122.419075111548)
6381 8554 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 2141 Geary Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Mayor Office of Housing 7     36 3x3   6001288.9794 2113445.5293 37.7831907304059 -122.439232023736 (37.7831907304059, -122.439232023736)
7008 26432 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 1450 Divisadero St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Mayor Office of Housing 7   01/01/2010 12:00:00 AM 3 3X3   6001275.1888 2113317.3521 37.7828380038034 -122.43927054326201 (37.7828380038034, -122.439270543262)
7280 24641 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 1450 Divisadero St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Mayor Office of Housing 7   01/01/2010 12:00:00 AM 3 3X3   6001279.2498 2113291.6319999998 37.7827676140685 -122.43925464983 (37.7827676140685, -122.43925464983)
7326 8558 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 2141 Geary Blvd 5 Sidewalk: Curb side : Cutout 1 Tree 1 Mayor Office of Housing 7     18 3x3   6001389.1705 2113457.8415 37.7832302373637 -122.43888628620701 (37.7832302373637, -122.438886286207)
8633 95172 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 1450 Divisadero St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Mayor Office of Housing 7   12/24/2014 01:10:00 PM 3 3x3   6001274.5119 2113333.5963 37.782882567708896 -122.439274049752 (37.7828825677089, -122.439274049752)
19598 16804 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 2060 O'Farrell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Mayor Office of Housing 7     18 4x3   6001450.7704065 2113227.696464 37.7826018222756 -122.438656679492 (37.7826018222756, -122.438656679492)
77318 5288 Permitted Site 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 1450 Divisadero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Mayor Office of Housing 7   01/01/2010 12:00:00 AM 3 3X3   6001279.390109099 2113342.5749494 37.7829074983832 -122.439257816981 (37.7829074983832, -122.439257816981)
78914 8553 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 2121 Geary Blvd 8 Sidewalk: Curb side : Cutout 1 Tree 1 Mayor Office of Housing 7     24 3X3   6001601.9223045 2113552.6348977 37.783502617914294 -122.438157044438 (37.7835026179143, -122.438157044438)
84260 16794 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 2040 O'Farrell St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Mayor Office of Housing 7     24 4X3   6001550.419691599 2113241.6119033 37.7826456988205 -122.438312933736 (37.7826456988205, -122.438312933736)
87019 116702 Permitted Site 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 1450 Divisadero St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Mayor Office of Housing 7       3X3   6001279.390109099 2113342.5749494 37.7829074983832 -122.439257816981 (37.7829074983832, -122.439257816981)
87633 5290 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 2070X O'Farrell St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Mayor Office of Housing 7     18 3X3   6001402.6275094 2113220.9735965 37.78258062415 -122.43882275095 (37.78258062415, -122.43882275095)
87869 8551 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 2121 Geary Blvd 6 Sidewalk: Curb side : Cutout 1 Tree 1 Mayor Office of Housing 7     24 3X3   6001601.9223045 2113552.6348977 37.783502617914294 -122.438157044438 (37.7835026179143, -122.438157044438)
94952 16810 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 2060 O'Farrell St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Mayor Office of Housing 7     18 3x3   6001450.7704065 2113227.696464 37.7826018222756 -122.438656679492 (37.7826018222756, -122.438656679492)
98904 5289 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 2070X O'Farrell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Mayor Office of Housing 7     18 3X3   6001402.6275094 2113220.9735965 37.78258062415 -122.43882275095 (37.78258062415, -122.43882275095)
103357 16808 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 2060 O'Farrell St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Mayor Office of Housing 7     18 4x3   6001450.7704065 2113227.696464 37.7826018222756 -122.438656679492 (37.7826018222756, -122.438656679492)
104346 8547 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 2121 Geary Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 Mayor Office of Housing 7     24 3X3   6001601.9223045 2113552.6348977 37.783502617914294 -122.438157044438 (37.7835026179143, -122.438157044438)
104978 8552 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 2121 Geary Blvd 7 Sidewalk: Curb side : Cutout 1 Tree 1 Mayor Office of Housing 7     30 3X3   6001601.9223045 2113552.6348977 37.783502617914294 -122.438157044438 (37.7835026179143, -122.438157044438)
106882 16806 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 2060 O'Farrell St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Mayor Office of Housing 7     18 4x3   6001450.7704065 2113227.696464 37.7826018222756 -122.438656679492 (37.7826018222756, -122.438656679492)
111436 16809 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 2060 O'Farrell St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Mayor Office of Housing 7     18 3x3   6001450.7704065 2113227.696464 37.7826018222756 -122.438656679492 (37.7826018222756, -122.438656679492)
114115 16807 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 2060 O'Farrell St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Mayor Office of Housing 7     18 3x3   6001450.7704065 2113227.696464 37.7826018222756 -122.438656679492 (37.7826018222756, -122.438656679492)
115154 16793 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 2040 O'Farrell St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Mayor Office of Housing 7     18 4X3   6001550.419691599 2113241.6119033 37.7826456988205 -122.438312933736 (37.7826456988205, -122.438312933736)
116216 8546 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 2121 Geary Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Mayor Office of Housing 7     30 3X3   6001601.9223045 2113552.6348977 37.783502617914294 -122.438157044438 (37.7835026179143, -122.438157044438)
121872 5291 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 2070X O'Farrell St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Mayor Office of Housing 7     18 4X3   6001402.6275094 2113220.9735965 37.78258062415 -122.43882275095 (37.78258062415, -122.43882275095)
122525 8549 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 2121 Geary Blvd 4 Sidewalk: Curb side : Cutout 1 Tree 1 Mayor Office of Housing 7     30 3X3   6001601.9223045 2113552.6348977 37.783502617914294 -122.438157044438 (37.7835026179143, -122.438157044438)
122818 8559 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 2141 Geary Blvd 6 Sidewalk: Curb side : Cutout 1 Tree 1 Mayor Office of Housing 7     18 3x3   6001514.3606953 2113518.2076175 37.783403109123995 -122.43845750560699 (37.783403109124, -122.438457505607)
123152 8557 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 2141 Geary Blvd 4 Sidewalk: Curb side : Cutout 1 Tree 1 Mayor Office of Housing 7     24 3x3   6001514.3606953 2113518.2076175 37.783403109123995 -122.43845750560699 (37.783403109124, -122.438457505607)
124398 116701 Permitted Site 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 1450 Divisadero St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Mayor Office of Housing 7       3X3   6001279.390109099 2113342.5749494 37.7829074983832 -122.439257816981 (37.7829074983832, -122.439257816981)
124399 5293 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 1500 Divisadero St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Mayor Office of Housing 7     12 3x3   6001245.27295 2113493.90626 37.7833210739867 -122.439386698953 (37.7833210739867, -122.439386698953)
127068 8550 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 2121 Geary Blvd 5 Sidewalk: Curb side : Cutout 1 Tree 1 Mayor Office of Housing 7     30 3X3   6001601.9223045 2113552.6348977 37.783502617914294 -122.438157044438 (37.7835026179143, -122.438157044438)
141685 16805 Permitted Site 1 Corymbia ficifolia :: Red Flowering Gum 60 2060 O'Farrell St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Mayor Office of Housing 7     18 3x3   6001450.7704065 2113227.696464 37.7826018222756 -122.438656679492 (37.7826018222756, -122.438656679492)
144167 8548 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 2121 Geary Blvd 3 Sidewalk: Curb side : Cutout 1 Tree 1 Mayor Office of Housing 7     30 3X3   6001601.9223045 2113552.6348977 37.783502617914294 -122.438157044438 (37.7835026179143, -122.438157044438)

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