Street_Tree_List

Data source: data.sfgov.org

14 rows where qSiteInfo = 2 and qSpecies = 102

✎ 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
26589 26589 196520 Undocumented 2 Prunus blireiana :: Flowering Plum 102 1100 Pennsylvania Ave 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1     6014495.9358 2101776.59314 37.751893084516894 -122.392724321763 (37.7518930845169, -122.392724321763)
39114 39114 218412 Undocumented 2 Prunus blireiana :: Flowering Plum 102 205 Castenada Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 0ft   5994303.242319999 2100628.09542 37.7475974107089 -122.46246968273199 (37.7475974107089, -122.462469682732)
44368 44368 181828 Undocumented 2 Prunus blireiana :: Flowering Plum 102 2311 31st Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 0ft   5986682.779 2099487.7451 37.744024532877496 -122.488736632211 (37.7440245328775, -122.488736632211)
54491 54491 182113 Undocumented 2 Prunus blireiana :: Flowering Plum 102 2462 27th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 0ft   5988005.6699 2098548.963 37.7415239963656 -122.484093600478 (37.7415239963656, -122.484093600478)
64692 64692 120351 Undocumented 2 Prunus blireiana :: Flowering Plum 102 2122 Lake St 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 6ft   5988809.84875 2114710.37 37.7859456052715 -122.482496990767 (37.7859456052715, -122.482496990767)
72171 72171 120349 Undocumented 2 Prunus blireiana :: Flowering Plum 102 2122 Lake St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 6ft   5988820.20378 2114710.2762700003 37.785945950300295 -122.48246115875799 (37.7859459503003, -122.482461158758)
138772 138772 196519 Undocumented 2 Prunus blireiana :: Flowering Plum 102 1100 Pennsylvania Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1     6014493.8282699995 2101802.94838 37.7519653333515 -122.392733453506 (37.7519653333515, -122.392733453506)
148111 148111 196521 Undocumented 2 Prunus blireiana :: Flowering Plum 102 1100 Pennsylvania Ave 7 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1     6014496.49753 2101766.20536 37.751864593079205 -122.392721652585 (37.7518645930792, -122.392721652585)
168107 168107 122160 Undocumented 2 Prunus blireiana :: Flowering Plum 102 547 15th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 4ft   5991246.04787 2111677.1817900003 37.7777587296811 -122.473847129053 (37.7777587296811, -122.473847129053)
173109 173109 218411 Undocumented 2 Prunus blireiana :: Flowering Plum 102 205 Castenada Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 0ft   5994290.425419999 2100613.6082200003 37.7475568944299 -122.462512951805 (37.7475568944299, -122.462512951805)
173448 173448 196517 Undocumented 2 Prunus blireiana :: Flowering Plum 102 1100 Pennsylvania Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1     6014492.802759999 2101818.43499 37.7520077993331 -122.39273808318899 (37.7520077993331, -122.392738083189)
183610 183610 182279 Undocumented 2 Prunus blireiana :: Flowering Plum 102 1496 Kirkham St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 0ft   5984984.0246 2105052.8568 37.7592055205034 -122.495020725609 (37.7592055205034, -122.495020725609)
188630 188630 196518 Undocumented 2 Prunus blireiana :: Flowering Plum 102 1100 Pennsylvania Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1     6014492.91389 2101810.6998099997 37.7519865663454 -122.39273715780399 (37.7519865663454, -122.392737157804)
188721 188721 119033 Undocumented 2 Prunus blireiana :: Flowering Plum 102 745 44th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 4ft   5982267.74264 2110681.1609400003 37.7744998336605 -122.50483182972499 (37.7744998336605, -122.504831829725)

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