Street_Tree_List

Data source: data.sfgov.org

45 rows where qSiteInfo = 9 and qSpecies = 190

✎ View and edit SQL

This data as json, CSV (advanced)

qSiteInfo ✖

  • Sidewalk: Property side : Yard · 22 ✖
Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
135662 135662 191707 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 2187 Revere Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12     6011937.92175 2096699.9343299998 37.7378112633764 -122.401213644004 (37.7378112633764, -122.401213644004)
141988 141988 113120 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1x TOMASO CT 8 Sidewalk: Property side : Yard 9 Tree 1 Private 1           6009323.0 2086334.0 37.70920235104 -122.40952334552 (37.70920235104, -122.40952334552)
148462 148462 176280 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 600 Blanken Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 5ft   6013180.81524 2086857.6738099998 37.7108556687339 -122.39622672069599 (37.7108556687339, -122.396226720696)
153779 153779 207734 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 301 Joost Ave 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 10ft   6000042.84201 2094939.4846400002 37.7323066857905 -122.442214249597 (37.7323066857905, -122.442214249597)
157462 157462 207708 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 916 Ortega St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 1ft   5991151.901959999 2102512.9309 37.7525906994144 -122.473504184373 (37.7525906994144, -122.473504184373)
161021 161021 207707 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1254 18th Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 3ft   5990519.642630001 2106849.6628099997 37.7644615768749 -122.476007325895 (37.7644615768749, -122.476007325895)
161098 161098 207716 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 115 Judson Ave 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 8ft   5999335.92351 2093459.52729 37.72820275463761 -122.44455189156601 (37.7282027546376, -122.444551891566)
162191 162191 123640 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 345 Arguello Blvd 7 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 6ft   5995501.56716 2113883.85045 37.784063214039605 -122.459285759007 (37.7840632140396, -122.459285759007)
163114 163114 126569 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 2745 Larkin St 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8     6006516.40415 2120646.68987 37.8032593947653 -122.42165884218599 (37.8032593947653, -122.421658842186)
165369 165369 224112 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1100 San Jose Ave 51 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5     6004737.84332 2096628.1853599998 37.7372099397936 -122.42610271887101 (37.7372099397936, -122.426102718871)
165907 165907 126567 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 2843 Larkin St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 5ft   6006455.5801099995 2121070.56705 37.8044198232789 -122.42189945398998 (37.8044198232789, -122.42189945399)
167274 167274 126570 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 94 MacOndray Ln 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7     6008053.53116 2119101.30283 37.7991027057905 -122.41623003160299 (37.7991027057905, -122.416230031603)
167474 167474 207709 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 916 Ortega St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 1ft   5991129.27817 2102510.74063 37.752583375332605 -122.47358226082 (37.7525833753326, -122.47358226082)
169472 169472 207719 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 126 Brighton Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 1ft   5996251.42646 2090752.11635 37.7205923605284 -122.455019501973 (37.7205923605284, -122.455019501973)
170332 170332 191688 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 800 19th St 18 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 10ft   6014977.94549 2105331.22601 37.761680105066105 -122.39130591015 (37.7616801050661, -122.39130591015)
172056 172056 207733 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 500 Joost Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4     5998757.70005 2094996.74516 37.732390582643205 -122.446661380942 (37.7323905826432, -122.446661380942)
172414 172414 249620 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 2400 Golden Gate Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 7ft   5997953.57215 2111367.44178 37.7772944806811 -122.45062126495199 (37.7772944806811, -122.450621264952)
175044 175044 207732 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 400 Congo St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     19 Width 10ft   6000124.6238 2095012.3046900001 37.7325112932663 -122.441936736802 (37.7325112932663, -122.441936736802)
177554 177554 191692 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 764 De Haro St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9     6012093.5937 2104845.22166 37.7601851458373 -122.401247624904 (37.7601851458373, -122.401247624904)
177778 177778 176281 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 600 Blanken Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 5ft   6013188.37125 2086854.32403 37.710846891333105 -122.39620037057101 (37.7108468913331, -122.396200370571)
179929 179929 207728 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 3802 19th Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 4ft   5990564.76109 2090542.95021 37.7196901687566 -122.47466105158199 (37.7196901687566, -122.474661051582)
180825 180825 224130 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 840 Castro St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     18     6002416.06064 2103301.09689 37.7554006877977 -122.434607174889 (37.7554006877977, -122.434607174889)

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