Street_Tree_List

Data source: data.sfgov.org

24 rows where qSiteInfo = 4 and qSpecies = 27

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qAddress, SiteOrder, DBH

qSiteInfo ✖

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
24738 24738 207248 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 574 Arch St 1 : 4 Tree 1 Private 1     6 Width 3ft   5992756.55156 2091026.1972 37.7211438059241 -122.46711999608401 (37.7211438059241, -122.467119996084)
33451 33451 191410 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 777 Rhode Island St 1 : 4 Tree 1 Private 1     3 Width 3ft   6011870.78856 2104734.77484 37.7598694505299 -122.402010442428 (37.7598694505299, -122.402010442428)
36484 36484 207243 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 324 Lakeview Ave 1 : 4 Tree 1 Private 1     1 Width 3ft   5996808.75565 2089668.4523599998 37.7176488300194 -122.453014817795 (37.7176488300194, -122.453014817795)
39672 39672 207255 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 551 Arch St 1 : 4 Tree 1 Private 1     6 Width 3ft   5992722.91506 2090824.1387 37.72058706082171 -122.467221582632 (37.7205870608217, -122.467221582632)
46658 46658 207264 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 319 Victoria St 1 : 4 Tree 1 Private 1     5 Width 3ft   5993222.99582 2089325.40947 37.716500767187 -122.465384161548 (37.716500767187, -122.465384161548)
48128 48128 207250 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 571 Arch St 1 : 4 Tree 1 Private 1     5 Width 3ft   5992722.93824 2090965.0292099998 37.7209739131985 -122.467231741345 (37.7209739131985, -122.467231741345)
51445 51445 207262 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 510 Ramsell St 2 : 4 Tree 1 Private 1     4 Width 3ft   5993010.6580300005 2090589.3329599998 37.7199589473287 -122.466209899286 (37.7199589473287, -122.466209899286)
59000 59000 227698 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 517 Hickory St 1 : 4 Tree 1 Private 1     1 Width 3ft   6004312.97566 2110291.73585 37.7747028072132 -122.428545336007 (37.7747028072132, -122.428545336007)
62400 62400 207257 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 545 Arch St 2 : 4 Tree 1 Private 1     8 Width 3ft   5992721.30272 2090787.38196 37.7204860426843 -122.467224484748 (37.7204860426843, -122.467224484748)
131761 131761 207244 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 246 Monticello St 1 : 4 Tree 1 Private 1     4 Width 3ft   5991705.04474 2090167.4544799998 37.7187251566245 -122.47069219949199 (37.7187251566245, -122.470692199492)
134488 134488 207256 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 545 Arch St 1 : 4 Tree 1 Private 1     6 Width 3ft   5992721.58386 2090800.7544 37.720522776379596 -122.467224484746 (37.7205227763796, -122.467224484746)
137140 137140 207254 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 559 Arch St 1 : 4 Tree 1 Private 1     6 Width 3ft   5992720.910730001 2090888.5643799999 37.720763842354 -122.467233192875 (37.720763842354, -122.467233192875)
138093 138093 207251 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 567 Arch St 1 : 4 Tree 1 Private 1     2 Width 3ft   5992723.294480001 2090942.0276900001 37.720910777190795 -122.46722883836 (37.7209107771908, -122.46722883836)
156004 156004 207247 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 495 Ralston St 1 : 4 Tree 1 Private 1     4 Width 3ft   5992207.674790001 2091176.35111 37.721524393612 -122.46902820910299 (37.721524393612, -122.469028209103)
156794 156794 207268 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 321 Shields St 1 : 4 Tree 1 Private 1     4 Width 3ft   5993118.56975 2089825.8623400002 37.7178688671261 -122.46578144695299 (37.7178688671261, -122.465781446953)
157438 157438 177007 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 216 Saint Charles Ave 1 : 4 Tree 1 Private 1     5 Width 3ft   5992028.26989 2086999.54978 37.710045543251205 -122.469344489883 (37.7100455432512, -122.469344489883)
158423 158423 207267 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 800 Shields St 1 : 4 Tree 1 Private 1     4 Width 3ft   5991908.73686 2089873.18907 37.71792895264 -122.469966710089 (37.71792895264, -122.469966710089)
166192 166192 207245 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 495 Ralston St 3 : 4 Tree 1 Private 1     4 Width 3ft   5992206.61176 2091125.8340200002 37.7213856246322 -122.469028209083 (37.7213856246322, -122.469028209083)
171030 171030 207253 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 556 Arch St 1 : 4 Tree 1 Private 1     6 Width 3ft   5992754.265459999 2090897.47883 37.7207902446595 -122.46711854461 (37.7207902446595, -122.46711854461)
174314 174314 207252 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 560 Arch St 1 : 4 Tree 1 Private 1     6 Width 3ft   5992752.3271699995 2090925.11248 37.7208660080514 -122.467127252727 (37.7208660080514, -122.467127252727)
176364 176364 207259 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 531 Arch St 1 : 4 Tree 1 Private 1     5 Width 3ft   5992719.90357 2090700.8696700002 37.720248420215 -122.467223034109 (37.720248420215, -122.467223034109)
178299 178299 207249 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 581 Arch St 1 : 4 Tree 1 Private 1     7 Width 3ft   5992725.89958 2091026.00542 37.7211415099655 -122.467225936253 (37.7211415099655, -122.467225936253)
186952 186952 207258 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 532 Arch St 1 : 4 Tree 1 Private 1     7 Width 3ft   5992753.93277 2090721.89417 37.7203081126976 -122.46710693523998 (37.7203081126976, -122.46710693524)
187054 187054 207246 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 495 Ralston St 2 : 4 Tree 1 Private 1     4 Width 3ft   5992206.82998 2091154.32928 37.7214638782474 -122.469029527495 (37.7214638782474, -122.469029527495)

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