Street_Tree_List

Data source: data.sfgov.org

13 rows where SiteOrder = 2, qSiteInfo = 2 and qSpecies = 27

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: DBH, PlotSize

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
34276 34276 182870 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 1847 26th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 0ft   5988127.2852 2102724.1956 37.752995155363 -122.483979194232 (37.752995155363, -122.483979194232)
37571 37571 249979 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 13 Napier Ln 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 0ft   6011649.02488 2120183.7348700003 37.802276317051 -122.403864545927 (37.802276317051, -122.403864545927)
41674 41674 185771 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 1325 Ortega St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 0ft   5989890.4756 2102411.1303 37.7522380517247 -122.47785892610399 (37.7522380517247, -122.477858926104)
42179 42179 207304 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 53 Hazelwood Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5996585.7495 2094006.0145 37.72954596675461 -122.454098749052 (37.7295459667546, -122.454098749052)
42221 42221 207173 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 451 Ulloa St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 4ft   5995323.713819999 2098239.63146 37.7410979958728 -122.45876808490601 (37.7410979958728, -122.458768084906)
47869 47869 129491 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 2536 Baker St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 4ft   5999689.18555 2117591.31365 37.794482803901296 -122.445064787505 (37.7944828039013, -122.445064787505)
54556 54556 207281 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 595 Darien Way 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   5993428.290469999 2094922.6798 37.731881346040794 -122.46508086700001 (37.7318813460408, -122.465080867)
58029 58029 207272 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 855 Ortega St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   5991341.884190001 2102447.3188400003 37.7524215459225 -122.472842415544 (37.7524215459225, -122.472842415544)
59888 59888 177028 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 164 Baltimore Way 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 6ft   6002357.56159 2086195.5289200002 37.7084293823926 -122.433587065817 (37.7084293823926, -122.433587065817)
63518 63518 207294 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 1414 Plymouth Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 3ft   5995890.4022699995 2093395.3891200002 37.727829439763106 -122.456458481978 (37.7278294397631, -122.456458481978)
74649 74649 207296 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 217 Colon Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5996041.08515 2094289.8634799998 37.7302941010767 -122.456002210028 (37.7302941010767, -122.456002210028)
149640 149640 207307 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 40 Hazelwood Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5996632.29133 2093946.6824400001 37.7293857237559 -122.453933566973 (37.7293857237559, -122.453933566973)
173676 173676 207279 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 186 Merced Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 4ft   5994221.53046 2099188.36085 37.743639556416504 -122.462647812372 (37.7436395564165, -122.462647812372)

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