Street_Tree_List

Data source: data.sfgov.org

18 rows where SiteOrder = 9 and qSiteInfo = 10

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, qSpecies, DBH, PlotSize

SiteOrder ✖

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
35364 35364 128452 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 251 Leidesdorff St 9 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     3 Width 4ft   6012151.25811 2116572.97679 37.7923900877774 -122.401872599739 (37.7923900877774, -122.401872599739)
39211 39211 221969 Undocumented 2 Ailanthus altissima :: Tree Of Heaven 401 3900 22nd St 9 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     5 Width 4ft   6002406.820619999 2102995.69652 37.754561606858296 -122.434617293171 (37.7545616068583, -122.434617293171)
41984 41984 135853 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 12 Filbert St 9 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     26     6012286.0131 2120198.4327700003 37.8023522396158 -122.40166127704799 (37.8023522396158, -122.401661277048)
44223 44223 128534 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 400 California St 9 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     7 Width 4ft   6012182.93636 2116816.5819200003 37.7930607374112 -122.40178012248 (37.7930607374112, -122.40178012248)
45138 45138 225105 Undocumented 2 Cercis canadensis :: Eastern Redbud 299 588 Ogden Ave 9 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     4 Width 4ft   6007741.08263 2096149.3925599998 37.736064564124206 -122.415685225898 (37.7360645641242, -122.415685225898)
51998 51998 131216 Undocumented 2 Melaleuca quinquenervia :: Cajeput 50 501 Jones St 9 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     4 Width 4ft   6008906.871669999 2114338.43634 37.7860729844153 -122.412940240507 (37.7860729844153, -122.412940240507)
53213 53213 179976 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 670 Brunswick St 9 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     7     5998720.79345 2086710.36043 37.709635974902504 -122.446193129116 (37.7096359749025, -122.446193129116)
58222 58222 190248 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 60 New Montgomery St 9 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     3 Width 3ft   6012269.23486 2114994.91979 37.788063699414394 -122.401353446303 (37.7880636994144, -122.401353446303)
70316 70316 222536 Undocumented 2 Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 1626 Diamond St 9 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     2 Width 8ft   6002000.604180001 2099254.59883 37.7442663713055 -122.43575444811898 (37.7442663713055, -122.435754448119)
71337 71337 190343 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 101 Howard St 9 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     4 Width 3ft   6014833.65153 2116067.9736900004 37.7911528005014 -122.39255603344499 (37.7911528005014, -122.392556033445)
99815 99815 93895 Permitted Site 1 Tree(s) :: 17 425 Folsom St 9 Sidewalk: Curb side : Pot 10 Tree 1 Private 1       3x3   6014407.0 2114805.0 37.787661263759 -122.393943797302 (37.787661263759, -122.393943797302)
135743 135743 222993 Undocumented 2 Cotoneaster SPP :: Cotoneaster 234 502 28th St 9 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     17     6002546.229730001 2099483.20236 37.7449250410506 -122.43388413076 (37.7449250410506, -122.43388413076)
148770 148770 128757 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 145 Geary St 9 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     5 Width 4ft   6010952.86492 2114849.98538 37.7875922118533 -122.40589766486201 (37.7875922118533, -122.405897664862)
160500 160500 189234 Undocumented 2 Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 1919 22nd St 9 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     2 Width 3ft   6012405.15003 2103734.72302 37.757153337862206 -122.400092102164 (37.7571533378622, -122.400092102164)
169554 169554 197514 Undocumented 2 Schinus terebinthifolius :: Brazilian Pepper 25 1275 Harrison St 9 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     15     6009780.84318 2109499.43172 37.7728352390743 -122.409574863193 (37.7728352390743, -122.409574863193)
173820 173820 127515 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 335 Powell St 9 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     5 Width 4ft   6010244.58304 2114855.01998 37.787566398622495 -122.40834854674699 (37.7875663986225, -122.408348546747)
177604 177604 190238 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 536 Mission St 9 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     6 Width 4ft   6013026.80272 2115299.87413 37.7889432705555 -122.398753786863 (37.7889432705555, -122.398753786863)
182271 182271 130978 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 2801 Webster St 9 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     1 Width 2ft   6002959.932159999 2118244.90398 37.7964635301195 -122.433794348725 (37.7964635301195, -122.433794348725)

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