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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
28966 | 28966 | 242013 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3350 18th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 3ft | 6007139.614130001 | 2105587.52459 | 37.7619457090369 | -122.418433769026 | (37.7619457090369, -122.418433769026) | |||
33930 | 33930 | 179988 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 765 Morse St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 5ft | 5998318.043769999 | 2087022.65362 | 37.7104704522241 | -122.447607562158 | (37.7104704522241, -122.447607562158) | |||
35429 | 35429 | 214965 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2 Teresita Blvd | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 5997341.38795 | 2099482.28659 | 37.7446257889394 | -122.451881359962 | (37.7446257889394, -122.451881359962) | |||
36386 | 36386 | 214970 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2 Juanita Way | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 4ft | 5997356.998319999 | 2099424.95505 | 37.744469264646604 | -122.45182324753799 | (37.7444692646466, -122.451823247538) | |||
41967 | 41967 | 214964 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2 Teresita Blvd | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 4ft | 5997334.71062 | 2099489.48616 | 37.7446451747439 | -122.451904968034 | (37.7446451747439, -122.451904968034) | |||
42326 | 42326 | 179980 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 670 Brunswick St | 14 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | 5998613.38234 | 2086668.65922 | 37.7095153380418 | -122.446561361025 | (37.7095153380418, -122.446561361025) | ||||
45435 | 45435 | 214966 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2 Teresita Blvd | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 5997362.590580001 | 2099453.8642700003 | 37.7445489625809 | -122.45180599584499 | (37.7445489625809, -122.451805995845) | |||
52752 | 52752 | 214969 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2 Juanita Way | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 5997363.66935 | 2099430.0456 | 37.7444836241267 | -122.45180054775899 | (37.7444836241267, -122.451800547759) | |||
53213 | 53213 | 179976 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 670 Brunswick St | 9 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | 5998720.79345 | 2086710.36043 | 37.709635974902504 | -122.446193129116 | (37.7096359749025, -122.446193129116) | ||||
54036 | 54036 | 214972 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2 Juanita Way | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 5997342.332719999 | 2099414.2781700003 | 37.7444391085762 | -122.451873187816 | (37.7444391085762, -122.451873187816) | |||
54756 | 54756 | 180379 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4172 Mission St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 3ft | 6003597.5733199995 | 2094144.24122 | 37.7303250782211 | -122.429868027407 | (37.7303250782211, -122.429868027407) | |||
56310 | 56310 | 198008 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 280 Shipley St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | 6011263.84387 | 2111528.91648 | 37.778490722908 | -122.40458785715799 | (37.778490722908, -122.404587857158) | ||||
57065 | 57065 | 180367 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 330 Harvard St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 2ft | 6006338.1415099995 | 2092311.4976 | 37.7254475817356 | -122.420263462185 | (37.7254475817356, -122.420263462185) | |||
58332 | 58332 | 241490 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2115 Castro St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 6ft | 6002706.79399 | 2099384.51572 | 37.744663180953495 | -122.433321879096 | (37.7446631809535, -122.433321879096) | |||
62012 | 62012 | 241730 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 125 Guerrero St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 2ft | 6005461.26465 | 2108292.38374 | 37.7692779842131 | -122.424430927738 | (37.7692779842131, -122.424430927738) | |||
67095 | 67095 | 179978 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 670 Brunswick St | 12 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | 5998663.42353 | 2086686.16888 | 37.709566273845894 | -122.446389669661 | (37.7095662738459, -122.446389669661) | ||||
67547 | 67547 | 179977 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 670 Brunswick St | 11 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | 5998676.25855 | 2086690.45816 | 37.7095787843051 | -122.446345618154 | (37.7095787843051, -122.446345618154) | ||||
68062 | 68062 | 136891 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1317 Greenwich St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6006598.09728 | 2119723.5928599997 | 37.8007294111786 | -122.42131054914499 | (37.8007294111786, -122.421310549145) | |||
71582 | 71582 | 214967 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2 Juanita Way | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 4ft | 5997371.01819 | 2099442.4443099997 | 37.7445180888416 | -122.45177603135201 | (37.7445180888416, -122.451776031352) | |||
80863 | 80863 | 106175 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1500 Van Ness Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | Permit Number 771770 | 6006417.5 | 2115761.6 | 37.7898405898041 | -122.42165393085101 | (37.7898405898041, -122.421653930851) | ||||
87230 | 87230 | 106179 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1500 Van Ness Ave | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | Permit Number 771770 | 6006417.5 | 2115761.6 | 37.7898405898041 | -122.42165393085101 | (37.7898405898041, -122.421653930851) | ||||
96623 | 96623 | 106177 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1500 Van Ness Ave | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | Permit Number 771770 | 6006417.5 | 2115761.6 | 37.7898405898041 | -122.42165393085101 | (37.7898405898041, -122.421653930851) | ||||
98842 | 98842 | 106181 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1500 Van Ness Ave | 8 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | Permit Number 771770 | 6006417.5 | 2115761.6 | 37.7898405898041 | -122.42165393085101 | (37.7898405898041, -122.421653930851) | ||||
101067 | 101067 | 106178 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1500 Van Ness Ave | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | Permit Number 771770 | 6006417.5 | 2115761.6 | 37.7898405898041 | -122.42165393085101 | (37.7898405898041, -122.421653930851) | ||||
104345 | 104345 | 106180 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1500 Van Ness Ave | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | Permit Number 771770 | 6006417.5 | 2115761.6 | 37.7898405898041 | -122.42165393085101 | (37.7898405898041, -122.421653930851) | ||||
125867 | 125867 | 106176 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1500 Van Ness Ave | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | Permit Number 771770 | 6006417.5 | 2115761.6 | 37.7898405898041 | -122.42165393085101 | (37.7898405898041, -122.421653930851) | ||||
129101 | 129101 | 106174 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1500 Van Ness Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | Permit Number 771770 | 6006417.5 | 2115761.6 | 37.7898405898041 | -122.42165393085101 | (37.7898405898041, -122.421653930851) | ||||
130318 | 130318 | 179975 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 670 Brunswick St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | 5998755.4264 | 2086725.5872 | 37.7096797619799 | -122.446074526535 | (37.7096797619799, -122.446074526535) | ||||
131014 | 131014 | 241828 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 137 Carl St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 13 | Width 4ft | 5997755.85795 | 2107114.51455 | 37.7656057168481 | -122.450998464913 | (37.7656057168481, -122.450998464913) | |||
134349 | 134349 | 242012 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3360 18th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 3ft | 6007095.87036 | 2105583.33984 | 37.761931756063106 | -122.41858476518101 | (37.7619317560631, -122.418584765181) | |||
134553 | 134553 | 214968 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2 Juanita Way | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 5997369.83185 | 2099435.93152 | 37.7445001383688 | -122.45177966372101 | (37.7445001383688, -122.451779663721) | |||
137512 | 137512 | 179979 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 670 Brunswick St | 13 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | 5998643.39451 | 2086681.70368 | 37.709552869435896 | -122.44645857210399 | (37.7095528694359, -122.446458572104) | ||||
148410 | 148410 | 139464 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 855 CENTRAL AVE | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 0ft | 5999524.9558 | 2111493.8508 | 37.777731385882 | -122.445194451227 | (37.777731385882, -122.445194451227) | |||
149734 | 149734 | 198011 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 250 Clara St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | 6011627.81903 | 2111614.0669299997 | 37.77874486142171 | -122.40333471393299 | (37.7787448614217, -122.403334713933) | ||||
151920 | 151920 | 241728 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 145 Guerrero St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 3ft | 6005472.00964 | 2108159.19985 | 37.7689128999345 | -122.424384287114 | (37.7689128999345, -122.424384287114) | |||
152698 | 152698 | 198015 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 950 Clara St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 10ft | 6011592.4393 | 2111542.93925 | 37.778547585231294 | -122.403452101555 | (37.7785475852313, -122.403452101555) | |||
154197 | 154197 | 198014 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 950 Clara St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 10ft | 6011583.34597 | 2111538.1965400004 | 37.778534054939705 | -122.40348322527099 | (37.7785340549397, -122.403483225271) | |||
154633 | 154633 | 214963 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2 Teresita Blvd | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 5997327.80888 | 2099498.52098 | 37.7446695868371 | -122.451929484457 | (37.7446695868371, -122.451929484457) | |||
156537 | 156537 | 241729 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 145 Guerrero St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 3ft | 6005472.26588 | 2108171.65943 | 37.7689471254258 | -122.42438428712 | (37.7689471254258, -122.42438428712) | |||
160108 | 160108 | 241827 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 137 Carl St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | Width 4ft | 5997738.08683 | 2107111.8321599998 | 37.7655973342788 | -122.451059737535 | (37.7655973342788, -122.451059737535) | |||
167698 | 167698 | 180363 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 267 Athens St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6004429.08043 | 2091723.63229 | 37.7237256758823 | -122.426821071242 | (37.7237256758823, -122.426821071242) | |||
181109 | 181109 | 214971 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2 Juanita Way | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 4ft | 5997351.13629 | 2099420.8934400002 | 37.744457776714896 | -122.451843224182 | (37.7444577767149, -122.451843224182) |
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");