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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
24708 | 24708 | 199517 | Undocumented 2 | Yucca elephantipes :: Giant Yucca 211 | 1 01st St | 13 | : Yard 23 | Tree 1 | Private 1 | 3 | 6014420.56618 | 2105901.8129 | 37.763215862946 | -122.39327360428801 | (37.763215862946, -122.393273604288) | ||||
28405 | 28405 | 199554 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1 01st St | 10 | : Yard 23 | Tree 1 | Private 1 | 17 | 6014431.6868199995 | 2105923.15598 | 37.763275084200295 | -122.39323663496599 | (37.7632750842003, -122.393236634966) | ||||
29380 | 29380 | 196093 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 01st St | 25 | : Yard 23 | Tree 1 | Private 1 | 8 | 6014406.1146599995 | 2105887.9731 | 37.763177058994 | -122.39332261913601 | (37.763177058994, -122.393322619136) | ||||
32102 | 32102 | 189290 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1 01st St | 23 | : Yard 23 | Tree 1 | Private 1 | 5 | 6014424.75736 | 2105899.2532900004 | 37.7632090676603 | -122.39325892915501 | (37.7632090676603, -122.393258929155) | ||||
38723 | 38723 | 191689 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 1 01st St | 27 | : Yard 23 | Tree 1 | Private 1 | 3 | 6014402.09171 | 2105890.67407 | 37.7631842517621 | -122.393336722306 | (37.7631842517621, -122.393336722306) | ||||
38976 | 38976 | 199555 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1 01st St | 15 | : Yard 23 | Tree 1 | Private 1 | 8 | 6014446.64039 | 2105914.6589900004 | 37.763252584054605 | -122.393184320496 | (37.7632525840546, -122.393184320496) | ||||
41043 | 41043 | 199551 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1 01st St | 7 | : Yard 23 | Tree 1 | Private 1 | 15 | 6014408.59689 | 2105921.94262 | 37.7632704697891 | -122.39331641112899 | (37.7632704697891, -122.393316411129) | ||||
48813 | 48813 | 199516 | Undocumented 2 | Yucca elephantipes :: Giant Yucca 211 | 1 01st St | 12 | : Yard 23 | Tree 1 | Private 1 | 3 | 6014441.55665 | 2105919.02201 | 37.7632642815347 | -122.393202208925 | (37.7632642815347, -122.393202208925) | ||||
56524 | 56524 | 191026 | Undocumented 2 | Cussonia spicata :: Cabbage tree 325 | 1 01st St | 36 | : Yard 23 | Tree 1 | Private 1 | 3 | 6014407.16325 | 2105848.78864 | 37.7630695252734 | -122.39331625017 | (37.7630695252734, -122.39331625017) | ||||
58033 | 58033 | 189291 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1 01st St | 31 | : Yard 23 | Tree 1 | Private 1 | 5 | 6014386.77773 | 2105894.3895799997 | 37.7631936029157 | -122.39338994869 | (37.7631936029157, -122.39338994869) | ||||
59106 | 59106 | 189293 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1 01st St | 35 | : Yard 23 | Tree 1 | Private 1 | 8 | 6014389.3663800005 | 2105866.30731 | 37.7631166389548 | -122.39337903001801 | (37.7631166389548, -122.393379030018) | ||||
59596 | 59596 | 199511 | Undocumented 2 | Yucca elephantipes :: Giant Yucca 211 | 1 01st St | 16 | : Yard 23 | Tree 1 | Private 1 | 4 | 6014447.50245 | 2105911.75995 | 37.7632446718137 | -122.393181136026 | (37.7632446718137, -122.393181136026) | ||||
70245 | 70245 | 190636 | Undocumented 2 | Hakea suaveolens :: Sweet Hakea Tree 14 | 1 01st St | 30 | : Yard 23 | Tree 1 | Private 1 | 8 | 6014391.99798 | 2105898.86804 | 37.763206189822796 | -122.393372206868 | (37.7632061898228, -122.393372206868) | ||||
70813 | 70813 | 199550 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1 01st St | 6 | : Yard 23 | Tree 1 | Private 1 | 15 | 6014401.0054 | 2105922.09622 | 37.7632704697749 | -122.393342678542 | (37.7632704697749, -122.393342678542) | ||||
73004 | 73004 | 190635 | Undocumented 2 | Hakea suaveolens :: Sweet Hakea Tree 14 | 1 01st St | 28 | : Yard 23 | Tree 1 | Private 1 | 9 | 6014407.37845 | 2105898.42582 | 37.7632058300952 | -122.393318979581 | (37.7632058300952, -122.393318979581) | ||||
76538 | 76538 | 199553 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1 01st St | 9 | : Yard 23 | Tree 1 | Private 1 | 20 | 6014424.93308 | 2105923.01259 | 37.7632743152759 | -122.393259984074 | (37.7632743152759, -122.393259984074) | ||||
132015 | 132015 | 196092 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 01st St | 24 | : Yard 23 | Tree 1 | Private 1 | 10 | 6014425.82588 | 2105887.0502299997 | 37.7631756200823 | -122.393254379501 | (37.7631756200823, -122.393254379501) | ||||
134605 | 134605 | 194275 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1 01st St | 34 | : Yard 23 | Tree 1 | Private 1 | 8 | 6014376.659969999 | 2105881.88915 | 37.76315871732 | -122.39342406806101 | (37.76315871732, -122.393424068061) | ||||
134619 | 134619 | 199515 | Undocumented 2 | Yucca elephantipes :: Giant Yucca 211 | 1 01st St | 11 | : Yard 23 | Tree 1 | Private 1 | 3 | 6014438.12631 | 2105919.24405 | 37.7632647006382 | -122.393214088968 | (37.7632647006382, -122.393214088968) | ||||
137271 | 137271 | 191088 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1 01st St | 19 | : Yard 23 | Tree 1 | Private 1 | 18 | 6014455.34951 | 2105889.6924799997 | 37.7631845152826 | -122.393152451232 | (37.7631845152826, -122.393152451232) | ||||
137382 | 137382 | 189292 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1 01st St | 33 | : Yard 23 | Tree 1 | Private 1 | 5 | 6014376.229280001 | 2105886.6133 | 37.763171664875294 | -122.393425888311 | (37.7631716648753, -122.393425888311) | ||||
138227 | 138227 | 199545 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1 01st St | 1 | : Yard 23 | Tree 1 | Private 1 | 12 | 6014356.43896 | 2105915.99545 | 37.7632512422621 | -122.39349639336099 | (37.7632512422621, -122.393496393361) | ||||
139126 | 139126 | 199549 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1 01st St | 5 | : Yard 23 | Tree 1 | Private 1 | 9 | 6014392.26095 | 2105920.87265 | 37.7632666242892 | -122.39337283731399 | (37.7632666242892, -122.393372837314) | ||||
147367 | 147367 | 194594 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1 01st St | 22 | : Yard 23 | Tree 1 | Private 1 | 10 | 6014433.28496 | 2105898.16367 | 37.7632065495547 | -122.393229358544 | (37.7632065495547, -122.393229358544) | ||||
152443 | 152443 | 196094 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 01st St | 26 | : Yard 23 | Tree 1 | Private 1 | 8 | 6014400.8809 | 2105882.83985 | 37.7631626734333 | -122.393340361863 | (37.7631626734333, -122.393340361863) | ||||
153276 | 153276 | 199557 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1 01st St | 18 | : Yard 23 | Tree 1 | Private 1 | 9 | 6014448.03527 | 2105905.59327 | 37.7632277690557 | -122.393178861636 | (37.7632277690557, -122.393178861636) | ||||
153814 | 153814 | 199510 | Undocumented 2 | Quercus engelmannii :: Engelmann oak 453 | 1 01st St | 14 | : Yard 23 | Tree 1 | Private 1 | 5 | 6014434.26374 | 2105920.54159 | 37.7632680488164 | -122.39322753922801 | (37.7632680488164, -122.393227539228) | ||||
157392 | 157392 | 190908 | Undocumented 2 | Cotinus coggygria 'Royal Purple' :: Smoke tree 298 | 1 01st St | 32 | : Yard 23 | Tree 1 | Private 1 | 1 | 6014392.80706 | 2105893.3505 | 37.7631910848138 | -122.393369022367 | (37.7631910848138, -122.393369022367) | ||||
163548 | 163548 | 189289 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1 01st St | 20 | : Yard 23 | Tree 1 | Private 1 | 10 | 6014461.84726 | 2105889.9963 | 37.76318571047079 | -122.393129998769 | (37.7631857104708, -122.393129998769) | ||||
165472 | 165472 | 199546 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1 01st St | 2 | : Yard 23 | Tree 1 | Private 1 | 8 | 6014366.09507 | 2105920.56167 | 37.7632643166198 | -122.393463315392 | (37.7632643166198, -122.393463315392) | ||||
166837 | 166837 | 199547 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1 01st St | 3 | : Yard 23 | Tree 1 | Private 1 | 15 | 6014373.91679 | 2105917.88241 | 37.763257394541796 | -122.39343607492201 | (37.7632573945418, -122.393436074922) | ||||
170055 | 170055 | 199552 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1 01st St | 8 | : Yard 23 | Tree 1 | Private 1 | 15 | 6014417.3246 | 2105922.3261 | 37.7632720076265 | -122.39328625146099 | (37.7632720076265, -122.393286251461) | ||||
171136 | 171136 | 199548 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1 01st St | 4 | : Yard 23 | Tree 1 | Private 1 | 9 | 6014382.11605 | 2105919.95745 | 37.7632635477036 | -122.39340786139499 | (37.7632635477036, -122.393407861395) | ||||
177343 | 177343 | 199556 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1 01st St | 17 | : Yard 23 | Tree 1 | Private 1 | 4 | 6014441.57524 | 2105911.35616 | 37.7632432338158 | -122.39320160818599 | (37.7632432338158, -122.393201608186) | ||||
182983 | 182983 | 194593 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 1 01st St | 21 | : Yard 23 | Tree 1 | Private 1 | 19 | 6014441.963140001 | 2105885.02123 | 37.763170945392496 | -122.393198423694 | (37.7631709453925, -122.393198423694) |
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");