Street_Tree_List

Data source: data.sfgov.org

19 rows where SiteOrder = 2 and qSpecies = 67

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, DBH, PlotSize

SiteOrder ✖

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
20750 20750 4205 DPW Maintained 3 Gleditsia triacanthos :: Honey Locust 67 3912 Cesar Chavez St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 3X3   6004396.20206 2100464.83316 37.747725180966796 -122.42755718612699 (37.7477251809668, -122.427557186127)
31700 31700 228349 Undocumented 2 Gleditsia triacanthos :: Honey Locust 67 583 Elizabeth St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6002614.94604 2102076.64 37.7520499091975 -122.43383185498001 (37.7520499091975, -122.43383185498)
34550 34550 190626 Undocumented 2 Gleditsia triacanthos :: Honey Locust 67 1155 04th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 5ft   6015057.75881 2109472.8514 37.773056530760606 -122.39131939456999 (37.7730565307606, -122.39131939457)
63417 63417 31615 Permitted Site 1 Gleditsia triacanthos :: Honey Locust 67 750 Guerrero St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/22/1995 12:00:00 AM     Permit Number 35136 6005596.48777411 2104595.39586612 37.75913456673371 -122.423700300709 (37.7591345667337, -122.423700300709)
65309 65309 219144 Undocumented 2 Gleditsia triacanthos :: Honey Locust 67 1349 Ulloa St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5991814.61663 2098388.03003 37.7413031402225 -122.47091196770799 (37.7413031402225, -122.470911967708)
78326 78326 39114 Permitted Site 1 Gleditsia triacanthos :: Honey Locust 67 501 Bartlett St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/19/1998 12:00:00 AM     Permit Number 40801 6006834.26665835 2100862.7419909 37.7489553490953 -122.419154691519 (37.7489553490953, -122.419154691519)
83784 83784 47253 Permitted Site 1 Gleditsia triacanthos :: Honey Locust 67 1001 Le Conte Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/02/2009 12:00:00 AM   3x3 Permit Number 52373 6013117.42744406 2089558.25653077 37.718267407089 -122.39663499597201 (37.718267407089, -122.396634995972)
95946 95946 36801 Permitted Site 1 Gleditsia triacanthos :: Honey Locust 67 1365 Donner Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/26/1998 12:00:00 AM     Permit Number 39529 6015184.51378884 2090800.41329061 37.72179295326 -122.389576597698 (37.72179295326, -122.389576597698)
119934 119934 47726 Permitted Site 1 Gleditsia triacanthos :: Honey Locust 67 85 Sycamore St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/23/2002 12:00:00 AM     Permit Number 45520 6006351.18478147 2105818.87737664 37.7625365339004 -122.421177070604 (37.7625365339004, -122.421177070604)
139243 139243 98475 Permitted Site 1 Gleditsia triacanthos :: Honey Locust 67 531X Franconia St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 3x3   6009973.6 2098264.6 37.7419977132603 -122.408115605514 (37.7419977132603, -122.408115605514)
140853 140853 113243 Undocumented 2 Gleditsia triacanthos :: Honey Locust 67 1301X 04TH ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       5x5   5994883.0 2106671.0 37.7642230519674 -122.46090282761001 (37.7642230519674, -122.46090282761)
141780 141780 31398 Permitted Site 1 Gleditsia triacanthos :: Honey Locust 67 3850 18th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/26/1995 12:00:00 AM     Permit Number 34990 6003938.7782539 2105415.4152023997 37.7612924290105 -122.429491931159 (37.7612924290105, -122.429491931159)
142349 142349 46812 Permitted Site 1 Gleditsia triacanthos :: Honey Locust 67 172 Yerba Buena Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/25/2002 12:00:00 AM     Permit Number 44893 5994497.83320908 2096348.9473150002 37.7358591414077 -122.461486623647 (37.7358591414077, -122.461486623647)
149623 149623 246820 Undocumented 2 Gleditsia triacanthos :: Honey Locust 67 198 Brewster St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2     6010060.69624 2098737.22367 37.743300311476105 -122.40784777277399 (37.7433003114761, -122.407847772774)
158412 158412 228362 Undocumented 2 Gleditsia triacanthos :: Honey Locust 67 685 Florida St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6009250.9801199995 2105080.31874 37.7606716691902 -122.411095524149 (37.7606716691902, -122.411095524149)
161353 161353 190620 Undocumented 2 Gleditsia triacanthos :: Honey Locust 67 111 Vermont St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6011131.868919999 2107990.98095 37.7687689895213 -122.404795265999 (37.7687689895213, -122.404795265999)
167861 167861 199663 Undocumented 2 Gleditsia triacanthos :: Honey Locust 67 1375 Donner Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 0ft   6015172.7356 2090807.3573 37.72181136705721 -122.389617796925 (37.7218113670572, -122.389617796925)
175181 175181 228355 Undocumented 2 Gleditsia triacanthos :: Honey Locust 67 650 Florida St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6009239.492459999 2105360.20677 37.761439533729 -122.41115502598801 (37.761439533729, -122.411155025988)
177224 177224 201612 Undocumented 2 Gleditsia triacanthos :: Honey Locust 67 98 Jerrold Ave 2 Side Yard : Yard 17 Tree 1 Private 1     2 Width 3ft   6020781.6072 2092974.15888 37.7280704113081 -122.370378850726 (37.7280704113081, -122.370378850726)

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