Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 28126 | 28126 | 125863 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 150 Francisco St | 11 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6010483.33133 | 2121337.12789 | 37.8053780572129 | -122.407979816633 | (37.8053780572129, -122.407979816633) | ||||
| 40486 | 40486 | 220806 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1300 San Jose Ave | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | Width 6ft | 6003687.50559 | 2095763.3116799998 | 37.7347757726743 | -122.42967254985099 | (37.7347757726743, -122.429672549851) | |||
| 60970 | 60970 | 188944 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 398 Quint St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6015253.92457 | 2099115.9674299997 | 37.7446296326645 | -122.389917233688 | (37.7446296326645, -122.389917233688) | ||||
| 67558 | 67558 | 111864 | Significant Tree 6 | Callistemon citrinus :: Lemon Bottlebrush 28 | 45 Allston Way | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 06/26/2015 12:00:00 AM | 3 | Permit Number 775591 | 5994228.4 | 2098418.0 | 37.741524734078205 | -122.46256819082701 | (37.7415247340782, -122.462568190827) | ||
| 73377 | 73377 | 188946 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 398 Quint St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 6015180.727109999 | 2099016.7469900004 | 37.7443531342865 | -122.390163407814 | (37.7443531342865, -122.390163407814) | ||||
| 87654 | 87654 | 99961 | Property Tree 7 | Callistemon citrinus :: Lemon Bottlebrush 28 | 537 Valley St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/25/2012 12:00:00 AM | Permit Number 768880 | 6002459.0 | 2099152.0 | 37.7440106863694 | -122.434162082356 | (37.7440106863694, -122.434162082356) | |||
| 99835 | 99835 | 104913 | Significant Tree 6 | Callistemon citrinus :: Lemon Bottlebrush 28 | 608 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990401.0 | 2090562.0 | 37.719732984351396 | -122.475228499286 | (37.7197329843514, -122.475228499286) | |||||
| 132366 | 132366 | 204571 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 406 Baden St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6000766.76898 | 2095333.10408 | 37.7334287051602 | -122.43973968405199 | (37.7334287051602, -122.439739684052) | ||||
| 157703 | 157703 | 250210 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 212 Union St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | Width 0ft | 6011753.31095 | 2119788.98637 | 37.8011982592529 | -122.40347587511101 | (37.8011982592529, -122.403475875111) | |||
| 172994 | 172994 | 188945 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 398 Quint St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 6015211.76442 | 2099058.69599 | 37.744470038975 | -122.39005901630699 | (37.744470038975, -122.390059016307) | ||||
| 173590 | 173590 | 250208 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 212 Union St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | Width 0ft | 6011783.4083 | 2119794.63457 | 37.8012154488822 | -122.403372122131 | (37.8012154488822, -122.403372122131) | |||
| 181228 | 181228 | 217834 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2 Cranleigh Dr | 25 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 5991396.17639 | 2095791.9232400001 | 37.734150681791796 | -122.472169581465 | (37.7341506817918, -122.472169581465) | ||||
| 185057 | 185057 | 220805 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1300 San Jose Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | Width 8ft | 6003673.53965 | 2095753.0634 | 37.7347468423996 | -122.429720104197 | (37.7347468423996, -122.429720104197) | |||
| 185701 | 185701 | 246440 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 485 Duncan St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6003368.11948 | 2099777.56573 | 37.745779900623 | -122.431063194026 | (37.745779900623, -122.431063194026) |
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");