Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qAddress, SiteOrder, qSiteInfo, qCaretaker
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 29523 | 29523 | 237237 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 643 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5998666.13007 | 2105451.86711 | 37.7610925752937 | -122.44773034478001 | (37.7610925752937, -122.44773034478) | |||
| 33846 | 33846 | 123222 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 738 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5993211.31332 | 2110438.04706 | 37.7744700313031 | -122.466958548333 | (37.7744700313031, -122.466958548333) | |||
| 34465 | 34465 | 179159 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 113 Seville St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6001727.04807 | 2087313.1468599997 | 37.711462320802205 | -122.435846103423 | (37.7114623208022, -122.435846103423) | |||
| 34716 | 34716 | 237236 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 641 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5998663.85715 | 2105470.4547200003 | 37.761143482317294 | -122.447739543949 | (37.7611434823173, -122.447739543949) | |||
| 34728 | 34728 | 123892 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 285 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5992432.92995 | 2113586.68874 | 37.7830703873676 | -122.469880394252 | (37.7830703873676, -122.469880394252) | |||
| 43899 | 43899 | 214548 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 800 Irving St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 1 | Width 4ft | 5993241.508719999 | 2106665.1801299998 | 37.7641124834295 | -122.46657980664 | (37.7641124834295, -122.46657980664) | |||
| 49492 | 49492 | 135940 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 310 Locust St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5997632.68283 | 2115371.58358 | 37.7882704283935 | -122.452020280013 | (37.7882704283935, -122.452020280013) | |||
| 50428 | 50428 | 237250 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 200 Upper Ter | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5999614.9988400005 | 2106452.87899 | 37.763895290861605 | -122.444520573572 | (37.7638952908616, -122.444520573572) | |||
| 50840 | 50840 | 237249 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 200 Upper Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5999617.47988 | 2106464.70048 | 37.7639278912924 | -122.444512842101 | (37.7639278912924, -122.444512842101) | |||
| 61667 | 61667 | 237251 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 200 Upper Ter | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5999611.7264 | 2106438.84771 | 37.763856577740505 | -122.444530883411 | (37.7638565777405, -122.444530883411) | |||
| 71087 | 71087 | 123089 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 667 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5992530.32341 | 2110923.09875 | 37.775762523428504 | -122.46934951505501 | (37.7757625234285, -122.469349515055) | |||
| 75705 | 75705 | 250820 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 60 Sea View Ter | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 4ft | 5986182.97775 | 2114165.47247 | 37.7842963089586 | -122.49154499381599 | (37.7842963089586, -122.491544993816) | |||
| 75805 | 75805 | 120094 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 749 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5987846.68793 | 2110842.25702 | 37.7752687833001 | -122.485545250327 | (37.7752687833001, -122.485545250327) | |||
| 151564 | 151564 | 179160 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 113 Seville St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6001754.98626 | 2087320.62379 | 37.711484437814896 | -122.43575007652599 | (37.7114844378149, -122.435750076526) | |||
| 152202 | 152202 | 214767 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 333 Pacheco St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 4ft | 5994252.85515 | 2100808.3467 | 37.7480894333884 | -122.462656990837 | (37.7480894333884, -122.462656990837) | |||
| 153946 | 153946 | 250819 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 60 Sea View Ter | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 4ft | 5986191.04243 | 2114164.9353 | 37.7842953053345 | -122.49151705368999 | (37.7842953053345, -122.49151705369) | |||
| 159910 | 159910 | 237243 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 36 Alma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5998389.08312 | 2106273.98135 | 37.7633340563385 | -122.44874774241501 | (37.7633340563385, -122.448747742415) | |||
| 166226 | 166226 | 237252 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 210 Upper Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5999600.48893 | 2106400.12324 | 37.7637496087851 | -122.444566966886 | (37.7637496087851, -122.444566966886) | |||
| 166393 | 166393 | 214768 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 48 Marcela Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5994762.16541 | 2100788.31407 | 37.7480637478616 | -122.460894375369 | (37.7480637478616, -122.460894375369) | |||
| 180388 | 180388 | 246511 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 207 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 4ft | 6005075.21268 | 2099872.36362 | 37.746136778598 | -122.42516705074101 | (37.746136778598, -122.425167050741) | |||
| 182146 | 182146 | 237253 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 210 Upper Ter | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5999591.4299099995 | 2106376.56541 | 37.7636844079359 | -122.444596605852 | (37.7636844079359, -122.444596605852) | |||
| 184686 | 184686 | 237254 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 210 Upper Ter | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5999583.74479 | 2106347.4136 | 37.7636039258024 | -122.444621090805 | (37.7636039258024, -122.444621090805) | |||
| 185212 | 185212 | 119495 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 831 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5986317.41656 | 2110242.64878 | 37.773533209765795 | -122.49079114745199 | (37.7735332097658, -122.490791147452) |
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");