Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 509 | 509 | 38234 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 0 16th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/1998 12:00:00 AM | Permit Number 40352 | ||||||||
| 5586 | 5586 | 43016 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2000 12:00:00 AM | Permit Number 42880 | |||||||||
| 9825 | 9825 | 46928 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1 Pacheco St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/2016 12:00:00 AM | 3 | Permit Number 779184 | 5995168.47040897 | 2099126.50126016 | 37.743524195830396 | -122.459369067857 | (37.7435241958304, -122.459369067857) | ||
| 12798 | 12798 | 34070 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 955 Kennedy Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37965 | ||||||||
| 31008 | 31008 | 49769 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 333 Schwerin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2003 12:00:00 AM | 4 | Permit Number 46559 | 6008658.89925 | 2086391.1157900002 | 37.70932194511621 | -122.411822622426 | (37.7093219451162, -122.411822622426) | |
| 41412 | 41412 | 192412 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 650 Rhode Island St | 4 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6011780.95507 | 2105331.83928 | 37.761503842456605 | -122.402363116082 | (37.7615038424566, -122.402363116082) | |||
| 43922 | 43922 | 176514 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 154 Brookdale Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 6006291.2518 | 2087400.97553 | 37.7119616963423 | -122.420077226985 | (37.7119616963423, -122.420077226985) | |||
| 67076 | 67076 | 192420 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2 Sierra St | 4 | : 4 | Tree 1 | Private 1 | 8 | Width 5ft | 6013708.5618199995 | 2104154.58233 | 37.7583787675789 | -122.395613785069 | (37.7583787675789, -122.395613785069) | |||
| 75133 | 75133 | 128874 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1270 Clay St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 6008580.96851 | 2116980.96928 | 37.7933104368651 | -122.41425481461799 | (37.7933104368651, -122.414254814618) | |||
| 79560 | 79560 | 7700 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 640 Francisco St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 6x6 | 6008187.1407969 | 2121043.7620312 | 37.804443723648895 | -122.415905321467 | (37.8044437236489, -122.415905321467) | |||
| 85572 | 85572 | 115126 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 499X MAIN ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 6015842.0 | 2114626.0 | 37.7872494168956 | -122.388966430338 | (37.7872494168956, -122.388966430338) | ||||
| 87311 | 87311 | 29766 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 570 Francisco St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4x4 | 6008571.0386595 | 2121096.2836166 | 37.8046095098754 | -122.414580523895 | (37.8046095098754, -122.414580523895) | |||
| 94395 | 94395 | 105962 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 10X Sierra St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5x9 | 6013706.37383 | 2104134.52437 | 37.758323571072204 | -122.39561994684401 | (37.7583235710722, -122.395619946844) | ||||
| 110418 | 110418 | 29761 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 500 Francisco St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6008886.831703201 | 2121139.4877643995 | 37.804745874094294 | -122.4134907456 | (37.8047458740943, -122.4134907456) | |||
| 118833 | 118833 | 98259 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2800X 16TH ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6008057.0 | 2106814.0 | 37.7653649274264 | -122.415347709739 | (37.7653649274264, -122.415347709739) | |||
| 121618 | 121618 | 95169 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 195x BARTLETT ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 54079 | 6006751.0 | 2102668.0 | 37.7539074858503 | -122.41957069165701 | (37.7539074858503, -122.419570691657) | |||
| 123727 | 123727 | 142340 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 520 Central Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5999729.6682 | 2110321.6281 | 37.774524444251206 | -122.444402018718 | (37.7745244442512, -122.444402018718) | |||
| 124344 | 124344 | 36067 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1398 Bryant St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/1998 12:00:00 AM | Permit Number 39186 | 6009394.0 | 2107812.0 | 37.76818025927739 | -122.410793808029 | (37.7681802592774, -122.410793808029) | |||
| 129468 | 129468 | 32983 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 618 Texas St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | Permit Number 37296 | 6013812.07366772 | 2104214.5102771 | 37.7585490739971 | -122.395259990599 | (37.7585490739971, -122.395259990599) | ||
| 139408 | 139408 | 30918 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 212 Granada Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/13/1995 12:00:00 AM | Permit Number 34735 | 5995669.33198455 | 2091339.19890433 | 37.722170938941005 | -122.45707405071501 | (37.722170938941, -122.457074050715) | |||
| 144515 | 144515 | 10133 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 899 Guerrero St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/04/1992 12:00:00 AM | 6 | 3X3 | 6005711.897824 | 2103735.5027185003 | 37.756780015162896 | -122.42324003225401 | (37.7567800151629, -122.423240032254) | ||
| 169474 | 169474 | 176504 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 178 Brookdale Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 6005618.83947 | 2087124.32667 | 37.711164168567 | -122.422381633625 | (37.711164168567, -122.422381633625) | |||
| 178781 | 178781 | 225940 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 183 Bartlett St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6006723.95695 | 2102704.663 | 37.7540066307184 | -122.419666814188 | (37.7540066307184, -122.419666814188) | |||
| 181038 | 181038 | 176508 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 150 Brookdale Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 50 | Width 6ft | 6005731.293880001 | 2087351.0784200002 | 37.71179312382829 | -122.422009060692 | (37.7117931238283, -122.422009060692) | |||
| 181544 | 181544 | 225967 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 3599 24th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6005877.128169999 | 2101963.64024 | 37.7519242145407 | -122.42254270219601 | (37.7519242145407, -122.422542702196) | |||
| 187028 | 187028 | 176511 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 127 Brookdale Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 6ft | 6006104.31545 | 2087436.5206900002 | 37.712048761508605 | -122.42072585491199 | (37.7120487615086, -122.420725854912) |
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");