Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qAddress, SiteOrder, PlantDate, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 28357 | 28357 | 31627 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 2430 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/1995 12:00:00 AM | 0 | Permit Number 35144 | 5981797.10260903 | 2098537.8771738 | 37.7411301336904 | -122.50555951218399 | (37.7411301336904, -122.505559512184) | |
| 36904 | 36904 | 31305 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 561 Birch St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1995 12:00:00 AM | 0 | Permit Number 34946 | 6005105.48028119 | 2111430.55673025 | 37.7778745481219 | -122.425884980842 | (37.7778745481219, -122.425884980842) | |
| 134786 | 134786 | 37114 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 4540 Irving St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | 0 | Permit Number 39707 | 5981688.69009077 | 2106263.69511954 | 37.7623366715481 | -122.506507175967 | (37.7623366715481, -122.506507175967) | |
| 135660 | 135660 | 37119 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 4731 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | 0 | Permit Number 39709 | 5981101.19035238 | 2106191.54023256 | 37.762103946482505 | -122.508533725105 | (37.7621039464825, -122.508533725105) | |
| 150825 | 150825 | 31310 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 577 Birch St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1995 12:00:00 AM | 0 | Permit Number 34948 | 6005032.34705274 | 2111420.35666119 | 37.777842407995294 | -122.42613724809999 | (37.7778424079953, -122.4261372481) | |
| 157476 | 157476 | 31309 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 577 Birch St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1995 12:00:00 AM | 0 | Permit Number 34948 | 6005032.34705274 | 2111420.35666119 | 37.777842407995294 | -122.42613724809999 | (37.7778424079953, -122.4261372481) | |
| 164869 | 164869 | 37115 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 4540 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | 0 | Permit Number 39707 | 5981688.69009077 | 2106263.69511954 | 37.7623366715481 | -122.506507175967 | (37.7623366715481, -122.506507175967) | |
| 174810 | 174810 | 31307 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 569 Birch St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1995 12:00:00 AM | 0 | Permit Number 34947 | 6005068.91365842 | 2111425.45669453 | 37.7778584781223 | -122.42601111452801 | (37.7778584781223, -122.426011114528) | |
| 178533 | 178533 | 31308 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 569 Birch St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1995 12:00:00 AM | 0 | Permit Number 34947 | 6005068.91365842 | 2111425.45669453 | 37.7778584781223 | -122.42601111452801 | (37.7778584781223, -122.426011114528) | |
| 180771 | 180771 | 31306 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 561 Birch St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1995 12:00:00 AM | 0 | Permit Number 34946 | 6005105.48028119 | 2111430.55673025 | 37.7778745481219 | -122.425884980842 | (37.7778745481219, -122.425884980842) | |
| 182887 | 182887 | 37113 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 4523 IRVING ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | 0 | Permit Number 39706 | 5981665.2 | 2106185.8 | 37.7621214108202 | -122.506582640723 | (37.7621214108202, -122.506582640723) | |
| 187630 | 187630 | 47074 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 106 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/03/2002 12:00:00 AM | 0 | Permit Number 45062 | 5996796.88091549 | 2112360.28017641 | 37.7799542788822 | -122.454694357616 | (37.7799542788822, -122.454694357616) |
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");