Street_Tree_List

Data source: data.sfgov.org

16 rows where PlantDate = "07/15/1994 12:00:00 AM" and qSpecies = 100

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qAddress, SiteOrder, DBH, PlotSize, XCoord, YCoord, Latitude, Longitude, Location

PlantDate ✖

  • 07/15/1994 12:00:00 AM · 16 ✖
Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
78875 78875 27848 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 100 The Embarcadero 3 Median : Cutout 11 Tree 1 Port 9   07/15/1994 12:00:00 AM 12 3X3   6015938.91901 2112416.43301 37.7811878161514 -122.388476823036 (37.7811878161514, -122.388476823036)
83890 83890 27801 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 650X The Embarcadero 5 Median : Cutout 11 Tree 1 Port 9   07/15/1994 12:00:00 AM 36 15   6012967.8705311 2119824.4474868 37.8013633914033 -122.399275432078 (37.8013633914033, -122.399275432078)
90111 90111 27847 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 280 The Embarcadero 8 Median : Cutout 11 Tree 1 Port 9   07/15/1994 12:00:00 AM 36     6013933.6105332 2118392.9536833 37.797486624670704 -122.395833154489 (37.7974866246707, -122.395833154489)
99547 99547 27845 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 280 The Embarcadero 6 Median : Cutout 11 Tree 1 Port 9   07/15/1994 12:00:00 AM 36     6013933.6105332 2118392.9536833 37.797486624670704 -122.395833154489 (37.7974866246707, -122.395833154489)
100729 100729 27843 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 280 The Embarcadero 4 Median : Cutout 11 Tree 1 Port 9   07/15/1994 12:00:00 AM 36     6013933.6105332 2118392.9536833 37.797486624670704 -122.395833154489 (37.7974866246707, -122.395833154489)
105556 105556 27842 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 280 The Embarcadero 3 Median : Cutout 11 Tree 1 Port 9   07/15/1994 12:00:00 AM 36     6013933.6105332 2118392.9536833 37.797486624670704 -122.395833154489 (37.7974866246707, -122.395833154489)
105677 105677 27827 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 280 The Embarcadero 1 Median : Cutout 11 Tree 1 Port 9   07/15/1994 12:00:00 AM 36     6013933.6105332 2118392.9536833 37.797486624670704 -122.395833154489 (37.7974866246707, -122.395833154489)
109189 109189 27850 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 100 The Embarcadero 5 Median : Cutout 11 Tree 1 Port 9   07/15/1994 12:00:00 AM 12 3X3   6015895.51701 2112292.73501 37.7808457639334 -122.38861833648701 (37.7808457639334, -122.388618336487)
110061 110061 27844 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 280 The Embarcadero 5 Median : Cutout 11 Tree 1 Port 9   07/15/1994 12:00:00 AM 36     6013933.6105332 2118392.9536833 37.797486624670704 -122.395833154489 (37.7974866246707, -122.395833154489)
114765 114765 27804 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 550X The Embarcadero 6 Median : Cutout 11 Tree 1 Port 9   07/15/1994 12:00:00 AM 36 15   6013263.823467299 2119389.8203611 37.8001864990432 -122.398220785892 (37.8001864990432, -122.398220785892)
115875 115875 27841 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 280 The Embarcadero 2 Median : Cutout 11 Tree 1 Port 9   07/15/1994 12:00:00 AM 36     6013933.6105332 2118392.9536833 37.797486624670704 -122.395833154489 (37.7974866246707, -122.395833154489)
117445 117445 27852 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 100 The Embarcadero 7 Median : Cutout 11 Tree 1 Port 9   07/15/1994 12:00:00 AM 12 3X3   6015817.39201 2112182.05801 37.780537539741395 -122.388880882265 (37.7805375397414, -122.388880882265)
118319 118319 27846 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 280 The Embarcadero 7 Median : Cutout 11 Tree 1 Port 9   07/15/1994 12:00:00 AM 36     6013933.6105332 2118392.9536833 37.797486624670704 -122.395833154489 (37.7974866246707, -122.395833154489)
120266 120266 27849 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 100 The Embarcadero 4 Median : Cutout 11 Tree 1 Port 9   07/15/1994 12:00:00 AM 12 3X3   6015921.55801 2112354.58401 37.7810170305764 -122.388532565578 (37.7810170305764, -122.388532565578)
139779 139779 27853 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 100 The Embarcadero 8 Median : Cutout 11 Tree 1 Port 9   07/15/1994 12:00:00 AM 12 3X3   6015772.90401 2112134.31501 37.780403982219205 -122.389031454309 (37.7804039822192, -122.389031454309)
139983 139983 27851 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 100 The Embarcadero 6 Median : Cutout 11 Tree 1 Port 9   07/15/1994 12:00:00 AM 12 3X3   6015857.5390099995 2112236.31101 37.7806887314792 -122.388745782008 (37.7806887314792, -122.388745782008)

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