Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 166626 | 166626 | 250938 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 239 28th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 5987099.7017 | 2114350.08641 | 37.7848567358866 | -122.48838706491101 | (37.7848567358866, -122.488387064911) | |||
| 167550 | 167550 | 135661 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 3130 Lyon St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 7ft | 5999056.0318599995 | 2119564.3251400003 | 37.7998640079851 | -122.447397647785 | (37.7998640079851, -122.447397647785) | |||
| 169930 | 169930 | 184767 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1301 Sunset Blvd | 24 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984672.982999999 | 2106076.3882 | 37.7619976377511 | -122.496171956525 | (37.7619976377511, -122.496171956525) | |||
| 170649 | 170649 | 247388 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 317 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6002209.9073 | 2109723.8575 | 37.7730243156057 | -122.435779625251 | (37.7730243156057, -122.435779625251) | |||
| 170730 | 170730 | 212836 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 410 Faxon Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 1ft | 5994790.20141 | 2091321.95288 | 37.7220730592142 | -122.46011172240101 | (37.7220730592142, -122.460111722401) | |||
| 171566 | 171566 | 234855 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 118 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007577.520219999 | 2098081.02135 | 37.7413591949664 | -122.41638750560301 | (37.7413591949664, -122.416387505603) | |||
| 171830 | 171830 | 195952 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1700 Bancroft Ave | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 10ft | 6013787.58166 | 2092619.66724 | 37.7267107029201 | -122.39453279185801 | (37.7267107029201, -122.394532791858) | |||
| 171874 | 171874 | 185357 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 2601 Sunset Blvd | 82 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985023.8956 | 2096938.833 | 37.736928958988706 | -122.494284751295 | (37.7369289589887, -122.494284751295) | |||
| 171989 | 171989 | 184772 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1301 Sunset Blvd | 32 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984713.9927 | 2106010.1272 | 37.7618181056778 | -122.49602523353201 | (37.7618181056778, -122.496025233532) | |||
| 173730 | 173730 | 186617 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1501 Sunset Blvd | 88 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984770.9865 | 2104379.1354 | 37.757343195198004 | -122.495707807467 | (37.757343195198, -122.495707807467) | |||
| 174475 | 174475 | 250944 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 237 28th Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 5987098.95404 | 2114369.2776099998 | 37.784909385797796 | -122.48839106242501 | (37.7849093857978, -122.488391062425) | |||
| 174573 | 174573 | 139154 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1881 POST ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6003238.0594 | 2114116.0648 | 37.7851425702811 | -122.432536906804 | (37.7851425702811, -122.432536906804) | |||
| 175065 | 175065 | 244282 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 563 Oak St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6004300.7385 | 2110098.3052 | 37.7741710014741 | -122.42857387592699 | (37.7741710014741, -122.428573875927) | |||
| 178980 | 178980 | 35843 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 425 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1998 12:00:00 AM | 13 | Permit Number 39070 | 6002146.05039 | 2091115.78994 | 37.721927328560206 | -122.434669664286 | (37.7219273285602, -122.434669664286) | |
| 179998 | 179998 | 139149 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1865 POST ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6003298.6479 | 2114126.9069 | 37.7851757756125 | -122.43232806423201 | (37.7851757756125, -122.432328064232) | |||
| 181063 | 181063 | 246079 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 663 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5998980.117000001 | 2108420.232 | 37.769260899787 | -122.446858004242 | (37.769260899787, -122.446858004242) | |||
| 181414 | 181414 | 234853 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 590 York St | 9 | : 4 | Tree 1 | Private 1 | 8 | Width 2ft | 6009779.5176 | 2105520.26331 | 37.7619092828952 | -122.40929859056101 | (37.7619092828952, -122.409298590561) | |||
| 182029 | 182029 | 234858 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 115 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6007085.582140001 | 2098738.0087099997 | 37.743135459435 | -122.41813502591002 | (37.743135459435, -122.41813502591) | |||
| 182107 | 182107 | 234866 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 3781 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6001808.66537 | 2106354.74749 | 37.7637507715923 | -122.436926328595 | (37.7637507715923, -122.436926328595) | |||
| 182921 | 182921 | 234863 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 116 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007043.4928 | 2098718.4405900002 | 37.7430793606347 | -122.418279172852 | (37.7430793606347, -122.418279172852) | |||
| 183634 | 183634 | 195950 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1700 Bancroft Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 10ft | 6013817.51149 | 2092596.07971 | 37.726647600184 | -122.394427673718 | (37.726647600184, -122.394427673718) | |||
| 185531 | 185531 | 186659 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1401 Sunset Blvd | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984689.126 | 2105565.0657 | 37.7605946348949 | -122.49607840021002 | (37.7605946348949, -122.49607840021) | |||
| 185748 | 185748 | 212847 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1269 02nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5995455.86214 | 2106863.98273 | 37.7647858787024 | -122.45893544780701 | (37.7647858787024, -122.458935447807) | |||
| 186487 | 186487 | 187098 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 2600 Sunset Blvd | 34 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985154.9931 | 2097192.9905 | 37.737634478481205 | -122.49385021979401 | (37.7376344784812, -122.493850219794) | |||
| 186707 | 186707 | 244545 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1921 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5997768.4306 | 2109193.5582 | 37.771314959230295 | -122.45110492040001 | (37.7713149592303, -122.4511049204) | |||
| 188608 | 188608 | 139128 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1601 POST ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6004473.6733 | 2114291.0091 | 37.7856929151772 | -122.428274539531 | (37.7856929151772, -122.428274539531) | |||
| 188863 | 188863 | 234852 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 590 York St | 6 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 6009778.46002 | 2105547.1996400002 | 37.7619831846864 | -122.40930414927799 | (37.7619831846864, -122.409304149278) |
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");