Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qSpecies, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11978 | 11978 | 112948 | Property Tree 7 | Ligustrum japonicum :: Japanese Privet 4 | 400 Pioche St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x15 | 6005670.66964 | 2093276.94718 | 37.7280608613968 | -122.42263943148599 | (37.7280608613968, -122.422639431486) | |||
| 77354 | 77354 | 33781 | Property Tree 7 | Magnolia grandiflora :: Southern Magnolia 21 | 200x misson st | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 770804 | 6013804.30364325 | 2116217.11127164 | 37.7915050790356 | -122.396128026757 | (37.7915050790356, -122.396128026757) | |
| 81246 | 81246 | 109097 | Property Tree 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 601 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774331 | 6002630.6 | 2098839.9 | 37.743163470374895 | -122.43354642924999 | (37.7431634703749, -122.43354642925) |
| 82327 | 82327 | 33793 | Property Tree 7 | Magnolia grandiflora :: Southern Magnolia 21 | 200x Mission St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 770804 | 6014138.0 | 2116340.0 | 37.791861063915796 | -122.394982044679 | (37.7918610639158, -122.394982044679) | |
| 83310 | 83310 | 33775 | Property Tree 7 | Magnolia grandiflora :: Southern Magnolia 21 | 200x Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 770804 | 6014138.0 | 2116340.0 | 37.791861063915796 | -122.394982044679 | (37.7918610639158, -122.394982044679) | |
| 85637 | 85637 | 33789 | Property Tree 7 | Magnolia grandiflora :: Southern Magnolia 21 | 200x Mission St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 770804 | 6014138.0 | 2116340.0 | 37.791861063915796 | -122.394982044679 | (37.7918610639158, -122.394982044679) | |
| 89534 | 89534 | 33794 | Property Tree 7 | Magnolia grandiflora :: Southern Magnolia 21 | 200x Mission St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 770804 | 6014138.0 | 2116340.0 | 37.791861063915796 | -122.394982044679 | (37.7918610639158, -122.394982044679) | |
| 92335 | 92335 | 33787 | Property Tree 7 | Magnolia grandiflora :: Southern Magnolia 21 | 200x Mission St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 770804 | 6014138.0 | 2116340.0 | 37.791861063915796 | -122.394982044679 | (37.7918610639158, -122.394982044679) | |
| 92371 | 92371 | 118371 | Property Tree 7 | Sequoia sempervirens :: Coast Redwood 116 | 4808 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999981.0 | 2101110.0 | 37.7492459313263 | -122.44287099416799 | (37.7492459313263, -122.442870994168) | ||||
| 95068 | 95068 | 109091 | Property Tree 7 | Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 316 | 4235 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773805 | 6001611.4 | 2102294.1 | 37.7525900037408 | -122.43731782876002 | (37.7525900037408, -122.43731782876) |
| 97037 | 97037 | 97024 | Property Tree 7 | Jacaranda mimosifolia :: Jacaranda 52 | 1455 Alabama St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/16/2011 12:00:00 AM | Permit Number 768189 | 6009349.0 | 2100759.5 | 37.748813167460106 | -122.410451409671 | (37.7488131674601, -122.410451409671) | ||||
| 100275 | 100275 | 96676 | Property Tree 7 | Prunus spp :: Cherry 84 | 1701 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2011 12:00:00 AM | 5989644.3 | 2103769.9 | 37.7559545815884 | -122.478809598698 | (37.7559545815884, -122.478809598698) | ||||
| 102061 | 102061 | 109092 | Property Tree 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 237 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773766 | 6004335.1 | 2099509.2 | 37.7450977767532 | -122.427700396282 | (37.7450977767532, -122.427700396282) |
| 102914 | 102914 | 112377 | Property Tree 7 | Eucalyptus sideroxylon :: Red Ironbark 36 | 801 ULLOA ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 36 | 5993401.0 | 2098089.0 | 37.7405736985828 | -122.46540514019699 | (37.7405736985828, -122.465405140197) | ||||
| 104891 | 104891 | 102101 | Property Tree 7 | Cordyline australis :: Dracena Palm 141 | 331 Vernon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/19/2012 12:00:00 AM | 12 | 3x3 | Permit Number 769722 | 5992434.3 | 2090067.3 | 37.718492301183204 | -122.468164197766 | (37.7184923011832, -122.468164197766) |
| 107232 | 107232 | 98405 | Property Tree 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 84 Richland Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/2012 12:00:00 AM | Permit Number 768549 | 6005038.1 | 2096133.0 | 37.735867237922 | -122.425029371072 | (37.735867237922, -122.425029371072) | ||||
| 107998 | 107998 | 97023 | Property Tree 7 | Jacaranda mimosifolia :: Jacaranda 52 | 1443 Alabama St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/16/2011 12:00:00 AM | Permit Number 768190 | 6009347.4 | 2100788.9 | 37.748893803646105 | -122.410459018192 | (37.7488938036461, -122.410459018192) | ||||
| 112911 | 112911 | 33786 | Property Tree 7 | Magnolia grandiflora :: Southern Magnolia 21 | 200x Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 770804 | 6014138.0 | 2116340.0 | 37.791861063915796 | -122.394982044679 | (37.7918610639158, -122.394982044679) | |
| 116003 | 116003 | 114410 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 10 GARDENSIDE DR | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999306.0 | 2102458.0 | 37.752908704913395 | -122.445302055175 | (37.7529087049134, -122.445302055175) | ||||||
| 120104 | 120104 | 33790 | Property Tree 7 | Magnolia grandiflora :: Southern Magnolia 21 | 200x Mission St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 770804 | 6014138.0 | 2116340.0 | 37.791861063915796 | -122.394982044679 | (37.7918610639158, -122.394982044679) | |
| 120823 | 120823 | 33791 | Property Tree 7 | Magnolia grandiflora :: Southern Magnolia 21 | 200x Mission St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 770804 | 6014138.0 | 2116340.0 | 37.791861063915796 | -122.394982044679 | (37.7918610639158, -122.394982044679) | |
| 122755 | 122755 | 102079 | Property Tree 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 76 Manchester St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/2012 12:00:00 AM | 3x3 | Permit Number 769729 | 6008162.3 | 2099676.4 | 37.7457726186307 | -122.414478397936 | (37.7457726186307, -122.414478397936) | |
| 128175 | 128175 | 33776 | Property Tree 7 | Magnolia grandiflora :: Southern Magnolia 21 | 200x Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 770804 | 6014138.0 | 2116340.0 | 37.791861063915796 | -122.394982044679 | (37.7918610639158, -122.394982044679) | |
| 128562 | 128562 | 33799 | Property Tree 7 | Magnolia grandiflora :: Southern Magnolia 21 | 200x Mission St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 770804 | 6014138.0 | 2116340.0 | 37.791861063915796 | -122.394982044679 | (37.7918610639158, -122.394982044679) | |
| 142955 | 142955 | 33788 | Property Tree 7 | Magnolia grandiflora :: Southern Magnolia 21 | 200x Mission St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 770804 | 6014138.0 | 2116340.0 | 37.791861063915796 | -122.394982044679 | (37.7918610639158, -122.394982044679) | |
| 146266 | 146266 | 109076 | Property Tree 7 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1137 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | Permit Number 772744 | 6001554.7 | 2087011.6 | 37.7106245477128 | -122.43642021389401 | (37.7106245477128, -122.436420213894) | ||
| 154560 | 154560 | 110181 | Property Tree 7 | Magnolia grandiflora :: Southern Magnolia 21 | 2620 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 1.5x4 | 5999902.8272 | 2114053.62 | 37.784781414472704 | -122.444071244627 | (37.7847814144727, -122.444071244627) |
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");