Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 61 | 61 | 226596 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1 Newburg St | 4 | Sidewalk: Property side : Pot 6 | Tree 1 | Private 1 | 4 | Width 4ft | 6002583.45295 | 2099992.19698 | 37.746324733318 | -122.433791792881 | (37.746324733318, -122.433791792881) | |||
| 29485 | 29485 | 139037 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1501 BRODERICK ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6000646.8218 | 2113873.9159999997 | 37.7843304076342 | -122.441484374883 | (37.7843304076342, -122.441484374883) | |||
| 33808 | 33808 | 207309 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 40 Hazelwood Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5996632.84291 | 2093955.22047 | 37.72940919877011 | -122.45393227647699 | (37.7294091987701, -122.453932276477) | |||
| 34662 | 34662 | 117967 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 4545 Anza St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5984550.3085 | 2111733.18458 | 37.7775224048599 | -122.497013781042 | (37.7775224048599, -122.497013781042) | |||
| 42650 | 42650 | 207339 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 436 Joost Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 7ft | 5999175.62485 | 2094995.5474599998 | 37.7324111582276 | -122.445216436593 | (37.7324111582276, -122.445216436593) | |||
| 44643 | 44643 | 177014 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 81 Lamartine St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6002672.79218 | 2094323.6061200001 | 37.7307651596849 | -122.433077929925 | (37.7307651596849, -122.433077929925) | |||
| 44944 | 44944 | 176990 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 763 Morse St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5998584.85135 | 2087137.0809 | 37.7107998882796 | -122.446693649496 | (37.7107998882796, -122.446693649496) | |||
| 53679 | 53679 | 207188 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 212 Hearst Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 5999995.26886 | 2094392.10213 | 37.7308009895535 | -122.442339437931 | (37.7308009895535, -122.442339437931) | ||||
| 55280 | 55280 | 184220 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 3437 Kirkham St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5984130.1355 | 2104934.7045 | 37.758831082518896 | -122.49796511397498 | (37.7588310825189, -122.497965113975) | |||
| 58147 | 58147 | 207303 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 59 Hazelwood Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5996585.5854400005 | 2094033.89672 | 37.7296225152507 | -122.45410132920601 | (37.7296225152507, -122.454101329206) | |||
| 58753 | 58753 | 185611 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2241 Quintara St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5986448.3245 | 2100932.1027 | 37.747976665787895 | -122.489653506406 | (37.7479766657879, -122.489653506406) | |||
| 59479 | 59479 | 207337 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 114 Melrose Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 10ft | 5999331.40158 | 2095537.8442099998 | 37.7339090681372 | -122.44471684701901 | (37.7339090681372, -122.444716847019) | |||
| 62912 | 62912 | 177003 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 746 Olmstead St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6009476.70201 | 2090586.0760400002 | 37.720886288652004 | -122.409291987754 | (37.720886288652, -122.409291987754) | |||
| 63394 | 63394 | 119482 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 426 33rd Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5985642.69106 | 2113025.08426 | 37.781133543390204 | -122.49333012331499 | (37.7811335433902, -122.493330123315) | |||
| 70570 | 70570 | 207314 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1570 07th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5994021.19813 | 2104903.51705 | 37.759320377550395 | -122.46375523571999 | (37.7593203775504, -122.46375523572) | |||
| 73346 | 73346 | 226593 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 4301 26th St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 8ft | 6001851.9880099995 | 2100572.11343 | 37.7478755125637 | -122.43636260477301 | (37.7478755125637, -122.436362604773) | |||
| 75227 | 75227 | 185264 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2147 Vicente St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5986264.4244 | 2097520.2042 | 37.7385977678327 | -122.490038499473 | (37.7385977678327, -122.490038499473) | |||
| 75474 | 75474 | 207342 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 538 Joost Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 5998499.20735 | 2095008.2855900002 | 37.7324075007117 | -122.447555877206 | (37.7324075007117, -122.447555877206) | ||||
| 77335 | 77335 | 207193 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 312 Hearst Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5999342.629819999 | 2094390.1530400002 | 37.7307584183688 | -122.444595567153 | (37.7307584183688, -122.444595567153) | |||
| 94485 | 94485 | 87363 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 3401 Taraval St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/08/2008 12:00:00 AM | 3x3 | Permit Number 50345 | 5982691.0 | 2098770.0 | 37.741820045233396 | -122.502485963998 | (37.7418200452334, -122.502485963998) | ||
| 125304 | 125304 | 177013 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 78 Lamartine St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6002644.59595 | 2094315.3545 | 37.7307409031583 | -122.433174819278 | (37.7307409031583, -122.433174819278) | |||
| 130678 | 130678 | 116712 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1400 Baker St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6000214.6483 | 2113835.6397 | 37.784200680215605 | -122.44297678993999 | (37.7842006802156, -122.44297678994) | |||
| 151291 | 151291 | 246438 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 498 Duncan St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | Width 3ft | 6003357.50799 | 2099800.56839 | 37.745842459268296 | -122.431101528529 | (37.7458424592683, -122.431101528529) | |||
| 160296 | 160296 | 207175 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 451 Ulloa St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5995328.909969999 | 2098238.4831 | 37.7410951414231 | -122.458750035501 | (37.7410951414231, -122.458750035501) | |||
| 161425 | 161425 | 207217 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 201 Judson Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 1ft | 5998700.58194 | 2093477.09847 | 37.7282147273036 | -122.44674954686701 | (37.7282147273036, -122.446749546867) | |||
| 161773 | 161773 | 226598 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 4222 26th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002345.605769999 | 2100643.12019 | 37.7480985156327 | -122.434660776296 | (37.7480985156327, -122.434660776296) | |||
| 172685 | 172685 | 95711 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 277 Athens St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 6 | 3x3 | Permit Number 767467 | 6004408.66119 | 2091673.84489 | 37.7235878160995 | -122.426888112994 | (37.7235878160995, -122.426888112994) |
| 175015 | 175015 | 207318 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 20 Woodside Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 5995646.386969999 | 2100270.85159 | 37.746693763801204 | -122.457799351359 | (37.7466937638012, -122.457799351359) | |||
| 178613 | 178613 | 176988 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 184 Mount Vernon Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 5998975.21291 | 2089361.52774 | 37.7169300054919 | -122.445504324886 | (37.7169300054919, -122.445504324886) | ||||
| 179463 | 179463 | 207199 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 580 Hearst Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5997518.57205 | 2094417.76245 | 37.7307299736956 | -122.450903581047 | (37.7307299736956, -122.450903581047) |
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");