Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qAddress, SiteOrder, PlantDate, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 73 | 73 | 65479 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1051 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1997 12:00:00 AM | 10 | 3x3 | Permit Number 28361 | 6008468.497880001 | 2115537.43749 | 37.789340533487795 | -122.41454177659901 | (37.7893405334878, -122.414541776599) |
| 31915 | 31915 | 64862 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 74 Almaden Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1989 12:00:00 AM | 10 | Permit Number 25878 | 5995911.37415 | 2112317.03505 | 37.779784708505105 | -122.45775457163401 | (37.7797847085051, -122.457754571634) | |
| 34567 | 34567 | 67434 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 772 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/1992 12:00:00 AM | 10 | Permit Number 30936 | 5989473.46135 | 2110070.59902 | 37.7732446703113 | -122.479861453207 | (37.7732446703113, -122.479861453207) | ||
| 39049 | 39049 | 51052 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 326 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/09/2004 12:00:00 AM | 10 | Permit Number 47522 | 5987167.50591 | 2113744.97071 | 37.7831992171669 | -122.488108007262 | (37.7831992171669, -122.488108007262) | ||
| 40854 | 40854 | 64351 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2829 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/13/1988 12:00:00 AM | 10 | Permit Number 25187 | 5999331.75802 | 2118714.3640900003 | 37.797545994610296 | -122.44638235637501 | (37.7975459946103, -122.446382356375) | ||
| 41980 | 41980 | 54425 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 664 Carolina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/1972 12:00:00 AM | 10 | Permit Number 10199 | 6012377.17429 | 2104832.12129 | 37.760164992032706 | -122.40026592765498 | (37.7601649920327, -122.400265927655) | ||
| 56028 | 56028 | 34878 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3009 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/09/1997 12:00:00 AM | 10 | Permit Number 38491 | 6000242.0296 | 2115774.84436 | 37.789526793876206 | -122.443021372241 | (37.7895267938762, -122.443021372241) | ||
| 58895 | 58895 | 37862 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 286 Moscow St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/07/1998 12:00:00 AM | 10 | Permit Number 40149 | 6004552.23885 | 2091481.5698 | 37.7230679881701 | -122.426378106562 | (37.7230679881701, -122.426378106562) | |
| 65573 | 65573 | 64859 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 45 Almaden Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/1993 12:00:00 AM | 10 | Permit Number 25875 | 5995863.10867 | 2112429.78445 | 37.7800915155758 | -122.457929703566 | (37.7800915155758, -122.457929703566) | |
| 68159 | 68159 | 32124 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 70 Sharon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1995 12:00:00 AM | 10 | Permit Number 35486 | 6003846.92621 | 2106756.5408799998 | 37.764969637151 | -122.429905274625 | (37.764969637151, -122.429905274625) | |
| 70449 | 70449 | 42715 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 43 Pomona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 10 | Permit Number 42728 | 6014158.74539 | 2094459.1278900001 | 37.731782116644794 | -122.393378351035 | (37.7317821166448, -122.393378351035) | |
| 74449 | 74449 | 41937 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 516 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | 10 | Permit Number 42296 | 5994398.69166 | 2111972.43189 | 37.7787515041629 | -122.462962556291 | (37.7787515041629, -122.462962556291) | |
| 116241 | 116241 | 48973 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1409 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/05/2002 12:00:00 AM | 10 | 3x3 | Permit Number 46160 | 5992699.25598435 | 2105862.87116543 | 37.7618782478409 | -122.468396910406 | (37.7618782478409, -122.468396910406) |
| 126623 | 126623 | 56348 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 111X Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/2009 12:00:00 AM | 10 | 3x3 | Permit Number 52603 | 6002684.86057117 | 2105294.05500137 | 37.7608881281181 | -122.433820024128 | (37.7608881281181, -122.433820024128) |
| 126699 | 126699 | 51677 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1398X 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/13/2005 12:00:00 AM | 10 | 3x3 | Permit Number 47956 | 5993492.40184836 | 2105988.6022895 | 37.762269253020705 | -122.46566288928301 | (37.7622692530207, -122.465662889283) | |
| 139783 | 139783 | 39603 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 636 Wisconsin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | 10 | Permit Number 41005 | 6012670.17637 | 2104503.85017 | 37.759279965615704 | -122.39922952194401 | (37.7592799656157, -122.399229521944) | |
| 145594 | 145594 | 46257 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1409 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2002 12:00:00 AM | 10 | 3x3 | Permit Number 44541 | 5992686.9 | 2105815.5 | 37.7617474653886 | -122.46843619791001 | (37.7617474653886, -122.46843619791) | |
| 168755 | 168755 | 41936 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 684 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | 10 | 3x9 | Permit Number 42295 | 5994746.112840001 | 2110871.9454099997 | 37.7757498669665 | -122.461680887642 | (37.7757498669665, -122.461680887642) |
| 172079 | 172079 | 41946 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 690 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | 10 | Permit Number 42304 | 5993510.89143 | 2110826.8547 | 37.775554879409206 | -122.46595051642299 | (37.7755548794092, -122.465950516423) | |
| 172523 | 172523 | 62479 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 35 Delano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2000 12:00:00 AM | 10 | Permit Number 31826 | 6000682.25846 | 2093099.2989400001 | 37.7272903816351 | -122.43987175399499 | (37.7272903816351, -122.439871753995) | |
| 173356 | 173356 | 38235 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 81 Langton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/1998 12:00:00 AM | 10 | Permit Number 40353 | 6010102.82343 | 2110824.83764 | 37.7764925318532 | -122.408554604827 | (37.7764925318532, -122.408554604827) | ||
| 173547 | 173547 | 37340 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 131 Brunswick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | 10 | Permit Number 39848 | 6000626.60293 | 2087367.0099799999 | 37.7115476439893 | -122.43965337791799 | (37.7115476439893, -122.439653377918) |
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");