Street_Tree_List

Data source: data.sfgov.org

19 rows where PlotSize = "Width 4ft", qSiteInfo = 2 and qSpecies = 27

✎ 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
25493 25493 207183 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 451 Ulloa St 12 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 4ft   5995337.35676 2098242.98475 37.7411079873364 -122.458721155571 (37.7411079873364, -122.458721155571)
42221 42221 207173 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 451 Ulloa St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 4ft   5995323.713819999 2098239.63146 37.7410979958728 -122.45876808490601 (37.7410979958728, -122.458768084906)
47869 47869 129491 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 2536 Baker St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 4ft   5999689.18555 2117591.31365 37.794482803901296 -122.445064787505 (37.7944828039013, -122.445064787505)
48704 48704 207278 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 575 Dewey Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 4ft   5994134.4568 2099399.45739 37.7442141593615 -122.462964201952 (37.7442141593615, -122.462964201952)
57155 57155 207179 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 451 Ulloa St 8 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 4ft   5995334.19857 2098241.75122 37.741104418845794 -122.458731986098 (37.7411044188458, -122.458731986098)
66041 66041 129492 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 2536 Baker St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 4ft   5999690.83284 2117600.09007 37.794506995647 -122.445059718941 (37.794506995647, -122.445059718941)
73076 73076 207146 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 1440 16th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 4ft   5991174.2447 2105585.9909099997 37.7610298052998 -122.47365107156601 (37.7610298052998, -122.473651071566)
76247 76247 207177 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 451 Ulloa St 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 4ft   5995331.55155 2098239.9871900002 37.7410994231129 -122.458741010797 (37.7410994231129, -122.458741010797)
130565 130565 207178 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 451 Ulloa St 7 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 4ft   5995329.77436 2098242.36362 37.7411058460538 -122.45874732764 (37.7411058460538, -122.45874732764)
146496 146496 207181 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 451 Ulloa St 10 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 4ft   5995335.301969999 2098244.58715 37.7411122690279 -122.458728376224 (37.7411122690279, -122.458728376224)
151636 151636 207176 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 451 Ulloa St 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 4ft   5995327.39898 2098241.1137 37.741102277551896 -122.45875545032301 (37.7411022775519, -122.458755450323)
152617 152617 207174 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 451 Ulloa St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 4ft   5995326.26295 2098236.71907 37.741090145688894 -122.458759060198 (37.7410901456889, -122.458759060198)
159001 159001 117979 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 430 38th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 4ft   5984095.97176 2112889.786 37.7806714622872 -122.498670920289 (37.7806714622872, -122.498670920289)
160296 160296 207175 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 451 Ulloa St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 4ft   5995328.909969999 2098238.4831 37.7410951414231 -122.458750035501 (37.7410951414231, -122.458750035501)
164704 164704 207182 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 451 Ulloa St 11 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 4ft   5995335.09015 2098246.93081 37.7411186919637 -122.458729278246 (37.7411186919637, -122.458729278246)
173676 173676 207279 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 186 Merced Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 4ft   5994221.53046 2099188.36085 37.743639556416504 -122.462647812372 (37.7436395564165, -122.462647812372)
174436 174436 207180 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 451 Ulloa St 9 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 4ft   5995332.94317 2098244.11673 37.7411108417945 -122.458736498001 (37.7411108417945, -122.458736498001)
175637 175637 129490 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 2536 Baker St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 4ft   5999691.42103 2117587.23687 37.794471737733105 -122.44505675927401 (37.7944717377331, -122.445056759274)
181601 181601 207172 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 451 Ulloa St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 4ft   5995322.34396 2098236.54105 37.741089431634705 -122.458772597671 (37.7410894316347, -122.458772597671)

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