Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 35036 | 35036 | 212841 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 310 Orizaba Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 4ft | 5994040.99289 | 2088811.375 | 37.7151364929198 | -122.46251951595801 | (37.7151364929198, -122.462519515958) | |||
| 39854 | 39854 | 55830 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 170 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/09/1973 12:00:00 AM | 7 | Permit Number 11879 | 5992452.285209999 | 2114337.35562 | 37.7851326311765 | -122.469868105299 | (37.7851326311765, -122.469868105299) | ||
| 52703 | 52703 | 234862 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 147 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007596.66098 | 2097957.46338 | 37.741021008521 | -122.41631257406 | (37.741021008521, -122.41631257406) | |||
| 53631 | 53631 | 244281 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 565 Oak St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6004280.5399 | 2110094.8567 | 37.7741603896423 | -122.42864350060499 | (37.7741603896423, -122.428643500605) | |||
| 53633 | 53633 | 250941 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 237 28th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 5987099.00691 | 2114408.0109900003 | 37.785015739640606 | -122.48839372709699 | (37.7850157396406, -122.488393727097) | |||
| 59264 | 59264 | 52753 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 59@ ROLPH Newton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2006 12:00:00 AM | 7 | Permit Number 48796 | 6000913.35841 | 2088160.63266 | 37.713743072553 | -122.438719109114 | (37.713743072553, -122.438719109114) | |
| 64254 | 64254 | 212842 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 310 Orizaba Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 4ft | 5994041.05729 | 2088814.44589 | 37.715144928561294 | -122.462519515984 | (37.7151449285613, -122.462519515984) | |||
| 72690 | 72690 | 39956 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 370 Teddy Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/1999 12:00:00 AM | 7 | Permit Number 41218 | 6009202.76969 | 2088674.77745 | 37.7156229083553 | -122.41010402697901 | (37.7156229083553, -122.410104026979) | |
| 136460 | 136460 | 250723 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 2701 Lake St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 5987051.3666 | 2114432.8618400004 | 37.7850811931768 | -122.48856037238501 | (37.7850811931768, -122.488560372385) | |||
| 148492 | 148492 | 139132 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1825 POST ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6003396.2273 | 2114143.489 | 37.7852268383201 | -122.431991654473 | (37.7852268383201, -122.431991654473) | |||
| 156075 | 156075 | 135657 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 341 Spruce St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 1ft | 5997133.32261 | 2115106.1258900003 | 37.7875129366126 | -122.453728797662 | (37.7875129366126, -122.453728797662) | |||
| 161191 | 161191 | 184192 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1426 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5984302.3594 | 2105559.8646 | 37.7605576926871 | -122.497415645594 | (37.7605576926871, -122.497415645594) | |||
| 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) | |||
| 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) | |||
| 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) |
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");