Street_Tree_List

Data source: data.sfgov.org

14 rows where DBH = 1, qLegalStatus = 2 and qSpecies = 66

View and edit SQL

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
27341 206556 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 32 Sotelo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 4ft   5993935.86279 2101082.16601 37.7488230103837 -122.463773001819 (37.7488230103837, -122.463773001819)
28309 206505 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 1965 10th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 6ft   5993138.76599 2102124.2403700002 37.7516383146611 -122.46660507218701 (37.7516383146611, -122.466605072187)
29530 218122 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 45 Lopez Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 0ft   5994032.10421 2100668.86964 37.7476937487685 -122.463410213512 (37.7476937487685, -122.463410213512)
43524 206628 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 20 Ventura Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 3ft   5994037.30563 2101977.91794 37.7512883623694 -122.463487212563 (37.7512883623694, -122.463487212563)
47365 141302 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 208 Anza St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   5998449.1975 2112684.3341 37.780938681749895 -122.449001631605 (37.7809386817499, -122.449001631605)
50270 206508 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 1023 Lawton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 2ft   5990927.20691 2104481.04629 37.7579816107755 -122.474424823051 (37.7579816107755, -122.474424823051)
135298 176075 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 100 Capistrano Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 4ft   6001444.800340001 2093622.381 37.7287700227166 -122.43727309280001 (37.7287700227166, -122.4372730928)
135645 223028 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 42 Rivoli St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5998401.231319999 2106021.8866 37.7626425622232 -122.448687567871 (37.7626425622232, -122.448687567871)
150435 206545 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 265 Pacheco St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 4ft   5994446.422040001 2100465.35227 37.747158803252 -122.461962779858 (37.747158803252, -122.461962779858)
153105 206509 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 1023 Lawton St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 2ft   5990938.9472 2104480.79856 37.75798161076639 -122.47438420248501 (37.7579816107664, -122.474384202485)
164342 249691 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 2400 Baker St 23 Front Yard : Yard 7 Tree 1 Private 1     1     5999714.93782 2117284.79533 37.793642655433004 -122.44495363669701 (37.793642655433, -122.444953636697)
166442 206532 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 160 San Aleso Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5993345.963169999 2094536.94274 37.730817459756 -122.46533747775 (37.730817459756, -122.46533747775)
171652 206516 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 1019 Lawton St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 2ft   5991047.261080001 2104483.88717 37.7579963659448 -122.474009836278 (37.7579963659448, -122.474009836278)
186978 190925 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 651 Kansas St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6011562.1933699995 2105343.91486 37.761524784975 -122.40312057635 (37.761524784975, -122.40312057635)

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