Street_Tree_List

Data source: data.sfgov.org

9 rows where SiteOrder = 1, qSiteInfo = 9 and qSpecies = 99

View and edit SQL

Suggested facets: DBH, PlotSize

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
34445 189999 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 700 Carolina St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12 Width 3ft   6012378.8382 2104615.7006200003 37.759570841431604 -122.400244972539 (37.7595708414316, -122.400244972539)
45931 190000 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 770 De Haro St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 3ft   6012104.84568 2104756.14819 37.7599411975544 -122.401202450128 (37.7599411975544, -122.401202450128)
57727 117702 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 4021 Clement St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 7ft   5983001.87469 2113075.50324 37.781117159673705 -122.50246961447901 (37.7811171596737, -122.502469614479)
66694 225148 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 1199 Capp St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 9ft   6007231.69522 2100624.49408 37.7483235475968 -122.417763493512 (37.7483235475968, -122.417763493512)
150193 206044 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 275 Byxbee St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 6ft   5991926.36894 2090353.75557 37.7192494901497 -122.46994073500099 (37.7192494901497, -122.469940735001)
159626 206047 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 575 Rockdale Dr 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 3ft   5997894.62452 2097851.39191 37.7401794193521 -122.449850874237 (37.7401794193521, -122.449850874237)
160931 126014 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 2322 North Point St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     20 Width 8ft   5999611.42315 2120546.01877 37.8025911966964 -122.445546423945 (37.8025911966964, -122.445546423945)
166960 126011 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 2600 Lyon St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13 Width 7ft   5999243.15513 2117721.3039700002 37.7948142553315 -122.446617458939 (37.7948142553315, -122.446617458939)
171539 190001 Undocumented 2 Chamaerops humilis :: Mediterranean Fan Palm 99 790 De Haro St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9     6012095.84153 2104748.83564 37.759920616576 -122.401233077439 (37.759920616576, -122.401233077439)

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