Street_Tree_List

Data source: data.sfgov.org

19 rows where PlotSize = "Width 8ft" and qSpecies = 142

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, qCaretaker, DBH

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
27523 27523 197764 DPW Maintained 3 Syagrus romanzoffianum :: Queen Palm 142 1150x Tennessee St 9 Median : Yard 3 Tree 1 DPW 2     14 Width 8ft   6015565.1078 2103547.1261299998 37.7568139175333 -122.389150557161 (37.7568139175333, -122.389150557161)
29638 29638 197767 DPW Maintained 3 Syagrus romanzoffianum :: Queen Palm 142 1150x Tennessee St 14 Median : Yard 3 Tree 1 DPW 2     14 Width 8ft   6015569.446690001 2103464.9174599997 37.756588430534 -122.38912981161002 (37.756588430534, -122.38912981161)
41702 41702 179568 Undocumented 2 Syagrus romanzoffianum :: Queen Palm 142 190 Foote Ave 11 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 8ft   5998649.6038 2088359.07643 37.7141589091721 -122.446557711588 (37.7141589091721, -122.446557711588)
49253 49253 197768 DPW Maintained 3 Syagrus romanzoffianum :: Queen Palm 142 1150x Tennessee St 15 Median : Yard 3 Tree 1 DPW 2     5 Width 8ft   6015570.7208 2103442.3208 37.7565264555391 -122.389123827518 (37.7565264555391, -122.389123827518)
50768 50768 240989 Undocumented 2 Syagrus romanzoffianum :: Queen Palm 142 2423 Market St 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 8ft   6002119.69058 2105763.49027 37.762144996112106 -122.43580828333599 (37.7621449961121, -122.435808283336)
56775 56775 179563 Undocumented 2 Syagrus romanzoffianum :: Queen Palm 142 190 Foote Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 8ft   5998684.14155 2088327.6956200001 37.71407471735 -122.44643608006099 (37.71407471735, -122.446436080061)
60757 60757 179566 Undocumented 2 Syagrus romanzoffianum :: Queen Palm 142 190 Foote Ave 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 8ft   5998660.62804 2088348.62653 37.7141308458255 -122.446518856356 (37.7141308458255, -122.446518856356)
67537 67537 179565 Undocumented 2 Syagrus romanzoffianum :: Queen Palm 142 190 Foote Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 8ft   5998669.51427 2088341.1410400001 37.714110799942205 -122.446487604047 (37.7141107999422, -122.446487604047)
67717 67717 240986 Undocumented 2 Syagrus romanzoffianum :: Queen Palm 142 2423 Market St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 8ft   6002082.382119999 2105743.71018 37.76208856545271 -122.43593590344601 (37.7620885654527, -122.435935903446)
69351 69351 240988 Undocumented 2 Syagrus romanzoffianum :: Queen Palm 142 2423 Market St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 8ft   6002104.213719999 2105756.02569 37.762123621029794 -122.435861277678 (37.7621236210298, -122.435861277678)
72075 72075 179564 Undocumented 2 Syagrus romanzoffianum :: Queen Palm 142 190 Foote Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 8ft   5998675.98821 2088335.1658599998 37.7140947632347 -122.446464798107 (37.7140947632347, -122.446464798107)
136283 136283 240985 Undocumented 2 Syagrus romanzoffianum :: Queen Palm 142 2423 Market St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 8ft   6002070.76552 2105741.45932 37.7620817252178 -122.435975919665 (37.7620817252178, -122.435975919665)
148626 148626 179569 Undocumented 2 Syagrus romanzoffianum :: Queen Palm 142 190 Foote Ave 13 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 8ft   5998642.9362699995 2088367.48919 37.7141816278426 -122.446581361956 (37.7141816278426, -122.446581361956)
158402 158402 240987 Undocumented 2 Syagrus romanzoffianum :: Queen Palm 142 2423 Market St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 8ft   6002096.23845 2105748.4059200003 37.762102245951205 -122.435888315809 (37.7621022459512, -122.435888315809)
162901 162901 197765 DPW Maintained 3 Syagrus romanzoffianum :: Queen Palm 142 1150x Tennessee St 11 Median : Yard 3 Tree 1 DPW 2     12 Width 8ft   6015567.051530001 2103517.02147 37.756731364291 -122.389141732999 (37.756731364291, -122.389141732999)
172965 172965 179567 Undocumented 2 Syagrus romanzoffianum :: Queen Palm 142 190 Foote Ave 7 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 8ft   5998654.86652 2088353.6134799998 37.7141442097611 -122.446539128875 (37.7141442097611, -122.446539128875)
174824 174824 179570 Undocumented 2 Syagrus romanzoffianum :: Queen Palm 142 190 Foote Ave 14 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13 Width 8ft   5998636.2181400005 2088373.4694599998 37.714197664554796 -122.44660501232599 (37.7141976645548, -122.446605012326)
177307 177307 179571 Undocumented 2 Syagrus romanzoffianum :: Queen Palm 142 190 Foote Ave 16 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12 Width 8ft   5998627.15829 2088384.3655400001 37.7142270651918 -122.446637110039 (37.7142270651918, -122.446637110039)
178786 178786 197766 DPW Maintained 3 Syagrus romanzoffianum :: Queen Palm 142 1150x Tennessee St 13 Median : Yard 3 Tree 1 DPW 2     15 Width 8ft   6015570.19786 2103483.2933099996 37.756638928352 -122.38912849679701 (37.756638928352, -122.389128496797)

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