Street_Tree_List

Data source: data.sfgov.org

18 rows where PlotSize = "Width 1ft" and qSpecies = 27

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qAddress, SiteOrder, qSiteInfo, DBH

PlotSize ✖

  • Width 1ft · 18 ✖
Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
23605 23605 207223 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 137 Marston Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 1ft   5998550.7404 2093191.23092 37.7274212410962 -122.447246987057 (37.7274212410962, -122.447246987057)
23659 23659 207211 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 351 Judson Ave 13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 1ft   5997557.05916 2093521.06587 37.7282700608095 -122.450705899268 (37.7282700608095, -122.450705899268)
25933 25933 207216 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 351 Judson Ave 18 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 1ft   5997629.9182 2093521.5482700001 37.7282755556595 -122.450454058505 (37.7282755556595, -122.450454058505)
27028 27028 207203 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 659 Joost Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 1ft   5997731.1976 2094979.2607200001 37.732283884374 -122.450208962681 (37.732283884374, -122.450208962681)
49999 49999 207214 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 351 Judson Ave 16 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 1ft   5997600.50896 2093520.6605599998 37.7282714349614 -122.450555663017 (37.7282714349614, -122.450555663017)
60108 60108 207212 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 351 Judson Ave 14 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 1ft   5997571.11535 2093520.52293 37.728269374612495 -122.450657267541 (37.7282693746125, -122.450657267541)
67877 67877 207215 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 351 Judson Ave 17 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 1ft   5997615.0933300005 2093521.35715 37.7282741823893 -122.450505294682 (37.7282741823893, -122.450505294682)
68943 68943 207150 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 830 Ortega St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 1ft   5991404.13851 2102515.6148 37.752612672541105 -122.47263211090099 (37.7526126725411, -122.472632110901)
69001 69001 176998 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 87 Seneca Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 1ft   6000227.51825 2089886.7347900001 37.7184435186304 -122.441213386902 (37.7184435186304, -122.441213386902)
75032 75032 207204 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 655 Joost Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 1ft   5997746.28105 2094978.11771 37.7322816091084 -122.450156733641 (37.7322816091084, -122.450156733641)
75859 75859 207224 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 49 Edna St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 1ft   5998734.87043 2093158.9272 37.727343062112396 -122.446608128468 (37.7273430621124, -122.446608128468)
133371 133371 207206 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 249 Gennessee St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 1ft   5997427.94217 2094345.17262 37.730525470566896 -122.451211668094 (37.7305254705669, -122.451211668094)
154947 154947 207205 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 243 Gennessee St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 1ft   5997427.42425 2094320.33561 37.7304572443933 -122.45121166810499 (37.7304572443933, -122.451211668105)
161425 161425 207217 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 201 Judson Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 1ft   5998700.58194 2093477.09847 37.7282147273036 -122.44674954686701 (37.7282147273036, -122.446749546867)
162797 162797 207229 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 1162 Capitol Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 1ft   5995089.6840699995 2091648.0085099998 37.7229855509323 -122.459100089412 (37.7229855509323, -122.459100089412)
165783 165783 207222 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 147 Edna St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 1ft   5998739.609180001 2093444.36182 37.728127069498 -122.44661227434999 (37.728127069498, -122.44661227435)
169719 169719 207149 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 830 Ortega St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 1ft   5991414.091469999 2102515.7859 37.7526137184551 -122.47259770464198 (37.7526137184551, -122.472597704642)
169893 169893 207213 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 351 Judson Ave 15 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 1ft   5997585.68903 2093520.71926 37.728270747876394 -122.45060690011499 (37.7282707478764, -122.450606900115)

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