Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 77547 | 77547 | 102068 | Permitted Site 1 | Acacia baileyana 'Purpurea' :: Purple-leaf Acacia 455 | 50X Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/2012 12:00:00 AM | 3x3 | Permit Number 52614 | 6006867.4 | 2099433.7 | 37.745033388538204 | -122.41893877466299 | (37.7450333885382, -122.418938774663) | |
| 79884 | 79884 | 24198 | DPW Maintained 3 | Acacia baileyana 'Purpurea' :: Purple-leaf Acacia 455 | 55X Whitney Young Cir | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/29/1990 12:00:00 AM | 12 | 3x3 | 6016412.1769872 | 2096105.6107163997 | 37.736427970914 | -122.38570241578998 | (37.736427970914, -122.38570241579) | ||
| 80167 | 80167 | 24845 | Permitted Site 1 | Acacia baileyana 'Purpurea' :: Purple-leaf Acacia 455 | 200X Alemany Blvd | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 01/29/1998 12:00:00 AM | 25 | 3X3 | 6009416.6826304 | 2095906.0445619 | 37.735490432624104 | -122.409874802768 | (37.7354904326241, -122.409874802768) | ||
| 82521 | 82521 | 24827 | Permitted Site 1 | Acacia baileyana 'Purpurea' :: Purple-leaf Acacia 455 | 200X Alemany Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 01/29/1998 12:00:00 AM | 20 | 3X3 | 6009416.6826304 | 2095906.0445619 | 37.735490432624104 | -122.409874802768 | (37.7354904326241, -122.409874802768) | ||
| 82612 | 82612 | 102072 | Permitted Site 1 | Acacia baileyana 'Purpurea' :: Purple-leaf Acacia 455 | 50X Coleridge St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/2012 12:00:00 AM | 3x3 | Permit Number 52614 | 6006867.4 | 2099433.7 | 37.745033388538204 | -122.41893877466299 | (37.7450333885382, -122.418938774663) | |
| 94975 | 94975 | 82122 | Permitted Site 1 | Acacia baileyana 'Purpurea' :: Purple-leaf Acacia 455 | 31 Molimo Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/25/2007 12:00:00 AM | 3x3 | Permit Number 49839 | 5998914.45704637 | 2096524.19274508 | 37.7365935453433 | -122.44622927318999 | (37.7365935453433, -122.44622927319) | ||
| 96361 | 96361 | 61345 | Permitted Site 1 | Acacia baileyana 'Purpurea' :: Purple-leaf Acacia 455 | 468 Hickory St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/17/1984 12:00:00 AM | 8 | 3x3 | Permit Number 773068 | 6004726.89480624 | 2110389.71520544 | 37.77499524996821 | -122.427120485635 | (37.7749952499682, -122.427120485635) | |
| 99270 | 99270 | 93028 | Permitted Site 1 | Acacia baileyana 'Purpurea' :: Purple-leaf Acacia 455 | 70X Quartz Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/13/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53143 | 5998951.5 | 2099827.0 | 37.7456643777065 | -122.446338725273 | (37.7456643777065, -122.446338725273) | |
| 106071 | 106071 | 53834 | Permitted Site 1 | Acacia baileyana 'Purpurea' :: Purple-leaf Acacia 455 | 1355 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/2015 12:00:00 AM | 3 | Permit Number 775431 | 5999512.42994465 | 2108042.68116702 | 37.768254636062295 | -122.44498962236099 | (37.7682546360623, -122.444989622361) | ||
| 108345 | 108345 | 109899 | Permitted Site 1 | Acacia baileyana 'Purpurea' :: Purple-leaf Acacia 455 | 1690 21st Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775091 | 5989706.3 | 2103886.3 | 37.7562777848379 | -122.478603696639 | (37.7562777848379, -122.478603696639) |
| 110529 | 110529 | 53941 | Permitted Site 1 | Acacia baileyana 'Purpurea' :: Purple-leaf Acacia 455 | 3865 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/1993 12:00:00 AM | Permit Number 53142 | 6002700.77086336 | 2102956.40295411 | 37.754470399038404 | -122.433597928435 | (37.7544703990384, -122.433597928435) | |||
| 120599 | 120599 | 109900 | Permitted Site 1 | Acacia baileyana 'Purpurea' :: Purple-leaf Acacia 455 | 1446X Moraga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775091 | 5989605.13452 | 2105488.6941 | 37.7606716554325 | -122.479070764462 | (37.7606716554325, -122.479070764462) |
| 122030 | 122030 | 56350 | Permitted Site 1 | Acacia baileyana 'Purpurea' :: Purple-leaf Acacia 455 | 147 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/29/2014 12:00:00 AM | 20 | 3x3 | Permit Number 772625 | 6002703.1613424 | 2105045.65789627 | 37.760207128059704 | -122.433738975969 | (37.7602071280597, -122.433738975969) | |
| 125883 | 125883 | 23029 | Permitted Site 1 | Acacia baileyana 'Purpurea' :: Purple-leaf Acacia 455 | 3 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/08/1998 12:00:00 AM | 20 | 3X3 | 6006356.28069 | 2104163.0328 | 37.75799025851121 | -122.42104187029 | (37.7579902585112, -122.42104187029) | ||
| 126690 | 126690 | 93027 | Permitted Site 1 | Acacia baileyana 'Purpurea' :: Purple-leaf Acacia 455 | 70X Quartz Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/13/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53143 | 5998951.5 | 2099827.0 | 37.7456643777065 | -122.446338725273 | (37.7456643777065, -122.446338725273) | |
| 138953 | 138953 | 63523 | DPW Maintained 3 | Acacia baileyana 'Purpurea' :: Purple-leaf Acacia 455 | 929 VALENCIA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/12/2015 03:22:00 PM | 3 | 3x3 | Permit Number 24134 | 6006356.3 | 2104163.0 | 37.757990169538495 | -122.42104180117902 | (37.7579901695385, -122.421041801179) | |
| 140482 | 140482 | 87226 | Permitted Site 1 | Acacia baileyana 'Purpurea' :: Purple-leaf Acacia 455 | 256 16th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/14/2008 12:00:00 AM | 3x3 | Permit Number 50265 | 5990916.5 | 2113685.8 | 37.7832547476295 | -122.475133806963 | (37.7832547476295, -122.475133806963) | |||
| 140699 | 140699 | 27699 | Permitted Site 1 | Acacia baileyana 'Purpurea' :: Purple-leaf Acacia 455 | 2480 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2002 12:00:00 AM | 9 | 3X3 | 6002931.52986 | 2115871.3895 | 37.789944858134 | -122.43372290238001 | (37.789944858134, -122.43372290238) | ||
| 142404 | 142404 | 24196 | DPW Maintained 3 | Acacia baileyana 'Purpurea' :: Purple-leaf Acacia 455 | 55X Whitney Young Cir | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/04/1998 12:00:00 AM | 6 | 3x3 | 6016412.1769872 | 2096105.6107163997 | 37.736427970914 | -122.38570241578998 | (37.736427970914, -122.38570241579) | ||
| 146199 | 146199 | 17226 | DPW Maintained 3 | Acacia baileyana 'Purpurea' :: Purple-leaf Acacia 455 | 1884X Alemany Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3X3 | 6001017.031830001 | 2091170.8979900002 | 37.722014482536295 | -122.438576333542 | (37.7220144825363, -122.438576333542) |
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");