Street_Tree_List

Data source: data.sfgov.org

8 rows where qSiteInfo = 7 and qSpecies = 137

View and edit SQL

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

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
1177 251471 DPW Maintained 3 Brugmansia spp :: Angel trumpet 137 2423 Market St 1 Front Yard : Yard 7 Tree 1 DPW 2                    
26819 202073 Undocumented 2 Brugmansia spp :: Angel trumpet 137 1 Gould St 2 Front Yard : Yard 7 Tree 1 Private 1     12     6012686.9776800005 2090655.72307 37.721256863288396 -122.398199843161 (37.7212568632884, -122.398199843161)
31705 249964 Undocumented 2 Brugmansia spp :: Angel trumpet 137 265 Filbert St 1 Front Yard : Yard 7 Tree 1 Private 1     5 Width 0ft   6011637.77879 2120097.34238 37.802038476045496 -122.403897380163 (37.8020384760455, -122.403897380163)
40318 249851 Undocumented 2 Brugmansia spp :: Angel trumpet 137 285 Greenwich St 2 Front Yard : Yard 7 Tree 1 Private 1     6 Width 0ft   6011475.66665 2120406.51075 37.8028783187521 -122.40448014355101 (37.8028783187521, -122.404480143551)
42111 249852 Undocumented 2 Brugmansia spp :: Angel trumpet 137 285 Greenwich St 3 Front Yard : Yard 7 Tree 1 Private 1     7 Width 0ft   6011471.43471 2120405.6011799998 37.8028755847944 -122.404494724258 (37.8028755847944, -122.404494724258)
62781 249850 Undocumented 2 Brugmansia spp :: Angel trumpet 137 285 Greenwich St 1 Front Yard : Yard 7 Tree 1 Private 1     14 Width 0ft   6011479.212780001 2120408.00843 37.8028826291885 -122.40446797753401 (37.8028826291885, -122.404467977534)
134941 188840 Undocumented 2 Brugmansia spp :: Angel trumpet 137 1301 Minnesota St 21 Front Yard : Yard 7 Tree 1 Private 1     15     6015386.40596 2102397.08701 37.753646246280496 -122.389688258224 (37.7536462462805, -122.389688258224)
175169 249972 Undocumented 2 Brugmansia spp :: Angel trumpet 137 222 Filbert St 1 Front Yard : Yard 7 Tree 1 Private 1     5 Width 0ft   6011689.8424 2120121.99827 37.802109083637 -122.403718950166 (37.802109083637, -122.403718950166)

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