Street_Tree_List

Data source: data.sfgov.org

24 rows where qSiteInfo = 2 and qSpecies = 20

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qAddress, SiteOrder, DBH, PlotSize

qSiteInfo ✖

  • Sidewalk: Curb side : Yard · 24 ✖
Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
24183 24183 175768 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 0 Gonzalez Dr 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13     5989578.68884 2089185.3656400002 37.7159053925979 -122.47797031747801 (37.7159053925979, -122.477970317478)
24841 24841 175769 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 0 Gonzalez Dr 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6     5989661.94364 2089233.64885 37.716042798215206 -122.477686080452 (37.7160427982152, -122.477686080452)
28542 28542 204628 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 1901 Monterey Blvd 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 4ft   5992344.57273 2095377.42888 37.733067423224 -122.46886055298701 (37.733067423224, -122.468860552987)
34559 34559 175753 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 755 London St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12     6000826.82092 2089512.30625 37.7174495420436 -122.439115030257 (37.7174495420436, -122.439115030257)
41434 41434 175767 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 0 Gonzalez Dr 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13     5989494.93952 2089175.43765 37.7158732715029 -122.478259065526 (37.7158732715029, -122.478259065526)
44057 44057 175774 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 0 Gonzalez Dr 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9     5990113.97654 2089437.91841 37.7166298945381 -122.47613856845 (37.7166298945381, -122.47613856845)
44691 44691 175766 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 0 Gonzalez Dr 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13     5989094.03032 2089506.27121 37.7167583770722 -122.47966897135001 (37.7167583770722, -122.47966897135)
58207 58207 204627 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 1901 Monterey Blvd 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 4ft   5992327.28359 2095380.5803 37.7330750773552 -122.46892055484301 (37.7330750773552, -122.468920554843)
59851 59851 175772 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 0 Gonzalez Dr 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9     5989911.02174 2089222.5365 37.716026738112 -122.47682434649201 (37.716026738112, -122.476824346492)
61227 61227 140862 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 100 Jordan Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 0ft   5996243.3642 2113769.3144 37.783791348572706 -122.456711139169 (37.7837913485727, -122.456711139169)
131647 131647 175755 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 10 Ruth St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 2ft   6001686.67815 2091578.8653 37.7231727394058 -122.43629071923401 (37.7231727394058, -122.436290719234)
137747 137747 204626 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 1901 Monterey Blvd 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 4ft   5992297.08253 2095382.05199 37.7330773733083 -122.46902507404499 (37.7330773733083, -122.469025074045)
152106 152106 204613 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 1440 16th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 4ft   5991174.12963 2105607.5581900002 37.7610890166517 -122.47365304285401 (37.7610890166517, -122.473653042854)
154455 154455 175771 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 0 Gonzalez Dr 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5     5989791.935380001 2089208.15493 37.7159803412063 -122.477234910356 (37.7159803412063, -122.477234910356)
157425 157425 124076 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 701 Funston Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 3ft   5991934.28865 2110305.99584 37.7740336644487 -122.471366355947 (37.7740336644487, -122.471366355947)
161999 161999 218270 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 1456 Portola Dr 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15 Width 5ft   5992782.12061 2097251.65776 37.73823885594471 -122.46748409202 (37.7382388559447, -122.46748409202)
164499 164499 204646 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 111 Ashton Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5994133.91606 2090657.47285 37.7202107871682 -122.462332152117 (37.7202107871682, -122.462332152117)
167088 167088 175765 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 0 Gonzalez Dr 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     18     5988629.85447 2089774.3019599998 37.7174673468061 -122.481292995899 (37.7174673468061, -122.481292995899)
171701 171701 175770 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 0 Gonzalez Dr 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     27     5989758.80887 2089246.54995 37.7160838423675 -122.477352214341 (37.7160838423675, -122.477352214341)
172522 172522 204657 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 2200 Mesa Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   5993588.18999 2100755.25284 37.7479053493615 -122.46495150490601 (37.7479053493615, -122.464951504906)
180214 180214 175773 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 0 Gonzalez Dr 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14     5990089.9017900005 2089410.48117 37.716553162587296 -122.476219779021 (37.7165531625873, -122.476219779021)
180450 180450 218271 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 1456 Portola Dr 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     16 Width 5ft   5992773.33281 2097243.56743 37.738216134576795 -122.467513887457 (37.7382161345768, -122.467513887457)
181339 181339 124077 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 701 Funston Ave 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 3ft   5991933.739630001 2110279.93645 37.7739620806591 -122.471366355942 (37.7739620806591, -122.471366355942)
185920 185920 204625 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 1901 Monterey Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 4ft   5992281.41366 2095382.3817200002 37.733077373320896 -122.469079268988 (37.7330773733209, -122.469079268988)

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