Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qAddress, SiteOrder, DBH, PlotSize
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▼ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
49606 | 49606 | 198325 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1225 Mission Bay Blvd South | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6013787.22843 | 2108637.88784 | 37.770693312961996 | -122.39565583825899 | (37.770693312962, -122.395655838259) | ||||
59226 | 59226 | 198321 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1225 Mission Bay Blvd South | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6013777.96356 | 2108496.99922 | 37.7703059488766 | -122.39567801282601 | (37.7703059488766, -122.395678012826) | ||||
66247 | 66247 | 198320 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1225 Mission Bay Blvd South | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6013760.20993 | 2108475.0165 | 37.7702446016405 | -122.39573788252 | (37.7702446016405, -122.39573788252) | ||||
71393 | 71393 | 198322 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1225 Mission Bay Blvd South | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6013789.7693 | 2108510.1655 | 37.7703427572515 | -122.39563809912599 | (37.7703427572515, -122.395638099126) | ||||
75545 | 75545 | 198319 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1225 Mission Bay Blvd South | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6013741.4074800005 | 2108464.54508 | 37.7702148034894 | -122.395802186723 | (37.7702148034894, -122.395802186723) | ||||
148832 | 148832 | 198324 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1225 Mission Bay Blvd South | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6013797.10576 | 2108619.17547 | 37.77064248240121 | -122.39562036091101 | (37.7706424824012, -122.395620360911) | ||||
158639 | 158639 | 198326 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1225 Mission Bay Blvd South | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6013771.76611 | 2108656.94068 | 37.7707447676885 | -122.39571065823601 | (37.7707447676885, -122.395710658236) | ||||
173800 | 173800 | 198327 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1225 Mission Bay Blvd South | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6013747.40215 | 2108665.50559 | 37.7707669296806 | -122.395795534462 | (37.7707669296806, -122.395795534462) | ||||
175328 | 175328 | 198323 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1225 Mission Bay Blvd South | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6013802.38344 | 2108531.614 | 37.7704023517081 | -122.39559596947201 | (37.7704023517081, -122.395595969472) | ||||
24235 | 24235 | 217813 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 198 Lee Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5996579.91933 | 2091952.01212 | 37.7239058307663 | -122.453970623549 | (37.7239058307663, -122.453970623549) | |||
29317 | 29317 | 217810 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 198 Lee Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5996576.41484 | 2091837.9853700001 | 37.7235925393546 | -122.453974506819 | (37.7235925393546, -122.453974506819) | |||
59386 | 59386 | 218777 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2097 16th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 3ft | 5991278.3024699995 | 2101198.1006 | 37.74898783722271 | -122.472971202076 | (37.7489878372227, -122.472971202076) | |||
59401 | 59401 | 217811 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 198 Lee Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5996578.30824 | 2091874.8605099998 | 37.7236938983276 | -122.453970623552 | (37.7236938983276, -122.453970623552) | |||
129527 | 129527 | 123027 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 744 Funston Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 3ft | 5991973.40436 | 2110362.91938 | 37.774192223739796 | -122.471235197447 | (37.7741922237398, -122.471235197447) | |||
137321 | 137321 | 217812 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 198 Lee Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5996576.30659 | 2091913.4949400001 | 37.723799864560704 | -122.453980331735 | (37.7237998645607, -122.453980331735) | |||
171649 | 171649 | 218778 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2097 16th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 3ft | 5991279.88316 | 2101182.92802 | 37.748946268773 | -122.47296462983299 | (37.748946268773, -122.472964629833) | |||
134180 | 134180 | 219427 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1426 16th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 5991170.38541 | 2105691.7804 | 37.7613200515933 | -122.47367213637101 | (37.7613200515933, -122.473672136371) | |||
153727 | 153727 | 123356 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 712 04th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 5994756.85987 | 2110644.08831 | 37.7751248504722 | -122.46162718724301 | (37.7751248504722, -122.461627187243) | |||
188649 | 188649 | 123336 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 723 04th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 4ft | 5994711.02171 | 2110605.04952 | 37.7750150216931 | -122.461782919201 | (37.7750150216931, -122.461782919201) | |||
59154 | 59154 | 218160 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1400 Portola Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 5ft | 5993082.74921 | 2097580.44526 | 37.7391589756979 | -122.46646856589899 | (37.7391589756979, -122.466468565899) | |||
147190 | 147190 | 218159 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1400 Portola Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 5ft | 5993095.853519999 | 2097590.7626 | 37.7391880606825 | -122.46642400716001 | (37.7391880606825, -122.46642400716) | |||
184260 | 184260 | 218161 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1400 Portola Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 5ft | 5993069.62325 | 2097569.10976 | 37.7391270938355 | -122.466513125474 | (37.7391270938355, -122.466513125474) | |||
67039 | 67039 | 120355 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2270 Lake St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 6ft | 5988402.72558 | 2114696.23379 | 37.78588309898829 | -122.48390447116999 | (37.7858830989883, -122.48390447117) | |||
70304 | 70304 | 120354 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2270 Lake St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 6ft | 5988430.28754 | 2114697.53592 | 37.7858882787477 | -122.483809211099 | (37.7858882787477, -122.483809211099) | |||
25481 | 25481 | 198281 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 500 Amador St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 8ft | 6017868.75025 | 2099595.89007 | 37.7460920687928 | -122.380908946009 | (37.7460920687928, -122.380908946009) | |||
30849 | 30849 | 198285 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 500 Amador St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 8ft | 6017793.32679 | 2099592.23757 | 37.7460778765941 | -122.381169499371 | (37.7460778765941, -122.381169499371) | |||
31735 | 31735 | 198284 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 500 Amador St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 8ft | 6017813.21777 | 2099593.44192 | 37.74608228148 | -122.381100801954 | (37.74608228148, -122.381100801954) | |||
35317 | 35317 | 123509 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2636 Fulton St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 8ft | 5995163.8038800005 | 2110297.4884900004 | 37.77419659482779 | -122.46019437077899 | (37.7741965948278, -122.460194370779) | |||
37378 | 37378 | 198292 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 500 Amador St | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 8ft | 6017651.2465699995 | 2099584.75723 | 37.7460494930826 | -122.381660279195 | (37.7460494930826, -122.381660279195) | |||
38795 | 38795 | 198287 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 500 Amador St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 8ft | 6017753.37339 | 2099590.18904 | 37.7460700461913 | -122.38130751204399 | (37.7460700461913, -122.381307512044) | |||
53948 | 53948 | 198296 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 500 Amador St | 17 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 8ft | 6017552.343280001 | 2099579.4388200003 | 37.7460294283132 | -122.382001907384 | (37.7460294283132, -122.382001907384) | |||
55610 | 55610 | 198286 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 500 Amador St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 8ft | 6017773.62926 | 2099591.7423799997 | 37.7460754295565 | -122.381237577149 | (37.7460754295565, -122.381237577149) | |||
57758 | 57758 | 198294 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 500 Amador St | 15 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 8ft | 6017591.2197 | 2099581.33021 | 37.7460367685821 | -122.381867608025 | (37.7460367685821, -122.381867608025) | |||
57835 | 57835 | 198293 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 500 Amador St | 13 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 8ft | 6017632.06769 | 2099583.36051 | 37.746044598982 | -122.381726500798 | (37.746044598982, -122.381726500798) | |||
65432 | 65432 | 198288 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 500 Amador St | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 8ft | 6017733.321719999 | 2099589.8795 | 37.7460680892801 | -122.3813768273 | (37.7460680892801, -122.3813768273) | |||
67092 | 67092 | 198290 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 500 Amador St | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 8ft | 6017692.8350599995 | 2099588.0199599997 | 37.746060748120705 | -122.381516697036 | (37.7460607481207, -122.381516697036) | |||
73875 | 73875 | 198295 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 500 Amador St | 16 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 8ft | 6017570.97457 | 2099580.31165 | 37.746032853833206 | -122.38193754289101 | (37.7460328538332, -122.381937542891) | |||
74955 | 74955 | 198283 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 500 Amador St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 8ft | 6017833.27301 | 2099593.92963 | 37.7460847276446 | -122.381031486718 | (37.7460847276446, -122.381031486718) | |||
131704 | 131704 | 198291 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 500 Amador St | 11 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 8ft | 6017672.75114 | 2099586.10688 | 37.746054386310796 | -122.38158601229601 | (37.7460543863108, -122.381586012296) | |||
147691 | 147691 | 198299 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 500 Amador St | 20 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 8ft | 6017490.49598 | 2099601.17912 | 37.746085707003004 | -122.38221728150499 | (37.746085707003, -122.382217281505) | |||
160306 | 160306 | 198282 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 500 Amador St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 8ft | 6017853.17114 | 2099595.49021 | 37.74609011098 | -122.38096278932301 | (37.74609011098, -122.380962789323) | |||
170643 | 170643 | 198289 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 500 Amador St | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 8ft | 6017712.53976 | 2099588.87163 | 37.746064174537004 | -122.381448619273 | (37.746064174537, -122.381448619273) | |||
172019 | 172019 | 198298 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 500 Amador St | 19 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 8ft | 6017519.7761 | 2099586.1475400003 | 37.7460460504973 | -122.38211498813601 | (37.7460460504973, -122.382114988136) | |||
183395 | 183395 | 198297 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 500 Amador St | 18 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 8ft | 6017533.81233 | 2099583.55419 | 37.7460397048816 | -122.382066271836 | (37.7460397048816, -122.382066271836) |
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");