Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qAddress, SiteOrder, PlantDate, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 84396 | 84396 | 90707 | DPW Maintained 3 | Quercus frainetto 'Trump' :: Hungarian Oak 483 | 4332 Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5982199.060847 | 2110334.3438979997 | 37.773543534511205 | -122.505043702231 | (37.7735435345112, -122.505043702231) | |
| 92270 | 92270 | 90716 | DPW Maintained 3 | Quercus frainetto 'Trump' :: Hungarian Oak 483 | 4530 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5981585.539599 | 2110312.077402 | 37.77344628141061 | -122.507164273797 | (37.7734462814106, -122.507164273797) | |
| 96444 | 96444 | 90726 | DPW Maintained 3 | Quercus frainetto 'Trump' :: Hungarian Oak 483 | 4799X Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5980764.077178 | 2110242.237714 | 37.773206105836 | -122.510000589277 | (37.773206105836, -122.510000589277) | |
| 97676 | 97676 | 90709 | DPW Maintained 3 | Quercus frainetto 'Trump' :: Hungarian Oak 483 | 4400 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5981985.083822 | 2110326.5779669997 | 37.7735096198008 | -122.505783291903 | (37.7735096198008, -122.505783291903) | |
| 105740 | 105740 | 90747 | DPW Maintained 3 | Quercus frainetto 'Trump' :: Hungarian Oak 483 | 4331 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5982206.432655 | 2110294.58511 | 37.773434802186706 | -122.505015255541 | (37.7734348021867, -122.505015255541) | |
| 125345 | 125345 | 90733 | DPW Maintained 3 | Quercus frainetto 'Trump' :: Hungarian Oak 483 | 4525 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5981604.755434 | 2110272.748468 | 37.773339427416296 | -122.50709488652001 | (37.7733394274163, -122.50709488652) | |
| 141260 | 141260 | 90748 | DPW Maintained 3 | Quercus frainetto 'Trump' :: Hungarian Oak 483 | 4331 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5982206.432655 | 2110294.58511 | 37.773434802186706 | -122.505015255541 | (37.7734348021867, -122.505015255541) | |
| 144389 | 144389 | 90741 | DPW Maintained 3 | Quercus frainetto 'Trump' :: Hungarian Oak 483 | 4499X Cabrillo St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5981694.399658999 | 2110276.0019259998 | 37.7733536396946 | -122.50678504147801 | (37.7733536396946, -122.506785041478) |
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");