Street_Tree_List

Data source: data.sfgov.org

22 rows where qSiteInfo = 4 and qSpecies = 131

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qAddress, SiteOrder, DBH, PlotSize

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
23657 23657 196979 Undocumented 2 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 1551 20th St 2 : 4 Tree 1 Private 1     5 Width 4ft   6013315.21298 2104723.80911 37.7599198521353 -122.39701407983802 (37.7599198521353, -122.397014079838)
32983 32983 196995 Undocumented 2 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 2 Napoleon St 8 : 4 Tree 1 Private 1     8 Width 4ft   6013853.97089 2100136.72086 37.7473546683845 -122.394829506973 (37.7473546683845, -122.394829506973)
38113 38113 196990 Undocumented 2 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 2 Napoleon St 1 : 4 Tree 1 Private 1     6 Width 4ft   6014143.12746 2100151.41021 37.7474110756645 -122.39383064437901 (37.7474110756645, -122.393830644379)
39431 39431 241273 Undocumented 2 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 55 Haight St 2 : 4 Tree 1 Private 1     3 Width 3ft   6005874.88911 2109629.37494 37.7729723901943 -122.423095264536 (37.7729723901943, -122.423095264536)
40771 40771 241272 Undocumented 2 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 67 Webster St 1 : 4 Tree 1 Private 1     13 Width 4ft   6004275.92505 2108860.93687 37.770772085482605 -122.428571490982 (37.7707720854826, -122.428571490982)
51103 51103 196994 Undocumented 2 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 2 Napoleon St 7 : 4 Tree 1 Private 1     7 Width 4ft   6013884.28274 2100137.93009 37.7473596740254 -122.39472477462401 (37.7473596740254, -122.394724774624)
69932 69932 197000 Undocumented 2 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 2 Napoleon St 15 : 4 Tree 1 Private 1     6 Width 4ft   6013614.06576 2100123.51682 37.7473050707808 -122.39565816299401 (37.7473050707808, -122.395658162994)
70562 70562 197002 Undocumented 2 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 2251 Silver Ave 3 : 4 Tree 1 Private 1     6 Width 3ft   6012830.37736 2096288.90355 37.736732407869205 -122.398099143384 (37.7367324078692, -122.398099143384)
73978 73978 196978 Undocumented 2 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 1551 20th St 1 : 4 Tree 1 Private 1     6 Width 4ft   6013296.03231 2104723.49575 37.7599179239891 -122.397080394946 (37.7599179239891, -122.397080394946)
75172 75172 196997 Undocumented 2 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 2 Napoleon St 11 : 4 Tree 1 Private 1     7 Width 4ft   6013762.67186 2100131.60985 37.747335557807496 -122.395144856947 (37.7473355578075, -122.395144856947)
130649 130649 197001 Undocumented 2 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 2 Napoleon St 16 : 4 Tree 1 Private 1     9 Width 4ft   6013598.90827 2100122.82985 37.7473023413409 -122.395710528743 (37.7473023413409, -122.395710528743)
134526 134526 196998 Undocumented 2 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 2 Napoleon St 13 : 4 Tree 1 Private 1     5 Width 4ft   6013702.500030001 2100126.86267 37.7473191766464 -122.39535259585101 (37.7473191766464, -122.395352595851)
134822 134822 246838 Undocumented 2 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 399 Broderick St 1 : 4 Tree 1 Private 1     5 Width 4ft   6001188.47767 2109990.61312 37.7736986862745 -122.43933199347201 (37.7736986862745, -122.439331993472)
135846 135846 201661 Undocumented 2 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 149 Dore St 1 : 4 Tree 1 Private 1     3 Width 2ft   6009207.44548 2109499.9434599997 37.772804497555704 -122.411558355748 (37.7728044975557, -122.411558355748)
152365 152365 196991 Undocumented 2 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 2 Napoleon St 2 : 4 Tree 1 Private 1     5 Width 4ft   6014086.846369999 2100149.18925 37.7474018495283 -122.394025106589 (37.7474018495283, -122.394025106589)
152370 152370 196996 Undocumented 2 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 2 Napoleon St 10 : 4 Tree 1 Private 1     8 Width 4ft   6013793.66265 2100133.46781 37.7473423827584 -122.395037822335 (37.7473423827584, -122.395037822335)
161791 161791 246445 Undocumented 2 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 457 Duncan St 1 : 4 Tree 1 Private 1     8 Width 3ft   6003558.45361 2099788.20108 37.7458198862793 -122.43040580490101 (37.7458198862793, -122.430405804901)
173145 173145 196992 Undocumented 2 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 2 Napoleon St 5 : 4 Tree 1 Private 1     7 Width 4ft   6013942.24849 2100140.56785 37.747370139416205 -122.394524516312 (37.7473701394162, -122.394524516312)
173275 173275 246856 Undocumented 2 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 425 Divisadero St 1 : 4 Tree 1 Private 1     4 Width 3ft   6001680.71036 2109929.19364 37.773558043107 -122.43762488777901 (37.773558043107, -122.437624887779)
174204 174204 196999 Undocumented 2 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 2 Napoleon St 14 : 4 Tree 1 Private 1     4 Width 4ft   6013629.21679 2100123.8728 37.7473068910098 -122.39560579639401 (37.7473068910098, -122.395605796394)
178824 178824 196980 Undocumented 2 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 320 Missouri St 1 : 4 Tree 1 Private 1     14 Width 3ft   6013452.78538 2105563.26016 37.76223245789279 -122.396597126255 (37.7622324578928, -122.396597126255)
187168 187168 196993 Undocumented 2 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 2 Napoleon St 6 : 4 Tree 1 Private 1     7 Width 4ft   6013912.096059999 2100139.0238799998 37.7473642236913 -122.39462867398501 (37.7473642236913, -122.394628673985)

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