Street_Tree_List

Data source: data.sfgov.org

12 rows where qSiteInfo = 13 and qSpecies = 141

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qAddress, SiteOrder, DBH, PlotSize

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
25938 25938 249996 Undocumented 2 Cordyline australis :: Dracena Palm 141 41 Darrell Pl 2 Back Yard : Yard 13 Tree 1 Private 1     9 Width 0ft   6011497.53106 2120284.14207 37.8025435461134 -122.40439586268101 (37.8025435461134, -122.404395862681)
43026 43026 245785 Undocumented 2 Cordyline australis :: Dracena Palm 141 21 Addison St 12 Back Yard : Yard 13 Tree 1 Private 1     2 Width 4ft   6003634.59217 2096849.8681700001 37.7377562131711 -122.42993297014401 (37.7377562131711, -122.429932970144)
43212 43212 245782 Undocumented 2 Cordyline australis :: Dracena Palm 141 21 Addison St 8 Back Yard : Yard 13 Tree 1 Private 1     6 Width 8ft   6003599.488059999 2096849.28505 37.7377526239794 -122.43005430038299 (37.7377526239794, -122.430054300383)
54645 54645 245788 Undocumented 2 Cordyline australis :: Dracena Palm 141 59 Poppy Ln 1 Back Yard : Yard 13 Tree 1 Private 1     8 Width 2ft   6002650.36065 2096519.5995200002 37.736793583358605 -122.433312337306 (37.7367935833586, -122.433312337306)
160995 160995 245783 Undocumented 2 Cordyline australis :: Dracena Palm 141 21 Addison St 10 Back Yard : Yard 13 Tree 1 Private 1     6 Width 8ft   6003607.92987 2096849.5108400001 37.73775372205 -122.430025129081 (37.73775372205, -122.430025129081)
162015 162015 245786 Undocumented 2 Cordyline australis :: Dracena Palm 141 21 Addison St 13 Back Yard : Yard 13 Tree 1 Private 1     2 Width 3ft   6003641.8158599995 2096850.294 37.73775779149221 -122.429908024732 (37.7377577914922, -122.429908024732)
176501 176501 245784 Undocumented 2 Cordyline australis :: Dracena Palm 141 21 Addison St 11 Back Yard : Yard 13 Tree 1 Private 1     4 Width 4ft   6003626.79774 2096849.74169 37.7377554244689 -122.429959910226 (37.7377554244689, -122.429959910226)
177217 177217 245789 Undocumented 2 Cordyline australis :: Dracena Palm 141 13 Penny Ln 1 Back Yard : Yard 13 Tree 1 Private 1     23 Width 2ft   6002510.68516 2096313.6496700002 37.736220167514404 -122.433780540537 (37.7362201675144, -122.433780540537)
177983 177983 245778 Undocumented 2 Cordyline australis :: Dracena Palm 141 21 Addison St 1 Back Yard : Yard 13 Tree 1 Private 1     11 Width 8ft   6003567.005919999 2096851.6434799999 37.7377572599929 -122.43016677498899 (37.7377572599929, -122.430166774989)
178882 178882 245780 Undocumented 2 Cordyline australis :: Dracena Palm 141 21 Addison St 5 Back Yard : Yard 13 Tree 1 Private 1     2 Width 8ft   6003583.611880001 2096848.84807 37.7377505249636 -122.430109160821 (37.7377505249636, -122.430109160821)
183987 183987 245781 Undocumented 2 Cordyline australis :: Dracena Palm 141 21 Addison St 6 Back Yard : Yard 13 Tree 1 Private 1     17 Width 8ft   6003587.5616 2096850.22083 37.7377545179491 -122.43009560263799 (37.7377545179491, -122.430095602638)
184872 184872 245779 Undocumented 2 Cordyline australis :: Dracena Palm 141 21 Addison St 4 Back Yard : Yard 13 Tree 1 Private 1     4 Width 8ft   6003578.068469999 2096849.2280400002 37.73775125431 -122.430128354157 (37.73775125431, -122.430128354157)

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