Street_Tree_List

Data source: data.sfgov.org

18 rows where DBH = 6 and qSpecies = 4

View and edit SQL

Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, qCaretaker, PlotSize

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
4 207368 Undocumented 2 Ligustrum japonicum :: Japanese Privet 4 920 Kirkham St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 1ft   5992009.48044 2105269.9271 37.760210314285004 -122.47073935813 (37.760210314285, -122.47073935813)
17499 9990 DPW Maintained 3 Ligustrum japonicum :: Japanese Privet 4 33 Guerrero St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 3X3   6005438.43144 2108674.6093 37.7703261944175 -122.424537099004 (37.7703261944175, -122.424537099004)
31087 119029 Undocumented 2 Ligustrum japonicum :: Japanese Privet 4 767 44th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 1ft   5982273.77271 2110527.62617 37.7740786267097 -122.504799591882 (37.7740786267097, -122.504799591882)
37549 129499 Undocumented 2 Ligustrum japonicum :: Japanese Privet 4 2144 Green St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6002813.515269999 2118209.0658299997 37.7963568183789 -122.43429841873501 (37.7963568183789, -122.434298418735)
39984 129551 Undocumented 2 Ligustrum japonicum :: Japanese Privet 4 44 Montgomery St 4 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     6 Width 4ft   6012074.07881 2115564.48535 37.789616701801 -122.40206871312 (37.789616701801, -122.40206871312)
42723 129514 Undocumented 2 Ligustrum japonicum :: Japanese Privet 4 2730 Lyon St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   5999183.84789 2118189.54872 37.796096542872206 -122.446856379121 (37.7960965428722, -122.446856379121)
45735 226654 Undocumented 2 Ligustrum japonicum :: Japanese Privet 4 220 Corbett Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   5999922.0088 2105601.51229 37.761575162283705 -122.443397564951 (37.7615751622837, -122.443397564951)
47627 191426 Undocumented 2 Ligustrum japonicum :: Japanese Privet 4 1700 22nd St 5 Front Yard : Yard 7 Tree 1 Private 1     6     6012934.525830001 2103813.36642 37.7573987772601 -122.39826682196001 (37.7573987772601, -122.39826682196)
52675 191422 Undocumented 2 Ligustrum japonicum :: Japanese Privet 4 518 Rhode Island St 1 : 4 Tree 1 Private 1     6 Width 1ft   6011739.544919999 2105950.9895099998 37.763201579013796 -122.402549877375 (37.7632015790138, -122.402549877375)
63854 129545 Undocumented 2 Ligustrum japonicum :: Japanese Privet 4 10 Miller Pl 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   6010092.54789 2116944.91924 37.7932962437837 -122.409022077819 (37.7932962437837, -122.409022077819)
68161 40706 Permitted Site 1 Ligustrum japonicum :: Japanese Privet 4 758 Sweeny St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/10/1999 12:00:00 AM 6   Permit Number 41685 6006892.85232 2094109.9471200001 37.7304169754587 -122.41847333918999 (37.7304169754587, -122.41847333919)
131107 129515 Undocumented 2 Ligustrum japonicum :: Japanese Privet 4 2730 Lyon St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   5999181.629430001 2118207.9413900003 37.7961469175038 -122.44686537955 (37.7961469175038, -122.44686537955)
147166 66159 Permitted Site 1 Ligustrum japonicum :: Japanese Privet 4 90 Bay View St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/04/1990 12:00:00 AM 6   Permit Number 29230 6013889.68751 2094856.83218 37.732859178908 -122.394336381736 (37.732859178908, -122.394336381736)
156654 177030 Undocumented 2 Ligustrum japonicum :: Japanese Privet 4 235 Ottawa Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 4ft   5998356.41955 2089266.50528 37.7166337499183 -122.447636347658 (37.7166337499183, -122.447636347658)
158427 129506 Undocumented 2 Ligustrum japonicum :: Japanese Privet 4 2644 Filbert St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6000302.575 2118552.44748 37.7971568138825 -122.443011447325 (37.7971568138825, -122.443011447325)
165011 120188 Undocumented 2 Ligustrum japonicum :: Japanese Privet 4 224 26th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5987762.7194300005 2114453.05727 37.785178126956396 -122.486100829584 (37.7851781269564, -122.486100829584)
168068 177032 Undocumented 2 Ligustrum japonicum :: Japanese Privet 4 663 University St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 5ft   6008682.45825 2090982.7781200001 37.7219310184866 -122.41206547985901 (37.7219310184866, -122.412065479859)
179072 53853 Permitted Site 1 Ligustrum japonicum :: Japanese Privet 4 586 Bush St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/01/1972 12:00:00 AM 6   Permit Number 9561 6010726.48535 2115910.4479900002 37.790491325756896 -122.40675566215599 (37.7904913257569, -122.406755662156)

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