Street_Tree_List

Data source: data.sfgov.org

23 rows where qSiteInfo = 9 and qSpecies = 42

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, qAddress, SiteOrder, DBH, PlotSize, XCoord, Latitude, Longitude, Location

qSiteInfo ✖

  • Sidewalk: Property side : Yard · 23 ✖
Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
19697 19697 85509 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 1 Nebraska St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1         Permit Number 49678 6009335.0 2098038.0 37.7413397420659 -122.410307693317 (37.7413397420659, -122.410307693317)
31523 31523 188515 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 1401 25th St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1     6014455.23285 2101981.54762 37.752453585184604 -122.39287941707799 (37.7524535851846, -122.392879417078)
31819 31819 220062 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 430 College Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13 Width 3ft   6005376.5701 2095055.5296099999 37.7329278583224 -122.423782556133 (37.7329278583224, -122.423782556133)
38771 38771 174961 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 54 Santa Ynez Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4     6000769.59798 2092028.9930200002 37.7243565377 -122.43949313040899 (37.7243565377, -122.439493130409)
41593 41593 220031 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 541 Grand View Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 5ft   6000040.44223 2101732.89415 37.7509596367958 -122.44271016275101 (37.7509596367958, -122.442710162751)
41760 41760 203657 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 226 Joost Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12 Width 10ft   6000556.64604 2094979.3129099999 37.7324453144793 -122.440440771241 (37.7324453144793, -122.440440771241)
42561 42561 203661 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 582 Mangels Ave 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 10ft   5997537.55728 2095290.5878599999 37.7331276310309 -122.450900858796 (37.7331276310309, -122.450900858796)
66468 66468 203632 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 1400 Monterey Blvd 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 10ft   5993831.29855 2094857.6984 37.7317261536347 -122.463682879865 (37.7317261536347, -122.463682879865)
69465 69465 188516 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 1506 25th St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 4ft   6014137.77003 2102020.8067900003 37.7525437439982 -122.39398001279301 (37.7525437439982, -122.393980012793)
77508 77508 85510 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 1 Nebraska St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1         Permit Number 49678 6009335.0 2098038.0 37.7413397420659 -122.410307693317 (37.7413397420659, -122.410307693317)
88150 88150 121723 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 199 Burnside Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10     6001086.0 2095247.0 37.7332104486713 -122.438629847451 (37.7332104486713, -122.438629847451)
117346 117346 85502 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 1 Nebraska St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1           6009335.0 2098038.0 37.7413397420659 -122.410307693317 (37.7413397420659, -122.410307693317)
146004 146004 203662 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 337 Detroit St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 5ft   5999398.70847 2094267.55477 37.7304249920009 -122.44439288782301 (37.7304249920009, -122.444392887823)
149197 149197 203647 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 70 Manor Dr 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 3ft   5993596.72892 2093377.0999599998 37.7276472749004 -122.46438636913099 (37.7276472749004, -122.464386369131)
151268 151268 203651 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 1390 Monterey Blvd 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 3ft   5993846.97887 2094818.6059299998 37.731619718855704 -122.46362583408701 (37.7316197188557, -122.463625834087)
157925 157925 203650 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 1390 Monterey Blvd 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 3ft   5993848.38247 2094813.0241599998 37.7316044735649 -122.46362057664699 (37.7316044735649, -122.463620576647)
158134 158134 203631 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 1400 Monterey Blvd 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 10ft   5993837.01835 2094842.09298 37.7316836345786 -122.46366197331801 (37.7316836345786, -122.463661973318)
166995 166995 203640 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 216 Ralston St 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13 Width 5ft   5992221.60329 2089317.4306299998 37.7164210557753 -122.468844858002 (37.7164210557753, -122.468844858002)
168971 168971 220018 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 1129 Douglass St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 6ft   6001364.34858 2100418.37342 37.7474256590636 -122.43803782498999 (37.7474256590636, -122.43803782499)
170022 170022 220032 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 4496 24th St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 5ft   6000063.08667 2101692.20447 37.7508492036437 -122.442628935085 (37.7508492036437, -122.442628935085)
170043 170043 203639 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 216 Ralston St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 5ft   5992221.12373 2089294.63928 37.7163584485498 -122.46884485801701 (37.7163584485498, -122.468844858017)
178200 178200 203649 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 1390 Monterey Blvd 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 3ft   5993852.26622 2094804.8663700002 37.731582298063394 -122.46360655802201 (37.7315822980634, -122.463606558022)
186555 186555 203630 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 1400 Monterey Blvd 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 10ft   5993843.17005 2094826.47883 37.731641116434496 -122.46363957301 (37.7316411164345, -122.46363957301)

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