Street_Tree_List

Data source: data.sfgov.org

21 rows where DBH = 1, SiteOrder = 2 and qSpecies = 48

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, qSiteInfo, PlotSize

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
28890 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)
35363 35363 98849 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1795X 31st Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/11/2012 12:00:00 AM 1 3x3 Permit Number 768753 5986486.2 2103095.0 37.7539176067687 -122.489681571094 (37.7539176067687, -122.489681571094)
43893 43893 117895 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 635 38th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5984097.32613 2111483.29523 37.7768097259285 -122.498562310404 (37.7768097259285, -122.498562310404)
44865 44865 46434 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 2St. Ankeny St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/30/2003 12:00:00 AM 1   Permit Number 47151 6011096.25435 2089701.2859 37.7185474406786 -122.40363143174 (37.7185474406786, -122.40363143174)
48201 48201 119241 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 50 Sutro Heights Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 8ft   5981435.03386 2111334.77238 37.776245435782 -122.50776079209999 (37.776245435782, -122.5077607921)
56930 56930 207038 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 270 Magellan Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 4ft   5994641.46146 2100307.8933900003 37.7467376875983 -122.461276941602 (37.7467376875983, -122.461276941602)
64913 64913 201811 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 101 Friedell St 2 : 4 Tree 1 Private 1     1 Width 6ft   6021050.71889 2093203.62599 37.7287152512926 -122.369464359799 (37.7287152512926, -122.369464359799)
66467 66467 176899 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 167 Madison St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 4ft   6005613.54422 2092807.28897 37.7267680598911 -122.422803552358 (37.7267680598911, -122.422803552358)
66926 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)
70354 70354 207004 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 171 Wawona St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5992803.19794 2098037.0989599996 37.7403966964551 -122.46746831791 (37.7403966964551, -122.46746831791)
122015 122015 88207 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 187 Beaumont Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/08/2008 12:00:00 AM 1 3x3 Permit Number 51211 5996848.1239 2111670.4224 37.7780630497691 -122.454467238117 (37.7780630497691, -122.454467238117)
133488 133488 118589 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 150 Point Lobos Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5982275.325019999 2112634.79146 37.779864376411 -122.50495040283998 (37.779864376411, -122.50495040284)
138540 138540 176888 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 13 Santa Rosa Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6002306.40089 2092528.2983099998 37.7258148612434 -122.43421630345301 (37.7258148612434, -122.434216303453)
145461 145461 111714 Planning Code 138.1 required 4 Lagunaria patersonii :: Primrose Tree 48 3038 CLEMENT ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/02/2015 12:00:00 AM 1 3x3 Permit Number 777015 5986051.0 2113265.0 37.7818161572934 -122.491935266217 (37.7818161572934, -122.491935266217)
153240 153240 95898 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1700 23rd Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/27/2011 12:00:00 AM 1 3x3 Permit Number 767603 5989073.1619 2103670.6386 37.755648856222 -122.48077749293999 (37.755648856222, -122.48077749294)
157031 157031 206985 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1498 17th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5990877.17813 2105275.0931700002 37.760158953986604 -122.474655794123 (37.7601589539866, -122.474655794123)
161979 161979 117687 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 50 Point Lobos Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 8ft   5982599.26265 2112595.13886 37.7797745547632 -122.50382684040501 (37.7797745547632, -122.503826840405)
172906 172906 207014 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 651 Joost Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 1ft   5997782.54111 2094977.3620200001 37.732281609092496 -122.45003132048201 (37.7322816090925, -122.450031320482)
172938 172938 176884 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 96 Alpha St 2 Front Yard : Yard 7 Tree 1 Private 1     1     6011062.55449 2088258.87965 37.7145850034576 -122.40364648639601 (37.7145850034576, -122.403646486396)
176471 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)
180870 180870 227099 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 75 Montcalm St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6010635.77556 2100089.10311 37.7470444571367 -122.40595450111401 (37.7470444571367, -122.405954501114)

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