Street_Tree_List

Data source: data.sfgov.org

22 rows where DBH = 1, PlotSize = "Width 0ft" and qSpecies = 48

View and edit SQL

Suggested facets: qAddress, SiteOrder, qSiteInfo, YCoord

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
27198 140780 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 5 Encanto Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   6000014.7367 2112198.3604 37.7796937331341 -122.44355075738399 (37.7796937331341, -122.443550757384)
28890 182659 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 2252 Ortega St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   5986985.3742 2102363.8158 37.7519391046129 -122.487901613135 (37.7519391046129, -122.487901613135)
35420 182699 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1659 Moraga St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   5989088.7291 2103739.8915 37.755839910949895 -122.480728726959 (37.7558399109499, -122.480728726959)
37433 184723 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1635 42nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   5983115.9866 2103988.5253 37.7561736313112 -122.501402462618 (37.7561736313112, -122.501402462618)
41737 183303 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1286 43rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   5982766.9656 2106385.9546 37.7627357893861 -122.502786935917 (37.7627357893861, -122.502786935917)
43034 140758 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 42 TERRA VISTA AVE 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   6000316.7782 2112875.0348 37.781568928755895 -122.442554464995 (37.7815689287559, -122.442554464995)
63806 181949 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 2450 32nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   5986451.9754 2098568.253 37.7414863814969 -122.489467090095 (37.7414863814969, -122.489467090095)
66926 184599 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1795 40th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   5983770.6594 2102984.6576 37.7534557168171 -122.499064248064 (37.7534557168171, -122.499064248064)
117673 140302 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 143 COLE ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   5997780.8586 2110053.3207 37.773676357183 -122.45112394331899 (37.773676357183, -122.451123943319)
130143 182826 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1781 31st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   5986558.6884 2103101.4836 37.7539396409234 -122.48943136928999 (37.7539396409234, -122.48943136929)
135392 181684 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1347 31st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   5986459.3313 2106064.8642 37.7620704697574 -122.48999290967501 (37.7620704697574, -122.489992909675)
153218 182607 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1867 32nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   5986269.2088 2102542.1488 37.7523869566931 -122.49039129916001 (37.7523869566931, -122.49039129916)
160731 140699 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 224 ASHBURY ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   5998816.4363 2109919.7991 37.773368976906205 -122.447532121663 (37.7733689769062, -122.447532121663)
167364 182307 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1509 29th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   5987118.7965 2104973.5941 37.7591126281614 -122.487631931758 (37.7591126281614, -122.487631931758)
171120 184598 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1795 40th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   5983770.321 2103008.0087 37.7535198125919 -122.499067143504 (37.7535198125919, -122.499067143504)
173458 184640 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1650 42nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   5983160.9711 2103902.0944 37.7559389581009 -122.501240500695 (37.7559389581009, -122.501240500695)
175623 184549 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 3501 Moraga St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 0ft   5983411.1343 2103548.3965 37.754982490057 -122.50034921882099 (37.754982490057, -122.500349218821)
176471 182700 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1651 Moraga St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   5989102.9459 2103739.8915 37.7558407372502 -122.48067956122401 (37.7558407372502, -122.480679561224)
178120 181690 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1374 45th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   5982168.1662 2105754.9295 37.760967965591604 -122.504811174863 (37.7609679655916, -122.504811174863)
179813 137671 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 756 LYON ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   6000049.6788 2111547.4906 37.7779086039439 -122.443383113797 (37.7779086039439, -122.443383113797)
185807 182658 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 2242 Ortega St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   5987004.6631 2102364.6195 37.751942436508706 -122.487834969288 (37.7519424365087, -122.487834969288)
188215 183121 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 2327 41st Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   5983581.7952 2099373.3538 37.7435289932417 -122.49945051311 (37.7435289932417, -122.49945051311)

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