Street_Tree_List

Data source: data.sfgov.org

9 rows where qAddress = "4404 20th St" and qSiteInfo = 23

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qSpecies, DBH

qAddress ✖

  • 4404 20th St · 9 ✖
Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
24928 24928 223320 Undocumented 2 Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 4404 20th St 5 : Yard 23 Tree 1 Private 1     6 Width 3ft   6003607.3788 2104219.57182 37.7579901597246 -122.430552770305 (37.7579901597246, -122.430552770305)
25470 25470 223317 Undocumented 2 Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 4404 20th St 2 : Yard 23 Tree 1 Private 1     3 Width 3ft   6003628.73131 2104227.65103 37.7580135529078 -122.430479500748 (37.7580135529078, -122.430479500748)
38165 38165 223321 Undocumented 2 Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 4404 20th St 6 : Yard 23 Tree 1 Private 1     6 Width 3ft   6003607.59341 2104210.2360400003 37.757964538052796 -122.430551361954 (37.7579645380528, -122.430551361954)
43379 43379 223787 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 4404 20th St 9 : Yard 23 Tree 1 Private 1     44 Width 3ft   6003650.35726 2104229.2336 37.75801912330729 -122.430404821951 (37.7580191233073, -122.430404821951)
68242 68242 223322 Undocumented 2 Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 4404 20th St 7 : Yard 23 Tree 1 Private 1     6 Width 3ft   6003609.4958 2104203.70513 37.757946713498704 -122.430544316686 (37.7579467134987, -122.430544316686)
75344 75344 233331 Undocumented 2 Pinus radiata :: Monterey Pine 3 4404 20th St 10 : Yard 23 Tree 1 Private 1     16 Width 3ft   6003656.39078 2104225.45781 37.7580090976571 -122.430383686085 (37.7580090976571, -122.430383686085)
151521 151521 223316 Undocumented 2 Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 4404 20th St 1 : Yard 23 Tree 1 Private 1     3 Width 3ft   6003622.06269 2104228.7754599997 37.7580162625599 -122.430502643895 (37.7580162625599, -122.430502643895)
156226 156226 223318 Undocumented 2 Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 4404 20th St 3 : Yard 23 Tree 1 Private 1     6 Width 3ft   6003637.291809999 2104227.88023 37.75801466716629 -122.43044991126101 (37.7580146671663, -122.430449911261)
171294 171294 223319 Undocumented 2 Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 4404 20th St 4 : Yard 23 Tree 1 Private 1     3 Width 3ft   6003647.0575 2104227.27295 37.7580135529116 -122.43041609403299 (37.7580135529116, -122.430416094033)

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