Street_Tree_List

Data source: data.sfgov.org

14 rows where qSiteInfo = 11 and qSpecies = 22

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qAddress, SiteOrder, DBH, PlotSize

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
43528 43528 209215 DPW Maintained 3 Maytenus boaria :: Mayten 22 99x Castenada Ave 25 Median : Cutout 11 Tree 1 DPW 2     15 Width 5ft   5993821.14503 2100240.07202 37.746504222711295 -122.46410856948 (37.7465042227113, -122.46410856948)
44102 44102 209213 DPW Maintained 3 Maytenus boaria :: Mayten 22 99x San Marcos Ave 23 Median : Cutout 11 Tree 1 DPW 2     2 Width 5ft   5993777.82606 2100247.64237 37.7465225122089 -122.46425891004101 (37.7465225122089, -122.464258910041)
53156 53156 209769 DPW Maintained 3 Maytenus boaria :: Mayten 22 100x Pacheco St 2 Median : Cutout 11 Tree 1 DPW 2     2 Width 3ft   5994792.885 2099741.94773 37.745192456276705 -122.460712331024 (37.7451924562767, -122.460712331024)
60137 60137 209212 DPW Maintained 3 Maytenus boaria :: Mayten 22 99x San Marcos Ave 22 Median : Cutout 11 Tree 1 DPW 2     2 Width 5ft   5993771.94389 2100232.96399 37.746481870051106 -122.4642781843 (37.7464818700511, -122.4642781843)
75541 75541 209208 DPW Maintained 3 Maytenus boaria :: Mayten 22 99x San Marcos Ave 18 Median : Cutout 11 Tree 1 DPW 2     3 Width 5ft   5993802.83706 2100253.03783 37.7465387683529 -122.46417281704399 (37.7465387683529, -122.464172817044)
106244 106244 459 DPW Maintained 3 Maytenus boaria :: Mayten 22 760x 23rd Ave 23 Median : Cutout 11 Tree 1 DPW 2     12     5988830.89675 2110023.4193700003 37.773077776353 -122.48208068722602 (37.773077776353, -122.482080687226)
123719 123719 209209 DPW Maintained 3 Maytenus boaria :: Mayten 22 99x San Marcos Ave 19 Median : Cutout 11 Tree 1 DPW 2     3 Width 5ft   5993795.21392 2100243.94669 37.746513367011 -122.464198516942 (37.746513367011, -122.464198516942)
134453 134453 209214 DPW Maintained 3 Maytenus boaria :: Mayten 22 99x Castenada Ave 24 Median : Cutout 11 Tree 1 DPW 2     8 Width 5ft   5993812.322269999 2100226.93547 37.746467644571 -122.464138123878 (37.746467644571, -122.464138123878)
134537 134537 209762 DPW Maintained 3 Maytenus boaria :: Mayten 22 1200x Plymouth Ave 2 Median : Cutout 11 Tree 1 DPW 2     7 Width 3ft   5995809.026930001 2092599.65126 37.72563986216979 -122.456682272862 (37.7256398621698, -122.456682272862)
134757 134757 209210 DPW Maintained 3 Maytenus boaria :: Mayten 22 99x San Marcos Ave 20 Median : Cutout 11 Tree 1 DPW 2     1 Width 5ft   5993788.41941 2100238.90873 37.746499142429705 -122.464221645739 (37.7464991424297, -122.464221645739)
152005 152005 209768 DPW Maintained 3 Maytenus boaria :: Mayten 22 100x Pacheco St 1 Median : Cutout 11 Tree 1 DPW 2     2 Width 3ft   5994733.37028 2099685.92288 37.7450352017206 -122.460914061546 (37.7450352017206, -122.460914061546)
157795 157795 209207 DPW Maintained 3 Maytenus boaria :: Mayten 22 99x San Marcos Ave 17 Median : Cutout 11 Tree 1 DPW 2     3 Width 5ft   5993815.86849 2100254.24474 37.7465428332992 -122.46412784372801 (37.7465428332992, -122.464127843728)
161466 161466 193529 DPW Maintained 3 Maytenus boaria :: Mayten 22 2x Garlington Ct 5 Median : Cutout 11 Tree 1 DPW 2     6 Width 6ft   6016723.20154 2094502.11588 37.732042299514106 -122.38451540818001 (37.7320422995141, -122.38451540818)
178018 178018 209211 DPW Maintained 3 Maytenus boaria :: Mayten 22 99x San Marcos Ave 21 Median : Cutout 11 Tree 1 DPW 2     2 Width 5ft   5993782.2667 2100229.04683 37.7464717095186 -122.46424220511601 (37.7464717095186, -122.464242205116)

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