Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
273 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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) |
JSON shape: default, array, newline-delimited
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");