Street_Tree_List

Data source: data.sfgov.org

17 rows where qSiteInfo = 3 and qSpecies = 75

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, qAddress, SiteOrder, qCaretaker, DBH, PlotSize, XCoord, YCoord, Latitude, Longitude, Location

qSiteInfo ✖

  • Median : Yard · 17 ✖
Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
29712 29712 244826 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 500x Dolores St 8 Median : Yard 3 Tree 1 DPW 2     20     6004940.864159999 2105188.02891 37.760724766043 -122.42600994929501 (37.760724766043, -122.426009949295)
35685 35685 244827 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 1450x Dolores St 8 Median : Yard 3 Tree 1 DPW 2     17     6005245.250469999 2099669.70272 37.745589922449604 -122.424564667746 (37.7455899224496, -122.424564667746)
64016 64016 244819 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 500x Dolores St 3 Median : Yard 3 Tree 1 DPW 2     15     6004938.112480001 2105333.55705 37.7611241963496 -122.426029826117 (37.7611241963496, -122.426029826117)
69875 69875 244858 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 431x Precita Ave 3 Median : Yard 3 Tree 1 DPW 2     14 Width 10ft   6009361.35634 2100204.6117700003 37.747290259852 -122.41036950684601 (37.747290259852, -122.410369506846)
72078 72078 244818 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 150x Dolores St 6 Median : Yard 3 Tree 1 DPW 2     16     6004818.66782 2107349.3149200003 37.7666522354392 -122.426586475898 (37.7666522354392, -122.426586475898)
85176 85176 104920 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 750 Gonzalez Dr 1 Median : Yard 3 Tree 1 Private 1           5990385.0 2090588.0 37.7198034465129 -122.47528570222 (37.7198034465129, -122.47528570222)
101258 101258 104921 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 750 Gonzalez Dr 2 Median : Yard 3 Tree 1 Private 1           5990385.0 2090588.0 37.7198034465129 -122.47528570222 (37.7198034465129, -122.47528570222)
111624 111624 104922 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 750 Gonzalez Dr 3 Median : Yard 3 Tree 1 Private 1         missing? 5990385.0 2090588.0 37.7198034465129 -122.47528570222 (37.7198034465129, -122.47528570222)
128606 128606 104928 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 810 Gonzalez Dr 3 Median : Yard 3 Tree 1 Private 1     12     5990385.0 2090588.0 37.7198034465129 -122.47528570222 (37.7198034465129, -122.47528570222)
129607 129607 244817 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 150x Dolores St 5 Median : Yard 3 Tree 1 DPW 2     16     6004826.7042 2107360.62058 37.7666837323921 -122.426559484554 (37.7666837323921, -122.426559484554)
135771 135771 244825 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 500x Dolores St 6 Median : Yard 3 Tree 1 DPW 2     17     6004935.84357 2105248.4287099997 37.760890325850795 -122.42603161307501 (37.7608903258508, -122.426031613075)
143894 143894 104927 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 810 Gonzalez Dr 2 Median : Yard 3 Tree 1 Private 1     10     5990385.0 2090588.0 37.7198034465129 -122.47528570222 (37.7198034465129, -122.47528570222)
144760 144760 104926 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 810 Gonzalez Dr 1 Median : Yard 3 Tree 1 Private 1           5990385.0 2090588.0 37.7198034465129 -122.47528570222 (37.7198034465129, -122.47528570222)
172077 172077 243922 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 1x Bartlett St 3 Median : Yard 3 Tree 1 DPW 2     12 Width 10ft   6006671.30131 2103734.09431 37.756830245634 -122.419921955443 (37.756830245634, -122.419921955443)
172474 172474 244816 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 150x Dolores St 4 Median : Yard 3 Tree 1 DPW 2     15     6004817.336069999 2107374.8750299998 37.766722342083 -122.42659290246701 (37.766722342083, -122.426592902467)
187703 187703 187521 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 100x Mary Teresa St 1 Median : Yard 3 Tree 1 DPW 2     15 Width 9ft   6012597.41848 2087914.4030799998 37.7137247587658 -122.398317184005 (37.7137247587658, -122.398317184005)
188330 188330 243923 DPW Maintained 3 Washingtonia robusta :: Mexican Fan Palm 75 1x Bartlett St 2 Median : Yard 3 Tree 1 DPW 2     12 Width 10ft   6006672.06961 2103729.13284 37.7568166658685 -122.419918946309 (37.7568166658685, -122.419918946309)

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