Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, PlantType, qCaretaker, PlantDate, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 78029 | 78029 | 92123 | Permitted Site 1 | Laurus x 'Saratoga' :: Hybrid Laurel 457 | 4222 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52452 | 6001057.0 | 2102908.0 | 37.7542440926769 | -122.439279034114 | (37.7542440926769, -122.439279034114) | ||
| 78931 | 78931 | 91324 | Permitted Site 1 | Laurus x 'Saratoga' :: Hybrid Laurel 457 | 450 Rhode Island St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/2009 12:00:00 AM | 3x3 | Permit Number 52049 | 6011745.0 | 2106547.0 | 37.7648383947947 | -122.40257292402 | (37.7648383947947, -122.40257292402) | ||
| 85165 | 85165 | 50075 | Permitted Site 1 | Laurus x 'Saratoga' :: Hybrid Laurel 457 | 2655 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | 3 | Permit Number 778488 | 5991409.21436461 | 2097353.26645998 | 37.738438489022 | -122.47223828140699 | (37.738438489022, -122.472238281407) | |
| 93615 | 93615 | 91325 | Permitted Site 1 | Laurus x 'Saratoga' :: Hybrid Laurel 457 | 450 Rhode Island St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/2009 12:00:00 AM | 3x3 | Permit Number 52049 | 6011745.0 | 2106547.0 | 37.7648383947947 | -122.40257292402 | (37.7648383947947, -122.40257292402) | ||
| 94895 | 94895 | 89672 | DPW Maintained 3 | Laurus x 'Saratoga' :: Hybrid Laurel 457 | 2627 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/18/2008 12:00:00 AM | 3 | 3x3 | 5990536.654767 | 2111956.813347 | 37.7784854072376 | -122.476321569471 | (37.7784854072376, -122.476321569471) | ||
| 95478 | 95478 | 115294 | Permitted Site 1 | Laurus x 'Saratoga' :: Hybrid Laurel 457 | 2167 18th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2016 12:00:00 AM | Permit Number 776197 | 5990660.3 | 2100644.0 | 37.7474306230823 | -122.47506779234502 | (37.7474306230823, -122.475067792345) | |||
| 97167 | 97167 | 91323 | Permitted Site 1 | Laurus x 'Saratoga' :: Hybrid Laurel 457 | 450 Rhode Island St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/2009 12:00:00 AM | 3x3 | Permit Number 52049 | 6011745.0 | 2106547.0 | 37.7648383947947 | -122.40257292402 | (37.7648383947947, -122.40257292402) | ||
| 103268 | 103268 | 117335 | Permitted Site 1 | Laurus x 'Saratoga' :: Hybrid Laurel 457 | 2655 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/07/2016 12:00:00 AM | 3 | Permit Number 778488 | 5991395.3 | 2097349.2 | 37.7384265182794 | -122.47228609371099 | (37.7384265182794, -122.472286093711) | ||
| 104828 | 104828 | 45456 | Permitted Site 1 | Laurus x 'Saratoga' :: Hybrid Laurel 457 | 850 Head St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2015 12:00:00 AM | Permit Number 776073 | 5993949.84571271 | 2091533.57261913 | 37.7226057448874 | -122.46303194910101 | (37.7226057448874, -122.463031949101) | ||
| 106419 | 106419 | 115007 | Permitted Site 1 | Laurus x 'Saratoga' :: Hybrid Laurel 457 | 1650 Portola Dr | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 775372 | 5991807.6 | 2096246.3 | 37.7354220869049 | -122.47078025988701 | (37.7354220869049, -122.470780259887) | ||||
| 107743 | 107743 | 89432 | DPW Maintained 3 | Laurus x 'Saratoga' :: Hybrid Laurel 457 | 2732 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/29/2008 12:00:00 AM | 3 | 3x3 | 5990207.269944999 | 2111985.0354509996 | 37.7785437899427 | -122.47746308716499 | (37.7785437899427, -122.477463087165) | ||
| 109957 | 109957 | 114818 | Permitted Site 1 | Laurus x 'Saratoga' :: Hybrid Laurel 457 | 825 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/2015 12:00:00 AM | Permit Number 774480 | 5986555.6 | 2110296.1 | 37.773693882861 | -122.489971179067 | (37.773693882861, -122.489971179067) | |||
| 110244 | 110244 | 91322 | Permitted Site 1 | Laurus x 'Saratoga' :: Hybrid Laurel 457 | 450 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/2009 12:00:00 AM | 3x3 | Permit Number 52049 | 6011745.0 | 2106547.0 | 37.7648383947947 | -122.40257292402 | (37.7648383947947, -122.40257292402) | ||
| 119693 | 119693 | 95733 | Permitted Site 1 | Laurus x 'Saratoga' :: Hybrid Laurel 457 | 525 Edinburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767480 | 6002894.0 | 2090661.9 | 37.7207234811925 | -122.43205179782 | (37.7207234811925, -122.43205179782) | |
| 124219 | 124219 | 92145 | Permitted Site 1 | Laurus x 'Saratoga' :: Hybrid Laurel 457 | 647 18th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 52518 | 5990297.6 | 2110960.8 | 37.7757367629665 | -122.477075740094 | (37.7757367629665, -122.477075740094) | |||
| 125444 | 125444 | 91326 | Permitted Site 1 | Laurus x 'Saratoga' :: Hybrid Laurel 457 | 450 Rhode Island St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/2009 12:00:00 AM | 3x3 | Permit Number 52049 | 6011745.0 | 2106547.0 | 37.7648383947947 | -122.40257292402 | (37.7648383947947, -122.40257292402) | ||
| 126697 | 126697 | 117336 | Permitted Site 1 | Laurus x 'Saratoga' :: Hybrid Laurel 457 | 2655 16th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/07/2016 12:00:00 AM | 3 | Permit Number 778488 | 5991395.3 | 2097349.2 | 37.7384265182794 | -122.47228609371099 | (37.7384265182794, -122.472286093711) | ||
| 127755 | 127755 | 83007 | Permitted Site 1 | Laurus x 'Saratoga' :: Hybrid Laurel 457 | 1058 De Haro St | 1 | Median : Cutout 11 | Landscaping 2 | Private 1 | 07/02/2009 12:00:00 AM | 3x3 | Permit Number 52381 | 6012170.46860809 | 2103464.70975517 | 37.7563988530014 | -122.40088475581499 | (37.7563988530014, -122.400884755815) | ||
| 144538 | 144538 | 92144 | Permitted Site 1 | Laurus x 'Saratoga' :: Hybrid Laurel 457 | 647 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 52518 | 5990297.6 | 2110960.8 | 37.7757367629665 | -122.477075740094 | (37.7757367629665, -122.477075740094) | |||
| 145949 | 145949 | 111043 | Permitted Site 1 | Laurus x 'Saratoga' :: Hybrid Laurel 457 | 2144 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/15/2015 12:00:00 AM | 3 | 3x3 | 5989308.1 | 2098377.8 | 37.741129770056205 | -122.479577773079 | (37.7411297700562, -122.479577773079) |
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");