Street_Tree_List

Data source: data.sfgov.org

24 rows where qSiteInfo = 9 and qSpecies = 46

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, qAddress, PlotSize

qSiteInfo ✖

  • Sidewalk: Property side : Yard · 24 ✖
Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
25133 25133 198661 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1670 Owen St 17 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 8ft   6013934.2668 2107404.04412 37.7673136301584 -122.39506079103 (37.7673136301584, -122.39506079103)
28071 28071 198653 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1670 Owen St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 8ft   6014062.16151 2107274.8882299997 37.7669661078202 -122.39460937273701 (37.7669661078202, -122.394609372737)
33042 33042 242763 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 230 States St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12 Width 3ft   6000829.7469 2106510.44882 37.764122601704 -122.440323264923 (37.764122601704, -122.440323264923)
41617 41617 198662 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1670 Owen St 19 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 8ft   6013921.99886 2107418.77263 37.767353389178204 -122.395104256175 (37.7673533891782, -122.395104256175)
46850 46850 123166 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 579 10th Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6     5992807.48236 2111535.8684400003 37.777461036027496 -122.468435352622 (37.7774610360275, -122.468435352622)
50915 50915 242704 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 4137 19th St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     24 Width 3ft   6002148.00481 2104679.56565 37.7591704102124 -122.435632805824 (37.7591704102124, -122.435632805824)
61149 61149 96876 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 2100X San Jose Ave 8 Sidewalk: Property side : Yard 9 Tree 1 Private 1           5999221.1 2091561.9 37.7229857575378 -122.444812491923 (37.7229857575378, -122.444812491923)
62289 62289 137024 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 2201 Broadway 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 4ft   6003051.10397 2117478.36483 37.794363984556796 -122.433424069968 (37.7943639845568, -122.433424069968)
131563 131563 198656 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1670 Owen St 8 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 8ft   6014014.86759 2107324.11249 37.7670986373305 -122.394776403817 (37.7670986373305, -122.394776403817)
132426 132426 198664 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1670 Owen St 23 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 8ft   6013893.51882 2107448.48806 37.7674333973606 -122.39520484712 (37.7674333973606, -122.39520484712)
133946 133946 198657 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1670 Owen St 10 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 8ft   6013998.084530001 2107337.5024 37.7671344699085 -122.39483539216499 (37.7671344699085, -122.394835392165)
137877 137877 180559 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 192 Dublin St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 5ft   6004156.4754099995 2089333.3612 37.717147098249605 -122.427593206665 (37.7171470982496, -122.427593206665)
157554 157554 198658 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1670 Owen St 11 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 8ft   6013985.93072 2107349.0106 37.767165393099205 -122.39487823676001 (37.7671653930992, -122.39487823676)
158133 158133 137054 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 218 Union St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 2ft   6011688.33574 2119796.9213799997 37.801216417450206 -122.403701277593 (37.8012164174502, -122.403701277593)
161482 161482 198659 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1670 Owen St 13 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 8ft   6013968.57822 2107369.74118 37.7672213498189 -122.39493970902001 (37.7672213498189, -122.39493970902)
167424 167424 198655 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1670 Owen St 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 8ft   6014030.31136 2107306.6382299997 37.7670515155374 -122.3947217619 (37.7670515155374, -122.3947217619)
169845 169845 198665 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1670 Owen St 25 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 8ft   6013878.81115 2107466.84131 37.767482973376396 -122.395257005115 (37.7674829733764, -122.395257005115)
169909 169909 198663 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1670 Owen St 21 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 8ft   6013906.856240001 2107433.3805400003 37.7673926571763 -122.395157656112 (37.7673926571763, -122.395157656112)
176026 176026 198512 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 681 Arkansas St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12 Width 4ft   6013048.29942 2103920.61394 37.7576995923826 -122.397880868001 (37.7576995923826, -122.397880868001)
177831 177831 198507 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 701 Rhode Island St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 6ft   6011858.82974 2105091.4042599997 37.7608480082603 -122.40207687446501 (37.7608480082603, -122.402076874465)
178916 178916 198666 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1670 Owen St 27 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 8ft   6013864.8595 2107478.20715 37.7675134055349 -122.39530605864901 (37.7675134055349, -122.395306058649)
182574 182574 198654 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1670 Owen St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 8ft   6014045.1024400005 2107292.39517 37.7670132295924 -122.39466960392201 (37.7670132295924, -122.394669603922)
186182 186182 180540 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 2134 San Jose Ave 9 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13 Width 8ft   5998917.8755 2091146.4939599999 37.7218278392563 -122.445830812055 (37.7218278392563, -122.445830812055)
186900 186900 198660 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1670 Owen St 15 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 8ft   6013952.391369999 2107385.9793599998 37.767265036187204 -122.39499683484101 (37.7672650361872, -122.394996834841)

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