Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qCaretaker, PlantDate, DBH, PlotSize, PermitNotes, XCoord, YCoord, Latitude, Longitude, Location
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10222 | 10222 | 173923 | DPW Maintained 3 | Tree(s) :: 17 | 2160X 09th Ave | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 6x10 | 5993671.0 | 2100995.0 | 37.7485684085064 | -122.464682560698 | (37.7485684085064, -122.464682560698) | ||||
10224 | 10224 | 173918 | DPW Maintained 3 | Tree(s) :: 17 | 2160X 09th Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 6x10 | 5993671.0 | 2100995.0 | 37.7485684085064 | -122.464682560698 | (37.7485684085064, -122.464682560698) | ||||
10225 | 10225 | 173920 | DPW Maintained 3 | Tree(s) :: 17 | 2160X 09th Ave | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 6x10 | 5993671.0 | 2100995.0 | 37.7485684085064 | -122.464682560698 | (37.7485684085064, -122.464682560698) | ||||
10227 | 10227 | 173914 | DPW Maintained 3 | Tree(s) :: 17 | 2160X 09th Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 6x10 | 5993671.0 | 2100995.0 | 37.7485684085064 | -122.464682560698 | (37.7485684085064, -122.464682560698) | ||||
10228 | 10228 | 173922 | DPW Maintained 3 | Tree(s) :: 17 | 2160X 09th Ave | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 6x10 | 5993671.0 | 2100995.0 | 37.7485684085064 | -122.464682560698 | (37.7485684085064, -122.464682560698) | ||||
10230 | 10230 | 173919 | DPW Maintained 3 | Tree(s) :: 17 | 2160X 09th Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 6x10 | 5993671.0 | 2100995.0 | 37.7485684085064 | -122.464682560698 | (37.7485684085064, -122.464682560698) | ||||
10232 | 10232 | 173916 | DPW Maintained 3 | Tree(s) :: 17 | 2160X 09th Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 6x10 | 5993671.0 | 2100995.0 | 37.7485684085064 | -122.464682560698 | (37.7485684085064, -122.464682560698) | ||||
10233 | 10233 | 173917 | DPW Maintained 3 | Tree(s) :: 17 | 2160X 09th Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 6x10 | 5993671.0 | 2100995.0 | 37.7485684085064 | -122.464682560698 | (37.7485684085064, -122.464682560698) | ||||
10234 | 10234 | 122682 | DPW Maintained 3 | Tree(s) :: 17 | 2160X 09th Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/03/2017 12:00:00 AM | 3 | 6x10 | Permit Number 778226 | 5993671.0 | 2100995.0 | 37.7485684085064 | -122.464682560698 | (37.7485684085064, -122.464682560698) | |
10237 | 10237 | 173915 | DPW Maintained 3 | Tree(s) :: 17 | 2160X 09th Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 6x10 | 5993671.0 | 2100995.0 | 37.7485684085064 | -122.464682560698 | (37.7485684085064, -122.464682560698) | ||||
10238 | 10238 | 173921 | DPW Maintained 3 | Tree(s) :: 17 | 2160X 09th Ave | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 6x10 | 5993671.0 | 2100995.0 | 37.7485684085064 | -122.464682560698 | (37.7485684085064, -122.464682560698) | ||||
14379 | 14379 | 48480 | Permitted Site 1 | Tree(s) :: 17 | 1 | Median : Cutout 11 | Tree 1 | Private 1 | Permit Number 45832 | ||||||||||
18486 | 18486 | 106393 | DPW Maintained 3 | Tree(s) :: 17 | 182x Lower Ter | 20 | Median : Cutout 11 | Tree 1 | DPW 2 | 10x10 | 6000081.12192 | 2106216.81045 | 37.763273691074204 | -122.442891445737 | (37.7632736910742, -122.442891445737) | ||||
69415 | 69415 | 185128 | DPW Maintained 3 | Tree(s) :: 17 | 1200x Sloat Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 0ft | 5987683.0779 | 2095922.3154 | 37.7342931239465 | -122.48501633511002 | (37.7342931239465, -122.48501633511) | |||
79975 | 79975 | 106399 | DPW Maintained 3 | Tree(s) :: 17 | 182x Lower Ter | 26 | Median : Cutout 11 | Tree 1 | DPW 2 | 10x10 | 6000081.12192 | 2106216.81045 | 37.763273691074204 | -122.442891445737 | (37.7632736910742, -122.442891445737) | ||||
80883 | 80883 | 106374 | DPW Maintained 3 | Tree(s) :: 17 | 182x Lower Ter | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 10x10 | 6000081.12192 | 2106216.81045 | 37.763273691074204 | -122.442891445737 | (37.7632736910742, -122.442891445737) | ||||
81473 | 81473 | 106380 | DPW Maintained 3 | Tree(s) :: 17 | 182x Lower Ter | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 10x10 | 6000081.12192 | 2106216.81045 | 37.763273691074204 | -122.442891445737 | (37.7632736910742, -122.442891445737) | ||||
81773 | 81773 | 104786 | DPW Maintained 3 | Tree(s) :: 17 | 750 Holly Park Cir | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 2x2 | 6006276.6738599995 | 2096799.83163 | 37.7377680961975 | -122.42079445065201 | (37.7377680961975, -122.420794450652) | ||||
82181 | 82181 | 106395 | DPW Maintained 3 | Tree(s) :: 17 | 182x Lower Ter | 22 | Median : Cutout 11 | Tree 1 | DPW 2 | 10x10 | 6000081.12192 | 2106216.81045 | 37.763273691074204 | -122.442891445737 | (37.7632736910742, -122.442891445737) | ||||
83897 | 83897 | 106386 | DPW Maintained 3 | Tree(s) :: 17 | 182x Lower Ter | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 10x10 | 6000081.12192 | 2106216.81045 | 37.763273691074204 | -122.442891445737 | (37.7632736910742, -122.442891445737) | ||||
83946 | 83946 | 106379 | DPW Maintained 3 | Tree(s) :: 17 | 182x Lower Ter | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 10x10 | 6000081.12192 | 2106216.81045 | 37.763273691074204 | -122.442891445737 | (37.7632736910742, -122.442891445737) | ||||
84835 | 84835 | 86968 | Permitted Site 1 | Tree(s) :: 17 | 3250 Van Ness Ave | 1 | Median : Cutout 11 | Tree 1 | Private 1 | 10/27/2007 12:00:00 AM | Permit Number 49934 | 6005499.7 | 2121504.7 | 37.8055578865418 | -122.42523827370701 | (37.8055578865418, -122.425238273707) | |||
89830 | 89830 | 106376 | DPW Maintained 3 | Tree(s) :: 17 | 182x Lower Ter | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 10x10 | 6000081.12192 | 2106216.81045 | 37.763273691074204 | -122.442891445737 | (37.7632736910742, -122.442891445737) | ||||
92047 | 92047 | 106392 | DPW Maintained 3 | Tree(s) :: 17 | 182x Lower Ter | 19 | Median : Cutout 11 | Tree 1 | DPW 2 | 10x10 | 6000081.12192 | 2106216.81045 | 37.763273691074204 | -122.442891445737 | (37.7632736910742, -122.442891445737) | ||||
94414 | 94414 | 106389 | DPW Maintained 3 | Tree(s) :: 17 | 182x Lower Ter | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 10x10 | 6000081.12192 | 2106216.81045 | 37.763273691074204 | -122.442891445737 | (37.7632736910742, -122.442891445737) | ||||
96550 | 96550 | 107116 | DPW Maintained 3 | Tree(s) :: 17 | 300X LIBERTY ST | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6004270.1 | 2103982.4 | 37.757376462852704 | -122.42824389606199 | (37.7573764628527, -122.428243896062) | ||||
97264 | 97264 | 106377 | DPW Maintained 3 | Tree(s) :: 17 | 182x Lower Ter | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 10x10 | 6000081.12192 | 2106216.81045 | 37.763273691074204 | -122.442891445737 | (37.7632736910742, -122.442891445737) | ||||
97640 | 97640 | 106384 | DPW Maintained 3 | Tree(s) :: 17 | 182x Lower Ter | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 10x10 | 6000081.12192 | 2106216.81045 | 37.763273691074204 | -122.442891445737 | (37.7632736910742, -122.442891445737) | ||||
101290 | 101290 | 111777 | Undocumented 2 | Tree(s) :: 17 | 96 CRESTLINE DR | 1 | Median : Cutout 11 | Tree 1 | Private 1 | 3x3 | 5998960.0 | 2102304.0 | 37.7524661019794 | -122.446487505153 | (37.7524661019794, -122.446487505153) | ||||
103968 | 103968 | 106387 | DPW Maintained 3 | Tree(s) :: 17 | 182x Lower Ter | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 10x10 | 6000081.12192 | 2106216.81045 | 37.763273691074204 | -122.442891445737 | (37.7632736910742, -122.442891445737) | ||||
105877 | 105877 | 106381 | DPW Maintained 3 | Tree(s) :: 17 | 182x Lower Ter | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 10x10 | 6000081.12192 | 2106216.81045 | 37.763273691074204 | -122.442891445737 | (37.7632736910742, -122.442891445737) | ||||
110313 | 110313 | 106397 | DPW Maintained 3 | Tree(s) :: 17 | 182x Lower Ter | 24 | Median : Cutout 11 | Tree 1 | DPW 2 | 10x10 | 6000081.12192 | 2106216.81045 | 37.763273691074204 | -122.442891445737 | (37.7632736910742, -122.442891445737) | ||||
115281 | 115281 | 106394 | DPW Maintained 3 | Tree(s) :: 17 | 182x Lower Ter | 21 | Median : Cutout 11 | Tree 1 | DPW 2 | 10x10 | 6000081.12192 | 2106216.81045 | 37.763273691074204 | -122.442891445737 | (37.7632736910742, -122.442891445737) | ||||
115311 | 115311 | 106383 | DPW Maintained 3 | Tree(s) :: 17 | 182x Lower Ter | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 10x10 | 6000081.12192 | 2106216.81045 | 37.763273691074204 | -122.442891445737 | (37.7632736910742, -122.442891445737) | ||||
116269 | 116269 | 96365 | Undocumented 2 | Tree(s) :: 17 | 2017 Grant Ave | 1 | Median : Cutout 11 | Tree 1 | Private 1 | 06/07/2011 12:00:00 AM | 12 | 3x3 | Permit Number 767883 | 6010284.4 | 2121422.5 | 37.805601328212795 | -122.408674274121 | (37.8056013282128, -122.408674274121) | |
120659 | 120659 | 106375 | DPW Maintained 3 | Tree(s) :: 17 | 182x Lower Ter | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 10x10 | 6000081.12192 | 2106216.81045 | 37.763273691074204 | -122.442891445737 | (37.7632736910742, -122.442891445737) | ||||
124349 | 124349 | 109295 | DPW Maintained 3 | Tree(s) :: 17 | 1062 Carolina St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 6012455.3 | 2103027.1 | 37.7552131559276 | -122.39986897476001 | (37.7552131559276, -122.39986897476) | |||||
125606 | 125606 | 106382 | DPW Maintained 3 | Tree(s) :: 17 | 182x Lower Ter | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 10x10 | 6000081.12192 | 2106216.81045 | 37.763273691074204 | -122.442891445737 | (37.7632736910742, -122.442891445737) | ||||
128923 | 128923 | 92212 | Permitted Site 1 | Tree(s) :: 17 | 300x Miramar Ave | 6 | Median : Cutout 11 | Tree 1 | Private 1 | 07/16/2009 12:00:00 AM | 2x2 | Permit Number 52642 | 5995384.3 | 2092126.4 | 37.724316032008204 | -122.45811627477501 | (37.7243160320082, -122.458116274775) | ||
139009 | 139009 | 106388 | DPW Maintained 3 | Tree(s) :: 17 | 182x Lower Ter | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 10x10 | 6000081.12192 | 2106216.81045 | 37.763273691074204 | -122.442891445737 | (37.7632736910742, -122.442891445737) | ||||
139171 | 139171 | 106385 | DPW Maintained 3 | Tree(s) :: 17 | 182x Lower Ter | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 10x10 | 6000081.12192 | 2106216.81045 | 37.763273691074204 | -122.442891445737 | (37.7632736910742, -122.442891445737) | ||||
140517 | 140517 | 86969 | Permitted Site 1 | Tree(s) :: 17 | 3250 Van Ness Ave | 2 | Median : Cutout 11 | Tree 1 | Private 1 | 10/27/2007 12:00:00 AM | Permit Number 49934 | 6005499.7 | 2121504.7 | 37.8055578865418 | -122.42523827370701 | (37.8055578865418, -122.425238273707) | |||
140616 | 140616 | 106396 | DPW Maintained 3 | Tree(s) :: 17 | 182x Lower Ter | 23 | Median : Cutout 11 | Tree 1 | DPW 2 | 10x10 | 6000081.12192 | 2106216.81045 | 37.763273691074204 | -122.442891445737 | (37.7632736910742, -122.442891445737) | ||||
142322 | 142322 | 106398 | DPW Maintained 3 | Tree(s) :: 17 | 182x Lower Ter | 25 | Median : Cutout 11 | Tree 1 | DPW 2 | 10x10 | 6000081.12192 | 2106216.81045 | 37.763273691074204 | -122.442891445737 | (37.7632736910742, -122.442891445737) | ||||
142776 | 142776 | 106390 | DPW Maintained 3 | Tree(s) :: 17 | 182x Lower Ter | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 10x10 | 6000081.12192 | 2106216.81045 | 37.763273691074204 | -122.442891445737 | (37.7632736910742, -122.442891445737) | ||||
142854 | 142854 | 113497 | DPW Maintained 3 | Tree(s) :: 17 | 200x MANSELL ST | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 6011136.0 | 2090597.0 | 37.7210091086741 | -122.403557031831 | (37.7210091086741, -122.403557031831) | ||||
143350 | 143350 | 106391 | DPW Maintained 3 | Tree(s) :: 17 | 182x Lower Ter | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 10x10 | 6000081.12192 | 2106216.81045 | 37.763273691074204 | -122.442891445737 | (37.7632736910742, -122.442891445737) | ||||
143771 | 143771 | 106378 | DPW Maintained 3 | Tree(s) :: 17 | 182x Lower Ter | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 10x10 | 6000081.12192 | 2106216.81045 | 37.763273691074204 | -122.442891445737 | (37.7632736910742, -122.442891445737) | ||||
160087 | 160087 | 185119 | DPW Maintained 3 | Tree(s) :: 17 | 1200x Sloat Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | Width 0ft | 5987585.1902 | 2095924.1623 | 37.734292492791205 | -122.485354895586 | (37.7342924927912, -122.485354895586) |
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");