Street_Tree_List

Data source: data.sfgov.org

18 rows where qSiteInfo = 2 and qSpecies = 190

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qAddress, SiteOrder, DBH, PlotSize

qSiteInfo ✖

  • Sidewalk: Curb side : Yard · 18 ✖
Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
24799 24799 120350 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 2122 Lake St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 6ft   5988813.63616 2114710.28976 37.7859456052821 -122.482483881641 (37.7859456052821, -122.482483881641)
26210 26210 118831 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 662 46th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   5981671.941000001 2111218.67307 37.775940615740105 -122.50693266579799 (37.7759406157401, -122.506932665798)
29901 29901 191709 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 3535 Jennings St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9     6013020.366769999 2089365.2626599998 37.717732082047895 -122.39695697201 (37.7177320820479, -122.39695697201)
32095 32095 224121 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 211 Ogden Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 4ft   6008290.10508 2096093.22608 37.7359411906366 -122.413783055452 (37.7359411906366, -122.413783055452)
37671 37671 176274 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 775 London St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6     6000713.865119999 2089358.3764799999 37.7170204575094 -122.439494437135 (37.7170204575094, -122.439494437135)
46503 46503 176289 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 140 South Hill Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 6ft   6003155.69301 2086832.03957 37.710222356236 -122.430874024341 (37.710222356236, -122.430874024341)
57318 57318 218344 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 385 Castenada Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 0ft   5993369.339269999 2100022.3312 37.745880311731 -122.46565503467501 (37.745880311731, -122.465655034675)
64704 64704 191708 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 979 Le Conte Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     18     6013251.209530001 2089459.918 37.7180048338374 -122.396165676526 (37.7180048338374, -122.396165676526)
73220 73220 246771 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1850 Alabama St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     18     6009333.37029 2098874.50038 37.743636497837 -122.410372378408 (37.743636497837, -122.410372378408)
151773 151773 224122 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 211 Ogden Ave 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 4ft   6008272.03754 2096094.4851799998 37.73594363319479 -122.41384561137899 (37.7359436331948, -122.413845611379)
153224 153224 176279 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 671 London St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7     6001065.40936 2089903.8077599998 37.7185380904529 -122.43831837391001 (37.7185380904529, -122.43831837391)
154589 154589 201358 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 245 Kalmanovitz St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 2ft   6013008.61874 2092664.0279400002 37.726789172374794 -122.39722877051001 (37.7267891723748, -122.39722877051)
157517 157517 224132 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 310 Liberty St 26 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 3ft   6004003.018680001 2103934.91108 37.7572309538551 -122.42916418288401 (37.7572309538551, -122.429164182884)
161284 161284 207731 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 32 Malta Dr 19 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 3ft   5999573.254930001 2096045.34694 37.735316349769704 -122.443917140176 (37.7353163497697, -122.443917140176)
172703 172703 176284 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 251 De Long St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 10ft   5993742.60383 2086796.45358 37.7095868089467 -122.46340473574101 (37.7095868089467, -122.463404735741)
177760 177760 184363 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 2251 47th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 0ft   5981706.71 2099767.9271 37.7445021893581 -122.50596322728998 (37.7445021893581, -122.50596322729)
185039 185039 224123 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 523 Powhattan Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7     6008526.38321 2098121.4064599997 37.7415233967761 -122.413109512687 (37.7415233967761, -122.413109512687)
186212 186212 200198 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 3125 Jennings St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 0ft   6013701.6232 2090281.2208 37.720285019418505 -122.394666263771 (37.7202850194185, -122.394666263771)

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