Street_Tree_List

Data source: data.sfgov.org

33 rows where PlotSize = "4X4", qLegalStatus = 3 and qSpecies = 59

View and edit SQL

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
273 20166 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 1155X Steiner St 7 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     20 4X4   6002621.0 2112212.0 37.7798794773869 -122.43453554599199 (37.7798794773869, -122.434535545992)
325 21670 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 1776 Sutter St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     22 4X4   6004121.8146 2114641.2436 37.786634655728605 -122.429516856277 (37.7866346557286, -122.429516856277)
342 21738 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 2045 Sutter St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 4X4   6002837.9936 2114410.7158 37.7859289122324 -122.43394207733601 (37.7859289122324, -122.433942077336)
894 15433 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 2135 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 4X4   6006876.1683 2105910.6162 37.7628180091578 -122.419367848279 (37.7628180091578, -122.419367848279)
1072 7266 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 1740 Fillmore St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     16 4X4   6003064.3461 2114369.1192 37.7858275412041 -122.433155987425 (37.7858275412041, -122.433155987425)
1120 7264 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 1730 Fillmore St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 4X4   6003073.6496 2114318.6841 37.78568958693 -122.43312019509199 (37.78568958693, -122.433120195092)
1363 21606 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 1525 Sutter St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 4X4   6005078.2447 2114724.3621 37.7869169843519 -122.426213757225 (37.7869169843519, -122.426213757225)
1504 21609 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 1531 Sutter St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/09/1990 12:00:00 AM 12 4X4   6005037.9058 2114711.086 37.7868782513618 -122.42635237507 (37.7868782513618, -122.42635237507)
1644 14813 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 1195 McAllister St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 4X4   6003481.2511 2111720.7527 37.778579430545896 -122.431524477475 (37.7785794305459, -122.431524477475)
1971 21669 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 1776 Sutter St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     22 4X4   6004141.1865 2114642.4934 37.7866391841692 -122.42944992335698 (37.7866391841692, -122.429449923357)
3990 21628 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 1615 Sutter St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   06/29/1994 12:00:00 AM 6 4X4   6004654.6857 2114664.3643 37.786728295749896 -122.427674898563 (37.7867282957499, -122.427674898563)
5252 17675 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 1010 Pierce St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 4X4   6002421.1673 2112056.7065 37.779441734619205 -122.435215744209 (37.7794417346192, -122.435215744209)
5781 7252 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 1701 Fillmore St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 4X4   6003031.0875 2114271.6252 37.78555796067371 -122.433264083866 (37.7855579606737, -122.433264083866)
5884 17676 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 1004 Pierce St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 4X4   6002427.6935 2112026.5749 37.779359371412795 -122.43519101157301 (37.7793593714128, -122.435191011573)
5974 21668 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 1776 Sutter St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     23 4X4   6004178.0557 2114647.4926 37.7866549980826 -122.42932272146601 (37.7866549980826, -122.429322721466)
6144 7206 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 940 Fillmore St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 4X4   6003460.3469 2111580.5338 37.778193239457295 -122.431586779834 (37.7781932394573, -122.431586779834)
6161 7251 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 1701 Fillmore St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 4X4   6003028.1584 2114287.7355 37.785602029314205 -122.43327536926 (37.7856020293142, -122.43327536926)
6666 7250 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 1701 Fillmore St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   05/21/1990 12:00:00 AM 12 4X4   6003025.9615 2114308.2396 37.7856582037536 -122.43328443554199 (37.7856582037536, -122.433284435542)
6743 7207 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 940 Fillmore St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 4X4   6003456.4877 2111615.9101 37.778290155247205 -122.431602656487 (37.7782901552472, -122.431602656487)
6753 14817 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 1234 McAllister St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 4X4   6003267.0451 2111739.9368 37.7786199621548 -122.43226686795799 (37.7786199621548, -122.432266867958)
7090 21632 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 1615 Sutter St 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/04/1991 12:00:00 AM 12 4X4   6004741.4911 2114677.6404 37.7867696583856 -122.42737551849501 (37.7867696583856, -122.427375518495)
7225 21740 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 2045 Sutter St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 4X4   6002881.8287 2114415.6319 37.7859448981022 -122.433790771597 (37.7859448981022, -122.433790771597)
7298 7263 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 1730 Fillmore St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 4X4   6003079.0359 2114300.077 37.785638802077706 -122.433100230123 (37.7856388020777, -122.433100230123)
7483 7265 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 1740 Fillmore St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 4X4   6003066.7944 2114355.8984 37.78579137911579 -122.433146572029 (37.7857913791158, -122.433146572029)
8428 21739 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 2045 Sutter St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 4X4   6002859.7063 2114412.7642 37.785935768772 -122.433867103908 (37.785935768772, -122.433867103908)
8655 21608 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 1531 Sutter St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   04/09/1990 12:00:00 AM 12 4X4   6005005.2261 2114710.5754 37.786875002060704 -122.42646540299 (37.7868750020607, -122.42646540299)
8679 21671 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 1776 Sutter St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 4X4   6004100.5679 2114639.3689 37.7866283052779 -122.429590230958 (37.7866283052779, -122.429590230958)
8928 7213 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 950 Fillmore St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 4X4   6003452.6284 2111644.2112 37.7783676442869 -122.43161802827 (37.7783676442869, -122.43161802827)
17307 15307 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 1650 Mission St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   06/29/2007 12:00:00 AM 3 4X4   6006881.466 2109048.7514 37.771434887034104 -122.419572183108 (37.7714348870341, -122.419572183108)
17778 15435 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 2141 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 4X4   6006881.4762 2105834.0306 37.7626080219354 -122.419344056803 (37.7626080219354, -122.419344056803)
19775 16873 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 262 Oak St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 4X4   6005733.6702 2110353.6763 37.7749531766501 -122.423635265131 (37.7749531766501, -122.423635265131)
22715 9008 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 5255 Geary Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 4X4   5990650.4547 2112633.3493 37.7803495870008 -122.475977319009 (37.7803495870008, -122.475977319009)
23012 21724 DPW Maintained 3 Ficus retusa nitida :: Banyan Fig 59 1942X Sutter St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   01/27/2003 12:00:00 AM 17 4X4   6003291.3026 2114524.3217 37.786266559771 -122.432381870835 (37.786266559771, -122.432381870835)

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