Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qCaretaker, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes ▼ | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 220 | 220 | 138363 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2060 SUTTER ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | Width 0ft | 6002798.656 | 2114455.2605 | 37.7860489882217 | -122.434081359893 | (37.7860489882217, -122.434081359893) | |||
| 1154 | 1154 | 246084 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1390 Waller St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5999058.5497 | 2108380.2585 | 37.7691556230859 | -122.446583834228 | (37.7691556230859, -122.446583834228) | |||
| 1462 | 1462 | 247381 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1001 Oak St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | Width 0ft | 6002208.0 | 2109818.0 | 37.7732826991746 | -122.43579295981199 | (37.7732826991746, -122.435792959812) | |||
| 3342 | 3342 | 140426 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1499 TURK ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 12 | Width 0ft | 6003027.0905 | 2112359.5298 | 37.7803076012967 | -122.43314124413601 | (37.7803076012967, -122.433141244136) | |||
| 4221 | 4221 | 244055 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 401 Cole St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5997910.1594 | 2109123.3007 | 37.771130163517704 | -122.450609610411 | (37.7711301635177, -122.450609610411) | |||
| 4236 | 4236 | 246150 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1504 Waller St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 5998421.7001 | 2108292.1353 | 37.7688772616464 | -122.448780303512 | (37.7688772616464, -122.448780303512) | |||
| 6997 | 6997 | 106207 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1600X Fillmore St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 5x5 | 6003107.6347 | 2114075.5662 | 37.785023974383705 | -122.43298524084 | (37.7850239743837, -122.43298524084) | |||
| 7583 | 7583 | 6242 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1250 Ellis St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/02/1991 12:00:00 AM | 12 | 3X3 | 6004855.4094 | 2113352.7921 | 37.783138396913294 | -122.426886998286 | (37.7831383969133, -122.426886998286) | ||
| 7706 | 7706 | 21589 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1500 Sutter St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X2 | 6005274.899 | 2114802.7621 | 37.7871433646236 | -122.425538959573 | (37.7871433646236, -122.425538959573) | |||
| 8148 | 8148 | 99230 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1111 Columbus Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2x2 | 6008035.3898 | 2121073.3853 | 37.8045165290969 | -122.416432570152 | (37.8045165290969, -122.416432570152) | |||
| 8289 | 8289 | 4662 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 600X Columbus Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 80 | 5X5 | 6009727.0981 | 2119617.2678 | 37.8006133797513 | -122.41047535239099 | (37.8006133797513, -122.410475352391) | |||
| 13519 | 13519 | 113149 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1035X Folsom St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3x3 | 6010826.0688 | 2111360.9298 | 37.7780049945656 | -122.406090456701 | (37.7780049945656, -122.406090456701) | |||
| 19201 | 19201 | 15302 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1640 Mission St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6006948.3596 | 2109215.1279 | 37.7718954850631 | -122.419352599105 | (37.7718954850631, -122.419352599105) | |||
| 21132 | 21132 | 15628 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 3550 Mission St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005530.9833 | 2097730.2012 | 37.74028062358521 | -122.423438788897 | (37.7402806235852, -122.423438788897) | |||
| 21742 | 21742 | 20094 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2075X Oak St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 5997081.4143 | 2109098.2817 | 37.7710139970036 | -122.453474447283 | (37.7710139970036, -122.453474447283) | |||
| 24837 | 24837 | 217620 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1830 Ocean Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5994327.7005 | 2092483.4396 | 37.7252356086447 | -122.461794638623 | (37.7252356086447, -122.461794638623) | |||
| 26124 | 26124 | 143189 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 184 FRANCISCO ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6010358.1536 | 2121339.5444 | 37.8053776832044 | -122.408413183131 | (37.8053776832044, -122.408413183131) | |||
| 29940 | 29940 | 138506 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1701 FILLMORE ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6003039.875 | 2114221.8295 | 37.7854217327846 | -122.43323012236999 | (37.7854217327846, -122.43323012237) | |||
| 38098 | 38098 | 98472 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1500 16th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6011885.4815 | 2107033.4874 | 37.766182021887005 | -122.402121236301 | (37.766182021887, -122.402121236301) | |||
| 39267 | 39267 | 141082 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 188 Commonwealth Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5996586.3547 | 2113042.2151 | 37.7818146143415 | -122.455471958556 | (37.7818146143415, -122.455471958556) | |||
| 41039 | 41039 | 110469 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 465 Grove St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 15 | 3x3 | 6005632.4002 | 2111334.52 | 37.777640618295706 | -122.42405534708901 | (37.7776406182957, -122.424055347089) | ||
| 44704 | 44704 | 110911 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 633 Folsom St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 6013393.5354 | 2113814.1809 | 37.784884328260105 | -122.397380700853 | (37.7848843282601, -122.397380700853) | ||||
| 47384 | 47384 | 143351 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1651 UNION ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6005123.5505 | 2118829.1947 | 37.7981903797597 | -122.426349379498 | (37.7981903797597, -122.426349379498) | |||
| 64849 | 64849 | 111733 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 313 Ivy St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 2.5x3 | 6005854.5902 | 2111208.289 | 37.777306560799 | -122.42327774010201 | (37.777306560799, -122.423277740102) | |||
| 64926 | 64926 | 142962 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 192 Pfeiffer St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6009928.7622 | 2121093.4626 | 37.804677948564404 | -122.409881772835 | (37.8046779485644, -122.409881772835) | |||
| 68249 | 68249 | 138745 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2965 Bush St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5999354.2167 | 2114269.6942 | 37.7853433864461 | -122.445984796208 | (37.7853433864461, -122.445984796208) | |||
| 68404 | 68404 | 139448 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 508 OCTAVIA ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6005463.3958 | 2111104.0081 | 37.7769981455225 | -122.42462358954799 | (37.7769981455225, -122.424623589548) | |||
| 110431 | 110431 | 113408 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1450 SANCHEZ ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003890.0 | 2099760.0 | 37.74576122776671 | -122.429257354108 | (37.7457612277667, -122.429257354108) | ||||
| 135249 | 135249 | 138125 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1850 FILLMORE ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | Width 0ft | 6003026.6898 | 2114633.7688 | 37.7865520657788 | -122.433305185236 | (37.7865520657788, -122.433305185236) | |||
| 136666 | 136666 | 141686 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2350 TURK BLVD | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5998577.2371 | 2111809.6049 | 37.7785442242281 | -122.448495667047 | (37.7785442242281, -122.448495667047) | |||
| 146565 | 146565 | 140708 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 500 PIERCE ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 6002652.7615 | 2110375.0497 | 37.7748374734767 | -122.434294303619 | (37.7748374734767, -122.434294303619) | |||
| 147016 | 147016 | 142635 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 241 BAY ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6009773.7882 | 2121554.2814 | 37.805934555696204 | -122.410450636982 | (37.8059345556962, -122.410450636982) | |||
| 148525 | 148525 | 199856 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2509 Keith St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6014162.2831 | 2092076.0569 | 37.725238881999395 | -122.393199428445 | (37.7252388819994, -122.393199428445) | |||
| 150035 | 150035 | 140421 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1120 STEINER ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6002869.1903 | 2112320.0547 | 37.780190254306795 | -122.43368467143 | (37.7801902543068, -122.43368467143) | |||
| 150798 | 150798 | 140692 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1120 FILLMORE ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6003358.0022 | 2112322.1697 | 37.780223785424496 | -122.43199379942301 | (37.7802237854245, -122.431993799423) | |||
| 152282 | 152282 | 142492 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 651 COLUMBUS AVE | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6009649.7576 | 2119605.0318 | 37.8005754466702 | -122.41074211863399 | (37.8005754466702, -122.410742118634) | |||
| 153799 | 153799 | 141611 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1511 Fulton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6000524.2023 | 2110966.5279 | 37.7763404768103 | -122.44169987057501 | (37.7763404768103, -122.441699870575) | |||
| 155316 | 155316 | 143253 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 661 LOMBARD ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 0ft | 6009276.7812 | 2120451.499 | 37.8028787161223 | -122.412092628976 | (37.8028787161223, -122.412092628976) | |||
| 157308 | 157308 | 138475 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1749 FILLMORE ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 6003020.8355 | 2114339.7281 | 37.7857443724045 | -122.433304420865 | (37.7857443724045, -122.433304420865) | |||
| 161539 | 161539 | 140542 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1025 FILLMORE ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6003382.3327 | 2111808.7639 | 37.778815480381205 | -122.43187295981501 | (37.7788154803812, -122.431872959815) | |||
| 167035 | 167035 | 142595 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 365 COLUMBUS AVE | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6008339.7594 | 2120798.6708 | 37.803779343791795 | -122.415359808453 | (37.8037793437918, -122.415359808453) | |||
| 167223 | 167223 | 246096 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 700 Stanyan St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5997106.9677 | 2108216.5794 | 37.768594534360204 | -122.453322392223 | (37.7685945343602, -122.453322392223) | |||
| 169564 | 169564 | 200689 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 4705 03rd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6015031.9275 | 2095672.1834 | 37.73516139610629 | -122.39044428404699 | (37.7351613961063, -122.390444284047) | |||
| 175434 | 175434 | 140536 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1099 FILLMORE ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6003366.6758 | 2111915.9993 | 37.779109034509204 | -122.43193478240102 | (37.7791090345092, -122.431934782401) | |||
| 180418 | 180418 | 143162 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 175 Bay St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6009943.6415 | 2121579.1756 | 37.8060124294215 | -122.409864588833 | (37.8060124294215, -122.409864588833) | |||
| 181119 | 181119 | 142605 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 700 CHESTNUT ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 6008282.9909 | 2120710.7963 | 37.8035348717489 | -122.41555003439501 | (37.8035348717489, -122.415550034395) | |||
| 134348 | 134348 | 97114 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1345 Noriega St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Permit Number 18860 | 5989801.9904 | 2103085.8445 | 37.7540855022306 | -122.47821424615101 | (37.7540855022306, -122.478214246151) | |||
| 167853 | 167853 | 32297 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1616 16th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/1996 12:00:00 AM | 12 | Permit Number 36875 | 6011502.2034 | 2107015.4172 | 37.766111004805396 | -122.40344565674499 | (37.7661110048054, -122.403445656745) | ||
| 3249 | 3249 | 142515 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 624 VALLEJO ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/2014 12:00:00 AM | 21 | Width 0ft | Permit Number 774306 | 6010502.9388 | 2118931.0084 | 37.7987725428783 | -122.40774219721901 | (37.7987725428783, -122.407742197219) | |
| 134413 | 134413 | 120659 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 160 Folsom St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | Permit Number 778623 | 6015041.8167 | 2115476.8576 | 37.7895412902416 | -122.391794432707 | (37.7895412902416, -122.391794432707) |
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");