Street_Tree_List

Data source: data.sfgov.org

19 rows where qSiteInfo = 13 and qSpecies = 39 sorted by qSiteInfo

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, qAddress, SiteOrder, DBH, PlotSize

qSiteInfo ✖

  • Back Yard : Yard · 19 ✖
Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo ▼ PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
669 669 251343 Property Tree 7 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 934 Brannan St 1 Back Yard : Yard 13 Tree 1 Private 1       3x3   6010724.0 2108745.0 37.7708165471861 -122.40625919407302 (37.7708165471861, -122.406259194073)
27119 27119 209185 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 140 Kensington Way 5 Back Yard : Yard 13 Tree 1 Private 1     7 Width 3ft   5994853.690119999 2098493.2474700003 37.741767335194105 -122.460411617495 (37.7417673351941, -122.460411617495)
48070 48070 209184 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 140 Kensington Way 4 Back Yard : Yard 13 Tree 1 Private 1     16 Width 3ft   5994856.4919300005 2098484.57238 37.7417436767315 -122.460401301401 (37.7417436767315, -122.460401301401)
48281 48281 209182 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 140 Kensington Way 2 Back Yard : Yard 13 Tree 1 Private 1     17 Width 3ft   5994867.86795 2098472.15279 37.7417102300345 -122.46036106750799 (37.7417102300345, -122.460361067508)
60639 60639 191813 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 300 Vermont St 6 Back Yard : Yard 13 Tree 1 Private 1     25     6011137.70759 2106686.95849 37.7651887659782 -122.40468325722901 (37.7651887659782, -122.404683257229)
63607 63607 191841 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1501 Davidson Ave 9 Back Yard : Yard 13 Tree 1 Private 1     23     6015067.74656 2099262.4877299997 37.7450216201491 -122.39057124226801 (37.7450216201491, -122.390571242268)
71300 71300 191840 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1501 Davidson Ave 8 Back Yard : Yard 13 Tree 1 Private 1     16     6015034.2062 2099284.7294900003 37.7450808306162 -122.39068877377701 (37.7450808306162, -122.390688773777)
73581 73581 191844 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1501 Davidson Ave 14 Back Yard : Yard 13 Tree 1 Private 1     27     6015247.82087 2099125.91751 37.7446566150196 -122.38993903417 (37.7446566150196, -122.38993903417)
73889 73889 191811 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 300 Vermont St 3 Back Yard : Yard 13 Tree 1 Private 1     24     6011131.47947 2106831.70462 37.76558585803421 -122.40471498982299 (37.7655858580342, -122.404714989823)
172795 172795 191843 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1501 Davidson Ave 11 Back Yard : Yard 13 Tree 1 Private 1     20     6015141.47385 2099207.7707599998 37.7448754686187 -122.390312482158 (37.7448754686187, -122.390312482158)
172941 172941 191812 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 300 Vermont St 5 Back Yard : Yard 13 Tree 1 Private 1     23     6011136.684719999 2106709.3643099996 37.765250230128004 -122.404688372578 (37.765250230128, -122.404688372578)
174819 174819 209181 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 140 Kensington Way 1 Back Yard : Yard 13 Tree 1 Private 1     15 Width 3ft   5994876.85162 2098459.48593 37.7416759667651 -122.46032908762699 (37.7416759667651, -122.460329087627)
177691 177691 209186 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 140 Kensington Way 6 Back Yard : Yard 13 Tree 1 Private 1     12 Width 3ft   5994849.5459 2098494.81966 37.741771413634794 -122.46042606063 (37.7417714136348, -122.46042606063)
177754 177754 209147 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 75 Ralston St 3 Back Yard : Yard 13 Tree 1 Private 1     16     5992171.618 2088327.33496 37.7136996047335 -122.46894561897 (37.7136996047335, -122.46894561897)
180957 180957 191842 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 1501 Davidson Ave 10 Back Yard : Yard 13 Tree 1 Private 1     15     6015112.514169999 2099226.0983 37.744924185813396 -122.390413900506 (37.7449241858134, -122.390413900506)
182862 182862 209187 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 156 Kensington Way 1 Back Yard : Yard 13 Tree 1 Private 1     9 Width 3ft   5994832.7400400005 2098518.64338 37.7418358608449 -122.460485895213 (37.7418358608449, -122.460485895213)
182994 182994 191809 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 300 Vermont St 1 Back Yard : Yard 13 Tree 1 Private 1     19     6011127.66334 2106895.1514 37.76575985524929 -122.404732656101 (37.7657598552493, -122.404732656101)
183262 183262 191810 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 300 Vermont St 2 Back Yard : Yard 13 Tree 1 Private 1     18     6011130.07486 2106859.15267 37.7656611456652 -122.40472178059099 (37.7656611456652, -122.404721780591)
189024 189024 209189 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 156 Kensington Way 3 Back Yard : Yard 13 Tree 1 Private 1     9 Width 3ft   5994812.38667 2098544.02713 37.7419043873887 -122.460558108972 (37.7419043873887, -122.460558108972)

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