Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qSpecies, DBH
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker ▼ | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25787 | 25787 | 189282 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1310 Indiana St | 17 | : Yard 23 | Tree 1 | Private 1 | 2 | 6015006.25242 | 2102364.64044 | 37.753536067647 | -122.39100065687 | (37.753536067647, -122.39100065687) | ||||
31493 | 31493 | 188360 | Undocumented 2 | Calocedrus decurrens :: Incense Cedar 177 | 1310 Indiana St | 19 | : Yard 23 | Tree 1 | Private 1 | 1 | 6014888.31128 | 2102546.96867 | 37.7540301569914 | -122.391421271577 | (37.7540301569914, -122.391421271577) | ||||
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) | ||||
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) | ||||
53317 | 53317 | 189283 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1310 Indiana St | 16 | : Yard 23 | Tree 1 | Private 1 | 4 | 6015000.28938 | 2102358.87265 | 37.753519899631904 | -122.391020875425 | (37.7535198996319, -122.391020875425) | ||||
56522 | 56522 | 194260 | Undocumented 2 | Persea americana :: Avocado 113 | 1310 Indiana St | 24 | : Yard 23 | Tree 1 | Private 1 | 1 | 6014928.75103 | 2102386.78077 | 37.7535925594679 | -122.391270223251 | (37.7535925594679, -122.391270223251) | ||||
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) | ||||
75041 | 75041 | 194131 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1310 Indiana St | 4 | : Yard 23 | Tree 1 | Private 1 | 37 | 6014985.85621 | 2102536.5970099997 | 37.754007092062004 | -122.391083210127 | (37.754007092062, -122.391083210127) | ||||
75684 | 75684 | 194428 | Undocumented 2 | Pinus contorta :: Shore Pine 423 | 1310 Indiana St | 13 | : Yard 23 | Tree 1 | Private 1 | 1 | 6014998.917640001 | 2102376.22038 | 37.7535674566975 | -122.391026831646 | (37.7535674566975, -122.391026831646) | ||||
136962 | 136962 | 188006 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1310 Indiana St | 5 | : Yard 23 | Tree 1 | Private 1 | 3 | 6014970.94657 | 2102528.93122 | 37.7539852160557 | -122.39113423586399 | (37.7539852160557, -122.391134235864) | ||||
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) | ||||
150778 | 150778 | 188007 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1310 Indiana St | 2 | : Yard 23 | Tree 1 | Private 1 | 9 | 6015000.133780001 | 2102555.57956 | 37.7540600063901 | -122.391035161147 | (37.7540600063901, -122.391035161147) | ||||
151834 | 151834 | 194402 | Undocumented 2 | Phoenix roebelenii :: Pigmy Date Palm 344 | 1310 Indiana St | 12 | : Yard 23 | Tree 1 | Private 1 | 7 | 6014991.28899 | 2102382.99945 | 37.7535856472653 | -122.39105368718799 | (37.7535856472653, -122.391053687188) | ||||
153691 | 153691 | 188436 | Undocumented 2 | Ceiba speciosa :: Silk floss 335 | 1310 Indiana St | 3 | : Yard 23 | Tree 1 | Private 1 | 3 | 6014947.70455 | 2102543.51938 | 37.7540239822338 | -122.391215632613 | (37.7540239822338, -122.391215632613) | ||||
162156 | 162156 | 193474 | Undocumented 2 | Mangifera indica :: Mango 549 | 1310 Indiana St | 25 | : Yard 23 | Tree 1 | Private 1 | 1 | 6014936.17409 | 2102358.6880200002 | 37.7535158347022 | -122.391242588881 | (37.7535158347022, -122.391242588881) | ||||
164046 | 164046 | 194259 | Undocumented 2 | Persea americana :: Avocado 113 | 1310 Indiana St | 22 | : Yard 23 | Tree 1 | Private 1 | 1 | 6014914.86206 | 2102424.38068 | 37.753695030018 | -122.391320882968 | (37.753695030018, -122.391320882968) | ||||
165387 | 165387 | 191435 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1310 Indiana St | 1 | : Yard 23 | Tree 1 | Private 1 | 1 | 6014946.60084 | 2102566.4575099996 | 37.75408690420971 | -122.39122105282699 | (37.7540869042097, -122.391221052827) | ||||
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) | ||||
180257 | 180257 | 189221 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 1310 Indiana St | 14 | : Yard 23 | Tree 1 | Private 1 | 1 | 6015010.96324 | 2102373.3642599997 | 37.7535602828051 | -122.39098497537901 | (37.7535602828051, -122.390984975379) | ||||
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");