Street_Tree_List

Data source: data.sfgov.org

11 rows where qSiteInfo = 17 and qSpecies = 36

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qAddress, SiteOrder, DBH

qSiteInfo ✖

  • Side Yard : Yard · 11 ✖
Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
29793 29793 247852 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 80 Bradford St 1 Side Yard : Yard 17 Tree 1 Private 1     27     6009577.25002 2098193.0016099997 37.741778919360705 -122.409481010838 (37.7417789193607, -122.409481010838)
30472 30472 247853 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 80 Bradford St 2 Side Yard : Yard 17 Tree 1 Private 1     25     6009574.28658 2098178.5899099996 37.7417391819242 -122.40949024059401 (37.7417391819242, -122.409490240594)
47085 47085 218783 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 230 Edna St 3 Side Yard : Yard 17 Tree 1 Private 1     9     5998795.47023 2095343.3571900001 37.7333444548841 -122.44655572948099 (37.7333444548841, -122.446555729481)
60526 60526 224443 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 198 Corbin Pl 10 Side Yard : Yard 17 Tree 1 Private 1     15 Width 3ft   6000083.78895 2105729.05454 37.76193458623221 -122.442847194237 (37.7619345862322, -122.442847194237)
70451 70451 176394 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 148 Milton St 1 Side Yard : Yard 17 Tree 1 Private 1     21     6003833.54644 2094691.18415 37.731840220943205 -122.42909121820801 (37.7318402209432, -122.429091218208)
133301 133301 218784 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 230 Edna St 4 Side Yard : Yard 17 Tree 1 Private 1     6     5998790.64503 2095351.5410200001 37.733366650131295 -122.446573000066 (37.7333666501313, -122.446573000066)
133793 133793 206299 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 231 Edna St 1 Side Yard : Yard 17 Tree 1 Private 1     21     5998763.35609 2095379.2875599999 37.733441276780205 -122.446669340837 (37.7334412767802, -122.446669340837)
134530 134530 218787 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 230 Edna St 7 Side Yard : Yard 17 Tree 1 Private 1     14     5998781.19291 2095377.439 37.733437219949 -122.44660754120702 (37.733437219949, -122.446607541207)
152132 152132 218786 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 230 Edna St 6 Side Yard : Yard 17 Tree 1 Private 1     11     5998782.33461 2095362.2846400002 37.733395674875005 -122.44660250410101 (37.733395674875, -122.446602504101)
165042 165042 218785 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 230 Edna St 5 Side Yard : Yard 17 Tree 1 Private 1     8     5998782.76063 2095352.74135 37.733369495591795 -122.446600344857 (37.7333694955918, -122.446600344857)
181489 181489 247933 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1099 Esmeralda Ave 6 Side Yard : Yard 17 Tree 1 Private 1     25     6010316.772530001 2098765.05298 37.7433910575536 -122.40696428417601 (37.7433910575536, -122.406964284176)

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