Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25925 | 25925 | 206997 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1290 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5992719.48539 | 2106665.14578 | 37.7640822509305 | -122.46838531523998 | (37.7640822509305, -122.46838531524) | |||
| 26796 | 26796 | 47678 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 536 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/2002 12:00:00 AM | 9 | Permit Number 45462 | 6014348.84456 | 2104603.39752 | 37.7596467118443 | -122.393430795897 | (37.7596467118443, -122.393430795897) | |
| 32789 | 32789 | 227562 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 4567 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6000777.25512 | 2104640.3736 | 37.7589848458951 | -122.440370692454 | (37.7589848458951, -122.440370692454) | |||
| 38388 | 38388 | 227552 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 4058 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6002586.755890001 | 2105341.84005 | 37.7610137667981 | -122.43416274071998 | (37.7610137667981, -122.43416274072) | |||
| 40644 | 40644 | 227097 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1650 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009272.782269999 | 2099754.5666099996 | 37.7460495695343 | -122.41064401410601 | (37.7460495695343, -122.410644014106) | |||
| 44029 | 44029 | 227126 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1689 Noe St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 4ft | 6003395.21055 | 2098417.4445 | 37.742046857971 | -122.430872467617 | (37.742046857971, -122.430872467617) | |||
| 47841 | 47841 | 207013 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 178 Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6000221.87075 | 2094376.8430299999 | 37.7307720044131 | -122.44155494671101 | (37.7307720044131, -122.441554946711) | |||
| 51569 | 51569 | 200835 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1101 16th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6013058.6169 | 2107038.7182 | 37.7662617940431 | -122.398063928568 | (37.7662617940431, -122.398063928568) | |||
| 53294 | 53294 | 79640 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 168 Orsi Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2002 12:00:00 AM | 9 | 6012982.50067 | 2092948.34875 | 37.727568405236 | -122.397338990501 | (37.727568405236, -122.397338990501) | ||
| 61295 | 61295 | 42963 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 560 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2000 12:00:00 AM | 9 | Permit Number 42852 | 5981647.94996 | 2111905.75128 | 37.7778257173711 | -122.50706663602502 | (37.7778257173711, -122.507066636025) | ||
| 66808 | 66808 | 52362 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1438ASHINGTON Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/2005 12:00:00 AM | 9 | Permit Number 48498 | 6007994.9364599995 | 2117377.7611599998 | 37.7943669936906 | -122.416310648633 | (37.7943669936906, -122.416310648633) | |
| 123811 | 123811 | 191221 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 101 Mississippi St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6014015.897890001 | 2106592.9178299997 | 37.7650909952748 | -122.39472162882099 | (37.7650909952748, -122.394721628821) | |||
| 133941 | 133941 | 227561 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 84 Seward St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 3ft | 6000738.66154 | 2104570.78605 | 37.7587915779822 | -122.44049917592 | (37.7587915779822, -122.44049917592) | |||
| 153522 | 153522 | 50036 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 73 University St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | 9 | Permit Number 46766 | 6007832.621069999 | 2093714.43935 | 37.729383856755796 | -122.41519642998199 | (37.7293838567558, -122.415196429982) | |
| 158124 | 158124 | 52937 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 436@THERESA Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2006 12:00:00 AM | 9 | Permit Number 48924 | 6002078.69882 | 2093873.61529 | 37.729495870020706 | -122.43509962926599 | (37.7294958700207, -122.435099629266) | |
| 161226 | 161226 | 129375 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 454 Walnut St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5998637.857999999 | 2115126.2699599997 | 37.7876543864995 | -122.448524881439 | (37.7876543864995, -122.448524881439) | |||
| 170912 | 170912 | 227554 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 359 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6001158.33464 | 2104306.33401 | 37.7580893450524 | -122.439028803251 | (37.7580893450524, -122.439028803251) | |||
| 187717 | 187717 | 227565 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 290 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6001097.22568 | 2104712.62438 | 37.7592014422066 | -122.43926926488501 | (37.7592014422066, -122.439269264885) |
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");