Street_Tree_List

Data source: data.sfgov.org

12 rows where qSiteInfo = 13 and qSpecies = 16 sorted by TreeID

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qAddress, SiteOrder, DBH, PlotSize

qSiteInfo ✖

  • Back Yard : Yard · 12 ✖
Link rowid TreeID ▼ qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
54919 54919 237847 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 21 Addison St 3 Back Yard : Yard 13 Tree 1 Private 1     6 Width 8ft   6003573.70242 2096850.7481 37.7377551807635 -122.430143558104 (37.7377551807635, -122.430143558104)
27714 27714 237848 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 21 Addison St 7 Back Yard : Yard 13 Tree 1 Private 1     6 Width 8ft   6003593.08721 2096850.61715 37.7377559191042 -122.430076526206 (37.7377559191042, -122.430076526206)
53839 53839 249807 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 258 Chestnut St 6 Back Yard : Yard 13 Tree 1 Private 1     7 Width 0ft   6010752.11734 2121021.55825 37.8045266258517 -122.407027386026 (37.8045266258517, -122.407027386026)
156801 156801 249808 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 258 Chestnut St 7 Back Yard : Yard 13 Tree 1 Private 1     12 Width 0ft   6010714.23144 2121016.75548 37.80451131849129 -122.40715815553101 (37.8045113184913, -122.407158155531)
169417 169417 249809 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 258 Chestnut St 8 Back Yard : Yard 13 Tree 1 Private 1     5 Width 0ft   6010708.4562800005 2121025.2354099997 37.804534279087704 -122.407178739215 (37.8045342790877, -122.407178739215)
52205 52205 249810 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 258 Chestnut St 9 Back Yard : Yard 13 Tree 1 Private 1     5 Width 0ft   6010696.08755 2121019.21593 37.804517058874396 -122.407221117962 (37.8045170588744, -122.407221117962)
131807 131807 249873 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 230 Greenwich St 9 Back Yard : Yard 13 Tree 1 Private 1     26 Width 0ft   6011670.78297 2120474.23594 37.8030751776447 -122.403809705266 (37.8030751776447, -122.403809705266)
171246 171246 249875 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 230 Greenwich St 11 Back Yard : Yard 13 Tree 1 Private 1     19 Width 0ft   6011656.00691 2120465.5569700003 37.803050521838706 -122.40386022737499 (37.8030505218387, -122.403860227375)
37934 37934 249882 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 230 Greenwich St 18 Back Yard : Yard 13 Tree 1 Private 1     27 Width 0ft   6011509.072430001 2120419.3733099997 37.8029155030083 -122.40436544761499 (37.8029155030083, -122.404365447615)
51583 51583 249891 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 230 Greenwich St 27 Back Yard : Yard 13 Tree 1 Private 1     15 Width 0ft   6011455.072819999 2120426.06234 37.8029308517393 -122.404552786308 (37.8029308517393, -122.404552786308)
28833 28833 249969 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 213 Filbert St 2 Back Yard : Yard 13 Tree 1 Private 1     28 Width 0ft   6011730.79134 2120085.86253 37.802012151107704 -122.403574702535 (37.8020121511077, -122.403574702535)
159363 159363 249970 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 213 Filbert St 1 Back Yard : Yard 13 Tree 1 Private 1     31 Width 0ft   6011737.037830001 2120086.51138 37.802014281606205 -122.403553132272 (37.8020142816062, -122.403553132272)

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