Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qAddress, SiteOrder, DBH
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 28971 | 28971 | 192361 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1 25th St | 10 | : Yard 23 | Tree 1 | Private 1 | 10 | 6015010.08641 | 2102185.10422 | 37.7530433120206 | -122.390974850809 | (37.7530433120206, -122.390974850809) | ||||
| 31965 | 31965 | 192372 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1310 Indiana St | 11 | : Yard 23 | Tree 1 | Private 1 | 18 | 6015021.64054 | 2102392.08058 | 37.753612266314796 | -122.39094935864401 | (37.7536122663148, -122.390949358644) | ||||
| 35549 | 35549 | 192359 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1 25th St | 3 | : Yard 23 | Tree 1 | Private 1 | 11 | 6015007.494080001 | 2102120.97523 | 37.7528670835631 | -122.390979333923 | (37.7528670835631, -122.390979333923) | ||||
| 35640 | 35640 | 192367 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1310 Indiana St | 6 | : Yard 23 | Tree 1 | Private 1 | 13 | 6014979.384930001 | 2102511.0329 | 37.75393653934321 | -122.39110380282101 | (37.7539365393432, -122.391103802821) | ||||
| 36486 | 36486 | 192371 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1310 Indiana St | 10 | : Yard 23 | Tree 1 | Private 1 | 11 | 6015009.21329 | 2102415.55606 | 37.7536760354269 | -122.390993975811 | (37.7536760354269, -122.390993975811) | ||||
| 40383 | 40383 | 192366 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1310 Indiana St | 20 | : Yard 23 | Tree 1 | Private 1 | 13 | 6014913.1297 | 2102461.68379 | 37.7537973602844 | -122.39132948139 | (37.7537973602844, -122.39132948139) | ||||
| 51964 | 51964 | 192363 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1310 Indiana St | 26 | : Yard 23 | Tree 1 | Private 1 | 8 | 6014946.149019999 | 2102349.52066 | 37.753491216648705 | -122.39120745237899 | (37.7534912166487, -122.391207452379) | ||||
| 54292 | 54292 | 192358 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1 25th St | 2 | : Yard 23 | Tree 1 | Private 1 | 12 | 6015008.12096 | 2102140.25985 | 37.752920069827 | -122.39097851376499 | (37.752920069827, -122.390978513765) | ||||
| 60000 | 60000 | 192362 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1 25th St | 20 | : Yard 23 | Tree 1 | Private 1 | 9 | 6014965.98324 | 2102248.74822 | 37.7532156176115 | -122.391131817592 | (37.7532156176115, -122.391131817592) | ||||
| 60677 | 60677 | 192360 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1 25th St | 8 | : Yard 23 | Tree 1 | Private 1 | 5 | 6015020.29565 | 2102164.4791599996 | 37.75298724647129 | -122.39093810360399 | (37.7529872464713, -122.390938103604) | ||||
| 70325 | 70325 | 192365 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1310 Indiana St | 21 | : Yard 23 | Tree 1 | Private 1 | 8 | 6014917.078430001 | 2102437.6688900003 | 37.7537316396243 | -122.391314147037 | (37.7537316396243, -122.391314147037) | ||||
| 74435 | 74435 | 192364 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1310 Indiana St | 23 | : Yard 23 | Tree 1 | Private 1 | 8 | 6014928.1243 | 2102399.042 | 37.7536261914184 | -122.391273247671 | (37.7536261914184, -122.391273247671) | ||||
| 148293 | 148293 | 192370 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1310 Indiana St | 9 | : Yard 23 | Tree 1 | Private 1 | 8 | 6015014.73228 | 2102443.11605 | 37.7537520155509 | -122.390976815833 | (37.7537520155509, -122.390976815833) | ||||
| 171000 | 171000 | 192369 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1310 Indiana St | 8 | : Yard 23 | Tree 1 | Private 1 | 7 | 6014983.64642 | 2102476.35721 | 37.7538415637469 | -122.391086641939 | (37.7538415637469, -122.391086641939) | ||||
| 173611 | 173611 | 192357 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1 25th St | 1 | : Yard 23 | Tree 1 | Private 1 | 16 | 6015039.28391 | 2102127.23317 | 37.7528860304727 | -122.39086983518801 | (37.7528860304727, -122.390869835188) | ||||
| 184577 | 184577 | 192373 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1310 Indiana St | 18 | : Yard 23 | Tree 1 | Private 1 | 17 | 6015020.94183 | 2102357.50513 | 37.7535172906979 | -122.390949358625 | (37.7535172906979, -122.390949358625) | ||||
| 188821 | 188821 | 192368 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1310 Indiana St | 7 | : Yard 23 | Tree 1 | Private 1 | 6 | 6014962.221059999 | 2102496.55555 | 37.753895835135104 | -122.39116214813801 | (37.7538958351351, -122.391162148138) |
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");