Street_Tree_List

Data source: data.sfgov.org

16 rows where DBH = 6 and qSpecies = 72

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, qCaretaker, PlotSize

DBH ✖

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
2707 2707 14854 DPW Maintained 3 Prunus domestica 'Mariposa' :: Mariposa Plum 72 1357 McAllister St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   05/21/1992 12:00:00 AM 6 3x3   6002671.377 2111611.0853 37.7782323757584 -122.43431829621201 (37.7782323757584, -122.434318296212)
6567 6567 18905 DPW Maintained 3 Prunus domestica 'Mariposa' :: Mariposa Plum 72 2602 Sacramento St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 3X3   6002286.89222 2115779.97328 37.789657253131 -122.435946744753 (37.789657253131, -122.435946744753)
36992 36992 181899 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 2374 28th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 0ft   5987671.9860000005 2099129.3564 37.7430981701656 -122.48528992840201 (37.7430981701656, -122.485289928402)
39405 39405 237883 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 74 Oakwood St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6005237.83328 2105067.23866 37.7604098837378 -122.424974271161 (37.7604098837378, -122.424974271161)
43511 43511 237904 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 215 Grand View Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 5ft   6000729.50411 2103183.58085 37.7549821289444 -122.440431357129 (37.7549821289444, -122.440431357129)
45763 45763 237933 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 101 Lower Ter 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 3ft   6000440.92976 2106173.77589 37.7631760355812 -122.441643904037 (37.7631760355812, -122.441643904037)
47303 47303 237934 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 101 Lower Ter 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 3ft   6000443.264219999 2106174.87839 37.76317919578 -122.441635909067 (37.76317919578, -122.441635909067)
52362 52362 237943 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 22 Ohlone Way 1 Back Yard : Yard 13 Tree 1 Private 1     6 Width 3ft   6002178.91966 2096366.0304900003 37.7363451615923 -122.43493133373501 (37.7363451615923, -122.434931333735)
53128 53128 51089 Permitted Site 1 Prunus domestica 'Mariposa' :: Mariposa Plum 72 2550 Pierce St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/26/2004 12:00:00 AM 6   Permit Number 47546 6001713.34736 2117152.10978 37.7933921861489 -122.438029475688 (37.7933921861489, -122.438029475688)
147966 147966 183564 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 2595 30th Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 0ft   5987057.6296 2097628.3948 37.738941118307295 -122.487303955513 (37.7389411183073, -122.487303955513)
164027 164027 237931 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 18 Temple St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 3ft   5999994.62286 2105880.85812 37.7623463174434 -122.443166486857 (37.7623463174434, -122.443166486857)
166087 166087 237935 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 272 Corbett Ave 4 Side Yard : Yard 17 Tree 1 Private 1     6 Width 3ft   5999636.03267 2105332.26436 37.7608195617885 -122.444367285948 (37.7608195617885, -122.444367285948)
170671 170671 237888 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 1294 Stanyan St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5997563.8752 2104944.75074 37.7596371016855 -122.451505971246 (37.7596371016855, -122.451505971246)
171658 171658 214349 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 290 San Fernando Way 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5992100.51565 2094983.26623 37.7319710480083 -122.46967563014299 (37.7319710480083, -122.469675630143)
177430 177430 214323 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 211 Granville Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 5ft   5994213.9284 2098746.3020200003 37.742425335868 -122.462642037812 (37.742425335868, -122.462642037812)
179831 179831 178849 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 13 Liebig St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 1ft   5995911.23484 2086261.34028 37.7082422172863 -122.455870959398 (37.7082422172863, -122.455870959398)

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