Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSpecies, qAddress, SiteOrder, qCaretaker, PlantDate, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 96 | 96 | 251196 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 900X 14th St | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 03/22/2017 12:00:00 AM | 3 | 6002515.0 | 2107976.0 | 37.768242455454995 | -122.43459927073098 | (37.768242455455, -122.434599270731) | |||
| 563 | 563 | 173951 | Significant Tree 6 | Tree(s) :: 17 | 2646 Union St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 04/11/2017 12:00:00 AM | 3 | 10x10 | Permit Number 779549 | 6000338.0 | 2118225.0 | 37.796259749404605 | -122.442865342513 | (37.7962597494046, -122.442865342513) | |
| 1358 | 1358 | 173635 | Significant Tree 6 | Tree(s) :: 17 | 2590 Pacific Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 05/11/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779167 | 6001760.0 | 2117029.0 | 37.7930568116395 | -122.43785923271999 | (37.7930568116395, -122.43785923272) | |
| 2105 | 2105 | 251411 | Significant Tree 6 | Tree(s) :: 17 | 2751 Buchanan St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 06/21/2017 12:00:00 AM | 3 | 6x6 | Permit Number 779887 | 6003497.0 | 2117826.0 | 37.7953437887296 | -122.431906052505 | (37.7953437887296, -122.431906052505) | |
| 2436 | 2436 | 110026 | Permitted Site 1 | Acer palmatum :: Japanese Maple 175 | 2585 Pacific Ave | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 03/18/2015 12:00:00 AM | 3 | Permit Number 779691 | 6001774.18039 | 2116969.68651 | 37.7928947585324 | -122.437805917729 | (37.7928947585324, -122.437805917729) | ||
| 2687 | 2687 | 253164 | Planning Code 138.1 required 4 | Tree(s) :: 17 | 146 Cambridge St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 07/27/2017 12:00:00 AM | 3 | 4x4 | 6006598.94029 | 2094006.4119099998 | 37.7301161400075 | -122.419482094225 | (37.7301161400075, -122.419482094225) | ||
| 3318 | 3318 | 253415 | Planning Code 138.1 required 4 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 55 Stoneybrook Ave | Front Yard : Cutout 8 | Tree 1 | Private 1 | 08/31/2017 12:00:00 AM | 3 | Permit Number 779907 | 6005926.97731 | 2093972.4268599998 | 37.729984953042795 | -122.421802746417 | (37.7299849530428, -122.421802746417) | |||
| 3709 | 3709 | 253265 | Significant Tree 6 | Juniperus chinensis :: Juniper 19 | 180 San Aleso Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 09/19/2017 12:00:00 AM | 3 | 3x3 | 5993319.0 | 2094440.0 | 37.730549723890206 | -122.465423653439 | (37.7305497238902, -122.465423653439) | ||
| 5087 | 5087 | 150676 | Planning Code 138.1 required 4 | Pittosporum undulatum :: Victorian Box 26 | 548 Rhode Island St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 11/07/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780811 | 6011754.983990001 | 2105812.52377 | 37.762822244976505 | -122.402486741392 | (37.7628222449765, -122.402486741392) | |
| 8205 | 8205 | 110025 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2585 Pacific Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 03/18/2015 12:00:00 AM | 3 | Permit Number 774536 | 6001760.7528800005 | 2116964.32872 | 37.7928792839017 | -122.437851993568 | (37.7928792839017, -122.437851993568) | ||
| 9848 | 9848 | 122687 | Significant Tree 6 | Tree(s) :: 17 | 1462 Funston Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 01/04/2017 12:00:00 AM | 3 | 3x8 | Permit Number 779171 | 5992142.99696903 | 2105491.66018597 | 37.7608268551195 | -122.470293739312 | (37.7608268551195, -122.470293739312) | |
| 10183 | 10183 | 173712 | Undocumented 2 | Tree(s) :: 17 | 699x 29th St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 02/03/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779391 | 6002089.0 | 2098776.0 | 37.7429572717864 | -122.435414565427 | (37.7429572717864, -122.435414565427) | |
| 10195 | 10195 | 173713 | Undocumented 2 | Tree(s) :: 17 | 699x 29th St | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 02/03/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779391 | 6002089.0 | 2098776.0 | 37.7429572717864 | -122.435414565427 | (37.7429572717864, -122.435414565427) | |
| 11497 | 11497 | 69940 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1295 30th Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 05/06/2016 12:00:00 AM | 3 | 5x5 | Permit Number 778203 | 5986757.5345 | 2106473.3538 | 37.7632094781069 | -122.488991584645 | (37.7632094781069, -122.488991584645) | |
| 22873 | 22873 | 251137 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 25x Goettingen St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 03/10/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779273 | 6009828.0 | 2094364.0 | 37.7312793503434 | -122.40834398535401 | (37.7312793503434, -122.408343985354) | |
| 66196 | 66196 | 107892 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 162 Brewster St | Front Yard : Cutout 8 | Tree 1 | Private 1 | 11/04/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773952 | 6010231.01704 | 2099016.49618 | 37.7440766668365 | -122.40727852777799 | (37.7440766668365, -122.407278527778) | ||
| 80053 | 80053 | 109497 | Permitted Site 1 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 254 | 785 Mangels Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | FUF 1 | 02/19/2015 12:00:00 AM | 3 | 3x3 | Permit Number 771883 | 5996438.0 | 2095245.0 | 37.732939449865896 | -122.45469900823 | (37.7329394498659, -122.45469900823) |
| 85057 | 85057 | 115566 | Permitted Site 1 | Tree(s) :: 17 | 2026 36TH AVE | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 04/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777529 | 5985134.0 | 2101392.0 | 37.7491625951009 | -122.49423221215099 | (37.7491625951009, -122.494232212151) | |
| 85532 | 85532 | 108239 | Permitted Site 1 | Tree(s) :: 17 | 15 ASHBURY TER | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 01/14/2015 12:00:00 AM | 3 | 5x50 | Permit Number 774721 | 5999554.7 | 2106911.6 | 37.7651513833487 | -122.444762103204 | (37.7651513833487, -122.444762103204) | |
| 85775 | 85775 | 114272 | Significant Tree 6 | Tree(s) :: 17 | 2241 Sacramento St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 03/22/2016 12:00:00 AM | 3 | 3x6 | Permit Number 776884 | 6004082.4 | 2115905.7 | 37.79010430227179 | -122.42974344149499 | (37.7901043022718, -122.429743441495) | |
| 94493 | 94493 | 110787 | Section 143 8 | Tree(s) :: 17 | 850x SANCHEZ ST | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 02/18/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777427 | 6003717.0 | 2103349.0 | 37.7556059854845 | -122.430111549694 | (37.7556059854845, -122.430111549694) | |
| 98858 | 98858 | 114924 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 37X EVERGLADE DR | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 01/13/2016 12:00:00 AM | 3 | 3x3 | 5986312.0 | 2095495.0 | 37.7330398702545 | -122.489725113139 | (37.7330398702545, -122.489725113139) | ||
| 102481 | 102481 | 114925 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 4400x OCEAN AVE | 3 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 02/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777127 | 5985931.0 | 2095134.0 | 37.7320264068308 | -122.491015755892 | (37.7320264068308, -122.491015755892) | |
| 103011 | 103011 | 114923 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 51X EVERGLADE DR | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 01/13/2016 12:00:00 AM | 3 | 3x3 | 5986312.0 | 2095495.0 | 37.7330398702545 | -122.489725113139 | (37.7330398702545, -122.489725113139) | ||
| 103199 | 103199 | 114934 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 4400x OCEAN AVE | 10 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 02/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777127 | 5985931.0 | 2095134.0 | 37.7320264068308 | -122.491015755892 | (37.7320264068308, -122.491015755892) | |
| 106272 | 106272 | 115004 | Private 5 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 1050 MCALLISTER ST | 1 | Front Yard : Cutout 8 | Tree 1 | Office of Mayor 21 | DPW 4 | 01/19/2016 09:19:00 AM | 3 | 3x3 | 6004148.0 | 2111858.0 | 37.778994045300706 | -122.42922772691401 | (37.7789940453007, -122.429227726914) | |
| 111849 | 111849 | 117150 | Section 143 8 | Eriobotrya deflexa :: Bronze Loquat 49 | 928 TOLAND ST | 5 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011950.0 | 2098029.0 | 37.7414612698949 | -122.401265252936 | (37.7414612698949, -122.401265252936) | |
| 115370 | 115370 | 107863 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 218 HOWTH ST | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3 | 5997350.1 | 2090721.9 | 37.720572361158105 | -122.451219574954 | (37.7205723611581, -122.451219574954) | ||||
| 128304 | 128304 | 115100 | Significant Tree 6 | Tree(s) :: 17 | 710 PACHECO ST | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 02/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777305 | 5992727.0 | 2102215.0 | 37.7518637464828 | -122.468035600741 | (37.7518637464828, -122.468035600741) | |
| 129398 | 129398 | 109973 | Undocumented 2 | Tree(s) :: 17 | 1458 43rd Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 03/16/2015 12:00:00 AM | 3 | 3x3 | 5982831.2 | 2105195.6 | 37.7594711884194 | -122.502476670215 | (37.7594711884194, -122.502476670215) | ||
| 142230 | 142230 | 120534 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2043 32nd Ave | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 08/10/2016 12:00:00 AM | 3 | 3x3 | 5986293.0 | 2101328.0 | 37.7490546230695 | -122.49021972232599 | (37.7490546230695, -122.490219722326) | ||
| 142954 | 142954 | 110788 | Section 143 8 | Tree(s) :: 17 | 850x SANCHEZ ST | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 02/18/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777427 | 6003717.0 | 2103349.0 | 37.7556059854845 | -122.430111549694 | (37.7556059854845, -122.430111549694) | |
| 143274 | 143274 | 122379 | Planning Code 138.1 required 4 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 466 Vernon St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 10/26/2016 12:00:00 AM | 3 | 3x3 | 5992521.0 | 2090937.0 | 37.7208852925782 | -122.46792773796801 | (37.7208852925782, -122.467927737968) |
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");