Street_Tree_List

Data source: data.sfgov.org

19 rows where DBH = 6, qSiteInfo = 9 and qSpecies = 27

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qAddress, SiteOrder, PlotSize

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
30391 30391 207358 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 171 Staples Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6     5998941.871780001 2093762.1788299999 37.7290112721346 -122.445935896945 (37.7290112721346, -122.445935896945)
33118 33118 118541 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 8250 Geary Blvd 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6     5981337.423690001 2112399.66579 37.779163567264 -122.50817750438699 (37.779163567264, -122.508177504387)
35068 35068 207355 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 430 Edna St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6     5998789.17566 2094262.87598 37.730377348622106 -122.446499784464 (37.7303773486221, -122.446499784464)
51466 51466 118540 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 8250 Geary Blvd 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6     5981337.117190001 2112394.76177 37.7791500842164 -122.50817820058701 (37.7791500842164, -122.508178200587)
59140 59140 207326 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 43 Gaviota Way 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 3ft   5998477.362380001 2097389.2678 37.7389438623547 -122.447802750104 (37.7389438623547, -122.447802750104)
59995 59995 226605 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 276 Bemis St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 6ft   6002989.382569999 2096277.75645 37.7361487649474 -122.432122925433 (37.7361487649474, -122.432122925433)
68271 68271 177021 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 1538 Burrows St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 4ft   6006775.37088 2092172.2563099999 37.72508988269 -122.41874212587 (37.72508988269, -122.41874212587)
75063 75063 123520 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 2808 Fulton St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 5ft   5994672.01997 2110241.5879900004 37.774014807441795 -122.461891472498 (37.7740148074418, -122.461891472498)
129591 129591 185132 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 2675 34th Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 0ft   5985816.5603 2097133.8948 37.7375109017116 -122.491558549707 (37.7375109017116, -122.491558549707)
136022 136022 118580 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 7900 Geary Blvd 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 10ft   5982502.32297 2112445.62468 37.7793583322752 -122.504151113367 (37.7793583322752, -122.504151113367)
147909 147909 226624 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 366 Eureka St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 3ft   6001461.5255 2103604.00302 37.75617816071271 -122.437929936033 (37.7561781607127, -122.437929936033)
152419 152419 207191 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 212 Hearst Ave 8 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6     5999968.7786 2094392.65203 37.7308009895755 -122.442431058168 (37.7308009895755, -122.442431058168)
158267 158267 207227 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 314 Ashton Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 2ft   5994211.43434 2092004.54355 37.7239139822334 -122.46216184121799 (37.7239139822334, -122.462161841218)
158363 158363 207189 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 212 Hearst Ave 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6     5999987.6528199995 2094392.26023 37.7308009895722 -122.442365779062 (37.7308009895722, -122.442365779062)
171748 171748 207363 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 98 Judson Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6     5999482.34141 2093540.9124 37.7284345728794 -122.444051566321 (37.7284345728794, -122.444051566321)
184301 184301 207208 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 101 Foerster St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 10ft   5998074.52147 2093832.4092700002 37.7291545431359 -122.44893943651199 (37.7291545431359, -122.448939436512)
184400 184400 207325 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 530 Rockdale Dr 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 3ft   5997976.81268 2097718.94755 37.739820461255604 -122.449557161036 (37.7398204612556, -122.449557161036)
185589 185589 207219 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 147 Judson Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6     5999123.85922 2093459.79448 37.728191385403704 -122.445285022505 (37.7281913854037, -122.445285022505)
188987 188987 207327 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 48 Gaviota Way 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 3ft   5998437.39477 2097397.71392 37.7389647688951 -122.44794154698401 (37.7389647688951, -122.447941546984)

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