Street_Tree_List

Data source: data.sfgov.org

22 rows where qSpecies = 343

View and edit SQL

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

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
25082 240367 Undocumented 2 Quillaja saponaria :: Chilean Soapbark 343 43 Woodland Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5997045.58025 2106312.21394 37.763362115200295 -122.45339721491399 (37.7633621152003, -122.453397214914)
33157 136297 Undocumented 2 Quillaja saponaria :: Chilean Soapbark 343 1471 Washington St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6007665.12866 2117142.06871 37.793701289428604 -122.417435114148 (37.7937012894286, -122.417435114148)
52785 139273 Undocumented 2 Quillaja saponaria :: Chilean Soapbark 343 765 FULTON ST 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 0ft   6004208.0444 2111479.3585 37.777957788247704 -122.428993006008 (37.7779577882477, -122.428993006008)
54339 124596 Undocumented 2 Quillaja saponaria :: Chilean Soapbark 343 3999 Clay St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 5ft   5995621.5881199995 2115140.66957 37.7875210010639 -122.458961562411 (37.7875210010639, -122.458961562411)
54998 240368 Undocumented 2 Quillaja saponaria :: Chilean Soapbark 343 55 Woodland Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   5997060.67774 2106228.7303 37.7631337557456 -122.453338970317 (37.7631337557456, -122.453338970317)
60315 61983 Permitted Site 1 Quillaja saponaria :: Chilean Soapbark 343 3154 Octavia St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/03/1985 12:00:00 AM 4   Permit Number 22050 6004222.7109199995 2120056.9871900002 37.801510618969104 -122.429554160418 (37.8015106189691, -122.429554160418)
62086 240369 Undocumented 2 Quillaja saponaria :: Chilean Soapbark 343 924 Stanyan St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5997240.50236 2107274.95853 37.7660167375967 -122.452792537768 (37.7660167375967, -122.452792537768)
67280 249976 Undocumented 2 Quillaja saponaria :: Chilean Soapbark 343 21 Napier Ln 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 0ft   6011642.19943 2120231.20207 37.8024062690918 -122.403891507608 (37.8024062690918, -122.403891507608)
69077 124597 Undocumented 2 Quillaja saponaria :: Chilean Soapbark 343 3999 Clay St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 5ft   5995606.88973 2115137.96045 37.78751271763029 -122.45901221931999 (37.7875127176303, -122.45901221932)
82759 51841 Permitted Site 1 Quillaja saponaria :: Chilean Soapbark 343 43 Woodland Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/16/2008 12:00:00 AM   3x3 Permit Number 50868 5997036.87173308 2106364.06035903 37.763503973090295 -122.453431078199 (37.7635039730903, -122.453431078199)
87554 108913 Permitted Site 1 Quillaja saponaria :: Chilean Soapbark 343 170 Highland Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/09/2015 12:00:00 AM 3 3x3 Permit Number 773176 6005928.5 2096596.4 37.7371898878165 -122.42198381060699 (37.7371898878165, -122.421983810607)
98844 4508 DPW Maintained 3 Quillaja saponaria :: Chilean Soapbark 343 150X Arguello Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     1 3X3   5995548.81365 2115103.97639 37.787416067917796 -122.45921068768699 (37.7874160679178, -122.459210687687)
100856 14543 DPW Maintained 3 Quillaja saponaria :: Chilean Soapbark 343 736 Masonic Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     100 3X3   5999282.2180699995 2110225.9006 37.7742360610429 -122.44594294328002 (37.7742360610429, -122.44594294328)
129345 107666 Undocumented 2 Quillaja saponaria :: Chilean Soapbark 343 140 STRATFORD DR 1 Front Yard : Yard 7 Tree 1 Private 1   12/17/2014 12:00:00 AM 3   Permit Number 774157 5990881.4 2091504.3 37.722348139716296 -122.473636645054 (37.7223481397163, -122.473636645054)
129833 139270 Undocumented 2 Quillaja saponaria :: Chilean Soapbark 343 775 FULTON ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 0ft   6004128.3145 2111467.9685 37.7779220007662 -122.429268007542 (37.7779220007662, -122.429268007542)
135947 240366 Undocumented 2 Quillaja saponaria :: Chilean Soapbark 343 170 Highland Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6005928.4079599995 2096616.55927 37.7372452354804 -122.42198556048099 (37.7372452354804, -122.421985560481)
142930 122459 Permitted Site 1 Quillaja saponaria :: Chilean Soapbark 343 1351 42nd Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1         5983044.58583163 2105938.11904156 37.7615224717284 -122.501793626008 (37.7615224717284, -122.501793626008)
150844 136296 Undocumented 2 Quillaja saponaria :: Chilean Soapbark 343 25 Retiro Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6001770.3759699995 2121234.42741 37.8046044010407 -122.43812472200199 (37.8046044010407, -122.438124722002)
159304 240370 Undocumented 2 Quillaja saponaria :: Chilean Soapbark 343 205 Grattan St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5997691.57416 2106447.88941 37.7637716529741 -122.451172728342 (37.7637716529741, -122.451172728342)
168073 136298 Undocumented 2 Quillaja saponaria :: Chilean Soapbark 343 902 Vallejo St 3 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     5 Width 4ft   6009157.405619999 2118748.49482 37.7981959904135 -122.412385286869 (37.7981959904135, -122.412385286869)
168803 249975 Undocumented 2 Quillaja saponaria :: Chilean Soapbark 343 21 Napier Ln 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 0ft   6011642.325669999 2120237.40655 37.8024233121334 -122.403891507612 (37.8024233121334, -122.403891507612)
177213 249977 Undocumented 2 Quillaja saponaria :: Chilean Soapbark 343 21 Napier Ln 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 0ft   6011643.6544699995 2120226.12946 37.8023924222307 -122.403886115262 (37.8023924222307, -122.403886115262)

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