Street_Tree_List

Data source: data.sfgov.org

20 rows where qSiteInfo = 10 and qSpecies = 15

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qAddress, SiteOrder, DBH, PlotSize

qSiteInfo ✖

  • Sidewalk: Curb side : Pot · 20 ✖
Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
31275 31275 195449 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 400 The Embarcadero 5 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     5 Width 5ft   6014736.842019999 2117083.55492 37.7939359738125 -122.392962080059 (37.7939359738125, -122.392962080059)
32033 32033 235482 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 106 Chattanooga St 6 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     8 Width 4ft   6004702.50004 2102988.75016 37.7546725903948 -122.42667772741699 (37.7546725903948, -122.426677727417)
32945 32945 178518 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 62 Kelloch Ave 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     14 Width 6ft   6008249.62715 2086262.35093 37.708945414261606 -122.41322803793899 (37.7089454142616, -122.413228037939)
38524 38524 124392 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 3900 Washington St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     7 Width 2ft   5996085.26261 2115570.92527 37.788729010018294 -122.45738849109199 (37.7887290100183, -122.457388491092)
40643 40643 195447 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 400 The Embarcadero 3 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     3 Width 5ft   6014706.202819999 2117116.39491 37.794024442814106 -122.393070394401 (37.7940244428141, -122.393070394401)
51822 51822 195451 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 400 The Embarcadero 7 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     6 Width 5ft   6014767.70739 2117048.87622 37.793842468603 -122.392852854701 (37.793842468603, -122.392852854701)
58740 58740 195446 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 400 The Embarcadero 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     5 Width 5ft   6014688.3614 2117131.68733 37.794065441128 -122.393133198563 (37.794065441128, -122.393133198563)
59798 59798 195450 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 400 The Embarcadero 6 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     4 Width 5ft   6014751.24936 2117067.54594 37.793892817153704 -122.392911108287 (37.7938928171537, -122.392911108287)
74677 74677 195448 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 400 The Embarcadero 4 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     5 Width 5ft   6014719.29527 2117100.4128400004 37.793981287051295 -122.393023974076 (37.7939812870513, -122.393023974076)
130790 130790 124395 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 3900 Washington St 4 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     12 Width 3ft   5996032.15972 2115565.17728 37.7887101773731 -122.45757180221001 (37.7887101773731, -122.45757180221)
134604 134604 135302 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 840 California St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     12 Width 2ft   6010328.26528 2116562.4227 37.792259202258 -122.408179486788 (37.792259202258, -122.408179486788)
146601 146601 178617 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1686 Alemany Blvd 3 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     17 Width 3ft   6001466.5158400005 2092244.27913 37.72498730330771 -122.43709939413999 (37.7249873033077, -122.43709939414)
147317 147317 124393 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 3900 Washington St 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     7 Width 2ft   5996070.40089 2115569.6533 37.7887246639076 -122.457439818112 (37.7887246639076, -122.457439818112)
147550 147550 135303 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 840 California St 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     11 Width 2ft   6010295.40817 2116554.0512599996 37.79223437647521 -122.40829258284799 (37.7922343764752, -122.408292582848)
148359 148359 124394 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 3900 Washington St 3 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     9 Width 2ft   5996045.97336 2115566.9988599997 37.7887159724195 -122.45752414117099 (37.7887159724195, -122.457524141171)
157502 157502 178616 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1686 Alemany Blvd 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     24 Width 4ft   6001474.37484 2092261.25737 37.7250343684236 -122.437073441507 (37.7250343684236, -122.437073441507)
163842 163842 238601 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 4808 25th St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     20 Width 10ft   5999995.98595 2101090.80522 37.7491940814535 -122.442817794501 (37.7491940814535, -122.442817794501)
180318 180318 238602 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 4808 25th St 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     11 Width 10ft   5999965.12286 2101089.08454 37.7491875973318 -122.442924395649 (37.7491875973318, -122.442924395649)
182549 182549 134900 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 301 Union St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     7 Width 3ft   6011410.78161 2119701.10617 37.8009378236702 -122.404654992453 (37.8009378236702, -122.404654992453)
186167 186167 195445 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 400 The Embarcadero 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     5 Width 5ft   6014671.32996 2117148.01113 37.79410931633421 -122.393193272358 (37.7941093163342, -122.393193272358)

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