Street_Tree_List

Data source: data.sfgov.org

18 rows where PlotSize = "Width 0ft", qSiteInfo = 11 and qSpecies = 100

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qAddress, SiteOrder, DBH

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
24559 24559 246349 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 2190x Market St 1 Median : Cutout 11 Tree 1 DPW 2     31 Width 0ft   6003723.2107 2107266.4094 37.766362606026796 -122.430369556243 (37.7663626060268, -122.430369556243)
25198 25198 246342 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 2020x Market St 4 Median : Cutout 11 Tree 1 DPW 2     30 Width 0ft   6004356.6072 2107872.2367 37.7680619198287 -122.42822193571301 (37.7680619198287, -122.428221935713)
36176 36176 246402 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 2000x Market St 1 Median : Cutout 11 Tree 1 DPW 2     30 Width 0ft   6004659.311000001 2108158.3365 37.7688646036969 -122.42719529666901 (37.7688646036969, -122.427195296669)
38993 38993 248619 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1801x Market St 1 Median : Cutout 11 Tree 1 DPW 2     25 Width 0ft   6005765.0052 2109117.0426 37.7715594473913 -122.42343893750099 (37.7715594473913, -122.423438937501)
54798 54798 246348 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 2150x Market St 1 Median : Cutout 11 Tree 1 DPW 2     32 Width 0ft   6003809.2361 2107348.5599 37.766593043924 -122.430077871393 (37.766593043924, -122.430077871393)
64559 64559 246403 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 2000x Market St 2 Median : Cutout 11 Tree 1 DPW 2     25 Width 0ft   6004628.6575 2108127.683 37.7687787030374 -122.427299141169 (37.7687787030374, -122.427299141169)
76295 76295 246340 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 2020x Market St 6 Median : Cutout 11 Tree 1 DPW 2     32 Width 0ft   6004296.5773 2107812.2068 37.767893695460295 -122.428425293549 (37.7678936954603, -122.428425293549)
132737 132737 246343 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 2020x Market St 5 Median : Cutout 11 Tree 1 DPW 2     26 Width 0ft   6004317.012999999 2107828.8108 37.767940442417604 -122.428355792358 (37.7679404424176, -122.428355792358)
135557 135557 246409 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 2190x Market St 2 Median : Cutout 11 Tree 1 DPW 2     29 Width 0ft   6003700.7355 2107248.5843 37.7663123894934 -122.43044602180001 (37.7663123894934, -122.4304460218)
136243 136243 246359 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 2150x Market St 2 Median : Cutout 11 Tree 1 DPW 2     26 Width 0ft   6003779.011 2107326.8598 37.766531748826 -122.430180866432 (37.766531748826, -122.430180866432)
148059 148059 248621 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 132x McCoppin St 1 Median : Cutout 11 Tree 1 DPW 2     29 Width 0ft   6005771.7237 2109102.262 37.7715192426118 -122.42341464686501 (37.7715192426118, -122.423414646865)
170480 170480 245964 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1950x Market St 2 Median : Cutout 11 Tree 1 DPW 2     25 Width 0ft   6005048.2837 2108538.5237 37.7699304954931 -122.42587693213301 (37.7699304954931, -122.425876932133)
171600 171600 248622 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 142x McCoppin St 2 Median : Cutout 11 Tree 1 DPW 2     26 Width 0ft   6005746.1935 2109104.2775 37.7715233357229 -122.423503100629 (37.7715233357229, -122.423503100629)
172221 172221 245963 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1950x Market St 1 Median : Cutout 11 Tree 1 DPW 2     20 Width 0ft   6005062.3371 2108554.2304 37.7699744164919 -122.425829439833 (37.7699744164919, -122.425829439833)
172817 172817 245965 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1950x Market St 3 Median : Cutout 11 Tree 1 DPW 2     24 Width 0ft   6005023.4835 2108512.8969 37.7698587289196 -122.425960891085 (37.7698587289196, -122.425960891085)
178250 178250 246357 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 2100x Market St 4 Median : Cutout 11 Tree 1 DPW 2     32 Width 0ft   6003963.462 2107490.3857 37.7669911968193 -122.429554546796 (37.7669911968193, -122.429554546796)
181978 181978 246356 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 2100x Market St 3 Median : Cutout 11 Tree 1 DPW 2     32 Width 0ft   6003986.7122 2107511.3108 37.7670499684983 -122.429475620431 (37.7670499684983, -122.429475620431)
182459 182459 246404 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 2000x Market St 3 Median : Cutout 11 Tree 1 DPW 2     29 Width 0ft   6004606.9445 2108108.5245 37.7687248704296 -122.427372879895 (37.7687248704296, -122.427372879895)

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