Street_Tree_List

Data source: data.sfgov.org

16 rows where PlotSize = "Width 0ft" and qSpecies = 93

✎ View and edit SQL

This data as json, CSV (advanced)

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

qLegalStatus ✖

PlotSize ✖

  • Width 0ft · 16 ✖
Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
34976 34976 210093 DPW Maintained 3 Melaleuca nesophila :: Pink Melaleuca 93 1x Minerva St 16 Median : Cutout 11 Tree 1 DPW 2     7 Width 0ft   5996144.00036 2089001.40747 37.715779161942 -122.45526438373899 (37.715779161942, -122.455264383739)
40578 40578 210099 Undocumented 2 Melaleuca nesophila :: Pink Melaleuca 93 700 Junipero Serra Blvd 70 : 4 Tree 1 Private 1     12 Width 0ft   5991230.12075 2092291.98484 37.72453111681111 -122.47248860785601 (37.7245311168111, -122.472488607856)
53662 53662 210096 Undocumented 2 Melaleuca nesophila :: Pink Melaleuca 93 300 Junipero Serra Blvd 45 : 4 Tree 1 Private 1     4 Width 0ft   5991386.500659999 2094355.8588400001 37.73020705030461 -122.47209839385201 (37.7302070503046, -122.472098393852)
56108 56108 183035 Undocumented 2 Melaleuca nesophila :: Pink Melaleuca 93 2522 Lower Great Hwy 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 0ft   5981504.4178 2097898.5163 37.7393573965741 -122.506524088332 (37.7393573965741, -122.506524088332)
60700 60700 183354 Undocumented 2 Melaleuca nesophila :: Pink Melaleuca 93 3544 Rivera St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 0ft   5982117.2654 2100157.6466 37.7455964086946 -122.504572502943 (37.7455964086946, -122.504572502943)
61265 61265 184530 Undocumented 2 Melaleuca nesophila :: Pink Melaleuca 93 4045 Ortega St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 0ft   5981394.5999 2102116.7749 37.7509330899515 -122.50721664272801 (37.7509330899515, -122.507216642728)
71380 71380 141700 Undocumented 2 Melaleuca nesophila :: Pink Melaleuca 93 150 BEAUMONT AVE 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 0ft   5996841.3555 2111986.1699 37.778929621332004 -122.454513467721 (37.778929621332, -122.454513467721)
75400 75400 210098 Undocumented 2 Melaleuca nesophila :: Pink Melaleuca 93 400 Junipero Serra Blvd 18 : 4 Tree 1 Private 1     17 Width 0ft   5991367.910130001 2094058.78209 37.72939027613779 -122.47214101722099 (37.7293902761378, -122.472141017221)
131557 131557 210095 DPW Maintained 3 Melaleuca nesophila :: Pink Melaleuca 93 1x Minerva St 47 Median : Cutout 11 Tree 1 DPW 2     4 Width 0ft   5996479.95925 2088997.21564 37.7157869222034 -122.454102858955 (37.7157869222034, -122.454102858955)
137755 137755 183353 Undocumented 2 Melaleuca nesophila :: Pink Melaleuca 93 3542 Rivera St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 0ft   5982133.0347 2100158.2902 37.7455991034071 -122.504518023708 (37.7455991034071, -122.504518023708)
153451 153451 139625 Undocumented 2 Melaleuca nesophila :: Pink Melaleuca 93 1761 TURK ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 0ft   6001622.1557 2112159.8649 37.779679575976 -122.437987249049 (37.779679575976, -122.437987249049)
154502 154502 184532 Undocumented 2 Melaleuca nesophila :: Pink Melaleuca 93 4041 Ortega St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 0ft   5981429.119 2102119.1438 37.7509416273735 -122.507097450181 (37.7509416273735, -122.507097450181)
157211 157211 183355 Undocumented 2 Melaleuca nesophila :: Pink Melaleuca 93 3546 Rivera St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 0ft   5982088.9451 2100155.7156 37.74558944081421 -122.504670285508 (37.7455894408142, -122.504670285508)
159623 159623 210100 Undocumented 2 Melaleuca nesophila :: Pink Melaleuca 93 700 Junipero Serra Blvd 125 : 4 Tree 1 Private 1     6 Width 0ft   5991216.87042 2091758.40738 37.7230652785221 -122.472495529943 (37.7230652785221, -122.472495529943)
169128 169128 210094 DPW Maintained 3 Melaleuca nesophila :: Pink Melaleuca 93 1x Minerva St 17 Median : Cutout 11 Tree 1 DPW 2     10 Width 0ft   5996151.37066 2089000.9708099999 37.715778385846896 -122.45523887719801 (37.7157783858469, -122.455238877198)
182701 182701 210097 Undocumented 2 Melaleuca nesophila :: Pink Melaleuca 93 300 Junipero Serra Blvd 46 : 4 Tree 1 Private 1     6 Width 0ft   5991383.70914 2094347.6763 37.7301844215576 -122.47210744821699 (37.7301844215576, -122.472107448217)

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