Street_Tree_List

Data source: data.sfgov.org

16 rows where PlotSize = "Width 3ft", qSiteInfo = 9 and qSpecies = 100

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qAddress, SiteOrder, DBH

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
25705 25705 234339 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 420 Dolores St 20 Sidewalk: Property side : Yard 9 Tree 1 Private 1     38 Width 3ft   6004868.93824 2105500.74139 37.7615793351331 -122.426280973507 (37.7615793351331, -122.426280973507)
29021 29021 234332 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 420 Dolores St 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     15 Width 3ft   6004849.34041 2105800.52772 37.7624013694379 -122.42637009990601 (37.7624013694379, -122.426370099906)
39365 39365 234337 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 420 Dolores St 17 Sidewalk: Property side : Yard 9 Tree 1 Private 1     31 Width 3ft   6004866.4127400005 2105541.3308900003 37.7616906415182 -122.42629259813299 (37.7616906415182, -122.426292598133)
44771 44771 234338 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 420 Dolores St 19 Sidewalk: Property side : Yard 9 Tree 1 Private 1     37 Width 3ft   6004867.72819 2105514.5268599996 37.761617118366104 -122.42628614009199 (37.7616171183661, -122.426286140092)
63620 63620 234384 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 899 Hampshire St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 3ft   6010216.7904900005 2104076.88773 37.757970587791 -122.407684453188 (37.757970587791, -122.407684453188)
72122 72122 234341 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 420 Dolores St 22 Sidewalk: Property side : Yard 9 Tree 1 Private 1     35 Width 3ft   6004869.93402 2105476.5468200003 37.7615129588681 -122.42627580688401 (37.7615129588681, -122.426275806884)
131685 131685 210910 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 151 Garcia Ave 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 3ft   5994660.64772 2099277.20114 37.743908769387005 -122.461135900907 (37.743908769387, -122.461135900907)
131778 131778 234335 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 420 Dolores St 13 Sidewalk: Property side : Yard 9 Tree 1 Private 1     28 Width 3ft   6004864.336759999 2105585.63058 37.7618121606106 -122.42630293224899 (37.7618121606106, -122.426302932249)
135856 135856 234333 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 420 Dolores St 10 Sidewalk: Property side : Yard 9 Tree 1 Private 1     30 Width 3ft   6004857.87037 2105688.78101 37.762095021687706 -122.42633264136002 (37.7620950216877, -122.42633264136)
136108 136108 234331 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 420 Dolores St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     25 Width 3ft   6004849.00155 2105814.83535 37.762440635635 -122.426372290646 (37.762440635635, -122.426372290646)
157052 157052 210909 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 151 Garcia Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 3ft   5994659.02084 2099296.69557 37.7439622025921 -122.46114293900601 (37.7439622025921, -122.461142939006)
160623 160623 234336 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 420 Dolores St 14 Sidewalk: Property side : Yard 9 Tree 1 Private 1     18 Width 3ft   6004864.2449199995 2105581.16954 37.7617999064621 -122.42630293226101 (37.7617999064621, -122.426302932261)
163745 163745 234334 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 420 Dolores St 12 Sidewalk: Property side : Yard 9 Tree 1 Private 1     33 Width 3ft   6004862.85296 2105604.25637 37.7618632187373 -122.426309390288 (37.7618632187373, -122.426309390288)
171635 171635 234401 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 3899 19th St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     31 Width 3ft   6003740.055819999 2104771.47672 37.75951307439 -122.430133288745 (37.75951307439, -122.430133288745)
174148 174148 234400 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 4 Corwin St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     43 Width 3ft   6001132.8816599995 2103964.26051 37.7571486461001 -122.439092314277 (37.7571486461001, -122.439092314277)
181869 181869 234340 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 420 Dolores St 21 Sidewalk: Property side : Yard 9 Tree 1 Private 1     39 Width 3ft   6004869.08955 2105489.95301 37.7615497213531 -122.42627968206499 (37.7615497213531, -122.426279682065)

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