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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
216 | 216 | 138364 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2060 SUTTER ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | Width 0ft | 6002783.7892 | 2114453.2783 | 37.7860427018539 | -122.43413265320801 | (37.7860427018539, -122.434132653208) | |||
3349 | 3349 | 140427 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1499 TURK ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 14 | Width 0ft | 6003052.211 | 2112362.4007 | 37.7803169090148 | -122.43305454594 | (37.7803169090148, -122.43305454594) | |||
4252 | 4252 | 244056 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 401 Cole St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5997913.0484 | 2109110.0936 | 37.771094065570296 | -122.45059866498 | (37.7710940655703, -122.45059866498) | |||
6110 | 6110 | 13189 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2055X Lombard St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002690.4208 | 2119498.1098 | 37.7998892100694 | -122.43481657946998 | (37.7998892100694, -122.43481657947) | |||
7037 | 7037 | 4663 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 600X Columbus Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 60 | 5X5 | 6009710.0139 | 2119634.3519 | 37.8006593307081 | -122.41053567802 | (37.8006593307081, -122.41053567802) | |||
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) | ||
8426 | 8426 | 99231 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1111 Columbus Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2x2 | 6008046.5206 | 2121063.2366 | 37.804489289265106 | -122.416393331612 | (37.8044892892651, -122.416393331612) | |||
8894 | 8894 | 21590 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1500 Sutter St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X2 | 6005256.9547 | 2114799.289 | 37.78713281444121 | -122.425600795702 | (37.7871328144412, -122.425600795702) | |||
20426 | 20426 | 496 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2749X 24th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6010495.2306 | 2102220.2128 | 37.7528881543902 | -122.406590648723 | (37.7528881543902, -122.406590648723) | |||
29770 | 29770 | 138507 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1701 FILLMORE ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6003042.8042 | 2114198.3962 | 37.785357557038296 | -122.433218313249 | (37.7853575570383, -122.433218313249) | |||
30500 | 30500 | 140709 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 500 PIERCE ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6002649.4537 | 2110396.2195 | 37.7748954127382 | -122.43430725979401 | (37.7748954127382, -122.434307259794) | |||
30671 | 30671 | 111734 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 313 Ivy St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 2.5x3 | 6005865.3001 | 2111209.4164 | 37.777310260787 | -122.423240771205 | (37.777310260787, -122.423240771205) | |||
37138 | 37138 | 140693 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1120 FILLMORE ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6003357.1733 | 2112337.09 | 37.780264705851 | -122.43199773269801 | (37.780264705851, -122.431997732698) | |||
39969 | 39969 | 139449 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 508 OCTAVIA ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6005461.1411 | 2111122.6096 | 37.7770490933731 | -122.42463271281 | (37.7770490933731, -122.42463271281) | |||
44319 | 44319 | 143254 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 661 LOMBARD ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6009304.3696 | 2120454.8431 | 37.802889446076605 | -122.411997395012 | (37.8028894460766, -122.411997395012) | |||
46381 | 46381 | 98473 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1500 16th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6011870.2645 | 2107034.4384 | 37.7661837837598 | -122.402173936122 | (37.7661837837598, -122.402173936122) | |||
46704 | 46704 | 246095 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 700 Stanyan St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 5997104.5451 | 2108242.017 | 37.768664240613205 | -122.45333260848801 | (37.7686642406132, -122.453332608488) | |||
48419 | 48419 | 138126 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1850 FILLMORE ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | Width 0ft | 6003024.8426 | 2114663.3242 | 37.78663311261921 | -122.433313688795 | (37.7866331126192, -122.433313688795) | |||
60794 | 60794 | 137528 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1300 Pierce St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 6002263.2838 | 2113153.4253 | 37.7824440807926 | -122.435840420812 | (37.7824440807926, -122.435840420812) | |||
66616 | 66616 | 110470 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 465 Grove St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 15 | 3x3 | 6005644.9931 | 2111337.1436 | 37.777648533038395 | -122.42401197054701 | (37.7776485330384, -122.424011970547) | ||
67407 | 67407 | 142493 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 651 COLUMBUS AVE | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6009645.6019 | 2119599.491 | 37.8005599999984 | -122.410756107582 | (37.8005599999984, -122.410756107582) | |||
68835 | 68835 | 199857 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2511 Keith St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6014147.0563 | 2092057.1756 | 37.725186191812 | -122.39325074575198 | (37.725186191812, -122.393250745752) | |||
73758 | 73758 | 199726 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2300 Jennings St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6015013.7839 | 2092118.9829 | 37.725404016033295 | -122.390258847729 | (37.7254040160333, -122.390258847729) | |||
147281 | 147281 | 140543 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1025 FILLMORE ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6003386.4685 | 2111785.1308 | 37.7787508242216 | -122.43185696454799 | (37.7787508242216, -122.431856964548) | |||
152387 | 152387 | 141535 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2901 TURK BLVD | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5996788.0463 | 2111499.0832 | 37.777589151551 | -122.454662685268 | (37.777589151551, -122.454662685268) | |||
153722 | 153722 | 143352 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1651 UNION ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6005162.5109 | 2118835.6881 | 37.7982104111867 | -122.426215027416 | (37.7982104111867, -122.426215027416) | |||
154938 | 154938 | 201882 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 633 Folsom St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6013405.8744 | 2113823.4352 | 37.7849104254124 | -122.397338660811 | (37.7849104254124, -122.397338660811) | |||
155943 | 155943 | 141687 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2350 TURK BLVD | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5998550.3836 | 2111804.4075 | 37.778528418096 | -122.448588188719 | (37.778528418096, -122.448588188719) | |||
156752 | 156752 | 142993 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 365 COLUMBUS AVE | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6008349.8689 | 2120789.339 | 37.803754289201606 | -122.415324162836 | (37.8037542892016, -122.415324162836) | |||
168873 | 168873 | 140508 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1020 FILLMORE ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6003419.5462 | 2111864.9347 | 37.778971820925996 | -122.43174823532401 | (37.778971820926, -122.431748235324) | |||
170236 | 170236 | 244974 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 205 Rose St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6005564.966 | 2109773.8307 | 37.7733515366804 | -122.424177602904 | (37.7733515366804, -122.424177602904) | |||
180017 | 180017 | 217621 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1830 Ocean Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5994307.7366 | 2092494.0455 | 37.725263580598 | -122.461864420033 | (37.725263580598, -122.461864420033) |
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");