Street_Tree_List

Data source: data.sfgov.org

11 rows where qSiteInfo = 2 and qSpecies = 59

View and edit SQL

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
29051 181932 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 2378 36th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     18 Width 0ft   5985195.246 2099024.2764 37.74266505256279 -122.49384596323 (37.7426650525628, -122.49384596323)
38088 142102 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 900 Fell St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 0ft   6003042.617000001 2110331.1771 37.7747391304954 -122.43294257823798 (37.7747391304954, -122.432942578238)
39439 181853 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 2318 32nd Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 0ft   5986420.3329 2099445.95 37.7438944556176 -122.48964102637699 (37.7438944556176, -122.489641026377)
39552 141364 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 451 BRODERICK ST 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 0ft   6001150.566000001 2110292.0606 37.7745242278003 -122.439484748915 (37.7745242278003, -122.439484748915)
41163 181854 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 2318 32nd Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 0ft   5986419.9945 2099457.4563 37.7439260290789 -122.48964304245001 (37.7439260290789, -122.48964304245)
55308 139484 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 1216 FULTON ST 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     18 Width 0ft   6001778.449 2111192.2794 37.7770317168845 -122.437377258879 (37.7770317168845, -122.437377258879)
65375 200196 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 1124 Fitzgerald Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     20 Width 0ft   6015063.1024 2090263.455 37.720311838731 -122.38995879887301 (37.720311838731, -122.389958798873)
68579 138831 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 745 BUCHANAN ST 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15 Width 0ft   6004451.1778 2111098.9724 37.7769271009021 -122.428124806353 (37.7769271009021, -122.428124806353)
134981 182109 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 2443 28th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 0ft   5987643.897000001 2098649.745 37.741779647708995 -122.48535186527599 (37.741779647709, -122.485351865276)
159251 183822 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 2235 27th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 0ft   5987905.4957 2100075.9969 37.7457109948541 -122.484551945811 (37.7457109948541, -122.484551945811)
159508 141351 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 457 BRODERICK ST 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     16 Width 0ft   6001146.5934 2110320.3656 37.774601720124295 -122.43950052034701 (37.7746017201243, -122.439500520347)

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