Street_Tree_List

Data source: data.sfgov.org

18 rows where qSiteInfo = 4 and qSpecies = 61

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, qAddress, SiteOrder, DBH

qSiteInfo ✖

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
3364 3364 188226 Permitted Site 1 Arbutus unedo :: Strawberry Tree 61 1350 19th St 3 : 4 Tree 1 Private 1   11/01/1996 12:00:00 AM 6 Width 3ft Permit Number 37286 6013575.41694 2105253.06849 37.7613875637091 -122.396151246903 (37.7613875637091, -122.396151246903)
3371 3371 188225 Permitted Site 1 Arbutus unedo :: Strawberry Tree 61 1350 19th St 2 : 4 Tree 1 Private 1   11/01/1996 12:00:00 AM 6 Width 3ft Permit Number 37286 6013591.2999599995 2105254.0413599997 37.7613911187249 -122.396096381957 (37.7613911187249, -122.396096381957)
3379 3379 188227 Permitted Site 1 Arbutus unedo :: Strawberry Tree 61 1350 19th St 4 : 4 Tree 1 Private 1   11/01/1996 12:00:00 AM 5 Width 3ft Permit Number 37286 6013561.10942 2105252.84027 37.7613861409778 -122.39620071499901 (37.7613861409778, -122.396200714999)
23966 23966 221105 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 2815 18th St 8 : 4 Tree 1 Private 1     9 Width 3ft   6009452.05657 2105439.4087799997 37.761668922891296 -122.41042544467301 (37.7616689228913, -122.410425444673)
25324 25324 204254 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 81 Elmhurst Dr 2 : 4 Tree 1 Private 1     4 Width 3ft   5991110.1119800005 2094515.36236 37.7306290086229 -122.473065523856 (37.7306290086229, -122.473065523856)
36521 36521 187478 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 1888 Geneva Ave 1 : 4 Tree 1 Private 1     1 Width 3ft   6004785.02328 2086870.2631599999 37.710419493035104 -122.425245442839 (37.7104194930351, -122.425245442839)
43264 43264 221106 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 2815 18th St 9 : 4 Tree 1 Private 1     11 Width 3ft   6009472.02471 2105439.84712 37.7616712458547 -122.410356413623 (37.7616712458547, -122.410356413623)
53922 53922 221100 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 2815 18th St 3 : 4 Tree 1 Private 1     10 Width 3ft   6009350.253169999 2105434.72135 37.7616503447144 -122.41077721180599 (37.7616503447144, -122.410777211806)
61465 61465 221103 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 2815 18th St 6 : 4 Tree 1 Private 1     9 Width 3ft   6009402.10993 2105437.04552 37.7616596338129 -122.410598023702 (37.7616596338129, -122.410598023702)
68111 68111 221104 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 2815 18th St 7 : 4 Tree 1 Private 1     9 Width 3ft   6009432.49535 2105438.1168 37.761664278799 -122.41049300806101 (37.761664278799, -122.410493008061)
131919 131919 187479 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 1888 Geneva Ave 2 : 4 Tree 1 Private 1     1 Width 3ft   6004800.91134 2086858.76625 37.7103888225503 -122.42518971275601 (37.7103888225503, -122.425189712756)
137057 137057 204255 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 40 Rossmoor Dr 1 : 4 Tree 1 Private 1     2 Width 3ft   5991076.25798 2094451.1602599998 37.7304507656815 -122.473177880653 (37.7304507656815, -122.473177880653)
138118 138118 221098 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 2815 18th St 1 : 4 Tree 1 Private 1     12 Width 3ft   6009314.5684 2105431.86525 37.7616405016156 -122.410900429722 (37.7616405016156, -122.410900429722)
146788 146788 221099 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 2815 18th St 2 : 4 Tree 1 Private 1     11 Width 3ft   6009329.84306 2105433.4467700003 37.7616457005982 -122.410847712362 (37.7616457005982, -122.410847712362)
158546 158546 204256 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 40 Rossmoor Dr 2 : 4 Tree 1 Private 1     6 Width 3ft   5991070.06293 2094489.8143 37.7305565412538 -122.473202115591 (37.7305565412538, -122.473202115591)
167069 167069 187480 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 1888 Geneva Ave 3 : 4 Tree 1 Private 1     1 Width 3ft   6004820.44605 2086842.7727 37.710346011228104 -122.42512105938299 (37.7103460112281, -122.425121059383)
173685 173685 221102 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 2815 18th St 5 : 4 Tree 1 Private 1     8 Width 3ft   6009385.9447800005 2105435.68423 37.7616549897172 -122.41065383649901 (37.7616549897172, -122.410653836499)
174745 174745 221101 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 2815 18th St 4 : 4 Tree 1 Private 1     11 Width 3ft   6009367.670080001 2105435.00012 37.7616520866991 -122.410716993221 (37.7616520866991, -122.410716993221)

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