Street_Tree_List

Data source: data.sfgov.org

19 rows where PlotSize = "Width 4ft" and qSpecies = 72

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qAddress, SiteOrder, qSiteInfo, DBH

PlotSize ✖

  • Width 4ft · 19 ✖
Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
24177 24177 237873 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 1200 San Jose Ave 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 4ft   6004198.3369 2096122.91618 37.7357920776323 -122.427932046027 (37.7357920776323, -122.427932046027)
29426 29426 117740 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 475 39th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 4ft   5983746.49746 2112674.00016 37.7800584750229 -122.499863945897 (37.7800584750229, -122.499863945897)
36470 36470 237886 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 286 Upper Ter 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 4ft   5999373.81016 2106048.64713 37.7627716059584 -122.445325703321 (37.7627716059584, -122.445325703321)
36891 36891 135862 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 8 Kimball Pl 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 4ft   6008000.712730001 2116486.83875 37.791921065252204 -122.416227532369 (37.7919210652522, -122.416227532369)
39539 39539 135867 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 2881 Vallejo St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 4ft   5999809.285519999 2117392.98346 37.7939450956373 -122.44463496643401 (37.7939450956373, -122.444634966434)
42168 42168 237919 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 1182 Clayton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 4ft   5998950.43455 2105771.37241 37.7619861021088 -122.446770052318 (37.7619861021088, -122.446770052318)
47260 47260 237897 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 1351 Alabama St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 4ft   6009296.40092 2101303.05308 37.7503026946211 -122.41067167815399 (37.7503026946211, -122.410671678154)
53560 53560 135870 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 2550 Pierce St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 4ft   6001706.98139 2117190.01379 37.7934958986807 -122.438054218747 (37.7934958986807, -122.438054218747)
57776 57776 237917 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 1295 Stanyan St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 4ft   5997516.67396 2104938.08371 37.7596160926213 -122.45166873503 (37.7596160926213, -122.45166873503)
60540 60540 135872 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 2550 Pierce St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 4ft   6001695.18556 2117280.97246 37.7937449767048 -122.43810155185601 (37.7937449767048, -122.438101551856)
67839 67839 135863 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 8 Kimball Pl 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 4ft   6007998.64807 2116497.60836 37.7919505198577 -122.416235439221 (37.7919505198577, -122.416235439221)
70609 70609 237916 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 1295 Stanyan St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 4ft   5997518.24966 2104934.77487 37.7596070976188 -122.451663046815 (37.7596070976188, -122.451663046815)
75667 75667 123051 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 544 Funston Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 4ft   5991925.368290001 2111718.74321 37.777912168825004 -122.47150017707199 (37.777912168825, -122.471500177072)
130531 130531 237915 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 1295 Stanyan St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 4ft   5997519.793 2104903.6211900003 37.7595216458395 -122.451655461936 (37.7595216458395, -122.451655461936)
147995 147995 135868 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 2881 Vallejo St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 4ft   5999820.06951 2117394.7311 37.7939505095535 -122.444597778561 (37.7939505095535, -122.444597778561)
155130 155130 237898 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 1087 Florida St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 4ft   6009471.98593 2102823.41576 37.754487114207 -122.41017181789101 (37.754487114207, -122.410171817891)
168000 168000 135869 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 2550 Pierce St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 4ft   6001710.05375 2117173.2312 37.7934499927743 -122.43804238544901 (37.7934499927743, -122.438042385449)
171158 171158 135864 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 2451 Steiner St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 4ft   6002234.27154 2116544.43758 37.791753285928294 -122.43618353624201 (37.7917532859283, -122.436183536242)
182972 182972 135871 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 2550 Pierce St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 4ft   6001702.83254 2117214.86813 37.7935639062924 -122.43807035526001 (37.7935639062924, -122.43807035526)

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