Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2274 | 2274 | 253006 | Permitted Site 1 | Cercis canadensis 'Forest Pansy' :: Forest Pansy Redbud 172 | 1201 Tennessee St | 15 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 07/10/2017 12:00:00 AM | 3 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | |||
| 2293 | 2293 | 253004 | Permitted Site 1 | Cercis canadensis 'Forest Pansy' :: Forest Pansy Redbud 172 | 1201 Tennessee St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2017 12:00:00 AM | 3 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | |||
| 2295 | 2295 | 253005 | Permitted Site 1 | Cercis canadensis 'Forest Pansy' :: Forest Pansy Redbud 172 | 1201 Tennessee St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2017 12:00:00 AM | 3 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | |||
| 12209 | 12209 | 113082 | Section 143 8 | Cercis canadensis 'Forest Pansy' :: Forest Pansy Redbud 172 | 414 Somerset St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/2015 12:00:00 AM | 3 | 3x3 | 6010030.65327 | 2092539.3572 | 37.726280612054204 | -122.40751477809499 | (37.7262806120542, -122.407514778095) | ||
| 13395 | 13395 | 110744 | Section 143 8 | Cercis canadensis 'Forest Pansy' :: Forest Pansy Redbud 172 | 2300x Mariposa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2015 12:00:00 AM | 3 | 3x3 | 6010545.16814 | 2106015.79361 | 37.76331276399971 | -122.406685416098 | (37.7633127639997, -122.406685416098) | ||
| 13873 | 13873 | 110741 | Section 143 8 | Cercis canadensis 'Forest Pansy' :: Forest Pansy Redbud 172 | 2300x Mariposa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2015 12:00:00 AM | 3 | 3x3 | 6010604.54028 | 2106019.5636299998 | 37.7633264372932 | -122.40648033199498 | (37.7633264372932, -122.406480331995) | ||
| 14294 | 14294 | 110746 | Section 143 8 | Cercis canadensis 'Forest Pansy' :: Forest Pansy Redbud 172 | 2300x Mariposa St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2015 12:00:00 AM | 3 | 3x3 | 6010517.260009999 | 2106013.51672 | 37.7633049506856 | -122.406781781161 | (37.7633049506856, -122.406781781161) | ||
| 15363 | 15363 | 110742 | Section 143 8 | Cercis canadensis 'Forest Pansy' :: Forest Pansy Redbud 172 | 2300x Mariposa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2015 12:00:00 AM | 3 | 3x3 | 6010595.22782 | 2106018.33058 | 37.7633225306396 | -122.40651245401101 | (37.7633225306396, -122.406512454011) | ||
| 26505 | 26505 | 124529 | Undocumented 2 | Cercis canadensis 'Forest Pansy' :: Forest Pansy Redbud 172 | 591 09th Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 7ft | 5993123.8797 | 2111433.88692 | 37.7771992927101 | -122.46733342160299 | (37.7771992927101, -122.467333421603) | |||
| 46026 | 46026 | 124514 | Undocumented 2 | Cercis canadensis 'Forest Pansy' :: Forest Pansy Redbud 172 | 2644 McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5996476.32022 | 2110803.03688 | 37.775660106318895 | -122.455690719205 | (37.7756601063189, -122.455690719205) | |||
| 75423 | 75423 | 225124 | Undocumented 2 | Cercis canadensis 'Forest Pansy' :: Forest Pansy Redbud 172 | 11 Norwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009212.85575 | 2099450.84457 | 37.7452122557381 | -122.41082978617099 | (37.7452122557381, -122.410829786171) | |||
| 75763 | 75763 | 225123 | Undocumented 2 | Cercis canadensis 'Forest Pansy' :: Forest Pansy Redbud 172 | 1 Bird St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 6005996.86725 | 2105736.8865900002 | 37.7622914255266 | -122.422396701747 | (37.7622914255266, -122.422396701747) | |||
| 80835 | 80835 | 47764 | Permitted Site 1 | Cercis canadensis 'Forest Pansy' :: Forest Pansy Redbud 172 | 560 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/2002 12:00:00 AM | Permit Number 45543 | 6002706.57602401 | 2103299.52910824 | 37.7554128710112 | -122.43360237343201 | (37.7554128710112, -122.433602373432) | |||
| 82378 | 82378 | 43153 | Permitted Site 1 | Cercis canadensis 'Forest Pansy' :: Forest Pansy Redbud 172 | 145 Harvard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | Permit Number 42963 | 6006127.87968671 | 2093167.54853876 | 37.727786260936206 | -122.421051074662 | (37.7277862609362, -122.421051074662) | ||
| 99032 | 99032 | 50993 | Permitted Site 1 | Cercis canadensis 'Forest Pansy' :: Forest Pansy Redbud 172 | 142REVISED Rivoli St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/04/2005 12:00:00 AM | Permit Number 47476 | 5998040.17668955 | 2105982.21326987 | 37.7625129768246 | -122.44993346094601 | (37.7625129768246, -122.449933460946) | |||
| 107989 | 107989 | 44120 | Permitted Site 1 | Cercis canadensis 'Forest Pansy' :: Forest Pansy Redbud 172 | 3101 25th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2000 12:00:00 AM | Permit Number 43624 | 6008987.7517307 | 2101549.34835425 | 37.7509616566697 | -122.411756412734 | (37.7509616566697, -122.411756412734) | |||
| 109630 | 109630 | 40454 | Permitted Site 1 | Cercis canadensis 'Forest Pansy' :: Forest Pansy Redbud 172 | 367 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/1999 12:00:00 AM | Permit Number 41539 | 6006432.39897637 | 2097043.87729658 | 37.738446967303794 | -122.420273348712 | (37.7384469673038, -122.420273348712) | ||
| 114138 | 114138 | 40451 | Permitted Site 1 | Cercis canadensis 'Forest Pansy' :: Forest Pansy Redbud 172 | 633 Ellsworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/10/1999 12:00:00 AM | Permit Number 41536 | 6008000.55737724 | 2095962.28514198 | 37.735565390683796 | -122.41477487631501 | (37.7355653906838, -122.414774876315) | ||
| 121270 | 121270 | 44121 | Permitted Site 1 | Cercis canadensis 'Forest Pansy' :: Forest Pansy Redbud 172 | 3101 25th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2000 12:00:00 AM | Permit Number 43624 | 6008987.7517307 | 2101549.34835425 | 37.7509616566697 | -122.411756412734 | (37.7509616566697, -122.411756412734) | |||
| 126140 | 126140 | 44122 | Permitted Site 1 | Cercis canadensis 'Forest Pansy' :: Forest Pansy Redbud 172 | 3101 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2000 12:00:00 AM | Permit Number 43624 | 6008987.7517307 | 2101549.34835425 | 37.7509616566697 | -122.411756412734 | (37.7509616566697, -122.411756412734) | |||
| 130180 | 130180 | 225126 | Undocumented 2 | Cercis canadensis 'Forest Pansy' :: Forest Pansy Redbud 172 | 3276 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009004.73271 | 2099632.84407 | 37.7457003142368 | -122.411562299281 | (37.7457003142368, -122.411562299281) | |||
| 136781 | 136781 | 225128 | Undocumented 2 | Cercis canadensis 'Forest Pansy' :: Forest Pansy Redbud 172 | 4125 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6002350.83715 | 2102354.10683 | 37.7527967763571 | -122.43476502120501 | (37.7527967763571, -122.434765021205) | |||
| 147042 | 147042 | 225127 | Undocumented 2 | Cercis canadensis 'Forest Pansy' :: Forest Pansy Redbud 172 | 479 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6003488.69838 | 2098907.50866 | 37.7433977575005 | -122.430584177336 | (37.7433977575005, -122.430584177336) | |||
| 157744 | 157744 | 225125 | Undocumented 2 | Cercis canadensis 'Forest Pansy' :: Forest Pansy Redbud 172 | 3276 Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009005.1841 | 2099614.1113299998 | 37.74564890359 | -122.41155941515801 | (37.74564890359, -122.411559415158) |
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");